private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 SrinVerifyTransfer svt = db.SrinVerifyTransfer.SingleOrDefault(u => u.SrinVerifyTransferID.Equals(_formid)); ((Label)GetControltByMaster("lblProject")).Text = svt.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(svt.CreateTime.ToLongDateString(), svt.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblCode")).Text = svt.SrinVerifyTransferCode; //初始化回收检验物资 spgvMaterial.DataSource = from a in db.SrinMaterialVerifyDetails where a.SrinVerifyTransferID == _formid select new { a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName, a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel, a.Manufacturer.ManufacturerName, a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.TotleGentaojian, a.SrinDetails.SrinStocktakingDetails.StorageInfo.StorageName, a.SrinDetails.SrinStocktakingDetails.PileInfo.PileName, a.RetrieveTime, a.Remark, a.SrinMaterialVerifyDetailsID }; this.spgvMaterial.DataBind(); //初始化表尾 ((Label)GetControltByMaster("lblMaterial")).Text = svt.EmpInfo.EmpName; ((Label)GetControltByMaster("lblReadyWork")).Text = svt.ReadyWorkIsFinished ? "是" : "否"; if (!Page.IsPostBack) { if (bModified)//分支流程--已经生成质检清单的情况 { SrinProduceVerifyTransfer spvt = db.SrinProduceVerifyTransfer.SingleOrDefault(u => u.TaskID == _taskid); txtRemark.Text = spvt.Remark.Trim(); dtcVerifyTime.SelectedDate = spvt.VerifyTime; } else { txtRemark.Text = svt.Remark.Trim(); dtcVerifyTime.SelectedDate = DateTime.Now.Date; } } } }
void btnOK_Click(object sender, EventArgs e) { try { //将确认结果保存到数据库 using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { if (bModified)//分支流程--已经生成质检清单的情况 { SrinProduceVerifyTransfer spvt = db.SrinProduceVerifyTransfer.SingleOrDefault(u => u.TaskID == _taskid); spvt.VerifyTime = dtcVerifyTime.SelectedDate; spvt.Remark = txtRemark.Text.Trim(); spvt.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); } else { SrinProduceVerifyTransfer spvt = new SrinProduceVerifyTransfer(); spvt.SrinVerifyTransferID = _formid; spvt.VerifyTime = dtcVerifyTime.SelectedDate; spvt.Remark = txtRemark.Text.Trim(); spvt.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); spvt.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID; spvt.TaskID = _taskid; db.SrinProduceVerifyTransfer.InsertOnSubmit(spvt); } db.SubmitChanges(); } Response.Redirect(string.Format("RiProduceArrangeVerifyMessage.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)); } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 SrinProduceVerifyTransfer spvt = db.SrinProduceVerifyTransfer.SingleOrDefault(u => u.TaskID == GetPreviousTaskID(0, _taskid)); ((Label)GetControltByMaster("lblProject")).Text = spvt.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(spvt.SrinVerifyTransfer.CreateTime.ToLongDateString(), spvt.SrinVerifyTransfer.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblCode")).Text = spvt.SrinVerifyTransfer.SrinVerifyTransferCode; _transferid = spvt.SrinProduceVerifyTransferID; //初始化回收检验物资 spgvMaterial.DataSource = from a in db.SrinMaterialVerifyDetails where a.SrinVerifyTransferID == _formid select new { a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName, a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel, a.Manufacturer.ManufacturerName, a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.TotleGentaojian, a.SrinDetails.SrinStocktakingDetails.StorageInfo.StorageName, a.SrinDetails.SrinStocktakingDetails.PileInfo.PileName, a.RetrieveTime, a.Remark, a.SrinMaterialVerifyDetailsID }; this.spgvMaterial.DataBind(); //初始化表尾 ((Label)GetControltByMaster("lblMaterial")).Text = spvt.SrinVerifyTransfer.EmpInfo.EmpName; ((Label)GetControltByMaster("lblReadyWork")).Text = spvt.SrinVerifyTransfer.ReadyWorkIsFinished ? "是" : "否"; ((Label)GetControltByMaster("lblProduce")).Text = spvt.EmpInfo.EmpName; ((Label)GetControltByMaster("lblVerifyTime")).Text = spvt.VerifyTime.ToLongDateString(); txtRemark.Text = spvt.Remark; } }