mp-ap/Areas/Api/Controllers/v1/Pos/MachineChangeController.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.pos
{
    [Area("Api")]
    [Route("Api/v1/pos/[controller]/[action]")]
    public class MachineChangeController : BaseController
    {
        public MachineChangeController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
        {
        }




        #region 创客-首页-仓库管理-售后单列表
        [Authorize]
        public JsonResult OrderList(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = OrderListDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> OrderListDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int OutStoreId = int.Parse(function.CheckInt(data["OutStoreId"].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>>();
            IQueryable<MachineChange> query = maindb.MachineChange.Where(m => m.OutStoreId == OutStoreId);
            query = query.OrderByDescending(m => m.Id);
            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<string, object> curData = new Dictionary<string, object>();
                curData.Add("UserId", subdata.UserId); //创客
                curData.Add("BackProductType", RelationClass.GetKqProductBrandInfo(subdata.BackProductType)); //退回产品类型
                curData.Add("ChangeTime", subdata.ChangeTime == null ? "" : subdata.ChangeTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); //转换时间
                curData.Add("AuditResult", subdata.AuditResult); //审核结果
                curData.Add("ChangeSnExpand", subdata.ChangeSnExpand); //转换机器SN来源
                curData.Add("Id", subdata.Id); //Id
                Orders order = maindb.Orders.FirstOrDefault(m => m.Id == subdata.QueryCount) ?? new Orders();
                curData.Add("ReceiveName", order.RealName); //收货人
                curData.Add("Address", order.Address); //收货地址
                curData.Add("Mobile", order.Mobile); //联系电话
                curData.Add("DeliveryType", order.DeliveryType); //提货方式
                curData.Add("Reason", subdata.SeoKeyword); //换新原因
                curData.Add("OrderStatus", order.Status);
                curData.Add("NewSnNo", order.SnNos); //新机具SN
                dataList.Add(curData);
            }
            return dataList;
        }
        #endregion



        #region 创客-首页-售后换新-换新记录
        [Authorize]
        public JsonResult List(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            List<Dictionary<string, object>> dataList = ListDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList });
        }
        public List<Dictionary<string, object>> ListDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            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>>();
            IQueryable<MachineChange> query = maindb.MachineChange.Where(m => m.UserId == UserId);
            query = query.OrderByDescending(m => m.Id);
            if (PageNum == 1)
            {
                query = query.Take(PageSize);
            }
            else
            {
                int skipNum = PageSize * (PageNum - 1);
                query = query.Skip(skipNum).Take(PageSize);
            }
            foreach (var subdata in query)
            {
                Dictionary<string, object> curData = new Dictionary<string, object>();
                curData.Add("AuditResult", subdata.AuditResult); //审核结果
                curData.Add("ChangeSnExpand", subdata.ChangeSnExpand); //转换机器SN来源
                curData.Add("Id", subdata.Id); //Id
                curData.Add("CreateDate", subdata.CreateDate == null ? "" : subdata.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //CreateDate
                curData.Add("Reason", subdata.SeoKeyword); //换机原因
                dataList.Add(curData);
            }
            return dataList;
        }
        #endregion



        #region 创客-首页-售后换新-换新记录-详情
        [Authorize]
        public JsonResult Detail(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = DetailDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
        }
        public Dictionary<string, object> DetailDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            int Id = int.Parse(function.CheckInt(data["Id"].ToString()));
            Dictionary<string, object> Obj = new Dictionary<string, object>();
            MachineChange query = maindb.MachineChange.FirstOrDefault(m => m.Id == Id && m.UserId == UserId) ?? new MachineChange();
            StoreHouse store = maindb.StoreHouse.FirstOrDefault(m => m.Id == query.OutStoreId) ?? new StoreHouse();
            Obj.Add("BackProductType", RelationClass.GetKqProductBrandInfo(query.BackProductType)); //退回产品类型
            Obj.Add("ChangeDeviceNum", query.ChangeDeviceNum); //转换机具数量
            Obj.Add("ChangeTime", query.ChangeTime == null ? "" : query.ChangeTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); //转换时间
            Obj.Add("AuditResult", query.AuditResult); //审核结果, 0：待审核，1：通过，2：驳回
            Obj.Add("ChangeSnExpand", query.ChangeSnExpand); //转换机器SN来源
            Obj.Add("OutStoreId", store.StoreName); //出库仓库
            Obj.Add("OutStoreManager", query.OutStoreManager); //出库仓库联系人
            Obj.Add("ChangeDate", query.CreateDate == null ? "" : query.CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss")); //申请时间
            Obj.Add("Reason", query.SeoKeyword); //换机原因
            Orders order = maindb.Orders.FirstOrDefault(m => m.Id == query.QueryCount) ?? new Orders();
            Obj.Add("DeliveryType", order.DeliveryType); //提货方式
            Obj.Add("Note", query.Remark); //备注
            Obj.Add("OrderId", order.Id); //订单Id
            Obj.Add("ReceiveName", order.RealName); //收货人
            Obj.Add("Address", order.Areas + order.Address); //收货地址
            Obj.Add("Mobile", order.Mobile); //联系电话
            Obj.Add("NewSnNo", order.SnNos); //新机具SN
            Obj.Add("OrderStatus", order.Status); //订单状态, 2：已发货（成功），1：待发货，-1：已驳回
            List<string> PosPhoto = new List<string>();
            if (!string.IsNullOrEmpty(query.SeoDescription))
            {
                string[] Photos = query.SeoDescription.Split(',');
                foreach (string Photo in Photos)
                {
                    PosPhoto.Add(SourceHost + Photo);
                }
            }
            Obj.Add("PosPhoto", PosPhoto); //机具照片(数组)
            return Obj;
        }
        #endregion



        #region 创客-首页-售后换新-提交
        [Authorize]
        public JsonResult Add(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            AppResultJson result = AddDo(value);
            return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
        }
        public AppResultJson AddDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            int BrandId = int.Parse(function.CheckInt(data["BackProductType"].ToString())); //退回产品类型
            string ChangeSnExpand = data["ChangeSnExpand"].ToString(); //转换机器SN来源
            string Remark = data["Remark"].ToString(); //订单备注
            int OutStoreId = int.Parse(function.CheckInt(data["OutStoreId"].ToString())); //出库仓库
            string PosPhoto = data["PosPhoto"].ToString(); //机具照片
            int AddressId = int.Parse(function.CheckInt(data["AddressId"].ToString())); //收货地址
            int DeliveryType = int.Parse(function.CheckInt(data["DeliveryType"].ToString()));//提货方式
            string Reason = data["Reason"].ToString(); //换机原因
            string Note = data["Note"].ToString(); //备注
            if (OutStoreId == 0)
            { 
                return new AppResultJson() { Status = "-1", Info = "请选择出库仓库" };
            }
            if (string.IsNullOrEmpty(ChangeSnExpand))
            {
                return new AppResultJson() { Status = "-1", Info = "请填写机具SN号" };
            }
            MachineForSnNo forSnNo = maindb.MachineForSnNo.FirstOrDefault(m => m.SnNo == ChangeSnExpand);
            if (forSnNo == null)
            {
                return new AppResultJson() { Status = "-1", Info = "机具SN号不正确" };
            }
            string ChangeNo = "BC" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + function.get_Random(8);
            KqProducts protype = KqProductsDbconn.Instance.GetList().FirstOrDefault(m => m.Id == BrandId) ?? new KqProducts();
            Users user = UsersDbconn.Instance.Get(UserId) ?? new Users();
            UserAddress address = UserAddressDbconn.Instance.Get(AddressId) ?? new UserAddress();
            StoreHouse store = StoreHouseDbconn.Instance.Get(OutStoreId) ?? new StoreHouse();
            if (store.BrandId != BrandId.ToString())
            { 
                return new AppResultJson() { Status = "-1", Info = "你选择的品牌和仓库不一致" };
            }
            Users storeuser = UsersDbconn.Instance.Get(store.UserId) ?? new Users();
            Users manager = UsersDbconn.Instance.Get(store.ManageUserId) ?? new Users();
            string OrderNo = "BM" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + function.get_Random(8);
            bool check = maindb.MachineChange.Any(m => m.ChangeSnExpand == ChangeSnExpand && m.AuditResult < 2);
            if (check)
            {
                return new AppResultJson() { Status = "-1", Info = "申请已提交，请勿重复申请" };
            }
            Dictionary<string, object> Obj = new Dictionary<string, object>();
            RedisDbconn.Instance.GetLock("MachineChange:" + UserId);
            MachineChange query = maindb.MachineChange.Add(new MachineChange()
            {
                CreateDate = DateTime.Now,
                UpdateDate = DateTime.Now,
                SeoKeyword = Reason,
                SeoDescription = PosPhoto,
                ChangeNo = ChangeNo, //转换单号
                UserId = UserId, //创客
                BackProductType = BrandId, //退回产品类型
                BackProductName = protype.Name, //退回产品名称
                ChangeDeviceNum = 1, //转换机具数量
                ChangeTime = DateTime.Now, //转换时间
                ChangeSnExpand = ChangeSnExpand, //转换机器SN来源
                BackStoreId = OutStoreId, //退回仓库
                BackStoreName = store.StoreName, //退回仓库名称
                Remark = Note, //订单备注
                BackStoreUserId = store.UserId, //退回仓库归属人
                OutProductType = BrandId, //出库产品类型
                OutProductName = protype.Name, //出库产品名称
                OutStoreId = OutStoreId, //出库仓库
                OutStoreName = store.StoreName, //出库仓库名称
                OutStoreAreas = store.Areas, //出库仓库所在地区
                OutStoreAddress	 = store.Address, //出库仓库地址
                OutStoreManager = storeuser.RealName, //出库仓库联系人
                OutStoreManagerMobile = store.ManageMobile, //出库仓库联系人手机号
            }).Entity;
            maindb.SaveChanges();
            RedisDbconn.Instance.ReleaseLock("MachineChange:" + UserId);
            Orders order = maindb.Orders.Add(new Orders()
            {
                OrderNo = OrderNo,
                RealName = address.RealName,
                Mobile = address.Mobile,
                Areas = address.Areas,
                Address = address.Address,
                StoreContact = manager.RealName,
                StoreContactMobile = store.ManageMobile,
                StoreUserId = store.UserId,
                StoreType = store.StoreType,
                CreateDate = DateTime.Now, //创建时间
                UserId = UserId, //创客
                StoreId = OutStoreId, //仓库
                TopUserId = PublicFunction.GetTopUserId(user.ParentNav), //顶级创客
                DeliveryType = DeliveryType, //提货类型
                BuyCount = 1,
                TotalPrice = 0, //订单总额
                Remark = Remark, //订单备注
                Status = 1,
                PayStatus = 1,
                PayDate = DateTime.Now,
                QueryCount = 2, //申请换新机标记
                Sort = query.Id,
            }).Entity;
            maindb.SaveChanges();
            MachineChange edit = maindb.MachineChange.FirstOrDefault(m => m.Id == query.Id);
            if (edit != null)
            {
                edit.QueryCount = order.Id;
                maindb.SaveChanges();
            }
            OrderForNo orderFor = maindb.OrderForNo.Add(new OrderForNo()
            {
                OrderNo = OrderNo,
                OrderIds = order.Id.ToString(),
            }).Entity;
            maindb.SaveChanges();
            Obj.Add("Id", query.Id); //Id
            return new AppResultJson() { Status = "1", Info = "", Data = Obj };
        }
        #endregion



        #region 创客-首页-售后换新-查询
        [Authorize]
        public JsonResult Check(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            AppResultJson result = CheckDo(value);
            return Json(new AppResultJson() { Status = result.Status, Info = result.Info, Data = result.Data });
        }
        public AppResultJson CheckDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            int BrandId = int.Parse(function.CheckInt(data["BrandId"].ToString())); //品牌
            string PosSn = data["PosSn"].ToString(); //转换机器SN来源
            PosMachinesTwo pos = maindb.PosMachinesTwo.FirstOrDefault(m => m.Status > -1 && m.PosSn == PosSn && m.UserId == UserId);
            if (pos == null)
            {
                return new AppResultJson() { Status = "-1", Info = "SN不存在" };
            }
            if (pos.BrandId != BrandId)
            { 
                return new AppResultJson() { Status = "-1", Info = "选择的品牌和SN号不一致" };
            }
            bool check = maindb.MachineChange.Any(m => m.ChangeSnExpand == PosSn && m.AuditResult < 2);
            if (check)
            {
                return new AppResultJson() { Status = "-1", Info = "此SN已提交，请勿重复申请" };
            }
            return new AppResultJson() { Status = "1", Info = "" };
        }
        #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

    }
}