|
·ÖÀർº½ |
 |
|
|
|
´´ÒµÃÅÕïÊշѹÜÀíϵͳÏêϸÉè¼ÆËµÃ÷Êé |
|
×ÊÔ´´óС£º2.22 MB |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 0 |
|
|
|
×ÊÔ´½éÉÜ |
|
BSHIS2.2ÏêϸÉè¼ÆËµÃ÷Êé
(ÃÅÕïÊշѹÜÀíϵͳ)
Ò»£® ¸ÅÊö
ÃÅÕïϵͳÌṩ¸øÓû§¸÷ÖÖÑ¡ÔñÒÔÂú×ãÓû§µÄ¸÷ÖÖÒªÇ󣬳ä·ÖÌåÏÖÁËÕýÈ·ÐÔ£¬Áé»îÐÔ¼°Ò×ÐÞ ¸ÄµÄÌØÐÔ¡£
¸ÃÃÅÕïϵͳ¿ÉÖ§³Ö¶à¸öÃÅÕïϵͳ(ÈçÃÅÕ¼±ÕïµÈ)£¬ÓÉMS_MZLB±íÃèÊö
MS_MZLB°üÀ¨Á½¸ö×Ö¶ÎMZLB,MZMC£¬ÃÅÕïÀà±ð²»Í¬±íʾÊDz»Í¬µÄÃÅÕïϵͳ£¬ ÃÅÕïÃû³ÆÎªÏàÓ¦µÄÃÅÕïϵͳµÄÃû³Æ(ÈçÃÅÕ¼±ÕïµÈ)£¬ÔÚÒ»°ãµÄÄ£¿éÖв»Í¬ÃÅÕïÀà±ðµÄÃÅÕïµÄ¸÷ÏîÊýÁ¿¿É·Ö¿ª²éѯ£¬Ê¹ÓúÍͳ¼Æ¡£
ÃÅÕïÊÕ·ÑϵͳÖ÷Òª¹¦ÄÜÓУº
½¨Á¢ÃÅÕﲡÈ˵µ°¸
¹ÒºÅÊÕ·Ñ(°üÀ¨Ô¤Ô¼¹ÒºÅ)
Í˺Å
ת¿Æ
¹ÒºÅÔ±¹ÒºÅÈÕ±¨±í¡£
»®¼ÛÊÕ·Ñ
·¢Æ±×÷·Ï
ÍË·Ñ´¦Àí
ͳ¼Æ¸öÈËÃÅÕïÊÕ·ÑÈÕ±¨±í
ÃÅÕïÊÕ·Ñ»ã×ÜÈÕ±¨¡£
²éѯ£º¿É°´¹ÒºÅºÅ±í¡¢¹ÒºÅ·ÖÀàºÍÊտƱ¼ìË÷µÈ¶àÖÖ·½Ê½½øÐйҺÅÓ뷢Ʊ²éѯ¡£
±¨±í£ºÌṩ¶àÖÖ·½Ê½µÄ»ã×Ü±í¡¢Í³¼Æ±íºÍºËËã±í¡£
ϵͳ£ºÌṩÓû§¼°È¨ÏÞÉèÖá¢ÃÅÕïºÅÉèÖúͳõʼ»¯µÈ¹¦ÄÜ¡£
ά»¤£º¶Ô²¡ÈËÐÔÖÊ¡¢¹ÒºÅ¿ÆÊÒ¡¢Ò½Ê¦ÅŰࡢ±¨±í¸ñʽµÈ½øÐÐά»¤¹ÜÀí¡£
¶þ£® Ä£¿éÉè¼ÆËµÃ÷Êé
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ÃÅÕﲡÈ˵µ°¸¹ÜÀí ±àºÅ 5£®11
¹¦
ÄÜ
Ãè
Êö µµ°¸¹ÜÀíÖ÷½çÃæ
³õʼʱδÁгö²¡È˵ĵµ°¸ÐÅÏ¢£¬²Ù×÷Ô±¿Éͨ¹ýÃÅÕïºÅÂë»ò²¡ÈËÐÕÃûµ÷³öÏà¹Ø²¡ÈËÐÅÏ¢£¬ÁгöµÄ²¡ÈËÐÅÏ¢°üÀ¨ÃÅÕïºÅÂ룬ÐÕÃû£¬ÐÔ±ð£¬ÐÔÖÊ£¬Ò½ÁÆÖ¤ºÅ£¬³öÉúÄêÔ £¬»éÒö£¬Ãñ×壬ְҵ µ±²Ù×÷Աͨ¹ýÃÅÕïºÅÂëµ÷³ö²¡ÈËÐÅϢʱ£¬²¡È˵µ°¸ÁÐ±í°´ÃÅÕïºÅÅÅÐò£¬µ±²Ù×÷Աͨ¹ý²¡ÈËÐÕÃûµ÷³ö²¡ÈËÐÅϢʱ£¬²¡È˵µ°¸ÁÐ±í°´²¡ÈËÐÕÃûÅÅÐò£¬²¢ÇÒ²Ù×÷Ô±»¹¿Éµã»÷ij¸ö×Ö¶ÎÃû´¦£¬ÒÑʹ²¡È˵µ°¸ÁÐ±í°´¸Ã×Ö¶ÎÅÅÐò
¸ÃÄ£¿é»¹¿Éн¨£¬Ð޸IJ¡È˵µ°¸£¬µ±ÏµÍ³²ÎÊýÖÐÑ¡ÔñÁË´òÓ¡²¡Àú£¬ÔòÔÚ¸ÃÄ£¿éÖл¹¿É´òÓ¡²¡Àú£¬·ñÔò´òÓ¡²¡Àú°´Å¥±ä»Ò²»¿ÉʹÓÃ
н¨»òÐ޸IJ¡È˵µ°¸
ÓÉϵͳ²ÎÊýÊäÈ벡È˵µ°¸¸ñʽ¾ö¶¨Ð½¨»òÐ޸IJ¡È˵µ°¸µÄ¸ñʽ£¬¹²ÓÐÈýÖÖ¸ñʽ¼òµ¥¸ñʽ£¬»§¿ÚµØÖ·¸ñʽ£¬×Ô¶¨Òå¸ñʽ£¬ÆäÖмòµ¥¸ñʽ°üÀ¨ÃÅÕïºÅ£¬²¡ÈËÐÔÖÊ£¬Ò½ÁÆÖ¤ºÅ£¬²¡ÈËÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣬»§¿ÚµØÖ·¸ñʽ±È×Ô¶¨Òå¸ñʽ¶àÒ»Ïî»§¿ÚµØÖ·£¬×Ô¶¨Òå¸ñʽ°üÀ¨²¡È˵µ°¸µÄËùÓÐÏÔÚ¿Í»§»¯³ÌÐòʱ£¬Óɿͻ§»¯ÈËÔ±¸ù¾ÝÓû§ÐèÇóͨ¹ýÐ޸ijÌÐò×ÔÓÉÉ趨ÊäÈëÏî
Èý¡¢´òÓ¡²¡Àú
¸ù¾Ýϵͳ²ÎÊýÖÐÉèÖõIJ¡Àú´òӡʹÓôòÓ¡»úÃû£¬Íù¸Ã´òÓ¡»úÉÏ´òÓ¡²¡Àú
³Ì
Ðò
Ãè
Êö Ò»¡¢µµ°¸¹ÜÀíÖ÷½çÃæ
ÔÚdw_1ÖÐÏÔʾ²¡È˵µ°¸ÁÐ±í£¬Ê¹ÓõÄdatawindowΪd_dagl_list (µµ°¸¹ÜÀíÁбí)d_dagl_listÖÐÄÚÈÝÈ¡×Ô±íMS_BRDA(²¡È˵µ°¸)£¬²¢ÇÒ²»·ÖÃÅÕïÀà±ð£¬¼´²»¹ÜÄĸöÊÕ·Ñ´¦Â¼ÈëµÄ²¡È˵µ°¸¶¼ÄÜÏÔʾ
¶þ¡¢ н¨»òÐ޸IJ¡È˵µ°¸
¼òµ¥¸ñʽʹÓõÄdatawindowΪd_dagl_simple£¬
»§¿ÚµØÖ·¸ñʽʹÓõÄdatawindowΪd_dagl_hkdz£¬
×Ô¶¨Òå¸ñʽʹÓõÄdatawindowΪd_dagl_custom
1¡¢ ÃÅÕïºÅÂ룬н¨²¡È˵µ°¸Ê±Í¨¹ýÔ±¹¤Æ±¾Ý¹ÜÀàu_ygpjglÀ´µÃµ½ÐµÄÃÅÕïºÅÂ룬Ð޸IJ¡È˵µ°¸Ê±£¬ÃÅÕïºÅÂëÓÉÍⲿ×÷Ϊ²ÎÊý´«Èë
2¡¢ ²¡ÈËÐÔÖÊ£¬²¡ÈËÐÔÖʱíÖÐmzsy(ÃÅÕïʹÓÃ)=1µÄ·ÇÉϼ¶ÐÔÖÊ(ÎÞϼ¶ÐÔÖʵÄÐÔÖÊ)
3¡¢ ²¡ÈËÐÔ±ð£¬1-ÄÐ 2-Å®
4¡¢ ²¡ÈËÄêÁ䣬ÓÐÁ½ÖÖÊäÈë µÚÒ»ÖÖΪÊäÈëÊý×Ö£¬±íʾÄêÁ䣬µÚ¶þÖÖΪÊäÈë³öÉúÄêÔÂ
ϵͳͨ¹ýuo_brxxÀ´ÊµÏÖÄêÁäºÍ³öÉúÄêÔµÄת»¯£¬ÔÚMS_BRDA±íÖб£´æµÄΪ³öÉúÄêÔÂ
5¡¢ÊäÈëÍê±Ïºó±£´æÈëMS_BRDAÖÐ
Èý¡¢´òÓ¡²¡Àú
¸ù¾Ýϵͳ²ÎÊýÖÐÉèÖõIJ¡Àú´òӡʹÓôòÓ¡»úÃû£¬Íù¸Ã´òÓ¡»úÉÏ´òÓ¡²¡Àú
¸Ã°´Å¥½«Êý¾Ý×¼±¸µ½Êý×éls_mzxxÖУ¬²¢´«µÝ¸øgf_bldy£¬ÓÉgf_bldy()ʵÏÖ²¡Àú´òÓ¡£¬gf_bldyÓɿͻ§»¯ÈËԱά»¤
Êý¾Ý´°¿Ú D_dagl_list,dd_brxz_mz,d_hyzk_dm,d_mzdm_dm,d_zydm_dm
ÒýÓñí MS_BRDA¡¢GY_BRXZ¡¢GY_DMZD¡¢MS_CYDW¡¢MS_CYDZ
²Ù×÷±í MS_BRDA
±àÖÆ ÷֥Óê¡¢ÖÓ»ª ÈÕÆÚ 2000.05.16
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ¹ÒºÅ´¦Àí ±àºÅ 5£®12
¹¦
ÄÜ
Ãè
Êö 1¡¢ ³õʼ»¯Ô±¹¤Æ±¾Ý¹ÜÀí, ×Ô¶¯²úÉúÃÅÕïºÅ, È¡¾ÍÕïºÅÂë, ÅжÏÊÇ·ñ¿É½øÐÐÔ¤Ô¼
2¡¢ Ô¤Ô¼¹ÒºÅ¡¢µ÷ÈëÔ¤Ô¼
3¡¢ ¹ÒºÅ£ºÍ¨¹ýÊäÈëÃÅÕïºÅÂë»ò¾ÍÕïºÅÂëµ÷³ö²¡ÈËÐÅÏ¢£¨¿ÉÔڴ˵÷Óò¡È˵µ°¸ÊäÈ룩£¬ÊäÈë¹ÒºÅ¿ÆÊҵĴúÂ룬ѡÔñijһ¿ÆÊÒ£¬Ñ¡ÔñÊÇ·ñÊÕ²¡Àú·Ñ£¬È»ºó£¬¸ù¾Ý¹ÒºÅ·Ñ¡¢ÕïÁÆ·Ñ¡¢²¡ÈË×Ô¸¶±ÈÀý£¬½øÐÐÊÕ·Ñ¡£
4¡¢ Ñ¡Ôñ´úÂëÊäÈ뷽ʽ£ºÆ´Òô¡¢Îå±Ê¡¢½ÇÐÍ¡¢ÆäËü
¿É¸ù¾Ý¾ÍÕïºÅÂë½øÐÐÍ˺š¢×ª¿Æ
³Ì
Ðò
Ãè
Êö Ò»¡¢¹ÒºÅ³õʼ׼±¸
1¡¢ u_ygpjgl.set_czgh(base_info.userid) ³õʼ»¯Ô±¹¤Æ±¾Ý¹ÜÀí
2¡¢ gf_zdcsmzh() ×Ô¶¯²úÉúÃÅÕïºÅ
3¡¢ ÅжÏÊÇ·ñ¿É½øÐйҺÅÔ¤Ô¼
4¡¢ È¡¾ÍÕïºÅÂ룺wf_getjzhm()
5¡¢ ¸ù¾Ýʱ¼äÅжÏÔçÖаàii_zblb
6¡¢ ¸ù¾ÝÈÕÆÚÇåÒѹÒÈËÊý(YGRS)£º¸üÐÂMS_GHKS±í£»½«¹ýÆÚµÄÔ¤Ô¼¹ÒºÅÖñêÖ¾2£ºMS_YYGH±í£¬GHBZ = 2
7¡¢ È¡¹ÒºÅ¿ÆÊÒÐÅÏ¢dw_ghks.retrieve(gi_mz_code,ldt_begin,ldt_end)
8¡¢ ȡר¼ÒÒ½ÉúÐÅÏ¢dw_ghys.retrieve(ii_zblb,ldt_begin,ldt_end)
9¡¢ ȡÿ¸ö¿ÆÊÒµÄÔ¤Ô¼¹ÒºÅÈËÊý£¨´ÓMS_YYGH±íÖУ©
10¡¢ ×¼±¸²¡ÈËÐÅÏ¢ºÍ¹ÒºÅÐÅÏ¢£¬µÈ´ýÊäÈëdw_brxx ¡¢dw_ghxx
11¡¢ È¡´òÓ¡²¡Àú±êÖ¾,²¡Àú·Ñ¼ÇÕʱêÖ¾¡¢È¡²¡Àúµ¥¼Û¡¢È¡¹ÒºÅ·ÑÏîÄ¿,ÕïÁÆ·ÑÏîÄ¿,ר¼Ò·ÑÏîÄ¿¡¢È¡ÊշѾ«¶ÈºÍÊշѽð¶î¸ñʽ
¶þ¡¢¹ÒºÅ²Ù×÷
1¡¢Ô¤Ô¼£º´ÓMS_YYGH±íÖÐÈ¡³öÔ¤Ô¼ÐÅÏ¢£¬È¡¹ÒºÅ·Ñ¼°ÕïÁÆ·Ñ£¨È¡×Ô¸º±ÈÀýwf_get_percent()£©£¬ÔÙµ÷ÓýɿÀíwf_jkcl()
2¡¢ µ÷ÈëÔ¤Ô¼£ºopen(w_xzyygh)Ñ¡ÔñÔ¤Ô¼¹ÒºÅ´°¿Ú£¬ÔÙ´ÓMS_YYGH±íÖÐÈ¡¸Ã´Îµ÷ÈëÔ¤Ô¼¹ÒºÅµÄÐÅÏ¢£¬Í¨¹ýMS_GHKS¡¢MS_YSPB±íÅжÏËùÑ¡ÔñµÄÔ¤Ô¼¹ÒºÅ¿ÆÊÒ¼°Ò½ÉúÊÇ·ñ½ñÌì¿ÉÒԹҺţ¬È¡¹ÒºÅ·Ñ¼°ÕïÁÆ·Ñ£¨È¡×Ô¸º±ÈÀýwf_get_percent()£©£¬È¡¹ÒºÅ²¡Àú·Ñ£¬¼ÆËãר¼Ò·ÑÓá¢×Ô¸º×¨¼Ò·Ñ£¬ÔÙµ÷ÓýɿÀíwf_jkcl()
3¡¢ н¨µµ°¸£ºd_dagl_custom
ÅжÏвúÉúµÄÃÅÕïºÅÊÇ·ñÒѱ»Ê¹Óã¬ÊÇ·ñÐèÒªÊäÈëÖ¤ºÅ£¬ÅжÏÐÅÏ¢ÊäÈëÍêÕûÐÔ£¬È»ºóв¡È˲úÉúеÄIDºÅ²¢¸üÐÂÐÅÏ¢¡£
4¡¢ ¹ÒºÅ£º
ÓïÒô·¢Éù¿ØÖÆgf_talk(1,0)
ÊäÈëÃÅÕïºÅ£º»Ø³µÅжϣ¬ÈôδÊäÈëÃÅÕïºÅ´ò¿ªÐ½¨µµ°¸´°¿Úopen(w_ghcl_new)²¢·µ»ØÃÅÕïºÅÂ룻ÈôÊäÈëÁËÃÅÕïºÅ£¬ÅжϸÃÃÅÕïºÅÊÇ·ñ´æÔÚ£¬Åжϲ¡ÈËÊÇ·ñΪÀϲ¡ÈË£¨ÊÇ·ñÊÕ²¡Àú·Ñ£©£¬Åжϸò¡ÈËÊÇ·ñÓÐÕÊ»§£¬ÓÐÔògf_readaccount()¶ÁÈ벡ÈËÕÊ»§
Ñ¡Ôñ¹ÒºÅ¿ÆÊÒ£ºÔÚdw_ghxxÖÐÕÒµ½ÏàÓ¦ÐÐ, ÅжÏÊÇ·ñ³¬¹ý¿ÆÊÒ¹ÒºÅÏÞ¶î(dw_ghksµÄygrs)£¬È¡¹ÒºÅ·Ñ¼°ÕïÁÆ·Ñ£¨dw_ghksµÄghf£©£¬wf_get_percent
È¡×Ô¸º±ÈÀý£¬È¡£¨dw_ghksµÄzlf£©ÕïÁÆ·Ñ£¬µÃµ½×Ô¸º¹ÒºÅ·ÑºÍ×Ô¸ºÕïÁÆ·Ñ£¬È¡²¡Àú·Ñ£¬µÃ×Ô¸º²¡Àú·Ñ¡£ÈôÔ¤Ô¼¹ÒºÅ״̬£¬Ôòwf_yyqr()ԤԼȷÈÏ£¬ÈôΪ¹ÒºÅ״̬£¬Ôòwf_jkcl()½É¿î´¦Àí¡£
5¡¢ Í˺Ŵ¦Àí£ºÏÈÅжÏMZLB±í¿´ÊÇ·ñΪ±¾ÃÅÕﲿµÄ¹ÒºÅ£¬ÈôÊÇ£¬Ôò¸üÐÂMS_GHMX SET THBZ=1£¬INSERT INTO MS_THMX(SBXH,CZGH,MZLB)£¬UPDATE MS_YSPB SET YGRS=YGRS-1£¬¸üРMS_BRZHµÄLJFYºÍZHYE
6¡¢ ת¿Æ´¦Àí£ºÏÈÅжÏMZLB±í¿´ÊÇ·ñΪ±¾ÃÅÕﲿµÄ¹ÒºÅ£¬·ÑÓÃÓëת¿ÆÇ°ÊÇ·ñÒ»Ö£¬ÈôÊÇ£¬ÔòUPDATE MS_GHKS£¬UPDATE MS_GHMX
Êý¾Ý´°¿Ú d_gh_ghks¡¢d_gh_ghys¡¢d_ghcl_brxx¡¢d_gh_ghrb_brxz
d_gh_thmx¡¢d_gh_thclµÈ
ÒýÓñí MS_YYGH, MS_GHKS¡¢MS_YSPB¡¢MS_BRDA ¡¢MS_ZHLB¡¢MS_BRZH¡¢MS_YGPJ
²Ù×÷±í MS_BRDA¡¢MS_SZMX¡¢MS_GHMX¡¢MS_YYGH¡¢MS_THMX
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000.05.16
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ¹ÒºÅÈÕ±¨ ±àºÅ 5£®13
¹¦
ÄÜ
Ãè
Êö ²Ù×÷ԱÿÌì²Ù×÷½áÊø½øÐйҺÅͳ¼Æ£¬²úÉú¹ÒºÅÈÕ±¨£¬½øÐнáÕÊ´¦Àí£¨¿É½áÕʶà´Î£©¡£½áÕʺ󣬿ɽøÐÐÈÕ±¨²éѯ£¨°üÀ¨Ã÷ϸ²éѯ£º¹ÒºÅÃ÷ϸ¡¢Í˺ÅÃ÷ϸ£©¡£
³Ì
Ðò
Ãè
Êö ij²Ù×÷Ô±¹ÒºÅÈÕ±¨£ºÍ³¼Æ¡ª¡ª"d_gh_ghrb_brxz"£¨MS_BRDA,MS_GHMX±íÖеÄGHCS¡¢GHJE¡¢ZFJE¡¢BLJE¡¢ZJJE¡¢BRXZ×ֶΣ©¼ìË÷³ö¸÷ÐÔÖÊÈËÊýºÍ½ð¶î£¬ÔÚÈÕ±¨ÖмõÈ¥×÷·ÏÊý¾Ý£¨ MS_GHMX.SBXH ÔÚ MS_THMXÖÐMS_THMX.JZRQ is null£©Ð´¾ÍÕïºÅÂ룬wf_cacl_cfhm()£¬ÔÚ±¨±íÖÐдÍ˺źÅÂ룬д´óдµÄÊÕ¿î×ܼÆgf_dxzh(ÊÕ·Ñ×ܼÆ)£¬Ð´ÏÖ½ðºÏ¼Æ£¨MS_GHMX£©µÈ¡£½áÕÊ¡ª¡ªUPDATE MS_GHMX SET JZRQ£¬UPDATE MS_THMX SET JZRQ¡£²éѯ¡ª¡ªSELECT distinct MS_GHMX.JZRQ£¬´ò¿ªw_gh_rbxz£¬Ñ¡Ôñijһ´ÎÈÕ±¨¡£ÓÉd_gh_ghrb_brxz_history¼ìË÷³öÊý¾Ý£¬ÔÚÈÕ±¨ÖмõÈ¥×÷·ÏÊý¾Ý£¬Ð´¾ÍÕïºÅÂë¡¢Í˺źÅÂ룬ÆäËûÓ¦ÊÕ¿îµÈ¡£¹ÒºÅÃ÷ϸ¡ª¡ªopen(w_gh_ghmx)£¬¡°d_gh_ghmx¡±¡£Í˺ÅÃ÷ϸ¡ª¡ªopen(w_gh_ghmx)£¬¡°d_gh_thmx¡±¡£
Êý¾Ý´°¿Ú d_gh_ghrb_brxz¡¢d_gh_ghrb_brxz_history¡¢d_gh_ghmx¡¢d_gh_thmxµÈ¡£
ÒýÓñí MS_GHMX,MS_THMX¡¢MS_GHKS¡¢MS_BRDAµÈ
²Ù×÷±í MS_GHMX¡¢MS_THMX
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000.05.16
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ÊշѽáËã ±àºÅ 5£®21
¹¦
ÄÜ
Ãè
Êö Ò»¡¢ ÊÕ·Ñ×¼±¸ : È¡³õʼ²ÎÊý£¬³õʼ»¯½çÃæ£¬³õʼ»¯µ÷Èë´¦·½µ¥ºÍÒ½¼¼µ¥µÄÑ¡Ôñ´¦·½´°¿Ú £¬³õʼ»¯ÊÕ·Ñ»·¾³£¬ÓÃÓÚ¿ªÊ¼Ò»ÕÅеÄÊÕ·Ñ·¢Æ±
¶þ¡¢ ÊշѲÙ×÷
1¡¢ È¡·¢Æ±ºÅÂ룬ÊäÈë¹ÒºÅ²úÉúµÄÃÅÕïºÅ£¨»òIC¿¨ºÅ£©£¬µ÷³ö²¡ÈËÐÅÏ¢¼°ÕÊ»§ÐÅÏ¢½øÐÐÊÕ·Ñ¡£Èç¹û²»ÊäÃÅÕïºÅ£¬Ôò¼ÈëÐÔÖʺÍÐÕÃû½øÐл®¼ÛÊÕ·Ñ.
2¡¢ Èç¹û¸ÃIDºÅ²¡ÈËÔÚ´¦·½¿â¼°Ò½¼¼¿âÖÐÓÐ×Ô¼ºµÄδÊշѵĵ¥¾Ý£¨Ò½ÉúÕ¾»òÒ©·¿¿ªµÄµ¥¾Ý£©£¬Ôòµ÷ÈëδÊշѵ¥¾Ý£¬¼ÆËã³öÊÕ·ÑÃ÷ϸ½ð¶î¼°×ܽð¶î.
3¡¢ Èç¹ûÎÞÒ½ÉúÕ¾¿ªµÄµ¥¾ÝÔò¸ù¾Ýµ¥¾ÝÓÅÏȱêÖ¾Ôò²úÉúµÚÒ»Õŵ¥¾Ý
4¡¢ ¸ù¾ÝÓû§µÄ°´¼üÇé¿öÖ´ÐÐÏàÓ¦µÄ¹¦ÄÜ¡£F2:Ôö¼Ó¼ì²éµ¥ F3:Ôö¼ÓÎ÷Ò©·½ F4:Ôö¼ÓÖÐÒ©·½ F5£ºÔö¼Ó²ÝÒ©·½F6/F7:²é¿´ÉÏϵ¥¾Ý.¼ÈëÏîÄ¿´úÂë¿É¸ù¾Ý²ÎÊýÉèÖö¨Îª¹Ì¶¨Ä£Ê½¼°¹â±ê¸úËæÁ½ÖÖģʽ F8£º¸ù¾Ý´¦·½ºÅÂë»òÌØ¼ìºÅÂëµ÷Èë´¦·½µ¥»òÒ½¼¼µ¥ F12£ºÈ¡Ïûµ±Ç°Â¼ÈëµÄÐÅÏ¢£¬´Óл»²¡ÈËÊÕ·Ñ
5¡¢ F8ʵÏÖ·¢Æ±¸´Öƹ¦ÄÜ(Ö÷ÒªÕë¶Ô·¢Æ±×÷·ÏºóÖØ´ò,ÍêÈ«¸´ÖÆ).
6¡¢ F9¶Ôµ±Ç°µÄµ¥¾Ý½øÐнáË㣬ÏÔʾӦÊպϼƣ¬Â¼Èë½»¿î½ð¶î,ÌáʾÕһؽð¶î£¬ÊÕÈ¡ÏÖ½ð»ò֧Ʊ£¬Èç¹û½É¿î·½Ê½ÎªÕÊ»§£¬Ôòµ÷ÓÃÍâ¹ÒµÄдÕÊ»§µÄº¯Êý£¬±£´æËùÓе¥¾Ý£¬´òÓ¡·¢Æ±ºó£¬½øÐÐв¡È˵ÄÊÕ·Ñ¡£Èç¹û²»Â¼Èë½É¿î½ð¶î£¬Ôò±íʾ±£´æµ±Ç°µ¥¾Ý£¬´òÓ¡·¢Æ±£¬ÀÛ¼Æ×ܼƷÑÓ㬼ÌÐø¸Ã²¡ÈËÆäËûµ¥¾ÝµÄ»®¼ÛÊÕ·Ñ.¶Ô·¢Æ±ºÅÂë½øÐеݼӡ£
Èý¡¢ ²éѯ
¿É¸ù¾Ý·¢Æ±ºÅÂë¡¢²¡ÈËÐÔÖÊ¡¢ÊÕ·ÑÈÕÆÚ¡¢µ¥Î»Ãû³Æ¡¢²¡ÈËÖ¤ºÅ¡¢ÃÅÕïºÅÂë¡¢²¡ÈËÐÕÃû¡¢ÊÕ¿îÔ±Ìõ¼þ¼ìË÷³ö·¢Æ±ÐÅÏ¢¡£
³Ì
Ðò
Ãè
Êö Ò»¡¢ÊÕ·Ñ×¼±¸
ÓÃWf_initpara ³õʼ²ÎÊý
1¡¢ È¡ÊäÈëÂ뷽ʽµÄÃû³Ægl_inputmode
2¡¢ È¡Î÷Ò©·Ñ¡¢ÖÐÒ©·Ñ¡¢²ÝÒ©·ÑÐòºÅ
3¡¢ È¡²ÎÊý¡°ÊÇ·ñÔÊÐí²»¹ÒºÅ¿ª´¦·½0.²»ÔÊÐí 1.ÔÊÐí¡±¡¢¡°ÓÅÏȱêÖ¾1.¼ì²éµ¥ÓÅÏÈ2.´¦·½ÓÅÏÈ¡±¡¢¡°´úÂë¼È뷽ʽ1.¹Ì¶¨Ä£Ê½2.¹â±ê¸úËæ¡±¡¢¡°´¦·½ºÅÂëĬÈÏģʽ1.¿Õ 2.È¡ÃÅÕïºÅ 3.È¡·¢Æ±ºÅ¡±¡¢¡°×î´óÊÕ·ÑÏîÄ¿Êý¡±
4¡¢ È¡ÊշѾ«¶ÈºÍÊշѽð¶î¸ñʽ
5¡¢ È¡¸÷±êÖ¾£ºÐ޸ĵ±Ç°·¢Æ±±êÖ¾¡¢Ò©Æ·ÌײÍʹÓñêÖ¾¡¢·ÑÓÃÌײÍʹÓñêÖ¾
6¡¢ ȡҩƷ¹ýÂË·½Ê½ 0.²»¹ýÂË 1.¹ýÂË¿â´æ´óÓÚ0µÄÒ©Æ·
7¡¢ ³õʼ»¯Ò©Æ·ÊäÈ룺u_sele_yp.init(Ò©Æ·ÌײÍʹÓñêÖ¾, Î÷Ò©·Ñ¡¢ÖÐÒ©·Ñ¡¢²ÝÒ©·ÑÐòºÅ£¬Ò©Æ·¹ýÂË·½Ê½,"ue_cf_clicked")ÈôijÐòºÅΪ0Ôò²»ÄÜʹÓÃijÀàÒ©Æ·¡£
8¡¢ ³õʼ»¯·ÑÓÃÊäÈ룺u_sele_fy.init(1, ·ÑÓÃÌײͱêÖ¾,"ue_yj_clicked")
9¡¢ ȡҩ·¿¿â´æ·½Ê½ 1.È¡×î´ó¿â´æ2.È¡Âú×ãËùÐè¿â´æµÄ×î´ó¿â´æ3.È¡×îС¿â´æ4.È¡Âú×ãËùÐè¿â´æµÄ×îС¿â´æ
10¡¢ ³õʼ»¯Ô±¹¤Æ±¾Ý¹ÜÀíu_ygpjgl.set_czgh(base_info.userid)¡¢ u_get_zfbl.initialize(sqlca,false)
11¡¢ ´´½¨µ¥Ò»Ò©Æ·¹ÜÀí¶ÔÏóu_ypxxºÍµ¥Ò»·ÑÓùÜÀí¶ÔÏóu_fyxx
12¡¢ ³õʼ»¯µ÷Èë´¦·½µ¥ºÍÒ½¼¼µ¥µÄÑ¡Ôñ´¦·½´°¿Úu_select_cfsb.initialize¡¢uo_select_yjxh.initialize
³õʼ»¯ÊÕ·Ñ»·¾³£¬ÓÃÓÚ¿ªÊ¼Ò»ÕÅеÄÊÕ·Ñ·¢Æ±
wf_getmzxx(ÀàÐÍ1.»»Ð²¡ÈË0.¼ÌÐø²Ù×÷Ô²¡ÈË)
13¡¢ Çå¿ÕÊý¾Ý´°¿Ú
14¡¢ ÉèÖ÷¢Æ±ºÅÂëu_ygpjgl.get_fphm()
15¡¢ Èç¹ûв¡ÈËÔò×Ü·ÑÓÃÇå¿Õopen(w_hjsf_mzxx)£¬wf_close()
16¡¢ дÃÅÕïÐÅÏ¢dw_mzxx
17¡¢ Åжϲ¡ÈËÊÇ·ñÓÐÕÊ»§gf_checkaccount(id)£¬Èô¸Ã²¡ÈËÓÐÕÊ»§¶ÁÕÊ»§Óà¶î¼°ÀۼƷÑÓÃgf_readaccount(id)
18¡¢ µ±ÃÅÕïºÅÂëÓÐЧÇҸò¡ÈËÊշѵĵÚÒ»ÕÅ·¢Æ±Ôòµ÷ÈëÒ½Éú¿ªµÄ´¦·½ºÍÒ½¼¼µ¥wf_load(id)
´¦·½ÓÅÏÈÇҷǹҺŲ¡È˿ɿª´¦·½ÔòÏÈÐÂÔöÒ»´¦·½£¬wf_add_cf(1)£¬·ñÔòÐÂÔöÒ»µ¥¾Ýwf_add_yj()
a) ÊշѲÙ×÷
1¡¢W_hjsf_mzxxµÄ˵Ã÷
Èô¹ÒºÅʹÓã¬ÔòÍ£ÔÚÊäÈëÃÅÕïºÅÂë´¦(Èô"ÊÕ·ÑʹÓúÅÂëÀàÐÍ¡±Îª¾ÍÕïºÅÂ룬ÔòÍ£ÔÚÊäÈë¾ÍÕïºÅÂë´¦)£¬·ñÔò²»ÊäÈëÃÅÕïºÅÂ루»ò¾ÍÕïºÅÂ룩£¬Í£ÔÚÊäÈ벡ÈËÐÔÖÊ´¦£¬²¢µ÷³öĬÈϵIJ¡ÈËÐÔÖÊ
ÊäÈëÃÅÕïºÅÂ룬µ±ÊäÈëµÄÃÅÕïºÅÂëΪ¿Õʱ£¬Í£µ½ÊäÈ벡ÈËÐÔÖÊ´¦£¬·ñÔòµ÷Óú¯Êýwf_brxx_mzhm ÉèÖò¡ÈËÐÅÏ¢
ÊäÈ벡ÈËÐÔÖʺ󣬸ù¾ÝÖ¤ºÅÅб𣬽«¹â±êÍ£µ½ÊäÈ벡ÈËÖ¤ºÅ´¦»òÊäÈ벡ÈËÐÕÃû´¦ÊäÈ벡ÈËÖ¤ºÅ£¬ÈôδÊäÈ벡ÈËÖ¤ºÅ£¬ÔòÐèÊäÈ벡È˵¥Î»
2¡¢·¢Æ±²éѯw_fpjsµÄ˵Ã÷
´Ód_fpcxtjµÄÊäÈëÖеõ½²éѯÌõ¼þ,Æ´½ÓSQLÓï¾ä£¬ÉèÖÃd_fpcxµÄSQLÓï·¨£¬ÔÙ´ÓMS_MZXXÖмìË÷³öÊý¾Ý¡£
3¡¢w_hjsf_mainµÄ˵Ã÷
¢Ùselectsfsb:µ÷Èë´¦·½µ¥£¨dw_cf02£©
¢Úselectyjxh:µ÷ÈëÒ½¼¼µ¥(dw_yj02)
¢Ûue_cf_clicked: wf_fixdata_yp_1()ÅжÏÊÇ·ñΪÌײÍu_sele_yp.gettcbz()£¬ÅжÏÊÇ·ñΪ×îºóÒ»ÐУ¬ÊÇÔòu_sele_yp.getypxh()²¢wf_set_cf02(),·ñÔò¢Ùu_sele_yp.clear_tcbz()ÇåÌײͱêÖ¾£¨²»¿ÉÊäÈ룩
¢Üue_yj_clicked: wf_fixdata_fy_1()ÀàËÆÓÚwf_fixdata_yp_1()
¢Ýdw_cf02µÄkeydownʼþÖУ¬°´Êý×Ö¼üÑ¡ÔñÒ©Æ·wf_fixdata_yp()£¬KeyEnterʱ£¬µ±Ò©Æ·Ñ¡Ôñ´°¿Ú¿É¼ûʱwf_fixdata_yp(u_sele_yp.il_pagerow)£¬µ±²»¿É¼ûʱµ÷ÓÃuo_ypxx.setypxx(ll_ypxh)ºÍuo_ypxx.setyfkc()£¬ u_sele_yp.settype(li_type)¡¢u_sele_yp.Reflush(ls_code)¡¢u_sele_yp.getypxh()£¬ÅжÏÊäÈëµÄÊÇ·ñΪÌײÍ
¢ÞÊäÈëÒ½Éú£¬ÈôÐè¿ÆÊÒºËËã(ifkshs=1)£¬Ôò±ØÐëÊäÈëÒ½Éú
5¡¢ ¹ØÓÚ¿ì½Ý¼üµÄ˵Ã÷£º
F2:Ôö¼Ó¼ì²éµ¥wf_add_yj()
F3:Ôö¼ÓÎ÷Ò©·½wf_add_cf(1)
F4:Ôö¼ÓÖÐÒ©·½wf_add_cf(2)
F5:Ôö¼Ó²ÝÒ©·½wf_add_cf(3)
F8:¸ù¾Ý´¦·½ºÅÂë»òÌØ¼ìºÅÂëµ÷Èë´¦·½µ¥»òÒ½¼¼µ¥ wf_fetch()
F9:½áË㿪Ʊ open(w_sh_hjsf_jscl)
F12: È¡Ïû wf_getmzxx(1) ³õʼ»¯»·¾³±äÁ¿£¬ÖØÐ¿ªÊ¼ÊäÈ벡ÈË
6¡¢ ÊäÈë·ÑÓõIJ¿·Öʼþ˵Ã÷
editchanged:ÈôΪ¹Ì¶¨Ä£Ê½ÇÒ·ÑÓÃÃû³Æ´°¿ÚÒÑ´ò¿ª»òΪ¸úËæÄ£Ê½£¬ Ôò»áµ÷Óô°¿Úw_sele_fyÏÔʾ·ÑÓã¬keydown: fymcÁУºÊäÈëÊý×ÖÔòÑ¡ÔñijÐУ¬ÊäÈë»Ø³µ£¬Ôò·µ»ØÑ¡ÖÐÐУ» ylslÁУºÊäÈë0£¬Ôòɾ³ý¸ÃÐУ¬²¢Ð¼ÓÒ»ÐÐ , µ÷ÓÃw_calc_sfmxÌîÊÕ·ÑÃ÷ϸdw_sfmx,ÔÚÊäÈë·ÑÓÃÃû³ÆÊ±Ä¬ÈÏ,ÊýÁ¿Îª1
³Ì
Ðò
Ãè
Êö 7¡¢ ¸´ÖÆËµÃ÷£ºw_hjsf_copy
¸ù¾ÝÊäÈëµÄ·¢Æ±ºÅÂëµÃµ½¸÷ÐÅÏ¢Ìîµ½w_hjsf_copy£¬dw_mzxx, dw_cf01, dw_cf02,dw_yj01,dw_yj02ÖУ¬²¢Ð´Èëw_hjsf_mainÖÐ
8¡¢½áËã˵Ã÷£º
ÅжÏÊÕ·ÑÏîÄ¿ÊÇ·ñ´óÓڹ涨ÏîÊýdw_sfmx.rowcount() > ii_max_sfxms
wf_save±£´æµ¥¾Ý
¸ù¾Ý¾«¶Èµ÷Õûdw_sfmxÖеÄzfjeºÍzjje
È¡ÏÖ½ð½ð¶î¡¢ÕÊ»§×Ô¸º½ð¶î¡¢Ö§Æ±½ð¶î¡¢ÕÊ»§½ð¶î¡¢ÆäËüÓ¦ÊÕµÈ
ɾ³ýdw_yj02ÖпÕÐУ¬É¾³ýdw_yj01ÖÐÎÞÃ÷ϸµÄÐУ¬É¾³ýdw_cf02ÖпÕÐУ¬É¾³ýdw_cf01ÖÐÎÞÃ÷ϸµÄÐÐ
update dw_sfmx,dw_yj01,dw_yj02,dw_cf01,dw_cf02
ÀÛ¼Ó·¢Æ±ºÅÂë
wf_create_fp ´òÓ¡
Êý¾Ý´°¿Ú D_mzxx,d_cf01,d_cf02,d_yj01,d_yj02,d_sfmx£¬d_uo_ypxx_yf_kcmx
ÒýÓñí Yk_ypbm,yk_typk,yf_kcmx,yk_ypcd,gy_ylsf,gy_sfxm,gy_ygdm,gy_zfbl,gy_fyjy,gy_fybm,gy_ypjyµÈ
²Ù×÷±í Ms_mzxx,ms_sfmx,ms_cf01,ms_cf02,ms_yj01,ms_yj02,ms_ygpj
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®16
¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ·¢Æ±×÷·Ï ±àºÅ 5£®22
¹¦
ÄÜ
Ãè
Êö 1.Êý¾Ý´°¿ÚÖÐÁгöδ½áÕʵı¾²Ù×÷Ô±µÄ×÷·Ï·¢Æ±
2£®Ë«»÷£ºµ÷ÓÃÈ¡Ïû×÷·Ï°´Å¥
3£®×÷·Ï°´Å¥£ºµ¯³öÊäÈë¿ò£¬ÊäÈ뷢Ʊ£¬ÏÔʾ·¢Æ±ÄÚÈÝ¿ò£¬´Ëʱ¿ÉÏÔʾ·¢Æ±ÄÚÈÝ»ò×÷·Ï¸Ã·¢Æ±
4.×÷·Ï·¢Æ±Ê±±ØÐ룺δ×÷·Ï¸Ã·¢Æ±ÖÐÏîĿδִÐи÷¢Æ±Öд¦·½Î´·¢Ò©
¸Ã·¢Æ±Î´ÍË·Ñ£¬ÈôÒÑÍË·Ñ£¬ÔòÖ»ÄÜ×öÈ«ÍË´¦Àí
5£®È¡Ïû×÷·Ï£ºÏÔʾ·¢Æ±ÄÚÈÝ¿ò£¬¿É½øÐÐÈ¡Ïû´¦Àí¡£
³Ì
Ðò
Ãè
Êö 1.dw_1ÖÐÁгöms_zffpÖÐjzrqΪ¿ÕµÄ±¾²Ù×÷Ô±µÄ·¢Æ±
2£®È¡Ïû×÷·Ï
È¡Ïû×÷·ÏÃèÊö£º
Åжϲ¡ÈËÊÇ·ñÓÐÕÊ»§gf_checkaccount(id)£¬¸Ã²¡ÈËÓÐÕÊ»§£¬Ôògf_readaccount(id)£¬²¢Ð´²¡ÈËÕÊ»§gf_writeaccount(id,brzh)
ms_mzxx,ms_yj01,ms_cf01ÖУ¬set ZFPB=0
ɾ³ý MS_ZFFPµÄÏà¹Ø¼Ç¼
3. ×÷·Ï°´Å¥£º
×÷·Ï²Ù×÷ÃèÊö£º
ÈômzxxÖÐqtje<>0,ÔòÐè½øÐÐÕÊ»§²Ù×÷
ms_mzxx,ms_yj01,ms_cf01ÖУ¬set zfpb = 1
ÔÚms_zffpÖмÓÈë¸Ã·¢Æ±
4£®µ¥¾Ý°´Å¥£º´ò¿ªw_djcx´°¿ÚÓÉ·¢Æ±ºÅÂë¼ìË÷³ö·¢Æ±ÐÅÏ¢
Êý¾Ý´°¿Ú d_zffp,d_fpnr£¬d_list£¬d_cf02_copy£¬d_yj01_copy
ÒýÓñí ms_cf02,ms_yj02µÈ
²Ù×÷±í ms_mzxx,ms_cf01,ms_yj01,ms_zffp
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®16
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ÍË·Ñ´¦Àí ±àºÅ 5.23
¹¦
ÄÜ
Ãè
Êö 1.ÊäÈëÐèÍË·Ñ·¢Æ±ºÅÂëºóÔÚ·ÑÓô°¿ÚÖÐÏÔʾËùÓпÉÍË·ÑÓã¬ÔÚÒ©Æ·´°¿ÚÖÐÏÔʾËùÓпÉÍËÒ©Æ·¼°Ò©·¿µÄÍËÒ©Çé¿ö
2£®ÊäÈëÍË·ÑÊýÁ¿
3£®Ö´ÐÐÍ˷Ѽ´½áËã
³Ì
Ðò
Ãè
Êö a) ÊäÈëµÄ·¢Æ±ºÅÂë´ÓMS_MZXXÖÐÈ¡³ö¸Ã·¢Æ±¼Ç¼£¬ÒªÇó
¸Ã·¢Æ±ºÅδ×÷·Ï ÎÞÍË·Ñ·¢Æ±ºÍ¸Ã·¢Æ±Ïà¹ØÁª
ÉÐδÈÕ½á,²ÅÄܽøÐÐÖØ´ò×÷·Ñ·¢Æ±²Ù×÷ δ·¢Ò©£¬Î´Ö´ÐÐ
b) ¸ù¾ÝÍË·Ñ·¢Æ±ºÅÂë²éÔʼ·¢Æ±ºÅÂëwf_get_first_fphm(tffphm)£¬²¢¸ù¾ÝÔʼ·¢Æ±ºÅÂëµÃµ½·¢Æ±ÄÚÈÝwf_get_fpnr_via_fphm(fphm)
c) dw_listÖÐÁгö´¦·½µ¥£¬dw_cf01¡¢dw_cf01_save¡¢dw_cf02¡¢dw_cf02_saveÖÐÁгö´¦·½Çé¿ö,dw_yj02,dw_yj02_save,dw_yj01,dw_yj01_saveÖÐÁгö·ÑÓÃÇé¿ö£¬dw_sfmx, dw_sfmx_totalÖÐÁгöÊÕ·ÑÇé¿ö
d) µã»÷dw_list,µ÷ÓÃwf_display(djlx, sbxh)Çл»µ¥¾Ý
e) dw_mzxxÖÐÁгö¸Ã·¢Æ±Ì§Í·Çé¿ö
¸ù¾ÝÍËÒ©Çé¿öÌîÖÐdw_cf02ÖÐÍËÒ©ÊýÁ¿(Èôij´¦·½µÄcfgl¹ØÁªµ½ÊôÓÚ·¢Æ±is_fphm µÄ´¦·½(cfsb),Ôò¸Ã´¦·½ÎªÓйصÄÍËÒ©´¦·½)
¸ù¾ÝÍËÒ©Çé¿öÌîdw_yj02ÖÐÍË·ÑÊýÁ¿(Èôijҽ¼¼µ¥µÄyjgl¹ØÁªµ½ÊôÓÚ·¢Æ±is_fphm µÄÒ½¼¼µ¥(yjxh),Ôò¸ÃÒ½¼¼µ¥ÎªÓйصÄÍ˷ѵ¥)
f) ¶Ô´æ´¢×¼±¸wf_save_prepare()µÄ˵Ã÷
±£´æÊý¾ÝʹÓõĸ÷ÏîÊý¾Ý´°¿ÚµÄ³õʼ»¯wf_save_reset()
È¡Ôʼ·¢Æ±µÄÊÕ·ÑÃ÷ϸdw_sfmx_total.retrieve(fphm)
´ÓÔʼ·¢Æ±µÄÊÕ·ÑÃ÷ϸÖп۳ýÒÑÍ˷Ѳ¿·ÖµÄ·ÑÓÃÃ÷ϸ£¬Ê£Óಿ·ÖΪ½øÐиôÎÍ˷ѲÙ×÷ǰ·ÑÓÃÃ÷ϸwf_cacl_sfmx_ytf()
¿½±´Ê¹dw_sfmx,dw_sfmx_totalÖб£´æµÄÊÕ·ÑÃ÷ϸ¾ùΪ½øÐиôÎÍ˷ѲÙ×÷ǰ·ÑÓÃÃ÷ϸdw_sfmx_total.rowscopy£¨£©
´Ódw_sfmx_totalÖп۳ý¸Ã´ÎÍ˷ѵĸ÷ÏîÊÕ·ÑÃ÷ϸwf_cacl_sfmx_tf()
×¼±¸dw_mzxxµÄÊý¾Ýwf_prepare_mzxx("tf")²¢
²úÉúdw_sfmx(ÓÃÓÚ±£´æµÄdatawindow) wf_save_prepare_print()
g) w_tfcl_jsµÄ˵Ã÷£º
¸ù¾Ý¾«¶Èµ÷Õûdw_sfmxÖеÄzfjeºÍzjje²¢È¡ÏÖ½ð¡¢Ö§Æ±¡¢ÕÊ»§ºÍÆäËüÓ¦ÊÕ
ÓÃwf_save±£´æµ¥¾Ý
dw_cf01_save.update()¡¢dw_cf02_save.update()¡¢dw_yj01_save.update()
dw_yj02_save.update()¡¢dw_mzxx.update()¡¢dw_sfmx.update()
update MS_MZXX set THPB = 1
update MS_CF01 set ZFPB = 1£¨sybz = 1 and fybz = 0£©
update MS_CF01 set FPHM = :ls_fphm£¨sybz = 1 and fybz = 3£©
update MS_YJ01 set ZFPB = 1(sybz = 1)
ÀÛ¼Ó·¢Æ±ºÅÂëuo_ygpjgl.add_one(new fphm)
¸üÐÂÔ±¹¤Æ±¾Ý¿âµÄʹÓúÅÂëuo_ygpjgl. update_fphm(fphm)
¸üÐÂÒ©·¿Â¼ÈëµÄÍËÒ©µ¥,ÌƱºÅÂë
w_tfcl.wf_create_fp()Éú³É·¢Æ±ÐÅÏ¢²¢´òÓ¡
Êý¾Ý´°¿Ú d_mzxx,d_sfmx, d_ms_cf01_tf£¬d_ms_yj01_tf£¬d_ms_cf02_tf£¬d_ms_yj02_tf
d_uo_yj02_ms_yj02£¬d_uo_sfmx_ms_sfmx£¬d_uo_cf02_ms_cf02£¬d_uo_yj01_ms_yj01
d_uo_cf01_ms_cf01
ÒýÓñí Ms_cf02£¬ms_yj02µÈ
²Ù×÷±í Ms_mzxx,ms_sfmx,ms_cf01,ms_yj01,ms_yj02£¬ms_cf02
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®16
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ²Ù×÷Ô±ÊÕ·ÑÈÕ±¨±í ±àºÅ 5.24
¹¦
ÄÜ
Ãè
Êö 1£® ¸ù¾Ý²ÎÊýÉèÖÃÊÕ·ÑÈÕ±¨Ä£Ê½
2£® ²úÉú°´Å¥ÓÃÓÚ²úÉúµ±ÈÕÊÕ¿îÈÕ±¨
3£®½áÕʰ´Å¥ÓÃÓÚ±£´æµ±ÈÕÊÕ¿îÈÕ±¨£¬½áÕÊʱʱ¼äΪ½áÕÊÈÕÆÚ
4£®²éѯ°´Å¥ÓÃÓÚ²éѯijһ½áÕÊÈÕÆÚµÄÊÕ¿îÈÕ±¨
5£®Ã÷ϸ°´Å¥ÓÃÓÚ²éѯºÍ¸ÃÈÕ±¨ÓйصÄÊÕ·ÑÃ÷ϸ
³Ì
Ðò
Ãè
Êö 1£® ÊÕ·ÑÈÕ±¨Ä£Ê½:1Ϊopen(w_skrb_sfxm)¡ªd_skrb_fylb £»2 Ϊopen(w_skrb_brxz) ¡ªd_skrb_brxz
2£® ¸ÃÄ£¿éÖÐÒÔ½áÕÊÈÕÆÚ(jzrq)Çø·Öÿһ´Î½áÕÊ£¬ÎÞ½áÕÊÈÕÆÚÔò±íʾδ½áÕÊ
¸Ã½áÕÊÈÕÆÚÓÃÓÚms_mzxx¼°ms_zffpÁ½¸ö±íÖÐ
3£® ±íÖеĸ÷·ÑÓÃÏîÄ¿¼°ÏÖ½ð½ð¶î£¬Ö§Æ±½ð¶î£¬ÕÊ»§½ð¶î(¼´ms_mzxxÖеÄqtje)
¾ùΪȫ²¿µÄijÏî½ð¶î¼õÈ¥ÏàÓ¦µÄ×÷·Ï·¢Æ±½ð¶î
4£® ÆäËüÓ¦ÊÕ¿î=ÊÕÈëºÏ¼Æ-ÏÖ½ð½ð¶î-֧Ʊ½ð¶î-ÕÊ»§½ð¶î
5£® ×÷·Ï·¢Æ±ÐòÁÐΪms_zffp¿âÖи÷·¢Æ±ºÅÂë
6£® ÍËÆ±Îª×ö¹ýÍË·Ñ´¦ÀíµÄ·¢Æ±ÐòÁÐ
7£® ²úÉú²Ù×÷˵Ã÷£º
¼ÆËã°´·ÑÓ÷ÖÀàµÄÊÕ·ÑÇé¿öwf_cacl_sfxm(dw_1)
¼ÆËã°´²¡ÈËÐÔÖÊ·ÖÀàµÄÊÕ·ÑÇé¿öwf_cacl_brxz(dw_1)
²úÉúʹÓ÷¢Æ±ÐòÁÐwf_cacl_fpxl()
²úÉú×÷·Ï·¢Æ±ÐòÁÐ,ÕÅÊý,×÷·Ï·¢Æ±×ܽð¶îwf_proc_zffpxl()
²úÉúÍË·Ñ·¢Æ±ÐòÁÐ,ÕÅÊý,ÍË·Ñ·¢Æ±×ܽð¶îwf_proc_tffpxl()
È¡½ñÈÕ¸÷ÏîºÏ¼Æ½ð¶îwf_cacl_hjje()
¼ÆËã°´·ÑÓÃÀà±ð·ÖÀàµÄÊÕ·ÑÇé¿öwf_cacl_sfxm(dw_2)
¼ÆËã°´ÊÕ·ÑÏîÄ¿µÄÊÕ·ÑÇé¿öwf_cacl_brxz(dw_2)
8. ²éѯ²Ù×÷˵Ã÷£ºopen(w_rbrq)Ñ¡Ôñijһ´ÎÈÕ±¨
µ÷ÓÃwf_cx("d_rbcx_brxz") or wf_cx("d_rbcx_sfxm")
8£® ½áÕʲÙ×÷˵Ã÷£º
д»ã×ÜÈÕ±¨±íwf_write_hzrb(ldt_jzrq)
дÐÔÖÊÃ÷ϸ±í(MS_XZMX) wf_write_xzmx(dw_1,ldt_jzrq)
дÈÕ±¨Ã÷ϸ±í(MS_XZMX) wf_write_rbmx(dw_1,ldt_jzrq)
ms_rbmx ÔڸñíÖмǼÿһ·ÑÓÃÀà±ðµÄ·ÑÓÃ(sfxmʵ¼ÊΪfylb
дÃÅÕïÊÕ·Ñ±í¼°·¢Æ±×÷·Ï±íÖеĽáÕÊÈÕÆÚwf_write_jzrq(ldt_jzrq)
ÔÚms_mzxx¼°ms_zffpÖн«¸Ã²Ù×÷Ô±µÄΪ½áÕʵļǼдÈë½áÕÊÈÕÆÚ
Êý¾Ý´°¿Ú d_skrb_fylb¡¢d_skrb_brxz
ÒýÓñí Ms_sfmxµÈ
²Ù×÷±í Ms_mzxx,ms_zffp,ms_hzrb,ms_rbmx
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®16
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ÃÅÕïÊÕ·Ñ»ã×ÜÈÕ±¨±í ±àºÅ 5.25
¹¦
ÄÜ
Ãè
Êö 1£®¸Ã±íΪ¸÷ÊÕ·ÑÔ±ËùÊÕ·ÑÓð´·ÑÓÃÀà±ð·ÖÀàµÄ±í(ÒÑ×ö¹ýÊÕ¿îÈÕ±¨)
2£®²úÉú°´Å¥ÓÃÓÚ½«Î´»ã×ܵÄÊÕ¿îÈÕ±¨°´ÊÕ¿îÔ±»ã×ÜÏÔʾ
3£®½áÕʰ´Å¥ÓÃÓÚ×÷»ã×Ü£¬Ð´Èë»ã×ÜÈÕÆÚ
²éѯ°´Å¥ÓÃÓÚ½«»ã×ÜÈÕÆÚÔÚ¸ø¶¨ÈÕÆÚ¶ÎµÄ»ã×ÜÈÕ±¨»ã×ÜÏÔʾ
³Ì
Ðò
Ãè
Êö ¹ÒºÅÊÕ·Ñ»ã×Üdw_hzrb¡¢ÏîÄ¿·ÖÀà»ã×Üdw_xmhz
A£®²úÉú
1£® °´ÊÕ¿îÔ±½øÐйҺŻã×ÜMS_GHMX
2£® °´ÊÕ¿îÔ±½øÐÐÍ˺Żã×ÜMS_THMX
3£® ÌîÈë¹ÒºÅÈÕ±¨ÐÅÏ¢£ºÏÖ½ð¡¢ÕÊ»§¡¢ÆäËûÓ¦ÊÕ
4£® ¼õÈ¥Í˺Ų¿·Ö
5£® ¼ÆËã¹ÒºÅ×÷·ÏºÍ¹ÒºÅÍ˺ÅÊý
6£® ¼ÆËã×÷·Ï·¢Æ±ºÍÍË·Ñ·¢Æ±Êý
B£®²éѯ
¸ù¾ÝÈÕÆÚ¼ìË÷Êý¾Ý£¬·½·¨Óë²úÉúÏàͬ
C£®½áÕÊ
¸üлã×ÜÈÕ±¨update MS_HZRB set HZRQ
¸üйҺÅÃ÷ϸUPDATE MS_GHMX SET HZRQ
¸üÐÂÍ˺ÅÃ÷ϸUPDATE MS_THMX SET HZRQ
¸üÐÂÃÅÕïÐÅÏ¢UPDATE MS_MZXX SET HZRQ
¸üÐÂ×÷·Ï·¢Æ±UPDATE MS_ZFFP SET HZRQ
ms_hzrbÖеÄHZRQΪ¸ÃÊÕ¿îÈÕ±¨ÊÇ·ñ×ö¹ý»ã×ܵıê¼Ç
½áÕʲÙ×÷¼´Êǽ«ms_hzrbÖеÄHZRQдÈë»ã×ܵÄÈÕÆÚ£¬Èô¸ÃÈÕÆÚΪ¿Õ£¬
±íʾδ×ö¹ý»ã×Ü
¸ù¾ÝÈÕÆÚ¼ìË÷Êý¾Ý£¬·½·¨Óë²úÉúÏàͬ
Êý¾Ý´°¿Ú d_mz_xmhz¡¢d_mz_hzrb
ÒýÓñí Ms_sfmxµÈ
²Ù×÷±í Ms_mzxx,ms_zffp,ms_hzrb,ms_rbmx
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®16
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ²¡ÈËÐÔÖʱ¨±í ±àºÅ 5.31
¹¦
ÄÜ
Ãè
Êö 1£®µ±Ñ¡ÔñµÄ²¡ÈËÐÔÖÊÓÐϼ¶ÐÔÖÊʱ£¬²úÉú°´Æäϼ¶ÐÔÖʹ鲢µÄ±¨±í
2£®µ±Ñ¡ÔñµÄ²¡ÈËÐÔÖÊÎÞϼ¶ÐÔÖÊʱ
µ±·½Ê½ÎªÃ÷ϸʱ£º²úÉú¸ÃÐÔÖʲ¡È˵Äÿ´ÎÃ÷ϸµÄ±¨±í
µ±·½Ê½Îª»ã×Üʱ£º²úÉú¸Ã°´¸ÃÐÔÖʲ¡ÈË»ã×ܵı¨±í
³Ì
Ðò
Ãè
Êö ¼û5.7 ²¡È˵¥Î»ÐÔÖʱ¨±í
Êý¾Ý´°¿Ú d_mz_brfy_1£¨Ã÷ϸ£©d_mz_brfy_2£¨»ã×Ü£©
ÒýÓñí Gy_brxz,gy_fydw,ms_mzxx,ms_sfmx
²Ù×÷±í
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®17
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ²¡ÈËÐÔÖʵ¥Î»±¨±í ±àºÅ 5.32
¹¦
ÄÜ
Ãè
Êö 1£®µ±Ñ¡ÔñµÄ²¡ÈËÐÔÖÊÓÐϼ¶ÐÔÖÊÇÒÐ迼ÂÇÆäϼ¶ÐÔÖÊʱ£¬²úÉú°´Æäϼ¶ÐÔÖʹ鲢µÄ±¨±í
2£®µ±Ñ¡ÔñµÄ²¡ÈËÐÔÖÊÎÞϼ¶ÐÔÖÊ»òÓÐϼ¶ÐÔÖʵ«²»Ð迼ÂÇÆäϼ¶ÐÔÖÊʱ
µ±·½Ê½ÎªÃ÷ϸʱ£º²úÉú¸ÃÐÔÖʲ¡È˵Äÿ´ÎÃ÷ϸµÄ±¨±í
µ±·½Ê½Îª»ã×Üʱ£º²úÉú¸Ã°´¸ÃÐÔÖʲ¡ÈË»ã×ܵı¨±í
3£®µ±Ñ¡ÔñµÄ²¡ÈËÐÔÖÊÓÐËùÊôµ¥Î»Ê±£¬²úÉú°´ËùÊôµ¥Î»»ã×ܵı¨±í
4£®µ±Ñ¡ÔñµÄΪµ¥Î»Ê±
µ±·½Ê½ÎªÃ÷ϸʱ£º²úÉú¸Ãµ¥Î»²¡È˵Äÿ´ÎÃ÷ϸµÄ±¨±í
µ±·½Ê½Îª»ã×Üʱ£º²úÉú¸Ã°´¸Ãµ¥Î»²¡ÈË»ã×ܵı¨±í
³Ì
Ðò
Ãè
Êö 1£® ±¨±í´°¿ÚÓÉw_bbfather´°¿Ú¼Ì³Ð
2£® ÔÚcb_2.clickedÖУ¬ifΪҶ½áµã and ifΪÃ÷ϸ±¨±í£¬Ôòis_data = "d_mz_dwfy_1"£¬·ñÔòΪ"d_mz_dwfy_2",if ·ÇÒ¶½áµã,Ôòis_data = "d_mz_dwfy"
3£® ³õʼ»¯wf_initial():Ã÷ϸwf_brdw_mx()£»»ã×Üwf_brdw_hz()£»¸ù½áµãwf_brxz()
·½·¨£º½«±¨±í×ֶηÅÈ뱨±í±íÍ·½á¹¹Êý×és_reportcolÖÐ
(colname, colcode, colleen, colgroup, coldata, coltype, coldatatype)
coltype ÀàÐÍ(1.ÐÅÏ¢,2.Êý¾Ý)£» coldatatypeÀàÐÍ(1-string 2-number 3-date)
4£® ½«'d_xmgb'ÖмͼÕûÀíµ½½á¹¹ÖУ¬gf_getreportcolparm(±¨±í±àºÅ,½á¹¹, ÊÇ·ñ·Ö×é, ÊÇ·ñ·Ö×éºÏ¼Æ, ¿ªÊ¼ÁÐ, ³¤¶È),ÉèÖÃcolgroupÏî
5£® ½«±¨±íÊ×β²¿·Ö·ÅÈ뱨±íÃû³Æ,̨ͷ,¸½×¢½á¹¹s_reporttabelÖУ¬(title1,title2,title3,title4,footer1,footer2,printp)£¬ÆäÖУ¬title1Ϊ±¨±í±êÌ⣬title2Ϊ±¨±í¸±Ìâ(´Ë´¦Ð´²¡È˵¥Î»)£¬title3Ϊ±¨±íÈÕÆÚ£¬title4Ϊ±¨±í×¢(´Ë´¦Îª¡®µ¥Î»:Ôª¡¯)£¬footer1£¬footer2Ϊ½Å×¢£¬printpΪÊÇ·ñ´òÓ¡Ò³ºÅ(T.ÊÇ,F.·ñ)
6£® ½«±¨±íÐÔÖʲ¿·Ö·ÅÈ뱨±íÖÐÐÐ×Ö¶Î,ÁÐ×Ö¶Î,Öµ×Ö¶Î,Êý¾ÝÔ´ÒÔ¼°×ÖÌå½á¹¹s_reporttablesysÖÐ(rowfield, rowtype, colfield, valfield, datastore,
tfont,hfont, dfont, colcount)
7£® uo_1.initial(s_reportcol [],s_reporttabel [],s_reporttablesys [])
8£® w_bbfather¿Ø¼þ˵Ã÷£º
cb_2 ¸ù¾ÝÀàÐÍÑ¡Ôñil_selecttype
s_exchange.longparm[1] = 1 ¿Éѡȫ²¿
s_exchange.longparm[2] = 2 ÃÅÕïÐÔÖÊ =1 È«²¿ÐÔÖÊ
1Ϊ¿ÆÊÒ£¬´ò¿ªw_ksdm_sele£»2Ϊȫ²¿²¡ÈËÐÔÖÊ£¬4ΪÃÅÕﲡÈËÐÔÖÊ£¬5ΪסԺ²¡ÈËÐÔÖÊ£¬´ò¿ªw_brxz_sele£»3Ϊȫ²¿µ¥Î»ÐÔÖÊ£¬6ΪÃÅÕﵥλÐÔÖÊ£¬7ΪסԺµ¥Î»ÐÔÖÊ£¬´ò¿ªw_fydw_sele¡£
uo_1 ¼Ì³ÐÓÚ vu_reportcomp
cb_tj ½øÐÐͳ¼Æ
ÔÚwf_getdata()ÖÐÉèÖô洢¹ý³Ì£¬DataObject = is_data£¬²¢È¡Êý¾Ý
wf_refreshdata(ʱ¼ä)£¬¸üÐÂuo_1¿Ø¼þÊý¾Ý
´òÓ¡µ÷ÓÃuo_1.printreport()
9£® Vu_reportcomp˵Ã÷£º
Êý¾Ý´°¿ÚΪdw_reportdisp(d_reportbbsign) À¸µ÷Õûµ÷ÓÃuf_column()
½á¹¹s_reportpage£¨zls×ÜÁÐÊý£¬xxlÐÅÏ¢ÁÐÊý£¬sjl Êý¾ÝÁÐÊý£¬fy·ÖÒ³Êý£¬
fyl·ÖÒ³ÁÐÊý£¬zys ×ÜÒ³Êý£©ÆäËü½á¹¹ÒÑÔÚÉÏÃæËµÃ÷¡£
getrowval() È¡µÃµ±Ç°ÐÐΨһ±êʾֵ
initial(stru_col[],stru_table[],stru_tablesys[])³õʼ»¯±í½á¹¹
printreport() ´òÓ¡±¨±í
Êý¾Ý´°¿Ú d_reportsfxm£¨gy_sfxm£©¡¢d_reportxmgb(gy_xmgb)¡¢
ÒýÓñí Gy_brxz,gy_fydw,ms_mzxx,ms_sfmx
²Ù×÷±í
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®17
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ¹ÒºÅ·Ö¿ÆÍ³¼Æ±í ±àºÅ 5.33
¹¦
ÄÜ
Ãè
Êö °´¿ÆÊÒ½øÐйҺÅͳ¼Æ
³Ì
Ðò
Ãè
Êö Dw_1¹ÒºÅÊý¾Ý¼õÈ¥dw_2Í˺ÅÊý¾ÝÏÔʾ½á¹ûÔÚdw_1 ÖÐ
Êý¾Ý´°¿Ú d_gh_kshz, d_gh_kshz_th
ÒýÓñí MS_GHMX,MS_GHKS,MS_THMX
²Ù×÷±í
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®17
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ Ò½Éú¹ÒºÅͳ¼Æ±í ±àºÅ 5.34
¹¦
ÄÜ
Ãè
Êö °´Ò½Éú½øÐйҺÅͳ¼Æ
³Ì
Ðò
Ãè
Êö Dw_1¹ÒºÅÊý¾Ý¼õÈ¥dw_2Í˺ÅÊý¾ÝÏÔʾ½á¹ûÔÚdw_1 ÖÐ
Êý¾Ý´°¿Ú d_gh_yshz, d_gh_yshz_th
ÒýÓñí MS_GHMX,MS_GHKS,MS_THMX
²Ù×÷±í
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®17
Ä£ ¿é ˵ Ã÷ Êé
²úÆ·Ãû³Æ ÃÅÕï¹ÒºÅÊÕ·Ñϵͳ Ä£¿éÃû³Æ ¿ÆÊÒÒ½ÉúºËË㱨±í ±àºÅ 5.35
¹¦
ÄÜ
Ãè
Êö 1£®°´¿ªµ¥¿ÆÊÒ£¬¿ªµ¥Ò½Éú£¬Ö´ÐпÆÊÒ£¬Ö´ÐÐÒ½ÉúËÄÖÖ·½Ê½½øÐкËËã
2£®¿ÉʵÏÖÒ»´Îͳ¼Æ£¬¶à´Î²éѯ
³Ì
Ðò
Ãè
Êö 1£®Ñ¡Ôñ¿ÆÊÒ£ºÈôÑ¡Ôñ¿ªµ¥is_data = "d_mz_kdks"£¬·ñÔòis_data = "d_mz_zxks"
Ñ¡ÔñÒ½Éú£ºÈôÑ¡Ôñ¿ªµ¥is_data = "d_mz_kdys"£¬·ñÔòis_data = "d_mz_zxys"
2£®ºǫ́ͳ¼Æ£ºÈô¸Ãʱ¼ä¶ÎÄÚÒÑ×ö¹ýͳ¼Æ,ÊÇ·ñ¸²¸Ç£¬Èô¸²¸ÇÔò
delete MS_MZMX¡¢MS_MZHS¡¢MS_YJMX¡¢MS_YJHS±íÄÚS_MZMX.GZRQ >= :ldt_begin and MS_MZMX.GZRQ <= :ldt_endµÄ¼Ç¼
wf_tj_mzhs(ldt_begin,ldt_end) ͳ¼ÆÃÅÕïºËËã±í
½øÐÐÃÅÕ↑µ¥ºËËã(ÌîMS_MZHS±í)dw_mzhs
´¦·½Í³¼Æd_mz_cftj_kdzs
¿Û³ý´¦·½×÷·Ïd_mz_cftj_kdzs_zf
Ò½¼¼Í³¼Æd_mz_yjtj_kdzs
¿Û³ýÒ½¼¼×÷·Ïd_mz_yjtj_kdzs_zf
wf_tj_mzmx(ldt_begin,ldt_end) ͳ¼ÆÃÅÕïÃ÷ϸ±ídw_mzmx
½øÐÐÃÅÕ↑µ¥ºËËãwf_tj_je(dw_mzmx,"d_mz_cftj_kdje",adt_begin,adt_end)
½øÐÐÃÅÕï×÷·ÏºËËãwf_tj_je(dw_mzmx,"d_mz_cftj_kdje_zf",adt_begin,adt_end)
½øÐÐÒ½¼¼¿ªµ¥ºËËãwf_tj_je(dw_mzmx,"d_mz_yjtj_kdje",adt_begin,adt_end)
½øÐÐÒ½¼¼×÷·ÏºËËãwf_tj_je(dw_mzmx,"d_mz_yjtj_kdje_zf",adt_begin,adt_end)
wf_tj_yjhs(ldt_begin,ldt_end) ͳ¼ÆÒ½¼¼(Ö´ÐÐ)ºËËã±í
½øÐÐÃÅÕïÖ´ÐкËËã(ÌîMS_YJHS±í) dw_yjhs
Ö´ÐÐͳ¼Æd_mz_yjtj_zxzs
wf_tj_yjmx(ldt_begin,ldt_end) ͳ¼ÆÒ½¼¼(Ö´ÐÐ)Ã÷ϸ±ídw_yjmx
Ò½¼¼Ö´Ðнð¶îºËËãwf_tj_je(dw_yjmx,"d_mz_yjtj_zxje",adt_begin,adt_end)
3.ͳ¼Æ²Ù×÷ͬ²¡ÈËÐÔÖʵ¥Î»±¨±í
Êý¾Ý´°¿Ú d_mz_kdks, d_mz_zxks,d_mz_kdys, d_mz_zxys,
d_mz_cftj_kdzs,d_mz_cftj_kdzs_zf, d_mz_yjtj_kdzs, d_mz_yjtj_kdzs_zf
d_mz_cftj_kdje, d_mz_cftj_kdje_zf, d_mz_yjtj_kdje, d_mz_yjtj_kdje_zf
d_mz_yjtj_zxzs, d_mz_yjtj_zxje
ÒýÓñí ms_mzxx,ms_sfmx,ms_cf01,ms_cf02,ms_yj01,ms_yj02
²Ù×÷±í Ms_mzhs,ms_mzmx,ms_yjhs,ms_yjmx
±àÖÆ ÖÓ»ª ÈÕÆÚ 2000£®05£®17
Èý£® ½çÃæÉè¼ÆÃèÊö
½çÃæÃû³Æ£º²¡È˵µ°¸Î¬»¤
½çÃæÍ¼Ê¾£º
ͼ1
ͼ2
|
|
ÏÂÔØµØÖ· |
|
|
|
|
|