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