0718.txt

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

合计:
1&select count(*) result from gsgsjin_basis02 where field096<? and field104=? and (field002 = ''020204'') and field155 = ''9002''
2&select count(*) result from gsgsjin_basis02 where (field096 between ? and ?) and field104=? and (field002 = ''020204'') and field155 = ''9002'' 
2&select count(*) result from gsgsjin_basis02 where (field096 between ? and ?) and field104=? and ((field002 = ''080204'') or (field002 = ''090204'')) and field155 = ''9002'' 
1&select count(*) result from gsgsjin_basis02 where field096<? and field104=? and ((field002 = ''080204'') or (field002 = ''090204'')) and field155 = ''9002'' 


field002 数据标志1：业务类型，是编码表 
field016 国别



field020 企业类型
field022 行业代码
field096 成立日期（登记日期）
field104 登记单位编码
field155 开业登记 9002’ 代表该业务处理完毕


080204 外国（地区）企业常驻代表机构注销登记
090204 外国（地区）企业常驻代表机构吊销登记
020204 外国（地区）企业常驻代表机构开业登记


select field016 mark,count(*) result from gsgsjin_basis02 where field096<? and field104=? and (field002 = ''020204'') and field155 = ''9002'' and field016 is not null group by field016


按钮:

3&SELECT bm,'&nbsp' as num1,bmnr FROM a_bm_gbdq   where ((bmzb <>20) and (bmzb <>40) and (bmzb <>60) and (bmzb <>80) and(bmzb <>100) and  (bmzb <>120)) or (bm  > '990')

1&select field022 mark,count(*) result from gsgsjin_basis02 where ?=?


编号 类型 内容 属性 跨行 跨列 行结束 对齐 宽度 高度 字体 文字大小 文字样式 文字颜色 变化标志 变化的数量逻辑 边线 元素输出值 左边线 右边线 上边线 下边线 左开始标志 右开始标记 上开始标记 下开始标记 coding1 组分类标记 



private 私营
person 个体
foreigncapital 外资
localcapital 内资


ZHANGFENG
localcapital0001	1公司登记基本情况统计表 Page32
localcapital0002	2查处企业违反工商企业登记法规情况统计表Page33
foreigncapital0001	3外商投资企业登记基本情况统计表（2）（按国别和地区分组)Page51~59
foreigncapital0002	4外商投资企业注册资本增减情况统计表 Page60
foreigncapital0003	5查处外商投资企业违反企业登记管理法规情况统计表 Page61
工作时间:2天
___________________________________________________________________________________
XIANFUGUO
foreigncapital0004	6外国及港澳台地区企业常驻代表机构登记情况统计表（按业务范围分组）Page62
foreigncapital0005	7外国及港澳台地区企业常驻代表机构登记情况统计表（按国别和地区分组）Page63~64
foreigncapital0006	8外国及港澳台地区企业在华承包、开发、金融保险登记基本情况表（按项目分组）Page65
foreigncapital0007	9外国及港澳台地区企业在华承包、开发、金融保险登记基本情况表（按国别分组）Page66~67
private0001	10私营企业基本情况统计表二 Page79
工作时间:2天

___________________________________________________________________________________
LIJUN
private0002	11私营企业基本情况统计表三 Page80
private0003	12私营企业违法违章情况统计表 Page81
person0004	13个体工商户违法违章情况统计表 Page91
person0005	14个体工商业基本情况季报表 Page92
工作时间:2天

___________________________________________________________________________________
wanglijun
person0006	15.个体工商户检查验照统计表
___________________________________________________________________________________
wangjiefei
foreigncapital0008	16.外商投资企业登记基本情况季报表（按国地区分组） Page69~70





-------------------------------------------------------------------------------------
sn//事务号
category//业务编号
coding//


field004 注册号
field009 企业名称
field034 营业场所
field067 经营范围

page_code,code,type,input_value,style,width,height,font_type,font_size,font_style,color,rowspan,colspan,rowcolendpoint,change_sign,change_num_logic,position,border_haveno_sign,output_value,left_haveno_sign,left_startend_sign,right_haveno_sign,right_startend_sign,top_haveno_sign,top_startend_sign,bottom_haveno_sign,bottom_startend_sign,coding1,logic_mark

//select field104 from gsgsjin_basis02 where field104 is not null order by field104;
select count(*) result,field016 mark from gsgsjin_basis02 where field096<'20031231' and field104='110101'   and (field002 = '020204') and field155 = '9002' and field016 is not null group by field016;
//select * from a_bm_gbdq where   bm='158';

1&select field016 mark,count(*) result from gsgsjin_basis02 where field096<? and field104=? and (field002 = ''020204'') and field155 = ''9002'' and field016 is not null group by field016

2&select field016 mark,count(*) result from gsgsjin_basis02 where (field096 between ? and ?) and field104=? and (field002 = ''020204'') and field155 = ''9002'' and field016 is not null group by field016

2&select field016 mark,count(*) result from gsgsjin_basis02 where (field096 between ? and ?) and field104=? and ((field002 = ''080204'') or (field002 = ''090204'')) and field155 = ''9002'' and field016 is not null group by field016

1&select field016 mark,count(*) result from gsgsjin_basis02 where field096<? and field104=? and ((field002 = ''080204'') or (field002 = ''090204'')) and field155 = ''9002'' and field016 is not null group by field016