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