Beispiel #1
0
        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 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 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 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")
                         ));
        }