/// <summary> /// 新增用户关系 /// </summary> /// <param name="user">关系信息</param> /// <returns></returns> public int AddUserRelation(UserRelation user_relation) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("insert into UserRelation values"); sbSql.Append("(@Id,@UserId,@FriendId);"); sbSql.Append("insert into UserRelation values"); sbSql.Append("(@Id,@FriendId,@UserId);"); SQLiteParameter[] parameters = { new SQLiteParameter("@Id", DbType.Int32){Value=DBNull.Value}, new SQLiteParameter("@UserId", DbType.String){Value=user_relation.UserId}, new SQLiteParameter("@FriendId", DbType.String){Value=user_relation.FriendId} }; return SqliteHelper.ExecuteNonQuery(sbSql.ToString(), parameters); }
public void Add_Friend() { UserInfo user = IPublic.VerifyUser(); if (user == null) return; UserRelation user_relation = new UserRelation() { UserId = HttpContext.Current.Request["UserId"], FriendId = HttpContext.Current.Request["FriendId"] }; if (!userRelationBLL.AddUserRelation(user_relation)) { responseResult.ResponseDetails = "添加好友失败!"; responseResult.ResponseStatus = 0; } else { responseResult.ResponseData = user_relation; responseResult.ResponseDetails = "添加好友成功!"; responseResult.ResponseStatus = 1; } responseResult.ResponseWrite(); }