public int Insert(T_BLOG_TAG model, IDbTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_BLOG_TAG(");
strSql.Append("TagName,CreateUser,CreateTime,UpdateUser,UpdateTime,Remark)");
strSql.Append(" values (");
strSql.Append("@TagName,@CreateUser,@CreateTime,@UpdateUser,@UpdateTime,@Remark)");
strSql.Append(" ;SELECT @@IDENTITY;");
using (var conn = ConnentionFactory.GetOpenSqlConnection(ConnStr))
{
int tagBlogID = conn.Query <int>(strSql.ToString(), model, transaction).First();
return(tagBlogID);
}
}
/// <summary>
/// 修改标签
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(T_BLOG_TAG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_BLOG_TAG set ");
strSql.Append("TagName=@TagName,");
strSql.Append("CreateUser=@CreateUser,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("UpdateUser=@UpdateUser,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Remark=@Remark");
strSql.Append(" where TagID=@TagID");
using (var conn = ConnentionFactory.GetOpenSqlConnection(ConnStr))
{
int resBlogID = conn.Execute(strSql.ToString(), model);
return(resBlogID > 0);
}
}
