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