using HH.WMS.DAL;
|
using HH.WMS.DAL.Basic;
|
using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Autobom;
|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.Entitys.Common;
|
using HH.WMS.Entitys.Entitys;
|
/********************************************************************************
|
|
** auth： DBS
|
|
** date： 2018/12/3 17:03:13
|
|
** desc： 尚未编写描述
|
|
** Ver.: V1.0.0
|
|
*********************************************************************************/
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace HH.WMS.BLL.Basic
|
{
|
public class TN_WM_LOCATION_EXTBLL : DapperBaseBLL, ITN_WM_LOCATION_EXTBLL
|
{
|
#region 根据巷道获取巷道内的货位状态
|
|
/// <summary>
|
/// 根据巷道获取巷道内的货位状态
|
/// </summary>
|
/// <param name="stockCode">仓库号</param>
|
/// <param name="areaCode">库区号</param>
|
/// <param name="roadway">巷道号</param>
|
/// <returns></returns>
|
/// <History>[Hanhe(DBS)] created 2018/12/03</History>
|
public DataTable ViewState(string stockCode, string areaCode, string roadway)
|
{
|
var dt = CreateDAL<TN_WM_LOCATION_EXTDAL>().ViewState(stockCode, areaCode, roadway);
|
dt.Columns["VIEW_STATE"].ReadOnly = false;
|
foreach (DataRow row in dt.Rows)
|
{
|
if (row["VIEW_STATE"].ToString().Equals("满"))
|
{
|
var trayLocation = CreateDAL<DapperDAL<TN_WM_B_TRAY_LOCATIONEntity>>().GetSingleEntity(new { CN_S_LOCATION_CODE = row["CN_S_LOCATION_CODE"].ToString() });
|
if (trayLocation != null)
|
{
|
var trayInfo = CreateDAL<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = trayLocation.CN_S_TRAY_CODE });
|
if (trayInfo != null)
|
{
|
if (!string.IsNullOrEmpty(trayInfo.CN_S_USE_STATE) && trayInfo.CN_S_USE_STATE.Trim() != "空")
|
row["VIEW_STATE"] = trayInfo.CN_S_USE_STATE;
|
}
|
}
|
}
|
}
|
return dt;
|
}
|
|
#endregion
|
|
public List<TN_WM_LOCATION_EXTEntity> GetModel(string strWhere)
|
{
|
return CreateDAL<TN_WM_LOCATION_EXTDAL>().GetModel(strWhere);
|
}
|
public List<TN_WM_LOCATION_EXTEntity> GetModelByRow(string strRow, string strArea)
|
{
|
return CreateDAL<TN_WM_LOCATION_EXTDAL>().GetModelByRow(strRow, strArea);
|
}
|
public TN_WM_LOCATION_EXTEntity GetExtModel(string strWhere)
|
{
|
List<TN_WM_LOCATION_EXTEntity> lst = CreateDAL<TN_WM_LOCATION_EXTDAL>().GetModel(strWhere);
|
if (!lst.Any())
|
{
|
return null;
|
}
|
return lst[0];
|
}
|
|
#region 删除
|
/// <summary>
|
/// 删除
|
/// </summary>
|
/// <param name="lstGuid">要删除的ID集合</param>
|
/// <param name="trans"></param>
|
/// <returns></returns>
|
public SqlExecuteResult Delete(string Where)
|
{
|
SqlExecuteResult result = new SqlExecuteResult();
|
result = CreateDAL<TN_WM_LOCATION_EXTDAL>().Delete(Where, null);
|
return result;
|
}
|
#endregion
|
|
public SqlExecuteResult Add(TN_WM_LOCATION_EXTEntity Entity)
|
{
|
SqlExecuteResult result = new SqlExecuteResult();
|
OperateResult Opresult = CreateDAL<DapperDAL<TN_WM_LOCATION_EXTEntity>>().Add(Entity, null);
|
result.Success = Opresult.Success;
|
result.Exception = new Exception(Opresult.Msg);
|
return result;
|
}
|
|
public SqlExecuteResult UpdateSync(TN_WM_LOCATION_EXTEntity Entity)
|
{
|
SqlExecuteResult result = CreateDAL<TN_WM_LOCATION_EXTDAL>().UpdateSync(Entity, null);
|
return result;
|
}
|
|
public SqlExecuteResult UpdateBFState(string where, string tableName)
|
{
|
SqlExecuteResult result = new SqlExecuteResult();
|
result = CreateDAL<TN_WM_LOCATION_EXTDAL>().UpdateBFState(where, tableName, null);
|
return result;
|
}
|
|
#region 更新状态
|
|
public OperateResult UpdateState(string locationCode, string state, string bState)
|
{
|
var result = CreateDAL<TN_WM_LOCATION_EXTDAL>().UpdateLocationExtState(locationCode, state, bState, "", null);
|
return result;
|
}
|
|
public OperateResult UpdateState(string locationCode, string state, string bState, IDbTransaction trans)
|
{
|
var result = CreateDAL<TN_WM_LOCATION_EXTDAL>().UpdateLocationExtState(locationCode, state, bState, "", trans);
|
return result;
|
}
|
|
#endregion
|
|
#region 更新状态根据托盘码
|
|
public OperateResult UpdateStateByTrayCode(string trayCode, string locationState, string useState, IDbTransaction trans)
|
{
|
var result = CreateDAL<TN_WM_LOCATION_EXTDAL>().UpdateStateByTrayCode(trayCode, locationState, useState, trans);
|
return result;
|
}
|
|
#endregion
|
|
#region
|
|
public OperateResult UpdateLocationExtState(string locationCode, string locationState, string locationUseState, string taskNo, IDbTransaction trans)
|
{
|
var result = CreateDAL<TN_WM_LOCATION_EXTDAL>().UpdateLocationExtState(locationCode, locationState, locationUseState, taskNo, trans);
|
return result;
|
}
|
|
#endregion
|
|
#region 查询货位拓展表
|
/// <summary>
|
/// 查询货位拓展表
|
/// </summary>
|
/// <param name="searchModel">实体</param>
|
/// <returns></returns>
|
/// <History>[HANHE(lt)] CREATED BY 2018-12-18</History>
|
public OperateResult GetLocationExtList(SearchModel searchModel)
|
{
|
return CreateDAL<TN_WM_LOCATION_EXTDAL>().GetLocationExtList(searchModel);
|
}
|
#endregion
|
|
/// <summary>
|
/// 根据仓库获取存储情况
|
/// </summary>
|
/// <param name="stockCode">仓库号</param>
|
/// <returns></returns>
|
public DataTable GetAreaStorageInfo(string stockCode,string[] areas)
|
{
|
return CreateDAL<TN_WM_LOCATION_EXTDAL>().GetAreaStorageInfo(stockCode, areas);
|
}
|
|
#region 获取货位列表
|
|
public List<TN_WM_LOCATION_EXTEntity> GetLocationList()
|
{
|
return CreateDAL<TN_WM_LOCATION_EXTDAL>().GetLocationList();
|
}
|
|
#endregion
|
|
#region 获取货位状态数量
|
|
public DataTable GetStateQty(string stockCode)
|
{
|
return CreateDAL<TN_WM_LOCATION_EXTDAL>().GetStateQty(stockCode);
|
}
|
|
#endregion
|
}
|
}
|
