protected void btndelinfo_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
String[] v_uids = this.txtuids.Value.Split(',');
for(var i=0;i<v_uids.Length;i++)
{
if (v_uids[i] != "")
{
//this.Response.Write("<script>alert('aaa')</script>");
//判断是否有人员
DataTable dt_dept = Hyoa_dept.Getdept(v_uids[i]);
DataTable dt_user = Hyoa_user.Getusersbydeptid(v_uids[i]);
if (dt_user.Rows.Count > 0)
{
Response.Write("<script>alert('" + dt_dept.Rows[0]["hy_deptname"].ToString() + "下存在人员，不能进行删除！');</script>");
return;
}
//判断是否有子部门
DataTable dt_subdept = Hyoa_dept.GetSubDepts(v_uids[i]);
if (dt_subdept.Rows.Count > 0)
{
Response.Write("<script>alert('" + dt_dept.Rows[0]["hy_deptname"].ToString() + "下存在子部门，不能进行删除！');</script>");
return;
}
//写删除部门系统日志start
HyoaClass.Hyoa_log Hyoa_log = new HyoaClass.Hyoa_log();
Hyoa_log.ID = System.Guid.NewGuid().ToString();
Hyoa_log.hy_createtime = System.DateTime.Now.ToString();
string userip = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (userip == null || userip == "")
{
userip = Request.ServerVariables["REMOTE_ADDR"];
}
Hyoa_log.hy_oppip = userip;
Hyoa_log.hy_opptype = "删除";
Hyoa_log.hy_oppcontent = "删除部门：" + dt_dept.Rows[0]["hy_deptname"].ToString();
Hyoa_log.hy_oppuserid = this.Session["hyuid"].ToString();
Hyoa_log.hy_oppusername = this.Session["hyuname"].ToString();
Hyoa_log.Insert();
Hyoa_dept.hy_deptid = v_uids[i];
Hyoa_dept.Delete();
}
}
this.txtuids.Value = "";
//DataPlay(1);
DataPlay(System.Int32.Parse(this.curpage.Text));
}
private void DataPlay()
{
//文档ID
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
if (this.Request.QueryString["tableid"] != null)
{
this.txttableid.Text = this.Request.QueryString["tableid"].ToString();
}
if (this.Request.QueryString["flowid"] != null)
{
this.txtflowid.Text = this.Request.QueryString["flowid"].ToString();
}
if (this.Request.QueryString["tacheid"] != null)
{
this.txtcurtacheid.Text = this.Request.QueryString["tacheid"].ToString();
}
if (this.Request.QueryString["nexttacheids"] != null)
{
string pis_nexttacheids = this.Request.QueryString["nexttacheids"].ToString();
string pis_nexttachenames = this.Request.QueryString["nexttachenames"].ToString();
//-----条件流程的情况 start-----
//根据模块ID得到流程信息
DataTable dt = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.txtflowid.Text, this.txtcurtacheid.Text);
if (dt.Rows.Count > 0)
{
//给相应的域赋值
//当前环节
this.Hy_CurrTacheName_Show.Text = dt.Rows[0]["hy_curtachename"].ToString();
//后续环节
if (pis_nexttacheids != "")
{
string[] piv_nexttacheids = pis_nexttacheids.Split(',');
string[] piv_nexttachenames = pis_nexttachenames.Split(',');
for (var i = 0; i < piv_nexttacheids.Length; i++)
{
Hy_nexttachename.Items.Add(new ListItem(piv_nexttachenames[i], piv_nexttacheids[i]));
}
this.Hy_nexttachename.SelectedIndex = 0;
//得到 后续环节的默认环节 对应的 提醒默认值，然后进行赋值
string ls_temp_tacheid = piv_nexttacheids[0];
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_getrddoissendsmsandmsg = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.txtflowid.Text, ls_temp_tacheid);
if (dt_getrddoissendsmsandmsg.Rows.Count > 0)
{
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendSms"].ToString() == "是")
this.f_isSendsms_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendMessage"].ToString() == "是")
this.f_isSendjstx_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendSms"].ToString() == "是")
this.f_isSendsms_cyr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendMessage"].ToString() == "是")
this.f_isSendjstx_cyr.Checked = true;
this.txthy_ifshowcurcomp.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurcomp"].ToString();
this.txthy_ifshowcurdept.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurdept"].ToString();
}
}
}
dt.Clear();
//后序环节处理人部门
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
//先得到后续环节处理人集合
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
this.Hy_deptlist_clr.Items.Insert(0, "--请选择--");
ls_temp1 = "";
int t = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_deptid"].ToString() + ","))
{
}
else
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist_clr.Items.Insert(t, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_deptid"].ToString();
}
}
this.Hy_deptlist_clr.SelectedIndex = 0;
}
}
dt.Clear();
//后序环节传阅人部门
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
dt = Hyoa_dept.Getdepts();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist.Items.Insert(i, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
}
//this.Hy_deptlist.DataSource = dt;
//this.Hy_deptlist.DataTextField = "hy_deptname";
//this.Hy_deptlist.DataValueField = "hy_deptid";
//this.Hy_deptlist.DataBind();
this.Hy_deptlist.SelectedIndex = 0;
}
dt.Clear();
//后序环节处理人员
//先得到后续环节处理人集合
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
//后序环节传阅人员
dt = Hyoa_user.Getusersbydeptid(this.Hy_deptlist.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_rylist.DataSource = dt;
this.Hy_rylist.DataTextField = "hy_username";
this.Hy_rylist.DataValueField = "hy_userid";
this.Hy_rylist.DataBind();
//this.Hy_rylist.SelectedIndex = 0;
}
dt.Clear();
//-----条件流程的情况 end-----
}
else
{
//-----非条件流程的情况 start-----
//根据模块ID得到流程信息
DataTable dt = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.txtflowid.Text, this.txtcurtacheid.Text);
if (dt.Rows.Count > 0)
{
//给相应的域赋值
//当前环节
this.Hy_CurrTacheName_Show.Text = dt.Rows[0]["hy_curtachename"].ToString();
//后续环节
this.Hy_nexttachename.DataSource = dt;
this.Hy_nexttachename.DataTextField = "hy_nexttachename";
this.Hy_nexttachename.DataValueField = "hy_nexttacheid";
this.Hy_nexttachename.DataBind();
this.Hy_nexttachename.SelectedIndex = 0;
//得到 后续环节的默认环节 对应的 提醒默认值，然后进行赋值
string ls_temp_tacheid = dt.Rows[0]["hy_nexttacheid"].ToString();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_getrddoissendsmsandmsg = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.txtflowid.Text, ls_temp_tacheid);
if (dt_getrddoissendsmsandmsg.Rows.Count > 0)
{
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendSms"].ToString() == "是")
this.f_isSendsms_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendMessage"].ToString() == "是")
this.f_isSendjstx_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendSms"].ToString() == "是")
this.f_isSendsms_cyr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendMessage"].ToString() == "是")
this.f_isSendjstx_cyr.Checked = true;
this.txthy_ifshowcurcomp.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurcomp"].ToString();
this.txthy_ifshowcurdept.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurdept"].ToString();
}
}
dt.Clear();
//后序环节处理人部门
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
//先得到后续环节处理人集合
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
this.Hy_deptlist_clr.Items.Insert(0, "--请选择--");
ls_temp1 = "";
int t = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_deptid"].ToString() + ","))
{
}
else
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist_clr.Items.Insert(t, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_deptid"].ToString();
}
}
this.Hy_deptlist_clr.SelectedIndex = 0;
}
}
dt.Clear();
//后序环节传阅人部门
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
dt = Hyoa_dept.Getdepts();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist.Items.Insert(i, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
}
//this.Hy_deptlist.DataSource = dt;
//this.Hy_deptlist.DataTextField = "hy_deptname";
//this.Hy_deptlist.DataValueField = "hy_deptid";
//this.Hy_deptlist.DataBind();
this.Hy_deptlist.SelectedIndex = 0;
}
dt.Clear();
//后序环节处理人员
//先得到后续环节处理人集合
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql="";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
//后序环节传阅人员
dt = Hyoa_user.Getusersbydeptid(this.Hy_deptlist.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_rylist.DataSource = dt;
this.Hy_rylist.DataTextField = "hy_username";
this.Hy_rylist.DataValueField = "hy_userid";
this.Hy_rylist.DataBind();
//this.Hy_rylist.SelectedIndex = 0;
}
dt.Clear();
//-----非条件流程的情况 end-----
}
//----考虑只显示本单位的情况start-----
if (this.txthy_ifshowcurcomp.Text == "是")
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
ls_dept1 = ls_dept1.Substring(0, 3);
string ls_curdept = Session["hydeptid"].ToString();
ls_curdept = ls_curdept.Substring(0, 3);
if (ls_dept1 == ls_curdept)
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
dt.Clear();
}
}
//----考虑只显示本单位的情况end-------
//----考虑只显示和登记人同单位的情况start-----
if (this.txthy_ifshowcurcomp.Text == "和登记人同单位")
{
if (Request.QueryString["docid"] != null)
{
//得到登记人的部门ID
string ls_djrbmid = "";
string sql = "select * from hyc_" + this.txttableid.Text+" where DOCID='" + Request.QueryString["docid"].ToString()+"'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
ls_djrbmid = dt_flowmain.Rows[0]["hy_djrbmid"].ToString();
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1.Substring(0, 3) == ls_djrbmid.Substring(0, 3))
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
dt.Clear();
}
}
}
}
//----考虑只显示和登记人同单位的情况end-------
//----考虑只显示登记人的分管领导的情况start-----
if (this.txthy_ifshowcurcomp.Text == "登记人的分管领导")
{
if (Request.QueryString["docid"] != null)
{
//得到登记人的部门ID
string ls_djrbmid = "";
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
ls_djrbmid = dt_flowmain.Rows[0]["hy_djrbmid"].ToString();
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门(登记人的分管领导(部门ID前3位不一样后边一样))
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1.Substring(3) == ls_djrbmid.Substring(3))
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
dt.Clear();
}
}
}
}
//----考虑只显示登记人的分管领导的情况end-------
//----只显示登记人start-----
if (this.txthy_ifshowcurdept.Text == "只显示登记人")
{
if (Request.QueryString["docid"] != null)
{
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
//先清空
this.Hy_deptlist_clr.Items.Clear();
Hy_deptlist_clr.Items.Insert(0, new ListItem(dt_flowmain.Rows[0]["hy_djrbmname"].ToString(), dt_flowmain.Rows[0]["hy_djrbmid"].ToString()));
//先清空
this.Hy_hjclr.Items.Clear();
Hy_hjclr.Items.Insert(0, new ListItem(dt_flowmain.Rows[0]["hy_djrname"].ToString(), dt_flowmain.Rows[0]["hy_djrid"].ToString()));
}
}
}
//----只显示登记人end-------
//----只显示当前用户本部门人员start-----
if (this.txthy_ifshowcurdept.Text == "是")
{
if (Request.QueryString["docid"] != null)
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1 == Session["hydeptid"].ToString())
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
dt.Clear();
}
}
}
//----只显示当前用户本部门人员end-------
//----自动传阅 start------------
DataTable dt_zdcy = Hyoa_flowwork.Getflowworkbyflowidtacheidnexttacheid(this.txtflowid.Text, this.txtcurtacheid.Text, this.Hy_nexttachename.SelectedValue);
if (dt_zdcy.Rows.Count > 0)
{
if (dt_zdcy.Rows[0]["hy_zdcyuserids"] != null)
{
if (dt_zdcy.Rows[0]["hy_zdcyuserids"].ToString() != "")
{
int ii=0;
//自动加载
string[] lv_zdcyuserids = dt_zdcy.Rows[0]["hy_zdcyuserids"].ToString().Split(',');
for (int i = 0; i < lv_zdcyuserids.Length; i++)
{
//根据系统名得到中文名
DataTable dt_user = Hyoa_user.Getuserallinfobyloginid(lv_zdcyuserids[i]);
if (dt_user.Rows.Count > 0)
{
this.Hy_selectedcyr.Items.Insert(ii, new ListItem(dt_user.Rows[0]["hy_username"].ToString(), lv_zdcyuserids[i]));
ii = ii + 1;
}
}
}
}
}
//----自动传阅 end------------
}
protected void Hy_nexttachename_SelectedIndexChanged(object sender, EventArgs e)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//后序环节处理人部门
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt = new DataTable();
//先清空
this.Hy_deptlist_clr.DataSource = dt;
this.Hy_deptlist_clr.DataTextField = "hy_deptname";
this.Hy_deptlist_clr.DataValueField = "hy_deptid";
this.Hy_deptlist_clr.DataBind();
//先得到后续环节处理人集合
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
this.Hy_deptlist_clr.Items.Insert(0, "--请选择--");
ls_temp1 = "";
int t = 1;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_deptid"].ToString() + ","))
{
}
else
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist_clr.Items.Insert(t, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_deptid"].ToString();
}
}
this.Hy_deptlist_clr.SelectedIndex = 0;
}
}
dt.Clear();
//后序环节传阅人员部门
//先清空
this.Hy_deptlist.DataSource = dt;
this.Hy_deptlist.DataTextField = "hy_deptname";
this.Hy_deptlist.DataValueField = "hy_deptid";
this.Hy_deptlist.DataBind();
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
dt = Hyoa_dept.Getdepts();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//解决多级部门后续提交时部门显示的问题 added by xf 20131226
string ls_deptname = "";
if (dt.Rows[i]["hy_deptid"].ToString().Length == 3)
{
ls_deptname = dt.Rows[i]["hy_deptname"].ToString();
}
else
{
ls_deptname = GetAllDeptNameByDeptId(dt.Rows[i]["hy_deptid"].ToString());
}
this.Hy_deptlist.Items.Insert(i, new ListItem(ls_deptname, dt.Rows[i]["hy_deptid"].ToString()));
}
this.Hy_deptlist.SelectedIndex = 0;
}
dt.Clear();
//后序环节处理人员
//先得到后续环节处理人集合
//先清空
this.Hy_hjclr.DataSource = dt;
this.Hy_hjclr.DataTextField = "hy_username";
this.Hy_hjclr.DataValueField = "hy_userid";
this.Hy_hjclr.DataBind();
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
//后序环节传阅人员
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
dt = Hyoa_user.Getusersbydeptid(this.Hy_deptlist.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_rylist.DataSource = dt;
this.Hy_rylist.DataTextField = "hy_username";
this.Hy_rylist.DataValueField = "hy_userid";
this.Hy_rylist.DataBind();
}
dt.Clear();
//得到 后续环节的默认环节 对应的 提醒默认值，然后进行赋值
string ls_temp_tacheid = this.Hy_nexttachename.SelectedValue.ToString();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_getrddoissendsmsandmsg = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.txtflowid.Text, ls_temp_tacheid);
if (dt_getrddoissendsmsandmsg.Rows.Count > 0)
{
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendSms"].ToString() == "是")
this.f_isSendsms_clr.Checked = true;
else
this.f_isSendsms_clr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendMessage"].ToString() == "是")
this.f_isSendjstx_clr.Checked = true;
else
this.f_isSendjstx_clr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendSms"].ToString() == "是")
this.f_isSendsms_cyr.Checked = true;
else
this.f_isSendsms_cyr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendMessage"].ToString() == "是")
this.f_isSendjstx_cyr.Checked = true;
else
this.f_isSendjstx_cyr.Checked = false;
this.txthy_ifshowcurcomp.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurcomp"].ToString();
this.txthy_ifshowcurdept.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurdept"].ToString();
}
//----考虑只显示本单位的情况start-----
if (this.txthy_ifshowcurcomp.Text == "是")
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
ls_dept1 = ls_dept1.Substring(0, 3);
string ls_curdept = Session["hydeptid"].ToString();
ls_curdept = ls_curdept.Substring(0, 3);
if (ls_dept1 == ls_curdept)
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
//先得到后续环节处理人集合
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
}
//----考虑只显示本单位的情况end-------
//----考虑只显示和登记人同单位的情况start-----
if (this.txthy_ifshowcurcomp.Text == "和登记人同单位")
{
if (Request.QueryString["docid"] != null)
{
//得到登记人的部门ID
string ls_djrbmid = "";
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
ls_djrbmid = dt_flowmain.Rows[0]["hy_djrbmid"].ToString();
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1.Substring(0, 3) == ls_djrbmid.Substring(0, 3))
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
}
}
}
//----考虑只显示和登记人同单位的情况end-------
//----考虑只显示登记人的分管领导的情况start-----
if (this.txthy_ifshowcurcomp.Text == "登记人的分管领导")
{
if (Request.QueryString["docid"] != null)
{
//得到登记人的部门ID
string ls_djrbmid = "";
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
ls_djrbmid = dt_flowmain.Rows[0]["hy_djrbmid"].ToString();
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1.Substring(3) == ls_djrbmid.Substring(3))
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
}
}
}
//----考虑只显示登记人的分管领导的情况end-------
//----只显示登记人start-----
if (this.txthy_ifshowcurdept.Text == "只显示登记人")
{
if (Request.QueryString["docid"] != null)
{
string sql = "select * from hyc_" + this.txttableid.Text + " where DOCID='" + Request.QueryString["docid"].ToString() + "'";
DataTable dt_flowmain = Hyoa_global.GetDataTable(sql);
if (dt_flowmain.Rows.Count > 0)
{
//先清空
this.Hy_deptlist_clr.Items.Clear();
Hy_deptlist_clr.Items.Insert(0, new ListItem(dt_flowmain.Rows[0]["hy_djrbmname"].ToString(), dt_flowmain.Rows[0]["hy_djrbmid"].ToString()));
//先清空
this.Hy_hjclr.Items.Clear();
Hy_hjclr.Items.Insert(0, new ListItem(dt_flowmain.Rows[0]["hy_djrname"].ToString(), dt_flowmain.Rows[0]["hy_djrid"].ToString()));
}
}
}
//----只显示登记人end-------
//----只显示当前用户本部门人员start-----
if (this.txthy_ifshowcurdept.Text == "是")
{
if (Request.QueryString["docid"] != null)
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1 == Session["hydeptid"].ToString())
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
this.Hy_hjclr.Items.Clear();
//在调用这个部门对应的人员
dt_nextflowuser.Clear();
dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (this.Hy_deptlist_clr.SelectedValue.ToString() == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + this.Hy_deptlist_clr.SelectedValue.ToString() + "' order by a.hy_deptsort,b.hy_sort";
}
}
dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
int t = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
this.Hy_hjclr.Items.Insert(t, new ListItem(dt.Rows[i]["hy_username"].ToString(), dt.Rows[i]["hy_userid"].ToString()));
t += 1;
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
dt.Clear();
}
}
//----只显示当前用户本部门人员end-------
}
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9990", this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
this.tdnewdoc.Visible = true; //新建
this.tddeldoc.Visible = true; //删除
}
else
{
this.isrole.Value = "0";
this.tdnewdoc.Visible = false; //新建
this.tddeldoc.Visible = false; //删除
}
if (this.txtdeptid.Value == "")
this.tdnewdoc.Visible = false; //新建
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt;
if (this.hy_name.Value != "")
{
if (this.txtdeptid.Value == "")
{
dt = Hyoa_user.GetusersbynameforCX(this.hy_name.Value);
}
else
{
dt = Hyoa_user.GetusersbydeptidforCX(this.txtdeptid.Value, this.hy_name.Value);
}
}
else
{
if (this.txtdeptid.Value == "")
{
//显示所有用户
dt = Hyoa_user.GetusersOrderbydeptsortandusersort();
}
else
{
//按部门ID显示
dt = Hyoa_user.Getusersbydeptid(this.txtdeptid.Value);
}
}
DataTable tempTable = dt.Clone();
DataColumn col = new DataColumn("ifjz", typeof(String)); //定义新的一列 是否兼职
tempTable.Columns.Add(col); //追加一列 add
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
if (dt.Rows[i]["hy_loginuid"].ToString() == "")
{
dr["ifjz"] = "<font color=red>[兼职信息]</font>"; //将新值赋给相应的列 add
}
else
{
dr["ifjz"] = ""; //将新值赋给相应的列 add
}
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
private void DataPlay()
{
////////得到当前模块对应的role
//////HyoaClass.Hyoa_mudel Hyoa_mudel = new HyoaClass.Hyoa_mudel();
//////DataTable dt_mudel = Hyoa_mudel.Getmudel(this.txtmudelid.Value);
//////string ls_role = "Role9999";
//////if (dt_mudel.Rows.Count > 0)
////// ls_role = dt_mudel.Rows[0]["hy_roleid"].ToString();
////////判断当前用户是否有统计权限
//////HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//////if (Hyoa_global.isHaveRole(ls_role, this.Session["hyuid"].ToString()))
//////{
////// this.isrole.Value = "1";
////// this.Button_Return.Visible = true; //统计
//////}
//////else
//////{
////// this.isrole.Value = "0";
////// this.Button_Return.Visible = false; //统计
//////}
HyoaClass.DAO db = new HyoaClass.DAO();
DataTable tempTable = new DataTable();
DataColumn coldeptname = new DataColumn("deptname", typeof(String));
tempTable.Columns.Add(coldeptname);
DataColumn colusername = new DataColumn("username", typeof(String));
tempTable.Columns.Add(colusername);
DataColumn col1 = new DataColumn("tatalvalue1", typeof(String));
tempTable.Columns.Add(col1);
DataColumn col2 = new DataColumn("tatalvalue2", typeof(String));
tempTable.Columns.Add(col2);
DataColumn col3 = new DataColumn("tatalvalue3", typeof(String));
tempTable.Columns.Add(col3);
string sql = "";
Double li_depttotal = 0;
Double li_deptusernum = 0;
Double li_dept_fts = 0;
float li_usertotal = 0;
//先得到部门，然后按部门进行统计
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
DataTable dt = Hyoa_dept.Getdepts();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
double lisum = 0;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
li_depttotal = 0;
li_deptusernum = 0;
li_dept_fts = 0;
//得到部门在选择时间段内的公摊总值
//sql = "select sum(a.hy_field36*a.hy_field37+a.hy_field38*a.hy_field40+a.hy_field39*a.hy_field71+a.hy_field76*a.hy_field81+a.hy_field77*a.hy_field82+a.hy_field78*a.hy_field83+a.hy_field79*a.hy_field84) as depttotal from hyp_flowmain a,hyp_flowmain b where a.hy_mudelid='" + this.txtmudelid.Value + "' and a.hy_tableid='" + this.txttableid.Value + "' and a.hy_curtacheid='**' and a.hy_djrbmid='" + dt.Rows[i]["hy_deptid"].ToString() + "' and a.hy_field1=b.hy_field3 and a.hy_field4=b.hy_field1 and b.hy_field2='否'";
sql = "select sum(a.hy_field36*a.hy_field37+a.hy_field38*a.hy_field40+a.hy_field39*a.hy_field71+a.hy_field76*a.hy_field81+a.hy_field77*a.hy_field82+a.hy_field78*a.hy_field83+a.hy_field79*a.hy_field84) as depttotal from hyp_flowmain a where a.hy_mudelid='" + this.txtmudelid.Value + "' and a.hy_tableid='" + this.txttableid.Value + "' and a.hy_curtacheid='**' and a.hy_djrbmid='" + dt.Rows[i]["hy_deptid"].ToString() + "' and a.hy_field7='否'";
if (this.hy_djsj_start_1.Value != "")
sql += " and a.hy_djsj >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and a.hy_djsj <= '" + this.hy_djsj_end_1.Value + "' ";
DataTable dt_depttatle = db.GetDataTable(sql);
if (dt_depttatle.Rows.Count > 0 && dt_depttatle.Rows[0]["depttotal"].ToString() != null && dt_depttatle.Rows[0]["depttotal"].ToString()!="")
li_depttotal = System.Double.Parse(dt_depttatle.Rows[0]["depttotal"].ToString());
//得到当前部门有几个人员
sql = "select count(*) as deptusernum from hyt_user where hy_deptid='" + dt.Rows[i]["hy_deptid"].ToString() + "'";
DataTable dt_deptusernum = db.GetDataTable(sql);
li_deptusernum = System.Int32.Parse(dt_deptusernum.Rows[0]["deptusernum"].ToString());
//部门分摊数
if (li_deptusernum == 0)
{ }
else
{
li_dept_fts = li_depttotal / li_deptusernum;
}
//得到该部门下边的人员
DataTable dt_user = Hyoa_user.Getusersbydeptid(dt.Rows[i]["hy_deptid"].ToString());
if (dt_user.Rows.Count > 0)
{
for (int j = 0; j < dt_user.Rows.Count; j++)
{
li_usertotal = 0;
//根据人员进行统计
sql = "select sum(a.hy_field36*a.hy_field37+a.hy_field38*a.hy_field40+a.hy_field39*a.hy_field71+a.hy_field76*a.hy_field81+a.hy_field77*a.hy_field82+a.hy_field78*a.hy_field83+a.hy_field79*a.hy_field84) as depttotal from hyp_flowmain a where a.hy_mudelid='" + this.txtmudelid.Value + "' and a.hy_tableid='" + this.txttableid.Value + "' and a.hy_curtacheid='**' and a.hy_bt='" + dt_user.Rows[j]["hy_username"].ToString() + "' and a.hy_field7='是'";
if (this.hy_djsj_start_1.Value != "")
sql += " and a.hy_djsj >= '" + this.hy_djsj_start_1.Value + "' ";
if (this.hy_djsj_end_1.Value != "")
sql += " and a.hy_djsj <= '" + this.hy_djsj_end_1.Value + "' ";
DataTable dt_usertatle = db.GetDataTable(sql);
if (dt_usertatle.Rows.Count > 0 && dt_usertatle.Rows[0]["depttotal"].ToString() != null && dt_usertatle.Rows[0]["depttotal"].ToString() != "")
{
li_usertotal = float.Parse(dt_usertatle.Rows[0]["depttotal"].ToString());
}
DataRow dr = tempTable.NewRow();
dr["deptname"] = dt.Rows[i]["hy_deptname"].ToString();
dr["username"] = dt_user.Rows[j]["hy_username"].ToString();
dr["tatalvalue1"] = li_usertotal.ToString("F2");
dr["tatalvalue2"] = li_dept_fts.ToString("F2");
dr["tatalvalue3"] = (li_usertotal + li_dept_fts).ToString("F2");
lisum += li_usertotal + li_dept_fts;
tempTable.Rows.Add(dr);
}
}
}
}
this.lblsum.Text = "合计总额：" + lisum.ToString("F2");
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_flowid;
string ls_nexttacheid;
string ls_deptid;
string ls_username;
string ls_userid;
string ls_opt;
ls_flowid = "";
ls_nexttacheid = "";
ls_deptid = "";
ls_username = "";
ls_userid = "";
ls_opt = "";
if (this.Request.QueryString["flowid"] != null)
{
ls_flowid = this.Request.QueryString["flowid"].ToString();
}
if (this.Request.QueryString["nexttacheid"] != null)
{
ls_nexttacheid = this.Request.QueryString["nexttacheid"].ToString();
}
if (this.Request.QueryString["deptid"] != null)
{
ls_deptid = this.Request.QueryString["deptid"].ToString();
}
if (this.Request.QueryString["opt"] != null)
{
ls_opt = this.Request.QueryString["opt"].ToString();
}
//如果opt等于clr，则表示处理人的域，如果opt等于cyr，则表示传阅人的域
if (ls_opt == "clr")
{
//后序环节处理人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt4 = Hyoa_flowtacheuser.Getcuruserinfobyflowidtacheiddeptid(ls_flowid, ls_nexttacheid, ls_deptid);
if (dt4.Rows.Count > 0)
{
for (int i = 0; i < dt4.Rows.Count; i++)
{
if (ls_username == "")
{
ls_username = dt4.Rows[i]["hy_username"].ToString();
ls_userid = dt4.Rows[i]["hy_userid"].ToString();
}
else
{
ls_username = ls_username + "+" + dt4.Rows[i]["hy_username"].ToString();
ls_userid = ls_userid + "+" + dt4.Rows[i]["hy_userid"].ToString();
}
}
}
dt4.Clear();
this.Response.Write(ls_username + "*" + ls_userid);
return ;
}
if (ls_opt == "cyr")
{
//后序环节传阅人员
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt3 = Hyoa_user.Getusersbydeptid(ls_deptid);
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
if (ls_username == "")
{
ls_username = dt3.Rows[i]["hy_username"].ToString();
ls_userid = dt3.Rows[i]["hy_userid"].ToString();
}
else
{
ls_username = ls_username + "+" + dt3.Rows[i]["hy_username"].ToString();
ls_userid = ls_userid + "+" + dt3.Rows[i]["hy_userid"].ToString();
}
}
}
dt3.Clear();
this.Response.Write(ls_username + "*" + ls_userid);
return;
}
////if (Request.QueryString["productid"] != null)
////{
// DataTable dt;
// TPortalClass.JpSupply JpSupply = new TPortalClass.JpSupply();
// if (HttpContext.Current.Request.Url.ToString().IndexOf("productname") > 0)
// {
// JpSupply.productname = Request.QueryString["productname"].ToString();
// dt = JpSupply.Getproductname();
// }
// else
// {
// dt = JpSupply.GetAllproductname();
// }
// string ls_name = "";
// //this.Response.Write("<div id=sampleLayer style=\"position:absolute; top:80px; left:285px; width:200px; height:100px; background:#EEEEEE; border: 1px solid #919191; font-family:Verdana; font-size:8pt\">");
// this.Response.Write("<div align=left id=sampleLayer style=\"position:absolute; top:80px; left:285px; width:300px; height:100px; background:#EEEEEE; overflow:scroll; border: 1px solid #919191; font-family:Verdana; font-size:8pt\">");
// //this.Response.Write("<div id=sampleLayer style=\"font: 0px/0px sans-serif;clear: both;display: block\">");
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// ls_name = ls_name + dt.Rows[i]["productname"].ToString();
// this.Response.Write("<li><a href=\"#\" onclick=document.forms[0].textfield.value='" + dt.Rows[i]["productname"].ToString() + "';>" + dt.Rows[i]["productname"].ToString() + "</a></li>");
// }
// //this.Response.Write(ls_name);
// this.Response.Write("</div>");
// //this.Response.Write("<div id=sampleLayer style=\"position:absolute; top:80px; left:285px; width:200px; height:100px; background:#EEEEEE; border: 1px solid #919191; font-family:Verdana; font-size:8pt\"><li><a href=\"#\" onclick=selectlist()>这是个简单</a></li><li>aaaa</li></divpt>");
// return;
////}
}
protected void Page_Load(object sender, EventArgs e)
{
string ls_flowid;
string ls_nexttacheid;
string ls_deptid;
string ls_username;
string ls_userid;
string ls_opt;
ls_flowid = "";
ls_nexttacheid = "";
ls_deptid = "";
ls_username = "";
ls_userid = "";
ls_opt = "";
if (this.Request.QueryString["flowid"] != null)
{
ls_flowid = this.Request.QueryString["flowid"].ToString();
}
if (this.Request.QueryString["nexttacheid"] != null)
{
ls_nexttacheid = this.Request.QueryString["nexttacheid"].ToString();
}
if (this.Request.QueryString["deptid"] != null)
{
ls_deptid = this.Request.QueryString["deptid"].ToString();
}
if (this.Request.QueryString["opt"] != null)
{
ls_opt = this.Request.QueryString["opt"].ToString();
}
//如果opt等于clr，则表示处理人的域，如果opt等于cyr，则表示传阅人的域
if (ls_opt == "clr")
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//后序环节处理人员
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
//先得到后续环节处理人集合
DataTable dt_nextflowuser = Hyoa_flowtacheuser.Getflowtacheusersbyflowidtacheid(ls_flowid, ls_nexttacheid);
if (dt_nextflowuser.Rows.Count > 0)
{
string ls_temp1 = "";
for (int i = 0; i < dt_nextflowuser.Rows.Count; i++)
{
ls_temp1 += "," + dt_nextflowuser.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += ",";
string sql = "";
if (ls_deptid == "--请选择--")
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') order by a.hy_deptsort,b.hy_sort";
}
}
else
{
if (Session["conntype"].ToString() == "SQL")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like '%,'+b.hy_userid+',%' and b.hy_deptid='" + ls_deptid + "' order by a.hy_deptsort,b.hy_sort";
}
if (Session["conntype"].ToString() == "ORACLE")
{
sql = "select * from hyt_dept a,hyt_user b where a.hy_deptid=b.hy_deptid and '" + ls_temp1 + "' like CONCAT(CONCAT('%,',b.hy_userid),',%') and b.hy_deptid='" + ls_deptid + "' order by a.hy_deptsort,b.hy_sort";
}
}
DataTable dt = Hyoa_global.GetDataTable_USER(sql);
if (dt.Rows.Count > 0)
{
ls_temp1 = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((ls_temp1 + ",").Contains("," + dt.Rows[i]["hy_userid"].ToString() + ","))
{
}
else
{
//开始输出
if (ls_username == "")
{
ls_username = dt.Rows[i]["hy_username"].ToString();
ls_userid = dt.Rows[i]["hy_userid"].ToString();
}
else
{
ls_username += "+" + dt.Rows[i]["hy_username"].ToString();
ls_userid += "+" + dt.Rows[i]["hy_userid"].ToString();
}
ls_temp1 += "," + dt.Rows[i]["hy_userid"].ToString();
}
}
}
}
this.Response.Write(ls_username + "*" + ls_userid);
return ;
}
if (ls_opt == "cyr")
{
//后序环节传阅人员
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt3 = Hyoa_user.Getusersbydeptid(ls_deptid);
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
if (ls_username == "")
{
ls_username = dt3.Rows[i]["hy_username"].ToString();
ls_userid = dt3.Rows[i]["hy_userid"].ToString();
}
else
{
ls_username = ls_username + "+" + dt3.Rows[i]["hy_username"].ToString();
ls_userid = ls_userid + "+" + dt3.Rows[i]["hy_userid"].ToString();
}
}
}
dt3.Clear();
this.Response.Write(ls_username + "*" + ls_userid);
return;
}
}
protected void Hy_nexttachename_SelectedIndexChanged(object sender, EventArgs e)
{
//后序环节处理人部门
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
DataTable dt2 = Hyoa_flowtacheuser.GetDeptInfobyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt2.Rows.Count > 0)
{
this.Hy_deptlist_clr.DataSource = dt2;
this.Hy_deptlist_clr.DataTextField = "hy_deptname";
this.Hy_deptlist_clr.DataValueField = "hy_deptid";
this.Hy_deptlist_clr.DataBind();
this.Hy_deptlist_clr.Items.Insert(0, "--请选择--");
this.Hy_deptlist_clr.SelectedIndex = 0;
}
dt2.Clear();
//后序环节传阅人员
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
dt2 = Hyoa_dept.Getdepts();
if (dt2.Rows.Count > 0)
{
this.Hy_deptlist.DataSource = dt2;
this.Hy_deptlist.DataTextField = "hy_deptname";
this.Hy_deptlist.DataValueField = "hy_deptid";
this.Hy_deptlist.DataBind();
this.Hy_deptlist.SelectedIndex = 0;
}
dt2.Clear();
//后序环节处理人员
dt2 = Hyoa_flowtacheuser.Getcuruserinfobyflowidtacheiddeptid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString(), this.Hy_deptlist_clr.SelectedValue.ToString());
if (dt2.Rows.Count > 0)
{
this.Hy_hjclr.DataSource = dt2;
this.Hy_hjclr.DataTextField = "hy_username";
this.Hy_hjclr.DataValueField = "hy_userid";
this.Hy_hjclr.DataBind();
this.Hy_hjclr.SelectedIndex = 0;
}
dt2.Clear();
//后序环节传阅人员
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
dt2 = Hyoa_user.Getusersbydeptid(this.Hy_deptlist.SelectedValue.ToString());
if (dt2.Rows.Count > 0)
{
this.Hy_rylist.DataSource = dt2;
this.Hy_rylist.DataTextField = "hy_username";
this.Hy_rylist.DataValueField = "hy_userid";
this.Hy_rylist.DataBind();
this.Hy_rylist.SelectedIndex = 0;
}
dt2.Clear();
//得到 后续环节的默认环节 对应的 提醒默认值，然后进行赋值
string ls_temp_tacheid = this.Hy_nexttachename.SelectedValue.ToString();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_getrddoissendsmsandmsg = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.txtflowid.Text, ls_temp_tacheid);
if (dt_getrddoissendsmsandmsg.Rows.Count > 0)
{
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendSms"].ToString() == "是")
this.f_isSendsms_clr.Checked = true;
else
this.f_isSendsms_clr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendMessage"].ToString() == "是")
this.f_isSendjstx_clr.Checked = true;
else
this.f_isSendjstx_clr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendSms"].ToString() == "是")
this.f_isSendsms_cyr.Checked = true;
else
this.f_isSendsms_cyr.Checked = false;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendMessage"].ToString() == "是")
this.f_isSendjstx_cyr.Checked = true;
else
this.f_isSendjstx_cyr.Checked = false;
//this.txthy_ifshowcurcomp.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurcomp"].ToString();
this.txthy_ifshowcurdept.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurdept"].ToString();
}
//----只显示当前用户本部门人员start-----
if (this.txthy_ifshowcurdept.Text == "是")
{
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
if (Request.QueryString["docid"] != null)
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1 == Session["hydeptid"].ToString())
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_hjclr.Items.Clear();
if (tempTable.Rows.Count > 0)
{
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
//在调用这个部门对应的人员
DataTable dt = Hyoa_flowtacheuser.Getcuruserinfobyflowidtacheiddeptid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString(), this.Hy_deptlist_clr.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_hjclr.DataSource = dt;
this.Hy_hjclr.DataTextField = "hy_username";
this.Hy_hjclr.DataValueField = "hy_userid";
this.Hy_hjclr.DataBind();
}
}
}
}
//----只显示当前用户本部门人员end-------
}
private void DataPlay()
{
//文档ID
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (this.Request.QueryString["flowid"] != null)
{
this.txtflowid.Text = this.Request.QueryString["flowid"].ToString();
}
if (this.Request.QueryString["tacheid"] != null)
{
this.txtcurtacheid.Text = this.Request.QueryString["tacheid"].ToString();
}
//根据模块ID得到流程信息
HyoaClass.Hyoa_flowwork Hyoa_flowwork = new HyoaClass.Hyoa_flowwork();
DataTable dt = Hyoa_flowwork.Getflowworkbyflowidtacheid(this.txtflowid.Text, this.txtcurtacheid.Text);
if (dt.Rows.Count > 0)
{
//给相应的域赋值
//当前环节
this.Hy_CurrTacheName_Show.Text = dt.Rows[0]["hy_curtachename"].ToString();
//后续环节
this.Hy_nexttachename.DataSource = dt;
this.Hy_nexttachename.DataTextField = "hy_nexttachename";
this.Hy_nexttachename.DataValueField = "hy_nexttacheid";
this.Hy_nexttachename.DataBind();
this.Hy_nexttachename.SelectedIndex = 0;
//得到 后续环节的默认环节 对应的 提醒默认值，然后进行赋值
string ls_temp_tacheid = dt.Rows[0]["hy_nexttacheid"].ToString();
HyoaClass.Hyoa_flowtache Hyoa_flowtache = new HyoaClass.Hyoa_flowtache();
DataTable dt_getrddoissendsmsandmsg = Hyoa_flowtache.Getflowtachebyflowidtacheid(this.txtflowid.Text, ls_temp_tacheid);
if (dt_getrddoissendsmsandmsg.Rows.Count > 0)
{
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendSms"].ToString() == "是")
this.f_isSendsms_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdDoIsSendMessage"].ToString() == "是")
this.f_isSendjstx_clr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendSms"].ToString() == "是")
this.f_isSendsms_cyr.Checked = true;
if (dt_getrddoissendsmsandmsg.Rows[0]["hy_rdPassIsSendMessage"].ToString() == "是")
this.f_isSendjstx_cyr.Checked = true;
this.txthy_ifshowcurdept.Text = dt_getrddoissendsmsandmsg.Rows[0]["hy_ifshowcurdept"].ToString();
}
}
dt.Clear();
//后序环节处理人部门
HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
dt = Hyoa_flowtacheuser.GetDeptInfobyflowidtacheid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_deptlist_clr.DataSource = dt;
this.Hy_deptlist_clr.DataTextField = "hy_deptname";
this.Hy_deptlist_clr.DataValueField = "hy_deptid";
this.Hy_deptlist_clr.DataBind();
this.Hy_deptlist_clr.Items.Insert(0, "--请选择--");
this.Hy_deptlist_clr.SelectedIndex = 0;
}
dt.Clear();
//后序环节传阅人部门
HyoaClass.Hyoa_dept Hyoa_dept = new HyoaClass.Hyoa_dept();
dt = Hyoa_dept.Getdepts();
if (dt.Rows.Count > 0)
{
this.Hy_deptlist.DataSource = dt;
this.Hy_deptlist.DataTextField = "hy_deptname";
this.Hy_deptlist.DataValueField = "hy_deptid";
this.Hy_deptlist.DataBind();
this.Hy_deptlist.SelectedIndex = 0;
}
dt.Clear();
//后序环节处理人员
dt = Hyoa_flowtacheuser.Getcuruserinfobyflowidtacheiddeptid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString(), this.Hy_deptlist_clr.SelectedValue.ToString ());
if (dt.Rows.Count > 0)
{
this.Hy_hjclr.DataSource = dt;
this.Hy_hjclr.DataTextField = "hy_username";
this.Hy_hjclr.DataValueField = "hy_userid";
this.Hy_hjclr.DataBind();
//this.Hy_hjclr.SelectedIndex = 0;
}
dt.Clear();
//后序环节传阅人员
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
dt = Hyoa_user.Getusersbydeptid(this.Hy_deptlist.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_rylist.DataSource = dt;
this.Hy_rylist.DataTextField = "hy_username";
this.Hy_rylist.DataValueField = "hy_userid";
this.Hy_rylist.DataBind();
//this.Hy_rylist.SelectedIndex = 0;
}
dt.Clear();
//----只显示当前用户本部门人员start-----
//this.Response.Write("<script>alert('" + this.txthy_ifshowcurdept.Text + "');</script>");
if (this.txthy_ifshowcurdept.Text == "是")
{
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
if (Request.QueryString["docid"] != null)
{
DataTable tempTable = new DataTable();
DataColumn col = new DataColumn("value1", typeof(String)); //定义新的一列
tempTable.Columns.Add(col); //追加一列 add
DataColumn col2 = new DataColumn("value2", typeof(String)); //定义新的一列
tempTable.Columns.Add(col2); //追加一列 add
//更新部门
for (var j = 0; j < this.Hy_deptlist_clr.Items.Count; j++)
{
string ls_dept1 = this.Hy_deptlist_clr.Items[j].Value;
if (ls_dept1 == Session["hydeptid"].ToString())
{
DataRow dr = tempTable.NewRow();
dr["value1"] = Hy_deptlist_clr.Items[j].Text;
dr["value2"] = Hy_deptlist_clr.Items[j].Value;
tempTable.Rows.Add(dr);
}
}
//先清空
this.Hy_deptlist_clr.Items.Clear();
this.Hy_hjclr.Items.Clear();
if (tempTable.Rows.Count > 0)
{
this.Hy_deptlist_clr.DataSource = tempTable;
this.Hy_deptlist_clr.DataTextField = "value1";
this.Hy_deptlist_clr.DataValueField = "value2";
this.Hy_deptlist_clr.DataBind();
//在调用这个部门对应的人员
//HyoaClass.Hyoa_flowtacheuser Hyoa_flowtacheuser = new HyoaClass.Hyoa_flowtacheuser();
dt = Hyoa_flowtacheuser.Getcuruserinfobyflowidtacheiddeptid(this.txtflowid.Text, this.Hy_nexttachename.SelectedValue.ToString(), this.Hy_deptlist_clr.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
this.Hy_hjclr.DataSource = dt;
this.Hy_hjclr.DataTextField = "hy_username";
this.Hy_hjclr.DataValueField = "hy_userid";
this.Hy_hjclr.DataBind();
}
}
}
}
//----只显示当前用户本部门人员end-------
}
private void DataPlay(int PageNo)
{
//判断当前用户是否有新建删除权限
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
if (Hyoa_global.isHaveRole("Role9999", this.Session["hyuid"].ToString()))
{
this.isrole.Value = "1";
}
else
{
this.isrole.Value = "0";
}
//得到当前页号
this.curpage.Text = PageNo.ToString();
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dt;
if (this.hy_name.Value != "")
{
if (this.txtdeptid.Value == "")
{
dt = Hyoa_user.GetusersbynameforCX(this.hy_name.Value);
}
else
{
dt = Hyoa_user.GetusersbydeptidforCX(this.txtdeptid.Value, this.hy_name.Value);
}
}
else
{
if (this.txtdeptid.Value == "")
{
//显示所有用户
dt = Hyoa_user.GetusersOrderbydeptsortandusersort();
}
else
{
//按部门ID显示
dt = Hyoa_user.Getusersbydeptid(this.txtdeptid.Value);
}
}
DataTable tempTable = dt.Clone();
for (int i = (PageNo - 1) * System.Int32.Parse(PageSize.Text); i < PageNo * System.Int32.Parse(PageSize.Text); i++)
{
if (i > dt.Rows.Count - 1)
break;
DataRow dr = tempTable.NewRow();
for (int j = 0; j < dt.Columns.Count; j++)
{
dr[dt.Columns[j].ColumnName] = dt.Rows[i][j];
}
tempTable.Rows.Add(dr);
}
int TotalRecord = dt.Rows.Count;
this.sumts.Text = TotalRecord.ToString();
this.sumts2.Text = TotalRecord.ToString();
this.ShowTotalRecord.Text = TotalRecord.ToString();
//计算及显示总页数
int TotalPage;
if (TotalRecord < System.Int32.Parse(PageSize.Text))
{
TotalPage = 1;
}
else
{
if (TotalRecord % System.Int32.Parse(PageSize.Text) != 0)
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text) + 1;
}
else
{
TotalPage = TotalRecord / System.Int32.Parse(PageSize.Text);
}
}
this.ShowTotalPage.Text = TotalPage.ToString();
this.rptlist.DataSource = tempTable;
this.rptlist.DataBind();
dt.Clear();
}
