/// <summary>
/// 获取计调项目支出已登记金额
/// </summary>
/// <param name="registerId">登记编号 不为null时计调项目支出已登记金额不含自身金额 为null时计调项目支出已登记金额</param>
/// <param name="planId">计调项目编号</param>
/// <param name="planType">计调项目类型</param>
/// <param name="expenseAmount">计调项目支出金额</param>
/// <returns></returns>
public decimal GetExpenseRegisterAmount(string registerId, string planId, Model.EnumType.FinanceStructure.OutPlanType planType, out decimal expenseAmount)
{
expenseAmount = 0;
decimal registerAmount = 0;
DbCommand cmd = this._db.GetStoredProcCommand("proc_Financial_GetExpenseRegisterAmount");
this._db.AddInParameter(cmd, "PlanId", DbType.AnsiStringFixedLength, planId);
this._db.AddInParameter(cmd, "PlanType", DbType.Byte, planType);
if (!string.IsNullOrEmpty(registerId))
{
this._db.AddInParameter(cmd, "RegisterId", DbType.AnsiStringFixedLength, registerId);
}
else
{
this._db.AddInParameter(cmd, "RegisterId", DbType.AnsiStringFixedLength, DBNull.Value);
}
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
expenseAmount = rdr.IsDBNull(rdr.GetOrdinal("ExpenseAmount")) ? 0 : rdr.GetDecimal(rdr.GetOrdinal("ExpenseAmount"));
registerAmount = rdr.IsDBNull(rdr.GetOrdinal("RegisterAmount")) ? 0 : rdr.GetDecimal(rdr.GetOrdinal("RegisterAmount"));
}
}
return(registerAmount);
}
/// <summary>
/// 获取计调项目支出已登记金额
/// </summary>
/// <param name="registerId">登记编号 不为null时计调项目支出已登记金额不含自身金额 为null时计调项目支出已登记金额</param>
/// <param name="planId">计调项目编号</param>
/// <param name="planType">计调项目类型</param>
/// <param name="expenseAmount">计调项目支出金额</param>
/// <returns></returns>
public decimal GetExpenseRegisterAmount(string registerId, string planId, Model.EnumType.FinanceStructure.OutPlanType planType, out decimal expenseAmount)
{
return(idal.GetExpenseRegisterAmount(registerId, planId, planType, out expenseAmount));
}
