/// <summary> /// 统计好友个数 /// </summary> /// <param name="friend"></param> /// <returns></returns> public DataSet SelectFriendSum(MarriageFriend friend) { SqlParameter[] parms = { data.MakeInParam("@FriendName", SqlDbType.VarChar, 100, friend.FriendName), }; return(data.RunProcReturn("SELECT * FROM tb_Friend WHERE FriendName = @FriendName", parms, "tb_User")); }
/// <summary> /// 加为好友 /// </summary> /// <param name="friend"></param> /// <returns></returns> public int FriendAdd(MarriageFriend friend) { SqlParameter[] parms = { data.MakeInParam("@UserName", SqlDbType.VarChar, 100, friend.UserName), data.MakeInParam("@FriendName", SqlDbType.VarChar, 100, friend.FriendName), }; return(data.RunProc("Insert into tb_Friend(UserName, FriendName) values (@UserName, @FriendName)", parms)); }