/// <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();
}
}
}