public static List <T> Filter <T>(List <string> columnsAndValues) where T : DbEntity { var tableName = UtilAnnotationTableDb <T> .GetTableName(); string queryFilter = FilterLikeBuilder.Build(columnsAndValues, "=", " LIKE "); return(SqlCommandSelectFilter <T> .Execute(tableName, queryFilter)); }
public static List <T> Filter <T>(string pageNumber, string totalPageNumber, List <string> columnsAndValues, List <string> sortingList) where T : DbEntity { var tableName = UtilAnnotationTableDb <T> .GetTableName(); string queryFilter = FilterLikeBuilder.Build(columnsAndValues, "=", " LIKE "); string sorting = sortingList != null && sortingList.Count > 0 ? string.Join(",", sortingList.ToArray()) : "(SELECT NULL)"; return(SqlCommandSelectPaginationSortingFilter <T> .Execute(tableName, pageNumber, totalPageNumber, sorting, queryFilter)); }