/// <summary>
/// 修改用户优选点赞和收藏状态
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static async Task <int> UpdateYouXuanRelatedOperactionStatus(YouXuanRelatedOperactionModel info)
{
using (var cmd = new SqlCommand("UPDATE Marketing..YouXuanRelatedOperaction WITH(ROWLOCK) SET Vote=@Vote,Favorite=@Favorite,LastUpdateDateTime=GETDATE() WHERE PKID=@PKID"))
{
cmd.Parameters.AddWithValue("@Vote", info.Vote);
cmd.Parameters.AddWithValue("@Favorite", info.Favorite);
cmd.Parameters.AddWithValue("@PKID", info.PKID);
return(await DbHelper.ExecuteNonQueryAsync(cmd));
}
}
/// <summary>
/// 插入用户优选点赞和收藏状态
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static async Task <int> InserYouXuanRelatedOperaction(YouXuanRelatedOperactionModel info)
{
using (var cmd = new SqlCommand("INSERT INTO Marketing..YouXuanRelatedOperaction VALUES ( @UserId, @ArticleId, @Vote, @Favorite, GETDATE(), GETDATE());"))
{
cmd.Parameters.AddWithValue("@UserId", info.UserId).SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.AddWithValue("@ArticleId", info.ArticleId);
cmd.Parameters.AddWithValue("@Vote", info.Vote);
cmd.Parameters.AddWithValue("@Favorite", info.Favorite);
return(await DbHelper.ExecuteNonQueryAsync(cmd));
}
}
/// <summary>
/// 优选点赞或收藏
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public static async Task <bool> YouXuanVoteOrFavorite(YouXuanRelatedOperactionModel info)
{
//查询是否存在如果存在返回当前信息
var userRelated = await Articles.SelectYouXuanRelatedOperaction(info.UserId, info.ArticleId);
if (userRelated?.PKID > 0)
{
info.PKID = userRelated.PKID;
//修改状态
var result = await Articles.UpdateYouXuanRelatedOperactionStatus(info);
return(result > 0);
}
else
{
//插入状态
var result = await Articles.InserYouXuanRelatedOperaction(info);
return(result > 0);
}
}
