mp-ap/Areas/Api/Controllers/v1/Pos/StoreSnActivateSummaryController.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/pos/[controller]/[action]")]
    public class StoreSnActivateSummaryController : BaseController
    {
        public StoreSnActivateSummaryController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
        {
            OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["SqlConnStr"].ToString();
        }




        #region 创客-首页-仓库管理-激活记录-按天
        [Authorize]
        public JsonResult ForDate(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = ForDateDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> ForDateDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            string TradeMonth = data["TradeMonth"].ToString(); //交易月
            int StoreId = int.Parse(function.CheckInt(data["StoreId"].ToString())); //仓库
            // int BrandId = int.Parse(function.CheckInt(data["BrandId"].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>>();
            DataTable dt = OtherMySqlConn.dtable("SELECT TradeDate,SUM(ActivateNum) sum FROM StoreSnActivateSummary WHERE StoreId = '"+StoreId+"' AND TradeMonth = '"+TradeMonth+"' GROUP BY TradeDate ORDER BY TradeDate DESC");
            foreach (DataRow item in dt.Rows)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("Date", item["TradeDate"]); //时间
                curData.Add("ActTotal", Convert.ToInt32(function.CheckInt(item["sum"].ToString()))); //总激活
                dataList.Add(curData);
                
            }
            dataList = dataList.Skip((PageNum - 1) * PageSize).Take(PageSize).ToList();//分页的重点
            
            return dataList;
        }
        #endregion



        #region 创客-首页-仓库管理-激活记录-按月
        [Authorize]
        public JsonResult ForMonth(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = ForMonthDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> ForMonthDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int StoreId = int.Parse(function.CheckInt(data["StoreId"].ToString())); //仓库
            // int BrandId = int.Parse(function.CheckInt(data["BrandId"].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>>();
            DataTable dt = OtherMySqlConn.dtable("SELECT TradeMonth,SUM(ActivateNum) sum FROM StoreSnActivateSummary WHERE StoreId = '" + StoreId + "' GROUP BY TradeMonth ORDER BY TradeMonth DESC");
            foreach (DataRow item in dt.Rows)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("Date", item["TradeMonth"]); //时间
                curData.Add("ActTotal", Convert.ToInt32(function.CheckInt(item["sum"].ToString()))); //总激活
                dataList.Add(curData);
                
            }
            dataList = dataList.Skip((PageNum - 1) * PageSize).Take(PageSize).ToList();//分页的重点
            
            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

    }
}