/// <summary>
/// 定时自动保存文章到Draft和Temp中去
/// </summary>
/// <param name="ArticleKey"></param>
/// <param name="ArticleTitle"></param>
/// <param name="ArticleCategory"></param>
/// <param name="ContentText"></param>
/// <param name="ArticleTag"></param>
/// <param name="ArticleDesc"></param>
/// <param name="AidStyle"></param>
/// <returns></returns>
public object Save(string ArticleKey, string ArticleTitle, string ArticleCategory, string ContentText, string ArticleTag, string ArticleDesc, string AidStyle)
{
int _status = 0;
string _msg = string.Empty;
int savecount = 0;
//只用判断标题、样式、和内容
if (ContentText != null)
{
var _cont = ContentText.Replace("<p>", "").Replace("<br>", "").Replace("</p>", "").Replace("</br>", ""); //去掉自带的样式
if (string.IsNullOrWhiteSpace(_cont))
{
ContentText = "";
}
}
if (string.IsNullOrWhiteSpace(ArticleTitle) && string.IsNullOrWhiteSpace(ContentText) && string.IsNullOrWhiteSpace(ArticleDesc) && string.IsNullOrWhiteSpace(AidStyle))
{
_status = 3;
_msg = "未提交数据";
}
else
{
ContentText = _PubComService._Pri_ArticleImage_DataService.ReplaceImagesPlaceholder(ContentText, ArticleKey);
//将数据存入到Temp中去
var tempdal = _PubComService._Pri_ArticleDraft_Temp_DataService;
var draftdal = _PubComService._Pri_ArticleDraft_DataService;
try
{
//只要有新的内容，就存成草稿状态
int oi = tempdal.InsertPri_ArticleDraft_Temp(new Pri_ArticleDraft_Temp_Entity()
{
ArticleKey = ArticleKey,
ArticleTag = ArticleTag ?? "",
ArticleDesc = ArticleDesc ?? "",
AidStyle = AidStyle ?? "",
ArticleCategory = ArticleCategory ?? "",
ArticleTitle = ArticleTitle ?? "",
ContentText = ContentText ?? "",
UpdateTime = DateTime.Now
});
if (oi > 0) //当有新的更新
{
var submitData = new Pri_ArticleDraft_Entity()
{
ArticleKey = ArticleKey,
ArticleTag = ArticleTag ?? "",
ArticleDesc = ArticleDesc ?? "",
AidStyle = AidStyle ?? "",
ArticleCategory = ArticleCategory ?? "",
ArticleTitle = ArticleTitle ?? "",
ContentText = ContentText ?? "",
UpdateTime = DateTime.Now
};
var olddraft = draftdal.GetPri_ArticleDraft(ArticleKey);
if (olddraft != null)
{
//必须在Draft中有这条记录修改才能生效，也就是说，只有点了保存按钮，产生了数据，才能够和temp数据进行关联，这样的话可以减少草稿内容（比如测试、或者打开页面没有做任何事情）的产生。
draftdal.UpdatePri_ArticleDraft(submitData);
}
}
//查询历史总次数
savecount = tempdal.GetSaveTempCountByArticleKey(ArticleKey);
_status = 1;
}
catch (Exception ex)
{
_status = 4;
_msg = ex.Message;
}
}
return(new { status = _status, msg = _msg, ak = ArticleKey, sc = savecount });
}
public int UpdatePri_ArticleDraft(Pri_ArticleDraft_Entity entity)
{
string sql = "UPDATE Pri_ArticleDraft SET ArticleTitle=@ArticleTitle, ArticleCategory=@ArticleCategory,ContentText=@ContentText,ArticleTag=@ArticleTag,ArticleDesc=@ArticleDesc,AidStyle=@AidStyle, UpdateTime=@UpdateTime WHERE ArticleKey=@ArticleKey;";
return(connection.Execute(sql, new { entity.ArticleTitle, entity.ArticleCategory, entity.ContentText, entity.ArticleTag, entity.ArticleDesc, entity.AidStyle, entity.UpdateTime, entity.ArticleKey }));
}
public IActionResult Submit([Bind("ArticleKey,ArticleTitle,ArticleCategory,ContentText,ArticleTag,ArticleDesc,AidStyle")] VM_Article article)
{
if (ModelState.IsValid)
{
if (article.ContentText != null)
{
var _cont = article.ContentText.Replace("<p>", "").Replace("<br>", "").Replace("</p>", "").Replace("</br>", ""); //去掉自带的样式
if (string.IsNullOrWhiteSpace(_cont))
{
article.ContentText = "";
}
}
if (string.IsNullOrWhiteSpace(article.ArticleTitle) && string.IsNullOrWhiteSpace(article.ContentText) && string.IsNullOrWhiteSpace(article.ArticleDesc) && string.IsNullOrWhiteSpace(article.AidStyle))
{
return(RedirectToAction("Edit", new { ArticleKey = article.ArticleKey }));
}
article.ContentText = _PubComService._Pri_ArticleImage_DataService.ReplaceImagesPlaceholder(article.ContentText, article.ArticleKey);
//将数据存入到Temp中去
var tempdal = _PubComService._Pri_ArticleDraft_Temp_DataService;
var draftdal = _PubComService._Pri_ArticleDraft_DataService;
//只要有新的内容，就存成草稿状态
int oi = tempdal.InsertPri_ArticleDraft_Temp(new Pri_ArticleDraft_Temp_Entity()
{
ArticleKey = article.ArticleKey,
ArticleTag = article.ArticleTag ?? "",
ArticleDesc = article.ArticleDesc ?? "",
AidStyle = article.AidStyle ?? "",
ArticleCategory = article.ArticleCategory ?? "",
ArticleTitle = article.ArticleTitle ?? "",
ContentText = article.ContentText ?? "",
UpdateTime = DateTime.Now
});
var submitData = new Pri_ArticleDraft_Entity()
{
ArticleKey = article.ArticleKey,
ArticleTag = article.ArticleTag ?? "",
ArticleDesc = article.ArticleDesc ?? "",
AidStyle = article.AidStyle ?? "",
ArticleCategory = article.ArticleCategory ?? "",
ArticleTitle = article.ArticleTitle ?? "",
ContentText = article.ContentText ?? "",
UpdateTime = DateTime.Now
};
var olddraft = draftdal.GetPri_ArticleDraft(article.ArticleKey);
if (olddraft == null)
{
//插入操作
draftdal.InsertPri_ArticleDraft(submitData);
}
else
{
//必须在Draft中有这条记录修改才能生效，也就是说，只有点了保存按钮，产生了数据，才能够和temp数据进行关联，这样的话可以减少草稿内容（比如测试、或者打开页面没有做任何事情）的产生。
draftdal.UpdatePri_ArticleDraft(submitData);
}
}
return(RedirectToAction("Edit", new { ArticleKey = article.ArticleKey }));
}
public int InsertPri_ArticleDraft(Pri_ArticleDraft_Entity entity)
{
string sql = "INSERT INTO Pri_ArticleDraft(ArticleKey,ArticleTitle,ArticleCategory,ContentText,ArticleTag,ArticleDesc,AidStyle,UpdateTime ) VALUES(@ArticleKey,@ArticleTitle,@ArticleCategory,@ContentText,@ArticleTag,@ArticleDesc,@AidStyle,GETDATE())";
return(connection.Execute(sql, new { entity.ArticleKey, entity.ArticleTitle, entity.ArticleCategory, entity.ContentText, entity.ArticleTag, entity.ArticleDesc, entity.AidStyle }));
}
