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;
}
}
