/// <summary>
/// 创建LookUpEdit
/// </summary>
/// <param name="lueControl">控件名称</param>
/// <param name="tableName">表名</param>
/// <param name="valueMember">代码字段</param>
/// <param name="valueName">代码字段标题</param>
/// <param name="displayMember">显示内容字段</param>
/// <param name="condition">显示内容标题</param>
/// <returns></returns>
public static void GetLookUpEditControl(LookUpEdit lueControl, string tableName,
string valueMember, string valueName,
string displayMember, string displayName,
string condition)
{
//设置显示格式和字段
lueControl.Properties.Appearance.Font = new System.Drawing.Font("SimSun", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
lueControl.Properties.Appearance.Options.UseFont = true;
lueControl.Properties.AppearanceDropDown.Font = new System.Drawing.Font("SimSun", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lueControl.Properties.AppearanceDropDown.Options.UseFont = true;
lueControl.Properties.Columns.Clear();
lueControl.Properties.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo(valueMember, valueName)
, new DevExpress.XtraEditors.Controls.LookUpColumnInfo(displayMember, displayName)
});
lueControl.Properties.DisplayMember = displayMember;
lueControl.Properties.ValueMember = valueMember;
lueControl.Properties.TextEditStyle = TextEditStyles.DisableTextEditor;
lueControl.Properties.NullText = "";
ProxyBllCommon bllCommon = new ProxyBllCommon();
//获得数据集
DataSet dsTable = bllCommon.GetLookUpEditDataSet(tableName, condition);
//有数据情况下绑定
if (dsTable != null && dsTable.Tables.Count > 0)
{
lueControl.Properties.DataSource = dsTable.Tables[0];
}
}
/// <summary>
/// 将工作站状态绑定到lue上。
/// </summary>
/// <param name="lueControl"></param>
public static void FillLueWorkStationStauts(DevExpress.XtraEditors.LookUpEdit lueControl)
{
//设置显示格式和字段
lueControl.Properties.Appearance.Font = new System.Drawing.Font("SimSun", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
lueControl.Properties.Appearance.Options.UseFont = true;
lueControl.Properties.AppearanceDropDown.Font = new System.Drawing.Font("SimSun", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lueControl.Properties.AppearanceDropDown.Options.UseFont = true;
lueControl.Properties.Columns.Clear();
lueControl.Properties.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo("F_VALUE", "编码")
, new DevExpress.XtraEditors.Controls.LookUpColumnInfo("F_DISPLAY", "状态")
});
lueControl.Properties.DisplayMember = "F_DISPLAY";
lueControl.Properties.ValueMember = "F_VALUE";
lueControl.Properties.TextEditStyle = TextEditStyles.DisableTextEditor;
lueControl.Properties.TextEditStyle = TextEditStyles.DisableTextEditor;
ProxyBllCommon bllCommon = new ProxyBllCommon();
//获得数据集
DataSet dsTable = bllCommon.GetLookUpEditDataSet("T_SYSTEM_LIST", "F_TYPE='F_WORKSTATION_STATUS'");
//有数据情况下绑定
if (dsTable != null && dsTable.Tables.Count > 0)
{
lueControl.Properties.DataSource = dsTable.Tables[0];
}
}
/// <summary>
/// 创建RepositoryItemLookUpEdit
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="valueMember">主键字段</param>
/// <param name="displayMember"></param>
/// <param name="condition"></param>
/// <returns></returns>
public static DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit GetRepositoryItemLookUpEditControl(string tableName,
string valueMember,
string displayMember,
string condition)
{
DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit repositoryItemLookUpEdit = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit();
repositoryItemLookUpEdit.Appearance.Font = new System.Drawing.Font("SimSun", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
repositoryItemLookUpEdit.Appearance.Options.UseFont = true;
repositoryItemLookUpEdit.AutoHeight = false;
repositoryItemLookUpEdit.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)
});
repositoryItemLookUpEdit.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] {
new DevExpress.XtraEditors.Controls.LookUpColumnInfo(displayMember, displayMember),
new DevExpress.XtraEditors.Controls.LookUpColumnInfo(valueMember, valueMember)
});
ProxyBllCommon bllCommon = new ProxyBllCommon();
DataSet dsTable = bllCommon.GetLookUpEditDataSet(tableName, condition);
if (dsTable != null && dsTable.Tables.Count > 0)
{
repositoryItemLookUpEdit.DataSource = dsTable.Tables[0];
}
repositoryItemLookUpEdit.DisplayMember = displayMember;
repositoryItemLookUpEdit.ValueMember = valueMember;
//默认显示内容
repositoryItemLookUpEdit.NullText = "";
return(repositoryItemLookUpEdit);
}
