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