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