public void Run(IHelios Helios)
{
Int32 ID = Helios.CurrentRecordID();
Int32 IDB = Helios.BrowseID();
//Zobrazí první připojený dokument na základě tabulky miniautoskenu
String SQL = "SELECT TOP 1 D.JmenoACesta FROM TabDokumenty AS D INNER JOIN TabDokumVazba AS DV ON DV.IdDok = D.ID INNER JOIN BKO_mini_autoscan_settings AS MAS ON MAS.IdentVazby = DV.IdentVazby WHERE MAS.CisloPrehledu = " + IDB + " AND DV.IdTab = " + ID;
IHeQuery Soubor = Helios.OpenSQL(SQL);
if (Soubor.RecordCount() == 1)
{
System.Diagnostics.Process.Start((String)(Soubor.FieldValues(0)));
}
}
public DochazkaUprava(DateTime Datum, String Stredisko, String Zakazka, String Cinnost, Double Hodiny, IHelios HeliosHandler)
{
_datum = Datum;
_stredisko = Stredisko;
_zakazka = Zakazka;
_cinnost = Cinnost;
_hodiny = Hodiny;
String SQL = "SELECT KD.Datum_D FROM TabMzKalendar AS K INNER JOIN TabMzKalendarDny AS KD ON KD.IDKalendar = K.ID WHERE K.Cislo = '001' AND KD.Svatek = 1 AND KD.Datum_Y = " + Datum.Year + " AND KD.Datum_M = " + Datum.Month + " AND KD.Datum_D = " + Datum.Day;
IHeQuery JeSvatek = HeliosHandler.OpenSQL(SQL);
if (JeSvatek.RecordCount() == 0)
_svatek = false;
else
_svatek = true;
SQL = "SELECT Cislo FROM TabEGDochazkaCinnosti WHERE Cislo = '" + Cinnost + "'";
IHeQuery JePrace = HeliosHandler.OpenSQL(SQL);
if (JePrace.RecordCount() == 0)
_prace = true;
else
_prace = false;
}