keepc.prg

通过VFP编程的方式来统计指定数据库中的有关数据

* -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
*  文件名: KEEPC.PRG <-- 本文件由 UnFoxAll 创建
* -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


 LNSELE00 = SELECT()
 DM = IIF(TYPE('SHORTNAME') = 'C',SHORTNAME,'')
 IF TYPE('DATEEND') <> 'C'
    DATEEND0 = DATE()
    DATEEND = DTOC(DATE())
    IF DAY(DATE()) = 1
       DATEEND0 = DATE() - 1
       DATEEND = DTOC(DATE() - 1)
    ENDIF 
 ENDIF 
 WAIT WINDOW NOWAIT TIMEOUT 60 '正在进行数据计算......'
 LCDATE = DATEEND
  USEDBFYX()
 SELECT B , MODEL , STR(F1)  F1 , STR(F)  F , D , L , 1  O WHERE  ;
      (MF = ' ' .OR. CCRQ > LCDATE) AND JCRQ <= LCDATE ORDER BY 1 , 2 , 3 , 4 , 5 INTO CURSOR YXXH  ;
      FROM YX
 IF _TALLY = 0
    SELECT YX
    USE 
    SELECT YXXH
    USE 
    = MESSAGEBOX('C类商品库存数为零！    ',64,'信息')
    RETURN 
 ENDIF 
 SELECT YX
 USE 
 SELECT YXXH
 COUNT TO NN
 IF NN > 0
    SUM TO NNP L
    DATETIME = DATETIME()
    REPORT FORM 库存C类 PREVIEW NOCONSOLE
    REPORT FORM 库存C类 TO PRINTER PROMPT NOCONSOLE
 ELSE 
    = MESSAGEBOX('C类商品库存数为零！    ',64,'信息')
 ENDIF 
 USE 
 SELECT (LNSELE00)
 RETURN 
*