NC_API

NC开发帮助作者:jieely✧ AAccsubjdoc// 通过系统提供的会计科目接口查询所有会计科目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 "); addBetcha.无参批量更新String sql = "update bd_deptdoc set dept_code =…aaa‟ where dept_code=…bbb‟"; session.addBatch(sql); //添加需要执行的同构SQLint 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); //添加需要执行的同构SQLint 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 newrowArrayListArrayList list = new ArrayList();…..list.add();SettleVO[] vos = new SettleVO[list.size()];vos = list.toArray(vos);//List与VO数组转换✧ BBillCode//得到单据号BillcodeGenerater billNoGen = new BillcodeGenerater();billno = billNoGen.getBillCode("TI55", "0001", null, null);BillDataBillData 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 ✧ CCaseWhenORACLE: Case…..When 语句SELECT(CASE dr WHEN0THEN'有效'WHEN1THEN'无效'END) AS显示FROM bd_corptry{}catch(DbException e){//如果是语法错误if(e.isBadSQLGrammar()){Logger.error("语法错误:"+e.getMessage(),e);}//如果是数据一致性错误if(e.isDataIntegrityViolation()){Logger.error("数据一致性错误:"+e.getMessage(),e);}}CheckRule<前台校验类> XXX UICheckRule//校验数据是否重复public IUniqueRule[] getItemUniqueRules(String tablecode) { if( "cl_gg_ytzwlb".equals( tablecode ) ){IUniqueRule[] unique = null;unique = new IUniqueRule[]{new UniqueRule("座类编码不能重复",newString[]{("zlbm")})};return unique;}return null;}//校验是否为空public ICheckRule[] getItemCheckRules(String tablecode) { CheckRule[] rules = new CheckRule[] {new CheckRule("【NC结算方式编码】", "ncsettlecode", false, null, null)};return rules;}checkPrerequisite//对于控制集团不能打开节点，只有公司可以打开节点的处理//在ClientUI中覆写Toftpanel的方法：public String checkPrerequisite(){String pk_corp = _getCorp().getPk_corp();if (pk_corp.equals("0001")) {return "当前处于集团，此功能点无法进入";}return null;}ClientEnvironmentColumn//单据模板获得jtable可通过getBillCardPanel().getBillTable()//获取列表模型 TableColumnModel tcm=table.getColumnMode();//第n列设置为隐藏TableColumn hideColumn = table.getColumn("第n列");//隐藏第n列设置tcm.removeColumn(hideColumn);//显示第n列设置tcm.addColumn(hideColumn);//把i列移动到第j列tcm.moveColumn(i, j);getBillCardPanel().getBodyPanel().hideTableCol(strKey)；//隐藏getBillCardPanel().getBodyPanel().showTableCol(strKey)；//显示ComboBoxUIComboBox typeCom = (UIComboBox) this.getBillCardPanel().getBodyItem("x").getComponent();typeCom.addItems(Object[] obj);ConnectionPersistenceManager sessionManager = PersistenceManager.getInstance(); JdbcSession session = sessionManager.getJdbcSession();Connection con = session.getConnection();PreparedStatement stmt = null;stmt = con.prepareStatement(con, sql);finally{stmt.close();con.close();sessionManager.release();}ConnectException//启动NC时抛异常.ConnectException: Connection refused: connect原因:80端口被占用ConditionVO//取查询对话框VO值ConditionVO[] conVOs = getQueryDLG().getConditionVO();for (int i = 0; i < conVOs.length; i++){if ("billdate".equals(conVOs[i].getFieldCode())){billdate = conVOs[i].getValue();}else if(){……}}Coperatorid//操作员所对应业务员cworkpsnid->getColValue(bd_psndoc,pk_psndoc,pk_psnbasdoc,getColValue( sm_userandclerk,pk_psndoc,userid,coperatorid))createQueryDLG()/**<UI类--查询对话框>*重写父类方法,取得查询对话框,如有动态显示下拉框和默认值需重写此方法*/protected QueryDLG createQueryDLG() {FundReportDLG dlg = new FundReportDLG();dlg.setTempletID(getUIControl()._getPk_corp(),this.getModuleCode(),getUIControl()._getOperator(),null);//设置默认日期QueryConditionVO[] qryvos = dlg.getConditionDatas();for(int i=0;i<qryvos.length;i++) {if(qryvos[i].getFieldCode().equals("billdate")){ qryvos[i].setValue(getClientEnvironment().getDate().toString());break;}}return dlg;}CARDPANELif(clientUI.isListPanelSelected())//如果是选取的列表界面clientUI.setCurrentPanel(BillTemplateWrapper.CARDPANEL);Controlcontrol userpasswords2 //运行【用户帐户】Custflag说明：0客户1供应商2既是客户又是供应商3既是供应商又是客户✧ DDapCallnc.ui.pf.pub.DapCallgetPkcorp()//取公司getOperator()//取操作员dataNotNullValidate// 验证不能为空的字段getBillCardPanelWrapper().getBillCardPanel().dataNotNullValidate();dataSourceString dataSource = DataSourceCenter.getInstance().getSourceName();//取当前数据源DateUFDate date = ClientEnvironment.getInstance().getDate();//得到登陆日期select to_char(last_day(to_date('20100625','yyyymmdd')),'dd') from dual;//得到每月多少天 DateFormatpublic class DateTest {public static void main(String[] args) {String dates = "2007-8-14";//日期时间DateFormat df = new SimpleDateFormat("yy-MM-dd");//日期格式化辅助类Date d;try {d = df.parse(dates);//格式化日期if (d.getDay() == 0 || d.getDay() == 6)//判断是不是双休日System.out.println("日期:[" + dates + "] 是双休日");elseSystem.out.println("日期:[" + dates + "] 不是双休日");} catch (ParseException e) {e.printStackTrace();}}}dataNotNullValidatepublic void onBoSave() throws Exception {getBillCardPanelWrapper().getBillCardPanel().getBillData().dataNotNullValidate ();//UAP模板设置必输项boolean flag = true;try{super.onBoSave();}catch (IllegalArgumentException e){(e);flag = false;}catch (Exception e){if(flag)this.getSelfUI().showErrorMessage("【资产名称】已存在,请检查");return ;}super.onBoRefresh();}DecodeDECODE的语法：DECODE(value,if1,then1,if2,then2,if3,then3,...,else)表示如果value等于if1时，DECODE函数的结果返回then1,...,如果不等于任何一个if值，则返回else。