| | |
| | | public AllBackMsg deleteAccount(@RequestParam(defaultValue = "0") Integer accountId, HttpServletRequest request, HttpServletResponse response) { |
| | | AllBackMsg msg = new AllBackMsg(); |
| | | try { |
| | | if (accountId == 0) { |
| | | if (accountId.equals(0)) { |
| | | msg.setFail("邮箱编号ID获取不到"); |
| | | return msg; |
| | | } |
| | |
| | | private boolean proxyFlag;//是否启用代理 |
| | | private String mailDomain; |
| | | private Integer mailType = 0;//邮箱类型 |
| | | private Integer mailStatusCode=0;//邮箱状态码 |
| | | private String mailStatus = "正常";//邮箱状态 |
| | | private String keywordList; |
| | | private String siteUrl; |
| | |
| | | sql += "select companyId,companyName,email,password,alias_email as aliasEmail,userCode,userName,accountId,receive_server_user_name as receiveServerUserName," + |
| | | "isnull(bisync_flag,0) as biSyncFlag,isnull(proxyFlag,0) as proxyFlag,mailDomain,isnull(mailType,0) as mailType,mailStatus,keywordList,siteUrl,receiveProtocol," + |
| | | "receiveEmail,receivePassword,receiveSSL,receivePort,receiveHost,smtpEmail,smtpPassword,smtpSSL,smtpPort,smtpHost," + |
| | | "isnull(invalid,0) as invalid,create_time as createTime,update_time as updateTime,DocVersion " + |
| | | "from t482102 " + |
| | | "isnull(invalid,0) as invalid,create_time as createTime,update_time as updateTime,DocVersion, " + |
| | | "(case when isnull(mailStatus,'')='正常' then 0 else -1 end) as mailStatusCode from t482102 " + |
| | | "where userCode=" + GridUtils.prossSqlParm(userCode); |
| | | sql += " order by accountId"; |
| | | return jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(T482102Entity.class)); |