private void PrikaziZbirove(int mTUD) { clsFormInitialisation fi = new clsFormInitialisation(); string ssel = " SElect AlijasPolja from RecnikPodataka Where TotalVSubtotal='S' and Dokument =@param0" + " AND Width>0"; t = db.ParamsQueryDT(ssel, Dokument); for (int k = 0; k < t.Rows.Count; k++) { var pb = forma.Controls.OfType <Field>().FirstOrDefault(n => n.IME == t.Rows[k]["AlijasPolja"].ToString()); string ssel1 = "Select sum(" + t.Rows[k]["AlijasPolja"].ToString() + ") as zbir from Unija" + Dokument + " " + WWhere; Console.WriteLine(ssel1); tt = db.ReturnDataTable(ssel1); if (tt.Rows.Count > 0) { Console.WriteLine(tt.Rows[0]["zbir"].ToString()); if (string.IsNullOrEmpty(tt.Rows[0]["zbir"].ToString())) { pb.Vrednost = "0"; } else { pb.Vrednost = tt.Rows[0]["zbir"].ToString(); } pb.textBox.Text = fi.FormatirajPolje(pb.Vrednost, pb.cTip); //pb.textBox.Text=string.Format("{0:###,##0.00}", tt.Rows[0]["zbir"]); } } }
public Double CalculatedField(Form forma, string dokument, string iddok) { CcalculatedVal cv = new CcalculatedVal(); clsEvaluation cev = new clsEvaluation(); DataBaseBroker db = new DataBaseBroker(); string KojaValuta; // Jovana 04.11.21 //KojaValuta = "RSD"; KojaValuta = Program.DomacaValuta; string KojePolje; double mvrednost = 0; string formula = ""; Dictionary <string, string> Broj = new Dictionary <string, string>(); foreach (var pb in forma.Controls.OfType <Field>()) { if (pb.cPolje.Contains("IzvodiSe") == true) { if (pb.cFormulaForme.Trim() == "") { pb.Vrednost = "0"; } else { formula = pb.cFormulaForme.Trim(); string aaa = cv.CalculateValue(forma, formula); //textBox.Text = Convert.ToString(float.Parse(dt.Rows[j][dt.Columns[k].ColumnName].ToString()).ToString("###,##0.00")); string rez = cev.Evaluate(aaa); pb.Vrednost = Convert.ToString(rez); if (pb.Vrednost.Trim() != "" || pb.Vrednost != null) { //pb.textBox.Text = Convert.ToString(float.Parse(rez.ToString()).ToString("###,##0.00")); //Jovana 05.01.21 clsFormInitialisation fi = new clsFormInitialisation(); pb.textBox.Text = fi.FormatirajPolje(rez.ToString(), pb.cTip); } } } } foreach (var ctrls in forma.Controls.OfType <Field>()) { if (ctrls.IME == "OznVal") { // Jovana 04.11.21 //if (ctrls.Vrednost != "RSD")/// DomacaValuta Then if (ctrls.Vrednost != Program.DomacaValuta) { KojaValuta = ctrls.Vrednost; break; } } } foreach (var pb in forma.Controls.OfType <Field>()) { if (pb.cPolje.Contains("Slovima") == true) { if (pb.cFormulaForme == "") { KojePolje = "Suma" + dokument.Trim(); } else { KojePolje = pb.cFormulaForme; } foreach (var ct in forma.Controls.OfType <Field>()) { if (ct.IME == KojePolje) { if (ct.Vrednost.Trim() != "") { mvrednost = Convert.ToDouble(ct.Vrednost) * 100; // jovana 05.01.21 mvrednost = Convert.ToInt64(mvrednost); if (mvrednost != 0) { Console.WriteLine(mvrednost); pb.textBox.Text = cv.Slovima(mvrednost, KojaValuta); // jovana 05.01.21 //Broj = db.ExecuteStoreProcedure("BrojSlovima", "KojiBroj:" + mvrednost, "KojaValuta:"+ KojaValuta, "Slovima:") ; //pb.textBox.Text = Broj["@Slovima"].Trim(); } } } } } } return(mvrednost); //neki komentar 01.12.2020. }
private void writeFrom(Form forma, string dokument, string iddok, string DokumentJe) { string Uslov = ""; string tUpit = ""; string[] separators = new[] { "," }; string selu = " SELECT Upit,ime FROM dbo.Upiti WHERE(NazivDokumenta = @param0" + ")"; selu += " AND Ime LIKE N'ggrr%' AND (TUD = 0)"; DataTable tt = db.ParamsQueryDT(selu, dokument); for (int i = 0; i < tt.Rows.Count; i++) { string KojiSegment = tt.Rows[i]["ime"].ToString(); KojiSegment = KojiSegment.Substring(4, KojiSegment.Length - 4); string mUpit = tt.Rows[i]["Upit"].ToString(); if (DokumentJe == "I") { Uslov = Program.WWhere; clsObradaOsnovnihSifarnika os = new clsObradaOsnovnihSifarnika(); string res = os.DodajRestrikcije(dokument, "0"); if (res.Trim() != "") { Uslov += " AND " + res; } mUpit += Uslov; tUpit = mUpit; } else { tUpit = CreateQuery(mUpit, KojiSegment, iddok, dokument, DokumentJe); } Console.WriteLine(tUpit); DataTable dt = db.ReturnDataTable(tUpit); if (dt.Rows.Count > 0) { for (int k = 0; k < dt.Columns.Count; k++) { Console.WriteLine(dt.Columns[k].ColumnName.ToUpper().ToString()); if (dt.Columns[k].ColumnName.ToUpper().ToString().Contains("ID_") == false) { Field ctrls = (Field)forma.Controls[dt.Columns[k].ColumnName]; //Field ctrls = forma.Controls.OfType<Field>().FirstOrDefault(n => n.IME == dt.Columns[k].ColumnName.ToString()); if (ctrls != null) { //Djora 16.07.21 poc ------------------------------------- if (DokumentJe == "I") { //Jovana 03.08.21 //Djora 16.07.21 if (ctrls.cIzborno != "") { } else { ctrls.Vrednost = dt.Rows[0][dt.Columns[k].ColumnName].ToString(); } // Jovana 03.08.21 if (ctrls.Vrednost != "") { switch (ctrls.VrstaKontrole) { case "tekst": clsFormInitialisation fi = new clsFormInitialisation(); ctrls.textBox.Text = fi.FormatirajPolje(ctrls.Vrednost, ctrls.cTip); break; case "datum": ctrls.dtp.Text = string.Format("{0:dd.MM.yy}", ctrls.Vrednost.ToString()); break; case "combo": ctrls.comboBox.Text = ctrls.Vrednost.ToString(); break; } } } else { //Djora 16.07.21 kraj ------------------------------------- ctrls.ID = "1"; ctrls.Vrednost = dt.Rows[0][dt.Columns[k].ColumnName].ToString(); switch (ctrls.VrstaKontrole) { case "tekst": if (ctrls.IME == "BrDok") { forma.Controls["lBrDok"].Text = ctrls.Vrednost; } string sadrzaj = dt.Rows[0][dt.Columns[k].ColumnName].ToString(); clsFormInitialisation fi = new clsFormInitialisation(); ctrls.textBox.Text = fi.FormatirajPolje(sadrzaj, ctrls.cTip); if (dokument == "IzlazniJCI") { Console.WriteLine(dt.Rows[0][dt.Columns[k].ColumnName].ToString()); if (dt.Columns[k].ColumnName.ToString() == "DatumIstupa" && (string.IsNullOrEmpty(dt.Rows[0][dt.Columns[k].ColumnName].ToString()))) { break; } else { if (dt.Columns[k].ColumnName.ToString() == "DatumIstupa") { DateTime mdat = Convert.ToDateTime(dt.Rows[0][dt.Columns[k].ColumnName].ToString()); ctrls.textBox.Text = mdat.ToString("dd.MM.yy"); } //Jovana 16.04.21 - ne treba mi ovo ispod //else // ctrls.textBox.Text = dt.Rows[0][dt.Columns[k].ColumnName].ToString(); } } break; case "datum": ctrls.dtp.Text = string.Format("{0:dd.MM.yy}", dt.Rows[0][dt.Columns[k].ColumnName].ToString()); if (ctrls.IME == "Datum") { forma.Controls["lDatum"].Text = ctrls.dtp.Text; } break; case "combo": //ivana 24.12.2020. if (ctrls.IME.Contains("NazivSkl")) { // jovana 13.01.21 if (ctrls.IME.Length == 8) { ((Bankom.frmChield)forma).NazivSkladista = dt.Rows[0][dt.Columns[k].ColumnName].ToString(); } else if (ctrls.IME.Substring(8) == ((Bankom.frmChield)forma).nastavakSkladista1) { ((Bankom.frmChield)forma).NazivSkladista1 = dt.Rows[0][dt.Columns[k].ColumnName].ToString(); } else { ((Bankom.frmChield)forma).NazivSkladista2 = dt.Rows[0][dt.Columns[k].ColumnName].ToString(); } } ctrls.comboBox.Text = dt.Rows[0][dt.Columns[k].ColumnName].ToString(); string kojiid; kojiid = "ID_" + ctrls.cAlijasTabele; for (int kk = 0; kk <= dt.Columns.Count - 1; kk++) { if (dt.Columns[kk].ColumnName.ToString() == kojiid) { string ccc = dt.Rows[0][dt.Columns[kk].ColumnName].ToString(); ctrls.ID = dt.Rows[0][dt.Columns[kk].ColumnName].ToString(); break; } } break; case "cek": if (dt.Rows[0][dt.Columns[k].ColumnName].ToString() == "1") { ctrls.cekboks.Checked = true; } else { ctrls.cekboks.Checked = false; } break; } //Djora 16.07.21 } } } } } else { foreach (var ctrls in forma.Controls.OfType <Field>().Where(g => String.Equals(g.cSegment, KojiSegment))) { // Jovana 09.11.21 //ctrls.ID = "1"; switch (ctrls.VrstaKontrole) { case "tekst": // Jovana 09.11.21 ctrls.ID = "1"; if (ctrls.IME == "BrDok") { ctrls.Text = ((Bankom.frmChield)forma).brdok; ctrls.Vrednost = ctrls.Text; ctrls.textBox.Text = ctrls.Text; } break; case "datum": // Jovana 09.11.21 ctrls.ID = "1"; if (ctrls.IME == "Datum") { ctrls.dtp.Text = ((Bankom.frmChield)forma).datum; //zajedno 15.6.2021. if (ctrls.dtp.Text.Trim() != "") { ctrls.dtp.Value = Convert.ToDateTime(ctrls.dtp.Text); } else { ctrls.dtp.Value = DateTime.Today; } } break; case "cek": // Jovana 09.11.21 ctrls.ID = "1"; break; } } } } }