@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; }