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.pos { [Area("Api")] [Route("Api/v1/pos/[controller]/[action]")] public class ProfitRewardRecordController : BaseController { public ProfitRewardRecordController(IHttpContextAccessor accessor, ILogger logger, IOptions setting) : base(accessor, logger, setting) { } #region 首页-客小爽产品-收益查看-交易分润 [Authorize] public JsonResult TradeProfitList(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = TradeProfitListDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> TradeProfitListDo(string value) { JsonData data = JsonMapper.ToObject(value); int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客 int ProductType = int.Parse(function.CheckInt(data["ProductType"].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.ProfitRecord.Where(m => m.UserId == UserId && m.BrandId == ProductType).OrderByDescending(m => m.Id); if (PageNum == 1) { query = query.Take(PageSize); } else { int skipNum = PageSize * (PageNum - 1); query = query.Skip(skipNum).Take(PageSize); } Dictionary items = new Dictionary(); foreach (var subdata in query.ToList()) { if(!items.ContainsKey(subdata.SeoTitle)) { string CreateDate = subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss"); items.Add(subdata.SeoTitle, subdata.ProfitAmount + "|" + CreateDate); } else { string[] datalist = items[subdata.SeoTitle].Split('|'); decimal ProfitAmount = decimal.Parse(datalist[0]) + subdata.ProfitAmount; items[subdata.SeoTitle] = ProfitAmount + "|" + datalist[1]; } } foreach (string MonthString in items.Keys) { Dictionary curData = new Dictionary(); string[] datalist = items[MonthString].Split('|'); curData.Add("TradeProfit", datalist[0]); //交易分润 string Month = MonthString.Substring(0, 4) + "-" + MonthString.Substring(4); curData.Add("TradeMonth", Month); //交易月 curData.Add("CreateDate", datalist[1]); //CreateDate 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 } }