public static string CopyTree(string tcode)
{
string r = "";
Sys_ViewTableBll svb = new Sys_ViewTableBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_ViewTable sv = svb.Query(" and tcode='" + tcode + "'");
sv.id = 0;
sv.cols = sv.cols.Replace("\n", "");
sv.sqlcols = sv.sqlcols.Replace("\n", "");
sv.sqlcondition = sv.sqlcondition.Replace("\n", "");
sv.cdate = DateTime.Now.ToString();
sv.maker = iv.u.ename;
sv.ecols = sv.ecols.Replace("\n", "");
sv.esqlcols = sv.esqlcols.Replace("\n", "");
sv.tcode = svb.CreateCode().ToString().PadLeft(4, '0');
if (svb.Add(sv) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = 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 ArrayList QueryTabTitle(string emcode)
{
ArrayList r = new ArrayList();
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_RoleBll srb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <Sys_ViewTable> ls = svb.Querytab(emcode, iv.u.rcode);
if (ls != null)
{
foreach (Sys_ViewTable s in ls)
{
ArrayList al = new ArrayList();
al.Add(s.tabcode);
al.Add(s.tabname);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static ArrayList QueryList(string emcode)
{
ArrayList r = new ArrayList();
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_RoleBll srb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
List <Sys_ViewTable> ls = svb.QueryList(" and emcode='" + emcode + "' ");
if (ls != null)
{
foreach (Sys_ViewTable s in ls)
{
Sys_Role sr = srb.Query(" and rcode='" + s.rcode + "'");
ArrayList al = new ArrayList();
al.Add(s.tcode);
al.Add(s.emname);
al.Add(sr == null?"":sr.rname);
al.Add(s.cols);
al.Add(s.sqlcols);
al.Add(s.sqlcondition);
al.Add(s.ecols);
al.Add(s.esqlcols);
r.Add(al);
}
}
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string SaveTree(string dcsql, string dctitle, string lbemcode, string lbemname, string lbid, string lbrole, string lbsql, string lbtable, string lbtcode, string lbtitle, string lbtj, string lbyq, string lbyqname)
{
string r = "";
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_ViewTable sv = new Sys_ViewTable();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
sv.emname = lbemname;
sv.emcode = lbemcode;
sv.tcode = lbtcode;
sv.cols = lbtitle.Replace("\n", "");
sv.sqlcols = lbsql.Replace("\n", "");
sv.sqlcondition = lbtj.Replace("\n", "");
sv.tabcode = lbyq;
sv.tabname = lbyqname;
sv.tname = lbtable;
sv.rcode = lbrole;
sv.cdate = DateTime.Now.ToString();
sv.maker = iv.u.ename;
sv.ecols = dctitle.Replace("\n", "");
sv.esqlcols = dcsql.Replace("\n", "");
if (lbid == "0")
{
if (svb.Add(sv) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
if (svb.Update(sv))
{
r = "S";
}
else
{
r = "F";
}
}
}
else
{
r = iv.badstr;
}
return(r);
}
public static ArrayList QueryTableTitle(string emcode, string tab)
{
ArrayList r = new ArrayList();
Sys_ViewTableBll svb = new Sys_ViewTableBll();
Sys_RoleBll srb = new Sys_RoleBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
r.Add(iv.badstr);
ArrayList r1 = svb.QueryTableCols(emcode, tab, iv.u.rcode);
r.Add(r1);
}
else
{
r.Add(iv.badstr);
}
return(r);
}
public static string DelTree(string tcode)
{
string r = "";
Sys_ViewTableBll sdb = new Sys_ViewTableBll();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
if (sdb.Delete(" and tcode='" + tcode + "'"))
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = iv.badstr;
}
return(r);
}
