예제 #1
0
        public static List <Servers> PropertiesList(string q)
        {
            List <Servers> list = new List <Servers>();

            DataTable tbl = new SQLITE_DAL().Listdata(q);

            if (tbl.Rows.Count != 0)
            {
                for (int i = 0; i < tbl.Rows.Count; i++)
                {
                    Servers obj = new Servers()
                    {
                        Servers_id          = tbl.Rows[i][SERVERS.SERVERS_ID].ToString(),
                        Servers_name        = tbl.Rows[i][SERVERS.SERVERS_NAME].ToString(),
                        Servers_version     = tbl.Rows[i][SERVERS.SERVERS_VERSION].ToString(),
                        Servers_path        = tbl.Rows[i][SERVERS.SERVERS_PATH].ToString(),
                        Servers_backup_path = tbl.Rows[i][SERVERS.SERVERS_BACKUP_PATH].ToString(),
                        Notes     = tbl.Rows[i][SERVERS.NOTES].ToString(),
                        Active_id = tbl.Rows[i][SERVERS.ACTIVE_ID].ToString(),
                        User_id   = tbl.Rows[i][SERVERS.USER_ID].ToString()
                    };
                    list.Add(obj);
                }
            }
            return(list);
        }
예제 #2
0
        private static List <MasterTables> EntityList(string q)
        {
            List <MasterTables> list = new List <MasterTables>();

            using (IDataReader redr = new SQLITE_DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    MasterTables obj = new MasterTables()
                    {
                        Mastertables_id   = redr[MASTERTABLES.MASTERTABLES_ID].ToString(),
                        Databases_id      = redr[DATABASES.DATABASES_NAME].ToString(),
                        Mastertables_name = redr[MASTERTABLES.MASTERTABLES_NAME].ToString(),
                        Alias             = redr[MASTERTABLES.ALIAS].ToString(),
                        Namespaces_id     = redr[NAMESPACES.NAMESPACES_NAME].ToString(),
                        Active_id         = redr[MASTERTABLES.ACTIVE_ID].ToString(),
                    };

                    list.Add(obj);
                }

                redr.Close();
            }
            return(list);
        }
예제 #3
0
파일: MTX.cs 프로젝트: CODEXSUN/codexdotnet
        private static List <MasterTablesItems> GetFields(int table_id)
        {
            string q = "SELECT * FROM " + MASTERTABLESITEMS.MASTERTABLESITEMS_TBL + " WHERE  " + MASTERTABLES.MASTERTABLES_ID + " =" + table_id;

            List <MasterTablesItems> list = new List <MasterTablesItems>();

            using (IDataReader redr = new SQLITE_DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    MasterTablesItems obj = new MasterTablesItems()
                    {
                        Mtablesitems_id = redr[MASTERTABLESITEMS.MASTERTABLESITEMS_ID].ToString(),
                        Mtables_id      = redr[MASTERTABLESITEMS.MASTERTABLES_ID].ToString(),
                        Fieldsname      = redr[MASTERTABLESITEMS.FIELDSNAME].ToString(),
                        Displayname     = redr[MASTERTABLESITEMS.DISPLAYNAME].ToString(),
                        Datatype        = redr[MASTERTABLESITEMS.DATATYPE].ToString(),
                        Inputtype       = redr[MASTERTABLESITEMS.INPUTTYPE].ToString(),
                        Width           = redr[MASTERTABLESITEMS.WIDTH].ToString(),
                        Height          = redr[MASTERTABLESITEMS.HEIGHT].ToString(),
                        Cposition       = redr[MASTERTABLESITEMS.CPOSITION].ToString(),
                        Rposition       = redr[MASTERTABLESITEMS.RPOSITION].ToString(),
                        Validate        = redr[MASTERTABLESITEMS.VALIDATE].ToString(),
                        Isdefault       = redr[MASTERTABLESITEMS.ISDEFAULT].ToString(),
                        Placement       = redr[MASTERTABLESITEMS.PLACEMENT].ToString(),
                        Alignto         = redr[MASTERTABLESITEMS.ALIGNTO].ToString(),
                    };

                    list.Add(obj);
                }
            }
            return(list);
        }
예제 #4
0
        public static void InsertSub(MasterTablesItems v, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + MASTERTABLESITEMS.MASTERTABLESITEMS_TBL + " ( ";

            q += " " + MASTERTABLESITEMS.FIELDSNAME + " \r\n ";
            q += "," + MASTERTABLESITEMS.MASTERTABLES_ID + " \r\n ";
            q += "," + MASTERTABLESITEMS.DISPLAYNAME + " \r\n ";
            q += "," + MASTERTABLESITEMS.DATATYPE + " \r\n ";
            q += "," + MASTERTABLESITEMS.INPUTTYPE + " \r\n ";
            q += "," + MASTERTABLESITEMS.WIDTH + " \r\n ";
            q += "," + MASTERTABLESITEMS.HEIGHT + " \r\n ";
            q += "," + MASTERTABLESITEMS.CPOSITION + " \r\n ";
            q += "," + MASTERTABLESITEMS.RPOSITION + " \r\n ";
            q += "," + MASTERTABLESITEMS.VALIDATE + " \r\n ";
            q += "," + MASTERTABLESITEMS.ISDEFAULT + " \r\n ";
            q += "," + MASTERTABLESITEMS.PLACEMENT + " \r\n ";
            q += "," + MASTERTABLESITEMS.ALIGNTO + " \r\n ";
            q += " ) VALUES ( ";
            q += "  @" + MASTERTABLESITEMS.FIELDSNAME + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.MASTERTABLES_ID + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.DISPLAYNAME + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.DATATYPE + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.INPUTTYPE + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.WIDTH + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.HEIGHT + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.CPOSITION + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.RPOSITION + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.VALIDATE + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.ISDEFAULT + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.PLACEMENT + "@ \r\n ";
            q += ", @" + MASTERTABLESITEMS.ALIGNTO + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #5
0
        private static List <Spath> EntityList(string q)
        {
            List <Spath> list = new List <Spath>();

            using (IDataReader redr = new SQLITE_DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    Spath obj = new Spath()
                    {
                        Spath_id    = redr[SPATH.SPATH_ID].ToString(),
                        Stables_id  = redr[STABLES.STABLES_NAME].ToString(),
                        Root_folder = redr[SPATH.ROOT_FOLDER].ToString(),
                        Contfolder  = redr[SPATH.CONTFOLDER].ToString(),
                        Classfolder = redr[SPATH.CLASSFOLDER].ToString(),
                        Formfolder  = redr[SPATH.FORMFOLDER].ToString(),
                        Listfolder  = redr[SPATH.LISTFOLDER].ToString(),
                        Setupfolder = redr[SPATH.SETUPFOLDER].ToString(),
                        Testfolder  = redr[SPATH.TESTFOLDER].ToString(),
                        Active_id   = redr[SPATH.ACTIVE_ID].ToString(),
                    };

                    list.Add(obj);
                }

                redr.Close();
            }
            return(list);
        }
예제 #6
0
        public static void Insert(MasterTablePath v, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + MASTERPATH.MASTERPATH_TBL + " ( ";

            q += " " + MASTERPATH.MASTERTABLES_ID + " \r\n ";
            q += "," + MASTERPATH.ROOT_FOLDER + " \r\n ";
            q += "," + MASTERPATH.CONTFOLDER + " \r\n ";
            q += "," + MASTERPATH.CLASSFOLDER + " \r\n ";
            q += "," + MASTERPATH.FORMFOLDER + " \r\n ";
            q += "," + MASTERPATH.LISTFOLDER + " \r\n ";
            q += "," + MASTERPATH.SETUPFOLDER + " \r\n ";
            q += "," + MASTERPATH.TESTFOLDER + " \r\n ";
            q += "," + MASTERPATH.ACTIVE_ID + " \r\n ";
            q += " ) VALUES ( ";
            q += "  @" + MASTERPATH.MASTERTABLES_ID + "@ \r\n ";
            q += ", @" + MASTERPATH.ROOT_FOLDER + "@ \r\n ";
            q += ", @" + MASTERPATH.CONTFOLDER + "@ \r\n ";
            q += ", @" + MASTERPATH.CLASSFOLDER + "@ \r\n ";
            q += ", @" + MASTERPATH.FORMFOLDER + "@ \r\n ";
            q += ", @" + MASTERPATH.LISTFOLDER + "@ \r\n ";
            q += ", @" + MASTERPATH.SETUPFOLDER + "@ \r\n ";
            q += ", @" + MASTERPATH.TESTFOLDER + "@ \r\n ";
            q += ", @" + MASTERPATH.ACTIVE_ID + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #7
0
파일: MTX.cs 프로젝트: CODEXSUN/codexdotnet
        private static MasterTables GetTables(int table_id)
        {
            string q = "SELECT " + MASTERTABLES.MASTERTABLES_TBL + ".* \r\n";

            q += ", " + NAMESPACES.NAMESPACES_TBL + "." + NAMESPACES.NAMESPACES_NAME + " \r\n";
            q += ", " + DATABASES.DATABASES_TBL + "." + DATABASES.DATABASES_NAME + " \r\n";
            q += " FROM " + MASTERTABLES.MASTERTABLES_TBL + " \r\n";

            q += " INNER JOIN  " + NAMESPACES.NAMESPACES_TBL + "\r\n";
            q += " ON(" + NAMESPACES.NAMESPACES_TBL + "." + NAMESPACES.NAMESPACES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.NAMESPACES_ID + " )\r\n";

            q += " INNER JOIN  " + DATABASES.DATABASES_TBL + "\r\n";
            q += " ON(" + DATABASES.DATABASES_TBL + "." + DATABASES.DATABASES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.DATABASES_ID + " )\r\n";

            q += " WHERE  " + MASTERTABLES.MASTERTABLES_ID + " =" + table_id;

            using (IDataReader redr = new SQLITE_DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    MasterTables obj = new MasterTables()
                    {
                        Mastertables_id   = redr[MASTERTABLES.MASTERTABLES_ID].ToString(),
                        Mastertables_name = redr[MASTERTABLES.MASTERTABLES_NAME].ToString(),
                        Alias             = redr[MASTERTABLES.ALIAS].ToString(),
                        Namespaces_id     = redr[NAMESPACES.NAMESPACES_NAME].ToString(),
                        Databases_id      = redr[DATABASES.DATABASES_NAME].ToString()
                    };
                    return(obj);
                }
                return(new MasterTables());
            }
        }
예제 #8
0
        public static void InsertSub(SFieldsItems v, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + SFIELDSITEMS.SFIELDSITEMS_TBL + " ( ";

            //q += " " + SFIELDSITEMS.SFIELDS_ID + " \r\n ";
            q += "" + SFIELDSITEMS.STABLES_ID + " \r\n ";
            q += "," + SFIELDSITEMS.FIELDSNAME + " \r\n ";
            q += "," + SFIELDSITEMS.DISPLAY_NAME + " \r\n ";
            q += "," + SFIELDSITEMS.DATATYPE + " \r\n ";
            //q += "," + SFIELDSITEMS.LENGTHS + " \r\n ";
            //q += "," + SFIELDSITEMS.PKEYS + " \r\n ";
            //q += "," + SFIELDSITEMS.IFNULL + " \r\n ";
            //q += "," + SFIELDSITEMS.REFEREDTBL + " \r\n ";
            q += "," + SFIELDSITEMS.INPUTTYPE + " \r\n ";
            q += "," + SFIELDSITEMS.WIDTH + " \r\n ";
            q += " ) VALUES ( ";
            //q += "  @" + SFIELDSITEMS.SFIELDS_ID + "@ \r\n ";
            q += " @" + SFIELDSITEMS.STABLES_ID + "@ \r\n ";
            q += ", @" + SFIELDSITEMS.FIELDSNAME + "@ \r\n ";
            q += ", @" + SFIELDSITEMS.DISPLAY_NAME + "@ \r\n ";
            q += ", @" + SFIELDSITEMS.DATATYPE + "@ \r\n ";
            //q += ", @" + SFIELDSITEMS.LENGTHS + "@ \r\n ";
            //q += ", @" + SFIELDSITEMS.PKEYS + "@ \r\n ";
            //q += ", @" + SFIELDSITEMS.IFNULL + "@ \r\n ";
            //q += ", @" + SFIELDSITEMS.REFEREDTBL + "@ \r\n ";
            q += ", @" + SFIELDSITEMS.INPUTTYPE + "@ \r\n ";
            q += ", @" + SFIELDSITEMS.WIDTH + "@ \r\n ";

            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #9
0
 private static MasterTablePath EntityData(string q)
 {
     using (IDataReader redr = new SQLITE_DAL().Listreader(q))
     {
         while (redr.Read() == true)
         {
             MasterTablePath obj = new MasterTablePath()
             {
                 Masterpath_id   = redr[MASTERPATH.MASTERPATH_ID].ToString(),
                 Mastertables_id = redr[MASTERTABLES.MASTERTABLES_NAME].ToString(),
                 Root_folder     = redr[MASTERPATH.ROOT_FOLDER].ToString(),
                 Contfolder      = redr[MASTERPATH.CONTFOLDER].ToString(),
                 Classfolder     = redr[MASTERPATH.CLASSFOLDER].ToString(),
                 Formfolder      = redr[MASTERPATH.FORMFOLDER].ToString(),
                 Listfolder      = redr[MASTERPATH.LISTFOLDER].ToString(),
                 Setupfolder     = redr[MASTERPATH.SETUPFOLDER].ToString(),
                 Testfolder      = redr[MASTERPATH.TESTFOLDER].ToString(),
                 Active_id       = redr[MASTERPATH.ACTIVE_ID].ToString(),
             };
             return(obj);
         }
         redr.Close();
         return(new MasterTablePath());
     }
 }
예제 #10
0
        private static List <SFieldsItems> EntityList(string q)
        {
            List <SFieldsItems> list = new List <SFieldsItems>();

            using (IDataReader redr = new SQLITE_DAL().Listreader(q))
            {
                while (redr.Read() == true)
                {
                    SFieldsItems obj = new SFieldsItems()
                    {
                        Sfields_id  = redr[SFIELDSITEMS.SFIELDSITEMS_ID].ToString(),
                        Stables_id  = redr[SFIELDSITEMS.STABLES_ID].ToString(),
                        Fieldsname  = redr[SFIELDSITEMS.FIELDSNAME].ToString(),
                        Displayname = redr[SFIELDSITEMS.DISPLAY_NAME].ToString(),
                        Datatype    = redr[SFIELDSITEMS.DATATYPE].ToString(),
                        //Lengths = redr[SFIELDSITEMS.LENGTHS].ToString(),
                        //Pkeys = redr[SFIELDSITEMS.PKEYS].ToString(),
                        //Ifnull = redr[SFIELDSITEMS.IFNULL].ToString(),
                        //Refered_tbl = redr[SFIELDSITEMS.REFEREDTBL].ToString(),
                        Inputtype = redr[SFIELDSITEMS.INPUTTYPE].ToString(),
                        Width     = redr[SFIELDSITEMS.WIDTH].ToString()
                    };

                    list.Add(obj);
                }
            }
            return(list);
        }
예제 #11
0
 public static void Insert(List <SFields> list, SQLITE_DAL dalsession)
 {
     for (int i = 0; i < list.Count; i++)
     {
         SFields obj = new SFields()
         {
             //Sfields_id = list[i].Sfields_id,
             Stables_id  = list[i].Stables_id,
             Fieldsname  = list[i].Fieldsname,
             Displayname = list[i].Displayname,
             Datatype    = list[i].Datatype,
             Inputtype   = list[i].Inputtype,
             Width       = list[i].Width,
             Height      = list[i].Height,
             Cposition   = list[i].Cposition,
             Rposition   = list[i].Rposition,
             Alignto     = list[i].Alignto,
             Validate    = list[i].Validate,
             Isdefault   = list[i].Isdefault,
             Placement   = list[i].Placement,
             Readonly    = list[i].Readonly
         };
         InsertSub(obj, dalsession);
     }
 }
예제 #12
0
        public static List <SFieldsItems> FKId(string id, SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + SFIELDSITEMS.SFIELDSITEMS_TBL + ".* \r\n";

            q += " FROM  " + SFIELDSITEMS.SFIELDSITEMS_TBL + " \r\n";
            q += " WHERE " + SFIELDSITEMS.SFIELDSITEMS_TBL + "." + STABLES.STABLES_ID + "  = '" + id + "' \r\n";
            q += " ORDER BY  " + SFIELDSITEMS.SFIELDSITEMS_TBL + "." + SFIELDSITEMS.SFIELDSITEMS_ID + ";\r\n";

            return(EntityList(q));
        }
예제 #13
0
        public static void Update(Namespaces v, SQLITE_DAL dalsession)
        {
            string q = "UPDATE " + NAMESPACES.NAMESPACES_TBL + " SET";

            q += " " + NAMESPACES.NAMESPACES_NAME + " = @" + NAMESPACES.NAMESPACES_NAME + "@ \r\n ";
            q += "," + NAMESPACES.NOTES + " = @" + NAMESPACES.NOTES + "@ \r\n ";
            q += "," + NAMESPACES.ACTIVE_ID + " = @" + NAMESPACES.ACTIVE_ID + "@ \r\n ";
            q += "  WHERE " + NAMESPACES.NAMESPACES_ID + " = @" + NAMESPACES.NAMESPACES_ID + "@ ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #14
0
        public static void Update(Databases _Databases, SQLITE_DAL dalsession)
        {
            string q = "UPDATE " + DATABASES.DATABASES_TBL + " SET";

            q += " " + DATABASES.DATABASES_NAME + " = @" + DATABASES.DATABASES_NAME + "@ \r\n ";
            q += "," + DATABASES.NOTES + " = @" + DATABASES.NOTES + "@ \r\n ";
            q += "," + DATABASES.ACTIVE_ID + " = @" + DATABASES.ACTIVE_ID + "@ \r\n ";
            q += "," + DATABASES.USER_ID + " = @" + DATABASES.USER_ID + "@ \r\n ";
            q += "  WHERE " + DATABASES.DATABASES_ID + " = @" + DATABASES.DATABASES_ID + "@ ";
            q  = AttachParams(q, _Databases);
            dalsession.Execute(q);
        }
예제 #15
0
        public static DataTable GetforLookup()
        {
            string q = " SELECT * FROM " + DATABASES.DATABASES_TBL + "";

            q += " WHERE " + DATABASES.ACTIVE_ID + " = " + Core.Active + " \r\n";
            //  q += " AND NOT " + DATABASES.DATABASES_ID + " = '" + Core.One + "' \r\n";
            q += " ORDER BY " + DATABASES.DATABASES_NAME + " \r\n";

            DataTable xlist = new SQLITE_DAL().Listdata(q);

            return(xlist);
        }
예제 #16
0
        public static MasterTablePath PKId(string v, SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + MASTERPATH.MASTERPATH_TBL + ".* \r\n";

            q += ", " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_NAME + " \r\n";
            q += " FROM  " + MASTERPATH.MASTERPATH_TBL + " \r\n";
            q += " INNER JOIN  " + MASTERTABLES.MASTERTABLES_TBL + " \r\n";
            q += " ON( " + MASTERPATH.MASTERPATH_TBL + "." + MASTERTABLES.MASTERTABLES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_ID + ")\r\n";
            q += " WHERE " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.MASTERPATH_ID + "  = '" + v + "' \r\n";

            return(EntityData(q));
        }
예제 #17
0
        public static void Update(MasterTables v, SQLITE_DAL dalsession)
        {
            string q = "UPDATE " + MASTERTABLES.MASTERTABLES_TBL + " SET";

            q += " " + MASTERTABLES.DATABASES_ID + " = @" + MASTERTABLES.DATABASES_ID + "@ \r\n ";
            q += "," + MASTERTABLES.MASTERTABLES_NAME + " = @" + MASTERTABLES.MASTERTABLES_NAME + "@ \r\n ";
            q += "," + MASTERTABLES.ALIAS + " = @" + MASTERTABLES.ALIAS + "@ \r\n ";
            q += "," + MASTERTABLES.NAMESPACES_ID + " = @" + MASTERTABLES.NAMESPACES_ID + "@ \r\n ";
            q += "," + MASTERTABLES.ACTIVE_ID + " = @" + MASTERTABLES.ACTIVE_ID + "@ \r\n ";
            q += "  WHERE " + MASTERTABLES.MASTERTABLES_ID + " = @" + MASTERTABLES.MASTERTABLES_ID + "@ ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #18
0
        public static DataTable GetforLookup(SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + MASTERPATH.MASTERPATH_TBL + ".* \r\n";

            q += ", " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_NAME + " \r\n";
            q += " FROM  " + MASTERPATH.MASTERPATH_TBL + " \r\n";
            q += " INNER JOIN  " + MASTERTABLES.MASTERTABLES_TBL + " \r\n";
            q += " ON( " + MASTERPATH.MASTERPATH_TBL + "." + MASTERTABLES.MASTERTABLES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_ID + ")\r\n";
            q += " WHERE " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.ACTIVE_ID + "  = '" + Core.Active + "' \r\n";
            q += " ORDER BY  " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.MASTERPATH_ID + ";\r\n";

            return(SQLITE_DAL.Listdata(q));
        }
예제 #19
0
        public static List <MasterTablePath> NotActive(SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + MASTERPATH.MASTERPATH_TBL + ".* \r\n";

            q += ", " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_NAME + " \r\n";
            q += " FROM  " + MASTERPATH.MASTERPATH_TBL + " \r\n";
            q += " INNER JOIN  " + MASTERTABLES.MASTERTABLES_TBL + " \r\n";
            q += " ON( " + MASTERPATH.MASTERPATH_TBL + "." + MASTERTABLES.MASTERTABLES_ID + " = " + MASTERTABLES.MASTERTABLES_TBL + "." + MASTERTABLES.MASTERTABLES_ID + ")\r\n";
            q += " WHERE " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.ACTIVE_ID + "  = '" + Core.NotActive + "' \r\n";
            q += " ORDER BY  " + MASTERPATH.MASTERPATH_TBL + "." + MASTERPATH.MASTERPATH_ID + ";\r\n";

            return(EntityList(q));
        }
예제 #20
0
        public static Spath SearchName(string v, SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + SPATH.SPATH_TBL + ".* \r\n";

            q += ", " + STABLES.STABLES_TBL + "." + STABLES.STABLES_NAME + " \r\n";
            q += " FROM  " + SPATH.SPATH_TBL + " \r\n";
            q += " INNER JOIN  " + STABLES.STABLES_TBL + " \r\n";
            q += " ON( " + SPATH.SPATH_TBL + "." + STABLES.STABLES_ID + " = " + STABLES.STABLES_TBL + "." + STABLES.STABLES_ID + ")\r\n";
            q += " WHERE " + SPATH.SPATH_TBL + "." + SPATH.STABLES_ID + "  = '" + v + "' \r\n";
            q += " ORDER BY  " + SPATH.SPATH_TBL + "." + SPATH.SPATH_ID + ";\r\n";

            return(EntityData(q));
        }
예제 #21
0
        public static List <Spath> Active(SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + SPATH.SPATH_TBL + ".* \r\n";

            q += ", " + STABLES.STABLES_TBL + "." + STABLES.STABLES_NAME + " \r\n";
            q += " FROM  " + SPATH.SPATH_TBL + " \r\n";
            q += " INNER JOIN  " + STABLES.STABLES_TBL + " \r\n";
            q += " ON( " + SPATH.SPATH_TBL + "." + STABLES.STABLES_ID + " = " + STABLES.STABLES_TBL + "." + STABLES.STABLES_ID + ")\r\n";
            q += " WHERE " + SPATH.SPATH_TBL + "." + SPATH.ACTIVE_ID + "  = '" + Core.Active + "' \r\n";
            q += " ORDER BY  " + SPATH.SPATH_TBL + "." + SPATH.SPATH_ID + ";\r\n";

            return(EntityList(q));
        }
예제 #22
0
        public static void Update(Version v, SQLITE_DAL dalsession)
        {
            string q = "UPDATE " + VERSION.VERSION_TBL + " SET";

            q += " " + VERSION.VERSION_NAME + " = @" + VERSION.VERSION_NAME + "@ \r\n ";
            q += "," + VERSION.CREATED_ON + " = @" + VERSION.CREATED_ON + "@ \r\n ";
            q += "," + VERSION.CHANGES + " = @" + VERSION.CHANGES + "@ \r\n ";
            //q += "," + VERSION.NOTES + " = @" + VERSION.NOTES + "@ \r\n ";
            //q += "," + VERSION.ACTIVE_ID + " = @" + VERSION.ACTIVE_ID + "@ \r\n ";
            //q += "," + VERSION.USER_ID + " = @" + VERSION.USER_ID + "@ \r\n ";
            q += "  WHERE " + VERSION.VERSION_ID + " = @" + VERSION.VERSION_ID + "@ ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #23
0
        public static Stables PKId(string v, SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + STABLES.STABLES_TBL + ".* \r\n";

            q += " , " + DATABASES.DATABASES_TBL + "." + DATABASES.DATABASES_NAME + " \r\n";
            q += " , " + NAMESPACES.NAMESPACES_TBL + "." + NAMESPACES.NAMESPACES_NAME + " \r\n";
            q += " FROM  " + STABLES.STABLES_TBL + " \r\n";
            q += " INNER JOIN  " + DATABASES.DATABASES_TBL + "\r\n";
            q += " ON(" + DATABASES.DATABASES_TBL + "." + DATABASES.DATABASES_ID + " = " + STABLES.STABLES_TBL + "." + STABLES.DATABASES_ID + " )\r\n";
            q += " INNER JOIN  " + NAMESPACES.NAMESPACES_TBL + "\r\n";
            q += " ON(" + NAMESPACES.NAMESPACES_TBL + "." + NAMESPACES.NAMESPACES_ID + " = " + STABLES.STABLES_TBL + "." + STABLES.NAMESPACES_ID + " )\r\n";
            q += " WHERE " + STABLES.STABLES_TBL + "." + STABLES.STABLES_ID + "  = '" + v + "' \r\n";

            return(EntityData(q));
        }
예제 #24
0
        public static void Update(Servers _Servers, SQLITE_DAL dalsession)
        {
            string q = "UPDATE " + SERVERS.SERVERS_TBL + " SET";

            q += " " + SERVERS.SERVERS_NAME + " = @" + SERVERS.SERVERS_NAME + "@ \r\n ";
            q += "," + SERVERS.SERVERS_VERSION + " = @" + SERVERS.SERVERS_VERSION + "@ \r\n ";
            q += "," + SERVERS.SERVERS_PATH + " = @" + SERVERS.SERVERS_PATH + "@ \r\n ";
            q += "," + SERVERS.SERVERS_BACKUP_PATH + " = @" + SERVERS.SERVERS_BACKUP_PATH + "@ \r\n ";
            q += "," + SERVERS.NOTES + " = @" + SERVERS.NOTES + "@ \r\n ";
            q += "," + SERVERS.ACTIVE_ID + " = @" + SERVERS.ACTIVE_ID + "@ \r\n ";
            q += "," + SERVERS.USER_ID + " = @" + SERVERS.USER_ID + "@ \r\n ";
            q += "  WHERE " + SERVERS.SERVERS_ID + " = @" + SERVERS.SERVERS_ID + "@ ";
            q  = AttachParams(q, _Servers);
            dalsession.Execute(q);
        }
예제 #25
0
        public static void Insert(Namespaces v, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + NAMESPACES.NAMESPACES_TBL + " ( ";

            q += " " + NAMESPACES.NAMESPACES_NAME + " \r\n ";
            q += "," + NAMESPACES.NOTES + " \r\n ";
            q += "," + NAMESPACES.ACTIVE_ID + " \r\n ";
            q += " ) VALUES ( ";
            q += "  @" + NAMESPACES.NAMESPACES_NAME + "@ \r\n ";
            q += ", @" + NAMESPACES.NOTES + "@ \r\n ";
            q += ", @" + NAMESPACES.ACTIVE_ID + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #26
0
        public static List <Stables> NotActive(SQLITE_DAL SQLITE_DAL)
        {
            string q = " SELECT " + STABLES.STABLES_TBL + ".* \r\n";

            q += " , " + DATABASES.DATABASES_TBL + "." + DATABASES.DATABASES_NAME + " \r\n";
            q += " , " + NAMESPACES.NAMESPACES_TBL + "." + NAMESPACES.NAMESPACES_NAME + " \r\n";
            q += " FROM  " + STABLES.STABLES_TBL + " \r\n";
            q += " INNER JOIN  " + DATABASES.DATABASES_TBL + "\r\n";
            q += " ON(" + DATABASES.DATABASES_TBL + "." + DATABASES.DATABASES_ID + " = " + STABLES.STABLES_TBL + "." + STABLES.DATABASES_ID + " )\r\n";
            q += " INNER JOIN  " + NAMESPACES.NAMESPACES_TBL + "\r\n";
            q += " ON(" + NAMESPACES.NAMESPACES_TBL + "." + NAMESPACES.NAMESPACES_ID + " = " + STABLES.STABLES_TBL + "." + STABLES.NAMESPACES_ID + " )\r\n";
            q += " WHERE " + STABLES.STABLES_TBL + "." + STABLES.ACTIVE_ID + "  = '" + Core.NotActive + "' \r\n";
            q += " ORDER BY  " + STABLES.STABLES_TBL + "." + STABLES.STABLES_ID + ";\r\n";

            return(EntityList(q));
        }
예제 #27
0
        public static void Update(MasterTablePath v, SQLITE_DAL dalsession)
        {
            string q = "UPDATE " + MASTERPATH.MASTERPATH_TBL + " SET";

            q += " " + MASTERPATH.MASTERTABLES_ID + " = @" + MASTERPATH.MASTERTABLES_ID + "@ \r\n ";
            q += "," + MASTERPATH.ROOT_FOLDER + " = @" + MASTERPATH.ROOT_FOLDER + "@ \r\n ";
            q += "," + MASTERPATH.CONTFOLDER + " = @" + MASTERPATH.CONTFOLDER + "@ \r\n ";
            q += "," + MASTERPATH.CLASSFOLDER + " = @" + MASTERPATH.CLASSFOLDER + "@ \r\n ";
            q += "," + MASTERPATH.FORMFOLDER + " = @" + MASTERPATH.FORMFOLDER + "@ \r\n ";
            q += "," + MASTERPATH.LISTFOLDER + " = @" + MASTERPATH.LISTFOLDER + "@ \r\n ";
            q += "," + MASTERPATH.SETUPFOLDER + " = @" + MASTERPATH.SETUPFOLDER + "@ \r\n ";
            q += "," + MASTERPATH.TESTFOLDER + " = @" + MASTERPATH.TESTFOLDER + "@ \r\n ";
            q += "," + MASTERPATH.ACTIVE_ID + " = @" + MASTERPATH.ACTIVE_ID + "@ \r\n ";
            q += "  WHERE " + MASTERPATH.MASTERPATH_ID + " = @" + MASTERPATH.MASTERPATH_ID + "@ ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #28
0
        public static void Insert(Databases _Databases, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + DATABASES.DATABASES_TBL + " ( ";

            q += " " + DATABASES.DATABASES_NAME + " \r\n ";
            q += "," + DATABASES.NOTES + " \r\n ";
            q += "," + DATABASES.ACTIVE_ID + " \r\n ";
            q += "," + DATABASES.USER_ID + " \r\n ";
            q += " ) VALUES ( ";
            q += "  @" + DATABASES.DATABASES_NAME + "@ \r\n ";
            q += ", @" + DATABASES.NOTES + "@ \r\n ";
            q += ", @" + DATABASES.ACTIVE_ID + "@ \r\n ";
            q += ", @" + DATABASES.USER_ID + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, _Databases);
            dalsession.Execute(q);
        }
예제 #29
0
 private static Version EntityData(string q)
 {
     using (IDataReader redr = new SQLITE_DAL().Listreader(q))
     {
         while (redr.Read() == true)
         {
             Version obj = new Version()
             {
                 Version_id   = redr[VERSION.VERSION_ID].ToString(),
                 Version_name = redr[VERSION.VERSION_NAME].ToString(),
                 Created_on   = redr[VERSION.CREATED_ON].ToString(),
                 Changes      = redr[VERSION.CHANGES].ToString()
             };
             return(obj);
         }
         redr.Close();
         return(new Version());
     }
 }
예제 #30
0
        public static void Insert(MasterTables v, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + MASTERTABLES.MASTERTABLES_TBL + " ( ";

            q += " " + MASTERTABLES.DATABASES_ID + " \r\n";
            q += "," + MASTERTABLES.MASTERTABLES_NAME + " \r\n";
            q += "," + MASTERTABLES.ALIAS + " \r\n";
            q += "," + MASTERTABLES.NAMESPACES_ID + " \r\n";
            q += "," + MASTERTABLES.ACTIVE_ID + " \r\n";
            q += " ) VALUES ( ";
            q += "  @" + MASTERTABLES.DATABASES_ID + "@ \r\n";
            q += ", @" + MASTERTABLES.MASTERTABLES_NAME + "@ \r\n";
            q += ", @" + MASTERTABLES.ALIAS + "@ \r\n";
            q += ", @" + MASTERTABLES.NAMESPACES_ID + "@ \r\n";
            q += ", @" + MASTERTABLES.ACTIVE_ID + "@ \r\n";
            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }