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