/// <summary> /// 绑定DataGridView1 /// </summary> /// <param name="sql">要查询的sql</param> private void Bind(string sql) { OracleDataReader myread = DataPublic.ReadDb(sql); task_data.Rows.Clear(); try { String machineseq = "", cusname = "", cigarename = "", pokenum = "", sortnum = "", regioncode = ""; while (myread != null && myread.Read()) { machineseq = myread["machineseq"].ToString().Trim(); cusname = myread["customername"].ToString().Trim(); cigarename = myread["cigarettename"].ToString().Trim(); pokenum = myread["pokenum"].ToString().Trim(); sortnum = myread["sortnum"].ToString().Trim(); regioncode = myread["regioncode"].ToString().Trim(); int index = this.task_data.Rows.Add(); this.task_data.Rows[index].Cells[0].Value = machineseq; this.task_data.Rows[index].Cells[1].Value = cusname; this.task_data.Rows[index].Cells[2].Value = cigarename; this.task_data.Rows[index].Cells[3].Value = pokenum; this.task_data.Rows[index].Cells[4].Value = sortnum; this.task_data.Rows[index].Cells[5].Value = regioncode; } } finally { if (myread != null) { myread.Close(); myread.Dispose(); } } }
public void initdata() { String sql = "select sum(ceil(h.taskquantity/36)) as sl,h.regioncode as czxx,h.packagedesc " + "FROM highspeed.T_PRODUCE_TASK h " + "group by h.regioncode,h.packagedesc order by h.regioncode,h.packagedesc"; OracleDataReader myread = DataPublic.ReadDb(sql); task_data.Rows.Clear(); try { String sl = "", czxx = "", packagedesc = ""; while (myread != null && myread.Read()) { sl = myread["sl"].ToString().Trim(); czxx = myread["czxx"].ToString().Trim(); packagedesc = myread["packagedesc"].ToString().Trim(); int index = this.task_data.Rows.Add(); this.task_data.Rows[index].Cells[0].Value = czxx; this.task_data.Rows[index].Cells[1].Value = sl; this.task_data.Rows[index].Cells[2].Value = packagedesc; } } finally { if (myread != null) { myread.Close(); myread.Dispose(); } } }
/// <summary> /// 绑定DataGridView1 /// </summary> /// <param name="sql">要查询的sql</param> private void Bind(string sql) { OracleDataReader myread = DataPublic.ReadDb(sql); task_data.Rows.Clear(); try { String machineseq = "", cusname = "", cigarename = "", sortseq = "", quantity = "", taskquantity = "", chezu, tasknum; while (myread != null && myread.Read()) { machineseq = myread["machineseq"].ToString().Trim(); cusname = myread["customername"].ToString().Trim(); cigarename = myread["cigarettename"].ToString().Trim(); quantity = myread["quantity"].ToString().Trim(); tasknum = myread["tasknum"].ToString().Trim(); chezu = myread["regioncode"].ToString().Trim(); sortseq = myread["sortseq"].ToString().Trim(); int index = this.task_data.Rows.Add(); this.task_data.Rows[index].Cells[0].Value = machineseq; this.task_data.Rows[index].Cells[1].Value = cusname; this.task_data.Rows[index].Cells[2].Value = cigarename; this.task_data.Rows[index].Cells[3].Value = quantity; this.task_data.Rows[index].Cells[4].Value = tasknum; this.task_data.Rows[index].Cells[5].Value = chezu + "/" + sortseq; } } finally { if (myread != null) { myread.Close(); myread.Dispose(); } } }
/// <summary> /// 绑定DataGridView1 /// </summary> /// <param name="sql">要查询的sql</param> private void Bind(string sql) { OracleDataReader myread = DataPublic.ReadDb(sql); task_data.Rows.Clear(); try { String cigarettecode = "", tasknum = "", regioncode = "", cigarename = "", quantity = "", taskquantity = ""; while (myread != null && myread.Read()) { cigarettecode = myread["cigarettecode"].ToString().Trim(); cigarename = myread["cigarettename"].ToString().Trim(); quantity = myread["replenishqty"].ToString().Trim(); tasknum = myread["tasknum"].ToString().Trim(); regioncode = myread["regioncode"].ToString().Trim(); int index = this.task_data.Rows.Add(); this.task_data.Rows[index].Cells[0].Value = cigarettecode; this.task_data.Rows[index].Cells[1].Value = cigarename; this.task_data.Rows[index].Cells[2].Value = quantity; this.task_data.Rows[index].Cells[3].Value = tasknum; this.task_data.Rows[index].Cells[4].Value = regioncode; } } finally { if (myread != null) { myread.Close(); myread.Dispose(); } } }
public void initdata() { String sql = "SELECT rownum as seq ,total.*,finish.finishcuscount,finish.finishqty,round(finishqty/qty*100,2)AS percent FROM " + "(SELECT o.regioncode,COUNT(o.billcode) AS cuscount,SUM(o.taskquantity)AS qty FROM t_produce_task o GROUP BY o.regioncode)total left outer join " + "(SELECT o.regioncode,COUNT(o.billcode) AS finishcuscount,SUM(o.taskquantity)AS finishqty FROM t_produce_task o WHERE state='30' GROUP BY o.regioncode)finish " + "on total.regioncode=finish.regioncode ORDER BY total.regioncode"; OracleDataReader myread = DataPublic.ReadDb(sql); task_data.Rows.Clear(); try { String regioncode = "", cuscount = "", qty = "", finishcuscount = "", finishqty = "", percent = "", seq = ""; while (myread != null && myread.Read()) { seq = myread["seq"].ToString().Trim(); regioncode = myread["regioncode"].ToString().Trim(); cuscount = myread["cuscount"].ToString().Trim(); qty = myread["qty"].ToString().Trim(); finishcuscount = myread["finishcuscount"].ToString().Trim(); if (finishcuscount == "") { finishcuscount = "0"; } finishqty = myread["finishqty"].ToString().Trim(); if (finishqty == "") { finishqty = "0"; } percent = myread["percent"].ToString().Trim(); if (finishqty == "0") { percent = "0"; } int index = this.task_data.Rows.Add(); this.task_data.Rows[index].Cells[0].Value = seq; this.task_data.Rows[index].Cells[1].Value = regioncode; this.task_data.Rows[index].Cells[2].Value = regioncode; this.task_data.Rows[index].Cells[3].Value = finishcuscount + "/" + cuscount; this.task_data.Rows[index].Cells[4].Value = finishqty + "/" + qty; this.task_data.Rows[index].Cells[5].Value = percent + "%"; } } finally { if (myread != null) { myread.Close(); myread.Dispose(); } } }
/// <summary> /// 绑定DataGridView1 /// </summary> /// <param name="sql">要查询的sql</param> private void Bind(string sql) { OracleDataReader myread = DataPublic.ReadDb(sql); task_data.Rows.Clear(); try { String tasknum = "", cusname = "", cigarename = "", quantity = "", taskquantity = ""; while (myread != null && myread.Read()) { tasknum = myread["tasknum"].ToString().Trim(); cusname = myread["customername"].ToString().Trim(); cigarename = myread["cigarettename"].ToString().Trim(); quantity = myread["quantity"].ToString().Trim(); taskquantity = myread["taskquantity"].ToString().Trim(); int index = this.task_data.Rows.Add(); this.task_data.Rows[index].Cells[0].Value = tasknum; this.task_data.Rows[index].Cells[1].Value = cusname; this.task_data.Rows[index].Cells[2].Value = cigarename; this.task_data.Rows[index].Cells[3].Value = quantity; this.task_data.Rows[index].Cells[4].Value = taskquantity; } //MessageBox.Show(sFun.getCzcode("950")); /*int indexj=0; * for (int i = 0; i < task_data.RowCount;i++ ) * { * if(this.task_data.Rows[i].Cells[0].Value.ToString()=="0204") * { * indexj=i; * break; * } * } * for (int i = 0; i < 10;i++ ) * { * double per=double.Parse(this.task_data.Rows[indexj].Cells[5].Value.ToString()); * per = per + i; * this.task_data.Rows[indexj].Cells[5].Value = per; * } */ } finally { if (myread != null) { myread.Close(); myread.Dispose(); } } }
public void init() { //初始化分拣线选择下拉框 String sSql1 = "select min(tasknum) num from t_produce_task"; String sSql2 = "select max(tasknum) num from t_produce_task"; OracleDataReader myread = DataPublic.ReadDb(sSql1); try { if (myread != null && myread.Read()) { textBox1.Text = myread["num"].ToString(); } } finally { if (myread != null) { myread.Close(); myread.Dispose(); } } myread = DataPublic.ReadDb(sSql2); try { if (myread != null && myread.Read()) { textBox2.Text = myread["num"].ToString(); } } finally { if (myread != null) { myread.Close(); myread.Dispose(); } } }