上海网站设计工具,如何用dreamer做网站,长沙网站制作的,wordpress数据库设计目录
需求文档
公积金销户类
controller层 service层
service层实现类
1.验证 #xff08;个人账户#xff09;
2.提交#xff08;添加#xff09;
controller层
service层
service层实现类
3.分页查询
controller层
service层
service层实现类
4. 详情查询…目录
需求文档
公积金销户类
controller层 service层
service层实现类
1.验证 个人账户
2.提交添加
controller层
service层
service层实现类
3.分页查询
controller层
service层
service层实现类
4. 详情查询
controller层
service层
service层实现类 需求文档 公积金销户流水表提交添加、分页、查看详情查询、验证个人账户 在离职、退休、提前退休的情况下会将公积金账户注销并取出里面资金 公积金销户类
controller层
Tag(name 管理后台-销户-公积金销户)
RestController
RequestMapping(/business/tq-gjjxh)
Validated
public class TqGjjxhlsbController {Resourceprivate TqGjjxhlsbService tqGjjxhlsbService;...(类中功能方法)} service层
/*** 个人网上营业厅-公积金销户流水 Service 接口** author 芋道源码*/
public interface TqGjjxhlsbService {...
}
service层实现类
/*** 个人网上营业厅-公积金销户流水 Service 实现类** author 芋道源码*/
Service
Validated
public class TqGjjxhlsbServiceImpl implements TqGjjxhlsbService {Resourceprivate TqGjjxhlsbMapper tqGjjxhlsbMapper;...
} 1.验证 个人账户 /*** 根据vo中的定义验证参数合法后验证请求数据合法性* param createReqVO 暂存、直接保存请求参数* return SaveGeneralReturn*/private CommonResultSaveGeneralReturn validateData(TqGjjxhlsbCreateReqVO createReqVO){SaveGeneralReturn saveGeneralReturnnew SaveGeneralReturn();ListErrorCode errorCodeListnew ArrayList();//传入参数不合法/*******判断网厅是否存在未审批记录*************/LambdaQueryWrapperTqGjjxhlsbDO queryWrapper new LambdaQueryWrapper();queryWrapper.eq(TqGjjxhlsbDO::getGrzh,createReqVO.getGrzh());queryWrapper.ne(TqGjjxhlsbDO::getYwzt,100);ListTqGjjxhlsbDO tqGjjxhlsbDOList tqGjjxhlsbService.getSelectList(queryWrapper);if (tqGjjxhlsbDOList ! null tqGjjxhlsbDOList.size() 0) {errorCodeList.add(GJJXHLSB_WSP);}saveGeneralReturn.setValidate(errorCodeList.size() 0);saveGeneralReturn.setErrorCount(errorCodeList.size());saveGeneralReturn.setErrorCodes(errorCodeList);//特殊判断return success(saveGeneralReturn);} 通过查询数据库表TqGjjxhlsbDO来判断具体查询条件是根据createReqVO中的grzh属性等于表中的grzh并且ywzt属性不等于100。如果查询结果不为空且数量大于0将给予错误码GJJXHLSB_WSP公积金提取流水表未审批提示。个人账户具有唯一性相同的个人账户不予添加。 2.提交添加
controller层 /***提交 保存数据 注意业务状态* */PostMapping(/create)Operation(summary 公积金销户_保存)public CommonResultSaveGeneralReturn createTqGjjxhlsb(Valid RequestBody TqGjjxhlsbCreateReqVO createReqVO){CommonResultSaveGeneralReturn validatedReturnvalidateData(createReqVO);SaveGeneralReturn validatedvalidatedReturn.getData();if(validated.getValidate()){createReqVO.setYwzt(0);BigDecimal id tqGjjxhlsbService.createTqGjjxhlsb(createReqVO);validated.setId(id);validated.setSuccessMsg(暂存成功);return success(validated);}return error(validatedReturn);} 通过判断validated对象的validate属性是否为true来确定是否通过了数据验证。如果通过验证即为库中不存在相同账户的额数据将createReqVO的ywzt属性设置为0 调用tqGjjxhlsbService.createTqGjjxhlsb(createReqVO)方法保存数据并将返回的id赋值给validated对象的id属性。随后设置validated对象的successMsg属性为暂存成功并返回success(validated)。 service层 /*** 创建个人网上营业厅-公积金销户流水** param createReqVO 创建信息* return 编号*/BigDecimal createTqGjjxhlsb(Valid TqGjjxhlsbCreateReqVO createReqVO);
service层实现类 Overridepublic BigDecimal createTqGjjxhlsb(TqGjjxhlsbCreateReqVO createReqVO) {// 插入TqGjjxhlsbDO tqGjjxhlsb TqGjjxhlsbConvert.INSTANCE.convert(createReqVO);tqGjjxhlsbMapper.insert(tqGjjxhlsb);// 返回return tqGjjxhlsb.getId();} 3.分页查询
controller层 /*** param pageVO 请求参数包括分页参数* return PageResultTqGjjxhlsbRespVO*/GetMapping(/page)Operation(summary 公积金销户_分页查询)public CommonResultPageResultTqGjjxhlsbRespVO getTqGjjxhlsbPage(Valid TqGjjxhlsbPageReqVO pageVO){PageResultTqGjjxhlsbDO pageResult tqGjjxhlsbService.getTqGjjxhlsbPage(pageVO);return success(TqGjjxhlsbConvert.INSTANCE.convertPage(pageResult));}
service层 /*** 获得个人网上营业厅-公积金销户流水分页** param pageReqVO 分页查询* return 个人网上营业厅-公积金销户流水分页*/PageResultTqGjjxhlsbDO getTqGjjxhlsbPage(TqGjjxhlsbPageReqVO pageReqVO);
service层实现类 Overridepublic PageResultTqGjjxhlsbDO getTqGjjxhlsbPage(TqGjjxhlsbPageReqVO pageReqVO) {return tqGjjxhlsbMapper.selectPage(pageReqVO);} 4. 详情查询
controller层 /*** 详情* param id 查询参数* result TqGjjxhlsbRespVO*/GetMapping(/get)Operation(summary 公积金销户_查看详情)Parameter(name id, description 编号, required true, example 1024)public CommonResultTqGjjxhlsbRespVO getTqGjjxhlsb(RequestParam(id) BigDecimal id){TqGjjxhlsbDO tqGjjxhlsb tqGjjxhlsbService.getTqGjjxhlsb(id);return success(TqGjjxhlsbConvert.INSTANCE.convert(tqGjjxhlsb));}
service层 /*** 获得个人网上营业厅-公积金销户流水** param id 编号* return 个人网上营业厅-公积金销户流水*/TqGjjxhlsbDO getTqGjjxhlsb(BigDecimal id);
service层实现类 Overridepublic TqGjjxhlsbDO getTqGjjxhlsb(BigDecimal id) {return tqGjjxhlsbMapper.selectById(id);}
