lkb-stat/Config/Base.cs

using System.Collections.Generic;
using Library;

namespace AppConfig
{
    public class Base
    {
        public static string SqlConn = Library.ConfigurationManager.AppSettings["SqlConnStr"].ToString();
        public static string StatSqlConn = Library.ConfigurationManager.AppSettings["StatSqlConnStr"].ToString();
        public static string SqlConn2 = Library.ConfigurationManager.AppSettings["SqlConnStr2"].ToString();
        public static string StatSqlConn2 = Library.ConfigurationManager.AppSettings["StatSqlConnStr2"].ToString();
        public static string KxsSqlConn = Library.ConfigurationManager.AppSettings["KxsSqlConnStr"].ToString();


        //交易记录表
        public static string CreateMerchantTradeSummary = "CREATE TABLE `MerchantTradeSummary#DateTime#` (" +
                                                "`Id` int(11) NOT NULL AUTO_INCREMENT," +
                                                "`Sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序序号'," +
                                                "`QueryCount` int(11) NOT NULL DEFAULT '0' COMMENT '点击量'," +
                                                "`Status` int(11) NOT NULL DEFAULT '0' COMMENT '状态'," +
                                                "`Version` int(11) NOT NULL DEFAULT '0' COMMENT '版本号'," +
                                                "`CreateDate` datetime DEFAULT NULL COMMENT '创建时间'," +
                                                "`UpdateDate` datetime DEFAULT NULL COMMENT '更新时间'," +
                                                "`CreateMan` varchar(50) DEFAULT NULL COMMENT '创建人'," +
                                                "`UpdateMan` varchar(50) DEFAULT NULL COMMENT '更新人'," +
                                                "`SeoTitle` varchar(100) DEFAULT NULL," +
                                                "`SeoKeyword` varchar(200) DEFAULT NULL," +
                                                "`SeoDescription` varchar(500) DEFAULT NULL," +
                                                "`NonActAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '非活动交易额'," +
                                                "`ActAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '活动交易额'," +
                                                "`AliPayInFactAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '支付宝实收金额'," +
                                                "`WeChatInfactAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '微信实收金额'," +
                                                "`OderCount` int(11) NOT NULL DEFAULT '0' COMMENT '订单数'," +
                                                "`InFactAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '实收金额'," +
                                                "`TradeAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '交易金额'," +
                                                "`TradeDate` varchar(50) DEFAULT NULL COMMENT '交易日期'," +
                                                "`TradeMonth` varchar(50) DEFAULT NULL COMMENT '交易月份'," +
                                                "`MerchantId` int(11) NOT NULL DEFAULT '0' COMMENT '商户Id'," +
                                                "PRIMARY KEY (`Id`)," +
                                                "KEY `MerchantTradeSummaryIndex#DateTime#` (`MerchantId`)" +
                                                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商户交易统计表';";

        public static string CreateMerchantTradeSummaryList = "CREATE TABLE `MerchantTradeSummaryList#DateTime#` (" +
                                                "`Id` int(11) NOT NULL AUTO_INCREMENT," +
                                                "`Sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序序号'," +
                                                "`QueryCount` int(11) NOT NULL DEFAULT '0' COMMENT '点击量'," +
                                                "`Status` int(11) NOT NULL DEFAULT '0' COMMENT '状态'," +
                                                "`Version` int(11) NOT NULL DEFAULT '0' COMMENT '版本号'," +
                                                "`CreateDate` datetime DEFAULT NULL COMMENT '创建时间'," +
                                                "`UpdateDate` datetime DEFAULT NULL COMMENT '更新时间'," +
                                                "`CreateMan` varchar(50) DEFAULT NULL COMMENT '创建人'," +
                                                "`UpdateMan` varchar(50) DEFAULT NULL COMMENT '更新人'," +
                                                "`SeoTitle` varchar(100) DEFAULT NULL," +
                                                "`SeoKeyword` varchar(200) DEFAULT NULL," +
                                                "`SeoDescription` varchar(500) DEFAULT NULL," +
                                                "`NonActAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '非活动交易额'," +
                                                "`ActAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '活动交易额'," +
                                                "`AliPayInFactAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '支付宝实收金额'," +
                                                "`WeChatInfactAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '微信实收金额'," +
                                                "`OderCount` int(11) NOT NULL DEFAULT '0' COMMENT '订单数'," +
                                                "`InFactAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '实收金额'," +
                                                "`TradeAmount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '交易金额'," +
                                                "`TradeDate` varchar(50) DEFAULT NULL COMMENT '交易日期'," +
                                                "`TradeMonth` varchar(50) DEFAULT NULL COMMENT '交易月份'," +
                                                "`MerchantId` int(11) NOT NULL DEFAULT '0' COMMENT '商户Id'," +
                                                "PRIMARY KEY (`Id`)," +
                                                "KEY `MerchantTradeSummaryListIndex#DateTime#` (`MerchantId`)" +
                                                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商户交易统计表';";
    }
}