蓝月亮

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
using HH.WMS.Entitys.Tzlj;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace HH.WMS.DAL.Tzlj
{
    public class MesStackTrayDAL :DapperBaseDAL
    {
        #region GET
 
        public List<MesStackTrayEntity> GetByGuids(List<string> guids)
        {
            var guidStr = "";
            guids.ForEach(e =>
            {
                guidStr += ("'" + e + "',");
            });
            if (guidStr.Length > 0)
            {
                guidStr = guidStr.Substring(0, guidStr.Length - 1);
            }
            else
            {
                return null;
            }
            var sql = " SELECT * FROM MesStackTray WHERE CN_GUID IN(" + guidStr + ") ";
            var list = ExecuteQuery<MesStackTrayEntity>(sql);
            return list;
        }
 
        #endregion
 
    }
}