private void comboBoxColors_SelectedIndexChanged(object sender, EventArgs e)
{
ObjectComboBox obj = (ObjectComboBox)comboBoxColors.SelectedItem;
if (obj.Id != 0)
{
addGridView(query.querySelectProducts(obj.Name));
}
else
{
addGridView(query.querySelectProducts());
}
}
public CardEditForm(CardsListForm instance)
{
this.instance = instance;
InitializeComponent();
query = new QueryTechnologicalCards();
queryProd = new QueryProducts();
this.Text = Properties.Resources.Card;
label1.Text = Properties.Resources.Title;
label2.Text = Properties.Resources.InputGoods;
label3.Text = Properties.Resources.OutputGoods;
label4.Text = Properties.Resources.Date;
buttonCancel.Text = Properties.Resources.Cancel;
labelAmount1.Text = Properties.Resources.Amount;
labelAmount2.Text = Properties.Resources.Amount;
buttonOK.Text = Properties.Resources.OK;
List <ObjectComboBox> lObjPr1 = new List <ObjectComboBox>();
foreach (var item in queryProd.querySelectProducts())
{
lObjPr1.Add(new ObjectComboBox(item.Id, item.Name));
}
comboBoxProductsImport.DataSource = lObjPr1;
comboBoxProductsImport.ValueMember = "Id";
comboBoxProductsImport.DisplayMember = "Name";
List <ObjectComboBox> lObjPr2 = new List <ObjectComboBox>();
foreach (var item in queryProd.querySelectProducts())
{
lObjPr2.Add(new ObjectComboBox(item.Id, item.Name));
}
comboBoxProductsExport.DataSource = lObjPr2;
comboBoxProductsExport.ValueMember = "Id";
comboBoxProductsExport.DisplayMember = "Name";
}
public MovementEditForm(MovementsListForm instance)
{
this.instance = instance;
InitializeComponent();
query = new QueryContractMove();
queryStore = new QueryStore();
queryProd = new QueryProducts();
this.Text = Properties.Resources.Movement;
label1.Text = Properties.Resources.Good;
label7.Text = Properties.Resources.Amount;
label2.Text = Properties.Resources.Date;
label3.Text = Properties.Resources.FromStorage;
label4.Text = Properties.Resources.FromCell;
label6.Text = Properties.Resources.ToStorage;
label5.Text = Properties.Resources.ToCell;
buttonCancel.Text = Properties.Resources.Cancel;
buttonOK.Text = Properties.Resources.OK;
List <ObjectComboBox> lObj1 = new List <ObjectComboBox>();
foreach (var item in queryStore.querySelectStorehouses())
{
lObj1.Add(new ObjectComboBox(item.Id, item.Name));
}
comboBoxStorehouseFrom.DataSource = lObj1;
comboBoxStorehouseFrom.ValueMember = "Id";
comboBoxStorehouseFrom.DisplayMember = "Name";
List <ObjectComboBox> lObj3 = new List <ObjectComboBox>();
foreach (var item in queryStore.querySelectStorehouses())
{
lObj3.Add(new ObjectComboBox(item.Id, item.Name));
}
comboBoxStorehouseTo.DataSource = lObj3;
comboBoxStorehouseTo.ValueMember = "Id";
comboBoxStorehouseTo.DisplayMember = "Name";
List <ObjectComboBox> lObjPr = new List <ObjectComboBox>();
foreach (var item in queryProd.querySelectProducts())
{
lObjPr.Add(new ObjectComboBox(item.Id, item.Name));
}
comboBoxProducts.DataSource = lObjPr;
comboBoxProducts.ValueMember = "Id";
comboBoxProducts.DisplayMember = "Name";
}
public SuppluEditForm(SupplyListForm instance)
{
this.instance = instance;
InitializeComponent();
query = new QueryContractSupply();
queryProd = new QueryProducts();
queryContractors = new QueryContractors();
this.Text = Properties.Resources.Supply;
labelId.Text = Properties.Resources.SupplyContract;
label2.Text = Properties.Resources.Date;
label3.Text = Properties.Resources.Goods;
label4.Text = Properties.Resources.Number;
labelAmount.Text = Properties.Resources.Amount;
labelWasReceived.Text = Properties.Resources.Received;
labelContractors.Text = Properties.Resources.Contractor;
buttonCancel.Text = Properties.Resources.Cancel;
buttonOK.Text = Properties.Resources.OK;
ArrayList lObjPr = new ArrayList();
foreach (var item in queryProd.querySelectProducts())
{
lObjPr.Add(new { Id = item.Id, Name = item.Name });
}
comboBoxProducts.DataSource = lObjPr;
comboBoxProducts.ValueMember = "Id";
comboBoxProducts.DisplayMember = "Name";
List <bool> lObjBool = new List <bool> {
true, false
};
comboBoxWasReceived.DataSource = lObjBool;
ArrayList lObjContr = new ArrayList();
foreach (var item in queryContractors.querySelectContractors(2))
{
lObjContr.Add(new { Id = item.Id, Name = item.Name });
}
comboBoxContractors.DataSource = lObjContr;
comboBoxContractors.ValueMember = "Id";
comboBoxContractors.DisplayMember = "Name";
}
public GoodsListForm()
{
InitializeComponent();
query = new QueryProducts();
this.Text = Properties.Resources.Goods;
labelSearch.Text = Properties.Resources.Search;
labelColor.Text = Properties.Resources.Color;
buttonCreate.Text = Properties.Resources.Create;
buttonEdit.Text = Properties.Resources.Edit;
button1.Text = Properties.Resources.Delete;
buttonRefresh.Text = Properties.Resources.Refresh;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.ReadOnly = true;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.RowHeadersVisible = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
dataGridView1.ScrollBars = ScrollBars.Both;
searchNameBox.Text = Properties.Resources.Title;
searchArticleBox.Text = Properties.Resources.VendorCode;
searchDescriptionBox.Text = Properties.Resources.Description;
buttonSearch.Text = Properties.Resources.Search;
DataGridViewTextBoxColumn col0 = new DataGridViewTextBoxColumn();
col0.HeaderText = Properties.Resources.ID;
DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn();
col1.HeaderText = Properties.Resources.Title;
DataGridViewTextBoxColumn col2 = new DataGridViewTextBoxColumn();
col2.HeaderText = Properties.Resources.VendorCode;
DataGridViewTextBoxColumn col3 = new DataGridViewTextBoxColumn();
col3.HeaderText = Properties.Resources.Description;
DataGridViewTextBoxColumn col4 = new DataGridViewTextBoxColumn();
col4.HeaderText = Properties.Resources.Color;
dataGridView1.Columns.Add(col0);
dataGridView1.Columns.Add(col1);
dataGridView1.Columns.Add(col2);
dataGridView1.Columns.Add(col3);
dataGridView1.Columns.Add(col4);
addGridView(query.querySelectProducts());
List <ObjectComboBox> lObj = new List <ObjectComboBox>();
lObj.Add(new ObjectComboBox(0, Properties.Resources.All));
int i = 1;
foreach (string item in query.querySelectAllColors())
{
lObj.Add(new ObjectComboBox(i, item));
i++;
}
comboBoxColors.DataSource = lObj;
comboBoxColors.ValueMember = "Id";
comboBoxColors.DisplayMember = "Name";
}