public static ArrayList QueryList(string dcode)
{
ArrayList r = new ArrayList();
Sys_EmployeeBll seb = new Sys_EmployeeBll();
Sys_DepmentBll sdb = new Sys_DepmentBll();
Sys_RoleBll srb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <Sys_Employee> ls = seb.QueryList(" and dcode='" + dcode + "' and estate='true'");
if (ls != null)
{
foreach (Sys_Employee s in ls)
{
Sys_Depment dep = sdb.Query(" and dcode='" + s.dcode + "'");
Sys_Role sr = srb.Query(" and rcode='" + s.rcode + "'");
ArrayList al = new ArrayList();
al.Add(s.eno);
al.Add(s.ename);
al.Add(dep == null?"":dep.dname);
al.Add(sr == null ? "" :sr.rname);
al.Add(s.estate == true ? "是" : "否");
al.Add(s.elogin == true?"是":"否");
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryTabTitle(string emcode)
{
ArrayList r = new ArrayList();
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_RoleBll srb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <Sys_ViewTable> ls = svb.Querytab(emcode, iv.u.rcode);
if (ls != null)
{
foreach (Sys_ViewTable s in ls)
{
ArrayList al = new ArrayList();
al.Add(s.tabcode);
al.Add(s.tabname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList(string emcode)
{
ArrayList r = new ArrayList();
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_RoleBll srb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <Sys_ViewTable> ls = svb.QueryList(" and emcode='" + emcode + "' ");
if (ls != null)
{
foreach (Sys_ViewTable s in ls)
{
Sys_Role sr = srb.Query(" and rcode='" + s.rcode + "'");
ArrayList al = new ArrayList();
al.Add(s.tcode);
al.Add(s.emname);
al.Add(sr == null?"":sr.rname);
al.Add(s.cols);
al.Add(s.sqlcols);
al.Add(s.sqlcondition);
al.Add(s.ecols);
al.Add(s.esqlcols);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList()
{
ArrayList r = new ArrayList();
Sys_UserBll sub = new Sys_UserBll();
SqlCondtion sc = new SqlCondtion();
Sys_EmployeeBll seb = new Sys_EmployeeBll();
Sys_RoleBll srb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
//where.Append(sc.GetSqlWhere(" ulogin ", "true", "", ""));
if (iv.u.rcode == "xtgl")
{
}
else
{
where.Append(" and eno in (select eno from Sys_Employee where dcode like '" + iv.u.dcode.Substring(0, 8) + "%')");
}
List <Sys_User> ls = sub.QueryList(where.ToString());
if (ls != null)
{
foreach (Sys_User s in ls)
{
Sys_Employee sr = seb.Query(" and eno='" + s.eno + "'");
ArrayList al = new ArrayList();
if (sr != null)
{
Sys_Role srs = srb.Query(" and rcode='" + sr.rcode + "'");
al.Add(sr.eno);
al.Add(s.uname);
al.Add(sr.ename);
al.Add(sr.dname);
al.Add(srs == null ? "" : srs.rname);
al.Add(s.ulogin == true ? "<span style='color:green'>正常</span>" : "<span style='color:red'>停用</span>");
r.Add(al);
}
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryTableTitle(string emcode, string tab)
{
ArrayList r = new ArrayList();
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_RoleBll srb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
ArrayList r1 = svb.QueryTableCols(emcode, tab, iv.u.rcode);
r.Add(r1);
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList(string account, string curpage, string pagesize, string udepname, string uname)
{
ArrayList r = new ArrayList();
Sys_UserBll seb = new Sys_UserBll();
Sys_RoleBll srb = new Sys_RoleBll();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
where.Append(sc.GetSqlWhere(" uname ", account, "l", ""));
where.Append(sc.GetSqlWhere(" dname ", udepname, "l", ""));
where.Append(sc.GetSqlWhere(" ename ", uname, "l", ""));
//where.Append(sc.GetSqlWhere(" estate ", "true", "", ""));
int rcount = 0;
int pcount = 0;
DataTable ls = seb.QueryTable(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), where.ToString(), "id desc", ref rcount, ref pcount);
if (ls != null)
{
r.Add(pcount);
foreach (DataRow s in ls.Rows)
{
Sys_Role sr = srb.Query(" and rcode='" + s["rcode"].ToString() + "'");
ArrayList al = new ArrayList();
al.Add(s["id"].ToString());
al.Add(s["uname"].ToString());
al.Add(s["ename"].ToString());
al.Add(s["dname"].ToString());
al.Add(sr == null?"":sr.rname);
al.Add(s["ulogin"].ToString() == "True"?"启用":"停用");
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryListFyRole(string curpage, string pagesize)
{
ArrayList r = new ArrayList();
Sys_RoleBll sdb = new Sys_RoleBll();
List <Sys_Role> lsr = new List <Sys_Role>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
string where = "";
r.Add(iv.badstr);
int rcount = 0;
int pcount = 0;
if (iv.u.rcode == "xtgl")
{
}
else
{
where = " and dcode='" + iv.u.dcode.Substring(0, 8) + "'";
}
lsr = sdb.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), where, "id desc", ref rcount, ref pcount);
if (lsr != null)
{
r.Add(pcount);
foreach (Sys_Role s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.rcode);
al.Add(s.rname);
al.Add(s.rdetail);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string InitRole(string rcode)
{
string r = "";
Sys_Role sr = new Sys_Role();
Sys_Role vsr = new Sys_Role();
Sys_RoleBll sdb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
vsr = sdb.Query(" and rcode='" + rcode + "'");
if (vsr != null)
{
if (iv.u.rcode != "xtgl")
{
vsr.rread = true;
}
r = js.Serialize(vsr);
}
else
{
if (iv.u.rcode != "xtgl")
{
sr.rread = true;
}
sr.rname = "";
sr.id = 0;
sr.rdetail = "";
sr.rcode = sdb.CreateCode().ToString().PadLeft(4, '0');
r = js.Serialize(sr);
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList QueryListRole()
{
ArrayList r = new ArrayList();
Sys_RoleBll sdb = new Sys_RoleBll();
Sys_DepmentBll sb = new Sys_DepmentBll();
List <Sys_Role> lsr = new List <Sys_Role>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
string where = "";
if (iv.u.rcode == "xtgl")
{
}
else
{
where = " and dcode='" + iv.u.dcode.Substring(0, 8) + "'";
}
lsr = sdb.QueryList(where);
if (lsr != null)
{
foreach (Sys_Role s in lsr)
{
ArrayList al = new ArrayList();
al.Add(s.rcode);
al.Add(s.rname);
al.Add(s.rdetail);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string DelRole(string rcode)
{
string r = "";
Sys_RoleBll sdb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (sdb.Delete(" and rcode='" + rcode + "'"))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static string SaveRole(string rattr, string rcode, string rdep, string rdetail, string rname, string rid)
{
string r = "";
Sys_RoleBll sdb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_Role sr = new Sys_Role();
sr.rname = rname;
sr.rcode = rcode;
sr.rdetail = rdetail;
sr.dcode = rdep;
sr.cdate = DateTime.Now.ToString();
sr.maker = iv.u.ename;
sr.rtype = rattr;
if (iv.u.rcode == "xtgl")
{
sr.rread = true;
}
else
{
sr.rread = false;
}
if (rattr == "a")
{
sr.dcode = "";
}
else
{
sr.dcode = rdep;
}
if (rid == "0")
{
if (sdb.Add(sr) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
if (sdb.Update(sr))
{
r = "S";
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
