B的配置文件
SELECT TOP 10
Cstr(ID) AS SJZ_KZ4,
TaskID AS SCRWBH,
TaskInf0 AS GCMC,
TaskInf6 AS GCBW,
ClassType AS QDDJ,
Format(iTime,'yyyy-MM-dd HH:mm:ss') AS SCSJ,
Format(iTime,'yyyy-MM-dd HH:mm:ss') AS JBSJ,
Format(iTime,'yyyy-MM-dd HH:mm:ss') AS CLSJ,
iif((TruckID IS NOT NULL AND TruckID<>''),TruckID,'0') AS CPBH,
FullMix AS JBSC,
Cubes AS SHEJFL,
S1 AS SHEJZ_GL1,
S2 AS SHEJZ_GL2,
S3 AS SHEJZ_GL3,
S4 AS SHEJZ_GL4,
S5 AS SHEJZ_GL5,
S12+S13+S14 AS SHEJZ_KF,
S16+S17 AS SHEJZ_FMH,
S22 AS SHEJZ_S,
S23 AS SHEJZ_WJJ1,
Cubes AS SJFL,
A1 AS SJZ_GL1,
A2 AS SJZ_GL2,
A3 AS SJZ_GL3,
A4 AS SJZ_GL4,
A5 AS SJZ_GL5,
A12+A13+A14 AS SJZ_KF,
A16+A17 AS SJZ_FMH,
A22 AS SJZ_S,
A23 AS SJZ_WJJ1
FROM
Act
WHERE CDate(iTime)>CDate('@time')
AND A22>0
AND (A1>0 OR A2>0 OR A3>0 OR A4>0 OR A5>0)
AND (A6>0 OR A7>0 OR A8>0 OR A9>0 OR A10>0 OR A11>0 OR A15>0)
ORDER BY CDate(iTime);
SELECT A.* FROM(
SELECT ID,'AAA'AS glname,Cstr(S6) AS shejz,Cstr(A6) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'AAA'AS glname,Cstr(S7) AS shejz,Cstr(A7) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'AAA'AS glname,Cstr(S8) AS shejz,Cstr(A8) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'AAA'AS glname,Cstr(S9) AS shejz,Cstr(A9) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'AAA'AS glname,Cstr(S10) AS shejz,Cstr(A10) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'AAA'AS glname,Cstr(S11) AS shejz,Cstr(A11) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'AAA'AS glname,Cstr(S15) AS shejz,Cstr(A15) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'BBB'AS glname,Cstr(S23) AS shejz,Cstr(A23) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'BBB'AS glname,Cstr(S24) AS shejz,Cstr(A24) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'BBB'AS glname,Cstr(S25) AS shejz,Cstr(A25) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'BBB'AS glname,Cstr(S26) AS shejz,Cstr(A26) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'BBB'AS glname,Cstr(S27) AS shejz,Cstr(A27) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
UNION ALL
SELECT ID,'BBB'AS glname,Cstr(S28) AS shejz,Cstr(A28) AS sjz FROM Act WHERE cstr(ID) IN('{0}')
) A WHERE A.sjz>0
