ÐÒÔË·Éͧƽ̨

¦ò

ÐÅÏ¢¹«¿ª

ÐÒÔË·Éͧƽ̨

Äúµ±Ç°ËùÔÚλÖ㺠Éó¼ÆÎÄ»¯

dz̸ҽԺHISϵͳÉó¼Æ

À´Ô´£º ºÓÄÏÉó¼ÆÌü ¡¡¡¡·¢²¼Ê±¼ä£º 2019Äê01ÔÂ09ÈÕ
×ÖÌå´óС: С ÖÐ ´ó

Ëæ×żÆËã»úÓ¦Óõ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»Í¬µÄ£¬ÎÒÃǽøÐÐÊý¾Ý±È¶ÔµÄʱºòÐèÒª°´ÕÕͬһÅú´ÎµÄ¹º½ø¼ÛºÍÁãÊÛ¼Û½øÐбȶԣ¬²»Í¬Åú´ÎµÄ²»ÄÜÖ±½Ó½øÐбȶԣ¬ÉÏÊöÓï¾äÖÐÈë¿âµ¥±àºÅÈç¹û²»Í¬µÄ»°¿ÉÒÔ»»³ÉÅú´ÎºÅ¡£ºË¶Ô±È¶Ô½á¹ûµÄʱºòÒª¿´Í¬Ò»ÖÖµÄÒ©Æ·µÄ¹æ¸ñºÍ¼ÆÁ¿µ¥Î»ÊÇ·ñ·¢ÉúÁ˱仯¡£

ÎÊÌâ¶þ£º³öÔºµ±ÌìÊÕÈ¡´²Î»·Ñ

Éó¼ÆË¼Â·£º¸ù¾Ý¹æ¶¨£¬Ò»Âɰ´¼ÆÈë²»¼Æ³öµÄ°ì·¨£¬¼´ÈëÔºµ±Ìì¼ÆË㴲λ·Ñ£¬³öÔºµ±Ìì²»¼ÆË㴲λ·Ñ¡£µ±ÌìÈëÔºµ±Ìì³öÔºµÄ£¬°´Ò»Ìì¼ÆË㴲λ·Ñ¡£ÎÒÃÇÔÚ±àдÓï¾äµÄʱºò¾ÍÒª°ÑÈëÔººÍ³öÔºÊÇͬһÌìµÄÈ¥µô£¬±È½ÏÈëÔº³öÔº²»ÊÇͬһÌìµÄ£¬²é¿´³öÔºµ±ÌìÊÇ·ñÊÕÈ¡ÁË´²Î»·Ñ£¬²¢ÇÒµÚÒ»ÌìÈëÔºµÚ¶þÌì³öÔºµÄÒ²Ó¦¸ÃÌÞ³ýµô¡£²éѯÓï¾äÈçÏ£º

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, ÐÒÔË·Éͧ all right reserved
µØÖ·£ºº×±ÚÊпª·¢Çø»ÆÉ½Â· Óʱࣺ458030 °æÈ¨ËùÓУºÐÒÔË·Éͧ δ¾­Ðí¿ÉÇëÎðËæÒâ×ªÔØ£¡
ÍøÕ¾±êʶÂ룺4106000034