3

ǰλã Ļ

dz̸ҽԺHISϵͳ

Դ ʱ䣺 20190109
С: С

żӦõIJ룬ؼҽԺ𲽿ʼʹշƼලҲҪʱƷֿƼǿҪ󣬲ƹҽԺHISϵͳܽһЩdzָ֮

һϵͳ

HISϵͳΪҽԺһҪϵͳҪΪĸϵͳҩϵͳҩϵͳϵͳԼסԺϵͳҩϵͳҪҽԺҩϣԹҩƷͲϽǼǣаҩƷϵĹۡš̵һЩϢǼǹ󣬸ϵͳ󣬻ֱ⵽ϵͳۻʹáҩϵͳҪϵȡҩԼҩƷۣϵͳְҩҩֱⷿԳҩĺҩϵͳҲжӦҩƷĹۡۼۡⵥšⵥŵϢϵͳҪڶ￴ʱҽߵĴйӸϵͳ棬ǿԵõÿ˿ʱϵҩƷҽšڵһЩϢסԺϵͳϵͳ¼ÿ˵סԺԺʱ䡢סԺڼҽƷϢƹֵܷⶼڸϵͳСĸϵͳ⣬HISϵͳлйϵͳϵͳжӦҩƷϱҽƷĿҽһЩϢ

ΪԱҪ߱кǿİȫʶڲɼҽԺHISϵͳ̨ݵʱҪȫһҪӰϵͳУѵѡǻȡϵͳĶڱݡΣȡݺҪݽдƪõSQL SERVER 2008汾ȡoracleݵĻҪתҽԺȡϵͳֵ䣬һ̨ݵıжӢƣҪֵҵһЩȽϹؼıС

ǰڹ׼Ժ󣬽ݱȶˣݱȶԵ˼·ѧϰӦ߷棬Ȼоٳ׼ҵ⣬ݾд䣬ٶԱȶԳݽкʵ£

һҩƷӼ

˼·ͨijһҩƷķƱ͹ϸ¼ϵͳĸҩƷܼ۽бȽϣ鿴Ƿ޲һµģĿҪΪ˷ֹ¼ϵͳʱҩƷ۸иġ鷢û⣬潫ϵͳϵĹۺۼ۽бȽϣ鿴ǷΥӼ۵

ҩƷҪӼۣҩӼ25%ҪԱȵۼ빺ۣڸϵͳ涼иü۸Ҫ׼ȷҵõıۿѡҩϵͳرۼۿѡҩϵͳرѯ£

select a.ⵥ,a.ҩ,a.,a.,a.ۼ,b.ⵥ,b.,b.ۼ,b.ҩƷ,b.ҩƷ,b.ҩƷ,b.ۼ/a. as Ӽ,b.ۼ-a. as Ӽ۽

from ҩϵͳⵥ a left join ҩϵͳⵥ b on a.ⵥ=b.ⵥ

where b.ۼ/a.>1 and a. <>0 and a.ҩ=0001ҩţ

order by b.ۼ/a. desc

ҪעͬһҩƷĽۿDzͬģǽݱȶԵʱҪͬһεĹۺۼ۽бȶԣͬεIJֱӽбȶԣⵥͬĻԻκš˶ԱȶԽʱҪͬһֵҩƷĹͼλǷ˱仯

Ժȡλ

˼·ݹ涨һɰ벻Ƴİ취Ժ㴲λѣԺ첻㴲λѡԺԺģһ㴲λѡڱдʱҪԺͳԺͬһȥȽԺԺͬһģ鿴ԺǷȡ˴λѣҵһԺڶԺҲӦ޳ѯ£

select a.סԺ,cast(b. as date) ,a.Ŀ,

a.,a.,b.סԺ,cast(b.Ժ as date) Ժ,cast(b.Ժ as date) Ժ

from סԺϵͳ_˽ϸ a left join סԺϵͳ_˽㵥 b on a.סԺ=b.סԺ

where a.Ŀ in

('9901','9902','9903','9904','9905','9906','9907','9908','9909','9910','9911','9913','9996')

and cast(b.Ժ as date)=cast(b. as date)

and (cast(dateadd(day,1,b.Ժ) as date))<>cast(b.Ժ as date)

and cast(b.Ժ as date)<>cast(b.Ժ as date)

and a.ע<>'' and a.>0

order by a.סԺ

еĿΪ˼䡢˫˼ȷĴλѱšҪעЩҽԺ˼¼Աʧ⵼µģƹҪʵз

dz

ͨһЩ򵥷Ƿһ򵥵ҪҪǰ׼ҽԺHISϵͳһȽӴϵͳ漰ϵͳͱȽ϶࣬ƵʱҪǰ׼ȾϤص߷棬ȻҪ֪ʲôһһг󣬾ҪȥصıɸѡЩãЩûõģ˽֮ĹϵǶЩȽˣдزѯͼ򵥶ˡ

һֵǽһ̽ооݷ棬󲻽ϼǿоḻۣҲԼʱܽʵս飬ǿʵоʽϣΪһԱDzҪ̳дͳģʽҪؿҰ̽ϢƷǿƵ˼άʵõѭƶʵķչ

 

 

ر
վ | ϵ | վ
ױмļ֧ copyright 2004-2018, Hebi Audit Bureau. all right reserved
ַױпɽ· ʱࣺ458030 ȨУ3ƻ δתأ
վʶ룺4106000034