public List <CrushedMaterialDetail> getAllCrushedMaterial(string area, string status)
{
List <CrushedMaterialDetail> cList = new List <CrushedMaterialDetail>();
SelectCommandBuilder s = new SelectCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde");
string sql = "SELECT id, 品番, 材料, 材料编号, 模具担当, addtime, area1style, area2style, area3style, area4style FROM trymolde WHERE (PO处理 = '粉碎') AND (isApprove = 'OK') AND (area" + area + "style = '" + status + "') ORDER BY addtime";
SqlDataReader dr = s.ExecuteReader(sql);
if (dr.HasRows)
{
while (dr.Read())
{
CrushedMaterialDetail c = new CrushedMaterialDetail()
{
id = dr.GetInt32(0),
Name = dr.GetString(1),
Material = dr.GetString(2),
MaterialNo = dr.GetString(3),
JigLeader = dr.GetString(4),
addtime = dr.GetString(5),
area1style = dr.IsDBNull(6) ? "待粉碎" : getStatusdeng(dr.GetString(6)),
area2style = dr.IsDBNull(7) ? "待粉碎" : getStatusdeng(dr.GetString(7)),
area3style = dr.IsDBNull(8) ? "待粉碎" : getStatusdeng(dr.GetString(8)),
area4style = dr.IsDBNull(9) ? "待粉碎" : getStatusdeng(dr.GetString(9))
};
cList.Add(c);
}
}
return(cList);
}
protected void btnDone_Click(object sender, EventArgs e)
{
if (ddlDemp.SelectedItem.Value == "0")
{
Response.Write("<script>alert('请选择处理区域!')</script>");
return;
}
else
{
ViewState["area"] = ddlDemp.SelectedItem.Value;
}
List <CrushedMaterialDetail> cmList = new List <CrushedMaterialDetail>();
List <string> sqlList = new List <string>();
if (dgvList.Rows.Count != 0)
{
for (int i = 0; i < dgvList.Rows.Count; i++)
{
if ((dgvList.Rows[i].Cells[0].FindControl("cboCheckItem") as CheckBox).Checked == true)
{
CrushedMaterialDetail c = new CrushedMaterialDetail()
{
id = int.Parse((dgvList.Rows[i].Cells[0].FindControl("Hfid") as HiddenField).Value),
Name = (dgvList.Rows[i].Cells[1].FindControl("Label1") as Label).Text,
MaterialNo = (dgvList.Rows[i].Cells[2].FindControl("Label2") as Label).Text,
Material = (dgvList.Rows[i].Cells[3].FindControl("Label3") as Label).Text,
JigLeader = (dgvList.Rows[i].Cells[4].FindControl("Label4") as Label).Text,
addtime = (dgvList.Rows[i].Cells[5].FindControl("Label5") as Label).Text,
area1style = (dgvList.Rows[i].Cells[6].FindControl("Label6") as Label).Text,
area2style = (dgvList.Rows[i].Cells[7].FindControl("Label7") as Label).Text,
area3style = (dgvList.Rows[i].Cells[8].FindControl("Label8") as Label).Text,
area4style = (dgvList.Rows[i].Cells[9].FindControl("Label9") as Label).Text,
Qty = int.Parse((dgvList.Rows[i].Cells[10].FindControl("TextBox1") as TextBox).Text == string.Empty ? "0" : (dgvList.Rows[i].Cells[10].FindControl("TextBox1") as TextBox).Text)
};
cmList.Add(c);
}
}
if (cmList.Count == 0)
{
Response.Write("<script>alert('没有选择任何行!')</script>");
return;
}
for (int i = 0; i < cmList.Count; i++)
{
UpdateCommandBuilder up = new UpdateCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde");
string status = "";
switch (ViewState["area"].ToString())
{
case "1":
up.UpdateColumn("area1style", "Done(" + cmList[i].Qty + ")");
up.UpdateColumn("area1CrushedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
status = cmList[i].area1style;
break;
case "2":
up.UpdateColumn("area2style", "Done(" + cmList[i].Qty + ")");
up.UpdateColumn("area2CrushedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
status = cmList[i].area2style;
break;
case "3":
up.UpdateColumn("area3style", "Done(" + cmList[i].Qty + ")");
up.UpdateColumn("area3CrushedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
status = cmList[i].area3style;
break;
case "4":
up.UpdateColumn("area4style", "Done(" + cmList[i].Qty + ")");
up.UpdateColumn("area4CrushedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
status = cmList[i].area4style;
break;
default:
break;
}
up.ConditionsColumn("id", cmList[i].id);
sqlList.Add(up.getUpdateCommand());
if (status != "粉碎中")
{
Response.Write("<script>alert('选择行中数据有误，请选择<粉碎中>的部番!')</script>");
return;
}
}
InsertCommandBuilder ins = new InsertCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde");
int count = ins.ExcutTransaction(sqlList);
if (count != 0)
{
dgvList.DataSource = getAllCrushedMaterial();
dgvList.DataBind();
}
}
}
