From bf5b01b14dc7bfc214e646425a62f5593890d7e3 Mon Sep 17 00:00:00 2001
From: jinlin <jinlin>
Date: 星期六, 08 十一月 2025 22:05:37 +0800
Subject: [PATCH] 清洗数据库日期错误，并且导入日期通用化处理
---
src/main/java/com/example/client/service/ProgressPromptService.java | 114 ++++++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 105 insertions(+), 9 deletions(-)
diff --git a/src/main/java/com/example/client/service/ProgressPromptService.java b/src/main/java/com/example/client/service/ProgressPromptService.java
index 25b3343..cd71895 100644
--- a/src/main/java/com/example/client/service/ProgressPromptService.java
+++ b/src/main/java/com/example/client/service/ProgressPromptService.java
@@ -1,16 +1,19 @@
package com.example.client.service;
import com.example.client.dto.ColumnDto;
+import com.example.client.dto.JComboBoxItem;
import com.example.client.utils.CommonTable;
-import com.example.server.progressTrack.Dto.StatistReportsDto;
+import com.example.client.utils.Compute;
+import com.example.client.utils.GBC;
import com.example.server.progressTrack.model.DjJdgzTrackRecord;
import com.example.server.progressTrack.service.DjJdgzTrackRecordService;
+import com.example.server.teamGroup.service.SysTeamGroupClassService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import javax.swing.*;
-import java.awt.event.WindowAdapter;
-import java.awt.event.WindowEvent;
+import java.awt.*;
+import java.awt.event.*;
import java.util.ArrayList;
import java.util.List;
@@ -21,6 +24,9 @@
private DjJdgzTrackRecordService djJdgzTrackRecordService;
private JTable table;
+ private List<DjJdgzTrackRecord> list;
+ @Autowired
+ private SysTeamGroupClassService sysTeamGroupClassService;
public void createTable(JFrame jFrame,Long level1NetworkId) {
JFrame frame1 = new JFrame("杩涘害妫�鏌�");
@@ -37,25 +43,115 @@
}
});
+ JPanel topJpanel = new JPanel();
+ GridBagLayout layout = new GridBagLayout();
+ topJpanel.setLayout(layout);
+ topJpanel.setPreferredSize(new Dimension(1200 - 20, 40));
+ topJpanel.setBackground(Color.WHITE);
+
+ JPanel centerJpanel = new JPanel();
+ centerJpanel.setPreferredSize(new Dimension(1200 - 20,700-40));
+ centerJpanel.setBackground(Color.WHITE);
+ frame1.add(topJpanel, BorderLayout.NORTH);
+ frame1.add(centerJpanel, BorderLayout.CENTER);
+
+ JComboBoxItem[] deptList = sysTeamGroupClassService.getDeptList();
+
+ JComboBoxItem[] teamList = sysTeamGroupClassService.getTeamList(null);
+
+ JLabel JLabel1 = new JLabel("閮ㄩ棬");
+ JComboBox<JComboBoxItem> comboBox1 = new JComboBox<>(deptList);
+ comboBox1.setPreferredSize(new Dimension(140, 28));
+ comboBox1.setMaximumSize(new Dimension(140, 28));
+
+ JComboBoxItem[] teamList1 = sysTeamGroupClassService.getTeamList(deptList[0].getId());
+
+ JLabel JLabel2 = new JLabel("涓撲笟");
+ JComboBox<JComboBoxItem> comboBox2 = new JComboBox<>(teamList1);
+ comboBox2.setPreferredSize(new Dimension(140, 28));
+ comboBox2.setMaximumSize(new Dimension(140, 28));
+
+ JTextField sb = new JTextField(16);
+ sb.setPreferredSize(new Dimension(140, 28));
+ sb.setMaximumSize(new Dimension(140, 28));
+
+ JButton query = new JButton("鏌ヨ");
+ query.setPreferredSize(new Dimension(90, 28));
+
+ topJpanel.add(JLabel1, new GBC(0, 0, 1, 1).setAnchor(GBC.SOUTHEAST).setInsets(5));
+ topJpanel.add(comboBox1, new GBC(1, 0, 2, 1).setAnchor(GBC.SOUTHWEST).setInsets(5));
+
+ topJpanel.add(JLabel2, new GBC(3, 0, 1, 1).setAnchor(GBC.SOUTHEAST).setInsets(5));
+ topJpanel.add(comboBox2, new GBC(4, 0, 2, 1).setAnchor(GBC.SOUTHWEST).setInsets(5));
+
+ topJpanel.add(sb, new GBC(8, 0, 3, 1).setInsets(5));
+ topJpanel.add(query, new GBC(15, 0, 1, 1).setInsets(5));
+
+
List<ColumnDto> columnDto = new ArrayList<>();
- List<DjJdgzTrackRecord> list = djJdgzTrackRecordService.prompt(level1NetworkId);
+ list = djJdgzTrackRecordService.prompt(level1NetworkId, null, null, null);
//columnDto.add(new ColumnDto("ID", "id", -1, null,false));
columnDto.add(new ColumnDto("宸ョ▼鍚嶇О", "ProjectName", 280, null, false, null,null));
- columnDto.add(new ColumnDto("鐝粍涓撲笟", "teamGroupName", 150, null, false, null,null));
+ columnDto.add(new ColumnDto("鐝粍涓撲笟", "teamgroupName", 150, null, false, null,null));
columnDto.add(new ColumnDto("涓�绾ц妭鐐�", "level1NodeName", 150, null, false, null,null));
columnDto.add(new ColumnDto("浜岀骇鑺傜偣", "level2NodeName", 150, null, false, null,null));
columnDto.add(new ColumnDto("椤圭洰鍚嶇О", "level3NetworkName", 150, null, false, null,null));
columnDto.add(new ColumnDto("褰撳墠鑺傜偣", "level3NodeName", 150, null, false, null,null));
columnDto.add(new ColumnDto("鐘舵��", "status", 150, null, false, null,null));
-
-
table = CommonTable.createCommonTable(list, columnDto);
table.setRowHeight(25);
- table.setAutoCreateRowSorter(true);
+
+
+ comboBox1.addItemListener(new ItemListener() {
+ public void itemStateChanged(final ItemEvent event) {
+ JComboBoxItem dept = (JComboBoxItem) comboBox1.getSelectedItem();
+ Long deptId = dept.getId();
+ JComboBoxItem[] teamList = sysTeamGroupClassService.getTeamList(deptId);
+ comboBox2.setModel(new DefaultComboBoxModel<>(teamList));
+
+ JComboBoxItem team = (JComboBoxItem) comboBox2.getSelectedItem();
+
+ list = djJdgzTrackRecordService.prompt(level1NetworkId,deptId,team.getId(),null);
+
+ CommonTable.refreshTable(list, columnDto, table);
+ table.setRowHeight(25);
+
+ table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
+ }
+ });
+
+ comboBox2.addItemListener(new ItemListener() {
+ public void itemStateChanged(final ItemEvent event) {
+ JComboBoxItem dept = (JComboBoxItem) comboBox1.getSelectedItem();
+ JComboBoxItem team = (JComboBoxItem) comboBox2.getSelectedItem();
+
+ list = djJdgzTrackRecordService.prompt(level1NetworkId,dept.getId(),team.getId(),null);
+
+ CommonTable.refreshTable(list, columnDto, table);
+ table.setRowHeight(25);
+
+ table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
+ }
+ });
+
+ query.addActionListener(new ActionListener() {
+ @Override
+ public void actionPerformed(ActionEvent e) {
+ list = djJdgzTrackRecordService.prompt(level1NetworkId, null, null,sb.getText());
+
+ CommonTable.refreshTable(list, columnDto, table);
+ table.setRowHeight(25);
+
+ table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
+ }
+ });
+
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
JScrollPane scrollTable = new JScrollPane(table);
- frame1.add(scrollTable);
+ scrollTable.setPreferredSize(new Dimension(1200 - 20,700-40));
+
+ centerJpanel.add(scrollTable);
frame1.setVisible(true);
}
--
Gitblit v1.9.1