/// <summary> /// 更新一条数据 /// </summary> public bool Update(Bookhole_blog.Model.blog_type model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update blog_type set "); strSql.Append("Type_name=@Type_name,"); strSql.Append("Type_percentage=@Type_percentage"); strSql.Append(" where Type_id=@Type_id "); MySqlParameter[] parameters = { new MySqlParameter("@Type_name", MySqlDbType.VarChar, 5), new MySqlParameter("@Type_percentage", MySqlDbType.Int32, 3), new MySqlParameter("@Type_id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.Type_name; parameters[1].Value = model.Type_percentage; parameters[2].Value = model.Type_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Bookhole_blog.Model.blog_type model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into blog_type("); strSql.Append("Type_id,Type_name,Type_percentage)"); strSql.Append(" values ("); strSql.Append("@Type_id,@Type_name,@Type_percentage)"); MySqlParameter[] parameters = { new MySqlParameter("@Type_id", MySqlDbType.Int32, 11), new MySqlParameter("@Type_name", MySqlDbType.VarChar, 5), new MySqlParameter("@Type_percentage", MySqlDbType.Int32, 3) }; parameters[0].Value = model.Type_id; parameters[1].Value = model.Type_name; parameters[2].Value = model.Type_percentage; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Bookhole_blog.Model.blog_type DataRowToModel(DataRow row) { Bookhole_blog.Model.blog_type model = new Bookhole_blog.Model.blog_type(); if (row != null) { if (row["Type_id"] != null && row["Type_id"].ToString() != "") { model.Type_id = int.Parse(row["Type_id"].ToString()); } if (row["Type_name"] != null) { model.Type_name = row["Type_name"].ToString(); } if (row["Type_percentage"] != null && row["Type_percentage"].ToString() != "") { model.Type_percentage = int.Parse(row["Type_percentage"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Bookhole_blog.Model.blog_type GetModel(int Type_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Type_id,Type_name,Type_percentage from blog_type "); strSql.Append(" where Type_id=@Type_id "); MySqlParameter[] parameters = { new MySqlParameter("@Type_id", MySqlDbType.Int32, 11) }; parameters[0].Value = Type_id; Bookhole_blog.Model.blog_type model = new Bookhole_blog.Model.blog_type(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }