/**
* 查询差异结果的数据
*
* @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;
}
