SQL多表单插入数据和DO转VO

@Override
	public int add(ChannelParam channelParam,UserInfo userInfo) {
		//添加渠道基本信息pay_channel
		Channel channel = new Channel();
		channel.setChannelId(UUID.randomUUID().toString());
		channel.setChannelNo(UUID.randomUUID().toString());
		channel.setChannelNm(channelParam.getChannelNm());
		channel.setChannelType(channelParam.getChannelType());
		channel.setIncorporator(channelParam.getIncorporator());
		channel.setInterfaceNo(channelParam.getInterfaceNo());
		if(null!=channelParam.getInterfaceNo()) {
			InterfaceInfo info = interfaceinfoDao.queryById(channelParam.getInterfaceNo());
			if(null!=info) {
				channel.setInterfaceNm(info.getInterfaceName());
			}
		}
		channel.setConnectType(channelParam.getConnectType());
		channel.setChannelStatus(channelParam.getChannelStatus());
		channel.setCreateUser(userInfo.getUserId());
		channel.setCreateTime(new Date());
		channel.setUpdateUser(userInfo.getUserId());
		channel.setUpdateTime(new Date());
		channel.setWorkEndTime(channelParam.getWorkEndTime());
		channel.setWorkStartTime(channelParam.getWorkStartTime());
		channel.setHolidayEndTime(channelParam.getHolidayEndTime());
		channel.setHolidayStartTime(channelParam.getHolidayStartTime());
		
		int result = channelDao.add(channel);
		
		//添加渠道银行 pay_channel_bank
		String bankStr = channelParam.getBankType();
		if(null!=bankStr) {
			String [] bankIds = bankStr.split(",");
			for (String bankId : bankIds) {
				ChannelBank channelBank = new ChannelBank();
				channelBank.setBankId(bankId);
				channelBank.setChannelId(channel.getChannelId());
				channelBank.setCreateTime(new Date());
				channelBank.setCreateUserId(userInfo.getUserId());
				channelBank.setUpdateTime(new Date());
				channelBank.setUpdateUserId(userInfo.getUserId());
				channelBankDao.insert(channelBank);
			}
		}
		//添加渠道接口 pay_channel_interface
		ChannelInterface channelInterface = new ChannelInterface();
		channelInterface.setChannelId(channel.getChannelId());
		channelInterface.setCreateTime(new Date());
		channelInterface.setCreateUserId(userInfo.getUserId());
		channelInterface.setInterfaceId(channelParam.getInterfaceNo());
		channelInterface.setUpdateTime(new Date());
		channelInterface.setUpdateUserId(userInfo.getUserId());
		channelInterfaceDao.insert(channelInterface);
		return result;
	}

	@Override
	public ChannelVO convert(Channel channel) {
		ChannelVO  vo = null;
		if(null==channel) {
			return vo;
		}else {
			vo = new ChannelVO();
		}
		vo.setAddress(channel.getAddress());
		vo.setAddressArea(channel.getAddressArea());
		vo.setCautionMoney(NumberUtil.convert(channel.getCautionMoney()));
		vo.setChannelId(channel.getChannelId());
		vo.setChannelNm(channel.getChannelNm());
		vo.setChannelNo(channel.getChannelNo());
		vo.setChannelStatus(channel.getChannelStatus());
		if(ChannelVO.CHANNELSTATUS_NORMAL.equals(channel.getChannelStatus())) {
			vo.setChannelStatusStr(ChannelVO.CHANNELSTATUSSTR_NORMAL);
		}else if (ChannelVO.CHANNELSTATUS_STOP.equals(channel.getChannelStatus())) {
			vo.setChannelStatusStr(ChannelVO.CHANNELSTATUSSTR_STOP);
		}
		vo.setChannelType(channel.getChannelType());
		if(ChannelVO.CHANNELTYPE_LOAN==channel.getChannelType()) {
			vo.setChannelTypeStr(ChannelVO.CHANNELTYPESTR_LOAN);
		}else if (ChannelVO.CHANNELTYPE_REPAY==channel.getChannelType()) {
			vo.setChannelTypeStr(ChannelVO.CHANNELTYPESTR_REPAY);
		}
		vo.setConnectType(channel.getConnectType());
		vo.setCreateTime(DateUtil.date2Str(channel.getCreateTime(), DateUtil.FORMAT_YYYY_MM_DD_HH_MM_SS));
		vo.setCreateUser(channel.getCreateUser());
		if(null!=channel.getCreateUser() && "".equals(channel.getCreateUser().trim())) {
			UserInfo userInfo = userDao.queryByUserId(channel.getCreateUser());
			if(null!=userInfo) {
				vo.setCreateUserName(userInfo.getUserName());
			}
		}
		vo.setEndPauseTime(DateUtil.date2Str(channel.getEndPauseTime(), DateUtil.FORMAT_YYYY_MM_DD_HH_MM_SS));
		vo.setHolidayEndTime(channel.getHolidayEndTime());
		vo.setHolidayStartTime(channel.getHolidayStartTime());
		vo.setIncorporator(channel.getIncorporator());
		vo.setInstallCost(NumberUtil.convert(channel.getInstallCost()));
		vo.setInterfaceDocURL(channel.getInterfaceDocURL());
		vo.setInterfaceNm(channel.getInterfaceNm());
		vo.setInterfaceNo(channel.getInterfaceNo());
		vo.setPeriodCost(NumberUtil.convert(channel.getPeriodCost()));
		vo.setPeriodType(channel.getPeriodType());
		vo.setQualifiedName(channel.getQualifiedName());
		vo.setStartPauseTime(DateUtil.date2Str(channel.getStartPauseTime(), DateUtil.FORMAT_YYYY_MM_DD_HH_MM_SS));
		vo.setUpdateTime(DateUtil.date2Str(channel.getUpdateTime(), DateUtil.FORMAT_YYYY_MM_DD_HH_MM_SS));
		vo.setUpdateUser(channel.getUpdateUser());
		if(null!=channel.getUpdateUser() && "".equals(channel.getUpdateUser().trim())) {
			UserInfo userInfo = userDao.queryByUserId(channel.getUpdateUser());
			if(null!=userInfo) {
				vo.setUpdateUserName(userInfo.getUserName());
			}
		}
		vo.setWorkEndTime(channel.getWorkEndTime());
		vo.setWorkStartTime(channel.getWorkStartTime());
		vo.setEndPauseTime(DateUtil.date2Str(channel.getEndPauseTime(), DateUtil.FORMAT_YYYY_MM_DD_HH_MM_SS));
		vo.setStartPauseTime(DateUtil.date2Str(channel.getStartPauseTime(), DateUtil.FORMAT_YYYY_MM_DD_HH_MM_SS));
		return vo;
	}