Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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);
        }