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