protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//读取
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.Label3.Text = MyModel.FormContent;
//this.Label1.Text = MyModel.ShenPiYiJian;
//不改变字体颜色
this.Label3.Text = this.Label3.Text.Replace("disabled", "readonly").Replace("hidden", "visible");; //将所有的 disabled 去除掉，取消隐藏
this.Label3.Text = this.Label3.Text.Replace("1px solid", " 0px solid "); //将所有的底部线条去除掉
this.Label3.Text = this.Label3.Text.Replace("id=CHK", "style=\"position:absolute;clip: rect(6 17 17 6);background-color:#FFFFFF\" id=CHK"); //将CheckBox框的边框去掉
this.Label3.Text = this.Label3.Text.Replace("id=Drop", "style=\"width:150px;position:absolute;clip: rect(2 130 20 8);background-color:#FFFFFF\" id=Drop"); //将下拉框的边框去掉
this.Label3.Text = this.Label3.Text.Replace("#d8d8d8\" id=TextArea", "#d8d8d8;overflow-x:hidden;overflow-y:hidden;\" id=TextArea"); //将多行文本框的滚动条去除
//update by wzb 20130926
this.Label3.Text = this.Label3.Text.Replace("<TABLE", "<TABLE HEIGHT=1123");
//update by andyxin 20131011
this.Label3.Text = this.Label3.Text.Replace("style=mini", "style=none");
this.Label3.Text = this.Label3.Text.Replace("eWebEditor/ewebeditor.htm", "eWebEditorPrint/ewebeditor.htm");
}
}
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPNWorkToDo Model = new ZWL.BLL.ERPNWorkToDo();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
if (Model.ChaoSongUserList.ToString() != "")
{
Model.ChaoSongUserList = Model.ChaoSongUserList + "," + ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.txtChaoSong.Text.Trim());
}
else
{
Model.ChaoSongUserList = ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.txtChaoSong.Text.Trim());
}
Model.Update();
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的抄送工作！(" + Model.WorkName + ")", ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.txtChaoSong.Text.Trim()));
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户抄送工作信息(" + Model.WorkName + ")！被抄送用户为：" + this.txtChaoSong.Text.Trim();
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "抄送工作添加成功！", "SerchWorkFlow.aspx");
}
public string PiLiangSet = "";//批量设置字段的可写、保密属性
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPNWorkToDo Model = new ZWL.BLL.ERPNWorkToDo();
Model.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.lblWorkName.Text = Model.WorkName.ToString();
this.lblWenHao.Text = Model.WenHao.ToString();
//this.lblFormID.Text=Model.FormID.ToString();
//this.lblWorkFlowID.Text=Model.WorkFlowID.ToString();
this.lblUserName.Text = Model.UserName.ToString();
this.lblTimeStr.Text = Model.TimeStr.ToString();
this.lblFormContent.Text = Model.FormContent.ToString();
this.lblFuJianList.Text = ZWL.Common.PublicMethod.GetWenJian(Model.FuJianList.ToString(), "../UpLoadFile/");
this.lblShenPiYiJian.Text = Model.ShenPiYiJian.ToString();
//this.lblJieDianID.Text=Model.JieDianID.ToString();
this.lblJieDianName.Text = "<a href=\"NWorkFlowReView.aspx?WorkFlowID=" + Model.WorkFlowID.ToString() + "&FormID=" + Model.FormID.ToString() + "\" target=\"_blank\">" + Model.JieDianName.ToString() + "</a>";
this.lblShenPiUserList.Text = Model.ShenPiUserList.ToString();
this.lblOKUserList.Text = Model.OKUserList.ToString();
this.lblStateNow.Text = Model.StateNow.ToString();
this.lblLateTime.Text = Model.LateTime.ToString();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户查看工作管理信息(" + this.lblWorkName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
SetNodeInfoAndSet();
}
}
public string PiLiangSet = "";//批量设置字段的可写、保密属性
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
// this.Label1.Text = MyModel.WorkName;
this.Label2.Text = MyModel.JieDianName;
this.TextBox3.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 = "NWorkFlowReView.aspx?WorkFlowID=" + MyModel.WorkFlowID.ToString();
//绑定常用审批
ZWL.DBUtility.DbHelperSQL.BindDropDownList2("select ContentStr from ERPShenPi where UserName='******'", this.DropDownList1, "ContentStr", "ContentStr");
SetNodeInfoAndSet();
}
//刷新界面后，将label1赋值
this.Label3.Text = this.TextBox3.Text;
}
/// <summary>
/// 判断条件，返回下一节点ID
/// </summary>
/// <param name="FormCcontent"></param>
/// <param name="TiaoJianStr"></param>
/// <param name="WorkFlowIDStr"></param>
/// <returns></returns>
protected string CheckTiaoJian(string TiaoJianStr)
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//条件格式如：ABCD_请假天数→大于→10→3
string ZiDuanStrEN = TiaoJianStr.Split('_')[0]; //字段名称EN 如：ABCD
string ZiDuanStrCN = TiaoJianStr.Split('_')[1]; //字段名称CN 如：请假天数
string BiJiaoStr = TiaoJianStr.Split('→')[1]; //条件比较 如：大于
string ZhiStr = TiaoJianStr.Split('→')[2]; //比较的值，如： 10
string JieDianXuHaoStr = TiaoJianStr.Split('→')[3]; //跳转的节点序号，如： 3
string NowValue = "";
try
{
NowValue = Request.Form[ZiDuanStrEN].ToString();
}
catch
{ }
if (BiaoJiaoTwoStr(NowValue, ZhiStr, BiJiaoStr) == true)
{
return(ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 ID from ERPNWorkFlowNode where NodeSerils='" + JieDianXuHaoStr + "' and WorkFlowID=" + MyModel.WorkFlowID.ToString()));
}
else
{
return("0");
}
}
/// <summary>
/// 将表单中个数据列的数据写入明细记录表中，便于后期统计
/// </summary>
public void GetDetailsData()
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//获取当前表单对应的工作数据列
string[] FormItemList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 ItemsList from ERPNForm where ID=" + MyModel.FormID.ToString()).Split('|');
for (int i = 0; i < FormItemList.Length; i++)
{
if (FormItemList[i].Trim().Length > 0)
{
try
{
ZWL.BLL.ERPNWorkDetails Model = new ZWL.BLL.ERPNWorkDetails();
Model.WorkID = int.Parse(Request.QueryString["ID"].ToString());
Model.ItemsNameCN = FormItemList[i].Split('_')[1];
Model.ItemsNameEn = FormItemList[i].Split('_')[0];
Model.ItemsValue = Request.Form[FormItemList[i].Split('_')[0]].ToString();
Model.Add();
}
catch { }
}
}
}
/// <summary>
/// 设置具体属性、当前判断权限、可写、保密等
/// </summary>
public void SetNodeInfoAndSet()
{
//当前开始节点是否有查看、编辑、删除按钮？当前按钮属性
string NowNodeID = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select JieDianID from ERPNWorkToDo where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkFlowNode MyJieDianNow = new ZWL.BLL.ERPNWorkFlowNode();
MyJieDianNow.GetModel(int.Parse(NowNodeID));
if (MyJieDianNow.IFCanDel == "否")
{
this.ImageButton3.Visible = false;
}
if (MyJieDianNow.IFCanView == "否")
{
this.ImageButton4.Visible = false;
}
if (MyJieDianNow.IFCanEdit == "否")
{
this.ImageButton5.Visible = false;
}
if (MyJieDianNow.IFCanJump == "否")
{
this.Button3.Visible = false;
}
ZWL.BLL.ERPNWorkToDo MyModelWork = new ZWL.BLL.ERPNWorkToDo();
MyModelWork.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//获取当前表单对应的工作数据列
string[] FormItemList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 ItemsList from ERPNForm where ID=" + MyModelWork.FormID.ToString()).Split('|');
//获取当前节点的可写权限、保密权限
string CanWriteStr = MyJieDianNow.CanWriteSet;
string SecretStr = MyJieDianNow.SecretSet;
for (int ItemNum = 0; ItemNum < FormItemList.Length; ItemNum++)
{
if (FormItemList[ItemNum].ToString().Trim().Length > 0)
{
if (ZWL.Common.PublicMethod.StrIFIn(FormItemList[ItemNum].ToString(), CanWriteStr) == false) //不属于可写字段
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").disabled=true;"; //readOnly
}
else
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").disabled=false;"; //readOnly
}
if (ZWL.Common.PublicMethod.StrIFIn(FormItemList[ItemNum].ToString(), SecretStr) == true) //属于保密字段
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").style.visibility=\"hidden\";";
}
else
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").style.visibility=\"visible\";";
}
}
}
}
public string PiLiangSet = ""; //批量设置字段的可写、保密属性
#endregion Fields
#region Methods
/// <summary>
/// 设置具体属性、当前判断权限、可写、保密等
/// </summary>
public void SetNodeInfoAndSet()
{
//当前开始节点是否有查看、编辑、删除按钮？当前按钮属性
string NowNodeID = ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select JieDianID from ERPNWorkToDo where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkFlowNode MyJieDianNow = new ZWL.BLL.ERPNWorkFlowNode();
MyJieDianNow.GetModel(int.Parse(NowNodeID));
if (MyJieDianNow.IFCanDel == "否")
{
this.ImageButton3.Visible = false;
}
if (MyJieDianNow.IFCanJump == "否")
{
this.Button3.Visible = false;
}
ZWL.BLL.ERPNWorkToDo MyModelWork = new ZWL.BLL.ERPNWorkToDo();
MyModelWork.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//获取当前表单对应的工作数据列
string[] FormItemList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 ItemsList from ERPNForm where ID=" + MyModelWork.FormID.ToString()).Split('|');
//获取当前节点的可写权限、保密权限
string CanWriteStr = MyJieDianNow.CanWriteSet;
string SecretStr = MyJieDianNow.SecretSet;
for (int ItemNum = 0; ItemNum < FormItemList.Length; ItemNum++)
{
if (FormItemList[ItemNum].ToString().Trim().Length > 0)
{
if (ZWL.Common.PublicMethod.StrIFIn(FormItemList[ItemNum].ToString(), CanWriteStr) == false)//不属于可写字段
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").disabled=true;";//readOnly
}
else
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").disabled=false;";//readOnly
}
if (ZWL.Common.PublicMethod.StrIFIn(FormItemList[ItemNum].ToString(), SecretStr) == true)//属于保密字段
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").style.visibility=\"hidden\";";
}
else
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").style.visibility=\"visible\";";
}
}
}
}
/// <summary>
/// 设置具体属性、当前判断权限、可写、保密等
/// </summary>
public void SetNodeInfoAndSet()
{
ZWL.BLL.ERPNWorkToDo MyModelWork = new ZWL.BLL.ERPNWorkToDo();
MyModelWork.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//获取当前表单对应的工作数据列
string[] FormItemList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 ItemsList from ERPNForm where ID=" + MyModelWork.FormID.ToString()).Split('|');
for (int ItemNum = 0; ItemNum < FormItemList.Length; ItemNum++)
{
if (FormItemList[ItemNum].ToString().Trim().Length > 0)
{
PiLiangSet = PiLiangSet + "document.getElementById(\"" + FormItemList[ItemNum].ToString().Split('_')[0] + "\").disabled=true;";//readOnly
}
}
}
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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',OKUserList=OKUserList+'," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + "',ShenPiYiJian='" + PiShiStr + "' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
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.Label3.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Redirect("GoToNextNode.aspx?DoType=" + Request.QueryString["DoType"].ToString() + "&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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',OKUserList=OKUserList+'," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + "',ShenPiYiJian='" + PiShiStr + "' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
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.Label3.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Redirect("GoToNextNode.aspx?DoType=" + Request.QueryString["DoType"].ToString() + "&Type=0&ID=" + Request.QueryString["ID"].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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',OKUserList=OKUserList+'," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + "',ShenPiYiJian='" + PiShiStr + "' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
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.Label3.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Redirect("GoToNextNode.aspx?DoType="+Request.QueryString["DoType"].ToString()+"&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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',OKUserList=OKUserList+'," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + "',ShenPiYiJian='" + PiShiStr + "' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
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.Label3.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
Response.Redirect("GoToNextNode.aspx?DoType=" + Request.QueryString["DoType"].ToString() + "&Type=0&ID=" + Request.QueryString["ID"].ToString());
}
}
public int CheckCondition(string DefaultNodeID)
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//格式如：DEFG_请假天数→大于→10→3|ABCD_请假天数→大于→10→3
string[] TiaoJianList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select ConditionSet from ERPNWorkFlowNode where ID=" + MyModel.JieDianID.ToString()).Split('|');
for (int i = 0; i < TiaoJianList.Length; i++)
{
if (TiaoJianList[i].Trim().Length > 0)
{
string NextIDStr = CheckTiaoJian(TiaoJianList[i].ToString());
if (NextIDStr != "0")
{
return(int.Parse(NextIDStr));
}
}
}
return(int.Parse(DefaultNodeID));
}
public void BanLiWork()
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
ZWL.BLL.ERPNWorkFlowToDoUser wfuser = new ZWL.BLL.ERPNWorkFlowToDoUser();
wfuser.ToDoID = int.Parse(Request.QueryString["ID"].ToString());
wfuser.NodeID = int.Parse(this.DropDownList3.SelectedItem.Value.ToString());
wfuser.WorkFlowID = int.Parse(MyModel.WorkFlowID.ToString());
wfuser.ShenPiUserList = ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.TextBox5.Text.Trim());
if (wfuser.Exists(wfuser.ToDoID, wfuser.NodeID))
{
wfuser.UpdateUser();
}
else
{
wfuser.Add();
}
ZWL.Common.MessageBox.ShowAndRedirect(this, "指定下节点审批人成功!", "NowWorkFlow.aspx");
}
public int CheckCondition(string DefaultNodeID)
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//格式如：DEFG_请假天数→大于→10→3|ABCD_请假天数→大于→10→3
string[] TiaoJianList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select ConditionSet from ERPNWorkFlowNode where ID=" + MyModel.JieDianID.ToString()).Split('|');
for (int i = 0; i < TiaoJianList.Length; i++)
{
if (TiaoJianList[i].Trim().Length > 0)
{
string NextIDStr = CheckTiaoJian(TiaoJianList[i].ToString());
if (NextIDStr != "0")
{
return int.Parse(NextIDStr);
}
}
}
return int.Parse(DefaultNodeID);
}
public void BanLiWork()
{
ZWL.BLL.ERPNWorkToDo XMyModel = new ZWL.BLL.ERPNWorkToDo();
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
{
///////////根据条件获取下一审批节点信息
XJieDianIDStr = CheckCondition(this.DropDownList3.SelectedValue.ToString()).ToString();
}
catch
{
XJieDianIDStr = this.DropDownList3.SelectedValue.ToString();
}
}
else
{
XJieDianIDStr = this.DropDownList3.SelectedValue.ToString();
}
XStateNowStr = "正在办理";
XJieDianNameStr = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeName from ERPNWorkFlowNode where ID=" + XJieDianIDStr);
}
catch
{
if (ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeAddr from ERPNWorkFlowNode where ID=" + XMyModel.JieDianID.ToString()) == "结束")
{
XStateNowStr = "正常结束";
XJieDianIDStr = XMyModel.JieDianID.ToString();
GetDetailsData();//写入明细表
}
else
{
XStateNowStr = "强制结束";
XJieDianIDStr = XMyModel.JieDianID.ToString();
GetDetailsData();//写入明细表
}
XJieDianNameStr = "结束";
}
if (JingBanRenStr == "")
{
XShenPiRenListStr = ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.TextBox5.Text);
}
else
{
XShenPiRenListStr = ZWL.Common.PublicMethod.WorkWeiTuoUserList(JingBanRenStr);
}
if (XShenPiRenListStr.Trim().Length <= 0)
{
XShenPiRenListStr = "工作已办结";
}
XTongGuoRenListStr = "默认";
//执行uodate语句
ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPNWorkToDo set LateTime='" + DateTime.Now.AddHours(double.Parse(ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 JieShuHours from ERPNWorkFlowNode where ID=" + XJieDianIDStr))).ToString() + "',JieDianID=" + XJieDianIDStr + ",JieDianName='" + XJieDianNameStr + "',ShenPiUserList='" + XShenPiRenListStr + "',OKUserList='" + XTongGuoRenListStr + "',StateNow='" + XStateNowStr + "' where ID=" + Request.QueryString["ID"].ToString());
if (XStateNowStr == "正在办理")
{
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的工作需要办理！(" + this.Label1.Text + ")", ZWL.Common.PublicMethod.WorkWeiTuoUserList(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, "工作办理成功！", "../Main.aspx");
}
public void BanLiWork()
{
ZWL.BLL.ERPNWorkToDo XMyModel = new ZWL.BLL.ERPNWorkToDo();
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
{
///////////根据条件获取下一审批节点信息
XJieDianIDStr = CheckCondition(this.DropDownList3.SelectedValue.ToString()).ToString();
}
catch
{
XJieDianIDStr = this.DropDownList3.SelectedValue.ToString();
}
}
else
{
XJieDianIDStr = this.DropDownList3.SelectedValue.ToString();
}
XStateNowStr = "正在办理";
XJieDianNameStr = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeName from ERPNWorkFlowNode where ID=" + XJieDianIDStr);
}
catch
{
if (ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeAddr from ERPNWorkFlowNode where ID=" + XMyModel.JieDianID.ToString()) == "结束")
{
XStateNowStr = "正常结束";
XJieDianIDStr = XMyModel.JieDianID.ToString();
GetDetailsData();//写入明细表
}
else
{
XStateNowStr = "强制结束";
XJieDianIDStr = XMyModel.JieDianID.ToString();
GetDetailsData();//写入明细表
}
XJieDianNameStr = "结束";
}
if (JingBanRenStr == "")
{
XShenPiRenListStr = ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.TextBox5.Text);
}
else
{
XShenPiRenListStr = ZWL.Common.PublicMethod.WorkWeiTuoUserList(JingBanRenStr);
}
if (XShenPiRenListStr.Trim().Length <= 0)
{
XShenPiRenListStr = "工作已办结";
}
XTongGuoRenListStr = "默认";
//执行uodate语句
ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPNWorkToDo set LateTime='" + DateTime.Now.AddHours(double.Parse(ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 JieShuHours from ERPNWorkFlowNode where ID=" + XJieDianIDStr))).ToString() + "',JieDianID=" + XJieDianIDStr + ",JieDianName='" + XJieDianNameStr + "',ShenPiUserList='" + XShenPiRenListStr + "',OKUserList='" + XTongGuoRenListStr + "',StateNow='" + XStateNowStr + "' where ID=" + Request.QueryString["ID"].ToString());
if (XStateNowStr == "正在办理")
{
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的工作需要办理！(" + this.Label1.Text + ")", ZWL.Common.PublicMethod.WorkWeiTuoUserList(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, "工作办理成功！", "../Main.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
//该节点根据传过来的工作的ID信息，查询到使用的工作流、当前节点信息（全部通过往下流转、一个通过往下流转）
//根据节点信息、该工作的通过人列表信息、审批人列表信息===>该节点是否应该继续往下流转
//如果要往下流转则显示页面上的下一节点设置信息，否则用程序跳转回待办事项页面。
//根据Type参数属性，Type为0时为正常下一节点，Type为1时为绑定所有节点供选择。
if (!Page.IsPostBack)
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.Label1.Text = MyModel.WorkName;
this.Label4.Text = MyModel.FormContent.Replace("disabled", "").Replace("hidden", "visible");
//判断 当前节点信息（全部通过可向下流转、一人通过可向下流转） 该工作的通过人列表信息、审批人列表信息
string SPMoShi = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 PSType from ERPNWorkFlowNode where ID=" + MyModel.JieDianID.ToString());
if (CheCkIfOk(MyModel.OKUserList, MyModel.ShenPiUserList, SPMoShi) == true)
{
//绑定下一个节点
try
{
//绑定下一节点 正常状态
if (Request.QueryString["Type"].ToString().Trim() == "0")
{
//绑定下一节点
string[] NextStrList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NextNode from ERPNWorkFlowNode 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 ERPNWorkFlowNode where NodeSerils='" + NextStrList[i].ToString() + "' and WorkFlowID=" + MyModel.WorkFlowID.ToString());//根据序号和workflowID获得节点ID
MyItem.Text = "节点序号：" + NextStrList[i].ToString() + "--节点名称：" + ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeName from ERPNWorkFlowNode where NodeSerils='" + 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,NodeSerils,NodeName from ERPNWorkFlowNode where 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]["NodeSerils"].ToString() + "--节点名称：" + MyDS.Tables[0].Rows[jjj]["NodeName"].ToString();
if (MyItem.Value.ToString().Length > 0)
{
this.DropDownList3.Items.Add(MyItem);
}
}
}
//根据选择的节点，绑定人员等信息。
ZWL.BLL.ERPNWorkFlowNode MyJieDian = new ZWL.BLL.ERPNWorkFlowNode();
MyJieDian.GetModel(int.Parse(this.DropDownList3.SelectedItem.Value.ToString()));
this.TextBox1.Text = MyJieDian.PSType;
this.TextBox2.Text = MyJieDian.SPType;
SetPageFromPSStr(MyJieDian.SPType, MyJieDian.SPDefaultList);
}
catch
{ }
}
else
{
ZWL.Common.MessageBox.ShowAndRedirect(this, "该节点工作需要等待其他人全部办理后才能继续往下流转，请继续等待！", "NowWorkFlow.aspx");
}
//~~~~~~~~~~~~~~~~~当前节点为空！并且下一节点的下拉框也为空！······直接进行提交操作！
if (this.DropDownList3.Items.Count <= 0 && ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeAddr from ERPNWorkFlowNode where ID=" + MyModel.JieDianID.ToString()) == "结束")
{
ZWL.Common.MessageBox.ResponseScript(this, "document.getElementById('ImageButton1').click();");
}
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
}
}
protected void Button2_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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',ShenPiYiJian='" + PiShiStr + "',StateNow='已被驳回' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
Mymodel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
Mymodel.ID = int.Parse(Request.QueryString["ID"].ToString());
Mymodel.FormContent = this.TextBox3.Text;
//发邮件通知发文拟稿人
ZWL.BLL.ERPLanEmail MyMail = new ZWL.BLL.ERPLanEmail();
MyMail.EmailContent = "您的工作已经被驳回！(" + this.Label3.Text + ")";
MyMail.EmailState = "未读";
MyMail.EmailTitle = "您的工作已经被驳回！(" + this.Label3.Text + ")";;
MyMail.FromUser = "******";
MyMail.FuJian = "";
MyMail.TimeStr = DateTime.Now;
MyMail.ToUser = Mymodel.UserName;
MyMail.Add();
Mymodel.UpdateBD();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户审批工作信息(" + this.Label3.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "审批操作完成！", "../Main.aspx");
}
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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',ShenPiYiJian='" + PiShiStr + "',StateNow='已被驳回' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
Mymodel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
Mymodel.ID = int.Parse(Request.QueryString["ID"].ToString());
Mymodel.FormContent = this.TextBox3.Text;
//发邮件通知发文拟稿人
ZWL.BLL.ERPLanEmail MyMail = new ZWL.BLL.ERPLanEmail();
MyMail.EmailContent = "您的工作已经被驳回！(" + this.Label3.Text + ")";
MyMail.EmailState = "未读";
MyMail.EmailTitle = "您的工作已经被驳回！(" + this.Label3.Text + ")";;
MyMail.FromUser = "******";
MyMail.FuJian = "";
MyMail.TimeStr = DateTime.Now;
MyMail.ToUser = Mymodel.UserName;
MyMail.Add();
Mymodel.UpdateBD();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户审批工作信息(" + this.Label3.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "审批操作完成！", "../Main.aspx");
}
}
/// <summary>
/// 判断条件，返回下一节点ID
/// </summary>
/// <param name="FormCcontent"></param>
/// <param name="TiaoJianStr"></param>
/// <param name="WorkFlowIDStr"></param>
/// <returns></returns>
protected string CheckTiaoJian(string TiaoJianStr)
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//条件格式如：ABCD_请假天数→大于→10→3
string ZiDuanStrEN = TiaoJianStr.Split('_')[0]; //字段名称EN 如：ABCD
string ZiDuanStrCN = TiaoJianStr.Split('_')[1]; //字段名称CN 如：请假天数
string BiJiaoStr = TiaoJianStr.Split('→')[1]; //条件比较 如：大于
string ZhiStr = TiaoJianStr.Split('→')[2];//比较的值，如： 10
string JieDianXuHaoStr = TiaoJianStr.Split('→')[3];//跳转的节点序号，如： 3
string NowValue = "";
try
{
NowValue = Request.Form[ZiDuanStrEN].ToString();
}
catch
{ }
if (BiaoJiaoTwoStr(NowValue, ZhiStr, BiJiaoStr) == true)
{
return ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 ID from ERPNWorkFlowNode where NodeSerils='" + JieDianXuHaoStr + "' and WorkFlowID=" + MyModel.WorkFlowID.ToString());
}
else
{
return "0";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ZWL.Common.PublicMethod.CheckSession();
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
// this.Label1.Text = MyModel.WorkName;
this.Label2.Text = MyModel.JieDianName;
this.TextBox3.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 = "NWorkFlowReView.aspx?WorkFlowID=" + MyModel.WorkFlowID.ToString();
//绑定常用审批
ZWL.DBUtility.DbHelperSQL.BindDropDownList2("select ContentStr from ERPShenPi where UserName='******'", this.DropDownList1, "ContentStr", "ContentStr");
SetNodeInfoAndSet();
}
//刷新界面后，将label1赋值
this.Label3.Text = this.TextBox3.Text;
}
protected void Page_Load(object sender, EventArgs e)
{
//该节点根据传过来的工作的ID信息，查询到使用的工作流、当前节点信息（全部通过往下流转、一个通过往下流转）
//根据节点信息、该工作的通过人列表信息、审批人列表信息===>该节点是否应该继续往下流转
//如果要往下流转则显示页面上的下一节点设置信息，否则用程序跳转回待办事项页面。
//根据Type参数属性，Type为0时为正常下一节点，Type为1时为绑定所有节点供选择。
if (!Page.IsPostBack)
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
this.Label1.Text = MyModel.WorkName;
this.Label4.Text = MyModel.FormContent.Replace("disabled", "").Replace("hidden", "visible");
//判断 当前节点信息（全部通过可向下流转、一人通过可向下流转） 该工作的通过人列表信息、审批人列表信息
string SPMoShi = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 PSType from ERPNWorkFlowNode where ID=" + MyModel.JieDianID.ToString());
if (CheCkIfOk(MyModel.OKUserList, MyModel.ShenPiUserList, SPMoShi) == true)
{
//绑定下一个节点
try
{
//绑定下一节点 正常状态
if (Request.QueryString["Type"].ToString().Trim() == "0")
{
//绑定下一节点
string[] NextStrList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NextNode from ERPNWorkFlowNode 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 ERPNWorkFlowNode where NodeSerils='" + NextStrList[i].ToString() + "' and WorkFlowID=" + MyModel.WorkFlowID.ToString());//根据序号和workflowID获得节点ID
MyItem.Text = "节点序号：" + NextStrList[i].ToString() + "--节点名称：" + ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeName from ERPNWorkFlowNode where NodeSerils='" + 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,NodeSerils,NodeName from ERPNWorkFlowNode where 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]["NodeSerils"].ToString() + "--节点名称：" + MyDS.Tables[0].Rows[jjj]["NodeName"].ToString();
if (MyItem.Value.ToString().Length > 0)
{
this.DropDownList3.Items.Add(MyItem);
}
}
}
//根据选择的节点，绑定人员等信息。
ZWL.BLL.ERPNWorkFlowNode MyJieDian = new ZWL.BLL.ERPNWorkFlowNode();
MyJieDian.GetModel(int.Parse(this.DropDownList3.SelectedItem.Value.ToString()));
this.TextBox1.Text = MyJieDian.PSType;
this.TextBox2.Text = MyJieDian.SPType;
SetPageFromPSStr(MyJieDian.SPType, MyJieDian.SPDefaultList);
}
catch
{ }
}
else
{
ZWL.Common.MessageBox.ShowAndRedirect(this, "该节点工作需要等待其他人全部办理后才能继续往下流转，请继续等待！", "NowWorkFlow.aspx");
}
//~~~~~~~~~~~~~~~~~当前节点为空！并且下一节点的下拉框也为空！······直接进行提交操作！
if (this.DropDownList3.Items.Count <= 0 && ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeAddr from ERPNWorkFlowNode where ID=" + MyModel.JieDianID.ToString()) == "结束")
{
ZWL.Common.MessageBox.ResponseScript(this, "document.getElementById('ImageButton1').click();");
}
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
}
}
protected void Button2_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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',ShenPiYiJian='" + PiShiStr + "',StateNow='已被驳回' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
Mymodel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
Mymodel.ID = int.Parse(Request.QueryString["ID"].ToString());
Mymodel.FormContent = this.TextBox3.Text;
//发邮件通知发文拟稿人
ZWL.BLL.ERPLanEmail MyMail = new ZWL.BLL.ERPLanEmail();
MyMail.EmailContent = "您的工作已经被驳回！(" + this.Label3.Text + ")";
MyMail.EmailState = "未读";
MyMail.EmailTitle = "您的工作已经被驳回！(" + this.Label3.Text + ")"; ;
MyMail.FromUser = "******";
MyMail.FuJian = "";
MyMail.TimeStr = DateTime.Now;
MyMail.ToUser = Mymodel.UserName;
MyMail.Add();
Mymodel.UpdateBD();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户审批工作信息(" + this.Label3.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "审批操作完成！", "../Main.aspx");
}
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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',ShenPiYiJian='" + PiShiStr + "',StateNow='已被驳回' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
Mymodel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
Mymodel.ID = int.Parse(Request.QueryString["ID"].ToString());
Mymodel.FormContent = this.TextBox3.Text;
//发邮件通知发文拟稿人
ZWL.BLL.ERPLanEmail MyMail = new ZWL.BLL.ERPLanEmail();
MyMail.EmailContent = "您的工作已经被驳回！(" + this.Label3.Text + ")";
MyMail.EmailState = "未读";
MyMail.EmailTitle = "您的工作已经被驳回！(" + this.Label3.Text + ")"; ;
MyMail.FromUser = "******";
MyMail.FuJian = "";
MyMail.TimeStr = DateTime.Now;
MyMail.ToUser = Mymodel.UserName;
MyMail.Add();
Mymodel.UpdateBD();
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户审批工作信息(" + this.Label3.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "审批操作完成！", "../Main.aspx");
}
}
/// <summary>
/// 将表单中个数据列的数据写入明细记录表中，便于后期统计
/// </summary>
public void GetDetailsData()
{
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//获取当前表单对应的工作数据列
string[] FormItemList = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 ItemsList from ERPNForm where ID=" + MyModel.FormID.ToString()).Split('|');
for (int i = 0; i < FormItemList.Length; i++)
{
if (FormItemList[i].Trim().Length > 0)
{
try
{
ZWL.BLL.ERPNWorkDetails Model = new ZWL.BLL.ERPNWorkDetails();
Model.WorkID = int.Parse(Request.QueryString["ID"].ToString());
Model.ItemsNameCN = FormItemList[i].Split('_')[1];
Model.ItemsNameEn = FormItemList[i].Split('_')[0];
Model.ItemsValue = Request.Form[FormItemList[i].Split('_')[0]].ToString();
Model.Add();
}
catch { }
}
}
}
public void BanLiWork()
{
ZWL.BLL.ERPNWorkToDo XMyModel = new ZWL.BLL.ERPNWorkToDo();
XMyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//初始化
string XJieDianIDStr = "0";
string XJieDianNameStr = "";
string XShenPiRenListStr = "";
string XTongGuoRenListStr = "";
string XStateNowStr = "正在办理";
string JingBanRenStr = "";//条件判断时读取经办人
try
{
#region 添加默认审批人检查 Andy 20130925
//根据选择的节点，绑定人员等信息。
ZWL.BLL.ERPNWorkFlowNode MyJieDian = new ZWL.BLL.ERPNWorkFlowNode();
MyJieDian.GetModel(int.Parse(this.DropDownList3.SelectedItem.Value.ToString()));
if (MyJieDian.SPType == "从默认审批人中选择")
{
if (!String.IsNullOrEmpty(MyJieDian.SPDefaultList))
{
ArrayList CurrentSP = new ArrayList(this.TextBox5.Text.Trim().Split(','));
ArrayList SPDefault = new ArrayList(MyJieDian.SPDefaultList.Split(','));
foreach (string sp in CurrentSP)
{
if (!SPDefault.Contains(sp))
{
ZWL.Common.MessageBox.Show(this, "请从默认审批人中选择，默认审批人:" + MyJieDian.SPDefaultList + " ！");
return;
}
}
}
}
else if (MyJieDian.SPType == "从默认审批部门中选择")
{
string SqlWhere = "";
string[] DefultList = MyJieDian.SPDefaultList.Split(',');
for (int i = 0; i < DefultList.Length; i++)
{
if (SqlWhere.Trim().Length > 0)
{
SqlWhere = SqlWhere + " or " + " ','+Department+',' like '%," + DefultList[i].ToString() + ",%' ";
}
else
{
SqlWhere = " ','+Department+',' like '%," + DefultList[i].ToString() + ",%' ";
}
}
string SPDefaultStr = ZWL.DBUtility.DbHelperSQL.GetStringList("select UserName from ERPUser where " + SqlWhere).Replace("|", ",");
if (!String.IsNullOrEmpty(SPDefaultStr))
{
ArrayList CurrentSP = new ArrayList(this.TextBox5.Text.Trim().Split(','));
ArrayList SPDefault = new ArrayList(SPDefaultStr.Split(','));
foreach (string sp in CurrentSP)
{
if (!SPDefault.Contains(sp))
{
ZWL.Common.MessageBox.Show(this, "请从默认审批部门中选择，默认审批部门:" + MyJieDian.SPDefaultList + " ！");
return;
}
}
}
}
else if (MyJieDian.SPType == "从默认审批角色中选择")
{
string SqlWhere = "";
string[] DefultList = MyJieDian.SPDefaultList.Split(',');
for (int i = 0; i < DefultList.Length; i++)
{
if (SqlWhere.Trim().Length > 0)
{
SqlWhere = SqlWhere + " or " + " ','+JiaoSe+',' like '%," + DefultList[i].ToString() + ",%' ";
}
else
{
SqlWhere = " ','+JiaoSe+',' like '%," + DefultList[i].ToString() + ",%' ";
}
}
string SPDefaultStr = ZWL.DBUtility.DbHelperSQL.GetStringList("select UserName from ERPUser where " + SqlWhere).Replace("|", ",");
if (!String.IsNullOrEmpty(SPDefaultStr))
{
ArrayList CurrentSP = new ArrayList(this.TextBox5.Text.Trim().Split(','));
ArrayList SPDefault = new ArrayList(SPDefaultStr.Split(','));
foreach (string sp in CurrentSP)
{
if (!SPDefault.Contains(sp))
{
ZWL.Common.MessageBox.Show(this, "请从默认审批角色中选择，默认审批角色:" + MyJieDian.SPDefaultList + " ！");
return;
}
}
}
}
#endregion
if (CheckBox1.Checked == true)
{
//条件未找到或者没有匹配项时，采用选择好的节点
XJieDianIDStr = this.DropDownList3.SelectedValue.ToString();
try
{
///////////根据条件获取下一审批节点信息
XJieDianIDStr = CheckCondition(this.DropDownList3.SelectedValue.ToString()).ToString();
}
catch
{
XJieDianIDStr = this.DropDownList3.SelectedValue.ToString();
}
}
else
{
XJieDianIDStr = this.DropDownList3.SelectedValue.ToString();
}
XStateNowStr = "正在办理";
XJieDianNameStr = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeName from ERPNWorkFlowNode where ID=" + XJieDianIDStr);
}
catch
{
if (ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeAddr from ERPNWorkFlowNode where ID=" + XMyModel.JieDianID.ToString()) == "结束")
{
XStateNowStr = "正常结束";
XJieDianIDStr = XMyModel.JieDianID.ToString();
GetDetailsData();//写入明细表
}
else
{
XStateNowStr = "强制结束";
XJieDianIDStr = XMyModel.JieDianID.ToString();
GetDetailsData();//写入明细表
}
XJieDianNameStr = "结束";
}
if (JingBanRenStr == "")
{
XShenPiRenListStr = ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.TextBox5.Text);
}
else
{
XShenPiRenListStr = ZWL.Common.PublicMethod.WorkWeiTuoUserList(JingBanRenStr);
}
if (XShenPiRenListStr.Trim().Length <= 0)
{
XShenPiRenListStr = "工作已办结";
}
XTongGuoRenListStr = "默认";
//执行uodate语句
ZWL.DBUtility.DbHelperSQL.ExecuteSQL("update ERPNWorkToDo set LateTime='" + DateTime.Now.AddHours(double.Parse(ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 JieShuHours from ERPNWorkFlowNode where ID=" + XJieDianIDStr))).ToString() + "',JieDianID=" + XJieDianIDStr + ",JieDianName='" + XJieDianNameStr + "',ShenPiUserList='" + XShenPiRenListStr + "',OKUserList='" + XTongGuoRenListStr + "',StateNow='" + XStateNowStr + "' where ID=" + Request.QueryString["ID"].ToString());
if (XStateNowStr == "正在办理")
{
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的工作需要办理！(" + this.Label1.Text + ")", ZWL.Common.PublicMethod.WorkWeiTuoUserList(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);
}
//Andy 20130925 添加委托人审批记录
string[] UserArray = this.TextBox5.Text.Trim().Split(',');
for (int i = 0; i < UserArray.Length; i++)
{
if (UserArray[i].ToString().Trim().Length > 0)
{
string WeiTuoUser = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 ToUser from ERPNWorkFlowWT where FromUser='******'");
if (WeiTuoUser.Trim().Length > 0)
{
ZWL.DBUtility.DbHelperSQL.ExecuteSQL("insert into ERPNWorkFlowWTLog(FromUser,ToUser,ToDoid,InTime) values('" + UserArray[i].ToString() + "','" + WeiTuoUser.Trim() + "'," + int.Parse(Request.QueryString["ID"].ToString()) + ",'" + DateTime.Now.ToString() + "')");
}
}
}
//写系统日志
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 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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',OKUserList=OKUserList+'," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + "',ShenPiYiJian='" + PiShiStr + "' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
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();
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//判断 当前节点信息（全部通过可向下流转、一人通过可向下流转） 该工作的通过人列表信息、审批人列表信息
string SPMoShi = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 PSType from ERPNWorkFlowNode where ID=" + MyModel.JieDianID.ToString());
if (CheCkIfOk(MyModel.OKUserList, MyModel.ShenPiUserList, SPMoShi) == false)
{
ZWL.Common.MessageBox.ShowAndRedirect(this, "该节点工作需要等待其他人全部办理后才能继续往下流转，请指定下一节点并审批人并继续等待！", "GoToNextNodeUser.aspx?DoType=" + Request.QueryString["DoType"].ToString() + "&Type=0&ID=" + Request.QueryString["ID"].ToString());
}
else
{
Response.Redirect("GoToNextNode.aspx?DoType=" + Request.QueryString["DoType"].ToString() + "&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 ERPNWorkToDo set FuJianList='" + ZWL.Common.PublicMethod.GetSessionValue("WenJianList") + "',OKUserList=OKUserList+'," + ZWL.Common.PublicMethod.GetSessionValue("UserName") + "',ShenPiYiJian='" + PiShiStr + "' where ID=" + Request.QueryString["ID"].ToString());
ZWL.BLL.ERPNWorkToDo Mymodel = new ZWL.BLL.ERPNWorkToDo();
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();
ZWL.BLL.ERPNWorkToDo MyModel = new ZWL.BLL.ERPNWorkToDo();
MyModel.GetModel(int.Parse(Request.QueryString["ID"].ToString()));
//判断 当前节点信息（全部通过可向下流转、一人通过可向下流转） 该工作的通过人列表信息、审批人列表信息
string SPMoShi = ZWL.DBUtility.DbHelperSQL.GetSHSL("select top 1 PSType from ERPNWorkFlowNode where ID=" + MyModel.JieDianID.ToString());
if (CheCkIfOk(MyModel.OKUserList, MyModel.ShenPiUserList, SPMoShi) == false)
{
ZWL.Common.MessageBox.ShowAndRedirect(this, "该节点工作需要等待其他人全部办理后才能继续往下流转，请指定下一节点并审批人并继续等待！", "GoToNextNodeUser.aspx?DoType=" + Request.QueryString["DoType"].ToString() + "&Type=0&ID=" + Request.QueryString["ID"].ToString());
}
else
{
Response.Redirect("GoToNextNode.aspx?DoType=" + Request.QueryString["DoType"].ToString() + "&Type=0&ID=" + Request.QueryString["ID"].ToString());
}
}
}