public override IVystup GetSelectOnTableData()
{
string s = "select id_lampy, id_sluzby, to_char(datum, 'dd.mm.yyyy'), nvl(popis,''), trvanie, cena from s_obsluha_lampy join s_sluzba using (id_sluzby) join s_servis using (id_sluzby) order by id_sluzby desc";
var select = new VystupSelect(s,
"id_lampy", "id_sluzby", "datum", "popis", "trvanie", "cena");
select.KlucovyStlpec = "ID_SLUZBY";
return(select);
}
public override IVystup GetSelectOnTableData()
{
var s = "select cislo, id_sluzby, to_char(datum, 'dd.mm.yyyy'), nvl(popis,''), trvanie, stav from s_obsluha_stlpu join s_sluzba using (id_sluzby) join s_kontrola using (id_sluzby) order by id_sluzby desc";
var select = new VystupSelect(s,
"cislo", "id_sluzby", "datum", "popis", "trvanie", "stav");
select.KlucovyStlpec = "ID_SLUZBY";
return(select);
}
public virtual IVystup GetSelectOnTableData()
{
var atribut = SqlClassAttribute.ExtractSqlClassAttribute(this);
var stlpce = string.Join(", ", this.GetType().GetProperties()
.Where(p => SqlClassAttribute.ExtractSqlClassAttribute(p)?.IsColumn == true &&
SqlClassAttribute.ExtractSqlClassAttribute(p)?.IsReference == false)
.Select(p => SqlClassAttribute.ExtractSqlClassAttribute(p)?.ColumnName));
var select = $"select distinct {stlpce} from {atribut.TableName}";// a0 {string.Join(" ", tabulky.Select(t => $"join {t} a{++poradieAlias} on(a0.{atribut.TableKey} = a{poradieTab}.{kluce[poradieTab]})"))}";
var vystup = new VystupSelect(select)
{
KlucovyStlpec = atribut.TableKey
};
return(vystup);
}
public override bool SelectPodlaId(object paIdEntity)
{
string s = "select cislo, rodne_cislo, id_sluzby, to_char(datum, 'dd.mm.yyyy hh24:mi'), nvl(popis,''), trvanie, cena from s_obsluha_stlpu join s_sluzba using (id_sluzby) join s_servis using (id_sluzby) where id_sluzby = " + paIdEntity;
var select = new VystupSelect(s,
"cislo", "rodne_cislo", "id_sluzby", "datum", "popis", "trvanie", "cena");
select.SpustiVystup();
foreach (var row in select.Rows)
{
Cislo = int.Parse(row[0].ToString());
RodneCislo = row[1].ToString();
IdSluzby = int.Parse(row[2].ToString());
Datum = DateTime.Parse(row[3].ToString());
Popis = row[4].ToString();
Trvanie = int.Parse(row[5].ToString());
Cena = int.Parse(row[6].ToString());
return(true);
}
return(false);
}
public override bool SelectPodlaId(object paIdEntity)
{
string s = "select id_lampy, rodne_cislo, id_sluzby, to_char(datum, 'dd.mm.yyyy hh24:mi'), nvl(popis,''), trvanie, stav, nvl(svietivost, 0) from s_obsluha_lampy join s_sluzba using (id_sluzby) join s_kontrola using (id_sluzby) where id_sluzby = " + paIdEntity;
var select = new VystupSelect(s,
"id_lampy", "rodne_cislo", "id_sluzby", "datum", "popis", "trvanie", "stav", "svietivost");
select.SpustiVystup();
foreach (var row in select.Rows)
{
IdLampy = int.Parse(row[0].ToString());
RodneCislo = row[1].ToString();
IdSluzby = int.Parse(row[2].ToString());
Datum = DateTime.Parse(row[3].ToString());
Popis = row[4].ToString();
Trvanie = int.Parse(row[5].ToString());
Stav = row[6].ToString()[0];//.ToCharArray()[0];
Svietivost = int.Parse(row[7].ToString());
return(true);
}
return(false);
}
public override bool SelectPodlaId(object paIdEntity)
{
var s = "select cislo, rodne_cislo, id_sluzby, to_char(datum, 'dd.mm.yyyy'), nvl(popis,''), trvanie, stav from s_obsluha_stlpu join s_sluzba using (id_sluzby) join s_kontrola using (id_sluzby) where id_sluzby = " + paIdEntity;
var select = new VystupSelect(s,
"cislo", "rodne_cislo", "id_sluzby", "datum", "popis", "trvanie", "stav");
select.SpustiVystup();
foreach (var row in select.Rows)
{
Cislo = int.Parse(row[0].ToString());
RodneCislo = row[1].ToString();
IdSluzby = int.Parse(row[2].ToString());
Datum = DateTime.Parse(row[3].ToString());
Popis = row[4].ToString();
Trvanie = int.Parse(row[5].ToString());
Stav = row[6].ToString()[0];//.ToArray()[0];
return(true);
}
//using (var enumerator = select.Rows.GetEnumerator())
//{
// if (enumerator.MoveNext())
// {
// Cislo = int.Parse(enumerator.Current[0].ToString());
// RodneCislo =
// IdSluzby = int.Parse(enumerator.Current[1].ToString());
// Datum = enumerator.Current[2].ToString();
// Popis = enumerator.Current[3].ToString();
// Trvanie = int.Parse(enumerator.Current[4].ToString());
// Stav = enumerator.Current[5].ToString().ToArray()[0];
// return true;
// }
//}
return(false);
}
public override bool SelectPodlaId(object paIdEntity)
{
string s = "select id_lampy, rodne_cislo, id_sluzby, to_char(datum, 'dd.mm.yyyy'), nvl(popis,''), trvanie, stav, nvl(svietivost, 0) from s_obsluha_lampy join s_sluzba using (id_sluzby) join s_kontrola using (id_sluzby) where rodne_cislo = " + paIdEntity + " order by datum";
var select = new VystupSelect(s,
"id_lampy", "rodne_cislo", "id_sluzby", "datum", "popis", "trvanie", "stav", "svietivost");
select.SpustiVystup();
foreach (var row in select.Rows)
{
KontrolyLamp.AddFirst(new SKontrolaLampy()
{
IdLampy = int.Parse(row[0].ToString()),
RodneCislo = row[1].ToString(),
IdSluzby = int.Parse(row[2].ToString()),
Datum = DateTime.Parse(row[3].ToString()),
Popis = row[4].ToString(),
Trvanie = int.Parse(row[5].ToString()),
Stav = row[6].ToString()[0],
Svietivost = int.Parse(row[7].ToString())
});
}
s = "select cislo, rodne_cislo, id_sluzby, to_char(datum, 'dd.mm.yyyy'), nvl(popis,''), trvanie, stav from s_obsluha_stlpu join s_sluzba using (id_sluzby) join s_kontrola using (id_sluzby) where rodne_cislo = " + paIdEntity + " order by datum";
select = new VystupSelect(s,
"cislo", "rodne_cislo", "id_sluzby", "datum", "popis", "trvanie", "stav");
select.SpustiVystup();
foreach (var row in select.Rows)
{
KontrolyStlpov.AddFirst(new SKontrolaStlpu()
{
Cislo = int.Parse(row[0].ToString()),
RodneCislo = row[1].ToString(),
IdSluzby = int.Parse(row[2].ToString()),
Datum = DateTime.Parse(row[3].ToString()),
Popis = row[4].ToString(),
Trvanie = int.Parse(row[5].ToString()),
Stav = row[6].ToString()[0]
});
}
s = "select id_lampy, id_sluzby, rodne_cislo, to_char(datum, 'dd.MM.yyyy'), nvl(popis,''), trvanie, cena from s_obsluha_lampy join s_sluzba using (id_sluzby) join s_servis using (id_sluzby) where rodne_cislo = " + paIdEntity + " order by datum";
select = new VystupSelect(s,
"id_lampy", "id_sluzby", "rodne_cislo", "datum", "popis", "trvanie", "cena");
select.SpustiVystup();
foreach (var row in select.Rows)
{
ServisLamp.AddFirst(new SServisLampy()
{
IdLampy = int.Parse(row[0].ToString()),
IdSluzby = int.Parse(row[1].ToString()),
RodneCislo = row[2].ToString(),
Datum = DateTime.Parse(row[3].ToString()),
Popis = row[4].ToString(),
Trvanie = int.Parse(row[5].ToString()),
Cena = int.Parse(row[6].ToString())
});
}
s = "select cislo, rodne_cislo, id_sluzby, to_char(datum, 'dd.mm.yyyy hh24:mi'), nvl(popis,''), trvanie, cena from s_obsluha_stlpu join s_sluzba using (id_sluzby) join s_servis using (id_sluzby) where rodne_cislo = " + paIdEntity + " order by datum";
select = new VystupSelect(s,
"cislo", "rodne_cislo", "id_sluzby", "datum", "popis", "trvanie", "cena");
select.SpustiVystup();
foreach (var row in select.Rows)
{
ServisStlpov.AddFirst(new SServisStlpu()
{
Cislo = int.Parse(row[0].ToString()),
RodneCislo = row[1].ToString(),
IdSluzby = int.Parse(row[2].ToString()),
Datum = DateTime.Parse(row[3].ToString()),
Popis = row[4].ToString(),
Trvanie = int.Parse(row[5].ToString()),
Cena = int.Parse(row[6].ToString())
});
}
return(true);
}
public bool SelectPodlaId(object paIdEntity)
{
//SStlp.SelectPodlaId(paIdEntity);
var select =
$"select sd.ID, sd.TYP_DOPLNKU, sd.POPIS, to_char(sd.DATUM_INSTALACIE, 'dd.MM.yyyy') as DATUM_INSTALACIE, to_char(sd.DATUM_DEMONTAZE, 'DD.MM.YYYY') as DATUM_DEMONTAZE from s_stlp s, table(s.doplnky) sd where s.cislo = {SStlp.Cislo}";
var rows = Databaza.SpecialSelect(select);
foreach (var row in rows)
{
var doplnok = new TDoplnok
{
Id = int.Parse(row["ID"].ToString()),
Popis = row["POPIS"].ToString(),
DatumDemontaze = row["DATUM_DEMONTAZE"].ToString(),
DatumInstalacie = DateTime.Parse(row["DATUM_INSTALACIE"].ToString()),//row["DATUM_INSTALACIE"].ToString(),
TypDoplnku = row["TYP_DOPLNKU"].ToString()[0],
Cislo = SStlp.Cislo
};
Doplnky.AddLast(doplnok);
}
var selectInfo = $"select * from s_info where cislo = {SStlp.Cislo}";
var informacie = Databaza.SpecialSelect(selectInfo);
foreach (var informacia in informacie)
{
var info = new SInfo
{
Id = int.Parse(informacia["ID"].ToString()),
Cislo = int.Parse(informacia["CISLO"].ToString()),
Data = (byte[])informacia["DATA"],
Typ = informacia["TYP"].ToString()[0]
};
DateTime d;
info.Datum = DateTime.TryParse(informacia["DATUM"].ToString(), out d) ? d.ToString("dd.MM.yyyy") : string.Empty;
SInformacie.AddLast(info);
}
var selectLampy = $"select * from s_lampa_na_stlpe where cislo = {SStlp.Cislo} order by datum_demontaze desc";
var lampy = Databaza.SpecialSelect(selectLampy);
foreach (var lampaNaStlpe in lampy)
{
var lampa = new SLampaNaStlpe()
{
IdLampy = int.Parse(lampaNaStlpe["ID_LAMPY"].ToString()),
Cislo = int.Parse(lampaNaStlpe["CISLO"].ToString()),
IdTypu = int.Parse(lampaNaStlpe["ID_TYPU"].ToString()),
Stav = lampaNaStlpe["STAV"].ToString()[0],
DatumInstalacie = DateTime.Parse(lampaNaStlpe["DATUM_INSTALACIE"].ToString())//.ToString("dd.MM.yyyy"),
};
DateTime dod;
lampa.DatumDemontaze = DateTime.TryParse(lampaNaStlpe["DATUM_DEMONTAZE"].ToString(), out dod) ? dod.ToString("dd.MM.yyyy") : string.Empty;
if (lampa.Stav == 'S' && lampa.DatumDemontaze == String.Empty)
{
var s = $"select svietivost_lampy({lampa.IdLampy}) from dual ";
var svietSelect = new VystupSelect(s, "svietivost");
svietSelect.SpustiVystup();;
foreach (var row in svietSelect.Rows)
{
lampa.Svietivost = int.Parse(row[0].ToString());
}
}
SLampyNaStlpe.AddLast(lampa);
}
return(true);
}
