using HH.WMS.Common;
using HH.WMS.DAL;
using HH.WMS.Entitys;
using HH.WMS.Entitys.Common;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace HH.WMS.DAL.OutStock
{
public class TN_WM_SHIPPING_NOTIFYDAL : DapperBaseDAL
{
#region 发运通知列表
///
/// 发运通知列表
///
///
///
public OperateResult NoticeList(SearchModel searchModel)
{
string sql = @"(SELECT
A.CN_S_NOTIFY_NO,
A.CN_S_OP_NO,
A.CN_S_OP_TYPE,
A.CN_S_STOCK_CODE,
A.CN_S_STATE,
A.CN_S_NOTIFIER,
A.CN_S_PHONE,
B.CN_S_NOTE CN_S_REMARKS,
B.CN_T_MODIFY
FROM TN_WM_SHIPPING_NOTIFY A,TN_WM_OUT_MST B WHERE A.CN_S_OP_NO=B.CN_S_OP_NO) t WHERE 1=1 ";
string opNo = Util.ToString(searchModel.SearchCondition.CN_S_OP_NO);
if (!string.IsNullOrEmpty(opNo))
{
sql += " t.CN_S_OP_NO='" + Util.ToStringInput(opNo) + "'";
}
return ExecutePagingResult(sql, searchModel.PageIndex, searchModel.PageSize);
}
#endregion
}
}