void btnOK_Click(object sender, EventArgs e) { try { //保存清点结果 SrinStocktaking sst; using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { sst = new SrinStocktaking(); sst.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID; sst.StocktakingDate = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); sst.SrinSubDocID = _subdocid; sst.StocktakingResult = chbCheck.Checked ? "清点有误" : "清点无误"; sst.StocktakingProblem = txtProblem.Text.Trim(); sst.TaskID = _taskid; db.SrinStocktaking.InsertOnSubmit(sst); db.SubmitChanges(); //保存清点物资明细 int iDetailsID, iStorageID, iPileID; SrinStocktakingDetails sstd; foreach (GridViewRow gvr in this.spgvMaterial.Rows) { iDetailsID = Convert.ToInt32(gvr.Cells[10].Text); iStorageID = Convert.ToInt32((gvr.Cells[6].Controls[0] as DropDownList).SelectedValue); iPileID = Convert.ToInt32((gvr.Cells[7].Controls[0] as DropDownList).SelectedValue); sstd = new SrinStocktakingDetails(); sstd.SrinStocktakingID = sst.SrinStocktakingID; sstd.SrinSubDetailsID = iDetailsID; sstd.StorageID = iStorageID == 0?new Nullable <int>():iStorageID; sstd.PileID = iPileID == 0?new Nullable <int>():iPileID; sstd.Remark = ((TextBox)gvr.Cells[9].Controls[0]).Text.Trim(); sstd.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); sstd.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID; db.SrinStocktakingDetails.InsertOnSubmit(sstd); } db.SubmitChanges(); } Response.Redirect(string.Format("RiMaterialStocktakingMessage.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.TaskID == _taskid); (GetControltByMaster("lblMaterial") as Label).Text = sst.EmpInfo.EmpName; (GetControltByMaster("lblResult") as Label).Text = sst.StocktakingResult; (GetControltByMaster("lblInventoryDate") as Label).Text = string.Concat(sst.StocktakingDate.ToLongDateString(), sst.StocktakingDate.ToLongTimeString()); (GetControltByMaster("lblOpinion") as Label).Text = sst.StocktakingProblem; //初始化回收入库单信息 SrinReceipt srp = db.SrinReceipt.SingleOrDefault(u => u.SrinReceiptID == _receiptid); ((Label)GetControltByMaster("lblProject")).Text = srp.SrinStocktakingConfirm.SrinStocktaking.SrinSubDoc.ProjectInfo.ProjectName; ((Label)GetControltByMaster("lblAsset")).Text = srp.EmpInfo.EmpName; ((Label)GetControltByMaster("lblCode")).Text = srp.SrinReceiptCode; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(srp.CreateTime.ToLongDateString(), srp.CreateTime.ToLongTimeString()); ((Label)GetControltByMaster("lblRemark")).Text = srp.Remark; this.spgvRepair.DataSource = from a in db.SrinRepairPlan join b in db.TaskStorageIn on new { TaskID = a.TaskID, RepairPlanID = a.SrinRepairPlanID, TaskType = "维修保养物资组长审核" } equals new { TaskID = b.PreviousTaskID.Value, RepairPlanID = b.StorageInID, b.TaskType } into c from d in c.DefaultIfEmpty() where a.SrinReceiptID == _receiptid select new { a.Remark, MaterialCount = a.SrinMaterialRepairDetails.Count, a.CreateTime, a.SrinRepairPlanCode, a.SrinRepairPlanID, MaterialChief = d == null ? "N/A" : d.EmpInfo1.EmpName, }; this.spgvRepair.DataBind(); this.spgvVerify.DataSource = from v in db.SrinVerifyTransfer where v.SrinReceiptID == _receiptid select new { v.Remark, MaterialCount = v.SrinMaterialVerifyDetails.Count, v.CreateTime, v.SrinVerifyTransferCode, Ready = v.ReadyWorkIsFinished ? "已完成" : "未完成", v.SrinVerifyTransferID }; this.spgvVerify.DataBind(); } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == db.TaskStorageIn.SingleOrDefault(v => v.TaskStorageID.Equals(_taskid)).StorageInID); ((Label)GetControltByMaster("lblCreater")).Text = ssd.EmpInfo.EmpName; ((Label)GetControltByMaster("lblProject")).Text = ssd.ProjectInfo.ProjectName; ((Label)GetControltByMaster("lblDate")).Text = string.Concat(ssd.CreateTime.ToLongDateString(), ssd.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.StorageID, a.PileID, a.Remark, a.SrinStocktakingDetailsID }; this.spgvMaterial.DataBind(); //初始化清点信息 if (!Page.IsPostBack) { SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.TaskID == _taskid); if (sst != null) { chbCheck.AutoPostBack = false; chbCheck.Checked = sst.StocktakingResult.Equals("清点有误") ? true : false; chbCheck.AutoPostBack = true; txtProblem.Visible = sst.StocktakingResult.Equals("清点有误") ? true : false; txtProblem.Text = sst.StocktakingProblem; btnOK.Text = "修改清点表单"; } } } }
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; } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == _subdocid); (GetControltByMaster("lblCreater") as Label).Text = ssd.EmpInfo.EmpName; (GetControltByMaster("lblProject") as Label).Text = ssd.ProjectInfo.ProjectName; (GetControltByMaster("lblDate") as Label).Text = string.Concat(ssd.CreateTime.ToLongDateString(), ssd.CreateTime.ToLongTimeString()); //初始化调拨明细 this.spgvMaterial.DataSource = from a in db.SrinSubDetails where a.SrinSubDocID == _subdocid select new { a.MaterialInfo.MaterialName, a.MaterialInfo.SpecificationModel, a.MaterialInfo.FinanceCode, a.TotleGentaojian, a.TotleMetre, a.TotleTon, a.RetrieveCode, a.Remark, a.SrinSubDetailsID }; this.spgvMaterial.DataBind(); //初始化清点信息 SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.TaskID == _pretaskid); (GetControltByMaster("lblMaterial") as Label).Text = sst.EmpInfo.EmpName; (GetControltByMaster("lblResult") as Label).Text = sst.StocktakingResult; (GetControltByMaster("lblInventoryDate") as Label).Text = string.Concat(sst.StocktakingDate.ToLongDateString(), sst.StocktakingDate.ToLongTimeString()); (GetControltByMaster("txtOpinion") as TextBox).Text = sst.StocktakingProblem; } }