public static void ExtractSearchParameter(this BaseSearchParameter parameter, IEnumerable <KeyValuePair <string, string> > query)
{
int startIndex, count;
string orderBy;
SortOrders findOrder;
if (query.TryGet("start_index", out startIndex))
{
parameter.StartIndex = startIndex;
}
if (query.TryGet("count", out count))
{
parameter.Count = count;
}
if (query.TryGet("order_by", out orderBy))
{
parameter.OrderBy = orderBy;
}
if (query.TryGet("order", out findOrder))
{
parameter.Order = findOrder;
}
}
public override BaseSearchParameter ParseParameterValue(QueryParmDef qryParmDef, String parmValStr)
{
Guid guidValue = Guid.Empty;
BaseSearchParameter searchParm = null;
guidValue = new Guid(parmValStr);
searchParm = new EqualSearchParameter(qryParmDef);
searchParm.ParameterValue = guidValue;
return(searchParm);
}
public override BaseSearchParameter ParseParameterValue(QueryParmDef qryParmDef, String parmValStr)
{
Int32 intValue = 0;
BaseSearchParameter searchParm = null;
intValue = Int32.Parse(parmValStr);
searchParm = new EqualSearchParameter(qryParmDef);
searchParm.ParameterValue = intValue;
return(searchParm);
}
public override BaseSearchParameter ParseParameterValue(QueryParmDef qryParmDef, String parmValStr)
{
DateTime dtValue = DateTime.MinValue;
BaseSearchParameter searchParm = null;
dtValue = DateTime.Parse(parmValStr);
searchParm = new EqualSearchParameter(qryParmDef);
searchParm.ParameterValue = dtValue;
return(searchParm);
}
public override BaseSearchParameter ParseParameterValue(QueryParmDef qryParmDef, String parmValStr)
{
BaseSearchParameter searchParm = null;
System.Diagnostics.Debug.Assert(this.ParameterType == qryParmDef.ParameterType);
if (parmValStr.Contains('%'))
{
searchParm = new LikeSearchParameter(qryParmDef);
}
else
{
searchParm = new EqualSearchParameter(qryParmDef);
}
searchParm.ParameterValue = parmValStr;
return(searchParm);
}
public virtual async Task <SearchResult <T, BaseSearchParameter> > GetListAsync(BaseSearchParameter searchParameters)
{
var result = new SearchResult <T, BaseSearchParameter>
{
SearchParameter = searchParameters
};
var query = _dbSet.AsNoTracking().OrderByDescending(c => c.Id).AsQueryable();
if (searchParameters.SearchParameter != default(DateTime))
{
query = query.Where(c => c.UpdateDate <= searchParameters.SearchParameter);
}
if (searchParameters.NeedTotalCount)
{
result.TotalCount = query.Count();
}
result.Result = await query.Take(searchParameters.PageSize).ToListAsync();
return(result);
}
