//用户注册 public int adminRegister(AdminOpr adminOpr) { int query = 0; if (oracleConnection == null) { oracleConnection = new OracleConnection(connectionString); } try { oracleConnection.Open(); OracleCommand oracleCommand = oracleConnection.CreateCommand(); string sql = @"INSERT INTO manager (manager_name,manager_id,age,sex,telephone,password) " + " VALUES('" + adminOpr.adminName + "','" + adminOpr.id + "','" + adminOpr.age + "','" + adminOpr.sex + "','" + adminOpr.phone + "','" + adminOpr.password + "')"; oracleCommand.CommandText = sql; query = oracleCommand.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { oracleConnection.Close(); } //MessageBox.Show(query.ToString()); return(query); }
public Admin_Opr_Reader(AdminOpr adminOpr) { this.adminOpr = adminOpr; InitializeComponent(); oracleConnection = new OracleConnection(connectionString); ltCus = new List <Users>(); Update(); }
private void Button_Click(object sender, RoutedEventArgs e) // 登录 { AdminOpr adminOpr = new AdminOpr(id.Text, password.Password); if (adminOpr.adminLogin()) { //MessageBox.Show("登录成功"); Administrator administrator = new Administrator(adminOpr); Application.Current.MainWindow = administrator; this.Close(); administrator.Show(); } else { MessageBox.Show("登录失败"); } }
public Adaim_Register() { adminOpr = new AdminOpr(); InitializeComponent(); }