/// <summary>
/// 获取支出登记明细金额合计
/// </summary>
/// <param name="model">支出登记查询实体</param>
/// <param name="haveUserIds">用户Id集合，半角逗号分割</param>
/// <param name="paymentAmount">付款金额</param>
public void GetOutRegisterList(Model.FinanceStructure.QueryOutRegisterInfo model, string haveUserIds, ref decimal paymentAmount)
{
if (model == null)
{
return;
}
var strSql = new StringBuilder();
string strOrder = string.Empty;
strSql.Append(" select sum(PaymentAmount) from tbl_FinancialPayInfo where ");
strSql.Append(GetSqlWhere(model, haveUserIds, ref strOrder));
DbCommand dc = _db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
{
if (dr.Read())
{
if (!dr.IsDBNull(0))
{
paymentAmount = dr.GetDecimal(0);
}
}
}
}
/// <summary>
/// 获取支出登记明细金额合计
/// </summary>
/// <param name="model">支出登记查询实体</param>
/// <param name="paymentAmount">付款金额</param>
public void GetOutRegisterList(Model.FinanceStructure.QueryOutRegisterInfo model, ref decimal paymentAmount)
{
if (model == null)
{
return;
}
idal.GetOutRegisterList(model, HaveUserIds, ref paymentAmount);
}
