void btnOK_Click(object sender, EventArgs e)
{
try
{
//将确认结果保存到数据库
using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
SrinStocktakingConfirm sstc = db.SrinStocktakingConfirm.SingleOrDefault(u => u.TaskID.Equals(_taskid));
if (sstc == null)
{
sstc = new SrinStocktakingConfirm();
sstc.SrinStocktakingID = _stocktakingid;
sstc.TaskID = _taskid;
sstc.MaterialChief = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID;
sstc.ConfirmTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First();
db.SrinStocktakingConfirm.InsertOnSubmit(sstc);
db.SubmitChanges();
}
}
Response.Redirect(string.Format("RiMChiefConfirmStocktakingMessage.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))
{
//初始化表头信息
SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.SrinStocktakingID == _stocktakingid);
((Label)GetControltByMaster("lblDelivery")).Text = sst.SrinSubDoc.EmpInfo.EmpName;
((Label)GetControltByMaster("lblProject")).Text = sst.SrinSubDoc.ProjectInfo.ProjectName;
((Label)GetControltByMaster("lblDate")).Text = string.Concat(sst.SrinSubDoc.CreateTime.ToLongDateString(), sst.SrinSubDoc.CreateTime.ToLongTimeString());
//初始化调拨明细
this.spgvMaterial.DataSource = from a in db.SrinStocktakingDetails
where a.SrinStocktakingID == _stocktakingid
select new
{
a.SrinSubDetails.MaterialInfo.MaterialName,
a.SrinSubDetails.MaterialInfo.SpecificationModel,
a.SrinSubDetails.MaterialInfo.FinanceCode,
a.SrinSubDetails.TotleGentaojian,
a.SrinSubDetails.TotleMetre,
a.SrinSubDetails.TotleTon,
a.SrinSubDetails.RetrieveCode,
a.StorageInfo.StorageName,
a.PileInfo.PileName,
a.Remark,
a.SrinStocktakingDetailsID
};
this.spgvMaterial.DataBind();
//初始化表尾
((Label)GetControltByMaster("lblMaterial")).Text = sst.EmpInfo.EmpName;
((Label)GetControltByMaster("lblInventoryDate")).Text = string.Concat(sst.StocktakingDate.ToLongDateString(), sst.StocktakingDate.ToLongTimeString());
((Label)GetControltByMaster("lblResult")).Text = sst.StocktakingResult.Trim();
((Label)GetControltByMaster("lblOpinion")).Text = sst.StocktakingProblem.Trim();
SrinStocktakingConfirm sstc = db.SrinStocktakingConfirm.SingleOrDefault(u => u.TaskID.Equals(_taskid));
((Label)GetControltByMaster("lblMChief")).Text = sstc.EmpInfo.EmpName;
((Label)GetControltByMaster("lblConfirmTime")).Text = string.Concat(sstc.ConfirmTime.ToLongDateString(), sstc.ConfirmTime.ToLongTimeString());
_confirmid = sstc.SrinStocktakingConfirmID;
}
}
