public static ArrayList QueryListCate()
{
ArrayList r = new ArrayList();
List <Sys_XsOverCondtionCategory> lsf = new List <Sys_XsOverCondtionCategory>();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
if (iv.u.rcode != "xtgl")
{
where.Append(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
}
lsf = snsb.QueryList(where.ToString());
if (lsf != null)
{
foreach (Sys_XsOverCondtionCategory s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.ocode);
al.Add(s.oname);
al.Add(s.otype);
al.Add(s.ounit);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList CustQueryList()
{
ArrayList r = new ArrayList();
Sys_SizeTransformBll stfb = new Sys_SizeTransformBll();
List <Sys_SizeTransform> lsf = new List <Sys_SizeTransform>();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
lsf = stfb.QueryList(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
if (lsf != null)
{
foreach (Sys_SizeTransform s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.jcode);
al.Add(s.jname);
al.Add(s.jtype);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList(string mpcode)
{
ArrayList r = new ArrayList();
Sys_MenuBll sdb = new Sys_MenuBll();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
where.Append(" and mpcode ='" + mpcode + "'");
where.Append(sc.GetSqlWhere(" mshow ", "True", "", ""));
where.Append(" order by msort");
List <Sys_Menu> lsm = sdb.QueryList(where.ToString());
if (lsm != null)
{
foreach (Sys_Menu s in lsm)
{
ArrayList al = new ArrayList();
al.Add(s.mcode);
al.Add(s.mname);
al.Add(s.mhaschild);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryListFyJcT(string curpage, string pagesize)
{
ArrayList r = new ArrayList();
Sys_SizeTransformBll stfb = new Sys_SizeTransformBll();
List <Sys_SizeTransform> lsf = new List <Sys_SizeTransform>();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
int rcount = 0;
int pcount = 0;
StringBuilder where = new StringBuilder();
where.Append(sc.GetSqlWhere(" jtype ", "套", "", ""));
if (iv.u.rcode == "xtgl")
{
}
else
{
where.Append(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
}
lsf = stfb.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), where.ToString(), "id desc", ref rcount, ref pcount);
if (lsf != null)
{
r.Add(pcount);
foreach (Sys_SizeTransform s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.jcode);
al.Add(s.jname);
al.Add(s.jtype);
al.Add(s.mtg);
al.Add(s.mtk);
al.Add(s.mth);
al.Add(s.mtsl);
al.Add(s.lbg);
al.Add(s.lbk);
al.Add(s.lbh);
al.Add(s.lbsl);
al.Add(s.stlg);
al.Add(s.stlk);
al.Add(s.stlh);
al.Add(s.stlsl);
al.Add(s.ltlg);
al.Add(s.ltlk);
al.Add(s.ltlh);
al.Add(s.ltlsl);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList()
{
ArrayList r = new ArrayList();
List <Sys_CgNomalSize> lsf = new List <Sys_CgNomalSize>();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
if (iv.u.rcode != "xtgl")
{
where.Append(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
}
lsf = snsb.QueryList("");
if (lsf != null)
{
foreach (Sys_CgNomalSize s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.ncode);
al.Add(s.nname);
switch (s.ntype)
{
case "ms":
al.Add("门");
break;
case "mt":
al.Add("套");
break;
case "qt":
al.Add("其他");
break;
}
al.Add(s.olen);
al.Add(s.owid);
al.Add(s.odee);
al.Add(s.ofc);
al.Add(s.tlen);
al.Add(s.twid);
al.Add(s.tdee);
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 CustQueryListFyJcDoor(string curpage, string pagesize)
{
ArrayList r = new ArrayList();
Sys_SizeTransformBll stfb = new Sys_SizeTransformBll();
List <Sys_SizeTransform> lsf = new List <Sys_SizeTransform>();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
int rcount = 0;
int pcount = 0;
StringBuilder where = new StringBuilder();
where.Append(sc.GetSqlWhere(" jtype ", "门扇", "", ""));
where.Append(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
lsf = stfb.QueryList(Convert.ToInt32(curpage), Convert.ToInt32(pagesize), where.ToString(), "id desc", ref rcount, ref pcount);
if (lsf != null)
{
r.Add(pcount);
foreach (Sys_SizeTransform s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.jcode);
al.Add(s.jname);
al.Add(s.dg);
al.Add(s.dk);
al.Add(s.dh);
al.Add(s.mcomputermethod == "比例" ? "比例" : "固定");
al.Add(s.d1sl);
al.Add(s.d2sl);
al.Add(s.d1k);
al.Add(s.d2k);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList()
{
ArrayList r = new ArrayList();
Sys_NomalSizeBll snsb = new Sys_NomalSizeBll();
List <Sys_NomalSize> lsf = new List <Sys_NomalSize>();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
if (iv.u.rcode == "xtgl")
{
}
else
{
where.Append(" and dcode ='" + iv.u.dcode.Substring(0, 8) + "'");
}
lsf = snsb.QueryList(where.ToString());
if (lsf != null)
{
foreach (Sys_NomalSize s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.ncode);
al.Add(s.nname);
al.Add(s.nattr);
al.Add(s.ng);
al.Add(s.nk);
al.Add(s.nh);
al.Add(s.nf);
al.Add(s.nsl);
r.Add(al);
}
}
}
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 QueryList()
{
ArrayList r = new ArrayList();
List <Sys_Package> lsf = new List <Sys_Package>();
SqlCondtion sc = new SqlCondtion();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
StringBuilder where = new StringBuilder();
if (iv.u.rcode != "xtgl")
{
where.Append(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
}
lsf = spb.QueryList("");
if (lsf != null)
{
foreach (Sys_Package s in lsf)
{
ArrayList al = new ArrayList();
al.Add(s.pcode);
al.Add(s.pname);
al.Add(s.basenum);
al.Add(s.zjtype);
al.Add(s.istz);
al.Add(s.tznum);
al.Add(s.psort);
al.Add(s.maxnum);
al.Add(s.hlvalue + "-" + s.htvalue);
al.Add(s.klvalue + "-" + s.ktvalue);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
