JAVA全系列 教程
3762个小节阅读:7092.4k
C语言快速入门
JAVA全系列 教程
面向对象的程序设计语言
Python全系列 教程
Python3.x版本,未来主流的版本
人工智能 教程
顺势而为,AI创新未来
大厂算法 教程
算法,程序员自我提升必经之路
C++ 教程
一门通用计算机编程语言
微服务 教程
目前业界流行的框架组合
web前端全系列 教程
通向WEB技术世界的钥匙
大数据全系列 教程
站在云端操控万千数据
AIGC全能工具班
A A
White Night
序号 | 接口名称 | 接口地址 | 请求类型 |
---|---|---|---|
1 | 分页查询供应商 | /erp/provider/listProviderForPage | get |
2 | 添加供应商 | /erp/provider/addProvider | post |
3 | 修改供应商 | /erp/provider/updateProvider | put |
4 | 根据id查询一个供应商 | /erp/provider/getProviderById/{providerId} | get |
5 | 删除供应商 | /erp/provider/deleteProviderByIds/{providerIds} | delete |
xxxxxxxxxx
package com.bjsxt.dto;
import ...
/**
*
* 供应商信息表
*/
value = "com-bjsxt-dto-ProviderDto") (
callSuper = true) (
public class ProviderDto extends BaseDto {
/**
* 供应商id
*/
value = "供应商id") (
private Long providerId;
/**
* 供应商名称
*/
message = "供应商名称不能为空") (
value = "供应商名称") (
private String providerName;
/**
* 联系人名称
*/
message = "联系人名称不能为空") (
value = "联系人名称") (
private String contactName;
/**
* 联系人手机
*/
message = "联系人手机不能为空") (
value = "联系人手机") (
private String contactMobile;
/**
* 联系人电话
*/
value = "联系人电话") (
private String contactTel;
/**
* 银行账号
*/
message = "银行账号不能为空") (
value = "银行账号") (
private String bankAccount;
/**
* 供应商地址
*/
value = "供应商地址") (
private String providerAddress;
/**
* 状态(0正常 1停用)sys_normal_disable
*/
message = "状态不能为空") (
value = "状态(0正常 1停用)sys_normal_disable") (
private String status;
}
xxxxxxxxxx
package com.bjsxt.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bjsxt.domain.Provider;
/**
*
*/
public interface ProviderMapper extends BaseMapper<Provider> {
}
ProviderMapper.xml
xxxxxxxxxx
<mapper namespace="com.bjsxt.mapper.ProviderMapper">
<resultMap id="BaseResultMap" type="com.bjsxt.domain.Provider">
<!--@mbg.generated-->
<!--@Table stock_provider-->
<id column="provider_id" jdbcType="BIGINT" property="providerId" />
<result column="provider_name" jdbcType="VARCHAR" property="providerName" />
<result column="contact_name" jdbcType="VARCHAR" property="contactName" />
<result column="contact_mobile" jdbcType="VARCHAR" property="contactMobile" />
<result column="contact_tel" jdbcType="VARCHAR" property="contactTel" />
<result column="bank_account" jdbcType="VARCHAR" property="bankAccount" />
<result column="provider_address" jdbcType="VARCHAR" property="providerAddress" />
<result column="status" jdbcType="CHAR" property="status" />
<result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
<result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
<result column="create_by" jdbcType="VARCHAR" property="createBy" />
<result column="update_by" jdbcType="VARCHAR" property="updateBy" />
</resultMap>
<sql id="Base_Column_List">
<!--@mbg.generated-->
provider_id, provider_name, contact_name, contact_mobile, contact_tel, bank_account,
provider_address, `status`, create_time, update_time, create_by, update_by
</sql>
</mapper>
xxxxxxxxxx
package com.bjsxt.service;
import com.bjsxt.domain.Provider;
import com.bjsxt.domain.Provider;
import com.baomidou.mybatisplus.extension.service.IService;
import com.bjsxt.dto.ProviderDto;
import com.bjsxt.vo.DataGridView;
import java.util.List;
/**
*
*/
public interface ProviderService {
/**
* 分页查询
*
* @param providerDto
* @return
*/
DataGridView listProviderPage(ProviderDto providerDto);
}
xxxxxxxxxx
import ...
/**
* @Author:
*/
/**
* methods = {@Method(name = "addProvider",retries = 0)
* 代表当前类里面的addProvider这个主就去只调一次,不重试
*/
methods = { (name = "addProvider",retries = 0)}) (
public class ProviderServiceImpl implements ProviderService{
private ProviderMapper providerMapper;
public DataGridView listProviderPage(ProviderDto providerDto) {
Page<Provider> page=new Page<>(providerDto.getPageNum(),providerDto.getPageSize());
QueryWrapper<Provider> qw=new QueryWrapper<>();
qw.like(StringUtils.isNotBlank(providerDto.getProviderName()),Provider.COL_PROVIDER_NAME,providerDto.getProviderName());
qw.like(StringUtils.isNotBlank(providerDto.getContactName()),Provider.COL_CONTACT_NAME,providerDto.getContactName());
qw.and(StringUtils.isNotBlank(providerDto.getContactTel()), new Consumer<QueryWrapper<Provider>>() {
//(tel like ? or mobile like ?)
public void accept(QueryWrapper<Provider> providerQueryWrapper) {
providerQueryWrapper.like(Provider.COL_CONTACT_TEL,providerDto.getContactTel())
.or().like(Provider.COL_CONTACT_MOBILE,providerDto.getContactTel());
}
});
qw.eq(StringUtils.isNotBlank(providerDto.getStatus()),Provider.COL_STATUS,providerDto.getStatus());
this.providerMapper.selectPage(page,qw);
return new DataGridView(page.getTotal(),page.getRecords());
}
}
xxxxxxxxxx
package com.bjsxt.controller.erp;
import ...
"erp/provider") (
public class ProviderController {
//使用dubbo的引用
private ProviderService providerService;
/**
* 分页查询
*/
"listProviderForPage") (
public AjaxResult listProviderForPage(ProviderDto providerDto){
DataGridView gridView = this.providerService.listProviderPage(providerDto);
return AjaxResult.success("查询成功",gridView.getData(),gridView.getTotal());
}
}
分页查询供应商/erp/provider/listProviderForPage
创建ProviderDto
创建ProviderMapper、ProviderMapper.xml
xxxxxxxxxx
package com.bjsxt.service;
import com.bjsxt.domain.Provider;
import com.bjsxt.domain.Provider;
import com.baomidou.mybatisplus.extension.service.IService;
import com.bjsxt.dto.ProviderDto;
import com.bjsxt.vo.DataGridView;
import java.util.List;
/**
*
*/
public interface ProviderService {
/**
* 分页查询
*
* @param providerDto
* @return
*/
DataGridView listProviderPage(ProviderDto providerDto);
/**
* 添加
*
* @param providerDto
* @return
*/
int addProvider(ProviderDto providerDto);
}
xxxxxxxxxx
package com.bjsxt.controller.erp;
import ...
"erp/provider") (
public class ProviderController {
//使用dubbo的引用
private ProviderService providerService;
/**
* 分页查询
*/
"listProviderForPage") (
public AjaxResult listProviderForPage(ProviderDto providerDto){
DataGridView gridView = this.providerService.listProviderPage(providerDto);
return AjaxResult.success("查询成功",gridView.getData(),gridView.getTotal());
}
/**
* 添加
*/
"addProvider") (
title = "添加供应商",businessType = BusinessType.INSERT) (
public AjaxResult addProvider( ProviderDto providerDto) {
providerDto.setSimpleUser(ShiroSecurityUtils.getCurrentSimpleUser());
return AjaxResult.toAjax(this.providerService.addProvider(providerDto));
}
}
添加供应商/erp/provider/addProvider
创建ProviderDto
创建ProviderMapper、ProviderMapper.xml
xxxxxxxxxx
package com.bjsxt.service;
import com.bjsxt.domain.Provider;
import com.bjsxt.domain.Provider;
import com.baomidou.mybatisplus.extension.service.IService;
import com.bjsxt.dto.ProviderDto;
import com.bjsxt.vo.DataGridView;
import java.util.List;
/**
*
*/
public interface ProviderService {
/**
* 分页查询
*
* @param providerDto
* @return
*/
DataGridView listProviderPage(ProviderDto providerDto);
/**
* 添加
*
* @param providerDto
* @return
*/
int addProvider(ProviderDto providerDto);
/**
* 修改
*
* @param providerDto
* @return
*/
int updateProvider(ProviderDto providerDto);
}
xxxxxxxxxx
package com.bjsxt.controller.erp;
import ...
"erp/provider") (
public class ProviderController {
//使用dubbo的引用
private ProviderService providerService;
/**
* 分页查询
*/
"listProviderForPage") (
public AjaxResult listProviderForPage(ProviderDto providerDto){
DataGridView gridView = this.providerService.listProviderPage(providerDto);
return AjaxResult.success("查询成功",gridView.getData(),gridView.getTotal());
}
/**
* 添加
*/
"addProvider") (
title = "添加供应商",businessType = BusinessType.INSERT) (
public AjaxResult addProvider( ProviderDto providerDto) {
providerDto.setSimpleUser(ShiroSecurityUtils.getCurrentSimpleUser());
return AjaxResult.toAjax(this.providerService.addProvider(providerDto));
}
/**
* 修改
*/
"updateProvider") (
title = "修改供应商",businessType = BusinessType.UPDATE) (
public AjaxResult updateProvider( ProviderDto providerDto) {
providerDto.setSimpleUser(ShiroSecurityUtils.getCurrentSimpleUser());
return AjaxResult.toAjax(this.providerService.updateProvider(providerDto));
}
}
修改供应商/erp/provider/updateProvider
创建ProviderDto
创建ProviderMapper、ProviderMapper.xml
xxxxxxxxxx
package com.bjsxt.service;
import com.bjsxt.domain.Provider;
import com.bjsxt.domain.Provider;
import com.baomidou.mybatisplus.extension.service.IService;
import com.bjsxt.dto.ProviderDto;
import com.bjsxt.vo.DataGridView;
import java.util.List;
/**
*
*/
public interface ProviderService {
/**
* 分页查询
*
* @param providerDto
* @return
*/
DataGridView listProviderPage(ProviderDto providerDto);
/**
* 根据ID查询
*
* @param providerId
* @return
*/
Provider getOne(Long providerId);
/**
* 添加
*
* @param providerDto
* @return
*/
int addProvider(ProviderDto providerDto);
/**
* 修改
*
* @param providerDto
* @return
*/
int updateProvider(ProviderDto providerDto);
}
xxxxxxxxxx
package com.bjsxt.controller.erp;
import ...
"erp/provider") (
public class ProviderController {
//使用dubbo的引用
private ProviderService providerService;
/**
* 分页查询
*/
"listProviderForPage") (
public AjaxResult listProviderForPage(ProviderDto providerDto){
DataGridView gridView = this.providerService.listProviderPage(providerDto);
return AjaxResult.success("查询成功",gridView.getData(),gridView.getTotal());
}
/**
* 添加
*/
"addProvider") (
title = "添加供应商",businessType = BusinessType.INSERT) (
public AjaxResult addProvider( ProviderDto providerDto) {
providerDto.setSimpleUser(ShiroSecurityUtils.getCurrentSimpleUser());
return AjaxResult.toAjax(this.providerService.addProvider(providerDto));
}
/**
* 修改
*/
"updateProvider") (
title = "修改供应商",businessType = BusinessType.UPDATE) (
public AjaxResult updateProvider( ProviderDto providerDto) {
providerDto.setSimpleUser(ShiroSecurityUtils.getCurrentSimpleUser());
return AjaxResult.toAjax(this.providerService.updateProvider(providerDto));
}
/**
* 根据ID查询一个供应商信息
*/
"getProviderById/{providerId}") (
public AjaxResult getProviderById( (message = "供应商ID不能为空") Long providerId) {
return AjaxResult.success(this.providerService.getOne(providerId));
}
}
根据id查询一个供应商/erp/provider/getProviderById/{providerId}
创建ProviderDto
创建ProviderMapper、ProviderMapper.xml
xxxxxxxxxx
package com.bjsxt.service;
import com.bjsxt.domain.Provider;
import com.bjsxt.domain.Provider;
import com.baomidou.mybatisplus.extension.service.IService;
import com.bjsxt.dto.ProviderDto;
import com.bjsxt.vo.DataGridView;
import java.util.List;
/**
*
*/
public interface ProviderService {
/**
* 分页查询
*
* @param providerDto
* @return
*/
DataGridView listProviderPage(ProviderDto providerDto);
/**
* 根据ID查询
*
* @param providerId
* @return
*/
Provider getOne(Long providerId);
/**
* 添加
*
* @param providerDto
* @return
*/
int addProvider(ProviderDto providerDto);
/**
* 修改
*
* @param providerDto
* @return
*/
int updateProvider(ProviderDto providerDto);
/**
* 根据ID删除
*
* @param providerIds
* @return
*/
int deleteProviderByIds(Long[] providerIds);
}
xxxxxxxxxx
package com.bjsxt.controller.erp;
import ...
"erp/provider") (
public class ProviderController {
//使用dubbo的引用
private ProviderService providerService;
/**
* 分页查询
*/
"listProviderForPage") (
public AjaxResult listProviderForPage(ProviderDto providerDto){
DataGridView gridView = this.providerService.listProviderPage(providerDto);
return AjaxResult.success("查询成功",gridView.getData(),gridView.getTotal());
}
/**
* 添加
*/
"addProvider") (
title = "添加供应商",businessType = BusinessType.INSERT) (
public AjaxResult addProvider( ProviderDto providerDto) {
providerDto.setSimpleUser(ShiroSecurityUtils.getCurrentSimpleUser());
return AjaxResult.toAjax(this.providerService.addProvider(providerDto));
}
/**
* 修改
*/
"updateProvider") (
title = "修改供应商",businessType = BusinessType.UPDATE) (
public AjaxResult updateProvider( ProviderDto providerDto) {
providerDto.setSimpleUser(ShiroSecurityUtils.getCurrentSimpleUser());
return AjaxResult.toAjax(this.providerService.updateProvider(providerDto));
}
/**
* 根据ID查询一个供应商信息
*/
"getProviderById/{providerId}") (
public AjaxResult getProviderById( (message = "供应商ID不能为空") Long providerId) {
return AjaxResult.success(this.providerService.getOne(providerId));
}
/**
* 删除
*/
"deleteProviderByIds/{providerIds}") (
title = "删除供应商",businessType = BusinessType.DELETE) (
public AjaxResult deleteProviderByIds( (message = "要删除的ID不能为空") Long[] providerIds) {
return AjaxResult.toAjax(this.providerService.deleteProviderByIds(providerIds));
}
}
删除供应商/erp/provider/deleteProviderByIds/{providerIds}