
using (DevExpress.Utils.WaitDialogForm dlg = new DevExpress.Utils.WaitDialogForm("请稍等", "查询中......", new System.Drawing.Size(100, 50)))
{
string sqlString = "SELECT ITEM ,DESCRIPTION ,CATEGORY3 FROM WIPDBA.TIME_IMA x WHERE x.SITE = '1140' ";//and x.ITEM = '1000080309'
var aa = ado.ExecuteDataTable(sqlString);
gridControl1.DataSource = aa;
//string fieldtitle = "物料组名称";
//string fieldname = "物料组名称";
//DevExpress.Data.UnboundColumnType ctype = DevExpress.Data.UnboundColumnType.String;
//gridView1._创建一个非绑定列(fieldname, fieldtitle, ctype);
}
gridView1.CustomUnboundColumnData += GridView1_CustomUnboundColumnData;
config.物料描述缓存 = DB.xmdb.Select<Z_ERP_T023T>().ToList();
private void GridView1_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
if (e.Column.FieldName == "物料组名称" && e.IsGetData)
e.Value = config.物料描述缓存.Find(a => a.MATKL == (e.Row as DataRowView).Row["CATEGORY3"]?.ToString())?.WGBEZ;
}
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· TypeScript + Deepseek 打造卜卦网站:技术与玄学的结合
· Manus的开源复刻OpenManus初探
· AI 智能体引爆开源社区「GitHub 热点速览」
· 三行代码完成国际化适配,妙~啊~
· .NET Core 中如何实现缓存的预热?