public Core.Business.UserFriend Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUserFriend"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.UserFriend userFriend = new Core.Business.UserFriend(); if (!reader.IsDBNull(0)) userFriend.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) userFriend.UserID = reader.GetGuid(1); if (!reader.IsDBNull(2)) userFriend.Des = reader.GetString(2); if (!reader.IsDBNull(3)) userFriend.AddTime = reader.GetDateTime(3); reader.Close(); return userFriend; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.UserFriend> GetAllUserFriend() { IList<Core.Business.UserFriend> userFriendlist = new List<Core.Business.UserFriend>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUserFriendsAll"); if(reader != null) { while(reader.Read()) { Core.Business.UserFriend userFriend = new Core.Business.UserFriend(); if (!reader.IsDBNull(0)) userFriend.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) userFriend.UserID = reader.GetGuid(1); if (!reader.IsDBNull(2)) userFriend.Des = reader.GetString(2); if (!reader.IsDBNull(3)) userFriend.AddTime = reader.GetDateTime(3); userFriend.MarkOld(); userFriendlist.Add(userFriend); } reader.Close(); } return userFriendlist; }