public JzcdWrongLog getJzcdWrongLog(String branchId, InsuranceInfo info,
Date pickDate, String pickFlag) {
log.debug("search JzcdWrongLog instance");
JzcdWrongLog jzcdWrongLog = null;
String netId = null;
String insuranceApplication = null;
String inputFileName = null;
String signatureFlag = null;
String status = new String("0");
if (null != info) {
netId = info.getNetId();
insuranceApplication = info.getInsuranceApplication();
inputFileName = info.getInputFileName();
signatureFlag = info.getDataSignature();
}
StringBuffer queryString = new StringBuffer();
queryString.append("from JzcdWrongLog where status=:status");
queryString.append(" and netId=:netId");
queryString.append(" and branchId=:branchId");
queryString.append(" and insuranceApplication=:insuranceApplication");
queryString.append(" and inputFileName=:inputFileName");
if(StringUtils.isBlank(signatureFlag)){
queryString.append(" and signatureFlag is null");
}else{
queryString.append(" and signatureFlag=:signatureFlag");
}
queryString.append(" and pickFlag=:pickFlag");
queryString.append(" order by pickDate desc");
Query query = getSession().createQuery(queryString.toString());
List<JzcdWrongLog> queryList = null;
query.setString("status", status);
query.setString("netId", netId);
query.setString("branchId", branchId);
query.setString("insuranceApplication", insuranceApplication);
query.setString("inputFileName", inputFileName);
if(StringUtils.isNotBlank(signatureFlag)){
query.setString("signatureFlag", signatureFlag);
}
query.setString("pickFlag", pickFlag);
queryList = query.list();
if (null != queryList && queryList.size() != 0) {
jzcdWrongLog=queryList.get(0);
}
return jzcdWrongLog;
}
Date pickDate, String pickFlag) {
log.debug("search JzcdWrongLog instance");
JzcdWrongLog jzcdWrongLog = null;
String netId = null;
String insuranceApplication = null;
String inputFileName = null;
String signatureFlag = null;
String status = new String("0");
if (null != info) {
netId = info.getNetId();
insuranceApplication = info.getInsuranceApplication();
inputFileName = info.getInputFileName();
signatureFlag = info.getDataSignature();
}
StringBuffer queryString = new StringBuffer();
queryString.append("from JzcdWrongLog where status=:status");
queryString.append(" and netId=:netId");
queryString.append(" and branchId=:branchId");
queryString.append(" and insuranceApplication=:insuranceApplication");
queryString.append(" and inputFileName=:inputFileName");
if(StringUtils.isBlank(signatureFlag)){
queryString.append(" and signatureFlag is null");
}else{
queryString.append(" and signatureFlag=:signatureFlag");
}
queryString.append(" and pickFlag=:pickFlag");
queryString.append(" order by pickDate desc");
Query query = getSession().createQuery(queryString.toString());
List<JzcdWrongLog> queryList = null;
query.setString("status", status);
query.setString("netId", netId);
query.setString("branchId", branchId);
query.setString("insuranceApplication", insuranceApplication);
query.setString("inputFileName", inputFileName);
if(StringUtils.isNotBlank(signatureFlag)){
query.setString("signatureFlag", signatureFlag);
}
query.setString("pickFlag", pickFlag);
queryList = query.list();
if (null != queryList && queryList.size() != 0) {
jzcdWrongLog=queryList.get(0);
}
return jzcdWrongLog;
}