//送审
protected void Send_Click2(object sender, EventArgs e)
{
string glryStr = Convert.ToString(SqlHelper.ExecuteScalar("SELECT HYS_FZR FROM OA_HYS WHERE HYS_ID='" + zkdd.SelectedValue + "'"));
SqlHelper.ExecuteSql("update oa_hyqc set zt='送审中',fqr='" + this.Session["userid"] + "',fqsj=GETDATE(),spr='" + glryStr + "' where fqr='" + this.Session["userid"] + "' and zt='起草中' and id='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
//Msg
string sdateStr = txtSdate.Text + " " + sxs.SelectedValue + sfz.SelectedValue + "00";
string edateStr = txtEdate.Text + " " + exs.SelectedValue + efz.SelectedValue + "00";
if (xxtz2.Checked == true | dxtz2.Checked == true)
{
SqlDataReader datar1 = SqlHelper.ExecuteReader("select hys_fzr from oa_hys where hys_id='" + zkdd.SelectedValue + "'");
if (datar1.Read())
{
ycxx.Text = datar1["hys_fzr"].ToString();
datar1.Close();
string message = "申请在" + sdateStr + "至" + edateStr + "使用" + zkdd.SelectedItem.Text + "!" + this.Session["username"].ToString();
hkdb.SendMsg(xxtz2.Checked, dxtz2.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
else
{
datar1.Close();
}
}
mydb.Alert_Refresh_Close("会议已成功送审！", "Hyqc.aspx");
}
//审批完成
protected void Sp_Click(object sender, EventArgs e)
{
SqlHelper.ExecuteSql("update oa_gzjh01 set zt='评价中',spr='" + this.Session["userid"] + "',spsj=getdate(),spyj='" + hkdb.GetStr(spyj.Text) + "' where jhid='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = this.Session["username"].ToString() + "已审批了您的工作计划,请查看!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
mydb.Alert_Refresh_Close("计划已审批完成！", "grjh.aspx");
}
protected void SaveBtn_Click(object sender, EventArgs e)
{
string strlist = null;
string str1 = null;
str1 = "" + wUserIDs.Text + "";
ArrayList myarr = new ArrayList();
string[] mystr = str1.Split(',');
for (int s = 0; s < mystr.Length; s++)
{
strlist += "'" + mystr[s] + "',";
}
strlist += "'0'";
//Msg
if (xxtx.Checked == true | dxtx.Checked == true)
{
SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT * FROM yh WHERE ui_id IN (" + strlist + ")");
while (datar2.Read())
{
hkdb.SendMsg(xxtx.Checked, dxtx.Checked, this.Session["userid"].ToString(), datar2["ui_id"].ToString(), mscContent.Text);
}
datar2.Close();
}
mydb.Alert_Close("催办成功！");
}
//发送邮件
protected void Send_Click(object sender, EventArgs e)
{
//发件箱
int iYjid = Convert.ToInt32(SqlHelper.ExecuteScalar("INSERT INTO hk_Mail_FS(jsrIDs,jsrNames,fsbt,fsnr,zyjb,yncg,scbz,msbz,yjfj,fslx,fsrID,fsrName,fssj) VALUES('" + hkdb.GetStr(UserID.Text) + "','" + hkdb.GetStr(UserName.Text) + "','" + hkdb.GetStr(bt.Text) + "','" + editor.Value + "','" + zyx.SelectedValue + "','否','否','" + hkdb.GetValueChk_Str(msbz.Checked) + "','" + hkdb.GetStr(Number.Text) + "','内部邮件','" + this.Session["UserID"] + "','" + this.Session["UserName"] + "',GETDATE())" + "SELECT CAST(scope_identity() AS int)"));
//循环收件箱
string sto = UserID.Text;
sto = sto.TrimEnd(',');
int i = 0;
for (i = 0; i < (sto.Split(',')).Length; i++)
{
SqlHelper.ExecuteSql("INSERT INTO hk_Mail_JS(ssyjid,jsr,jsrIDs,jsrNames,jsbt,jsnr,zyjb,jszt,scbz,msbz,yjfj,jslx,fsrID,fsrName,fssj) VALUES('" + iYjid + "','" + sto.Split(',')[i] + "','" + hkdb.GetStr(UserID.Text) + "','" + hkdb.GetStr(UserName.Text) + "','" + hkdb.GetStr(bt.Text) + "','" + editor.Value + "','" + zyx.SelectedValue + "','0','否','" + hkdb.GetValueChk_Str(msbz.Checked) + "','" + hkdb.GetStr(Number.Text) + "','内部邮件','" + this.Session["UserID"] + "','" + this.Session["UserName"] + "',GETDATE())");
}
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = this.Session["username"].ToString() + "给您发了一封站内新邮件,请查收!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), sto, message);
}
mydb.Alert_Close("发送成功！");
}
protected void Dxyj_Click(string mess)
{
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = null;
switch (mess)
{
case "1":
message = "您申请使用的[" + sqzy.Text + "]资源已被同意,请登录平台查看!" + this.Session["username"].ToString();
break;
case "2":
message = "您申请使用的[" + sqzy.Text + "]资源已被拒绝,请登录平台查看!" + this.Session["username"].ToString();
break;
default:
message = "您申请使用的[" + sqzy.Text + "]资源已被收回,请登录平台查看!" + this.Session["username"].ToString();
break;
}
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
}
protected void Dxyj_Click(string mess)
{
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = null;
switch (mess)
{
case "1":
message = "您撰写的[" + xwbt.Text + "]新闻已发布!" + this.Session["username"].ToString();
break;
case "2":
message = "您撰写的[" + xwbt.Text + "]新闻已停用!" + this.Session["username"].ToString();
break;
default:
message = "您撰写的[" + xwbt.Text + "]新闻已退回!" + this.Session["username"].ToString();
break;
}
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
}
//消息通知
public void SendMsg()
{
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
if (jsr.SelectedValue == "jdqr")
{
string message = this.Session["username"].ToString() + "批量审批通过了一份考勤说明,请确认!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), kqry.SelectedValue, message);
}
else
{
string message = this.Session["username"].ToString() + "批量审批通过了一份考勤说明,请继续审批!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), jsr.SelectedValue, message);
}
}
}
//消息通知
public void SendMsg()
{
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = this.Session["username"].ToString() + "提交了一份考勤说明,请审批!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), jsr.SelectedValue, message);
}
}
//消息通知
public void SendMsg()
{
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = this.Session["username"].ToString() + "已经最终确认通过了您的考勤申请!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), sqrid.Text, message);
}
}
protected void Save_Click(object sender, EventArgs e)
{
//Msg
if (xxtx.Checked == true | dxtx.Checked == true)
{
hkdb.SendMsg(xxtx.Checked, dxtx.Checked, this.Session["userid"].ToString(), Request.QueryString["bid"].ToString(), hkdb.GetStr(txnr.Text));
}
mydb.Alert_Close("催办提醒成功！");
}
//送审
protected void Send_Click(object sender, EventArgs e)
{
SqlHelper.ExecuteSql("update OA_GZJH01 set zt='审核中',lrsj=GETDATE(),sprIDs='" + hkdb.GetStr(UserID.Text) + "',sprNames='" + hkdb.GetStr(UserName.Text) + "' where zt='录入' and jhid='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = this.Session["username"].ToString() + "向您提交了一份部门工作计划,请审批!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), UserID.Text, message);
}
mydb.Alert_Refresh_Close("计划已成功送审！", "bmjhzd.aspx");
}
protected void Save_Click(object sender, EventArgs e)
{
//更新工作记录
SqlHelper.ExecuteSql("UPDATE hk_Work SET wUserIDs=wUserIDs+'" + hkdb.GetStr(UserID.Text) + "',wUserNames=wUserNames+'" + hkdb.GetStr(UserName.Text) + "',ynJQ='是' WHERE wID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
//记录审批意见
SqlHelper.ExecuteSql("INSERT INTO hk_WorkAppComm(ac_wfID,ac_fName,ac_wfName,acContent,acAttName,acAttNewName,FK_uid,AddTime,ac_type) values ('" + hkdb.GetStr(Request.QueryString["id"]) + "','" + strfnName + "','" + Name + "','" + hkdb.GetStr(txt_AppComm.Text) + "','','','" + this.Session["userid"] + "',GETDATE(),'加签')");
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = this.Session["username"].ToString() + "加签给您一条标题为【" + lbltitle.Text + "】工作记录,请审批!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), UserID.Text, message);
}
mydb.Alert_Refresh_Close("加签成功！", "HandleWork.aspx");
}
protected void Dxxx_Click(string mess)
{
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = null;
if (mess == "yes")
{
message = "您申请的会议<" + hkdb.GetStr(hyzt.Text) + ">已经审批通过!" + this.Session["username"].ToString();
}
else
{
message = "您申请的会议<" + hkdb.GetStr(hyzt.Text) + ">已经被退回!" + this.Session["username"].ToString();
}
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
}
protected void Save_Click(object sender, EventArgs e)
{
//判断btn
Button btn = (Button)sender;
string s = btn.ID;
DateTime sdateStr = default(DateTime);
DateTime edateStr = default(DateTime);
sdateStr = Convert.ToDateTime(xssj_s.Text + " " + sxs.SelectedValue + sfz.SelectedValue + "00");
edateStr = Convert.ToDateTime(xssj_e.Text + " " + exs.SelectedValue + efz.SelectedValue + "00");
string sql = null;
if (s == "SaveBtn")
{
sql = "insert into oa_clsq(sqbm,ccxs,fcdd,dddd,czrs,xssj_s,xssj_e,ccsy,xycl,jsy,bz,zt,sqr,sqsj) values('" + sqbm.SelectedValue + "','" + ccxs.SelectedValue + "','" + hkdb.GetStr(fcdd.Text) + "','" + hkdb.GetStr(dddd.Text) + "','" + hkdb.GetStr(czrs.Text) + "','" + sdateStr + "','" + edateStr + "','" + hkdb.GetStr(ccsy.Text) + "','" + xycl.SelectedValue + "','" + jsy.SelectedValue + "','" + hkdb.GetStr(bz.Text) + "','审批中','" + this.Session["userid"] + "',GETDATE())";
}
SqlHelper.ExecuteSql(sql);
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
SqlDataReader datar = SqlHelper.ExecuteReader("select glry from oa_clda where id='" + xycl.SelectedValue + "'");
if (datar.Read())
{
ycxx.Text = datar["glry"].ToString();
datar.Close();
string message = this.Session["username"].ToString() + "申请从" + sdateStr + "到" + edateStr + "使用[" + xycl.SelectedItem.Text + "]!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
else
{
datar.Close();
}
}
//判断btn
if (s == "SaveBtn")
{
mydb.Alert_Refresh_Close("保存成功并已送审！", "Zysq.aspx");
}
}
protected void Save_Click(object sender, EventArgs e)
{
//判断btn
Button btn = (Button)sender;
string s = btn.ID;
string sdateStr = null;
string edateStr = null;
sdateStr = txtSdate.Text + " " + sxs.SelectedValue + sfz.SelectedValue + "00";
edateStr = txtEdate.Text + " " + exs.SelectedValue + efz.SelectedValue + "00";
SqlHelper.ExecuteSql("insert into OA_ZYSQ(sybm,sqzy,jysm,sysj,ghsj,zt,sqr,sqsj) values('" + sybm.SelectedValue + "','" + sqzy.SelectedValue + "','" + hkdb.GetStr(jysm.Text) + "','" + sdateStr + "','" + edateStr + "','审批中','" + this.Session["userid"] + "',GETDATE())");
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
SqlDataReader datar = SqlHelper.ExecuteReader("select glry from oa_zyfl where flid='" + zyfl.SelectedValue + "'");
if (datar.Read())
{
ycxx.Text = datar["glry"].ToString();
datar.Close();
string message = "申请从" + sdateStr + "到" + edateStr + "使用[" + sqzy.SelectedItem.Text + "],请批复!" + this.Session["username"].ToString();
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
else
{
datar.Close();
}
}
//判断btn
if (s == "SaveBtn")
{
mydb.Alert_Refresh("保存成功！", "Zysq.aspx");
//sybm.SelectedValue = "";
zyfl.SelectedValue = "";
jysm.Text = "";
sxs.SelectedValue = "";
sfz.SelectedValue = "";
exs.SelectedValue = "";
efz.SelectedValue = "";
}
}
//送审
protected void Send_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
SqlHelper.ExecuteSql("update OA_XWNR set zt='送审中' where xwid='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' and zt='草稿'");
}
else
{
SqlHelper.ExecuteSql("update OA_XWNR set zt='送审中' where xwid='" + lblID.Text + "' and zt='草稿'");
}
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
ycxx.Text = Convert.ToString(SqlHelper.ExecuteScalar("select glry from OA_XWFL where flid='" + xwfl.SelectedValue + "'"));
string message = this.Session["username"].ToString() + "撰写了一篇新闻,请审批!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
mydb.Alert_Refresh_Close("送审成功！", "Xwzg.aspx");
}
//消息短信
protected void Dxyj_Click(string mess)
{
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = null;
if (mess == "1")
{
message = this.Session["username"].ToString() + "已同意您的车辆申请,车辆:[" + xzcl.SelectedItem.Text + "]驾驶员[" + xzjsy.SelectedItem.Text + "]!";
}
else if (mess == "2")
{
message = "您使用的[" + xzcl.SelectedItem.Text + "]车辆已确认归还!" + this.Session["username"].ToString();
}
else
{
message = "您申请使用的[" + xycl.SelectedItem.Text + "]已被拒绝,请登录平台查看详细信息!" + this.Session["username"].ToString();
}
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ycxx.Text, message);
}
}
private void AudiRun()
{
string jbryuser = lblwUserIDs.Text;
string jbryname = wUserNames.Text;
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc,C.ui_desc AS enName FROM hk_WorkFlowEntrust A LEFT OUTER JOIN yh B ON(A.feUserID=B.ui_id) LEFT OUTER JOIN yh C ON(A.EnUserID=C.ui_id) WHERE feStatus='启用'");
while (dr.Read())
{
jbryuser = jbryuser.Replace("" + dr["feUserID"] + "", "" + dr["EnUserID"] + "");
jbryname = jbryname.Replace("" + dr["ui_desc"] + "", "" + dr["enName"] + "");
}
dr.Close();
if (wUserNames.Text == "")
{
mydb.Alert("请选择审批人员！");
return;
}
if (FormName.SelectedValue == "")
{
mydb.Alert("未选择下一步骤！");
return;
}
else
{
SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlowNode WHERE fnID='" + FormName.SelectedValue + "'");
if (datar1.Read())
{
SqlHelper.ExecuteSql("UPDATE hk_Work SET SelectMode='" + datar1["SelectMode"] + "',wStatus='等待办理',wUserIDs='" + jbryuser + "',wUserNames='" + jbryname + "',ReviewMode='" + datar1["ReviewMode"] + "',TimeLimit='" + datar1["TimeLimit"] + "',NextNodeNo='" + datar1["fnNo"] + "',NextNodeID='" + datar1["fnID"] + "',NextNodeNum='" + datar1["fnNum"] + "',NextNodeName='" + datar1["fnName"] + "' WHERE wNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "'");
}
else
{
mydb.Alert("未找到下一步骤！");
return;
}
datar1.Close();
string strlist = null;
string str1 = null;
str1 = "" + jbryuser + "";
ArrayList myarr = new ArrayList();
string[] mystr = str1.Split(',');
for (int s = 0; s < mystr.Length; s++)
{
strlist += "'" + mystr[s] + "',";
}
strlist += "'0'";
//Msg
if (ynxx.Checked == true | yndx.Checked == true)
{
SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT * FROM yh WHERE ui_id IN (" + strlist + ")");
while (datar2.Read())
{
string message = "有新工作：[" + Name + "]需要办理";
hkdb.SendMsg(ynxx.Checked, yndx.Checked, this.Session["userid"].ToString(), datar2["ui_id"].ToString(), message);
}
datar2.Close();
}
mydb.Alert_Close("提交成功！");
}
}
protected void Save_Click(object sender, EventArgs e)
{
//判断btn
Button btn = (Button)sender;
string s = btn.ID;
int srxzStr = hkdb.GetValueChk_Int(srxz.Checked);
int cfStr = hkdb.GetValueChk_Int(cf.Checked);
int txStr = hkdb.GetValueChk_Int(tx.Checked);
string sdateStr = null;
string edateStr = null;
sdateStr = hkdb.GetStr(srq.Text) + " " + sxs.SelectedValue + sfz.SelectedValue;
edateStr = hkdb.GetStr(erq.Text) + " " + exs.SelectedValue + efz.SelectedValue;
if (Convert.ToDateTime(edateStr) < Convert.ToDateTime(sdateStr))
{
mydb.Alert("开始时间必须小于结束时间！");
return;
}
if (scheid == 0)
{
SqlHelper.ExecuteSql("INSERT INTO HK_JSB (EMPID,SUBJECT,SCHTYPE,PLACE,CONTENT,PRIVFLAG,REPEATFLAG,REQUENCATE,UPTODATE,REMINDFLAG,REMINDDAY,FDATE,TDATE,CDATE,YYRY) VALUES('" + this.Session["userid"] + "','" + hkdb.GetStr(zt.Text) + "','" + lx.SelectedValue + "','" + hkdb.GetStr(dd.Text) + "','" + hkdb.GetStr(nr.Text) + "'," + srxzStr + "," + cfStr + ",'" + cfzq.SelectedValue + "','" + hkdb.GetStr(jzrq.Text) + "'," + txStr + ",'" + hkdb.GetStr(txts.Text) + "','" + hkdb.GetStr(sdateStr) + "','" + hkdb.GetStr(edateStr) + "',GETDATE(),'" + hkdb.GetStr(UserID.Text).TrimEnd(',') + "')");
}
else
{
SqlHelper.ExecuteSql("UPDATE HK_JSB SET Subject='" + hkdb.GetStr(zt.Text) + "',SchType='" + lx.SelectedValue + "',Place='" + hkdb.GetStr(dd.Text) + "',Content='" + hkdb.GetStr(nr.Text) + "',PrivFlag=" + srxzStr + ",RepeatFlag=" + cfStr + ",RequenCate='" + cfzq.SelectedValue + "',UpToDate='" + hkdb.GetStr(jzrq.Text) + "',RemindFlag=" + txStr + ",RemindDay='" + hkdb.GetStr(txts.Text) + "',FDate='" + hkdb.GetStr(sdateStr) + "',TDate='" + hkdb.GetStr(edateStr) + "',yyry='" + hkdb.GetStr(UserID.Text).TrimEnd(',') + "' WHERE SchID=" + scheid + "");
}
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = this.Session["username"].ToString() + "就[" + hkdb.GetStr(zt.Text) + "]事情在" + sdateStr + "至" + edateStr + "向您预约时间!";
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), UserID.Text, message);
}
//判断btn
if (s == "SaveAddBtn")
{
zt.Text = "";
lx.SelectedValue = "";
dd.Text = "";
sxs.SelectedValue = "";
sfz.SelectedValue = "";
exs.SelectedValue = "";
efz.SelectedValue = "";
txts.Text = "";
tx.Checked = false;
nr.Text = "";
srxz.Checked = false;
cfzq.SelectedValue = "0";
jzrq.Text = "";
cf.Checked = false;
UserName.Text = "";
UserID.Text = "";
mydb.Alert_Refresh("保存成功,请新增下一条记录！", "Wdjsb.aspx");
}
else
{
Server.Transfer((reurl + "?i=2&date=" + date));
}
}
//发布
protected void Use_Click(object sender, EventArgs e)
{
string cal = "";
string call = "";
int i = 0;
for (i = 0; i <= GridView1.Rows.Count - 1; i++)
{
CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[1].FindControl("del");
if (cb.Checked == true)
{
if (string.IsNullOrEmpty(cal))
{
cal = GridView1.DataKeys[i].Value.ToString();
}
else
{
cal = cal + "','" + GridView1.DataKeys[i].Value.ToString();
}
if (string.IsNullOrEmpty(call))
{
call = GridView1.DataKeys[i].Value.ToString();
}
else
{
call = call + "," + GridView1.DataKeys[i].Value.ToString();
}
}
}
if (!string.IsNullOrEmpty(cal))
{
int j = 0;
for (j = 0; j < (call.Split(',')).Length; j++)
{
string mestr = "";
string rwdhstr = "";
string rwstr = "";
SqlDataReader datar = SqlHelper.ExecuteReader("select jsid,jsr from OA_RWD02 where ssrwid='" + call.Split(',')[j] + "'");
while (datar.Read())
{
mestr = mestr + "," + datar["jsr"].ToString();
}
datar.Close();
SqlDataReader datar1 = SqlHelper.ExecuteReader("select rwdh,rwbt from OA_RWD01 where rwid='" + call.Split(',')[j] + "'");
if (datar1.Read())
{
rwdhstr = rwdhstr + "," + "[" + datar1["rwdh"].ToString() + "]" + datar1["rwbt"].ToString();
rwstr = rwstr + "," + datar1["rwbt"].ToString();
}
datar1.Close();
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = "请您尽快接收" + rwdhstr.Substring(1) + "任务单!" + this.Session["username"].ToString();
string templateParam = "{\"name\":\"" + rwstr.Substring(1) + "\",\"status\":" + "\"待接收\"" + "}";
if (!string.IsNullOrEmpty(mestr))
{
//hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), mestr.Substring(1), message);
hkdb.SendAliSMS(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), mestr.Substring(1), message, templateParam);
}
else
{
hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), mestr, message);
}
}
else
{
mydb.Alert("发布失败,请选择站内消息或手机短信任意一种！");
return;
}
}
SqlHelper.ExecuteSql("update OA_RWD01 set rwzt='已发布' where rwid in ('" + cal + "')");
mydb.Alert("发布成功！");
GridViewBind();
}
else
{
mydb.Alert("发布失败,请先选中记录！");
}
}
private void AudiRun()
{
string jbryuser = txt_wUserIDs.Text;
string jbryname = txt_wUserNames.Text;
//审批人员to委托人员
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc,C.ui_desc AS enName FROM hk_WorkFlowEntrust A LEFT OUTER JOIN yh B ON(A.feUserID=B.ui_id) LEFT OUTER JOIN yh C ON(A.EnUserID=C.ui_id) WHERE feStatus='启用'");
while (dr.Read())
{
jbryuser = jbryuser.Replace("" + dr["feUserID"] + "", "" + dr["EnUserID"] + "");
jbryname = jbryname.Replace("" + dr["ui_desc"] + "", "" + dr["enName"] + "");
}
dr.Close();
if (lblmsg5.Text == "结束")
{
string GdTypeId = null;
//归档
SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT A.*,B.ffName FROM hk_WorkFlow A LEFT OUTER JOIN hk_WorkFlowFolder B ON(A.FK_ffid=B.ffID) WHERE wfID='" + lblFlowId.Text + "'");
if (datar1.Read())
{
GdTypeId = datar1["FK_ffid"].ToString();
}
datar1.Close();
SqlDataReader datar2 = SqlHelper.ExecuteReader("SELECT * FROM hk_Work WHERE wNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "'");
if (datar2.Read())
{
SqlHelper.ExecuteSql("INSERT INTO hk_WorkFolder(FK_fid,FK_fno,FK_wfid,FK_wfno,FK_fnno,FK_fnnum,fdNo,fdSerialNo,fdName,fdContent,fdPromoterID,fdEndUserIDs,fdEndUserNames,FK_ffid,FK_uid,AddTime,fdTitle) values ('" + datar2["FK_fid"] + "','" + datar2["FK_fno"] + "','" + datar2["FK_wfid"] + "','" + datar2["FK_wfno"] + "','" + datar2["FK_fnno"] + "','" + datar2["FK_fnnum"] + "','" + datar2["wNo"] + "','" + datar2["wSerialNo"] + "','" + datar2["wName"] + "','" + datar2["wContent"] + "','" + datar2["PromoterID"] + "','" + datar2["EndUserIDs"] + "','" + datar2["EndUserNames"] + "','" + GdTypeId + "','" + this.Session["userid"] + "',GETDATE(),'" + datar2["wTitle"] + "')");
SqlHelper.ExecuteSql("exec sp_Send_Mess 1,0,'" + this.Session["userid"] + "','" + datar2["PromoterID"] + "','您发起的工作：" + datar2["wName"] + "审批完成'");
}
datar2.Close();
SqlHelper.ExecuteSql("UPDATE hk_Work SET wStatus='正常结束',wUserIDs='正常结束',wUserNames='正常结束',LastTime=GETDATE() WHERE wNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "'");
}
else
{
if (txt_wUserNames.Text == "")
{
mydb.Alert("请选择审批人员！");
return;
}
if (rblFormName.SelectedValue == "")
{
mydb.Alert("未选择下一步骤！");
return;
}
else
{
SqlDataReader datar3 = SqlHelper.ExecuteReader("SELECT * FROM hk_WorkFlowNode WHERE fnID='" + rblFormName.SelectedValue + "'");
if (datar3.Read())
{
SqlHelper.ExecuteSql("UPDATE hk_Work SET SelectMode='" + datar3["SelectMode"] + "',wUserIDs='" + jbryuser + "',wUserNames='" + jbryname + "',ReviewMode='" + datar3["ReviewMode"] + "',TimeLimit='" + datar3["TimeLimit"] + "',NextNodeNo='" + datar3["fnNo"] + "',NextNodeID='" + datar3["fnID"] + "',NextNodeNum='" + datar3["fnNum"] + "',NextNodeName='" + datar3["fnName"] + "',LastTime=GETDATE() WHERE wNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "'");
SqlHelper.ExecuteSql("INSERT INTO hk_WorkAppLog(FK_wfID,al_fName,al_wfName,alContent,FK_uid,AddTime) values ('" + hkdb.GetStr(Request.QueryString["id"]) + "','" + rblFormName + "','" + lblName.Text + "','审批工作，转入下一步骤[" + datar3["fnName"] + "]','" + this.Session["userid"] + "',GETDATE())");
}
else
{
mydb.Alert("未找到下一步骤！");
return;
}
datar3.Close();
string strlist = null;
string str1 = null;
str1 = "" + jbryuser + "";
ArrayList myarr = new ArrayList();
string[] mystr = str1.Split(',');
for (int s = 0; s < mystr.Length; s++)
{
strlist += "'" + mystr[s] + "',";
}
strlist += "'0'";
//Msg
if (xxtx.Checked == true | dxtx.Checked == true)
{
SqlDataReader datar4 = SqlHelper.ExecuteReader("SELECT * FROM yh WHERE ui_id IN (" + strlist + ")");
while (datar4.Read())
{
string message = "有新工作：[" + lblName.Text + "]需要办理";
hkdb.SendMsg(xxtx.Checked, dxtx.Checked, this.Session["userid"].ToString(), datar4["ui_id"].ToString(), message);
}
datar4.Close();
}
}
}
//正式更新审批意见的状态
SqlHelper.ExecuteSql("Update hk_WorkAppComm SET ac_status='有效' WHERE acID='" + hkdb.GetStr(Request.QueryString["acid"]) + "'");
mydb.Alert_Refresh_Close("保存成功！", "HandleWork.aspx");
}
