/// <summary> /// 根据cabh取实体类 /// </summary> /// <param name="cabh"></param> /// <returns></returns> public Niunan.CaiPiao.Model.News GetModelByCabh(string cabh) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from news where cabh=@cabh limit 1"); Niunan.CaiPiao.Model.News model = null; using (var connection = ConnectionFactory.GetOpenConnection(ConnStr)) { model = connection.QuerySingleOrDefault <Niunan.CaiPiao.Model.News>(strSql.ToString(), new { cabh = cabh }); } return(model); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Niunan.CaiPiao.Model.News model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update news set "); strSql.Append("createtime=@createtime, title=@title, body=@body, cabh=@cabh, caname=@caname, visitnum=@visitnum "); 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.CaiPiao.Model.News GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from news "); strSql.Append(" where id=@id "); Niunan.CaiPiao.Model.News model = null; using (var connection = ConnectionFactory.GetOpenConnection(ConnStr)) { model = connection.QuerySingleOrDefault <Niunan.CaiPiao.Model.News>(strSql.ToString(), new { id = id }); } return(model); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Niunan.CaiPiao.Model.News model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into news("); strSql.Append("createtime, title, body, cabh, caname, visitnum )"); strSql.Append(" values ("); strSql.Append("@createtime, @title, @body, @cabh, @caname, @visitnum ) ;select @@IDENTITY"); using (var connection = ConnectionFactory.GetOpenConnection(ConnStr)) { int i = connection.QueryFirst <int>(strSql.ToString(), model); return(i); } }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Niunan.CaiPiao.Model.News GetModelByCond(string cond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from news "); if (!string.IsNullOrEmpty(cond)) { strSql.Append(" where " + cond); } Niunan.CaiPiao.Model.News model = null; using (var connection = ConnectionFactory.GetOpenConnection(ConnStr)) { model = connection.QuerySingleOrDefault <Niunan.CaiPiao.Model.News>(strSql.ToString()); } return(model); }