private void LoadProduct()
{
gvProdukty.AutoGenerateColumns = false;
DataGridViewTextBoxColumn[] Cl = new DataGridViewTextBoxColumn[8];
for (int i = 0; i < Cl.Count(); i++)
{
Cl[i] = new DataGridViewTextBoxColumn();
}
Cl[0].Name = "Product";
Cl[0].DataPropertyName = "Product";
Cl[1].Name = "Mn.";
Cl[1].DataPropertyName = "Quantity";
Cl[2].Name = "Jedn.";
Cl[2].DataPropertyName = "UnitShort";
Cl[3].Name = "Druh";
Cl[3].DataPropertyName = "Druh";
Cl[4].Name = "Komodita";
Cl[4].DataPropertyName = "Komodita";
Cl[5].Name = "Podkomodita";
Cl[5].DataPropertyName = "Podkomodita";
Cl[6].Name = "Priznak";
Cl[6].DataPropertyName = "Priznak";
Cl[7].Name = "idProduct";
Cl[7].DataPropertyName = "idProduct";
// Cl[7].Visible = false;
foreach (DataGridViewTextBoxColumn dgvColumn in Cl)
{
gvProdukty.Columns.Add(dgvColumn);
}
gvProdukty.DataSource = ActiveProductTable;
gvProdukty.EditMode = DataGridViewEditMode.EditProgrammatically;
gvProdukty.AllowUserToAddRows = false;
gvProdukty.AllowUserToDeleteRows = false;
gvProdukty.AllowUserToOrderColumns = true;
gvProdukty.SetColumnOrderExt();
ReadPriceProduct(0);
// gvProdukty.Refresh();
}
private void LoadItems()
{
gvPair.AutoGenerateColumns = false;
DataGridViewTextBoxColumn[] Cl = new DataGridViewTextBoxColumn[16];
for (int i = 0; i < Cl.Count(); i++)
{
Cl[i] = new DataGridViewTextBoxColumn();
}
Cl[0].Name = "Název";
Cl[0].DataPropertyName = "ItemName";
Cl[1].Name = "Mn.";
Cl[1].DataPropertyName = "Quantity";
Cl[2].Name = "Jedn.";
Cl[2].DataPropertyName = "UnitShort";
Cl[3].Name = "Dodavatel";
Cl[3].DataPropertyName = "FirmName";
Cl[4].Name = "Den";
Cl[4].DataPropertyName = "DateDUZP";
Cl[4].DefaultCellStyle.Format = "dd.MM";
Cl[5].Name = "Týden";
Cl[5].DataPropertyName = "InvoiceWeek";
Cl[6].Name = "Jedn. Cena";
Cl[6].DataPropertyName = "BasePriceBezDPH";
Cl[6].DefaultCellStyle.Format = "N2";
Cl[7].Name = "Celkem";
Cl[7].DataPropertyName = "PriceBezDPH";
Cl[7].DefaultCellStyle.Format = "N2";
Cl[8].Name = "Pair-Cena";
Cl[8].DataPropertyName = "PairPrice";
Cl[9].Name = "Rozdíl";
Cl[9].DataPropertyName = "Rozdil";
Cl[9].DefaultCellStyle.Format = "0\\%";
Cl[10].Name = "Pair-Type";
Cl[10].DataPropertyName = "PairType";
Cl[11].Name = "P-Produkt";
Cl[11].DataPropertyName = "Product";
Cl[12].Name = "idInvoiceItem";
Cl[12].DataPropertyName = "idInvoiceItem";
Cl[12].Visible = false;
Cl[13].Name = "idPair";
Cl[13].DataPropertyName = "idPair";
Cl[13].Visible = false;
Cl[14].Name = "idPairType";
Cl[14].DataPropertyName = "idPairType";
Cl[14].Visible = false;
Cl[15].Name = "idProduct";
Cl[15].DataPropertyName = "idProduct";
Cl[15].Visible = false;
gvPair.DataSource = PairItems;
foreach (DataGridViewTextBoxColumn dgvColumn in Cl)
{
gvPair.Columns.Add(dgvColumn);
}
DataGridViewButtonColumn btnCol = new DataGridViewButtonColumn();
btnCol.HeaderText = "PDF";
btnCol.DataPropertyName = "idInvoice";
btnCol.Name = "PDF";
gvPair.Columns.Add(btnCol);
gvPair.EditMode = DataGridViewEditMode.EditProgrammatically;
gvPair.AllowUserToAddRows = false;
gvPair.AllowUserToDeleteRows = false;
gvPair.AllowUserToOrderColumns = true;
gvPair.SetColumnOrderExt();
// gvPair.Refresh();
}
