예제 #1
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);
        }
예제 #2
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);
        }
예제 #3
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);
        }
예제 #4
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);
        }
예제 #5
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);
        }
예제 #6
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);
        }
예제 #7
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);
        }
예제 #8
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);
        }
예제 #9
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);
        }
예제 #10
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);
        }
예제 #11
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);
        }
예제 #12
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);
        }
예제 #13
0
        public static void Insert(Version v, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + VERSION.VERSION_TBL + " ( ";

            q += " " + VERSION.VERSION_NAME + " \r\n ";
            q += "," + VERSION.CREATED_ON + " \r\n ";
            q += "," + VERSION.CHANGES + " \r\n ";
            //q += "," + VERSION.NOTES + " \r\n ";
            //q += "," + VERSION.ACTIVE_ID + " \r\n ";
            //q += "," + VERSION.USER_ID + " \r\n ";
            q += " ) VALUES ( ";
            q += "  @" + VERSION.VERSION_NAME + "@ \r\n ";
            q += ", @" + VERSION.CREATED_ON + "@ \r\n ";
            q += ", @" + VERSION.CHANGES + "@ \r\n ";
            //q += ", @" + VERSION.NOTES + "@ \r\n ";
            //q += ", @" + VERSION.ACTIVE_ID + "@ \r\n ";
            //q += ", @" + VERSION.USER_ID + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #14
0
        public static void InsertSub(SFields v, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + SFIELDS.SFIELDS_TBL + " ( ";

            //q += " " + SFIELDS.SFIELDS_ID + " \r\n ";
            q += "" + SFIELDS.STABLES_ID + " \r\n ";
            q += "," + SFIELDS.FIELDSNAME + " \r\n ";
            q += "," + SFIELDS.DISPLAY_NAME + " \r\n ";
            q += "," + SFIELDS.DATATYPE + " \r\n ";
            q += "," + SFIELDS.INPUTTYPE + " \r\n ";
            q += "," + SFIELDS.WIDTH + " \r\n ";
            q += "," + SFIELDS.HEIGHT + " \r\n ";
            q += "," + SFIELDS.CPOSITION + " \r\n ";
            q += "," + SFIELDS.RPOSITION + " \r\n ";
            q += "," + SFIELDS.ALIGNTO + " \r\n ";
            q += "," + SFIELDS.VALIDATE + " \r\n ";
            q += "," + SFIELDS.ISDEFAULT + " \r\n ";
            q += "," + SFIELDS.PLACEMENT + " \r\n ";
            q += "," + SFIELDS.READONLY + " \r\n ";
            q += " ) VALUES ( ";
            //q += "  @" + SFIELDS.SFIELDS_ID + "@ \r\n ";
            q += " @" + SFIELDS.STABLES_ID + "@ \r\n ";
            q += ", @" + SFIELDS.FIELDSNAME + "@ \r\n ";
            q += ", @" + SFIELDS.DISPLAY_NAME + "@ \r\n ";
            q += ", @" + SFIELDS.DATATYPE + "@ \r\n ";
            q += ", @" + SFIELDS.INPUTTYPE + "@ \r\n ";
            q += ", @" + SFIELDS.WIDTH + "@ \r\n ";
            q += ", @" + SFIELDS.HEIGHT + "@ \r\n ";
            q += ", @" + SFIELDS.CPOSITION + "@ \r\n ";
            q += ", @" + SFIELDS.RPOSITION + "@ \r\n ";
            q += ", @" + SFIELDS.ALIGNTO + "@ \r\n ";
            q += ", @" + SFIELDS.VALIDATE + "@ \r\n ";
            q += ", @" + SFIELDS.ISDEFAULT + "@ \r\n ";
            q += ", @" + SFIELDS.PLACEMENT + "@ \r\n ";
            q += ", @" + SFIELDS.READONLY + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, v);
            dalsession.Execute(q);
        }
예제 #15
0
        public static void Insert(Servers _Servers, SQLITE_DAL dalsession)
        {
            string q = " INSERT INTO " + SERVERS.SERVERS_TBL + " ( ";

            q += " " + SERVERS.SERVERS_NAME + " \r\n ";
            q += "," + SERVERS.SERVERS_VERSION + " \r\n ";
            q += "," + SERVERS.SERVERS_PATH + " \r\n ";
            q += "," + SERVERS.SERVERS_BACKUP_PATH + " \r\n ";
            q += "," + SERVERS.NOTES + " \r\n ";
            q += "," + SERVERS.ACTIVE_ID + " \r\n ";
            q += "," + SERVERS.USER_ID + " \r\n ";
            q += " ) VALUES ( ";
            q += "  @" + SERVERS.SERVERS_NAME + "@ \r\n ";
            q += ", @" + SERVERS.SERVERS_VERSION + "@ \r\n ";
            q += ", @" + SERVERS.SERVERS_PATH + "@ \r\n ";
            q += ", @" + SERVERS.SERVERS_BACKUP_PATH + "@ \r\n ";
            q += ", @" + SERVERS.NOTES + "@ \r\n ";
            q += ", @" + SERVERS.ACTIVE_ID + "@ \r\n ";
            q += ", @" + SERVERS.USER_ID + "@ \r\n ";
            q += " ) \r\n ";
            q  = AttachParams(q, _Servers);
            dalsession.Execute(q);
        }
예제 #16
0
 public static void Delete(string _Databases_id, SQLITE_DAL dalsession)
 {
     dalsession.Execute("DELETE FROM  " + DATABASES.DATABASES_TBL + " WHERE " + DATABASES.DATABASES_ID + " =  " + _Databases_id + ";");
 }
예제 #17
0
 public static void Delete(string _Servers_id, SQLITE_DAL dalsession)
 {
     dalsession.Execute("DELETE FROM  " + SERVERS.SERVERS_TBL + " WHERE " + SERVERS.SERVERS_ID + " =  " + _Servers_id + ";");
 }
예제 #18
0
 public static void Delete(string fkid, SQLITE_DAL dalsession)
 {
     dalsession.Execute("DELETE FROM  " + SFIELDSITEMS.SFIELDSITEMS_TBL + " WHERE " + SFIELDSITEMS.STABLES_ID + " =  " + fkid + ";");
 }
예제 #19
0
 public static void Delete(string pkid, SQLITE_DAL dalsession)
 {
     dalsession.Execute("DELETE FROM  " + MASTERTABLES.MASTERTABLES_TBL + " WHERE " + MASTERTABLES.MASTERTABLES_ID + " =  " + pkid + ";");
 }
예제 #20
0
 public static void Delete(string pkid, SQLITE_DAL dalsession)
 {
     dalsession.Execute("DELETE FROM  " + VERSION.VERSION_TBL + " WHERE " + VERSION.VERSION_ID + " =  " + pkid + ";");
 }