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

namespace HH.WMS.DAL.InStock
{
    public class TN_WM_ITEMBACK_MSTDAL : DapperBaseDAL
    {
        public List<TN_WM_ITEMBACK_MSTEntity> GetItemBackList(string opNo)
        {
            StringBuilder sbStr = new StringBuilder();

            sbStr.Append("SELECT * from TN_WM_ITEMBACK_MST WHERE CN_S_STATE='" + Constants.State_New + "' ");

            if (!string.IsNullOrEmpty(opNo))
            {
                sbStr.Append(" AND CN_S_OP_NO LIKE '%" + opNo + "%' ");
            }
            return ExecuteQuery<TN_WM_ITEMBACK_MSTEntity>(sbStr.ToString()).ToList();
        }
    }
}