C# OpenCbsReader.GetMoney方法代码示例

        private static Event GetSavingEvent(OpenCbsReader r)
        {
            SavingEvent e;

            switch (r.GetString("code"))
            {
                case OSavingEvents.Deposit:
                    e = new SavingDepositEvent();
                    break;
                case OSavingEvents.Withdraw:
                    e = new SavingWithdrawEvent();
                    break;
                case OSavingEvents.InitialDeposit:
                    e = new SavingInitialDepositEvent();
                    break;
                case OSavingEvents.CreditTransfer:
                    e = new SavingCreditTransferEvent();
                    break;
                case OSavingEvents.DebitTransfer:
                    e = new SavingDebitTransferEvent();
                    break;
                case OSavingEvents.SpecialOperationCredit:
                    e = new SavingCreditOperationEvent();
                    break;
                case OSavingEvents.SpecialOperationDebit:
                    e = new SavingDebitOperationEvent();
                    break;
                case OSavingEvents.InterBranchCreditTransfer:
                    e = new SavingCreditInterBranchTransferEvent();
                    break;
                case OSavingEvents.InterBranchDebitTransfer:
                    e = new SavingDebitInterBranchTransferEvent();
                    break;
                default:
                    throw new Exception();
            }

            e.Amount = r.GetMoney("se_amount");
            if (e is ISavingsFees)
                ((ISavingsFees)e).Fee = r.GetMoney("se_fees");
            if (e is SavingTransferEvent)
                ((SavingTransferEvent)e).RelatedContractCode = r.GetString("se_transfer_code");

            return e;
        }

        private static ISavingProduct GetProduct(OpenCbsReader r)
        {
            ISavingProduct product;

            switch (r.GetChar("product_type"))
            {
                case 'B' : product = new SavingsBookProduct(); break;
               default : product = null; break;
            }

            product.Id = r.GetInt("id");
            product.Delete = r.GetBool("deleted");
            product.Name = r.GetString("name");
            product.Code = r.GetString("code");

            product.ClientType = r.GetChar("client_type") == 'C' ? OClientTypes.Corporate
                                 : r.GetChar("client_type") == 'G' ? OClientTypes.Group
                                 : r.GetChar("client_type") == 'I' ? OClientTypes.Person
                                 : OClientTypes.All;

            product.InitialAmountMin = r.GetMoney("initial_amount_min");
            product.InitialAmountMax = r.GetMoney("initial_amount_max");
            product.BalanceMin = r.GetMoney("balance_min");
            product.BalanceMax = r.GetMoney("balance_max");
            product.DepositMin = r.GetMoney("deposit_min");
            product.DepositMax = r.GetMoney("deposit_max");
            product.WithdrawingMin = r.GetMoney("withdraw_min");
            product.WithdrawingMax = r.GetMoney("withdraw_max");
            product.TransferMin = r.GetMoney("transfer_min");
            product.TransferMax = r.GetMoney("transfer_max");
            product.InterestRate = r.GetNullDouble("interest_rate");
            product.InterestRateMin = r.GetNullDouble("interest_rate_min");
            product.InterestRateMax = r.GetNullDouble("interest_rate_max");
            product.EntryFees = r.GetMoney("entry_fees");
            product.EntryFeesMax = r.GetMoney("entry_fees_max");
            product.EntryFeesMin = r.GetMoney("entry_fees_min");

            if (product is SavingsBookProduct)
            {
                var savingBookProduct = (SavingsBookProduct) product;

                savingBookProduct.InterestBase = (OSavingInterestBase)r.GetSmallInt("interest_base");
                savingBookProduct.InterestFrequency = (OSavingInterestFrequency)r.GetSmallInt("interest_frequency");

                if (savingBookProduct.InterestBase == OSavingInterestBase.Monthly ||
                    savingBookProduct.InterestBase == OSavingInterestBase.Weekly)
                    savingBookProduct.CalculAmountBase = (OSavingCalculAmountBase)r.GetSmallInt("calcul_amount_base");

                savingBookProduct.WithdrawFeesType = (OSavingsFeesType)r.GetSmallInt("withdraw_fees_type");
                if (savingBookProduct.WithdrawFeesType == OSavingsFeesType.Flat)
                {
                    savingBookProduct.FlatWithdrawFeesMin = r.GetMoney("flat_withdraw_fees_min");
                    savingBookProduct.FlatWithdrawFeesMax = r.GetMoney("flat_withdraw_fees_max");
                    savingBookProduct.FlatWithdrawFees = r.GetMoney("flat_withdraw_fees");
                }
                else
                {
                    savingBookProduct.RateWithdrawFeesMin = r.GetNullDouble("rate_withdraw_fees_min");
                    savingBookProduct.RateWithdrawFeesMax = r.GetNullDouble("rate_withdraw_fees_max");
                    savingBookProduct.RateWithdrawFees = r.GetNullDouble("rate_withdraw_fees");
                }

                savingBookProduct.TransferFeesType = (OSavingsFeesType)r.GetSmallInt("transfer_fees_type");
                if (savingBookProduct.TransferFeesType == OSavingsFeesType.Flat)
                {
                    savingBookProduct.FlatTransferFeesMin = r.GetMoney("flat_transfer_fees_min");
                    savingBookProduct.FlatTransferFeesMax = r.GetMoney("flat_transfer_fees_max");
                    savingBookProduct.FlatTransferFees = r.GetMoney("flat_transfer_fees");
                }
                else
                {
                    savingBookProduct.RateTransferFeesMin = r.GetNullDouble("rate_transfer_fees_min");
                    savingBookProduct.RateTransferFeesMax = r.GetNullDouble("rate_transfer_fees_max");
                    savingBookProduct.RateTransferFees = r.GetNullDouble("rate_transfer_fees");
                }

                Fee fee = savingBookProduct.InterBranchTransferFee;
                fee.IsFlat = r.GetBool("is_ibt_fee_flat");
                fee.Min = r.GetNullDecimal("ibt_fee_min");
                fee.Max = r.GetNullDecimal("ibt_fee_max");
                fee.Value = r.GetNullDecimal("ibt_fee");

                savingBookProduct.DepositFees = r.GetMoney("deposit_fees");
                savingBookProduct.DepositFeesMax = r.GetMoney("deposit_fees_max");
                ((SavingsBookProduct)product).DepositFeesMin = r.GetMoney("deposit_fees_min");

                savingBookProduct.ChequeDepositMin = r.GetMoney("cheque_deposit_min");
                savingBookProduct.ChequeDepositMax = r.GetMoney("cheque_deposit_max");
                savingBookProduct.ChequeDepositFees = r.GetMoney("cheque_deposit_fees");
                savingBookProduct.ChequeDepositFeesMin = r.GetMoney("cheque_deposit_fees_min");
                savingBookProduct.ChequeDepositFeesMax = r.GetMoney("cheque_deposit_fees_max");

                savingBookProduct.CloseFees = r.GetMoney("close_fees");
                savingBookProduct.CloseFeesMax = r.GetMoney("close_fees_max");
                savingBookProduct.CloseFeesMin = r.GetMoney("close_fees_min");

                savingBookProduct.ManagementFees = r.GetMoney("management_fees");
                savingBookProduct.ManagementFeesMax = r.GetMoney("management_fees_max");
                savingBookProduct.ManagementFeesMin = r.GetMoney("management_fees_min");

//.........这里部分代码省略.........

 private static RescheduleLoanEvent GetReschedulingLoanEvent(OpenCbsReader r)
 {
     return new RescheduleLoanEvent{
         Id = r.GetInt("rle_id"),
         Amount = r.GetMoney("rle_amount"),
         NbOfMaturity = r.GetInt("rle_maturity"),
         DateOffset = r.GetInt("rle_date_offset")
     };
 }

        private static void SetSavingsEvent(OpenCbsReader r, SavingEvent e, ISavingProduct pProduct)
        {
            e.Id = r.GetInt("id");
            e.ContracId = r.GetInt("contract_id");
            e.Code = r.GetString("code");
            e.Amount = r.GetMoney("amount");
            e.Description = r.GetString("description");
            e.Deleted = r.GetBool("deleted");
            e.Date = r.GetDateTime("creation_date");
            e.Cancelable = r.GetBool("cancelable");
            e.IsFired = r.GetBool("is_fired");
            e.CancelDate = r.GetNullDateTime("cancel_date");

            if(pProduct != null)
                e.ProductType = pProduct.GetType();

            if (r.GetNullSmallInt("savings_method").HasValue)
                e.SavingsMethod = (OSavingsMethods)r.GetNullSmallInt("savings_method").Value;

            e.IsPending = r.GetBool("pending");
            e.PendingEventId = r.GetNullInt("pending_event_id");
            e.TellerId = r.GetNullInt("teller_id");
            e.LoanEventId = r.GetNullInt("loan_event_id");

            if (pProduct != null)
            {
                e.ProductType = pProduct.GetType();
            }

            if (e is SavingTransferEvent)
            {
                ((SavingTransferEvent)e).RelatedContractCode = r.GetString("related_contract_code");
            }

            if (e is ISavingsFees)
            {
                ((ISavingsFees) e).Fee = r.GetMoney("fees");
            }

            e.User = new User
                         {
                             Id = r.GetInt("user_id"),
                             UserName = r.GetString("user_name"),
                             Password = r.GetString("user_pass"),
                             LastName = r.GetString("last_name"),
                             FirstName = r.GetString("first_name")
                         };
            e.User.SetRole(r.GetString("role_code"));

            e.ClientType = OClientTypes.All;

            switch (r.GetString("client_type_code"))
            {
                case "I":
                    e.ClientType = OClientTypes.Person; break;
                case "C":
                    e.ClientType = OClientTypes.Corporate; break;
                case "G":
                    e.ClientType = OClientTypes.Group; break;
                case "V":
                    e.ClientType = OClientTypes.Village; break;
            }

            e.Branch = new Branch { Id = r.GetInt("branch_id") };
            e.Currency = new Currency
                             {
                                 Id = r.GetInt("currency_id"),
                                 Code = r.GetString("currency_code"),
                                 IsPivot = r.GetBool("is_pivot"),
                                 IsSwapped = r.GetBool("is_swapped")
                             };
            e.SavingProduct = new SavingsBookProduct { Id = r.GetInt("product_id") };
        }

        private Loan _GetLoan(OpenCbsReader r)
        {
            return new Loan(_user, ApplicationSettings.GetInstance(_user.Md5),
                            NonWorkingDateSingleton.GetInstance(_user.Md5),
                            ProvisionTable.GetInstance(_user), ChartOfAccounts.GetInstance(_user))
                       {
                           Id = r.GetInt("credit_id"),
                           ClientType = r.GetChar("client_type_code") == 'I'
                                            ? OClientTypes.Person
                                            : r.GetChar("client_type_code") == 'G'
                                                  ? OClientTypes.Group
                                                  : OClientTypes.Corporate,
                           ContractStatus = (OContractStatus) r.GetSmallInt("status"),
                           CreditCommiteeDate = r.GetNullDateTime("credit_commitee_date"),
                           CreditCommiteeComment = r.GetString("credit_commitee_comment"),
                           CreditCommitteeCode = r.GetString("credit_commitee_code"),
                           Amount = r.GetMoney("amount"),
                           InterestRate = r.GetDecimal("interest_rate"),
                           NbOfInstallments = r.GetInt("nb_of_installment"),
                           NonRepaymentPenalties = new NonRepaymentPenalties
                                                       {
                                                           InitialAmount = r.GetDouble("non_repayment_penalties_based_on_initial_amount"),
                                                           OLB = r.GetDouble("non_repayment_penalties_based_on_olb"),
                                                           OverDueInterest = r.GetDouble("non_repayment_penalties_based_on_overdue_interest"),
                                                           OverDuePrincipal = r.GetDouble("non_repayment_penalties_based_on_overdue_principal")
                                                       },

                           AnticipatedTotalRepaymentPenalties = r.GetDouble("anticipated_total_repayment_penalties"),
                           AnticipatedPartialRepaymentPenalties = r.GetDouble("anticipated_partial_repayment_penalties"),
                           AnticipatedPartialRepaymentPenaltiesBase = (OAnticipatedRepaymentPenaltiesBases)
                               r.GetSmallInt("anticipated_partial_repayment_base"),
                           AnticipatedTotalRepaymentPenaltiesBase =(OAnticipatedRepaymentPenaltiesBases)
                               r.GetSmallInt("anticipated_total_repayment_base"),

                           Disbursed = r.GetBool("disbursed"),
                           GracePeriod = r.GetNullInt("grace_period"),
                           GracePeriodOfLateFees = r.GetNullInt("grace_period_of_latefees"),
                           WrittenOff = r.GetBool("written_off"),
                           Rescheduled = r.GetBool("rescheduled"),

                           Code = r.GetString("contract_code"),
                           BranchCode = r.GetString("branch_code"),
                           CreationDate = r.GetDateTime("creation_date"),
                           StartDate = r.GetDateTime("start_date"),
                           AlignDisbursementDate = r.GetDateTime("align_disbursed_date"),
                           CloseDate = r.GetDateTime("close_date"),
                           Closed = r.GetBool("closed"),
                           BadLoan = r.GetBool("bad_loan"),
                           Synchronize = r.GetBool("synchronize"),
                           ScheduleChangedManually = r.GetBool("schedule_changed"),
                           AmountUnderLoc = r.GetMoney("amount_under_loc"),
                           CompulsorySavingsPercentage = r.GetNullInt("loan_percentage"),
                           LoanPurpose = r.GetString("loan_purpose"),
                           Comments = r.GetString("comments"),
                           AmountMin = r.GetMoney("amount_min"),
                           AmountMax = r.GetMoney("amount_max"),
                           InterestRateMin = r.GetNullDecimal("ir_min"),
                           InterestRateMax = r.GetNullDecimal("ir_max"),
                           NmbOfInstallmentsMin = r.GetNullInt("nmb_of_inst_min"),
                           NmbOfInstallmentsMax = r.GetNullInt("nmb_of_inst_max"),
                           LoanCycle = r.GetNullInt("loan_cycle"),
                           Insurance = r.GetDecimal("insurance"),
                           NsgID = r.GetNullInt("nsg_id"),
                           EconomicActivityId = r.GetInt("activity_id"),
                           FirstInstallmentDate = r.GetDateTime("preferred_first_installment_date"),
            };
        }

 private LoanDisbursmentEvent GetLoanDisbursmentEvent(OpenCbsReader r)
 {
     return new LoanDisbursmentEvent
                {
                    Id = r.GetInt("lde_id"),
                    Amount = r.GetMoney("lde_amount"),
                    Fee = r.GetMoney("lde_fees"),
                    PaymentMethodId = r.GetNullInt("lde_pm"),
                    PaymentMethod = r.GetNullInt("lde_pm") == null
                                        ? null
                                        : _paymentMethodManager.SelectPaymentMethodById(
                                            r.GetNullInt("lde_pm").Value)
                };
 }

        private static Booking GetBooking(OpenCbsReader reader)
        {
            return new Booking
                       {
                           Id = reader.GetInt("id"),
                           Amount = reader.GetMoney("amount"),
                           IsExported = reader.GetBool("is_exported"),
                           DebitAccount =
                               new Account
                                   {
                                       Id = reader.GetInt("debit_account_number_id")
                                   },
                           CreditAccount =
                               new Account
                                   {
                                       Id = reader.GetInt("credit_account_number_id")
                                   },
                           EventId = reader.GetInt("event_id"),
                           ContractId = reader.GetInt("contract_id"),

                           Date = reader.GetDateTime("transaction_date"),
                           Currency =
                               new Currency
                                   {Id = reader.GetInt("currency_id")},
                           ExchangeRate = reader.GetDouble("exchange_rate"),
                           Description = reader.GetString("description"),
                           Branch = new Branch {Id = reader.GetInt("branch_id")}

                       };
        }

 private static TrancheEvent GetTrancheLoanEvent(OpenCbsReader r)
 {
     return new TrancheEvent{
         Id = r.GetInt("tranche_id"),
         Amount = r.GetMoney("tranche_amount"),
         InterestRate = r.GetMoney("tranche_interest_rate").Value,
         Maturity = r.GetInt("tranche_maturity"),
         StartDate = r.GetDateTime("tranche_start_date"),
         GracePeriod = r.GetInt("tranche_grace_period"),
         FirstRepaymentDate = r.GetDateTime("tranche_first_repayment_date"),
     };
 }

 private Person GetPersonFromReader(OpenCbsReader r)
 {
     Person person;
     person = new Person
                  {
                      Id = r.GetInt("tiers_id"),
                      HomePhone = r.GetString("home_phone"),
                      Email = r.GetString("e_mail"),
                      Status = (OClientStatus)r.GetSmallInt("status"),
                      SecondaryEmail = r.GetString("secondary_e_mail"),
                      HomeType = r.GetString("home_type"),
                      SecondaryHomeType = r.GetString("secondary_hometype"),
                      ZipCode = r.GetString("zipCode"),
                      SecondaryZipCode = r.GetString("secondary_zipCode"),
                      OtherOrgComment = r.GetString("other_org_comment"),
                      PersonalPhone = r.GetString("personal_phone"),
                      SecondaryHomePhone = r.GetString("secondary_home_phone"),
                      SecondaryPersonalPhone = r.GetString("secondary_personal_phone"),
                      CashReceiptIn = r.GetNullInt("cash_input_voucher_number"),
                      CashReceiptOut = r.GetNullInt("cash_output_voucher_number"),
                      Type = r.GetChar("client_type_code") == 'I'
                                 ? OClientTypes.Person
                                 : r.GetChar("client_type_code") == 'G'
                                       ? OClientTypes.Group
                                       : OClientTypes.Corporate,
                      Scoring = r.GetNullDouble("scoring"),
                      LoanCycle = r.GetInt("loan_cycle"),
                      Active = r.GetBool("active"),
                      BadClient = r.GetBool("bad_client"),
                      OtherOrgName = r.GetString("other_org_name"),
                      OtherOrgAmount = r.GetMoney("other_org_amount"),
                      OtherOrgDebts = r.GetMoney("other_org_debts"),
                      City = r.GetString("city"),
                      Address = r.GetString("address"),
                      SecondaryCity = r.GetString("secondary_city"),
                      SecondaryAddress = r.GetString("secondary_address"),
                      FirstName = r.GetString("first_name"),
                      Sex = r.GetChar("sex"),
                      IdentificationData = r.GetString("identification_data"),
                      DateOfBirth = r.GetNullDateTime("birth_date"),
                      LastName = r.GetString("last_name"),
                      FatherName = r.GetString("father_name"),
                      Image = r.GetString("image_path"),
                      BirthPlace = r.GetString("birth_place"),
                      Nationality = r.GetString("nationality"),
                      FollowUpComment = r.GetString("follow_up_comment"),
                      Sponsor1 = r.GetString("sponsor1"),
                      Sponsor2 = r.GetString("sponsor2"),
                      Sponsor1Comment = r.GetString("sponsor1_comment"),
                      Sponsor2Comment = r.GetString("sponsor2_comment"),
                      FavouriteLoanOfficerId = r.GetNullInt("loan_officer_id"),
                      Branch = new Branch { Id = r.GetInt("branch_id") }
                  };
     return person;
 }

 private static RescheduleLoanEvent GetReschedulingLoanEvent(OpenCbsReader r)
 {
     return new RescheduleLoanEvent{
         Id = r.GetInt("rle_id"),
         Amount = r.GetMoney("rle_amount"),
         NbOfMaturity = r.GetInt("rle_maturity"),
         PreferredFirstInstallmentDate = r.GetDateTime("rle_preferred_first_installment_date"),
          PreviousInterestRate = r.GetDecimal("rle_previous_interest_rate")
     };
 }

 private TrancheEvent GetTrancheLoanEvent(OpenCbsReader r)
 {
     return new TrancheEvent{
         Id = r.GetInt("tranche_id"),
         Amount = r.GetMoney("tranche_amount"),
         InterestRate = r.GetMoney("tranche_interest_rate").Value,
         Maturity = r.GetInt("tranche_maturity"),
         StartDate = r.GetDateTime("tranche_start_date"),
         GracePeriod = r.GetInt("tranche_grace_period"),
         FirstRepaymentDate = r.GetDateTime("tranche_first_repayment_date"),
         PaymentMethodId = r.GetNullInt("tranche_pm"),
         PaymentMethod = r.GetNullInt("tranche_pm") == null
                             ? null
                             : _paymentMethodManager.SelectPaymentMethodById(
                                 r.GetNullInt("tranche_pm").Value)
     };
 }

 private static LoanTransitionEvent GetLoanTransitionEvent(OpenCbsReader r)
 {
     return new LoanTransitionEvent
     {
         Id = r.GetInt("glll_id"),
         Amount = r.GetMoney("glll_amount"),
     };
 }

 private static LoanPenaltyAccrualEvent GetLoanPenaltyAccrualEvent(OpenCbsReader r)
 {
     return new LoanPenaltyAccrualEvent
         {
             Id = r.GetInt("lpae_id"),
             Penalty = r.GetMoney("lpae_penalty"),
         };
 }

 private static LoanInterestAccrualEvent GetLoanInterestAccrualEvent(OpenCbsReader r)
 {
     return new LoanInterestAccrualEvent
         {
             Id = r.GetInt("aile_id"),
             Interest = r.GetMoney("aile_interest"),
         };
 }

 private static TrancheEvent GetTrancheLoanEvent(OpenCbsReader r)
 {
     return new TrancheEvent{
         Id = r.GetInt("tranche_id"),
         Amount = r.GetMoney("tranche_amount"),
         InterestRate = r.GetMoney("tranche_interest_rate").Value,
         Maturity = r.GetInt("tranche_maturity"),
         StartDate = r.GetDateTime("tranche_start_date")
     };
 }