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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
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
{
    [Area("Api")]
    [Route("Api/v1/[controller]/[action]")]
    public class UserTradeDaySummaryController : BaseController
    {
        public UserTradeDaySummaryController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
        {
            OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["SqlConnStr"].ToString();
        }



        #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");
            if (DateTime.Now.Day == 1)
            {
                Month = DateTime.Now.AddMonths(-1).ToString("yyyyMM");
            }
            decimal HelpAmount = 0;
            decimal final = 0;

            DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + UserId + ",%' OR Id=" + UserId + ")) AND TradeMonth=" + Month + "");
            // DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + UserId + ",%' OR Id=" + UserId + ")) or SeoDescription like '%," + UserId + ",%' or QueryCount=" + UserId + ") AND TradeMonth=" + Month + "");
            if (dt.Rows.Count > 0)
            {
                HelpAmount = decimal.Parse(function.CheckNum(dt.Rows[0]["TradeAmount"].ToString()));
                var a = UserTradeDaySummaryDbconn.Instance.GetMonthTrade(UserId, Month, "team");
                final = a + HelpAmount;
                Obj.Add("HelpAmount", HelpAmount); //助利宝交易额
            }
            Obj.Add("DirectTradeAmt", final); //团队交易总额
            Obj.Add("DirectDebitCapNum", UserDataDbconn.Instance.GetTeamPosActCount(UserId, Month)); //直营激活商户数
            Obj.Add("AddCount", UsersDbconn.Instance.GetTeamNewUserCount(UserId, Month)); //新增创客数

            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>();
            decimal HelpAmount = 0;
            // DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId=" + UserId + ") or QueryCount=" + UserId + ") AND TradeMonth=" + TradeMonth + "");
            DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId=" + UserId + ")) AND TradeMonth=" + TradeMonth + "");
            foreach (DataRow item in dt.Rows)
            {
                HelpAmount = decimal.Parse(function.CheckNum(item["TradeAmount"].ToString()));
                Obj.Add("HelpAmount", HelpAmount); //助利宝交易额
            }
            Obj.Add("TotalAmount", UserTradeDaySummaryDbconn.Instance.GetMonthTrade(UserId, TradeMonth) + HelpAmount); //总交易
            Obj.Add("TotalActiveAmount", RedisDbconn.Instance.Get<decimal>("TotalAmount:Active:" + UserId + ":" + TradeMonth)); //总活动交易
            Obj.Add("TotalUnActiveAmount", UserTradeDaySummaryDbconnV2.Instance.GetMonthTradeForCloud(UserId, TradeMonth, 0, 0)); //非活动交易
            Obj.Add("TotalUser", UsersDbconn.Instance.GetNewUserCount(UserId)); //累计总创客
            Obj.Add("TotalActMerchant", RedisDbconn.Instance.Get<int>("ActMerchantCount:" + UserId + ":" + TradeMonth)); //累计激活商户
            Obj.Add("TotalWeChatOrder", RedisDbconn.Instance.Get<int>("TotalOrder:WeChat:" + UserId + ":" + TradeMonth)); //微信订单数
            Obj.Add("TotalAlipayOrder", RedisDbconn.Instance.Get<int>("TotalOrder:Alipay:" + UserId + ":" + TradeMonth)); //支付宝订单数

            Obj.Add("TotalPosAmount", UserTradeDaySummaryDbconnV2.Instance.GetMonthTradeForCloud(UserId, TradeMonth, 0, 1)); //POS机刷卡交易额
            Obj.Add("TotalCloudPayAmount", UserTradeDaySummaryDbconn.Instance.GetMonthTradeForCloud(UserId, TradeMonth, 1)); //云闪付小额交易额
            Obj.Add("AddUser", UsersDbconn.Instance.GetNewUserCount(UserId, TradeMonth)); //新增创客
            Obj.Add("TotalPosMerchant", UserDataDbconn.Instance.GetPosActCount(UserId)); //累计激活POS机商户

            return Obj;
        }
        #endregion



        #region 创客-首页-交易分析-个人业绩-服务费明细
        [Authorize]
        public JsonResult PersonalServiceProfit(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = PersonalServiceProfitDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> PersonalServiceProfitDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string TradeDate = data["TradeDate"].ToString(); //交易日
            string PayMode = data["PayMode"].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>>();
            List<UserTradeDaySummary> query = RedisDbconn.Instance.GetList<UserTradeDaySummary>("UserTradeDaySummary", PageNum, PageSize);
            if (!string.IsNullOrEmpty(data["UserId"].ToString()))
            {
                query = query.Where(m => m.UserId == UserId).ToList();
            }
            if (!string.IsNullOrEmpty(data["TradeDate"].ToString()))
            {
                query = query.Where(m => m.TradeDate == TradeDate).ToList();
            }
            foreach (var subdata in query)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("CreateDate", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //CreateDate
                curData.Add("PayMode", ""); //支付方式
                curData.Add("ServiceProfit", ""); //服务费分润
                dataList.Add(curData);
            }
            return dataList;
        }
        #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").AddMonths(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);
                // if (date.ToString("yyyyMMdd") != start.ToString("yyyyMMdd"))
                // {
                string Date = date.ToString("yyyyMMdd");
                Dictionary<string, object> curData = new Dictionary<string, object>();
                decimal HelpAmount = 0;
                // DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId=" + UserId + ") or QueryCount=" + UserId + ") AND TradeDate=" + Date + "");
                DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId=" + UserId + ")) AND TradeDate=" + Date + "");
                foreach (DataRow item in dt.Rows)
                {
                    HelpAmount = decimal.Parse(function.CheckNum(item["TradeAmount"].ToString()));
                    curData.Add("HelpAmount", HelpAmount); //助利宝交易额
                }
                curData.Add("TradeDate", date.ToString("yyyy-MM-dd")); //交易月份
                curData.Add("TradeAmount", UserTradeDaySummaryDbconn.Instance.GetDateTrade(UserId, Date) + HelpAmount); //总交易额
                curData.Add("TotalActiveAmount", RedisDbconn.Instance.Get<decimal>("TotalAmount:Active:" + UserId + ":" + Date)); //码牌活动交易
                curData.Add("TotalUnActiveAmount", UserTradeDaySummaryDbconnV2.Instance.GetDateTradeForCloud(UserId, Date, 0, 0)); //码牌非活动交易
                curData.Add("TotalPosAmount", UserTradeDaySummaryDbconnV2.Instance.GetDateTradeForCloud(UserId, Date, 0, 1)); //刷卡总交易
                curData.Add("TotalCloudPayAmount", UserTradeDaySummaryDbconn.Instance.GetDateTradeForCloud(UserId, Date, 1)); //云闪付小额交易

                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 = UserTradeDaySummaryDbconn.Instance.GetDateTradeForBrand(UserId, Date, sub.Id);
                    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);
                var month = Month.ToString("yyyyMM");
                Dictionary<string, object> curData = new Dictionary<string, object>();
                decimal HelpAmount = 0;
                // DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId=" + UserId + ") or QueryCount=" + UserId + ") AND TradeMonth=" + month + "");
                DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId=" + UserId + ")) AND TradeMonth=" + month + "");
                foreach (DataRow item in dt.Rows)
                {
                    HelpAmount = decimal.Parse(function.CheckNum(item["TradeAmount"].ToString()));
                    curData.Add("HelpAmount", HelpAmount); //助利宝交易额
                }
                curData.Add("TradeMonth", Month.ToString("yyyy-MM")); //交易月份
                curData.Add("TradeAmount", UserTradeDaySummaryDbconn.Instance.GetMonthTrade(UserId, Month.ToString("yyyyMM")) + HelpAmount); //总交易额
                curData.Add("TotalActiveAmount", RedisDbconn.Instance.Get<decimal>("TotalAmount:Active:" + UserId + ":" + Month.ToString("yyyyMM"))); //码牌活动交易
                curData.Add("TotalUnActiveAmount", UserTradeDaySummaryDbconnV2.Instance.GetMonthTradeForCloud(UserId, Month.ToString("yyyyMM"), 0, 0)); //码牌非活动交易
                curData.Add("TotalPosAmount", UserTradeDaySummaryDbconnV2.Instance.GetMonthTradeForCloud(UserId, Month.ToString("yyyyMM"), 0, 1)); //刷卡总交易
                curData.Add("TotalCloudPayAmount", UserTradeDaySummaryDbconn.Instance.GetMonthTradeForCloud(UserId, Month.ToString("yyyyMM"), 1)); //云闪付小额交易

                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 = UserTradeDaySummaryDbconn.Instance.GetMonthTradeForBrand(UserId, Month.ToString("yyyyMM"), sub.Id);
                    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)
        {
            // TODO:每月1号显示上月数据，2号显示本月数据
            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>();
            decimal HelpAmount = 0;
            // DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + UserId + ",%' OR Id=" + UserId + ")) or SeoDescription like '%," + UserId + ",%' or QueryCount=" + UserId + ") AND TradeMonth=" + TradeMonth + "");
            DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + UserId + ",%' OR Id=" + UserId + "))) AND TradeMonth=" + TradeMonth + "");
            foreach (DataRow item in dt.Rows)
            {
                HelpAmount = decimal.Parse(function.CheckNum(item["TradeAmount"].ToString()));
                Obj.Add("HelpAmount", HelpAmount); //助利宝交易额
            }
            Obj.Add("TotalAmount", UserTradeDaySummaryDbconn.Instance.GetMonthTrade(UserId, TradeMonth, "team") + HelpAmount); //总交易
            Obj.Add("TotalActiveAmount", RedisDbconn.Instance.Get<decimal>("TeamTotalAmount:Active:" + UserId + ":" + TradeMonth)); //总活动交易
            Obj.Add("TotalUnActiveAmount", UserTradeDaySummaryDbconnV2.Instance.GetMonthTradeForCloud(UserId, TradeMonth, 0, 0, "team")); //非活动交易
            Obj.Add("TotalUser", UsersDbconn.Instance.GetTeamNewUserCount(UserId)); //累计总创客
            Obj.Add("TotalActMerchant", RedisDbconn.Instance.Get<int>("TeamActMerchantCount:" + UserId + ":" + TradeMonth)); //累计激活商户
            Obj.Add("TotalWeChatOrder", RedisDbconn.Instance.Get<int>("TeamTotalOrder:WeChat:" + UserId + ":" + TradeMonth)); //微信订单数
            Obj.Add("TotalAlipayOrder", RedisDbconn.Instance.Get<int>("TeamTotalOrder:Alipay:" + UserId + ":" + TradeMonth)); //支付宝订单数

            Obj.Add("TotalPosAmount", UserTradeDaySummaryDbconnV2.Instance.GetMonthTradeForCloud(UserId, TradeMonth, 0, 1, "team")); //POS机刷卡交易额
            Obj.Add("TotalCloudPayAmount", UserTradeDaySummaryDbconn.Instance.GetMonthTradeForCloud(UserId, TradeMonth, 1, "team")); //云闪付小额交易额
            Obj.Add("AddUser", UsersDbconn.Instance.GetTeamNewUserCount(UserId, TradeMonth)); //新增创客
            Obj.Add("TotalPosMerchant", UserDataDbconn.Instance.GetTeamPosActCount(UserId)); //累计激活POS机商户

            return Obj;
        }
        #endregion



        #region 创客-首页-交易分析-团队业绩-服务费明细
        [Authorize]
        public JsonResult TeamServiceProfit(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = TeamServiceProfitDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> TeamServiceProfitDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            string TradeDate = data["TradeDate"].ToString(); //交易日
            string PayMode = data["PayMode"].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>>();
            List<UserTradeDaySummary> query = RedisDbconn.Instance.GetList<UserTradeDaySummary>("UserTradeDaySummary", PageNum, PageSize);
            if (!string.IsNullOrEmpty(data["UserId"].ToString()))
            {
                query = query.Where(m => m.UserId == UserId).ToList();
            }
            if (!string.IsNullOrEmpty(data["TradeDate"].ToString()))
            {
                query = query.Where(m => m.TradeDate == TradeDate).ToList();
            }
            foreach (var subdata in query)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("CreateDate", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //CreateDate
                curData.Add("PayMode", ""); //支付方式
                curData.Add("ServiceProfit", ""); //服务费分润
                dataList.Add(curData);
            }
            return dataList;
        }
        #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(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").AddMonths(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);
                // if (date.ToString("yyyyMMdd") != start.ToString("yyyyMMdd"))
                // {
                string Date = date.ToString("yyyyMMdd");
                Dictionary<string, object> curData = new Dictionary<string, object>();

                decimal HelpAmount = 0;
                // DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + UserId + ",%' OR Id=" + UserId + ")) or SeoDescription like '%," + UserId + ",%' or QueryCount=" + UserId + ") AND TradeDate=" + Date + "");
                DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + UserId + ",%' OR Id=" + UserId + "))) AND TradeDate=" + Date + "");
                foreach (DataRow item in dt.Rows)
                {
                    HelpAmount = decimal.Parse(function.CheckNum(item["TradeAmount"].ToString()));
                    curData.Add("HelpAmount", HelpAmount); //助利宝交易额
                }
                curData.Add("TradeDate", date.ToString("yyyy-MM-dd")); //交易月份
                curData.Add("TradeAmount", UserTradeDaySummaryDbconn.Instance.GetDateTrade(UserId, Date, "team") + HelpAmount); //总交易额
                curData.Add("TotalActiveAmount", RedisDbconn.Instance.Get<decimal>("TeamTotalAmount:Active:" + UserId + ":" + Date)); //码牌活动交易
                curData.Add("TotalUnActiveAmount", UserTradeDaySummaryDbconnV2.Instance.GetDateTradeForCloud(UserId, Date, 0, 0, "team")); //码牌非活动交易
                curData.Add("TotalPosAmount", UserTradeDaySummaryDbconnV2.Instance.GetDateTradeForCloud(UserId, Date, 0, 1, "team")); //刷卡总交易
                curData.Add("TotalCloudPayAmount", UserTradeDaySummaryDbconn.Instance.GetDateTradeForCloud(UserId, Date, 1, "team")); //云闪付小额交易

                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 = UserTradeDaySummaryDbconn.Instance.GetDateTradeForBrand(UserId, Date, sub.Id, "team");
                    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 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);
                var month = Month.ToString("yyyyMM");
                Dictionary<string, object> curData = new Dictionary<string, object>();
                decimal HelpAmount = 0;

                // DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + UserId + ",%' OR Id=" + UserId + ")) or SeoDescription like '%," + UserId + ",%' or QueryCount=" + UserId + ") AND TradeMonth=" + month + "");
                DataTable dt = OtherMySqlConn.dtable("SELECT SUM(TradeAmount) TradeAmount FROM HelpProfitMerTradeSummay WHERE (MerchantId IN(SELECT MerchantId FROM HelpProfitMerIds WHERE UserId IN(SELECT Id from Users WHERE ParentNav like '%," + UserId + ",%' OR Id=" + UserId + "))) AND TradeMonth=" + month + "");
                foreach (DataRow item in dt.Rows)
                {
                    HelpAmount = decimal.Parse(function.CheckNum(item["TradeAmount"].ToString()));
                    curData.Add("HelpAmount", HelpAmount); //助利宝交易额
                }
                curData.Add("TradeMonth", Month.ToString("yyyy-MM")); //交易月份
                curData.Add("TradeAmount", UserTradeDaySummaryDbconn.Instance.GetMonthTrade(UserId, Month.ToString("yyyyMM"), "team") + HelpAmount); //总交易额
                curData.Add("TotalActiveAmount", RedisDbconn.Instance.Get<decimal>("TeamTotalAmount:Active:" + UserId + ":" + Month.ToString("yyyyMM"))); //码牌活动交易
                curData.Add("TotalUnActiveAmount", UserTradeDaySummaryDbconnV2.Instance.GetMonthTradeForCloud(UserId, Month.ToString("yyyyMM"), 0, 0, "team")); //码牌非活动交易
                curData.Add("TotalPosAmount", UserTradeDaySummaryDbconnV2.Instance.GetMonthTradeForCloud(UserId, Month.ToString("yyyyMM"), 0, 1, "team")); //刷卡总交易
                curData.Add("TotalCloudPayAmount", UserTradeDaySummaryDbconn.Instance.GetMonthTradeForCloud(UserId, Month.ToString("yyyyMM"), 1, "team")); //云闪付小额交易

                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 = UserTradeDaySummaryDbconn.Instance.GetMonthTradeForBrand(UserId, Month.ToString("yyyyMM"), sub.Id, "team");
                    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);
            List<Dictionary<string, object>> dataList = MerchantTradeListDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> MerchantTradeListDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            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>>();
            List<string> query = RedisDbconn.Instance.GetList<string>("MerchantTradeList:" + MerchantId + ":" + TradeMonth, PageNum, PageSize);
            foreach (string DateString in query)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("TradeDate", DateString); //交易日
                curData.Add("TradeAmt", RedisDbconn.Instance.Get<decimal>("MerchantTradeAmount:" + MerchantId + ":" + DateString)); //交易额
                dataList.Add(curData);
            }
            return dataList;
        }
        #endregion



        #region 创客-首页-我的商户-商户详情-交易统计-近半年
        [Authorize]
        public JsonResult MerchantTradeListForHalfYear(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = MerchantTradeListForHalfYearDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> MerchantTradeListForHalfYearDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            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>>();
            List<UserTradeDaySummary> query = RedisDbconn.Instance.GetList<UserTradeDaySummary>("UserTradeDaySummary", PageNum, PageSize);
            foreach (var subdata in query)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("TradeMonth", subdata.TradeMonth); //交易月
                curData.Add("TradeAmt", ""); //交易额
                curData.Add("TradeCount", ""); //交易数
                dataList.Add(curData);
            }
            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

    }
}