public int AddCAI_OrderCheck(int id) { CAI_OrderCheck order = new CAI_OrderCheck(); order.CreatePer = 1; order.CheckPer = 1; order.CheckTime = DateTime.Now; order.CheckRemark = "库存初始化"; VAN_OA.Model.EFrom.tb_EForm eform = new tb_EForm(); int userId = 1; eform.appPer = userId; eform.appTime = DateTime.Now; eform.createPer = 1; eform.createTime = DateTime.Now; eform.proId = 21; eform.state = "不通过"; eform.toPer = 0; eform.toProsId = 0; CAI_POCaiService POSer = new CAI_POCaiService(); List <CAI_POCaiView> modelList = POSer.GetListViewCai_POOrders_Cai_POOrderChecks_View(" id=" + id); List <CAI_OrderChecks> POOrders = new List <CAI_OrderChecks>(); foreach (var model in modelList) { CAI_OrderChecks checkModel = new CAI_OrderChecks(); checkModel.Total = model.Total; checkModel.CaiId = model.POCaiId; checkModel.CheckGoodId = model.GoodId; checkModel.CheckNum = model.Num; checkModel.CheckPrice = model.Price; checkModel.Good_Model = model.Good_Model; checkModel.GoodName = model.GoodName; checkModel.GoodNo = model.GoodNo; checkModel.GoodSpec = model.GoodSpec; checkModel.GoodTypeSmName = model.GoodTypeSmName; checkModel.GoodUnit = model.GoodUnit; checkModel.GuestName = model.GuestName; checkModel.POName = model.POName; checkModel.PONo = model.PONo; checkModel.SupplierName = model.Supplier; checkModel.CaiProNo = model.ProNo; checkModel.QingGou = model.CaiGou; checkModel.CaiGouPer = model.loginName; checkModel.CheckLastTruePrice = model.LastTruePrice; checkModel.GoodAreaNumber = model.GoodAreaNumber; POOrders.Add(checkModel); } CAI_OrderCheckService POOrderSer = new CAI_OrderCheckService(); int MainId = 0; return(POOrderSer.addTran(order, eform, POOrders, out MainId)); }
private void LastUpdate(int id) { CAI_OrderInHousesService ordersSer = new CAI_OrderInHousesService(); List <CAI_OrderInHouses> orders = ordersSer.GetListArray(" 1=1 and CAI_OrderInHouses.id=1"); CAI_OrderChecksService ordersSer111 = new CAI_OrderChecksService(); List <CAI_OrderChecks> orders1111 = ordersSer111.GetListArray(" 1=1 and CAI_OrderChecks.CheckId=" + id); CAI_OrderCheckService mainSer = new CAI_OrderCheckService(); CAI_OrderCheck pp = mainSer.GetModel(id); DBHelp.ExeCommand(string.Format(@" update CAI_OrderInHouse SET ChcEkProNo='{0}',pono='{1}',poname='{2}' where id=1; update CAI_OrderOutHouse set pono='{1}',poname='{2}' where ChcEkProNo='20120000'; update CAI_OrderCheck set status='通过' where id={3} ;update tb_EForm set state='通过',e_LastTime=getdate() where allE_id={3} and proId=21;", pp.ProNo, orders1111[0].PONo, orders1111[0].POName, id)); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlTransaction tan = conn.BeginTransaction(); SqlCommand objCommand = conn.CreateCommand(); objCommand.Transaction = tan; CAI_POCaiService CaiSer = new CAI_POCaiService(); try { objCommand.Parameters.Clear(); foreach (var caiIn in orders) { var check = orders1111.Single(t => t.CheckGoodId == caiIn.GooId); string sql = string.Format(" update CAI_OrderInHouses set OrderCheckIds={1} where ids={0}", caiIn.Ids, check.Ids); objCommand.CommandText = sql; objCommand.ExecuteNonQuery(); } tan.Commit(); } catch (Exception) { tan.Rollback(); } } }
protected void gvMain_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='';"); CAI_OrderCheck model = e.Row.DataItem as CAI_OrderCheck; System.Web.UI.WebControls.Label lblIsHanShui = e.Row.FindControl("lblIsHanShui") as System.Web.UI.WebControls.Label; if (lblIsHanShui != null) { lblIsHanShui.Text = model.IsHanShui == 1 ? "含税" : "不含税"; } if (model.IsHanShui == 0) { e.Row.BackColor = System.Drawing.Color.LightGray; } if (model.Status != "通过" || !idsList.Contains(model.Id.ToString())) { System.Web.UI.WebControls.LinkButton lbtnDoSupplierInvoice = e.Row.FindControl("lbtnDoSupplierInvoice") as System.Web.UI.WebControls.LinkButton; lbtnDoSupplierInvoice.Visible = false; } } }
protected void Button1_Click(object sender, EventArgs e) { if (FormCheck()) { btnSub.Enabled = false; if (base.Request["ProId"] != null) { #region 获取单据基本信息 CAI_OrderCheck order = new CAI_OrderCheck(); int CreatePer = Convert.ToInt32(DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtName.Text))); order.CreatePer = CreatePer; order.CheckPer = Convert.ToInt32(DBHelp.ExeScalar(string.Format("select ID from tb_User where loginName='{0}'", txtCheckPer.Text))); order.CheckTime = Convert.ToDateTime(txtCheckTime.Text); order.CheckRemark = txtCheckRemark.Text; List <CAI_OrderChecks> POOrders = Session["Orders"] as List <CAI_OrderChecks>; #endregion if (Request["allE_id"] == null)//单据增加+//再次编辑) { VAN_OA.Model.EFrom.tb_EForm eform = new tb_EForm(); int userId = CreatePer; 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"]); } int MainId = 0; CAI_OrderCheckService POOrderSer = new CAI_OrderCheckService(); if (POOrderSer.addTran(order, eform, POOrders, out MainId) > 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 order.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 = CreatePer; 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 (fromSer.ifAudiPerAndCon(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"])) == false) { if (Session["backurl"] != null) { base.Response.Redirect("~" + Session["backurl"]); } 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 (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"]); } } CAI_OrderCheckService POOrderSer = new CAI_OrderCheckService(); string IDS = ViewState["POOrdersIds"].ToString(); order.ProNo = lblProNo.Text; if (POOrderSer.updateTran(order, eform, forms, POOrders, IDS)) { if (ddlPers.Visible == false && ddlResult.SelectedItem.Text == "通过") { string checkIds = ""; string caiIds = ""; foreach (var model in POOrders) { checkIds += model.Ids + ","; caiIds += model.CaiId + ","; } if (checkIds.Length > 0) { checkIds = checkIds.Substring(0, checkIds.Length - 1); caiIds = caiIds.Substring(0, caiIds.Length - 1); } new TB_SupplierInvoiceService().AddSupplierInvoice(checkIds, caiIds, Session["LoginName"].ToString(), Convert.ToInt32(Session["currentUserId"].ToString()), POOrders[0].SupplierName); try { //更新库存价格字段 string sql = string.Format("update UPDATE_CAIINHOUSE_PRICE set TempHousePrice=isnull(GoodAvgPrice,0) where id={0}", order.Id); DBHelp.ExeCommand(sql); } catch (Exception) { } } 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>"); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { if (Session["LoginName"].ToString() != "admin") { Button1.Visible = false; } //请假单子 Session["Orders"] = null; lbtnAddFiles.Visible = false; gvList.Columns[0].Visible = false; gvList.Columns[12].Visible = false; //gvList.Columns[1].Visible = false; if (base.Request["ProId"] != null) { //加载基本数据 VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User; txtName.Text = use.LoginName; txtCheckTime.Text = DateTime.Now.ToString(); tb_EFormService eformSer = new tb_EFormService(); if (Request["allE_id"] == null)//单据增加 { //权限1(销售) lbtnAddFiles.Visible = true; gvList.Columns[0].Visible = true; // gvList.Columns[1].Visible = true; gvList.Columns[12].Visible = true; gvList.Columns[13].Visible = false; //加载初始数据 List <CAI_OrderChecks> orders = new List <CAI_OrderChecks>(); Session["Orders"] = orders; ViewState["OrdersCount"] = orders.Count; gvList.DataSource = orders; gvList.DataBind(); //检查自己是否在请假单中流程设置中,来确定自己下一个审批人 lblResult.Visible = false; lblYiJian.Visible = false; ddlResult.Visible = false; txtResultRemark.Visible = false; if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"]))) { //获取审批人 int pro_IDs = 0; int ids = 0; List <A_Role_User> roleUserList = eformSer.getFristNodeUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids); ViewState["ids"] = ids; if (roleUserList != null) { ddlPers.DataSource = roleUserList; ddlPers.DataBind(); ddlPers.DataTextField = "UserName"; ddlPers.DataValueField = "UserId"; } else { lblPer.Visible = false; ddlPers.Visible = false; } } else { lblPer.Visible = false; ddlPers.Visible = false; } } else//单据审批 { ViewState["POOrdersIds"] = ""; //加载已经审批的数据 tb_EFormsService eformsSer = new tb_EFormsService(); List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})", Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))); if (eforms.Count > 0) { string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>"; for (int i = 0; i < eforms.Count; i++) { string per = ""; if (eforms[i].consignor != null && eforms[i].consignor != 0) { per = eforms[i].Consignor_Name + "(委托人:" + eforms[i].Audper_Name + ")"; } else { per = eforms[i].Audper_Name; } mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}:{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见:{5}</td></tr>", i + 1, eforms[i].RoleName , per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea); } mess += "</table>"; lblMess.Text = mess; } ViewState["EformsCount"] = eforms.Count; #region 加载 请假单数据 CAI_OrderCheckService mainSer = new CAI_OrderCheckService(); CAI_OrderCheck pp = mainSer.GetModel(Convert.ToInt32(Request["allE_id"])); txtName.Text = pp.CreateName; txtCheckPer.Text = pp.CheckUserName; txtCheckTime.Text = pp.CheckTime.ToString(); txtCheckRemark.Text = pp.CheckRemark; if (pp.ProNo != null) { lblProNo.Text = pp.ProNo; } CAI_OrderChecksService ordersSer = new CAI_OrderChecksService(); List <CAI_OrderChecks> orders = ordersSer.GetListArray(" 1=1 and CAI_OrderChecks.CheckId=" + Request["allE_id"]); Session["Orders"] = orders; ViewState["OrdersCount"] = orders.Count; gvList.DataSource = orders; gvList.DataBind(); #endregion //判断单据是否已经结束 if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { btnSub.Visible = false; lblPer.Visible = false; ddlPers.Visible = false; lblResult.Visible = false; lblYiJian.Visible = false; ddlResult.Visible = false; txtResultRemark.Visible = false; setEnable(false); } else { //是否为审核人 if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { lblPer.Visible = false; ddlPers.Visible = false; } else { int ids = 0; List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids); ViewState["ids"] = ids; if (roleUserList != null) { ddlPers.DataSource = roleUserList; ddlPers.DataBind(); ddlPers.DataTextField = "UserName"; ddlPers.DataValueField = "UserId"; } } setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))); gvList.Columns[12].Visible = true; } else { //是否为代理人 if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { ViewState["ifConsignor"] = true; if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { lblPer.Visible = false; ddlPers.Visible = false; } else { int ids = 0; List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids); ViewState["ids"] = ids; if (roleUserList != null) { ddlPers.DataSource = roleUserList; ddlPers.DataBind(); ddlPers.DataTextField = "UserName"; ddlPers.DataValueField = "UserId"; } } setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))); gvList.Columns[12].Visible = true; } else { btnSub.Visible = false; lblPer.Visible = false; ddlPers.Visible = false; lblResult.Visible = false; lblYiJian.Visible = false; ddlResult.Visible = false; txtResultRemark.Visible = false; setEnable(false); } } } } } } }