示例#1
0
 public void saveStaff(Staff sta)
 {
     cmd.CommandText = "INSERT INTO staff(name, address, email, phone, birthday, role)" +
                 " values(@name, @address, @email, @phone, @birthday, @role)";
             cmd.Parameters.AddWithValue("@name", sta.getName());
             cmd.Parameters.AddWithValue("@address", sta.getAddress());
             cmd.Parameters.AddWithValue("@email", sta.getEmail());
             cmd.Parameters.AddWithValue("@phone", sta.getPhone());
             cmd.Parameters.AddWithValue("@birthday", sta.getBirthday());
             cmd.Parameters.AddWithValue("@role", sta.getRoleId());
             cmd.ExecuteNonQuery();
             conn.Close();
 }
示例#2
0
 public void updateStaff(Staff sta)
 {
     cmd.CommandText = " UPDATE staff SET name = @name, address=@address, "+
                       " email = @email, phone = @phone, birthday=@birthday, role = @role "+
                       " where id = @id ";
     cmd.Parameters.AddWithValue("@name", sta.getName());
     cmd.Parameters.AddWithValue("@address", sta.getAddress());
     cmd.Parameters.AddWithValue("@email", sta.getEmail());
     cmd.Parameters.AddWithValue("@phone", sta.getPhone());
     cmd.Parameters.AddWithValue("@birthday", sta.getBirthday());
     cmd.Parameters.AddWithValue("@role", sta.getRoleId());
     cmd.Parameters.AddWithValue("@id", sta.getId());
     cmd.ExecuteNonQuery();
     conn.Close();
 }