/// <summary>
/// Saves an entity.
/// </summary>
/// <param name="entity">The resource entity to save.</param>
/// <param name="cancellationToken">The optional token to monitor for cancellation requests.</param>
/// <returns>The changing result information.</returns>
public override async Task <ChangingResultInfo> SaveAsync(BlogCommentEntity entity, CancellationToken cancellationToken = default)
{
if (entity == null)
{
return(new ChangingResultInfo(ChangeErrorKinds.Argument, EntityNullTips));
}
if (string.IsNullOrWhiteSpace(UserId))
{
return(new ChangingResultInfo(ChangeErrorKinds.Unauthorized, LoginErrorTips));
}
if (string.IsNullOrWhiteSpace(entity.PublisherId) && entity.IsNew)
{
entity.PublisherId = UserId;
}
try
{
var result = await DataProvider.SaveAsync(entity, cancellationToken);
if (ResourceEntityExtensions.IsSuccessful(result))
{
return(new ChangingResultInfo <BlogCommentEntity>(result, entity, result.ToString() + " blog comment entity."));
}
return(result);
}
catch (Exception ex)
{
var err = ResourceEntityExtensions.TryCatch(ex);
if (err != null)
{
return(err);
}
throw;
}
}
/// <summary>
/// 添加博客信息
/// </summary>
public int Add(BlogCommentEntity blogCommentEntity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BlogComment(");
strSql.Append("BCID, BlogID, BCContent , CommentBy, CommentTime, Memo, CreatedBy, CreatedTime, ModifiedBy, ModifiedTime)");
strSql.Append(" values (");
strSql.Append("@BCID, @BlogID, @BCContent, @CommentBy, @CommentTime, @Memo, @CreatedBy, @CreatedTime,@ModifiedBy, @ModifiedTime)");
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
var param = new DynamicParameters();
param.Add("@BCID", blogCommentEntity.BCID, dbType: DbType.String);
param.Add("@BlogID", blogCommentEntity.BlogID, dbType: DbType.String);
param.Add("@BCContent", blogCommentEntity.BCContent, dbType: DbType.String);
param.Add("@CommentBy", blogCommentEntity.CommentBy, dbType: DbType.String);
param.Add("@CommentTime", blogCommentEntity.CommentTime, dbType: DbType.DateTime);
param.Add("@Memo", blogCommentEntity.Memo, dbType: DbType.String);
param.Add("@CreatedBy", blogCommentEntity.CreatedBy, dbType: DbType.String);
param.Add("@CreatedTime", blogCommentEntity.CreatedTime, dbType: DbType.DateTime);
param.Add("@ModifiedBy", blogCommentEntity.ModifiedBy, dbType: DbType.String);
param.Add("@ModifiedTime", blogCommentEntity.ModifiedTime, dbType: DbType.DateTime);
int i = connection.Execute(strSql.ToString(), param);
return(i);
}
}
/// <summary>
/// 编辑博客评论
/// </summary>
/// <param name="sBlogID"></param>
/// <returns></returns>
public IActionResult Update(string sBCID)
{
BlogCommentEntity m = null;
if (!string.IsNullOrEmpty(sBCID))
{
m = blogCommentDAL.GetBlogCommentByBCID(sBCID);
}
return(View(m));
}
/// <summary>
/// 获取所有的博客列表信息
/// </summary>
/// <returns></returns>
public IActionResult Index(string sBlogID)
{
List <BlogCommentEntity> blogcommentlist = new List <BlogCommentEntity>();
BlogCommentEntity blogcomment = new BlogCommentEntity();
Hashtable has = new Hashtable();
blogcommentlist = blogCommentDAL.GetBlogCommentByBlogID(sBlogID);
blogcomment.BlogID = sBlogID;
blogcommentlist.Add(blogcomment);
return(View(blogcommentlist));
}
/// <summary>
/// 更新博客信息
/// </summary>
public bool Update(BlogCommentEntity blogCommentEntity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BlogComment set ");
strSql.Append(" BCContent=@BCContent, ModifiedTime=getdate() ");
strSql.Append(" where BCID=@BCID ");
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
int i = connection.Execute(strSql.ToString(), blogCommentEntity);
return(i > 0);
}
}
/// <summary>
/// 添加博客
/// </summary>
/// <param name="sBlogID"></param>
/// <returns></returns>
public IActionResult Add(string sBlogID)
{
BlogCommentEntity m = null;
if (!string.IsNullOrEmpty(sBlogID))
{
m = blogCommentDAL.GetOneBlogCommentByBlogID(sBlogID);
if (m == null)
{
m = new BlogCommentEntity();
m.BlogID = sBlogID;
}
}
return(View(m));
}
/// <summary>
/// 根据ID获取博客评论信息
/// </summary>
public BlogCommentEntity GetBlogCommentByBCID(string sBCID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from BlogComment ");
strSql.Append(" where BCID=@BCID ");
BlogCommentEntity blogcomment = null;
using (var connection = ConnectionFactory.GetOpenConnection(ConnStr))
{
var param = new DynamicParameters();
param.Add("@BCID", sBCID, dbType: DbType.String);
blogcomment = connection.QuerySingle <BlogCommentEntity>(strSql.ToString(), param);
}
return(blogcomment);
}
public IActionResult Update(BlogCommentEntity blogCommentEntity)
{
BlogCommentEntity m = null;
if (!string.IsNullOrEmpty(blogCommentEntity.BCID))
{
//修改
m = blogCommentDAL.GetBlogCommentByBCID(blogCommentEntity.BCID);
if (m != null)
{
blogCommentEntity.ModifiedTime = DateTime.Now;
blogCommentEntity.ModifiedBy = this.User.Identity.Name;
blogCommentDAL.Update(blogCommentEntity);
}
}
return(Redirect("/BlogComment/Index?sBlogID=" + blogCommentEntity.BlogID));
}
public IActionResult Add(BlogCommentEntity blogCommentEntity)
{
if (string.IsNullOrEmpty(this.User.Identity.Name))
{
return(Content("您尚未登录用户"));
}
if (string.IsNullOrEmpty(blogCommentEntity.BCID))
{
//新增
blogCommentEntity.BCID = Guid.NewGuid().ToString();
blogCommentEntity.CreatedTime = DateTime.Now;
blogCommentEntity.CommentTime = DateTime.Now;
blogCommentEntity.CommentBy = this.User.Identity.Name;
blogCommentEntity.CreatedBy = this.User.Claims.First().Value;
blogCommentDAL.Add(blogCommentEntity);
}
return(Redirect("/BlogComment/Index?sBlogID=" + blogCommentEntity.BlogID));
}
public IActionResult Del(string sBCID)
{
BlogCommentEntity m = null;
if (!string.IsNullOrEmpty(sBCID))
{
m = blogCommentDAL.GetBlogCommentByBCID(sBCID);
if (m != null)
{
bool b = blogCommentDAL.DeleteBlogCommentByBCID(sBCID);
if (b)
{
return(Content("删除成功！"));
}
else
{
return(Content("删除失败，请联系管理员！"));
}
}
}
return(null);
}
/// <summary>
/// Saves an entity.
/// </summary>
/// <param name="entity">The resource entity to save.</param>
/// <param name="cancellationToken">The optional token to monitor for cancellation requests.</param>
/// <returns>The changing result information.</returns>
public Task <ChangeMethods> SaveAsync(BlogCommentEntity entity, CancellationToken cancellationToken = default)
{
var context = GetContext(false);
return(DbResourceEntityExtensions.SaveAsync(context.BlogComments, context.SaveChangesAsync, entity, cancellationToken));
}
public Task <IActionResult> SaveAsync([FromBody] BlogCommentEntity entity)
{
return(this.SaveSnsEntityAsync(entity, (sns, e, cancellationToken) => sns.SaveAsync(entity, cancellationToken), Logger, new EventId(17001328, "SaveEntity")));
}
