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