public QueryApprovalVo operateApproval(QueryApprovalVo approvalVo) {
String sql =
"select * from APPROVAL_INFO_LIST where aclid = "
+ approvalVo.getAclid()
+ " and ailfl = 1 and aaz318 = "
+ approvalVo.getAaz318()
+ " and ailid="
+ approvalVo.getAilid();
ApprovalInfoList a = CommonJdbcDaoUtils.get(sql, ApprovalInfoList.class);
BeanTools.copyPropertiesIgnoreNull(approvalVo, a);
CommonHibernateDaoUtils.update(a);
if (approvalVo.getAilspfl() != null) {
if (approvalVo.getAilspfl() == 1) {
CommonJdbcDaoUtils.update(
"update APPROVAL_INFO_LIST set ailspfl=1 where aaz318="
+ approvalVo.getAaz318()
+ " and ailfl=1 and ailspfl=0 and aclid<>"
+ approvalVo.getAclid());
}
}
BeanTools.copyProperties(a, approvalVo);
return approvalVo;
}
public ApprovalClassList qryMaxApprovalId() {
String sql = "select max(aclid) aclid from APPROVAL_CLASS_LIST";
return CommonJdbcDaoUtils.get(sql, ApprovalClassList.class);
}