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 } }