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