|
/********************************************************************************
|
|
** auth： DBS
|
|
** date： 2018/12/5 14:38:14
|
|
** desc： 尚未编写描述
|
|
** Ver.: V1.0.0
|
|
*********************************************************************************/
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using HH.Redis.ReisModel;
|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.Common;
|
using HH.WMS.DAL;
|
using HH.WMS.DAL.Basic;
|
using System.Data;
|
using HH.WMS.Entitys;
|
|
namespace HH.WMS.BLL.Basic
|
{
|
public class TN_WM_B_TRAY_INFOBLL:DapperBaseBLL
|
{
|
public TN_WM_B_TRAY_INFOEntity GetModel(string trayCode)
|
{
|
return DALCreator.Create<TN_WM_B_TRAY_INFODAL>().GetModel(trayCode);
|
}
|
#region GET
|
|
public TN_WM_B_TRAY_INFOEntity GetByTrayCode(string trayCode)
|
{
|
return DALCreator.Create<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = trayCode });
|
}
|
|
public OperateResult GetForPrint(string trayCode, string trayType, string spec, int pageIndex, int pageSize)
|
{
|
return DALCreator.Create<TN_WM_B_TRAY_INFODAL>().GetForPrint(trayCode, trayType, spec, pageIndex, pageSize);
|
}
|
|
#endregion
|
|
#region 批量新增
|
/// <summary>
|
/// 批量新增
|
/// </summary>
|
/// <param name="list">新增实体</param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] created by 2018/12/06</History>
|
public OperateResult AddRange(List<TN_WM_B_TRAY_INFOEntity> list)
|
{
|
return CreateDAL<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().AddRange(list);
|
}
|
#endregion
|
|
#region 根据托盘号批量删除
|
/// <summary>
|
/// 根据托盘号批量删除
|
/// </summary>
|
/// <param name="trays">多个托盘号用逗号隔开</param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] created by 2018/12/06</History>
|
public OperateResult Delete(string trays)
|
{
|
string[] arrTray = trays.Split(',');
|
int okCount = 0;
|
for (int i = 0; i < arrTray.Length; i++)
|
{
|
bool isUsed = CreateDAL<TN_WM_B_TRAY_INFODAL>().GetUseState(arrTray[i]);
|
if (!isUsed)
|
{
|
OperateResult or = CreateDAL<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().Delete(new { CN_S_TRAY_CODE = arrTray[i] });
|
okCount += or.AffectedRows;
|
}
|
}
|
if (okCount == arrTray.Length)
|
return OperateResult.Succeed("");
|
else if(okCount == 0)
|
return OperateResult.Error("删除异常！");
|
else
|
return OperateResult.Succeed("删除部分托盘！");
|
}
|
#endregion
|
|
/// <summary>
|
/// 创建虚拟托盘
|
/// </summary>
|
/// <param name="user"></param>
|
/// <returns></returns>
|
internal OperateResult CreateVirtualTray(RedisUserEntity user)
|
{
|
OperateResult or = GetCode(user, Constants.VirtualTray);
|
if (or.Status != ResultStatus.Success)
|
return or;
|
|
string trayCode = or.Data.ToString();
|
or = CreateDAL<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().Add(new TN_WM_B_TRAY_INFOEntity
|
{
|
CN_S_TRAY_CODE = trayCode,
|
CN_S_TRAY_CODE_EXT = "",
|
CN_S_TRAY_TYPE = "虚拟托盘",
|
CN_S_TRAY_DIMENSION = "",
|
CN_S_TRAY_COLOR = "",
|
CN_S_STATE = "",
|
CN_S_SPEC = "",
|
CN_S_SORTING_CODE = "",
|
CN_S_COLLECT_CODE = "",
|
CN_S_COLLECT_LOCATION = "",
|
CN_N_LATTICE_NUM = 1,
|
CN_S_USE_STATE = "",
|
CN_N_ROW_NUM = 1,
|
CN_N_COLUMN_NUM = 1,
|
CN_F_LOADBEARING = 0,
|
CN_F_GROSSWEIGHT = 0,
|
CN_F_WEIGHT = 0,
|
CN_S_CREATOR = user.CN_S_LOGIN,
|
CN_S_CREATOR_BY = user.CN_S_NAME,
|
CN_T_CREATE = DateTime.Now,
|
CN_S_MODIFY = user.CN_S_LOGIN,
|
CN_S_MODIFY_BY = user.CN_S_NAME,
|
CN_T_MODIFY = DateTime.Now
|
});
|
if (or.Status == ResultStatus.Success)
|
or.Data = trayCode;
|
return or;
|
}
|
}
|
}
|
