lkb-ap1/Areas/Api/Controllers/v1/Pos/LeaderReserveRecordController.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 LeaderReserveRecordController : BaseController
    {
        public LeaderReserveRecordController(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 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>>();
            IQueryable<LeaderReserveRecord> query = maindb.LeaderReserveRecord.Where(m => m.UserId == UserId);
            if (!string.IsNullOrEmpty(data["TradeMonth"].ToString()))
            {
                query = query.Where(m => m.TradeMonth == TradeMonth);
            }
            int TotalCount = query.Count();
            query = query.OrderByDescending(m => m.Sort).ThenByDescending(m => m.Id);
            if (PageNum == 1)
            {
                query = query.Take(PageSize);
            }
            else
            {
                int skipNum = PageSize * (PageNum - 1);
                query = query.Skip(skipNum).Take(PageSize);
            }
            var mydata = query.ToList();
            foreach (var subdata in mydata)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("Id", subdata.Id); //Id
                curData.Add("ChangeType", subdata.ChangeType); //变动类型
                curData.Add("CreateDate", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //CreateDate
                curData.Add("ChangeAmt", subdata.ChangeAmt); //变动金额
                curData.Add("AfterAmt", subdata.AfterAmt); //变动后余额
                curData.Add("Remark", subdata.Remark); //备注
                if (subdata.Remark == "购机奖励")
                {
                    var userAccount = maindb.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new UserAccount();
                    curData.Add("LeaderBalanceAmount", userAccount.LeaderBalanceAmount); //剩余可提现余额

                }
                dataList.Add(curData);
            }
            return dataList;
        }
        #endregion


        #region 创客-我的-盟主中心-兑换机具券
        [Authorize]
        public JsonResult ExchangePosCoupons(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            AppResultJson result = ExchangePosCouponsDo(value);
            return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
        }
        public AppResultJson ExchangePosCouponsDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            JsonData ApplyList = data["ApplyList"];//申请数据
            var a = ApplyList.ToJson().Length;
            int NeedPay = int.Parse(function.CheckInt(data["NeedPay"].ToString())); //所需金额
            Dictionary<string, object> Obj = new Dictionary<string, object>();
            UserAccount userAccount = maindb.UserAccount.FirstOrDefault(m => m.Id == UserId) ?? new UserAccount();
            if (userAccount.LeaderReserve >= NeedPay)
            {
                var query = maindb.LeaderReserveRecord.Add(new LeaderReserveRecord()
                {
                    CreateDate = DateTime.Now, //创建时间
                    QueryCount = 1,
                    SeoTitle = ApplyList.ToJson(),//申请机具券json数据
                    SeoKeyword = "MZ" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + function.get_Random(8),//申请单号
                    UserId = UserId, //创客
                    Remark = "兑换机具券",
                    BeforeAmt = userAccount.LeaderReserve,
                    AfterAmt = userAccount.LeaderReserve - NeedPay,
                    ChangeAmt = NeedPay,
                    TradeDate = DateTime.Now.ToString("yyyyMMdd"),
                    TradeMonth = DateTime.Now.ToString("yyyyMM"),
                }).Entity;
                maindb.SaveChanges();
                userAccount.LeaderReserve -= NeedPay;
                Obj.Add("LeaderReserve", userAccount.LeaderReserve);
                maindb.SaveChanges();
                RedisDbconn.Instance.AddList("LeaderApplyCouponsQueue", query.Id.ToString());
            }
            else
            {
                return new AppResultJson() { Status = "-1", Info = "额度不足" };
            }
            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

    }
}