/// <summary>
/// 修改
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int Change(MOD.User user)
{
string sql = "update user set username='******'" + user.Key + "'," +
"userNumber='" + user.Number + "',userWhere='" + user.Where + "' where ID='" + user.ID1 + "'";
return(xiugaiuser(sql));
}
//查询
public MOD.User SelectUser(string userName)
{
sqlConnection.Open();
MySqlCommand mySqlCommand = new MySqlCommand("select * from user where UserName='******'", sqlConnection);
MySqlDataReader reader = mySqlCommand.ExecuteReader();
if (reader.Read())
{
MOD.User user = new MOD.User(Convert.ToInt32(reader[0].ToString()), reader[1].ToString(), reader[2].ToString(),
reader[3].ToString(), reader[4].ToString());
sqlConnection.Clone();
return(user);
}
else
{
sqlConnection.Close();
return(null);
}
}
//增加
public int AddUser(MOD.User user)
{
sqlConnection.Open();
MySqlCommand mySqlCommand = new MySqlCommand();
mySqlCommand.Connection = sqlConnection;
mySqlCommand.CommandText = "insert into User (UserName ,UserKey,UserNumber,UserWhere) " +
"values (@UserName ,@Key ,@Number,@Where)";
mySqlCommand.Parameters.AddRange(
new MySqlParameter[]
{
new MySqlParameter("@UserName", user.UserName),
new MySqlParameter("@Key", user.Key),
new MySqlParameter("@Number", user.Number),
new MySqlParameter("@Where", user.Where)
}
);
int a = mySqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return(a);
}
