public void btnSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(this.txtBillCode.Text)) { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageIn SI = new StorageIn(); StorageIn scode = db.StorageIn.SingleOrDefault(u => u.StorageInCode == this.txtBillCode.Text.Trim()); if (scode != null) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('单据编码重复!')</script>"); return; } SI.StorageInCode = this.txtBillCode.Text.Trim(); SI.Remark = this.txtRemark.Text.Trim(); //var SevTime = db.ExecuteQuery<DateTime>("select getdate()", new object[] { }); SI.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); SI.CreateTime = this.DateTimeStorageIn.SelectedDate; db.StorageIn.InsertOnSubmit(SI); db.SubmitChanges(); Response.Redirect("StorageInManage.aspx"); } } } 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)); } }
private void LoadData() { //单据ID int mainID = 0; using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int id = Convert.ToInt32(Request.QueryString["StorageDetailedID"]); StorageInDetailed SID = db.StorageInDetailed.SingleOrDefault(a => a.StorageDetailedID == id); if (SID != null) { //单据id mainID = SID.StorageInID; StorageIn SI = db.StorageIn.SingleOrDefault(u => u.StorageInID == mainID); this.txtStorageinNum.Text = SI.StorageInCode; this.txtMaterialCode.Text = SID.MaterialInfo.MaterialCode; this.txtMaterialMod.Text = SID.SpecificationModel; this.txtMaterialQuantity.Text = SID.Quantity.ToString(); this.txtGTJ.Text = SID.QuantityGentaojian.ToString(); this.txtMetre.Text = SID.QuantityMetre.ToString(); this.txtTon.Text = SID.QuantityTon.ToString(); this.ddlUnit.SelectedIndex = reIndex(SID.CurUnit.ToString()); this.txtMaterialUnitPrice.Text = SID.UnitPrice.ToString(); this.txtMaterialAmount.Text = SID.Amount.ToString(); this.ddlStorage.SelectedValue = SID.PileInfo.StorageID.ToString(); this.ddlPile.SelectedValue = SID.PileInfo.PileID.ToString(); this.txtMaterialfinance.Text = SID.financeCode.ToString(); this.DateTimeStorageIn.SelectedDate = SID.StorageTime; this.ddlSupplier.SelectedValue = SID.SupplierInfo.SupplierID.ToString(); this.txtManager.Text = db.EmpInfo.SingleOrDefault(u => u.EmpID == SID.MaterialsManager).Account; this.txtWarehouseWorker.Text = db.EmpInfo.SingleOrDefault(u => u.EmpID == SID.WarehouseWorker).Account; this.ddlbatch.SelectedValue = SID.BatchIndex.Trim(); this.txtRemark.Text = SID.Remark.ToString(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('记录不存在! ');</script>"); Response.Redirect("StorageInDetailedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + ""); } } }
void btnOK_Click(object sender, EventArgs e) { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { if (chbAgree.Checked == true) { Response.Redirect("QualityControlMessage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&QCBatch=" + Request.QueryString["QCBatch"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&state=材料会计审核&&storageInType=正常入库"); } else { //任务信息 TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(_taskID)); tsi.TaskState = "已完成"; StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID); //发送新任务(回退任务) TaskStorageIn TSI = new TaskStorageIn(); TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); TSI.TaskTargetID = tsi.TaskCreaterID; if (TSI.TaskTargetID == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户,请同步AD账户 ')</script>"); return; } TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); TSI.StorageInType = "正常入库"; TSI.TaskTitle = "质检任务:" + tsi.TaskTitle.ToString() + "(质检未通过)"; TSI.TaskState = "未完成"; TSI.TaskDispose = "未废弃"; TSI.TaskType = "质检前清单"; TSI.InspectState = "驳回"; //TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString(); TSI.QCBatch = tsi.QCBatch; TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资质检不合格原因:" + this.txtOpinion.Text.Trim(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); TSI.CreateTime = SevTime.First(); db.TaskStorageIn.InsertOnSubmit(TSI); db.SubmitChanges(); Response.Redirect("../../default-old.aspx", false); } } }
public void btnSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(this.txtBillCode.Text)) { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int id = Convert.ToInt32(Request.QueryString["StorageInID"]); StorageIn SI = db.StorageIn.SingleOrDefault(a => a.StorageInID == id); //单据编号唯一 StorageIn scode = db.StorageIn.SingleOrDefault(u => u.StorageInCode == this.txtBillCode.Text.Trim()); if (scode == null) { SI.StorageInCode = this.txtBillCode.Text.Trim(); } else { if (SI.StorageInID == scode.StorageInID) { SI.StorageInCode = this.txtBillCode.Text.Trim(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('单据号重复!')</script>"); return; } } SI.StorageInCode = this.txtBillCode.Text.Trim(); SI.Remark = this.txtRemark.Text.Trim(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); SI.CreateTime = SevTime.First(); db.SubmitChanges(); Response.Redirect("StorageInManage.aspx"); } } } 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)); } }
private void BindDefaultDate() { int id = 0; if (!string.IsNullOrEmpty(Request.QueryString["StorageInID"])) { id = Convert.ToInt32(Request.QueryString["StorageInID"]); using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageIn temp = db.StorageIn.SingleOrDefault(u => u.StorageInID == id); this.txtStorageinNum.Text = temp.StorageInCode.ToString(); this.txtStorageinNum.Enabled = false; } } else { Response.Redirect("StorageInManage.aspx"); } }
private void LoadData() { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int id = Convert.ToInt32(Request.QueryString["StorageInID"]); StorageIn SI = db.StorageIn.SingleOrDefault(a => a.StorageInID == id); if (SI != null) { this.txtBillCode.Text = SI.StorageInCode.ToString(); this.DateTimeStorageIn.SelectedDate = SI.CreateTime; this.txtRemark.Text = SI.Remark.ToString(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('记录不存在! ');</script>"); Response.Redirect("StorageInManage.aspx"); } } }
void btnOK_Click(object sender, EventArgs e) { //修改审核状态为初始值 using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //旧任务 TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"])); tsi.TaskState = "已完成"; StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID); //新任务 TaskStorageIn TSI = new TaskStorageIn(); TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); TSI.TaskTargetID = tsi.TaskCreaterID; if (TSI.TaskTargetID == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户,请同步AD账户 ')</script>"); return; } TSI.StorageInID = _storageInID; TSI.StorageInType = "正常入库"; TSI.TaskTitle = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资已修改,请重新质检"; TSI.TaskState = "未完成"; TSI.TaskDispose = "未废弃"; TSI.TaskType = "质检"; TSI.InspectState = "未审核"; TSI.QCBatch = tsi.QCBatch; TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资已修改"; var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); TSI.CreateTime = SevTime.First(); db.TaskStorageIn.InsertOnSubmit(TSI); db.SubmitChanges(); Response.Redirect("../../default-old.aspx", false); } }
private void BindGridView() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化TaskStoreIn信息 TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(t => t.TaskStorageID == _taskstorageid); if (tsi == null) { Response.Redirect(_errorpage); return; } ((Label)GetControltByMaster("labTaskCreater")).Text = tsi.EmpInfo.EmpName + "[" + tsi.EmpInfo.Account + "]"; ((Label)GetControltByMaster("labCreateTime")).Text = tsi.CreateTime.ToString(); ((Label)GetControltByMaster("labTaskTitle")).Text = tsi.TaskTitle; ((Label)GetControltByMaster("labRemark")).Text = tsi.Remark; //初始化StoreInQualified信息 StorageIn siq = db.StorageIn.SingleOrDefault(s => s.StorageInID == _storageinid); if (siq == null) { Response.Redirect(_errorpage); return; } this.spgviewAuditControl.DataSource = from a in db.StorageInQualified join b in db.StorageIn on a.StorageInID equals b.StorageInID join c in db.MaterialInfo on a.MaterialID equals c.MaterialID join d in db.PileInfo on a.PileID equals d.PileID join e in db.SupplierInfo on a.SupplierID equals e.SupplierID where a.StorageInID == this._storageinid && a.BatchIndex == _batchname select new { a.StorageInQualifiedID, b.StorageInQualifiedNum, b.StorageInCode, c.MaterialName, c.MaterialCode, c.MaterialID, a.SpecificationModel, a.Quantity, a.QuantityGentaojian, a.QuantityMetre, a.QuantityTon, a.CurUnit, a.InspectionTime, a.InspectionReportNum, a.UnitPrice, a.Amount, d.StorageInfo.StorageName, d.PileCode, a.financeCode, a.StorageTime, a.BatchIndex, e.SupplierName, MaterialsManager = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.MaterialsManager).EmpName, WarehouseWorker = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.WarehouseWorker).EmpName, a.Remark, e.SupplierID, MaterialsManagerID = a.MaterialsManager, WarehouseWorkerID = a.WarehouseWorker, }; this.spgviewAuditControl.DataBind(); this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 1].Visible = false; this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 2].Visible = false; this.spgviewAuditControl.Columns[this.spgviewAuditControl.Columns.Count - 3].Visible = false; } }
public void btnSave_Click(object sender, EventArgs e) { try { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //判断所选质检批次是否在待质检表中 var tmp = from a in db.StorageInDetailed where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == batchStr select new { a.StorageDetailedID }; if (tmp.ToArray().Length == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('无此待质检批次,请重新选择 ')</script>"); return; } //判断任务列表中是否已发过此条任务 var task = from a in db.TaskStorageIn where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.QCBatch == batchStr && a.TaskType == currentFlow select new { a.TaskCreaterID, a.InspectState }; if (task.ToArray().Length != 0) { //如果是驳回的信息允许再次发送 ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复发送相同任务 ')</script>"); return; } //修改完成状态 if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"])) { TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"])); if (ts != null) { ts.TaskState = "已完成"; } } //生成质检完成流水号 if (Request.QueryString["state"].ToString() == "材料会计审核") { StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"])); si.StorageInQualifiedNum = this.txtMessageCode.Text.Trim(); } //发送新任务 TaskStorageIn TSI = new TaskStorageIn(); TSI.TaskCreaterID = reEmpId(this.lblCreator.Text.Trim()); TSI.TaskTargetID = reEmpId(this.txtRecipient.Text.Trim()); if (TSI.TaskTargetID == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户,请同步AD账户 ')</script>"); return; } TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); TSI.StorageInType = "正常入库"; TSI.TaskTitle = this.txtTaskTitle.Text.Trim(); TSI.TaskState = "未完成"; TSI.TaskDispose = "未废弃"; TSI.TaskType = Request.QueryString["state"].ToString(); TSI.InspectState = "未审核"; //TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString(); TSI.QCBatch = batchStr; TSI.Remark = this.txtRemark.Text.Trim(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); TSI.CreateTime = SevTime.First(); db.TaskStorageIn.InsertOnSubmit(TSI); db.SubmitChanges(); Response.Redirect("../../default-old.aspx", 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)); } }
/// <summary> /// 发回重新质检 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnReCheck_Click(object sender, EventArgs e) { try { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //从审核表中删除此批次记录,之前写过库 var siaTemp = from a in db.StorageInAudited where a.StorageInID == _storageinid && a.BatchIndex == _batchname select new { a.StorageInAuditedID }; for (int i = 0; i < siaTemp.ToList().Count; i++) { StorageInAudited sia = db.StorageInAudited.SingleOrDefault(a => a.StorageInAuditedID == siaTemp.ToList()[i].StorageInAuditedID); if (sia != null) { db.StorageInAudited.DeleteOnSubmit(sia); } } db.SubmitChanges(); //任务信息 TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid); tsi.TaskState = "已完成"; tsi.InspectState = "已审核"; StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID); //发送新任务(回退任务) TaskStorageIn TSI = new TaskStorageIn(); TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); TSI.TaskTargetID = tsi.TaskCreaterID; if (TSI.TaskTargetID == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户,请同步AD账户 ')</script>"); return; } TSI.StorageInID = _storageinid; TSI.StorageInType = "正常入库"; TSI.TaskTitle = "材料会计审核任务:" + tsi.TaskTitle.ToString() + "(未通过)"; TSI.TaskState = "未完成"; TSI.TaskDispose = "未废弃"; TSI.TaskType = "质检"; TSI.InspectState = "驳回"; //TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString(); TSI.QCBatch = tsi.QCBatch; TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资审核不合格原因:" + this.txtOpinion.Text.Trim(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); TSI.CreateTime = SevTime.First(); db.TaskStorageIn.InsertOnSubmit(TSI); db.SubmitChanges(); Response.Redirect("../../default-old.aspx", 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)); } }
public void btnSave_Click(object sender, EventArgs e) { try { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //用户IE回退操作检验 TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.StorageInID == _storageinid && u.QCBatch == _batchname && u.TaskType == "主任审核" && u.InspectState == "未审核"); if (tsi != null) { Response.Redirect("../../default-old.aspx", false); return; } //修改完成状态 if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"])) { TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid); ts.TaskState = "已完成"; ts.InspectState = "已审核"; } //审核完在主表StorageIn中填入入库类型 StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == _storageinid); si.ReceivingType = Convert.ToInt32(ddlReceivingType.SelectedValue); int iDirector = reEmpId(txtDirector.Text.Trim()); if (iDirector == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户,请同步AD账户 ')</script>"); return; } //在StorageInAudited表中填入审批主任 var Auditeds = from a in db.StorageInAudited where a.StorageInID == _storageinid select a; foreach (StorageInAudited audited in Auditeds) { audited.Director = iDirector; } //检查当前登录用户是否有代理任务 oldDor = iDirector; iDirector = Proxy.send(iDirector, 1); //发送新任务 TaskStorageIn TSI = new TaskStorageIn(); TSI.TaskCreaterID = reEmpId(((Label)this.GetControltByMaster("lblCreator")).Text.Trim()); TSI.TaskTargetID = iDirector; TSI.StorageInID = _storageinid; TSI.StorageInType = "正常入库"; TSI.TaskTitle = ((TextBox)this.GetControltByMaster("txtTaskTitle")).Text.Trim(); TSI.TaskState = "未完成"; TSI.TaskDispose = "未废弃"; TSI.TaskType = "主任审核"; //ProxyDirector pd = new ProxyDirector(); //TaskProxy TP = db.TaskProxy.SingleOrDefault(u => u.TaskProxyType.TaskProxyTypeName == "正常入库" && u.ProxyPrincipal == TSI.TaskTargetID); //if (TSI.TaskType == "主任审核") //{ // if (TP != null) // { // pd.TaskProxy.ProxyPrincipal = TP.ProxyPrincipal; // pd.TaskID = TSI.TaskStorageID; // pd.TaskProxyID = TP.TaskProxyID; // pd.TaskProxy.ProxyFiduciary = TP.ProxyFiduciary; // TSI.TaskTargetID = TP.ProxyFiduciary; // TSI.TaskTitle = TP.EmpInfo.EmpName + "主任委托入库审批任务:" + TSI.TaskTitle; // db.ProxyDirector.InsertOnSubmit(pd); // } //} TSI.InspectState = "未审核"; TSI.Remark = ((TextBox)this.GetControltByMaster("txtRemark")).Text.Trim(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); TSI.CreateTime = SevTime.First(); TSI.QCBatch = _batchname; db.TaskStorageIn.InsertOnSubmit(TSI); db.SubmitChanges(); //保存代理任务信息 Proxy.saveTask(TSI.TaskStorageID, Proxy.getProxyTaskId(oldDor, 1)); Response.Redirect("../../default-old.aspx", false); //pd.TaskID = TSI.TaskStorageID; //db.SubmitChanges(); } } 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)); } }
/// <summary> /// 绑定Gridview /// </summary> private void BindGridView() { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { string strTaskID = this.Request.QueryString["TaskStorageID"]; TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(a => a.TaskStorageID == int.Parse(strTaskID)); if (tsi == null) { Response.Redirect(strUrl); } Label labTaskCreater = (Label)GetControltByMaster("labTaskCreater"); labTaskCreater.Text = tsi.EmpInfo.EmpName + "[" + tsi.EmpInfo.Account + "]"; ((Label)GetControltByMaster("labCreateTime")).Text = tsi.CreateTime.ToString(); ((Label)GetControltByMaster("labTaskTitle")).Text = tsi.TaskTitle; ((Label)GetControltByMaster("labRemark")).Text = tsi.Remark; string strID = this.Request.QueryString["StorageInID"]; StorageIn si = db.StorageIn.SingleOrDefault(a => a.StorageInID == int.Parse(strID)); if (si == null) { Response.Redirect(strUrl); } BoundField bf = new BoundField(); BoundField bfColumn; TemplateField GentaojianTextBox = new TemplateField(); GentaojianTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtGentaojian"); GentaojianTextBox.HeaderTemplate = new MulTextBoxTemplate("根/套/件", DataControlRowType.Header); GentaojianTextBox.ItemStyle.Width = 150; TemplateField MetreTextBox = new TemplateField(); MetreTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtMetre"); MetreTextBox.HeaderTemplate = new MulTextBoxTemplate("米", DataControlRowType.Header); MetreTextBox.ItemStyle.Width = 150; TemplateField TonTextBox = new TemplateField(); TonTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtTon"); TonTextBox.HeaderTemplate = new MulTextBoxTemplate("吨", DataControlRowType.Header); TonTextBox.ItemStyle.Width = 150; //TemplateField tfieldTextBox = new TemplateField(); //tfieldTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtCount"); //tfieldTextBox.HeaderTemplate = new MulTextBoxTemplate("合格数量", DataControlRowType.Header); //tfieldTextBox.ItemStyle.Width = 150; TemplateField reportTextBox = new TemplateField(); reportTextBox.ItemTemplate = new MulTextBoxTemplate("请选择", DataControlRowType.DataRow, "", "StorageDetailedID", "txtQualityNum"); reportTextBox.HeaderTemplate = new MulTextBoxTemplate("质检报告号", DataControlRowType.Header); reportTextBox.ItemStyle.Width = 150; foreach (var kvp in Tlist) { bfColumn = new BoundField(); bfColumn.HeaderText = kvp.Split(':')[0]; bfColumn.DataField = kvp.Split(':')[1]; this.spgviewQualityControl.Columns.Add(bfColumn); } this.spgviewQualityControl.Columns.Insert(10, GentaojianTextBox); this.spgviewQualityControl.Columns.Insert(11, MetreTextBox); this.spgviewQualityControl.Columns.Insert(12, TonTextBox); //this.spgviewQualityControl.Columns.Insert(13, tfieldTextBox); this.spgviewQualityControl.Columns.Insert(13, reportTextBox); this.spgviewQualityControl.DataSource = from a in db.StorageInDetailed join b in db.StorageIn on a.StorageInID equals b.StorageInID join c in db.MaterialInfo on a.MaterialID equals c.MaterialID join d in db.PileInfo on a.PileID equals d.PileID join e in db.SupplierInfo on a.SupplierID equals e.SupplierID where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == batchidx select new { a.StorageDetailedID, b.StorageInCode, a.SpecificationModel, a.BatchIndex, c.MaterialName, c.MaterialCode, c.MaterialID, a.Quantity, a.UnitPrice, a.Amount, d.StorageInfo.StorageName, d.PileCode, a.financeCode, a.StorageTime, e.SupplierName, a.QuantityGentaojian, a.QuantityMetre, a.QuantityTon, a.CurUnit, MaterialsManager = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.MaterialsManager).EmpName, WarehouseWorker = db.EmpInfo.SingleOrDefault(u => u.EmpID == a.WarehouseWorker).EmpName, a.Remark, e.SupplierID }; this.spgviewQualityControl.DataBind(); this.spgviewQualityControl.Columns[0].Visible = false; this.spgviewQualityControl.Columns[this.spgviewQualityControl.Columns.Count - 1].Visible = false; p1 = (Panel)GetControltByMaster("Panel1"); p1.Controls.Add(this.spgviewQualityControl); } } 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_QUERYERROR)); } }
void btnEdit_Click(object sender, EventArgs e) { try { //检查输入格式 if (CheckStringEmpty() != true) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将数据填写完整,且合格数量只能是数字 ')</script>"); return; } //检查输入数据是否溢出 if (CheckOverFlow() != true) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('合格数量不能超过质检前数量! ')</script>"); return; } using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { var task = from a in db.TaskStorageIn where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.QCBatch == batchidx && a.TaskType == "质检" && a.InspectState == "驳回" && a.TaskState == "未完成" select new { a.TaskCreaterID, a.InspectState }; //如果是回退到质检的调拨单 if (task.ToList().Count > 0) { //更新 var tep = from a in db.StorageInQualified where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString()) && a.BatchIndex == batchidx orderby a.StorageInQualifiedID ascending select new { a.StorageInQualifiedID }; var li = tep.ToList(); for (int i = 0; i < this.spgviewQualityControl.Rows.Count; i++) { StorageInQualified SIQ = new StorageInQualified(); SIQ = db.StorageInQualified.SingleOrDefault(u => u.StorageInQualifiedID == li[i].StorageInQualifiedID); TextBox gentaojian = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[10].Controls[0]); SIQ.QuantityGentaojian = Convert.ToDecimal(gentaojian.Text.Trim()); TextBox metre = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[11].Controls[0]); SIQ.QuantityMetre = Convert.ToDecimal(metre.Text.Trim()); TextBox ton = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[12].Controls[0]); SIQ.QuantityTon = Convert.ToDecimal(ton.Text.Trim()); TextBox ti = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[13].Controls[0]); SIQ.InspectionReportNum = ti.Text.Trim(); db.SubmitChanges(); //DataTable dt = new DataTable(); //dt.Columns.Add("UserID", typeof(int)); //dt.Columns.Add("userName", typeof(string)); //dt.Columns.Add("Gender", typeof(bool)); //var temp = from u in dt.AsEnumerable() // where u.Field<bool>("Gender") == true // select u; } //旧任务 TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"])); tsi.TaskState = "已完成"; tsi.InspectState = "已审核"; StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID); //新任务 TaskStorageIn TSI = new TaskStorageIn(); TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); TSI.TaskTargetID = tsi.TaskCreaterID; if (TSI.TaskTargetID == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户,请同步AD账户 ')</script>"); return; } TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); TSI.StorageInType = "正常入库"; TSI.TaskTitle = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资已质检,请重新审核"; TSI.TaskState = "未完成"; TSI.TaskDispose = "未废弃"; TSI.TaskType = "材料会计审核"; TSI.InspectState = "未审核"; TSI.QCBatch = tsi.QCBatch; TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资已重新质检"; var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); TSI.CreateTime = SevTime.First(); db.TaskStorageIn.InsertOnSubmit(TSI); db.SubmitChanges(); Response.Redirect("../../default-old.aspx", false); } else { //更新数据 var tep = from a in db.StorageInQualified where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString()) && a.BatchIndex == batchidx orderby a.StorageInQualifiedID ascending select new { a.StorageInQualifiedID }; var li = tep.ToList(); for (int i = 0; i < this.spgviewQualityControl.Rows.Count; i++) { StorageInQualified SIQ = new StorageInQualified(); SIQ = db.StorageInQualified.SingleOrDefault(u => u.StorageInQualifiedID == li[i].StorageInQualifiedID); TextBox gentaojian = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[10].Controls[0]); SIQ.QuantityGentaojian = Convert.ToDecimal(gentaojian.Text.Trim()); TextBox metre = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[11].Controls[0]); SIQ.QuantityMetre = Convert.ToDecimal(metre.Text.Trim()); TextBox ton = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[12].Controls[0]); SIQ.QuantityTon = Convert.ToDecimal(ton.Text.Trim()); TextBox ti = (TextBox)(this.spgviewQualityControl.Rows[i].Cells[13].Controls[0]); SIQ.InspectionReportNum = ti.Text.Trim(); db.SubmitChanges(); } Response.Redirect("QualifiedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&QCBatch=" + batchidx + " "); } } } 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 btnSend_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { var tp = from a in db.StorageInDirector where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == Request.QueryString["QCBatch"].ToString() select a; if (tp.ToArray().Length > 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不能重复插入记录!')</script>"); return; } } if (chbAgree.Checked == true) { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { for (int i = 0; i < this.gv.Rows.Count; i++) { //写入流程中的主任审核表 StorageInDirector sid = new StorageInDirector(); sid.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); MaterialInfo mi = db.MaterialInfo.SingleOrDefault(u => u.MaterialID == Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 2].Text.ToString())); sid.MaterialID = mi.MaterialID; sid.SpecificationModel = this.gv.Rows[i].Cells[3].Text.ToString(); sid.BatchIndex = this.gv.Rows[i].Cells[20].Text.ToString(); sid.QuantityGentaojian = Convert.ToDecimal(this.gv.Rows[i].Cells[4].Text.ToString()); sid.QuantityMetre = Convert.ToDecimal(this.gv.Rows[i].Cells[5].Text.ToString()); sid.QuantityTon = Convert.ToDecimal(this.gv.Rows[i].Cells[6].Text.ToString()); sid.Quantity = Convert.ToDecimal(this.gv.Rows[i].Cells[7].Text.ToString()); sid.CurUnit = this.gv.Rows[i].Cells[8].Text.ToString(); sid.NumberQualified = 0; sid.InspectionReportNum = this.gv.Rows[i].Cells[11].Text.ToString(); sid.InspectionTime = Convert.ToDateTime(this.gv.Rows[i].Cells[12].Text.ToString()); sid.UnitPrice = Convert.ToDecimal(this.gv.Rows[i].Cells[9].Text.ToString()); sid.Amount = Convert.ToDecimal(this.gv.Rows[i].Cells[10].Text.ToString()); PileInfo pi = db.PileInfo.SingleOrDefault(u => u.PileCode == this.gv.Rows[i].Cells[14].Text.ToString()); sid.PileID = pi.PileID; sid.financeCode = this.gv.Rows[i].Cells[15].Text.ToString(); sid.StorageTime = Convert.ToDateTime(this.gv.Rows[i].Cells[16].Text.ToString()); //这里不唯一要出问题。 sid.SupplierID = Convert.ToInt32(this.gv.Rows[i].Cells[25].Text.ToString()); var temp = from a in db.StorageInAudited where a.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"]) && a.BatchIndex == Request.QueryString["QCBatch"].ToString() select new { a.MaterialsManager, a.WarehouseWorker, a.MaterialAccounting }; var list = temp.ToList(); sid.MaterialsManager = list[i].MaterialsManager; sid.WarehouseWorker = list[i].WarehouseWorker; sid.MaterialAccounting = list[i].MaterialAccounting; sid.AuditStatus = this.gv.Rows[i].Cells[21].Text.ToString(); sid.AuditTime = Convert.ToDateTime(this.gv.Rows[i].Cells[22].Text.ToString()); sid.DirectorStatus = "已审批"; var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); sid.DirectorTime = SevTime.First(); sid.Remark = this.gv.Rows[i].Cells[24].Text.ToString(); sid.BatchIndex = this.gv.Rows[i].Cells[23].Text.ToString(); sid.Director = reEmpId(SPContext.Current.Web.CurrentUser.LoginName.ToString()); db.StorageInDirector.InsertOnSubmit(sid); //写入库存表 TableOfStocks tos = new TableOfStocks(); tos.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); tos.StorageInType = "正常入库"; tos.MaterialID = mi.MaterialID; tos.SpecificationModel = this.gv.Rows[i].Cells[3].Text.ToString(); tos.QuantityGentaojian = Convert.ToDecimal(this.gv.Rows[i].Cells[4].Text.ToString()); tos.QuantityMetre = Convert.ToDecimal(this.gv.Rows[i].Cells[5].Text.ToString()); tos.QuantityTon = Convert.ToDecimal(this.gv.Rows[i].Cells[6].Text.ToString()); tos.Quantity = Convert.ToDecimal(this.gv.Rows[i].Cells[7].Text.ToString()); tos.CurUnit = this.gv.Rows[i].Cells[8].Text.ToString(); tos.UnitPrice = Convert.ToDecimal(this.gv.Rows[i].Cells[9].Text.ToString()); tos.NumberQualified = 0; tos.PileID = pi.PileID; tos.financeCode = sid.financeCode; tos.StorageTime = sid.StorageTime; tos.SupplierID = sid.SupplierID; tos.MaterialsManager = list[i].MaterialsManager; tos.WarehouseWorker = list[i].WarehouseWorker; tos.OnlineState = "线下"; sid.Remark = sid.Remark; db.TableOfStocks.InsertOnSubmit(tos); db.SubmitChanges(); } //修改完成状态 if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"])) { TaskStorageIn ts = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"])); if (ts != null) { ts.TaskState = "已完成"; ts.InspectState = "已审核"; //修改代理任务完成状态 //ProxyDirector pd = db.ProxyDirector.SingleOrDefault(u => u.TaskID == Convert.ToInt32(Request.QueryString["TaskStorageID"]) && u.TaskProxy.TaskProxyType.TaskProxyTypeName == "正常入库"); //if (pd != null) //{ // TaskProxy tp = db.TaskProxy.SingleOrDefault(u => u.TaskProxyType.TaskProxyTypeName == "正常入库" && u.ProxyPrincipal == pd.TaskProxy.ProxyPrincipal && u.TaskDispose == "未完成"); // tp.TaskDispose = "完成"; //} } db.SubmitChanges(); } } Response.Redirect("StorageInDirectorPass.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&QCBatch=" + Request.QueryString["QCBatch"] + " "); } else { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //任务信息 TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == Convert.ToInt32(Request.QueryString["TaskStorageID"])); tsi.TaskState = "已完成"; tsi.InspectState = "已审核"; StorageIn si = db.StorageIn.SingleOrDefault(u => u.StorageInID == tsi.StorageInID); //发送新任务(回退任务) TaskStorageIn TSI = new TaskStorageIn(); TSI.TaskCreaterID = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); TSI.TaskTargetID = tsi.TaskCreaterID; if (TSI.TaskTargetID == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('不存在质检用户,请同步AD账户 ')</script>"); return; } TSI.StorageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); TSI.StorageInType = "正常入库"; TSI.TaskTitle = "主任审批任务:" + tsi.TaskTitle.ToString() + "(未通过)"; TSI.TaskState = "未完成"; TSI.TaskDispose = "未废弃"; TSI.TaskType = "材料会计审核"; TSI.InspectState = "驳回"; //TSI.BatchOfIndex = this.ddlbatch.SelectedItem.Text.ToString(); TSI.QCBatch = tsi.QCBatch; TSI.Remark = "交货通知单编号为:" + si.StorageInCode + "的" + tsi.QCBatch.ToString() + "物资审批不合格原因:" + this.txtOpinion.Text.Trim(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); TSI.CreateTime = SevTime.First(); db.TaskStorageIn.InsertOnSubmit(TSI); db.SubmitChanges(); } Response.Redirect("../../default-old.aspx", 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)); } //Response.Redirect("QualityControlMessage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&state=材料会计审核"); }