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; } } } } }