|
版本: |
BeX5V3.5 |
小版本号: |
|
|
|
数据库: |
Oracle |
服务器操作系统: |
|
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
Chrome |
|
|
本帖最后由 jzy1993 于 2017-12-7 10:03 编辑
使用SQL.select执行SQL,只能查出ID列,其他列查不到,报编码: JUSTEP150137; 提示: 列"fType"不存在错误。sql在Navicat中可正常执行可以查出结果
附SQL:
SELECT
*
FROM
(
SELECT
HEC_ProductNonconformity.FID FID1,
'产品不符合项' AS fType,
HEC_ProductNonconformity.fDisposalSheetNum AS fDisposalSheetNum,
HEC_ProductNonconformity.fFillInTime AS fFillInTime,
HEC_ProductNonconformity.fOccDept AS fOccDept,
HEC_ProductNonconformity.fWorkNumber AS fWorkNumber,
HEC_ProductNonconformity.fCoverNumber AS fCoverNumber,
HEC_ProductNonconformity.fMaterialCode AS fMaterialCode,
HEC_ProductNonconformity.fMaterialName AS fMaterialName,
HEC_ProductNonconformity.fFigureNo AS fFigureNo,
HEC_ProductNonconformity.fPhysicalExaNum AS fPhysicalExaNum,
HEC_ProductNonconformity.fDescribe AS fDescribe,
HEC_ProductNonconformity.fClassAManagement AS fClassAManagement,
HEC_ProductNonconformity.fOneLevelReviewPerson AS fOneLevelReviewPerson,
HEC_ProductNonconformity.fPrimaryDesignReviewMan AS fPrimaryDesignReviewMan,
HEC_ProductNonconformity.fPrimaryDesignReviewPerson AS fPrimaryDesignReviewPerson,
HEC_ProductNonconformity.fTwoJudgeMan AS fTwoJudgeMan,
HEC_ProductNonconformity.fTwoJudge AS fTwoJudge,
HEC_ProductNonconformity.fThreeJudgeMan AS fThreeJudgeMan,
HEC_ProductNonconformity.fThreeJudge AS fThreeJudge,
HEC_ProductNonconformity.fOtherCostTotal AS fOtherCostTotal,
HEC_ProductNonconformity.fDisposalResult AS fDisposalResult,
HEC_ReworkScrapDept.FID FID2,
HEC_ReworkScrapDept.fRepairDept AS fRepairDept,
HEC_ReworkScrapDept.fRepairDeptInsTeam AS fRepairDeptInsTeam,
HEC_ReworkScrapDept.fResultValidation AS fResultValidation,
HEC_ReworkScrapDept.fConfirmingPerson AS fConfirmingPerson,
HEC_ReworkScrapDept.fConfirmationTime AS fConfirmationTime,
HEC_ResUnitInformation.FID FID3,
HEC_ResUnitInformation.fResponsibilityUnit AS fResponsibilityUnit,
HEC_ResUnitInformation.fResponsibilityProportion AS fResponsibilityProportion,
HEC_ResUnitInformation.fPersonLiable AS fPersonLiable,
HEC_ResUnitInformation.fApprovedState AS fApprovedState,
HEC_ResUnitInformation.fRootCauseAnalysis AS fRootCauseAnalysis,
HEC_ResUnitInformation.fCorrAndPreveActions AS fCorrAndPreveActions,
HEC_ResUnitInformation.fClassProductNonconformity1 AS fClassProductNonconformity1,
HEC_ResUnitInformation.fClassProductNonconformity2 AS fClassProductNonconformity2,
HEC_ResUnitInformation.fClassProductNonconformity3 AS fClassProductNonconformity3,
HEC_ResponsibleSupplier.FID FID4,
HEC_ResponsibleSupplier.fResponsibleSupplier AS fResponsibleSupplier
FROM
HEC_ProductNonconformity HEC_ProductNonconformity
LEFT JOIN HEC_ReworkScrapDept HEC_ReworkScrapDept ON HEC_ProductNonconformity.FID = HEC_ReworkScrapDept.fMasterID
LEFT JOIN HEC_ResUnitInformation HEC_ResUnitInformation ON HEC_ProductNonconformity.FID = HEC_ResUnitInformation.fMasterID
LEFT JOIN HEC_ResponsibleSupplier HEC_ResponsibleSupplier ON HEC_ProductNonconformity.FID = HEC_ResponsibleSupplier.fMasterID
UNION ALL
SELECT
HEC_CalibrationMaterial.FID FID1,
'脱标材料不符合项' AS fType,
HEC_CalibrationMaterial.fDisposalSheetNum AS fDisposalSheetNum,
HEC_CalibrationMaterial.fFillInTime AS fFillInTime,
HEC_CalibrationMaterial.fOccDept AS fOccDept,
HEC_CalibrationMaterial.fWorkNumber AS fWorkNumber,
HEC_CalibrationMaterial.fCoverNumber AS fCoverNumber,
HEC_CalibrationMaterial.fMaterialCode AS fMaterialCode,
HEC_CalibrationMaterial.fMaterialName AS fMaterialName,
HEC_CalibrationMaterial.fFigureNo AS fFigureNo,
HEC_CalibrationMaterial.fPhysicalExaNum AS fPhysicalExaNum,
HEC_CalibrationMaterial.fDescribe AS fDescribe,
HEC_CalibrationMaterial.fClassAManagement AS fClassAManagement,
HEC_CalibrationMaterial.fOneLevelReviewPerson AS fOneLevelReviewPerson,
HEC_CalibrationMaterial.fPrimaryDesignReviewMan AS fPrimaryDesignReviewMan,
HEC_CalibrationMaterial.fPrimaryDesignReviewPerson AS fPrimaryDesignReviewPerson,
HEC_CalibrationMaterial.fTwoJudgeMan AS fTwoJudgeMan,
HEC_CalibrationMaterial.fTwoJudge AS fTwoJudge,
HEC_CalibrationMaterial.fThreeJudgeMan AS fThreeJudgeMan,
HEC_CalibrationMaterial.fThreeJudge AS fThreeJudge,
HEC_CalibrationMaterial.fOtherCostTotal AS fOtherCostTotal,
HEC_CalibrationMaterial.fDisposalResult AS fDisposalResult,
HEC_ReworkScrapDept.FID FID2,
HEC_ReworkScrapDept.fRepairDept AS fRepairDept,
HEC_ReworkScrapDept.fRepairDeptInsTeam AS fRepairDeptInsTeam,
HEC_ReworkScrapDept.fResultValidation AS fResultValidation,
HEC_ReworkScrapDept.fConfirmingPerson AS fConfirmingPerson,
HEC_ReworkScrapDept.fConfirmationTime AS fConfirmationTime,
HEC_ResUnitInformation.FID FID3,
HEC_ResUnitInformation.fResponsibilityUnit AS fResponsibilityUnit,
HEC_ResUnitInformation.fResponsibilityProportion AS fResponsibilityProportion,
HEC_ResUnitInformation.fPersonLiable AS fPersonLiable,
HEC_ResUnitInformation.fApprovedState AS fApprovedState,
HEC_ResUnitInformation.fRootCauseAnalysis AS fRootCauseAnalysis,
HEC_ResUnitInformation.fCorrAndPreveActions AS fCorrAndPreveActions,
HEC_ResUnitInformation.fClassProductNonconformity1 AS fClassProductNonconformity1,
HEC_ResUnitInformation.fClassProductNonconformity2 AS fClassProductNonconformity2,
HEC_ResUnitInformation.fClassProductNonconformity3 AS fClassProductNonconformity3,
HEC_ResponsibleSupplier.FID FID4,
HEC_ResponsibleSupplier.fResponsibleSupplier AS fResponsibleSupplier
FROM
HEC_CalibrationMaterial HEC_CalibrationMaterial
LEFT JOIN HEC_ReworkScrapDept HEC_ReworkScrapDept ON HEC_CalibrationMaterial.FID = HEC_ReworkScrapDept.fMasterID
LEFT JOIN HEC_ResUnitInformation HEC_ResUnitInformation ON HEC_CalibrationMaterial.FID = HEC_ResUnitInformation.fMasterID
LEFT JOIN HEC_ResponsibleSupplier HEC_ResponsibleSupplier ON HEC_CalibrationMaterial.FID = HEC_ResponsibleSupplier.fMasterID
UNION ALL
SELECT
HEC_SupplierBiasNonconformity.FID FID1,
'供方偏差不符合项' AS fType,
HEC_SupplierBiasNonconformity.fDisposalSheetNum AS fDisposalSheetNum,
HEC_SupplierBiasNonconformity.fFillInTime AS fFillInTime,
HEC_SupplierBiasNonconformity.fOccDept AS fOccDept,
HEC_SupplierBiasNonconformity.fWorkNumber AS fWorkNumber,
HEC_SupplierBiasNonconformity.fCoverNumber AS fCoverNumber,
HEC_SupplierBiasNonconformity.fMaterialCode AS fMaterialCode,
HEC_SupplierBiasNonconformity.fDrawName AS fMaterialName,
HEC_SupplierBiasNonconformity.fFigureNo AS fFigureNo,
HEC_SupplierBiasNonconformity.fPhysicalExaNum AS fPhysicalExaNum,
HEC_SupplierBiasNonconformity.fNonconformityDescribe AS fDescribe,
HEC_SupplierBiasNonconformity.fClassAManagement AS fClassAManagement,
HEC_SupplierBiasNonconformity.fOneLevelReviewPerson AS fOneLevelReviewPerson,
HEC_SupplierBiasNonconformity.fPrimaryDesignReviewMan AS fPrimaryDesignReviewMan,
HEC_SupplierBiasNonconformity.fPrimaryDesignReviewPerson AS fPrimaryDesignReviewPerson,
HEC_SupplierBiasNonconformity.fTwoJudgeMan AS fTwoJudgeMan,
HEC_SupplierBiasNonconformity.fTwoJudge AS fTwoJudge,
HEC_SupplierBiasNonconformity.fThreeJudgeMan AS fThreeJudgeMan,
HEC_SupplierBiasNonconformity.fThreeJudge AS fThreeJudge,
HEC_SupplierBiasNonconformity.fOtherCostTotal AS fOtherCostTotal,
HEC_SupplierBiasNonconformity.fDisposalResult AS fDisposalResult,
HEC_SupplierReworkScrapDept.FID FID2,
HEC_SupplierReworkScrapDept.fRepairDept AS fRepairDept,
HEC_SupplierReworkScrapDept.fRepairDeptInsTeam AS fRepairDeptInsTeam,
HEC_SupplierReworkScrapDept.fResultValidation AS fResultValidation,
HEC_SupplierReworkScrapDept.fConfirmingPerson AS fConfirmingPerson,
HEC_SupplierReworkScrapDept.fConfirmationTime AS fConfirmationTime,
HEC_SupplierResUnitInformation.FID FID3,
HEC_SupplierResUnitInformation.fResponsibilityUnit AS fResponsibilityUnit,
HEC_SupplierResUnitInformation.fResponsibilityProportion AS fResponsibilityProportion,
HEC_SupplierResUnitInformation.fPersonLiable AS fPersonLiable,
HEC_SupplierResUnitInformation.fApprovedState AS fApprovedState,
HEC_SupplierResUnitInformation.fRootCauseAnalysis AS fRootCauseAnalysis,
HEC_SupplierResUnitInformation.fCorrAndPreveActions AS fCorrAndPreveActions,
HEC_SupplierResUnitInformation.fClassProductNonconformity1 AS fClassProductNonconformity1,
HEC_SupplierResUnitInformation.fClassProductNonconformity2 AS fClassProductNonconformity2,
HEC_SupplierResUnitInformation.fClassProductNonconformity3 AS fClassProductNonconformity3,
HEC_SupplierResponsible.FID FID4,
HEC_SupplierResponsible.fResponsibleSupplier AS fResponsibleSupplier
FROM
HEC_SupplierBiasNonconformity HEC_SupplierBiasNonconformity
LEFT JOIN HEC_SupplierReworkScrapDept HEC_SupplierReworkScrapDept ON HEC_SupplierBiasNonconformity.FID = HEC_SupplierReworkScrapDept.fMasterID
LEFT JOIN HEC_SupplierResUnitInformation HEC_SupplierResUnitInformation ON HEC_SupplierBiasNonconformity.FID = HEC_SupplierResUnitInformation.fMasterID
LEFT JOIN HEC_SupplierResponsible HEC_SupplierResponsible ON HEC_SupplierBiasNonconformity.FID = HEC_SupplierResponsible.fMasterID
UNION ALL
SELECT
HEC_SiteNonconformity.FID FID1,
'工地不符合项' AS fType,
HEC_SiteNonconformity.fDisposalSheetNum AS fDisposalSheetNum,
HEC_SiteNonconformity.fOccTime AS fFillInTime,
HEC_SiteNonconformity.fElecStation AS fOccDept,
HEC_SiteNonconformity.fWorkNumber AS fWorkNumber,
HEC_SiteNonconformity.fCoverNumber AS fCoverNumber,
HEC_SiteNonconformity.fMaterialCode AS fMaterialCode,
HEC_SiteNonconformity.fMaterialName AS fMaterialName,
HEC_SiteNonconformity.fFigureNo AS fFigureNo,
HEC_SiteNonconformity.fPhysicalExaNum AS fPhysicalExaNum,
HEC_SiteNonconformity.fNonconformityDescribe AS fDescribe,
HEC_SiteNonconformity.fClassAManagement AS fClassAManagement,
HEC_SiteNonconformity.fOneLevelReviewPerson AS fOneLevelReviewPerson,
HEC_SiteNonconformity.fPrimaryDesignReviewMan AS fPrimaryDesignReviewMan,
HEC_SiteNonconformity.fPrimaryDesignReviewPerson AS fPrimaryDesignReviewPerson,
HEC_SiteNonconformity.fTwoJudgeMan AS fTwoJudgeMan,
HEC_SiteNonconformity.fTwoJudge AS fTwoJudge,
HEC_SiteNonconformity.fThreeJudgeMan AS fThreeJudgeMan,
HEC_SiteNonconformity.fThreeJudge AS fThreeJudge,
'N/A' AS fOtherCostTotal,
HEC_SiteNonconformity.fDisposalResult AS fDisposalResult,
HEC_SiteReworkScrapDept.FID FID2,
HEC_SiteReworkScrapDept.FREPAIRDEPT AS fRepairDept,
HEC_SiteReworkScrapDept.fRepairDeptInsTeam AS fRepairDeptInsTeam,
HEC_SiteReworkScrapDept.fResultValidation AS fResultValidation,
HEC_SiteReworkScrapDept.fConfirmingPerson AS fConfirmingPerson,
HEC_SiteReworkScrapDept.fConfirmationTime AS fConfirmationTime,
HEC_SiteResUnitInformation.FID FID3,
HEC_SiteResUnitInformation.fResponsibilityUnit AS fResponsibilityUnit,
HEC_SiteResUnitInformation.fResponsibilityProportion AS fResponsibilityProportion,
HEC_SiteResUnitInformation.fPersonLiable AS fPersonLiable,
HEC_SiteResUnitInformation.fApprovedState AS fApprovedState,
HEC_SiteResUnitInformation.fRootCauseAnalysis AS fRootCauseAnalysis,
HEC_SiteResUnitInformation.fCorrAndPreveActions AS fCorrAndPreveActions,
HEC_SiteResUnitInformation.fClassProductNonconformity1 AS fClassProductNonconformity1,
HEC_SiteResUnitInformation.fClassProductNonconformity2 AS fClassProductNonconformity2,
HEC_SiteResUnitInformation.fClassProductNonconformity3 AS fClassProductNonconformity3,
HEC_SiteResponsible.FID FID4,
HEC_SiteResponsible.fResponsibleSupplier AS fResponsibleSupplier
FROM
HEC_SiteNonconformity HEC_SiteNonconformity
LEFT JOIN HEC_SiteReworkScrapDept HEC_SiteReworkScrapDept ON HEC_SiteNonconformity.FID = HEC_SiteReworkScrapDept.fMasterID
LEFT JOIN HEC_SiteResUnitInformation HEC_SiteResUnitInformation ON HEC_SiteNonconformity.FID = HEC_SiteResUnitInformation.fMasterID
LEFT JOIN HEC_SiteResponsible HEC_SiteResponsible ON HEC_SiteNonconformity.FID = HEC_SiteResponsible.fMasterID
)
WHERE
1 = 1
后台代码:
public static Table synthesizeQueryOutPutReport(String fType,String fDisposalResult,String StartTime,String EndTime,String fDisposalSheetNum,String fMaterialCode,String fMaterialName,String fPhysicalExaNum,String fResponsibilityUnit,String fResponsibleSupplier,String fWorkNumber,String fCoverNumber){
String ksql = " SELECT * FROM ( "
+ " SELECT "
+ " HEC_ProductNonconformity.FID FID1, "
+ " '产品不符合项' AS fType, "
+ " HEC_ProductNonconformity.fDisposalSheetNum AS fDisposalSheetNum, "
+ " HEC_ProductNonconformity.fFillInTime AS fFillInTime, "
+ " HEC_ProductNonconformity.fOccDept AS fOccDept, "
+ " HEC_ProductNonconformity.fWorkNumber AS fWorkNumber, "
+ " HEC_ProductNonconformity.fCoverNumber AS fCoverNumber, "
+ " HEC_ProductNonconformity.fMaterialCode AS fMaterialCode, "
+ " HEC_ProductNonconformity.fMaterialName AS fMaterialName, "
+ " HEC_ProductNonconformity.fFigureNo AS fFigureNo, "
+ " HEC_ProductNonconformity.fPhysicalExaNum AS fPhysicalExaNum, "
+ " HEC_ProductNonconformity.fDescribe AS fDescribe, "
+ " HEC_ProductNonconformity.fClassAManagement AS fClassAManagement, "
+ " HEC_ProductNonconformity.fOneLevelReviewPerson AS fOneLevelReviewPerson, "
+ " HEC_ProductNonconformity.fPrimaryDesignReviewMan AS fPrimaryDesignReviewMan, "
+ " HEC_ProductNonconformity.fPrimaryDesignReviewPerson AS fPrimaryDesignReviewPerson, "
+ " HEC_ProductNonconformity.fTwoJudgeMan AS fTwoJudgeMan, "
+ " HEC_ProductNonconformity.fTwoJudge AS fTwoJudge, "
+ " HEC_ProductNonconformity.fThreeJudgeMan AS fThreeJudgeMan, "
+ " HEC_ProductNonconformity.fThreeJudge AS fThreeJudge, "
+ " HEC_ProductNonconformity.fOtherCostTotal AS fOtherCostTotal, "
+ " HEC_ProductNonconformity.fDisposalResult AS fDisposalResult, "
+ " HEC_ReworkScrapDept.FID FID2, "
+ " HEC_ReworkScrapDept.fRepairDept AS fRepairDept, "
+ " HEC_ReworkScrapDept.fRepairDeptInsTeam AS fRepairDeptInsTeam, "
+ " HEC_ReworkScrapDept.fResultValidation AS fResultValidation, "
+ " HEC_ReworkScrapDept.fConfirmingPerson AS fConfirmingPerson, "
+ " HEC_ReworkScrapDept.fConfirmationTime AS fConfirmationTime, "
+ " HEC_ResUnitInformation.FID FID3, "
+ " HEC_ResUnitInformation.fResponsibilityUnit AS fResponsibilityUnit, "
+ " HEC_ResUnitInformation.fResponsibilityProportion AS fResponsibilityProportion, "
+ " HEC_ResUnitInformation.fPersonLiable AS fPersonLiable, "
+ " HEC_ResUnitInformation.fApprovedState AS fApprovedState, "
+ " HEC_ResUnitInformation.fRootCauseAnalysis AS fRootCauseAnalysis, "
+ " HEC_ResUnitInformation.fCorrAndPreveActions AS fCorrAndPreveActions, "
+ " HEC_ResUnitInformation.fClassProductNonconformity1 AS fClassProductNonconformity1, "
+ " HEC_ResUnitInformation.fClassProductNonconformity2 AS fClassProductNonconformity2, "
+ " HEC_ResUnitInformation.fClassProductNonconformity3 AS fClassProductNonconformity3, "
+ " HEC_ResponsibleSupplier.FID FID4, "
+ " HEC_ResponsibleSupplier.fResponsibleSupplier AS fResponsibleSupplier "
+ " FROM "
+ " HEC_ProductNonconformity HEC_ProductNonconformity "
+ " LEFT JOIN HEC_ReworkScrapDept HEC_ReworkScrapDept ON HEC_ProductNonconformity.FID = HEC_ReworkScrapDept.fMasterID "
+ " LEFT JOIN HEC_ResUnitInformation HEC_ResUnitInformation ON HEC_ProductNonconformity.FID = HEC_ResUnitInformation.fMasterID "
+ " LEFT JOIN HEC_ResponsibleSupplier HEC_ResponsibleSupplier ON HEC_ProductNonconformity.FID = HEC_ResponsibleSupplier.fMasterID "
+ " UNION ALL "
+ " SELECT "
+ " HEC_CalibrationMaterial.FID FID1, "
+ " '脱标材料不符合项' AS fType, "
+ " HEC_CalibrationMaterial.fDisposalSheetNum AS fDisposalSheetNum, "
+ " HEC_CalibrationMaterial.fFillInTime AS fFillInTime, "
+ " HEC_CalibrationMaterial.fOccDept AS fOccDept, "
+ " HEC_CalibrationMaterial.fWorkNumber AS fWorkNumber, "
+ " HEC_CalibrationMaterial.fCoverNumber AS fCoverNumber, "
+ " HEC_CalibrationMaterial.fMaterialCode AS fMaterialCode, "
+ " HEC_CalibrationMaterial.fMaterialName AS fMaterialName, "
+ " HEC_CalibrationMaterial.fFigureNo AS fFigureNo, "
+ " HEC_CalibrationMaterial.fPhysicalExaNum AS fPhysicalExaNum, "
+ " HEC_CalibrationMaterial.fDescribe AS fDescribe, "
+ " HEC_CalibrationMaterial.fClassAManagement AS fClassAManagement, "
+ " HEC_CalibrationMaterial.fOneLevelReviewPerson AS fOneLevelReviewPerson, "
+ " HEC_CalibrationMaterial.fPrimaryDesignReviewMan AS fPrimaryDesignReviewMan, "
+ " HEC_CalibrationMaterial.fPrimaryDesignReviewPerson AS fPrimaryDesignReviewPerson, "
+ " HEC_CalibrationMaterial.fTwoJudgeMan AS fTwoJudgeMan, "
+ " HEC_CalibrationMaterial.fTwoJudge AS fTwoJudge, "
+ " HEC_CalibrationMaterial.fThreeJudgeMan AS fThreeJudgeMan, "
+ " HEC_CalibrationMaterial.fThreeJudge AS fThreeJudge, "
+ " HEC_CalibrationMaterial.fOtherCostTotal AS fOtherCostTotal, "
+ " HEC_CalibrationMaterial.fDisposalResult AS fDisposalResult, "
+ " HEC_ReworkScrapDept.FID FID2, "
+ " HEC_ReworkScrapDept.fRepairDept AS fRepairDept, "
+ " HEC_ReworkScrapDept.fRepairDeptInsTeam AS fRepairDeptInsTeam, "
+ " HEC_ReworkScrapDept.fResultValidation AS fResultValidation, "
+ " HEC_ReworkScrapDept.fConfirmingPerson AS fConfirmingPerson, "
+ " HEC_ReworkScrapDept.fConfirmationTime AS fConfirmationTime, "
+ " HEC_ResUnitInformation.FID FID3, "
+ " HEC_ResUnitInformation.fResponsibilityUnit AS fResponsibilityUnit, "
+ " HEC_ResUnitInformation.fResponsibilityProportion AS fResponsibilityProportion, "
+ " HEC_ResUnitInformation.fPersonLiable AS fPersonLiable, "
+ " HEC_ResUnitInformation.fApprovedState AS fApprovedState, "
+ " HEC_ResUnitInformation.fRootCauseAnalysis AS fRootCauseAnalysis, "
+ " HEC_ResUnitInformation.fCorrAndPreveActions AS fCorrAndPreveActions, "
+ " HEC_ResUnitInformation.fClassProductNonconformity1 AS fClassProductNonconformity1, "
+ " HEC_ResUnitInformation.fClassProductNonconformity2 AS fClassProductNonconformity2, "
+ " HEC_ResUnitInformation.fClassProductNonconformity3 AS fClassProductNonconformity3, "
+ " HEC_ResponsibleSupplier.FID FID4, "
+ " HEC_ResponsibleSupplier.fResponsibleSupplier AS fResponsibleSupplier "
+ " FROM "
+ " HEC_CalibrationMaterial HEC_CalibrationMaterial "
+ " LEFT JOIN HEC_ReworkScrapDept HEC_ReworkScrapDept ON HEC_CalibrationMaterial.FID = HEC_ReworkScrapDept.fMasterID "
+ " LEFT JOIN HEC_ResUnitInformation HEC_ResUnitInformation ON HEC_CalibrationMaterial.FID = HEC_ResUnitInformation.fMasterID "
+ " LEFT JOIN HEC_ResponsibleSupplier HEC_ResponsibleSupplier ON HEC_CalibrationMaterial.FID = HEC_ResponsibleSupplier.fMasterID "
+ " UNION ALL "
+ " SELECT "
+ " HEC_SupplierBiasNonconformity.FID FID1, "
+ " '供方偏差不符合项' AS fType, "
+ " HEC_SupplierBiasNonconformity.fDisposalSheetNum AS fDisposalSheetNum, "
+ " HEC_SupplierBiasNonconformity.fFillInTime AS fFillInTime, "
+ " HEC_SupplierBiasNonconformity.fOccDept AS fOccDept, "
+ " HEC_SupplierBiasNonconformity.fWorkNumber AS fWorkNumber, "
+ " HEC_SupplierBiasNonconformity.fCoverNumber AS fCoverNumber, "
+ " HEC_SupplierBiasNonconformity.fMaterialCode AS fMaterialCode, "
+ " HEC_SupplierBiasNonconformity.fDrawName AS fMaterialName, "
+ " HEC_SupplierBiasNonconformity.fFigureNo AS fFigureNo, "
+ " HEC_SupplierBiasNonconformity.fPhysicalExaNum AS fPhysicalExaNum, "
+ " HEC_SupplierBiasNonconformity.fNonconformityDescribe AS fDescribe, "
+ " HEC_SupplierBiasNonconformity.fClassAManagement AS fClassAManagement, "
+ " HEC_SupplierBiasNonconformity.fOneLevelReviewPerson AS fOneLevelReviewPerson, "
+ " HEC_SupplierBiasNonconformity.fPrimaryDesignReviewMan AS fPrimaryDesignReviewMan, "
+ " HEC_SupplierBiasNonconformity.fPrimaryDesignReviewPerson AS fPrimaryDesignReviewPerson, "
+ " HEC_SupplierBiasNonconformity.fTwoJudgeMan AS fTwoJudgeMan, "
+ " HEC_SupplierBiasNonconformity.fTwoJudge AS fTwoJudge, "
+ " HEC_SupplierBiasNonconformity.fThreeJudgeMan AS fThreeJudgeMan, "
+ " HEC_SupplierBiasNonconformity.fThreeJudge AS fThreeJudge, "
+ " HEC_SupplierBiasNonconformity.fOtherCostTotal AS fOtherCostTotal, "
+ " HEC_SupplierBiasNonconformity.fDisposalResult AS fDisposalResult, "
+ " HEC_SupplierReworkScrapDept.FID FID2, "
+ " HEC_SupplierReworkScrapDept.fRepairDept AS fRepairDept, "
+ " HEC_SupplierReworkScrapDept.fRepairDeptInsTeam AS fRepairDeptInsTeam, "
+ " HEC_SupplierReworkScrapDept.fResultValidation AS fResultValidation, "
+ " HEC_SupplierReworkScrapDept.fConfirmingPerson AS fConfirmingPerson, "
+ " HEC_SupplierReworkScrapDept.fConfirmationTime AS fConfirmationTime, "
+ " HEC_SupplierResUnitInformation.FID FID3, "
+ " HEC_SupplierResUnitInformation.fResponsibilityUnit AS fResponsibilityUnit, "
+ " HEC_SupplierResUnitInformation.fResponsibilityProportion AS fResponsibilityProportion, "
+ " HEC_SupplierResUnitInformation.fPersonLiable AS fPersonLiable, "
+ " HEC_SupplierResUnitInformation.fApprovedState AS fApprovedState, "
+ " HEC_SupplierResUnitInformation.fRootCauseAnalysis AS fRootCauseAnalysis, "
+ " HEC_SupplierResUnitInformation.fCorrAndPreveActions AS fCorrAndPreveActions, "
+ " HEC_SupplierResUnitInformation.fClassProductNonconformity1 AS fClassProductNonconformity1, "
+ " HEC_SupplierResUnitInformation.fClassProductNonconformity2 AS fClassProductNonconformity2, "
+ " HEC_SupplierResUnitInformation.fClassProductNonconformity3 AS fClassProductNonconformity3, "
+ " HEC_SupplierResponsible.FID FID4, "
+ " HEC_SupplierResponsible.fResponsibleSupplier AS fResponsibleSupplier "
+ " FROM "
+ " HEC_SupplierBiasNonconformity HEC_SupplierBiasNonconformity "
+ " LEFT JOIN HEC_SupplierReworkScrapDept HEC_SupplierReworkScrapDept ON HEC_SupplierBiasNonconformity.FID = HEC_SupplierReworkScrapDept.fMasterID "
+ " LEFT JOIN HEC_SupplierResUnitInformation HEC_SupplierResUnitInformation ON HEC_SupplierBiasNonconformity.FID = HEC_SupplierResUnitInformation.fMasterID "
+ " LEFT JOIN HEC_SupplierResponsible HEC_SupplierResponsible ON HEC_SupplierBiasNonconformity.FID = HEC_SupplierResponsible.fMasterID "
+ " UNION ALL "
+ " SELECT "
+ " HEC_SiteNonconformity.FID FID1, "
+ " '工地不符合项' AS fType, "
+ " HEC_SiteNonconformity.fDisposalSheetNum AS fDisposalSheetNum, "
+ " HEC_SiteNonconformity.fOccTime AS fFillInTime, "
+ " HEC_SiteNonconformity.fElecStation AS fOccDept, "
+ " HEC_SiteNonconformity.fWorkNumber AS fWorkNumber, "
+ " HEC_SiteNonconformity.fCoverNumber AS fCoverNumber, "
+ " HEC_SiteNonconformity.fMaterialCode AS fMaterialCode, "
+ " HEC_SiteNonconformity.fMaterialName AS fMaterialName, "
+ " HEC_SiteNonconformity.fFigureNo AS fFigureNo, "
+ " HEC_SiteNonconformity.fPhysicalExaNum AS fPhysicalExaNum, "
+ " HEC_SiteNonconformity.fNonconformityDescribe AS fDescribe, "
+ " HEC_SiteNonconformity.fClassAManagement AS fClassAManagement, "
+ " HEC_SiteNonconformity.fOneLevelReviewPerson AS fOneLevelReviewPerson, "
+ " HEC_SiteNonconformity.fPrimaryDesignReviewMan AS fPrimaryDesignReviewMan, "
+ " HEC_SiteNonconformity.fPrimaryDesignReviewPerson AS fPrimaryDesignReviewPerson, "
+ " HEC_SiteNonconformity.fTwoJudgeMan AS fTwoJudgeMan, "
+ " HEC_SiteNonconformity.fTwoJudge AS fTwoJudge, "
+ " HEC_SiteNonconformity.fThreeJudgeMan AS fThreeJudgeMan, "
+ " HEC_SiteNonconformity.fThreeJudge AS fThreeJudge, "
+ " 'N/A' AS fOtherCostTotal, "
+ " HEC_SiteNonconformity.fDisposalResult AS fDisposalResult, "
+ " HEC_SiteReworkScrapDept.FID FID2, "
+ " HEC_SiteReworkScrapDept.FREPAIRDEPT AS fRepairDept, "
+ " HEC_SiteReworkScrapDept.fRepairDeptInsTeam AS fRepairDeptInsTeam, "
+ " HEC_SiteReworkScrapDept.fResultValidation AS fResultValidation, "
+ " HEC_SiteReworkScrapDept.fConfirmingPerson AS fConfirmingPerson, "
+ " HEC_SiteReworkScrapDept.fConfirmationTime AS fConfirmationTime, "
+ " HEC_SiteResUnitInformation.FID FID3, "
+ " HEC_SiteResUnitInformation.fResponsibilityUnit AS fResponsibilityUnit, "
+ " HEC_SiteResUnitInformation.fResponsibilityProportion AS fResponsibilityProportion, "
+ " HEC_SiteResUnitInformation.fPersonLiable AS fPersonLiable, "
+ " HEC_SiteResUnitInformation.fApprovedState AS fApprovedState, "
+ " HEC_SiteResUnitInformation.fRootCauseAnalysis AS fRootCauseAnalysis, "
+ " HEC_SiteResUnitInformation.fCorrAndPreveActions AS fCorrAndPreveActions, "
+ " HEC_SiteResUnitInformation.fClassProductNonconformity1 AS fClassProductNonconformity1, "
+ " HEC_SiteResUnitInformation.fClassProductNonconformity2 AS fClassProductNonconformity2, "
+ " HEC_SiteResUnitInformation.fClassProductNonconformity3 AS fClassProductNonconformity3, "
+ " HEC_SiteResponsible.FID FID4, "
+ " HEC_SiteResponsible.fResponsibleSupplier AS fResponsibleSupplier "
+ " FROM "
+ " HEC_SiteNonconformity HEC_SiteNonconformity LEFT "
+ " JOIN HEC_SiteReworkScrapDept HEC_SiteReworkScrapDept ON HEC_SiteNonconformity.FID = HEC_SiteReworkScrapDept.fMasterID LEFT "
+ " JOIN HEC_SiteResUnitInformation HEC_SiteResUnitInformation ON HEC_SiteNonconformity.FID = HEC_SiteResUnitInformation.fMasterID LEFT "
+ " JOIN HEC_SiteResponsible HEC_SiteResponsible ON HEC_SiteNonconformity.FID = HEC_SiteResponsible.fMasterID "
+ " ) WHERE 1=1 ";
System.out.println("综合查询全部导出sql:"+ksql);
HashMap<String,String> sqlMap = new HashMap<String,String>();
sqlMap.put(DatabaseProduct.ORACLE.name(),ksql);
sqlMap.put(DatabaseProduct.KINGBASE.name(),ksql);
sqlMap.put(DatabaseProduct.DB2.name(),ksql);
Table table = SQL.select(sqlMap,null,"/HECManagePlatform/Nonconformity/data");
System.out.println(table.size());
Iterator<Row> rows = table.iterator();
while(rows.hasNext()) {
Row row = rows.next();
row.getValue("FID1");
//Org org = OrgHelper.getOrgByRow(row); //出现问题
System.out.println(row.getValue("FID1"));
System.out.println(row.getValue("fType"));
}
//System.out.println(table.);
return table;
}
|
|