[大数据]NC65开发资料

//弹窗

MessageDialog.showHintDlg(null, "debug", "已经进入编辑后事件");

//异常事件

throw new RuntimeException("是这个按钮");

//后台抛出异常

ExceptionUtils.wrappBusinessException(sb.toString());

//前台查询sql

HYPubBO_Client.queryByCondition(VO.class,"strwhere")

//数据库查询帮助类 IUAPQueryBS
?

IUAPQueryBS iUAPQueryBS = (IUAPQueryBS) NCLocator.getInstance().lookup(IUAPQueryBS.class.getName());

List<String> list = (List<String>)iUAPQueryBS.executeQuery(sql, new ColumnListProcessor());

//返回结果集

String result = (String)iUAPQueryBS.executeQuery(sql, new ColumnProcessor());//返回单一结果

//查询数据返回Map数据结构,keyCloumn ?key的字段名 ,vauleCloumn 值得字段名

sql.append("select code,pk_dept from org_dept ?where ?(enablestate = 1 or enablestate = 2) and code='"+signunitCode+"'");
Map<String, String> deptMap = queryDataForMap("code", "pk_dept", sql.toString());
DBAccessUtil dbUtil = new DBAccessUtil();
dbUtil.executeQuery(sql, new KeyValueMapProcessor<String,String>(keyCloumn,vauleCloumn));

//数据库增删改类 接口

IVOPersistence iVOPersistence = (IVOPersistence) NCLocator.getInstance().lookup(IVOPersistence.class.getName());

//更新实体中变化的字段到数据库中

nc.impl.pubapp.pattern.data.vo.VOUpdate<E extends ISuperVO>
VOUpdate<CtoperaManualVO> update = new VOUpdate<CtoperaManualVO>();

//map转实体

BeanUtils.populate(bean, map);

值转换工具类，将某个未知类型的object转换为特定类型的值。

ValueUtils.getInt(obj);

根据表头pk查询aggvo?
可以前端使用：

IMDPersistenceQueryService service=NCLocator.getInstance().lookup(IMDPersistenceQueryService.class);
?? ??? ?ArriveVO arriveVO=(ArriveVO) service.queryBillOfNCObjectByPK(ArriveVO.class,"1001A110000000B3ACOT").getContainmentObject();

后端：

BillQuery<OrderVO> billquery = new BillQuery(OrderVO.class);
?? ??? ?OrderVO[] aggvo=billquery.query(new String[] {pk});
?? ??? ?return aggvo;

前端没有测试的方法

ArriveVO ? arriveVO =(ArriveVO) HYPubBO_Client.queryBillVOByPrimaryKey(new String[]{ArriveVO.class.getName(),ArriveHeaderVO.class.getName(),ArriveItemVO.class.getName()},"1001A110000000B3ACOT");

返回多个aggvo 第四个参数如果是true 不返回表体数据，如果是false 返回表体数据

String [] str = {"1001AA100000001NUX5Y","1001AA100000001NUVMX"};
?? ??? ??? ? NCObject[] arriveVO = service.queryBillOfNCObjectByPKs(AggForemanVO.class, str, null, false);

//前端获取aggvo

AggSubProjSumVO aggvo = (AggSubProjSumVO) getEditor().getValue();
MaterialOutVO aggvo = (MaterialOutVO) getEditorModel().getICBizView().getValue();

//保存aggvo

HYPubBO.saveBill();

//查询单个字段

String groupName= (String) getHypubbo().findColValue("org_orgs", "name","pk_org = '" + tempMsgvo.getPk_group() + "'");
getHypubbo().findColValue();

//获取aggvo网站
https://note.youdao.com/ynoteshare1/index.html?id=24db1463f80c40ae4d9023f0202d4b31&type=note

视图VO查询,根据表体id查询

RecPlanViewVO[] views =
? ? ? ? new ViewQuery<RecPlanViewVO>(RecPlanViewVO.class).query(backIds
? ? ? ? ? ? .toArray(new String[0]));

//执行编辑公式

billPanel.getBillModel().execEditFormulas(i+rowOrg);

//加载参照数据

billPanel.getBillModel().loadLoadRelationItemValue();

//设置文本框 "比例样式"

MetaDataEditPropertyAdpter metaDataProperty = new MetaDataEditPropertyAdpter(panel.getBodyItem("material_quality").getMetaDataProperty());
metaDataProperty.setDatatype(19);
panel.getBodyItem("material_quality").setMetaDataProperty(metaDataProperty);
UIFractionTextField fraction = (UIFractionTextField)panel.getBodyItem("material_quality").getComponent();
fraction.setNumberPoint(8);

//aggvo工具类
?

nc.vo.ct.uitl.AggVOUtil