private string TransKLUDruguIUpisUBazu(string datum1, string datum2, string Ddok, int IdDok) { var lista = new List <string>(); string transKLUDruguIUpisUBazu = ""; DataTable RSImaNema = db.ReturnDataTable("select * from KursnaLista where Datum = '" + datum1 + "'"); if (RSImaNema.Rows.Count == 0) { transKLUDruguIUpisUBazu = "Nema kursne liste za taj datum u bazi"; } else { RSImaNema.Dispose(); RSImaNema = db.ReturnDataTable("select * from KursnaLista where Datum = '" + datum2 + "'"); if (RSImaNema.Rows.Count > 0) { string str = "INSERT INTO KursnaLista(Datum, Paritet, Kupovni, Srednji,"; str += " Prodajni, Dogovorni, OBRADA, ID_SifrarnikValuta, Verzija, "; str += " KupovniZaDevize, ProdajniZaDevize,OznVal, ID_Zemlja,ID_DokumentaView, "; str += " UUser, TTime) SELECT '" + datum2 + "', Paritet, Kupovni, Srednji, Prodajni, "; str += " Dogovorni, OBRADA, ID_SifrarnikValuta, Verzija, KupovniZaDevize,"; str += " ProdajniZaDevize,OznVal, ID_Zemlja," + IdDok.ToString(); str += " , UUser, TTime FROM KursnaLista WHERE Datum = '" + datum1 + "'"; lista.Add(str); string rs = db.ExecuteSqlTransaction(lista); lista.Clear(); if (rs != "") { transKLUDruguIUpisUBazu = rs; return(rs); } } else { transKLUDruguIUpisUBazu = "Kursna Lista za taj datum vec postoji"; } } RSImaNema.Dispose(); return(transKLUDruguIUpisUBazu); }
// Jovana 29.11.21 - ne koristi se //private void password_Enter(object sender, EventArgs e) //{ // PasswordTextBox.Text = ""; //} //private void username_Enter(object sender, EventArgs e) //{ // UsernameTextBox.Text = ""; //} private void UsernameTextBox_Leave(object sender, EventArgs e) { //pictureBox1.Visible = false; aliasDatabase = new Dictionary <string, string>(); cmbBaze.Items.Clear(); CmbOrg.Items.Clear(); CmbOrg.Visible = false; lblGrupa.Visible = false; cmbBaze.Visible = false; lblBaza.Visible = false; if (UsernameTextBox.Text != "") { //var fileReader = File.ReadAllText(Application.StartupPath + @"\XmlLat\xxxx.ini"); Console.WriteLine(Application.StartupPath); //Djora 30.11.20 //var fileReader = File.ReadAllText(Application.StartupPath+ @"\xxxx.ini"); //ivana 15.10.2021. da ne bi pucao, mozda treba obraditi else var fileReader = ""; if (System.IO.File.Exists(@"\\192.168.1.4\Repozitorijum\ISBankom\XXXX\xxxx.ini")) { fileReader = File.ReadAllText(@"\\192.168.1.4\Repozitorijum\ISBankom\XXXX\xxxx.ini"); } else { MessageBox.Show("xxxx.ini Nedostupan."); return; } string[] separators11 = new[] { "[", "]" }; int n = 0; string struser = UsernameTextBox.Text.ToLower(); string strobrada = ""; string[] words = fileReader.Split(separators11, StringSplitOptions.RemoveEmptyEntries); for (n = 0; n < words.Length; n++) { string cc = words[n].ToLower(); if (strobrada != "") { strobrada = words[n]; break; } if (cc == struser) { strobrada = words[n]; } if (cc == "logovanje") { string pom = words[n + 1]; char[] separators1 = { '#' }; pom = pom.Replace("\r\n", "#").Replace("\r", "").Replace("\n", ""); var result1 = pom.Split(separators1, StringSplitOptions.None); for (int j = 0; j < result1.Length; j++) { //steva 04.03.2021. if (result1[j].Contains("RptSlike=")) { ReportSlike = result1[j].Substring(result1[j].IndexOf("=") + 1); // break; } if (result1[j].Contains("Report=")) { ReportServer = result1[j].Substring(result1[j].IndexOf("=") + 1); // break; } //kraj steva 04.03.2021. //Jovana 19.02.21 Console.WriteLine(result1[j]); if (result1[j].Contains("Server=")) { if (result1[j].IndexOf("Server=") == 0) { ImeServera = result1[j].Substring(result1[j].IndexOf("=") + 1); } else { FileServer = result1[j].Substring(result1[j].IndexOf("=") + 1); } //break; } //tamara 22.4.2021. if (result1[j].Contains("SlikaZaposlenog=")) { SlikePutanja = result1[j].Substring(result1[j].IndexOf("=") + 1); } if ((result1[j].Length > 8 && result1[j].Substring(0, 9) == "Dokumenti")) { gDokumenti = result1[j].Substring(result1[j].IndexOf("=") + 3); } } } } //Jovana 19.02.21 gDokumenti = "\\" + FileServer + gDokumenti; // char[] separators = { '#','=' }; char[] separators = { '#' }; strobrada = strobrada.Replace("\r\n", "#").Replace("\r", "").Replace("\n", ""); //ivana 18.10.2021. aliasDatabase.Clear(); var result = strobrada.Split(separators, StringSplitOptions.None); int k = -1; for (n = 0; n < result.Length; n++) { if (result[n] != "") { if (result[n] == "IzborBaze=1") { strIzborBaze = result[n]; } //tamara 12.7.21. else if (result[n] == "IzborBaze=0") { strIzborBaze = result[n]; } if (result[n] == "IzborOrganizacionogDela=1") { strIzborOrganizacionogDela = result[n]; } //tamara 12.7.21. else if (result[n] == "IzborOrganizacionogDela=0") { strIzborOrganizacionogDela = result[n]; } if (result[n].Length > 4 && result[n].Substring(0, 4) == "Baza") { k++; if (result[n].Substring(0, 5) == "Baza1") { indexCurrentbaza = k; strCurrentbaza = result[n].Substring(result[n].IndexOf("=") + 1); } aliasDatabase.Add(result[n].Substring(result[n].IndexOf("-") + 1), result[n].Substring(result[n].IndexOf("=") + 1, result[n].IndexOf("-") - result[n].IndexOf("=") - 1)); cmbBaze.Items.Add(result[n].Substring(result[n].IndexOf("-") + 1)); } if ((result[n].Length > 15 && result[n].Substring(0, 16) == "OrganizacioniDeo")) { strOrgDefaultText = result[n].Substring(result[n].IndexOf("=") + 1); //grupa.AddItem(result[n].Substring(result[n].IndexOf("=") + 1)); } } } switch (strIzborBaze) { case "IzborBaze=0": //tamara 12.7.21. lblBaza.Visible = true; cmbBaze.Visible = true; cmbBaze.Enabled = false; cmbBaze.SelectedIndex = k > -1 ? indexCurrentbaza : -1; break; case "IzborBaze=1": lblBaza.Visible = true; cmbBaze.Visible = true; //ivana 13.10.2021. //cmbBaze.SelectedIndex = indexCurrentbaza; cmbBaze.SelectedIndex = k > -1 ? indexCurrentbaza : -1; break; } switch (strIzborOrganizacionogDela) { case "IzborOrganizacionogDela=0": CmbOrg.Items.Add(strOrgDefaultText); //tamara 12.7.21. lblGrupa.Visible = true; CmbOrg.Visible = true; CmbOrg.Enabled = false; CmbOrg.SelectedIndex = 0; break; case "IzborOrganizacionogDela=1": //ivana 8.12.2021. dodala sam Ccopy = 0 zbog 3. i 4. org.struk., jer su iste var query = "SELECT Naziv FROM OrganizacionaStruktura where Ccopy = 0"; var dataTable = DB.ReturnDataTable(query); for (int i = 0; i < dataTable.Rows.Count; i++) { if (dataTable.Rows[i][0].ToString() == strOrgDefaultText) { indexOrgDefault = i; } CmbOrg.Items.Add(dataTable.Rows[i][0].ToString()); } lblGrupa.Visible = true; CmbOrg.Visible = true; CmbOrg.SelectedIndex = indexOrgDefault; break; } //novo 08.12.2020. zajedno CmbOrg.Items.Clear(); var query1 = "SELECT Naziv FROM OrganizacionaStruktura "; var databaseBroker = new DataBaseBroker(); var dataTable1 = databaseBroker.ReturnDataTable(query1); for (int i = 0; i < dataTable1.Rows.Count; i++) { if (dataTable1.Rows[i][0].ToString() == strOrgDefaultText) { indexOrgDefault = i; } if (dataTable1.Rows[i][0].ToString() != "") { CmbOrg.Items.Add(dataTable1.Rows[i][0].ToString()); } } Console.WriteLine(cmbBaze.Text); Console.WriteLine(CmbOrg.Text); DataSet IdOrg = DB.ReturnDS( " select o.*,o.ID_Zemlja,os.NazivJavni as Firma ,os.NazivStampaca, os.PutanjaStampaca,os.Pib from OrganizacionaStruktura as o WITH (NOLOCK) ,organizacionastrukturastablo os WITH (NOLOCK) where o.Naziv='" + CmbOrg.Text + "' And o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;"); DataView dv = IdOrg.Tables[0].DefaultView; var zemlja = dv[0]["ID_Zemlja"]; string str = "select v.ID_Sifrarnikvaluta,OznVal,ID_Zemlja from sifrarnikvaluta as v WITH (NOLOCK) ,Zemlja as z WITH (NOLOCK) where z.ID_Zemlja=" + Convert.ToString(dv[0]["ID_Zemlja"]); str += " AND v.SifraZemlje=z.SifraZemlje"; DataTable RsValuta = DB.ReturnDataTable(str); dv.Dispose(); dv = RsValuta.DefaultView; if (RsValuta.Rows.Count == 0) { Program.DomacaValuta = "RSD"; Program.ID_DomacaValuta = 1; Program.ID_MojaZemlja = 4; } else { Program.DomacaValuta = Convert.ToString(dv[0]["OznVal"]); Program.ID_DomacaValuta = Convert.ToInt32(dv[0]["ID_SifrarnikValuta"]); Program.ID_MojaZemlja = Convert.ToInt32(dv[0]["ID_Zemlja"]); } //ivana 8.10.2021. izmenila sam ceo ovaj deo //var upit = "SELECT ID_Radnik FROM KadrovskaEvidencija WHERE Suser = @param0"; var upit = "SELECT ID_KadrovskaEvidencija FROM KadrovskaEvidencija WHERE Suser = @param0"; var prDok = DB.ParamsQueryDT(upit, UsernameTextBox.Text); //if (prDok.Rows.Count != 0 && prDok.Rows[0]["ID_Radnik"] != System.DBNull.Value) if (prDok.Rows.Count != 0 && prDok.Rows[0]["ID_KadrovskaEvidencija"] != System.DBNull.Value) { //int ID_Radnik = Convert.ToInt32(prDok.Rows[0]["ID_Radnik"]); int Id_ke = Convert.ToInt32(prDok.Rows[0]["ID_KadrovskaEvidencija"]); //upit = "SELECT ID_Firma,mbr FROM Radnik where ID = @param0"; upit = "SELECT ID_Firma,mbr FROM Radnik where ID_KadrovskaEvidencija = @param0"; //prDok = DB.ParamsQueryDT(upit, ID_Radnik); prDok = DB.ParamsQueryDT(upit, Id_ke); if (prDok.Rows.Count != 0) { int ID_Firma = Convert.ToInt32(prDok.Rows[0]["ID_Firma"]); int mbr = Convert.ToInt32(prDok.Rows[0]["mbr"]); //tamara 22.4.2021. if (File.Exists(SlikePutanja + ID_Firma + "-" + mbr + ".jpg")) { pictureBox1.Image = Image.FromFile(SlikePutanja + ID_Firma + "-" + mbr + ".jpg"); pictureBox1.Visible = true; } else { //pictureBox1.Visible = false; pictureBox1.Image = Image.FromFile(SlikePutanja + "default.jpg"); } pictureBox1.Refresh(); } else { pictureBox1.Image = Image.FromFile(SlikePutanja + "default.jpg"); } } else { pictureBox1.Image = Image.FromFile(SlikePutanja + "default.jpg"); } } }
private void OK_Click(object sender, EventArgs e) { if (CmbOrg.Text.Trim() == "") { MessageBox.Show("Morate odabrati grupu."); } else { //tamara 21.10.2020. Program.ID_Jezik = VratiJezik(); //Djora 26.09.20 int standardHeight = 1080; // 600; //900 int standardWidth = 1920; // 800; //1440 int presentHeight = Screen.PrimaryScreen.Bounds.Height; //.Bounds.Height; int presentWidth = Screen.PrimaryScreen.Bounds.Width; float heightRatio = (float)((float)presentHeight / (float)standardHeight); float widthRatio = (float)((float)presentWidth / (float)standardWidth); //Djora 28.10.21 dodato jer se kod Bojane i ako ima iste parametre za ekran kao ja, 1920x1080 i kod menbe je dobro, a kod nje nije //moj ekran je ima velicinu 226, a njena 223 //heightRatio = heightRatio + (float)0.1; float skalFaktor = getScalingFactor(); heightRatio = heightRatio * skalFaktor; widthRatio = widthRatio * skalFaktor; Program.RacioWith = (float)widthRatio; //Djora 17.11.21 if ((presentHeight == 768 && presentWidth == 1366) || (presentHeight == 768 && presentWidth == 1360)) { Program.RacioHeight = (float)0.80; } else { Program.RacioHeight = (float)heightRatio; } string ImeKorisnika = ""; string PassKorisnika = ""; string n = UsernameTextBox.Text; lblBaza.Text = ""; lblGrupa.Text = ""; if (n.Length == 0) { MessageBox.Show("Polje korisničko ime je prazno."); return; } n = PasswordTextBox.Text; if (n.Length == 0) { MessageBox.Show("Polje za lozinku je prazno."); return; } using (SqlConnection cnn = new SqlConnection(connectionString)) { if (cnn.State == ConnectionState.Closed) { cnn.Open(); } string str = " select suser,Pass,ID_KadrovskaEvidencija,SifRadnika from KadrovskaEvidencija WITH (NOLOCK) where SUSER = @username and id_kadrovskaevidencija <> 1 "; var usernameParam = new SqlParameter("username", SqlDbType.NVarChar) { Value = UsernameTextBox.Text.Trim() }; var cmd = new SqlCommand { CommandText = str, Connection = cnn }; cmd.Parameters.Add(usernameParam); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { ImeKorisnika = Convert.ToString(rdr[0]); PassKorisnika = Convert.ToString(rdr[1]); Program.idkadar = Convert.ToInt32(rdr[2]); Program.SifRadnika = Convert.ToString(rdr[3]); } else { MessageBox.Show("Pogrešno korisničko ime."); lblBaza.Visible = false; cmbBaze.Visible = false; lblGrupa.Visible = false; CmbOrg.Visible = false; rdr.Close(); cmd.Dispose(); cnn.Close(); return; } rdr.Close(); cmd.Dispose(); string strOrgDeo = "select o.ID_OrganizacionaStruktura,o.ID_OrganizacionaStrukturaStablo,os.Naziv "; strOrgDeo += " from OrganizacionaStruktura as o WITH(NOLOCK) ,organizacionastrukturastablo os WITH(NOLOCK) "; strOrgDeo += " where o.Naziv = '" + CmbOrg.Text + "' and o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;"; DataSet ds = new DataSet(); ds = DB.ReturnDS(strOrgDeo); DataView dv = ds.Tables[0].DefaultView; Program.imeFirme = dv[0]["Naziv"].ToString(); Program.idOrgDeo = Convert.ToInt32(dv[0]["ID_OrganizacionaStruktura"]); Program.idFirme = Convert.ToInt32(dv[0]["ID_OrganizacionaStrukturaStablo"]); Program.NazivOrg = CmbOrg.Text; cnn.Close(); } //ivana 26.10.2021. dodala sam ToLower() if (UsernameTextBox.Text.ToLower() != ImeKorisnika.ToLower()) { MessageBox.Show("Pogrešno korisničko ime."); lblBaza.Visible = false; cmbBaze.Visible = false; lblGrupa.Visible = false; CmbOrg.Visible = false; UsernameTextBox.Text = ""; return; } bool result = PasswordTextBox.Text.Equals(PassKorisnika); if (result == false) { MessageBox.Show("Pogrešna lozinka."); PasswordTextBox.Text = ""; return; } Program.imekorisnika = ImeKorisnika; Program.IntLogovanje = 1; Hide(); Program.Parent.Text = Program.imeFirme + "-" + Program.imekorisnika; Close(); int godina = DateTime.Now.Year; string ssel = " Select DatumPocetkaObrade from ZakljucenjeKnjiga WITH(NOLOCK) " + " where GodinaZakljucenja=" + (godina - 1).ToString() + " and id_firma =1 "; DataBaseBroker dk = new DataBaseBroker(); DataTable tk = new DataTable(); tk = dk.ReturnDataTable(ssel); if (tk.Rows.Count > 0) { Program.kDatum = Convert.ToDateTime(tk.Rows[0]["DatumPocetkaObrade"]); } else { Program.kDatum = Convert.ToDateTime("01.01." + (godina - 1).ToString()); } //Luka 14.07.21 Ako stoji min(Godina) onda iako nije nasao id_kadrovskaEvidencija sa flegom = 1 ipak muje rows.count =1 umesto nula //ssel = " SELECT min(Godina) as god FROM Godine where flag=1 AND ID_KadrovskaEvidencija=@param0"; ssel = " SELECT Godina as god FROM Godine where flag=1 AND ID_KadrovskaEvidencija=@param0"; tk = dk.ParamsQueryDT(ssel, Program.idkadar); if (tk.Rows.Count == 0) { Program.mGodina = 0; //Djora 17.07.21 Program.mGodina2 = ""; } else { Program.mGodina = Convert.ToInt32(tk.Rows[0]["god"].ToString()); //Djora 14.07.21 clsRazneFunkcije rf = new clsRazneFunkcije(); Program.mGodina2 = rf.fGodine(); } //Djora 24.08.21 pocetak --------------------------------------------------------- var MyIni = new clsIniFile(@"\\192.168.1.4\Repozitorijum\ISBankom\XXXX\xxxx.ini"); //Djora 04.11.21 string mm = MyIni.PopValue("LOGOVANJE", "PutanjaPrenosa"); Program.PutanjaPrenosa = mm; //ivana 13.12.2021. mm = MyIni.PopValue("LOGOVANJE", "PutanjaKomitenti"); Program.PutanjaKomitenti = mm; mm = MyIni.PopValue("LOGOVANJE", "LogError"); Program.LogError = mm; mm = MyIni.PopValue("LOGOVANJE", "IOSI="); Program.IOSI = mm; //Uzima po defoltu mm = MyIni.PopValue("LOGOVANJE", "FontVelicina"); Program.FontVelicina = Int16.Parse(mm); mm = MyIni.PopValue("LOGOVANJE", "FontStil"); Program.FontStil = mm; mm = MyIni.PopValue("LOGOVANJE", "FontColor"); Program.FontColor = mm; mm = MyIni.PopValue("LOGOVANJE", "BackgroundColor"); Program.BackgroundColor = mm; mm = MyIni.PopValue("LOGOVANJE", "OddTableRowColor"); Program.OddTableRowColor = mm; mm = MyIni.PopValue("LOGOVANJE", "EvenTableRowColor"); Program.EvenTableRowColor = mm; mm = MyIni.PopValue("LOGOVANJE", "ControlBackColor"); Program.ControlBackColor = mm; mm = MyIni.PopValue("LOGOVANJE", "GridColor"); Program.GridColor = mm; mm = MyIni.PopValue("LOGOVANJE", "TableBackColor"); Program.TableBackColor = mm; mm = MyIni.PopValue("LOGOVANJE", "TableHeaderColor"); Program.TableHeaderColor = mm; //Djora 02.12.21 mm = MyIni.PopValue("LOGOVANJE", "RequiredColor"); Program.RequiredColor = mm; //Uzima za korisnika ako ima mm = MyIni.PopValue(Program.imekorisnika, "FontVelicina"); if (mm != "") { Program.FontVelicina = Int16.Parse(mm); } mm = MyIni.PopValue(Program.imekorisnika, "FontStil"); if (mm != "") { Program.FontStil = mm; } mm = MyIni.PopValue(Program.imekorisnika, "FontColor"); if (mm != "") { Program.FontColor = mm; } mm = MyIni.PopValue(Program.imekorisnika, "BackgroundColor"); if (mm != "") { Program.BackgroundColor = mm; } mm = MyIni.PopValue(Program.imekorisnika, "OddTableRowColor"); if (mm != "") { Program.OddTableRowColor = mm; } mm = MyIni.PopValue(Program.imekorisnika, "EvenTableRowColor"); if (mm != "") { Program.EvenTableRowColor = mm; } mm = MyIni.PopValue(Program.imekorisnika, "ControlBackColor"); if (mm != "") { Program.ControlBackColor = mm; } mm = MyIni.PopValue(Program.imekorisnika, "GridColor"); if (mm != "") { Program.GridColor = mm; } mm = MyIni.PopValue(Program.imekorisnika, "TableBackColor"); if (mm != "") { Program.TableBackColor = mm; } mm = MyIni.PopValue(Program.imekorisnika, "TableHeaderColor"); if (mm != "") { Program.TableHeaderColor = mm; } //Djora 24.08.21 kraj ------------------------------------------------------------ //Djora 02.12.21 mm = MyIni.PopValue(Program.imekorisnika, "RequiredColor"); if (mm != "") { Program.RequiredColor = mm; } } }
// Jovana 29.11.21 - ne koristi se //private void dateTimePicker1_ValueChanged(object sender, EventArgs e) //{ //} //Djora 23.09.19 private void button1_Click(object sender, EventArgs e) { //Djora 02.12.19 string Datum = dateTimePicker1.Value.ToString("dd.MM.yy"); string NazivDokumenta = "KursnaLista"; string brojDok = ""; int rbr = 0; DataBaseBroker db = new DataBaseBroker(); //Provera kursne liste string sel = " SELECT Id_KursnaLista FROM KursnaLista WHERE datum='" + Datum + "'"; DataTable t = db.ReturnDataTable(sel); if (t.Rows.Count > 0) { MessageBox.Show("Kursna lista vec postoji!"); goto Kraj; } int IdDokView; string opis = string.Concat("Kursna lista ", Datum); clsObradaOsnovnihSifarnika os = new clsObradaOsnovnihSifarnika(); IdDokView = os.UpisiDokument(ref brojDok, opis, 61, Datum.ToString()); // upisan dokument u dokumenta i izvrseni totali SqlCommand cmd = new SqlCommand(); //Poziv Web servisa NBA i preuzimanje KursneListe u obliku XML-a rs.nbs.webservicesListe.ExchangeRateXmlService proxy2 = new rs.nbs.webservicesListe.ExchangeRateXmlService(); rs.nbs.webservicesListe.AuthenticationHeader auth = new rs.nbs.webservicesListe.AuthenticationHeader(); auth.LicenceID = Guid.Parse("15b91077-22f7-4e4c-87cd-c4a3756bee6e"); auth.UserName = "******"; auth.Password = "******"; proxy2.AuthenticationHeaderValue = auth; proxy2.Url = "https://webservices.nbs.rs/CommunicationOfficeService1_0/ExchangeRateXmlService.asmx"; //Kreiranje data seta na osnovu dobijenog xml-a DataSet ds = new DataSet(); DataSet ds2 = new DataSet(); DataSet ds3 = new DataSet(); //Djora 19.05.20 primer: datumF = "20200515" string datumF = dateTimePicker1.Value.Date.ToString("yyyyMMdd"); StringReader stringReaderSrednji = new StringReader(proxy2.GetExchangeRateByDate(datumF, 3)); //Srednji kurs StringReader stringReaderKupProd = new StringReader(proxy2.GetExchangeRateByDate(datumF, 1)); //Kupovni i prodajni kurs StringReader stringReaderEfektiva = new StringReader(proxy2.GetExchangeRateByDate(datumF, 2)); //za Efektivu ds.ReadXml(stringReaderSrednji); ds2.ReadXml(stringReaderKupProd); ds3.ReadXml(stringReaderEfektiva); stringReaderSrednji.Dispose(); stringReaderKupProd.Dispose(); stringReaderEfektiva.Dispose(); //Postavlja kolonu CurrencyCode kao primarni kljuc da bi kasnije, dole, mogo da koristim komandu Find DataColumn[] keyColumns = new DataColumn[1]; keyColumns[0] = ds.Tables[0].Columns["CurrencyCode"]; ds.Tables[0].PrimaryKey = keyColumns; ds.Tables[0].Columns.Add("KupovniZaDevize", typeof(String)); ds.Tables[0].Columns.Add("ProdajniZaDevize", typeof(String)); ds.Tables[0].Columns.Add("ID_SifrarnikValuta", typeof(String)); string Paritet; string Kupovni; string Prodajni; string Srednji; string SifVal; string Verzija = ""; string KupovniZaDevize; string ProdajniZaDevize; string IDSifVal; string OznVal; string sql = ""; SqlDataAdapter da = new SqlDataAdapter(); SqlConnection con; con = new SqlConnection(Program.connectionString); con.Open(); //Idi kroz r1 i nadji u r2 r1-KupProd r2-Srednji foreach (DataRow r1 in ds2.Tables[0].Rows) { DataRow r2 = ds.Tables[0].Rows.Find(r1["CurrencyCode"]); //Ako nisi nasao onda nista if (r2 == null) { //ds2.Tables[0].Rows.Add(r1["XID"], r1["X"]); } else { r2["BuyingRate"] = r1["BuyingRate"]; r2["SellingRate"] = r1["SellingRate"]; } } //Idi kroz r1 i nadji u r2 r1-ZaEfektivu r2-Srednji foreach (DataRow r1 in ds3.Tables[0].Rows) { DataRow r2 = ds.Tables[0].Rows.Find(r1["CurrencyCode"]); //Ako nisi nasao onda nista if (r2 == null) { //ds2.Tables[0].Rows.Add(r1["XID"], r1["X"]); } else { r2["KupovniZaDevize"] = r1["BuyingRate"]; r2["ProdajniZaDevize"] = r1["SellingRate"]; } } DataTable dt = db.ReturnDataTable("SELECT id_sifrarnikvaluta, SifVal FROM dbo.SifrarnikValuta"); DataColumn[] keyColumns2 = new DataColumn[1]; keyColumns2[0] = dt.Columns["SifVal"]; dt.PrimaryKey = keyColumns2; //Idi kroz r1 i nadji u t foreach (DataRow r1 in ds.Tables[0].Rows) { DataRow r2 = dt.Rows.Find(r1["CurrencyCodeNumChar"]); //Ako nisi nasao onda nista if (r2 == null) { //ds2.Tables[0].Rows.Add(r1["XID"], r1["X"]); } else { r1["ID_SifrarnikValuta"] = r2["id_sifrarnikvaluta"]; } } foreach (DataRow dr in ds.Tables[0].Rows) { Paritet = dr["Unit"].ToString(); Kupovni = dr["BuyingRate"].ToString(); Prodajni = dr["SellingRate"].ToString(); Srednji = dr["MiddleRate"].ToString(); SifVal = dr["CurrencyCode"].ToString(); Verzija = dr["ExchangeRateListNumber"].ToString(); //Datum = dr["Date"].ToString(); KupovniZaDevize = (dr["KupovniZaDevize"].ToString() == "") ? "0" : dr["KupovniZaDevize"].ToString(); ProdajniZaDevize = (dr["ProdajniZaDevize"].ToString() == "") ? "0" : dr["ProdajniZaDevize"].ToString(); IDSifVal = dr["ID_SifrarnikValuta"].ToString(); OznVal = dr["CurrencyCodeAlfaChar"].ToString(); //string sql = ""; //Insert u KursnaLista sql = "insert into KursnaLista(ID_SifrarnikValuta,ID_Zemlja, ID_DokumentaView, Datum, Paritet, Kupovni, Srednji, Prodajni, Dogovorni, KupovniZaDevize, ProdajniZaDevize, OznVal, Verzija) " + "values(" + IDSifVal + ", 4, " + IdDokView + ", '" + Datum.Trim() + "', " + Paritet + ", " + Kupovni + ", " + Srednji + ", " + Prodajni + ", " + Srednji + ", " + KupovniZaDevize + ", " + ProdajniZaDevize + ", '" + OznVal + "', " + Verzija + " )"; da.InsertCommand = new SqlCommand(sql, con); da.InsertCommand.ExecuteNonQuery(); } //Unos RSD (domaca valuta) sql = "insert into KursnaLista(ID_SifrarnikValuta,ID_Zemlja, ID_DokumentaView, Datum, Paritet, Kupovni, Srednji, Prodajni, Dogovorni, KupovniZaDevize, ProdajniZaDevize, OznVal, Verzija) " + "values(1, 4, " + IdDokView + ", '" + Datum + "', 1, 1, 1, 1, 1, 1, 1, 'RSD', " + Verzija + " )"; da.InsertCommand = new SqlCommand(sql, con); da.InsertCommand.ExecuteNonQuery(); //Totali za KurnuListu string strTabela = ""; string dokType = ""; string strParams = ""; string str = ""; List <string[]> lista = new List <string[]>(); str = "Execute TotaliZaDokument " + NazivDokumenta + "," + IdDokView.ToString(); lista.Add(new string[] { str, strParams, strTabela, dokType, IdDokView.ToString() }); lista.ToArray(); db.ReturnSqlTransactionParamsFull(lista); dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = ds; // dataset dataGridView1.DataMember = "ExchangeRate"; //tamara 17.6.21. dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[1].Visible = false; dataGridView1.Columns[2].Visible = false; dataGridView1.Columns[3].Visible = false; dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[5].Visible = false; dataGridView1.Columns[6].Visible = false; dataGridView1.Columns[9].Visible = false; dataGridView1.Columns[11].Visible = false; dataGridView1.Columns[12].Visible = false; dataGridView1.Columns[14].Visible = false; dataGridView1.Columns[19].Visible = false; dataGridView1.Columns[20].Visible = false; dataGridView1.Columns[21].Visible = false; dataGridView1.Columns[22].Visible = false; dataGridView1.Columns[7].HeaderText = "Šifra valute"; dataGridView1.Columns[8].HeaderText = "Oznaka valute"; dataGridView1.Columns[10].HeaderText = "Naziv valute"; dataGridView1.Columns[13].HeaderText = "Naziv zemlje"; dataGridView1.Columns[15].HeaderText = "Važi za"; dataGridView1.Columns[16].HeaderText = "Kupovni kurs"; dataGridView1.Columns[17].HeaderText = "Srednji kurs"; dataGridView1.Columns[18].HeaderText = "Prodajni kurs"; db.ExecuteStoreProcedure("TotaliZaDokument", "NazivDokumenta:Dokumenta", "IdDokument:" + IdDokView.ToString()); db.ExecuteStoreProcedure("TotaliZaDokument", "NazivDokumenta:KursnaLista", "IdDokument:" + IdDokView.ToString()); Kraj :; }
private void Obrada(string imebaze = "") { strIzborBaze = ""; strOrgDefaultText = ""; strCurrentbaza = ""; baza.Text = imebaze; strCurrentbaza = imebaze; string usrnam = username.Text; var dv = new DataView(); grupalabel.Visible = false; grupa.Visible = false; bazalabel.Visible = false; baza.Visible = false; baza.Clear(); grupa.Clear(); if (usrnam != "") { //fileReader = File.ReadAllText(Application.StartupPath + @"\XmlLat\xxxx.ini"); var fileReader = File.ReadAllText(@"\\BANKOMW\Repozitorijum\ISBankom\XXXX\xxxx.ini"); string[] separators11 = new[] { "[", "]" }; int n = 0; string struser = usrnam; string strobrada = ""; string[] words = fileReader.Split(separators11, StringSplitOptions.RemoveEmptyEntries); for (n = 0; n < words.Length; n++) { string cc = words[n].ToLower(); if (strobrada != "") { strobrada = words[n]; break; } if (cc == struser) { strobrada = words[n]; } } // char[] separators = { '#','=' }; char[] separators = { '#' }; strobrada = strobrada.Replace("\r\n", "#").Replace("\r", "").Replace("\n", ""); var result = strobrada.Split(separators, StringSplitOptions.None); //strIzborBaze statusbaze //strCurrentbaza defaultna baza. //strIzborOrganizacionogDela = status org deo // strOrgDefaultText = defaultna org deo for (n = 0; n < result.Length; n++) { if (result[n] != "") { if (result[n].Contains("Baza1") == true) { if (strCurrentbaza == "") { strCurrentbaza = result[n].Substring(result[n].IndexOf("=") + 1); } } if (result[n] == "IzborBaze=1") { strIzborBaze = result[n]; } if (result[n] == "IzborOrganizacionogDela=1") { strIzborOrganizacionogDela = result[n]; } if (result[n].Length > 4 && result[n].Substring(0, 4) == "Baza") { if (strIzborBaze == "IzborBaze=1" && strCurrentbaza == "") { strCurrentbaza = result[n].Substring(result[n].IndexOf("=") + 1); } } if ((result[n].Length > 15 && result[n].Substring(0, 16) == "OrganizacioniDeo")) { strOrgDefaultText = result[n].Substring(result[n].IndexOf("=") + 1); //break; } } } if (strIzborBaze == "IzborBaze=1") // ako je 1 puni combo { var con1 = new SqlConnection(Program.connectionString); if (con1.State == ConnectionState.Closed) { con1.Open(); } var cmd = new SqlCommand(); var da = new SqlDataAdapter(); cmd.Connection = con1; cmd.CommandText = "listaDB"; cmd.Parameters.Add("@imebaze", SqlDbType.VarChar, 100).Value = imebaze; cmd.CommandType = CommandType.StoredProcedure; da.SelectCommand = cmd; da.Fill(dtUlaz); string[] tobeDistinct = { "DatabaseName" }; DataTable dtDistinct = GetDistinctRecords(dtUlaz, tobeDistinct); for (int p = 0; p < dtDistinct.Rows.Count; p++) { if (dtDistinct.Rows[p][0].ToString() != "") { if (dtDistinct.Rows[p][0].ToString() == strCurrentbaza) { indexCurrentbaza = p; } } baza.AddItem(dtDistinct.Rows[p][0].ToString()); aliasDatabase.Add(dtDistinct.Rows[p][0].ToString(), dtDistinct.Rows[p][0].ToString()); } } if (strIzborOrganizacionogDela == "IzborOrganizacionogDela=1") // puni combo za org { string[] TobeDistinct = { "Naziv" }; DataTable dtDistinct = GetDistinctRecords(dtUlaz, TobeDistinct); grupa.Clear(); for (int p = 0; p < dtDistinct.Rows.Count; p++) { if (dtDistinct.Rows[p][0].ToString() == strOrgDefaultText) { indexOrgDefault = p; } if (dtDistinct.Rows[p][0].ToString() != "") { grupa.AddItem(dtDistinct.Rows[p][0].ToString()); } } } DataTable drr = new DataTable(); baza.Visible = false; grupa.Visible = false; switch (strIzborBaze) { case "": baza.Clear(); break; case "IzborBaze=1": bazalabel.Visible = true; baza.Visible = true; baza.selectedIndex = indexCurrentbaza; break; } switch (strIzborOrganizacionogDela) { case "": grupa.Clear(); break; case "IzborOrganizacionogDela=1": grupalabel.Visible = true; grupa.Visible = true; grupa.selectedIndex = indexOrgDefault; DataTable IdOrg = DB.ReturnDataTable(" select o.*,os.NazivJavni as Firma ,os.NazivStampaca, os.PutanjaStampaca,os.Pib from OrganizacionaStruktura as o WITH (NOLOCK) ,organizacionastrukturastablo os WITH (NOLOCK) where o.Naziv='" + strOrgDefaultText + "' And o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;"); dv = IdOrg.DefaultView; if (dv.Count > 0) { string str = "select v.ID_Sifrarnikvaluta,OznVal,ID_Zemlja from sifrarnikvaluta as v WITH (NOLOCK) ,Zemlja as z WITH (NOLOCK) "; str += " where z.ID_Zemlja=" + Convert.ToString(dv[0]["ID_Zemlja"]); str += " AND v.SifraZemlje=z.SifraZemlje"; DataBaseBroker db = new DataBaseBroker(); DataTable t = new DataTable(); t = db.ReturnDataTable(str); if (t.Rows.Count == 0) { Program.DomacaValuta = "RSD"; Program.ID_DomacaValuta = 1; Program.ID_MojaZemlja = 4; } else { Program.DomacaValuta = Convert.ToString(t.Rows[0]["OznVal"]); Program.ID_DomacaValuta = Convert.ToInt32(t.Rows[0]["ID_SifrarnikValuta"]); Program.ID_MojaZemlja = Convert.ToInt32(t.Rows[0]["ID_Zemlja"]); } } grupa.Text = strOrgDefaultText; break; } } if (baza.selectedIndex != -1) { Program.NazivBaze = baza.selectedValue; // izmeniti konekciju i u Program.cs // Program.connectionString = "Data Source=DESKTOP-71PLEMH;Initial Catalog=" + cmbBaze.Text + ";User ID=sa;password=password;"; // Program.GetConnection(); } }
private void bazaonItemSelected(object sender, EventArgs e) { string strimebaze = ""; SqlConnection cnn = new SqlConnection(connectionString); cnn = Program.GetConnection(); if (cnn == null) { MessageBox.Show("Greska u konekciji!"); Application.Exit(); System.Environment.Exit(1); } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT name FROM master.dbo.sysdatabases"; cmd.Connection = cnn; DataSet dss = new DataSet(); DataView dv = new DataView(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(dss); dv = dss.Tables[0].DefaultView; for (int x = 0; x < dv.Count; x++) { if (aliasDatabase[baza.selectedValue] == Convert.ToString(dv[x][0])) { strimebaze = Convert.ToString(dv[x][0]); Program.NazivBaze = strimebaze; break; } } if (strimebaze == "") { MessageBox.Show("Ne postoji izabrana baza", "info"); grupa.Clear(); } else { changeDatabase(baza.selectedValue); grupa.Clear(); var query = "SELECT Naziv FROM OrganizacionaStruktura "; var databaseBroker = new DataBaseBroker(); var dataTable = databaseBroker.ReturnDataTable(query); for (int i = 0; i < dataTable.Rows.Count; i++) { if (dataTable.Rows[i][0].ToString() == strOrgDefaultText) { indexOrgDefault = i; } if (dataTable.Rows[i][0].ToString() != "") { grupa.AddItem(dataTable.Rows[i][0].ToString()); } } if (baza.selectedValue == strCurrentbaza) { grupa.selectedIndex = indexOrgDefault; } } }
private void OK_Click(object sender, EventArgs e) { //Djora 26.09.20 int standardHeight = 1080; // 600; //900 int standardWidth = 1920; // 800; //1440 int presentHeight = Screen.PrimaryScreen.Bounds.Height; //.Bounds.Height; int presentWidth = Screen.PrimaryScreen.Bounds.Width; float heightRatio = (float)((float)presentHeight / (float)standardHeight); float widthRatio = (float)((float)presentWidth / (float)standardWidth); Program.RacioWith = (float)widthRatio; Program.RacioHeight = (float)heightRatio; if (changePassword) { if (password.Text.Trim().Equals(newpassword.Text.Trim())) { DB.ReturnDataTable("UPDATE KadrovskaEvidencija SET pass ='******' WHERE Suser = '******'"); MessageBox.Show("Uspešno ste promenili lozinku!"); ReloadLogin(); changePassword = false; } else { MessageBox.Show("Ne podudaraju se lozinke,pokušajte ponovo!"); } return; } string ImeKorisnika = ""; string PassKorisnika = ""; string n = username.Text; bazalabel.Text = ""; grupalabel.Text = ""; if (n.Length == 0) { porukalabel.Text = "Polje korisničko ime je prazno"; porukalabel.Visible = true; return; } n = password.Text; if (n.Length == 0) { porukalabel.Text = "Polje za lozinku je prazno"; porukalabel.Visible = true; return; } using (SqlConnection cnn = new SqlConnection(connectionString)) { if (cnn.State == ConnectionState.Closed) { cnn.Open(); } string str = " select suser,Pass,ID_KadrovskaEvidencija,SifRadnika from KadrovskaEvidencija WITH (NOLOCK) where SUSER = @username and id_kadrovskaevidencija <> 1 "; var usernameParam = new SqlParameter("username", SqlDbType.NVarChar) { Value = username.Text.Trim() }; var cmd = new SqlCommand { CommandText = str, Connection = cnn }; cmd.Parameters.Add(usernameParam); SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { ImeKorisnika = Convert.ToString(rdr[0]); PassKorisnika = Convert.ToString(rdr[1]); Program.idkadar = Convert.ToInt32(rdr[2]); Program.SifRadnika = Convert.ToString(rdr[3]); } else { porukalabel.Text = "Pogresno korisničko ime !"; porukalabel.Visible = true; rdr.Close(); cmd.Dispose(); cnn.Close(); return; } rdr.Close(); cmd.Dispose(); string strOrgDeo = "select o.ID_OrganizacionaStruktura,o.ID_OrganizacionaStrukturaStablo,os.Naziv "; strOrgDeo += " from OrganizacionaStruktura as o WITH(NOLOCK) ,organizacionastrukturastablo os WITH(NOLOCK) "; strOrgDeo += " where o.Naziv = '" + grupa.selectedValue + "' and o.ID_OrganizacionaStrukturaStablo=os.ID_OrganizacionaStrukturaStablo ;"; DataSet ds = new DataSet(); ds = DB.ReturnDS(strOrgDeo); DataView dv = ds.Tables[0].DefaultView; Program.idOrgDeo = Convert.ToInt32(dv[0]["ID_OrganizacionaStruktura"]); Program.idFirme = Convert.ToInt32(dv[0]["ID_OrganizacionaStrukturaStablo"]); Program.imeFirme = dv[0]["Naziv"].ToString(); cnn.Close(); } if (username.Text != ImeKorisnika) { porukalabel.Text = "Pogrešno korisničko ime !"; porukalabel.Visible = true; username.Text = ""; return; } bool result = password.Text.Equals(PassKorisnika); if (result == false) { porukalabel.Text = "Pogrešna lozinka!"; return; } Program.imekorisnika = ImeKorisnika; Program.IntLogovanje = 1; Hide(); try { ((BankomMDI)MdiParent).Controls["menuStrip"].Enabled = true; ((BankomMDI)MdiParent).Controls["menuStrip1"].Enabled = true; ((BankomMDI)MdiParent).Text = Program.imeFirme + "-" + Program.imekorisnika; } catch { } Program.Parent.Text = Program.imeFirme + "-" + Program.imekorisnika; Close(); int godina = DateTime.Now.Year; string ssel = " Select DatumPocetkaObrade from ZakljucenjeKnjiga WITH(NOLOCK) " + " where GodinaZakljucenja=" + (godina - 1).ToString() + " and id_firma =1 "; DataBaseBroker dk = new DataBaseBroker(); DataTable tk = new DataTable(); tk = dk.ReturnDataTable(ssel); if (tk.Rows.Count > 0) { Program.kDatum = Convert.ToDateTime(tk.Rows[0]["DatumPocetkaObrade"]); } else { Program.kDatum = Convert.ToDateTime("01.01." + (godina - 1).ToString()); } }
private void frmChield_Load(object sender, EventArgs e) { //steva 20.04.21 pritiskanje F1 dugmeta za help this.KeyPreview = true; this.KeyDown += new KeyEventHandler(pozivanjeHelpa); //tamara 03.2021. Djora 10.05.21 //if (exe=="Excel.exe") if (Program.Excel != "" && Program.Excel != null) { this.FormBorderStyle = FormBorderStyle.None; //Djora 24.08.21 //this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(226)))), ((int)(((byte)(220))))); this.BackColor = Color.FromArgb(Int32.Parse(Program.BackgroundColor)); //Color.Green; this.AutoScroll = true; //Djora 10.05.21 panel2.Dock = DockStyle.Fill; //Djora 10.05.21 //panel2.Visible = true; //panel2.BringToFront(); excelApp = new Microsoft.Office.Interop.Excel.Application(); //string putanja1 = "C:\\Users\\tamara.martinovic\\Desktop\\AnalitikaNabavkePoDobavljacima.xls"; object misValue = System.Reflection.Missing.Value; //excelApp.Wait(8000); string PutanjaDokumenta = ""; string sql = "select UlazniIzlazni as NazivKlona,NacinRegistracije,PutanjaZaCuvanje,prikaz,vrsta,OdakleSePreuzima from SifarnikDokumenta where Naziv=@param0"; System.Data.DataTable dt1 = db.ParamsQueryDT(sql, Program.Excel); if (dt1.Rows.Count != 0) { PutanjaDokumenta = dt1.Rows[0]["PutanjaZaCuvanje"].ToString().Trim(); PutanjaDokumenta = PutanjaDokumenta.Replace("ImeServera", LoginForm.FileServer.ToUpper()).Replace("FFirma", Program.imeFirme); } //Djora 10.05.21 Thread thread = Thread.CurrentThread; System.Diagnostics.Debug.WriteLine(thread.ManagedThreadId); if (File.Exists(@PutanjaDokumenta + Program.Excel + ".xls")) { //Djora 20.07.21 treci parametar (read only) je stavljen na false, jer kad je true onda se ne vidi meni. excelWorkBook = excelApp.Workbooks.Open(PutanjaDokumenta + Program.Excel + ".xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); // Jovana 25.10.21 vratila red iznad da bi bilo read only //excelWorkBook = excelApp.Workbooks.Open(PutanjaDokumenta + Program.Excel + ".xls", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); excelApp.Visible = true; excelWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelWorkBook.Sheets[1]; excelWorkSheet.SelectionChange += new Microsoft.Office.Interop.Excel.DocEvents_SelectionChangeEventHandler(excelWorkSheet_SelectionChange); IntPtr excelHwnd = new IntPtr(excelApp.Application.Hwnd); panel2.Height = this.Height - 70; panel2.Width = this.Width; //ivana 23.3.2021. Djora 01.06.21 Djora 20.07.21 Treba da ostane zagradjeno, nemojte vise da odgradjujete ili resite na drugi nacin //excelApp.Width = panel2.Width; //excelApp.Height = panel2.Height - 229; //ivana 19.5.2021. ((BankomMDI)this.MdiParent).itemn_click(this.Name, e); SetParent(excelHwnd, panel2.Handle); this.Tag = excelHwnd; panel2.Visible = true; panel2.BringToFront(); } else { MessageBox.Show("Ne postoji dati izveštaj!"); } } else { this.FormBorderStyle = FormBorderStyle.None; //Djora 24.08.21 //this.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(226)))), ((int)(((byte)(220))))); this.BackColor = Color.FromArgb(Int32.Parse(Program.BackgroundColor)); //Color.Green; this.AutoScroll = true; ////tamara 01.02.2021. //this.Text = "."; intStart = 0; toolStripStatusPrazno.Text = new String(' ', 150); toolStripStatusprdva.Text = new String(' ', 50); clscontrolsOnForm cononf = new clscontrolsOnForm(); clsdokumentRefresh docref = new clsdokumentRefresh(); DataBaseBroker db = new DataBaseBroker(); liddok.Text = iddokumenta.ToString(); ldokje.Text = DokumentJe; lidstablo.Text = idstablo.ToString(); limestabla.Text = imestabla; limedok.Text = imedokumenta; lBrDok.Text = brdok; lDatum.Text = datum; panel1.Visible = false; switch (VrstaPrikaza) { case "TreeView": clsTreeProcessing tw = new clsTreeProcessing(); tw.ObradaStabla(this, "1", imedokumenta, DokumentJe); break; default: string supit = ""; switch (DokumentJe) { case "D": if (imedokumenta == "KalkulacijaUlaza" || imedokumenta == "PDVKalkulacijaUlaza") { // punimo tabelu kalk za odabranu kalkulaciju da bismo imali podatke za zavisne troskove string Odakle = "Load"; clsObradaKalkulacije okal = new clsObradaKalkulacije(); okal.RasporedTroskova(iddokumenta, " ", " ", " ", Odakle); Odakle = ""; } cononf.addFormControls(this, imedokumenta, iddokumenta.ToString(), OOperacija.Text); docref.refreshDokumentBody(this, imedokumenta, iddokumenta.ToString(), DokumentJe); docref.refreshDokumentGrid(this, imedokumenta, iddokumenta.ToString(), "", "", DokumentJe); break; case "P": cononf.addFormControls(this, imedokumenta, iddokumenta.ToString(), OOperacija.Text); clsObradaStablaPtipa procp = new clsObradaStablaPtipa(); supit = procp.Proces(imestabla, imedokumenta, idstablo); docref.refreshDokumentGrid(this, imedokumenta, idstablo.ToString(), supit, "1", DokumentJe); break; case "I": cononf.addFormControls(this, imedokumenta, iddokumenta.ToString(), OOperacija.Text); //cononf.addFormControls(this, imestabla, idstablo.ToString(), OOperacija.Text); string sel = "Select TUD From Upiti Where NazivDokumenta='" + imedokumenta + "' and ime like'GGrr%' AND TUD>0 Order by TUD"; Console.WriteLine(sel); System.Data.DataTable ti = db.ReturnDataTable(sel); clsObradaStablaItipa proci = new clsObradaStablaItipa(); for (int j = 0; j < ti.Rows.Count; j++) { supit = proci.Proces(imedokumenta, ti.Rows[j]["TUD"].ToString()); Console.WriteLine(supit); docref.refreshDokumentGrid(this, imedokumenta, idstablo.ToString(), supit, ti.Rows[j]["TUD"].ToString(), DokumentJe); } break; case "S": clsObradaStablaStipa procss = new clsObradaStablaStipa(); supit = procss.Proces(imestabla, imedokumenta, Convert.ToInt32(idstablo)); if (supit != "") { cononf.addFormControls(this, imestabla, idstablo.ToString(), OOperacija.Text); docref.refreshDokumentGrid(this, imestabla, idstablo.ToString(), supit, "1", DokumentJe); } break; } break; } panel1.Top = 0; if (this.Text == "LOT") { foreach (var pb in this.Controls.OfType <Field>()) { //if (pb.cTip == 10 || pb.cTip == 8) // pb.Enabled = false; if (pb.cTip == 10) { if (pb.VrstaKontrole == "combo") { pb.comboBox.Enabled = false; } else { pb.textBox.Enabled = false; } } if (pb.cTip == 8) { pb.dtp.Enabled = false; } } } } }