Example #1
0
        public static void Create_UserDealsLog()
        {
            CSQLCreateBuilder bld = new CSQLCreateBuilder();

            string sql =
                bld
                ._1_CreateTable("UserDealsLog")
                ._2_AddFieldsDefault()
                ._2_AddFieldsFromObject(typeof(CUserDeal))
                ._2_AddField("IsClearingProcessed", "INT DEFAULT 0")
                .Build();
        }
Example #2
0
        public static void Create_Clearing()
        {
            string sql = new CSQLCreateBuilder()
                         ._1_CreateTable("Clearing")
                         ._2_AddFieldIdPK()
                         ._2_AddFieldsFromObject(typeof(CDBClearing))
                         .Build();

            if (sql != null)
            {
                Thread.Sleep(0);
            }
        }
Example #3
0
        public static void  CreateTableSimple <T>(string tableName)
        {
            string sql = new CSQLCreateBuilder()
                         ._1_CreateTable(tableName)
                         ._2_AddFieldIdPK()
                         ._2_AddFieldsFromObject(typeof(T))
                         .Build();

            if (sql != null)
            {
                Thread.Sleep(0);
            }
        }
Example #4
0
        public static void Create_ExceptHolidays()
        {
            string sql = new CSQLCreateBuilder()
                         ._1_CreateTable("session_default_schedule")
                         ._2_AddFieldIdPK()
                         ._2_AddFieldsFromObject(typeof(CDBSessionDefaultSchedule))
                         .Build();


            if (sql != null)
            {
                Thread.Sleep(0);
            }
        }