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
    
    }
}