using HH.WMS.Entitys.Basic;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.DAL.Basic
{
    public class TN_WM_OPERATION_TYPEDAL : DapperBaseDAL
    {
        public List<TN_WM_OPERATION_TYPEEntity> GetOperationTypeList(string opType, string OutSelection)
        {

            string strSql = @"SELECT * FROM TN_WM_OPERATION_TYPE WHERE 1=1  ";

            if (!string.IsNullOrEmpty(opType))
            {
                if (opType.IndexOf(",") > 0)
                {
                    opType = "'" + opType.Replace(",", "','") + "'";
                    strSql += " AND CN_S_OP_TYPE in (" + opType + ") ";
                }
                else
                {
                    strSql += " AND CN_S_OP_TYPE='" + opType + "' ";
                }
            }
            if (!string.IsNullOrEmpty(OutSelection))
            {
                string[] arr = OutSelection.Split(',');
                foreach (var item in arr)
                {
                     strSql += " AND CN_S_OPERATION_NAME!='" + item + "' ";
                }
            }

            List<TN_WM_OPERATION_TYPEEntity> list = ExecuteQuery<TN_WM_OPERATION_TYPEEntity>(strSql.ToString());
            return list;
        }
    }
}