/// <summary>
/// ViewModel 转 DataModel
/// </summary>
/// <param name="articleVModel"></param>
/// <returns></returns>
public static ArticleInfo ArticleVModelToInfo(ArticleVModel articleVModel)
{
if (articleVModel == null)
{
return(new ArticleInfo());
}
return(new ArticleInfo
{
Id = articleVModel.Id,
Title = articleVModel.Title,
Content = articleVModel.Content,
Type = articleVModel.Type,
CommentNum = articleVModel.CommentNum,
Dot = articleVModel.Dot,
CreateTime = articleVModel.CreateTime,
UserId = articleVModel.UserId,
ImgNum = articleVModel.ImgNum,
AttachmentNum = articleVModel.AttachmentNum,
LastEditUserId = articleVModel.LastEditUserId,
Guid = articleVModel.Guid,
State = articleVModel.State,
Score = articleVModel.Score,
IsStick = articleVModel.IsStick,
IsCloseComment = articleVModel.IsCloseComment,
CloseCommentReason = articleVModel.CloseCommentReason
});
}
/// <summary>
/// ViewModel 转 DataModel
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public static ArticleInfo ArticleVModelToInfo(ArticleVModel article)
{
if (article == null)
{
return(new ArticleInfo());
}
return(new ArticleInfo
{
Id = article.Id,
Title = article.Title,
Content = article.Content,
Type = article.Type,
CommentNum = article.CommentNum,
Dot = article.Dot,
CreateTime = article.CreateTime,
UserId = article.UserId,
ImgNum = article.ImgNum,
AttachmentNum = article.AttachmentNum,
LastEditUserId = article.LastEditUserId,
LastEditTime = article.LastEditTime,
Guid = article.Guid,
IsDelete = article.IsDelete,
State = article.State,
RefuseReason = article.RefuseReason,
BType = article.BType,
DianZanNum = article.DianZanNum,
Score = article.Score,
IsStick = article.IsStick,
IsJiaJing = article.IsJiaJing,
IsCloseComment = article.IsCloseComment,
CloseCommentReason = article.CloseCommentReason
});
}
public ActionResult Add()
{
var vm = new ArticleVModel {
Guid = Guid.NewGuid()
};
return(View(vm));
}
public JsonResult Add(ArticleVModel model)
{
var result = new JsonResultModel();
if (ModelState.IsValid)
{
//add
result.ResultState = Articles.AddArticle(Articles.ArticleVModelToInfo(model)) > 0;
}
else
{
result.ResultState = false;
result.Message = ModelStateHelper.GetAllErrorMessage(ModelState);
}
return(Json(result));
}
public JsonResult Edit(ArticleVModel model)
{
var result = new JsonResultModel();
if (ModelState.IsValid)
{
model.LastEditUserId = CurrentUserInfo.Id;
//edit user
result.ResultState = Articles.UpdateArticle(Articles.ArticleVModelToInfo(model)) > 0;
}
else
{
result.ResultState = false;
result.Message = ModelStateHelper.GetAllErrorMessage(ModelState);
}
return(Json(result));
}
/// <summary>
/// 修改文章主体信息
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public static int UpdateArticlePart(ArticleVModel article)
{
string sql = @"UPDATE [Article] SET
Title=@Title,
Content=@Content,
Type=@Type,
State=@State,
ImgNum=@ImgNum,
AttachmentNum=@AttachmentNum,
LastEditUserId=@LastEditUserId,
LastEditTime=GETDATE()
WHERE Id=@Id";
var par = new DynamicParameters();
par.Add("@Id", article.Id, DbType.Int32);
par.Add("@Title", article.Title, DbType.String);
par.Add("@Content", article.Content, DbType.AnsiString);
par.Add("@Type", article.Type, DbType.Int32);
par.Add("@State", article.State, DbType.Int32);
par.Add("@ImgNum", article.ImgNum, DbType.Int32);
par.Add("@AttachmentNum", article.AttachmentNum, DbType.Int32);
par.Add("@LastEditUserId", article.LastEditUserId, DbType.Int32);
return(DapWrapper.InnerExecuteSql(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 更新文章
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public bool UpdateArticle(ArticleVModel article)
{
return(Articles.UpdateArticlePart(article) > 0);
}
/// <summary>
/// 添加文章
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <long> Add(ArticleVModel model)
{
return(await Task.Run(() => Articles.AddArticle(Articles.ArticleVModelToInfo(model))));
}
public ActionResult Add()
{
var vm = new ArticleVModel();
return(View(vm));
}
/// <summary>
/// 修改文章主体信息
/// </summary>
/// <param name="article"></param>
/// <returns></returns>
public static int UpdateArticlePart(ArticleVModel article)
{
return(DataProvider.Articles.UpdateArticlePart(article));
}
