public int Insert(T_BLOG_CATELOG categry, IDbTransaction transaction)
{
using (var conn = ConnentionFactory.GetOpenSqlConnection(ConnStr))
{
var resBlogID = conn.Query <int>(@"INSERT INTO T_BLOG_CATELOG(CatelogName,Remark,CreateUser,UpdateUser) VALUES (@CatelogName,@Remark,@CreateUser,@UpdateUser);" +
" SELECT @@IDENTITY", categry, transaction).First();
return(resBlogID);
}
}
public IActionResult Add(int?id)
{
T_BLOG_CATELOG categ = new T_BLOG_CATELOG();
if (id != null)
{
categ = _categ.GetList("CatelogID=" + id).First();
}
return(View(categ));
}
/// <summary>
/// 修改博客类别
/// </summary>
/// <param name="categry"></param>
/// <returns></returns>
public bool Update(T_BLOG_CATELOG categry)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_BLOG_CATELOG set ");
strSql.Append("ParentCategID=@ParentCategID,");
strSql.Append("CatelogName=@CatelogName,");
strSql.Append("UpdateUser=@UpdateUser,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Remark=@Remark");
strSql.Append(" WHERE CatelogID=@CatelogID");
using (var conn = ConnentionFactory.GetOpenSqlConnection(ConnStr))
{
int resBlogID = conn.Execute(strSql.ToString(), categry);
return(resBlogID > 0);
}
}
public IActionResult Add(T_BLOG_CATELOG model)
{
//int userId = HttpContext.Session.GetInt32("userid")==null?1:int.Parse(HttpContext.Session.GetInt32("userid").ToString());
int userId = int.Parse(User.Identities.First(u => u.IsAuthenticated)
.FindFirst(ClaimTypes.PrimarySid).Value);
if (model.CatelogID == 0)
{
model.CreateUser = userId;
model.CreateTime = DateTime.Now;
_categ.Insert(model);
}
else
{
model.UpdateUser = userId;
model.UpdateTime = DateTime.Now;
_categ.Update(model);
}
return(Redirect("/Admin/Categry/Index"));
}
