后台自动将请假单转换为销假单的语句

    /**请假单转换为销假单 billid为请假单的id*/
    protected void _reportTo(Context ctx, BOSUuid billId) throws BOSException,
            EASBizException {
        synchronized(countLeaveBillLock){
            ObjectUuidPK PK=new ObjectUuidPK(billId);
            ILeaveBill iLeaveBill=LeaveBillFactory.getLocalInstance(ctx);
            LeaveBillInfo leaveBillInfo=iLeaveBill.getLeaveBillInfo(PK);
            if(!leaveBillInfo.getBizState().equals(BizStateEnum.COMPLETE)){
                throw new BOSException("该单据尚未审核,该单据跳过，不进行销假");
            }
            LeaveReportBillInfo leaveReportBillInfo=new LeaveReportBillInfo();
            leaveReportBillInfo.setNumber(leaveBillInfo.getNumber());
            leaveReportBillInfo.setAdminOrg(leaveBillInfo.getAdminOrg());
            leaveReportBillInfo.setApplyDate(leaveBillInfo.getApplyDate());
            leaveReportBillInfo.setApproveState(com.kingdee.eas.hr.time.ApproveStateEnum.DIRECT);
            leaveReportBillInfo.setBizDate(leaveBillInfo.getBizDate());
            leaveReportBillInfo.setBizOU(leaveBillInfo.getBizOU());
            leaveReportBillInfo.setBizState(BizStateEnum.EDIT);
            leaveReportBillInfo.setCreateTime(new Timestamp(new Date().getTime()));
            leaveReportBillInfo.setCreator(ContextUtil.getCurrentUserInfo(ctx));
            leaveReportBillInfo.setDept(leaveBillInfo.getDept());
            leaveReportBillInfo.setDescription(leaveBillInfo.getDescription());
            leaveReportBillInfo.setHandler(leaveBillInfo.getHandler());
            leaveReportBillInfo.setHrOrgUnit(leaveBillInfo.getHrOrgUnit());
            leaveReportBillInfo.setInnerState(leaveBillInfo.getInnerState());
            leaveReportBillInfo.setCU(leaveBillInfo.getCU());
            leaveReportBillInfo.setIsMultiEntry(leaveBillInfo.isIsMultiEntry());
            leaveReportBillInfo.setLastUpdateTime(new Timestamp(new Date().getTime()));
            leaveReportBillInfo.setLastUpdateUser(ContextUtil.getCurrentUserInfo(ctx));
            leaveReportBillInfo.setLeaveBill(leaveBillInfo);
            leaveReportBillInfo.setPhone(leaveBillInfo.getPhone());
            leaveReportBillInfo.setPKField(leaveBillInfo.getPKField());
            leaveReportBillInfo.setProposer(leaveBillInfo.getProposer());
            leaveReportBillInfo.setReportToState(ReportToStateEnum.INPROGRESS);
            leaveReportBillInfo.setSourceBillId(leaveBillInfo.getId().toString());

            //设置销假单中分录中的数据
            for(int i=0,n=leaveBillInfo.getEntries().size();i<n;i++){
                LeaveReportBillEntryInfo leaveReportBillEntryInfo =new LeaveReportBillEntryInfo();
                leaveReportBillEntryInfo.setBeginTime(leaveBillInfo.getEntries().get(i).getBeginTime());
                leaveReportBillEntryInfo.setBill(leaveReportBillInfo);
                leaveReportBillEntryInfo.setEndTime(leaveBillInfo.getEntries().get(i).getEndTime());
                leaveReportBillEntryInfo.setLeaveBillEntry(leaveBillInfo.getEntries().get(i));
                leaveReportBillEntryInfo.setLeaveLength(leaveBillInfo.getEntries().get(i).getLeaveLength());
                leaveReportBillEntryInfo.setNewDay(leaveBillInfo.getEntries().get(i).getNewDay());
                leaveReportBillEntryInfo.setNewHour(leaveBillInfo.getEntries().get(i).getNewHour());
                leaveReportBillEntryInfo.setNumber(leaveBillInfo.getEntries().get(i).getNumber());
                leaveReportBillEntryInfo.setPerson(leaveBillInfo.getEntries().get(i).getPerson());
                leaveReportBillEntryInfo.setRemark(leaveBillInfo.getEntries().get(i).getRemark());
                leaveReportBillEntryInfo.setType(leaveBillInfo.getEntries().get(i).getType());
                leaveReportBillInfo.getEntries().add(leaveReportBillEntryInfo);
            }
            LeaveReportBillFactory.getLocalInstance(ctx).addnew(leaveReportBillInfo);
            _countLeaveBill(ctx,leaveReportBillInfo);
            //更改销假单的状态为已审核
            sqlSB.delete(0,sqlSB.length());
            sqlSB.append("update T_HR_LeaveReportBill set FReportToState=1,FState=3 where fid='");
            sqlSB.append(leaveReportBillInfo.getId());
            sqlSB.append("'");
            logger.info("更改销假单的状态为:"+sqlSB);
            DbUtil.execute(ctx,sqlSB.toString());
        }
    }