public static (DataTable dataTable, List <FilterHandler.FilterDescription> filterDescription) FilterListEmployee(List <FilterHandler.FilterDescription> currentFilterDescription, MySqlConnection connection)
{
// Список полей, по которым мы можем делать отбор
List <FindHandler.FieldParameters> listOfField = FillFindFields(connection);
var query = getQueryText();
(DataTable dataTable, List <FilterHandler.FilterDescription> filterDescription)result = FilterHandler.GetDataWithFilter(currentFilterDescription, connection, listOfField, query);
return(result);
}
// Фильтр
public static (System.Data.DataTable dataTable, List <FilterHandler.FilterDescription> filterDescription) FilterListOrders(List <FilterHandler.FilterDescription> currentFilterDescription, MySqlConnection connection)
{
// Список полей, по которым мы можем делать отбор
List <FindHandler.FieldParameters> listOfField = FillFindFields(connection);
var query = getQueryText();
var queryNotNull = getNotNullQueryText();
var queryNull = getNullQueryText();
var queryGroupBy = getGroupBy();
(System.Data.DataTable dataTable, List <FilterHandler.FilterDescription> filterDescription)result = FilterHandler.GetDataWithFilter(currentFilterDescription, connection, listOfField, query,
queryNotNull, queryNull, queryGroupBy);
return(result);
}