NC 自定义参照类

package nc.ui.hzctr.costctr.ref;

import nc.ui.bd.ref.AbstractRefModel;
import nc.vo.pubapp.pattern.pub.SqlBuilder;

/**
 * 成本合同档案参照类 2017-6-27 11:15:04
 * 
 * @author Yaolz
 */
public class ContractRef extends AbstractRefModel {
	/**
	 * 参照列名称
	 * 
	 */
	@Override
	public String getRefTitle() {
		return "合同类型参照";
	}

	/**
	 * 可显示字段编码
	 */
	private static final String[] FIELD_CODE = { "contractnum", "contractname",
			"contracttype", "pk_costctr_h" };

	/**
	 * 可显示字段
	 */
	@Override
	public String[] getFieldCode() {
		return ContractRef.FIELD_CODE;
	}

	/**
	 * 参照列名称
	 * 
	 */
	private static final String[] FIELDNAME = { "合同号", "合同方", "合同类型", "主键" };
	
	/**
	 * 显示列名
	 */
	@Override
	public int getDefaultFieldCount() {
		return ContractRef.FIELDNAME.length;
	}

	@Override
	public String[] getFieldName() {
		return ContractRef.FIELDNAME;
	}

	private static final String table = "hzctr_costctr_h";

	@Override
	public String getTableName() {
		return ContractRef.table;
	}

	@Override
	protected String getEnvWherePart() {
		SqlBuilder wherePart = new SqlBuilder();
		wherePart.append(" nvl(dr,0)=0 and 1=1  ");
		return wherePart.toString();
	}

	/**
	 * 参照列主键
	 */
	public static final String PKCODE = "pk_costctr_h";

	@Override
	public String getPkFieldCode() {
		return ContractRef.PKCODE;
	}

	/**
	 * 隐藏列
	 */
	private static final String[] HIDDENFIELDCODE = { "pk_costctr_h" };

	@Override
	public String[] getHiddenFieldCode() {
		return ContractRef.HIDDENFIELDCODE;
	}
}

insert into bd_refinfo (CODE, DR, ISNEEDPARA, ISSPECIALREF, METADATATYPENAME, MODULENAME, NAME, PARA1, PARA2, PARA3, PK_REFINFO, REFCLASS, REFSYSTEM, REFTYPE, RESERV1, RESERV2, RESERV3, RESID, RESIDPATH, TS, WHEREPART)
values ('XXX101', 0, null, null, 'ContractTyeVO', 'xxx', '合同类型', null, null, null, '0001Z010000000HTLX01', 'nc.ui.xxx.contracttype.ref.ContractTypeRef', null, 0, null, null, null, '合同类型', 'ref', '2017-06-26 15:58:34', null);

 

　　

　在client下。