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 StoreHouseController : BaseController { public StoreHouseController(IHttpContextAccessor accessor, ILogger logger, IOptions setting) : base(accessor, logger, setting) { } #region 创客-商城-确认支付-发货仓库 [Authorize] public JsonResult SendStores(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = SendStoresDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> SendStoresDo(string value) { JsonData data = JsonMapper.ToObject(value); int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客Id string BrandId = data["BrandId"].ToString(); //品牌Id string searchContent = data["searchContent"].ToString(); int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString())); int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString())); Users user = UsersDbconn.Instance.Get(UserId) ?? new Users(); List uids = new List(); uids.Add(1); uids.Add(UserId); if (!string.IsNullOrEmpty(user.ParentNav)) { string ParentNav = function.CheckNull(user.ParentNav).Trim(',').Replace(",,", ","); string[] ParentNavList = ParentNav.Split(','); // foreach (string uid in ParentNavList) // { // uids.Add(int.Parse(uid)); // } int TopUserId = 0; if (ParentNavList.Length > 1) { TopUserId = int.Parse(ParentNavList[1]); } else { TopUserId = int.Parse(ParentNavList[0]); } string UidString = "," + TopUserId + ","; var subusers = maindb.Users.Select(m => new { m.Id, m.ParentNav }).Where(m => m.ParentNav.Contains(UidString)).ToList(); foreach (var subuser in subusers) { uids.Add(subuser.Id); } uids.Add(TopUserId); } // string UidString = "," + UserId + ","; // var subusers = maindb.Users.Select(m => new { m.Id, m.ParentNav }).Where(m => m.ParentNav.Contains(UidString)).ToList(); // foreach (var subuser in subusers) // { // uids.Add(subuser.Id); // } List> dataList = new List>(); IQueryable query = maindb.StoreHouse.Where(m => m.Status == 1); if (UserId == 1) { query = query.Where(m => m.LaveNum > 0 && m.BrandId == BrandId); } else { query = query.Where(m => uids.Contains(m.UserId) && m.LaveNum > 0 && m.BrandId == BrandId); } // IQueryable query = maindb.StoreHouse.Where(m => m.LaveNum > 0 && m.BrandId == BrandId); if (!string.IsNullOrEmpty(searchContent)) { query = query.Where(m => m.StoreName.Contains(searchContent)); } query = query.OrderBy(m => m.UserId); if (PageNum == 1) { query = query.Take(PageSize); } else { int skipNum = PageSize * (PageNum - 1); query = query.Skip(skipNum).Take(PageSize); } foreach (StoreHouse subdata in query.ToList()) { // StoreHouse subdata = StoreHouseDbconn.Instance.Get(id) ?? new StoreHouse(); Dictionary curData = new Dictionary(); curData.Add("StoreName", subdata.StoreName); //仓库名称 curData.Add("Address", subdata.Address); //仓库地址 curData.Add("LaveNum", subdata.LaveNum); //剩余库存数 curData.Add("Areas", function.CheckNull(subdata.Areas).Replace(",", "")); //所属地区 curData.Add("Id", subdata.Id); //Id dataList.Add(curData); } return dataList; } #endregion #region 创客-商城-确认支付-发货仓库详情 [Authorize] public JsonResult SendStoreDetail(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Obj = SendStoreDetailDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj }); } public Dictionary SendStoreDetailDo(string value) { JsonData data = JsonMapper.ToObject(value); string UserId = data["UserId"].ToString(); //创客Id Dictionary Obj = new Dictionary(); StoreHouse query = new StoreHouse(); int Id = int.Parse(function.CheckInt(data["Id"].ToString())); query = StoreHouseDbconn.Instance.Get(Id) ?? new StoreHouse(); Obj.Add("StoreName", query.StoreName); //仓库名称 Obj.Add("Address", query.Address); //仓库地址 Obj.Add("LaveNum", query.LaveNum); //剩余库存数 Obj.Add("Areas", function.CheckNull(query.Areas).Replace(",", "")); //所属地区 Users user = UsersDbconn.Instance.Get(query.ManageUserId) ?? new Users(); Obj.Add("ManageName", user.RealName); //仓库联系人名称 if(query.ManageUserId == 1) { Obj.Add("ManageMobile", "19141324516"); //仓库联系人手机号 } else { Obj.Add("ManageMobile", user.Mobile); //仓库联系人手机号 } Obj.Add("Id", query.Id); //Id return Obj; } #endregion #region 首页-仓库管理-主界面产品 [Authorize] public JsonResult IndexList(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = IndexListDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> IndexListDo(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>(); List query = maindb.StoreHouse.Where(m => m.UserId == UserId && m.Sort == 0 && m.Status > 0).ToList(); //StoreHouseDbconn.Instance.GetList(UserId, PageNum, PageSize); foreach (StoreHouse subdata in query) { // StoreHouse subdata = StoreHouseDbconn.Instance.Get(id) ?? new StoreHouse(); Dictionary curData = new Dictionary(); curData.Add("ProductName", subdata.ProductName); //产品名称 int PreCount = maindb.PreSendStockDetail.Count(m => m.FromStoreId == subdata.Id && m.ApplyFlag == 0 && m.Status >= 0 && m.Status <= 1); curData.Add("LaveNum", subdata.LaveNum); //剩余库存数 curData.Add("PreCount", PreCount); //预发机数 curData.Add("Id", subdata.Id); //Id curData.Add("BrandId", subdata.BrandId); curData.Add("Icon", ""); //产品图标 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 } }