C# (CSharp) Dianda.COMMON.pageControl Exemples

Exemple #1

        private string GetParentBudgetBalance(string parentBudgetId)
        {
            string    sql = string.Format("SELECT isnull(sum(Balance),0) totalBalance FROM vBudget_Department_List  where ParentId={0} group by ParentId", parentBudgetId);
            DataTable tb  = new Dianda.COMMON.pageControl().doSql(sql).Tables[0];

            return(tb.Rows.Count > 0? tb.Rows[0]["totalBalance"].ToString() + "元" : "0元");
        }