mp-ap/Areas/Api/Controllers/v1/Pos/PosMachinesTwoController.cs

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<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
        {
        }




        #region 创客-过期机具回收-回收机具列表
        [Authorize]
        public JsonResult RecycPos(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = new Dictionary<string, object>();
            List<Dictionary<string, object>> dataList = RecycPosDo(value, out Obj);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Obj });
        }
        public List<Dictionary<string, object>> RecycPosDo(string value, out Dictionary<string, object> 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<Dictionary<string, object>> dataList = new List<Dictionary<string, object>>();
            var time = DateTime.Parse(DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd 00:00:00"));//过期限制时间
            IQueryable<PosMachinesTwo> 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<string, object> curData = new Dictionary<string, object>();
                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<string, object> Obj = new Dictionary<string, object>();
            Obj.Add("RecyclableCount", RecyclableCount);//可回收数量
            Obj.Add("PendCount", PendCount);//待处理数量
            Other = Obj;
            return dataList;
        }
        #endregion



        #region 检查签名是否合法，合法返回1，不合法返回提示信息

        /// <summary>
        /// 检查签名是否合法，合法返回1，不合法返回提示信息
        /// </summary>
        /// <param name="value">请求的参数(json字符串)</param>
        /// <param name="signField">要签名的字段</param>
        /// <returns></returns>
        private string CheckSign(string value, string[] signField)
        {
            JsonData json = JsonMapper.ToObject(value);
            Dictionary<string, string> dic = new Dictionary<string, string>();
            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

    }
}