public int addTran(TB_Good model, VAN_OA.Model.EFrom.tb_EForm eform)
{
int id = 0;
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
tb_EFormService eformSer = new tb_EFormService();
string proNo = eformSer.GetAllE_No("TB_Good", "GoodProNo", objCommand);
model.ProNo = proNo;
eform.E_No = proNo;
id = Add(model, objCommand);
eform.allE_id = id;
eformSer.Add(eform, objCommand);
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(0);
}
return(id);
}
}
public bool updateTran(TB_Good model, VAN_OA.Model.EFrom.tb_EForm eform, tb_EForms forms)
{
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlTransaction tan = conn.BeginTransaction();
SqlCommand objCommand = conn.CreateCommand();
objCommand.Transaction = tan;
try
{
objCommand.Parameters.Clear();
model.Status = eform.state;
Update(model, objCommand);
tb_EFormService eformSer = new tb_EFormService();
eformSer.Update(eform, objCommand);
tb_EFormsService eformsSer = new tb_EFormsService();
eformsSer.Add(forms, objCommand);
tan.Commit();
}
catch (Exception)
{
tan.Rollback();
return(false);
}
}
return(true);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
if (this.FormCheck())
{
try
{
string sqlCheck = string.Format("select count(*) from TB_Good where GoodName='{0}' and GoodModel='{1}' and GoodSpec='{2}' and GoodTypeSmName='{4}' and GoodBrand='{5}' and GoodId<>{3}",
txtGoodName.Text, txtModel.Text, txtSpec.Text, Request["Id"], ddlGoodSmType.Text, txtGoodBrand.Text);
if (Convert.ToInt32(DBHelp.ExeScalar(sqlCheck)) > 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, string.Format("<script>alert('名称[{0}],规格[{1}],型号[{2}],已经存在！');</script>", txtGoodName.Text, txtSpec.Text, txtModel.Text));
return;
}
TB_Good model = getModel();
if (this.goodSer.Update(model))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改成功！');</script>");
}
else
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('修改失败！');</script>");
}
}
catch (Exception ex)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('" + ex.Message + "！');</script>");
}
}
}
private void ShowInfo(int Id)
{
TB_Good model = goodSer.GetModel(Id);
txtGoodName.Text = model.GoodName;
txtGoodNo.Text = model.GoodNo;
txtModel.Text = model.GoodModel;
txtSpec.Text = model.GoodSpec;
txtUnit.Text = model.GoodUnit;
txtZhuJi.Text = model.ZhuJi;
cbSpec.Checked = model.IfSpec;
txtGoodBrand.Text = model.GoodBrand;
lblProNo.Text = model.ProNo;
txtProduct.Text = model.Product;
ddlArea.Text = model.GoodArea;
ddlCol.Text = model.GoodCol;
ddlRow.Text = model.GoodRow;
ddlNumber.Text = model.GoodNumber;
if (model.GoodTypeName != null)
{
ddlGoodType.SelectedValue = model.GoodTypeName.ToString();
TB_GoodsSmTypeService goodsSmTypeSer = new TB_GoodsSmTypeService();
List <TB_GoodsSmType> goodsSmTypeList = goodsSmTypeSer.GetListArray(" 1=1 and GoodTypeName='" + model.GoodTypeName + "'");
ddlGoodSmType.DataSource = goodsSmTypeList;
ddlGoodSmType.DataBind();
ddlGoodSmType.DataTextField = "GoodTypeSmName";
ddlGoodSmType.DataValueField = "GoodTypeSmName";
}
if (model.GoodTypeSmName != null)
{
ddlGoodSmType.Text = model.GoodTypeSmName.ToString();
}
}
protected void gvList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#EAF1FD',this.style.fontWeight='';");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';");
TB_Good model = e.Row.DataItem as TB_Good;
if (model.GoodNum > model.SumKuXuCai)
{
e.Row.BackColor = ColorTranslator.FromHtml("#FFF0F5");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (FormCheck())
{
btnSub.Enabled = false;
if (base.Request["ProId"] != null)
{
#region 获取单据基本信息
TB_Good model = getModel();
#endregion
int CreateUser = Convert.ToInt32(Session["currentUserId"]);
if (Request["allE_id"] == null)//单据增加
{
VAN_OA.Model.EFrom.tb_EForm eform = new tb_EForm();
int userId = CreateUser;
eform.appPer = userId;
eform.appTime = DateTime.Now;
eform.createPer = Convert.ToInt32(Session["currentUserId"].ToString());
eform.createTime = DateTime.Now;
eform.proId = Convert.ToInt32(Request["ProId"]);
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"]);
}
if (goodSer.addTran(model, eform) > 0)
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交成功！');</script>");
if (Session["backurl1"] != null)
{
base.Response.Redirect("~" + Session["backurl1"]);
}
else
{
base.Response.Redirect("~/EFrom/MyRequestEForms.aspx");
}
}
else
{
btnSub.Enabled = false;
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交失败！');</script>");
}
}
else//审核
{
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 = CreateUser;// Convert.ToInt32(DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text)));
eform.appPer = userId;
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;
}
if (Request["ReAudit"] == null)
{
if (fromSer.ifAudiPerAndCon(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])) == false)
{
if (Session["backurl1"] != null)
{
base.Response.Redirect("~" + Session["backurl1"]);
}
else
{
base.Response.Redirect("~/EFrom/MyRequestEForms.aspx");
}
return;
}
}
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 (Request["ReAudit"] != null)
{
forms.RoleName = "重新编辑";
}
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"]);
}
}
if (goodSer.updateTran(model, eform, forms))
{
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交成功！');</script>");
if (Session["backurl1"] != null)
{
base.Response.Redirect("~" + Session["backurl1"]);
}
else
{
base.Response.Redirect("~/EFrom/MyRequestEForms.aspx");
}
}
else
{
btnSub.Enabled = false;
base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交失败！');</script>");
}
}
}
}
}
