protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPTelFile MyModel = new ZWL.BLL.ERPTelFile();
MyModel.ChuanYueYiJian = "";
MyModel.FileType = this.TextBox3.Text;
MyModel.TimeStr = DateTime.Now;
MyModel.TitleStr = this.TextBox1.Text;
MyModel.ContentStr = this.TxtContent.Text;
MyModel.FuJianStr = ZWL.Common.PublicMethod.GetSessionValue("WenJianList2");
MyModel.FromUser = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyModel.ToUser = this.TextBox2.Text;
MyModel.YiJieShouRen = "";
MyModel.ChuanYueHouIDList1 = this.DropDownList1.SelectedItem.Value.ToString();
MyModel.QianShouHouIDList = "0";
MyModel.Zihao = this.TextBoxZihao.Text;
MyModel.Add();
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的文件需要接收！(" + this.TextBox1.Text + ")", this.TextBox2.Text.Trim());
//写系统日志
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, "传阅文件添加成功！", "SendFile.aspx");
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPTaskFP Model = new ZWL.BLL.ERPTaskFP();
Model.ID = int.Parse(Request.QueryString["ID"].ToString());
Model.TaskTitle = this.txtTaskTitle.Text.ToString();
Model.TaskContent = this.txtTaskContent.Text.ToString();
Model.FromUser = this.txtFromUser.Text.ToString();
Model.ToUserList = this.txtToUserList.Text.ToString();
Model.XinXiGouTong = this.txtXinXiGouTong.Text.ToString();
Model.JinDu = decimal.Parse(this.txtJinDu.Text);
Model.WanCheng = this.txtWanCheng.Text.ToString();
Model.NowState = this.DropDownList1.SelectedValue.ToString();
Model.KSSJ = DateTime.Parse(this.TextBox3.Text.Trim() + " " + this.DropDownList2.SelectedItem.Text + ":" + this.DropDownList3.SelectedItem.Text + ":00");
Model.JSSJ = DateTime.Parse(this.TextBox2.Text.Trim() + " " + this.DropDownList4.SelectedItem.Text + ":" + this.DropDownList5.SelectedItem.Text + ":00");
Model.FKSJ = DateTime.Parse(this.TextBox4.Text.Trim() + " " + this.DropDownList6.SelectedItem.Text + ":" + this.DropDownList7.SelectedItem.Text + ":00");
Model.SFFK = this.TX.Value;
Model.Update();
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的任务需要执行！(" + this.txtTaskTitle.Text + ")", this.txtToUserList.Text.Trim());
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户修改任务分配信息(" + this.txtTaskTitle.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "任务分配信息修改成功！", "TaskFP.aspx");
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPMeeting Model = new ZWL.BLL.ERPMeeting();
Model.ChuXiRen = this.TextBox4.Text;
Model.CurentOnline = "";
Model.HuiYiJiYao = this.TxtContent.Text;
Model.HuiYiZhuChi = this.TextBox6.Text;
Model.JieShuTime = DateTime.Parse(this.TextBox8.Text.Trim() + " " + this.DropDownList3.SelectedItem.Text + ":" + this.DropDownList4.SelectedItem.Text + ":00");
Model.KaiShiTime = DateTime.Parse(this.TextBox7.Text.Trim() + " " + this.DropDownList1.SelectedItem.Text + ":" + this.DropDownList2.SelectedItem.Text + ":00");
Model.MeetingTitle = this.TextBox1.Text;
Model.MeetingZhuTi = this.TextBox2.Text;
Model.MiaoShu = this.TextBox3.Text;
Model.TimeStr = DateTime.Now;
Model.WangLuoHuiYiShiIP = this.TextBox5.Text;
Model.ZhuanXieRen = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.Add();
//写系统日志
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();
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的会议需要参加！(" + this.TextBox1.Text + ")", this.TextBox4.Text.Trim());
ZWL.Common.MessageBox.ShowAndRedirect(this, "会议添加成功！", "MeetingDengJi.aspx");
}
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");
}
protected void ImageButton1_Click(object sender, EventArgs e)
{
ZWL.BLL.ERPTaskFP Model = new ZWL.BLL.ERPTaskFP();
Model.TaskTitle = this.txtTaskTitle.Text.ToString();
Model.TaskContent = this.txtTaskContent.Text.ToString();
Model.FromUser = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.ToUserList = this.txtToUserList.Text.ToString();
Model.XinXiGouTong = "";
Model.JinDu = decimal.Parse("0");
Model.WanCheng = "暂无";
Model.NowState = "任务添加";
Model.KSSJ = DateTime.Parse(this.TextBox3.Value.Trim());
Model.JSSJ = DateTime.Parse(this.TextBox2.Value.Trim());
Model.FKSJ = DateTime.Parse(this.TextBox4.Value.Trim());
Model.SFFK = this.TX.Value;
Model.Add();
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的任务需要执行！(" + this.txtTaskTitle.Text + ")", this.txtToUserList.Text.Trim());
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加任务分配信息(" + this.txtTaskTitle.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "任务分配信息添加成功！", "TaskFP.aspx");
}
protected void CheckRW()
{
string ToDayStr = DateTime.Now.ToString();
DataSet MyDataSet = ZWL.DBUtility.DbHelperSQL.GetDataSet("select * from ERPTaskFP where SFFK='是' and FKSJ<='" + ToDayStr + "'");
for (int j = 0; j < MyDataSet.Tables[0].Rows.Count; j++)
{
SendMainAndSms.SendMobileMessage("有需要您反馈的任务提醒时间已到，请尽快反馈。(" + MyDataSet.Tables[0].Rows[j]["TaskTitle"].ToString() + "--" + MyDataSet.Tables[0].Rows[j]["FromUser"].ToString() + "内容:" + MyDataSet.Tables[0].Rows[j]["TaskContent"].ToString() + ")", MyDataSet.Tables[0].Rows[j]["ToUserList"].ToString() + "," + MyDataSet.Tables[0].Rows[j]["FromUser"].ToString());
ZWL.DBUtility.DbHelperSQL.Query("update ERPTaskFP set SFFK='已发' where ID =" + MyDataSet.Tables[0].Rows[j]["ID"].ToString() + " ");
}
}
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 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");
}
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 ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPNWorkToDo Model = new ZWL.BLL.ERPNWorkToDo();
Model.WorkName = this.txtWorkName.Text.Trim();
Model.WenHao = this.txtWenHao.Text.Trim();
Model.FormID = int.Parse(Request.QueryString["FormID"].ToString());
Model.WorkFlowID = int.Parse(Request.QueryString["WorkFlowID"].ToString());
Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.TimeStr = DateTime.Now;
Model.FormContent = this.TextBox3.Text;
Model.FuJianList = ZWL.Common.PublicMethod.GetSessionValue("WenJianList");
Model.ShenPiYiJian = "";
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)
{
//条件未找到或者没有匹配项时，采用选择好的节点
Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString());
try
{
///////////根据条件获取下一审批节点信息
Model.JieDianID = CheckCondition(this.DropDownList3.SelectedValue.ToString());
}
catch
{
Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString());
}
}
else
{
Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString());
}
Model.JieDianName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeName from ERPNWorkFlowNode where ID=" + Model.JieDianID.ToString());
Model.StateNow = "正在办理";
}
catch
{
Model.JieDianName = "结束";
Model.StateNow = "强制结束";
}
Model.ShenPiUserList = ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.TextBox5.Text.Trim());
Model.OKUserList = "默认";
Model.LateTime = DateTime.Now.AddHours(double.Parse(ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 JieShuHours from ERPNWorkFlowNode where ID=" + Model.JieDianID.ToString())));
int todoid = Model.Add();
if (Model.StateNow == "正在办理")
{
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的工作需要办理！(" + this.txtWorkName.Text + ")", ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.TextBox5.Text.Trim()));
}
else
{
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您的工作已经被强制结束！(" + this.txtWorkName.Text + ")", ZWL.Common.PublicMethod.GetSessionValue("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() + "'," + todoid + ",'" + DateTime.Now.ToString() + "')");
}
}
}
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加新工作信息(" + this.txtWorkName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "审批工作添加成功！", "NWorkToDo.aspx?FormID=" + Request.QueryString["FormID"].ToString() + "&WorkFlowID=" + Request.QueryString["WorkFlowID"].ToString());
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
ZWL.BLL.ERPNWorkToDo Model = new ZWL.BLL.ERPNWorkToDo();
Model.WorkName = this.txtWorkName.Text;
Model.FormID = int.Parse(Request.QueryString["FormID"].ToString());
Model.WorkFlowID = int.Parse(Request.QueryString["WorkFlowID"].ToString());
Model.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
Model.TimeStr = DateTime.Now;
Model.FormContent = this.TextBox3.Text;
Model.FuJianList = ZWL.Common.PublicMethod.GetSessionValue("WenJianList");
Model.ShenPiYiJian = "";
try
{
if (CheckBox1.Checked == true)
{
//条件未找到或者没有匹配项时，采用选择好的节点
Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString());
try
{
///////////根据条件获取下一审批节点信息
Model.JieDianID = CheckCondition(this.DropDownList3.SelectedValue.ToString());
}
catch
{
Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString());
}
}
else
{
Model.JieDianID = int.Parse(this.DropDownList3.SelectedValue.ToString());
}
Model.JieDianName = ZWL.DBUtility.DbHelperSQL.GetSHSL("select NodeName from ERPNWorkFlowNode where ID=" + Model.JieDianID.ToString());
Model.StateNow = "正在办理";
}
catch
{
Model.JieDianName = "结束";
Model.StateNow = "强制结束";
}
Model.ShenPiUserList = ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.TextBox5.Text.Trim());
Model.ChaoSongUserList = ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.txtChaoSong.Text.Trim());
Model.OKUserList = "默认";
Model.LateTime = DateTime.Now.AddHours(double.Parse(ZWL.DBUtility.DbHelperSQL.GetSHSLInt("select top 1 JieShuHours from ERPNWorkFlowNode where ID=" + Model.JieDianID.ToString())));
Model.Add();
if (Model.StateNow == "正在办理")
{
//发送短信
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您有新的工作需要办理！(" + this.txtWorkName.Text + ")", ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.TextBox5.Text.Trim()));
SendMainAndSms.SendMessage(CHKSMS1, CHKMOB1, "您有新的抄送工作！(" + this.txtWorkName.Text + ")", ZWL.Common.PublicMethod.WorkWeiTuoUserList(this.txtChaoSong.Text.Trim()));
}
else
{
SendMainAndSms.SendMessage(CHKSMS, CHKMOB, "您的工作已经被强制结束！(" + this.txtWorkName.Text + ")", ZWL.Common.PublicMethod.GetSessionValue("UserName"));
}
//写系统日志
ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi();
MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName");
MyRiZhi.DoSomething = "用户添加新工作信息(" + this.txtWorkName.Text + ")";
MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString();
MyRiZhi.Add();
ZWL.Common.MessageBox.ShowAndRedirect(this, "审批工作添加成功！", "NWorkToDo.aspx?FormID=" + Request.QueryString["FormID"].ToString() + "&WorkFlowID=" + Request.QueryString["WorkFlowID"].ToString());
}
