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 PosMachinesController : BaseController { public PosMachinesController(IHttpContextAccessor accessor, ILogger logger, IOptions setting) : base(accessor, logger, setting) { } #region 首页-客小爽产品-机具管理-已绑定机具列表 [Authorize] public JsonResult MyMachinesForBind(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Other = new Dictionary(); List> dataList = MyMachinesForBindDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } public List> MyMachinesForBindDo(string value, out Dictionary Other) { JsonData data = JsonMapper.ToObject(value); int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //所属创客 int BrandId = int.Parse(function.CheckInt(data["BrandId"].ToString())); //产品类型 string SnNo = data["SnNo"].ToString(); //SN号 int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString())); int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString())); List> dataList = new List>(); if (!string.IsNullOrEmpty(SnNo)) { PageSize = 100000; } IQueryable query = maindb.PosMachinesTwo.Where(m => m.Status > -1 && m.BuyUserId == UserId && m.BrandId == BrandId && m.BindingState == 1); if (!string.IsNullOrEmpty(SnNo)) { query = query.Where(m => m.PosSn == SnNo); } Other = new Dictionary(); if (PageNum == 1) { Other.Add("count", query.Count()); 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(); int IsLeader = 0;//是否为大盟主机(0-否 1-是) if (subdata.LeaderUserId > 0) { IsLeader = 1; } else { IsLeader = 0; } curData.Add("ActivationState", subdata.ActivationState == 1 ? "已激活" : "未激活"); //激活状态 curData.Add("PosSn", subdata.PosSn); //SN编号 curData.Add("PosSnType", RelationClass.GetPosSnTypeInfo(subdata.PosSnType)); //机具类型 curData.Add("Id", subdata.Id); //Id decimal Deposit = 299; if (BrandId == 6) { Deposit = 249; } if (!string.IsNullOrEmpty(subdata.PrizeParams)) { Deposit = decimal.Parse(function.CheckNum(subdata.PrizeParams)); } curData.Add("Deposit", Deposit); curData.Add("BindedMerchant", subdata.BuyUserId != subdata.UserId ? 1 : 0); //是否已绑定商户型创客 curData.Add("IsLeader",IsLeader); dataList.Add(curData); } return dataList; } #endregion #region 首页-客小爽产品-机具管理-总机具列表 [Authorize] public JsonResult MyMachines(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Other = new Dictionary(); List> dataList = MyMachinesDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } public List> MyMachinesDo(string value, out Dictionary Other) { JsonData data = JsonMapper.ToObject(value); int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //所属创客 int BrandId = int.Parse(function.CheckInt(data["BrandId"].ToString())); //产品类型 string SnNo = data["SnNo"].ToString(); //SN号 int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString())); int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString())); List> dataList = new List>(); if (!string.IsNullOrEmpty(SnNo)) { PageSize = 100000; } IQueryable query = maindb.PosMachinesTwo.Where(m => m.Status > -1 && m.BuyUserId == UserId && m.BrandId == BrandId); if (!string.IsNullOrEmpty(SnNo)) { query = query.Where(m => m.PosSn == SnNo); } Other = new Dictionary(); if (PageNum == 1) { Other.Add("count", query.Count()); 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(); int IsLeader = 0;//是否为大盟主机(0-否 1-是) if (subdata.LeaderUserId > 0) { IsLeader = 1; } else { IsLeader = 0; } curData.Add("PosSn", subdata.PosSn); //SN编号 curData.Add("PosSnType", RelationClass.GetPosSnTypeInfo(subdata.PosSnType)); //机具类型 curData.Add("Id", subdata.Id); //Id curData.Add("CreateDate", subdata.TransferTime == null ? "" : subdata.TransferTime.Value.ToString("yyyy-MM-dd HH:mm:ss")); //CreateDate StoreHouse store = StoreHouseDbconn.Instance.Get(subdata.StoreId) ?? new StoreHouse(); curData.Add("FromStore", store.StoreName); //来自仓库 decimal Deposit = 299; if (BrandId == 6) { Deposit = 249; } if (!string.IsNullOrEmpty(subdata.PrizeParams)) { Deposit = decimal.Parse(function.CheckNum(subdata.PrizeParams)); } curData.Add("Deposit", Deposit); curData.Add("IsLeader",IsLeader); dataList.Add(curData); } return dataList; } #endregion #region 首页-客小爽产品-机具管理-未绑定机具列表 [Authorize] public JsonResult MyMachinesForUnBind(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); Dictionary Other = new Dictionary(); List> dataList = MyMachinesForUnBindDo(value, out Other); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList, Other = Other }); } public List> MyMachinesForUnBindDo(string value, out Dictionary Other) { JsonData data = JsonMapper.ToObject(value); int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //所属创客 int BrandId = int.Parse(function.CheckInt(data["BrandId"].ToString())); //产品类型 string SnNo = data["SnNo"].ToString(); //SN号 int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString())); int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString())); List> dataList = new List>(); if (!string.IsNullOrEmpty(SnNo)) { PageSize = 100000; } IQueryable query = maindb.PosMachinesTwo.Where(m => m.Status > -1 && m.BuyUserId == UserId && m.BrandId == BrandId && m.BindingState == 0); if (!string.IsNullOrEmpty(SnNo)) { query = query.Where(m => m.PosSn == SnNo && m.PosSnType == 0); } Other = new Dictionary(); if (PageNum == 1) { Other.Add("count", query.Count()); 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(); int IsLeader = 0;//是否为大盟主机(0-否 1-是) if (subdata.LeaderUserId > 0) { IsLeader = 1; } else { IsLeader = 0; } curData.Add("PosSn", subdata.PosSn); //SN编号 curData.Add("PosSnType", RelationClass.GetPosSnTypeInfo(subdata.PosSnType)); //机具类型 curData.Add("Id", subdata.Id); //Id if (subdata.RecycEndDate != null) { TimeSpan ts = subdata.RecycEndDate.Value - DateTime.Now; curData.Add("ActDays", ts.TotalDays.ToString("f0")); //活动剩余天数 } else { curData.Add("ActDays", 0); //活动剩余天数 } curData.Add("CreateDate", subdata.CreateDate.Value.ToString("yyyy-MM-dd")); //机具初始日期 curData.Add("EndDate", subdata.RecycEndDate == null ? "" : subdata.RecycEndDate.Value.ToString("yyyy-MM-dd")); //截止日期 decimal Deposit = 299; if (BrandId == 6) { Deposit = 249; } if (!string.IsNullOrEmpty(subdata.PrizeParams)) { Deposit = decimal.Parse(function.CheckNum(subdata.PrizeParams)); } curData.Add("Deposit", Deposit); curData.Add("IsLeader",IsLeader); dataList.Add(curData); } return dataList; } #endregion #region 首页-客小爽产品-机具管理-已绑定机具列表-设置商户型创客(立刷) [Authorize] public JsonResult SetMerchantMaker(string value) { //TODO: 要做一下判断机具是否是当前操作人本人 value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); int SnId = int.Parse(function.CheckInt(data["SnId"].ToString())); int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); Users user = maindb.Users.FirstOrDefault(m => m.Id == UserId); if (user != null) { if (user.MerchantType == 1) { return Json(new AppResultJson() { Status = "-1", Info = "创客" + user.MakerCode + "已是商户型创客,请勿重复设置" }); } if (user.AuthFlag != 1) { return Json(new AppResultJson() { Status = "-1", Info = "创客" + user.MakerCode + "未实名认证" }); } bool checkPos = maindb.PosMachinesTwo.Any(m => m.Status > -1 && m.UserId == user.Id); if (checkPos) { return Json(new AppResultJson() { Status = "-1", Info = "创客" + user.MakerCode + "已拥有机具" }); } PosMachinesTwo pos = maindb.PosMachinesTwo.FirstOrDefault(m => m.Status > -1 && m.Id == SnId); if (pos != null) { if (!function.CheckNull(user.ParentNav).Contains("," + pos.BuyUserId + ",")) { return Json(new AppResultJson() { Status = "-1", Info = "创客" + user.MakerCode + "不在您可操作的系统内" }); } pos.UserId = user.Id; user.MerchantType = 1; string MerNo = ""; PosMerchantInfo merchant = maindb.PosMerchantInfo.FirstOrDefault(m => m.Id == pos.BindMerchantId); if (merchant != null) { merchant.UserId = user.Id; merchant.MerUserType = 1; MerNo = merchant.MerchantName; } pos.SeoTitle = user.Id.ToString(); // 记录商户型创客的Id maindb.SetMerchantTypeRecord.Add(new SetMerchantTypeRecord() { CreateDate = DateTime.Now, IsRecyc = (ulong)pos.IsPurchase, CreditAmount = pos.CreditTrade, PosSnType = pos.PosSnType, ActDate = pos.ActivationTime, BindDate = pos.BindingTime, ActStatus = (ulong)pos.ActivationState, BindStatus = (ulong)pos.BindingState, MerNo = MerNo, PosSn = pos.PosSn, Note = "设置商户型创客", ToUserId = user.Id, FromUserId = pos.BuyUserId, }); maindb.SaveChanges(); } } return Json(new AppResultJson() { Status = "1", Info = "" }); } #endregion #region 首页-客小爽产品-机具管理-已绑定机具列表-设置商户型创客(无创客编号) [Authorize] public JsonResult SetMerchantMakerWithoutUser(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); int SnId = int.Parse(function.CheckInt(data["SnId"].ToString())); int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); string path = function.CreateQRCode2(SourceHost + "/p/user-inviteregist-1?Id=" + UserId + "&SnId=" + SnId, function.MD5_16(SnId.ToString()), "/static/MerQrCode/"); path = path.Replace("//", "/"); return Json(new AppResultJson() { Status = "1", Info = "", Data = SourceHost + path }); } #endregion #region 首页-客小爽产品-机具管理-整箱划拨搜索 [Authorize] public JsonResult WholeSearchByUser(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = WholeSearchByUserDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> WholeSearchByUserDo(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())); int BrandSubId = int.Parse(function.CheckInt(data["BrandSubId"].ToString())); string SnNo = data["SnNo"].ToString(); //搜索关键词 int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString())); int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString())); List> dataList = new List>(); if (string.IsNullOrEmpty(SnNo)) { return dataList; } List MachineSnNos = maindb.MachineForSnNo.Where(m => m.SnNo.Contains(SnNo)).ToList(); List SnIds = MachineSnNos.Select(m => m.SnId).ToList(); List query = maindb.PosMachinesTwo.Where(m => SnIds.Contains(m.Id) && m.Status > -1 && m.BuyUserId == UserId && m.BrandId == BrandId && m.BindingState == 0 && m.ActivationState == 0 && m.PreUserId == 0).OrderBy(m => m.PosSn).ToList(); foreach (var subdata in query) { Dictionary curData = new Dictionary(); curData.Add("PosSn", subdata.PosSn); //SN编号 curData.Add("Id", subdata.Id); //Id curData.Add("ProductType", RelationClass.GetKqProductBrandInfo(subdata.BrandId)); //产品类型 int day = 0; if (subdata.RecycEndDate != null) { TimeSpan ts = subdata.RecycEndDate.Value - DateTime.Now; day = ts.Days; } curData.Add("ActDays", day); curData.Add("EndDate", subdata.RecycEndDate == null ? "" : subdata.RecycEndDate.Value.ToString("yyyy-MM-dd")); dataList.Add(curData); } return dataList; } #endregion #region 首页-仓库管理-整箱划拨搜索 [Authorize] public JsonResult WholeSearch(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = WholeSearchDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> WholeSearchDo(string value) { JsonData data = JsonMapper.ToObject(value); int StoreId = int.Parse(function.CheckInt(data["StoreId"].ToString())); //所在仓库 int BrandId = int.Parse(function.CheckInt(data["BrandId"].ToString())); string SearchKey = data["SearchKey"].ToString(); //搜索关键词 int PageSize = int.Parse(function.CheckInt(data["PageSize"].ToString())); int PageNum = int.Parse(function.CheckInt(data["PageNum"].ToString())); List> dataList = new List>(); if (string.IsNullOrEmpty(SearchKey)) { return dataList; } List SnNos = new List(); int start = int.Parse(SearchKey.Substring(SearchKey.Length - 4)); for (int i = start; i < start + 100; i++) { string EndNo = i.ToString(); for (int j = 0; j < 4 - i.ToString().Length; j++) { EndNo = "0" + EndNo; } string SnNo = SearchKey.Substring(0, SearchKey.Length - 4) + EndNo; SnNos.Add(SnNo); } List MachineSnNos = maindb.MachineForSnNo.Where(m => SnNos.Contains(m.SnNo)).ToList(); List SnIds = MachineSnNos.Select(m => m.SnId).ToList(); List query = maindb.PosMachinesTwo.Where(m => SnIds.Contains(m.Id) && m.Status > -1 && m.StoreId == StoreId && m.BrandId == BrandId && m.UserId == 0 && m.PosSnType == 0 && m.BindingState == 0 && m.ActivationState == 0 && m.PreUserId == 0).OrderBy(m => m.PosSn).ToList(); foreach (var subdata in query) { Dictionary curData = new Dictionary(); curData.Add("PosSn", subdata.PosSn); //SN编号 curData.Add("Id", subdata.Id); //Id curData.Add("ProductType", RelationClass.GetKqProductBrandInfo(subdata.BrandId)); //产品类型 dataList.Add(curData); } return dataList; } #endregion #region 首页-仓库管理-逐台划拨搜索 [Authorize] public JsonResult OneSearch(string value) { value = DesDecrypt(value); JsonData data = JsonMapper.ToObject(value); List> dataList = OneSearchDo(value); return Json(new AppResultJson() { Status = "1", Info = "", Data = dataList }); } public List> OneSearchDo(string value) { JsonData data = JsonMapper.ToObject(value); int StoreId = int.Parse(function.CheckInt(data["StoreId"].ToString())); //所在仓库 int BrandId = int.Parse(function.CheckInt(data["BrandId"].ToString())); string SearchKey = data["SearchKey"].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.PosMachinesTwo.Where(m => m.Status > -1 && m.StoreId == StoreId && m.BrandId == BrandId && m.UserId == 0 && m.PreUserId == 0).OrderBy(m => m.PosSn).ToList(); if (!string.IsNullOrEmpty(SearchKey)) { query = query.Where(m => m.PosSn.EndsWith(SearchKey)).ToList(); } if (PageNum == 1) { query = query.Take(PageSize).ToList(); } else { int skipNum = PageSize * (PageNum - 1); query = query.Skip(skipNum).Take(PageSize).ToList(); } foreach (var subdata in query) { Dictionary curData = new Dictionary(); curData.Add("PosSn", subdata.PosSn); //SN编号 curData.Add("Id", subdata.Id); //Id curData.Add("ProductType", RelationClass.GetKqProductBrandInfo(subdata.BrandId)); //产品类型 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 } }