前台获取sql数据集

 EFX.EFCGrid.InitSingleGridColumn(this.efDevGrid_where, v_func_id, v_curr_part_name);
                (EFX.EFCGrid.GetEFCGridBase(efDevGrid_where) as EFX.EFCGridImp.SingleDev.EFCGridSingleDev).ResetGridValue();
                if (factory_div.Trim() == "LG_2")//长材
                {

                    string s_sqlstr = "SELECT ST_NO AS 出钢记号,LG_ST AS 炼钢钢种,INGOT_CODE AS 坯型 FROM PSSMMA.TPSSMMABWD9 WHERE FACTORY_DIV='LG2'";
                    
                    DataTable dt = EF.Utility.ExecQueryPart(this.ef_args.formPartition, s_sqlstr).Tables[0];
                   
                    //设置任务编号数据源
                    (EFX.EFCGrid.GetEFCGridBase(efDevGrid_where).Columns["ST_NO"]).SetPopupGridDataSource(dt, "出钢记号", new string[]  { "炼钢钢种","坯型" });
                }

 

posted @ 2022-03-25 09:57  gitee1412  阅读(119)  评论(0编辑  收藏  举报