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