private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //初始化表头信息 SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == _subdocid); ((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.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(); } }
private void BindDataToCustomControls() { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == this._subdocid); txtTaker.Text = ssd.EmpInfo1.Account; txtRemark.Text = ssd.Remark; ddlCompany.SelectedValue = ssd.ProjectInfo.Owner.ToString(); dtcCreateTime.SelectedDate = ssd.CreateTime; BindProject(); ddlProject.SelectedValue = ssd.Project.ToString(); btnSave.Text = "修改"; } }
void btnSave_Click(object sender, EventArgs e) { try { if (Page.IsValid) { if (this.ddlProject.SelectedIndex == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "提示", "<script>alert('请选择回收项目! ');</script>"); return; } using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { SrinSubDoc ssd; if (this._subdocid == 0) //主流程--新建的情况 { ssd = new SrinSubDoc(); ssd.Creator = this._userid; ssd.CreateTime = ((DateTimeControl)GetControltByMaster("dtcCreateTime")).SelectedDate; ssd.Project = Convert.ToInt32(ddlProject.SelectedValue); ssd.Remark = ((TextBox)GetControltByMaster("txtRemark")).Text.Trim(); ssd.Taker = db.EmpInfo.SingleOrDefault(u => u.Account.Equals(txtTaker.Text.Trim())).EmpID; db.SrinSubDoc.InsertOnSubmit(ssd); } else { ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == this._subdocid); ssd.CreateTime = ((DateTimeControl)GetControltByMaster("dtcCreateTime")).SelectedDate; ssd.Project = Convert.ToInt32(ddlProject.SelectedValue); ssd.Remark = txtRemark.Text.Trim(); ssd.Taker = db.EmpInfo.SingleOrDefault(u => u.Account.Equals(txtTaker.Text.Trim())).EmpID; } db.SubmitChanges(); } Response.Redirect("ManageSrinSubDoc.aspx", 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)) { //初始化表头信息 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)) { //初始化表头信息 SrinSubDoc ssd = db.SrinSubDoc.SingleOrDefault(u => u.SrinSubDocID == _subdocid); ((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.StorageInfo.StorageName, a.PileInfo.PileName, a.Remark, a.SrinStocktakingDetailsID }; this.spgvMaterial.DataBind(); //初始化清点信息 SrinStocktaking sst = db.SrinStocktaking.SingleOrDefault(u => u.TaskID == _taskid); ((Label)GetControltByMaster("lblMaterial")).Text = sst.EmpInfo.EmpName; lblResult.Text = sst.StocktakingResult; ((Label)GetControltByMaster("lblInventoryDate")).Text = string.Concat(sst.StocktakingDate.ToLongDateString(), sst.StocktakingDate.ToLongTimeString()); lblOpinion.Text = sst.StocktakingProblem; } }