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