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