| | |
| | | if (saveEntity.isUnbind()) { |
| | | return this.jdbcTemplate.update("set nocount on \n update a set a.dbId=null,a.AuthenticatedCompanyId=null,a.AuthenticatedCompanyName=null,a.AuthenticatedCcCode=null,a.AuthenticatedCcName=null,a.authenticatedCode=null from t110203 a where cltCode=?", saveEntity.getCltCode()); |
| | | } else { |
| | | return this.jdbcTemplate.update("set nocount on \n update a set a.dbId=?,a.AuthenticatedCompanyId=?,a.AuthenticatedCompanyName=?,a.AuthenticatedCcCode=?,a.AuthenticatedCcName=?,a.authenticatedCode=? from t110203 a where cltCode=?", saveEntity.getDbId(), saveEntity.getCompanyId(), saveEntity.getCompanyName(), saveEntity.getCcCode(), saveEntity.getCcName(), saveEntity.getCltCode(),saveEntity.getAuthenticatedCode()); |
| | | return this.jdbcTemplate.update("set nocount on \n update a set a.dbId=?,a.AuthenticatedCompanyId=?,a.AuthenticatedCompanyName=?,a.AuthenticatedCcCode=?,a.AuthenticatedCcName=?,a.authenticatedCode=? from t110203 a where cltCode=?", saveEntity.getDbId(), saveEntity.getCompanyId(), saveEntity.getCompanyName(), saveEntity.getCcCode(), saveEntity.getCcName(),saveEntity.getAuthenticatedCode(),saveEntity.getCltCode()); |
| | | } |
| | | } |
| | | |
| | |
| | | if (saveEntity.isUnbind()) { |
| | | return this.jdbcTemplate.update("set nocount on \n update a set a.dbId=null,a.AuthenticatedCompanyId=null,a.AuthenticatedCompanyName=null,a.AuthenticatedCcCode=null,a.AuthenticatedCcName=null,a.authenticatedCode=null from t110302 a where vndCode=?", saveEntity.getVndCode()); |
| | | } else { |
| | | return this.jdbcTemplate.update("set nocount on \n update a set a.dbId=? ,a.AuthenticatedCompanyId=?,a.AuthenticatedCompanyName=?,a.AuthenticatedCcCode=?,a.AuthenticatedCcName=?,a.authenticatedCode=? from t110302 a where vndCode=?", saveEntity.getDbId(), saveEntity.getCompanyId(), saveEntity.getCompanyName(), saveEntity.getCcCode(), saveEntity.getCcName(), saveEntity.getVndCode(),saveEntity.getAuthenticatedCode()); |
| | | return this.jdbcTemplate.update("set nocount on \n update a set a.dbId=? ,a.AuthenticatedCompanyId=?,a.AuthenticatedCompanyName=?,a.AuthenticatedCcCode=?,a.AuthenticatedCcName=?,a.authenticatedCode=? from t110302 a where vndCode=?", saveEntity.getDbId(), saveEntity.getCompanyId(), saveEntity.getCompanyName(), saveEntity.getCcCode(), saveEntity.getCcName(),saveEntity.getAuthenticatedCode(), saveEntity.getVndCode()); |
| | | } |
| | | } |
| | | |