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