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

namespace HH.WMS.DAL.Tzlj
{
    public class MesStackTrayDAL :DapperBaseDAL
    {
        #region GET

        public List<MesStackTrayEntity> GetByGuids(List<string> guids)
        {
            var guidStr = "";
            guids.ForEach(e =>
            {
                guidStr += ("'" + e + "',");
            });
            if (guidStr.Length > 0)
            {
                guidStr = guidStr.Substring(0, guidStr.Length - 1);
            }
            else
            {
                return null;
            }
            var sql = " SELECT * FROM MesStackTray WHERE CN_GUID IN(" + guidStr + ") ";
            var list = ExecuteQuery<MesStackTrayEntity>(sql);
            return list;
        }

        #endregion

    }
}