public ActionResult AddArticle(NovelArticle article) { string result = "发布失败"; if (Session["UserId"] == null) { return Content("长时间未操作,请重新登录。"); } if (article == null) { result = "参数为空"; } else { if (!string.IsNullOrEmpty(article.Title) && !string.IsNullOrEmpty(article.ContentStyle) && article.NovelId > 0) { NovelService novelService = new NovelService(); result = novelService.AddNovelArticle(article); } else { result = "必填项 [标题、内容] 不能为空"; } } return Content(result); }
/// <summary> /// 更新小说文章 /// </summary> public string EditNovelArticle(NovelArticle novelArticle) { string result = "更新失败"; var conn = DBRepository.GetSqlConnection(); try { conn.Open(); if (novelArticle != null) { if (novelArticle.NovelId > 0 && !string.IsNullOrEmpty(novelArticle.ContentStyle) && !string.IsNullOrEmpty(novelArticle.Title)) { if (DBRepository.Update<NovelArticle>(novelArticle, "Id", conn)) { result = "success"; } } } else { result = "category对象为空"; LogService.Log("NovelService.EditNovelArticle", "novelArticle对象为空"); } } catch (Exception e) { result = "程序出现异常,详情见日志"; LogService.Log("更新失败", e.ToString()); } finally { conn.Close(); } return result; }
/// <summary> /// 获取小说文章 /// </summary> public NovelArticle GetNovelArticleById(int id) { NovelArticle result = new NovelArticle(); var conn = DBRepository.GetSqlConnection(); try { conn.Open(); result = DBRepository.SelectOne<NovelArticle>("Id", id, conn); } catch (Exception e) { LogService.Log("获取小说文章", e.ToString()); } finally { conn.Close(); } return result; }
/// <summary> /// 添加小说文章 /// </summary> public string AddNovelArticle(NovelArticle novelArticle) { string result = "添加失败"; var conn = DBRepository.GetSqlConnection(); try { conn.Open(); if (novelArticle != null) { if (novelArticle.NovelId > 0 && !string.IsNullOrEmpty(novelArticle.ContentStyle) && !string.IsNullOrEmpty(novelArticle.Title)) { novelArticle.InsertTime = DateTime.Now; List<string> filterColumns = new List<string>() { "Id" }; if (DBRepository.Insert<NovelArticle>(novelArticle, conn, filterColumns)) { result = "success"; //更新内容章节数 List<NovelArticle> articles = DBRepository.SelectMore<NovelArticle>("NovelId=" + novelArticle.NovelId, conn); if (articles != null && articles.Count > 0) { DBRepository.UpdateOneColumn<Novel>("ArticleCount", articles.Count, "Id=" + novelArticle.NovelId, conn); } } } } else { result = "novelArticle对象为空"; LogService.Log("NovelService.AddNovelArticle", "novelArticle对象为空"); } } catch (Exception e) { result = "程序出现异常,详情见日志"; LogService.Log("添加分类", e.ToString()); } finally { conn.Close(); } return result; }