/// <summary>
/// ��ø��û������ĺ�������
/// </summary>
/// <param name="account"></param>
/// <returns></returns>
public IList<CY.UME.Core.Business.Friendship> GetAccountRequestList(CY.UME.Core.Business.Account account)
{
string sqlstr = "AccountId=" + account.Id;
IList<Core.Business.Friendship> friendshiplist = new List<Core.Business.Friendship>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
string sqlwhere = "SELECT * FROM [dbo].[Friendship] where ";
sqlwhere += sqlstr + " ORDER BY [Id] desc";
SqlDataReader reader = sql.ExecuteSqlReader(sqlwhere);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Friendship friendship = new Core.Business.Friendship();
if (!reader.IsDBNull(0)) friendship.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) friendship.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) friendship.FriendId = reader.GetInt64(2);
if (!reader.IsDBNull(3)) friendship.GroupId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) friendship.IsChecked = reader.GetBoolean(4);
if (!reader.IsDBNull(5)) friendship.Remark = reader.GetString(5);
if (!reader.IsDBNull(6)) friendship.CommunicateNum = reader.GetInt32(6);
if (!reader.IsDBNull(7)) friendship.DateCreated = reader.GetDateTime(7);
friendship.MarkOld();
friendshiplist.Add(friendship);
}
reader.Close();
}
return friendshiplist;
}
public IList<Core.Business.Friendship> GetAllFriendship()
{
IList<Core.Business.Friendship> friendshiplist = new List<Core.Business.Friendship>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSPReader("USP_Friendship_SelectAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.Friendship friendship = new Core.Business.Friendship();
long id = reader.GetInt64(0);
friendship = Core.Business.Friendship.Load(id);
/*
if (!reader.IsDBNull(0)) friendship.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) friendship.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) friendship.FriendId = reader.GetInt64(2);
if (!reader.IsDBNull(3)) friendship.GroupId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) friendship.CommunicateNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) friendship.DateCreated = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) friendship.IsChecked = reader.GetBoolean(6);
if (!reader.IsDBNull(7)) friendship.Remark = reader.GetString(7);
*/
friendship.MarkOld();
friendshiplist.Add(friendship);
}
reader.Close();
}
return friendshiplist;
}
public CY.UME.Core.Business.Friendship Select(CY.UME.Core.Business.Account account, CY.UME.Core.Business.Account friend)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@AccountId", SqlDbType.BigInt, account.Id);
sql.AddParameter("@FriendId", SqlDbType.BigInt, friend.Id);
SqlDataReader reader = sql.ExecuteSPReader("USP_Friendship_Select_By_AccountId_And_FriendId");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Friendship friendship = new Core.Business.Friendship();
long id = reader.GetInt64(0);
friendship = Core.Business.Friendship.Load(id);
/*
if (!reader.IsDBNull(0)) friendship.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) friendship.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) friendship.FriendId = reader.GetInt64(2);
if (!reader.IsDBNull(3)) friendship.GroupId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) friendship.CommunicateNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) friendship.DateCreated = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) friendship.IsChecked = reader.GetBoolean(6);
if (!reader.IsDBNull(7)) friendship.Remark = reader.GetString(7);
*/
reader.Close();
return friendship;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<CY.UME.Core.Business.Friendship> GetRequestFriendList(CY.UME.Core.Business.Account account, CY.UME.Core.PagingInfo pagingInfo)
{
IList<Core.Business.Friendship> friendshiplist = new List<Core.Business.Friendship>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Tables", SqlDbType.VarChar, "Friendship");
sql.AddParameter("@PK", SqlDbType.VarChar, "Id");
sql.AddParameter("@Sort", SqlDbType.VarChar, "Id"); // CommunicateNum desc ���·�ҳ��Ч
sql.AddParameter("@Fields", SqlDbType.VarChar, "[Id],[AccountId],[FriendId],[GroupId],[CommunicateNum],[DateCreated],[IsChecked],[Remark]");
sql.AddParameter("@Filter", SqlDbType.VarChar, "[FriendId] = " + account.Id + " And [IsChecked]=0");
sql.AddParameter("@PageNumber", SqlDbType.Int, pagingInfo.CurrentPage);
sql.AddParameter("@PageSize", SqlDbType.Int, pagingInfo.PageSize);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.Friendship friendship = new Core.Business.Friendship();
long id = reader.GetInt64(0);
friendship = Core.Business.Friendship.Load(id);
/*
if (!reader.IsDBNull(0)) friendship.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) friendship.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) friendship.FriendId = reader.GetInt64(2);
if (!reader.IsDBNull(3)) friendship.GroupId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) friendship.CommunicateNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) friendship.DateCreated = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) friendship.IsChecked = reader.GetBoolean(6);
if (!reader.IsDBNull(7)) friendship.Remark = reader.GetString(7);
*/
friendship.MarkOld();
friendshiplist.Add(friendship);
}
reader.Close();
}
return friendshiplist;
}
