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