public List <CustomerInfo> GetCacheCustomerForUserByList()
{
var startDate = DateTime.Now.AddDays(LoanConsts.AccessCustomerLimitDayRange).ToString("yyyy-MM-dd 00:00:00").AsDateTimeOfNull();
var endDate = DateTime.Now.ToString("yyyy-MM-dd 23:59:59").AsDateTimeOfNull();
CustomerSearchCondition condition = new CustomerSearchCondition()
{
CreationTimeFrom = startDate, CreationTimeTo = endDate
};
string cacheKey = "global_CustomerDBList";
var list = _cacheManager.GetCache <string, List <CustomerInfo> >(LoanConsts.Cache_CustomerAppService_Method_CacheCustomerForUserByList)
.Get(cacheKey, () => {
List <SqlParameter> paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@StartDate", startDate));
paramList.Add(new SqlParameter("@EndDate", endDate));
paramList.Add(new SqlParameter("@Area", ""));
paramList.Add(new SqlParameter("@Age_Max", ""));
paramList.Add(new SqlParameter("@Age_Min", ""));
var q = _sqlExecuter.SqlQuery <CustomerInfo>("dbo.SP_SEARCH_CUSTOMER_FOR_USER @StartDate,@EndDate,@Area,@Age_Max,@Age_Min", paramList.ToArray());
return(q.ToList());
}
);
return(list);
}
public IQueryable <CustomerInfo> GetCustomersList(CustomerSearchCondition input)
{
var list = _customerRepository.GetAll()
.WhereIf(input.IdCard.IsNullOrWhiteSpace(), m => m.IdCard == input.IdCard)
.WhereIf(input.Name.IsNullOrWhiteSpace(), m => m.Name == input.Name)
.WhereIf(input.AgeFrom.HasValue, m => m.Age >= input.AgeFrom)
.WhereIf(input.AgeTo.HasValue, m => m.Age <= input.AgeTo)
.WhereIf(input.Area.IsNullOrWhiteSpace(), m => m.Area.StartsWith(input.Area))
.WhereIf(input.AppEquipment.IsNullOrWhiteSpace(), m => m.AppEquipment == input.AppEquipment)
.WhereIf(input.SesameScoreFrom.HasValue, m => m.SesameScore >= input.SesameScoreFrom)
.WhereIf(input.SesameScoreTo.HasValue, m => m.SesameScore <= input.SesameScoreTo)
.WhereIf(input.Source.IsNullOrWhiteSpace(), m => m.Source == input.Source)
.WhereIf(input.Tel.IsNullOrWhiteSpace(), m => m.Tel == input.Tel)
.WhereIf(input.WeChat.IsNullOrWhiteSpace(), m => m.WeChat == input.WeChat)
.WhereIf(input.TransTimes.HasValue, m => m.TransTimes <= input.TransTimes)
.WhereIf(input.CreationTimeFrom.HasValue, m => m.CreationTime >= input.CreationTimeFrom)
.WhereIf(input.CreationTimeTo.HasValue, m => m.CreationTime <= input.CreationTimeTo)
;
return(list);
}
