private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid); txtNoticeCode.Text = scon.StorageCommitOutNoticeCode; txtRemark.Text = scon.Remark; ddlReceiver.SelectedValue = scon.Receiver.ToString(); dtcCreateTime.SelectedDate = scon.CreateTime; btnSave.Text = "修改"; } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid); ((Label)GetControltByMaster("lblReceiver")).Text = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitID == scon.Receiver).BusinessUnitName; ((Label)GetControltByMaster("lblNoticeCode")).Text = scon.StorageCommitOutNoticeCode; ((Label)GetControltByMaster("lblDate")).Text = scon.CreateTime.ToLongDateString(); //初始化审核列表 this.spgvMaterial.DataSource = from a in db.StorageCommitOutDetails where a.StorageCommitOutNoticeID == _noticeid select new { a.MaterialInfo.FinanceCode, a.MaterialInfo.MaterialName, a.MaterialInfo.SpecificationModel, a.Gentaojian, a.Metre, a.Ton, StocksGenTaojian = (from c in db.StorageStocks where c.MaterialID == a.MaterialID select c).Sum(u => u.StocksGenTaojian), StocksMetre = (from c in db.StorageStocks where c.MaterialID == a.MaterialID select c).Sum(u => u.StocksMetre), StocksTon = (from c in db.StorageStocks where c.MaterialID == a.MaterialID select c).Sum(u => u.StocksTon), a.Remark }; this.spgvMaterial.DataBind(); //分支流程--已经审核的情况 if (this.scopa != null) { if (!Page.IsPostBack) { if (scopa.AuditStatus.Equals("未通过")) { txtOpinion.Text = scopa.AuditOpinion; txtOpinion.Enabled = true; chbAgree.AutoPostBack = false; chbAgree.Checked = false; chbAgree.AutoPostBack = true; } } } } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid); ((Label)GetControltByMaster("lblReceiver")).Text = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitID == scon.Receiver).BusinessUnitName; ((Label)GetControltByMaster("lblNoticeCode")).Text = scon.StorageCommitOutNoticeCode; ((Label)GetControltByMaster("lblDate")).Text = scon.CreateTime.ToLongDateString(); //初始化审核列表 this.spgvMaterial.DataSource = from a in db.StorageCommitOutRealDetails where a.StorageCommitOutNoticeID == _noticeid select new { //a.StorageCommitOutDetails.FinanceCode, //a.StorageCommitOutDetails.TableOfStocks.MaterialCode, //a.StorageCommitOutDetails.TableOfStocks.MaterialInfo.MaterialName, //a.StorageCommitOutDetails.TableOfStocks.MaterialInfo.SpecificationModel, //a.StorageCommitOutDetails.TableOfStocks.SupplierInfo.SupplierName, //a.StorageCommitOutDetails.TableOfStocks.PileInfo.StorageInfo.StorageName, //a.StorageCommitOutDetails.TableOfStocks.PileInfo.PileName, //a.StorageCommitOutDetails.TableOfStocks.StorageTime, //a.RealGentaojian, //a.RealMetre, //a.RealTon, //a.RealAmount, //a.StorageCommitOutDetails.TableOfStocks.UnitPrice }; this.spgvMaterial.DataBind(); //初始化主任审批信息 StorageCommitOutRemove scor = db.StorageCommitOutRemove.SingleOrDefault(u => u.StorageCommitOutRemoveID == this._auditid); ((Label)GetControltByMaster("lblDirectorOpinion")).Text = scor.DirectorOpinion; ((Label)GetControltByMaster("lblDirectorResult")).Text = scor.DirectorAuditStatus; ((Label)GetControltByMaster("lblDirector")).Text = scor.EmpInfo.EmpName; //初始化物资组长审核信息 ((Label)GetControltByMaster("lblMaterialOpinion")).Text = scor.StorageCommitOutMaterialAudit.MaterialAuditOpinion; ((Label)GetControltByMaster("lblMaterialResult")).Text = scor.StorageCommitOutMaterialAudit.MaterialAuditStatus; ((Label)GetControltByMaster("lblMaterialChief")).Text = scor.StorageCommitOutMaterialAudit.EmpInfo.EmpName; //初始化生产组长审核信息 ((Label)GetControltByMaster("lblProduceOpinion")).Text = scor.StorageCommitOutProducingAudit.AuditOpinion; ((Label)GetControltByMaster("lblProduceResult")).Text = scor.StorageCommitOutProducingAudit.AuditStatus; ((Label)GetControltByMaster("lblProduceChief")).Text = scor.StorageCommitOutProducingAudit.EmpInfo.EmpName; } }
void btnSave_Click(object sender, EventArgs e) { try { if (Page.IsValid) { if (this.ddlReceiver.SelectedIndex == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择领料单位! ');</script>"); return; } using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageCommitOutNotice scon; if (this._noticeid == 0) //主流程--新建的情况 { scon = new StorageCommitOutNotice(); scon.Creator = this._userid; scon.CreateTime = dtcCreateTime.SelectedDate; scon.Receiver = Convert.ToInt32(ddlReceiver.SelectedValue); scon.Remark = ((TextBox)GetControltByMaster("txtRemark")).Text.Trim(); scon.StorageCommitOutNoticeCode = ((TextBox)GetControltByMaster("txtNoticeCode")).Text.Trim(); db.StorageCommitOutNotice.InsertOnSubmit(scon); } else { scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid); scon.CreateTime = ((DateTimeControl)GetControltByMaster("dtcCreateTime")).SelectedDate; scon.Receiver = Convert.ToInt32(ddlReceiver.SelectedValue); scon.Remark = txtRemark.Text.Trim(); scon.StorageCommitOutNoticeCode = txtNoticeCode.Text.Trim(); } db.SubmitChanges(); } Response.Redirect("ManageCommitOutNotice.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)); } }
void vldNoticeCode_ServerValidate(object source, ServerValidateEventArgs args) { try { if (btnSave.Text.Equals("创建")) { string strNoticeCode = this.txtNoticeCode.Text.Trim(); //NoticeID为空的情况 if (string.IsNullOrEmpty(strNoticeCode)) { args.IsValid = false; vldNoticeCode.Text = "调拨通知单号不能为空!"; return; } //数据库中存在相同NoticeCode的情况 using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeCode == strNoticeCode); if (scon != null) { args.IsValid = false; vldNoticeCode.Text = "调拨通知单号已存在!"; return; } } args.IsValid = true; } } 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)); } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid); ((Label)GetControltByMaster("lblReceiver")).Text = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitID == scon.Receiver).BusinessUnitName; ((Label)GetControltByMaster("lblNoticeCode")).Text = scon.StorageCommitOutNoticeCode; ((Label)GetControltByMaster("lblDate")).Text = scon.CreateTime.ToLongDateString(); //初始化物资出库明细列表 this.spgvMaterial.DataSource = from a in db.StorageCommitOutRealDetails join b in db.StorageStocks on new { a.StocksID, Status = a.MaterialStatus } equals new { b.StocksID, b.Status } where a.StorageCommitOutNoticeID == _noticeid orderby b.MaterialID, b.StorageTime ascending let v1 = (from e in db.StorageCommitOutRealDetails.AsEnumerable() where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID select new { e.RealGentaojian }).Sum(u => u.RealGentaojian) let v2 = (from e in db.StorageCommitOutRealDetails.AsEnumerable() where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID select new { e.RealMetre }).Sum(u => u.RealMetre) let v3 = (from e in db.StorageCommitOutRealDetails.AsEnumerable() where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID select new { e.RealTon }).Sum(u => u.RealTon) select new { MaterialName = string.Format("{0}--规格型号:{1}", b.MaterialName, b.SpecificationModel), b.MaterialCode, b.ManufacturerName, b.StorageName, b.PileName, b.BatchIndex, a.MaterialStatus, b.StorageTime, StocksGenTaojian = b.StocksGenTaojian + a.RealGentaojian, StocksMetre = b.StocksMetre + a.RealMetre, StocksTon = b.StocksTon + a.RealTon, a.RealGentaojian, a.RealMetre, a.RealTon, b.UnitPrice, a.RealAmount, a.Remark, Description = string.Format("财务编码:{0}--根台套件/米/吨(总库存):{1}/{2}/{3}--根台套件/米/吨(调拨):{4}/{5}/{6}", b.FinanceCode, (from c in db.StorageStocks where c.MaterialID == b.MaterialID select c).Sum(u => u.StocksGenTaojian) + v1, (from c in db.StorageStocks where c.MaterialID == b.MaterialID select c).Sum(u => u.StocksMetre) + v2, (from c in db.StorageStocks where c.MaterialID == b.MaterialID select c).Sum(u => u.StocksTon) + v3, a.StorageCommitOutDetails.Gentaojian, a.StorageCommitOutDetails.Metre, a.StorageCommitOutDetails.Ton) }; this.spgvMaterial.DataBind(); //分支流程--已经审核的情况 scoaa = db.StorageCommitOutAssetAudit.SingleOrDefault(u => u.TaskID.Equals(_taskid)); if (scoaa != null) { btnOK.Text = "修改审核表单"; if (!Page.IsPostBack) { if (scoaa.AuditStatus.Equals("未通过")) { txtOpinion.Text = scoaa.AuditOpinion; txtOpinion.Enabled = true; chbAgree.AutoPostBack = false; chbAgree.Checked = false; chbAgree.AutoPostBack = true; } } } //初始化生产组审核信息 StorageCommitOutProduceAudit scopa = db.StorageCommitOutProduceAudit.SingleOrDefault(u => u.TaskID == GetPreviousTaskID("物资调拨审核", _taskid)); (GetControltByMaster("lblOpinion") as Label).Text = scopa.AuditOpinion; (GetControltByMaster("lblResult") as Label).Text = scopa.AuditStatus; (GetControltByMaster("lblProduceChief") as Label).Text = scopa.EmpInfo.EmpName; (GetControltByMaster("lblProduceTime") as Label).Text = string.Concat(scopa.AuditTime.ToLongDateString(), scopa.AuditTime.ToLongTimeString()); _pauditid = scopa.StorageCommitOutProduceAuditID; } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 StorageCommitOutNotice scon = db.StorageCommitOutNotice.SingleOrDefault(u => u.StorageCommitOutNoticeID == this._noticeid); ((Label)GetControltByMaster("lblReceiver")).Text = db.BusinessUnitInfo.SingleOrDefault(u => u.BusinessUnitID == scon.Receiver).BusinessUnitName; (GetControltByMaster("lblNoticeCode") as Label).Text = scon.StorageCommitOutNoticeCode; ((Label)GetControltByMaster("lblDate")).Text = scon.CreateTime.ToLongDateString(); //初始化出库物资明细 this.spgvMaterial.DataSource = from a in db.StorageCommitOutRealDetails join b in db.StorageStocks on new { a.StocksID, Status = a.MaterialStatus } equals new { b.StocksID, b.Status } where a.StorageCommitOutNoticeID == _noticeid orderby b.MaterialID, b.StorageTime ascending let v1 = (from e in db.StorageCommitOutRealDetails.AsEnumerable() where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID select new { e.RealGentaojian }).Sum(u => u.RealGentaojian) let v2 = (from e in db.StorageCommitOutRealDetails.AsEnumerable() where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID select new { e.RealMetre }).Sum(u => u.RealMetre) let v3 = (from e in db.StorageCommitOutRealDetails.AsEnumerable() where e.StorageCommitOutNoticeID == _noticeid && e.StorageCommitOutDetails.MaterialID == b.MaterialID select new { e.RealTon }).Sum(u => u.RealTon) select new { MaterialName = string.Format("{0}--规格型号:{1}", b.MaterialName, b.SpecificationModel), b.MaterialCode, b.ManufacturerName, b.StorageName, b.PileName, b.BatchIndex, a.MaterialStatus, b.StorageTime, StocksGenTaojian = b.StocksGenTaojian + a.RealGentaojian, StocksMetre = b.StocksMetre + a.RealMetre, StocksTon = b.StocksTon + a.RealTon, a.RealGentaojian, a.RealMetre, a.RealTon, b.UnitPrice, a.RealAmount, a.Remark, Description = string.Format("财务编码:{0}--根台套件/米/吨(总库存):{1}/{2}/{3}--根台套件/米/吨(调拨):{4}/{5}/{6}", b.FinanceCode, (from c in db.StorageStocks where c.MaterialID == b.MaterialID select c).Sum(u => u.StocksGenTaojian) + v1, (from c in db.StorageStocks where c.MaterialID == b.MaterialID select c).Sum(u => u.StocksMetre) + v2, (from c in db.StorageStocks where c.MaterialID == b.MaterialID select c).Sum(u => u.StocksTon) + v3, a.StorageCommitOutDetails.Gentaojian, a.StorageCommitOutDetails.Metre, a.StorageCommitOutDetails.Ton) }; this.spgvMaterial.DataBind(); ////初始化主任审批信息 StorageCommitOutDirectorConfirm scodc = db.StorageCommitOutDirectorConfirm.SingleOrDefault(u => u.TaskID.Equals(_taskid)); (GetControltByMaster("lblDirector") as Label).Text = scodc.EmpInfo.EmpName; (GetControltByMaster("lblDirectorTime") as Label).Text = string.Concat(scodc.ConfirmTime.ToLongDateString(), scodc.ConfirmTime.ToLongTimeString()); //初始化资产组长审核信息 (GetControltByMaster("lblAssetOpinion") as Label).Text = scodc.StorageCommitOutAssetAudit.AuditOpinion; (GetControltByMaster("lblAssetResult") as Label).Text = scodc.StorageCommitOutAssetAudit.AuditStatus; (GetControltByMaster("lblAssetChief") as Label).Text = scodc.StorageCommitOutAssetAudit.EmpInfo.EmpName; (GetControltByMaster("lblAssetTime") as Label).Text = string.Concat(scodc.StorageCommitOutAssetAudit.AuditTime.ToLongDateString(), scodc.StorageCommitOutAssetAudit.AuditTime.ToLongTimeString()); //初始化生产组长审核信息 (GetControltByMaster("lblProduceOpinion") as Label).Text = scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.AuditOpinion; (GetControltByMaster("lblProduceResult") as Label).Text = scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.AuditStatus; (GetControltByMaster("lblProduceChief") as Label).Text = scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.EmpInfo.EmpName; (GetControltByMaster("lblProduceTime") as Label).Text = string.Concat(scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.AuditTime.ToLongDateString(), scodc.StorageCommitOutAssetAudit.StorageCommitOutProduceAudit.AuditTime.ToLongTimeString()); } }