nc系统常用代码

最新推荐文章于 2023-09-07 11:03:30 发布

苡菁

最新推荐文章于 2023-09-07 11:03:30 发布

阅读量1.1w

点赞数 4

分类专栏： # nc

本文链接：https://blog.csdn.net/siyi1219/article/details/89189824

版权

nc 专栏收录该内容

55 篇文章 26 订阅

订阅专栏

1. 在字段编辑前后的类中获取值以及赋值

@Override
public void handleAppEvent(CardBodyAfterEditEvent e) {

    //获取卡片面板
    BillCardPanel card = e.getBillCardPanel();

    //卡片停止编辑 必须写在最上面
    card.stopEditing();

    //获取表体中某一行某一个字段的值，price为字段名称，e.getRow()是修改行的行标（从0开始）
    Object price = card.getBodyValueAt(e.getRow(), "price");

    //把amount值赋值给修改行的字段amount
    card.setBodyValueAt(amount, e.getRow(), "amount");

    //把值赋给表头为totalnum的字段
    card.setHeadItem("totalnum", UFDouble.sum(nnum_array));	
    
    //获取表体中的数据条数
    int bodyRows = e.getBillCardPanel().getRowCount();

    //获取表头某个字段的值
    Object receptionTypeObj = card.getHeadItem("reception_type").getValueObject();

}

2.连接数据库的几种方式

import nc.vo.hybz.hybz.HybzHVO;
import nc.itf.uap.IUAPQueryBS;
import nc.bs.framework.common.NCLocator;

//第一种方式，用于客户端
//tablename:表名  fieldname：字段名称  strwhere：查询条件
HYPubBO_Client.findColValue(tablename, fieldname, strwhere);
//从数据库中查询数据，findColValue(表名，字段名，查询条件)
Object value = HYPubBO_Client.findColValue("zdbz_zdbz_h", "pk_head", " reception_type='"+receptionType+"' and reception_level = '"+receptionLevel+"' and pk_head <> '"+pk_head+"' and nvl(dr,0)=0");

//第二种方式，随时可用
IUAPQueryBS bs = NCLocator.getInstance().lookup(IUAPQueryBS.class);
//bs.executeQuery("sql", new MapListProcessor()); MapListProcessor查询语句可以返回多行结果
//bs.executeQuery("", new BeanProcessor(type));BeanProcessor查询语句只返回一个VO
//ColumnProcessor查询语句只能返回一行一列结果
//ArrayListProcessor查询语句可以返回多行多列
//MapProcessor查询语句只返回一行结果
//BeanListProcessor查询语句返回多个VO

例如：
String meetingLevel = clientFullVOs[0].getParentVO().getMeeting_level();
String regionType = clientFullVOs[0].getParentVO().getRegion_type();
			
IUAPQueryBS bs = NCLocator.getInstance().lookup(IUAPQueryBS.class);
			
try {
	    String sql = "select count(1) from hybz_hybz_h where 1=1 and dr=0 and meeting_level='"+meetingLevel+"' and region_type='"+regionType+"'";
		Vector vector = (Vector)bs.executeQuery(sql, new VectorProcessor());
				
		if(vector != null && !vector.isEmpty()){
			Integer num = new Integer(((Vector)vector.get(0)).get(0).toString());
				if(num>0){
						MessageDialog.showOkCancelDlg(new Container(), "警告", "该会议费标准已存在，请重新输入或选择");						
		        }else{
						processor = new CompareAroundProcesser<HybzBillVO>(
								HybzPluginPoint.SCRIPT_INSERT);
						// TODO 在此处添加前后规则
						   IRule<HybzBillVO> rule=null;
				}
		}
} catch (BusinessException e1) {
	// TODO 自动生成的 catch 块
	e1.printStackTrace();
}

//第三种方式，私有端使用
new BaseDAO().executeQuery(arg0, arg1);

3.怎样在新写的action中获得 BillCardPanel 卡片面板

package nc.ui.fytz.hybz.action;

import java.awt.event.ActionEvent;

import nc.ui.pub.beans.MessageDialog;
import nc.ui.pub.bill.BillCardPanel;
import nc.ui.pubapp.uif2app.actions.pflow.SaveScriptAction;
import nc.ui.pubapp.uif2app.model.BillManageModel;
import nc.ui.pubapp.uif2app.view.ShowUpableBillForm;
import nc.ui.trade.business.HYPubBO_Client;

/**
 * 会议费标准保存
 * @author ChenSiyi
 *
 */
public class MySaveScriptAction extends SaveScriptAction {
	
	private BillManageModel model;
	private ShowUpableBillForm editor;
	
	public BillManageModel getModel() {
		return model;
	}

	public void setModel(BillManageModel model) {
		this.model = model;
		this.model.addAppEventListener(this);
		super.model = model;
	}

	public ShowUpableBillForm getEditor() {
		return editor;
	}

	public void setEditor(ShowUpableBillForm editor) {
		this.editor = editor;
		super.editor = editor;
	}

	@Override
	public void doAction(ActionEvent e) throws Exception {
		
		BillCardPanel card = this.getEditor().getBillCardPanel();
		
		//卡片停止编辑
		card.stopEditing();
				
		String pk_head = null;
		String meetingLevel = null;
		String regionType = null;
		
		//1、非空验证
		
		//会议级别非空判断
		Object meeting_levelObj = card.getHeadItem("meeting_level").getValueObject();
		if(meeting_levelObj != null){
			meetingLevel = meeting_levelObj.toString();
		}else{
			MessageDialog.showWarningDlg(card, "警告", "会议级别字段值为空，不能进行保存操作!");
			return;
		}
		
		//地区类别非空判断
		Object region_typeObj = card.getHeadItem("region_type").getValueObject();
		if(region_typeObj != null){
			regionType = region_typeObj.toString();
		}else{
			MessageDialog.showWarningDlg(card, "警告", "地区类别字段值为空，不能进行保存操作!");
			return;
		}
		
		//主键非空判断
		Object pk_headObj = card.getHeadItem("pk_head").getValueObject();
		if(pk_headObj != null){
			pk_head = pk_headObj.toString();
		}
		
		//住宿费非空判断
		Object stayCost = card.getHeadItem("stay_cost").getValueObject();
		if(stayCost == null){
			MessageDialog.showWarningDlg(card, "警告", "住宿费为空，不能进行保存操作!");
			return;
		}
		
		//餐饮费非空判断
		Object repastCost = card.getHeadItem("repast_cost").getValueObject();
		if(repastCost == null){
			MessageDialog.showWarningDlg(card, "警告", "餐饮费为空，不能进行保存操作!");
			return;
		}
		
		//2、查询数据
		//判断新增还是修改,pk_head存在则为修改，不存在则为添加
		if(pk_head != null){
			
			//从数据库中查询数据，findColValue(表名，字段名，查询条件) and pk_head <> '"+pk_head+"'
			Object value = HYPubBO_Client.findColValue("hybz_hybz_h", "pk_head", " meeting_level='"+meetingLevel+"' and region_type='"+regionType+"' and nvl(dr,0)=0");			
			//不为空则表示数据库中已存在这条数据，为空则添加数据
			if(value != null){
				MessageDialog.showWarningDlg(card, "警告", "该会议费标准已存在,不能保存!");
				return;
			}
		}else{
			Object value = HYPubBO_Client.findColValue("hybz_hybz_h", "pk_head", " meeting_level='"+meetingLevel+"' and region_type='"+regionType+"' and nvl(dr,0)=0");
			if(value != null){
				MessageDialog.showWarningDlg(card, "警告", "该会议费标准已存在，不能保存!");
				return;
			}
		}

		super.doAction(e);
	}

}

在界面的XML中找到保存saveAction

和以下代码对应

4.隐藏字段

//表体隐藏
BillData bs =getBillCardPanel().getBillData();
BillItem[] items =bs.getBillModel().getBodyItems();
for (int i = 0; i <items.length; i++) {
    items[i].setShow(false);
}
getBillCardPanel().setBillData(bs);
//表头隐藏
billCardPanel.getHeadItem("aaa").getComponent().setVisible(false); 
 
billCardPanel.getHeadItem("aaa").getCaptionLabel().setText("");

5.代码执行公式

//表头
getBillCardPanel().execHeadLoadFormulas();
//表体
getBillCardPanel().getBillModel().execLoadFormula();
//表体某行、某个字段执行
getBillCardPanel().execBodyFormula(i,"pk_supdoc");
 
// 列表执行 案例
String[] strs = new String[8];
String pk_wuliao_pk_measdoc_strFomula = "pk_wuliao.pk_measdoc->getcolvalue(bd_material,pk_measdoc,pk_material,pk_wuliao);";
        		String pk_wuliao_pk_marbasclass_strFomula = "pk_wuliao.pk_marbasclass->getcolvalue(bd_material,pk_marbasclass,pk_material,pk_wuliao);";
        		String pk_wuliao_flname_strFomula = "pk_wuliao.pk_marbasclass.name->getcolvalue(bd_marbasclass,name,pk_marbasclass,pk_wuliao.pk_marbasclass);";
        		String pk_wuliao_dwname_strFomula = "pk_wuliao.pk_measdoc.name->getcolvalue(bd_measdoc,name,pk_measdoc,pk_wuliao.pk_measdoc);";
        		String pk_wuliao_name_strFomula = "pk_wuliao.name->getcolvalue(bd_material,name,pk_material,pk_wuliao);";
        		String pk_wuliao_materialtype_strFomula = "pk_wuliao.materialtype->getcolvalue(bd_material,materialtype,pk_material,pk_wuliao);";
        		String pk_wuliao_materialspec_strFomula = "pk_wuliao.materialspec->getcolvalue(bd_material,materialspec,pk_material,pk_wuliao);";
        		String pk_wuliao_strFomula = "pk_wuliao->getcolvalue(bd_material,code,pk_material,pk_wuliao);";
        		strs[0]=pk_wuliao_pk_marbasclass_strFomula;
        		strs[1]=pk_wuliao_pk_measdoc_strFomula;
        		strs[2]=pk_wuliao_flname_strFomula;
        		strs[3]=pk_wuliao_dwname_strFomula;
        		strs[4]=pk_wuliao_name_strFomula;
        		strs[5]=pk_wuliao_materialtype_strFomula;
        		strs[6]=pk_wuliao_materialspec_strFomula;
        		strs[7]=pk_wuliao_strFomula;
        		getbillListPanel().getBodyBillModel().execFormulas(strs);

6.字段下拉

getBillCardWrapper().initHeadComboBox("wlname",new String[]{"A","B","C"}, true);

7.参照相关

1.表头参照多选取值
 
((UIRefPane)billCardPanel.getHeadItem("aaa").getComponent()).getRefModel().getPkValues();
 
2.动态指定参照类
 
((UIRefPane)(getBillCardPanelWrapper().getBillCardPanel().getHeadItem("字段").getComponent())).setRefModel(参照类.class);
 
3.设置参照是否支持多选
 
((UIRefPane)editor.getBillCardPanel().getHeadItem("aaa").getComponent()).setMultiSelectedEnabled(true);
 
4.判断是否参照类型：
 
Object obj =((UIRefPane)getBillCardPanel().getHeadItem("").getComponent()).getRefModel();

8.下拉去掉空白选项

单据模板设置必输即可

9.获取表体所有页签名

getBillCardPanel().getBillData().getBodyTableCodes();

10.取得某个页签上的vo

BillModel tempmodel = getEditor().getBillCardPanel().getBillModel("id_oadjtb_d");
OadjtbDVO[] dvos = (OadjtbDVO[]) tempmodel.getBodyValueVOs(OadjtbDVO.class.getName());
if(dvos!=null&&dvos.length>0)
{
 
}
 
ZzyjhBVO[] yjhbvos = (ZzyjhBVO[]) getEditor().getBillCardPanel().getBillModel().getBodyValueVOs(ZzyjhBVO.class.getName());
 
 
 
AggZzyjhHVO aggvo = (AggZzyjhHVO) getEditor().getBillCardPanel().getBillValueVO(AggZzyjhHVO.class.getName(),ZzyjhHVO.class.getName(),ZzyjhBVO.class.getName());

11.单据状态栏---输出消息

ShowStatusBarMsgUtil.showStatusBarMsg("执行成功!", model.getContext());

12.获取当前时间当前年当前月当前集团当前公司

CurTime.getCurrentTimeStampString();
 
//NC5X 
UFDate today = ClientEnvironment.getInstance().getDate();
String pk_corp = ClientEnvironment.getInstance().getCorporation().getPrimaryKey();
UFDate today = ClientEnvironment.getInstance().getBusinessDate();
String dDate = today.toString();
String cyear = ""+today.getYear();
String cmonth = today.getStrMonth();
 
 
//NC6X
String user = this.model.getContext().getPk_loginUser();// 当前登录用户
String pk_group = this.model.getContext().getPk_group();//当前登录集团
UFDate today = AppContext.getInstance().getBusiDate();
String pk_user = AppContext.getInstance().getPkUser();
String dDate = today.toString();
String cyear = ""+today.getYear();
String cmonth = today.getStrMonth();

13.UFDouble 保留2位有效数字

（1）单据模板初始化中设置

（2） new UFDouble().setScale(2,UFDouble.ROUND_HALF_UP);

14.字段编辑态不可改，新增态可改

在EditAction中重载doAction方法中加入如下代码
BillItem txtCode = cardPanel.getHeadItem(CODE);(获取字段控件)
txtCode.setEdit(true);（设置编辑态可见，这个不影响控件可编辑性。这名字容易误导，被它还惨了。）
txtCode.setEnabled(false);（设置可编辑，是否可编辑要设置这个。）

15.自定义参照

1）自定义一个RefModel继承自AbstractRefModel。
2）手动在bd_refinfo中插入一条数据refclass对应自定义的refmodel全路径。
3）在refmodel的vo元数据bmf参照中设置参照。（一般文档里都不说这一步，导致元数据引用时出不来参照。）
4）其他元数据ref时就可以出来来参照了

16.编辑时切换某个页签

e.getBillCardPanel().getBodyTabbedPane().setSelectedIndex(0);

17.获取某个页签下的总行数与值

int rowb = e.getBillCardPanel().getRowCount();
for (int i = 0; i < rowb; i++) 
{
    Object temp = e.getBillCardPanel().getBodyValueAt(i,"字段名");
}

18.根据主键查询hvo bvo

    @Override
	public BzqcHVO queryBzqcHVOByPk(String pk_bzqc) throws BusinessException {
		BaseDAO dao = new BaseDAO(design);
		BzqcHVO vo = null;
		vo = (BzqcHVO) dao.retrieveByPK(BzqcHVO.class,pk_bzqc);	
		return vo;
	}
 
	@Override
	public BzqcBVO[] queryBzqcBVOSByPk(String pk_bzqc) throws BusinessException {
		BaseDAO dao = new BaseDAO(design);
		String wheresql = " dr = 0 and pk_bzqc = '"+pk_bzqc+"' ";
		List<BzqcBVO> bodyVos = (List<BzqcBVO>) dao.retrieveByClause(BzqcBVO.class, wheresql);
		BzqcBVO[] bvos = (BzqcBVO[]) bodyVos.toArray(new BzqcBVO[0]);
		return bvos;
	}

19.业务锁

 
	//业务锁：把业务锁放在事务之外，可行原因主要有业务锁不是基于数据库和业务锁是基于Select的处理，无需事务。
	public void updateAreaclVO(AreaclVO vo) {
		boolean islock = PKLock.getInstance().acquireLock(vo.getPrimaryKey(),null, null);
if (!islock)
			try {
				throw new nc.vo.pub.BusinessException(nc.vo.bd.BDMsg.MSG_LOCKED());
			} catch (BusinessException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		try {
			String[] updateFields = null;
			String[] fields = vo.getAttributeNames();
			Vector v = new Vector();
			v.add("vdef1");
			if (v.size() > 0) {
				updateFields = new String[v.size()];
				updateFields = (String[]) v.toArray(updateFields);
			}
			try {
				new BaseDAO().updateVO(vo, updateFields);
			} catch (DAOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		// 解锁
		finally {
			PKLock.getInstance().releaseLock(vo.getPrimaryKey(), null, null);
		}
	}

20.读取文件

   public class ExceptionTest {
        public static void main(String[] args) {
            String file = "D:\\exceptionTest.txt";
            FileReader reader;
            try {
                reader = new FileReader(file);
                Scanner in = new Scanner(reader);  
                String string = in.next();  
                System.out.println(string + "不知道我有幸能够执行到不.....");
            } catch (FileNotFoundException e) {
                e.printStackTrace();
                System.out.println("对不起,你执行不到...");
            }  
            finally{
                System.out.println("finally 在执行...");
            }
        }
    }

苡菁

关注

4
点赞
踩
33

收藏

觉得还不错? 一键收藏
0
评论
nc系统常用代码

1. 在字段编辑前后的类中获取值以及赋值@Overridepublic void handleAppEvent(CardBodyAfterEditEvent e) { //获取卡片面板 BillCardPanel card = e.getBillCardPanel(); //卡片停止编辑必须写在最上面 card.stopEditing(); ...
复制链接

扫一扫