/// <summary>
        /// 返回指定条件的总支出
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        public decimal GetCountForWhere(string sqlWhere = "")
        {
            string sql = "SELECT SUM(gCount*gPrice) FROM " + strSql + sqlWhere + " ";

            return(SqlHelper.ExcuteScalarForDecimal(sql));
        }
        /// <summary>
        /// 返回指定时间段的总支出
        /// </summary>
        /// <param name="dt1"></param>
        /// <param name="dt2"></param>
        /// <returns></returns>
        public decimal GetCountForPay(DateTime dt1, DateTime dt2)
        {
            string sql = "SELECT SUM(gCount*gPrice) FROM " + strSql + " WHERE gBuyTime BETWEEN '" + dt1.ToString("yyyy-MM-dd") + "' AND '" + dt2.ToString("yyyy-MM-dd") + "'";

            return(SqlHelper.ExcuteScalarForDecimal(sql));
        }