コード例 #1
0
        public void Update_owed_CHB(BudgetingMonths budgeting_months)
        {
            var num_months     = budgeting_months.Num_budgeting_months();
            var base_amount    = _spreadsheet_io.Get_amount(MainSheetNames.Budget_out, Codes.Code003);
            var current_amount = _spreadsheet_io.Get_amount(MainSheetNames.Expected_out, Codes.Code003, 2);
            var new_amount     = current_amount + (base_amount * num_months);
            var total_months   = (current_amount / base_amount) + num_months;

            _spreadsheet_io.Update_amount(MainSheetNames.Expected_out, Codes.Code003, new_amount);

            var text = _spreadsheet_io.Get_text(MainSheetNames.Expected_out, Codes.Code003);

            if (!String.IsNullOrEmpty(text))
            {
                var begin_text  = text.Substring(0, text.Length - 31);
                var month_total = String.Format("{0:00}", total_months);
                var start_date  = text.Substring(text.Length - 21, 8);
                var end_month   = budgeting_months.Budgeting_end_date().ToString("MMM", CultureInfo.CurrentCulture);
                var end_year    = budgeting_months.Budgeting_end_date().Year;
                text = $"{begin_text}{month_total} months {start_date} to {end_month} {end_year})";
                _spreadsheet_io.Update_text(MainSheetNames.Expected_out, Codes.Code003, text);
            }
        }