绑定Lookup
来源:互联网 发布:如何运行mysql命令 编辑:程序博客网 时间:2024/06/05 04:21
C# code
/// <summary>
/// 绑定LookupEdit
/// </summary>
/// <param name="LookUp">控件名</param>
/// <param name="TableName">表名</param>
/// <param name="columnValueName">Value字段</param>
/// <param name="columnDispName">显示字段</param>
/// <param name="Condition">提取表的条件</param>
/// <param name="type">Value字段类型</param>
public static void BindLookUpbyCondition(DevExpress.XtraEditors.LookUpEdit LookUp, string TableName, string columnValueName, string columnDispName, string Condition ,Type type)
{
MES.BLL.BaseDataManage m = new BaseDataManage();
DataTable DT = AppHelper.GetTableByTabaleNameAndColumnNameAndCondition(TableName, columnValueName, columnDispName, Condition);
DataTable sourceDT = new DataTable();
DataColumn c = new DataColumn();
c.Caption = "序号";
c.ColumnName = "CODE";
c.DataType = type;
sourceDT.Columns.Add(c);
c = new DataColumn();
c.Caption = "值";
c.ColumnName = "DISP";
c.DataType = typeof(System.String);
sourceDT.Columns.Add(c);
foreach (DataRow r in DT.Rows)
{
DataRow rowNew = sourceDT.NewRow();
if (type.FullName == "System.String")
{
rowNew["CODE"] = r[columnValueName].ToString();
}
else
{
rowNew["CODE"] = (int)(decimal)r[columnValueName];
}
rowNew["DISP"] = r[columnDispName].ToString();
sourceDT.Rows.Add(rowNew);
}
LookUp.Properties.DataSource = sourceDT;
LookUp.Properties.Columns.Clear();
LookUp.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo(c.ColumnName, 200, c.Caption));
LookUp.Properties.DisplayMember = c.ColumnName;
LookUp.Properties.ValueMember = "CODE";
LookUp.Properties.NullText = "--请选择--";
}
- 绑定Lookup
- EJB Remote/Local 绑定和JNDI Lookup
- lookup
- dwz 通过js 动态生成的查找找回按钮需要手动绑定lookup() 方法
- ENUM Lookup
- Lookup forms
- informatical lookup
- LOOKUP Function
- lookup transformation
- lookup原理
- Bookmark Lookup
- Lookup Table
- MSCRM2011 lookup
- CMapStringToOb::Lookup
- informatical lookup
- IP Lookup
- Constraint Lookup
- Lookup Transformation
- java 获取当前路径
- Hive随谈(六):Hive扩展特性
- 在Windows下搭建Android2.2开发环境
- 三星bada平台开发挑战赛-----武汉高校赛
- USACO Solution Code(6):Mixing Milk & Barn Repair
- 绑定Lookup
- 简述Oracle 11g 新特性
- 摘录
- WinCE6下字符串在注册表中读写操作
- How to Bind an ArrayList to a DataGrid -- 解决ArrayList刷新问题
- 转凉篇
- serv u 9.4.0.2 安装在windows2003下客户端不能访问的解决
- SQL自动增长列
- Android移植: wifi设计原理(转)