public int AddFriend(int hostId,int friendShipPolicy,int friendId)
{
DbOperate dbo = new DbOperate();
dbo.TableName = FriendsOperator.TABLENAME;
//定义数据操作对象，并初始化其将执行的SQL语句
SqlCommand com = new SqlCommand();
com.CommandText = string.Format("insert into Friends values({0},{1},null,{2})",hostId,friendShipPolicy,friendId);
return dbo.Insert(com);
}
/// <summary>
/// ע��һ���û�
/// </summary>
/// <param name="item">�û�ʵ�����</param>
/// <returns>�����ݿ��и��µļ�¼����</returns>
public int InsertUser(UserItem item)
{
//����һ�����ݿ����ͨ�ö���
DbOperate dbo = new DbOperate();
dbo.TableName = UsersOperator.TABLENAME;
//����һ�����ݲ����SQL���
SqlCommand com = new SqlCommand();
com.CommandText = "insert into Users values(@LoginPwd,@nickName,@faceId,@sex,@age,@name,@starId,@bloodTypeId)";
//����SQL���������û�ʵ������ֵ�������
com.Parameters.Add(new SqlParameter("@LoginPwd", SqlDbType.VarChar,50)).Value = item.LoginPwd;
com.Parameters.Add(new SqlParameter("@nickName", SqlDbType.VarChar, 50)).Value = item.NickName;
com.Parameters.Add(new SqlParameter("@faceId", SqlDbType.Int)).Value = item.FaceId;
com.Parameters.Add(new SqlParameter("@sex", SqlDbType.VarChar,50)).Value = item.Sex;
com.Parameters.Add(new SqlParameter("@age", SqlDbType.Int)).Value = item.Age;
com.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar,50)).Value=item.Name;
com.Parameters.Add(new SqlParameter("@starId", SqlDbType.Int)).Value = item.StarId;
com.Parameters.Add(new SqlParameter("@bloodTypeId", SqlDbType.Int)).Value = item.BloodTypeId;
//ִ�����ݿ���������������Ӱ��ļ�¼����
//SqlDataReader objReader = dbo.ModifyAndFind(com);
//if (objReader.Read())
//{
// return (int)objReader[0];
//}
//return -1;
int result = dbo.Insert(com);
this._lastUserId = this.getUserId();
return result;
}
/// <summary>
/// 所有插入消息的状态都是未读消息
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int InsertMessage(MessageItem item)
{
DbOperate dbo = new DbOperate();
dbo.TableName = MessageOperator.TABLENAME;
SqlCommand com = new SqlCommand();
com.CommandText = "insert into Messages values(@fromUserId,@toUserId,@message,@messageTypeId,@messageState,@messageTime)";
com.Parameters.Add(new SqlParameter("@fromUserId", SqlDbType.Int)).Value = item.FromUserId;
com.Parameters.Add(new SqlParameter("@toUserId", SqlDbType.Int)).Value = item.ToUserId;
com.Parameters.Add(new SqlParameter("@message", SqlDbType.VarChar,50)).Value = item.Message;
com.Parameters.Add(new SqlParameter("@messageTypeId", SqlDbType.Int)).Value = item.MessageTypeId;
com.Parameters.Add(new SqlParameter("@messageState", SqlDbType.Int)).Value = item.MessageState;
com.Parameters.Add(new SqlParameter("@messageTime", SqlDbType.DateTime)).Value = item.MessageTime;
return dbo.Insert(com);
}
