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