public void GridViewBind()
{
string str1 = " WHERE B.UI_LX='企业' AND DL_ZT='登录系统' AND DL_RQ BETWEEN '" + hkdb.GetStr(txtSdate.Text) + "' AND '" + hkdb.GetStr(txtEdate.Text) + "'";
//个人权限
if (hkdb.StrIx("603091", Session["roleqx"].ToString()))
{
str1 = str1 + " AND DL_ID='" + this.Session["userid"] + "'";
}
//部门权限
if (hkdb.StrIx("603092", Session["roleqx"].ToString()))
{
if (this.Session["bmglqx"].ToString() == "Y")
{
string cal = "";
SqlDataReader dr_bm = SqlHelper.ExecuteReader("EXEC sp_RECUR_BM '" + this.Session["deptid"].ToString() + "'");
while (dr_bm.Read())
{
if (string.IsNullOrEmpty(cal))
{
cal = dr_bm["bm_id"].ToString();
}
else
{
cal = cal + "','" + dr_bm["bm_id"].ToString();
}
}
dr_bm.Close();
str1 = str1 + " AND DL_ID IN(SELECT UI_ID FROM YH WHERE UI_SSBM IN('" + cal + "'))";
}
else
{
str1 = str1 + " AND DL_ID IN(SELECT UI_ID FROM YH WHERE UI_SSBM='" + this.Session["deptid"] + "')";
}
}
if (!string.IsNullOrEmpty(rysq.Text))
{
str1 = str1 + " AND (DL_ID LIKE '%" + hkdb.GetStr(rysq.Text) + "%' OR UI_DESC LIKE '%" + hkdb.GetStr(rysq.Text) + "%')";
}
if (!string.IsNullOrEmpty(dl_rk.SelectedValue))
{
str1 = str1 + " AND dl_rk='" + dl_rk.SelectedValue + "'";
}
AspNetPager1.RecordCount = (int)SqlHelper.ExecuteScalar("SELECT COUNT(*) FROM(SELECT A.DL_ID,B.UI_DESC,COUNT(*)AS DLNUMS FROM HK_DLRZ A LEFT OUTER JOIN YH B ON(A.DL_ID=B.UI_ID) " + str1 + " GROUP BY A.DL_ID,B.UI_DESC)Z");
DataSet ds = SqlHelper.ExecuteDs("SELECT A.DL_ID,B.UI_DESC,COUNT(*)AS DLNUMS FROM HK_DLRZ A LEFT OUTER JOIN YH B ON(A.DL_ID=B.UI_ID) " + str1 + " GROUP BY A.DL_ID,B.UI_DESC ORDER BY COUNT(*) DESC", AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize);
GridView1.DataSource = ds;
GridView1.DataBind();
}
public void GridViewBind()
{
string str1 = " WHERE 1=1";
//个人权限
if (hkdb.StrIx("603091", Session["roleqx"].ToString()))
{
str1 = str1 + " AND UserID='" + this.Session["userid"] + "'";
}
//部门权限
if (hkdb.StrIx("603092", Session["roleqx"].ToString()))
{
if (this.Session["bmglqx"].ToString() == "Y")
{
string cal = "";
SqlDataReader dr_bm = SqlHelper.ExecuteReader("EXEC sp_RECUR_BM '" + this.Session["deptid"].ToString() + "'");
while (dr_bm.Read())
{
if (string.IsNullOrEmpty(cal))
{
cal = dr_bm["bm_id"].ToString();
}
else
{
cal = cal + "','" + dr_bm["bm_id"].ToString();
}
}
dr_bm.Close();
str1 = str1 + " AND DeptID IN('" + cal + "')";
}
else
{
str1 = str1 + " AND DeptID='" + this.Session["deptid"] + "'";
}
}
if (!string.IsNullOrEmpty(txtSdate.Text))
{
str1 = str1 + " AND NowTime>='" + hkdb.GetStr(txtSdate.Text) + "'";
}
if (!string.IsNullOrEmpty(txtEdate.Text))
{
str1 = str1 + " AND NowTime<='" + hkdb.GetStr(txtEdate.Text) + "'";
}
if (!string.IsNullOrEmpty(UserName.Text))
{
str1 = str1 + " AND UserName LIKE '%" + hkdb.GetStr(UserName.Text) + "%'";
}
if (!string.IsNullOrEmpty(IPAddress.Text))
{
str1 = str1 + " AND IPAddress='" + hkdb.GetStr(IPAddress.Text) + "'";
}
if (!string.IsNullOrEmpty(LogContent.Text))
{
str1 = str1 + " AND LogContent LIKE '%" + hkdb.GetStr(LogContent.Text) + "%'";
}
if (!string.IsNullOrEmpty(ModuName.Text))
{
if (ModuName.Text == "00000")
{
str1 = str1 + " AND MODUID='00000'";
}
else
{
str1 = str1 + " AND (MODUID LIKE '%" + hkdb.GetStr(ModuName.Text) + "%' OR MODU_MC LIKE '%" + hkdb.GetStr(ModuName.Text) + "%')";
}
}
else
{
str1 = str1 + " AND MODUID<>'00000'";
}
AspNetPager1.RecordCount = (int)SqlHelper.ExecuteScalar("SELECT COUNT(*) FROM HK_SYSTEMLOG A LEFT OUTER JOIN HK_MODU B ON(A.MODUID=B.MODU_ID) " + str1 + "");
DataSet ds = SqlHelper.ExecuteDs("SELECT A.*,B.MODU_MC FROM HK_SYSTEMLOG A LEFT OUTER JOIN HK_MODU B ON(A.MODUID=B.MODU_ID) " + str1 + " ORDER BY NOWTIME DESC", AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
hkdb.VeriSess("3");
if (!IsPostBack)
{
hkdb.PassTo("60302", "0");
LabelRole.Text = Request.QueryString["rolename"];
GridviewBind();
SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM JS WHERE ROLE_ID='" + hkdb.GetStr(Request.QueryString["roleid"]) + "'");
if (datar.Read())
{
RoleQxStr = datar["role_qx"].ToString();
datar.Close();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
CheckBox Co_que = (CheckBox)row.FindControl("o_que");
Label Lo_que = (Label)row.FindControl("o_queid");
CheckBox Co_full = (CheckBox)row.FindControl("o_full");
Label Lo_full = (Label)row.FindControl("o_fullid");
CheckBox Co_add = (CheckBox)row.FindControl("o_add");
Label Lo_add = (Label)row.FindControl("o_addid");
CheckBox Co_mod = (CheckBox)row.FindControl("o_mod");
Label Lo_mod = (Label)row.FindControl("o_modid");
CheckBox Co_del = (CheckBox)row.FindControl("o_del");
Label Lo_del = (Label)row.FindControl("o_delid");
CheckBox Co_exp = (CheckBox)row.FindControl("o_exp");
Label Lo_exp = (Label)row.FindControl("o_expid");
CheckBox Co_aud = (CheckBox)row.FindControl("o_aud");
Label Lo_aud = (Label)row.FindControl("o_audid");
CheckBox Co_exe = (CheckBox)row.FindControl("o_exe");
Label Lo_exe = (Label)row.FindControl("o_exeid");
RadioButton Cindi = (RadioButton)row.FindControl("indi");
Label Lindi = (Label)row.FindControl("indiid");
RadioButton Cdept = (RadioButton)row.FindControl("dept");
Label Ldept = (Label)row.FindControl("deptid");
RadioButton Ccorp = (RadioButton)row.FindControl("corp");
Label Lcorp = (Label)row.FindControl("corpid");
if (hkdb.StrIx(Lindi.Text, RoleQxStr) && Lindi.Text != "0")
{
Cindi.Checked = true;
}
if (hkdb.StrIx(Ldept.Text, RoleQxStr) && Ldept.Text != "0")
{
Cdept.Checked = true;
}
if (hkdb.StrIx(Lcorp.Text, RoleQxStr) && Lcorp.Text != "0")
{
Ccorp.Checked = true;
}
if (hkdb.StrIx(Lo_full.Text, RoleQxStr) && Lo_full.Text != "0")
{
Co_full.Checked = true;
}
if (hkdb.StrIx(Lo_add.Text, RoleQxStr) && Lo_add.Text != "0")
{
Co_add.Checked = true;
}
if (hkdb.StrIx(Lo_mod.Text, RoleQxStr) && Lo_mod.Text != "0")
{
Co_mod.Checked = true;
}
if (hkdb.StrIx(Lo_del.Text, RoleQxStr) && Lo_del.Text != "0")
{
Co_del.Checked = true;
}
if (hkdb.StrIx(Lo_exp.Text, RoleQxStr) && Lo_exp.Text != "0")
{
Co_exp.Checked = true;
}
if (hkdb.StrIx(Lo_aud.Text, RoleQxStr) && Lo_aud.Text != "0")
{
Co_aud.Checked = true;
}
if (hkdb.StrIx(Lo_exe.Text, RoleQxStr) && Lo_exe.Text != "0")
{
Co_exe.Checked = true;
}
if (hkdb.StrIx(Lo_que.Text, RoleQxStr) && Lo_que.Text != "0")
{
Co_que.Checked = true;
}
}
}
else
{
datar.Close();
mydb.Alert_Goto("此记录不存在，可能已被删除！", "role.aspx");
}
//快速定位
string Sql = "";
if (this.Session["systype"].ToString() != "A") //主登录页
{
Sql = " AND MODU_LX IN('P','" + this.Session["systype"] + "')";
}
int k = 0;
SqlDataReader dr = SqlHelper.ExecuteReader("SELECT MODU_ID,MODU_MC FROM hk_Modu WHERE YN_OPER='是' AND LEN(MODU_ID)=3 " + Sql + " ORDER BY ORDERID");
while (dr.Read())
{
lbldw.Text += "[<a href=#" + dr["modu_id"] + " class=yellow>" + dr["modu_mc"] + "</a>] ";
k = k + 1;
if (k == 8)
{
lbldw.Text += "<br>";
k = 0;
}
}
dr.Close();
}
}
