www.pudn.com > jq_caiwu.ARJ > FYJZ.PRG


 CLOS ALL 
 SET PATH TO C:\ 
 IF  .NOT. FILE('pzk.dbf') .OR.  .NOT. FILE('mxk.dbf') .OR.  .NOT. FILE('zzk.dbf') 
      ?? CHR(7) 
      @ 11, 40 SAY '凭证尚未入帐,无法结转费用!' 
      i = INKEY(0) 
      SET PATH TO \cw 
      @ 11, 40 SAY '鞍鞍鞍鞍鞍鞍鞍鞍鞍鞍鞍鞍鞍鞍' COLOR W+/N  
      RETU 
 ENDI 
 SET PATH TO \cw 
 USE pzk 
 pd = jzbz 
 USE 
 IF pd='1' 
      ?? CHR(7) 
      @ 11, 45 SAY '本月已结帐!' 
      i = INKEY(0) 
      @ 11, 45 SAY '鞍鞍鞍鞍鞍鞍鞍' COLOR W+/N  
      RETU 
 ENDI 
 USE pzk 
 LOCA ALL FOR shy='系统生成' 
 IF  .NOT. EOF() 
      SET COLOR TO W/N 
      @ 12, 42, 16, 72 BOX '鞍鞍鞍鞍鞍鞍' 
      SET COLOR TO W+/BG 
      @ 11, 40 CLEAR TO 15, 70 
      @ 11, 40 TO 15, 70 DOUBLE 
      @ 12, 46 SAY '费用已经结转!再次进行凭' 
      @ 13, 42 SAY '证输入或凭证修改时,上次的结' 
      @ 14, 42 SAY '转费用作废!' 
      i = INKEY(0) 
      USE 
      SET COLOR TO W+/N 
      @ 11, 38, 16, 72 BOX '鞍鞍鞍鞍鞍鞍鞍' 
      RETU 
 ENDI 
 USE mxk 
 LOCA ALL FOR zy='本月合计' 
 IF EOF() 
      SET COLOR TO W/N 
      @ 12, 47, 15, 72 BOX '鞍鞍鞍鞍鞍鞍' 
      SET COLOR TO W+/BG 
      @ 11, 45 CLEAR TO 14, 70 
      @ 11, 45 TO 14, 70 DOUBLE 
      @ 12, 46 SAY '凭证尚未入帐!请将凭证入' 
      @ 13, 46 SAY '入帐后再进行费用结转!' 
      i = INKEY(0) 
      SET COLOR TO W+/N 
      @ 11, 40, 15, 72 BOX '鞍鞍鞍鞍鞍鞍' 
      USE 
      RETU 
 ENDI 
 USE 
 SET COLOR TO W/N 
 @ 12, 44, 14, 72 BOX '鞍鞍鞍鞍鞍鞍' 
 SET COLOR TO W+/BG, GR+/R 
 @ 10, 42 CLEAR TO 13, 69 
 @ 10, 42 TO 13, 68 DOUBLE 
 pd = 'Y' 
 @ 11, 44 SAY '是否采用自动结转成本?' 
 @ 12, 49 SAY 'Y=是,其他=否:' GET pd PICTURE 'x' 
 READ 
 IF pd='Y' .OR. pd='y' 
      DO cbjs 
 ENDI 
 HIDE POPUP pop3 
 CLOS ALL 
 SET COLOR TO N/G 
 CLEA 
 SET COLOR TO N/W 
 @ 1, 2 CLEAR TO 23, 77 
 SET COLOR TO W/N 
 @ 11, 14 CLEAR TO 15, 69 
 SET COLOR TO N/B 
 @ 9, 10 CLEAR TO 13, 65 
 SET COLOR TO R+/B 
 @ 5, 27 SAY ' 结  转  费  用' 
 SET COLOR TO W+/B 
 ?? CHR(7) 
 @ 9, 30 SAY '注      意' 
 @ 11, 17 SAY '1. 结转费用期间,请勿中断计算机;请勿关机!' 
 @ 12, 17 SAY '2. 建议您使用不间断电源(UPS).' 
 @ 17, 30 SAY ' 请等候......' 
 COPY FILE mxk.dbf TO mxkk%%.dbf 
 USE mxkk%%.dbf 
 DELE ALL FOR zy<>'期末及累计' 
 PACK 
 SELE 1 
 USE pzk 
 SET INDEX TO pz 
 REIN 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '501' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '507' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '511' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '517' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '521' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '531' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '541' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '545' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '551' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '555' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '557' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '561' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '550' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '571' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '575' 
 DO fyjz-1 
 GOTO BOTTOM 
 pz = pzh 
 pz = pz+1 
 pd = '560' 
 DO fyjz-2 
 pd = 0 
 SELE 1 
 REPL shy WITH '系统生成', lry WITH '系统生成', ssl WITH 0, fsl WITH 0 ALL FOR zy='结转利润' 
 USE 
 SELE 2 
 USE 
 SELE 3 
 USE 
 DO pzrz 
 IF ryf=1 
      USE mxk 
      REPL jje WITH jje-dje, dje WITH 0 ALL FOR SUBSTR(kmdm, 1, 3)='322' .AND. zy='期末及累计' 
      REPL dje WITH dje-jje, jje WITH 0 ALL FOR SUBSTR(kmdm, 1, 3)='321' .AND. zy='期末及累计' 
      REPL dje WITH dje-jje, jje WITH 0 ALL FOR SUBSTR(kmdm, 1, 3)='585' .AND. zy='期末及累计' 
      USE zzk 
      REPL jje WITH jje-dje, dje WITH 0 ALL FOR SUBSTR(kmdm, 1, 3)='322' .AND. zy='期末及累计' 
      REPL dje WITH dje-jje, jje WITH 0 ALL FOR SUBSTR(kmdm, 1, 3)='321' .AND. zy='期末及累计' 
      REPL dje WITH dje-jje, jje WITH 0 ALL FOR SUBSTR(kmdm, 1, 3)='585' .AND. zy='期末及累计' 
      USE 
 ENDI 
 RETU 
*