//发布
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("发布失败,请先选中记录！");
}
}
//通知
protected void Send_Click(object sender, EventArgs e)
{
string cal = "";
string mestr = "";
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(cal))
{
int j = 0;
for (j = 0; j < (cal.Split(',')).Length; j++)
{
SqlDataReader datar = SqlHelper.ExecuteReader("select jsid,jsr from OA_RWD02 where jsid='" + cal.Split(',')[j] + "'");
if (datar.Read())
{
mestr = mestr + "," + datar["jsr"].ToString();
}
datar.Close();
}
}
if (string.IsNullOrEmpty(mestr))
{
mydb.Alert("请先选择接收人员，再执行任务催办！");
}
else
{
//Msg
//SqlHelper.ExecuteSql("insert into OA_Rwd01(cbyy) values('" + hkdb.GetStr(cbreason.Text) + "',GETDATE())");
var arr = mestr.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (i = 0; i < arr.Length; i++)
{
SqlHelper.ExecuteSql("insert into OA_RwCb(rwid,reason,person,createuser,createtime) values ('" + hkdb.GetStr(rwidstr.Text) + "','" + hkdb.GetStr(cbreason.Text) + "','" + arr[i] + "','" + this.Session["userid"] + "', GETDATE())");
}
mydb.Alert_Close("已成功催办！");
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = "请尽快接收[" + hkdb.GetStr(rwdh.Text) + "-" + lblrwbt.Text + "]任务单!" + this.Session["username"].ToString();
string templateParam = "{\"name\":\"" + lblrwbt.Text + "\",\"status\":" + "\"催办\"" + "}";
hkdb.SendAliSMS(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), mestr.Substring(1), message, templateParam);
//hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), mestr.Substring(1), message);
mydb.Alert_Close("己成功通知任务接收人员！");
}
else
{
mydb.Alert("请先选择站内消息或手机短信任意一种，再执行任务催办！");
}
}
}
//问责
protected void Send_Click1(object sender, EventArgs e)
{
string cal = "";
string ca2 = "";
string ca3 = "";
string ca4 = "";
string mestr = "";
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();
}
}
}
for (i = 0; i <= GridView2.Rows.Count - 1; i++)
{
CheckBox cb1 = (CheckBox)GridView2.Rows[i].Cells[1].FindControl("del1");
if (cb1.Checked == true)
{
if (string.IsNullOrEmpty(ca2))
{
ca2 = GridView2.DataKeys[i].Value.ToString();
}
else
{
ca2 = ca2 + "," + GridView2.DataKeys[i].Value.ToString();
}
}
}
for (i = 0; i <= GridView3.Rows.Count - 1; i++)
{
CheckBox cb2 = (CheckBox)GridView3.Rows[i].Cells[1].FindControl("del2");
if (cb2.Checked == true)
{
if (string.IsNullOrEmpty(ca3))
{
ca3 = GridView3.DataKeys[i].Value.ToString();
}
else
{
ca3 = ca3 + "," + GridView3.DataKeys[i].Value.ToString();
}
}
}
for (i = 0; i <= GridView4.Rows.Count - 1; i++)
{
CheckBox cb3 = (CheckBox)GridView4.Rows[i].Cells[1].FindControl("del3");
if (cb3.Checked == true)
{
if (string.IsNullOrEmpty(ca4))
{
ca4 = GridView4.DataKeys[i].Value.ToString();
}
else
{
ca4 = ca4 + "," + GridView4.DataKeys[i].Value.ToString();
}
}
}
if (!string.IsNullOrEmpty(cal))
{
int j = 0;
for (j = 0; j < (cal.Split(',')).Length; j++)
{
SqlDataReader datar = SqlHelper.ExecuteReader("select jsid,jsr from OA_RWD02 where jsid='" + cal.Split(',')[j] + "'");
if (datar.Read())
{
mestr = mestr + "," + datar["jsr"].ToString();
}
datar.Close();
}
}
if (!string.IsNullOrEmpty(ca2))
{
string message = "您办理的[" + hkdb.GetStr(rwdh.Text) + "]" + lblrwbt.Text + ";任务被问责!" + this.Session["username"].ToString();
string templateParam = "{\"name\":\"" + lblrwbt.Text + "\",\"status\":" + "\"被问责\"" + "}";
hkdb.SendAliSMS(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ca2, message, templateParam);
var arr = ca2.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (i = 0; i < arr.Length; i++)
{
string s = Convert.ToString(SqlHelper.ExecuteScalar("select score from yh WHERE ui_id ='" + arr[i] + "'"));
int ss = Convert.ToInt32(s);
SqlHelper.ExecuteSql("Update yh set score='" + (ss - 3) + "' WHERE ui_id='" + arr[i] + "'");
SqlHelper.ExecuteSql("insert into OA_RwPunish (rwid,reason,person,createuser,createtime) values ('" + hkdb.GetStr(rwidstr.Text) + "','" + hkdb.GetStr(reason.Text) + "','" + arr[i] + "','" + this.Session["userid"] + "', GETDATE())");
}
mydb.Alert_Close("己成功问责！");
}
if (!string.IsNullOrEmpty(ca3))
{
string message = "您办理的[" + hkdb.GetStr(rwdh.Text) + "]" + lblrwbt.Text + ";任务被问责!" + this.Session["username"].ToString();
string templateParam = "{\"name\":\"" + lblrwbt.Text + "\",\"status\":" + "\"被问责\"" + "}";
hkdb.SendAliSMS(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ca3, message, templateParam);
var arr = ca3.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (i = 0; i < arr.Length; i++)
{
string s = Convert.ToString(SqlHelper.ExecuteScalar("select score from yh WHERE ui_id ='" + arr[i] + "'"));
int ss = Convert.ToInt32(s);
SqlHelper.ExecuteSql("Update yh set score='" + (ss - 3) + "' WHERE ui_id='" + arr[i] + "'");
SqlHelper.ExecuteSql("insert into OA_RwPunish (rwid,reason,person,createuser,createtime) values ('" + hkdb.GetStr(rwidstr.Text) + "','" + hkdb.GetStr(reason.Text) + "','" + arr[i] + "','" + this.Session["userid"] + "', GETDATE())");
}
mydb.Alert_Close("己成功问责！");
}
if (!string.IsNullOrEmpty(ca4))
{
string message = "您办理的[" + hkdb.GetStr(rwdh.Text) + "]" + lblrwbt.Text + ";任务被问责!" + this.Session["username"].ToString();
string templateParam = "{\"name\":\"" + lblrwbt.Text + "\",\"status\":" + "\"被问责\"" + "}";
hkdb.SendAliSMS(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), ca4, message, templateParam);
var arr = ca4.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (i = 0; i < arr.Length; i++)
{
string s = Convert.ToString(SqlHelper.ExecuteScalar("select score from yh WHERE ui_id ='" + arr[i] + "'"));
int ss = Convert.ToInt32(s);
SqlHelper.ExecuteSql("Update yh set score='" + (ss - 3) + "' WHERE ui_id='" + arr[i] + "'");
SqlHelper.ExecuteSql("insert into OA_RwPunish (rwid,reason,person,createuser,createtime) values ('" + hkdb.GetStr(rwidstr.Text) + "','" + hkdb.GetStr(reason.Text) + "','" + arr[i] + "','" + this.Session["userid"] + "', GETDATE())");
}
mydb.Alert_Close("己成功问责！");
}
if (string.IsNullOrEmpty(mestr))
{
//mydb.Alert("请先选择，再执行问责！");
}
else
{
string message = "您办理的[" + hkdb.GetStr(rwdh.Text) + "]" + lblrwbt.Text + ";任务被问责!" + this.Session["username"].ToString();
string templateParam = "{\"name\":\"" + lblrwbt.Text + "\",\"status\":" + "\"被问责\"" + "}";
hkdb.SendAliSMS(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), mestr.Substring(1), message, templateParam);
var arr = mestr.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (i = 0; i < arr.Length; i++)
{
string s = Convert.ToString(SqlHelper.ExecuteScalar("select score from yh WHERE ui_id ='" + arr[i] + "'"));
int ss = Convert.ToInt32(s);
SqlHelper.ExecuteSql("Update yh set score='" + (ss - 3) + "' WHERE ui_id='" + arr[i] + "'");
SqlHelper.ExecuteSql("insert into OA_RwPunish (rwid,reason,person,createuser,createtime) values ('" + hkdb.GetStr(rwidstr.Text) + "','" + hkdb.GetStr(reason.Text) + "','" + arr[i] + "','" + this.Session["userid"] + "', GETDATE())");
}
mydb.Alert_Close("己成功问责！");
}
}
//送审
protected void SS_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request.QueryString["jsid"]))
{
string FileName = "";
string FileVisualPathStr = "";
string UserName = this.Session["userid"].ToString();
string PathStr = null;
string type = null;
//判断附件
if (!string.IsNullOrEmpty(fj.PostedFile.FileName.Trim()))
{
try
{
PathStr = fj.PostedFile.FileName;
if (fj.PostedFile.ContentLength < 1024 * int.Parse(lblAttachSize.Text))
{
type = PathStr.Substring((PathStr.LastIndexOf(".") + 1));
FileName = System.IO.Path.GetFileName(fj.PostedFile.FileName);
//if (!System.IO.Directory.Exists((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName)))
//{
// System.IO.Directory.CreateDirectory((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName));
//}
Random TempNameInt = new Random();
string NewDocDirName = TempNameInt.Next(100000000).ToString();
if (!System.IO.Directory.Exists((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName + "\\" + NewDocDirName)))
{
System.IO.Directory.CreateDirectory((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName + "\\" + NewDocDirName));
}
TempNameInt = null;
fj.PostedFile.SaveAs((Server.MapPath("..\\..\\") + "Attach\\oa\\rw\\" + UserName + "\\" + NewDocDirName + "\\" + FileName));
FileVisualPathStr = "\\Attach\\oa\\rw\\" + UserName + "\\" + NewDocDirName + "\\";
}
else
{
mydb.Alert("附件大小超出 " + lblAttachSize.Text + " KB的限制！");
}
}
catch (Exception ex)
{
throw ex;
}
}
SqlHelper.ExecuteSql("update OA_RWD02 set jszt='送审中',clr='" + this.Session["userid"] + "',clsj=GETDATE(),fjmc='" + FileName + "',fjlj='" + FileVisualPathStr + "',bzsm='" + hkdb.GetStr(wcqk.Text) + "' where jsid='" + hkdb.GetStr(Request.QueryString["jsid"].ToString()) + "'");
//Msg
if (xxtz.Checked == true | dxtz.Checked == true)
{
string message = "[" + hkdb.GetStr(rwdh.Text) + "]" + lblrwbt.Text + ";任务单已经办理，请审核!" + this.Session["username"].ToString();
string templateParam = "{\"name\":\"" + lblrwbt.Text + "\",\"status\":" + "\"送审中\"" + "}";
hkdb.SendAliSMS(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), fbr.Text, message, templateParam);
//hkdb.SendMsg(xxtz.Checked, dxtz.Checked, this.Session["userid"].ToString(), fbr.Text, message);
mydb.Alert_Close("己成功通知任务发布人！");
}
SSBtn.Visible = false;
if (Request.QueryString["flag"] != null && Request.QueryString["flag"].Equals("index"))
{
mydb.Alert_Reload_Close("已成功送审待办任务，请等候审批结果！");
}
else
{
mydb.Alert_Refresh_Close("已成功送审待办任务，请等候审批结果！", "wddbrwy.aspx");
}
}
else
{
mydb.Alert("请先选中待办任务再执行送审！");
}
}
