📄 htbm_qylx.sql

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

//插入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));
alter table dbo.sc_bm_wfyy add constraint indx_bm primary key nonclustered (bm) ;
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));
alter table dbo.ht_bm_zxyy add constraint indx_zx_code primary key nonclustered (zx_code) ;
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', '', '', '', '') ;

//建主键，删除数据，插入数据
delete sc_bm_wfyy;
alter table dbo.sc_bm_wfyy add constraint indx_bm primary key nonclustered (bm) ;
INSERT INTO sc_bm_wfyy VALUES (
	'01',
	' 超范围经营');
INSERT INTO sc_bm_wfyy VALUES (
	'02',
	'无照经营');
INSERT INTO sc_bm_wfyy VALUES (
	'03',
	'乱设摊点');
INSERT INTO sc_bm_wfyy VALUES (
	'04',
	'不按规定明码标价');
INSERT INTO sc_bm_wfyy VALUES (
	'05',
	'缺尺少寸，缺斤少两');
INSERT INTO sc_bm_wfyy VALUES (
	'06',
	'强买强卖');
INSERT INTO sc_bm_wfyy VALUES (
	'07',
	'骗买骗卖');
INSERT INTO sc_bm_wfyy VALUES (
	'08',
	'掺杂使假');
INSERT INTO sc_bm_wfyy VALUES (
	'09',
	'假冒伪劣');
INSERT INTO sc_bm_wfyy VALUES (
	'10',
	'出售违禁商品');
INSERT INTO sc_bm_wfyy VALUES (
	'11',
	'签订虚假合同');
INSERT INTO sc_bm_wfyy VALUES (
	'12',
	'串通订价');
INSERT INTO sc_bm_wfyy VALUES (
	'13',
	'发布虚假信息、广告');
INSERT INTO sc_bm_wfyy VALUES (
	'14',
	'其他违法行为');
INSERT INTO sc_bm_wfyy VALUES (
	'21',
	'经纪人从事非法经营活动');
INSERT INTO sc_bm_wfyy VALUES (
	'31',
	'非法倒卖房地产');
INSERT INTO sc_bm_wfyy VALUES (
	'32',
	'侵害消费者权益');
INSERT INTO sc_bm_wfyy VALUES (
	'33',
	'超范围经营');
INSERT INTO sc_bm_wfyy VALUES (
	'34',
	'虚假房地产广告');
INSERT INTO sc_bm_wfyy VALUES (
	'39',
	'房地产市场其它违法行为');
INSERT INTO sc_bm_wfyy VALUES (
	'41',
	'转让虚.假.劣技术');
INSERT INTO sc_bm_wfyy VALUES (
	'49',
	'技术市场其它违法行为');
INSERT INTO sc_bm_wfyy VALUES (
	'51',
	'非法集资');
INSERT INTO sc_bm_wfyy VALUES (
	'52',
	'非法从事证券期货代理');
INSERT INTO sc_bm_wfyy VALUES (
	'59',
	'金融市场其它违法行为');
INSERT INTO sc_bm_wfyy VALUES (
	'61',
	'职业介绍机构违法行为');
INSERT INTO sc_bm_wfyy VALUES (
	'69',
	'劳动力市场其它违法行为');
/////插入SC_BM_SCLX到a_sys_dic_group
INSERT INTO a_sys_dic_group VALUES (
	'SC_BM_SCLX',
	'市场管理市场类型',
	'N');
//建表sc_bm_sclx，插入数据
CREATE TABLE sc_bm_sclx (
	bm char(5),
	nr varchar(100));
alter table dbo.sc_bm_sclx add constraint idx_sclx primary key nonclustered (bm) ;
INSERT INTO sc_bm_sclx VALUES (
	'3',
	'生产要素市场');
INSERT INTO sc_bm_sclx VALUES (
	'2',
	'生产资料市场');
INSERT INTO sc_bm_sclx VALUES (
	'1',
	'消费品市场');
INSERT INTO sc_bm_sclx VALUES (
	'29',
	'其他');
INSERT INTO sc_bm_sclx VALUES (
	'284',
	'农机');
INSERT INTO sc_bm_sclx VALUES (
	'283',
	'种子');
INSERT INTO sc_bm_sclx VALUES (
	'282',
	'化肥');
INSERT INTO sc_bm_sclx VALUES (
	'281',
	'农药');
INSERT INTO sc_bm_sclx VALUES (
	'28',
	'农资');
INSERT INTO sc_bm_sclx VALUES (
	'27',
	'木材');
INSERT INTO sc_bm_sclx VALUES (
	'26',
	'建材');
INSERT INTO sc_bm_sclx VALUES (
	'25',
	'粮食');
INSERT INTO sc_bm_sclx VALUES (
	'24',
	'成品油');
INSERT INTO sc_bm_sclx VALUES (
	'23',
	'钢材');
INSERT INTO sc_bm_sclx VALUES (
	'22',
	'旧车');
INSERT INTO sc_bm_sclx VALUES (
	'21',
	'新车');
INSERT INTO sc_bm_sclx VALUES (
	'35',
	'金融');
INSERT INTO sc_bm_sclx VALUES (
	'34',
	'科技');
INSERT INTO sc_bm_sclx VALUES (
	'33',
	'旅游');
INSERT INTO sc_bm_sclx VALUES (
	'32',
	'经纪人');
INSERT INTO sc_bm_sclx VALUES (
	'31',
	'房地产');

//插入数据到a_zhizhao_print_move_parameter中增加户卡打印
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'jycs',
	'地址',
	247.00,
	548.00,
	1074.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'jyfw',
	'经营范围',
	78.00,
	1136.00,
	594.00,
	492.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'jyjzrq',
	'经营截止日期',
	919.00,
	888.00,
	402.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'jyqsrq',
	'经营开始日期',
	389.00,
	892.00,
	416.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'jyzm',
	'负责人',
	288.00,
	416.00,
	480.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'lxdh',
	'电话',
	928.00,
	416.00,
	398.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	't_3',
	'经济性质',
	343.00,
	716.00,
	379.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'zch',
	'注册号码（内容）',
	571.00,
	168.00,
	677.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'zch_t',
	'注册号码（显示）',
	274.00,
	168.00,
	283.00,
	60.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'个体户卡打印',
	'd_qt_hk_print',
	'zhmc',
	'企业名称',
	283.00,
	276.00,
	1033.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'hzrq',
	'核准日期',
	389.00,
	892.00,
	416.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'lxdh',
	'电话',
	928.00,
	416.00,
	398.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'qylx',
	'经济性质',
	343.00,
	716.00,
	379.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'qymc',
	'企业名称',
	283.00,
	276.00,
	1033.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'ywfw',
	'经营范围',
	78.00,
	1136.00,
	594.00,
	492.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'yyqx2',
	'经营截止日期',
	919.00,
	888.00,
	402.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'zch',
	'注册号码（内容）',
	571.00,
	168.00,
	677.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'zch_t',
	'注册号码（显示）',
	274.00,
	168.00,
	283.00,
	60.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'zs',
	'地址',
	247.00,
	548.00,
	1074.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
INSERT INTO a_zhizhao_print_move_parameter VALUES (
	'企业户卡打印',
	'd_qy_hk_print',
	'zyfzr',
	'负责人',
	288.00,
	416.00,
	480.00,
	64.00,
	NULL,
	NULL,
	NULL,
	10);
💿 文件大小 25634 K
👤 上传用户 zhuying0000
📂 所属分类电子政务应用
🏷️ 相关标签

#商 #行政管理 #源码
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -