private void btn_form_Click(object sender, RoutedEventArgs e)
{
last_click = btn_form_Click;
last_sender = sender;
move_rect(sender);
table = "Форма выпуска";
fields = new string[]
{
"id_form", "форма"
};
fields_types = new string[]
{
"int", "string"
};
FillGridFromDataSet(FillDataSetFromDB(generate_select(fields, table)));
fix_cmb_width();
StretchLastColumn();
}
private void btn_districts_Click(object sender, RoutedEventArgs e)
{
last_click = btn_districts_Click;
last_sender = sender;
move_rect(sender);
table = "Районы города";
fields = new string[]
{
"id_district", "район"
};
fields_types = new string[]
{
"int", "string"
};
FillGridFromDataSet(FillDataSetFromDB(generate_select(fields, table)));
fix_cmb_width();
StretchLastColumn();
}
private void btn_type_hosp_Click(object sender, RoutedEventArgs e)
{
last_click = btn_type_hosp_Click;
last_sender = sender;
move_rect(sender);
table = "Типы больницы";
fields = new string[]
{
"id_type", "тип"
};
fields_types = new string[]
{
"int", "string"
};
FillGridFromDataSet(FillDataSetFromDB(generate_select(fields, table)));
fix_cmb_width();
StretchLastColumn();
}
private void btn_firms_Click(object sender, RoutedEventArgs e)
{
last_click = btn_firms_Click;
last_sender = sender;
move_rect(sender);
table = "Заказчики";
fields = new string[]
{
"id_client", "название", "город", "телефон"
};
fields_types = new string[]
{
"int", "string", "string", "string"
};
FillGridFromDataSet(FillDataSetFromDB(generate_select(fields, table)));
fix_cmb_width();
StretchLastColumn();
}
private void btn_firms_Click(object sender, RoutedEventArgs e)
{
last_click = btn_firms_Click;
last_sender = sender;
move_rect(sender);
table = "Фирма производитель";
fields = new string[]
{
"id_firm", "название", "id_type", "страна", "год"
};
fields_types = new string[]
{
"int", "string", "int", "string", "int"
};
FillGridFromDataSet(FillDataSetFromDB(generate_select(fields, table)));
dataGridView1.Columns["id_type"].Visible = false;
addComboBoxColumn("cmb_type", "Тип", "Тип собственности", "id_type", "тип", 2);
setComboBoxColumn("cmb_type", "id_type");
fix_cmb_width();
}
