//Заполнение комбо-бокса
private void cbUFill()
{
DBConnection2 connection = new DBConnection2();
connection.SotrudnikiFill();
cbName_Sotrudnika.ItemsSource = connection.dtSotrudniki.DefaultView;
cbName_Sotrudnika.SelectedValuePath = "ID_Sotrudnika";
cbName_Sotrudnika.DisplayMemberPath = "Name_Sotrudnika";
}
//Заполнение комбо-бокса
private void cbPFill()
{
DBConnection2 connection = new DBConnection2();
connection.PokupatelFill();
cbPokupatel_ID.ItemsSource = connection.dtPokupatel.DefaultView;
cbPokupatel_ID.SelectedValuePath = "ID_Pokupatel";
cbPokupatel_ID.DisplayMemberPath = "Name_Pokupatelya";
}
//Заполнение комбо-бокса
private void cbPFill()
{
DBConnection2 connection = new DBConnection2();
connection.DogovoraFill();
cbNomer_of_Dogovor.ItemsSource = connection.dtDogovora.DefaultView;
cbNomer_of_Dogovor.SelectedValuePath = "ID_Dogovor";
cbNomer_of_Dogovor.DisplayMemberPath = "Nomer_of_Dogovor";
}
//Заполнение комбо-бокса
private void cbUFill()
{
DBConnection2 connection = new DBConnection2();
connection.UslugiFill();
cbUsluga_ID.ItemsSource = connection.dtUsluga.DefaultView;
cbUsluga_ID.SelectedValuePath = "ID_Usluga";
cbUsluga_ID.DisplayMemberPath = "Name_Of_Usluga";
}
//Заполнение датагрида
private void dgFill(string qr)
{
DBConnection2 connection = new DBConnection2();
DBConnection2.qrDolgnost = qr;
connection.DolgnostFill();
dgDolgnost.ItemsSource = connection.dtDolgnost.DefaultView;
dgDolgnost.Columns[0].Visibility = Visibility.Collapsed;
}
//Заполнение датагрида
private void dgFill(string qr)
{
DBConnection2 connection = new DBConnection2();
DBConnection2.qrPokupatel = qr;
connection.PokupatelFill();
dgPokupatel.ItemsSource = connection.dtPokupatel.DefaultView;
dgPokupatel.Columns[0].Visibility = Visibility.Collapsed;
}
//Заполнение комбо-бокса
private void cbFill()
{
DBConnection2 connection = new DBConnection2();
connection.DolgnostFill();
cbDolgnost.ItemsSource = connection.dtDolgnost.DefaultView;
cbDolgnost.SelectedValuePath = "ID_Dolgnost";
cbDolgnost.DisplayMemberPath = "Name_of_Dolgnost";
}
//Заполнение датагрида
private void dgFill(string qr)
{
DBConnection2 connection = new DBConnection2();
DBConnection2.qrUsluga = qr;
connection.UslugiFill();
dgUslugi.ItemsSource = connection.dtUsluga.DefaultView;
dgUslugi.Columns[0].Visibility = Visibility.Collapsed;
}
//Заполнение комбо-бокса
private void cbPFill()
{
DBConnection2 connection = new DBConnection2();
connection.Tovarnoy_NakladnoyFill();
cbTovarnoy_Nakladnoy_ID.ItemsSource = connection.dtTovarnaya_Nakladnaya.DefaultView;
cbTovarnoy_Nakladnoy_ID.SelectedValuePath = "ID_Tovarnoy_Nakladnoy";
cbTovarnoy_Nakladnoy_ID.DisplayMemberPath = "Nazv_Tovarnoy_Nakladnoy";
}
//Заполнение датагрида
private void dgFill(string qr)
{
DBConnection2 connection = new DBConnection2();
DBConnection2.qrTovar = qr;
connection.TovarFill();
dgTovar.ItemsSource = connection.dtTovar.DefaultView;
dgTovar.Columns[0].Visibility = Visibility.Collapsed;
dgTovar.Columns[5].Visibility = Visibility.Collapsed;
}
//Заполнение датагрида
private void dgFill(string qr)
{
DBConnection2 connection = new DBConnection2();
DBConnection2.qrTransportnaya_Nakladnaya = qr;
connection.Transportnaya_NakladnayaFill();
dgTransportnaya_NakladnayaWPF.ItemsSource = connection.dtTransportnaya_Nakladnaya.DefaultView;
dgTransportnaya_NakladnayaWPF.Columns[0].Visibility = Visibility.Collapsed;
dgTransportnaya_NakladnayaWPF.Columns[4].Visibility = Visibility.Collapsed;
dgTransportnaya_NakladnayaWPF.Columns[5].Visibility = Visibility.Collapsed;
}
//Заполнение датагрида
private void dgFill(string qr)
{
DBConnection2 connection = new DBConnection2();
DBConnection2.qrSotrudniki = qr;
connection.SotrudnikiFill();
dgSotrudnik.ItemsSource = connection.dtSotrudniki.DefaultView;
dgSotrudnik.Columns[0].Visibility = Visibility.Collapsed;
dgSotrudnik.Columns[8].Visibility = Visibility.Collapsed;
dgSotrudnik.Columns[9].Visibility = Visibility.Collapsed;
}
//Заполнение датагрида
private void dgFill(string qr)
{
DBConnection2 connection = new DBConnection2();
DBConnection2.qrTovarnoy_Nakladnoy = qr;
connection.Tovarnoy_NakladnoyFill();
dgTovarnoy_NakladnoyWPF.ItemsSource = connection.dtTovarnaya_Nakladnaya.DefaultView;
dgTovarnoy_NakladnoyWPF.Columns[0].Visibility = Visibility.Collapsed;
dgTovarnoy_NakladnoyWPF.Columns[4].Visibility = Visibility.Collapsed;
dgTovarnoy_NakladnoyWPF.Columns[3].Visibility = Visibility.Collapsed;
}
//Заполнение датагрида
private void dgFill(string qr)
{
Action action = () =>
{
DBConnection2 connection = new DBConnection2();
DBConnection2.qrDogovara = qr;
connection.DogovoraFill();
dgDogovara.ItemsSource = connection.dtDogovora.DefaultView;
dgDogovara.Columns[0].Visibility = Visibility.Collapsed;
dgDogovara.Columns[4].Visibility = Visibility.Collapsed;
dgDogovara.Columns[5].Visibility = Visibility.Collapsed;
};
Dispatcher.Invoke(action);
}
