/** * 查询差异结果的数据 * * @return */ @SuppressWarnings("unchecked") @Override public SQLModel getPageQueryModel() throws SQLModelException { SQLModel sqlModel = new SQLModel(); List sqlArgs = new ArrayList(); DealTdProjectDiversityCheckDTO srvAssetCategory = (DealTdProjectDiversityCheckDTO) dtoParameter; String sqlStr = "SELECT " + " EDPVE.BOOK_TYPE_CODE," + " EDPVE.MIS_PROJECT_ID," + " EPPA.NAME PROJECT_NAME," + " EDPVE.TAG_NUMBER," + " EDPVE.DIFF_TYPE_CODE," + " EDPVE.DIFF_TYPE," + " EDPVE.PA_VALUE," + " EDPVE.EAM_VALUE," + " EPPA.SEGMENT1" + " FROM EAM_DIFF_PA_VS_EII_TD EDPVE,ETS_PA_PROJECTS_ALL EPPA,ETS_OU_CITY_MAP EOCM" + " WHERE" + " EDPVE.MIS_PROJECT_ID IN(" + srvAssetCategory.getMisProjectId() + ")" + " AND EDPVE.BOOK_TYPE_CODE=EOCM.BOOK_TYPE_CODE" // 帐套限制 + " AND EOCM.ORGANIZATION_ID=EPPA.ORGANIZATION_ID" // 帐套限制 + " AND EDPVE.DIFF_TYPE_CODE IN (" + srvAssetCategory.getDiffTypeCode() + ")" + " AND EDPVE.MIS_PROJECT_ID=EPPA.MIS_PROJECT_ID" + " ORDER BY 1,2,3,4"; // sqlArgs.add(srvAssetCategory.getMisProjectId()); // sqlArgs.add(srvAssetCategory.getDiffTypeCode()); sqlModel.setSqlStr(sqlStr); sqlModel.setArgs(sqlArgs); return sqlModel; }