Esempio n. 1
0
 public override IDictionary <string, QueryDefInfo> CreateQueryDictionary()
 {
     return(new Dictionary <string, QueryDefInfo>()
     {
         { QueryKrokujPracPocitanyInfo.GetNameKey(), QueryKrokujPracPocitanyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryKrokujPracovnikyInfo.GetNameKey(), QueryKrokujPracovnikyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPracZarazeniInfo.GetNameKey(), QueryVyberPracZarazeniInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPPomZarazeniInfo.GetNameKey(), QueryVyberPPomZarazeniInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPracOpravneniInfo.GetNameKey(), QueryVyberPracOpravneniInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPracovnikyFiltrXOInfo.GetNameKey(), QueryVyberPracovnikyFiltrXOInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPracovnikyFiltrXPInfo.GetNameKey(), QueryVyberPracovnikyFiltrXPInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPracovnikyFiltrXZInfo.GetNameKey(), QueryVyberPracovnikyFiltrXZInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPracovnikyFiltrZPInfo.GetNameKey(), QueryVyberPracovnikyFiltrZPInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPracPocitanyInfo.GetNameKey(), QueryVyberPracPocitanyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPracovnikyInfo.GetNameKey(), QueryVyberPracovnikyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberUtvaryInfo.GetNameKey(), QueryVyberUtvaryInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberSestavyInfo.GetNameKey(), QueryVyberSestavyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberSbMediaInfo.GetNameKey(), QueryVyberSbMediaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberPlMediaInfo.GetNameKey(), QueryVyberPlMediaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberUcMediaInfo.GetNameKey(), QueryVyberUcMediaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberUcetPrPolozkyInfo.GetNameKey(), QueryVyberUcetPrPolozkyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryHodnExtMListInfo.GetNameKey(), QueryHodnExtMListInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryCelkExtMListInfo.GetNameKey(), QueryCelkExtMListInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryHodnVyuctFinInfo.GetNameKey(), QueryHodnVyuctFinInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryCelkVyuctFinInfo.GetNameKey(), QueryCelkVyuctFinInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QuerySocialInfo.GetNameKey(), QuerySocialInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QuerySumaDanInfo.GetNameKey(), QuerySumaDanInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyplListkySortInfo.GetNameKey(), QueryVyplListkySortInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryMzvIIsspPredpisyInfo.GetNameKey(), QueryMzvIIsspPredpisyInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberReldp09DavkaInfo.GetNameKey(), QueryVyberReldp09DavkaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberReldp09DataInfo.GetNameKey(), QueryVyberReldp09DataInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberReldpDavkaInfo.GetNameKey(), QueryVyberReldpDavkaInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
         { QueryVyberReldpDataInfo.GetNameKey(), QueryVyberReldpDataInfo.GetDictValue(m_strOwnerName, m_strUsersName) },
     });
 }
        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")
                         ));
        }