private void LoadFromUsableBudget() { int city = int.Parse(tr_FromOrganizeCity.SelectValue); int month = int.Parse(ddl_FromMonth.SelectedValue); if (city > 0) { IList <FNA_BudgetBalance> balances = FNA_BudgetBalanceBLL.GetModelList("OrganizeCity=" + city.ToString() + " AND AccountMonth=" + month.ToString() + " ORDER BY FeeType"); #region 根据费用类型加上余额中没有的类型,以便支持从下级向上调回该费用类型的预算额度 Dictionary <string, Dictionary_Data> dicFeetype = DictionaryBLL.GetDicCollections("FNA_FeeType"); foreach (Dictionary_Data dic in dicFeetype.Values) { if (balances.FirstOrDefault(p => p.FeeType == int.Parse(dic.Code)) == null) { FNA_BudgetBalance balance = new FNA_BudgetBalance(); balance.AccountMonth = month; balance.OrganizeCity = city; balance.FeeType = int.Parse(dic.Code); balance.CostBalance = 0; balance.DDFInitialBalance = 0; balances.Add(balance); } } #endregion gv_FromBalance.BindGrid(balances); } }
private void LoadToUsableBudget() { int city = int.Parse(tr_ToOrganizeCity.SelectValue); int month = int.Parse(ddl_ToMonth.SelectedValue); if (city > 0) { gv_ToBalance.BindGrid(FNA_BudgetBalanceBLL.GetModelList("OrganizeCity=" + city.ToString() + " AND AccountMonth=" + month.ToString() + " ORDER BY FeeType")); } }
private void BindGrid() { int OrganizeCity = int.Parse(tr_OrganizeCity.SelectValue); int Month = int.Parse(ddl_Month.SelectedValue); //会计月条件 int Level = int.Parse(ddl_Level.SelectedValue); DataTable dt = FNA_BudgetBalanceBLL.GetBalance(OrganizeCity, Month, Level); DataTable dt_Matrix = MatrixTable.Matrix(dt, new string[] { "OrganizeCity", "区域名称", "区域级别" }, "FeeTypeName", "CostBalance"); gv_BalanceList.SelectedIndex = -1; gv_BalanceList.DataSource = dt_Matrix; gv_BalanceList.DataBind(); tr_BalanceChangeList.Visible = false; }