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); } }