Examples with SignatureRecordExample com.itrus.portal.db.SignatureRecordExample used on opensource projects

Example 1 with SignatureRecordExample

use of com.itrus.portal.db.SignatureRecordExample in project portal by ixinportal.

the class SignatureRecordService method getCertSnByUserid.

/**
 * 根据userid返回最近一次签名记录所用到的证书序列号
 * @param userid
 * @return
 */
public String getCertSnByUserid(Long userid) {
    SignatureRecordExample sre = new SignatureRecordExample();
    SignatureRecordExample.Criteria srec = sre.createCriteria();
    srec.andUserIdEqualTo(userid);
    sre.setOrderByClause("sign_time");
    sre.setLimit(1);
    SignatureRecord signatureRecord = sqlSession.selectOne("com.itrus.portal.db.SignatureRecordMapper.selectByExample", sre);
    String certSn = "";
    if (null != signatureRecord) {
        certSn = signatureRecord.getCertSn().equals("") ? "" : signatureRecord.getCertSn();
    }
    return certSn;
}