个人网厅——提取
目录
需求文档
公积金提取类
controller层
service层
service层实现类
1.验证（个人账户）
2.提交（添加）
controller层
service层
service层实现类
3.分页查询
controller层
service层
service层实现类
4.详情查询
controller层
service层
service层实现类
DO字段类
Mapper映射类
Convert转换类
需求文档
公积金提取流水表提交（添加）、分页、查看（详情查询）、验证（个人账户）
在买房、租房的情况下，可以取出部分公积金
公积金提取类
controller层
@Tag(name = "管理后台 - 个人网上营业厅-公积金提取流水")
@RestController
@RequestMapping("/business/tq-gjjtqlsb")
@Validated
public class TqGjjtqlsbController {@Resourceprivate TqGjjtqlsbService tqGjjtqlsbService;...（类中功能方法）}
需要注意注意@RequestMapping中请求路径名与包名的位置一致
@RequestMapping("/business/tq-gjjtqlsb") 否则会提示请求路径错误
@RequestMapping("/wt/tq-gjjtqlsb")
service层
/*** 个人网上营业厅-公积金提取流水 Service 接口** @author 芋道源码*/
public interface TqGjjtqlsbService {...
}
service层实现类
/*** 个人网上营业厅-公积金提取流水 Service 实现类** @author 芋道源码*/
@Service
@Validated
public class TqGjjtqlsbServiceImpl implements TqGjjtqlsbService {@Resourceprivate TqGjjtqlsbMapper tqGjjtqlsbMapper;...
}
1.验证（个人账户）
/*** 根据vo中的定义验证参数合法后，验证请求数据合法性* @param createReqVO （暂存、直接保存）请求参数* @return SaveGeneralReturn*/private CommonResult<SaveGeneralReturn> validateData(TqGjjtqlsbCreateReqVO createReqVO){SaveGeneralReturn saveGeneralReturn=new SaveGeneralReturn();List<ErrorCode> errorCodeList=new ArrayList<>();//传入参数不合法/*******判断网厅是否存在未审批记录*************/LambdaQueryWrapper<TqGjjtqlsbDO> queryWrapper = new LambdaQueryWrapper();queryWrapper.eq(TqGjjtqlsbDO::Grzh());(TqGjjtqlsbDO::getYwzt,"100");List<TqGjjtqlsbDO> tqGjjtqlsbDOList = SelectList(queryWrapper);if (tqGjjtqlsbDOList != null && tqGjjtqlsbDOList.size() > 0) {errorCodeList.add(GJJTQLSB_WSP);}saveGeneralReturn.setValidate(errorCodeList.size() == 0);saveGeneralReturn.setErrorCount(errorCodeList.size());saveGeneralReturn.setErrorCodes(errorCodeList);//特殊判断return success(saveGeneralReturn);}
通过查询数据库表TqGjjtqlsbDO来判断，具体查询条件是根据createReqVO中的"grzh"属性等于表中的"grzh"并且"ywzt"属性不等于"100"。如果查询结果不为空且数量大于0，将给予错误码GJJTQLSB_WSP（公积金提取流水表未审批）提示。个人账户具有唯一性，相同的个人账户，不予添加。
2.提交（添加）
controller层
/***提交 保存数据 注意业务状态* */@PostMapping("/create")@Operation(summary = "公积金提取_保存")public CommonResult<SaveGeneralReturn> createTqGjjtqlsb(@Valid @RequestBody TqGjjtqlsbCreateReqVO createReqVO){CommonResult<SaveGeneralReturn> validatedReturn=validateData(createReqVO);SaveGeneralReturn validated&#Data();Validate()){createReqVO.setYwzt("0");BigDecimal id = ateTqGjjtqlsb(createReqVO);validated.setId(id);validated.setSuccessMsg("暂存成功");return success(validated);}return error(validatedReturn);}
通过判断validated对象的validate属性是否为true来确定是否通过了数据验证。如果通过验证，即为库中不存在相同账户的额数据，将createReqVO的ywzt属性设置为"0"，
调用方法保存数据，并将返回的id赋值给validated对象的id属性。随后，设置validated对象的successMsg属性为"暂存成功"，并返回success(validated)。
service层
/*** 创建个人网上营业厅-公积金提取流水** @param createReqVO 创建信息* @return 编号*/BigDecimal createTqGjjtqlsb(@Valid TqGjjtqlsbCreateReqVO createReqVO);
service层实现类
@Overridepublic BigDecimal createTqGjjtqlsb(TqGjjtqlsbCreateReqVO createReqVO) {// 插入TqGjjtqlsbDO tqGjjtqlsb = vert(createReqVO);tqGjjtqlsbMapper.insert(tqGjjtqlsb);// 返回Id();}
3.分页查询
controller层
/*** @param pageVO 请求参数（包括分页参数）* @return PageResult<TqGjjtqlsbRespVO>*/@GetMapping("/page")@Operation(summary = "公积金提取_分页查询")public CommonResult<PageResult<TqGjjtqlsbRespVO>> getTqGjjtqlsbPage(@Valid TqGjjtqlsbPageReqVO pageVO){PageResult<TqGjjtqlsbDO> pageResult = TqGjjtqlsbPage(pageVO);return success(vertPage(pageResult));}
service层
/*** 获得个人网上营业厅-公积金提取流水分页** @param pageReqVO 分页查询* @return 个人网上营业厅-公积金提取流水分页*/PageResult<TqGjjtqlsbDO> getTqGjjtqlsbPage(TqGjjtqlsbPageReqVO pageReqVO);
service层实现类
@Overridepublic PageResult<TqGjjtqlsbDO> getTqGjjtqlsbPage(TqGjjtqlsbPageReqVO pageReqVO) {return tqGjjtqlsbMapper.selectPage(pageReqVO);}
4.详情查询
controller层
/*** 详情* @param id 查询参数* @result TqGjjtqlsbRespVO*/@GetMapping("/get")@Operation(summary = "公积金提取_查看详情")@Parameter(name = "id", description = "编号", required = true, example = "1024")public CommonResult<TqGjjtqlsbRespVO> getTqGjjtqlsb(@RequestParam("id") BigDecimal id){TqGjjtqlsbDO tqGjjtqlsb = TqGjjtqlsb(id);return success(vert(tqGjjtqlsb));}
service层
/*** 获得个人网上营业厅-公积金提取流水** @param id 编号* @return 个人网上营业厅-公积金提取流水*/TqGjjtqlsbDO getTqGjjtqlsb(BigDecimal id);
service层实现类
@Overridepublic TqGjjtqlsbDO getTqGjjtqlsb(BigDecimal id) {return tqGjjtqlsbMapper.selectById(id);}
DO字段类
@TableName("WT_TQ_GJJTQLSB")对应好数据库中表并全部大写
@KeySequence("SEQ_WT_TQ_GJJTQLSB")对应好数据库中表并加上SEQ全部大写
否则会报错：
org.springframework.jdbc.BadSqlGrammarException: Error selecting key or setting result to parameter object. Cause: java.sql.SQLSyntaxErrorException: ORA-02289: 序列不存在
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-02289: 序列不存在
/*** 个人网上营业厅-公积金提取流水 DO** @author 芋道源码*/
@TableName("WT_TQ_GJJTQLSB")
@KeySequence("SEQ_WT_TQ_GJJTQLSB") // 用于 Oracle、PostgreSQL、Kingbase、DB2、H2 数据库的主键自增。如果是 MySQL 等数据库，可不写。
@Data
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class TqGjjtqlsbDO extends BaseDO {/*** 主键*/@TableIdprivate BigDecimal id;/*** 地区代码*/private String dqdm;/*** 归属地地区代码*/private String gsddqdm;/*** 缴存地地区代码（个人信息的地区代码）*/private String jcddqdm;/*** 单位账号*/private String dwzh;/*** 个人账号*/private String grzh;/*** 经办人姓名*/private String jbrxm;/*** 经办人身份证号码*/private String jbrzjhm;/*** 姓名*/private String xm;/*** 合计提取金额*/private BigDecimal hjtqje;/*** 证件号码*/private String zjhm;/*** 单位名称*/private String dwmc;/*** 提取金额*/private BigDecimal tqje;/*** 月缴存额*/private BigDecimal yjce;/*** 公积金余额*/private BigDecimal gjjye;/*** 费用总额*/private BigDecimal fyze;/*** 提取原因*/private String tqyy;/*** 剩余公积金余额*/private BigDecimal syye;/*** 申请日期*/private String sqrq;/*** 银行卡号*/private String yhkh;/*** 付款银行代码（用哪个银行付款）*/private String fkyhdm;/*** 是否对公： 是 否*/private String sfzhlb;/*** 是否是首付款提取 （是 否）*/private String sfssfktq;/*** 售房单位名称*/private String sfdwmc;/*** 房屋位置*/private String fwwz;/*** 所购楼层*/private String szlc;/*** 房屋面积*/private String fwmj;/*** 房屋单价*/private BigDecimal fwdj;/*** 房屋总价*/private BigDecimal fwzj;/*** 首付房款*/private BigDecimal sffk;/*** 占房价比*/private BigDecimal zfjb;/*** 建筑年份*/private String jznf;/*** 与产权人关系 本人 配偶 直系亲属*/private String ycqrgx;/*** 发票号*/private String fph;/*** 物业维修资金*/private BigDecimal wywxzj;/*** 契税*/private BigDecimal qishui;/*** 总价款 （房屋总价 + 物业维修资金+契税）*/private BigDecimal zjk;/*** 不动产单元号*/private String bdcdyh;/*** 房屋属地 州内，州外*/private String fwsd;/*** 银行全称*/private String yhqc;/*** 省*/private String sheng;/*** 市*/private String shi;/*** 开户银行*/private String khyh;/*** 联行号*/private String lhh;/*** 转入单位名称*/private String zrdwmc;/*** 患者姓名*/private String hzxm;/*** 患病名称*/private String hbmc;/*** 与提取人关系*/private String ytqrgx;/*** 医保报销金额*/private BigDecimal ybbxje;/*** 医疗自费金额*/private BigDecimal ylzfje;/*** 医疗总费用*/private BigDecimal ylzfy;/*** 产权置换售房单位 售房单位 （对应老表拆迁单位）*/private String cqzhsfdw;/*** 产权置换房屋位置 房屋位置 （对应老表拆迁房屋位置）*/private String cqzhfwwz;/*** 产权置换所购楼层 所购楼层 （对应老表回迁楼层）*/private String cqzhsglc;/*** 产权置换原房屋面积 原房屋面积(㎡) （对应老表拆迁面积） */private String cqzhyfwmj;/*** 产权置换所购房屋面积 所购房屋面积 （对应老表预付款金额） */private String cqzhsgfwmj;/*** 产权置换房屋差价额 房屋差价额*/private BigDecimal cqzhfwcje;/*** 房屋租赁起始时间*/private String fwzlqssj;/*** 房屋租赁终止时间*/private String fwzlzzsj;/*** 是否是公租房*/private String sfsgzf;/*** 所租房屋面积*/private String fzfwmj;/*** 月租金额*/private BigDecimal yzje;/*** 月还款额*/private BigDecimal yhke;/*** 本年还款月数*/private String bnhkys;/*** 本年还款额*/private BigDecimal bnhkje;/*** 是否打印*/private String sfdy;/*** 备注*/private String beiz;/*** 婚姻状况*/private String hyzk;/*** 配偶姓名*/private String poxm;/*** 配偶证件号码*/private String pozjhm;/*** 是否是结清商业贷款*/private String sfsjqsydk;/*** 情况说明综合结论*/private String qksmzhjl;/*** 多人连续提取ID*/private Long drlxtqid;/*** 多人提取ID*/private Short drtqid;/*** 连续提取ID*/private Short lxtqid;/*** 打印操作员*/private BigDecimal dyczy;/*** 打印操作日期*/private LocalDateTime dyczrq;/*** 操作员*/private BigDecimal czy;/*** 操作日期*/private LocalDateTime czrq;/*** 复核人员*/private BigDecimal fhry;/*** 复核日期*/private LocalDateTime fhrq;/*** 审核人员*/private BigDecimal shry;/*** 审核日期*/private LocalDateTime shrq;/*** 预审人员*/private BigDecimal ysry;/*** 预审日期*/private LocalDateTime ysrq;/*** 审批人员*/private BigDecimal spry;/*** 审批日期*/private LocalDateTime sprq;/*** 业务状态 100完成*/private String ywzt;/*** 最后修改日期*/private LocalDateTime zhxgrq;/*** 最后修改操作员*/private BigDecimal zhxgczy;/*** 流程控制ID*/private String lckzid;/*** 三账表ID*/private Long szbid;/*** 提取生效日期*/private LocalDateTime sxrq;/*** 业务记财务账状态*/private String ywjcwzzt;/*** 业务记财务账返回描述*/private String ywjcwzfhms;/*** 开发商id*/private Long kfsid;/*** 退回拒签标识*/private String thjqbs;/*** 房屋面积数字*/private BigDecimal fwmjnum;/*** 修改标识 0:未修改 1：修改中 2：修改完成*/private String xgbs;/*** 借款人姓名（偿还贷款合同提取）*/private String jkrxm;/*** 借款人证件号码（偿还贷款合同提取）*/private String jkrzjhm;/*** 借款人合同编号（偿还贷款合同提取）*/private String jkrhtbh;/*** 实际出资额*/private BigDecimal sjcze;/*** 提取业务表主键*/private Long tqid;/*** 复核备注*/private String fhbz;/*** 记录上传图片uuid*/private String uuid;/*** 核验标识 ：
0通过 1 未通过*/private String verification;/*** 业务办理类型*/private String ywbllx;}
Mapper映射类
分页查询 以及 查询多条 时会使用，CRUD操作基本在Mapper和BaseMapper各种Mapper中，各种Mapper类由Mybatis-plus自动生成不用深究
/*** 个人网上营业厅-公积金提取流水 Mapper** @author 芋道源码*/
@Mapper
public interface TqGjjtqlsbMapper extends BaseMapperX<TqGjjtqlsbDO> {default PageResult<TqGjjtqlsbDO> selectPage(TqGjjtqlsbPageReqVO reqVO) {return selectPage(reqVO, new LambdaQueryWrapperX<TqGjjtqlsbDO>().eqIfPresent(TqGjjtqlsbDO::getDqdm, Dqdm()).eqIfPresent(TqGjjtqlsbDO::getGsddqdm, Gsddqdm()).eqIfPresent(TqGjjtqlsbDO::getJcddqdm, Jcddqdm()).eqIfPresent(TqGjjtqlsbDO::getDwzh, Dwzh()).eqIfPresent(TqGjjtqlsbDO::getGrzh, Grzh()).eqIfPresent(TqGjjtqlsbDO::getJbrxm, Jbrxm()).eqIfPresent(TqGjjtqlsbDO::getJbrzjhm, Jbrzjhm()).eqIfPresent(TqGjjtqlsbDO::getXm, Xm()).eqIfPresent(TqGjjtqlsbDO::getHjtqje, Hjtqje()).eqIfPresent(TqGjjtqlsbDO::getZjhm, Zjhm()).eqIfPresent(TqGjjtqlsbDO::getDwmc, Dwmc()).eqIfPresent(TqGjjtqlsbDO::getTqje, Tqje()).eqIfPresent(TqGjjtqlsbDO::getYjce, Yjce()).eqIfPresent(TqGjjtqlsbDO::getGjjye, Gjjye()).eqIfPresent(TqGjjtqlsbDO::getFyze, Fyze()).eqIfPresent(TqGjjtqlsbDO::getTqyy, Tqyy()).eqIfPresent(TqGjjtqlsbDO::getSyye, Syye()).eqIfPresent(TqGjjtqlsbDO::getSqrq, Sqrq()).eqIfPresent(TqGjjtqlsbDO::getYhkh, Yhkh()).eqIfPresent(TqGjjtqlsbDO::getFkyhdm, Fkyhdm()).eqIfPresent(TqGjjtqlsbDO::getSfzhlb, Sfzhlb()).eqIfPresent(TqGjjtqlsbDO::getSfssfktq, Sfssfktq()).eqIfPresent(TqGjjtqlsbDO::getSfdwmc, Sfdwmc()).eqIfPresent(TqGjjtqlsbDO::getFwwz, Fwwz()).eqIfPresent(TqGjjtqlsbDO::getSzlc, Szlc()).eqIfPresent(TqGjjtqlsbDO::getFwmj, Fwmj()).eqIfPresent(TqGjjtqlsbDO::getFwdj, Fwdj()).eqIfPresent(TqGjjtqlsbDO::getFwzj, Fwzj()).eqIfPresent(TqGjjtqlsbDO::getSffk, Sffk()).eqIfPresent(TqGjjtqlsbDO::getZfjb, Zfjb()).eqIfPresent(TqGjjtqlsbDO::getJznf, Jznf()).eqIfPresent(TqGjjtqlsbDO::getYcqrgx, Ycqrgx()).eqIfPresent(TqGjjtqlsbDO::getFph, Fph()).eqIfPresent(TqGjjtqlsbDO::getWywxzj, Wywxzj()).eqIfPresent(TqGjjtqlsbDO::getQishui, Qishui()).eqIfPresent(TqGjjtqlsbDO::getZjk, Zjk()).eqIfPresent(TqGjjtqlsbDO::getBdcdyh, Bdcdyh()).eqIfPresent(TqGjjtqlsbDO::getFwsd, Fwsd()).eqIfPresent(TqGjjtqlsbDO::getYhqc, Yhqc()).eqIfPresent(TqGjjtqlsbDO::getSheng, Sheng()).eqIfPresent(TqGjjtqlsbDO::getShi, Shi()).eqIfPresent(TqGjjtqlsbDO::getKhyh, Khyh()).eqIfPresent(TqGjjtqlsbDO::getLhh, Lhh()).eqIfPresent(TqGjjtqlsbDO::getZrdwmc, Zrdwmc()).eqIfPresent(TqGjjtqlsbDO::getHzxm, Hzxm()).eqIfPresent(TqGjjtqlsbDO::getHbmc, Hbmc()).eqIfPresent(TqGjjtqlsbDO::getYtqrgx, Ytqrgx()).eqIfPresent(TqGjjtqlsbDO::getYbbxje, Ybbxje()).eqIfPresent(TqGjjtqlsbDO::getYlzfje, Ylzfje()).eqIfPresent(TqGjjtqlsbDO::getYlzfy, Ylzfy()).eqIfPresent(TqGjjtqlsbDO::getCqzhsfdw, Cqzhsfdw()).eqIfPresent(TqGjjtqlsbDO::getCqzhfwwz, Cqzhfwwz()).eqIfPresent(TqGjjtqlsbDO::getCqzhsglc, Cqzhsglc()).eqIfPresent(TqGjjtqlsbDO::getCqzhyfwmj, Cqzhyfwmj()).eqIfPresent(TqGjjtqlsbDO::getCqzhsgfwmj, Cqzhsgfwmj()).eqIfPresent(TqGjjtqlsbDO::getCqzhfwcje, Cqzhfwcje()).eqIfPresent(TqGjjtqlsbDO::getFwzlqssj, Fwzlqssj()).eqIfPresent(TqGjjtqlsbDO::getFwzlzzsj, Fwzlzzsj()).eqIfPresent(TqGjjtqlsbDO::getSfsgzf, Sfsgzf()).eqIfPresent(TqGjjtqlsbDO::getFzfwmj, Fzfwmj()).eqIfPresent(TqGjjtqlsbDO::getYzje, Yzje()).eqIfPresent(TqGjjtqlsbDO::getYhke, Yhke()).eqIfPresent(TqGjjtqlsbDO::getBnhkys, Bnhkys()).eqIfPresent(TqGjjtqlsbDO::getBnhkje, Bnhkje()).eqIfPresent(TqGjjtqlsbDO::getSfdy, Sfdy()).eqIfPresent(TqGjjtqlsbDO::getBeiz, Beiz()).eqIfPresent(TqGjjtqlsbDO::getHyzk, Hyzk()).eqIfPresent(TqGjjtqlsbDO::getPoxm, Poxm()).eqIfPresent(TqGjjtqlsbDO::getPozjhm, Pozjhm()).eqIfPresent(TqGjjtqlsbDO::getSfsjqsydk, Sfsjqsydk()).eqIfPresent(TqGjjtqlsbDO::getQksmzhjl, Qksmzhjl()).eqIfPresent(TqGjjtqlsbDO::getDrlxtqid, Drlxtqid()).eqIfPresent(TqGjjtqlsbDO::getDrtqid, Drtqid()).eqIfPresent(TqGjjtqlsbDO::getLxtqid, Lxtqid()).eqIfPresent(TqGjjtqlsbDO::getDyczy, Dyczy()).eqIfPresent(TqGjjtqlsbDO::getDyczrq, Dyczrq()).eqIfPresent(TqGjjtqlsbDO::getCzy, Czy()).eqIfPresent(TqGjjtqlsbDO::getCzrq, Czrq()).eqIfPresent(TqGjjtqlsbDO::getFhry, Fhry()).eqIfPresent(TqGjjtqlsbDO::getFhrq, Fhrq()).eqIfPresent(TqGjjtqlsbDO::getShry, Shry()).eqIfPresent(TqGjjtqlsbDO::getShrq, Shrq()).eqIfPresent(TqGjjtqlsbDO::getYsry, Ysry()).eqIfPresent(TqGjjtqlsbDO::getYsrq, Ysrq()).eqIfPresent(TqGjjtqlsbDO::getSpry, Spry()).eqIfPresent(TqGjjtqlsbDO::getSprq, Sprq()).eqIfPresent(TqGjjtqlsbDO::getYwzt, Ywzt()).eqIfPresent(TqGjjtqlsbDO::getZhxgrq, Zhxgrq()).eqIfPresent(TqGjjtqlsbDO::getZhxgczy, Zhxgczy()).eqIfPresent(TqGjjtqlsbDO::getLckzid, Lckzid()).eqIfPresent(TqGjjtqlsbDO::getSzbid, Szbid()).eqIfPresent(TqGjjtqlsbDO::getSxrq, Sxrq()).eqIfPresent(TqGjjtqlsbDO::getYwjcwzzt, Ywjcwzzt()).eqIfPresent(TqGjjtqlsbDO::getYwjcwzfhms, Ywjcwzfhms()).eqIfPresent(TqGjjtqlsbDO::getKfsid, Kfsid()).eqIfPresent(TqGjjtqlsbDO::getThjqbs, Thjqbs()).eqIfPresent(TqGjjtqlsbDO::getFwmjnum, Fwmjnum()).eqIfPresent(TqGjjtqlsbDO::getXgbs, Xgbs()).eqIfPresent(TqGjjtqlsbDO::getJkrxm, Jkrxm()).eqIfPresent(TqGjjtqlsbDO::getJkrzjhm, Jkrzjhm()).eqIfPresent(TqGjjtqlsbDO::getJkrhtbh, Jkrhtbh()).eqIfPresent(TqGjjtqlsbDO::getSjcze, Sjcze()).eqIfPresent(TqGjjtqlsbDO::getTqid, Tqid()).eqIfPresent(TqGjjtqlsbDO::getFhbz, Fhbz()).eqIfPresent(TqGjjtqlsbDO::getUuid, Uuid()).eqIfPresent(TqGjjtqlsbDO::getVerification, Verification()).eqIfPresent(TqGjjtqlsbDO::getYwbllx, Ywbllx()).betweenIfPresent(TqGjjtqlsbDO::getCreateTime, CreateTime()).orderByDesc(TqGjjtqlsbDO::getId));}default List<TqGjjtqlsbDO> selectList(TqGjjtqlsbExportReqVO reqVO) {return selectList(new LambdaQueryWrapperX<TqGjjtqlsbDO>().eqIfPresent(TqGjjtqlsbDO::getDqdm, Dqdm()).eqIfPresent(TqGjjtqlsbDO::getGsddqdm, Gsddqdm()).eqIfPresent(TqGjjtqlsbDO::getJcddqdm, Jcddqdm()).eqIfPresent(TqGjjtqlsbDO::getDwzh, Dwzh()).eqIfPresent(TqGjjtqlsbDO::getGrzh, Grzh()).eqIfPresent(TqGjjtqlsbDO::getJbrxm, Jbrxm()).eqIfPresent(TqGjjtqlsbDO::getJbrzjhm, Jbrzjhm()).eqIfPresent(TqGjjtqlsbDO::getXm, Xm()).eqIfPresent(TqGjjtqlsbDO::getHjtqje, Hjtqje()).eqIfPresent(TqGjjtqlsbDO::getZjhm, Zjhm()).eqIfPresent(TqGjjtqlsbDO::getDwmc, Dwmc()).eqIfPresent(TqGjjtqlsbDO::getTqje, Tqje()).eqIfPresent(TqGjjtqlsbDO::getYjce, Yjce()).eqIfPresent(TqGjjtqlsbDO::getGjjye, Gjjye()).eqIfPresent(TqGjjtqlsbDO::getFyze, Fyze()).eqIfPresent(TqGjjtqlsbDO::getTqyy, Tqyy()).eqIfPresent(TqGjjtqlsbDO::getSyye, Syye()).eqIfPresent(TqGjjtqlsbDO::getSqrq, Sqrq()).eqIfPresent(TqGjjtqlsbDO::getYhkh, Yhkh()).eqIfPresent(TqGjjtqlsbDO::getFkyhdm, Fkyhdm()).eqIfPresent(TqGjjtqlsbDO::getSfzhlb, Sfzhlb()).eqIfPresent(TqGjjtqlsbDO::getSfssfktq, Sfssfktq()).eqIfPresent(TqGjjtqlsbDO::getSfdwmc, Sfdwmc()).eqIfPresent(TqGjjtqlsbDO::getFwwz, Fwwz()).eqIfPresent(TqGjjtqlsbDO::getSzlc, Szlc()).eqIfPresent(TqGjjtqlsbDO::getFwmj, Fwmj()).eqIfPresent(TqGjjtqlsbDO::getFwdj, Fwdj()).eqIfPresent(TqGjjtqlsbDO::getFwzj, Fwzj()).eqIfPresent(TqGjjtqlsbDO::getSffk, Sffk()).eqIfPresent(TqGjjtqlsbDO::getZfjb, Zfjb()).eqIfPresent(TqGjjtqlsbDO::getJznf, Jznf()).eqIfPresent(TqGjjtqlsbDO::getYcqrgx, Ycqrgx()).eqIfPresent(TqGjjtqlsbDO::getFph, Fph()).eqIfPresent(TqGjjtqlsbDO::getWywxzj, Wywxzj()).eqIfPresent(TqGjjtqlsbDO::getQishui, Qishui()).eqIfPresent(TqGjjtqlsbDO::getZjk, Zjk()).eqIfPresent(TqGjjtqlsbDO::getBdcdyh, Bdcdyh()).eqIfPresent(TqGjjtqlsbDO::getFwsd, Fwsd()).eqIfPresent(TqGjjtqlsbDO::getYhqc, Yhqc()).eqIfPresent(TqGjjtqlsbDO::getSheng, Sheng()).eqIfPresent(TqGjjtqlsbDO::getShi, Shi()).eqIfPresent(TqGjjtqlsbDO::getKhyh, Khyh()).eqIfPresent(TqGjjtqlsbDO::getLhh, Lhh()).eqIfPresent(TqGjjtqlsbDO::getZrdwmc, Zrdwmc()).eqIfPresent(TqGjjtqlsbDO::getHzxm, Hzxm()).eqIfPresent(TqGjjtqlsbDO::getHbmc, Hbmc()).eqIfPresent(TqGjjtqlsbDO::getYtqrgx, Ytqrgx()).eqIfPresent(TqGjjtqlsbDO::getYbbxje, Ybbxje()).eqIfPresent(TqGjjtqlsbDO::getYlzfje, Ylzfje()).eqIfPresent(TqGjjtqlsbDO::getYlzfy, Ylzfy()).eqIfPresent(TqGjjtqlsbDO::getCqzhsfdw, Cqzhsfdw()).eqIfPresent(TqGjjtqlsbDO::getCqzhfwwz, Cqzhfwwz()).eqIfPresent(TqGjjtqlsbDO::getCqzhsglc, Cqzhsglc()).eqIfPresent(TqGjjtqlsbDO::getCqzhyfwmj, Cqzhyfwmj()).eqIfPresent(TqGjjtqlsbDO::getCqzhsgfwmj, Cqzhsgfwmj()).eqIfPresent(TqGjjtqlsbDO::getCqzhfwcje, Cqzhfwcje()).eqIfPresent(TqGjjtqlsbDO::getFwzlqssj, Fwzlqssj()).eqIfPresent(TqGjjtqlsbDO::getFwzlzzsj, Fwzlzzsj()).eqIfPresent(TqGjjtqlsbDO::getSfsgzf, Sfsgzf()).eqIfPresent(TqGjjtqlsbDO::getFzfwmj, Fzfwmj()).eqIfPresent(TqGjjtqlsbDO::getYzje, Yzje()).eqIfPresent(TqGjjtqlsbDO::getYhke, Yhke()).eqIfPresent(TqGjjtqlsbDO::getBnhkys, Bnhkys()).eqIfPresent(TqGjjtqlsbDO::getBnhkje, Bnhkje()).eqIfPresent(TqGjjtqlsbDO::getSfdy, Sfdy()).eqIfPresent(TqGjjtqlsbDO::getBeiz, Beiz()).eqIfPresent(TqGjjtqlsbDO::getHyzk, Hyzk()).eqIfPresent(TqGjjtqlsbDO::getPoxm, Poxm()).eqIfPresent(TqGjjtqlsbDO::getPozjhm, Pozjhm()).eqIfPresent(TqGjjtqlsbDO::getSfsjqsydk, Sfsjqsydk()).eqIfPresent(TqGjjtqlsbDO::getQksmzhjl, Qksmzhjl()).eqIfPresent(TqGjjtqlsbDO::getDrlxtqid, Drlxtqid()).eqIfPresent(TqGjjtqlsbDO::getDrtqid, Drtqid()).eqIfPresent(TqGjjtqlsbDO::getLxtqid, Lxtqid()).eqIfPresent(TqGjjtqlsbDO::getDyczy, Dyczy()).eqIfPresent(TqGjjtqlsbDO::getDyczrq, Dyczrq()).eqIfPresent(TqGjjtqlsbDO::getCzy, Czy()).eqIfPresent(TqGjjtqlsbDO::getCzrq, Czrq()).eqIfPresent(TqGjjtqlsbDO::getFhry, Fhry()).eqIfPresent(TqGjjtqlsbDO::getFhrq, Fhrq()).eqIfPresent(TqGjjtqlsbDO::getShry, Shry()).eqIfPresent(TqGjjtqlsbDO::getShrq, Shrq()).eqIfPresent(TqGjjtqlsbDO::getYsry, Ysry()).eqIfPresent(TqGjjtqlsbDO::getYsrq, Ysrq()).eqIfPresent(TqGjjtqlsbDO::getSpry, Spry()).eqIfPresent(TqGjjtqlsbDO::getSprq, Sprq()).eqIfPresent(TqGjjtqlsbDO::getYwzt, Ywzt()).eqIfPresent(TqGjjtqlsbDO::getZhxgrq, Zhxgrq()).eqIfPresent(TqGjjtqlsbDO::getZhxgczy, Zhxgczy()).eqIfPresent(TqGjjtqlsbDO::getLckzid, Lckzid()).eqIfPresent(TqGjjtqlsbDO::getSzbid, Szbid()).eqIfPresent(TqGjjtqlsbDO::getSxrq, Sxrq()).eqIfPresent(TqGjjtqlsbDO::getYwjcwzzt, Ywjcwzzt()).eqIfPresent(TqGjjtqlsbDO::getYwjcwzfhms, Ywjcwzfhms()).eqIfPresent(TqGjjtqlsbDO::getKfsid, Kfsid()).eqIfPresent(TqGjjtqlsbDO::getThjqbs, Thjqbs()).eqIfPresent(TqGjjtqlsbDO::getFwmjnum, Fwmjnum()).eqIfPresent(TqGjjtqlsbDO::getXgbs, Xgbs()).eqIfPresent(TqGjjtqlsbDO::getJkrxm, Jkrxm()).eqIfPresent(TqGjjtqlsbDO::getJkrzjhm, Jkrzjhm()).eqIfPresent(TqGjjtqlsbDO::getJkrhtbh, Jkrhtbh()).eqIfPresent(TqGjjtqlsbDO::getSjcze, Sjcze()).eqIfPresent(TqGjjtqlsbDO::getTqid, Tqid()).eqIfPresent(TqGjjtqlsbDO::getFhbz, Fhbz()).eqIfPresent(TqGjjtqlsbDO::getUuid, Uuid()).eqIfPresent(TqGjjtqlsbDO::getVerification, Verification()).eqIfPresent(TqGjjtqlsbDO::getYwbllx, Ywbllx()).betweenIfPresent(TqGjjtqlsbDO::getCreateTime, CreateTime()).orderByDesc(TqGjjtqlsbDO::getId));}}
Convert转换类
用于VO、DO间的转换，TqGjjtqlsbDO convert(TqGjjtqlsbCreateReqVO bean);将TqGjjtqlsbCreateReqVO 对象转换成TqGjjtqlsbDO 对象。转换类自动生成不用深究
/*** 个人网上营业厅-公积金提取流水 Convert** @author 芋道源码*/
@Mapper
public interface TqGjjtqlsbConvert {TqGjjtqlsbConvert INSTANCE = Mapper(TqGjjtqlsbConvert.class);TqGjjtqlsbDO convert(TqGjjtqlsbCreateReqVO bean);TqGjjtqlsbDO convert(TqGjjtqlsbUpdateReqVO bean);TqGjjtqlsbRespVO convert(TqGjjtqlsbDO bean);List<TqGjjtqlsbRespVO> convertList(List<TqGjjtqlsbDO> list);PageResult<TqGjjtqlsbRespVO> convertPage(PageResult<TqGjjtqlsbDO> page);List<TqGjjtqlsbExcelVO> convertList02(List<TqGjjtqlsbDO> list);}
