/// <summary>
/// 获取退票统计合计信息
/// </summary>
/// <param name="refundAmount">退回金额合计</param>
/// <param name="model">查询实体</param>
public void GetSumRefundStatistic(ref decimal refundAmount, Model.StatisticStructure.MQueryRefundStatistic model)
{
refundAmount = 0M;
if (model == null || model.CompanyId <= 0)
{
return;
}
dal.GetSumRefundStatistic(ref refundAmount, model, HaveUserIds);
}
/// <summary>
/// 获取退票统计合计信息
/// </summary>
/// <param name="refundAmount">退回金额合计</param>
/// <param name="model">查询实体</param>
/// <param name="us">用户信息集合</param>
public void GetSumRefundStatistic(ref decimal refundAmount, Model.StatisticStructure.MQueryRefundStatistic model, string us)
{
refundAmount = 0M;
var strSql = new StringBuilder();
strSql.Append(" select sum(RefundAmount) from View_RefundStatistics ");
string strWhere = GetSqlWhereByQueryModel(model, us);
if (!string.IsNullOrEmpty(strWhere))
{
strSql.AppendFormat(" where {0} ", strWhere);
}
DbCommand dc = _db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
{
if (dr.Read())
{
refundAmount = dr.IsDBNull(0) ? 0M : dr.GetDecimal(0);
}
}
}
/// <summary>
/// 获取退票统计
/// </summary>
/// <param name="PageSize">每页条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="model">查询实体</param>
/// <returns></returns>
public IList <Model.StatisticStructure.MRefundStatistic> GetRefundStatistic(int PageSize, int PageIndex
, ref int RecordCount, Model.StatisticStructure.MQueryRefundStatistic model)
{
if (model == null || model.CompanyId <= 0)
{
return(null);
}
return(dal.GetRefundStatistic(PageSize, PageIndex, ref RecordCount, model, HaveUserIds));
}