public List <CrushedMaterial> getAllCrushedMaterial() { List <CrushedMaterial> cList = new List <CrushedMaterial>(); SelectCommandBuilder s = new SelectCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde"); string sql = "SELECT id, 品番, 材料, 材料编号, 模具担当, addtime, PO处理 FROM trymolde WHERE (PO处理 = '粉碎') AND(isApprove is null) ORDER BY addtime"; SqlDataReader dr = s.ExecuteReader(sql); if (dr.HasRows) { while (dr.Read()) { CrushedMaterial c = new CrushedMaterial() { id = dr.GetInt32(0), Name = dr.GetString(1), Material = dr.GetString(2), MaterialNo = dr.GetString(3), JigLeader = dr.GetString(4), addtime = dr.GetString(5) }; cList.Add(c); } } return(cList); }
protected void btnVerify_Click(object sender, EventArgs e) { try { List <CrushedMaterial> cmList = new List <CrushedMaterial>(); List <string> sqlList = new List <string>(); if (dgvList.Rows.Count != 0 && checkVerifyInput()) { for (int i = 0; i < dgvList.Rows.Count; i++) { if ((dgvList.Rows[i].Cells[0].FindControl("cboCheckItem") as CheckBox).Checked == true) { CrushedMaterial c = new CrushedMaterial() { 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 }; cmList.Add(c); } } if (cmList.Count == 0) { Response.Write("<script>alert('没有选择任何行!')</script>"); return; } string body = "部番:"; List <string> bd = new List <string>(); string list = ""; for (int i = 0; i < cmList.Count; i++) { if (i != cmList.Count - 1) { body += cmList[i].Name + ","; list += cmList[i].JigLeader + ";"; } else { body += cmList[i].Name; list += cmList[i].JigLeader; } UpdateCommandBuilder up = new UpdateCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde"); up.UpdateColumn("isApprove", ddlVerify.SelectedItem.Text); up.UpdateColumn("ApprovedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); up.UpdateColumn("Reason", txtReason.Text.Trim()); if (string.IsNullOrEmpty(txtReason.Text.Trim())) { up.UpdateColumn("area1style", "Wait"); up.UpdateColumn("area2style", "Wait"); up.UpdateColumn("area3style", "Wait"); up.UpdateColumn("area4style", "Wait"); } up.ConditionsColumn("id", cmList[i].id); sqlList.Add(up.getUpdateCommand()); } if (ddlVerify.SelectedItem.Text == "NG") { body += "审核未通过,原因为:" + txtReason.Text; mailList = getUserMailAddress(list); } else { bd.Add(body + "审核已通过!" + " <a href='" + url + "?status=Wait&&area=1'>点击此链接开始进行粉碎...</a>"); bd.Add(body + "审核已通过!" + " <a href='" + url + "?status=Wait&&area=2'>点击此链接开始进行粉碎...</a>"); bd.Add(body + "审核已通过!" + " <a href='" + url + "?status=Wait&&area=3'>点击此链接开始进行粉碎...</a>"); bd.Add(body + "审核已通过!" + " <a href='" + url + "?status=Wait&&area=4'>点击此链接开始进行粉碎...</a>"); } InsertCommandBuilder ins = new InsertCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde"); int count = ins.ExcutTransaction(sqlList); if (count != 0) { Response.Write("<script>alert('审核成功!')</script>"); if (mailList != "") { if (ddlVerify.SelectedItem.Text == "NG") { SendMail.ExecuteSendMail(smtpIp, Port, fromUser, fromPwd, mailList, "", "试作品粉碎审核通告(系统邮件,请勿回复!)", body, "", ""); } else { for (int i = 0; i <= 3; i++) { SendMail.ExecuteSendMail(smtpIp, Port, fromUser, fromPwd, ConfigurationManager.AppSettings["area" + (i + 1)].ToString(), "", "试作品粉碎审核通告(系统邮件,请勿回复!)", bd[i], "", ""); } } } dgvList.DataSource = getAllCrushedMaterial(); dgvList.DataBind(); //Response.Write("<script>alert('" + s + "!')</script>"); } else { Response.Write("<script>alert('审核失败!')</script>"); } } } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "!')</script>");; } }