public static string InitLButton(string emcode, string bcode)
{
string r = "";
Sys_EventMenuBll semb = new Sys_EventMenuBll();
Sys_EventMenu sem = new Sys_EventMenu();
Sys_ButtonBll sbb = new Sys_ButtonBll();
Sys_Button sb = new Sys_Button();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (bcode == "" || bcode == null)
{
sem = semb.Query(" and emcode='" + emcode + "'");
sb.id = 0;
sb.bname = "";
sb.bcode = sbb.CreateCode().ToString().PadLeft(4, '0');
sb.emname = sem.emname == null ? "" : sem.emname;
sb.emcode = sem.emcode == null ? "" : sem.emcode;
sb.bshow = true;
}
else
{
sb = sbb.Query(" and bcode='" + bcode + "'");
}
r = js.Serialize(sb);
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList QueryListByEmenu(string emcode)
{
ArrayList r = new ArrayList();
Sys_OrderTypeBll svb = new Sys_OrderTypeBll();
Sys_EventMenuBll srb = new Sys_EventMenuBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <Sys_OrderType> ls = svb.QueryList(" and emcode='" + emcode + "'");
if (ls != null)
{
foreach (Sys_OrderType s in ls)
{
ArrayList al = new ArrayList();
al.Add(s.tcode);
al.Add(s.tname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string InitTree(string emcode, string tcode)
{
string r = "";
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_ViewTable st = new Sys_ViewTable();
Sys_EventMenuBll seb = new Sys_EventMenuBll();
Sys_EventMenu sem = new Sys_EventMenu();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (emcode != "")
{
st.tcode = svb.CreateCode().ToString().PadLeft(4, '0');
st.tname = "";
st.emcode = emcode;
st.emname = seb.Query(" and emcode='" + emcode + "'").emname;
st.id = 0;
}
else
{
st = svb.Query(" and tcode='" + tcode + "'");
}
r = js.Serialize(st);
}
else
{
r = iv.badstr;
}
return(r);
}
public static string InitLMenu(string emcode)
{
string r = "";
Sys_EventMenuBll semb = new Sys_EventMenuBll();
Sys_EventMenu sem = new Sys_EventMenu();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (emcode == "")
{
sem.emcode = semb.CreateCode().ToString().PadLeft(4, '0');
}
else
{
sem = semb.Query(" and emcode='" + emcode + "'");
}
r = js.Serialize(sem);
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList QueryListEventMenuByAttr(string eattr)
{
ArrayList r = new ArrayList();
StringBuilder sql = new StringBuilder();
Sys_EventMenuBll semb = new Sys_EventMenuBll();
List <Sys_EventMenu> lsem = new List <Sys_EventMenu>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
sql.Append(" and emattrex='" + eattr + "'");
lsem = semb.QueryList(sql.ToString());
if (lsem != null)
{
foreach (Sys_EventMenu s in lsem)
{
ArrayList al = new ArrayList();
al.Add(s.emcode);
al.Add(s.emname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);;
}
return(r);
}
public static string SaveEventMenuEx(string emattr, string emcode, string eme, string emf, string emid, string eml, string emname, string emt, string mcode, string mname, string etype)
{
string r = "";
Sys_EventMenuBll semb = new Sys_EventMenuBll();
Sys_EventMenu sem = new Sys_EventMenu();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sem.emcode = emcode;
sem.emname = emname;
sem.isexp = Convert.ToInt32(eme);
sem.isflow = emf == "0" ? false : true;
sem.islist = eml == "0" ? false : true;
sem.isspe = emt == "0" ? false : true;
sem.mcode = mcode;
sem.mname = mname;
sem.emtype = etype;
sem.cdate = DateTime.Now.ToString();
sem.maker = iv.u.ename;
if (iv.u.rcode == "xtgl")
{
sem.emattr = emattr;
sem.emread = false;
}
else
{
sem.emattr = emattr;
sem.emread = false;
sem.dcode = iv.u.dcode.Substring(0, 8);
}
if (emid == "0")
{
if (semb.Add(sem) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
if (semb.Update(sem))
{
r = "S";
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList NQueryListEventMenu(string ptype, string pvalue)
{
ArrayList r = new ArrayList();
StringBuilder sql = new StringBuilder();
Sys_EventMenuBll semb = new Sys_EventMenuBll();
List <Sys_EventMenu> lsem = new List <Sys_EventMenu>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
if (iv.u.rcode != "xtgl")
{
sql.Append(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
}
if (ptype == "f")
{
sql.Append(" and isflow='true'");
}
if (ptype == "l")
{
sql.Append(" and islist='true'");
}
if (ptype == "t")
{
sql.Append(" and isspe='true'");
}
if (ptype == "e")
{
sql.Append(" and isexp=" + pvalue + " ");
}
if (ptype == "bb")
{
sql.Append(" and isbb='true'");
}
lsem = semb.QueryList(sql.ToString());
if (lsem != null)
{
foreach (Sys_EventMenu s in lsem)
{
ArrayList al = new ArrayList();
al.Add(s.emcode);
al.Add(s.emname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);;
}
return(r);
}
public static ArrayList QueryListEventMenu(string e, string f, string l, string t)
{
ArrayList r = new ArrayList();
StringBuilder sql = new StringBuilder();
Sys_EventMenuBll semb = new Sys_EventMenuBll();
List <Sys_EventMenu> lsem = new List <Sys_EventMenu>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
if (iv.u.rcode != "xtgl")
{
sql.Append(" and dcode='" + iv.u.dcode.Substring(0, 8) + "'");
}
if (f != "")
{
sql.Append(" and isflow='true'");
}
if (l != "")
{
sql.Append(" and islist='true'");
}
if (t != "")
{
sql.Append(" and isspe='true'");
}
if (e != "")
{
sql.Append(" and isexp=" + Convert.ToInt32(e) + "");
}
lsem = semb.QueryList(sql.ToString());
if (lsem != null)
{
foreach (Sys_EventMenu s in lsem)
{
ArrayList al = new ArrayList();
al.Add(s.emcode);
al.Add(s.emname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);;
}
return(r);
}
public static ArrayList CustQueryList()
{
ArrayList r = new ArrayList();
Sys_EventMenuBll srb = new Sys_EventMenuBll();
Sys_DepmentBll sdb = new Sys_DepmentBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
string where = "";
if (iv.u.rcode == "xtgl")
{
}
else
{
where = " and dcode like '" + iv.u.dcode.Substring(0, 8) + "%'";
}
List <Sys_ProduceCyc> ls = spcb.QueryList(where);
if (ls != null)
{
foreach (Sys_ProduceCyc s in ls)
{
Sys_Depment d = sdb.Query(" and dcode='" + s.fcode + "'");
Sys_EventMenu em = srb.Query(" and emcode='" + s.emcode + "'");
ArrayList al = new ArrayList();
al.Add(s.ccode);
al.Add(s.cname);
al.Add(em == null ? "" : em.emname);
al.Add(d == null ? "" : d.dname);
al.Add(s.cnum);
al.Add(s.otype);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList()
{
ArrayList r = new ArrayList();
Sys_OrderTypeBll svb = new Sys_OrderTypeBll();
Sys_EventMenuBll srb = new Sys_EventMenuBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
string where = "";
if (iv.u.rcode != "xtgl")
{
where = " and dcode='" + iv.u.dcode.Substring(0, 8) + "'";
}
List <Sys_OrderType> ls = svb.QueryList(where);
if (ls != null)
{
foreach (Sys_OrderType s in ls)
{
Sys_EventMenu sem = srb.Query(" and emcode='" + s.emcode + "'");
ArrayList al = new ArrayList();
al.Add(s.tcode);
al.Add(s.tname);
if (sem != null)
{
al.Add(sem.emname);
}
else
{
al.Add("");
}
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList()
{
ArrayList r = new ArrayList();
Sys_EventMenuBll srb = new Sys_EventMenuBll();
Sys_DepmentBll sdb = new Sys_DepmentBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
string where = "";
if (iv.u.rcode != "xtgl")
{
where = " and dcode='" + iv.u.dcode.Substring(0, 8) + "' ";
}
List <Sys_ProduceCyc> ls = spcb.QueryList(where);
if (ls != null)
{
foreach (Sys_ProduceCyc s in ls)
{
ArrayList al = new ArrayList();
al.Add(s.ccode);
al.Add(s.cname);
al.Add(s.emname);
al.Add(s.fname);
al.Add(s.bdname);
al.Add(s.cnum);
al.Add(s.otype == "f"?"加急":"正常");
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList CustQueryMainEventMenu(string etype)
{
ArrayList r = new ArrayList();
StringBuilder sql = new StringBuilder();
Sys_EventMenuBll semb = new Sys_EventMenuBll();
List <Sys_EventMenu> lsem = new List <Sys_EventMenu>();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
string where = "";
if (iv.u.rcode == "xtgl")
{
where = " and emattr='a'";
}
else
{
where = " and (emattr='a' or dcode='" + iv.u.dcode.Substring(0, 8) + "')";
}
lsem = semb.QueryList(" and emtype='" + etype + "'" + where);
if (lsem != null)
{
foreach (Sys_EventMenu s in lsem)
{
ArrayList al = new ArrayList();
al.Add(s.emcode);
al.Add(s.emname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);;
}
return(r);
}
public static ArrayList CustQueryListByEmenu(string emcode)
{
ArrayList r = new ArrayList();
Sys_OrderTypeBll svb = new Sys_OrderTypeBll();
Sys_EventMenuBll srb = new Sys_EventMenuBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
string where = "";
if (iv.u.rcode == "xtgl")
{
}
else
{
where = " and (ttype='a' or dcode='" + iv.u.dcode.Substring(0, 8) + "')";
}
List <Sys_OrderType> ls = svb.QueryList(" and emcode='" + emcode + "'" + where);
if (ls != null)
{
foreach (Sys_OrderType s in ls)
{
ArrayList al = new ArrayList();
al.Add(s.tcode);
al.Add(s.tname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string DelEventMenu(string emcode)
{
string r = "";
Sys_EventMenuBll semb = new Sys_EventMenuBll();
Sys_EventMenu sem = new Sys_EventMenu();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (semb.Delete(emcode))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
