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); }