/** * 功能:框架自动生成备件事务头表(EAM) ETS_ASSETS_ADD_H数据详细信息查询SQLModel,请根据实际需要修改。 * * @return SQLModel 返回数据详细信息查询用SQLModel */ public SQLModel getPrimaryKeyDataModel() { SQLModel sqlModel = new SQLModel(); List sqlArgs = new ArrayList(); AssetsAddDTO dto = (AssetsAddDTO) dtoParameter; String sqlStr = "SELECT EAAH.HEAD_ID,\n" + " EAAH.BILL_NO,\n" + " CASE WHEN EAAH.STATUS = 0 THEN '未完成' ELSE '已完成' END STATUS," + " EAAH.CREATE_USER CREATED_BY,\n " + " EAAH.CREATED_DATE CREATED_DATE,\n" + " EAAH.REMARK,\n" + " EAAH.SPEC_DEPT,\n" + " AMD.DEPT_NAME SPECIALITY_DEPT, \n" + " SU.USERNAME CREATE_USER\n" + " FROM ETS_ASSETS_ADD_H EAAH,\n" + " AMS_MIS_DEPT AMD, \n" + " SF_USER SU\n" + " WHERE EAAH.CREATE_USER = SU.USER_ID\n" + " AND EAAH.SPEC_DEPT *= AMD.DEPT_CODE \n" + " AND EAAH.HEAD_ID = ?"; sqlArgs.add(dto.getHeadId()); sqlModel.setSqlStr(sqlStr); sqlModel.setArgs(sqlArgs); return sqlModel; }
/** * 功能:新增管理资产查询。 * * @return SQLModel 返回页面翻页查询SQLModel * @throws com.sino.base.exception.SQLModelException 发生日历异常时转化为该异常抛出 */ public SQLModel getPageQueryModel() throws SQLModelException { SQLModel sqlModel = new SQLModel(); try { List sqlArgs = new ArrayList(); AssetsAddDTO dto = (AssetsAddDTO) dtoParameter; // AssetsAddLDTO dtoL = (AssetsAddLDTO) dtoParameter; String sqlStr = "SELECT EAAH.HEAD_ID,\n" + " EAAH.BILL_NO,\n" + " CASE WHEN EAAH.STATUS=0 THEN '未完成' ELSE '已完成' END STATUS," + " EAAH.CREATE_USER,\n" + " EAAH.CREATED_DATE,\n" + " EAAH.SPEC_DEPT,\n" + " EAAL.BARCODE,\n" + " EAAL.ITEM_CODE,\n" + " ESI.ITEM_NAME,\n" + " ESI.ITEM_SPEC,\n" + " SU.USERNAME\n" + "FROM ETS_ASSETS_ADD_H EAAH,\n" + " ETS_ASSETS_ADD_L EAAL,\n" + " ETS_SYSTEM_ITEM ESI,\n" + " SF_USER SU\n" + "WHERE EAAH.HEAD_ID = EAAL.HEAD_ID\n" + " AND EAAL.ITEM_CODE = ESI.ITEM_CODE\n" + " AND EAAH.CREATE_USER = SU.USER_ID\n" + " AND SU.ORGANIZATION_ID = ?\n" + " AND SU.USERNAME LIKE dbo.NVL(?, SU.USERNAME)\n" + " AND ESI.ITEM_SPEC LIKE dbo.NVL(?, ESI.ITEM_SPEC)\n" + " AND ESI.ITEM_NAME LIKE dbo.NVL(?, ESI.ITEM_NAME)\n" + " AND EAAH.STATUS = ISNULL(?, EAAH.STATUS)\n" + " AND (? = '' OR EAAH.CREATED_DATE >= ISNULL(?, EAAH.CREATED_DATE))\n" + " AND (? = '' OR EAAH.CREATED_DATE <= ISNULL(?, EAAH.CREATED_DATE))\n" + " AND EAAL.BARCODE LIKE dbo.NVL(?, EAAL.BARCODE)\n" + "ORDER BY EAAH.BILL_NO,\n" + " EAAL.BARCODE"; sqlArgs.add(sfDto.getOrganizationId()); sqlArgs.add(dto.getCreateUser()); sqlArgs.add(dto.getItemSpec()); sqlArgs.add(dto.getItemName()); if ("".equals(dto.getStatus()) || null == dto.getStatus()) { sqlArgs.add(null); } else { sqlArgs.add(StrUtil.strToInt(dto.getStatus())); } sqlArgs.add(dto.getFromDate()); sqlArgs.add(dto.getFromDate()); sqlArgs.add(dto.getToDate()); sqlArgs.add(dto.getToDate()); sqlArgs.add(dto.getBarcod()); sqlModel.setSqlStr(sqlStr); sqlModel.setArgs(sqlArgs); } catch (CalendarException ex) { ex.printLog(); throw new SQLModelException(ex); } return sqlModel; }
/** * 功能:执行新增数据操作。 * * @return SQLModel 返回数据插入用SQLModel */ public SQLModel getDataCreateModel() { SQLModel sqlModel = new SQLModel(); // try { List sqlArgs = new ArrayList(); AssetsAddDTO dto = (AssetsAddDTO) dtoParameter; String sqlStr = "INSERT INTO " + " ETS_ASSETS_ADD_H(" + " HEAD_ID," + " BILL_NO," + " STATUS," + " CREATE_USER," + " CREATED_DATE," + " SPEC_DEPT," + " REMARK" + ") " + " VALUES (?, ?, ?, ?, GETDATE(), ?, ?)"; sqlArgs.add(dto.getHeadId()); sqlArgs.add(dto.getBillNo()); sqlArgs.add(StrUtil.strToInt(dto.getStatus())); sqlArgs.add(userAccount.getUserId()); sqlArgs.add(dto.getSpecialityDept()); sqlArgs.add(dto.getRemark()); sqlModel.setSqlStr(sqlStr); sqlModel.setArgs(sqlArgs); return sqlModel; }
/** * 功能:框架自动生成备件事务头表(EAM) ETS_ASSETS_ADD_H数据更新SQLModel,请根据实际需要修改。 * * @return SQLModel 返回数据更新用SQLModel */ public SQLModel getDataUpdateModel() throws SQLModelException { SQLModel sqlModel = new SQLModel(); List sqlArgs = new ArrayList(); AssetsAddDTO dto = (AssetsAddDTO) dtoParameter; String sqlStr = "UPDATE ETS_ASSETS_ADD_H" + " SET" + " STATUS = ?, " + " SPEC_DEPT = ?, " + " REMARK = ? " + " WHERE" + " HEAD_ID = ?"; // try { sqlArgs.add(StrUtil.strToInt(dto.getStatus())); sqlArgs.add(dto.getSpecialityDept()); sqlArgs.add(dto.getRemark()); sqlArgs.add(dto.getHeadId()); sqlModel.setSqlStr(sqlStr); sqlModel.setArgs(sqlArgs); return sqlModel; }