/// <summary>更新一条数据 /// /// </summary> public bool Update(Niunan.Blog.Model.Blog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update `blog` set "); strSql.Append("createdate=@createdate, title=@title, body=@body, body_md=@body_md, visitnum=@visitnum, cabh=@cabh, caname=@caname, remark=@remark, sort=@sort, updatetime=@updatetime "); strSql.Append(" where id=@id "); using (var connection = ConnectionFactory.GetOpenConnection(ConnStr)) { int i = connection.Execute(strSql.ToString(), model); return(i > 0); } }
/// <summary>得到一个对象实体 /// /// </summary> public Niunan.Blog.Model.Blog GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from `blog` "); strSql.Append(" where id=@id "); Niunan.Blog.Model.Blog model = null; using (var connection = ConnectionFactory.GetOpenConnection(ConnStr)) { model = connection.QuerySingleOrDefault <Niunan.Blog.Model.Blog>(strSql.ToString(), new { id = id }); } return(model); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Niunan.Blog.Model.Blog model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into `blog`("); strSql.Append("createdate, title, body, body_md, visitnum, cabh, caname, remark, sort, updatetime )"); strSql.Append(" values ("); strSql.Append("@createdate, @title, @body, @body_md, @visitnum, @cabh, @caname, @remark, @sort, @updatetime )"); strSql.Append(";select @@IDENTITY"); using (var connection = ConnectionFactory.GetOpenConnection(ConnStr)) { int i = connection.QuerySingle <int>(strSql.ToString(), model); return(i); } }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Niunan.Blog.Model.Blog GetModelByCond(string cond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from `blog` "); if (!string.IsNullOrEmpty(cond)) { strSql.Append(" where " + cond); } strSql.Append(" limit 1;"); Niunan.Blog.Model.Blog model = null; using (var connection = ConnectionFactory.GetOpenConnection(ConnStr)) { model = connection.QuerySingleOrDefault <Niunan.Blog.Model.Blog>(strSql.ToString()); } return(model); }