mp-ap/Areas/Api/Controllers/v1/MainServer/UserCardRecordController.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
{
    [Area("Api")]
    [Route("Api/v1/[controller]/[action]")]
    public class UserCardRecordController : BaseController
    {
        public UserCardRecordController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
        {
        }




        #region 商户-会员列表
        [Authorize]
        public JsonResult List(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = ListDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> ListDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户
            string SearchKey = data["SearchKey"].ToString(); //查询关键词
            string Sort = data["Sort"].ToString(); //排序，0-默认，1-最近消费降序，2-最近加入会员降序，3-累计消费次数降序，4-累计消费金额降序，5-近7日消费金额降序
            ulong CardFlag = ulong.Parse(function.CheckInt(data["CardFlag"].ToString()));
            int ConsumerFlag = int.Parse(function.CheckInt(data["ConsumerFlag"].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<ConsumerOfMerchant> query = RedisDbconn.Instance.GetList<ConsumerOfMerchant>("ConsumerOfMerchant:" + MerchantId, 1, 1000000);
            if (!string.IsNullOrEmpty(data["SearchKey"].ToString()))
            {
                query = query.Where(m => m.NickName.Contains(SearchKey)).ToList();
            }
            if (!string.IsNullOrEmpty(data["CardFlag"].ToString()))
            {
                query = query.Where(m => m.CardFlag == CardFlag).ToList();
            }
            if (!string.IsNullOrEmpty(data["ConsumerFlag"].ToString()))
            {
                DateTime check = DateTime.Parse(DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd") + "00:00:00");
                if (ConsumerFlag == 1)
                {
                    query = query.Where(m => m.LastConsumDate >= check).ToList();
                }
                else if (ConsumerFlag == 0)
                { 
                    query = query.Where(m => m.LastConsumDate < check).ToList();
                }
            }
            if (!string.IsNullOrEmpty(data["Sort"].ToString()))
            {
                if (Sort == "1")
                {
                    query = query.OrderByDescending(m => m.LastConsumDate).ToList();
                }
                else if (Sort == "2")
                {
                    query = query.OrderByDescending(m => m.Id).ToList();
                }
                else if (Sort == "3")
                {
                    query = query.OrderByDescending(m => m.TotalConsumCount).ToList();
                }
                else if (Sort == "4")
                {
                    query = query.OrderByDescending(m => m.TotalAmount).ToList();
                }
            }
            else
            { 
                query = query.OrderByDescending(m => m.Id).ToList();
            }
            if (PageNum == 1)
            {
                query = query.Take(PageSize).ToList();
            }
            else
            {
                int skipNum = PageSize * (PageNum - 1);
                query = query.Skip(skipNum).Take(PageSize).ToList();
            }
            foreach (var subdata in query)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("ConsumerId", RelationClass.GetConsumersInfo(subdata.Id)); //消费者
                Dictionary<string, object> Consumer = new Dictionary<string, object>();
                Consumers ConsumersData = ConsumersDbconn.Instance.Get(subdata.Id) ?? new Consumers();
                Consumer.Add("NickName", ConsumersData.NickName); //昵称
                Consumer.Add("HeadPhoto", ConsumersData.HeadPhoto); //头像
                Consumer.Add("CurIntgegral", ConsumersData.CurIntgegral); //当前积分
                Consumer.Add("TotalAmount", ConsumersData.TotalAmount); //累计消费金额
                Consumer.Add("TotalConsumCount", ConsumersData.TotalConsumCount); //累计消费次数
                Consumer.Add("LastConsumDate", ConsumersData.LastConsumDate); //最近消费时间
                curData.Add("Consumer", Consumer);

                curData.Add("CreateDate", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //CreateDate
                int ConsumeCount = 0;
                for (int i = 0; i < 7; i++)
                {
                    string Date = DateTime.Now.AddDays(-i).ToString("yyyyMMdd");
                    ConsumeCount += RedisDbconn.Instance.Get<int>("ConsumeCount:" + subdata.Id + ":" + Date);
                }
                curData.Add("ConsumeCount", ConsumeCount); //近7日消费次数
                dataList.Add(curData);
            }
            return dataList;
        }
        #endregion



        #region 消费者-发放会员卡
        [Authorize]
        public JsonResult Add(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            AppResultJson result = AddDo(value);
            return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
        }
        public AppResultJson AddDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int ConsumerId = int.Parse(function.CheckInt(data["ConsumerId"].ToString())); //消费者
            int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户
            UserCardForWeChat card = RedisDbconn.Instance.Get<UserCardForWeChat>("UserCardForWeChat:" + MerchantId) ?? new UserCardForWeChat();Dictionary<string, object> Obj = new Dictionary<string, object>();
            UserCardRecord query = new UserCardRecord()
            {
                CreateDate = DateTime.Now, //创建时间
                UpdateDate = DateTime.Now, //修改时间
                ConsumerId = ConsumerId, //消费者
                MerchantId = MerchantId, //商户
                CardId = card.Id, 
            };
            return new AppResultJson() { Status = "1", Info = "", Data = Obj };
        }
        #endregion


        #region 消费者-获取会员卡
        [Authorize]
        public JsonResult GetCardList(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            AppResultJson result = GetCardListDo(value);
            return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
        }
        public AppResultJson GetCardListDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int MerchantId = int.Parse(function.CheckInt(data["MerchantId"].ToString())); //商户
            UserCardForWeChat card = RedisDbconn.Instance.Get<UserCardForWeChat>("UserCardForWeChat:" + MerchantId) ?? new UserCardForWeChat();Dictionary<string, object> Obj = new Dictionary<string, object>();
            Dictionary<string, object> cardExt = new WeChatFunction(_accessor.HttpContext).GetUserCard(MerchantId);
            Obj.Add("CardId", card.Id);
            Obj.Add("CardExt", cardExt);
            return new AppResultJson() { Status = "1", Info = "", Data = Obj };
        }
        #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

    }
}