protected void btnEdit_Click(object sender, EventArgs e) { #region 设置自己要判断的信息 if (txtName.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写姓名!');</script>"); txtName.Focus(); return; } if (txtProName.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写项目名称!');</script>"); txtName.Focus(); return; } if (txtCreateTime.Text.Trim() == "") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('请填写日期!');</script>"); txtCreateTime.Focus(); return; } try { Convert.ToDateTime(txtCreateTime.Text); } catch (Exception) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写的时间格式有误!');</script>"); txtCreateTime.Focus(); return; } if (DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text)) == null) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('你填写申请用户不存在!');</script>"); txtName.Focus(); return; } #endregion Tb_ProjectInv model = new Tb_ProjectInv(); model.ProName = txtProName.Text; model.CreateTime = Convert.ToDateTime(txtCreateTime.Text); model.State = ddlProState.Text; model.GuestId = Convert.ToInt32(ddlUser.SelectedValue); List <Tb_ProjectInvs> projectList = Session["ProInvs"] as List <Tb_ProjectInvs>; model.Id = Convert.ToInt32(Request["allE_id"]); string IDS = ViewState["ProInvsIds"].ToString(); Tb_ProjectInvService proMainSer = new Tb_ProjectInvService(); if (proMainSer.updateTran(model, projectList, IDS)) { string sql = string.Format("update tb_EForm set e_Remark='{0}' where id={1}", txtProName.Text, Request["EForm_Id"]); DBHelp.ExeCommand(sql); base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交成功!');</script>"); } else { btnSub.Enabled = false; base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交失败!');</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { if (FormCheck()) { btnSub.Enabled = false; if (base.Request["ProId"] != null) { if (Request["allE_id"] != null) { if (ddlProState.Text != "已完工") { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('工程尚未完工,无法审核!');</script>"); txtName.Focus(); return; } } #region 获取单据基本信息 Tb_ProjectInv model = new Tb_ProjectInv(); model.UserId = Convert.ToInt32(DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text))); model.ProName = txtProName.Text; model.CreateTime = Convert.ToDateTime(txtCreateTime.Text); model.State = ddlProState.Text; model.GuestId = Convert.ToInt32(ddlUser.SelectedValue); List <Tb_ProjectInvs> projectList = Session["ProInvs"] as List <Tb_ProjectInvs>; #endregion if (Request["allE_id"] == null)//单据增加 { VAN_OA.Model.EFrom.tb_EForm eform = new tb_EForm(); int userId = Convert.ToInt32(DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text))); eform.appPer = userId; eform.appTime = DateTime.Now; eform.createPer = Convert.ToInt32(Session["currentUserId"].ToString()); eform.createTime = DateTime.Now; eform.proId = Convert.ToInt32(Request["ProId"]); eform.E_Remark = txtProName.Text; if (ddlPers.Visible == false) { eform.state = "通过"; eform.toPer = 0; eform.toProsId = 0; } else { eform.state = "执行中"; eform.toPer = Convert.ToInt32(ddlPers.SelectedItem.Value); eform.toProsId = Convert.ToInt32(ViewState["ids"]); } Tb_ProjectInvService proMainSer = new Tb_ProjectInvService(); if (proMainSer.addTran(model, eform, projectList) > 0) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交成功!');</script>"); if (Session["backurl"] != null) { base.Response.Redirect("~" + Session["backurl"]); } else { base.Response.Redirect("~/EFrom/MyRequestEForms.aspx"); } } else { btnSub.Enabled = false; base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交失败!');</script>"); } } else//审核 { #region 本单据的ID model.Id = Convert.ToInt32(Request["allE_id"]); #endregion tb_EForm eform = new tb_EForm(); tb_EForms forms = new tb_EForms(); eform.id = Convert.ToInt32(Request["EForm_Id"]); eform.proId = Convert.ToInt32(Request["ProId"]); eform.allE_id = Convert.ToInt32(Request["allE_id"]); int userId = Convert.ToInt32(DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text))); eform.appPer = userId; eform.E_Remark = txtProName.Text; tb_EFormService fromSer = new tb_EFormService(); if (ViewState["ifConsignor"] != null && Convert.ToBoolean(ViewState["ifConsignor"]) == true) { forms.audPer = fromSer.getCurrentAuPer(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])); forms.consignor = Convert.ToInt32(Session["currentUserId"]); } else { forms.audPer = Convert.ToInt32(Session["currentUserId"]); forms.consignor = 0; } forms.doTime = DateTime.Now; forms.e_Id = Convert.ToInt32(Request["EForm_Id"]); //fromSer.getCurrentid(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])); forms.idea = txtResultRemark.Text; forms.prosIds = fromSer.getCurrenttoProsId(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])); forms.resultState = ddlResult.Text; forms.RoleName = fromSer.getCurrenttoRoleName(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])); if (ddlPers.Visible == false)//说明为最后一次审核 { eform.state = ddlResult.Text; eform.toPer = 0; eform.toProsId = 0; } else { if (ddlResult.Text == "不通过") { eform.state = ddlResult.Text; eform.toPer = 0; eform.toProsId = 0; } else { eform.state = "执行中"; eform.toPer = Convert.ToInt32(ddlPers.SelectedItem.Value); eform.toProsId = Convert.ToInt32(ViewState["ids"]); } } string IDS = ViewState["ProInvsIds"].ToString(); Tb_ProjectInvService proMainSer = new Tb_ProjectInvService(); if (proMainSer.updateTran(model, eform, forms, projectList, IDS)) { // btnSub.Enabled = true; base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交成功!');</script>"); if (Session["backurl"] != null) { base.Response.Redirect("~" + Session["backurl"]); } else { base.Response.Redirect("~/EFrom/MyRequestEForms.aspx"); } } else { btnSub.Enabled = false; base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交失败!');</script>"); } } } } }