XJBHZCX.PRG
上传用户:hbmaozhan
上传日期:2013-01-31
资源大小:1007k
文件大小:13k
源码类别:

企业管理

开发平台:

VFP

  1.  HIDE POPUP pop4
  2.  HIDE POPUP pop4_2
  3.  HIDE MENU mainmenu
  4.  SET CLOCK TO 0, 69
  5.  DEAC WINDOW win
  6.  ON KEY
  7.  SET SYSMENU OFF
  8.  SET COLOR TO W/N
  9.  CLOS DATABASES
  10.  CLEA
  11.  p = 1
  12.  wj = 'bdbhz.dbf'
  13.  IF FILE(wj)
  14.       use &wj
  15.  ELSE
  16.       ! copy cwbdbhz.dbf &wj >nul
  17.       use &wj
  18.  ENDI
  19.  SET COLOR TO GR/N
  20.  @ 1, 0 SAY '广西盐业公司'
  21.  @ 1, 67 SAY 'JQ财务系统'
  22.  SET COLOR TO G/N
  23.  @ 0, 25 SAY '现  金  流  量  表  '
  24.  @ 2, 0 SAY '┏━━━━━━━━━━━━━━━━━━━━━━━━━━┯━━┯━━━━━━━━┓'
  25.  @ 3, 0 SAY '┃'
  26.  @ 3, 5 SAY '             项             目    '
  27.  @ 3, 54 SAY '│'
  28.  @ 3, 57 SAY '行'
  29.  @ 3, 60 SAY '│'
  30.  SET COLOR TO GR+/N
  31.  @ 3, 63 SAY ' 金      额 '
  32.  SET COLOR TO G/N
  33.  @ 3, 78 SAY '┃'
  34.  @ 4, 0 SAY '┠──────────────────────────┼──┼────────┨'
  35.  pd = 4
  36.  DO WHILE pd<23
  37.       i = pd+1
  38.       @ i, 0 SAY '┃'
  39.       @ i, 54 SAY '│'
  40.       @ i, 60 SAY '│'
  41.       @ i, 78 SAY '┃'
  42.       pd = pd+1
  43.  ENDD
  44.  @ 23, 0 SAY '┗━━━━━━━━━━━━━━━━━━━━━━━━━━┷━━┷━━━━━━━━┛'
  45.  SET COLOR TO B/GR
  46.  @ 24, 0 SAY '←左栏:→右栏:|←左页:右页→|:↑上笔:↓下笔:PgUp上页:PgDn 下页:Home计算:Esc退出'
  47.  SET COLOR TO W/N
  48.  GOTO BOTTOM
  49.  pd = RECNO()
  50.  pd = pd/16
  51.  pd1 = INT(pd)
  52.  ys = pd-pd1
  53.  IF ys=0
  54.       ys = pd1
  55.  ELSE
  56.       ys = pd1+1
  57.  ENDI
  58.  GOTO TOP
  59.  pd = 1
  60.  ys1 = 1
  61.  DO WHILE .T.
  62.       @ 4+pd, 2 SAY sm1
  63.       @ 4+pd, 57 SAY h1
  64.       IF je1<>0
  65.            @ 4+pd, 63 SAY je1 PICTURE '999,999,999.99'
  66.       ENDI
  67.       IF  .NOT. EOF()
  68.            SKIP
  69.            pd = pd+1
  70.       ELSE
  71.            EXIT
  72.       ENDI
  73.       IF pd=19
  74.            EXIT
  75.       ENDI
  76.  ENDD
  77.  GOTO 1
  78.  SET COLOR TO G+/B
  79.  @ 5, 2 SAY sm1
  80.  @ 5, 57 SAY h1
  81.  IF je1<>0
  82.       @ 5, 63 SAY je1 PICTURE '999,999,999.99'
  83.  ELSE
  84.       @ 5, 63 SAY '              '
  85.  ENDI
  86.  pd = 1
  87.  zc1 = 'sm1'
  88.  h = 'h1'
  89.  ncs = 'je1'
  90.  zy = 1
  91.  p = 1
  92.  DO WHILE .T.
  93.       x = INKEY(0)
  94.       DO CASE
  95.            CASE x=46 .OR. x=45 .OR. x>47 .AND. x<58
  96.                 a1 = 0.00
  97.                 IF pp1='1' .AND. p=1 .OR. p=2 .AND. pp2='1' .OR. EOF()
  98.                      ?? CHR(7)
  99.                      LOOP
  100.                 ENDI
  101.                 KEYB CHR(x)
  102.                 SET COLOR TO N/W
  103.                 @ 4+pd, 63 SAY '           '
  104.                 @ 4+pd, 63 GET a1 PICTURE '@bz 99999999999.99'
  105.                 READ
  106.                 repl &ncs with a1 
  107.                 SET COLOR TO W/N
  108.                 xx = RECNO()
  109.                 pd2 = pd
  110.                 SELE 3
  111.                 USE xjbjs
  112.                 DO jsgs
  113.                 SELE 1
  114.                 IF ys1=ys
  115.                      GOTO (ys-1)*18+1
  116.                 ELSE
  117.                      GOTO (ys1)*18
  118.                      SKIP -17
  119.                 ENDI
  120.                 pd = 1
  121.                 SET COLOR TO W/N
  122.                 DO WHILE .T.
  123.                      if &ncs<>0
  124.                           @ 4+pd,63 say &ncs pict'999,999,999.99'
  125.                      ELSE
  126.                           @ 4+pd, 63 SAY '              '
  127.                      ENDI
  128.                      IF  .NOT. EOF()
  129.                           SKIP
  130.                           pd = pd+1
  131.                      ELSE
  132.                           EXIT
  133.                      ENDI
  134.                      IF pd=19
  135.                           EXIT
  136.                      ENDI
  137.                 ENDD
  138.                 GOTO xx
  139.                 pd = pd2
  140.                 IF pd=18 .OR. EOF()
  141.                      ?? CHR(7)
  142.                 ELSE
  143.                      SET COLOR TO W/N
  144.                      @ 4+pd,2 say &zc1
  145.                      @ 4+pd,57 say &h
  146.                      if &ncs<>0
  147.                           @ 4+pd,63 say &ncs pict'999,999,999.99'
  148.                      ELSE
  149.                           @ 4+pd, 62 SAY '               '
  150.                      ENDI
  151.                      SET COLOR TO G+/B
  152.                      SKIP
  153.                      pd = pd+1
  154.                      @ 4+pd,2 say &zc1
  155.                      @ 4+pd,57 say &h
  156.                      if &ncs<>0
  157.                           @ 4+pd,63 say &ncs pict'999,999,999.99'
  158.                      ELSE
  159.                           @ 4+pd, 63 SAY '              '
  160.                      ENDI
  161.                 ENDI
  162.            CASE x=5
  163.                 IF pd=1 .OR. RECNO()=1
  164.                      ?? CHR(7)
  165.                 ELSE
  166.                      SET COLOR TO W/N
  167.                      @ 4+pd,2 say &zc1
  168.                      @ 4+pd,57 say &h
  169.                      if &ncs<>0
  170.                           @ 4+pd,63 say &ncs pict'999,999,999.99'
  171.                      ELSE
  172.                           @ 4+pd, 63 SAY '              '
  173.                      ENDI
  174.                      SET COLOR TO G+/B
  175.                      SKIP -1
  176.                      pd = pd-1
  177.                      @ 4+pd,2 say &zc1
  178.                      @ 4+pd,57 say &h
  179.                      if &ncs<>0
  180.                           @ 4+pd,63 say &ncs pict'999,999,999.99'
  181.                      ELSE
  182.                           @ 4+pd, 63 SAY '              '
  183.                      ENDI
  184.                 ENDI
  185.            CASE x=24
  186.                 IF pd=18 .OR. EOF()
  187.                      ?? CHR(7)
  188.                 ELSE
  189.                      SET COLOR TO W/N
  190.                      @ 4+pd,2 say &zc1
  191.                      @ 4+pd,57 say &h
  192.                      if &ncs<>0
  193.                           @ 4+pd,63 say &ncs pict'999,999,999.99'
  194.                      ELSE
  195.                           @ 4+pd, 63 SAY '              '
  196.                      ENDI
  197.                      SET COLOR TO G+/B
  198.                      SKIP
  199.                      pd = pd+1
  200.                      @ 4+pd,2 say &zc1
  201.                      @ 4+pd,57 say &h
  202.                      if &ncs<>0
  203.                           @ 4+pd,63 say &ncs pict'999,999,999.99'
  204.                      ELSE
  205.                           @ 4+pd, 63 SAY '              '
  206.                      ENDI
  207.                 ENDI
  208.            CASE x=18
  209.                 IF ys1>1
  210.                      ys1 = ys1-1
  211.                      GOTO ys1*18
  212.                      SKIP -17
  213.                      pd = 1
  214.                      SET COLOR TO W/N
  215.                      @ 5, 2 CLEAR TO 22, 52
  216.                      @ 5, 56 CLEAR TO 22, 58
  217.                      @ 5, 62 CLEAR TO 22, 77
  218.                      DO WHILE .T.
  219.                           @ 4+pd,2 say &zc1
  220.                           @ 4+pd,57 say &h
  221.                           if &ncs<>0
  222.                                @ 4+pd,63 say &ncs pict'999,999,999.99'
  223.                           ELSE
  224.                                @ 4+pd, 63 SAY '              '
  225.                           ENDI
  226.                           IF  .NOT. EOF()
  227.                                SKIP
  228.                                pd = pd+1
  229.                           ELSE
  230.                                EXIT
  231.                           ENDI
  232.                           IF pd=19
  233.                                EXIT
  234.                           ENDI
  235.                      ENDD
  236.                      SKIP -18
  237.                      SET COLOR TO G+/B
  238.                      @ 5,2 say &zc1
  239.                      @ 5,57 say &h
  240.                      if &ncs<>0
  241.                           @ 5,63 say &ncs pict'999,999,999.99'
  242.                      ELSE
  243.                           @ 5, 63 SAY '              '
  244.                      ENDI
  245.                      pd = 1
  246.                 ELSE
  247.                      ?? CHR(7)
  248.                 ENDI
  249.            CASE x=3
  250.                 SET COLOR TO W/N
  251.                 IF ys1<ys
  252.                      ys1 = ys1+1
  253.                      GOTO (ys1-1)*18+1
  254.                      x = RECNO()
  255.                      pd = 1
  256.                      SET COLOR TO W/N
  257.                      @ 5, 2 CLEAR TO 22, 52
  258.                      @ 5, 56 CLEAR TO 22, 58
  259.                      @ 5, 62 CLEAR TO 22, 77
  260.                      DO WHILE .T.
  261.                           @ 4+pd,2 say &zc1
  262.                           @ 4+pd,57 say &h
  263.                           if &ncs<>0
  264.                                @ 4+pd,63 say &ncs pict'999,999,999.99'
  265.                           ENDI
  266.                           IF  .NOT. EOF()
  267.                                SKIP
  268.                                pd = pd+1
  269.                           ELSE
  270.                                EXIT
  271.                           ENDI
  272.                           IF pd=19
  273.                                EXIT
  274.                           ENDI
  275.                      ENDD
  276.                      GOTO x
  277.                      SET COLOR TO G+/B
  278.                      @ 5,2 say &zc1
  279.                      @ 5,57 say &h
  280.                      if &ncs<>0
  281.                           @ 5,63 say &ncs pict'999,999,999.99'
  282.                      ELSE
  283.                           @ 5, 63 SAY '              '
  284.                      ENDI
  285.                      pd = 1
  286.                 ELSE
  287.                      ?? CHR(7)
  288.                 ENDI
  289.            CASE x=15
  290.                 IF p=2
  291.                      zc1 = 'sm1'
  292.                      h = 'h1'
  293.                      ncs = 'je1'
  294.                      SET COLOR TO W/N
  295.                      GOTO (ys1-1)*18+1
  296.                      x = RECNO()
  297.                      pd = 1
  298.                      SET COLOR TO G/N
  299.                      @ 3, 5 SAY '          项        目                      '
  300.                      SET COLOR TO W/N
  301.                      @ 5, 2 CLEAR TO 22, 52
  302.                      @ 5, 56 CLEAR TO 22, 58
  303.                      @ 5, 62 CLEAR TO 22, 77
  304.                      DO WHILE .T.
  305.                           @ 4+pd,2 say &zc1
  306.                           @ 4+pd,57 say &h
  307.                           if &ncs<>0
  308.                                @ 4+pd,63 say &ncs pict'999,999,999.99'
  309.                           ENDI
  310.                           IF  .NOT. EOF()
  311.                                SKIP
  312.                                pd = pd+1
  313.                           ELSE
  314.                                EXIT
  315.                           ENDI
  316.                           IF pd=19
  317.                                EXIT
  318.                           ENDI
  319.                      ENDD
  320.                      GOTO x
  321.                      SET COLOR TO G+/B
  322.                      @ 5,2 say &zc1
  323.                      @ 5,57 say &h
  324.                      if &ncs<>0
  325.                           @ 5,63 say &ncs pict'999,999,999.99'
  326.                      ELSE
  327.                           @ 5, 63 SAY '              '
  328.                      ENDI
  329.                      pd = 1
  330.                      p = 1
  331.                 ELSE
  332.                      ?? CHR(7)
  333.                 ENDI
  334.            CASE x=9
  335.                 IF p=1
  336.                      SET COLOR TO W/N
  337.                      GOTO (ys1-1)*18+1
  338.                      x = RECNO()
  339.                      pd = 1
  340.                      zc1 = 'sm2'
  341.                      h = 'h2'
  342.                      ncs = 'je2'
  343.                      SET COLOR TO G/N
  344.                      @ 3, 5 SAY '           补充资料项目                 '
  345.                      SET COLOR TO W/N
  346.                      @ 5, 2 CLEAR TO 22, 52
  347.                      @ 5, 56 CLEAR TO 22, 58
  348.                      @ 5, 62 CLEAR TO 22, 77
  349.                      DO WHILE .T.
  350.                           @ 4+pd,2 say &zc1
  351.                           @ 4+pd,57 say &h
  352.                           if &ncs<>0
  353.                                @ 4+pd,63 say &ncs pict'999,999,999.99'
  354.                           ENDI
  355.                           IF  .NOT. EOF()
  356.                                SKIP
  357.                                pd = pd+1
  358.                           ELSE
  359.                                EXIT
  360.                           ENDI
  361.                           IF pd=19
  362.                                EXIT
  363.                           ENDI
  364.                      ENDD
  365.                      GOTO x
  366.                      SET COLOR TO G+/B
  367.                      @ 5,2 say &zc1
  368.                      @ 5,57 say &h
  369.                      if &ncs<>0
  370.                           @ 5,63 say &ncs pict'999,999,999.99'
  371.                      ELSE
  372.                           @ 5, 63 SAY '              '
  373.                      ENDI
  374.                      pd = 1
  375.                      p = 2
  376.                 ELSE
  377.                      ?? CHR(7)
  378.                 ENDI
  379.            CASE x=27
  380.                 EXIT
  381.            OTHE
  382.                 ?? CHR(7)
  383.       ENDC
  384.  ENDD
  385.  CLOS DATABASES
  386.  SET COLOR TO W+/B
  387.  @ 0, 0, 23, 79 BOX '北北北北'
  388.  SET COLOR TO W+/N
  389.  @ 1, 1, 22, 78 BOX '鞍鞍鞍鞍鞍'
  390.  @ 23, 28 SAY '当前数据的月份:'+STR(ryear, 4, 0)+'年'+STR(ryf, 2, 0)+'月' COLOR B+/BG 
  391.  @ 24, 0 SAY ' JQ001汇总报表系统(Ver1.0)  黄朝生研制  版权所有  南宁市建政路51号  邮编:530023 ' COLOR R/W 
  392.  SET CLOCK TO 23, 69
  393.  ON KEY LABEL Escape do Rquit
  394.  RETU
  395. *