502增加预算样表审批流的方法nc产品支持部王静wjmint@ufida.com.cn502的预算在补丁版中增加了样表的审批流程，很多项目在实施中发现，该功能打上补丁后怎么不管用呢？其实，该功能的实现，需要打补丁，插脚本，功能注册三步。现做整理。具体如下：1打补丁NC-TB-V5.02-Patch-20090804-00171（或者最新汇总补丁）2.执行脚本deletefromBD_BILLTYPEwherePK_BILLTYPECODE='T1'deletefromPUB_VOTABLEwherePK_BILLTYPE='T1'deletefromPUB_BILLACTIONwherePK_BILLTYPE='T1'deletefromPUB_BUSICLASSwherePK_BILLTYPE='T1'ALTERTABLENTB_SD_TASKMODIFYREVIEWMANVARCHAR(100)ALTERTABLENTB_SD_TASKMODIFYCHECKMANVARCHAR(100)INSERTINTOBD_BILLTYPE(ACCOUNTCLASS,BILLSTYLE,BILLTYPENAME,CHECKCLASSNAME,CLASSNAME,DEF1,DEF2,DEF3,DR,ISACCOUNT,ISITEM,ISROOT,NODECODE,PARENTBILLTYPE,PK_BILLTYPECODE,REFERCLASSNAME,SYSTEMCODE,TS,WHERESTRING)VALUES(NULL,NULL,'预算审批','nc.vo.ntb.db.WorkFlowCheck','30020702',NULL,NULL,NULL,NULL,'N','N','N','30020702',NULL,'T1',NULL,'TB','2009-03-2515:29:00',NULL)INSERTINTOPUB_VOTABLE(APPROVEID,BILLID,BILLNO,BILLVO,BUSITYPE,DEF1,DEF2,DEF3,DR,HEADBODYFLAG,HEADITEMVO,ITEMCODE,OPERATOR,PK_BILLTYPE,PK_CORP,PK_VOTABLE,PKFIELD,TS,VOTABLE)VALUES('reviewman','pk_obj','objname','nc.vo.ntb.db.AggregatedSdTaskVO',NULL,NULL,NULL,NULL,NULL,'Y','nc.vo.ntb.db.SdTaskVO',NULL,'compileman','T1',NULL,'0001ZD1000000000E7L4','pk_obj','2009-03-1916:18:42','ntb_sd_task')INSERTINTOPUB_BILLACTION(ACTIONNOTE,ACTIONSTYLE,ACTIONSTYLEREMARK,ACTIONTYPE,CONSTRICTFLAG,CONTROLFLAG,DR,FINISHFLAG,PK_BILLACTION,PK_BILLTYPE,SHOWHINT,TS)VALUES('保存',NULL,NULL,'SAVE','N','N',0,'N','0001ZD1000000000E7L0','T1',NULL,'2009-03-1915:42:56')INSERTINTOPUB_BILLACTION(ACTIONNOTE,ACTIONSTYLE,ACTIONSTYLEREMARK,ACTIONTYPE,CONSTRICTFLAG,CONTROLFLAG,DR,FINISHFLAG,PK_BILLACTION,PK_BILLTYPE,SHOWHINT,TS)VALUES('审批',NULL,NULL,'APPROVE','N','N',0,'N','0001ZD1000000000E7L1','T1',NULL,'2009-03-1915:43:22')INSERTINTOPUB_BUSICLASS(ACTIONTYPE,CLASSNAME,DR,ISBEFORE,PK_BILLTYPE,PK_BUSICLASS,PK_BUSINESSTYPE,PK_CORP,TS)VALUES('SAVE','N_T1_SAVE',0,'N','T1','TB_NEW10000000T1SAVE',NULL,NULL,'2008-10-2700:00:00')INSERTINTOPUB_BUSICLASS(ACTIONTYPE,CLASSNAME,DR,ISBEFORE,PK_BILLTYPE,PK_BUSICLASS,PK_BUSINESSTYPE,PK_CORP,TS)VALUES('APPROVE','N_T1_APPROVE',0,'N','T1','TB_NEW10000T1APPROVE',NULL,NULL,'2008-10-2700:00:00')3.功能注册在预算项表下，直接增加功能按钮名称为审批流设置即可4.分配按钮权限这样，在样表设置中就会看到审批流设置，审批流定义中也会出现新的预算审批功能点
