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