LOCAL
m_nian1,m_ri1,m_yue1,m_nian2,m_ri2,m_yue2,m_nianyueri1,m_nianyueri2,riqi,daozhan,chehao,chexing,minglinghao,xianghao,xiangshu,xiangxing,hunyunyuan,chehzong,i
IF EMPTY() OR EMPTY() OR EMPTY() OR EMPTY() OR EMPTY() OR EMPTY()
MESSAGEBOX("请输入要查询的日期!",40)
ELSE
m_nian1=
m_ri1=
m_yue1=
m_nian2=
m_ri2=
m_yue2=
m_nianyueri1=CTOD(m_nian1+"/"+m_yue1+"/"+m_ri1)
m_nianyueri2=CTOD(m_nian2+"/"+m_yue2+"/"+m_ri2)
SELECT 加固统计查询
DELETE all
PACK
SELECT 空箱加固库
GO top
i=1
DO WHILE NOT EOF()
IF 日期>=m_nianyueri1 AND 日期<m_nianyueri2
riqi=日期
daozhan=到站
minglinghao=命令号
chexing=车型
chehao=车号
xainghao=箱号1+"、"+箱号2
xiangshu=箱属
xiangxing=箱型
huoyunyuan=货运员
chezhong=车种
select 加固统计查询
appe blank
repl 序号 WITH i
*,车号 WITH chehao,车型 WITH chexing,车种 WITH chezhong,到站 WITH daozhan,货运员 WITH huoyunyuan,命令号 WITH mingling,日期 WITH riqi,箱号 WITH xianghao,箱属 WITH xiangshu,箱型 WITH xiangxing
ENDIF
thisform.Release
use 空箱加固库
SKIP 1
i=i+1
enddo
MESSAGEBOX("请输入要查询的日期!",40)
ENDIF