protected void tbarbtnAdd_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(Request.QueryString["TaskStorageID"])) { ClientScript.RegisterClientScriptBlock(typeof(string), "Messages", "<script>alert('回退任务不能新增批次.')</script>"); return; } else { Response.Redirect("StorageDetailedCreate.aspx?StorageInID=" + _storageInID + ""); } } 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_QUERYERROR)); } //ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('hello! ')</script>"); }
void btnmodify_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //更新数据 var tep = from a in db.StorageInTest where a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString()) && a.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex == _QCbatch orderby a.StorageInTestID ascending select new { a.StorageInTestID }; var li = tep.ToList(); for (int i = 0; i < this.gv.Rows.Count; i++) { StorageInTest st = new StorageInTest(); st = db.StorageInTest.SingleOrDefault(u => u.StorageInTestID == li[i].StorageInTestID); st.MaterialsLeaderID = Convert.ToInt32(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text.ToString()); TextBox gentaojian_qualified = (TextBox)(this.gv.Rows[i].Cells[5].Controls[0]); st.TestGentaojian = Convert.ToDecimal(gentaojian_qualified.Text.Trim()); TextBox gentaojian_unqualified = (TextBox)(this.gv.Rows[i].Cells[6].Controls[0]); st.FailedGentaojian = Convert.ToDecimal(gentaojian_unqualified.Text.Trim()); TextBox metre_qualified = (TextBox)(this.gv.Rows[i].Cells[8].Controls[0]); st.TestMetre = Convert.ToDecimal(metre_qualified.Text.Trim()); TextBox metre_unqualified = (TextBox)(this.gv.Rows[i].Cells[9].Controls[0]); st.FailedMetre = Convert.ToDecimal(metre_unqualified.Text.Trim()); TextBox ton_qualified = (TextBox)(this.gv.Rows[i].Cells[11].Controls[0]); st.TestTon = Convert.ToDecimal(ton_qualified.Text.Trim()); TextBox ton_unqualified = (TextBox)(this.gv.Rows[i].Cells[12].Controls[0]); st.FailedTon = Convert.ToDecimal(ton_unqualified.Text.Trim()); TextBox reportNum = (TextBox)(this.gv.Rows[i].Cells[13].Controls[0]); st.InspectionReportNum = reportNum.Text.Trim(); st.FileNameStr = "reportqualified"; var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); st.CreateTime = SevTime.First(); st.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); db.SubmitChanges(); } //存库标识 ViewState["Temp"] = flag = true; } //Response.Redirect("QualifiedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&QCBatch=" + Request.QueryString["QCBatch"] + " "); } 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)); } }
protected void Page_Load(object sender, EventArgs e) { try { string strTaskID = Request.QueryString["TaskID"]; _taskid = string.IsNullOrEmpty(strTaskID) ? -1 : Convert.ToInt32(strTaskID); _tasktype = Request.QueryString["TaskType"]; string strNoticeID = Request.QueryString["NoticeID"]; _noticeid = string.IsNullOrEmpty(strNoticeID) ? -1 : Convert.ToInt32(strNoticeID); _executor = Request.QueryString["Executor"]; strFinishUrl = "../../default-old.aspx"; InitControl(); } 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_QUERYERROR)); } }
void btnOK_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageOutDetails sod; foreach (GridViewRow gvr in this.spgvMaterial.Rows) { sod = db.StorageOutDetails.SingleOrDefault(u => u.StorageOutDetailsID == Convert.ToInt32(gvr.Cells[11].Text)); sod.Gentaojian = Convert.ToDecimal((gvr.Cells[5].Controls[0] as TextBox).Text.Trim()); sod.Metre = Convert.ToDecimal((gvr.Cells[7].Controls[0] as TextBox).Text.Trim()); sod.Ton = Convert.ToDecimal((gvr.Cells[9].Controls[0] as TextBox).Text.Trim()); sod.Remark = (gvr.Cells[10].Controls[0] as TextBox).Text.Trim(); sod.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); db.SubmitChanges(); } } Response.Redirect(string.Format("NormalOutProduceDetailsMessage.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_UPDATEERROR)); } }
protected void Page_Load(object sender, EventArgs e) { try { _storageInID = Convert.ToInt32(Request.QueryString["StorageInID"]); _taskID = Convert.ToInt32(Request.QueryString["TaskStorageID"]); _QCbatch = Request.QueryString["QCBatch"]; control(); taskState(); initControl(_flag); this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; BindGridView(); if (!IsPostBack) { ViewState["Temp"] = false; dataLoad(); } } 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_LOADERROR)); } }
protected void Page_Load(object sender, EventArgs e) { try { _taskid = Convert.ToInt32(Request.QueryString["TaskID"]); using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageOutTask sot = db.StorageOutTask.SingleOrDefault(u => u.TaskID == this._taskid); if (sot.TaskState.Equals("已完成")) { Response.Redirect(string.Format("NormalOutAssetDetailsMessage.aspx?TaskID={0}", _taskid), false); return; } _noticeid = sot.NoticeID; } InitializeCustomControls(); BindDataToCustomControls(); ShowCustomControls(); } 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_LOADERROR)); } }
private int reEmpId(string Emp) { int valueEmp = 0; try { using (MMSProDBDataContext dc = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { EmpInfo EI = dc.EmpInfo.SingleOrDefault(u => u.Account == Emp); if (EI != null) { valueEmp = EI.EmpID; } } } 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_QUERYERROR)); } return(valueEmp); }
private bool RealDetailsIsDone() { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { if (db.StorageCommitOutRealDetails.Count(u => u.StorageCommitOutNoticeID.Equals(_noticeid)) != 0) { return(true); } else { return(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_QUERYERROR)); return(false); } }
protected void Page_Load(object sender, EventArgs e) { try { this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]); using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { _receiptid = db.SrinQualifiedReceipt.SingleOrDefault(u => u.TaskID.Equals(_taskid)).SrinQualifiedReceiptID; if (db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID.Equals(_taskid)).TaskState.Equals("已完成")) { bfinished = true; } } InitializeCustomControls(); BindDataToCustomControls(); ShowCustomControls(); } 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_LOADERROR)); } }
void btnCancel_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //分支流程--任务已完成的情况 StorageOutTask sot = db.StorageOutTask.SingleOrDefault(u => u.StorageOutTaskID == this._taskid); if (sot.TaskState.Equals("未完成") && lblDirectorResult.Text.Equals("未通过"))//主流程--任务未完成而且主任审批未通过则将出库数目清零 { db.ExecuteCommand("Update StorageCommitOutRealDetails Set RealGentaojian = 0,RealMetre = 0,RealTon = 0,RealAmount = 0 Where StorageCommitOutNoticeID = {0}", this._noticeid); } if (sot.TaskState.Equals("未完成")) { sot.TaskState = "已完成"; } db.SubmitChanges(); } Response.Redirect("../../default-old.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_QUERYERROR)); } }
void ddlProprietor_SelectedIndexChanged(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { this.ddlProject.DataSource = from a in db.ProjectInfo where a.Owner == Convert.ToInt32(ddlProprietor.SelectedValue) select new { Key = a.ProjectName, Value = a.ProjectID, }; this.ddlProject.DataTextField = "Key"; this.ddlProject.DataValueField = "Value"; this.ddlProject.DataBind(); this.ddlProject.Items.Insert(0, "--请选择--"); this.ddlProjectStage.Items.Clear(); } } 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_LOADERROR)); } }
protected void Page_Load(object sender, EventArgs e) { try { this._userid = Convert.ToInt32(Request.QueryString["CurrentUserID"]); this._noticeid = Convert.ToInt32(Request.QueryString["NoticeID"]); InitializeCustomControl(); if (!Page.IsPostBack) { BindControl(); if (_noticeid != 0)//分支流程--修改Notice的情况 { BindDataToCustomControls(); } } } 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_LOADERROR)); } }
protected void Page_Load(object sender, EventArgs e) { try { _noticeid = Convert.ToInt32(Request.QueryString["NoticeID"]); strBackUrl = Request.QueryString["BackUrl"]; if (string.IsNullOrEmpty(strBackUrl)) { strBackUrl = string.Format("ManageStorageOutDetails.aspx?NoticeID={0}", _noticeid); } else { strBackUrl = HttpUtility.UrlDecode(strBackUrl); } InitializeCustomControls(); BindDataToCustomControls(); ShowCustomControls(); } 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_LOADERROR)); } }
void chbShowAll_CheckedChanged(object sender, EventArgs e) { try { if (!chbShowAll.Checked) { chbShowAll.Enabled = true; } else { txtFinanceCode.Text = string.Empty; txtMaterialName.Text = string.Empty; txtSpecificationModel.Text = string.Empty; chbShowAll.Enabled = false; } Response.AddHeader("Refresh", "0"); } 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_LOADERROR)); } }
protected void Page_Load(object sender, EventArgs e) { this.gv = new SPGridView(); this.gv.AutoGenerateColumns = false; try { BindGridView(); //添加按钮到toolbar ToolBar tbarTop = (ToolBar)GetControltByMaster("tbarbusiness"); ToolBarButton btnRefresh = (ToolBarButton)this.Page.LoadControl("~/_controltemplates/ToolBarButton.ascx"); btnRefresh.ID = "btnRefresh"; btnRefresh.Text = "刷新"; btnRefresh.ImageUrl = "/_layouts/images/refresh.GIF"; btnRefresh.Padding = "0,5,0,0"; btnRefresh.Click += new EventHandler(btnRefresh_Click); tbarTop.RightButtons.Controls.Add(btnRefresh); } 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_LOADERROR)); } }
protected void tbarbtnDelte_Click(object sender, EventArgs e) { try { List <CheckBox> listString = GetCheckedID(); if (listString.Count > 0) { StorageInDetailed SID; using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { foreach (var li in listString) { SID = db.StorageInDetailed.SingleOrDefault(a => a.StorageDetailedID == int.Parse(li.ToolTip)); if (SID != null) { db.StorageInDetailed.DeleteOnSubmit(SID); } } db.SubmitChanges(); } Response.Redirect("StorageInDetailedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + ""); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择需要删除的记录!')</script>"); } } 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_DELETEERROR)); } }
void btnOK_Click(object sender, EventArgs e) { try { //将审核结果保存到数据库 using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { StorageCommitOutDirectorConfirm scodc; //将审核结果保存到数据库 scodc = new StorageCommitOutDirectorConfirm(); scodc.StorageCommitOutNoticeID = _noticeid; scodc.StorageCommitOutAssetAuditID = _aauditid; scodc.ConfirmTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); scodc.Director = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID; scodc.TaskID = _taskid; db.StorageCommitOutDirectorConfirm.InsertOnSubmit(scodc); db.SubmitChanges(); //转到审核表单页 Response.Redirect(string.Format("CommitOutDirectorMessage.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 InsertAudited(GridViewRow gvr) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { Label lb = (Label)gvr.Cells[23].Controls[0]; //新增 StorageInAudited sia = new StorageInAudited(); sia.StorageInID = _storageinid; sia.MaterialID = (db.MaterialInfo.SingleOrDefault(u => u.MaterialID == Convert.ToInt32(gvr.Cells[25].Text))).MaterialID; sia.SpecificationModel = gvr.Cells[4].Text; sia.QuantityGentaojian = Convert.ToDecimal(gvr.Cells[5].Text); sia.QuantityMetre = Convert.ToDecimal(gvr.Cells[6].Text); sia.QuantityTon = Convert.ToDecimal(gvr.Cells[7].Text); sia.Quantity = Convert.ToDecimal(gvr.Cells[8].Text); sia.CurUnit = gvr.Cells[9].Text; sia.NumberQualified = 0; sia.InspectionTime = Convert.ToDateTime(gvr.Cells[10].Text); sia.InspectionReportNum = gvr.Cells[11].Text; sia.UnitPrice = Convert.ToDecimal(gvr.Cells[12].Text); sia.Amount = Convert.ToDecimal(gvr.Cells[13].Text); sia.PileID = (db.PileInfo.SingleOrDefault(u => u.PileCode == gvr.Cells[15].Text)).PileID; sia.financeCode = gvr.Cells[16].Text; sia.StorageTime = Convert.ToDateTime(gvr.Cells[17].Text); sia.BatchIndex = gvr.Cells[18].Text; var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); sia.AuditTime = SevTime.First(); sia.Remark = gvr.Cells[22].Text; sia.SupplierID = Convert.ToInt32(gvr.Cells[26].Text); sia.MaterialsManager = Convert.ToInt32(gvr.Cells[27].Text); sia.WarehouseWorker = Convert.ToInt32(gvr.Cells[28].Text); sia.AuditStatus = lb.Text == "未通过" ? "未通过" : "已通过"; sia.MaterialAccounting = (db.EmpInfo.SingleOrDefault(u => u.EmpName == SPContext.Current.Web.CurrentUser.Name)).EmpID; db.StorageInAudited.InsertOnSubmit(sia); db.SubmitChanges(); } } 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)); } }
protected void InitControls() { this.lblFromProcess = (Label)GetControltByMaster("lblFromProcess"); this.lblFromTask = (Label)GetControltByMaster("lblFromTask"); this.lblFromEmp = (Label)GetControltByMaster("lblFromEmp"); this.lblCreateTime = (Label)GetControltByMaster("lblCreateTime"); this.lblMsgTitle = (Label)GetControltByMaster("lblMsgTitle"); this.lblMsgContent = (Label)GetControltByMaster("lblMsgContent"); this.lblMsgStatus = (Label)GetControltByMaster("lblMsgStatus"); this.btnEditStatus = (Button)GetControltByMaster("btnEditStatus"); btnEditStatus.Click += new EventHandler(btnEditStatus_Click); using (MMSProDBDataContext dc = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { try { MessageInfo msgInfoTemp = dc.MessageInfo.SingleOrDefault(mi => mi.MessageInfoID == this.curMsgInfoID); if (msgInfoTemp != null) { this.lblFromProcess.Text = msgInfoTemp.MessageSource; if (msgInfoTemp.MessageSource == "回收入库") { this.lblFromTask.Text = dc.TaskStorageIn.SingleOrDefault(tsi => tsi.TaskStorageID == msgInfoTemp.TaskID).TaskTitle; } else if (msgInfoTemp.MessageSource == "正常入库") { this.lblFromTask.Text = dc.StorageOutTask.SingleOrDefault(sot => sot.TaskID == msgInfoTemp.TaskID).TaskTitle; } //this.lblFromEmp.Text = dc.EmpInfo.SingleOrDefault(ei => ei.EmpID == msgInfoTemp.Creater).EmpName; this.lblFromEmp.Text = msgInfoTemp.EmpInfo.EmpName; this.lblCreateTime.Text = msgInfoTemp.CreateTime.ToString(); this.lblMsgTitle.Text += msgInfoTemp.MessageTitle; this.lblMsgContent.Text = msgInfoTemp.MessageContent; this.lblMsgStatus.Text = msgInfoTemp.MessageStatus; if (this.lblMsgStatus.Text == "未读") { this.lblMsgStatus.ForeColor = System.Drawing.Color.Red; this.btnEditStatus.Text = "标记为已读?"; this.btnEditStatus.Enabled = true; } else { this.lblMsgStatus.ForeColor = System.Drawing.Color.Green; this.btnEditStatus.Text = "已读状态"; this.btnEditStatus.Enabled = 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_LOADERROR)); } } }
protected void Page_Load(object sender, EventArgs e) { try { InitControl(); checkSendPolicy(); if (!IsPostBack) { BindDefaultDate(); } selUser(this.txtRecipient); if (!string.IsNullOrEmpty(Request.QueryString["storageInType"])) { switch (Request.QueryString["storageInType"]) { case "正常入库": storageInType = "正常入库"; break; case "委外入库": storageInType = "委外入库"; break; case "回收入库": storageInType = "回收入库"; break; } } if (Request.QueryString["state"].ToString() == "质检") { this.txtMessageCode.Enabled = false; lblre.Text = "质检人"; currentFlow = "质检"; } if (Request.QueryString["state"].ToString() == "材料会计审核") { this.txtMessageCode.Enabled = true; lblre.Text = "材料会计"; currentFlow = "材料会计审核"; } } 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_LOADERROR)); } }
void btnOK_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { CheckBox chb; int iCount = 0; SrinSubDetails ssd; foreach (GridViewRow gvr in spgvMaterial.Rows) { chb = (CheckBox)gvr.Cells[0].Controls[0]; if (!chb.Checked) { continue; } //将选中项保存到数据库 ssd = new SrinSubDetails(); ssd.SrinSubDocID = _subdocid; ssd.TotleGentaojian = Convert.ToDecimal(((TextBox)gvr.Cells[4].Controls[0]).Text.Trim()); ssd.TotleMetre = Convert.ToDecimal(((TextBox)gvr.Cells[5].Controls[0]).Text.Trim()); ssd.TotleTon = Convert.ToDecimal(((TextBox)gvr.Cells[6].Controls[0]).Text.Trim()); ssd.RetrieveCode = ((TextBox)gvr.Cells[7].Controls[0]).Text.Trim(); ssd.Remark = ((TextBox)gvr.Cells[8].Controls[0]).Text.Trim(); ssd.MaterialID = Convert.ToInt32(gvr.Cells[9].Text); ssd.CreateTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }).First(); ssd.Creator = db.EmpInfo.SingleOrDefault(u => u.Account == SPContext.Current.Web.CurrentUser.LoginName).EmpID; db.SrinSubDetails.InsertOnSubmit(ssd); iCount++; } db.SubmitChanges(); //没有选中的情况 if (iCount == 0) { Response.Write("<script language='javaScript'>alert('没有选中要添加的物资明细!');</script>"); return; } } Response.AddHeader("Refresh", "0"); } 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)); } }
void btnmodify_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //更新数据 var tep = from a in db.StorageInAssets where a.StorageInTest.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.StorageInID == Convert.ToInt32(Request.QueryString["StorageInID"].ToString()) && a.StorageInTest.StorageInMaterialsLeader.StorageInMaterials.StorageProduce.BatchIndex == _QCbatch orderby a.StorageInAssetsID ascending select new { a.StorageInAssetsID }; var li = tep.ToList(); for (int i = 0; i < this.gv.Rows.Count; i++) { StorageInAssets sia = db.StorageInAssets.SingleOrDefault(u => u.StorageInAssetsID == li[i].StorageInAssetsID); DropDownList ddlunit = (DropDownList)(this.gv.Rows[i].Cells[7].Controls[0]); sia.CurUnit = ddlunit.SelectedItem.Text; TextBox unitprice = (TextBox)(this.gv.Rows[i].Cells[8].Controls[0]); sia.UnitPrice = Convert.ToDecimal(unitprice.Text.Trim()); //TextBox amount = (TextBox)(this.gv.Rows[i].Cells[9].Controls[0]); sia.Amount = Convert.ToDecimal(this.gv.Rows[i].Cells[reCellIndex(ddlunit.SelectedItem.Text)].Text) * sia.UnitPrice; TextBox reportNum = (TextBox)(this.gv.Rows[i].Cells[10].Controls[0]); sia.BillCode = reportNum.Text.Trim(); TextBox material = (TextBox)(this.gv.Rows[i].Cells[11].Controls[0]); sia.MaterialsAttribute = material.Text.Trim(); sia.financeCode = "009811"; var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); sia.CreateTime = SevTime.First(); sia.Creator = reEmpId(SPContext.Current.Web.CurrentUser.LoginName); db.SubmitChanges(); } //存库标识 ViewState["Temp"] = flag = true; } //Response.Redirect("QualifiedManage.aspx?StorageInID=" + Request.QueryString["StorageInID"] + "&&TaskStorageID=" + Request.QueryString["TaskStorageID"] + "&&QCBatch=" + Request.QueryString["QCBatch"] + " "); } 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)); } }
void btnSave_Click(object sender, EventArgs e) { try { List <CheckBox> listString = GetCheckedID(); if (listString.Count > 0) { if (CheckStringEmpty()) { for (int i = 0; i < this.gv.Rows.Count; i++) { chb = (CheckBox)this.gv.Rows[i].Cells[0].Controls[0]; if (!chb.Checked) { continue; } if (this.gv.Rows[i].Cells[4].Controls[0] is TextBox) { itembox = (TextBox)this.gv.Rows[i].Cells[4].Controls[0]; using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { AwaitScrap asp = db.AwaitScrap.SingleOrDefault(u => u.AwaitScrapID == int.Parse(this.gv.Rows[i].Cells[this.gv.Columns.Count - 1].Text)); asp.ScrapReportNum = itembox.Text.Trim(); db.SubmitChanges(); } } } Response.Redirect("AwaitScrapManage.aspx", false); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请将选择的数据填写完整!')</script>"); return; } } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择要提交的物资!')</script>"); return; } } 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_UPDATEERROR)); } }
protected void Page_Load(object sender, EventArgs e) { try { this.InitControl(); } 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_LOADERROR)); } }
public void btnSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(this.txtBillCode.Text)) { using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int id = Convert.ToInt32(Request.QueryString["StorageInID"]); StorageInMain SI = db.StorageInMain.SingleOrDefault(a => a.StorageInID == id); //单据编号唯一 StorageInMain scode = db.StorageInMain.SingleOrDefault(u => u.StorageInCode == this.txtBillCode.Text.Trim()); if (scode == null) { SI.StorageInCode = this.txtBillCode.Text.Trim(); } else { if (SI.StorageInID == scode.StorageInID) { SI.StorageInCode = this.txtBillCode.Text.Trim(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('单据号重复!')</script>"); return; } } if (this.ddlType.SelectedIndex == 0) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择入库类型!')</script>"); return; } SI.StorageInCode = this.txtBillCode.Text.Trim(); SI.ReceivingType = Convert.ToInt32(this.ddlType.SelectedValue.Trim()); SI.Remark = this.txtRemark.Text.Trim(); var SevTime = db.ExecuteQuery <DateTime>("select getdate()", new object[] { }); SI.CreateTime = SevTime.First(); db.SubmitChanges(); Response.Redirect("StorageManage.aspx"); } } } 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_UPDATEERROR)); } }
protected void Page_Load(object sender, EventArgs e) { try { string strTaskstorageid = Request.QueryString["TaskStorageID"]; if (string.IsNullOrEmpty(strTaskstorageid)) { Response.Redirect(_errorpage); return; } else { this._taskstorageid = Convert.ToInt32(strTaskstorageid); using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { TaskStorageIn tsi = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskstorageid); this._storageinid = tsi.StorageInID; this._batchname = tsi.QCBatch; } InitializeCustomControls(); BindGridView(); ShowCustomControls(); if (this.IsAudited()) { Response.Redirect("AuditedModify.aspx?TaskStorageID=" + _taskstorageid + " "); } else { if (!Page.IsPostBack) { //初始化审核状态为"待审核" SetAuditStatus(Audit.Init); } else { //审核后更改审核状态 SetAuditStatus(Audit.Normal); } } } } 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_LOADERROR)); } }
void tbarbtnDelete_Click(object sender, EventArgs e) { try { using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { int ichecked = 0; CheckBox chb; int idetailsid; foreach (GridViewRow gvr in spgvMaterial.Rows) { chb = (CheckBox)gvr.Cells[0].Controls[0]; if (!chb.Checked) { continue; } ichecked++; switch (_type) { case "维修保养": idetailsid = Convert.ToInt32(gvr.Cells[12].Text); SrinMaterialRepairDetails smrd = db.SrinMaterialRepairDetails.SingleOrDefault(a => a.SrinMaterialRepairDetailsID == idetailsid); db.SrinMaterialRepairDetails.DeleteOnSubmit(smrd); break; case "回收检验": idetailsid = Convert.ToInt32(gvr.Cells[9].Text); SrinMaterialVerifyDetails smvd = db.SrinMaterialVerifyDetails.SingleOrDefault(a => a.SrinMaterialVerifyDetailsID == idetailsid); db.SrinMaterialVerifyDetails.DeleteOnSubmit(smvd); break; } } if (ichecked != 0) { db.SubmitChanges(); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择需要删除的记录!')</script>"); } } Response.AddHeader("Refresh", "0"); } 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_QUERYERROR)); } }
/// <summary> /// 检查入库单下是否有物资 /// </summary> /// <returns></returns> //private bool checkDetail(int cid) //{ // using (MMSProDBDataContext data = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) // { // var temp = from a in data.StorageInDetailed // where a.StorageInID == cid // select a; // if (temp.ToList().Count > 0) // { // return false; // } // } // return true; //} protected void tbarbtnDelte_Click(object sender, EventArgs e) { try { List <CheckBox> listString = GetCheckedID(); if (listString.Count > 0) { StorageInMain SI; using (MMSProDBDataContext data = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { foreach (var li in listString) { if (!isInTask(li.ToolTip)) { //检查入库单下是否有明细物资 if (checkDetail(int.Parse(li.ToolTip)) == false) { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('此入库单已存在物资,若要删除入库单,请先删除入库单下的物资!')</script>"); return; } SI = data.StorageInMain.SingleOrDefault(a => a.StorageInID == int.Parse(li.ToolTip)); if (SI != null) { data.StorageInMain.DeleteOnSubmit(SI); data.SubmitChanges(); } } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('此入库单单已进入任务流程不能删除!')</script>"); return; } } } Response.Redirect("StorageManage.aspx"); } else { ClientScript.RegisterClientScriptBlock(typeof(string), "ShowMessage", "<script>alert('请选择需要删除的记录!')</script>"); return; } } 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_QUERYERROR)); } }
protected void Page_Load(object sender, EventArgs e) { try { this._taskid = Convert.ToInt32(Request.QueryString["TaskID"]); using (MMSProDBDataContext db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString)) { //分支流程--任务已经完成的情况 if (db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid).TaskState.Equals("已完成")) { if (db.SrinStocktaking.Count(u => u.TaskID == _taskid && u.StocktakingResult.Equals("清点有误")) != 0)//分支流程--清点有误的情况 { Response.Redirect(string.Format("RiMaterialStocktakingMessage.aspx?TaskID={0}", _taskid), false); } else//清点无误的情况 { Response.Redirect(string.Format("ViewRepairAndVerifyInfo.aspx?TaskID={0}", _taskid), false); } return; } else { //分支流程--已经发送确认任务的情况 if (db.TaskStorageIn.Count(u => u.PreviousTaskID.Equals(_taskid) && u.TaskType.Equals("物资组长确认清点结果")) != 0) { Response.Redirect(string.Format("RiMaterialStocktakingMessage.aspx?TaskID={0}", _taskid), false); return; } //分支流程--已经清点过的情况 if (db.SrinStocktaking.Count(u => u.TaskID == _taskid) != 0) { Response.Redirect(string.Format("RiMaterialModifyStocktaking.aspx?TaskID={0}", _taskid), false); return; } } _subdocid = db.TaskStorageIn.SingleOrDefault(u => u.TaskStorageID == _taskid).StorageInID; } InitializeCustomControls(); BindDataToCustomControls(); ShowCustomControls(); } 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_LOADERROR)); } }
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)); } }