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 ActivityRedPackageTop10Controller : BaseController { public ActivityRedPackageTop10Controller(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); string result = RedisDbconn.Instance.Get("ActivityRedPackageTop10"); if(!string.IsNullOrEmpty(result)) { return Json(new AppResultJson() { Status = "1", Info = "", Data = result }); } List> dataList = ListDo(value); RedisDbconn.Instance.Set("ActivityRedPackageTop10", Newtonsoft.Json.JsonConvert.SerializeObject(dataList)); RedisDbconn.Instance.SetExpire("ActivityRedPackageTop10", 60); return Json(new AppResultJson() { Status = "1", Info = "", Data = Newtonsoft.Json.JsonConvert.SerializeObject(dataList) }); } public List> ListDo(string value) { JsonData data = JsonMapper.ToObject(value); int Kind = int.Parse(function.CheckInt(data["Kind"].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.ActivityRedPackageTop10.Where(m => m.Kind == Kind); if(Kind == 1) { query = query.OrderByDescending(m => m.PrizeAmt).ThenBy(m => m.Sort); } else if(Kind == 2) { query = query.OrderByDescending(m => m.TimeNum).ThenBy(m => m.Sort); } if (PageNum == 1) { query = query.Take(PageSize); } else { int skipNum = PageSize * (PageNum - 1); query = query.Skip(skipNum).Take(PageSize); } foreach (var subdata in query.ToList()) { Dictionary curData = new Dictionary(); curData.Add("UserId", RelationClass.GetUsersInfo(subdata.UserId)); //创客 Dictionary UserInfo = new Dictionary(); Users UsersData = maindb.Users.FirstOrDefault(m => m.Id == subdata.UserId) ?? new Users(); UserInfo.Add("RealName", UsersData.RealName); //真实姓名 UserInfo.Add("MakerCode", UsersData.MakerCode); //创客编号 curData.Add("UserInfo", UserInfo); curData.Add("Num", subdata.Sort); //排行名次 if(Kind == 1) { curData.Add("Data", subdata.PrizeAmt); //金额/次数 } else if(Kind == 2) { curData.Add("Data", subdata.TimeNum); //金额/次数 } dataList.Add(curData); } return dataList; } #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 } }