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