/// <summary>
/// 获取收入、支出增加减少费用明细信息集合
/// </summary>
/// <param name="itemType">项目类型</param>
/// <param name="itemId">项目编号</param>
/// <returns></returns>
public IList <EyouSoft.Model.FinanceStructure.MGoldDetailInfo> GetDetails(EyouSoft.Model.EnumType.FinanceStructure.GoldType itemType, string itemId)
{
IList <EyouSoft.Model.FinanceStructure.MGoldDetailInfo> items = new List <EyouSoft.Model.FinanceStructure.MGoldDetailInfo>();
DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_GetDetails);
this._db.AddInParameter(cmd, "ItemType", DbType.Byte, itemType);
this._db.AddInParameter(cmd, "ItemId", DbType.AnsiStringFixedLength, itemId);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, this._db))
{
while (rdr.Read())
{
items.Add(new EyouSoft.Model.FinanceStructure.MGoldDetailInfo()
{
AddAmount = rdr.GetDecimal(rdr.GetOrdinal("AddAmount")),
CreateTime = rdr.GetDateTime(rdr.GetOrdinal("CreateTime")),
DetailId = rdr.GetString(rdr.GetOrdinal("DetailId")),
ItemId = rdr.GetString(rdr.GetOrdinal("ItemId")),
ItemType = (EyouSoft.Model.EnumType.FinanceStructure.GoldType)rdr.GetByte(rdr.GetOrdinal("ItemType")),
OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId")),
ReduceAmount = rdr.GetDecimal(rdr.GetOrdinal("ReduceAmount")),
Remark = rdr["Remark"].ToString()
});
}
}
return(items);
}
/// <summary>
/// 获取收入、支出增加减少费用明细信息集合
/// </summary>
/// <param name="itemType">项目类型</param>
/// <param name="itemId">项目编号</param>
/// <returns></returns>
private IList <EyouSoft.Model.FinanceStructure.MGoldDetailInfo> GetDetails(EyouSoft.Model.EnumType.FinanceStructure.GoldType itemType, string itemId)
{
if (string.IsNullOrEmpty(itemId))
{
return(null);
}
return(dal.GetDetails(itemType, itemId));
}
