protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); //绑定dd7 ,条件字段 ZWL.Common.PublicMethod.BindDDL(this.DropDownList7, ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 TiaoJianList from ERPForm where FormName='" + ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 FormName from ERPWorkFlow where ID=" + Request.QueryString["WorkFlowID"].ToString()) + "'")); ZWL.BLL.ERPWorkFlowJieDian Model = new ZWL.BLL.ERPWorkFlowJieDian(); Model.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.DropDownList3.SelectedValue = Model.IFDelFile; this.DropDownList2.SelectedValue = Model.IFEditFile; this.DropDownList4.SelectedValue = Model.JieDianAddr; this.TextBox2.Text = Model.JieDianName; this.TextBox1.Text = Model.JieDianSerils; this.TextBox5.Text = Model.JieShuHours.ToString(); this.TextBox6.Text = Model.JingBanRenYuanList; this.TextBox3.Text = Model.NextJieDianSerils; this.DropDownList1.SelectedValue = Model.PingShenMoShi; this.DropDownList5.SelectedValue = Model.ShengPiUserSetting; ZWL.Common.PublicMethod.SetSessionValue("TiaoJiaoList", Model.TiaoJianTiaoZhuan); ZWL.Common.PublicMethod.BindDDL(this.DropDownList6, ZWL.Common.PublicMethod.GetSessionValue("TiaoJiaoList")); } }
public void DataBindToGridview() { ZWL.BLL.ERPWorkFlowJieDian MyModel = new ZWL.BLL.ERPWorkFlowJieDian(); GVData.DataSource = MyModel.GetList("WorkFlowID=" + Request.QueryString["ID"].ToString() + " order by JieDianSerils asc"); GVData.DataBind(); LabPageSum.Text = Convert.ToString(GVData.PageCount); LabCurrentPage.Text = Convert.ToString(((int)GVData.PageIndex + 1)); this.GoPage.Text = LabCurrentPage.Text.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); //设置上传的附件为空 ZWL.Common.PublicMethod.SetSessionValue("WenJianList", ""); try { //绑定所有表单 限制使用人 ZWL.DBUtility.DbHelperSQL.BindDropDownList("select distinct FormName from ERPWorkFlow where FormName in(select FormName from ERPForm where ShiYongUserList='' or ','+ShiYongUserList+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%') order by FormName asc", this.DropDownList1, "FormName", "FormName"); //获取表单内容 GetFormContent(this.DropDownList1.SelectedItem.Text); //绑定该表单下的所有工作流 限制使用人 ZWL.DBUtility.DbHelperSQL.BindDropDownList("select ID,WorkFlowName from ERPWorkFlow where (UserList='' and FormName='" + this.DropDownList1.SelectedItem.Text + "') or (','+UserList+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' and FormName='" + this.DropDownList1.SelectedItem.Text + "') order by WorkFlowName asc", this.DropDownList2, "WorkFlowName", "ID"); //绑定工作名称 this.TextBox1.Text = ZWL.Common.PublicMethod.GetSessionValue("UserName") + "--" + this.DropDownList2.SelectedItem.Text + "(" + DateTime.Now.ToShortDateString() + ")"; //绑定下一节点 string[] NextStrList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NextJieDianSerils from ERPWorkFlowJieDian where WorkFlowID=" + this.DropDownList2.SelectedItem.Value.ToString() + " and JieDianAddr='开始'").Split(','); for (int i = 0; i < NextStrList.Length; i++) { ListItem MyItem = new ListItem(); MyItem.Value = ZWL.DBUtility.DbHelperSQL.GetSHSL("select ID from ERPWorkFlowJieDian where JieDianSerils='" + NextStrList[i].ToString() + "' and WorkFlowID=" + this.DropDownList2.SelectedItem.Value.ToString());//根据序号和workflowID获得节点ID MyItem.Text = "节点序号:" + NextStrList[i].ToString() + "--节点名称:" + ZWL.DBUtility.DbHelperSQL.GetSHSL("select JieDianName from ERPWorkFlowJieDian where JieDianSerils='" + NextStrList[i].ToString() + "' and WorkFlowID=" + this.DropDownList2.SelectedItem.Value.ToString()); if (MyItem.Value.ToString().Length > 0) { this.DropDownList3.Items.Add(MyItem); } } //根据选择的节点,绑定人员等信息。 ZWL.BLL.ERPWorkFlowJieDian MyJieDian = new ZWL.BLL.ERPWorkFlowJieDian(); MyJieDian.GetModel(int.Parse(this.DropDownList3.SelectedItem.Value.ToString())); this.Label2.Text = MyJieDian.PingShenMoShi + " " + MyJieDian.ShengPiUserSetting; this.Label3.Text = MyJieDian.JingBanRenYuanList; this.TextBox5.Text = MyJieDian.JingBanRenYuanList; //设定选择审批人员是自由指定还是定向指定 if (MyJieDian.ShengPiUserSetting == "审批时自由指定") { this.TextBox2.Text = ""; } else { this.TextBox2.Text = this.DropDownList3.SelectedItem.Value.ToString(); } } catch { } } }
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { this.DropDownList3.Items.Clear(); //绑定工作名称 this.TextBox1.Text = ZWL.Common.PublicMethod.GetSessionValue("UserName") + "--" + this.DropDownList2.SelectedItem.Text + "(" + DateTime.Now.ToShortDateString() + ")"; try { //绑定下一节点 string[] NextStrList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NextJieDianSerils from ERPWorkFlowJieDian where WorkFlowID=" + this.DropDownList2.SelectedItem.Value.ToString() + " and JieDianAddr='开始'").Split(','); for (int i = 0; i < NextStrList.Length; i++) { ListItem MyItem = new ListItem(); MyItem.Value = ZWL.DBUtility.DbHelperSQL.GetSHSL("select ID from ERPWorkFlowJieDian where JieDianSerils='" + NextStrList[i].ToString() + "' and WorkFlowID=" + this.DropDownList2.SelectedItem.Value.ToString());//根据序号和workflowID获得节点ID MyItem.Text = "节点序号:" + NextStrList[i].ToString() + "--节点名称:" + ZWL.DBUtility.DbHelperSQL.GetSHSL("select JieDianName from ERPWorkFlowJieDian where JieDianSerils='" + NextStrList[i].ToString() + "' and WorkFlowID=" + this.DropDownList2.SelectedItem.Value.ToString()); if (MyItem.Value.ToString().Length > 0) { this.DropDownList3.Items.Add(MyItem); } } //根据选择的节点,绑定人员等信息。 ZWL.BLL.ERPWorkFlowJieDian MyJieDian = new ZWL.BLL.ERPWorkFlowJieDian(); MyJieDian.GetModel(int.Parse(this.DropDownList3.SelectedItem.Value.ToString())); this.Label2.Text = MyJieDian.PingShenMoShi + " " + MyJieDian.ShengPiUserSetting; this.Label3.Text = MyJieDian.JingBanRenYuanList; this.TextBox5.Text = MyJieDian.JingBanRenYuanList; //设定选择审批人员是自由指定还是定向指定 if (MyJieDian.ShengPiUserSetting == "审批时自由指定") { this.TextBox2.Text = ""; } else { this.TextBox2.Text = this.DropDownList3.SelectedItem.Value.ToString(); } } catch { } }
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e) { try { //根据选择的节点,绑定人员等信息。 ZWL.BLL.ERPWorkFlowJieDian MyJieDian = new ZWL.BLL.ERPWorkFlowJieDian(); MyJieDian.GetModel(int.Parse(this.DropDownList3.SelectedItem.Value.ToString())); this.Label2.Text = MyJieDian.PingShenMoShi + " " + MyJieDian.ShengPiUserSetting; this.Label3.Text = MyJieDian.JingBanRenYuanList; this.TextBox5.Text = MyJieDian.JingBanRenYuanList; //设定选择审批人员是自由指定还是定向指定 if (MyJieDian.ShengPiUserSetting == "审批时自由指定") { this.TextBox2.Text = ""; } else { this.TextBox2.Text = this.DropDownList3.SelectedItem.Value.ToString(); } } catch { } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { //判断开始、结束两个节点的唯一性,中间节点必须指定下一节点 if (this.DropDownList4.SelectedItem.Text == "开始") { string ExsistID = ZWL.DBUtility.DbHelperSQL.GetSHSL("select ID from ERPWorkFlowJieDian where WorkFlowID=" + Request.QueryString["WorkFlowID"].ToString() + " and JieDianAddr='开始' and ID!=" + Request.QueryString["ID"].ToString()); if (ExsistID.Trim().Length > 0) { ZWL.Common.MessageBox.Show(this, "该流程已经存在“开始”节点,请不要重复添加!"); return; } } if (this.DropDownList4.SelectedItem.Text == "结束") { string ExsistID = ZWL.DBUtility.DbHelperSQL.GetSHSL("select ID from ERPWorkFlowJieDian where WorkFlowID=" + Request.QueryString["WorkFlowID"].ToString() + " and JieDianAddr='结束' and ID!=" + Request.QueryString["ID"].ToString()); if (ExsistID.Trim().Length > 0) { ZWL.Common.MessageBox.Show(this, "该流程已经存在“结束”节点,请不要重复添加!"); return; } } if (this.DropDownList4.SelectedItem.Text == "中间段" || this.DropDownList4.SelectedItem.Text == "开始") { string ExsistID = this.TextBox3.Text.Trim(); if (ExsistID.Trim().Length <= 0) { ZWL.Common.MessageBox.Show(this, "中间段和开始节点必须指定下一节点序号!"); return; } } //判断节点序号的唯一性 string NodeSerils = ZWL.DBUtility.DbHelperSQL.GetSHSL("select ID from ERPWorkFlowJieDian where WorkFlowID=" + Request.QueryString["WorkFlowID"].ToString() + " and JieDianSerils='" + this.TextBox1.Text + "' and ID!=" + Request.QueryString["ID"].ToString()); if (NodeSerils.Trim().Length > 0) { ZWL.Common.MessageBox.Show(this, "该节点序号已经存在,请不要重复添加!"); return; } ZWL.BLL.ERPWorkFlowJieDian Model = new ZWL.BLL.ERPWorkFlowJieDian(); Model.ID = int.Parse(Request.QueryString["ID"].ToString()); Model.IFDelFile = this.DropDownList3.SelectedItem.Text; Model.IFEditFile = this.DropDownList2.SelectedItem.Text; Model.JieDianAddr = this.DropDownList4.SelectedItem.Text; Model.JieDianName = this.TextBox2.Text; Model.JieDianSerils = this.TextBox1.Text; Model.JieShuHours = int.Parse(this.TextBox5.Text.Trim()); Model.JingBanRenYuanList = this.TextBox6.Text.Trim(); Model.NextJieDianSerils = this.TextBox3.Text.Trim(); Model.PingShenMoShi = this.DropDownList1.SelectedItem.Text; Model.ShengPiUserSetting = this.DropDownList5.SelectedItem.Text; Model.TiaoJianTiaoZhuan = ZWL.Common.PublicMethod.GetSessionValue("TiaoJiaoList"); Model.WorkFlowID = int.Parse(Request.QueryString["WorkFlowID"].ToString()); Model.Update(); //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户修改工作流程节点信息(" + this.TextBox2.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "工作流程节点修改成功!", "WorkFlowDesign.aspx?ID=" + Request.QueryString["WorkFlowID"].ToString()); }
protected void Page_Load(object sender, EventArgs e) { //该节点根据传过来的工作的ID信息,查询到使用的工作流、当前节点信息(全部通过往下流转、一个通过往下流转) //根据节点信息、该工作的通过人列表信息、审批人列表信息===>该节点是否应该继续往下流转 //如果要往下流转则显示页面上的下一节点设置信息,否则用程序跳转回待办事项页面。 //根据Type参数属性,Type为0时为正常下一节点,Type为1时为绑定所有节点供选择。 if (!Page.IsPostBack) { ZWL.BLL.ERPWorkToDo MyModel = new ZWL.BLL.ERPWorkToDo(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.Label1.Text = MyModel.WorkName; //判断 当前节点信息(全部通过往下流转、一个通过往下流转) 该工作的通过人列表信息、审批人列表信息 string SPMoShi = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 PingShenMoShi from ERPWorkFlowJieDian where ID=" + MyModel.JieDianID.ToString()); if (CheCkIfOk(MyModel.TongGuoRenList, MyModel.ShenPiRenList, SPMoShi) == true) { //绑定下一个节点 try { //绑定下一节点 正常状态 if (Request.QueryString["Type"].ToString().Trim() == "0") { string[] NextStrList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NextJieDianSerils from ERPWorkFlowJieDian where ID=" + MyModel.JieDianID.ToString()).Split(','); for (int i = 0; i < NextStrList.Length; i++) { ListItem MyItem = new ListItem(); MyItem.Value = ZWL.DBUtility.DbHelperSQL.GetSHSL("select ID from ERPWorkFlowJieDian where JieDianSerils='" + NextStrList[i].ToString() + "' and WorkFlowID=" + MyModel.WorkFlowID.ToString());//根据序号和workflowID获得节点ID MyItem.Text = "节点序号:" + NextStrList[i].ToString() + "--节点名称:" + ZWL.DBUtility.DbHelperSQL.GetSHSL("select JieDianName from ERPWorkFlowJieDian where JieDianSerils='" + NextStrList[i].ToString() + "' and WorkFlowID=" + MyModel.WorkFlowID.ToString()); if (MyItem.Value.ToString().Length > 0) { this.DropDownList3.Items.Add(MyItem); } } } else //绑定所有节点(除开始节点) { //清除根据条件决定下一节点选项 this.CheckBox1.Checked = false; this.CheckBox1.Enabled = false; DataSet MyDS = ZWL.DBUtility.DbHelperSQL.GetDataSet("select ID,JieDianSerils,JieDianName from ERPWorkFlowJieDian where JieDianAddr!='开始' and WorkFlowID=" + MyModel.WorkFlowID.ToString()); for (int jjj = 0; jjj < MyDS.Tables[0].Rows.Count; jjj++) { ListItem MyItem = new ListItem(); MyItem.Value = MyDS.Tables[0].Rows[jjj]["ID"].ToString(); MyItem.Text = "节点序号:" + MyDS.Tables[0].Rows[jjj]["JieDianSerils"].ToString() + "--节点名称:" + MyDS.Tables[0].Rows[jjj]["JieDianName"].ToString(); if (MyItem.Value.ToString().Length > 0) { this.DropDownList3.Items.Add(MyItem); } } } //根据选择的节点,绑定人员等信息。 ZWL.BLL.ERPWorkFlowJieDian MyJieDian = new ZWL.BLL.ERPWorkFlowJieDian(); MyJieDian.GetModel(int.Parse(this.DropDownList3.SelectedItem.Value.ToString())); this.Label2.Text = MyJieDian.PingShenMoShi + " " + MyJieDian.ShengPiUserSetting; this.Label3.Text = MyJieDian.JingBanRenYuanList; this.TextBox5.Text = MyJieDian.JingBanRenYuanList; //设定选择审批人员是自由指定还是定向指定 if (MyJieDian.ShengPiUserSetting == "审批时自由指定") { this.TextBox2.Text = ""; } else { this.TextBox2.Text = this.DropDownList3.SelectedItem.Value.ToString(); } } catch { } } else { ZWL.Common.MessageBox.ShowAndRedirect(this, "该节点工作需要等待其他人办理后才能继续往下流转,请继续等待!", "NowWorkFlow.aspx"); } } }