kxs-stat/Config/Base.cs

using System.Collections.Generic;
using Library;

namespace AppConfig
{
    public class Base
    {
        public static string StatSqlConn = Library.ConfigurationManager.AppSettings["StatSqlConnStr"].ToString();

        public static string CreateTradeDaySummary = "SET NAMES utf8mb4;" +
                                                    "SET FOREIGN_KEY_CHECKS = 0;" +
                                                    "CREATE TABLE `TradeDaySummary#DateTime#` (" +
                                                    "`Id` int(11) NOT NULL AUTO_INCREMENT," +
                                                    "`Sort` int(11) NOT NULL DEFAULT '0'," +
                                                    "`QueryCount` int(11) NOT NULL DEFAULT '0'," +
                                                    "`Status` int(11) NOT NULL DEFAULT '0'," +
                                                    "`Version` int(11) NOT NULL DEFAULT '0'," +
                                                    "`CreateDate` datetime DEFAULT NULL," +
                                                    "`UpdateDate` datetime DEFAULT NULL," +
                                                    "`CreateMan` varchar(50) DEFAULT NULL," +
                                                    "`UpdateMan` varchar(50) DEFAULT NULL," +
                                                    "`SeoTitle` varchar(100) DEFAULT NULL," +
                                                    "`SeoKeyword` varchar(200) DEFAULT NULL," +
                                                    "`SeoDescription` varchar(500) DEFAULT NULL," +
                                                    "`TopUserId` int(11) NOT NULL DEFAULT '0'," +
                                                    "`HelpNonDirectNonQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectNonQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpNonDirectQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpNonDirectDebitCapNum` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpNonDirectDebitCapTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpNonDirectDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectDebitCapNum` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectDebitCapTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpNonDirectNonQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectNonQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpNonDirectQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpNonDirectCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpNonDirectTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`HelpDirectTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpNonDirectNonQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpDirectNonQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpNonDirectQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpDirectQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpNonDirectDebitCapNum` int(11) NOT NULL DEFAULT '0'," +
                                                    "`NotHelpNonDirectDebitCapTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpNonDirectDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpDirectDebitCapNum` int(11) NOT NULL DEFAULT '0'," +
                                                    "`NotHelpDirectDebitCapTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpDirectDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpNonDirectNonQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpDirectNonQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpNonDirectQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpDirectQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpNonDirectCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpDirectCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpNonDirectTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`NotHelpDirectTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`MgrName` varchar(32) DEFAULT NULL," +
                                                    "`MgrNo` varchar(16) DEFAULT NULL," +
                                                    "`BrandId` int(11) NOT NULL DEFAULT '0'," +
                                                    "`TradeMonth` varchar(6) DEFAULT NULL," +
                                                    "`TradeDate` varchar(8) DEFAULT NULL," +
                                                    "`UserId` int(11) NOT NULL DEFAULT '0'," +
                                                    "`PayType` int(11) NOT NULL DEFAULT '0'," +
                                                    "`VipFlag` int(11) NOT NULL DEFAULT '0'," +
                                                    "`ProfitNonDirectNonQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectNonQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitNonDirectQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectQrDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitNonDirectDebitCapNum` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitNonDirectDebitCapTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitNonDirectDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectDebitCapNum` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectDebitCapTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectDebitTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitNonDirectNonQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectNonQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitNonDirectQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectQrCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitNonDirectCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectCreditTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitNonDirectTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "`ProfitDirectTradeAmt` decimal(18,2) NOT NULL DEFAULT '0.00'," +
                                                    "PRIMARY KEY (`Id`) USING BTREE," +
                                                    "KEY `TradeDaySummaryIndex` (`UserId`,`TradeMonth`,`TradeDate`,`BrandId`,`QueryCount`,`VipFlag`,`PayType`,`SeoTitle`)" +
                                                    ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;" +
                                                    "SET FOREIGN_KEY_CHECKS = 1;";
    }
}