private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头 SrinRepairPlan srp = db.SrinRepairPlan.SingleOrDefault(u => u.SrinRepairPlanID == _formid); ((Label)GetControltByMaster("lblMaterial")).Text = srp.EmpInfo.EmpName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(srp.CreateTime.ToLongDateString(), srp.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblCode")).Text = srp.SrinRepairPlanCode; spgvMaterial.DataSource = from a in db.SrinMaterialRepairDetails where a.SrinRepairPlanID == _formid select new { a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName, a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel, a.Manufacturer.ManufacturerName, a.ArrivalTime, a.Gentaojian, a.RepairReason, a.PlanTime, a.RealGentaojian, a.RealTime, a.Remark, a.SrinMaterialRepairDetailsID }; spgvMaterial.DataBind(); } }
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)) { //初始化表头 SrinRepairPlan srp = db.SrinRepairPlan.SingleOrDefault(u => u.SrinRepairPlanID == _formid); ((Label)GetControltByMaster("lblMaterial")).Text = srp.EmpInfo.EmpName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(srp.CreateTime.ToLongDateString(), srp.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblCode")).Text = srp.SrinRepairPlanCode; spgvMaterial.DataSource = from a in db.SrinMaterialRepairDetails where a.SrinRepairPlanID == _formid select new { a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName, a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel, a.Manufacturer.ManufacturerName, a.ArrivalTime, a.Gentaojian, a.RepairReason, a.PlanTime, a.RealGentaojian, a.RealTime, a.Remark }; spgvMaterial.DataBind(); if (smra != null)//已经审核的情况 { if (!Page.IsPostBack) { if (smra.AuditResult.Equals("未通过")) { txtOpinion.Text = smra.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)) { //初始化表头 SrinRepairPlan srp = db.SrinRepairPlan.SingleOrDefault(u => u.SrinRepairPlanID == _formid); ((Label)GetControltByMaster("lblMaterial")).Text = srp.EmpInfo.EmpName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(srp.CreateTime.ToLongDateString(), srp.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblCode")).Text = srp.SrinRepairPlanCode; spgvMaterial.DataSource = from a in db.SrinMaterialRepairDetails where a.SrinRepairPlanID == _formid select new { a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName, a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel, a.ManufactureID, a.ArrivalTime, RetrieveInQuantity = a.SrinDetails.SrinStocktakingDetails.SrinSubDetails.TotleGentaojian, a.Gentaojian, a.RepairReason, a.PlanTime, a.RealGentaojian, a.RealTime, a.Remark, a.SrinMaterialRepairDetailsID }; spgvMaterial.DataBind(); //初始化审核信息 SrinMaterialRepairAudit smra = db.SrinMaterialRepairAudit.SingleOrDefault(u => u.TaskID == _pretaskid); ((Label)GetControltByMaster("lblMChief")).Text = smra.EmpInfo.EmpName; ((Label)GetControltByMaster("lblAuditDate")).Text = string.Concat(smra.AuditTime.ToLongDateString(), smra.AuditTime.ToLongTimeString()); ((Label)GetControltByMaster("lblResult")).Text = smra.AuditResult; ((TextBox)GetControltByMaster("txtOpinion")).Text = smra.AuditOpinion; } }
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)); } }