protected void Page_Load(object sender, EventArgs e) { try { _taskid = Convert.ToInt32(Request.QueryString["TaskID"]); using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid); _formid = tsi.StorageInID; //分支流程--任务已经完成的情况 if (tsi.TaskState.Equals("已完成")) { Response.Redirect(string.Format("RiMaterialRepairAuditMessage.aspx?TaskID={0}", _taskid), false); return; } smra = db.SrinMaterialRepairAudit.SingleOrDefault(u => u.TaskID == _taskid); } InitializeCustomControls(); BindDataToCustomControls(); ShowCustomControls(); } 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_LOADERROR)); } }
void btnOK_Click(object sender, EventArgs e) { try { //将审核结果保存到数据库 using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { if (smra == null)//主流程--未审核的情况 { smra = new SrinMaterialRepairAudit(); smra.SrinRepairPlanID = _formid; smra.AuditResult = chbAgree.Checked == true ? "通过" : "未通过"; smra.AuditOpinion = txtOpinion.Text.Trim(); smra.AuditTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); smra.MaterialChief = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID; smra.TaskID = _taskid; db.SrinMaterialRepairAudit.InsertOnSubmit(smra); db.SubmitChanges(); } else//分支流程--已经审核的情况 { smra = db.SrinMaterialRepairAudit.SingleOrDefault(u => u.TaskID == _taskid); smra.AuditOpinion = txtOpinion.Text.Trim(); smra.AuditResult = chbAgree.Checked == true ? "通过" : "未通过"; smra.AuditTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); } db.SubmitChanges(); } //转到审核表单页 Response.Redirect(string.Format("RiMaterialRepairAuditMessage.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)) { //初始化表头 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; } }