/// <summary> /// 增加一条数据 /// </summary> public int Add(Mxm.Model.recommend_content model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into recommend_content("); strSql.Append("title,content,url,picture,group_id)"); strSql.Append(" values ("); strSql.Append("@title,@content,@url,@picture,@group_id)"); strSql.Append(";select @@IDENTITY"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "title", DbType.String, model.title); db.AddInParameter(dbCommand, "content", DbType.String, model.content); db.AddInParameter(dbCommand, "url", DbType.String, model.url); db.AddInParameter(dbCommand, "picture", DbType.String, model.picture); db.AddInParameter(dbCommand, "group_id", DbType.Int32, model.group_id); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public Mxm.Model.recommend_content GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,title,content,url,picture,group_id from recommend_content "); strSql.Append(" where id=@id "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "id", DbType.Int32, id); Mxm.Model.recommend_content model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public Mxm.Model.recommend_content ReaderBind(IDataReader dataReader) { Mxm.Model.recommend_content model = new Mxm.Model.recommend_content(); object ojb; ojb = dataReader["id"]; if (ojb != null && ojb != DBNull.Value) { model.id = (int)ojb; } model.title = dataReader["title"].ToString(); model.content = dataReader["content"].ToString(); model.url = dataReader["url"].ToString(); model.picture = dataReader["picture"].ToString(); ojb = dataReader["group_id"]; if (ojb != null && ojb != DBNull.Value) { model.group_id = (int)ojb; } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(Mxm.Model.recommend_content model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update recommend_content set "); strSql.Append("title=@title,"); strSql.Append("content=@content,"); strSql.Append("url=@url,"); strSql.Append("picture=@picture,"); strSql.Append("group_id=@group_id"); strSql.Append(" where id=@id "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "id", DbType.Int32, model.id); db.AddInParameter(dbCommand, "title", DbType.String, model.title); db.AddInParameter(dbCommand, "content", DbType.String, model.content); db.AddInParameter(dbCommand, "url", DbType.String, model.url); db.AddInParameter(dbCommand, "picture", DbType.String, model.picture); db.AddInParameter(dbCommand, "group_id", DbType.Int32, model.group_id); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// ����ʵ������� /// </summary> public Mxm.Model.recommend_content ReaderBind(IDataReader dataReader) { Mxm.Model.recommend_content model=new Mxm.Model.recommend_content(); object ojb; ojb = dataReader["id"]; if(ojb != null && ojb != DBNull.Value) { model.id=(int)ojb; } model.title=dataReader["title"].ToString(); model.content=dataReader["content"].ToString(); model.url=dataReader["url"].ToString(); model.picture=dataReader["picture"].ToString(); ojb = dataReader["group_id"]; if(ojb != null && ojb != DBNull.Value) { model.group_id=(int)ojb; } return model; }