C# IDalSession.GetTypedListByNamedQuery方法代码示例

 public static IList<IModelComponent> GetModelComponentsLatestVersion(IDalSession session, int modelID)
 {
     Hashtable parameters = new Hashtable();
     parameters.Add("modelID", modelID);
     return session.GetTypedListByNamedQuery<IModelComponent>(
         "B4F.TotalGiro.Instruments.ModelComponent.GetModelComponentsLatestVersion",
         parameters);
 }

        public static IList<ILedgerType> GetLedgerEntryGroupings(IDalSession session, DateTime dateUntil)
        {
            string query = "B4F.TotalGiro.Communicator.Exact.LedgerEntry.GetLedgerEntryGroupings";

            Hashtable parameters = new Hashtable();
            parameters.Add("dateUntil", dateUntil);

            return session.GetTypedListByNamedQuery<ILedgerType>(query, parameters);
        }

        public static IList<IAverageHolding> GetAverageHoldings(IDalSession session, int[] averageHoldingIds)
        {
            Hashtable parameterLists = new Hashtable(1);
            parameterLists.Add("averageHoldingIds", averageHoldingIds);

            return session.GetTypedListByNamedQuery<IAverageHolding>(
                "B4F.TotalGiro.Valuations.AverageHoldings.GetAverageHoldings",
                new Hashtable(), parameterLists);
        }

 public static IList<IValuationCashMutation> GetValuationCashMutations(IDalSession session, int accountID, DateTime[] dates)
 {
     Hashtable parameters = new Hashtable(1);
     Hashtable parameterLists = new Hashtable(1);
     parameters.Add("accountID", accountID);
     parameterLists.Add("dates", dates);
     return session.GetTypedListByNamedQuery<IValuationCashMutation>(
         "B4F.TotalGiro.Valuations.GetValuationCashMutationDataByDates",
         parameters, parameterLists);
 }

 public static IList<ISecurityValuationMutation> GetSecurityValuationMutations(IDalSession session, int accountID, DateTime startDate, DateTime endDate)
 {
     Hashtable parameters = new Hashtable(1);
     parameters.Add("accountID", accountID);
     parameters.Add("startDate", startDate);
     parameters.Add("endDate", endDate);
     return session.GetTypedListByNamedQuery<ISecurityValuationMutation>(
         "B4F.TotalGiro.Valuations.GetSecurityValuationMutationData",
         parameters);
 }

 public static IList<IDepositWithdrawal> GetDepositsWithdrawals(IDalSession session, int accountID, DateTime startDate, DateTime endDate)
 {
     Hashtable parameters = new Hashtable(1);
     parameters.Add("accountID", accountID);
     parameters.Add("startDate", startDate);
     parameters.Add("endDate", endDate);
     return session.GetTypedListByNamedQuery<IDepositWithdrawal>(
         "B4F.TotalGiro.Valuations.GetDepositsWithdrawalData",
         parameters);
 }

 public static IList<IGLAccount> GetGLAccounts(IDalSession session, bool isFixed, bool showAllowedManualOnly)
 {
     Hashtable parameters = new Hashtable();
     parameters.Add("isFixed", isFixed);
     if (showAllowedManualOnly)
         parameters.Add("isAllowedManual", true);
     return session.GetTypedListByNamedQuery<IGLAccount>(
         "B4F.TotalGiro.GeneralLedger.Static.GetGLAccounts",
         parameters);
 }

        public static IList<ILedgerEntry> GetLedgerEntriesinFile(IDalSession session, int fileID)
        {
            string query = @"FROM LedgerEntry L
                             WHERE L.ExportedLedgerFile.Key = :fileID
                             ORDER BY L.BookingNumber";

            Hashtable parameters = new Hashtable();
            parameters.Add("fileID", fileID);

            return session.GetTypedListByNamedQuery<ILedgerEntry>(query, parameters);
        }

        public static IList<IJournalEntryLine> GetJournalEntriesToExport(IDalSession session, ExactEntryGrouping grouping)
        {
            string query = "B4F.TotalGiro.Communicator.Exact.SubledgerEntry.GetJournalEntriesToExport";

            Hashtable parameters = new Hashtable();
            parameters.Add("exactJournalID", grouping.Key);
            parameters.Add("transactionDate", grouping.TransactionDate);

            IList<IJournalEntryLine> lines = session.GetTypedListByNamedQuery<IJournalEntryLine>(query, parameters);
            return lines;
        }

 public static IList<IDividendHistory> GetDividendHistoryList(IDalSession session, int instrumentKey, DateTime startdate, DateTime endDate)
 {
     Hashtable parameters = new Hashtable();
     if (instrumentKey != 0 && instrumentKey != int.MinValue)
         parameters.Add("instrumentKey", instrumentKey);
     if (Util.IsNotNullDate(startdate))
         parameters.Add("startdate", startdate);
     if (Util.IsNotNullDate(endDate))
         parameters.Add("endDate", endDate);
     return session.GetTypedListByNamedQuery<IDividendHistory>(
         "B4F.TotalGiro.Instruments.CorporateAction.GetDividendHistories",
         parameters);
 }

        /// <summary>
        /// Get lifecycle by ID
        /// </summary>
        /// <param name="session">Data access object</param>
        /// <param name="assetManagerId">Identifier</param>
        /// <param name="activityFilter">Identifier</param>
        /// <returns>List of Lifecycle objects</returns>
        public static IList<ILifecycle> GetLifecycles(IDalSession session, int assetManagerId, ActivityReturnFilter activityFilter)
        {
            Hashtable parameters = new Hashtable();
            if (assetManagerId != 0)
                parameters.Add("managementCompanyID", assetManagerId);

            if (activityFilter != ActivityReturnFilter.All)
                parameters.Add("isActive", (activityFilter == ActivityReturnFilter.Active ? true : false));

            return session.GetTypedListByNamedQuery<ILifecycle>(
                "B4F.TotalGiro.Instruments.Lifecycles",
                parameters);
        }

        public static IList<IGeneralOperationsBooking> GetBookings(IDalSession session, GeneralOperationsBookingReturnClass bookingType, int accountId, DateTime beginDate, DateTime endDate, bool includeStornos)
        {
            Hashtable parameters = new Hashtable();
            parameters.Add("accountId", accountId);
            parameters.Add("beginDate", beginDate);
            parameters.Add("endDate", endDate);
            parameters.Add("bookTypeId", (int)bookingType);
            if (!includeStornos)
                parameters.Add("hideStornos", 1);

            return session.GetTypedListByNamedQuery<IGeneralOperationsBooking>(
                "B4F.TotalGiro.GeneralLedger.Journal.Bookings.GetGeneralOperationsBookings",
                parameters);
        }

        /// <summary>
        /// Get all system categories
        /// </summary>
        /// <param name="session">Data access object</param>
        /// <param name="secCategoryFilter">Type of sec category to return</param>
        /// <param name="includeNotSupported">include Not Supported sec categories</param>
        /// <returns>Collection of categories</returns>
        public static IList<ISecCategory> GetSecCategories(IDalSession session, SecCategoryFilterOptions secCategoryFilter, bool? includeNotSupported)
        {
            Hashtable parameters = new Hashtable();

            if (secCategoryFilter != SecCategoryFilterOptions.All)
                parameters.Add("secCategoryFilter", (int)secCategoryFilter);
            if (includeNotSupported.HasValue && !includeNotSupported.Value)
                parameters.Add("isSupported", true);
            IList<ISecCategory> list = session.GetTypedListByNamedQuery<ISecCategory>(
                "B4F.TotalGiro.Instruments.SecCategories",
                parameters);
            return list.ToList();

            //
        }

        public static IList<IBenchMark> GetBenchMarks(
            IDalSession session, string isin, string instrumentName, 
            int currencyNominalId, ActivityReturnFilter activityFilter)
        {
            Hashtable parameters = new Hashtable();

            if (!string.IsNullOrEmpty(isin))
                parameters.Add("isin", Util.PrepareNamedParameterWithWildcard(isin, MatchModes.Anywhere));
            if (!string.IsNullOrEmpty(instrumentName))
                parameters.Add("instrumentName", Util.PrepareNamedParameterWithWildcard(instrumentName, MatchModes.Anywhere));
            if (currencyNominalId > 0)
                parameters.Add("currencyNominalId", currencyNominalId);
            if (activityFilter != ActivityReturnFilter.All)
                parameters.Add("isActive", activityFilter == ActivityReturnFilter.Active);
            return session.GetTypedListByNamedQuery<IBenchMark>(
                "B4F.TotalGiro.Instruments.Instrument.GetBenchmarks",
                parameters);
        }

        public static IList<IInstrumentsHistoryConversion> GetInstrumentConversions(
            IDalSession session, string isin, string instrumentName, 
            SecCategories secCategoryId, int currencyNominalId)
        {
            Hashtable parameters = new Hashtable();

            if (!string.IsNullOrEmpty(isin))
                parameters.Add("isin", Util.PrepareNamedParameterWithWildcard(isin, MatchModes.Anywhere));
            if (!string.IsNullOrEmpty(instrumentName))
                parameters.Add("instrumentName", Util.PrepareNamedParameterWithWildcard(instrumentName, MatchModes.Anywhere));
            if (secCategoryId != SecCategories.Undefined)
                parameters.Add("secCategoryId", secCategoryId);
            if (currencyNominalId > 0)
                parameters.Add("currencyNominalId", currencyNominalId);

            return session.GetTypedListByNamedQuery<IInstrumentsHistoryConversion>(
                "B4F.TotalGiro.Instruments.History.GetInstrumentConversions",
                parameters);
        }