package com.vci.client.portal.UI.v3.comptdesign.compt.popupcompt;
|
|
import java.awt.BorderLayout;
|
import java.awt.GridBagConstraints;
|
import java.awt.GridBagLayout;
|
import java.awt.Insets;
|
import java.awt.event.ActionEvent;
|
import java.awt.event.ActionListener;
|
import java.util.LinkedList;
|
import java.util.List;
|
|
import com.vci.client.oq.QTClient;
|
import com.vci.client.ui.swing.VCISwingUtil;
|
import com.vci.client.ui.swing.components.VCIJButton;
|
import com.vci.client.ui.swing.components.VCIJPanel;
|
import com.vci.client.ui.swing.components.table.AbstractVCIJTableDataProvider;
|
import com.vci.client.ui.swing.components.table.VCIJTableDataProvider;
|
import com.vci.client.ui.swing.components.table.VCIJTableNode;
|
import com.vci.client.ui.swing.components.table.VCIJTablePanel;
|
import com.vci.corba.common.VCIError;
|
import com.vci.corba.omd.btm.BtmItem;
|
|
public class BtmTypePopupTablePanel extends VCIJPanel{
|
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 8891383036571391327L;
|
private final String COLUMN_NAME = "名称";
|
private final String COLUMN_LABEL = "标签";
|
private VCIJButton btnSearch = VCISwingUtil.createVCIJButton("search", "查询", "查询", "search.gif", new ActionListener() {
|
@Override
|
public void actionPerformed(ActionEvent e) {
|
btnSearch_actionPerformed(e);
|
}
|
});
|
private VCIJButton btnClear = VCISwingUtil.createVCIJButton("clear", "清空", "清空查询条件", "clear.gif", new ActionListener() {
|
@Override
|
public void actionPerformed(ActionEvent e) {
|
btnClear_actionPerformed(e);
|
}
|
});
|
|
private VCIJPanel searchInfoPanel = null;
|
private VCIJTableDataProvider<BtmItem> dataProvider = null;
|
private VCIJTablePanel<BtmItem> tablePanel = null;
|
|
|
private BtmTypePopupDialog popupDialog = null;
|
|
public BtmTypePopupTablePanel(BtmTypePopupDialog popupDialog){
|
this.popupDialog = popupDialog;
|
}
|
|
public void buildTablePanel(){
|
setLayout(new BorderLayout());
|
|
dataProvider = new AbstractVCIJTableDataProvider<BtmItem>() {
|
@Override
|
public String[] getSpecialColumns() {
|
return new String[]{COLUMN_NAME, COLUMN_LABEL};
|
}
|
@Override
|
public int getTotal() {
|
return super.total;
|
}
|
@Override
|
public VCIJTableNode<BtmItem> getNewRowNode(BtmItem obj) {
|
VCIJTableNode<BtmItem> res = new VCIJTableNode<BtmItem>(obj);
|
res.setPropertyValue(COLUMN_NAME, obj.name);
|
res.setPropertyValue(COLUMN_LABEL, obj.label);
|
return res;
|
}
|
@Override
|
public BtmItem[] getDatas(int pageIndex, int pageSize) {
|
BtmItem[] datas = new BtmItem[0];
|
try {
|
ResData<BtmItem> res = getBtmNames(pageIndex, pageSize);
|
datas = res.getDatas();
|
super.total = res.getTotal();
|
} catch (VCIError e) {
|
e.printStackTrace();
|
}
|
return datas;
|
}
|
};
|
tablePanel = new VCIJTablePanel<BtmItem>(dataProvider);
|
tablePanel.setShowExport(false);
|
tablePanel.setColumnDefaultWidth(250);
|
tablePanel.setPageSizeList(new int[]{10,20,30,40,50,100, 10});
|
tablePanel.buildTablePanel();
|
|
searchInfoPanel = getNorthSearchPanel();
|
add(searchInfoPanel, BorderLayout.NORTH);
|
add(tablePanel, BorderLayout.CENTER);
|
}
|
|
private VCIJPanel getNorthSearchPanel(){
|
VCIJPanel pal = new VCIJPanel(new GridBagLayout());
|
pal.add(btnSearch, getGBC(1, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE, 1));
|
pal.add(btnClear, getGBC(2, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE, 1));
|
searchInfoPanel = pal;
|
return pal;
|
}
|
private GridBagConstraints getGBC(int gridx, int gridy, int gridwidth, int gridheight, double weightx, double weighty, int anchor, int fill, int padxy) {
|
return new GridBagConstraints(gridx, gridy, gridwidth, gridheight, weightx, weighty, anchor, fill, new Insets(padxy, padxy, padxy, padxy), padxy, padxy);
|
}
|
|
private ResData<BtmItem> getBtmNames(int pageIndex, int pageSize) throws VCIError{
|
BtmItem[] btmNames = null;
|
int start = pageIndex <= 1 ? 1 : (pageIndex - 1) * pageSize + 1;
|
int end = pageIndex <= 1 ? pageSize : (pageIndex * pageSize);
|
|
String where = " 1=1 ";
|
String text = "";
|
|
if(getPopupDialog() != null){
|
if(!getPopupDialog().isIgnoreTxtInputValue()){
|
text = getPopupDialog().getSearchInputTxt().getText().trim();
|
where += String.format(" and (bt.name like '%%%s%%' or bt.label like '%%%s%%')", text, text);
|
}
|
}
|
String fromWhere = String.format(" from plbtmtype bt where %s ", where);
|
String fromWhereOrderBy = String.format(" %s order by bt.name", fromWhere);
|
String sql = String.format("select * from(" +
|
" select row_.*,rownum rownum_ from( " +
|
" select bt.name, bt.label %s" +
|
" ) row_ " +
|
") where rownum_ >= %d and rownum_ <= %d ", fromWhereOrderBy, start, end);
|
List<BtmItem> list = new LinkedList<BtmItem>();
|
String[][] kvss = QTClient.getService().queryBySqlWithoutKey(sql);
|
for(String[] kvs : kvss){
|
BtmItem bi = new BtmItem();
|
bi.name = kvs[0];
|
bi.label = kvs[1];
|
list.add(bi);
|
}
|
btmNames = list.toArray(new BtmItem[]{});
|
|
sql = String.format("select count(1) count_ %s", fromWhere);
|
kvss = QTClient.getService().queryBySqlWithoutKey(sql);
|
int total = Integer.valueOf(kvss[0][0]);
|
|
ResData<BtmItem> res = new ResData<BtmItem>();
|
res.setDatas(btmNames);
|
res.setTotal(total);
|
return res;
|
}
|
|
private void btnSearch_actionPerformed(ActionEvent e){
|
tablePanel.setPageIndex(1);
|
tablePanel.refreshTableData();
|
}
|
|
private void btnClear_actionPerformed(ActionEvent e){
|
tablePanel.setPageIndex(1);
|
if(getPopupDialog() != null && getPopupDialog().getSearchInputTxt() != null){
|
getPopupDialog().getSearchInputTxt().setText("");
|
}
|
tablePanel.refreshTableData();
|
}
|
|
public VCIJTablePanel<BtmItem> getTablePanel() {
|
return tablePanel;
|
}
|
|
public BtmTypePopupDialog getPopupDialog() {
|
return popupDialog;
|
}
|
|
public void setPopupDialog(BtmTypePopupDialog popupDialog) {
|
this.popupDialog = popupDialog;
|
}
|
|
|
}
|
