public async Task <IActionResult> OnGetAsync(int id)
{
if (!base.CheckLogin())
{
return(Redirect("/login/index"));
}
if (id > 0)
{
await Task.Run(() =>
{
//获取信息
this.ArticleCategoryEntity = dal.GetArticleCategory(id);
});
if (ArticleCategoryEntity == null)
{
return(RedirectToPage("ArticleCategoryManagement"));
}
}
return(Page());
}
public int UpdateArticleCategory(Base_ArticleCategory_Entity entity)
{
string sql = "UPDATE Base_ArticleCategory SET ArticleCategoryCode=@ArticleCategoryCode, ArticleCategoryName=@ArticleCategoryName, DelStatus=@DelStatus,UpdateTime=GETDATE() WHERE Id=@Id;";
return(connection.Execute(sql, new { ArticleCategoryName = entity.ArticleCategoryName, ArticleCategoryCode = entity.ArticleCategoryCode, DelStatus = entity.DelStatus, Id = entity.Id }));
}
public int InsertArticleCategory(Base_ArticleCategory_Entity entity)
{
string sql = "INSERT INTO Base_ArticleCategory(ArticleCategoryName, ArticleCategoryCode,DelStatus,UpdateTime ) VALUES(@ArticleCategoryName,@ArticleCategoryCode,@DelStatus,GETDATE())";
return(connection.Execute(sql, new { ArticleCategoryName = entity.ArticleCategoryName, ArticleCategoryCode = entity.ArticleCategoryCode, DelStatus = entity.DelStatus }));
}
public int InsertArticleCategory(Base_ArticleCategory_Entity entity)
{
string sql = "INSERT INTO Base_ArticleCategory(ArticleCategoryName, ArticleCategoryCode ) VALUES(@ArticleCategoryName,@ArticleCategoryCode)";
return(connection.Execute(sql, new { ArticleCategoryName = entity.ArticleCategoryName, ArticleCategoryCode = entity.ArticleCategoryCode }));
}
