jt
2021-06-10 5d0d028456874576560552f5a5c4e8b801786f11
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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 发运通知列表
        /// <summary>
        /// 发运通知列表
        /// </summary>
        /// <param name="searchModel"></param>
        /// <returns></returns>
        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
    }
}