using HH.WMS.DAL.SysMgr;
|
using HH.WMS.Entitys.Entitys;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using HH.WMS.Entitys;
|
using System.Data;
|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.DAL.Basic;
|
using HH.WMS.DAL;
|
|
namespace HH.WMS.BLL.SysMgr
|
{
|
public class TN_WM_B_TRAY_CAPACITYBLL : DapperBaseBLL
|
{
|
#region 返回托盘物料容量关联实体
|
/// <summary>
|
/// 根据条件获取容量实体
|
/// </summary>
|
/// <param name="itemCode"></param>
|
/// <returns></returns>
|
/// <History>[HANHE(XDL)] CREATED BY 2018-11-16</History>
|
public TN_WM_B_TRAY_CAPACITYEntity GetEntityByItemCode(string itemCode)
|
{
|
return CreateDAL<TN_WM_B_TRAY_CAPACITYDAL>().GetEntityByItemCode(itemCode);
|
}
|
|
#endregion
|
|
/// <summary>
|
/// PDA接口-根据托盘码获取存放容量
|
/// </summary>
|
/// <param name="trayCode">托盘码</param>
|
/// <returns></returns>
|
/// <History>[HANHE(XDL)] CREATED BY 2019-03-19</History>
|
public OperateResult GetCapacityinfoByTrayCode(string trayCode)
|
{
|
DataTable dt = CreateDAL<TN_WM_B_TRAY_CAPACITYDAL>().GetCapacityinfoByTrayCode(trayCode);
|
DataTable dt1 = CreateDAL<TN_WM_TRAY_LOGICDAL>().GetModel(" where CN_S_TRAY_CODE='" + trayCode + "'");
|
dt.Columns.Add(new DataColumn("CN_F_TW", typeof(decimal)));
|
dt.Columns.Add("CN_S_MODEL");
|
dt.Columns.Add("CN_C_IS_WARRANTY_PARTS");
|
dt.Columns.Add("CN_S_AREA_CODE");
|
dt.Columns.Add("CN_S_AREA_NAME");
|
dt.Columns.Add("CN_S_TRAY_AREA");
|
string trayarea = "";
|
foreach (DataRow logic in dt1.Rows)
|
{
|
trayarea += logic["CN_S_LOGIC_CODE"] + ",";
|
}
|
if (!string.IsNullOrEmpty(trayarea))
|
{
|
trayarea = trayarea.Substring(0, trayarea.Length - 1);
|
}
|
dt.Rows[0]["CN_S_TRAY_AREA"] = trayarea;
|
Dictionary<string, decimal> itemGross = new Dictionary<string, decimal>();
|
Dictionary<string, string> model = new Dictionary<string, string>();
|
Dictionary<string, string> iswarrnyParts = new Dictionary<string, string>();
|
Dictionary<string, string> areacodeGross = new Dictionary<string, string>();
|
Dictionary<string, string> areanameGross = new Dictionary<string, string>();
|
foreach (DataRow dr in dt.Rows)
|
{
|
string itemCode = dr["CN_S_ITEM_CODE"].ToString().Trim();
|
if (!string.IsNullOrEmpty(itemCode))
|
{
|
if (!itemGross.ContainsKey(itemCode))
|
{
|
AutoBomItemEntity item = CreateDAL<TN_WMS_ITEMDAL>().GetItemEntity(itemCode);
|
itemGross.Add(itemCode, item.CN_F_TW);
|
model.Add(itemCode, item.CN_S_MODEL);
|
iswarrnyParts.Add(itemCode, item.CN_C_IS_WARRNTY_PARTS);
|
dr["CN_F_TW"] = item.CN_F_TW;
|
dr["CN_S_MODEL"] = item.CN_S_MODEL;
|
dr["CN_C_IS_WARRANTY_PARTS"] = item.CN_C_IS_WARRNTY_PARTS;
|
|
|
AutoBomStockAreaEntity entityarea = CreateDAL<TN_AB_B_STOCK_AREADAL>().GetStockArea("CN_S_AREA_NAME", item.CN_S_STORE_TYPE);
|
areacodeGross.Add(itemCode, entityarea == null ? "" : entityarea.CN_S_AREA_CODE);
|
areanameGross.Add(itemCode, entityarea == null ? "" : entityarea.CN_S_AREA_NAME);
|
dr["CN_S_AREA_CODE"] = entityarea == null ? "" : entityarea.CN_S_AREA_CODE;
|
dr["CN_S_AREA_NAME"] = entityarea == null ? "" : entityarea.CN_S_AREA_NAME;
|
|
}
|
else
|
{
|
dr["CN_F_TW"] = itemGross[itemCode];
|
dr["CN_S_MODEL"] = model[itemCode];
|
dr["CN_C_IS_WARRANTY_PARTS"] = iswarrnyParts[itemCode];
|
dr["CN_S_AREA_CODE"] = areacodeGross[itemCode];
|
dr["CN_S_AREA_NAME"] = areanameGross[itemCode];
|
}
|
}
|
}
|
|
var result = dt.AsEnumerable().Select(x => new
|
{
|
CN_S_ITEM_CODE = x.Field<string>("CN_S_ITEM_CODE"),
|
CN_S_ITEM_NAME = x.Field<string>("CN_S_ITEM_NAME"),
|
CN_S_MODEL = x.Field<string>("CN_S_MODEL"),
|
CN_F_PACKING_QTY = x.Field<int>("CN_F_PACKING_QTY")
|
}).GroupBy(y => new
|
{
|
CN_S_ITEM_CODE = y.CN_S_ITEM_CODE,
|
CN_S_ITEM_NAME = y.CN_S_ITEM_NAME,
|
CN_S_MODEL = y.CN_S_MODEL
|
|
}).Select(g => new
|
{
|
CN_S_ITEM_CODE = g.Key.CN_S_ITEM_CODE,
|
CN_S_ITEM_NAME = g.Key.CN_S_ITEM_NAME,
|
CN_S_MODEL = g.Key.CN_S_MODEL,
|
CN_F_PACKING_QTY = g.Sum(r => r.CN_F_PACKING_QTY)
|
}).ToList();
|
|
return OperateResult.Succeed("", new
|
{
|
Data = dt, //已码物料
|
DataSum = result //已码物料汇总
|
});
|
|
}
|
|
|
/// <summary>
|
/// PDA接口-根据物料编码获取物料存放容器信息
|
/// </summary>
|
/// <param name="itemCode">物料编码</param>
|
/// <returns></returns>
|
public OperateResult GetTrayCapacityByitem(string itemCode)
|
{
|
TN_WM_B_TRAY_CAPACITYEntity trayCapacityEntity = new TN_WM_B_TRAY_CAPACITYEntity();
|
AutoBomItemEntity itementity = CreateDAL<TN_WMS_ITEMDAL>().GetItemEntity(itemCode);//获取物料判断物料类型
|
if (itementity == null)
|
{
|
|
}
|
else
|
{
|
trayCapacityEntity = CreateDAL<DapperDAL<TN_WM_B_TRAY_CAPACITYEntity>>().GetSingleEntity(new { CN_S_ITEM_CODE = itemCode });
|
}
|
AutoBomStockAreaEntity entityarea = CreateDAL<TN_AB_B_STOCK_AREADAL>().GetStockArea("CN_S_AREA_NAME", itementity.CN_S_STORE_TYPE);
|
|
|
trayCapacityEntity.CN_S_AREA_CODE = entityarea == null ? "" : entityarea.CN_S_AREA_CODE;
|
trayCapacityEntity.CN_S_AREA_NAME = entityarea == null ? "" : entityarea.CN_S_AREA_NAME;
|
trayCapacityEntity.CN_S_MODEL = itementity == null ? "" : itementity.CN_S_MODEL;
|
trayCapacityEntity.CN_C_IS_TRAY = entityarea == null ? "" : entityarea.CN_C_IS_TRAY;
|
trayCapacityEntity.CN_C_IS_CHECKTRAY = entityarea == null ? "" : entityarea.CN_C_IS_CHECKTRAY;
|
|
return OperateResult.Succeed("", trayCapacityEntity);
|
}
|
|
}
|
}
|
