/// <summary> /// 更新文章 /// </summary> /// <param name="para"></param> /// <returns></returns> public async Task <string> EditArticle(ArticleViewModel_para para) { #region 驗證 if (string.IsNullOrEmpty(para.article_id) || !Guid.TryParse(para.article_id, out Guid id)) { return("請選擇文章"); } var GetArticle = await _articleRepo.GetById(id); if (GetArticle == null) { return("該文章不存在"); } var check = await ArticleVerify(para); if (check != "success") { return(check); } #endregion var UpdateArticle = new TArticleModel() { f_article_id = id, f_category_id = new Guid(para.category_id), f_article_name = para.article_name, f_content = para.article_content }; var update = await _articleRepo.UpdateArticle(UpdateArticle); return("success"); }
/// <summary> /// 更新文章 /// </summary> /// <param name="para"></param> /// <returns></returns> public async Task <int> UpdateArticle(TArticleModel para) { var sqlQuery = $@"UPDATE t_article SET f_category_id = @f_category_id ,f_article_name = @f_article_name ,f_content = @f_content WHERE f_article_id = @f_article_id"; using (var conn = new SqlConnection(_dbList.Article)) { return(await conn.ExecuteAsync(sqlQuery, para)); } }
/// <summary> /// 新增文章 /// </summary> /// <param name="para"></param> /// <returns></returns> public async Task <int> CreateArticle(TArticleModel para) { var sqlQuery = $@"INSERT INTO t_article (f_article_id ,f_category_id ,f_article_name ,f_content) VALUES (@f_article_id ,@f_category_id ,@f_article_name ,@f_content)"; using (var conn = new SqlConnection(_dbList.Article)) { return(await conn.ExecuteAsync(sqlQuery, para)); } }
/// <summary> /// 新增文章 /// </summary> /// <param name="category_id"></param> /// <param name="name"></param> /// <param name="content"></param> /// <returns></returns> public async Task <dynamic> CreateArticle(ArticleViewModel_para para) { #region 驗證 var check = await ArticleVerify(para); if (check != "success") { return(check); } #endregion var NewArticle = new TArticleModel() { f_article_id = Guid.NewGuid(), f_category_id = new Guid(para.category_id), f_article_name = para.article_name, f_content = para.article_content }; await _articleRepo.CreateArticle(NewArticle); return("success"); }
public async Task <dynamic> DeleteArticle(TArticleModel para) { return(await _ArticleService.DeleteArticle(para.f_article_id)); }