/// <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)); }