NC_API

NC开发帮助

作者:jieely

✧ A

Accsubjdoc

// 通过系统提供的会计科目接口查询所有会计科目

Accsubjdoc itf =

(Accsubjdoc) NCLocator.getInstance().lookup(Accsubjdoc.class.getName());

nc.vo.bd.b02.AccsubjVO[] targetSubjV os = itf.queryAccsubjVOs(pk_glorgbook, null, false); AccperiodVO

//查询会计期间

AccperiodVO[] accperiodVOs =

(AccperiodVO[]) HYPubBO_Client.queryByCondition(AccperiodVO.class, " nvl(dr,0)=0 "); addBetch

a.无参批量更新

String sql = "update bd_deptdoc set dept_code =…aaa‟ where dept_code=…bbb‟"; session.addBatch(sql); //添加需要执行的同构SQL

int rows = session.executeBatch(); //执行

b.有参批量更新

String sql = "update bd_deptdoc set dept_code =…aaa‟ where dept_code=?”; SQLParameter param = new SQLParameter(); //构造参数对象

param.addParam(“bbb”); //添加参数

session.addBatch(sql, param); //添加需要执行的同构SQL

int rows = session.executeBatch(); //执行

afterEdit

@Override//表的编辑后赋默认值方法(UI类重写方法)*先执行afterEdit，后执行公式* public void afterEdit(BillEditEvent event)

{

super.afterEdit(event);

if(event.getKey().equals("zd"))

{

t his.getBillCardPanel().execHeadEditFormulas();

}

else if (event.getTableCode().equals("st_xx_jyzy") &&

event.getKey().equals("code"))

{

t his.getBillCardPanel().setBodyValueAt(new UFBoolean('N'), event.getRow(), "jyzt");

t his.getBillCardPanel().setBodyValueAt(new UFBoolean('Y'), event.getRow(), "zyzt");

}

}

ALTER

//增加字段

ALTER TABLE tablea ADD newcol char(20)

//更改字段名

ALTER TABLE tablea CHANGE newcol newrow char(50)

//更改字段类型

ALTER TABLE tablea MODIFY newrow char(30)

//删除字段

ALTER TABLE tablea DROP newrow

ArrayList

ArrayList list = new ArrayList();

…..

list.add();

SettleVO[] vos = new SettleVO[list.size()];

vos = list.toArray(vos);//List与VO数组转换

✧ B

BillCode

//得到单据号

BillcodeGenerater billNoGen = new BillcodeGenerater();

billno = billNoGen.getBillCode("TI55", "0001", null, null);

BillData

BillData bd = getBillCardPanel().getBillData();

BillItem item = bd.getBodyItem(_TABLECODE1, "ialloctype");

BillField

@Override//修改单据状态时需重写此方法

protected IBillField createBillField()

{

return BillField.getInstance();

}

Button

//自定义按钮

public ButtonVO getFujian_btn()

{

ButtonVO btnVO = new ButtonVO();

btnVO.setBtnNo( IprivateButton.Fujian_btn );

btnVO.setBtnName( "附件管理" );

btnVO.setHintStr( "附件管理" );

btnVO.setOperateStatus( new int[]{IBillOperate.OP_NOTEDIT} ); // 在非新增和非编辑状态下可用

return btnVO;

}

//在UI中设置按钮状态

getButtonManager().getButton(nc.ui.trade.button.IBillButton.Add).setEnabled(false);

Byte[]

public static final byte[] m_ENTER = {0x0d, 0x0a};//换行符 ASCII码: 0x0d 0x0a ✧ C

CaseWhen

ORACLE: Case…..When 语句

SELECT

(CASE dr WHEN0THEN'有效'

WHEN1THEN'无效'

END) AS显示

FROM bd_corp