sql.txt

asp.net办公自动化实例导航——非常经典的OA源代码

select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A76'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A76'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select WLBZDMC,WJBDM from MIS_WLBDY Where len(WJBDM)>0 AND WJBLX='1' AND WLBDM='A76'
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'B%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'B001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A003'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A003'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select WLBZDMC,WJBDM from MIS_WLBDY Where len(WJBDM)>0 AND WJBLX='1' AND WLBDM='A003'
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A006'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A006'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select WLBZDMC,WJBDM from MIS_WLBDY Where len(WJBDM)>0 AND WJBLX='1' AND WLBDM='A006'
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A55'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A55'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select WLBZDMC,WJBDM from MIS_WLBDY Where len(WJBDM)>0 AND WJBLX='1' AND WLBDM='A55'
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'A%' 
select  distinct mis_wlbdy.wlbzddm,wlbzdmc from mis_wlbdy,mis_zbczqxb,mis_jsyhb where mis_wlbdy.wlbdm = 'A001'  and mis_wlbdy.wlbzddm  not like  'A__00'  and mis_zbczqxb.JSID = mis_jsyhb.JSID  and mis_jsyhb.YHID = 4  and mis_wlbdy.WLBDM = mis_zbczqxb.WLBDM  and mis_wlbdy.WLBZDDM = mis_zbczqxb.WLBZDDM 
select distinct mis_wlbdy.wlbdm,mis_zbjdyxx.wlbmc from mis_wlbdy,mis_zbjdyxx where mis_wlbdy.wlbdm = mis_zbjdyxx.wlbdm  and mis_wlbdy.wlbdm  like  'B%'