public QueryKrokujPracPocitanyInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PRAC", TablePracVyberAggrInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pracovnik_id"), SimpleName.Create("logicky_zrusen"), SimpleName.Create("logicky_neuplny"), SimpleName.Create("pocitane_obdobi"), SimpleName.Create("osobni_cislo"), SimpleName.Create("datum_narozeni"), SimpleName.Create("rodne_cislo"), SimpleName.Create("prijmeni"), SimpleName.Create("jmeno"), SimpleName.Create("titul_pred"), SimpleName.Create("titul_za"), AliasName.Create("zar_mesic", "mesic"), SimpleName.Create("vyuct_cast") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uutvar_id"), SimpleName.Create("utvnazev"), SimpleName.Create("vyuctgr"), SimpleName.Create("zeme_cislo"), SimpleName.Create("uzivatel_id") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("PRAC", "UTVAR"). AddColumn("firma_id", "firma_id"). AddColumn("uutvar_id", "uutvar_id")); }
public QueryMzvIIsspPredpisyInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MP", TableMzvIisspPredpisyInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("uzivatel_id"), SimpleName.Create("vtrideni"), SimpleName.Create("davka_id"), SimpleName.Create("rok"), SimpleName.Create("mesic"), SimpleName.Create("vyuct_cast"), SimpleName.Create("mena"), SimpleName.Create("castkakc"), SimpleName.Create("castka_mena"), SimpleName.Create("kurz_mena"), SimpleName.Create("datum_kurz"), SimpleName.Create("datum_vypl"), SimpleName.Create("datum_exp"), SimpleName.Create("id_koruny"), SimpleName.Create("id_syntet"), SimpleName.Create("id_paragraf"), SimpleName.Create("id_polozka"), SimpleName.Create("id_analyt"), SimpleName.Create("stredisko"), SimpleName.Create("popis_koruny") )); }
public QueryVyberUtvaryInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("uutvar_id"), SimpleName.Create("utvnazev"), SimpleName.Create("poznamka"), SimpleName.Create("zeme_cislo"), SimpleName.Create("vyuctgr") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UZIVATEL", TableUzivatelInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uuzivatel_id"), SimpleName.Create("uzivjmeno"), SimpleName.Create("uzivfunkce"), SimpleName.Create("uplne_jmeno") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UTVAR", "UZIVATEL"). AddColumn("firma_id", "firma_id"). AddColumn("uzivatel_id", "uuzivatel_id")); }
public QueryVyberPlMediaInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PM", TablePlatebniMediumInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pmedium_id"), SimpleName.Create("info_medium"), SimpleName.Create("nazev_klienta"), SimpleName.Create("soubor_start"), SimpleName.Create("soubor_stop"), SimpleName.Create("soubor_next"), SimpleName.Create("datum_predani"), SimpleName.Create("pol_cis1"), SimpleName.Create("pol_cis2"), SimpleName.Create("pol_cis3"), SimpleName.Create("pol_txt1"), SimpleName.Create("pol_txt2"), SimpleName.Create("pol_txt3"), SimpleName.Create("soub_cis1"), SimpleName.Create("soub_cis2"), SimpleName.Create("soub_cis3"), SimpleName.Create("soub_txt1"), SimpleName.Create("soub_txt2"), SimpleName.Create("soub_txt3"), SimpleName.Create("mena"), SimpleName.Create("ustav"), SimpleName.Create("cislo_pobocky"), SimpleName.Create("prideleny_kod"), SimpleName.Create("banka_id") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SLST", TableSestavyLstInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("nazev"), SimpleName.Create("soubor"), SimpleName.Create("trideni"), SimpleName.Create("kod_lst"), SimpleName.Create("kod_data") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ULST", TableSestavyUlstInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uzivatel_id"), SimpleName.Create("sestavy_id"), SimpleName.Create("exp_cesta") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("PM", "SLST"). AddColumn("firma_id", "firma_id"). AddColumn("pmedium_id", "subjekt_id"). AddRightColumn("typ_lst", "=", "3")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("SLST", "ULST"). AddColumn("firma_id", "firma_id"). AddColumn("kod_lst", "kod_lst")); }
public QueryVyberPracOpravneniInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("DAN_UTVAR", TableDanInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pracovnik_id"), SimpleName.Create("mesic"), AliasName.Create("informace", "vyuct_cast") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("vyuctgr"), SimpleName.Create("uutvar_id"), AliasName.Create("utvnazev", "nazev_utvar"), AliasName.Create("zeme_cislo", "cislo_zeme"), SimpleName.Create("uzivatel_id"), SimpleName.Create("personal_id"), SimpleName.Create("prohlizet_id"), SimpleName.Create("omezproh_id"), SimpleName.Create("referzp_id") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UPRES", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( AliasName.Create("uutvar_id", "uupres_id"), AliasName.Create("utvnazev", "nazev_upres"), AliasName.Create("uzivatel_id", "uziv_pres"), AliasName.Create("personal_id", "pers_pres"), AliasName.Create("prohlizet_id", "proh_pres"), AliasName.Create("omezproh_id", "omez_pres"), AliasName.Create("referzp_id", "refz_pres") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UZIVATEL", TableUzivatelInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uzivjmeno") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("DAN_UTVAR", "UTVAR"). AddColumn("firma_id", "firma_id"). AddColumn("sazba", "uutvar_id"). AddLeftColumn("odkud", "=", "0"). AddLeftColumn("kod", "=", "6100"). AddLeftColumn("cislo", "=", "1")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("DAN_UTVAR", "UPRES"). AddColumn("firma_id", "firma_id"). AddColumn("hodnota", "uutvar_id")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("UTVAR", "UZIVATEL"). AddColumn("firma_id", "firma_id"). AddColumn("uzivatel_id", "uuzivatel_id")); }
public QuerySocialInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PRAC", TableZsestSocialInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), AliasName.Create("druh_cinnosti", "max_vymzakl"), AliasName.Create("zap_prijem", "sum_prijem"), AliasName.Create("pojist_org", "pojsum_org"), AliasName.Create("pojistne_zam", "pojsum_zam") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PPOM", TableZsestSocialInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uzivatel_id"), SimpleName.Create("kod_data"), SimpleName.Create("pracovnik_id"), SimpleName.Create("cislo_pp"), SimpleName.Create("socsprava_id"), SimpleName.Create("info_org"), SimpleName.Create("uplne_jmeno"), SimpleName.Create("rodne_cislo"), SimpleName.Create("ucast_poj"), SimpleName.Create("ppom_stav"), SimpleName.Create("koef_poj"), SimpleName.Create("druh_cinnosti"), SimpleName.Create("zap_prijem"), SimpleName.Create("pojist_org"), SimpleName.Create("pojistne_zam"), SimpleName.Create("vyl_doby"), SimpleName.Create("absence"), SimpleName.Create("nemoc_dny"), SimpleName.Create("nemoc_kc"), SimpleName.Create("osetrovani_dny"), SimpleName.Create("osetrovani_kc"), SimpleName.Create("materstvi_kc"), SimpleName.Create("materstvi_n"), SimpleName.Create("vyrovnani_n"), SimpleName.Create("vyrovnani_kc"), SimpleName.Create("davka_e_kod"), SimpleName.Create("davka_e_kc"), SimpleName.Create("davka_f_kod"), SimpleName.Create("davka_f_kc") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("PRAC", "PPOM"). AddColumn("firma_id", "firma_id"). AddColumn("uzivatel_id", "uzivatel_id"). AddColumn("kod_data", "kod_data"). AddColumn("pracovnik_id", "pracovnik_id"). AddColumn("socsprava_id", "socsprava_id"). AddLeftColumn("cislo_pp", "=", "0"). AddRightColumn("cislo_pp", "<>", "0")); }
public QueryVyberUcetPrPolozkyInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UCPREDP", TableUcetniPredpisyInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), AliasName.Create("ppredpis_id", "predpis_id"), SimpleName.Create("predpis_uckod"), SimpleName.Create("predpis_nazev"), SimpleName.Create("predpis_druh") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UCPOLOZ", TableUcetniPolozkyInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("cislo"), SimpleName.Create("poloz_nazev"), SimpleName.Create("poloz_druh"), SimpleName.Create("poloz_skup"), SimpleName.Create("poloz_synt"), SimpleName.Create("poloz_anal"), SimpleName.Create("poloz_text1"), SimpleName.Create("poloz_inf1"), SimpleName.Create("poloz_delka1"), SimpleName.Create("poloz_fmt1"), SimpleName.Create("poloz_text2"), SimpleName.Create("poloz_inf2"), SimpleName.Create("poloz_delka2"), SimpleName.Create("poloz_fmt2"), SimpleName.Create("poloz_text3"), SimpleName.Create("poloz_inf3"), SimpleName.Create("poloz_delka3"), SimpleName.Create("poloz_fmt3"), SimpleName.Create("poloz_text4"), SimpleName.Create("poloz_inf4"), SimpleName.Create("poloz_delka4"), SimpleName.Create("poloz_fmt4"), SimpleName.Create("poloz_text5"), SimpleName.Create("poloz_inf5"), SimpleName.Create("poloz_delka5"), SimpleName.Create("poloz_fmt5") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UCPREDP", "UCPOLOZ"). AddColumn("firma_id", "firma_id"). AddColumn("ppredpis_id", "predpis_id")); }
public QuerySumaDanInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("DAN", TableDanInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("mesic"), SimpleName.Create("odkud"), SimpleName.Create("kod"), AliasName.Create("hodnota", "hodnota", "SUM({0})"), AliasName.Create("pocjed", "pocjed", "SUM({0})"), AliasName.Create("pocdal", "pocdal", "SUM({0})"), AliasName.Create("sazba", "sazba", "SUM({0})") )); AddClause("GROUP BY firma_id, mesic, odkud, kod"); }
public QueryCelkVyuctFinInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("VFIN", TableZsestPrehvyuctfinInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("kod_data"), SimpleName.Create("uzivatel_id"), SimpleName.Create("kod"), AliasName.Create("hodnota_numb", "hodnota_numb", "SUM({0})") )); AddFiltr(QueryWhereDefInfo.GetQueryWhereDefInfo("VFIN", TableZsestPrehvyuctfinInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddConstraints( QueryFilterDefInfo.Create("mesic", "<>", "0"), QueryFilterDefInfo.Create("poradi", "=", "0") )); AddClause("GROUP BY firma_id, kod_data, uzivatel_id, kod"); }
public QueryVyberPracZarazeniInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MDAN_UTVAR", TableDanInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pracovnik_id"), SimpleName.Create("mesic"), AliasName.Create("sazba", "cislo_utvar"), AliasName.Create("pocjed", "cislo_zdrpoj") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MDAN_STRCZ", TableDanInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("cislo_zdroj"), SimpleName.Create("cislo_stred"), SimpleName.Create("cislo_cinnost"), SimpleName.Create("cislo_zakazka") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MUTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( AliasName.Create("utvnazev", "nazev_utvar"), AliasName.Create("zeme_cislo", "cislo_zeme") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("MDAN_UTVAR", "MDAN_STRCZ"). AddColumn("firma_id", "firma_id"). AddColumn("pracovnik_id", "pracovnik_id"). AddColumn("mesic", "mesic"). AddRightColumn("odkud", "=", "0"). AddRightColumn("kod", "=", "6100"). AddRightColumn("cislo", "=", "1"). AddLeftColumn("odkud", "=", "0"). AddLeftColumn("kod", "=", "6101"). AddLeftColumn("cislo", "=", "1")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("MDAN_UTVAR", "MUTVAR"). AddColumn("firma_id", "firma_id"). AddColumn("sazba", "uutvar_id")); }
public QueryCelkExtMListInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("EXTML", TableZsestExtMzdlistInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("kod_data"), SimpleName.Create("uzivatel_id"), SimpleName.Create("pracovnik_id"), SimpleName.Create("pomer_id"), SimpleName.Create("mesic_opr"), SimpleName.Create("kod"), SimpleName.Create("hodnota_numb", "SUM({0})"))); AddFiltr(QueryWhereDefInfo.GetQueryWhereDefInfo("EXTML", TableZsestExtMzdlistInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddConstraints( QueryFilterDefInfo.Create("mesic", "<>", "0"), QueryFilterDefInfo.Create("poradi", "=", "0"))); AddClause("GROUP BY firma_id, kod_data, uzivatel_id, pracovnik_id, pomer_id, mesic_opr, kod"); }
public QueryVyplListkySortInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ZSEST_VYPL_LISTKY", TableZsestVyplListkyInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("uzivatel_id"), SimpleName.Create("pracovnik_id"), SimpleName.Create("vlist_info"), SimpleName.Create("radek"), SimpleName.Create("typ"), SimpleName.Create("radtext"), SimpleName.Create("engtext") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("LISTKYP", TableZsestVyplListkyInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( AliasName.Create("typ", "typ_pr"), AliasName.Create("radtext", "text_pr") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("LISTKYU", TableZsestVyplListkyInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( AliasName.Create("typ", "typ_ut"), AliasName.Create("radtext", "text_ut") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("ZSEST_VYPL_LISTKY", "LISTKYP"). AddColumn("firma_id", "firma_id"). AddColumn("uzivatel_id", "uzivatel_id"). AddColumn("pracovnik_id", "pracovnik_id"). AddRightColumn("typ", "=", "2")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("ZSEST_VYPL_LISTKY", "LISTKYU"). AddColumn("firma_id", "firma_id"). AddColumn("uzivatel_id", "uzivatel_id"). AddColumn("pracovnik_id", "pracovnik_id"). AddRightColumn("typ", "=", "1")); }
public QueryVyberPPomZarazeniInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("MMZDA_STRCZ", TableMzdaInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pracovnik_id"), SimpleName.Create("cislo_pp"), SimpleName.Create("mesic"), AliasName.Create("cislo_zdroj", "ppomer_zdroj"), AliasName.Create("cislo_stred", "ppomer_stred"), AliasName.Create("cislo_cinnost", "ppomer_cinnost"), AliasName.Create("cislo_zakazka", "ppomer_zakazka") )); AddFiltr(QueryWhereDefInfo.GetQueryWhereDefInfo("MMZDA_STRCZ", TableZsestExtMzdlistInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddConstraints( QueryFilterDefInfo.Create("odkud", "=", "0"), QueryFilterDefInfo.Create("kod", "=", "6000"), QueryFilterDefInfo.Create("cislo", "=", "1") )); }
public QueryVyberReldp09DavkaInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UD", TableUzivReldpDavkaInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), AliasName.Create("ddavka_reldp_id", "davka_reldp_id"), SimpleName.Create("uzivatel_id"), AliasName.Create("vydano_dat", "vydano_dat", "MAX({0})"), AliasName.Create("info_davka", "info_davka", "MAX({0})") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PP", TablePracReldp09DataPracInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( AliasName.Create("eldp_rok", "eldp_rok", "MAX({0})") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UD", "PP"). AddColumn("firma_id", "firma_id"). AddColumn("ddavka_reldp_id", "davka_reldp_id"). AddColumn("uzivatel_id", "uzivatel_id")); AddClause("GROUP BY UD.firma_id, UD.ddavka_reldp_id, UD.uzivatel_id"); }
public QueryVyberSestavyInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SLST", TableSestavyLstInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("kod_lst"), SimpleName.Create("kod_data"), SimpleName.Create("druh"), SimpleName.Create("typ_lst"), SimpleName.Create("trideni"), SimpleName.Create("nazev"), SimpleName.Create("soubor"), SimpleName.Create("skupina"), SimpleName.Create("subjekt_id"), SimpleName.Create("informace") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UDATA", TableSestavyUdataInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("vytvor_vyuc"), SimpleName.Create("vyuct_dat"), SimpleName.Create("mesic_od"), SimpleName.Create("mesic_do"), SimpleName.Create("rok"), SimpleName.Create("vytvor_txt"), SimpleName.Create("vytvor_dat") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ULST", TableSestavyUlstInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("tisknout"), SimpleName.Create("sestavy_id"), SimpleName.Create("pg_margins"), SimpleName.Create("papir"), SimpleName.Create("tridit"), SimpleName.Create("exp_cesta"), SimpleName.Create("lst_param"), SimpleName.Create("txt_param"), SimpleName.Create("msg_param"), SimpleName.Create("filtr_zobr") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UZ", TableUzivatelInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uuzivatel_id"), AliasName.Create("sestavy_id", "usestavy_id") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("SLST", "UDATA"). AddColumn("firma_id", "firma_id"). AddColumn("kod_data", "kod_data")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("SLST", "ULST"). AddColumn("firma_id", "firma_id"). AddColumn("kod_lst", "kod_lst"). AddRightColumn("uzivatel_id", "=", "UDATA.uzivatel_id")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("ULST", "UZ"). AddColumn("firma_id", "firma_id"). AddColumn("uzivatel_id", "uuzivatel_id")); }
public QueryVyberReldp09DataInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UD", TableUzivReldpDavkaInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("ddavka_reldp_id"), SimpleName.Create("uzivatel_id"), SimpleName.Create("vydano_dat"), SimpleName.Create("info_davka") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("EPRAC", TablePracReldp09DataPracInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("pracovnik_id"), SimpleName.Create("sprava_id"), SimpleName.Create("eldp_rok"), SimpleName.Create("eldp_oprava"), SimpleName.Create("prijmeni"), SimpleName.Create("jmeno"), SimpleName.Create("titul"), SimpleName.Create("rodne_prijmeni"), SimpleName.Create("datum_narozeni"), SimpleName.Create("rodne_cislo"), SimpleName.Create("ulice"), SimpleName.Create("cislo_domu"), SimpleName.Create("obec"), SimpleName.Create("posta"), SimpleName.Create("psc"), SimpleName.Create("stat"), SimpleName.Create("misto_narozeni") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("EPOJ", TablePracReldp09DataPojInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("pomer_id"), SimpleName.Create("eldp_typ"), SimpleName.Create("stranka"), SimpleName.Create("radek"), SimpleName.Create("kod"), SimpleName.Create("maly_rozsah"), SimpleName.Create("cinn_od"), SimpleName.Create("cinn_do"), SimpleName.Create("dny"), SimpleName.Create("vyd_cinn_od"), SimpleName.Create("s1"), SimpleName.Create("s2"), SimpleName.Create("s3"), SimpleName.Create("s4"), SimpleName.Create("s5"), SimpleName.Create("s6"), SimpleName.Create("s7"), SimpleName.Create("s8"), SimpleName.Create("s9"), SimpleName.Create("s10"), SimpleName.Create("s11"), SimpleName.Create("s12"), SimpleName.Create("s1_12"), SimpleName.Create("vylouc_doby1"), SimpleName.Create("vymer_zaklad1"), SimpleName.Create("doby_odecet1"), SimpleName.Create("vylouc_doby2"), SimpleName.Create("vymer_zaklad2"), SimpleName.Create("doby_odecet2"), SimpleName.Create("vylouc_doby3"), SimpleName.Create("vymer_zaklad3"), SimpleName.Create("doby_odecet3"), SimpleName.Create("vylouc_doby4"), SimpleName.Create("vymer_zaklad4"), SimpleName.Create("doby_odecet4"), SimpleName.Create("vylouc_doby5"), SimpleName.Create("vymer_zaklad5"), SimpleName.Create("doby_odecet5"), SimpleName.Create("vylouc_doby6"), SimpleName.Create("vymer_zaklad6"), SimpleName.Create("doby_odecet6"), SimpleName.Create("vylouc_doby7"), SimpleName.Create("vymer_zaklad7"), SimpleName.Create("doby_odecet7"), SimpleName.Create("vylouc_doby8"), SimpleName.Create("vymer_zaklad8"), SimpleName.Create("doby_odecet8"), SimpleName.Create("vylouc_doby9"), SimpleName.Create("vymer_zaklad9"), SimpleName.Create("doby_odecet9"), SimpleName.Create("vylouc_doby10"), SimpleName.Create("vymer_zaklad10"), SimpleName.Create("doby_odecet10"), SimpleName.Create("vylouc_doby11"), SimpleName.Create("vymer_zaklad11"), SimpleName.Create("doby_odecet11"), SimpleName.Create("vylouc_doby12"), SimpleName.Create("vymer_zaklad12"), SimpleName.Create("doby_odecet12") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UD", "EPRAC"). AddColumn("firma_id", "firma_id"). AddColumn("ddavka_reldp_id", "davka_reldp_id"). AddColumn("uzivatel_id", "uzivatel_id")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("EPRAC", "EPOJ"). AddColumn("firma_id", "firma_id"). AddColumn("davka_reldp_id", "davka_reldp_id"). AddColumn("uzivatel_id", "uzivatel_id"). AddColumn("pracovnik_id", "pracovnik_id"). AddColumn("sprava_id", "sprava_id")); }
public QueryVyberReldpDataInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UD", TableUzivReldpDavkaInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("uzivatel_id"), SimpleName.Create("vydano_dat"), SimpleName.Create("neprijata"), SimpleName.Create("info_davka") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PL", TablePracReldpListekInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("pracovnik_id"), SimpleName.Create("davka_reldp_id"), SimpleName.Create("eldppgn"), SimpleName.Create("logicky_zrusen"), SimpleName.Create("info_eldp"), SimpleName.Create("eldprok"), SimpleName.Create("datum_narozeni"), SimpleName.Create("rodne_cislo"), SimpleName.Create("rodne_prijmeni"), SimpleName.Create("uplne_jmeno"), SimpleName.Create("misto_narozeni"), SimpleName.Create("posledni_prijmeni"), SimpleName.Create("adresa1_3"), SimpleName.Create("eldptyp"), SimpleName.Create("zacatek"), SimpleName.Create("eldpvydzedne"), SimpleName.Create("eldpoprzedne") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PD", TablePracReldpDataInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("listek_reldp_id"), SimpleName.Create("pomer_id"), SimpleName.Create("eldpkod"), SimpleName.Create("eldpod"), SimpleName.Create("eldpdo"), SimpleName.Create("eldppoj"), SimpleName.Create("eldpdnym01"), SimpleName.Create("eldpdnym02"), SimpleName.Create("eldpdnym03"), SimpleName.Create("eldpdnym04"), SimpleName.Create("eldpdnym05"), SimpleName.Create("eldpdnym06"), SimpleName.Create("eldpdnym07"), SimpleName.Create("eldpdnym08"), SimpleName.Create("eldpdnym09"), SimpleName.Create("eldpdnym10"), SimpleName.Create("eldpdnym11"), SimpleName.Create("eldpdnym12"), SimpleName.Create("zaklvym01"), SimpleName.Create("zaklvym02"), SimpleName.Create("zaklvym03"), SimpleName.Create("zaklvym04"), SimpleName.Create("zaklvym05"), SimpleName.Create("zaklvym06"), SimpleName.Create("zaklvym07"), SimpleName.Create("zaklvym08"), SimpleName.Create("zaklvym09"), SimpleName.Create("zaklvym10"), SimpleName.Create("zaklvym11"), SimpleName.Create("zaklvym12"), SimpleName.Create("eldpvcm") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UD", "PL"). AddColumn("firma_id", "firma_id"). AddColumn("ddavka_reldp_id", "davka_reldp_id")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("PL", "PD"). AddColumn("firma_id", "firma_id"). AddColumn("llistek_reldp_id", "listek_reldp_id"). AddColumn("eldpPgn", "eldpPgn")); }
public QueryVyberSbMediaInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SM", TableSberneMediumInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("smedium_id"), SimpleName.Create("info_medium"), SimpleName.Create("nazev_klienta"), SimpleName.Create("soubor_start"), SimpleName.Create("soubor_stop"), SimpleName.Create("soubor_next"), SimpleName.Create("soub_cis1"), SimpleName.Create("soub_cis2"), SimpleName.Create("soub_cis3"), SimpleName.Create("soub_txt1"), SimpleName.Create("soub_txt2"), SimpleName.Create("soub_txt3"), SimpleName.Create("datum_predani"), SimpleName.Create("datum_transakce"), SimpleName.Create("datum_splatnosti"), SimpleName.Create("datum_prevodu"), SimpleName.Create("datum_popprev"), SimpleName.Create("bezny_bkspoj_id"), SimpleName.Create("debet_bkspoj_id"), SimpleName.Create("cpopl_bkspoj_id"), SimpleName.Create("dpopl_bkspoj_id"), SimpleName.Create("par_kod_obr11"), SimpleName.Create("par_kod_obr32"), SimpleName.Create("crc"), SimpleName.Create("prior_prevodu"), SimpleName.Create("prior_popprev"), SimpleName.Create("cislo_klienta"), SimpleName.Create("telefon"), SimpleName.Create("ucet_dal"), SimpleName.Create("ucet_md"), SimpleName.Create("ucetni_zdr"), SimpleName.Create("ucetni_str"), SimpleName.Create("ucetni_zak"), SimpleName.Create("ucetni_cin"), SimpleName.Create("prijem_id") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SLST", TableSestavyLstInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("nazev"), SimpleName.Create("soubor"), SimpleName.Create("trideni"), SimpleName.Create("kod_lst"), SimpleName.Create("kod_data") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ULST", TableSestavyUlstInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uzivatel_id"), SimpleName.Create("sestavy_id"), SimpleName.Create("exp_cesta") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("SM", "SLST"). AddColumn("firma_id", "firma_id"). AddColumn("smedium_id", "subjekt_id"). AddRightColumn("typ_lst", "=", "2")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("SLST", "ULST"). AddColumn("firma_id", "firma_id"). AddColumn("kod_lst", "kod_lst")); }
public QueryVyberPracovnikyInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("VPFZ", QueryVyberPracovnikyFiltrZPInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pracovnik_id"), AliasName.Create("zar_mesic", "mesic"), SimpleName.Create("logicky_zrusen"), SimpleName.Create("logicky_neuplny"), SimpleName.Create("osobni_cislo"), SimpleName.Create("rodne_cislo"), SimpleName.Create("nema_rodcis"), SimpleName.Create("prijmeni"), SimpleName.Create("jmeno"), SimpleName.Create("titul_pred"), SimpleName.Create("titul_za"), SimpleName.Create("cislo_pp"), SimpleName.Create("pompopis"), SimpleName.Create("funkce"), SimpleName.Create("praczac"), SimpleName.Create("prackon"), SimpleName.Create("druh"), SimpleName.Create("druh07"), SimpleName.Create("uzivjmeno"), SimpleName.Create("nazev_utvar"), SimpleName.Create("cislo_zeme"), SimpleName.Create("datum_narozeni"), SimpleName.Create("pohlavi"), SimpleName.Create("ppomer_cislo"), SimpleName.Create("kzam"), SimpleName.Create("platova_trida"), SimpleName.Create("platovy_stupen"), SimpleName.Create("spraxe_roku"), SimpleName.Create("praxe_dnu"), SimpleName.Create("uzivatel_id"), SimpleName.Create("personal_id"), SimpleName.Create("prohlizet_id"), SimpleName.Create("omezproh_id"), SimpleName.Create("referzp_id"), SimpleName.Create("uziv_pres"), SimpleName.Create("pers_pres"), SimpleName.Create("proh_pres"), SimpleName.Create("omez_pres"), SimpleName.Create("refz_pres"), SimpleName.Create("uutvar_id"), SimpleName.Create("vyuctgr"), SimpleName.Create("vyuct_cast"), SimpleName.Create("uupres_id"), SimpleName.Create("nazev_upres"), SimpleName.Create("cislo_utvar"), SimpleName.Create("cislo_zdrpoj"), SimpleName.Create("cislo_zdroj"), SimpleName.Create("cislo_stred"), SimpleName.Create("cislo_cinnost"), SimpleName.Create("cislo_zakazka"), SimpleName.Create("ppomer_zdroj"), SimpleName.Create("ppomer_stred"), SimpleName.Create("ppomer_cinnost"), SimpleName.Create("ppomer_zakazka") )); AddFiltr(QueryWhereDefInfo.GetQueryWhereDefInfo("VPFZ", QueryVyberPracovnikyFiltrZPInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()). AddConstraints( QueryFilterDefInfo.Create("zar_mesic", "=", "opr_mesic") )); }
public QueryVyberPracPocitanyInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("VPFZ", TablePracVyberAggrInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("pracovnik_id"), AliasName.Create("zar_mesic", "mesic"), SimpleName.Create("zar_mesic"), SimpleName.Create("opr_mesic"), SimpleName.Create("logicky_zrusen"), SimpleName.Create("logicky_neuplny"), SimpleName.Create("osobni_cislo"), SimpleName.Create("rodne_cislo"), SimpleName.Create("nema_rodcis"), SimpleName.Create("prijmeni"), SimpleName.Create("jmeno"), SimpleName.Create("titul_pred"), SimpleName.Create("titul_za"), SimpleName.Create("cislo_pp"), SimpleName.Create("pompopis"), SimpleName.Create("funkce"), SimpleName.Create("praczac"), SimpleName.Create("prackon"), SimpleName.Create("druh"), SimpleName.Create("druh07"), SimpleName.Create("datum_narozeni"), SimpleName.Create("pohlavi"), SimpleName.Create("ppomer_cislo"), SimpleName.Create("kzam"), SimpleName.Create("platova_trida"), SimpleName.Create("platovy_stupen"), SimpleName.Create("spraxe_roku"), SimpleName.Create("praxe_dnu"), SimpleName.Create("cislo_zdrpoj"), SimpleName.Create("cislo_zdroj"), SimpleName.Create("cislo_stred"), SimpleName.Create("cislo_cinnost"), SimpleName.Create("cislo_zakazka"), SimpleName.Create("ppomer_zdroj"), SimpleName.Create("ppomer_stred"), SimpleName.Create("ppomer_cinnost"), SimpleName.Create("ppomer_zakazka"), SimpleName.Create("cislo_utvar"), SimpleName.Create("uutvar_id"), SimpleName.Create("vyuct_cast"), SimpleName.Create("uupres_id"))); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UTVAR", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( AliasName.Create("utvnazev", "nazev_utvar"), AliasName.Create("zeme_cislo", "cislo_zeme"), SimpleName.Create("uzivatel_id"), SimpleName.Create("personal_id"), SimpleName.Create("prohlizet_id"), SimpleName.Create("omezproh_id"), SimpleName.Create("referzp_id"))); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UPRES", TableUtvarInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( AliasName.Create("utvnazev", "nazev_upres"), AliasName.Create("uzivatel_id", "uziv_pres"), AliasName.Create("personal_id", "pers_pres"), AliasName.Create("prohlizet_id", "proh_pres"), AliasName.Create("omezproh_id", "omez_pres"), AliasName.Create("referzp_id", "refz_pres"))); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UZIVATEL", TableUzivatelInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uzivjmeno"))); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("VPFZ", "UTVAR"). AddColumn("firma_id", "firma_id"). AddColumn("cislo_utvar", "uutvar_id")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("VPFZ", "UPRES"). AddColumn("firma_id", "firma_id"). AddColumn("uupres_id", "uutvar_id")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("UTVAR", "UZIVATEL"). AddColumn("firma_id", "firma_id"). AddColumn("uzivatel_id", "uuzivatel_id")); }
public QueryVyberPracovnikyFiltrXOInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PRAC", TablePracInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), AliasName.Create("ppracovnik_id", "pracovnik_id"), SimpleName.Create("logicky_zrusen"), SimpleName.Create("logicky_neuplny"), SimpleName.Create("osobni_cislo"), SimpleName.Create("rodne_cislo"), SimpleName.Create("nema_rodcis"), SimpleName.Create("prijmeni"), SimpleName.Create("jmeno"), SimpleName.Create("titul_pred"), SimpleName.Create("titul_za"), SimpleName.Create("datum_narozeni"), SimpleName.Create("pohlavi") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PPOMER", TablePpomerInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("cislo_pp"), SimpleName.Create("pompopis"), SimpleName.Create("funkce"), SimpleName.Create("praczac"), SimpleName.Create("prackon"), SimpleName.Create("druh"), SimpleName.Create("druh07"), SimpleName.Create("ppomer_cislo"), SimpleName.Create("kzam"), SimpleName.Create("platova_trida"), SimpleName.Create("platovy_stupen"), SimpleName.Create("spraxe_roku"), SimpleName.Create("praxe_dnu") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("OPR", QueryVyberPracOpravneniInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()). AddColumns( AliasName.Create("mesic", "zar_mesic"), AliasName.Create("mesic", "opr_mesic"), SimpleName.Create("uzivjmeno"), SimpleName.Create("nazev_utvar"), SimpleName.Create("cislo_zeme"), SimpleName.Create("uzivatel_id"), SimpleName.Create("personal_id"), SimpleName.Create("prohlizet_id"), SimpleName.Create("omezproh_id"), SimpleName.Create("referzp_id"), SimpleName.Create("uziv_pres"), SimpleName.Create("pers_pres"), SimpleName.Create("proh_pres"), SimpleName.Create("omez_pres"), SimpleName.Create("refz_pres"), SimpleName.Create("uutvar_id"), SimpleName.Create("vyuctgr"), SimpleName.Create("vyuct_cast"), SimpleName.Create("uupres_id"), SimpleName.Create("nazev_upres") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("PRAC", "PPOMER"). AddColumn("firma_id", "firma_id"). AddColumn("ppracovnik_id", "pracovnik_id")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("PPOMER", "OPR"). AddColumn("firma_id", "firma_id"). AddColumn("pracovnik_id", "pracovnik_id")); }
public QueryVyberUcMediaInfo(string lpszOwnerName, string lpszUsersName) : base(lpszOwnerName, lpszUsersName, TABLE_NAME, 1600) { AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("UM", TableUcetniMediumInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("firma_id"), SimpleName.Create("umedium_id"), SimpleName.Create("info_medium"), SimpleName.Create("doklad_druh"), SimpleName.Create("soub_cis1"), SimpleName.Create("soub_cis2"), SimpleName.Create("soub_cis3"), SimpleName.Create("soub_txt1"), SimpleName.Create("soub_txt2"), SimpleName.Create("soub_txt3"), SimpleName.Create("doklad_cis1"), SimpleName.Create("doklad_cis2"), SimpleName.Create("doklad_cis3"), SimpleName.Create("doklad_txt1"), SimpleName.Create("doklad_txt2"), SimpleName.Create("doklad_txt3"), SimpleName.Create("ucto_klicmd"), SimpleName.Create("ucto_klicdal"), SimpleName.Create("znam_plus"), SimpleName.Create("znam_minus"), SimpleName.Create("domaci_mena"), SimpleName.Create("spoj_ucet_md"), SimpleName.Create("spoj_ucet_dal"), SimpleName.Create("bezny_ucet_md"), SimpleName.Create("bezny_ucet_dal"), SimpleName.Create("korekce_zdr"), SimpleName.Create("korekce_str"), SimpleName.Create("korekce_zak"), SimpleName.Create("korekce_cin") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("SLST", TableSestavyLstInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("nazev"), SimpleName.Create("soubor"), SimpleName.Create("trideni"), SimpleName.Create("kod_lst"), SimpleName.Create("kod_data") )); AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ULST", TableSestavyUlstInfo.GetDictValue(lpszOwnerName, lpszUsersName)). AddColumns( SimpleName.Create("uzivatel_id"), SimpleName.Create("sestavy_id"), SimpleName.Create("exp_cesta") )); AddTableJoin(QueryJoinDefInfo.GetQueryFirstJoinDefInfo("UM", "SLST"). AddColumn("firma_id", "firma_id"). AddColumn("umedium_id", "subjekt_id"). AddRightColumn("typ_lst", "=", "1")); AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("SLST", "ULST"). AddColumn("firma_id", "firma_id"). AddColumn("kod_lst", "kod_lst")); }