hs
/
hbghj


			
				
					
						
						
							123456789101112131415161718192021222324252627282930
							--单号规则
delete from T_YJPT_NORULE;
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4201','WH','yyyyMMdd',NULL,4,'危险作业申报地市的生成编号例如ZJ20155120001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('AQSSZXYS','AS','yyyyMM','-',4,'安全设施专项验收编号，AS-201603-0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('JSXMAQTJSC','JS','yyyyMM','-',4,'建设项目安全条件审查编号，JS-201603-0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('AQSSZPSC','ZP','yyyyMM','-',4,'安全设施设计专篇编号，ZP-201603-0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4201WHZYFZ','WHKG_FZSQ','yyyy','_','4','附证申请办理编号.WHKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4201ZDWXYBA','WHKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.WHKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4202WHZYFZ','HSKG_FZSQ','yyyy','_','4','附证申请办理编号.HSKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4202ZDWXYBA','HSKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.HSKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4203WHZYFZ','SYKG_FZSQ','yyyy','_','4','附证申请办理编号.SYHKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4203ZDWXYBA','SYKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.SYKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4205WHZYFZ','YCKG_FZSQ','yyyy','_','4','附证申请办理编号.YCKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4205ZDWXYBA','YCKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.YCKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4206WHZYFZ','XYKG_FZSQ','yyyy','_','4','附证申请办理编号.XYKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4206ZDWXYBA','XYKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.XYKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4207WHZYFZ','EZKG_FZSQ','yyyy','_','4','附证申请办理编号.EZKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4207ZDWXYBA','EZKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.EZKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4208WHZYFZ','JMKG_FZSQ','yyyy','_','4','附证申请办理编号.JMKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4208ZDWXYBA','JMKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.JMKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4209WHZYFZ','XGKG_FZSQ','yyyy','_','4','附证申请办理编号.XGKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4209ZDWXYBA','XGKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.XGKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4210WHZYFZ','JZKG_FZSQ','yyyy','_','4','附证申请办理编号.JZKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4210ZDWXYBA','JZKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.JZKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4211WHZYFZ','HGKG_FZSQ','yyyy','_','4','附证申请办理编号.HGKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4211ZDWXYBA','HGKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.HGKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4212WHZYFZ','XNKG_FZSQ','yyyy','_','4','附证申请办理编号.XNKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4212ZDWXYBA','XNKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.XNKG_ZDWXYBA_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4213WHZYFZ','SZKG_FZSQ','yyyy','_','4','附证申请办理编号.SZKG_FZSQ_2016_0001');
Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('4213ZDWXYBA','SZKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.SZKG_ZDWXYBA_2016_0001');