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();
|
}
|
}
|
}
|
