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);