using System; using System.Web; using System.Collections.Generic; using System.Diagnostics; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Http; using Microsoft.Extensions.Logging; using Microsoft.Extensions.Options; using MySystem.Models; using Library; using LitJson; using MySystemLib; /// /// 机具申请记录 /// namespace MySystem.Areas.Admin.Controllers { [Area("Admin")] [Route("Admin/[controller]/[action]")] public class StoreMachineApplyController : BaseController { public StoreMachineApplyController(IHttpContextAccessor accessor, ILogger logger, IOptions setting) : base(accessor, logger, setting) { OtherMySqlConn.connstr = ConfigurationManager.AppSettings["SqlConnStr"].ToString(); } #region 机具申请记录列表 /// /// 机具申请记录列表 /// /// public IActionResult Index(StoreMachineApply data, string right) { ViewBag.RightInfo = RightInfo; ViewBag.right = right; return View(); } #endregion #region 根据条件查询机具申请记录列表 /// /// 机具申请记录列表 /// /// public JsonResult IndexData(StoreMachineApply data, string MakerCode, string RealName, string StoreNo, string StoreName, string StoreMakerCode, string StatusSelect, string SendStatusSelect, string StoreTypeSelect, int page = 1, int limit = 30) { Dictionary Fields = new Dictionary(); Fields.Add("ApplyNo", "1"); //申请单号 Fields.Add("BrandId", "1"); //品牌 Fields.Add("ApplyTime", "3"); //申请时间 Fields.Add("ExpressNo", "1"); //快递单号 string condition = " and Status>-1"; //创客编号 if (!string.IsNullOrEmpty(MakerCode)) { condition += " and UserId in (select UserId from UserForMakerCode where MakerCode='" + MakerCode + "')"; } //创客名称 if (!string.IsNullOrEmpty(RealName)) { condition += " and UserId in (select UserId from UserForRealName where RealName='" + RealName + "')"; } //仓库编号 if (!string.IsNullOrEmpty(StoreNo)) { condition += " and StoreId in (select StoreId from StoreForCode where Code='" + StoreNo + "')"; } //仓库名称 if (!string.IsNullOrEmpty(StoreName)) { condition += " and StoreId in (select StoreId from StoreForName where Name='" + StoreName + "')"; } //仓库归属创客编号 if (!string.IsNullOrEmpty(StoreMakerCode)) { condition += " and UserId in (select UserId from UserForMakerCode where MakerCode='" + StoreMakerCode + "')"; } //订单状态 if (!string.IsNullOrEmpty(StatusSelect)) { condition += " and Status=" + StatusSelect; } //发货状态 if (!string.IsNullOrEmpty(SendStatusSelect)) { condition += " and SendStatus=" + SendStatusSelect; } //仓库类型 if (!string.IsNullOrEmpty(StoreTypeSelect)) { condition += " and StoreType=" + StoreTypeSelect; } Dictionary obj = new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).IndexData("StoreMachineApply", Fields, "Id desc", "0", page, limit, condition); List> diclist = obj["data"] as List>; foreach (Dictionary dic in diclist) { dic["BrandId"] = RelationClass.GetKqProductBrandInfo(int.Parse(dic["BrandId"].ToString())); //申请仓库信息 int StoreId = int.Parse(dic["StoreId"].ToString()); StoreHouse store = db.StoreHouse.FirstOrDefault(m => m.Id == StoreId) ?? new StoreHouse(); dic["StoreInfo"] = store.StoreNo + "
" + store.StoreName; //仓库收货地址 dic["StoreAddressInfo"] = store.Areas + "
" + store.Address; //仓库联系人信息 //dic["StoreContact"] = dic["StoreManagerMobile"].ToString() + "
" + dic["StoreManager"].ToString(); //仓库归属信息 // int StoreUserId = int.Parse(dic["StoreUserId"].ToString()); // Users storeUser = db.Users.FirstOrDefault(m => m.Id == StoreUserId) ?? new Users(); // int StoreType = int.Parse(dic["StoreType"].ToString()); // string StoreTypeName = ""; // if(StoreType == 0) StoreTypeName = "总仓"; // if(StoreType == 1) StoreTypeName = "分仓"; // dic["StoreUser"] = storeUser.MakerCode + "
" + StoreTypeName; //创客信息 int UserId = int.Parse(dic["UserId"].ToString()); Users puser = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users(); dic["UserInfo"] = puser.MakerCode + "
" + puser.RealName; //顶级创客 // int TopUserId = int.Parse(dic["TopUserId"].ToString()); // Users tuser = db.Users.FirstOrDefault(m => m.Id == TopUserId) ?? new Users(); // dic["TopUserInfo"] = tuser.MakerCode + "
" + tuser.RealName; //申请状态 int Status = int.Parse(dic["Status"].ToString()); if (Status == 0) dic["Status"] = "待审核"; if (Status == 1) dic["Status"] = "申请成功"; if (Status == 2) dic["Status"] = "申请失败"; } Dictionary other = new Dictionary(); other.Add("ApplyNum", 0); other.Add("SendNum", 0); obj.Add("other", other); return Json(obj); } #endregion #region 增加机具申请记录 /// /// 增加或修改机具申请记录信息 /// /// public IActionResult Add(string right) { ViewBag.RightInfo = RightInfo; ViewBag.right = right; return View(); } #endregion #region 增加机具申请记录 /// /// 增加或修改机具申请记录信息 /// /// [HttpPost] public string Add(StoreMachineApply data) { Dictionary Fields = new Dictionary(); Fields.Add("SeoTitle", data.SeoTitle); Fields.Add("SeoKeyword", data.SeoKeyword); Fields.Add("SeoDescription", data.SeoDescription); int Id = new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Add("StoreMachineApply", Fields, 0); AddSysLog(data.Id.ToString(), "StoreMachineApply", "add"); db.SaveChanges(); return "success"; } #endregion #region 修改机具申请记录信息 /// /// 增加或修改机具申请记录信息 /// /// public IActionResult Edit(string right, int Id = 0) { ViewBag.RightInfo = RightInfo; ViewBag.right = right; StoreMachineApply editData = db.StoreMachineApply.FirstOrDefault(m => m.Id == Id) ?? new StoreMachineApply(); ViewBag.data = editData; KqProducts kqProducts = db.KqProducts.FirstOrDefault(m => m.Id == editData.BrandId); ViewBag.BrandName = kqProducts.Name; Users user = db.Users.FirstOrDefault(m => m.Id == editData.UserId) ?? new Users(); ViewBag.MakerCode = user.MakerCode; ViewBag.RealName = user.RealName; int Status = editData.Status; if (Status == 0) ViewBag.Status = "待审核"; if (Status == 1) ViewBag.Status = "申请成功"; if (Status == 2) ViewBag.Status = "申请失败"; return View(); } #endregion #region 修改机具申请记录 /// /// 增加或修改机具申请记录信息 /// /// [HttpPost] public string Edit(StoreMachineApply data) { Dictionary Fields = new Dictionary(); Fields.Add("ApplyNo", data.ApplyNo); //申请单号 // Fields.Add("BrandId", data.BrandId); //产品Id Fields.Add("ApplyNum", data.ApplyNum); //申请箱数 Fields.Add("SendNum", data.SendNum); //发货箱数 // Fields.Add("UserId", data.UserId); //创客ID Fields.Add("Status", data.Status); //申请状态 Fields.Add("SwapSnExpand", data.SwapSnExpand);//已发货机具SN Fields.Add("SeoDescription", data.SeoDescription); //申请描述 new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("StoreMachineApply", Fields, data.Id); AddSysLog(data.Id.ToString(), "StoreMachineApply", "update"); db.SaveChanges(); return "success"; } #endregion #region 删除机具申请记录信息 /// /// 删除机具申请记录信息 /// /// public string Delete(string Id) { string[] idlist = Id.Split(new char[] { ',' }); AddSysLog(Id, "StoreMachineApply", "del"); foreach (string subid in idlist) { int id = int.Parse(subid); Dictionary Fields = new Dictionary(); Fields.Add("Status", -1); new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("StoreMachineApply", Fields, id); } db.SaveChanges(); return "success"; } #endregion #region 取消机具申请记录信息 /// /// 取消机具申请记录信息 /// /// public string Cancel(int Id) { AddSysLog(Id, "StoreMachineApply", "cancel"); AddSysLog(Id, "Orders", "cancel"); StoreMachineApply storeMachineApply = db.StoreMachineApply.FirstOrDefault(m => m.Id == Id); Orders order = db.Orders.FirstOrDefault(m => m.Id == storeMachineApply.OrderId); if (storeMachineApply != null && order != null) { function.WriteLog(Newtonsoft.Json.JsonConvert.SerializeObject(storeMachineApply) + "#cut#" + Newtonsoft.Json.JsonConvert.SerializeObject(order) + "#cut#" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "机具申请订单取消日志"); db.StoreMachineApply.Remove(storeMachineApply); db.Orders.Remove(order); db.SaveChanges(); } return "success"; // if (storeMachineApply != null) // { // Orders order = db.Orders.FirstOrDefault(m => m.Id == storeMachineApply.OrderId); // if (order != null) // { // string SwapSnExpand = storeMachineApply.SwapSnExpand; // if (!string.IsNullOrEmpty(SwapSnExpand)) // { // string[] list = SwapSnExpand.TrimEnd('\n').Split('\n'); // if (storeMachineApply.Sort > 0) // { // int Kind = storeMachineApply.Sort - 1; // string ChangeRecordNo = "SC" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + function.get_Random(8); // int CouponCount = 0; // foreach (string sub in list) // { // PosCoupons coupon = db.PosCoupons.FirstOrDefault(m => m.ExchangeCode == sub && m.UserId == order.UserId && m.IsUse == 1); // if (coupon != null) // { // coupon.IsUse = 0; // coupon.IsLock = 0; // coupon.UseDate = DateTime.Parse("1900-01-01"); // PosCouponRecord query = db.PosCouponRecord.Add(new PosCouponRecord() // { // QueryCount = Kind, // CreateDate = DateTime.Now, // ChangeKind = 1, // OrderNo = ChangeRecordNo, // ToUserId = order.UserId, // FromUserId = order.UserId, // PosCouponId = coupon.Id, // }).Entity; // CouponCount += 1; // } // } // if (CouponCount > 0) // { // PosCouponForUser forUser = db.PosCouponForUser.FirstOrDefault(m => m.Id == order.UserId); // if (forUser == null) // { // forUser = db.PosCouponForUser.Add(new PosCouponForUser() // { // Id = order.UserId, // }).Entity; // db.SaveChanges(); // } // int BeforeOut = forUser.OutNum; // int BeforeTotal = forUser.TotalNum; // int BeforeStock = forUser.StockNum; // forUser.StockNum += CouponCount; // int AfterOut = forUser.OutNum; // int AfterTotal = forUser.TotalNum; // int AfterStock = forUser.StockNum; // PosCouponOrders stat = db.PosCouponOrders.Add(new PosCouponOrders() // { // QueryCount = Kind, // CreateDate = DateTime.Now, // ChangeKind = 1, // ChangeCount = CouponCount, // AfterOut = AfterOut, // AfterTotal = AfterTotal, // AfterStock = AfterStock, // BeforeOut = BeforeOut, // BeforeTotal = BeforeTotal, // BeforeStock = BeforeStock, // OrderNo = ChangeRecordNo, // ToUserId = order.UserId, // FromUserId = order.UserId, // }).Entity; // } // function.WriteLog(Newtonsoft.Json.JsonConvert.SerializeObject(storeMachineApply) + "#cut#" + Newtonsoft.Json.JsonConvert.SerializeObject(order) + "#cut#" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "机具申请订单取消日志"); // db.StoreMachineApply.Remove(storeMachineApply); // db.Orders.Remove(order); // db.SaveChanges(); // } // else // { // foreach (string sub in list) // { // string SourcePosSn = sub.Split(':')[0]; // MachineForSnNo forSnNo = db.MachineForSnNo.FirstOrDefault(m => m.SnNo == SourcePosSn) ?? new MachineForSnNo(); // PosMachinesTwo pos = db.PosMachinesTwo.FirstOrDefault(m => m.Id == forSnNo.SnId); // if (pos != null) // { // function.WriteLog(Newtonsoft.Json.JsonConvert.SerializeObject(storeMachineApply) + "#cut#" + Newtonsoft.Json.JsonConvert.SerializeObject(order) + "#cut#" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "机具申请订单取消日志"); // pos.IsPurchase = 0; // RedisDbconn.Instance.Clear("PosMachinesTwo:" + pos.Id); // } // } // db.StoreMachineApply.Remove(storeMachineApply); // db.Orders.Remove(order); // db.SaveChanges(); // } // } // } // } // return "success"; } #endregion #region 开启 /// /// 开启 /// /// public string Open(string Id) { string[] idlist = Id.Split(new char[] { ',' }); AddSysLog(Id, "StoreMachineApply", "open"); foreach (string subid in idlist) { int id = int.Parse(subid); Dictionary Fields = new Dictionary(); Fields.Add("Status", 1); new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("StoreMachineApply", Fields, id); } db.SaveChanges(); return "success"; } #endregion #region 关闭 /// /// 关闭 /// /// public string Close(string Id) { string[] idlist = Id.Split(new char[] { ',' }); AddSysLog(Id, "StoreMachineApply", "close"); foreach (string subid in idlist) { int id = int.Parse(subid); Dictionary Fields = new Dictionary(); Fields.Add("Status", 0); new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("StoreMachineApply", Fields, id); } db.SaveChanges(); return "success"; } #endregion #region 排序 /// /// 排序 /// /// public string Sort(int Id, int Sort) { new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Sort("StoreMachineApply", Sort, Id); AddSysLog(Id.ToString(), "StoreMachineApply", "sort"); return "success"; } #endregion #region 导入数据 public IActionResult Import(string right, string ExcelKind) { ViewBag.RightInfo = RightInfo; ViewBag.right = right; ViewBag.ExcelKind = ExcelKind; return View(); } /// /// 导入数据 /// /// [HttpPost] public string ImportPost(string ExcelPath, int Kind = 0) { // RedisDbconn.Instance.AddList("ExcelImport", ExcelPath + "#cut#" + Kind); string key = function.MD5_16(Guid.NewGuid().ToString()); RedisDbconn.Instance.AddList("ExcelImportV2", ExcelPath + "#cut#" + Kind + "#cut#" + key); return "success|" + key; } #endregion #region 导出Excel /// /// 导出Excel /// /// public JsonResult ExportExcel(StoreMachineApply data, string MakerCode, string RealName, string StoreNo, string StoreName, string StoreMakerCode, string StatusSelect, string SendStatusSelect, string StoreTypeSelect) { Dictionary Fields = new Dictionary(); Fields.Add("ApplyNo", "1"); //申请单号 Fields.Add("BrandId", "1"); //品牌 Fields.Add("ApplyTime", "3"); //申请时间 Fields.Add("ExpressNo", "1"); //快递单号 string condition = " and Status>-1"; //创客编号 if (!string.IsNullOrEmpty(MakerCode)) { condition += " and UserId in (select UserId from UserForMakerCode where MakerCode='" + MakerCode + "')"; } //创客名称 if (!string.IsNullOrEmpty(RealName)) { condition += " and UserId in (select UserId from UserForRealName where RealName='" + RealName + "')"; } //仓库编号 if (!string.IsNullOrEmpty(StoreNo)) { condition += " and StoreId in (select StoreId from StoreForCode where Code='" + StoreNo + "')"; } //仓库名称 if (!string.IsNullOrEmpty(RealName)) { condition += " and StoreId in (select StoreId from StoreForName where Name='" + RealName + "')"; } //仓库归属创客编号 if (!string.IsNullOrEmpty(StoreMakerCode)) { condition += " and UserId in (select UserId from UserForMakerCode where MakerCode='" + StoreMakerCode + "')"; } //订单状态 if (!string.IsNullOrEmpty(StatusSelect)) { condition += " and Status=" + StatusSelect; } //发货状态 if (!string.IsNullOrEmpty(SendStatusSelect)) { condition += " and SendStatus=" + SendStatusSelect; } //仓库类型 if (!string.IsNullOrEmpty(StoreTypeSelect)) { condition += " and StoreType=" + StoreTypeSelect; } Dictionary obj = new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).IndexData("MachineApply", Fields, "Id desc", "0", 1, 20000, condition, "ApplyNo,UserId,TopUserId,BrandId,Areas,Address,RealName,Mobile,ApplyDeviceName,ApplyDeviceNum,ApplyTime,SendStatus,ExpressNo,ExpressName,DeliveryType,StoreId,StoreName,StoreManager,StoreManagerMobile,Remark,StoreUserId,SendDate,StoreType,Status", false); List> diclist = obj["data"] as List>; foreach (Dictionary dic in diclist) { dic["BrandId"] = RelationClass.GetKqProductBrandInfo(int.Parse(dic["BrandId"].ToString())); //申请仓库信息 int StoreId = int.Parse(dic["StoreId"].ToString()); StoreHouse store = db.StoreHouse.FirstOrDefault(m => m.Id == StoreId) ?? new StoreHouse(); dic["StoreInfo"] = store.StoreNo + "
" + store.StoreName; //仓库联系人信息 //dic["StoreContact"] = dic["StoreManagerMobile"].ToString() + "
" + dic["StoreManager"].ToString(); //仓库归属信息 // int StoreUserId = int.Parse(dic["StoreUserId"].ToString()); // Users storeUser = db.Users.FirstOrDefault(m => m.Id == StoreUserId) ?? new Users(); // int StoreType = int.Parse(dic["StoreType"].ToString()); // string StoreTypeName = ""; // if(StoreType == 0) StoreTypeName = "总仓"; // if(StoreType == 1) StoreTypeName = "分仓"; // dic["StoreUser"] = storeUser.MakerCode + "
" + StoreTypeName; //创客信息 int UserId = int.Parse(dic["UserId"].ToString()); Users puser = db.Users.FirstOrDefault(m => m.Id == UserId) ?? new Users(); dic["UserInfo"] = puser.MakerCode + "
" + puser.RealName; //顶级创客 // int TopUserId = int.Parse(dic["TopUserId"].ToString()); // Users tuser = db.Users.FirstOrDefault(m => m.Id == TopUserId) ?? new Users(); // dic["TopUserInfo"] = tuser.MakerCode + "
" + tuser.RealName; //申请状态 int Status = int.Parse(dic["Status"].ToString()); if (Status == 0) dic["Status"] = "待审核"; if (Status == 1) dic["Status"] = "申请成功"; if (Status == 2) dic["Status"] = "申请失败"; dic.Remove("BrandId"); dic.Remove("StoreInfo"); dic.Remove("UserInfo"); dic.Remove("Status"); } Dictionary result = new Dictionary(); result.Add("Status", "1"); result.Add("Info", "Excel报表-" + DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss") + ".xlsx"); result.Add("Obj", diclist); Dictionary ReturnFields = new Dictionary(); ReturnFields.Add("ApplyNo", "申请单号"); ReturnFields.Add("BrandId", "产品类型"); ReturnFields.Add("StoreId", "申请仓库"); ReturnFields.Add("StoreMakerCode", "仓库归属创客编号"); ReturnFields.Add("StoreRealName", "仓库归属创客名称"); ReturnFields.Add("MakerCode", "创客编号"); ReturnFields.Add("MakerName", "创客名称"); ReturnFields.Add("Status", "申请状态"); ReturnFields.Add("ApplyTime", "申请时间"); ReturnFields.Add("ApplyNum", "申请箱数"); ReturnFields.Add("SendNum", "发货箱数"); ReturnFields.Add("SwapSnExpand", "已发货SN号"); ReturnFields.Add("SeoDescription", "申请描述"); result.Add("Fields", ReturnFields); AddSysLog("0", "StoreMachineApply", "ExportExcel"); return Json(result); } #endregion #region 审核发货 public IActionResult AuditSend(string right, int Id = 0) { ViewBag.RightInfo = RightInfo; ViewBag.right = right; StoreMachineApply editData = db.StoreMachineApply.FirstOrDefault(m => m.Id == Id) ?? new StoreMachineApply(); ViewBag.data = editData; Users users = db.Users.FirstOrDefault(m => m.Id == editData.UserId) ?? new Users(); StoreHouse storeHouse = db.StoreHouse.FirstOrDefault(m => m.Id == editData.StoreId) ?? new StoreHouse(); ViewBag.MakerCode=users.MakerCode; ViewBag.RealName=users.RealName; return View(); } #endregion #region 审核发货 [HttpPost] public string AuditSend(StoreMachineApply data) { Dictionary Fields = new Dictionary(); // Fields.Add("ApplyNo", data.ApplyNo); //申请单号 // Fields.Add("BrandId", data.BrandId); //产品Id Fields.Add("ApplyNum", data.ApplyNum); //申请箱数 Fields.Add("SendNum", data.SendNum); //发货箱数 // Fields.Add("UserId", data.UserId); //创客ID // Fields.Add("Status", data.Status); //申请状态 Fields.Add("SwapSnExpand", data.SwapSnExpand);//已发货机具SN Fields.Add("SeoDescription", data.SeoDescription); //申请描述 Fields.Add("Status", data.Status); new AdminContentOther(_accessor.HttpContext, PublicFunction.MainTables).Edit("StoreMachineApply", Fields, data.Id); AddSysLog(data.Id.ToString(), "StoreMachineApply", "AuditSend"); db.SaveChanges(); if (data.Status == 1) { return "success"; } else { return "false"; } } #endregion } }