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