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); }