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