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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
using HH.MData;
using HH.WMS.Common;
using HH.WMS.Entitys.Basic;
using HH.WMS.Entitys.Common;
using MongoDB.Bson;
using MongoDB.Driver;
using MongoDB.Driver.Builders;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
 
namespace HH.WMS.DAL.Basic
{
    public class TN_AB_SUPPLIERDAL : DapperBaseDAL
    {
        #region 获取供应商信息
        /// <summary>
        /// 分页获取供应商信息
        /// </summary>
        /// <param name="pageIndex">页码</param>
        /// <param name="pageSize">页显示条数</param>
        /// <param name="total">返回总行数</param>
        /// <returns></returns>
        /// <History>[HANHE(XDL)] CREATED BY 2018-11-20</History>
        public List<TN_AB_SUPPLIEREntity> GetVendorList(SearchModel searchModel, out int total)
        {
            
            List<IMongoQuery> queryList = new List<IMongoQuery>();
            if (searchModel.SearchCondition != null)
            {
                string vendorName = Util.ToString(searchModel.SearchCondition.VendorName);
                if (!string.IsNullOrEmpty(vendorName))
                    queryList.Add(Query.Matches("CN_S_VENDOR_NAME", "/" + vendorName + "/"));
            }
            IMongoQuery query = null;
            if (queryList.Any())
                query = Query.And(queryList);
            total = Convert.ToInt32(MongoDBSingleton.Instance.FindCount<TN_AB_SUPPLIEREntity>(query, "TN_AB_SUPPLIER"));
            return MongoDBSingleton.Instance.Find<TN_AB_SUPPLIEREntity>(query, searchModel.PageIndex, searchModel.PageSize, null, "TN_AB_SUPPLIER");
            //if (!string.IsNullOrEmpty(vendorName))
            //{
            //    queryItem.Add(Query.Matches("CN_S_VENDOR_NAME", BsonRegularExpression.Create(new Regex(vendorName))));
            //    total = Convert.ToInt32(MongoDBSingleton.Instance.FindCount<TN_AB_SUPPLIEREntity>(Query.And(queryItem), "TN_AB_SUPPLIER"));
            //    return MongoDBSingleton.Instance.Find<TN_AB_SUPPLIEREntity>(Query.And(queryItem), pageIndex, pageSize, null, "TN_AB_SUPPLIER");
            //}
            //else
            //{
            //    total = Convert.ToInt32(MongoDBSingleton.Instance.FindCount<TN_AB_SUPPLIEREntity>(null, "TN_AB_SUPPLIER"));
            //    return MongoDBSingleton.Instance.Find<TN_AB_SUPPLIEREntity>(null, pageIndex, pageSize, null, "TN_AB_SUPPLIER");
            //}
        }
        #endregion
    }
}