|
using HH.WMS.Entitys.Basic;
|
using HH.WMS.Entitys.Common;
|
using System;
|
using System.Data;
|
using System.Collections.Generic;
|
using System.Data.Common;
|
using System.Data.OracleClient;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using HH.WMS.Common;
|
|
|
namespace HH.WMS.DAL.Basic
|
{
|
public class TN_WM_B_STRATEGYDAL : DapperBaseDAL
|
{
|
|
#region 根据库区编码获取该库区对应的策略应用
|
/// <summary>
|
/// 根据库区编码获取该库区对应的策略应用
|
/// </summary>
|
/// <param name="stockAreaCode"></param>
|
/// <returns></returns>
|
public List<STRATEGYALGOREntity> GetStrateListByAreaOrStock(string stockCode,string stockAreaCode, string strateType)
|
{
|
StringBuilder sbSql = new StringBuilder();
|
sbSql.AppendLine("SELECT distinct a.CN_S_NAME,a.CN_S_CODE, b.CN_N_PRIORITY FROM tn_wm_b_strategy a INNER JOIN tn_wm_b_strategy_use b on a.CN_GUID = b.CN_STRATEGY_GUID WHERE a.CN_C_IS_USE = 'Y'");
|
|
if(!string.IsNullOrEmpty(stockCode))
|
{
|
sbSql.AppendLine(" AND b.CN_S_STOCK_CODE='" + stockCode + "' and CN_S_STOCK_AREA = '" + stockAreaCode + "' ");
|
}
|
else
|
{
|
sbSql.AppendLine(" AND b.CN_S_STOCK_AREA='" + stockAreaCode + "' ");
|
}
|
if (!string.IsNullOrEmpty(strateType))
|
{
|
sbSql.AppendLine(" AND a.CN_S_TYPE='" + strateType + "' ");
|
}
|
sbSql.AppendLine(" ORDER BY b.CN_N_PRIORITY DESC ");
|
DbCommand cmd = DataAccess.GetSqlStringCommand(sbSql.ToString());
|
List<STRATEGYALGOREntity> list = ExecuteQuery<STRATEGYALGOREntity>(sbSql.ToString());
|
return list;
|
}
|
#endregion
|
|
}
|
}
|