using HH.WMS.BLL.InStock;
|
using HH.WMS.Common;
|
using HH.WMS.Common.External;
|
using HH.WMS.DAL;
|
using HH.WMS.DAL.ERP;
|
using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.Entitys.ERP;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace HH.WMS.BLL.ERP
|
{
|
/// <summary>
|
/// 小磅单
|
/// </summary>
|
public class TN_ER_ITEM_POUNDBLL : DapperBaseBLL
|
{
|
#region GET
|
|
public TN_ER_ITEM_POUNDEntity Get(string taskNo, int sync = 0)
|
{
|
var data = BLLCreator.Create<DapperBLL<TN_ER_ITEM_POUNDEntity>>().GetSingleEntity(new { CN_S_TASK_NO = taskNo, CN_N_SYNC = sync });
|
return data;
|
}
|
|
public List<TN_ER_ITEM_POUNDEntity> GetList(int sync)
|
{
|
return CreateDAL<DapperDAL<TN_ER_ITEM_POUNDEntity>>().GetList(new { CN_N_SYNC = sync });
|
}
|
|
public TN_ER_ITEM_POUNDEntity GetByTrayCode(string trayCode, string poundNo)
|
{
|
var data = BLLCreator.Create<DapperBLL<TN_ER_ITEM_POUNDEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = trayCode, CN_S_POUND_NO = poundNo });
|
return data;
|
}
|
|
#endregion
|
|
#region UPDATE
|
|
public OperateResult UpdateSyncState(string poundNo, int syncState, IDbTransaction trans)
|
{
|
var result = BLLCreator.Create<DapperBLL<TN_ER_ITEM_POUNDEntity>>().Update(new { CN_N_SYNC = syncState }, new { CN_S_POUND_NO = poundNo });
|
return result;
|
}
|
|
public OperateResult Update(string taskNo, int sync, LogPara logPara = null)
|
{
|
var result = DALCreator.Create<DapperDAL<TN_ER_ITEM_POUNDEntity>>().Update(new { CN_N_SYNC = sync }, new { CN_S_TASK_NO = taskNo });
|
if (logPara != null) Log.Detail(logPara, "更新WMS中的小磅单" + result.Describe());
|
return result;
|
}
|
|
public OperateResult UpdateWeightAndQty(string poundNo, string trayCode, decimal trayWeight, decimal qty, IDbTransaction trans, LogPara logPara = null)
|
{
|
if (logPara == null) logPara = LogType.LogPara("更新小磅单重量和数量");
|
return DALCreator.Create<DapperDAL<TN_ER_ITEM_POUNDEntity>>().Update(new { CN_F_WEIGHT = trayWeight, CN_F_QTY = qty }, new { CN_S_POUND_NO = poundNo, CN_S_TRAY_CODE = trayCode });
|
}
|
|
#endregion
|
|
#region ADD
|
|
/// <summary>
|
/// 添加小磅单
|
/// </summary>
|
/// <param name="trayCode"></param>
|
/// <param name="trayWeight"></param>
|
/// <param name="logPara"></param>
|
/// <returns></returns>
|
public OperateResult Add(string trayCode, decimal trayWeight, string taskNo, IDbTransaction trans, LogPara logPara = null)
|
{
|
if (logPara == null) logPara = LogType.LogPara("添加小磅单");
|
var trayItems = BLLCreator.Create<TN_WM_B_TRAY_ITEM_RELBLL>().GetByTrayCode(trayCode);
|
if (trayItems.Count() == 0) return OperateResult.Error("未找到当前托盘" + trayCode + "的物料！");
|
|
var trayInfo = BLLCreator.Create<DapperBLL<TN_WM_B_TRAY_INFOEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = trayCode });
|
var itemPounds = new List<TN_ER_ITEM_POUNDEntity>();
|
|
//小磅单号
|
var postData = "{\"appCode\":\"" + Constants.appCode + "\",\"ruleName\":\"" + Constants.Rule_ItemPound + "\",\"orgId\":\"0\",\"orgFlag\":\"\"}";
|
var itemPoundNo = WebApiManager.HttpAutoBom_Post("api/BillRule/GenBillNo", postData);
|
|
//流水号
|
postData = "{\"appCode\":\"" + Constants.appCode + "\",\"ruleName\":\"" + Constants.Rule_SerialNum + "\",\"orgId\":\"0\",\"orgFlag\":\"\"}";
|
var serialNum = WebApiManager.HttpAutoBom_Post("api/BillRule/GenBillNo", postData);
|
if (serialNum.Length > 3)
|
{
|
serialNum = serialNum.Substring(3, serialNum.Length - 3);
|
}
|
var lotNo = DateTime.Now.ToString("yyyyMMdd") + "02" + serialNum;
|
|
foreach (var trayItem in trayItems)
|
{
|
itemPounds.Add(new TN_ER_ITEM_POUNDEntity
|
{
|
CN_GUID = Guid.NewGuid().ToString(),
|
CN_S_POUND_NO = trayItem.CN_S_FIGURE_NO,
|
CN_S_OP_NO = itemPoundNo,
|
CN_S_ITEM_CODE = trayItem.CN_S_ITEM_CODE,
|
CN_S_ITEM_NAME = trayItem.CN_S_ITEM_NAME,
|
CN_S_ITEM_SPEC = trayItem.CN_S_MODEL,
|
CN_S_STOCK_CODE = trayItem.CN_S_STOCK_CODE,
|
CN_F_WEIGHT = trayWeight,
|
CN_F_QTY = trayItem.CN_F_QUANTITY,
|
CN_DT_WEIGHT = DateTime.Now,
|
CN_S_LOT_NO = lotNo,
|
CN_DT_OPERATION = DateTime.Now,
|
CN_F_TRAY_WEIGHT = trayInfo.CN_F_GROSSWEIGHT,
|
CN_T_CREATE = DateTime.Now,
|
CN_N_SYNC = -1,
|
CN_S_TASK_NO = taskNo,
|
CN_DT_CREATE = DateTime.Now,
|
CN_S_TRAY_CODE = trayCode
|
});
|
}
|
return DALCreator.Create<DapperDAL<TN_ER_ITEM_POUNDEntity>>().AddRange(itemPounds, trans);
|
}
|
|
#endregion
|
|
#region DELETE
|
|
public OperateResult Delete(string taskNo, LogPara logPara = null)
|
{
|
var result = DALCreator.Create<DapperDAL<TN_ER_ITEM_POUNDEntity>>().Delete(new { CN_N_SYNC = -1, CN_S_TASK_NO = taskNo });
|
if (logPara != null) Log.Detail(logPara, "任务取消，删除WMS中的小磅单" + result.Describe());
|
return result;
|
}
|
|
#endregion
|
}
|
}
|
