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 RecommendTradeSummaryController : BaseController { public RecommendTradeSummaryController(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>(); var recommendDirectUser = maindb.RecommendDirectUser.Where(m => m.UserId == UserId && m.TradeMonth == TradeMonth).ToList(); List DirectUser = new List(); foreach (var item in recommendDirectUser) { Dictionary userInfo = new Dictionary(); Users users = maindb.Users.FirstOrDefault(m => m.Id == item.DirectUserId)?? new Users(); userInfo.Add("HeadPhoto", DefaultPic(users.HeadPhoto)); userInfo.Add("Name", PublicFunction.SetSensitiveName(users.RealName)); userInfo.Add("MakerCode", users.MakerCode); int posCount = maindb.RecommendTradeSummary.Where(m => m.UserId == item.DirectUserId && m.TradeMonth == TradeMonth).Count(); var posAmountList = maindb.RecommendTradeSummary.Where(m => m.UserId == item.DirectUserId && m.TradeMonth == TradeMonth).OrderByDescending(m => m.TradeAmount).Take(2).ToList(); decimal posAmount = posAmountList.Count > 0 ? posAmountList[0].TradeAmount : 0; decimal posAmount2 = posAmountList.Count > 1 ? posAmountList[1].TradeAmount : 0; userInfo.Add("PosCount", posCount); userInfo.Add("PosAmount", posAmount); userInfo.Add("PosAmount2", posAmount2); dataList.Add(userInfo); } dataList = dataList.Skip((PageNum - 1) * PageSize).Take(PageSize).ToList();//分页的重点 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 } }