#region
|
|
using System;
|
using System.Data;
|
using System.Windows.Forms;
|
using CSFrameworkV5.Business;
|
using CSFrameworkV5.CodeGeneratorCore;
|
using CSFrameworkV5.Models;
|
using DevExpress.XtraEditors;
|
using DevExpress.XtraEditors.Controls;
|
using DevExpress.XtraEditors.Repository;
|
using DevExpress.XtraTreeList.Columns;
|
using DataTableTools = CSFrameworkV5.Common.DataTableTools;
|
using Msg = CSFrameworkV5.Common.Msg;
|
|
#endregion
|
|
namespace CSFrameworkV5.Library.CommonClass
|
{
|
public class DataBinderToolBase
|
{
|
[CG_LookupDataBoundAttribute("设置勾选组件(CheckEdit)",
|
CG_EditorType.NormalEditor)]
|
public static void BoundCheckEdit(CheckEdit chk)
|
{
|
chk.Properties.AutoHeight = false;
|
chk.Properties.NullStyle = StyleIndeterminate.Unchecked;
|
chk.Properties.ValueChecked = "Y";
|
chk.Properties.ValueUnchecked = "N";
|
}
|
|
[CG_LookupDataBoundAttribute("设置勾选组件(RepositoryItem)",
|
CG_EditorType.RepositoryItemEditor)]
|
public static void BoundCheckEdit(RepositoryItemCheckEdit lueCheck)
|
{
|
lueCheck.AutoHeight = false;
|
lueCheck.NullStyle = StyleIndeterminate.Unchecked;
|
lueCheck.ValueChecked = "Y";
|
lueCheck.ValueUnchecked = "N";
|
}
|
|
/// <summary>
|
/// 初始化控件列(Names和FileNames必须保证长度一致)
|
/// </summary>
|
/// <param name="lue"></param>
|
/// <param name="Names">显示列名集合</param>
|
/// <param name="FileNames">对应字段名</param>
|
protected static void InitializeControl(LookUpEdit lue, string[] Names,
|
string[] FileNames)
|
{
|
try
|
{
|
lue.Properties.Columns.Clear();
|
lue.Properties.NullText = "";
|
lue.Properties.DropDownRows = 25;
|
|
if (lue.Properties.Columns.Count == 0)
|
for (var i = 0; i < Names.Length; i++)
|
{
|
var col = new LookUpColumnInfo();
|
col.Caption = Names[i];
|
col.FieldName = FileNames[i];
|
lue.Properties.Columns.Add(col);
|
}
|
}
|
catch (Exception e)
|
{
|
Msg.Warning(e.Message);
|
}
|
}
|
|
/// <summary>
|
/// 初始化控件列(Names和FileNames必须保证长度一致)
|
/// </summary>
|
/// <param name="lue"></param>
|
/// <param name="Names">显示列名集合</param>
|
/// <param name="FileNames">对应字段名</param>
|
protected static void InitializeControl(RepositoryItemLookUpEdit lue,
|
string[] Names, string[] FileNames)
|
{
|
try
|
{
|
lue.Columns.Clear();
|
lue.NullText = "";
|
if (lue.Columns.Count == 0)
|
for (var i = 0; i < Names.Length; i++)
|
{
|
var col = new LookUpColumnInfo();
|
col.Caption = Names[i];
|
col.FieldName = FileNames[i];
|
lue.Columns.Add(col);
|
}
|
}
|
catch (Exception e)
|
{
|
Msg.Warning(e.Message);
|
}
|
}
|
|
/// <summary>
|
/// 初始化控件列(Names和FileNames必须保证长度一致)
|
/// </summary>
|
/// <param name="lue"></param>
|
/// <param name="Names">显示列名集合</param>
|
/// <param name="FileNames">对应字段名</param>
|
protected static void InitializeControl(
|
RepositoryItemSearchLookUpEdit lue, string[] Cations,
|
string[] FileName)
|
{
|
try
|
{
|
lue.View.Columns.Clear();
|
lue.NullText = "";
|
if (lue.View.Columns.Count == 0)
|
for (var i = 0; i < Cations.Length; i++)
|
{
|
var col = lue.View.Columns.Add();
|
col.Caption = Cations[i];
|
col.FieldName = FileName[i];
|
col.VisibleIndex = lue.View.Columns.Count;
|
}
|
}
|
catch (Exception e)
|
{
|
Msg.Warning(e.Message);
|
}
|
}
|
|
/// <summary>
|
/// 设置下拉窗体显示的行数
|
/// </summary>
|
/// <param name="lue"></param>
|
protected static void SetDropDownRows(LookUpEdit lue)
|
{
|
if (lue.Properties.DataSource is DataTable)
|
{
|
var rows = (lue.Properties.DataSource as DataTable).Rows.Count;
|
if (rows < 20)
|
lue.Properties.DropDownRows = rows + 1;
|
else
|
lue.Properties.DropDownRows = 20 + 1;
|
}
|
}
|
|
protected static void SetDropDownRows(RepositoryItemLookUpEdit lue)
|
{
|
if (lue.DataSource is DataTable)
|
{
|
var rows = (lue.DataSource as DataTable).Rows.Count;
|
if (rows < 20)
|
lue.DropDownRows = rows;
|
else
|
lue.DropDownRows = 20;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 绑定下拉数据组件数据源的工具
|
/// </summary>
|
public class DataBinderTools : DataBinderToolBase
|
{
|
#region 绑定下拉数据组件的数据源
|
|
/// <summary>
|
/// 绑定组织机构
|
/// </summary>
|
/// <param name="lue">TreeListLookUpEdit组件</param>
|
/// <param name="imageList">图标</param>
|
public static void BoundOrganization(TreeListLookUpEdit lue,
|
ImageList imageList)
|
{
|
//创建TreeList的列
|
var col_Popup_GroupName = new TreeListColumn();
|
col_Popup_GroupName.Caption = "组织机构";
|
col_Popup_GroupName.FieldName = tb_MyGroup.GroupName;
|
col_Popup_GroupName.Name = "col_Popup_GroupName";
|
col_Popup_GroupName.Visible = true;
|
col_Popup_GroupName.VisibleIndex = 0;
|
col_Popup_GroupName.Width = 130;
|
|
//TreeListLookUpEdit.Properties
|
lue.Properties.NullText = "";
|
lue.Properties.DisplayMember = tb_MyGroup.GroupName;
|
lue.Properties.ValueMember = tb_MyGroup.GroupCode;
|
|
var tree = lue.Properties.TreeList;
|
tree.StateImageList = imageList;
|
tree.Columns.Clear();
|
tree.Columns.AddRange(new[] { col_Popup_GroupName });
|
|
var treeData = DataDictCache.Cache.UserGroup;
|
tree.KeyFieldName = tb_MyGroup.GroupCode; //设置主键
|
tree.ParentFieldName = tb_MyGroup.ParentGroupCode; //设置父级主键
|
tree.RootValue = ""; //顶级树结点的值
|
tree.DataSource = treeData.Copy();
|
|
DevStyle.SetTreeListSelectStyle(tree);
|
DevTreeListView.SetImageIndex(tree, null, 1, 0);
|
|
tree.ExpandAll();
|
}
|
|
[CG_LookupDataBoundAttribute("绑定组织机构", CG_EditorType.NormalEditor)]
|
public static void BoundOrganization(LookUpEdit lue, bool AddNull)
|
{
|
lue.Properties.DropDownRows = 15;
|
InitializeControl(lue, new[] { "编号", "组织机构名称" },
|
new[] { tb_MyGroup.GroupCode, tb_MyGroup.GroupName });
|
lue.Properties.Columns[0].Width = 80;
|
lue.Properties.Columns[1].Width = 350;
|
lue.Properties.PopupWidth = 430;
|
var dt = DataDictCache.Cache.UserGroup.Copy();
|
if (AddNull) DataTableTools.AddFirstEmptyRow(dt);
|
|
DataBinder.BindingLookupEditDataSource(lue, dt,
|
tb_MyGroup.GroupName, tb_MyGroup.GroupCode);
|
SetDropDownRows(lue);
|
}
|
|
[CG_LookupDataBoundAttribute("绑定组织机构",
|
CG_EditorType.RepositoryItemEditor)]
|
public static void BoundOrganization(RepositoryItemLookUpEdit lue)
|
{
|
lue.DropDownRows = 15;
|
InitializeControl(lue, new[] { "编号", "组织机构名称" },
|
new[] { tb_MyGroup.GroupCode, tb_MyGroup.GroupName });
|
lue.Columns[0].Width = 80;
|
lue.Columns[1].Width = 350;
|
lue.PopupWidth = 430;
|
var dt = DataDictCache.Cache.UserGroup.Copy();
|
DataBinder.BindingLookupEditDataSource(lue, dt,
|
tb_MyGroup.GroupName, tb_MyGroup.GroupCode);
|
SetDropDownRows(lue);
|
}
|
|
/// <summary>
|
/// 绑定表格单元格中用户下拉数据源,tb_MyUser表
|
/// </summary>
|
/// <param name="lue"></param>
|
[CG_LookupDataBoundAttribute("绑定用户资料",
|
CG_EditorType.RepositoryItemEditor)]
|
public static void BoundUser(RepositoryItemLookUpEdit lue)
|
{
|
lue.Columns.Clear();
|
InitializeControl(lue, new[] { "姓名" },
|
new[] { tb_MyUser.UserName });
|
lue.DropDownRows = 25;
|
var dt = DataDictCache.Cache.User; //数据源
|
DataBinder.BindingLookupEditDataSource(lue, dt, tb_MyUser.UserName,
|
tb_MyUser.Account);
|
SetDropDownRows(lue);
|
}
|
|
/// <summary>
|
/// 绑定用户下拉数据源,tb_MyUser表
|
/// </summary>
|
/// <param name="lue"></param>
|
[CG_LookupDataBoundAttribute("绑定用户资料", CG_EditorType.NormalEditor)]
|
public static void BoundUser(LookUpEdit lue)
|
{
|
lue.Properties.NullText = "";
|
lue.Properties.DropDownRows = 15;
|
InitializeControl(lue, new[] { "帐号", "姓名" },
|
new[] { tb_MyUser.Account, tb_MyUser.UserName });
|
lue.Properties.Columns[0].Width = 60;
|
lue.Properties.Columns[1].Width = 140;
|
lue.Properties.PopupWidth = 200;
|
var dt = DataDictCache.Cache.User; //数据源
|
DataBinder.BindingLookupEditDataSource(lue, dt, tb_MyUser.UserName,
|
tb_MyUser.Account);
|
SetDropDownRows(lue);
|
}
|
|
[CG_LookupDataBoundAttribute("绑定用户资料(第一条记录添加空行)",
|
CG_EditorType.NormalEditor)]
|
public static void BoundUser(LookUpEdit lue, bool firstRowEmpty)
|
{
|
lue.Properties.NullText = "";
|
lue.Properties.DropDownRows = 15;
|
InitializeControl(lue, new[] { "帐号", "姓名" },
|
new[] { "Account", "UserName" });
|
lue.Properties.Columns[0].Width = 60;
|
lue.Properties.Columns[1].Width = 140;
|
lue.Properties.PopupWidth = 200;
|
|
if (firstRowEmpty)
|
{
|
var dt = DataDictCache.Cache.User.Copy();
|
DataTableTools.AddFirstEmptyRow(dt);
|
DataBinder.BindingLookupEditDataSource(lue, dt, "UserName",
|
"Account");
|
}
|
else
|
{
|
DataBinder.BindingLookupEditDataSource(lue,
|
DataDictCache.Cache.User.Copy(), "UserName", "Account");
|
}
|
|
SetDropDownRows(lue);
|
}
|
|
public static void BoundFormTable(LookUpEdit lue)
|
{
|
lue.Properties.DropDownItemHeight = 20;
|
lue.Properties.Columns.Clear();
|
InitializeControl(lue, new[] { "名称", "编号" },
|
new[]
|
{
|
sys_BusinessTables.FormCaption, sys_BusinessTables.Table1
|
});
|
lue.Properties.Columns[0].Width = 150;
|
lue.Properties.Columns[1].Width = 200;
|
lue.Properties.PopupWidth = 350;
|
var dt = DataDictCache.Cache.BusinessTables;
|
DataBinder.BindingLookupEditDataSource(lue, dt,
|
sys_BusinessTables.FormCaption, sys_BusinessTables.Table1);
|
SetDropDownRows(lue);
|
}
|
|
/// <summary>
|
/// 绑定账套
|
/// </summary>
|
/// <param name="lue"></param>
|
/// <param name="keyFieldName"></param>
|
/// <param name="onlyVisibleDataset">仅显示可见账套</param>
|
public static void BoundDBDataSet(LookUpEdit lue, string keyFieldName,
|
bool onlyVisibleDataset = true)
|
{
|
lue.Properties.DropDownItemHeight = 20;
|
lue.Properties.Columns.Clear();
|
InitializeControl(lue, new[] { "名称", "编号" },
|
new[] { tb_DataSet.DataSetName, keyFieldName });
|
lue.Properties.Columns[0].Width = 150;
|
lue.Properties.Columns[1].Width = 200;
|
lue.Properties.PopupWidth = 350;
|
|
var dt = DataDictCache.Cache.DataSet.Copy();
|
|
dt.DefaultView.RowFilter =
|
onlyVisibleDataset ? "IsVisible='Y'" : "";
|
dt = dt.DefaultView.ToTable();
|
|
DataBinder.BindingLookupEditDataSource(lue, dt,
|
tb_DataSet.DataSetName, keyFieldName);
|
SetDropDownRows(lue);
|
}
|
|
public static void BoundFormTable(RepositoryItemLookUpEdit lue)
|
{
|
lue.DropDownItemHeight = 20;
|
lue.Columns.Clear();
|
InitializeControl(lue, new[] { "名称", "编号" },
|
new[]
|
{
|
sys_BusinessTables.FormCaption, sys_BusinessTables.Table1
|
});
|
var dt = DataDictCache.Cache.BusinessTables;
|
DataBinder.BindingLookupEditDataSource(lue, dt,
|
sys_BusinessTables.FormCaption, sys_BusinessTables.Table1);
|
SetDropDownRows(lue);
|
}
|
|
public static void BoundDBDataSet(RepositoryItemLookUpEdit lue)
|
{
|
lue.DropDownItemHeight = 20;
|
lue.Columns.Clear();
|
InitializeControl(lue, new[] { "名称", "编号" },
|
new[] { tb_DataSet.DataSetName, tb_DataSet.DBName });
|
var dt = DataDictCache.Cache.DataSet;
|
DataBinder.BindingLookupEditDataSource(lue, dt,
|
tb_DataSet.DataSetName, tb_DataSet.DBName);
|
SetDropDownRows(lue);
|
}
|
|
[CG_LookupDataBoundAttribute("设置勾选组件(CheckEdit)",
|
CG_EditorType.NormalEditor)]
|
public static void BoundCheckEdit(CheckEdit chk)
|
{
|
chk.Properties.AutoHeight = false;
|
chk.Properties.NullStyle = StyleIndeterminate.Unchecked;
|
chk.Properties.ValueChecked = "Y";
|
chk.Properties.ValueUnchecked = "N";
|
}
|
|
[CG_LookupDataBoundAttribute("设置勾选组件(RepositoryItem)",
|
CG_EditorType.RepositoryItemEditor)]
|
public static void BoundCheckEdit(RepositoryItemCheckEdit lueCheck)
|
{
|
lueCheck.AutoHeight = false;
|
lueCheck.NullStyle = StyleIndeterminate.Unchecked;
|
lueCheck.ValueChecked = "Y";
|
lueCheck.ValueUnchecked = "N";
|
}
|
|
/// <summary>
|
/// 绑定销售员,tb_MyUser表
|
/// </summary>
|
/// <param name="lue"></param>
|
/// <param name="AddNull">true:表示增加空行，适用于条件选择, 预设为false</param>
|
[CG_LookupDataBoundAttribute("绑定销售员", CG_EditorType.NormalEditor)]
|
public static void BoundSales(LookUpEdit lue)
|
{
|
lue.Properties.Columns.Clear();
|
InitializeControl(lue, new[] { "姓名" },
|
new[] { tb_MyUser.UserName });
|
lue.Properties.DropDownRows = 25;
|
var dt = DataDictCache.Cache.User.Copy();
|
DataBinder.BindingLookupEditDataSource(lue, dt, tb_MyUser.UserName,
|
tb_MyUser.Account);
|
SetDropDownRows(lue);
|
}
|
|
/// <summary>
|
/// 绑定销售员,tb_MyUser表
|
/// </summary>
|
/// <param name="lue"></param>
|
/// <param name="AddNull">true:表示增加空行，适用于条件选择, 预设为false</param>
|
[CG_LookupDataBoundAttribute("绑定销售员 - 带参数", CG_EditorType.NormalEditor)]
|
public static void BoundSales(LookUpEdit lue, bool AddNull)
|
{
|
lue.Properties.Columns.Clear();
|
InitializeControl(lue, new[] { "姓名" },
|
new[] { tb_MyUser.UserName });
|
lue.Properties.DropDownRows = 25;
|
var dt = DataDictCache.Cache.User.Copy();
|
if (AddNull) DataTableTools.AddFirstEmptyRow(dt);
|
|
DataBinder.BindingLookupEditDataSource(lue, dt, tb_MyUser.UserName,
|
tb_MyUser.Account);
|
SetDropDownRows(lue);
|
}
|
|
/// <summary>
|
/// 绑定业务员数据员,tb_MyUser表
|
/// </summary>
|
/// <param name="lue"></param>
|
[CG_LookupDataBoundAttribute("绑定销售员",
|
CG_EditorType.RepositoryItemEditor)]
|
public static void BoundSales(RepositoryItemLookUpEdit lue)
|
{
|
lue.Columns.Clear();
|
InitializeControl(lue, new[] { "姓名" },
|
new[] { tb_MyUser.UserName });
|
lue.DropDownRows = 25;
|
var dt = DataDictCache.Cache.User;
|
DataBinder.BindingLookupEditDataSource(lue, dt, tb_MyUser.UserName,
|
tb_MyUser.Account);
|
SetDropDownRows(lue);
|
}
|
|
/// <summary>
|
/// 绑定枚举类型
|
/// </summary>
|
/// <param name="combo"></param>
|
/// <param name="enumType"></param>
|
public static void BoundEnum(RepositoryItemComboBox combo,
|
Type enumType)
|
{
|
var names = Enum.GetNames(enumType);
|
combo.Items.Clear();
|
combo.Items.AddRange(names);
|
}
|
|
/// <summary>
|
/// 绑定枚举类型
|
/// </summary>
|
/// <param name="combo"></param>
|
/// <param name="enumType"></param>
|
/// <param name="AddEmptyItem">第一行添加空行</param>
|
public static void BoundEnum(RepositoryItemComboBox combo,
|
Type enumType, bool AddEmptyItem)
|
{
|
var names = Enum.GetNames(enumType);
|
combo.Items.Clear();
|
combo.Items.AddRange(names);
|
|
if (AddEmptyItem) combo.Items.Insert(0, "");
|
}
|
|
/// <summary>
|
/// 绑定枚举类型
|
/// </summary>
|
/// <param name="combo"></param>
|
/// <param name="enumType"></param>
|
public static void BoundEnum(ComboBoxEdit combo, Type enumType)
|
{
|
var names = Enum.GetNames(enumType);
|
combo.Properties.Items.Clear();
|
combo.Properties.Items.AddRange(names);
|
}
|
|
/// <summary>
|
/// 绑定枚举类型
|
/// </summary>
|
/// <param name="combo"></param>
|
/// <param name="enumType"></param>
|
/// <param name="AddEmptyItem">第一行添加空行</param>
|
public static void BoundEnum(ComboBoxEdit combo, Type enumType,
|
bool AddEmptyItem)
|
{
|
var names = Enum.GetNames(enumType);
|
combo.Properties.Items.Clear();
|
combo.Properties.Items.AddRange(names);
|
|
if (AddEmptyItem) combo.Properties.Items.Insert(0, "");
|
}
|
|
public static void BoundBusinessTables(RepositoryItemLookUpEdit lue,
|
bool AddNull)
|
{
|
lue.Columns.Clear();
|
InitializeControl(lue, new[] { "编号", "单据名称" },
|
new[] { "DocCode", "FormCaption" });
|
lue.Columns[0].Width = 40;
|
lue.Columns[1].Width = 100;
|
lue.PopupWidth = 140;
|
|
var dt = DataDictCache.Cache.BusinessTables.Copy();
|
|
if (AddNull) DataTableTools.AddFirstEmptyRow(dt);
|
|
DataBinder.BindingLookupEditDataSource(lue, dt, "FormCaption",
|
"DocCode");
|
}
|
|
public static void BoundBusinessTables(LookUpEdit lue,
|
DataTable dataSource)
|
{
|
lue.Properties.Columns.Clear();
|
InitializeControl(lue, new[] { "单据名称" }, new[] { "FormName" });
|
lue.Properties.Columns[0].Width = 140;
|
lue.Properties.PopupWidth = 140;
|
DataBinder.BindingLookupEditDataSource(lue, dataSource, "FormName",
|
"DocCode");
|
}
|
|
public static void BoundBusinessTables(LookUpEdit lue, bool AddNull)
|
{
|
lue.Properties.Columns.Clear();
|
InitializeControl(lue, new[] { "单据字头", "单据名称" },
|
new[] { "DocCode", "FormCaption" });
|
lue.Properties.Columns[0].Width = 40;
|
lue.Properties.Columns[1].Width = 100;
|
lue.Properties.PopupWidth = 140;
|
|
var dt = DataDictCache.Cache.BusinessTables.Copy();
|
|
if (AddNull) DataTableTools.AddFirstEmptyRow(dt);
|
|
DataBinder.BindingLookupEditDataSource(lue, dt, "FormCaption",
|
"DocCode");
|
}
|
|
#endregion
|
}
|
}
|
