@SuppressWarnings("unchecked")
public SQLModel getDataUpdateModel() throws SQLModelException {
SQLModel sqlModel = new SQLModel();
List sqlArgs = new ArrayList();
DealTdProjectDiversityCheckDTO srvAssetCategory = (DealTdProjectDiversityCheckDTO) dtoParameter;
String sqlStr =
"UPDATE ZTE_TD_CUST_DETAIL"
+ " SET"
+ " BOOK_TYPE_CODE = ?,"
+ " PROJECT_NUMBER = ?,"
+ " TASK_NUMBER = ?,"
+ " TASK_NAME = ?,"
+ " PROJECT_TYPE = ?,"
+ " TAG_NUMBER = ?,"
+ " ASSET_NAME = ?,"
+ " ASSET_DESCRIPTION = ?,"
+ " ASSET_NUMBER = ?,"
+ " ASSET_CATEGORY = ?,"
+ " ASSET_CATEGORY_DESC = ?,"
+ " ASSET_LOCATION = ?,"
+ " ASSET_UNITS = CONVERT(FLOAT, ?),"
+ " UNIT_OF_MEASURE = ?,"
+ " CAPITALIZED_COST = CONVERT(FLOAT, ?),"
+ " CAPITALIZED_DATE = ?,"
+ " ASSET_KEY_CCID_DESC = ?,"
+ " ASSET_EMPLOYEE = CONVERT(FLOAT, ?),"
+ " EMPLOYEE_NAME = ?,"
+ " EMPLOYEE_NUMBER = ?,"
+ " DEPRECIATION_EXPENSE_CCID = CONVERT(FLOAT, ?),"
+ " MODEL_NUMBER = ?,"
+ " MANUFACTURER_NAME = ?,"
+ " DATE_PLACED_IN_SERVICE = ?,"
+ " FA_PERIOD_NAME = ?,"
+ " LOCATION_ID = CONVERT(FLOAT, ?),"
+ " LOCATION_CODE = ?,"
+ " TASK_ID = CONVERT(FLOAT, ?),"
+ " PROJECT_ID = CONVERT(FLOAT, ?),"
+ " PROJECT_ASSET_ID = CONVERT(FLOAT, ?),"
+ " ATTRIBUTE4 = ?,"
+ " ATTRIBUTE5 = ?,"
+ " ATTRIBUTE6 = ?,"
+ " ATTRIBUTE7 = ?"
+ " WHERE PROJECT_ASSET_ID = ?"
+ " AND TASK_ID = ?"
+ " AND PROJECT_ID = ?";
sqlArgs.add(srvAssetCategory.getBookTypeCode());
sqlArgs.add(srvAssetCategory.getProjectNumber());
sqlArgs.add(srvAssetCategory.getTaskNumber());
sqlArgs.add(srvAssetCategory.getTaskName());
sqlArgs.add(srvAssetCategory.getProjectType());
sqlArgs.add(srvAssetCategory.getTagNumber());
sqlArgs.add(srvAssetCategory.getAssetName());
sqlArgs.add(srvAssetCategory.getAssetDescription());
sqlArgs.add(srvAssetCategory.getAssetNumber());
sqlArgs.add(srvAssetCategory.getAssetCategory());
sqlArgs.add(srvAssetCategory.getAssetCategoryDesc());
sqlArgs.add(srvAssetCategory.getAssetLocation());
sqlArgs.add(srvAssetCategory.getAssetUnits());
sqlArgs.add(srvAssetCategory.getUnitOfMeasure());
sqlArgs.add(srvAssetCategory.getCapitalizedCost());
sqlArgs.add(srvAssetCategory.getCapitalizedDate());
sqlArgs.add(srvAssetCategory.getAssetKeyCcidDesc());
sqlArgs.add(srvAssetCategory.getAssetEmployee());
sqlArgs.add(srvAssetCategory.getEmployeeName());
sqlArgs.add(srvAssetCategory.getEmployeeNumber());
sqlArgs.add(srvAssetCategory.getDepreciationExpenseCcid());
sqlArgs.add(srvAssetCategory.getModelNumber());
sqlArgs.add(srvAssetCategory.getManufactorerName());
sqlArgs.add(srvAssetCategory.getDatePlacedInService());
sqlArgs.add(srvAssetCategory.getFaPeriodName());
sqlArgs.add(srvAssetCategory.getLocationId());
sqlArgs.add(srvAssetCategory.getLocationCode());
sqlArgs.add(srvAssetCategory.getTaskId());
sqlArgs.add(srvAssetCategory.getProjectId());
sqlArgs.add(srvAssetCategory.getProjectAssetId());
sqlArgs.add(srvAssetCategory.getAttribute4());
sqlArgs.add(srvAssetCategory.getAttribute5());
sqlArgs.add(srvAssetCategory.getAttribute6());
sqlArgs.add(srvAssetCategory.getAttribute7());
sqlArgs.add(srvAssetCategory.getProjectAssetId());
sqlArgs.add(srvAssetCategory.getTaskId());
sqlArgs.add(srvAssetCategory.getProjectId());
sqlModel.setSqlStr(sqlStr);
sqlModel.setArgs(sqlArgs);
return sqlModel;
}
