用友NC客户化开发帮助文档 - 图文(3)

for( int j = 0 ; addnum.intValue() > 0 && j < addnum.intValue() ;j++ ) { } }

this.getBillCardPanel().addLine();

this.getBillCardPanel().setBodyValueAt( \ + (j+1) , j, \);

? DesktopPanel

//nc.ui.sm.desktop.DesktopPanel private void initialize(){

//============TODO modify by jtxr_jieely 【环保部项目专用】登陆后自动隐藏左侧树状条 String pk_corp =

nc.ui.pub.ClientEnvironment.getInstance().getCorporation().getPrimaryKey(); if(\.equals(pk_corp))//只针对144001公司，主键为1002 {

setLayout(new BorderLayout());

setBackground(new Color(0xC1CCDB));

centerPanel = new JPanel(new BorderLayout()); centerPanel.setOpaque(false);

centerPanel.setBorder(BorderFactory.createEmptyBorder(5, 3, 3, 5)); centerPanel.add(getTabbedPane(), BorderLayout.CENTER); add(centerPanel, BorderLayout.CENTER);

add(getSysFuncBtnPanel(), BorderLayout.NORTH); return;

}

// ============END 2010-08-25

setLayout(new BorderLayout()); setBackground(new Color(0xC1CCDB));

centerPanel = new JPanel(new BorderLayout()); centerPanel.setOpaque(false);

centerPanel.setBorder(BorderFactory.createEmptyBorder(0,3, 2,3)); centerPanel.add(getSingleSidZoomPane(), BorderLayout.WEST); centerPanel.add(getTabbedPane(), BorderLayout.CENTER); add(centerPanel, BorderLayout.CENTER);

add(getSysFuncBtnPanel(), BorderLayout.NORTH); }

? DetailReportBaseEx

//报表UI类中的反注册按钮方法

protected void setPrivateButtons() {

}

this.unRegisterButton(ButtonAssets.m_boRefresh); this.unRegisterButton(ButtonAssets.m_boGroup); this.unRegisterButton(ButtonAssets.m_boFilter); this.unRegisterButton(ButtonAssets.m_boCross); this.unRegisterButton(ButtonAssets.m_boSort);

? dialog

/**

* 启用系统运行提示框 避免造成假死现象 */

private void onButton_import() { } /**

* 系统运行提示框 */

private Container getCurrUI() {

// 该操作是耗时操作，所以启用系统运行提示框 Runnable runImpDoc = new Runnable() { };

new Thread(runImpDoc).start();

public void run() { }

BannerDialog dialog = new BannerDialog(getCurrUI()); dialog.start(); try { }

catch (Exception e) { }

dialog.end();// 销毁系统运行提示框

dialog.end(); e.printStackTrace(); return; importData();

}

return this.getSelfUI();

? E

? Excel

//获取sheet中的HSSFRow对象,如果没有就创建一个 private HSSFRow getRow(HSSFSheet sheet, int rowNum) {

HSSFRow row = sheet.getRow(rowNum);

return row == null ? sheet.createRow(rowNum) : row; }

//获取sheet中的HSSFCell对象,如果没有就创建一个 private HSSFCell getCell(HSSFRow row, short cellNum) {

HSSFCell cell = row.getCell(cellNum);

return cell == null ? row.createCell(cellNum) : cell; }

//单元格赋值

public static void setCellValue(HSSFCell cell ,String cellValue) {

cell.setEncoding(HSSFWorkbook.ENCODING_UTF_16);//这一句是解决中文乱码问题 cell.setCellValue(cellValue);//单元格赋值 }

//设置单元格背景颜色(为红色)

public static void setCellColorRed(HSSFCellStyle style, HSSFCell cell) {

style.setFillForegroundColor(HSSFColor.RED.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); cell.setCellStyle(style);;

}//说明:HSSFColor里有好多颜色,可根据要求改为其他 //获取单元格背景颜色

public static void getCellColor(HSSFCell cell ) { HSSFCellStyle style = cell.getCellStyle();

short colorIndex = style.getFillForegroundColor(); }

? Exe

1.0 用java调用windows系统的exe文件，比如notepad，calc之类： public class Demo{

public static void main(String args[]){ Runtime rn=Runtime.getRuntime(); Process p=null;

try{

p=rn.exec(notepad); }catch(Exception e){

System.out.println(\ } } }

2.0调用其他的可执行文件，例如：自己制作的exe，或是下载安装的软件 public class Demo{

public static void main(String args[]){ Runtime rn=Runtime.getRuntime(); Process p=null;

try{

p=rn.exec(\ }catch(Exception e){

System.out.println(\ } } }

? EXP/IMP

exp nc50/nc50@MINE file=e:\\0328.dmp OWNER = nc50//导出

imp nc50/nc50@mine file=e:\\0227.dmp fromuser=nc50test touser=nc50//导入

? ExportExcel

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream;

import javax.swing.JFileChooser;

import nc.bs.logging.Logger;

import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ExportExcel { private ClientUI clientUI = null; public ExportExcel(ClientUI clientUI) { this.clientUI = clientUI; } /** * 生成Excel文件 */ public String makeExcel(Object[] cellVOs) { String[] keys1 = (String[]) cellVOs[0]; String[] keys2 = (String[]) cellVOs[1]; InputStream inputstream = null; OutputStream outputstream = null; String filePath = getFilePath(); if (filePath == null) return filePath; this.CreateExcel(filePath); try { inputstream = new FileInputStream(filePath); HSSFWorkbook book = new HSSFWorkbook(inputstream); HSSFSheet sheet1 = book.getSheetAt(0); for (int …… 此处隐藏：2653字，全部文档内容请下载后查看。喜欢就下载吧 ……