public void PrikaziFormu(string vrsta, string imestabla, string imedokumenta, Int32 idstablo, string DokumentJe)
{
if (DokumentJe != "K")
{
switch (imestabla)
{
case "Artikli":
case "Komitenti":
//ivana 13.9.2021.
//Program.Parent.ShowNewForm(imestabla, 1, imestabla + "-" + imedokumenta, 1, "", "", DokumentJe, "", "");
//Djora 10.09.21
//Program.Parent.ShowNewForm(imestabla, 1, imedokumenta, 1, "", "", DokumentJe, "", "");
//ivana 17.9.2021.
//Program.Parent.ShowNewForm(imestabla, idstablo, imestabla + "-" + imedokumenta, 1, "", "", DokumentJe, "", "");
Program.Parent.ShowNewForm(imestabla, idstablo, imedokumenta, 1, "", "", DokumentJe, "", "");
break;
case "Izvestaj":
//if (vrsta == "D")
// Program.Parent.ShowNewForm("Dokumenta", idstablo, imedokumenta, 1, "", "", "S", "", ""); // na dogadjaju form load otvara se nova forma sa predatim parametrima
//else
//{
string sql = " select s.ulazniizlazni as NazivDokumenta,NacinRegistracije as nr,"
+ " Knjizise,Izvor from SifarnikDokumenta as s"
+ " Where s.naziv=@param0";
DataTable t = db.ParamsQueryDT(sql, imedokumenta);
if (t.Rows.Count > 0)
{
Program.AktivnaSifraIzvestaja = imedokumenta;
if (t.Rows[0]["nr"].ToString().ToUpper() == "B") // izvestaj je u bazi
{
//ivana 16.9.2021.
//Program.Parent.ShowNewForm("Izvestaj", 1, imedokumenta, -1, "", "", "I", "", "");
Program.Parent.ShowNewForm("Izvestaj", idstablo, imedokumenta, -1, "", "", "I", "", "");
}
else if (t.Rows[0]["Izvor"].ToString() == "online")
{
string iddok = "1";
//ivana 13.9.2021.
//string naslov = "Print - " + imedokumenta;
//if (!Program.Parent.DalijevecOtvoren("I", "", naslov))
if (!Program.Parent.DalijevecOtvoren("I", "", imedokumenta))
{
Print fs = new Print();
fs.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(226)))), ((int)(((byte)(220)))));
fs.FormBorderStyle = FormBorderStyle.None;
fs.MdiParent = Program.Parent;
fs.Text = imedokumenta;
//ivana 13.9.2021.
//fs.Name = naslov;
fs.Name = imedokumenta;
fs.intCurrentdok = Convert.ToInt32(iddok);
fs.LayoutMdi(MdiLayout.TileVertical);
fs.imefajla = imedokumenta;
fs.kojiprint = "rpt";
fs.kojinacin = "E";
fs.izvor = t.Rows[0]["Izvor"].ToString();
fs.Show();
fs.Focus();
Program.Parent.addFormTotoolstrip1(fs, imedokumenta);
//ivana 21.10.2021.
EventArgs e = new EventArgs();
Program.Parent.itemn_click(imedokumenta, e);
}
}
else // izvestaj je excel
{
Program.Excel = imedokumenta;
//ivana 13.9.2021.
//string naslov = "Print - " + imedokumenta;
Boolean odgovor = false;
odgovor = Program.Parent.DalijevecOtvoren("I", "", imedokumenta);
if (odgovor == false)
{
frmChield fs = new frmChield();
fs.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(238)))), ((int)(((byte)(226)))), ((int)(((byte)(220)))));
fs.FormBorderStyle = FormBorderStyle.None;
fs.MdiParent = Program.Parent;
fs.Text = imedokumenta;
//ivana 13.9.2021.
//fs.Name = naslov;
fs.Name = imedokumenta;
fs.LayoutMdi(MdiLayout.TileVertical);
fs.Visible = false;
//ivana 15.9.2021.
Program.vred = "excel";
Program.Parent.addFormTotoolstrip1(fs, imedokumenta);
fs.Show();
}
//ivana 27.9.2021.
Program.Excel = "";
}
}
break;
default:
Program.Parent.ShowNewForm(imestabla, idstablo, imedokumenta, 1, "", "", DokumentJe, "", "");
//Program.Parent.ShowNewForm("Dokumenta", idstablo, imedokumenta, 1, "", "", "S", "", ""); // na dogadjaju form load otvara se nova forma sa predatim parametrima
break;
}
}
//}
}
private void PripremiPaging(Form forma, ref string tUpit, string iddok)
{
// POCETAK KODA VEZAN ZA PSGEING
int intfrom = tUpit.ToUpper().IndexOf("FROM", StringComparison.OrdinalIgnoreCase);
int intOrder = tUpit.ToUpper().IndexOf("ORDER", StringComparison.OrdinalIgnoreCase);
if (intOrder > -1)// UPIT SADRZI ORDER BY
{
((Bankom.frmChield)forma).intUkupno = db.ReturnInt(" select count(*) from " + tUpit.Substring(intfrom + 5, intOrder - intfrom - 5), 0);
}
else
{
((Bankom.frmChield)forma).intUkupno = db.ReturnInt(" select count(*) from " + tUpit.Substring(intfrom + 5), 0);
}
((Bankom.frmChield)forma).toolStripTextBroj.Text = iddok;
((Bankom.frmChield)forma).statusStrip1.Visible = true;
string strstart = "";
int pageno = 0;
if (((Bankom.frmChield)forma).intUkupno > 0)
{
if (((Bankom.frmChield)forma).BrRedova > 0)
{
pageno = ((Bankom.frmChield)forma).intUkupno / ((Bankom.frmChield)forma).BrRedova;
}
}
if (pageno * ((Bankom.frmChield)forma).BrRedova < ((Bankom.frmChield)forma).intUkupno)
{
pageno = pageno + 1;
}
string strFind = "";
strFind = ((Bankom.frmChield)forma).toolStripTextFind.Text;
((Bankom.frmChield)forma).ToolStripLblPos.Text = Convert.ToString(pageno);
((Bankom.frmChield)forma).toolStripTexIme.Text = ((Bankom.frmChield)forma).Controls["limedok"].Text;
if (((Bankom.frmChield)forma).intStart < 0)
{
((Bankom.frmChield)forma).intStart = 0;
}
if (((Bankom.frmChield)forma).intUkupno > 0 && ((Bankom.frmChield)forma).intStart >= ((Bankom.frmChield)forma).intUkupno)
{
((Bankom.frmChield)forma).intStart = ((Bankom.frmChield)forma).intUkupno - ((Bankom.frmChield)forma).BrRedova;
strstart = Convert.ToString(((Bankom.frmChield)forma).intStart);
}
if (((Bankom.frmChield)forma).intUkupno > ((Bankom.frmChield)forma).BrRedova)
{
strstart = "";
frmChield activeChild1 = (frmChield)forma.ActiveMdiChild;
if (activeChild1 != null) // da li se nalazimo na forma ako je odgovor DA nije null radi se o PAGING-u
{
strFind = activeChild1.toolStripTextFind.Text.ToString();
strstart = activeChild1.ToolStripTextPos.Text.ToString();
((Bankom.frmChield)activeChild1).ToolStripLblPos.Text = Convert.ToString(((Bankom.frmChield)activeChild1).intUkupno);
if (((Bankom.frmChield)activeChild1).intUkupno > 0 && ((Bankom.frmChield)activeChild1).intStart >= ((Bankom.frmChield)activeChild1).intUkupno)
{
((Bankom.frmChield)activeChild1).intStart = ((Bankom.frmChield)activeChild1).intUkupno - ((Bankom.frmChield)forma).BrRedova;
strstart = Convert.ToString(((Bankom.frmChield)activeChild1).intStart);
}
}
else
{
strFind = ((Bankom.frmChield)forma).toolStripTextFind.Text.ToString();
strstart = Convert.ToString(((Bankom.frmChield)forma).intStart);
((Bankom.frmChield)forma).ToolStripLblPos.Text = Convert.ToString(pageno);
if (((Bankom.frmChield)forma).intUkupno > 0 && ((Bankom.frmChield)forma).intStart >= ((Bankom.frmChield)forma).intUkupno)
{
((Bankom.frmChield)forma).intStart = ((Bankom.frmChield)forma).intUkupno - ((Bankom.frmChield)forma).BrRedova;
strstart = Convert.ToString(((Bankom.frmChield)forma).intStart);
}
}
switch (strFind)
{
case "":
case null:
if (intOrder > -1)
{
tUpit += " OFFSET " + strstart + " ROWS FETCH NEXT " + ((Bankom.frmChield)forma).BrRedova + " ROWS ONLY;";
}
Console.WriteLine(tUpit);
break;
default:
if (intOrder > -1)
{
string[] separating = new[] { "<", ">" };
string[] words = strFind.Trim().Split(separating, System.StringSplitOptions.RemoveEmptyEntries);
strFind = "";
foreach (var word in words)
{
if (word.Trim() != "")
{
strFind += " and " + word.Replace(":", " like '%") + "%'";
}
}
tUpit = tUpit.Replace("order", strFind + " order");
intfrom = tUpit.IndexOf("from", StringComparison.OrdinalIgnoreCase);
intOrder = tUpit.IndexOf("order", StringComparison.OrdinalIgnoreCase);
if (activeChild1 != null)
{
DataTable tu = db.ReturnDataTable(tUpit);
int intukupno = tu.Rows.Count;
activeChild1.intUkupno = intukupno;
if (((Bankom.frmChield)forma).BrRedova > 0)
{
float broj = intukupno / ((Bankom.frmChield)forma).BrRedova;
activeChild1.ToolStripLblPos.Text = Convert.ToString(intukupno / ((Bankom.frmChield)forma).BrRedova);
}
}
DataTable tu1 = db.ReturnDataTable(tUpit);
int intukupno1 = tu1.Rows.Count;
((Bankom.frmChield)forma).ToolStripLblPos.Text = Convert.ToString(intukupno1 / ((Bankom.frmChield)forma).BrRedova);
tUpit += " OFFSET " + strstart + " ROWS FETCH NEXT " + ((Bankom.frmChield)forma).BrRedova + " ROWS ONLY;";
}
break;
}
}
}
public void OtvoriDokument(string vrstaDokumenta, string putanjaDokumenta, string brDok, string dokje)
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(Program.connectionString);
putanjaDokumenta = putanjaDokumenta.Replace("ImeServera", LoginForm.FileServer.ToUpper()).Replace("FFirma", Program.imeFirme);
// putanjaDokumenta += brDok;
string exe = "";
switch (vrstaDokumenta)
{
case "W":
putanjaDokumenta += PrviBezDrugog(brDok, "/") + ".doc";
exe = "Winword.exe";
/* var wdApp = new Microsoft.Office.Interop.Word.Application
*
* {
* Visible = true,
* WindowState = WdWindowState.wdWindowStateNormal
*
* };
* Document aDoc = wdApp.Documents.Open(putanjaDokumenta);*/
break;
case "E":
if (brDok == Program.Excel)
{
putanjaDokumenta = putanjaDokumenta + ".xls";
}
else
{
putanjaDokumenta += PrviBezDrugog(brDok, "/") + ".xls";
}
exe = "Excel.exe";
//Djora 13.07.21 Pocetak -------------------------------------------
//Dole sam ostavio da se otvara kao proces
//var excelApp = new Microsoft.Office.Interop.Excel.Application
//{
// WindowState = XlWindowState.xlNormal,
// Visible = true
//};
//var books = excelApp.Workbooks;
//excelApp.Workbooks.Open(putanjaDokumenta);
//Djora 13.07.21 Kraj -----------------------------------------------
//Microsoft.Office.Interop.Excel.Workbook MyBook = Workbooks.Open("C:\\Users\\tamara.martinovic\\Desktop\\BrutoBilans.xlsx");
//Microsoft.Office.Interop.Excel.Worksheet MySheet = MyBook.Sheets[1];
//Microsoft.Office.Interop.Excel.Range MyRange = MySheet.UsedRange;
break;
case "P":
putanjaDokumenta += PrviBezDrugogPDF(brDok, "/") + ".pdf";
exe = "AcroRd32.exe";
break;
}
//Console.WriteLine(putanjaDokumenta);
//tamara 17.03.2021.
if (exe == "Excel.exe")
{
if (dokje == "I")
{
frmChield v = new frmChield(putanjaDokumenta, exe);
v.FormBorderStyle = FormBorderStyle.None;
v.Name = Program.Excel;
v.MdiParent = Program.Parent;
v.Dock = DockStyle.Fill;
Program.Parent.addFormTotoolstrip1(v, Program.Excel);
Program.Parent.updateToolStrip(Program.Excel);
v.StartPosition = FormStartPosition.CenterScreen;
Program.Excel = "excel";
v.Show();
}
else
{
//Djora 13.07.21 Gore sam ga zakomentarisao, jer ga ovde otvaram kao proces. Ako bi gore ostavili onda bi se otvarao dva puta.
Process p = Process.Start(exe, putanjaDokumenta);
p.WaitForInputIdle();
}
}
if (exe == "Winword.exe")
{
if (File.Exists(putanjaDokumenta))
{
Process p = Process.Start(exe, putanjaDokumenta);
p.WaitForInputIdle();
}
else
{
MessageBox.Show("Dokument je obrisan sa servera.");
}
}
if (exe == "AcroRd32.exe")
{
if (File.Exists(putanjaDokumenta))
{
Process p = Process.Start(exe, putanjaDokumenta);
p.WaitForInputIdle();
}
else
{
MessageBox.Show("Dodajte PDF dokument.");
frmSlika f = new frmSlika(Program.Parent.DodajSliku, Program.Parent);
f.Show();
}
}
}
