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
}
}