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 logger, IOptions setting) : base(accessor, logger, setting) { } #region 创客-我的-盟主中心-储备金变动记录 [Authorize] public JsonResult List(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = ListDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> 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> dataList = new List>(); IQueryable 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 curData = new Dictionary(); 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 Obj = new Dictionary(); 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,不合法返回提示信息 /// /// 检查签名是否合法,合法返回1,不合法返回提示信息 /// /// 请求的参数(json字符串) /// 要签名的字段 /// private string CheckSign(string value, string[] signField) { JsonData json = JsonMapper.ToObject(value); Dictionary dic = new Dictionary(); 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 } }