|
·ÖÀർº½ |
 |
|
|
|
´´ÒµÈí¼þHISÒ©·¿ÏµÍ³ÏêϸÉè¼ÆËµÃ÷Êé |
|
×ÊÔ´´óС£º30.94 KB |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 7 |
|
|
|
×ÊÔ´½éÉÜ |
|
BSHIS2.2ÏêϸÉè¼ÆËµÃ÷Êé
(ÖÐÎ÷Ò©·¿¹ÜÀíϵͳ)
Ò»£® ¸ÅÊö
ÖÐÎ÷Ò©·¿¹ÜÀíϵͳÖ÷Òª´¦ÀíÒ©·¿»®¼Û·¢Ò©¼°»ù±¾¿â·¿ÒµÎñ¡£È·ÇÐ
µØËµ£¬ËüÊǽ«ÖС¢Î÷¡¢²¡ÇøÒ©·¿µÄ¸÷ÖÖÒµÎñ²Ù×÷ÌáÉý²¢×ÛºÏÆðÀ´ÓÃͬһ¸öϵͳµÄ³ÌÐòÀ´Íê³É£¬ÆäÖв¡ÇøÒ©·¿·¢Ò©µÄ²Ù×÷±È½ÏÌØÊ⣬ËùÒÔµ¥¶À´¦Àí²¢ÔÚ¡°²¡Çø·¢Ò©¹ÜÀíϵͳ¡±ÖмÓÒÔ˵Ã÷¡£
¸Ãϵͳ¹²ÓÐÈýÖÖÀàÐ͵ÄÒµÎñ£º¿â·¿ÒµÎñ¡¢ÃÅÕï·¢Ò©¡¢×¡Ôº·¢Ò©£¨ÔÚÃÅÕïÒ©·¿ÖÐÖ¸¶ÔסԺ²¡È˵Ĵ¦·½·¢Ò©£¬ÔÚ²¡ÇøÒ©·¿ÖÐÔòÖ¸¶Ô²¡ÇøµÄÒ½Öö·¢Ò©µÈ£©£¬ÒÔÏ·ֱð½øÐÐÏêϸÃèÊö¡£
Ò©·¿µÄ¿â·¿ÒµÎñÖ÷Òª°üÀ¨ÏòÒ©¿âÁìÒ©¡¢ÆäËüÈë¿â¡¢³ö¿â¡¢Ò©·¿Ö®¼äµ÷²¦¡¢ÅÌ´æ´¦Àí¡¢Ô½ᴦÀíµÈ£¬¸ù¾Ý²»Í¬ÐèÒª»¹Ðè´¦ÀíһЩ²éѯ²Ù×÷£¬Èç¼Û¸ñ²éѯ¡¢¿â´æ²éѯ¡¢µ÷¼Û²éѯ¡¢Ô±¨²éѯ¡¢Ì¨Õʲéѯ¡¢µÍ´¢±¨¾¯µÈ£¬ÁíÍ⻹ÓÐ¿â´æµ÷Õû¡¢¿â´æ½ûÓõÈÌØÊâ²Ù×÷¡£
ÃÅÕï·¢Ò©ÒµÎñ°üÀ¨´¦·½»®¼Û¡¢´¦·½·¢£¨Å䣩ҩ¡¢ÍËÒ©´¦Àí¡¢È¡Ïû·¢Ò©µÈ£¬ÏàÓ¦µÄÓд¦·½·¢Ò©²éѯ¡¢Î´·¢Ò©´¦·½²éѯ¡¢·¢Ò©Í³¼ÆµÈ²Ù×÷¡£
סԺ·¢Ò©ÒµÎñÔÚÕâÀïÖ»Ö¸¶ÔסԺ²¡È˵Ĵ¦·½·¢Ò©£¬ÔÚ·¢Ò©Í³¼ÆÖлá×÷ͳ¼Æ¡£
ΪÊÊÓ¦Ò½ÔºÒµÎñ¹¤×÷ģʽµÄ¶à±äÐÔ£¬ÔÚ2.2°æ±¾ÖУ¬Ôö¼ÓÁËÈý¼¶¿â·¿¹ÜÀíµÄÉè¼Æ£¬Æä¾ßÌåÉè¼ÆË¼Â·ÈçÏ£º
£¨1£©ÔÚÈý¼¶¿â·¿Ä£Ê½ÖУ¬Ò©·¿×÷ΪÖмä¿â·¿£¬Ö÷Òª´¦Àí¿â´æÏà¹Ø²Ù×÷£¨ÈçÏòÒ©¿âÁìÒ©¡¢ÆäËüÈ루³ö£©¿â¡¢Í³¼Æ²¢¼Ç¼Õû¸öÒ©·¿µÄÒ©Æ·½ø³öÇé¿ö£©£¬¶ø¶ÔÃÅÕﲡÈ˺ÍסԺ²¡È˵ķ¢Ò©ÒµÎñ¶¼ÔÚ´°¿ÚϵͳÖд¦Àí£»´°¿Ú×÷Ϊ¶ÀÁ¢µÄ¿â·¿µ¥Î»£¬ÓÐ×Ô¼ºµÄ¿â´æ¼°ÏàÓ¦µÄ¹ÜÀíÒµÎñ£¬´°¿ÚÖ®¼ä¿ÉÒÔ»¥Ïàµ÷²¦£¬Ò²¿ÉÒÔÏòÒ©·¿ÉêÇëµ÷²¦¡£
£¨2£©´°¿Ú¿â´æÊÇÒ©·¿¿â´æµÄÒ»²¿·Ö£¬Ò©·¿Ì¨ÕʶÔÕû¸öÒ©·¿µÄÊÕÖ§ÒµÎñ½øÐмǼ£¬Ò©·¿Ô½áÊǶÔÕû¸öÒ©·¿ÒµÎñµÄ×ܽᣬҩ·¿ÄÚ²¿µÄµ÷²¦²»ÁÐÈëÊÕÖ§£»¸÷´°¿Ú¿ÉÒÔ½øÐжÀÁ¢ºËË㣬ÉèÁ¢×Ô¼ºµĄ̈ÕÊ£¬¼Ç¼´°¿ÚµÄÒ©Æ·½ø³ö£¬½øÐд°¿ÚÔ½ᡣ
£¨3£©ÔÚ¾ßÌåÉè¼ÆÖÐÒª¿¼ÂǶþ¼¶Ä£Ê½ºÍÈý¼¶Ä£Ê½µÄ¼æÈÝ£¬³ý´°¿ÚϵͳÖÐÓÐÌØÊâÐèÇó»òÒµÎñÒªÇóÐÂÔöµÄÄ£¿é£¬ÆäÓà¿É¹²ÓõIJ¿·Ö»ù±¾ÉÏÓÃÏàͬµÄ³ÌÐòÀ´ÊµÏÖ¡£ÏÂÃæ¶Ô¹á´©Õû¸öϵͳµÄһЩÉè¼ÆÏ¸½Ú×÷ÏêÊö£º
1£® ÔÚ¸÷Ïà¹ØÊý¾Ý±íÖÐÔö¼ÓCKBH×ֶΣ¬ÏµÍ³Ä¬ÈÏCKBH=0µÄÊý¾ÝΪҩ·¿Êý¾Ý¡£
2£® ÉèÒ»¹«ÓñäÁ¿gi_kcck£¬ÔËÐÐÒ©·¿ÏµÍ³Ê±gi_kcck=0£¬ÔËÐд°¿Úϵͳʱgi_kcck=ckbh£¬ÔÚ´¦Àí¿â´æÔö¼õʱ£¬ÓÃgi_kcckÀ´ÅжÏÓ¦¸Ã±ä¶¯¿â´æµÄ´°¿ÚºÅ¡£
3£® ÔÚ´¦·½»®¼Û¡¢ÃÅÕï·¢Ò©¡¢×¡ÔºÓÃҩʱ£¬ÅжÏÓÐÎÞ¿â´æ¾ùʹÓø÷´°¿Ú¿â´æµÄÀÛ¼Ó£»¶øÔÚ²¡Çø·¢Ò©¸÷Ä£¿éÖУ¬¿¼ÂÇ´¦ÀíµÄ¸´ÔÓÐÔ¼°ËÙ¶ÈÒªÇó£¬Èç¹û´°¿ÚûÓÐ¿â´æ£¬Ôò²»ÄÜ·¢Ò©£¬ÕâʱӦÏÈÏòÆäËü´°¿Úµ÷²¦¡£
¶þ£®Ä£¿éÉè¼ÆËµÃ÷Êé
ϵͳÃû³Æ ÖÐÎ÷Ò©·¿ÏµÍ³ ϵͳ±àºÅ 03
Ä£¿é±àºÅ 3.1.1.1
Ä£¿éÃû³Æ ÃÅÕï·¢Ò©->´¦·½·¢Ò©(Ö±½Ó·¢Ò©)
¹¦
ÄÜ
Ãè
Êö ¶ÔÒÑÊÕ·Ñ´¦·½½øÐз¢Ò©²Ù×÷
×ó±ßµÄÁбíÁгöËùÓÐÒÑÊÕ·Ñδ·¢Ò©µÄ´¦·½£¬ÊÖËùָΪѡÖд¦·½
ÓÒ±ßÏÔʾѡÖеĴ¦·½ÏêϸÐÅÏ¢¡£
IPO
¹ý
³Ì
Ãè
Êö 1. µ±ÏµÍ³ÉèÖÃÖÐÉè·¢Ò©·½Ê½Îª¡°Ö±½Ó·¢Ò©¡±Ê±µ÷Óô°¿Úw_yf_cffy×ö·¢Ò©´¦Àí£¬Èç¹ûÉèÖÃÁË¡°×Ô¶¯Ë¢Ð¡±¼°¡°×Ô¶¯Ë¢ÐÂÃëÊý¡±Ñ¡Ïÿ¸ô¹Ì¶¨µÄʱ¼ä»á×Ô¶¯Ë¢ÐÂ×ó±ßµÄ´¦·½ÁÐ±í£»
2. ×¼±¸¹¤×÷°üÀ¨£ºÈ»ºó³õʼ»¯Ò©Æ·ÊäÈëÑ¡Ôñ¶ÔÏó£¨u_select_yp£©¼°Ò©Æ·¹ÜÀí¶ÔÏó£¨u_yf_mzfy£©£»ÉèÖ÷¢Ò©È˺ÍÅäÒ©ÈË(ÅäÒ©ÈËȷʡΪ·¢Ò©ÈË)£»È¡¿É·¢Ò©´¦·½ÀàÐÍ£»³õʼ»¯DATAWINDOW²¢Ë¢ÐÂÈ«ÆÁÄ»£»È¡×Ô¶¯Ë¢ÐÂÃëÊý£¬´¥·¢timerʼþ£¬Ë¢ÐÂÆÁÄ»£¨Ë¢ÐÂdw_cf01ºÍdw_cf02£©£»refresh_listºÍrefresh_detail£»ÉèÖò¡Çø·¢Ò©Ìáʾ£¨u_distri_notify£©¡£
3£®×ó±ßÁгöms_cf01ÖÐÂú×ãÒÔÏÂÌõ¼þµÄËùÓд¦·½£º
(1)δ·¢Ò©fybz=0
(2)δ×÷·Ïzfbz=0
(3)´¦·½Ð§ÆÚÔÚÖ¸¶¨µÄÈÕÆÚºó
(4)´¦·½ÀàÐÍΪ¸ÃÒ©·¿µÄ´¦·½ÀàÐÍ ÃÅÕïÒ©·¿Îª1,ÖÐÒ©·¿Îª2
ÓÒ±ßÁгöµÄ´¦·½Ò©Æ·Ã÷ϸ´Óms_cf02ÖÐÈ¡³ö,ÿ»»Ò»ÕÅ´¦·½ÖØÐÂË¢ÐÂÒ©Æ·Ã÷ϸ¡£
4£®·¢Ò©Ê±£¬ÏÈÅб𴦷½ÊÇ·ñÒÑ×÷·Ï»òÒѱ»ÆäËü´°¿Ú·¢Ò©£¬´¦·½ÉÏÒ©Æ·µÄ¿â´æÊÇ·ñÂú×ãÒª
Çó(u_yf_mzfy.checkcf())¡£È·¶¨¿ÉÒÔ·¢Ò©ºó£¬µ¯³öÅäÒ©ÈË´°¿Ú£¬ÊäÈëÅäÒ©È˹¤ºÅ¡£ÔÙ·¢Ò©£¨u_yf_mzfy.issueprocess(as_pyr)£©,¸ù¾Ý´¦·½Ò©Æ·Ã÷ϸÖðÌõ¼õÉÙyf_kcmxÖÐ¿â´æ£»¸üÐÂms_cf01ÖеÄFYBZ£¬FYRQ£¬FYGH£¬FYCK£¬PYGH£¬PYBZ
5£® ¹ûÔÚ·¢Ò©ÒÔǰҩƷ¼Û¸ñÒѱ䶯(°üÀ¨Ò©·¿°ü×°±ä¶¯)£¬ÔòÔÚyf_tjjlÖÐÌîдµ÷¼Û¼Ç¼£»
6£®µã»÷¡°ÓÃÒ©Éó²é¡±¿É¶Ôµ±Ç°´¦·½½øÐÐÓÃÒ©Éó²é£¬µã¡°ÉèÖ᱿ɸü¸ÄÆÁÄ»ÏÔʾµÄÅäÒ©ÈË¡£
Êý¾Ý´°¿Ú D_yf_fycf,d_yf_fycf_head,d_yf_fycf_mx
ÒýÓñí Ms_cf01,ms_cf02,yk_typk,yk_ypcd
²Ù×÷±í Ms_cf01,yf_kcmx,yf_tjjl
±à ÖÆ ÀîÇ¿¡¢ÖÓ»ª ±àÖÆÈÕÆÚ 2000/5/9 ÉóºË ÉóºËÈÕÆÚ
ϵͳÃû³Æ ÖÐÎ÷Ò©·¿ÏµÍ³ ϵͳ±àºÅ 03
Ä£¿é±àºÅ 3.1.1.2
Ä£¿éÃû³Æ ÃÅÕï·¢Ò©->´¦·½·¢Ò©(ÅäÒ©·½Ê½)
¹¦
ÄÜ
Ãè
Êö ¶ÔÒÑÊÕ·Ñ´¦·½½øÐз¢Ò©²Ù×÷
ÿ¸ôÖ¸¶¨µÄʱ¼ä´Óms_cf01ÖÐÁгöδÅäÒ©´¦·½
ÅäÍêÒ©ºó½«´¦·½´ÓϱßÒÆµ½Éϱߴ°¿Ú
¶ÔÒÑÅäÍêÒ©µÄ´¦·½½øÐз¢Ò©(¼ûÖ±½Ó·¢Ò©)
IPO
¹ý
³Ì
Ãè
Êö 1. µ±ÏµÍ³ÉèÖÃÖÐÉè·¢Ò©·½Ê½Îª¡°ÅäÒ©·½Ê½¡±Ê±µ÷Óô°¿Úw_yf_cffy_qz×ö·¢Ò©´¦Àí£¬ÏµÍ³¸ù¾Ý ¡°ÅäÒ©¼ä¸ôʱ¼ä¡±Ñ¡ÏîÖеÄÃëÊý¶¨Ê±×¥È¡Î´ÅäÒ©µÄ´¦·½²¢ÐÞ¸ÄÆäPYBZ=-1£¬FYCK=´°¿ÚºÅ£¬PYGH=ĬÈÏÅäÒ©ÈË¡£
3. ×¼±¸¹¤×÷°üÀ¨£ºÈ»ºó³õʼ»¯Ò©Æ·ÊäÈëÑ¡Ôñ¶ÔÏó£¨u_select_yp£©¼°Ò©Æ·¹ÜÀí¶ÔÏó£¨u_yf_mzfy£©£»ÉèÖ÷¢Ò©È˺ÍÅäÒ©ÈË(ÅäÒ©ÈËȷʡΪ·¢Ò©ÈË)£»È¡¿É·¢Ò©´¦·½ÀàÐÍ£»³õʼ»¯DATAWINDOW²¢Ë¢ÐÂÈ«ÆÁÄ»£»È¡ÅäÒ©¼ä¸ôʱ¼ä£¬´¥·¢timerʼþ£¬Ô¤Éè´¦·½·¢Ò©´°¿Ú£¨Í¬Ò»·¢Æ±¶àÕÅ´¦·½ÉèΪͬһ´°¿Ú£©¶¨ÆÚץȡ´¦·½£¬Ë¢ÐÂÆÁÄ»£»refresh_listºÍrefresh_detail£»ÉèÖò¡Çø·¢Ò©Ìáʾ£¨u_distri_notify£©¡£
2. Ms_cf01ÖÐpybzÅäÒ©±êÖ¾ ¨C1ÕýÔÚÅäÒ©£¬0δÅäÒ©£¬1ÒÑÅäÍêÒ©
3. ×óÉÏ·½ÁгöÅäÍêÒ©µÄ´¦·½£¬×óÏ·½ÁгöÕýÔÚÅäÒ©µÄ´¦·½£»¡°È¡ÏûÅäÒ©¡±Éè´¦·½µÄPYBZ=0£¬²¢½«Æä´Ó´ýÅäÒ©´¦·½ÁбíÖÐɾ³ý£»¡°ÔÝÍ£ÅäÒ©¡± Éètimer(0),ÔÝÍ£´Óms_cf01ÖÐץȡ´¦·½£»¡°½áÊøÅäÒ©¡±Ð޸Ĵ¦·½µÄPYBZ=1£¬½«Æä×ªÒÆµ½×óÉÏ·½ÁÐ±í£¬Õâʱ¿É¶Ô¸Ã´¦·½·¢Ò©£»¡°ÀúÊ·´¦·½¡±Í¨¹ýÊäÈë´¦·½ºÅµ÷ÈëÒ»ÕÅÅäÍêÒ©µÄ´¦·½£¬¡°È¡Ïû·¢Ò©¡±½«ÒÑÅäºÃÒ©µÄ´¦·½´Ó¶ÓÁÐÖÐɾ³ý£¬²¢ÉèFYCK=0,¿ÉÓá°ÀúÊ·´¦·½¡±µ÷Èë¡£ÓÒ±ßÁгöµÄ´¦·½Ò©Æ·Ã÷ϸ´Óms_cf02ÖÐÈ¡³ö,ÿ»»Ò»ÕÅ´¦·½ÖØÐÂË¢ÐÂÒ©Æ·Ã÷ϸ¡£
4. ·¢Ò©Ê±£¬ÏÈÅб𴦷½ÊÇ·ñÒÑ×÷·Ï»òÒѱ»ÆäËü´°¿Ú·¢Ò©£¬´¦·½ÉÏÒ©Æ·µÄ¿â´æÊÇ·ñÂú×ãÒª Çó¡£È·¶¨¿ÉÒÔ·¢Ò©ºó£¬¸ù¾Ý´¦·½Ò©Æ·Ã÷ϸÖðÌõ¼õÉÙyf_kcmxÖÐ¿â´æ£»¸üÐÂms_cf01ÖеÄFYBZ£¬FYRQ£¬FYGH£»Èç¹ûÔÚ·¢Ò©ÒÔǰҩƷ¼Û¸ñÒѱ䶯£¬ÔòÐèÔÚYF_TJJLÖÐÌîдµ÷¼Û¼Ç¼£»
5. µã»÷¡°ÓÃÒ©Éó²é¡±¿É¶Ôµ±Ç°´¦·½½øÐÐÓÃÒ©Éó²é£¬µã¡°ÉèÖ᱿ɸü¸ÄÆÁÄ»ÏÔʾµÄÅäÒ©ÈË¡£
Êý¾Ý´°¿Ú D_yf_fycf_qz,d_yf_fycf_qz_pycf,d_yf_fycf_head,d_yf_fycf_mx
ÒýÓñí Ms_cf01,ms_cf02,yk_typk,yk_ypcd
²Ù×÷±í Ms_cf01,yf_kcmx,yf_tjjl
±à ÖÆ ÀîÇ¿¡¢ÖÓ»ª ±àÖÆÈÕÆÚ 2000/5/9 ÉóºË ÉóºËÈÕÆÚ
ϵͳÃû³Æ ÖÐÎ÷Ò©·¿ÏµÍ³ ϵͳ±àºÅ 03
Ä£¿é±àºÅ 3.1.2
Ä£¿éÃû³Æ ÃÅÕï·¢Ò©->ÍËÒ©´¦Àí
¹¦
ÄÜ
Ãè
Êö ¶Ô¶à·¢»ò´í·¢µÄÒ©Æ·½øÐÐÍËÒ©¡£
IPO
¹ý³Ì
Ãè
Êö 1. ´ò¿ªw_yf_cfty½øÐÐÍËÒ©´¦Àí£¬ÊäÈ뷢ƱºÅÂë»ò´¦·½ºÅÂëºórefresh_listºÍrefresh_detail¡£
2. È·ÈÏʱgf_get_max(sqlca,'MS_CF01',1)£¬È¡ÍËÒ©´¦·½µÄ´¦·½Ê¶±ð£¬Éú³ÉÒ»ÕÅеÄÍËÒ©´¦·½£¬½«ms_cf01ԼǼµÄÍËÒ©±êÖ¾ÖóÉ1£¬°´´¦·½Ò©Æ·Ã÷ϸÖðÌõÔö¼Óyf_kcmxÖÐ¿â´æ£¬Ò©Æ·¼Û¸ñÓб仯µÄÐèÌîдµ÷¼Û¼Ç¼£¬ÔÙÈ¡MS_CF02µÄ´¦·½Ê¶±ð,ÌîÏêϸÍËÒ©¼Ç¼£»
Êý¾Ý´°¿Ú D_yf_tycf,d_yf_fycf_head,d_yf_qxfy_mx
ÒýÓñí Ms_cf01,ms_cf02,yk_typk,yk_ypcd
²Ù×÷±í Ms_cf01,yf_kcmx,yf_tjjl
±à ÖÆ ÖÓ»ª ±àÖÆÈÕÆÚ 2000/6/22 Éó ºË ÉóºËÈÕÆÚ
ϵͳÃû³Æ ÖÐÎ÷Ò©·¿ÏµÍ³ ϵͳ±àºÅ 03
Ä£¿é±àºÅ 3.1.3
Ä£¿éÃû³Æ ÃÅÕï·¢Ò©->È¡Ïû·¢Ò©
¹¦
ÄÜ
Ãè
Êö ¶Ô·¢´íÒ©µÄ´¦·½È¡Ïû·¢Ò©¡£
|
|
ÏÂÔØµØÖ· |
|
|
|
|
|