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