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 logger, IOptions setting) : base(accessor, logger, setting) { } #region 创客-首页-仓库管理-售后单列表 [Authorize] public JsonResult OrderList(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = OrderListDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> 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> dataList = new List>(); IQueryable 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 curData = new Dictionary(); 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> 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())); //创客 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.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 curData = new Dictionary(); 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 Obj = DetailDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj }); } public Dictionary 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 Obj = new Dictionary(); 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 PosPhoto = new List(); 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 Obj = new Dictionary(); 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,不合法返回提示信息 /// /// 检查签名是否合法,合法返回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 } }