void btnSave_Click(object sender, EventArgs e) { try { List <CheckBox> listString = GetCheckedID(); if (listString.Count > 0) { if (CheckStringEmpty()) { for (int i = 0; i < this.gv.Rows.Count; i++) { chb = (CheckBox)this.gv.Rows[i].Cells[0].Controls[0]; if (!chb.Checked) { continue; } if (this.gv.Rows[i].Cells[4].Controls[0] is TextBox) { itembox = (TextBox)this.gv.Rows[i].Cells[4].Controls[0]; using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { AwaitScrap asp = db.AwaitScrap.SingleOrDefault(u => u.AwaitScrapID == int.Parse(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text)); asp.ScrapReportNum = itembox.Text.Trim(); db.SubmitChanges(); } } } Response.Redirect("AwaitScrapManage.aspx", false); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将选择的数据填写完整!')</script>"); return; } } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择要提交的物资!')</script>"); return; } } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_UPDATEERROR)); } }
void btnReject_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { if (db.AwaitScrap.Count(u => u.TransferID.Equals(_transferid) && u.TransferType.Equals("正常检验")) == 0)//没有写入报废库则写入,考虑用户IE回退等问题 { AwaitScrap asrp; foreach (GridViewRow gvr in this.spgvRejectMaterial.Rows) { asrp = new AwaitScrap(); asrp.State = "待报废"; asrp.ScrapReportNum = "未填写"; asrp.TransferType = "正常检验"; asrp.StorageID = Convert.ToInt32(gvr.Cells[12].Text); asrp.PileID = Convert.ToInt32(gvr.Cells[13].Text); asrp.MaterialID = Convert.ToInt32(gvr.Cells[14].Text); asrp.ManufactureID = Convert.ToInt32(gvr.Cells[15].Text); asrp.Gentaojian = Convert.ToDecimal(gvr.Cells[3].Text); asrp.TransferID = _transferid; asrp.ProjectID = db.SrinInspectorVerifyTransfer.SingleOrDefault(u => u.SrinInspectorVerifyTransferID.Equals(_transferid)).SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.Project; asrp.Creator = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID; asrp.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); db.AwaitScrap.InsertOnSubmit(asrp); } db.SubmitChanges(); } } Response.Redirect(string.Format("../PublicPage/SendMessage.aspx?TaskID={0}", _taskid), false); } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_INSERTERROR)); } }
void btnSave_Click(object sender, EventArgs e) { try { List <CheckBox> listString = GetCheckedID(); if (listString.Count > 0) { if (listString.Count != 1) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择一条且仅能有一条记录进行报废!')</script>"); return; } if (CheckReportNum()) { if (CheckStringEmpty()) { for (int i = 0; i < this.gv.Rows.Count; i++) { chb = (CheckBox)this.gv.Rows[i].Cells[0].Controls[0]; if (!chb.Checked) { continue; } if (this.gv.Rows[i].Cells[4].Controls[0] is TextBox) { itembox = (TextBox)this.gv.Rows[i].Cells[4].Controls[0]; using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { AapId = int.Parse(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text); AwaitScrap asp = db.AwaitScrap.SingleOrDefault(u => u.AwaitScrapID == AapId); asp.State = "已报废"; Scrapped sp = new Scrapped(); sp.AwaitScrapID = AapId; sp.StockID = Convert.ToInt32(this.txtID.Text.Trim()); sp.StockType = this.txtType.Text.Trim(); sp.ScrappedNum = itembox.Text.Trim(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); sp.ScrappedTime = SevTime.First(); var Time = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); sp.CreateTime = Time.First(); sp.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); db.Scrapped.InsertOnSubmit(sp); db.SubmitChanges(); } } } Response.Redirect("ScrappedInfo.aspx", false); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将选择的数据填写完整!')</script>"); return; } } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('所选物资中存在未设定待报废报告号的物资!')</script>"); return; } } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择要提交的物资!')</script>"); return; } } catch (Exception ex) { MethodBase mb = MethodBase.GetCurrentMethod(); LogToDBHelper lhelper = LogToDBHelper.Instance; lhelper.WriteLog(ex.Message, "错误", string.Format("{0}.{1}", mb.ReflectedType.Name, mb.Name)); ClientScript.RegisterClientScriptBlock(typeof(string), "提示", string.Format("<script>alert('{0}')</script>", LogToDBHelper.LOG_MSG_UPDATEERROR)); } }