public JsonResult InitRptTemp(string emcode, string rtcode) { JsonData d = new JsonData(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_RptTemp sa = new Sys_RptTemp(); if (rtcode != "") { sa = stb.Query(" and rtcode='" + rtcode + "'"); } else { Sys_EventMenu sem = semb.Query(" and emcode='" + emcode + "'"); if (sem != null) { sa.emcode = sem.emcode; sa.emname = sem.emname; } sa.rtcode = stb.CreateCode().ToString().PadLeft(4, '0'); } d.d = js.Serialize(sa); } else { d.d = iv.badstr; } return(Json(d)); }
public JsonResult InitTabMenuAbc(string tmcode, string id) { JsonData d = new JsonData(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_TabMenuAbc sal = new Sys_TabMenuAbc(); if (id != "") { sal = stmab.Query(" and id=" + id + ""); } else { Sys_EventMenu stm = semb.Query(" and emcode='" + tmcode + "'"); sal.id = 0; sal.tmcode = stm.emcode; sal.tmname = stm.emname; } d.d = js.Serialize(sal); } else { d.d = iv.badstr; } return(Json(d)); }
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 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 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 JsonResult QueryList() { JsonData d = new JsonData(); ArrayList r = new ArrayList(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { string where = ""; r.Add(iv.badstr); if (iv.u.rcode != "xtgl") { where = " and dcode ='" + iv.u.dcode.Substring(0, 8) + "'"; } List <Sys_ProductionXqTemp> ls = sptcb.QueryList(where); if (ls != null) { foreach (Sys_ProductionXqTemp sw in ls) { ArrayList al = new ArrayList(); al.Add(sw.qtcode); al.Add(sw.qtname); al.Add(sw.qttemp); al.Add(sw.qtemp); Sys_EventMenu sem = semb.Query(" and emcode='" + sw.emcode + "'"); if (sem != null) { al.Add(sem.emname); } else { al.Add(""); } r.Add(al); } } } else { r.Add(iv.badstr); } d.d = js.Serialize(r); return(Json(d)); }
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 CustQueryList() { ArrayList r = new ArrayList(); List <Sys_OrderCode> lsr = new List <Sys_OrderCode>(); 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 = socb.QueryList(where); if (lsr != null) { foreach (Sys_OrderCode s in lsr) { ArrayList al = new ArrayList(); Sys_EventMenu sem = symb.Query(" and emcode='" + s.emcode + "'"); al.Add(s.ccode); al.Add(s.cname); al.Add(sem == null ? "" : sem.emname); al.Add(s.inum); al.Add(s.years); al.Add(s.prestr); 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); }
public static string SaveProduceCyc(string bdcode, string ccode, string cid, string cname, string cnum, string csql, string dcode, string emcode, string otype) { string r = ""; Sys_ProduceCyc sv = new Sys_ProduceCyc(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_Brands sb = sbb.Query(" and pbcode='" + bdcode + "'"); Sys_EventMenu sem = semb.Query(" and emcode='" + emcode + "'"); Sys_Depment sd = sdb.Query(" and dcode='" + dcode + "'"); sv.ccode = ccode; sv.cname = cname; sv.csql = csql; sv.cnum = Convert.ToInt32(cnum); if (sb != null) { sv.bdname = sb.pbname; sv.bdcode = sb.pbcode; } if (sem != null) { sv.emname = sem.emname; sv.emcode = emcode; } if (sd != null) { sv.fcode = dcode; sv.fname = sd.dname; } if (iv.u.rcode == "xtgl") { sv.dcode = ""; } else { sv.dcode = iv.u.dcode.Substring(0, 8); } sv.cdate = DateTime.Now.ToString(); sv.maker = iv.u.ename; sv.otype = otype; if (cid == "0") { if (spcb.Add(sv) > 0) { r = "S"; } else { r = "F"; } } else { if (spcb.Update(sv)) { r = "S"; } else { r = "F"; } } } else { r = iv.badstr; } return(r); }
public JsonResult SaveTemp(string emenu, string id, string ptype, string tbody, string ttype, string utype) { JsonData d = new JsonData(); Sys_Templet sa = new Sys_Templet(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { Sys_EventMenu sem = semb.Query(" and emcode='" + emenu + "'"); if (sem != null) { sa.emcode = sem.emcode; sa.emname = sem.emname; } else { sa.emcode = ""; sa.emname = ""; } sa.ttype = ttype; sa.ttext = tbody; if (iv.u.rcode == "xtgl") { sa.dcode = "00010001"; } else { sa.dcode = iv.u.dcode.Substring(0, 8); } sa.utype = utype; sa.ptype = ptype; sa.cdate = DateTime.Now.ToString(); sa.maker = iv.u.ename; if (id == "0") { if (stb.Add(sa) > 0) { d.d = "S"; } else { d.d = "F"; } } else { sa.id = Convert.ToInt32(id); if (stb.Update(sa)) { d.d = "S"; } else { d.d = "F"; } } } else { d.d = iv.badstr; } return(Json(d)); }