public IList<Core.Business.FavoritesComment> GetAllFavoritesComment() { IList<Core.Business.FavoritesComment> favoritesCommentlist = new List<Core.Business.FavoritesComment>(); SqlServerUtility sql = new SqlServerUtility(connectionString); SqlDataReader reader = sql.ExecuteSPReader("USP_FavoritesComment_Select_All"); if (reader != null) { while (reader.Read()) { Core.Business.FavoritesComment favoritesComment = new Core.Business.FavoritesComment(); long id = 0; if (!reader.IsDBNull(0)) id = reader.GetInt64(0); favoritesComment = CY.UME.Core.Business.FavoritesComment.Load(id); favoritesComment.MarkOld(); favoritesCommentlist.Add(favoritesComment); } reader.Close(); } return favoritesCommentlist; }
public Core.Business.FavoritesComment Select(Int64 id) { SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@Id", SqlDbType.BigInt, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectFavoritesComment); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.FavoritesComment favoritesComment = new Core.Business.FavoritesComment(); if (!reader.IsDBNull(0)) favoritesComment.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) favoritesComment.DateCreated = reader.GetDateTime(1); if (!reader.IsDBNull(2)) favoritesComment.InstanceId = reader.GetInt64(2); if (!reader.IsDBNull(3)) favoritesComment.AccountId = reader.GetInt64(3); if (!reader.IsDBNull(4)) favoritesComment.AuthorId = reader.GetInt64(4); if (!reader.IsDBNull(5)) favoritesComment.ReferedId = reader.GetInt64(5); if (!reader.IsDBNull(6)) favoritesComment.Content = reader.GetString(6); if (!reader.IsDBNull(7)) favoritesComment.IP = reader.GetString(7); reader.Close(); return favoritesComment; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<CY.UME.Core.Business.FavoritesComment> GetTopFavoritesCommentByReferedId(long ReferedId, int Num) { IList<Core.Business.FavoritesComment> favoritesCommentlist = new List<Core.Business.FavoritesComment>(); SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@InstanceId", SqlDbType.BigInt, ReferedId); sql.AddParameter("@Num", SqlDbType.BigInt, Num); SqlDataReader reader = sql.ExecuteSPReader("USP_FavoritesComment_Select_Top_By_InstanceId"); if (reader != null) { while (reader.Read()) { Core.Business.FavoritesComment favoritesComment = new Core.Business.FavoritesComment(); if (!reader.IsDBNull(0)) favoritesComment.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) favoritesComment.DateCreated = reader.GetDateTime(1); if (!reader.IsDBNull(2)) favoritesComment.InstanceId = reader.GetInt64(2); if (!reader.IsDBNull(3)) favoritesComment.AccountId = reader.GetInt64(3); if (!reader.IsDBNull(4)) favoritesComment.AuthorId = reader.GetInt64(4); if (!reader.IsDBNull(5)) favoritesComment.ReferedId = reader.GetInt64(5); if (!reader.IsDBNull(6)) favoritesComment.Content = reader.GetString(6); if (!reader.IsDBNull(7)) favoritesComment.IP = reader.GetString(7); favoritesComment.MarkOld(); favoritesCommentlist.Add(favoritesComment); } reader.Close(); } return favoritesCommentlist; }