U8C(NC57)数据库字段扩展

需求:
客商档案自定义项不够用,需扩展自定义档案。
步骤:
1. 元数据升级(跟6版本做升级一样 修改bmf文件)版本号一定要调大。
在这里插入图片描述
升级元数据会联动更新md_table,md_column,md_ormap表。
2. 数据库表增加对应的数据字段

/*bd_cubasdoc 增加字段列*//*bd_cubasdoc 增加字段列*/
alter table bd_cubasdoc add 
    def21 varchar(400) null,
	 def22 varchar(400) null,
	 def23 varchar(400) null,
	 def24 varchar(400) null,
	 def25 varchar(400) null,
	 def26 varchar(400) null,
	 def27 varchar(400) null,
	 def28 varchar(400) null,
	 def29 varchar(400) null,
    def30 varchar(400) null,
    def31 varchar(400) null,
	 def32 varchar(400) null,
	 def33 varchar(400) null,
	 def34 varchar(400) null,
	 def35 varchar(400) null,
	 def36 varchar(400) null,
	 def37 varchar(400) null,
	 def38 varchar(400) null,
	 def39 varchar(400) null,
	 def40 varchar(400) null,
	 def41 varchar(400) null,
	 def42 varchar(400) null,
	 def43 varchar(400) null,
	 def44 varchar(400) null,
	 def45 varchar(400) null,
	 def46 varchar(400) null,
	 def47 varchar(400) null,
	 def48 varchar(400) null,
	 def49 varchar(400) null,
	 def50 varchar(400) null,
	 def51 varchar(400) null,
	 def52 varchar(400) null,
	 def53 varchar(400) null,
	 def54 varchar(400) null,
	 def55 varchar(400) null,
	 def56 varchar(400) null,
	 def57 varchar(400) null,
	 def58 varchar(400) null,
	 def59 varchar(400) null,
	 def60 varchar(400) null;
go
4.	修改mapping文件
/*    */ package nc.vo.bd.b08;
/*    */ import nc.jdbc.framework.mapping.IMappingMeta;
/*    */ public class CustBasMapping
/*    */   implements IMappingMeta
/*    */ {
/*    */   private static final String BD_CUBASDOC = "bd_cubasdoc";
/*    */   private static final String PK_CUBASDOC = "pk_cubasdoc";
/* 14 */   private static final String[] ATTRIBUTES = { "bp1", "bp2", "bp3", "conaddr", "creditmny", "custcode", "custname", "custprop", "custshortname", "def1", "def10", "def11", "def12", "def13", "def14", "def15", "def16", "def17", "def18", "def19", "def2", "def20", "def3", "def4", "def5", "def6", "def7", "def8", "def9", "dr", "drpnodeflag", "ecotypesincevfive", "email", "engname", "fax1", "fax2", "freecustflag", "isconnflag", "legalbody", "linkman1", "linkman2", "linkman3", "memo", "mnecode", "mobilephone1", "mobilephone2", "mobilephone3", "phone1", "phone2", "phone3", "pk_areacl", "pk_corp", "pk_corp1", "pk_cubasdoc", "pk_cubasdoc1", "pk_pricegroup", "registerfund", "saleaddr", "sealflag", "taxpayerid", "trade", "ts", "url", "zipcode", "correspondunit", "creator", "createtime", "modifier", "modifytime", "accdefault", "billtemplet",
	 			"def21", "def22", "def23", "def24", "def25", "def26", "def27", "def28", "def29", "def30",
	 			"def31", "def32", "def33", "def34", "def35", "def36", "def37", "def38", "def39", "def40",
	 			"def41", "def42", "def43", "def44", "def45", "def46", "def47", "def48", "def49", "def50",
	 			"def51", "def52", "def53", "def54", "def55", "def56", "def57", "def58", "def59", "def60"};
6.	修改数据VO,增加get set防范。要修改相关的几个方法getAttributeNames,getAttributeValue,setAttributeValue
/*      */   public String[] getAttributeNames()
/*      */   {
/*  231 */     return new String[] { "pk_corp", "custcode", "custname", "custshortname", "engname", "mnecode", "trade", "correspondunit", "freecustflag", "drpnodeflag", "isconnflag", "pk_cubasdoc1", "custprop", "pk_areacl", "pk_corp1", "taxpayerid", "legalbody", "creditmny", "ecotypesincevfive", "saleaddr", "conaddr", "zipcode", "phone1", "phone2", "phone3", "fax1", "fax2", "linkman1", "linkman2", "linkman3", "bp1", "bp2", "bp3", "mobilephone1", "mobilephone2", "mobilephone3", "email", "url", "def1", "def2", "def3", "def4", "def5", "def6", "def7", "def8", "def9", "def10", "def11", "def12", "def13", "def14", "def15", "def16", "def17", "def18", "def19", "def20", "memo", "registerfund", 
					"pk_pricegroup", "sealflag_b", "dr", "ts", "accdefault", "billtemplet",
					"def21", "def22", "def23", "def24", "def25", "def26", "def27", "def28", "def29", "def30",
		 			"def31", "def32", "def33", "def34", "def35", "def36", "def37", "def38", "def39", "def40",
		 			"def41", "def42", "def43", "def44", "def45", "def46", "def47", "def48", "def49", "def50",
		 			"def51", "def52", "def53", "def54", "def55", "def56", "def57", "def58", "def59", "def60"};
/*      */   }
  1. 单据模板中 右键增加
    在这里插入图片描述
    在这里插入图片描述
    项目主键值与数据表字段列名一致
  • 1
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值