/// <summary>
/// 获取离线消息
/// </summary>
/// <param name="aHostEmail">接受者邮箱</param>
/// <param name="aFriendEmail">发送者邮箱</param>
/// <returns></returns>
public DataTable GetOffMessage(string aHostEmail)
{
SqlStoreCommand mSqlStoreCommand = new SqlStoreCommand();
mSqlStoreCommand.StoreProdureName = "Chat_Message";
mSqlStoreCommand.ClearParameters();
mSqlStoreCommand.AddParameters("@mFunctionName", "GetOffMessage");
mSqlStoreCommand.AddParameters("@mReceiverEmail", aHostEmail);
DataTable mGetOffMessage = mSqlStoreCommand.ExecuteDataTable();
return mGetOffMessage;
}
/// <summary>
/// 个人主页显示个人信息
/// </summary>
public DataTable ShowSelfMessage(string aUserEmail)
{
SqlStoreCommand mSqlStoreCommand = new SqlStoreCommand();
mSqlStoreCommand.StoreProdureName = "Chat_User";
mSqlStoreCommand.ClearParameters();
mSqlStoreCommand.AddParameters("@mFunctionName", "SearchOne");
mSqlStoreCommand.AddParameters("@mUserEmail", aUserEmail);
DataTable mShowSelfMessage = mSqlStoreCommand.ExecuteDataTable();
return mShowSelfMessage;
}
/// <summary>
/// 获取好友列表
/// </summary>
/// <param name="aUserEmail">用户账号</param>
/// <returns></returns>
public DataTable FriendsList(string aUserEmail)
{
SqlStoreCommand mSqlStoreCommand = new SqlStoreCommand();
mSqlStoreCommand.StoreProdureName = "Chat_Friend"; //motified by stf & pzb
mSqlStoreCommand.ClearParameters();
mSqlStoreCommand.AddParameters("@mFunctionName", "GetFriends");
mSqlStoreCommand.AddParameters("@mHostEmail", aUserEmail);
DataTable mFriendsList = mSqlStoreCommand.ExecuteDataTable();
return mFriendsList;
}
