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