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