private void ButtonCancelFind_Click(object sender, RoutedEventArgs e)
{
buttonCancelFind.Style = (System.Windows.Style)buttonCancelFind.FindResource("NoActive");
currentFindDescription = new FindHandler.FindDescription();
RefreshList();
}
public CustomersListWindow()
{
InitializeComponent();
currentFindDescription = new FindHandler.FindDescription();
currentFilterDescription = new List <FilterHandler.FilterDescription>();
connection = new MySqlConnection(connectionString);
}
private void ButtonFind_Click(object sender, RoutedEventArgs e)
{
List <FindHandler.FieldParameters> listOfField = FillFindFields();
var findWindow = new FindWindow(currentFindDescription, listOfField);
if (findWindow.ShowDialog().Value)
{
currentFindDescription = findWindow.Result;
}
else
{
return;
}
var field = listOfField.Where(kvp => kvp.application_name == currentFindDescription.field).First().db_name;
string query = getQueryText();
string edited_query;
edited_query = query.Replace(";", " where " + field + " ");
edited_query += string.Format(currentFindDescription.typeOfFind == TypeOfFind.TypesOfFind.byExactCoincidence ? "= \"{0}\"" : "like \"{0}%\"", currentFindDescription.value);
MySqlConnection connection = new MySqlConnection(connectionString);
DataTable dataTable = new DataTable();
MySqlCommand command = new MySqlCommand(edited_query, connection);
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(dataTable);
productsGrid.ItemsSource = dataTable.DefaultView;
connection.Close();
buttonCancelFind.Style = (Style)buttonCancelFind.FindResource("Active");
}
private void ButtonFind_Click(object sender, RoutedEventArgs e)
{
(DataTable dataTable, FindHandler.FindDescription findDescription)result = Order.FindListOrders(currentFindDescription, connection);
if (result.dataTable != null)
{
ordersGrid.ItemsSource = result.dataTable.DefaultView;
}
currentFindDescription = result.findDescription;
buttonCancelFind.Style = (System.Windows.Style)buttonCancelFind.FindResource("Active");
}
public static (DataTable dataTable, FindHandler.FindDescription findDescription) FindListEmployee(FindHandler.FindDescription currentFindDescription, MySqlConnection connection)
{
List <FindHandler.FieldParameters> listOfField = FillFindFields(connection);
var query = getQueryText();
(DataTable dataTable, FindHandler.FindDescription findDescription)result = FindHandler.GetDataWithFind(currentFindDescription, connection, listOfField, query);
return(result);
}
// Поиск
public static (System.Data.DataTable dataTable, FindHandler.FindDescription findDescription) FindListOrders(FindHandler.FindDescription currentFindDescription, MySqlConnection connection)
{
List <FindHandler.FieldParameters> listOfField = FillFindFields(connection);
var query = getQueryText();
var queryNotNull = getNotNullQueryText();
var queryNull = getNullQueryText();
var queryGroupBy = getGroupBy();
var queryNullAlex = getNull();
(System.Data.DataTable dataTable, FindHandler.FindDescription findDescription)result = FindHandler.GetDataWithFind(currentFindDescription, connection, listOfField, query,
queryNotNull, queryNull, queryGroupBy, queryNullAlex);
return(result);
}
public ProductListWindow()
{
InitializeComponent();
currentFindDescription = new FindHandler.FindDescription();
currentFilterDescription = new List <FilterHandler.FilterDescription>();
}
public CustomerStatusesListWindow()
{
InitializeComponent();
currentFindDescription = new FindHandler.FindDescription();
currentFilterDescription = new List <FilterHandler.FilterDescription>();
}
public ConsumptionCategoriesListWindow()
{
InitializeComponent();
currentFindDescription = new FindHandler.FindDescription();
currentFilterDescription = new List <FilterHandler.FilterDescription>();
}
public TypeOfTransactionsListWindow()
{
InitializeComponent();
currentFindDescription = new FindHandler.FindDescription();
currentFilterDescription = new List <FilterHandler.FilterDescription>();
}
public EmployeePositionsListWindow()
{
InitializeComponent();
currentFindDescription = new FindHandler.FindDescription();
currentFilterDescription = new List <FilterHandler.FilterDescription>();
}
public OrderChannelsListWindow()
{
InitializeComponent();
currentFindDescription = new FindHandler.FindDescription();
currentFilterDescription = new List <FilterHandler.FilterDescription>();
}
public TypesOfMaterialListWindow()
{
InitializeComponent();
currentFindDescription = new FindHandler.FindDescription();
currentFilterDescription = new List <FilterHandler.FilterDescription>();
}
