/// <summary> /// Opens articles (roba) selection menu /// </summary> private void SelectRoba() { frmRobaTrazi roba_trazi = new frmRobaTrazi(); if (Convert.ToInt32(cbSkladiste.SelectedValue) != 0) { roba_trazi.idSkladiste = Convert.ToInt32(cbSkladiste.SelectedValue); } roba_trazi.ShowDialog(); string roba_sifra = Properties.Settings.Default.id_roba.Trim(); if (roba_sifra != "") { for (int y = 0; y < dgw.Rows.Count; y++) { if (roba_sifra == dgw.Rows[y].Cells["sifra"].FormattedValue.ToString()) { MessageBox.Show("Artikl ili usluga već postoje!", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } string sql = "SELECT * FROM roba WHERE sifra='" + roba_sifra + "'"; DataTable DTRoba = classSQL.select(sql, "roba").Tables[0]; if (DTRoba.Rows.Count > 0) { SetRoba(DTRoba); } else { MessageBox.Show("Za ovu šifru ne postoji artikl ili usluga.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnOpenRoba_Click(object sender, EventArgs e) { frmRobaTrazi roba_trazi = new frmRobaTrazi(); roba_trazi.ShowDialog(); string propertis_sifra = Properties.Settings.Default.id_roba.Trim(); if (propertis_sifra != "") { for (int y = 0; y < dgw.Rows.Count; y++) { if (propertis_sifra == dgw.Rows[y].Cells["sifra"].FormattedValue.ToString()) { MessageBox.Show("Artikl ili usluga već postoje!", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } string sql = "SELECT * FROM roba WHERE sifra='" + propertis_sifra + "' AND oduzmi='DA'"; DTRoba = classSQL.select(sql, "roba").Tables[0]; if (DTRoba.Rows.Count > 0) { txtSifra_robe.BackColor = Color.White; SetRoba(); } else { MessageBox.Show("Za ovu šifru ne postoji artikl ili usluga.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnOpenRoba_Click_1(object sender, EventArgs e) { frmRobaTrazi roba_trazi = new frmRobaTrazi(); roba_trazi.ShowDialog(); string propertis_sifra = Properties.Settings.Default.id_roba.Replace(" ", ""); if (propertis_sifra != "") { for (int y = 0; y < dgw.Rows.Count; y++) { if (propertis_sifra == dgw.Rows[y].Cells["sifra"].FormattedValue.ToString()) { MessageBox.Show("Artikl ili usluga već postoje u ovoj kalkulaciji.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } string sql = "SELECT roba.*, roba_prodaja.kolicina FROM roba " + "LEFT JOIN roba_prodaja on roba_prodaja.sifra = roba.sifra and roba_prodaja.id_skladiste = '" + cbSkladiste.SelectedValue + "'" + " WHERE roba.sifra='" + propertis_sifra + "'"; DTRoba = classSQL.select(sql, "roba").Tables[0]; if (DTRoba.Rows.Count > 0) { txtSifra_robe.BackColor = Color.White; SetRoba(); } else { MessageBox.Show("Za ovu šifru ne postoj artikl ili usluga.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnOpenRoba_Click(object sender, EventArgs e) { frmRobaTrazi roba_trazi = new frmRobaTrazi(); roba_trazi.ShowDialog(); string propertis_sifra = Properties.Settings.Default.id_roba.Trim(); for (int y = 0; y < dgw.Rows.Count; y++) { if (propertis_sifra == dgw.Rows[y].Cells["sifra"].FormattedValue.ToString().Trim()) { MessageBox.Show("Artikl ili usluga već postoje!", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } string sql = string.Format(@"SELECT roba.jm, roba.naziv, roba.oduzmi, roba_prodaja.id_skladiste, roba_prodaja.kolicina, roba_prodaja.vpc, roba_prodaja.porez, roba_prodaja.sifra FROM roba_prodaja INNER JOIN roba ON roba_prodaja.sifra = roba.sifra WHERE roba_prodaja.sifra = '{0}' AND roba_prodaja.id_skladiste = '{1}';", propertis_sifra, cbSkladiste.SelectedValue); DTRoba = classSQL.select(sql, "roba_prodaja").Tables[0]; if (DTRoba.Rows.Count > 0) { txtSifra_robe.BackColor = Color.White; SetRoba(); dgw.Select(); dgw.CurrentCell = dgw.Rows[dgw.Rows.Count - 1].Cells[4]; dgw.BeginEdit(true); txtBrojInventure.ReadOnly = true; nmGodinaInventure.ReadOnly = true; } else { sql = string.Format(@"SELECT jm, naziv, oduzmi, '0' as kolicina, vpc, porez, sifra FROM roba WHERE sifra = '{0}';", propertis_sifra); DTRoba = classSQL.select(sql, "roba").Tables[0]; if (DTRoba.Rows.Count > 0) { txtSifra_robe.BackColor = Color.White; SetRoba(); dgw.Select(); dgw.CurrentCell = dgw.Rows[dgw.Rows.Count - 1].Cells[4]; dgw.BeginEdit(true); txtBrojInventure.ReadOnly = true; nmGodinaInventure.ReadOnly = true; } else { MessageBox.Show("Za ovu šifru ne postoji artikl ili usluga u odabranom skladištu.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void EnterDGW(DataGridView d) { if (d.CurrentCell.ColumnIndex == 0) { if (d.CurrentCell.FormattedValue.ToString() == "") { frmRobaTrazi roba = new frmRobaTrazi(); roba.ShowDialog(); if (Properties.Settings.Default.id_roba != "") { d.CurrentCell.Value = Properties.Settings.Default.id_roba; } else { return; } } d.EndEdit(); DataTable DTart = classSQL.select("SELECT * FROM roba WHERE sifra='" + dgw.Rows[dgw.CurrentRow.Index].Cells[0].FormattedValue.ToString() + "'", "roba").Tables[0]; if (DTart.Rows.Count > 0) { dgw.Rows[dgw.CurrentRow.Index].Cells["naziv"].Value = DTart.Rows[0]["naziv"].ToString(); dgw.Rows[dgw.CurrentRow.Index].Cells["kolicina"].Value = "1"; dgw.Rows[dgw.CurrentRow.Index].Cells["mpc"].Value = DTart.Rows[0]["mpc"].ToString(); dgw.CurrentCell = dgw.Rows[dgw.CurrentRow.Index].Cells[2]; dgw.BeginEdit(true); } } else if (d.CurrentCell.ColumnIndex == 2) { int curent = d.CurrentRow.Index; if (curent == d.RowCount - 1 && d.Rows[curent].Cells["naziv"].FormattedValue.ToString() != "") { d.Rows.Add(); d.CurrentCell = dgw.Rows[d.RowCount - 1].Cells[0]; d.BeginEdit(true); } else if (curent == d.RowCount - 1) { d.CurrentCell = dgw.Rows[d.RowCount - 1].Cells[0]; d.BeginEdit(true); } else { d.CurrentCell = dgw.Rows[curent + 1].Cells[0]; d.BeginEdit(true); } } }
private void txtSifra_robe_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { e.SuppressKeyPress = true; if (txtSifra_robe.Text == "") { frmRobaTrazi roba = new frmRobaTrazi(); roba.ShowDialog(); if (Properties.Settings.Default.id_roba != "") { txtSifra_robe.Text = Properties.Settings.Default.id_roba; } else { return; } } string sql = "SELECT * FROM roba WHERE sifra='" + txtSifra_robe.Text + "'"; DTRoba = classSQL.select(sql, "roba").Tables[0]; if (DTRoba.Rows.Count > 0) { sifra_dobivena = DTRoba.Rows[0]["sifra"].ToString(); lblOartiklu.Text = DTRoba.Rows[0]["naziv"].ToString() + "\r\nCijena:" + Convert.ToDouble(DTRoba.Rows[0]["mpc"].ToString()).ToString("#0.00") + " kn"; string sql_normativ = "SELECT " + " caffe_normativ.sifra_normativ," + " roba.naziv," + " roba.mpc," + " caffe_normativ.kolicina," + " caffe_normativ.id_stavka" + " FROM caffe_normativ" + " LEFT JOIN roba ON roba.sifra=caffe_normativ.sifra_normativ WHERE caffe_normativ.sifra='" + sifra_dobivena + "'"; DTRobaNormativi = classSQL.select(sql_normativ, "caffe_normativ").Tables[0]; dgw.Rows.Clear(); for (int i = 0; i < DTRobaNormativi.Rows.Count; i++) { dgw.Rows.Add(DTRobaNormativi.Rows[i]["sifra_normativ"].ToString(), DTRobaNormativi.Rows[i]["naziv"].ToString(), DTRobaNormativi.Rows[i]["kolicina"].ToString(), DTRobaNormativi.Rows[i]["mpc"].ToString(), DTRobaNormativi.Rows[i]["id_stavka"].ToString()); } dgw.Rows.Add(); } else { MessageBox.Show("Za ovu šifru ne postoj artikl ili usluga.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private bool SetNormativ(DataGridViewCellEventArgs e) { if (dgw.Rows[e.RowIndex].Cells[0].FormattedValue.ToString() == "") { frmRobaTrazi roba = new frmRobaTrazi(); roba.ShowDialog(); if (Properties.Settings.Default.id_roba != "") { dgw.Rows[e.RowIndex].Cells[0].Value = Properties.Settings.Default.id_roba; DataTable DTart = classSQL.select("SELECT * FROM roba WHERE sifra='" + Properties.Settings.Default.id_roba + "'", "roba").Tables[0]; dgw.Rows[e.RowIndex].Cells["naziv"].Value = DTart.Rows[0]["naziv"].ToString(); dgw.Rows[e.RowIndex].Cells["kolicina"].Value = "1"; dgw.Rows[e.RowIndex].Cells["mpc"].Value = DTart.Rows[0]["mpc"].ToString(); dgw.CurrentCell = dgw.Rows[dgw.CurrentRow.Index].Cells[2]; dgw.BeginEdit(true); return(false); } else { return(false); } } else { DataTable DTart = classSQL.select("SELECT * FROM roba WHERE sifra='" + dgw.Rows[e.RowIndex].Cells[0].FormattedValue.ToString() + "'", "roba").Tables[0]; if (DTart.Rows.Count > 0) { dgw.Rows[e.RowIndex].Cells["naziv"].Value = DTart.Rows[0]["naziv"].ToString(); dgw.Rows[e.RowIndex].Cells["kolicina"].Value = "1"; dgw.Rows[e.RowIndex].Cells["mpc"].Value = DTart.Rows[0]["mpc"].ToString(); dgw.CurrentCell = dgw.Rows[dgw.CurrentRow.Index].Cells[2]; dgw.BeginEdit(true); return(true); } else { MessageBox.Show("Kriva šifra.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); dgw.CurrentCell = dgw.Rows[dgw.CurrentRow.Index].Cells[0]; dgw.CurrentCell.Value = ""; dgw.BeginEdit(true); return(false); } } }
private void btnEnter_Click(object sender, EventArgs e) { frmRobaTrazi roba_trazi = new frmRobaTrazi(); roba_trazi.ShowDialog(); string propertis_sifra = Properties.Settings.Default.id_roba.Replace(" ", ""); if (propertis_sifra != "") { string sql = "SELECT * FROM roba WHERE sifra='" + propertis_sifra + "'"; DTRoba = classSQL.select(sql, "roba").Tables[0]; if (DTRoba.Rows.Count > 0) { txtSifra_robe.Text = DTRoba.Rows[0]["sifra"].ToString(); lblOartiklu.Text = DTRoba.Rows[0]["naziv"].ToString() + ", \r\nCijena:" + Convert.ToDouble(DTRoba.Rows[0]["mpc"].ToString()).ToString("#0.00") + " kn"; string sql_normativ = "SELECT " + " caffe_normativ.sifra_normativ," + " roba.naziv," + " roba.mpc," + " caffe_normativ.kolicina," + " caffe_normativ.id_stavka" + " FROM caffe_normativ" + " LEFT JOIN roba ON roba.sifra=caffe_normativ.sifra_normativ WHERE caffe_normativ.sifra='" + propertis_sifra + "'"; DTRobaNormativi = classSQL.select(sql_normativ, "caffe_normativ").Tables[0]; dgw.Rows.Clear(); for (int i = 0; i < DTRobaNormativi.Rows.Count; i++) { dgw.Rows.Add(DTRobaNormativi.Rows[i]["sifra_normativ"].ToString(), DTRobaNormativi.Rows[i]["naziv"].ToString(), DTRobaNormativi.Rows[i]["kolicina"].ToString(), DTRobaNormativi.Rows[i]["mpc"].ToString(), DTRobaNormativi.Rows[i]["id_stavka"].ToString()); } dgw.Rows.Add(); } else { MessageBox.Show("Za ovu šifru ne postoj artikl ili usluga.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnPartner_Click(object sender, EventArgs e) { frmRobaTrazi roba_trazi = new frmRobaTrazi(); roba_trazi.ShowDialog(); string propertis_sifra = Properties.Settings.Default.id_roba.Trim(); if (propertis_sifra != "") { string sql = "SELECT * FROM roba WHERE sifra='" + propertis_sifra + "'"; DataTable DTRoba = classSQL.select(sql, "roba").Tables[0]; if (DTRoba.Rows.Count > 0) { txtSifra.Text = DTRoba.Rows[0]["sifra"].ToString(); txtNaslov.Text = DTRoba.Rows[0]["naziv"].ToString(); } else { MessageBox.Show("Za ovu šifru ne postoji artikl ili usluga.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void txtSifra_robe_KeyDown(object sender, KeyEventArgs e) { spremljeno = false; if (e.KeyCode == Keys.Enter) { e.SuppressKeyPress = true; if (txtSifra_robe.Text == "") { frmRobaTrazi roba = new frmRobaTrazi(); roba.ShowDialog(); if (Properties.Settings.Default.id_roba != "") { txtSifra_robe.Text = Properties.Settings.Default.id_roba; txtSifra_robe.Select(); } else { return; } } for (int y = 0; y < dgw.Rows.Count; y++) { if (txtSifra_robe.Text == dgw.Rows[y].Cells["sifra"].FormattedValue.ToString().Trim()) { MessageBox.Show("Artikl ili usluga već postoje u ovoj inventuri.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); dgw.CurrentCell = dgw.Rows[y].Cells[4]; dgw.BeginEdit(true); return; } } string sql = string.Format(@"SELECT roba.jm, roba.naziv, roba.oduzmi, roba_prodaja.id_skladiste, roba_prodaja.kolicina, roba_prodaja.vpc, roba_prodaja.porez, roba_prodaja.sifra FROM roba_prodaja INNER JOIN roba ON roba_prodaja.sifra=roba.sifra WHERE (roba_prodaja.sifra = '{0}' OR roba.ean = '{0}') AND roba_prodaja.id_skladiste = '{1}';", txtSifra_robe.Text, cbSkladiste.SelectedValue); DTRoba = classSQL.select(sql, "roba_prodaja").Tables[0]; if (DTRoba.Rows.Count > 0) { for (int y = 0; y < dgw.Rows.Count; y++) { if (DTRoba.Rows[0]["sifra"].ToString() == dgw.Rows[y].Cells["sifra"].FormattedValue.ToString().Trim()) { MessageBox.Show("Artikl ili usluga već postoje u ovoj inventuri.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } txtSifra_robe.BackColor = Color.White; SetRoba(); dgw.Select(); dgw.CurrentCell = dgw.Rows[dgw.Rows.Count - 1].Cells[4]; dgw.BeginEdit(true); txtBrojInventure.ReadOnly = true; nmGodinaInventure.ReadOnly = true; } else { sql = string.Format(@"SELECT jm, naziv, oduzmi, '0' as kolicina, vpc, porez,sifra FROM roba WHERE sifra = '{0}' OR ean = '{0}';", txtSifra_robe.Text); DTRoba = classSQL.select(sql, "roba").Tables[0]; if (DTRoba.Rows.Count > 0) { txtSifra_robe.BackColor = Color.White; SetRoba(); dgw.Select(); dgw.CurrentCell = dgw.Rows[dgw.Rows.Count - 1].Cells[4]; dgw.BeginEdit(true); txtBrojInventure.ReadOnly = true; nmGodinaInventure.ReadOnly = true; } else { MessageBox.Show("Za ovu šifru ne postoji artikl ili usluga u odabranom skladištu.", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }