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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
using HH.MData;
using HH.WMS.Common;
using HH.WMS.Entitys.Basic;
using HH.WMS.Entitys.Common;
using MongoDB.Driver;
using MongoDB.Driver.Builders;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
 
namespace HH.WMS.DAL.Basic
{
    public class TN_AB_CUSTOMERDAL : BaseDAL
    {
        #region 客户分页查询
        /// <summary>
        /// 客户分页查询
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="total"></param>
        /// <returns></returns>
        public List<TN_AB_CUSTOMEREntity> GetCustomList(SearchModel searchModel, out int total)
        {
 
            List<IMongoQuery> queryList = new List<IMongoQuery>();
            if (searchModel.SearchCondition != null)
            {
                string customerName = Util.ToString(searchModel.SearchCondition.CustomerName);
                if (!string.IsNullOrEmpty(customerName))
                    queryList.Add(Query.Matches("CN_S_CUSTOMER_NAME", "/" + customerName + "/"));
            }
            IMongoQuery query = null;
            if (queryList.Any())
                query = Query.And(queryList);
            total = Convert.ToInt32(MongoDBSingleton.Instance.FindCount<TN_AB_CUSTOMEREntity>(query, "TN_AB_CUSTOMER"));
            return MongoDBSingleton.Instance.Find<TN_AB_CUSTOMEREntity>(query, searchModel.PageIndex, searchModel.PageSize, null, "TN_AB_CUSTOMER");
        }
        #endregion
 
        #region 获取客户
        /// <summary>
        /// 获取客户
        /// </summary>
        /// <param name="customCode"></param>
        /// <returns></returns>
        public TN_AB_CUSTOMEREntity GetSingleCustom(string customCode)
        {
            IMongoQuery query = Query.EQ("CN_S_CUSTOMER_CODE", customCode);
            return MongoDBSingleton.Instance.FindOne<TN_AB_CUSTOMEREntity>(query, "TN_AB_CUSTOMER");
        }
        #endregion
 
        #region 客户地址
        /// <summary>
        /// 客户地址
        /// </summary>
        /// <param name="customCode"></param>
        /// <returns></returns>
        public List<TN_AB_B_ADDRESS_INFOEntity> GetCustomerAddress(string customCode)
        {
            IMongoQuery query = Query.EQ("CN_S_CODE", customCode);
            return MongoDBSingleton.Instance.Find<TN_AB_B_ADDRESS_INFOEntity>(query, "TN_AB_B_ADDRESS_INFO");
        }
        #endregion
 
        #region 默认地址
        /// <summary>
        /// 默认地址
        /// </summary>
        /// <param name="customCode"></param>
        /// <returns></returns>
        public TN_AB_B_ADDRESS_INFOEntity GetDefaultAddress(string customCode)
        {
            List<IMongoQuery> querys = new List<IMongoQuery>();
            querys.Add(Query.EQ("CN_S_CODE", customCode));
            querys.Add(Query.EQ("CN_C_IS_DEFAULT", Constants.Y));
            IMongoQuery query = null;
            if (querys.Any())
                query = Query.And(querys);
            return MongoDBSingleton.Instance.FindOne<TN_AB_B_ADDRESS_INFOEntity>(query, "TN_AB_B_ADDRESS_INFO");
        }
        #endregion
    }
}