protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPWorkToDo MyModel = new ZWL.BLL.ERPWorkToDo(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.Label1.Text = MyModel.WorkName; this.Label2.Text = MyModel.JieDianName; this.Label3.Text = MyModel.FormContent; ZWL.Common.PublicMethod.SetSessionValue("WenJianList", MyModel.FuJianList); ZWL.Common.PublicMethod.BindDDL(this.CheckBoxList1, ZWL.Common.PublicMethod.GetSessionValue("WenJianList")); this.Label5.Text = MyModel.ShenPiYiJian; this.HyperLink1.NavigateUrl = "JustShowWorkFlow.aspx?ID=" + MyModel.WorkFlowID.ToString(); //绑定常用审批 ZWL.DBUtility.DbHelperSQL.BindDropDownList2("select ContentStr from ERPShenPi where UserName='******'", this.DropDownList1, "ContentStr", "ContentStr"); //根据节点属性判断是否可以编辑附件、删除附件 if (ZWL.DBUtility.DbHelperSQL.GetSHSL("select IFEditFile from ERPWorkFlowJieDian where ID=" + MyModel.JieDianID.ToString()) == "否") { this.ImageButton5.Visible = false; } if (ZWL.DBUtility.DbHelperSQL.GetSHSL("select IFDelFile from ERPWorkFlowJieDian where ID=" + MyModel.JieDianID.ToString()) == "否") { this.ImageButton3.Visible = false; } } }
public void DataBindToGridview() { GVData.PageSize = AspNetPager1.PageSize; GVData.PageIndex = AspNetPager1.CurrentPageIndex - 1; ZWL.BLL.ERPWorkToDo MyModel = new ZWL.BLL.ERPWorkToDo(); DataSet ds = MyModel.GetList("WorkName Like '%" + this.TextBox1.Text + "%' and FormName Like '%" + this.TextBox2.Text + "%' and UserName Like '%" + this.TextBox3.Text + "%' order by ID desc"); GVData.DataSource = ds; GVData.DataBind(); AspNetPager1.RecordCount = ds.Tables[0].Rows.Count; }
public void DataBindToGridview() { GVData.PageSize = AspNetPager1.PageSize; GVData.PageIndex = AspNetPager1.CurrentPageIndex - 1; ZWL.BLL.ERPWorkToDo MyModel = new ZWL.BLL.ERPWorkToDo(); DataSet ds = MyModel.GetList(" StateNow='正在办理' and ','+ShenPiRenList+',' like '%," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + ",%' and WorkName Like '%" + this.TextBox1.Text + "%' and FormName Like '%" + this.TextBox2.Text + "%' and UserName Like '%" + this.TextBox3.Text + "%' order by ID desc"); GVData.DataSource = ds; GVData.DataBind(); AspNetPager1.RecordCount = ds.Tables[0].Rows.Count; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ZWL.Common.PublicMethod.CheckSession(); ZWL.BLL.ERPWorkToDo MyModel = new ZWL.BLL.ERPWorkToDo(); MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); this.Label1.Text = MyModel.WorkName; this.Label2.Text = MyModel.JieDianName; this.Label3.Text = MyModel.FormContent; this.Label4.Text = ZWL.Common.PublicMethod.GetWenJian(MyModel.FuJianList, "../UploadFile/"); this.Label5.Text = MyModel.ShenPiYiJian; this.HyperLink1.NavigateUrl = "JustShowWorkFlow.aspx?ID=" + MyModel.WorkFlowID.ToString(); } }
protected void Button1_Click(object sender, EventArgs e) { //找到下一节点 string FileNameStr = ZWL.Common.PublicMethod.UploadFileIntoDir(this.FileUpload1, DateTime.Now.Ticks.ToString() + System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName)); if (FileNameStr.Trim().Length > 0) { string PiShiStr = "<font color=#0000FF>" + ZWL.Common.PublicMethod.GetSessionValue("UserName") + " " + DateTime.Now.ToString() + " </font><BR>" + this.TextBox1.Text.ToString() + "<br>审批附件:<a href=../UploadFile/" + FileNameStr + ">[右键下载]</a><hr>" + this.Label5.Text; ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',TongGuoRenList=TongGuoRenList+'," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + "',ShenPiYiJian='" + PiShiStr + "' where ID=" + Request.QueryString["ID"].ToString()); ZWL.BLL.ERPWorkToDo Mymodel = new ZWL.BLL.ERPWorkToDo(); Mymodel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); Mymodel.ID = int.Parse(Request.QueryString["ID"].ToString()); Mymodel.FormContent = this.TextBox3.Text; Mymodel.UpdateBD(); //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户审批工作信息(" + this.Label1.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); Response.Redirect("GoToNextNode.aspx?Type=0&ID=" + Request.QueryString["ID"].ToString()); } else if (FileUpload1.PostedFile.FileName.Trim().Length <= 0) { string PiShiStr = "<font color=#0000FF>" + ZWL.Common.PublicMethod.GetSessionValue("UserName") + " " + DateTime.Now.ToString() + " </font><BR>" + this.TextBox1.Text.ToString() + "<hr>" + this.Label5.Text; ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',TongGuoRenList=TongGuoRenList+'," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + "',ShenPiYiJian='" + PiShiStr + "' where ID=" + Request.QueryString["ID"].ToString()); ZWL.BLL.ERPWorkToDo Mymodel = new ZWL.BLL.ERPWorkToDo(); Mymodel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); Mymodel.ID = int.Parse(Request.QueryString["ID"].ToString()); Mymodel.FormContent = this.TextBox3.Text; Mymodel.UpdateBD(); //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户审批工作信息(" + this.Label1.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); Response.Redirect("GoToNextNode.aspx?Type=0&ID=" + Request.QueryString["ID"].ToString()); } }
protected void ImageButton1_Click(object sender, EventArgs e) { ZWL.BLL.ERPWorkToDo Model = new ZWL.BLL.ERPWorkToDo(); Model.FormContent = this.TextBox3.Text; Model.FormName = this.DropDownList1.SelectedItem.Text; Model.FuJianList = ZWL.Common.PublicMethod.GetSessionValue("WenJianList"); string JingBanRenStr = "";//条件判断时读取经办人 try { if (CheckBox1.Checked == true) { //条件未找到或者没有匹配项时,采用选择好的节点 Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString()); try { //根据条件跳转 //分析当前节点中的条件字段,如果有,则分析跳转的步骤,如存在,则跳转,否则,按照选择好的进行 //从开始节点中找到条件字段,如果找不到采用选定的,找到则,根据条件跳转 //格式如:请假天数[数字型]'大于'10→3|请假天数[数字型]'小于等于'10→2|请假部门[常规型]'等于'开发部→3|请假部门[常规型]'不等于'开发部→2 string[] TiaoJianList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select TiaoJianTiaoZhuan from ERPWorkFlowJieDian where WorkFlowID=" + this.DropDownList2.SelectedItem.Value.ToString() + " and JieDianAddr='开始'").Split('|'); for (int i = 0; i < TiaoJianList.Length; i++) { string NextIDStr = CheckTiaoJian(this.TextBox3.Text, TiaoJianList[i].ToString(), this.DropDownList2.SelectedItem.Value.ToString()); if (NextIDStr != "0") { Model.JieDianID = int.Parse(NextIDStr); JingBanRenStr = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 JingBanRenYuanList from ERPWorkFlowJieDian where ID=" + NextIDStr); break; //跳出当前循环 } } } catch { Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString()); } } else { Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString()); } Model.StateNow = "正在办理"; Model.JieDianName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select JieDianName from ERPWorkFlowJieDian where ID=" + Model.JieDianID.ToString()); } catch { Model.StateNow = "强制结束"; Model.JieDianName = "结束"; } if (JingBanRenStr == "") { Model.ShenPiRenList = this.TextBox5.Text; } else { Model.ShenPiRenList = JingBanRenStr; } Model.ShenPiYiJian = ""; Model.TimeStr = DateTime.Now; Model.TongGuoRenList = ""; Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); Model.WorkFlowID = int.Parse(this.DropDownList2.SelectedItem.Value.ToString()); Model.WorkName = this.TextBox1.Text; Model.Add(); if (Model.StateNow == "正在办理") { //发送短信 SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的工作需要办理!(" + this.TextBox1.Text + ")", this.TextBox5.Text.Trim()); } else { SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您的工作已经被强制结束!(" + this.TextBox1.Text + ")", ZWL.Common.PublicMethod.GetSessionValue("UserName")); } //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户添加新工作信息(" + this.TextBox1.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "新工作添加成功!", "MyWorkFlow.aspx"); }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { //如果选择了下一节点,就必须指定审批人 if (this.DropDownList3.SelectedValue.Trim() != "") { if (this.TextBox5.Text.Trim().Length <= 0) { ZWL.Common.MessageBox.Show(this, "必须指定下一节点的审批人!"); return; } } ZWL.BLL.ERPWorkToDo XMyModel = new ZWL.BLL.ERPWorkToDo(); XMyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString())); //初始化 string XJieDianIDStr = "0"; string XJieDianNameStr = ""; string XShenPiRenListStr = ""; string XTongGuoRenListStr = ""; string XStateNowStr = "正在办理"; string JingBanRenStr = "";//条件判断时读取经办人 try { if (CheckBox1.Checked == true) { //条件未找到或者没有匹配项时,采用选择好的节点 XJieDianIDStr = this.DropDownList3.SelectedValue.ToString(); try { //根据条件跳转 //分析当前节点中的条件字段,如果有,则分析跳转的步骤,如存在,则跳转,否则,按照选择好的进行 //从开始节点中找到条件字段,如果找不到采用选定的,找到则,根据条件跳转 //格式如:请假天数[数字型]'大于'10→3|请假天数[数字型]'小于等于'10→2|请假部门[常规型]'等于'开发部→3|请假部门[常规型]'不等于'开发部→2 string[] TiaoJianList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select TiaoJianTiaoZhuan from ERPWorkFlowJieDian where ID=" + XMyModel.JieDianID.ToString()).Split('|'); for (int i = 0; i < TiaoJianList.Length; i++) { string NextIDStr = CheckTiaoJian(XMyModel.FormContent, TiaoJianList[i].ToString(), XMyModel.WorkFlowID.ToString()); if (NextIDStr != "0") { XJieDianIDStr = NextIDStr; JingBanRenStr = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 JingBanRenYuanList from ERPWorkFlowJieDian where ID=" + NextIDStr); break; //跳出当前循环 } } } catch { XJieDianIDStr = this.DropDownList3.SelectedValue.ToString(); } } else { XJieDianIDStr = this.DropDownList3.SelectedValue.ToString(); } XStateNowStr = "正在办理"; XJieDianNameStr = ZWL.DBUtility.DbHelperSQL.GetSHSL("select JieDianName from ERPWorkFlowJieDian where ID=" + XJieDianIDStr); } catch { if (ZWL.DBUtility.DbHelperSQL.GetSHSL("select JieDianAddr from ERPWorkFlowJieDian where ID=" + XMyModel.JieDianID.ToString()) == "结束") { XStateNowStr = "正常结束"; XJieDianIDStr = XMyModel.JieDianID.ToString(); } else { XStateNowStr = "强制结束"; XJieDianIDStr = XMyModel.JieDianID.ToString(); } XJieDianNameStr = "结束"; } if (JingBanRenStr == "") { XShenPiRenListStr = this.TextBox5.Text; } else { XShenPiRenListStr = JingBanRenStr; } XTongGuoRenListStr = ""; //执行uodate语句 ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPWorkToDo set LateTime=getdate(),JieDianID=" + XJieDianIDStr + ",JieDianName='" + XJieDianNameStr + "',ShenPiRenList='" + XShenPiRenListStr + "',TongGuoRenList='" + XTongGuoRenListStr + "',StateNow='" + XStateNowStr + "' where ID=" + Request.QueryString["ID"].ToString()); if (XStateNowStr == "正在办理") { //发送短信 SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的工作需要办理!(" + this.Label1.Text + ")", this.TextBox5.Text.Trim()); } else if (XStateNowStr == "正常结束") { SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您的工作已经正常结束!(" + this.Label1.Text + ")", XMyModel.UserName); } else { SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您的工作已经被强制结束!(" + this.Label1.Text + ")", XMyModel.UserName); } //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "用户办理工作(" + this.Label1.Text + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "工作办理成功!", "NowWorkFlow.aspx"); }
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"); } } }