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 QueryVyberPracovnikyFiltrZPInfo(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", "opr_mesic"),
                         SimpleName.Create("uzivjmeno"),
                         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")
                         ));

            AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("ZAR", QueryVyberPracZarazeniInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()).
                     AddColumns(
                         AliasName.Create("mesic", "zar_mesic"),
                         SimpleName.Create("nazev_utvar"),
                         SimpleName.Create("cislo_zeme"),
                         SimpleName.Create("cislo_utvar"),
                         SimpleName.Create("cislo_zdrpoj"),
                         SimpleName.Create("cislo_zdroj"),
                         SimpleName.Create("cislo_stred"),
                         SimpleName.Create("cislo_cinnost"),
                         SimpleName.Create("cislo_zakazka")
                         ));

            AddTable(QueryTableDefInfo.GetQueryAliasDefInfo("PPZ", QueryVyberPPomZarazeniInfo.GetDictValue(lpszOwnerName, lpszUsersName).GetTableDef()).
                     AddColumns(
                         SimpleName.Create("ppomer_zdroj"),
                         SimpleName.Create("ppomer_stred"),
                         SimpleName.Create("ppomer_cinnost"),
                         SimpleName.Create("ppomer_zakazka")
                         ));

            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"));

            AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("PPOMER", "ZAR").
                         AddColumn("firma_id", "firma_id").
                         AddColumn("pracovnik_id", "pracovnik_id"));

            AddTableJoin(QueryJoinDefInfo.GetQueryJoinDefInfo("PPOMER", "PPZ").
                         AddColumn("firma_id", "firma_id").
                         AddColumn("pracovnik_id", "pracovnik_id").
                         AddColumn("cislo_pp", "cislo_pp").
                         AddRightColumn("mesic", "=", "ZAR.mesic"));
        }