private void menu1RangeShop_Click(object sender, EventArgs e)
{
menu1RangeShop.BackColor = Color.Brown;
menu2Cashbox.BackColor = Color.LightCoral;
menu3PersonalOrder.BackColor = Color.LightCoral;
tabControl1.SelectedTab = tabRange;
formDBProvider.loadTable(dgvRange, "products");
dgvRange.Refresh();
dgvRange.Columns[0].HeaderText = "№";
dgvRange.Columns[1].HeaderText = "продукт";
dgvRange.Columns[2].HeaderText = "код категории";
dgvRange.Columns[3].HeaderText = "срок годности";
dgvRange.Columns[4].HeaderText = "себестоимость";
dgvRange.Columns[5].HeaderText = "цена";
dgvRange.Columns[6].HeaderText = "вес";
}
private void menu2PersonalOrder_Click(object sender, EventArgs e)
{
menu2PersonalOrder.BackColor = Color.Blue;
menu1Range.BackColor = Color.FromArgb(128, 128, 255);
menu3Stats.BackColor = Color.FromArgb(128, 128, 255);
tabControl1.SelectedTab = tabPersOrder;
string sql;
sql = "SELECT i.id_order,sh.address,p.name_product,i.weight,i.amount,i.date_order,i.date_ready,i.comment_order FROM indiv_order i join shop sh on i.code_shop = sh.id_shop join products p on i.code_product = p.id_product;";
formDBProvider.loadTable(dgvIndOrder, sql);
dgvIndOrder.Refresh();
dgvIndOrder.Columns[0].HeaderText = "№";
dgvIndOrder.Columns[1].HeaderText = "магазин";
dgvIndOrder.Columns[2].HeaderText = "товар";
dgvIndOrder.Columns[3].HeaderText = "вес,гр";
dgvIndOrder.Columns[4].HeaderText = "количество,шт";
dgvIndOrder.Columns[5].HeaderText = "дата создания заказа";
dgvIndOrder.Columns[6].HeaderText = "дата готовности";
dgvIndOrder.Columns[7].HeaderText = "доп.комментарий";
}
public void frmShop_Load(dbProvider myDBProvider)
{
formDBProvider = myDBProvider;
formDBProvider.loadTable(dgvRange, "products");
dgvRange.Refresh();
dgvRange.Columns[0].HeaderText = "№";
dgvRange.Columns[1].HeaderText = "продукт";
dgvRange.Columns[2].HeaderText = "код категории";
dgvRange.Columns[3].HeaderText = "срок годности";
dgvRange.Columns[4].HeaderText = "себестоимость";
dgvRange.Columns[5].HeaderText = "цена";
dgvRange.Columns[6].HeaderText = "вес";
}
