public JsonResult AddAttention(OauthToken token, long attentionUserKeyId)
{
var model = new ArticleAttentionDataContract();
model.UserKeyId = token.UserKeyId;
model.AttentionUserKeyId = attentionUserKeyId;
model.AttentionTime = DateTime.Now;
return(Json(articleAttentionService.AddArticleAttention(model)));
}
public ReturnResult <bool> AddArticleAttention(ArticleAttentionDataContract articleAttention)
{
if (articleAttention.AttentionUserKeyId == articleAttention.UserKeyId)
{
return(new ReturnResult <bool>(101, false, "不允许关注自己"));
}
if (ArticleAttentionRepository.Instance.IsExists(articleAttention.UserKeyId, articleAttention.AttentionUserKeyId))
{
return(new ReturnResult <bool>(true));
}
return(new ReturnResult <bool>(ArticleAttentionRepository.Instance.InsertArticleAttention(articleAttention)));
}
public bool InsertArticleAttention(ArticleAttentionDataContract articleAttention)
{
string sql = "INSERT INTO SA_ArticleAttention(UserKeyId,AttentionUserKeyId,AttentionTime) VALUES(@userKeyId,@attentionUserKeyId,@attentionTime);SELECT @@IDENTITY;";
var _parm = new SqlParameter[] {
new SqlParameter("@userKeyId", articleAttention.UserKeyId),
new SqlParameter("@attentionUserKeyId", articleAttention.AttentionUserKeyId),
new SqlParameter("@attentionTime", articleAttention.AttentionTime)
};
articleAttention.AttentionId = Convert.ToInt64(SqlHelper.ExecuteScalar(SqlHelper.GetConnSting(), CommandType.Text, sql, _parm));
return(articleAttention.AttentionId > 0);
}
