public ArticulosStockCompletoForCountingSpecification(ArticulosStockSpecificationParams pArticulosStockParams) : base (x => (!pArticulosStockParams.ArticulosId.HasValue || x.Articulo.Id == pArticulosStockParams.ArticulosId) && (!pArticulosStockParams.MarcasId.HasValue || x.Vehiculo.Marca.Id == pArticulosStockParams.MarcasId) && (!pArticulosStockParams.ModelosId.HasValue || x.Vehiculo.Modelo.Id == pArticulosStockParams.ModelosId) && (x.EstadosId == 2) ) { }
public ArticulosStockCompletoSpecification(ArticulosStockSpecificationParams pArticulosStockParams) : base(x => (!pArticulosStockParams.ArticulosId.HasValue || x.Articulo.Id == pArticulosStockParams.ArticulosId) && (!pArticulosStockParams.MarcasId.HasValue || x.Vehiculo.Marca.Id == pArticulosStockParams.MarcasId) && (!pArticulosStockParams.ModelosId.HasValue || x.Vehiculo.Modelo.Id == pArticulosStockParams.ModelosId) && (x.EstadosId == 2) ) { //Agrego tablas relacionadas AgregarIncludes(a => a.Articulo); AgregarIncludes(a => a.Vehiculo); AgregarIncludes(a => a.Vehiculo.Marca); AgregarIncludes(a => a.Vehiculo.Modelo); //AddOrderBy(a => a.CodigoBarra); //Paginacion //ApplyPaging(0,20); ApplyPaging(pArticulosStockParams.PageSize * (pArticulosStockParams.PageIndex - 1), pArticulosStockParams.PageSize); //Ordenamiento if (!string.IsNullOrEmpty(pArticulosStockParams.Sort)) { switch (pArticulosStockParams.Sort) { case "codigoBarraAsc": AddOrderBy(a => a.CodigoBarra); break; case "codigoBarraDesc": AddOrderByDescending(a => a.CodigoBarra); break; case "marcaVehiculoAsc": AddOrderBy(a => a.Vehiculo.Marca.Descripcion); break; case "modeloVehiculoAsc": AddOrderBy(a => a.Vehiculo.Modelo.Descripcion); break; default: AddOrderBy(a => a.Articulo.Descripcion); break; } } }