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

企业管理

开发平台:

VFP

  1.  SET PATH TO C:
  2.  IF  .NOT. FILE('pzk.dbf') .OR.  .NOT. FILE('mxk.dbf') .OR.  .NOT. FILE('zzk.dbf')
  3.       ?? CHR(7)
  4.       SET COLOR TO
  5.       @ 8, 22 CLEAR TO 11, 62
  6.       SET COLOR TO RB+/B
  7.       @ 7, 20 CLEAR TO 10, 60
  8.       @ 8, 29 SAY '当前月工作区没有数据!'
  9.       i = INKEY(0)
  10.       SET PATH TO cw
  11.       RETU
  12.  ENDI
  13.  SET PATH TO cw
  14.  DO WHILE .T.
  15.       pd = 1
  16.       SET COLOR TO
  17.       @ 3, 40 CLEAR TO 13, 58
  18.       SET COLOR TO N/BG
  19.       @ 2, 37 CLEAR TO 11, 52
  20.       SET COLOR TO W/BG
  21.       x1 = 2
  22.       x2 = 11
  23.       y1 = 37
  24.       y2 = 53
  25.       DO box-1
  26.       SET COLOR TO W/B, W+/R
  27.       @ 3, 40 PROMPT '返        回'
  28.       @ 4, 40 PROMPT '报表自动生成'
  29.       @ 5, 40 PROMPT '报表打印输出'
  30.       @ 6, 40 PROMPT '系统报表查询'
  31.       @ 7, 40 PROMPT '删除无效报表'
  32.       MENU TO pd
  33.       SET COLOR TO
  34.       DO CASE
  35.            CASE pd=1 .OR. pd=0
  36.                 EXIT
  37.            CASE pd=2
  38.                 DO WHILE .T.
  39.                      SET COLOR TO
  40.                      @ 5, 42 CLEAR TO 15, 60
  41.                      SET COLOR TO W/G
  42.                      @ 4, 40 CLEAR TO 14, 58
  43.                      x1 = 4
  44.                      x2 = 14
  45.                      y1 = 42
  46.                      y2 = 56
  47.                      DO box-1
  48.                      pd = 1
  49.                      SET COLOR TO GR+/G
  50.                      @ 5, 45 SAY '报表生成器'
  51.                      SET COLOR TO W/B, W+/R
  52.                      @ 7, 45 PROMPT '返      回'
  53.                      @ 8, 45 PROMPT '资产负债表'
  54.                      @ 9, 45 PROMPT '损  益  表'
  55.                      @ 10, 45 PROMPT '补充资料表'
  56.                      @ 11, 45 PROMPT '应交款项表'
  57.                      @ 12, 45 PROMPT '增值税报表'
  58.                      MENU TO pd
  59.                      DO CASE
  60.                           CASE pd=1 .OR. pd=0
  61.                                SET COLOR TO N/W
  62.                                @ 5, 40 CLEAR TO 15, 60
  63.                                EXIT
  64.                           CASE pd=2
  65.                                SET PATH TO C:
  66.                                IF FILE('fzb.dbf')
  67.                                     ?? CHR(7)
  68.                                     SET COLOR TO
  69.                                     @ 5, 8 CLEAR TO 10, 35
  70.                                     SET COLOR TO W+/B
  71.                                     @ 4, 5 CLEAR TO 9, 33
  72.                                     x1 = 4
  73.                                     x2 = 9
  74.                                     y1 = 5
  75.                                     y2 = 31
  76.                                     DO box-1
  77.                                     @ 6, 9 SAY '资产负债表已经存在!'
  78.                                     @ 7, 9 SAY '按任意键继续......'
  79.                                     i = INKEY(0)
  80.                                     SET PATH TO cw
  81.                                ELSE
  82.                                     SET PATH TO cw   
  83.                                     SET COLOR TO
  84.                                     @ 5, 8 CLEAR TO 10, 35
  85.                                     SET COLOR TO W+/B
  86.                                     @ 4, 5 CLEAR TO 9, 33
  87.                                     x1 = 4
  88.                                     x2 = 9
  89.                                     y1 = 5
  90.                                     y2 = 31
  91.                                     DO box-1
  92.                                     @ 6, 9 SAY '正在生成资产负债表!'
  93.                                     @ 7, 13 SAY '请稍候......'
  94.                                     RUN copy cwfzb.dbf>nul
  95.                                     DO fzb
  96.                                ENDI
  97.                           CASE pd=3
  98.                                SET PATH TO C:
  99.                                IF FILE('syb.dbf')
  100.                                     ?? CHR(7)
  101.                                     SET COLOR TO
  102.                                     @ 5, 8 CLEAR TO 10, 35
  103.                                     SET COLOR TO W+/B
  104.                                     @ 4, 5 CLEAR TO 9, 33
  105.                                     x1 = 4
  106.                                     x2 = 9
  107.                                     y1 = 5
  108.                                     y2 = 31
  109.                                     DO box-1
  110.                                     @ 6, 9 SAY '损  益  表已经存在!'
  111.                                     @ 7, 9 SAY '按任意键继续......'
  112.                                     i = INKEY(0)
  113.                                     SET PATH TO cw
  114.                                ELSE
  115.                                     SET PATH TO cw
  116.                                     SET COLOR TO
  117.                                     @ 5, 8 CLEAR TO 10, 35
  118.                                     SET COLOR TO W+/B
  119.                                     @ 4, 5 CLEAR TO 9, 33
  120.                                     x1 = 4
  121.                                     x2 = 9
  122.                                     y1 = 5
  123.                                     y2 = 31
  124.                                     DO box-1
  125.                                     @ 6, 9 SAY '正在生成损  益  表!'
  126.                                     @ 7, 13 SAY '请稍候......'
  127.                                     RUN copy cwsyb.dbf>nul
  128.                                     DO syb
  129.                                ENDI
  130.                           CASE pd=4
  131.                                SET PATH TO C:
  132.                                IF FILE('bcmxb.dbf')
  133.                                     ?? CHR(7)
  134.                                     SET COLOR TO
  135.                                     @ 5, 8 CLEAR TO 10, 35
  136.                                     SET COLOR TO W+/B
  137.                                     @ 4, 5 CLEAR TO 9, 33
  138.                                     x1 = 4
  139.                                     x2 = 9
  140.                                     y1 = 5
  141.                                     y2 = 31
  142.                                     DO box-1
  143.                                     @ 6, 9 SAY '补充资料表已经存在!'
  144.                                     @ 7, 9 SAY '按任意键继续......'
  145.                                     i = INKEY(0)
  146.                                     SET PATH TO cw
  147.                                ELSE
  148.                                     SET PATH TO cw
  149.                                     SET COLOR TO
  150.                                     @ 5, 8 CLEAR TO 10, 35
  151.                                     SET COLOR TO W+/B
  152.                                     @ 4, 5 CLEAR TO 9, 33
  153.                                     x1 = 4
  154.                                     x2 = 9
  155.                                     y1 = 5
  156.                                     y2 = 31
  157.                                     DO box-1
  158.                                     @ 6, 9 SAY '正在生成补充资料表!'
  159.                                     @ 7, 13 SAY '请稍候......'
  160.                                     RUN copy cwbcmxb.dbf>nul
  161.                                     DO bcmxb
  162.                                ENDI
  163.                           CASE pd=5
  164.                                SET PATH TO C:
  165.                                IF FILE('yjkb.dbf')
  166.                                     ?? CHR(7)
  167.                                     SET COLOR TO
  168.                                     @ 5, 8 CLEAR TO 10, 35
  169.                                     SET COLOR TO W+/B
  170.                                     @ 4, 5 CLEAR TO 9, 33
  171.                                     x1 = 4
  172.                                     x2 = 9
  173.                                     y1 = 5
  174.                                     y2 = 31
  175.                                     DO box-1
  176.                                     @ 6, 9 SAY '应交款项表已经存在!'
  177.                                     @ 7, 9 SAY '按任意键继续......'
  178.                                     i = INKEY(0)
  179.                                     SET PATH TO cw
  180.                                ELSE
  181.                                     SET PATH TO cw
  182.                                     SET COLOR TO
  183.                                     @ 5, 8 CLEAR TO 10, 35
  184.                                     SET COLOR TO W+/B
  185.                                     @ 4, 5 CLEAR TO 9, 33
  186.                                     x1 = 4
  187.                                     x2 = 9
  188.                                     y1 = 5
  189.                                     y2 = 31
  190.                                     DO box-1
  191.                                     @ 6, 9 SAY '正在生成应交款项表!'
  192.                                     @ 7, 13 SAY '请稍候......'
  193.                                     RUN copy cwyjkb.dbf>nul
  194.                                     DO yjkb
  195.                                ENDI
  196.                           CASE pd=6
  197.                                SET PATH TO C:
  198.                                IF FILE('zzsb.dbf')
  199.                                     ?? CHR(7)
  200.                                     SET COLOR TO
  201.                                     @ 5, 8 CLEAR TO 10, 35
  202.                                     SET COLOR TO W+/B
  203.                                     @ 4, 5 CLEAR TO 9, 33
  204.                                     x1 = 4
  205.                                     x2 = 9
  206.                                     y1 = 5
  207.                                     y2 = 31
  208.                                     DO box-1
  209.                                     @ 6, 9 SAY '增值税报表已经存在!'
  210.                                     @ 7, 9 SAY '按任意键继续......'
  211.                                     i = INKEY(0)
  212.                                     SET PATH TO cw
  213.                                ELSE
  214.                                     SET PATH TO cw
  215.                                     SET COLOR TO
  216.                                     @ 5, 8 CLEAR TO 10, 35
  217.                                     SET COLOR TO W+/B
  218.                                     @ 4, 5 CLEAR TO 9, 33
  219.                                     x1 = 4
  220.                                     x2 = 9
  221.                                     y1 = 5
  222.                                     y2 = 31
  223.                                     DO box-1
  224.                                     @ 6, 9 SAY '正在生成增值税报表!'
  225.                                     @ 7, 13 SAY '请稍候......'
  226.                                     RUN copy cwzzsb.dbf>nul
  227.                                     DO zzsb
  228.                                ENDI
  229.                      ENDC
  230.                      SET COLOR TO N/W
  231.                      @ 3, 3 CLEAR TO 10, 35
  232.                 ENDD
  233.            CASE pd=3
  234.                 DO WHILE .T.
  235.                      SET COLOR TO
  236.                      @ 5, 42 CLEAR TO 15, 60
  237.                      SET COLOR TO W/G
  238.                      @ 4, 40 CLEAR TO 14, 58
  239.                      x1 = 4
  240.                      x2 = 14
  241.                      y1 = 42
  242.                      y2 = 56
  243.                      DO box-1
  244.                      pd = 1
  245.                      SET COLOR TO GR+/G
  246.                      @ 5, 46 SAY '报表打印'
  247.                      SET COLOR TO W/B, W+/R
  248.                      @ 7, 45 PROMPT '返      回'
  249.                      @ 8, 45 PROMPT '资产负债表'
  250.                      @ 9, 45 PROMPT '损  益  表'
  251.                      @ 10, 45 PROMPT '补充资料表'
  252.                      @ 11, 45 PROMPT '应交款项表'
  253.                      MENU TO pd
  254.                      DO CASE
  255.                           CASE pd=1 .OR. pd=0
  256.                                SET COLOR TO N/W
  257.                                @ 5, 40 CLEAR TO 15, 60
  258.                                EXIT
  259.                           CASE pd=2
  260.                                SET PATH TO C:
  261.                                IF  .NOT. FILE('fzb.dbf')
  262.                                     ?? CHR(7)
  263.                                     SET COLOR TO
  264.                                     @ 5, 8 CLEAR TO 10, 35
  265.                                     SET COLOR TO W+/B
  266.                                     @ 4, 5 CLEAR TO 9, 33
  267.                                     x1 = 4
  268.                                     x2 = 9
  269.                                     y1 = 5
  270.                                     y2 = 31
  271.                                     DO box-1
  272.                                     @ 6, 9 SAY '资产负债表不存在!'
  273.                                     @ 7, 9 SAY '按任意键继续......'
  274.                                     i = INKEY(0)
  275.                                     SET PATH TO cw
  276.                                     SET COLOR TO N/W
  277.                                     @ 3, 3 CLEAR TO 10, 35
  278.                                ELSE
  279.                                     SET PATH TO cw
  280.                                     USE fzb
  281.                                     DO fzbdy
  282.                                     SET COLOR TO N/W
  283.                                     @ 3, 3 CLEAR TO 10, 35
  284.                                ENDI
  285.                           CASE pd=3
  286.                                SET PATH TO C:
  287.                                IF  .NOT. FILE('syb.dbf')
  288.                                     ?? CHR(7)
  289.                                     SET COLOR TO
  290.                                     @ 5, 8 CLEAR TO 10, 35
  291.                                     SET COLOR TO W+/B
  292.                                     @ 4, 5 CLEAR TO 9, 33
  293.                                     x1 = 4
  294.                                     x2 = 9
  295.                                     y1 = 5
  296.                                     y2 = 31
  297.                                     DO box-1
  298.                                     @ 6, 9 SAY '损  益  表不存在!'
  299.                                     @ 7, 9 SAY '按任意键继续......'
  300.                                     i = INKEY(0)
  301.                                     SET PATH TO cw
  302.                                     SET COLOR TO N/W
  303.                                     @ 3, 3 CLEAR TO 10, 35
  304.                                ELSE
  305.                                     SET PATH TO cw
  306.                                     USE syb
  307.                                     DO sybdy
  308.                                     SET COLOR TO N/W
  309.                                     @ 3, 3 CLEAR TO 10, 35
  310.                                ENDI
  311.                           CASE pd=4
  312.                                SET PATH TO C:
  313.                                IF  .NOT. FILE('bcmxb.dbf')
  314.                                     ?? CHR(7)
  315.                                     SET COLOR TO
  316.                                     @ 5, 8 CLEAR TO 10, 35
  317.                                     SET COLOR TO W+/B
  318.                                     @ 4, 5 CLEAR TO 9, 33
  319.                                     x1 = 4
  320.                                     x2 = 9
  321.                                     y1 = 5
  322.                                     y2 = 31
  323.                                     DO box-1
  324.                                     @ 6, 9 SAY '补充资料表不存在!'
  325.                                     @ 7, 9 SAY '按任意键继续......'
  326.                                     i = INKEY(0)
  327.                                     SET PATH TO cw
  328.                                     SET COLOR TO N/W
  329.                                     @ 3, 3 CLEAR TO 10, 35
  330.                                ELSE
  331.                                     SET PATH TO cw
  332.                                     USE bcmxb
  333.                                     DO bcmxbdy
  334.                                     SET COLOR TO N/W
  335.                                     @ 3, 3 CLEAR TO 10, 35
  336.                                ENDI
  337.                           CASE pd=5
  338.                                SET PATH TO C:
  339.                                IF  .NOT. FILE('yjkb.dbf') .OR.  .NOT. FILE('zzsb.dbf')
  340.                                     ?? CHR(7)
  341.                                     SET COLOR TO
  342.                                     @ 5, 8 CLEAR TO 10, 35
  343.                                     SET COLOR TO W+/B
  344.                                     @ 4, 5 CLEAR TO 9, 33
  345.                                     x1 = 4
  346.                                     x2 = 9
  347.                                     y1 = 5
  348.                                     y2 = 31
  349.                                     DO box-1
  350.                                     @ 6, 7 SAY '应交款或增值税表不存在!'
  351.                                     @ 7, 9 SAY '按任意键继续......'
  352.                                     i = INKEY(0)
  353.                                     SET PATH TO cw
  354.                                     SET COLOR TO N/W
  355.                                     @ 3, 3 CLEAR TO 10, 35
  356.                                ELSE
  357.                                     SET PATH TO cw
  358.                                     wj1 = 'yjkb'
  359.                                     wj2 = 'zzsb'
  360.                                     DO yjkbdy
  361.                                     SET COLOR TO N/W
  362.                                     @ 3, 3 CLEAR TO 10, 35
  363.                                ENDI
  364.                      ENDC
  365.                      USE
  366.                 ENDD
  367.            CASE pd=4
  368.                 DO WHILE .T.
  369.                      SET COLOR TO
  370.                      @ 5, 42 CLEAR TO 15, 60
  371.                      SET COLOR TO W/G
  372.                      @ 4, 40 CLEAR TO 14, 58
  373.                      x1 = 4
  374.                      x2 = 14
  375.                      y1 = 42
  376.                      y2 = 56
  377.                      DO box-1
  378.                      pd = 1
  379.                      SET COLOR TO GR+/G
  380.                      @ 5, 46 SAY '报表查询'
  381.                      SET COLOR TO W/B, W+/R
  382.                      @ 7, 45 PROMPT '返      回'
  383.                      @ 8, 45 PROMPT '资产负债表'
  384.                      @ 9, 45 PROMPT '损  益  表'
  385.                      @ 10, 45 PROMPT '补充资料表'
  386.                      @ 11, 45 PROMPT '应交款项表'
  387.                      @ 12, 45 PROMPT '增值税报表'
  388.                      MENU TO pd
  389.                      DO CASE
  390.                           CASE pd=1
  391.                                SET COLOR TO N/W
  392.                                @ 4, 38 CLEAR TO 15, 60
  393.                                EXIT
  394.                           CASE pd=2
  395.                                USE fzb
  396.                                DO fzbcx
  397.                                USE
  398.                                DO zcd
  399.                           CASE pd=3
  400.                                USE syb
  401.                                DO sybcx
  402.                                USE
  403.                                DO zcd
  404.                           CASE pd=4
  405.                                USE bcmxb
  406.                                DO bcmxbcx
  407.                                USE
  408.                                DO zcd
  409.                           CASE pd=5
  410.                                USE yjkb
  411.                                DO yjkbcx
  412.                                USE
  413.                                DO zcd
  414.                           CASE pd=6
  415.                                USE zzsb
  416.                                DO zzsbcx
  417.                                USE
  418.                                DO zcd
  419.                      ENDC
  420.                      SET COLOR TO
  421.                      @ 3, 40 CLEAR TO 13, 58
  422.                      SET COLOR TO N/BG
  423.                      @ 2, 37 CLEAR TO 11, 52
  424.                      SET COLOR TO W/BG
  425.                      x1 = 2
  426.                      x2 = 11
  427.                      y1 = 37
  428.                      y2 = 53
  429.                      DO box-1
  430.                      SET COLOR TO W/B, W+/R
  431.                      @ 3, 40 SAY '返        回'
  432.                      @ 4, 40 SAY '报表自动生成'
  433.                      @ 5, 40 SAY '报表打印输出'
  434.                      @ 6, 40 SAY '系统报表查询'
  435.                      @ 7, 40 SAY '删除无效报表'
  436.                 ENDD
  437.            CASE pd=5
  438.                 DO scbb
  439.            CASE pd=6
  440.                 DO zcd
  441.       ENDC
  442.  ENDD
  443.  RETU
  444. *