package dell_Fence;
|
import javax.swing.*;
|
import javax.swing.table.DefaultTableModel;
|
import java.awt.*;
|
import java.sql.SQLException;
|
import java.util.List;
|
import java.util.ResourceBundle;
|
import dell_Fence.Dell_Fence;
|
import dell_Fence.Dell_FenceType;
|
import targets.Fence;
|
import publicsWay.TableUtils;
|
|
@SuppressWarnings("serial")
|
public class FenceListPanel extends JPanel {
|
private ResourceBundle messages;
|
private JTable fenceTable;
|
private DefaultTableModel tableModel;
|
private JTextField searchField;
|
|
// ×ÊÔ´¼üÖµ
|
private static final String TITLE_KEY = "fence.list.title";
|
private static final String SEARCH_KEY = "fence.list.search";
|
private static final String EDIT_KEY = "fence.list.edit";
|
private static final String DELETE_KEY = "fence.list.delete";
|
private static final String REFRESH_KEY = "fence.list.refresh";
|
private static final String COL_ID_KEY = "fence.list.column.id";
|
private static final String COL_NAME_KEY = "fence.list.column.name";
|
private static final String COL_TYPE_KEY = "fence.list.column.type";
|
private static final String COL_DEPT_KEY = "fence.list.column.department";
|
private static final String COL_LAYER_KEY = "fence.list.column.layer";
|
private static final String COL_START_KEY = "fence.list.column.startTime";
|
private static final String COL_END_KEY = "fence.list.column.endTime";
|
private static final String COL_COLOR_KEY = "fence.list.column.color";
|
private static final String COL_ENABLED_KEY = "fence.list.column.enabled";
|
private static final String COL_COMPANY_KEY = "fence.list.column.company";
|
private static final String COL_ADD_TIME_KEY = "fence.list.column.addTime";
|
|
public FenceListPanel(ResourceBundle messages) {
|
this.messages = messages;
|
setLayout(new BorderLayout());
|
initUI();
|
loadFenceData();
|
}
|
|
private void initUI() {
|
// ¶¥²¿Ãæ°å
|
JPanel topPanel = new JPanel(new BorderLayout());
|
topPanel.setBorder(BorderFactory.createTitledBorder(getResourceString(TITLE_KEY)));
|
|
// ËÑË÷Ãæ°å
|
JPanel searchPanel = new JPanel(new FlowLayout(FlowLayout.LEFT, 5, 0));
|
searchField = new JTextField(20);
|
searchPanel.add(new JLabel(getResourceString(COL_NAME_KEY) + ":"));
|
searchPanel.add(searchField);
|
|
// ËÑË÷°´Å¥
|
JButton searchButton = new JButton(getResourceString(SEARCH_KEY));
|
searchButton.addActionListener(e -> searchFences());
|
searchPanel.add(searchButton);
|
|
// ²Ù×÷°´Å¥Ãæ°å
|
JPanel actionPanel = new JPanel(new FlowLayout(FlowLayout.RIGHT, 5, 0));
|
|
// ±à¼°´Å¥
|
JButton editButton = new JButton(getResourceString(EDIT_KEY));
|
editButton.addActionListener(e -> showEditDialog());
|
actionPanel.add(editButton);
|
|
// ɾ³ý°´Å¥
|
JButton deleteButton = new JButton(getResourceString(DELETE_KEY));
|
deleteButton.addActionListener(e -> deleteSelectedFence());
|
actionPanel.add(deleteButton);
|
|
// ˢа´Å¥
|
JButton refreshButton = new JButton(getResourceString(REFRESH_KEY));
|
refreshButton.addActionListener(e -> refreshData());
|
actionPanel.add(refreshButton);
|
|
// Ìí¼Ó×é¼þµ½¶¥²¿Ãæ°å
|
topPanel.add(searchPanel, BorderLayout.CENTER);
|
topPanel.add(actionPanel, BorderLayout.EAST);
|
add(topPanel, BorderLayout.NORTH);
|
|
// ±í¸ñÁÐÃû
|
String[] columnNames = {
|
getResourceString(COL_ID_KEY),
|
getResourceString(COL_NAME_KEY),
|
getResourceString(COL_TYPE_KEY),
|
getResourceString(COL_DEPT_KEY),
|
getResourceString(COL_LAYER_KEY),
|
getResourceString(COL_START_KEY),
|
getResourceString(COL_END_KEY),
|
getResourceString(COL_COLOR_KEY),
|
getResourceString(COL_ENABLED_KEY),
|
getResourceString(COL_COMPANY_KEY),
|
getResourceString(COL_ADD_TIME_KEY)
|
};
|
|
// ´´½¨±í¸ñ
|
fenceTable = TableUtils.createCommonTable(columnNames);
|
tableModel = (DefaultTableModel) fenceTable.getModel();
|
|
// Ìí¼Ó±í¸ñµ½¹ö¶¯Ãæ°å
|
JScrollPane scrollPane = new JScrollPane(fenceTable);
|
add(scrollPane, BorderLayout.CENTER);
|
}
|
|
private void loadFenceData() {
|
tableModel.setRowCount(0);
|
try {
|
List<Fence> fences = Dell_Fence.getAllFences();
|
for (Fence fence : fences) {
|
Object[] row = {
|
fence.getId(),
|
fence.getFenceName(),
|
getFenceTypeName(fence.getFenceType()),
|
fence.getRelatedDepartment(),
|
fence.getLayer(),
|
fence.getEffectiveTime(),
|
fence.getExpirationTime(),
|
getColorName(fence.getColor()),
|
fence.getIsEnabled().equals("1") ? "ÊÇ" : "·ñ",
|
fence.getCompany(),
|
fence.getAddedTime()
|
};
|
tableModel.addRow(row);
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
JOptionPane.showMessageDialog(this,
|
"¼ÓÔØΧÀ¸Êý¾Ýʧ°Ü: " + e.getMessage(),
|
"´íÎó",
|
JOptionPane.ERROR_MESSAGE);
|
}
|
}
|
|
private String getFenceTypeName(String typeCode) {
|
try {
|
return Dell_FenceType.getFenceTypeById(Integer.parseInt(typeCode)).getTypeName();
|
} catch (Exception e) {
|
return "δ֪ÀàÐÍ";
|
}
|
}
|
|
private String getColorName(String colorCode) {
|
switch (colorCode) {
|
case "0": return "ºìÉ«";
|
case "1": return "À¶É«";
|
case "2": return "ÂÌÉ«";
|
case "3": return "×ÏÉ«";
|
case "4": return "ÇàÉ«";
|
default: return "δ֪";
|
}
|
}
|
|
private void searchFences() {
|
String keyword = searchField.getText().trim().toLowerCase();
|
tableModel.setRowCount(0);
|
try {
|
List<Fence> fences = Dell_Fence.getAllFences();
|
for (Fence fence : fences) {
|
if (fence.getFenceName().toLowerCase().contains(keyword)) {
|
Object[] row = {
|
fence.getId(),
|
fence.getFenceName(),
|
getFenceTypeName(fence.getFenceType()),
|
fence.getRelatedDepartment(),
|
fence.getLayer(),
|
fence.getEffectiveTime(),
|
fence.getExpirationTime(),
|
getColorName(fence.getColor()),
|
fence.getIsEnabled().equals("1") ? "ÊÇ" : "·ñ",
|
fence.getCompany(),
|
fence.getAddedTime()
|
};
|
tableModel.addRow(row);
|
}
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
JOptionPane.showMessageDialog(this,
|
"ËÑË÷ΧÀ¸Ê§°Ü: " + e.getMessage(),
|
"´íÎó",
|
JOptionPane.ERROR_MESSAGE);
|
}
|
}
|
|
private void showEditDialog() {
|
int selectedRow = fenceTable.getSelectedRow();
|
if (selectedRow == -1) {
|
JOptionPane.showMessageDialog(this,
|
"ÇëÏÈÑ¡ÔñÒªÐ޸ĵÄΧÀ¸",
|
"Ìáʾ",
|
JOptionPane.WARNING_MESSAGE);
|
return;
|
}
|
|
int fenceId = Integer.parseInt(tableModel.getValueAt(selectedRow, 0).toString());
|
try {
|
Fence fence = Dell_Fence.getFenceById(String.valueOf(fenceId));
|
if (fence != null) {
|
EditFenceDialog dialog = new EditFenceDialog(
|
(JFrame) SwingUtilities.getWindowAncestor(this),
|
"ÐÞ¸ÄΧÀ¸",
|
true,
|
fence,
|
messages
|
);
|
dialog.setVisible(true);
|
|
if (dialog.isSaved()) {
|
refreshData();
|
}
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
JOptionPane.showMessageDialog(this,
|
"»ñȡΧÀ¸Êý¾Ýʧ°Ü: " + e.getMessage(),
|
"´íÎó",
|
JOptionPane.ERROR_MESSAGE);
|
}
|
}
|
|
private void deleteSelectedFence() {
|
int selectedRow = fenceTable.getSelectedRow();
|
if (selectedRow == -1) {
|
JOptionPane.showMessageDialog(this,
|
"ÇëÏÈÑ¡ÔñҪɾ³ýµÄΧÀ¸",
|
"Ìáʾ",
|
JOptionPane.WARNING_MESSAGE);
|
return;
|
}
|
|
int confirm = JOptionPane.showConfirmDialog(this,
|
"È·¶¨ÒªÉ¾³ýÑ¡ÖеÄΧÀ¸Âð£¿",
|
"È·ÈÏɾ³ý",
|
JOptionPane.YES_NO_OPTION);
|
|
if (confirm == JOptionPane.YES_OPTION) {
|
int fenceId = Integer.parseInt(tableModel.getValueAt(selectedRow, 0).toString());
|
try {
|
Dell_Fence.deleteFence(String.valueOf(fenceId));
|
refreshData();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
JOptionPane.showMessageDialog(this,
|
"ɾ³ýΧÀ¸Ê§°Ü: " + e.getMessage(),
|
"´íÎó",
|
JOptionPane.ERROR_MESSAGE);
|
}
|
}
|
}
|
|
private void refreshData() {
|
loadFenceData();
|
searchField.setText("");
|
}
|
|
private String getResourceString(String key) {
|
return messages.getString(key);
|
}
|
}
|
