/// <summary>
/// 获取出纳登帐信息金额合计
/// </summary>
/// <param name="model">出纳登帐信息查询实体</param>
/// <param name="paymentCount">到款银行</param>
/// <param name="totalAmount">已销账金额</param>
public void GetCashierRegisterMoney(Model.FinanceStructure.QueryCashierRegisterInfo model
, ref decimal paymentCount, ref decimal totalAmount)
{
if (model == null)
{
return;
}
idal.GetCashierRegisterMoney(model, HaveUserIds, ref paymentCount, ref totalAmount);
}
/// <summary>
/// 获取出纳登帐信息金额合计
/// </summary>
/// <param name="model">出纳登帐信息查询实体</param>
/// <param name="haveUserIds">用户Id集合，半角逗号分割</param>
/// <param name="paymentCount">到款银行</param>
/// <param name="totalAmount">已销账金额</param>
public void GetCashierRegisterMoney(Model.FinanceStructure.QueryCashierRegisterInfo model, string haveUserIds
, ref decimal paymentCount, ref decimal totalAmount)
{
if (model == null)
{
return;
}
string strOrder = string.Empty;
string strWhere = GetSqlWhere(model, haveUserIds, ref strOrder);
var strSql = new StringBuilder();
strSql.Append(" select sum(PaymentCount),sum(TotalAmount) from tbl_CashierRegister ");
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())
{
if (!dr.IsDBNull(0))
{
paymentCount = dr.GetDecimal(0);
}
if (!dr.IsDBNull(1))
{
totalAmount = dr.GetDecimal(1);
}
}
}
}
/// <summary>
/// 获取出纳登帐信息
/// </summary>
/// <param name="model">出纳登帐信息查询实体</param>
/// <param name="PageSize">每页条数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记录数</param>
/// <returns></returns>
public IList <Model.FinanceStructure.CashierRegisterInfo> GetList(Model.FinanceStructure.QueryCashierRegisterInfo model
, int PageSize, int PageIndex, ref int RecordCount)
{
return(idal.GetList(model, base.HaveUserIds, PageSize, PageIndex, ref RecordCount));
}
