mp-ap/Areas/Api/Controllers/v1/Pos/UserTradeDaySummaryController.cs

using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Options;
using Microsoft.AspNetCore.Authorization;
using System.Web;
using MySystem.MainModels;
using LitJson;
using Library;

namespace MySystem.Areas.Api.Controllers.v1.pos
{
    [Area("Api")]
    [Route("Api/v1/pos/[controller]/[action]")]
    public class UserTradeDaySummaryController : BaseController
    {
        public UserTradeDaySummaryController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
        {
        }




        #region 首页-本月团队业绩
        [Authorize]
        public JsonResult ThisMonth(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = ThisMonthDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
        }
        public Dictionary<string, object> ThisMonthDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            Dictionary<string, object> Obj = new Dictionary<string, object>();
            string Month = DateTime.Now.ToString("yyyyMM");
            IndexTeamPerformance performance = RedisDbconn.Instance.Get<IndexTeamPerformance>("IndexTeamPerformance:" + UserId + ":" + Month) ?? new IndexTeamPerformance();
            Obj.Add("DirectTradeAmt", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:" + UserId + ":" + Month)); //团队交易总额
            Obj.Add("DirectDebitCapNum", RedisDbconn.Instance.Get<int>("TActMerchantCount:" + UserId + ":" + Month)); //直营激活商户数
            Obj.Add("AddCount", performance.AddCount); //新增创客数
            return Obj;
        }
        #endregion




        #region 首页-客小爽产品-我的业绩-个人业绩
        [Authorize]
        public JsonResult PersonalPerformance(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = PersonalPerformanceDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
        }
        public Dictionary<string, object> PersonalPerformanceDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string TradeMonth = data["TradeMonth"].ToString(); //交易月
            Dictionary<string, object> Obj = new Dictionary<string, object>();
            Obj.Add("TradeAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:" + UserId + ":" + TradeMonth)); //总交易额
            Obj.Add("CardAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:Card:" + UserId + ":" + TradeMonth)); //刷卡总交易
            Obj.Add("QrPayAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:QrPay:" + UserId + ":" + TradeMonth)); //云闪付小额交易
            Obj.Add("MakerCount", UserDataDbconn.Instance.GetSelfMakerCount(UserId)); //累计总创客
            Obj.Add("AddMakerCount", UserDataDbconn.Instance.GetSelfMakerCountForMonth(UserId, TradeMonth)); //新增创客
            Obj.Add("ActMerchantCount", RedisDbconn.Instance.Get<int>("ActMerchantCount:" + UserId)); //累计激活商户
            Obj.Add("AddActMerchantCount", RedisDbconn.Instance.Get<int>("ActMerchantCount:" + UserId + ":" + TradeMonth)); //新增激活商户
            return Obj;
        }
        #endregion



        #region 首页-客小爽产品-我的业绩-个人业绩-按时间和产品统计
        [Authorize]
        public JsonResult PersonalPerformanceForDateAndPro(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = PersonalPerformanceForDateAndProDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
        }
        public Dictionary<string, object> PersonalPerformanceForDateAndProDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string TradeDate = data["TradeDate"].ToString(); //交易月/交易日
            string ProductType = data["ProductType"].ToString(); //产品类型
            Dictionary<string, object> Obj = new Dictionary<string, object>();

            if (ProductType != "1") //MPOS没有扶持期
            {
                //扶持期商户交易
                Dictionary<string, object> HelpTradeObj = new Dictionary<string, object>();
                PerformanceForDateAndPro HelpTrade = RedisDbconn.Instance.Get<PerformanceForDateAndPro>("PerformanceForDateAndPro:" + UserId + ":" + ProductType + ":Help:" + TradeDate) ?? new PerformanceForDateAndPro();
                HelpTradeObj.Add("TradeAmount", HelpTrade.TradeAmount);
                HelpTradeObj.Add("CreditAmount", HelpTrade.CreditAmount);
                HelpTradeObj.Add("DebitNotCapAmount", HelpTrade.DebitNotCapAmount);
                HelpTradeObj.Add("DebitCapAmount", HelpTrade.DebitCapAmount);
                HelpTradeObj.Add("DebitCapCount", HelpTrade.DebitCapCount);
                HelpTradeObj.Add("QrTradeAmount", HelpTrade.QrTradeAmount);
                Obj.Add("HelpTrade", HelpTradeObj);
            }

            //稳定期商户交易
            Dictionary<string, object> NotHelpTradeObj = new Dictionary<string, object>();
            PerformanceForDateAndPro NotHelpTrade = RedisDbconn.Instance.Get<PerformanceForDateAndPro>("PerformanceForDateAndPro:" + UserId + ":" + ProductType + ":NotHelp:" + TradeDate) ?? new PerformanceForDateAndPro();
            NotHelpTradeObj.Add("TradeAmount", NotHelpTrade.TradeAmount);
            NotHelpTradeObj.Add("CreditAmount", NotHelpTrade.CreditAmount);
            NotHelpTradeObj.Add("DebitNotCapAmount", NotHelpTrade.DebitNotCapAmount);
            NotHelpTradeObj.Add("DebitCapAmount", NotHelpTrade.DebitCapAmount);
            NotHelpTradeObj.Add("DebitCapCount", NotHelpTrade.DebitCapCount);
            NotHelpTradeObj.Add("QrTradeAmount", NotHelpTrade.QrTradeAmount);
            Obj.Add("NotHelpTrade", NotHelpTradeObj);

            //交易商户
            List<int> TradeMerchants = RedisDbconn.Instance.GetList<int>("PerformanceForDateAndPro:Mer:" + UserId + ":" + ProductType + ":" + TradeDate);
            List<Dictionary<string, object>> TradeMerchantList = new List<Dictionary<string, object>>();
            foreach (int TradeMerchantId in TradeMerchants)
            {
                PosMerchantInfo merchant = maindb.PosMerchantInfo.FirstOrDefault(m => m.Id == TradeMerchantId) ?? new PosMerchantInfo();
                Dictionary<string, object> item = new Dictionary<string, object>();
                item.Add("Name", merchant.MerchantName); //商户名称
                item.Add("TradeAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:" + merchant.UserId + ":" + ProductType + ":" + TradeDate)); //交易额
                TradeMerchantList.Add(item);
            }
            Obj.Add("TradeMerchants", TradeMerchantList); 

            return Obj;
        }
        #endregion



        #region 首页-客小爽产品-我的业绩-个人业绩-每月明细
        [Authorize]
        public JsonResult PersonalPerformanceForDay(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = PersonalPerformanceForDayDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> PersonalPerformanceForDayDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string TradeMonth = data["TradeMonth"].ToString(); //交易月
            int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
            int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
            List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
            DateTime start = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00");
            if (DateTime.Now.ToString("yyyyMM") != TradeMonth)
            {
                start = DateTime.Parse(TradeMonth.Substring(0, 4) + "-" + TradeMonth.Substring(4, 2) + "-01 00:00:00").AddHours(1).AddDays(-1);
            }
            if (PageNum > 1)
            {
                int skipNum = PageSize * (PageNum - 1);
                start = start.AddDays(-skipNum);
            }
            for (int i = 0; i < PageSize; i++)
            {
                DateTime date = start.AddDays(-i);
                string Date = date.ToString("yyyyMMdd");
                if (Date != DateTime.Now.ToString("yyyyMMdd"))
                {
                    Dictionary<string, object> curData = new Dictionary<string, object>();
                    curData.Add("TradeDate", date.ToString("yyyy-MM-dd")); //交易月份
                    curData.Add("TradeAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:" + UserId + ":" + Date)); //总交易额
                    curData.Add("CardAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:Card:" + UserId + ":" + Date)); //刷卡总交易
                    curData.Add("QrPayAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:QrPay:" + UserId + ":" + Date)); //云闪付小额交易
                    List<Dictionary<string, object>> ProductList = new List<Dictionary<string, object>>();
                    List<KqProducts> list = RedisDbconn.Instance.GetList<KqProducts>("KqProducts", 1, 100);
                    foreach (KqProducts sub in list)
                    {
                        decimal Amount = RedisDbconn.Instance.Get<decimal>("TradeStat:" + UserId + ":" + sub.Id + ":" + Date);
                        if (Amount > 0)
                        {
                            Dictionary<string, object> item = new Dictionary<string, object>();
                            item.Add("Id", sub.Id); //产品Id
                            item.Add("Name", sub.Name); //名称
                            item.Add("Amount", Amount); //交易额
                            ProductList.Add(item);
                        }
                    }
                    curData.Add("ProductList", ProductList); //产品列表
                    dataList.Add(curData);
                }
            }
            return dataList;
        }
        #endregion



        #region 首页-客小爽产品-我的业绩-个人业绩-近半年
        [Authorize]
        public JsonResult PersonalPerformanceHalfYear(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = PersonalPerformanceHalfYearDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> PersonalPerformanceHalfYearDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
            int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
            List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
            for (int i = 0; i < 6; i++)
            {
                DateTime Month = DateTime.Now.AddMonths(-i);
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("TradeMonth", Month.ToString("yyyy-MM")); //交易月份
                curData.Add("TradeAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:" + UserId + ":" + Month.ToString("yyyyMM"))); //总交易额
                curData.Add("CardAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:Card:" + UserId + ":" + Month.ToString("yyyyMM"))); //刷卡总交易
                curData.Add("QrPayAmount", RedisDbconn.Instance.Get<decimal>("TradeStat:QrPay:" + UserId + ":" + Month.ToString("yyyyMM"))); //云闪付小额交易
                List<Dictionary<string, object>> ProductList = new List<Dictionary<string, object>>();
                List<KqProducts> list = RedisDbconn.Instance.GetList<KqProducts>("KqProducts", 1, 100);
                foreach (KqProducts sub in list)
                {
                    decimal Amount = RedisDbconn.Instance.Get<decimal>("TradeStat:" + UserId + ":" + sub.Id + ":" + Month.ToString("yyyyMM"));
                    if (Amount > 0)
                    {
                        Dictionary<string, object> item = new Dictionary<string, object>();
                        item.Add("Id", sub.Id); //产品Id
                        item.Add("Name", sub.Name); //名称
                        item.Add("Amount", Amount); //交易额
                        ProductList.Add(item);
                    }
                }
                curData.Add("ProductList", ProductList); //产品列表
                dataList.Add(curData);
            }
            return dataList;
        }
        #endregion



        #region 首页-客小爽产品-我的业绩-团队业绩
        [Authorize]
        public JsonResult TeamPerformance(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = TeamPerformanceDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
        }
        public Dictionary<string, object> TeamPerformanceDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string TradeMonth = data["TradeMonth"].ToString(); //交易月
            Dictionary<string, object> Obj = new Dictionary<string, object>();
            Obj.Add("TradeAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:" + UserId + ":" + TradeMonth)); //总交易额
            Obj.Add("CardAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:Card:" + UserId + ":" + TradeMonth)); //刷卡总交易
            Obj.Add("QrPayAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:QrPay:" + UserId + ":" + TradeMonth)); //云闪付小额交易
            Obj.Add("MakerCount", UserDataDbconn.Instance.GetTeamMakerCount(UserId)); //累计总创客
            Obj.Add("AddMakerCount", UserDataDbconn.Instance.GetTeamMakerCountForMonth(UserId, TradeMonth)); //新增创客
            Obj.Add("ActMerchantCount", RedisDbconn.Instance.Get<int>("TActMerchantCount:" + UserId)); //累计激活商户
            Obj.Add("AddActMerchantCount", RedisDbconn.Instance.Get<int>("TActMerchantCount:" + UserId + ":" + TradeMonth)); //新增激活商户
            return Obj;
        }
        #endregion



        #region 首页-客小爽产品-我的业绩-团队业绩-按时间和产品统计
        [Authorize]
        public JsonResult TeamPerformanceForDateAndPro(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = TeamPerformanceForDateAndProDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
        }
        public Dictionary<string, object> TeamPerformanceForDateAndProDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string TradeDate = data["TradeDate"].ToString(); //交易月/交易日
            string ProductType = data["ProductType"].ToString(); //产品类型
            Dictionary<string, object> Obj = new Dictionary<string, object>();

            if (ProductType != "1") //MPOS没有扶持期
            {
                //扶持期商户交易
                Dictionary<string, object> HelpTradeObj = new Dictionary<string, object>();
                PerformanceForDateAndPro HelpTrade = RedisDbconn.Instance.Get<PerformanceForDateAndPro>("TeamPerformanceForDateAndPro:" + UserId + ":" + ProductType + ":Help:" + TradeDate) ?? new PerformanceForDateAndPro();
                HelpTradeObj.Add("TradeAmount", HelpTrade.TradeAmount);
                HelpTradeObj.Add("CreditAmount", HelpTrade.CreditAmount);
                HelpTradeObj.Add("DebitNotCapAmount", HelpTrade.DebitNotCapAmount);
                HelpTradeObj.Add("DebitCapAmount", HelpTrade.DebitCapAmount);
                HelpTradeObj.Add("DebitCapCount", HelpTrade.DebitCapCount);
                HelpTradeObj.Add("QrTradeAmount", HelpTrade.QrTradeAmount);
                Obj.Add("HelpTrade", HelpTradeObj);
            }

            //稳定期商户交易
            Dictionary<string, object> NotHelpTradeObj = new Dictionary<string, object>();
            PerformanceForDateAndPro NotHelpTrade = RedisDbconn.Instance.Get<PerformanceForDateAndPro>("TeamPerformanceForDateAndPro:" + UserId + ":" + ProductType + ":NotHelp:" + TradeDate) ?? new PerformanceForDateAndPro();
            NotHelpTradeObj.Add("TradeAmount", NotHelpTrade.TradeAmount);
            NotHelpTradeObj.Add("CreditAmount", NotHelpTrade.CreditAmount);
            NotHelpTradeObj.Add("DebitNotCapAmount", NotHelpTrade.DebitNotCapAmount);
            NotHelpTradeObj.Add("DebitCapAmount", NotHelpTrade.DebitCapAmount);
            NotHelpTradeObj.Add("DebitCapCount", NotHelpTrade.DebitCapCount);
            NotHelpTradeObj.Add("QrTradeAmount", NotHelpTrade.QrTradeAmount);
            Obj.Add("NotHelpTrade", NotHelpTradeObj); 

            //交易商户
            // List<int> TradeMerchants = RedisDbconn.Instance.GetList<int>("TeamPerformanceForDateAndPro:Mer:" + UserId + ":" + ProductType + ":" + TradeDate);
            // List<Dictionary<string, object>> TradeMerchantList = new List<Dictionary<string, object>>();
            // foreach (int TradeMerchantId in TradeMerchants)
            // {
            //     MerchantInfo merchant = RedisDbconn.Instance.Get<MerchantInfo>("MerchantInfo:" + TradeMerchantId) ?? new MerchantInfo();
            //     Dictionary<string, object> item = new Dictionary<string, object>();
            //     item.Add("Name", merchant.MerchantName); //商户名称
            //     item.Add("TradeAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:" + merchant.UserId + ":" + ProductType + ":" + TradeDate)); //交易额
            //     TradeMerchantList.Add(item);
            // }
            // Obj.Add("TradeMerchants", TradeMerchantList); 

            return Obj;
        }
        #endregion



        #region 首页-客小爽产品-我的业绩-团队业绩-每月明细
        [Authorize]
        public JsonResult TeamPerformanceForDay(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = TeamPerformanceForDayDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> TeamPerformanceForDayDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string TradeMonth = data["TradeMonth"].ToString(); //交易月
            string MerchantId = data["MerchantId"].ToString(); //商户Id
            int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
            int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
            List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
            DateTime start = DateTime.Parse(TradeMonth.Substring(0, 4) + "-" + TradeMonth.Substring(4, 2) + "-01 00:00:00");
            DateTime end = start.AddMonths(1).AddDays(-1);
            int skipNum = 1;
            if (PageNum > 1)
            {
                skipNum = PageSize * (PageNum - 1) + 1;
            }
            int index = 0;
            while (start <= end)
            {
                index += 1;
                if (index >= skipNum && dataList.Count < PageSize)
                {
                    string Date = end.ToString("yyyyMMdd");
                    if (Date != DateTime.Now.ToString("yyyyMMdd"))
                    {
                        Dictionary<string, object> curData = new Dictionary<string, object>();
                        curData.Add("TradeDate", end.ToString("yyyy-MM-dd")); //交易月份
                        curData.Add("TradeAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:" + UserId + ":" + MerchantId + ":" + Date)); //总交易额
                        curData.Add("CardAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:Card:" + UserId + ":" + MerchantId + ":" + Date)); //刷卡总交易
                        curData.Add("QrPayAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:QrPay:" + UserId + ":" + MerchantId + ":" + Date)); //云闪付小额交易
                        List<Dictionary<string, object>> ProductList = new List<Dictionary<string, object>>();
                        List<KqProducts> list = RedisDbconn.Instance.GetList<KqProducts>("KqProducts", 1, 100);
                        foreach (KqProducts sub in list)
                        {
                            decimal Amount = RedisDbconn.Instance.Get<decimal>("TeamTradeStat:" + UserId + ":" + MerchantId + ":" + sub.Id + ":" + Date);
                            if (Amount > 0)
                            {
                                Dictionary<string, object> item = new Dictionary<string, object>();
                                item.Add("Id", sub.Id); //产品Id
                                item.Add("Name", sub.Name); //名称
                                item.Add("Amount", Amount); //交易额
                                ProductList.Add(item);
                            }
                        }
                        curData.Add("ProductList", ProductList); //产品列表
                        dataList.Add(curData);
                    }
                }                
                end = end.AddDays(-1);
            }
            return dataList;
        }
        #endregion



        #region 首页-客小爽产品-我的业绩-团队业绩-近半年
        [Authorize]
        public JsonResult TeamPerformanceHalfYear(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = TeamPerformanceHalfYearDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> TeamPerformanceHalfYearDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string MerchantId = data["MerchantId"].ToString(); //商户Id
            int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
            int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
            List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
            for (int i = 0; i < 6; i++)
            {
                DateTime Month = DateTime.Now.AddMonths(-i);
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("TradeMonth", Month.ToString("yyyy-MM")); //交易月份
                curData.Add("TradeAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:" + UserId + ":" + MerchantId + ":" + Month.ToString("yyyyMM"))); //总交易额
                curData.Add("CardAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:Card:" + UserId + ":" + MerchantId + ":" + Month.ToString("yyyyMM"))); //刷卡总交易
                curData.Add("QrPayAmount", RedisDbconn.Instance.Get<decimal>("TeamTradeStat:QrPay:" + UserId + ":" + MerchantId + ":" + Month.ToString("yyyyMM"))); //云闪付小额交易
                List<Dictionary<string, object>> ProductList = new List<Dictionary<string, object>>();
                List<KqProducts> list = RedisDbconn.Instance.GetList<KqProducts>("KqProducts", 1, 100);
                foreach (KqProducts sub in list)
                {
                    decimal Amount = RedisDbconn.Instance.Get<decimal>("TeamTradeStat:" + UserId + ":" + MerchantId + ":" + sub.Id + ":" + Month.ToString("yyyyMM"));
                    if (Amount > 0)
                    {
                        Dictionary<string, object> item = new Dictionary<string, object>();
                        item.Add("Id", sub.Id); //产品Id
                        item.Add("Name", sub.Name); //名称
                        item.Add("Amount", Amount); //名称
                        ProductList.Add(item);
                    }
                }
                curData.Add("ProductList", ProductList); //产品列表
                dataList.Add(curData);
            }
            return dataList;
        }
        #endregion



        #region 首页-我的商户-商户详情-交易记录
        [Authorize]
        public JsonResult MerchantTradeList(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Other = new Dictionary<string, object>();
            List<Dictionary<string, object>> dataList = MerchantTradeListDo(value, out Other);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other });
        }
        public List<Dictionary<string, object>> MerchantTradeListDo(string value, out Dictionary<string, object> Other)
        {
            JsonData data = JsonMapper.ToObject(value);
            string TradeMonth = data["TradeMonth"].ToString(); //交易月
            int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户Id
            int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString()));
            int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString()));
            List<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
            PosMerchantInfo merchant = PosMerchantInfoDbconn.Instance.Get(MerchantId) ?? new PosMerchantInfo();
            DateTime start = DateTime.Parse(TradeMonth.Substring(0, 4) + "-" + TradeMonth.Substring(4, 2) + "-01 00:00:00");
            DateTime end = start.AddMonths(1).AddDays(-1);
            if (TradeMonth == DateTime.Now.ToString("yyyyMM"))
            {
                end = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00");
            }
            int skipNum = 1;
            if (PageNum > 1)
            {
                skipNum = PageSize * (PageNum - 1) + 1;
            }
            int index = 0;
            while(start <= end)
            {
                index += 1;
                if (index >= skipNum && dataList.Count < PageSize)
                {
                    Dictionary<string, object> curData = new Dictionary<string, object>();
                    curData.Add("TradeDate", end.ToString("yyyy-MM-dd")); //交易日
                    curData.Add("TradeAmt", PosMerchantTradeSummaryDbconn.Instance.GetDateTimeTrade(merchant.Id, end.ToString("yyyyMMdd"))); //交易额
                    dataList.Add(curData);
                }
                end = end.AddDays(-1);
            }
            Other = new Dictionary<string, object>();
            Other.Add("MonthTradeAmt", PosMerchantTradeSummaryDbconn.Instance.GetDateTimeTrade(merchant.Id, TradeMonth));
            return dataList;
        }
        #endregion




        #region 检查签名是否合法，合法返回1，不合法返回提示信息

        /// <summary>
        /// 检查签名是否合法，合法返回1，不合法返回提示信息
        /// </summary>
        /// <param name="value">请求的参数(json字符串)</param>
        /// <param name="signField">要签名的字段</param>
        /// <returns></returns>
        private string CheckSign(string value, string[] signField)
        {
            JsonData json = JsonMapper.ToObject(value);
            Dictionary<string, string> dic = new Dictionary<string, string>();
            for (int i = 0; i < signField.Length; i++)
            {
                dic.Add(signField[i], json[signField[i]].ToString());
            }
            string sign = json["sign"].ToString(); //客户端签名字符串
            return new Sign().sign(dic, sign);
        }

        #endregion

    }
}