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 btnOK_Click(object sender, EventArgs e)
{
try
{
//将确认结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
if (bModified)//分支流程--已经生成质检清单的情况
{
SrinProduceVerifyTransfer spvt = db.SrinProduceVerifyTransfer.SingleOrDefault(u => u.TaskID == _taskid);
spvt.VerifyTime = dtcVerifyTime.SelectedDate;
spvt.Remark = txtRemark.Text.Trim();
spvt.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
}
else
{
SrinProduceVerifyTransfer spvt = new SrinProduceVerifyTransfer();
spvt.SrinVerifyTransferID = _formid;
spvt.VerifyTime = dtcVerifyTime.SelectedDate;
spvt.Remark = txtRemark.Text.Trim();
spvt.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
spvt.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID;
spvt.TaskID = _taskid;
db.SrinProduceVerifyTransfer.InsertOnSubmit(spvt);
}
db.SubmitChanges();
}
Response.Redirect(string.Format("RiProduceArrangeVerifyMessage.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))
{
//初始化表头信息
SrinProduceVerifyTransfer spvt = db.SrinProduceVerifyTransfer.SingleOrDefault(u => u.TaskID == GetPreviousTaskID(0, _taskid));
((Label)GetControltByMaster("lblProject")).Text = spvt.SrinVerifyTransfer.SrinReceipt.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(spvt.SrinVerifyTransfer.CreateTime.ToLongDateString(), spvt.SrinVerifyTransfer.CreateTime.ToLongTimeString());
((Label)GetControltByMaster("lblCode")).Text = spvt.SrinVerifyTransfer.SrinVerifyTransferCode;
_transferid = spvt.SrinProduceVerifyTransferID;
//初始化回收检验物资
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 = spvt.SrinVerifyTransfer.EmpInfo.EmpName;
((Label)GetControltByMaster("lblReadyWork")).Text = spvt.SrinVerifyTransfer.ReadyWorkIsFinished ? "是" : "否";
((Label)GetControltByMaster("lblProduce")).Text = spvt.EmpInfo.EmpName;
((Label)GetControltByMaster("lblVerifyTime")).Text = spvt.VerifyTime.ToLongDateString();
txtRemark.Text = spvt.Remark;
}
}
