예제 #1
0
 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;
 }
예제 #2
0
 public ApprovalClassList qryMaxApprovalId() {
   String sql = "select max(aclid) aclid from APPROVAL_CLASS_LIST";
   return CommonJdbcDaoUtils.get(sql, ApprovalClassList.class);
 }