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 PosMachinesTwoController : BaseController { public PosMachinesTwoController(IHttpContextAccessor accessor, ILogger logger, IOptions setting) : base(accessor, logger, setting) { } #region 创客-过期机具回收-回收机具列表 [Authorize] public JsonResult RecycPos(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Obj = new Dictionary(); List> dataList = RecycPosDo(value, out Obj); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Obj }); } public List> RecycPosDo(string value, out Dictionary Other) { JsonData data = JsonMapper.ToObject(value); int BrandId = int.Parse(function.CheckInt(data["BrandId"].ToString())); //产品类型 int RecycStatus = int.Parse(function.CheckInt(data["RecycStatus"].ToString())); //回收状态(0 待回收 1 已回收 2 拒绝 99 待处理) int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //机具所属人 int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString())); int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString())); List> dataList = new List>(); var time = DateTime.Parse(DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd 00:00:00"));//过期限制时间 IQueryable query = maindb.PosMachinesTwo.Where(m => m.Status > -1 && m.BuyUserId == UserId && m.ScanQrTrade == 999 && m.BindingState == 0 && m.ActivationState == 0 && m.RecycEndDate < time); var RecyclableCount = maindb.PosMachinesTwo.Where(m => m.Status > -1 && m.ScanQrTrade == 999 && m.BuyUserId == UserId && m.BrandId == BrandId && m.BindingState == 0 && m.ActivationState == 0 && m.RecycEndDate < time && m.RecycStatus == 0).Count(); var PendCount = maindb.PosMachinesTwo.Where(m => m.Status > -1 && m.ScanQrTrade == 999 && m.BuyUserId == UserId && m.BrandId == BrandId && m.BindingState == 0 && m.ActivationState == 0 && m.RecycEndDate < time && m.RecycStatus == 99).Count(); if (!string.IsNullOrEmpty(data["BrandId"].ToString())) { query = query.Where(m => m.BrandId == BrandId); } if (!string.IsNullOrEmpty(data["RecycStatus"].ToString())) { query = query.Where(m => m.RecycStatus == RecycStatus); } query = query.OrderByDescending(m => m.CreateDate).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("PosSn", subdata.PosSn); //SN编号 curData.Add("RecycEndDate", subdata.RecycEndDate == null ? "" : subdata.RecycEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //循环截止时间 curData.Add("Id", subdata.Id); //Id dataList.Add(curData); } Dictionary Obj = new Dictionary(); Obj.Add("RecyclableCount", RecyclableCount);//可回收数量 Obj.Add("PendCount", PendCount);//待处理数量 Other = Obj; 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 } }