private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { ((Label)GetControltByMaster("lblCode")).Text = db.SrinReceipt.SingleOrDefault(u => u.SrinReceiptID == _receiptid).SrinReceiptCode; ((Label)GetControltByMaster("lblCreator")).Text = SPContext.Current.Web.CurrentUser.LoginName; dtcCreateTime.SelectedDate = DateTime.Now; if (!Page.IsPostBack && _workid != 0) { switch (_type) { case "维修保养表": SrinRepairPlan srp = db.SrinRepairPlan.SingleOrDefault(u => u.SrinRepairPlanID == _workid); txtCode.Text = srp.SrinRepairPlanCode; txtRemark.Text = srp.Remark; dtcCreateTime.SelectedDate = srp.CreateTime; break; case "回收检验表": SrinVerifyTransfer svt = db.SrinVerifyTransfer.SingleOrDefault(u => u.SrinVerifyTransferID == _workid); txtCode.Text = svt.SrinVerifyTransferCode; txtRemark.Text = svt.Remark; dtcCreateTime.SelectedDate = svt.CreateTime; chbReadWork.Checked = svt.ReadyWorkIsFinished; break; } } } }
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 btnSave_Click(object sender, EventArgs e) { try { if (Page.IsValid) { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { if (_workid == 0)//新建情况 { switch (_type) { case "维修保养表": SrinRepairPlan srp = new SrinRepairPlan(); srp.SrinRepairPlanCode = txtCode.Text.Trim(); srp.SrinReceiptID = _receiptid; srp.Remark = txtRemark.Text.Trim(); srp.CreateTime = dtcCreateTime.SelectedDate; srp.Creator = db.EmpInfo.SingleOrDefault(u => u.Account.Equals(SPContext.Current.Web.CurrentUser.LoginName)).EmpID; srp.TaskID = _taskid; db.SrinRepairPlan.InsertOnSubmit(srp); break; case "回收检验表": SrinVerifyTransfer svt = new SrinVerifyTransfer(); svt.SrinVerifyTransferCode = txtCode.Text.Trim(); svt.SrinReceiptID = _receiptid; svt.Remark = txtRemark.Text.Trim(); svt.ReadyWorkIsFinished = chbReadWork.Checked; svt.CreateTime = dtcCreateTime.SelectedDate; svt.Creator = db.EmpInfo.SingleOrDefault(u => u.Account.Equals(SPContext.Current.Web.CurrentUser.LoginName)).EmpID; svt.TaskID = _taskid; db.SrinVerifyTransfer.InsertOnSubmit(svt); break; } } else//修改情况 { switch (_type) { case "维修保养表": SrinRepairPlan srp = db.SrinRepairPlan.SingleOrDefault(u => u.SrinRepairPlanID == _workid); srp.SrinRepairPlanCode = txtCode.Text.Trim(); srp.Remark = txtRemark.Text.Trim(); srp.CreateTime = dtcCreateTime.SelectedDate; break; case "回收检验表": SrinVerifyTransfer svt = db.SrinVerifyTransfer.SingleOrDefault(u => u.SrinVerifyTransferID == _workid); svt.SrinVerifyTransferCode = txtCode.Text.Trim(); svt.Remark = txtRemark.Text.Trim(); svt.CreateTime = dtcCreateTime.SelectedDate; svt.ReadyWorkIsFinished = chbReadWork.Checked; break; } } db.SubmitChanges(); } Response.Redirect(string.Format("ManageRepairAndVerify.aspx?TaskID={0}&ReceiptID={1}", _taskid, _receiptid), 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)); } }