//录入设备 private void Add_NewEquipment(object sender, RoutedEventArgs e) { AddEquipment add = new AddEquipment();; EquipmentClass equip = new EquipmentClass(); RoomClass room = new RoomClass(); MySqlDataReader roomReader = room.queryRoomsName(); MySqlDataReader typeReader = room.getTypeList(); MySqlDataReader reader = equip.getMaxId(); if (reader.Read()) { // ReaderAndWriterConnection EpcNumber = new ReaderAndWriterConnection(); int i = 1; if (reader["ID"].ToString().Equals("") || reader["ID"] == null) { add.ID.Content = i; add.numberStr.Text = ReaderAndWriterConnection.getEPCCode(i); } else { add.ID.Content = reader["ID"]; add.numberStr.Text = ReaderAndWriterConnection.getEPCCode(int.Parse(reader["ID"].ToString())); } } ComboBox rooms = add.roomBox; ComboBoxItem check = new ComboBoxItem(); check.Content = "请选择..."; check.Tag = ""; check.IsSelected = true; rooms.Items.Add(check); while (roomReader.Read()) { check = new ComboBoxItem(); check.Content = roomReader["ROOM_NAME"]; check.Tag = roomReader["ID"]; rooms.Items.Add(check); } ComboBox types = add.typeBox; ComboBoxItem checkType = new ComboBoxItem(); checkType.Content = "请选择..."; checkType.Tag = ""; checkType.IsSelected = true; types.Items.Add(checkType); while (typeReader.Read()) { if (int.Parse(typeReader["ID"].ToString()) == 4) { continue; } else { ComboBoxItem TypeItems = new ComboBoxItem(); TypeItems.Content = typeReader["TYPE_NAME"]; TypeItems.Tag = typeReader["ID"]; types.Items.Add(TypeItems); } } add.Owner = Window.GetWindow(this); add.ShowDialog(); }
//录入设备 private void Add_NewEquipment(object sender, RoutedEventArgs e) { AddEquipment add = new AddEquipment(); ; EquipmentClass equip = new EquipmentClass(); RoomClass room = new RoomClass(); MySqlDataReader roomReader = room.queryRoomsName(); MySqlDataReader typeReader = room.getTypeList(); MySqlDataReader reader = equip.getMaxId(); if (reader.Read()) { // ReaderAndWriterConnection EpcNumber = new ReaderAndWriterConnection(); int i = 1; if (reader["ID"].ToString().Equals("") || reader["ID"] == null) { add.ID.Content = i; add.numberStr.Text = ReaderAndWriterConnection.getEPCCode(i); } else { add.ID.Content = reader["ID"]; add.numberStr.Text = ReaderAndWriterConnection.getEPCCode(int.Parse(reader["ID"].ToString())); } } ComboBox rooms = add.roomBox; ComboBoxItem check = new ComboBoxItem(); check.Content = "请选择..."; check.Tag = ""; check.IsSelected = true; rooms.Items.Add(check); while (roomReader.Read()) { check = new ComboBoxItem(); check.Content = roomReader["ROOM_NAME"]; check.Tag = roomReader["ID"]; rooms.Items.Add(check); } ComboBox types = add.typeBox; ComboBoxItem checkType = new ComboBoxItem(); checkType.Content = "请选择..."; checkType.Tag = ""; checkType.IsSelected = true; types.Items.Add(checkType); while (typeReader.Read()) { if (int.Parse(typeReader["ID"].ToString()) == 4) { continue; } else { ComboBoxItem TypeItems = new ComboBoxItem(); TypeItems.Content = typeReader["TYPE_NAME"]; TypeItems.Tag = typeReader["ID"]; types.Items.Add(TypeItems); } } add.Owner = Window.GetWindow(this); add.ShowDialog(); }