private void BindDataToCustomControls()
{
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
//初始化表头信息
SrinRepairReport srrp = db.SrinRepairReport.SingleOrDefault(u => u.TaskID.Equals(_taskid));
((Label)GetControltByMaster("lblCode")).Text = srrp.SrinRepairReportCode.Trim();
((Label)GetControltByMaster("lblDate")).Text = string.Concat(srrp.CreateTime.ToLongDateString(), srrp.CreateTime.ToLongTimeString());
((Label)GetControltByMaster("lblProduce")).Text = srrp.EmpInfo.EmpName;
(GetControltByMaster("lblRemark") as Label).Text = srrp.Remark.Trim();
//初始化质检待修复物资
spgvMaterial.DataSource = from a in db.SrinInspectorVerifyDetails
where a.SrinInspectorVerifyTransferID == srrp.SrinInspectorVerifyTransferID &&
a.RepairGentaojian != 0
select new
{
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinMaterialVerifyDetails.Manufacturer.ManufacturerName,
a.RepairGentaojian,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.RetrieveCode,
a.Remark,
};
this.spgvMaterial.DataBind();
}
}
void btnOK_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid)
{
//将确认结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
SrinRepairReport srrp;
//生成修复申请报告
if (bcreated)//分支流程--已经生成报告的情况
{
srrp = db.SrinRepairReport.SingleOrDefault(u => u.TaskID.Equals(_taskid));
srrp.CreateTime = dtcCreateTime.SelectedDate;
srrp.Remark = txtRemark.Text.Trim();
srrp.SrinRepairReportCode = txtCode.Text.Trim();
}
else
{
srrp = new SrinRepairReport();
srrp.SrinInspectorVerifyTransferID = _transferid;
srrp.Remark = txtRemark.Text.Trim();
srrp.SrinRepairReportCode = txtCode.Text.Trim();
srrp.TaskID = _taskid;
srrp.CreateTime = dtcCreateTime.SelectedDate;
srrp.Creator = db.EmpInfo.SingleOrDefault(u => u.Account.Equals(SPContext.Current.Web.CurrentUser.LoginName)).EmpID;
db.SrinRepairReport.InsertOnSubmit(srrp);
}
db.SubmitChanges();
Response.Redirect(string.Format("RiProduceApplyReportMessage.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))
{
//初始化表头信息
SrinInspectorVerifyTransfer sivt = db.SrinInspectorVerifyTransfer.SingleOrDefault(u => u.TaskID == GetPreviousTaskID(0, _taskid));
((Label)GetControltByMaster("lblProject")).Text = sivt.SrinProduceVerifyTransfer.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(sivt.CreateTime.ToLongDateString(), sivt.CreateTime.ToLongTimeString());
((Label)GetControltByMaster("lblInspector")).Text = sivt.EmpInfo.EmpName;
//初始化质检待修复物资
spgvMaterial.DataSource = from a in db.SrinInspectorVerifyDetails
where a.SrinInspectorVerifyTransferID == _transferid &&
a.RepairGentaojian != 0
select new
{
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinMaterialVerifyDetails.Manufacturer.ManufacturerName,
a.RepairGentaojian,
a.SrinMaterialVerifyDetails.SrinDetails.SrinStocktakingDetails.SrinSubDetails.RetrieveCode,
a.VerifyCode,
a.Remark,
a.SrinInspectorVerifyDetailsID
};
this.spgvMaterial.DataBind();
if (bcreated)//分支流程--已经生成报告的情况
{
if (!Page.IsPostBack)
{
SrinRepairReport srrp = db.SrinRepairReport.SingleOrDefault(u => u.TaskID.Equals(_taskid));
txtCode.Text = srrp.SrinRepairReportCode;
txtRemark.Text = srrp.Remark;
dtcCreateTime.SelectedDate = srrp.CreateTime;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]);
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID.Equals(_taskid));
_reportid = tsi.StorageInID;
SrinRepairReport srrp = db.SrinRepairReport.SingleOrDefault(u => u.SrinRepairReportID.Equals(_reportid));
//已生成质检清单的情况
if (db.SrinInspectorVerifyRDetails.Count(u => u.SrinInspectorVerifyDetails.SrinInspectorVerifyTransferID.Equals(srrp.SrinInspectorVerifyTransferID)) != 0)
{
//质检清单已经处理的情况
int count = db.TaskStorageIn.Count(u => u.StorageInType.Equals("回收入库") && u.TaskType.Equals("资产组处理修复合格物资") && u.StorageInID.Equals(srrp.SrinInspectorVerifyTransferID));
count += db.MessageInfo.Count(u => u.TaskID.Equals(_taskid));
if (count != 0)
{
Response.Redirect(string.Format("RiInspectorVerifyRDetailsMessage.aspx?TaskID={0}", _taskid), false);
}
else
{
Response.Redirect(string.Format("RiInspectorModifyVerifyRDetails.aspx?TaskID={0}", _taskid), false);
}
return;
}
}
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));
}
}
