private void fillForma(long avans, int godina) { string sql = string.Format(@"SELECT * from avansi where broj_avansa = '{0}' AND godina_avansa = '{1}';", avans, godina); DSAvansi = RemoteDB.select(sql, "avansi").Tables[0]; if (DSAvansi.Rows.Count < 1) { MessageBox.Show("Ne postoji avans!"); deleteFields(); EnableDisable(false); txtBrojAvans.Focus(); txtBrojAvans.SelectAll(); return; } ControlDisableEnable(true, true, true, true, true, true); DSAvansi.Rows[0][0].ToString(); storno = DSAvansi.Rows[0]["storno"].ToString(); txtBrojAvans.Text = avans.ToString(); numGodina.Value = Convert.ToInt16(DSAvansi.Rows[0][10].ToString()); dateTimePicker1.Value = Convert.ToDateTime(DSAvansi.Rows[0][1].ToString()); dateTimePicker2.Value = Convert.ToDateTime(DSAvansi.Rows[0][2].ToString()); cbPDV.SelectedIndex = 1; txtIzradio.Text = RemoteDB.select(string.Format(@"SELECT concat(ime, ' ', prezime) as Ime FROM zaposlenici WHERE id_zaposlenik = '{0}';", Properties.Settings.Default.id_zaposlenik), "zaposlenici"). Tables[0].Rows[0][0].ToString(); txtModel.Text = DSAvansi.Rows[0][5].ToString(); cbZiroRacun.SelectedIndex = Convert.ToInt16(DSAvansi.Rows[0][19].ToString()) - 1; cbValuta.SelectedIndex = Convert.ToInt16(DSAvansi.Rows[0][7].ToString()) - 1; cbNacinPlacanja.SelectedIndex = Convert.ToInt16(DSAvansi.Rows[0][6].ToString()) - 1; rtbOpis.Text = DSAvansi.Rows[0][8].ToString(); cbPDV.SelectedIndex = Convert.ToInt16(DSAvansi.Rows[0][17].ToString()) - 1; txtAvansirati.Text = DSAvansi.Rows[0][18].ToString(); DataTable DSpar = RemoteDB.select(string.Format(@"SELECT ime_tvrtke FROM partners WHERE id_partner = '{0}';", txtAvansirati.Text), "partners").Tables[0]; if (DSpar.Rows.Count > 0) { txtPartner.Text = DSpar.Rows[0][0].ToString(); } c = new Cijene(Convert.ToDouble(DSAvansi.Rows[0][11].ToString()), Convert.ToDouble(DSAvansi.Rows[0][14].ToString()), Convert.ToDouble(DSAvansi.Rows[0][15].ToString()), Convert.ToDouble(DSAvansi.Rows[0][12].ToString()), Convert.ToDouble(DSAvansi.Rows[0][13].ToString()), Convert.ToDouble(DSAvansi.Rows[0][16].ToString())); CijeneUTextBox(c); promjeniLabelePorezOsnovica(); //System.Windows.Forms.SendKeys.Send("{TAB}"); this.SelectNextControl(this, true, true, true, true); EnableDisable(true); }
private void CijeneUTextBox(Cijene c) { textUkupno.Text = Math.Round(c.ukupno, 2).ToString("#0.00"); textPorez10.Text = Math.Round(c.porez10, 2).ToString("#0.00"); textPorez25.Text = Math.Round(c.porezVar, 2).ToString("#0.00"); textOsnov25.Text = Math.Round(c.osnovicaVar, 2).ToString("#0.00"); textOsnov10.Text = Math.Round(c.osnovica10, 2).ToString("#0.00"); textNeoporezivo.Text = Math.Round(c.neoporezivo, 2).ToString("#0.00"); textNultaStp.Text = Math.Round(c.nultaStp, 2).ToString("#0.00"); }
private void button1_Click(object sender, EventArgs e) { edit = false; EnableDisable(true); txtBrojAvans.Text = brojAvansa(); numGodina.Value = DateTime.Now.Year; ControlDisableEnable(false, true, true, false, false, false); c = new Cijene(); CijeneUTextBox(c); }
private void textUkupno_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.OemPeriod) { e.SuppressKeyPress = true; } else if (e.KeyCode == Keys.Oemcomma || e.KeyCode == (Keys)110) { if (textUkupno.Text.Count(x => x == ',') > 0) { e.SuppressKeyPress = true; } } else if (e.KeyCode == Keys.Enter) { e.SuppressKeyPress = true; try { string vr = textUkupno.Text; //.Replace(",", "."); double p = Convert.ToDouble(vr); string post = cbPDV.Text; //.Replace(",", "."); double p1 = Convert.ToDouble(post); if (p != c.ukupno) { c = new Cijene(); c.SrediCijeneUkupno(p, p1 / 100); CijeneUTextBox(c); } System.Windows.Forms.SendKeys.Send("{TAB}"); } catch { MessageBox.Show("Unesi numeričku vrijednost!"); } } }
private void frmAvans_Load(object sender, EventArgs e) { kreirajTablice(); Paint += new PaintEventHandler(Funkcije.Form1_Paint); DTBojeForme = classDBlite.LiteSelect("SELECT * FROM FormColors", "FormColors").Tables[0]; MyDataGrid.MainForm = this; txtBrojAvans.Text = brojAvansa(); numeric(); fillComboBox(); EnableDisable(false); ControlDisableEnable(true, true, true, true, true, true); if (broj_avansa_edit != 0 && godina != 0) { fillForma(broj_avansa_edit, godina); } else { c = new Cijene(); } }
private void cijeneToolStripMenuItem_Click(object sender, EventArgs e) { Cijene cijene = new Cijene(); cijene.ShowDialog(); }