protected void btnRun_Click(object sender, EventArgs e) { btnRun.Attributes["onclick"] = this.GetPostBackEventReference(this.btnRun) + ";this.disabled=true;this.value='处理中...'"; string id = CommadMethod.getNextId("GID" + DateTime.Now.ToString("yyyyMMdd"), ""); txtMNo.BackColor = Color.White; SelectCommandBuilder s = new SelectCommandBuilder(constr, ""); string sql = "select count(*) from goods_tran where goods_no=(select DISTINCT goods_name from goods_tmp where goods_id = '" + ViewState["id"].ToString() + "')"; string sql1 = "select count(*) from goods_tmp where goods_name = '" + txtgoodsName.Text.Trim().ToUpper() + "' and version = '" + txtVersion.Text.Trim().ToUpper().ToUpper() + "'"; string sql2 = "select count(*) from materials where name = '" + txtMNo.Text.Trim().ToUpper() + "'"; string sql3 = "select count(*) from goods_chage_record where goods_name='" + txtgoodsName.Text.Trim().ToUpper() + "' and version = '" + txtVersion.Text.Trim().ToUpper().ToUpper() + "'"; int count = Convert.ToInt32(s.ExecuteScalar(sql)); int count1 = Convert.ToInt32(s.ExecuteScalar(sql1)); int count2 = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(sql2)); int count3 = Convert.ToInt32(s.ExecuteScalar(sql3)); int i = 0; if (count2 == 0) { Response.Write("<script>alert('材料编号不存在,请确认后再试!')</script>"); txtMNo.BackColor = Color.Red; txtMNo.Focus(); return; } if (count3 != 0) { Response.Write("<script>alert('该部品已经被发行!')</script>"); return; } if (count1 == 0) { InsertData("goods_tmp", id); hifId.Value = id; } if (count != 0) { //UpdateData("goods_tran"); new DeleteCommandBuilder(constr, "").ExecuteNonQuery("delete from goods_tran where goods_no = '" + txtgoodsName.Text.Trim().ToUpper() + "'"); InsertData("goods_tran", hifId.Value.Trim()); } else { InsertData("goods_tran", hifId.Value.Trim()); } UpdateCommandBuilder u = new UpdateCommandBuilder(constr, "goods_tran"); u.UpdateColumn("isConfirm", "Waiting"); u.ConditionsColumn("goods_no", txtgoodsName.Text.Trim().ToUpper()); u.getUpdateCommand(); i = Convert.ToInt32(u.ExecuteNonQuery()); if (i != 0) { InsertData("goods_chage_record", hifId.Value.Trim()); new UpdateCommandBuilder(constr, "").ExecuteNonQuery("update goods_tmp set lb8_id = '1'"); Response.Write("<script>alert('发行成功')</script>"); dgvList.DataSource = getConfirmGoodsList(ViewState["id"].ToString()); dgvList.DataBind(); string _body = "部番:" + txtgoodsName.Text + " 版本:" + txtVersion.Text.Trim() + " 已发行成功," + "<a href='http://192.168.1.199:81/GoodsManager/Goods_Aprove.aspx'>点击此链接快速审核...</a>"; SendMail.ExecuteSendMail(smtpIp, Port, fromUser, fromPwd, mailList, ccList, "部品发行成功通知", _body, "", ""); } else { Response.Write("<script>alert('发行失败')</script>"); } }
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>");; } }