Index: ssts-datasync-default-impl/src/main/java/com/forgon/disinfectsystem/verification/VerificationCodeManagerImpl.java =================================================================== diff -u -r40903 -r40904 --- ssts-datasync-default-impl/src/main/java/com/forgon/disinfectsystem/verification/VerificationCodeManagerImpl.java (.../VerificationCodeManagerImpl.java) (revision 40903) +++ ssts-datasync-default-impl/src/main/java/com/forgon/disinfectsystem/verification/VerificationCodeManagerImpl.java (.../VerificationCodeManagerImpl.java) (revision 40904) @@ -239,7 +239,7 @@ } //限制每天每个用户最多发送的短信数量 String dateAreaSql = dateQueryAdapter.dateAreaSql("createDateTime", DateTools.getFormatDateStr(DateTools.startOfDate(nowDateTime), DateTools.COMMON_DATE_HMS), DateTools.getFormatDateStr(nowDateTime, DateTools.COMMON_DATE_HMS)); - String countSql = String.format("select count(1) from %s where userName = '%s' and smsNumber = '%s' and %s", loginName, smsMumber, SmsVerificationCode.class.getSimpleName(), dateAreaSql); + String countSql = String.format("select count(1) from %s where userName = '%s' and smsNumber = '%s' and %s", SmsVerificationCode.class.getSimpleName(), loginName, smsMumber, dateAreaSql); if(objectDao.countBySql(countSql) >= SmsVerificationCode.MAX_SMS_AMOUNT_PER_DAY){ throw new SystemException("验证码获取达到上限,请联系管理员处理。"); }