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

}

public boolean isAutoManageTree() { }

return true;//自动管理树节点

? 树:数据类

public class DhxtTreeData implements IVOTreeDataByID {

public String getIDFieldName() { }

public String getParentIDFieldName() { }

public String getShowFieldName() { //此字段若为空刚无法构建树 }

public SuperVO[] getTreeVO() {

SuperVO[] treeVOs = null;

BusinessDelegator business = new BDBusinessDelegator(); try {

String pk_corp = treeVOs = return \; return \; return \;

ClientEnvironment.getInstance().getCorporation().getPk_corp();

business.queryByCondition(nc.vo.assetmanage.xx.StXxJcxxVO.class, \'ST53' and pk_corp = '\+pk_corp+\ ); }

}

{ }

return treeVOs;

e.printStackTrace();

}catch(Exception e)

? 树:单据UI类

? AbstractUI

public abstract class AbstractDhxtUI extends MultiChildBillTreeManageUI implements

ILinkQuery{

protected AbstractManageController createController() { }

@Override

protected IVOTreeData createTreeData() { }

@Override

protected IVOTreeData createTableTreeData() { }

return null;

return new DhxtTreeData(); return new DhxtUICtrl();

? UI

public class DhxtUI extends AbstractDhxtUI{

protected ManageEventHandler createEventHandler() {

}

return new MyEventHandler(this, getUIControl());

@Override

public void afterInit() throws Exception { super.afterInit();

this.modifyRootNodeShowName( \电话系统\ );

}

@Override//编辑后事件

public void afterEdit(BillEditEvent event) {

super.afterEdit(event);

if( \.equals( event.getKey() ) ) {

this.getBillCardPanel().execHeadEditFormulas(); //参照编辑公式

//node_show_name->getColValue(station,lstationname , pk_station, zd)

} }

}

? 建表空间脚本

===============================================SQLServer ALTER DATABASE [nc50] ADD FILEGROUP [NNC_DATA01] go

ALTER DATABASE [nc50] ADD FILEGROUP [NNC_DATA02] go

ALTER DATABASE [nc50] ADD FILEGROUP [NNC_DATA03]

go

ALTER DATABASE [nc50] ADD FILEGROUP [NNC_INDEX01] go

ALTER DATABASE [nc50] ADD FILEGROUP [NNC_INDEX02] go

ALTER DATABASE [nc50] ADD FILEGROUP [NNC_INDEX03] go

ALTER DATABASE [nc50] ADD FILE(NAME = N'nnc_data01', FILENAME = N'D:\\Program Files\\Microsoft SQL Server\\data\\nnc_data01_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA01]

go

ALTER DATABASE [nc50] ADD FILE(NAME = N'nnc_data02', FILENAME = N'D:\\Program Files\\Microsoft SQL Server\\data\\nnc_data02_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA02]

go

ALTER DATABASE [nc50] ADD FILE(NAME = N'nnc_data03', FILENAME = N'D:\\Program Files\\Microsoft SQL Server\\data\\nnc_data03_Data.NDF' , SIZE = 500, FILEGROWTH = 200) TO FILEGROUP [NNC_DATA03]

go

ALTER DATABASE [nc50] ADD FILE(NAME = N'nnc_index01', FILENAME = N'D:\\Program Files\\Microsoft SQL Server\\data\\nnc_index01_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX01]

go

ALTER DATABASE [nc50] ADD FILE(NAME = N'nnc_index02', FILENAME = N'D:\\Program Files\\Microsoft SQL Server\\data\\nnc_index02_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX02]

go

ALTER DATABASE [nc50] ADD FILE(NAME = N'nnc_index03', FILENAME = N'D:\\Program Files\\Microsoft SQL Server\\data\\nnc_index03_Data.NDF' , SIZE = 200, FILEGROWTH = 100) TO FILEGROUP [NNC_INDEX03]

Go

===============================================Oracle

CREATE TABLESPACE NNC_DATA01 DATAFILE 'D:\\ORACLE\\ORADATA\\ORA10G\\nnc_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE NNC_DATA02 DATAFILE 'D:\\ORACLE\\ORADATA\\ORA10G\\nnc_data02.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE NNC_DATA03 DATAFILE 'D:\\ORACLE\\ORADATA\\ORA10G\\nnc_data03.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;

CREATE TABLESPACE NNC_INDEX01 DATAFILE 'D:\\ORACLE\\ORADATA\\ORA10G\\nnc_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE TABLESPACE NNC_INDEX02 DATAFILE 'D:\\ORACLE\\ORADATA\\ORA10G\\nnc_index02.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE TABLESPACE NNC_INDEX03 DATAFILE 'D:\\ORACLE\\ORADATA\\ORA10G\\nnc_index03.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE USER NC50 IDENTIFIED BY NC50 DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;

GRANT connect,dba to NC50;

===============================================DB2

CREATE DATABASE NCTEST ON '/BigData' USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM

CATALOG

TABLESPACE

MANAGED

BY

DATABASE

USING

(

FILE

'/BigData/NCTEST/Catalogdata1' 128000 ) USER TABLESPACE MANAGED BY DATABASE USING ( FILE '/BigData/NCTEST/Userdata1' 512000 ) TEMPORARY TABLESPACE MANAGED BY DATABASE USING ( FILE '/BigData/NCTEST/Tempspace1' 768000 )

connect to NCTEST user db2inst1 using db2inst1

CREATE Bufferpool NCUSED4 SIZE 102400 PAGESIZE 4K

CREATE Bufferpool NCUSED16 SIZE 38400 PAGESIZE 16K

CREATE REGULAR TABLESPACE NNC_DATA01 PAGESIZE 16K MANAGED BY DATABASE USING ( FILE '/BigData/NCTEST/nnc_data01' 204800) EXTENTSIZE 8 OVERHEAD 24.1 PREFETCHSIZE 8 TRANSFERRATE 0.9 BUFFERPOOL NCUSED16

CREATE REGULAR TABLESPACE NNC_I …… 此处隐藏：5688字，全部文档内容请下载后查看。喜欢就下载吧 ……