public void loadData() { //LFProdArea //string sql = "select * from cbase_all_code where CODE_GROUP='"+maintype+"'"; try { // string sql = "select * from cbase_all_code where CODE_GROUP='LFProdArea'"; string sql = "select * from cbase_all_code where CODE_GROUP='" + maintype + "'"; ds = new AppSvrHMI.L3DataSet(); ds.SourceType = AppSvrHMI.L3DataSetSourceType.SQL; ds.SourceMethod = sql; ds.L3DataAdapter = this.Adapter; ds.LoadData(); if (ds.Tables[0].Rows.Count > 0) { cbYuanyin.DataSource = ds; // cbYuanyin.DataMember = "L3DataTable"; cbYuanyin.DisplayMember = "L3DataTable.Code_Des"; } // cbYuanyin.DataSource = ds; //// cbYuanyin.DataMember = "L3DataTable"; // cbYuanyin.DisplayMember = "L3DataTable.Code_Des"; // MessageBox.Show(ds.Tables[0].Rows.Count.ToString()); } catch { return; } }
private void LoadData() { StringBuilder strsql = new StringBuilder(); // string strheatid = "炉号"; // dvTel.Rows.Clear(); //strsql.Append("select heatid as 炉号 from CCCM_Base_Data where HeatConfirm = 1 "); //strsql.Append("and PRODUCTIONDATE> sysdate-14 and heatid not in "); if (comboBox1.Text.Trim() != "") { strsql.Append("select a.heatid as 炉号,createtime as 错误时间,b.remark as 错误原因 from CCCM_Base_Data a, "); strsql.Append("(select heatid,remark,createtime,row_number()over(partition by heatid order by createtime desc) as ar "); strsql.Append(string.Format("from CRETRUNDATA_NC where BILLTYPE='{0}' and flag=1) b ", comboBox1.Text)); strsql.Append("where a.HeatConfirm = 1 and a.PRODUCTIONDATE> sysdate-14 and a.heatid=b.heatid(+) and ((b.ar=1) or (b.ar is null) ) and a.heatid not in "); strsql.Append(string.Format("( select heatid from CRETRUNDATA_NC where BILLTYPE='{0}' and flag=0 )", comboBox1.Text)); } else { return; } try { AppSvrHMI.L3DataSet dsLabElement = new AppSvrHMI.L3DataSet(); dsLabElement.SourceType = AppSvrHMI.L3DataSetSourceType.SQL; dsLabElement.SourceMethod = strsql.ToString(); dsLabElement.L3DataAdapter = this.Adapter; dsLabElement.LoadData(); dvTel.DataSource = dsLabElement.Tables[0]; MessageBox.Show("执行完毕"); } catch { return; } }