蓝月亮

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
using HH.WMS.Entitys.Basic;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace HH.WMS.DAL.Basic
{
    public class TN_WM_OPERATION_TYPEDAL : DapperBaseDAL
    {
        public List<TN_WM_OPERATION_TYPEEntity> GetOperationTypeList(string opType, string OutSelection)
        {
 
            string strSql = @"SELECT * FROM TN_WM_OPERATION_TYPE WHERE 1=1  ";
 
            if (!string.IsNullOrEmpty(opType))
            {
                if (opType.IndexOf(",") > 0)
                {
                    opType = "'" + opType.Replace(",", "','") + "'";
                    strSql += " AND CN_S_OP_TYPE in (" + opType + ") ";
                }
                else
                {
                    strSql += " AND CN_S_OP_TYPE='" + opType + "' ";
                }
            }
            if (!string.IsNullOrEmpty(OutSelection))
            {
                string[] arr = OutSelection.Split(',');
                foreach (var item in arr)
                {
                     strSql += " AND CN_S_OPERATION_NAME!='" + item + "' ";
                }
            }
 
            List<TN_WM_OPERATION_TYPEEntity> list = ExecuteQuery<TN_WM_OPERATION_TYPEEntity>(strSql.ToString());
            return list;
        }
    }
}