public void IspisKarticeOS(object sender, EventArgs e)
{
frmUvjetiBilanca bilanca = new frmUvjetiBilanca();
OSDataSet set = new OSDataSet();
ReportDocument document = new ReportDocument();
int index = 0;
RowEnumerator enumerator = this.userControlDataGridOS.DataGrid.Selected.Rows.GetEnumerator();
while (enumerator.MoveNext())
{
UltraGridRow current = enumerator.Current;
DataRow[] rowArray = this.userControlDataGridOS.DataGrid.DataSet.OS.Select(Conversions.ToString(Operators.ConcatenateObject("invbroj = ", current.Cells["invbroj"].Value)));
DataRow[] rowArray2 = this.userControlDataGridOS.DataGrid.DataSet.OSTEMELJNICA.Select(Conversions.ToString(Operators.ConcatenateObject("invbroj = ", current.Cells["invbroj"].Value)));
set.OS.ImportRow(rowArray[0]);
int num2 = rowArray2.Length - 1;
for (index = 0; index <= num2; index++)
{
set.OSTEMELJNICA.ImportRow(rowArray2[index]);
}
}
document.Load(System.Windows.Forms.Application.StartupPath + @"\Izvjestaji\rptOSKartica.rpt");
document.SetDataSource(set);
KORISNIKDataSet dataSet = new KORISNIKDataSet();
new KORISNIKDataAdapter().Fill(dataSet);
document.SetParameterValue("ustanova", RuntimeHelpers.GetObjectValue(dataSet.KORISNIK.Rows[0]["KORISNIK1NAZIV"]));
document.SetParameterValue("ustanova2", Operators.AddObject(Operators.AddObject(dataSet.KORISNIK.Rows[0]["KORISNIK1ADRESA"], " "), dataSet.KORISNIK.Rows[0]["KORISNIK1MJESTO"]));
document.SetParameterValue("tel", RuntimeHelpers.GetObjectValue(dataSet.KORISNIK.Rows[0]["KONTAKTTELEFON"]));
document.SetParameterValue("fax", RuntimeHelpers.GetObjectValue(dataSet.KORISNIK.Rows[0]["KONTAKTFAX"]));
document.SetParameterValue("oib", RuntimeHelpers.GetObjectValue(dataSet.KORISNIK.Rows[0]["KORISNIKOIB"]));
ExtendedWindowWorkspace workspace = new ExtendedWindowWorkspace();
PreviewReportWorkItem item = this.Controller.WorkItem.Items.Get <PreviewReportWorkItem>("Pregled");
if (item == null)
{
item = this.Controller.WorkItem.Items.AddNew <PreviewReportWorkItem>("Pregled");
}
item.Izvjestaj = document;
item.Activate();
item.Show(item.Workspaces["main"]);
}
public void IspisBilance(object sender, EventArgs e)
{
frmUvjetiBilanca bilanca = new frmUvjetiBilanca();
if (bilanca.ShowDialog() == DialogResult.OK)
{
string str = string.Empty;
ReportDocument document = new ReportDocument();
if (bilanca.___PoNosiocu)
{
document.Load(System.Windows.Forms.Application.StartupPath + @"\Izvjestaji\rptOSBilancaPoNosiocu.rpt");
}
else
{
document.Load(System.Windows.Forms.Application.StartupPath + @"\Izvjestaji\rptOSBilanca.rpt");
}
S_OS_BILANCA_STANJA_NA_DANDataAdapter adapter = new S_OS_BILANCA_STANJA_NA_DANDataAdapter();
S_OS_BILANCA_STANJA_NA_DANDataSet dataSet = new S_OS_BILANCA_STANJA_NA_DANDataSet();
S_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJIDataAdapter adapter2 = new S_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJIDataAdapter();
S_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJIDataSet set2 = new S_OS_BILANCA_STANJA_NA_DAN_PO_LOKACIJIDataSet();
if (bilanca.___PoNosiocu)
{
adapter2.Fill(set2, bilanca.__nadan, Conversions.ToString(bilanca.__Sort), Conversions.ToInteger(bilanca.__Vrsta));
document.SetDataSource(set2);
}
else
{
adapter.Fill(dataSet, bilanca.__nadan, Conversions.ToString(bilanca.__Sort), Conversions.ToShort(bilanca.__Vrsta));
document.SetDataSource(dataSet);
}
DateTimeFormatInfo dateTimeFormat = new CultureInfo("hr-HR").DateTimeFormat;
if (Operators.ConditionalCompareObjectEqual(bilanca.__Vrsta, 1, false))
{
if (bilanca.___PoNosiocu)
{
str = "Stanje osnovnih sredstava po lokacijama na dan: " + bilanca.__nadan.ToString("d", dateTimeFormat);
}
else
{
str = "Stanje osnovnih sredstava na dan: " + bilanca.__nadan.ToString("d", dateTimeFormat);
}
}
else if (bilanca.___PoNosiocu)
{
str = "Stanje sitnog inventara po lokacijama na dan: " + bilanca.__nadan.ToString("d", dateTimeFormat);
}
else
{
str = "Stanje sitnog inventara na dan: " + bilanca.__nadan.ToString("d", dateTimeFormat);
}
KORISNIKDataSet set3 = new KORISNIKDataSet();
new KORISNIKDataAdapter().Fill(set3);
document.SetParameterValue("ustanova", RuntimeHelpers.GetObjectValue(set3.KORISNIK.Rows[0]["KORISNIK1NAZIV"]));
document.SetParameterValue("ustanova2", Operators.AddObject(Operators.AddObject(set3.KORISNIK.Rows[0]["KORISNIK1ADRESA"], " "), set3.KORISNIK.Rows[0]["KORISNIK1MJESTO"]));
document.SetParameterValue("tel", RuntimeHelpers.GetObjectValue(set3.KORISNIK.Rows[0]["KONTAKTTELEFON"]));
document.SetParameterValue("fax", RuntimeHelpers.GetObjectValue(set3.KORISNIK.Rows[0]["KONTAKTFAX"]));
document.SetParameterValue("oib", RuntimeHelpers.GetObjectValue(set3.KORISNIK.Rows[0]["KORISNIKOIB"]));
document.SetParameterValue("naslov", str);
ExtendedWindowWorkspace workspace = new ExtendedWindowWorkspace();
PreviewReportWorkItem item = this.Controller.WorkItem.Items.Get <PreviewReportWorkItem>("Pregled");
if (item == null)
{
item = this.Controller.WorkItem.Items.AddNew <PreviewReportWorkItem>("Pregled");
}
item.Izvjestaj = document;
item.Activate();
item.Show(item.Workspaces["main"]);
}
}
