package com.vci.client.omd.btm.ui;
|
|
import java.awt.BorderLayout;
|
import java.awt.Dimension;
|
import java.awt.FlowLayout;
|
import java.awt.Toolkit;
|
import java.awt.event.ActionEvent;
|
import java.awt.event.ActionListener;
|
import java.util.List;
|
import javax.swing.JButton;
|
import javax.swing.JCheckBox;
|
import javax.swing.JDialog;
|
import javax.swing.JOptionPane;
|
import javax.swing.JPanel;
|
import javax.swing.JScrollPane;
|
import javax.swing.table.JTableHeader;
|
import javax.swing.table.TableColumn;
|
import org.jdesktop.swingx.JXTable;
|
import org.jdesktop.swingx.decorator.HighlighterFactory;
|
|
import com.vci.client.omd.linktype.LinkTypeStart;
|
import com.vci.client.ui.table.CheckBoxEditor;
|
import com.vci.client.ui.table.CheckBoxRenderer;
|
import com.vci.corba.common.VCIError;
|
|
public class DeleteDataDialog extends JDialog{
|
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 2315167245802578900L;
|
|
private String[] tables = new String[]{"pl_qtemplate", "PL_QTEMPLATEDEF",
|
"pl_typeright", "plcommandparameter", "plpagedefination",
|
"pluilayout", "pltabbutton", "pltabpage", "plportalvi",
|
"plreleasedobj"
|
};
|
/**
|
* workFlowTables 中的表有主外键关系,当表主键或唯一键被引用为外键时,
|
* 就算引用方没有数据, truncate还不是不能删除表中数据, 而 delete可以.
|
*/
|
private String[] workFlowTables = new String[]{
|
//流程(自定义表)
|
"PLPROCESSTEMPLATE", "PLPROCESSCATEGORY", "PLPROCESSTASK",//"PLRMTEMPLATEPROCESS",
|
"PLPROCESSTASKPROPERTY", "PLFLOWAPPROVEOPINION", "PLFLOWOBJECT", "PLFLOWINSTANCE",
|
"WORKFLOW_TASK_CC_TABLE", "PLTASKDESC", "PLTASKSASSIGNED", "JBPM_SUBPROCESSTEM",
|
"JBPM4_TASKANDUSERCONFIG", "PLREVOKEPOLICY", "JBPM4_TASKANDUSERCONFIGEX",
|
//流程(JBPM系统表)
|
"JBPM4_DEPLOYPROP", "JBPM4_HIST_DETAIL", "JBPM4_ID_MEMBERSHIP", "JBPM4_JOB",
|
"JBPM4_PARTICIPATION", "JBPM4_VARIABLE", "JBPM4_HIST_ACTINST", "JBPM4_HIST_VAR",
|
"JBPM4_ID_GROUP", "JBPM4_ID_USER", "JBPM4_LOB", "JBPM4_DEPLOYMENT",
|
"JBPM4_HIST_PROCINST", "JBPM4_HIST_TASK", "JBPM4_TASK", "JBPM4_SWIMLANE",
|
"JBPM4_EXECUTION", "JBPM4_PROPERTY"
|
};
|
private List<String> btNames, ltNames;
|
private JPanel centerPanel;
|
private JPanel southPanel;
|
private JButton btnDelete;
|
private JButton btnCancel;
|
private JXTable table;
|
private TableModelWithCheckBox model;
|
private final int TABLE_HEADER_HEIGHT = 25;
|
private final int ROW_HEIGHT = 30;
|
private JButton btnSelAll;
|
private JButton btnSelOpp;
|
private JPanel northPanel;
|
|
/**
|
*
|
* @param btNames
|
* @param ltNames
|
* @param exceptBts : 保留的业务类型
|
*/
|
public DeleteDataDialog(List<String> btNames, List<String> ltNames){
|
this.btNames = btNames;
|
this.ltNames = ltNames;
|
initUI();
|
addListener();
|
initData();
|
}
|
|
private void initUI(){
|
this.setTitle("清除数据框");
|
Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
|
this.setSize(screenSize.width/2, screenSize.height/2);
|
this.setModal(true);
|
this.setLocationRelativeTo(null);
|
this.setResizable(false);
|
this.setLayout(new BorderLayout());
|
|
northPanel = new JPanel();
|
northPanel.setLayout(new FlowLayout(FlowLayout.LEFT));
|
centerPanel = new JPanel();
|
centerPanel.setLayout(new BorderLayout());
|
southPanel = new JPanel();
|
southPanel.setLayout(new FlowLayout(FlowLayout.RIGHT));
|
this.add(northPanel, BorderLayout.NORTH);
|
this.add(centerPanel, BorderLayout.CENTER);
|
this.add(southPanel, BorderLayout.SOUTH);
|
|
btnSelAll = new JButton("全选");
|
btnSelOpp = new JButton("反选");
|
northPanel.add(btnSelAll);
|
northPanel.add(btnSelOpp);
|
|
table = new JXTable();
|
model = new TableModelWithCheckBox();
|
model.setColumnCount(4);
|
model.setColumnIdentifiers(new String[]{"", "类型名 ", "类型", "清除状态"});
|
table.setModel(model);
|
TableColumn column = table.getColumn(0);
|
column.setCellEditor(new CheckBoxEditor(new JCheckBox()));
|
column.setCellRenderer(new CheckBoxRenderer());
|
column.setPreferredWidth(10);
|
table.setHorizontalScrollEnabled(true);
|
table.setAutoscrolls(true);
|
table.setSortable(false);
|
table.setHighlighters(HighlighterFactory.createAlternateStriping());
|
table.setRowHeight(ROW_HEIGHT);
|
//设置表头高度
|
JTableHeader tableHeader = table.getTableHeader();
|
Dimension size = tableHeader.getPreferredSize();
|
size.height = TABLE_HEADER_HEIGHT;
|
tableHeader.setPreferredSize(size);
|
|
|
centerPanel.add(new JScrollPane(table), BorderLayout.CENTER);
|
|
btnDelete = new JButton("清除");
|
btnCancel = new JButton("关闭");
|
southPanel.add(btnDelete);
|
southPanel.add(btnCancel);
|
}
|
|
private void initData(){
|
// 重新设置table的Cell的可编辑性
|
model.setInitFlag(false);
|
int btSize = btNames.size();
|
int ltSize = ltNames.size();
|
model.setRowCount(btSize + ltSize + tables.length + workFlowTables.length);
|
for(int i = 0; i < btSize; i++){
|
table.setValueAt(new JCheckBox(), i, 0);
|
table.setValueAt(btNames.get(i), i, 1);
|
table.setValueAt("业务类型", i, 2);
|
table.setValueAt("未清除", i, 3);
|
}
|
|
for(int i = 0; i < ltSize; i++){
|
table.setValueAt(new JCheckBox(), i + btSize, 0);
|
table.setValueAt(ltNames.get(i), i + btSize, 1);
|
table.setValueAt("链接类型", i + btSize, 2);
|
table.setValueAt("未清除", i + btSize, 3);
|
}
|
|
for(int i = 0; i< tables.length; i++){
|
table.setValueAt(new JCheckBox(), i + btSize + ltSize, 0);
|
table.setValueAt(tables[i], i + btSize + ltSize, 1);
|
table.setValueAt("-", i + btSize + ltSize, 2);
|
table.setValueAt("未清除", i + btSize + ltSize, 3);
|
}
|
|
for(int i = 0; i< workFlowTables.length; i++){
|
table.setValueAt(new JCheckBox(), i + btSize + ltSize + tables.length, 0);
|
table.setValueAt(workFlowTables[i], i + btSize + ltSize + tables.length, 1);
|
table.setValueAt("-", i + btSize + ltSize + tables.length, 2);
|
table.setValueAt("未清除", i + btSize + ltSize + tables.length, 3);
|
}
|
// 重新设置table的Cell的可编辑性
|
model.setInitFlag(true);
|
}
|
|
private void addListener() {
|
btnSelAll.addActionListener(new ActionListener() {
|
|
@Override
|
public void actionPerformed(ActionEvent e) {
|
selectAll();
|
}
|
});
|
btnSelOpp.addActionListener(new ActionListener() {
|
|
@Override
|
public void actionPerformed(ActionEvent e) {
|
selectOpposite();
|
}
|
});
|
btnDelete.addActionListener(new ActionListener() {
|
|
@Override
|
public void actionPerformed(ActionEvent e) {
|
if(!hasSelect()){
|
JOptionPane.showMessageDialog(getInstance(), "请选择要清楚的数据类型", "未选中数据", JOptionPane.INFORMATION_MESSAGE);
|
return;
|
}
|
int option = JOptionPane.showConfirmDialog(getInstance(), "确认删除所选类型数据?该操作不可回滚", "删除确认框", JOptionPane.YES_NO_OPTION);
|
if(option != JOptionPane.YES_OPTION){
|
return;
|
}
|
int btSize = btNames.size();
|
int ltSize = ltNames.size();
|
//truncate业务类型数据
|
for(int i = 0; i < btSize; i++){
|
if(!((JCheckBox)table.getValueAt(i, 0)).isSelected()){
|
continue;
|
}
|
String btName = (String) table.getValueAt(i, 1);
|
//String btmTableName = OmdTools.getBTTableName(btName);
|
try {
|
if(BtmClient.getService().truncateTable(btName)){
|
updateTable(i, 3, "成功");
|
}
|
} catch (VCIError e1) {
|
e1.printStackTrace();
|
updateTable(i, 3, "失败");
|
}
|
}
|
//truncate链接类型数据
|
for(int i = 0; i < ltSize; i++){
|
if(!((JCheckBox)table.getValueAt(i + btSize, 0)).isSelected()){
|
continue;
|
}
|
String ltName = (String) table.getValueAt(i + btSize, 1);
|
//String ltTableName = OmdTools.getLTTableName(ltName);
|
try {
|
if(LinkTypeStart.getService().truncateTable(ltName)){
|
updateTable(i + btSize, 3, "成功");
|
}
|
} catch (VCIError e1) {
|
e1.printStackTrace();
|
updateTable(i + btSize, 3, "失败");
|
}
|
}
|
|
//truncate QT, RIGHT, UI数据
|
// for(int i = 0; i < tables.length; i++){
|
// if(!((JCheckBox)table.getValueAt(i + btSize + ltSize, 0)).isSelected()){
|
// continue;
|
// }
|
// String tableName = (String) table.getValueAt(i + btSize + ltSize, 1);
|
// try {
|
// if(BtmClient.getService().truncateTable(tableName)){
|
// updateTable(i + btSize + ltSize, 3, "成功");
|
// }
|
// } catch (VCIError e1) {
|
// e1.printStackTrace();
|
// updateTable(i + btSize + ltSize, 3, "失败");
|
// }
|
// }
|
|
//workflow数据
|
// for(int i = 0; i < workFlowTables.length; i++){
|
// if(!((JCheckBox)table.getValueAt(i + btSize + ltSize + tables.length, 0)).isSelected()){
|
// continue;
|
// }
|
// String tableName = (String) table.getValueAt(i + btSize + ltSize + tables.length, 1);
|
// try {
|
// if(BtmClient.getService().deleteTable(tableName)){
|
// updateTable(i + btSize + ltSize + tables.length, 3, "成功");
|
// }
|
// } catch (VCIError e1) {
|
// e1.printStackTrace();
|
// updateTable(i + btSize + ltSize + tables.length, 3, "失败");
|
// }
|
// }
|
|
JOptionPane.showMessageDialog(getInstance(), "清楚数据完成", "清楚数据完成", JOptionPane.INFORMATION_MESSAGE);
|
}
|
|
});
|
|
btnCancel.addActionListener(new ActionListener() {
|
|
@Override
|
public void actionPerformed(ActionEvent e) {
|
dipose_();
|
}
|
});
|
}
|
|
/**
|
* 判断table中是否有选择的记录
|
* @return
|
*/
|
protected boolean hasSelect() {
|
for(int i = 0; i < table.getRowCount(); i++){
|
if(((JCheckBox)table.getValueAt(i, 0)).isSelected()){
|
return true;
|
}
|
}
|
return false;
|
}
|
|
/**
|
* 更新table单元格的值
|
* @param row
|
* @param column
|
* @param value
|
*/
|
private void updateTable(int row, int column, String value) {
|
// 重新设置table的Cell的可编辑性
|
model.setInitFlag(false);
|
table.setValueAt(value, row, column);
|
model.setInitFlag(true);
|
table.updateUI();
|
}
|
|
/**
|
* 全选
|
*/
|
private void selectAll() {
|
for(int i = 0; i < table.getRowCount(); i++){
|
((JCheckBox)table.getValueAt(i, 0)).setSelected(true);
|
}
|
table.updateUI();
|
}
|
|
/**
|
* 反选
|
*/
|
private void selectOpposite() {
|
for(int i = 0; i < table.getRowCount(); i++){
|
JCheckBox chb = ((JCheckBox)table.getValueAt(i, 0));
|
if(chb.isSelected()){
|
chb.setSelected(false);
|
}else{
|
chb.setSelected(true);
|
}
|
}
|
table.updateUI();
|
}
|
|
private void dipose_(){
|
this.dispose();
|
}
|
|
|
private JDialog getInstance(){
|
return this;
|
}
|
|
}
|
