using HH.WMS.Entitys;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.IO;
|
using System.Linq;
|
using System.Text;
|
using System.Web;
|
using System.Web.Mvc;
|
using System.Xml;
|
using NPOI.HSSF.UserModel;
|
using NPOI.SS.UserModel;
|
using NPOI.XSSF.UserModel;
|
using HH.WMS.Utils;
|
using HH.WMS.WebUI.Controllers;
|
using HH.WMS.Entitys.Algorithm;
|
using HH.WMS.Entitys.Basic;
|
using System.Text.RegularExpressions;
|
using HH.AutoBom.Core;
|
using HH.WMS.Entitys.Common;
|
|
namespace HH.WMS.WebUI.Areas.Sys.Controllers
|
{
|
public class StockInitController : BaseController
|
{
|
//
|
// GET: /Sys/StockInit/
|
|
public ActionResult Index()
|
{
|
return View();
|
}
|
|
public string UnscrambleXls(HttpPostedFileBase file)
|
{
|
try
|
{
|
string stockStr = HttpWMS_Get("api/Common/StockList");
|
List<TN_AB_STOCKEntity> lstStock = JsonConvert.DeserializeObject<List<TN_AB_STOCKEntity>>(JsonConvert.DeserializeObject<OperateResult>(stockStr).Data.ToString());
|
|
string locationStr = HttpWMS_Get("api/LocationExt/GetLocationList");
|
List<TN_WM_LOCATION_EXTEntity> lstLocation = JsonConvert.DeserializeObject<List<TN_WM_LOCATION_EXTEntity>>(locationStr);
|
|
string trayStr = HttpWMS_Get("api/Tray/GetTrayList");
|
List<TN_WM_B_TRAY_INFOEntity> lstTray = JsonConvert.DeserializeObject<List<TN_WM_B_TRAY_INFOEntity>>(trayStr);
|
|
//string lotStr = HttpWMS_Get("api/LotInfo/GetLotInfoList");
|
//List<TN_WM_LOT_INFOEntity> lstLot = JsonConvert.DeserializeObject<List<TN_WM_LOT_INFOEntity>>(lotStr);
|
|
|
List<AutoBomItemEntity> lstItem = new List<AutoBomItemEntity>();
|
|
IWorkbook wk = null;
|
var stream = file.InputStream;
|
var buffer = new byte[stream.Length];
|
stream.Read(buffer, 0, buffer.Length);
|
stream.Position = 0;
|
if (file.FileName.ToLower().IndexOf(".xlsx") > 0)
|
{
|
wk = new XSSFWorkbook(stream);
|
}
|
else if (file.FileName.ToLower().IndexOf(".xls") > 0)
|
{
|
wk = new HSSFWorkbook(stream);
|
}
|
//importOrderList = new List<ImportOrderTemplate>();
|
var loginer = HH.AutoBom.Core.FormsAuth.GetUserData<HH.AutoBom.Core.LoginerBase>();
|
List<ImportTemplateEntity> iteList = new List<ImportTemplateEntity>();
|
List<ErrorRowData> errorDataList = new List<ErrorRowData>();
|
|
ISheet sheet = wk.GetSheetAt(0); //读取当前表数据
|
|
for (int j = 1; j <= sheet.LastRowNum; j++) //LastRowNum 是当前表的总行数
|
{
|
var excelRowIndex = (j + 1).ToString();
|
|
IRow row = sheet.GetRow(j); //读取当前行数据
|
if (string.IsNullOrEmpty(Util.ToString(row.Cells[3]))) continue;
|
if (row != null)
|
{
|
try
|
{
|
ImportTemplateEntity ite = new ImportTemplateEntity();
|
ite.CN_S_STOCK_CODE = Util.ToString(Util.ToString(row.Cells[0]));//仓库编码
|
ite.CN_S_LOCATION_CODE = Util.ToString(row.Cells[1]);//货位编码
|
ite.CN_S_TRAY_CODE = Util.ToString(row.Cells[2]);//托盘编码
|
ite.CN_S_ITEM_CODE = Util.ToString(row.Cells[3]);//物料编码
|
ite.CN_F_QUANTITY = Convert.ToDecimal(row.Cells[4].ToString());//数量
|
ite.CN_S_PRODUCTION_BATCH = Util.ToString(row.Cells[5]);//生产批次
|
//ite.CN_S_LOT_CODE = Util.ToString(row.Cells[6]);//到货批次
|
ite.CN_S_ITEM_STATE = Util.ToString(row.Cells[6]);//物料状态
|
if (string.IsNullOrEmpty(ite.CN_S_ITEM_STATE))
|
{
|
ite.CN_S_ITEM_STATE = HH.WMS.Common.Constants.ItemState_Qualified;//没传物料状态的情况下，默认合格
|
}
|
|
|
|
if (!string.IsNullOrEmpty(ite.CN_S_STOCK_CODE))
|
{
|
var checkStock = lstStock.Where(t => t.CN_S_STOCK_CODE == ite.CN_S_STOCK_CODE).ToList();
|
if (!checkStock.Any())
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "仓库号 " + ite.CN_S_STOCK_CODE + " 不存在！" });
|
}
|
var checkStockIn = iteList.Where(t => t.CN_S_STOCK_CODE == ite.CN_S_STOCK_CODE).ToList();
|
if (iteList.Count > 0 && (!checkStockIn.Any()))
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "仓库号 " + ite.CN_S_STOCK_CODE + " 错误,一个Excel只能初始化一个仓库！" });
|
}
|
}
|
else
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "仓库号不可为空！" });
|
}
|
|
if (!string.IsNullOrEmpty(ite.CN_S_LOCATION_CODE))
|
{
|
var checkLocation = lstLocation.Where(t => t.CN_S_LOCATION_CODE.Trim() == ite.CN_S_LOCATION_CODE).ToList();
|
if (!checkLocation.Any())
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "货位号 " + ite.CN_S_LOCATION_CODE + " 不存在！" });
|
}
|
else
|
{
|
ite.CN_S_AREA_CODE = checkLocation[0].CN_S_AREA_CODE;
|
}
|
}
|
else
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "货位号不可为空！" });
|
}
|
|
if (!string.IsNullOrEmpty(ite.CN_S_TRAY_CODE))
|
{
|
var checkTray = lstTray.Where(t => t.CN_S_TRAY_CODE == ite.CN_S_TRAY_CODE).ToList();
|
if (!checkTray.Any())
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "托盘号 " + ite.CN_S_TRAY_CODE + " 不存在！" });
|
}
|
}
|
|
if (!string.IsNullOrEmpty(ite.CN_S_ITEM_CODE))
|
{
|
var checkTray = lstItem.Where(t => t.CN_S_ITEM_CODE == ite.CN_S_ITEM_CODE).ToList();
|
if (!checkTray.Any())
|
{
|
string jsonItem = HttpWMS_Get("api/Item/GetItemModel?itemCode=" + ite.CN_S_ITEM_CODE);
|
OperateResult oresult = JsonConvert.DeserializeObject<OperateResult>(jsonItem);
|
if (oresult.Success)
|
{
|
AutoBomItemEntity itemEntity = JsonConvert.DeserializeObject<AutoBomItemEntity>(oresult.Data.ToString());
|
|
List<AutoBomItemEntity> lstItemEntity = new List<AutoBomItemEntity>();
|
lstItemEntity.Add(itemEntity);
|
|
if (!lstItemEntity.Any())
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "物料编码 " + ite.CN_S_ITEM_CODE + " 不存在！" });
|
}
|
else
|
{
|
ite.CN_S_ITEM_NAME = lstItemEntity[0].CN_S_ITEM_NAME;
|
ite.CN_S_MEASURE_UNIT = lstItemEntity[0].CN_S_MEASURE_UNIT;
|
ite.CN_S_FIGURE_NO = lstItemEntity[0].CN_S_FIGURE_NO;
|
ite.CN_S_MODEL = lstItemEntity[0].CN_S_MODEL;
|
lstItem.AddRange(lstItemEntity);
|
}
|
}
|
else
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "物料编码 " + ite.CN_S_ITEM_CODE + " 不存在！" });
|
}
|
}
|
else
|
{
|
ite.CN_S_ITEM_NAME = checkTray[0].CN_S_ITEM_NAME;
|
ite.CN_S_MEASURE_UNIT = checkTray[0].CN_S_MEASURE_UNIT;
|
ite.CN_S_FIGURE_NO = checkTray[0].CN_S_FIGURE_NO;
|
ite.CN_S_MODEL = checkTray[0].CN_S_MODEL;
|
}
|
}
|
else
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "物料编码不可为空！" });
|
}
|
|
|
if (!(string.IsNullOrEmpty(ite.CN_F_QUANTITY.ToString()) || ite.CN_F_QUANTITY.ToString() == "0"))
|
{
|
var qtyCheck = Regex.IsMatch(ite.CN_F_QUANTITY.ToString(), @"^[0-9]+\.{0,1}[0-9]{0,2}$");
|
if (!qtyCheck)
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "数量格式不正确！" });
|
}
|
}
|
else
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "数量不可为空或0！" });
|
}
|
|
//if (!string.IsNullOrEmpty(ite.CN_S_LOT_CODE))
|
//{
|
// var checkLot = iteList.Where(t => t.CN_S_LOT_CODE == ite.CN_S_LOT_CODE).ToList();
|
// if (checkLot.Count > 1)
|
// {
|
// errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "到货批次 " + ite.CN_S_LOT_CODE + " 在Excel中有重复！" });
|
// }
|
|
// var checkLotSys = lstLot.Where(t => t.CN_S_LOT_CODE == ite.CN_S_LOT_CODE).ToList();
|
// if (checkLotSys.Any())
|
// {
|
// errorDataList.Add(new ErrorRowData { CN_S_RowIndex = excelRowIndex, CN_S_ErrorContent = "到货批次 " + ite.CN_S_LOT_CODE + " 在系统中已存在！" });
|
// }
|
//}
|
|
|
iteList.Add(ite);
|
|
}
|
catch (Exception ex)
|
{
|
return JsonConvert.SerializeObject(OperateResult.Error("内部抛出异常！" + ex.ToString()));
|
}
|
}
|
}
|
var Group_List = iteList.GroupBy(x => new
|
{
|
x.CN_S_LOCATION_CODE,
|
x.CN_S_TRAY_CODE,
|
x.CN_S_ITEM_CODE
|
}).Select(g => new ImportTemplateEntity
|
{
|
CN_S_LOCATION_CODE = g.FirstOrDefault().CN_S_LOCATION_CODE.Trim(),
|
CN_S_TRAY_CODE = g.FirstOrDefault().CN_S_TRAY_CODE.Trim(),
|
CN_S_ITEM_CODE = g.FirstOrDefault().CN_S_ITEM_CODE.Trim(),
|
CN_F_QUANTITY = g.Count()
|
}).ToList();
|
|
foreach (var item in Group_List)
|
{
|
if (item.CN_F_QUANTITY > 1)
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = "0", CN_S_ErrorContent = "货位 " + item.CN_S_LOCATION_CODE + " ,托盘 " + item.CN_S_TRAY_CODE + " ,物料 " + item.CN_S_ITEM_CODE + " 存在重复！" });
|
}
|
}
|
|
var stockEntityList = lstStock.Where(x => x.CN_S_STOCK_CODE == iteList[0].CN_S_STOCK_CODE).ToList();
|
|
if (stockEntityList.Any())
|
{
|
if (stockEntityList[0].CN_C_IS_INIT !="N")
|
{
|
errorDataList.Add(new ErrorRowData { CN_S_RowIndex = "0", CN_S_ErrorContent = stockEntityList[0].CN_S_STOCK_CODE + " 号仓库必须是未初始化状态！" });
|
}
|
}
|
|
return
|
JsonConvert.SerializeObject(new
|
{
|
ImportData = iteList,
|
ErrorData = errorDataList
|
});
|
}
|
catch (Exception ex)
|
{
|
return JsonConvert.SerializeObject(OperateResult.Error("外部抛出异常！" + ex.ToString()));
|
}
|
}
|
|
#region 初始化功能
|
/// <summary>
|
/// 初始化功能
|
/// </summary>
|
/// <returns></returns>
|
public string ImportExcelData()
|
{
|
//XML文件流
|
var sr = new StreamReader(Request.InputStream);
|
var stream = sr.ReadToEnd();
|
|
var loginer = FormsAuth.GetUserData<LoginerBase>();
|
var TokenId = loginer.Extend1;//TokenId
|
|
var streamStr = new
|
{
|
PostData = stream,
|
TokenId = TokenId
|
};
|
return HttpWMS_Post("api/StockInit/SaveStockInit", JsonConvert.SerializeObject(streamStr));
|
}
|
|
#endregion
|
}
|
|
|
}
|
