htbm_qylx.sql

一套PB开发的工商行政管理全套源码,包括企业登记,执照,案件管理等.

//插入htbm_qylx到a_sys_dic_group
INSERT INTO a_sys_dic_group VALUES (
	'HTBM_QYLX',
	'合同管理企业类型',
	'P');
//建表htbm_qylx和插入数据
CREATE TABLE htbm_qylx (
	bm char(2),
	qylx varchar(30));
INSERT INTO htbm_qylx VALUES (
	'1',
	'国有企业');
INSERT INTO htbm_qylx VALUES (
	'2',
	'集体企业');
INSERT INTO htbm_qylx VALUES (
	'3',
	'私营企业');
INSERT INTO htbm_qylx VALUES (
	'4',
	'混合所有企业');
INSERT INTO htbm_qylx VALUES (
	'5',
	'外商投资企业');
INSERT INTO htbm_qylx VALUES (
	'6',
	'其他');
//插入数据到a_bm_jbdw
INSERT INTO a_bm_jbdw VALUES (
	'qt',
	'其他单位');
//建表ht_bm_zxyy和插入数据
CREATE TABLE ht_bm_zxyy (
	zx_code char(2),
	zxyy varchar(100));
INSERT INTO ht_bm_zxyy VALUES (
	'03',
	'其他');
INSERT INTO ht_bm_zxyy VALUES (
	'02',
	'抵押物灭失');
INSERT INTO ht_bm_zxyy VALUES (
	'01',
	'债务履行完毕');
//增加表ht_dcxqb字段xqyy
alter table dbo.ht_dcxqb add xqyy text null ;
update dbo.pbcattbl set pbd_fhgt = -10, pbd_fwgt = 400, pbd_fitl = 'N', pbd_funl = 'N', pbd_fchr = 0, pbd_fptc = 34, pbd_ffce = 'Arial', pbh_fhgt = -10, pbh_fwgt = 400 , pbh_fitl = 'N', pbh_funl = 'N', pbh_fchr = 0, pbh_fptc = 34, pbh_ffce = 'Arial', pbl_fhgt = -10, pbl_fwgt = 400 , pbl_fitl = 'N', pbl_funl = 'N', pbl_fchr = 0, pbl_fptc = 34, pbl_ffce = 'Arial', pbt_cmnt = '抵押续期表' where pbt_tid = object_id('dbo.ht_dcxqb') ;
insert into dbo.pbcatcol (pbc_tnam, pbc_tid, pbc_ownr, pbc_cnam, pbc_cid, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_mask, pbc_case, pbc_hght, pbc_wdth, pbc_ptrn, pbc_bmap, pbc_init, pbc_cmnt, pbc_edit, pbc_tag) values ( 'ht_dcxqb', object_id('dbo.ht_dcxqb'), 'dbo', 'xqyy', 8, '', 0 , '', 0, 23 , '', 0 , 65 , 4718 , '', 'N', '', '', '', '') ;