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.common.portal.enums.PortalVIType;
|
import com.vci.corba.common.VCIError;
|
import com.vci.corba.portal.data.PLUILayout;
|
import com.vci.corba.portal.data.PortalVI;
|
|
public class UILayoutPopupTablePanel extends VCIJPanel{
|
|
/**
|
*
|
*/
|
private static final long serialVersionUID = 4648692230788439584L;
|
|
private final String COLUMN_NAME = "名称";
|
private final String COLUMN_CODE = "编码";
|
|
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<PLUILayout> dataProvider = null;
|
private VCIJTablePanel<PLUILayout> tablePanel = null;
|
private UILayoutPopupDialog popupDialog = null;
|
|
public UILayoutPopupTablePanel(UILayoutPopupDialog popupDialog){
|
this.popupDialog = popupDialog;
|
}
|
|
public void buildTablePanel(){
|
setLayout(new BorderLayout());
|
|
dataProvider = new AbstractVCIJTableDataProvider<PLUILayout>() {
|
@Override
|
public String[] getSpecialColumns() {
|
return new String[]{COLUMN_CODE, COLUMN_NAME};
|
}
|
@Override
|
public int getTotal() {
|
return super.total;
|
}
|
@Override
|
public VCIJTableNode<PLUILayout> getNewRowNode(PLUILayout obj) {
|
VCIJTableNode<PLUILayout> res = new VCIJTableNode<PLUILayout>(obj);
|
res.setPropertyValue(COLUMN_NAME, obj.plName);
|
res.setPropertyValue(COLUMN_CODE, obj.plCode);
|
return res;
|
}
|
@Override
|
public PLUILayout[] getDatas(int pageIndex, int pageSize) {
|
PLUILayout[] datas = new PLUILayout[0];
|
try {
|
ResData<PLUILayout> res = getDatasByPageInfo(pageIndex, pageSize);
|
datas = res.getDatas();
|
super.total = res.getTotal();
|
} catch (VCIError e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return datas;
|
}
|
};
|
tablePanel = new VCIJTablePanel<PLUILayout>(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<PLUILayout> getDatasByPageInfo(int pageIndex, int pageSize) throws VCIError{
|
PLUILayout[] datas = 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().getBtmTypeTxt() != null){
|
text = getPopupDialog().getBtmTypeTxt().getText().trim();
|
where += String.format(" and ui.PLRELATEDTYPE = '%s' ", text);
|
}
|
// if(getPopupDialog().getPortalVIType() != null){
|
// where += String.format(" and vi.vitype = %d ", getPopupDialog().getPortalVIType().getIntVal());
|
// }
|
if(!getPopupDialog().isIgnoreTxtInputValue()){
|
text = getPopupDialog().getSearchInputTxt().getText().trim();
|
where += String.format(" and (ui.plname like '%%%s%%') ", text, text);
|
}
|
}
|
String fromWhere = String.format(" from PLUILAYOUT ui where %s ", where);
|
String fromWhereOrderBy = String.format(" %s order by ui.plname", fromWhere);
|
String sql = String.format("select * from(" +
|
" select row_.*,rownum rownum_ from( " +
|
" select ui.plname, ui.plcode %s" +
|
" ) row_ " +
|
") where rownum_ >= %d and rownum_ <= %d ", fromWhereOrderBy, start, end);
|
List<PLUILayout> list = new LinkedList<PLUILayout>();
|
String[][] kvss = QTClient.getService().queryBySqlWithoutKey(sql);
|
for(String[] kvs : kvss){
|
PLUILayout bi = new PLUILayout();
|
bi.plName = kvs[0];
|
bi.plCode = kvs[1];
|
list.add(bi);
|
}
|
datas = list.toArray(new PLUILayout[0]);
|
|
sql = String.format("select count(1) count_ %s", fromWhere);
|
kvss = QTClient.getService().queryBySqlWithoutKey(sql);
|
int total = Integer.valueOf(kvss[0][0]);
|
|
ResData<PLUILayout> res = new ResData<PLUILayout>();
|
res.setDatas(datas);
|
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<PLUILayout> getTablePanel() {
|
return tablePanel;
|
}
|
|
public UILayoutPopupDialog getPopupDialog() {
|
return popupDialog;
|
}
|
|
public void setPopupDialog(UILayoutPopupDialog popupDialog) {
|
this.popupDialog = popupDialog;
|
}
|
|
}
|
