From 4e0e2808594c48896aa76c61b171bc83ae8089cd Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Thu, 22 Jul 2021 14:17:03 +0800
Subject: [PATCH] 202107022

---
 gc-sys/src/main/java/com/xzx/gc/system/dto/UpdateSysBannerDto.java            |   24 +++
 gc-sys/src/main/java/com/xzx/gc/system/dto/ViewSysBannerDto.java              |    8 +
 gc-sys/src/main/java/com/xzx/gc/system/service/BannerService.java             |   57 ++++++++
 gc-sys/src/main/resources/mapper/system/BannerMapper.xml                      |   31 ++++
 gc-shop/src/main/resources/sql                                                |    5 
 gc-sys/src/main/java/com/xzx/gc/system/dto/DelSysBannerDto.java               |   10 +
 gc-core/src/main/java/com/xzx/gc/entity/BannerInfo.java                       |    4 
 gc-sys/src/main/java/com/xzx/gc/system/dto/OnSysBannerDto.java                |   14 ++
 gc-sys/src/main/java/com/xzx/gc/system/controller/AdminSysNewsController.java |    2 
 gc-sys/src/main/java/com/xzx/gc/system/dto/SysBannerListDto.java              |   14 ++
 gc-sys/src/main/java/com/xzx/gc/system/vo/ViewSysBannerVo.java                |   35 +++++
 gc-sys/src/main/java/com/xzx/gc/system/dto/AddSysBannerDto.java               |   26 +++
 gc-sys/src/main/java/com/xzx/gc/system/mapper/BannerMapper.java               |   14 ++
 gc-sys/src/main/java/com/xzx/gc/system/vo/SysBannerListVo.java                |   37 +++++
 gc-sys/src/main/java/com/xzx/gc/system/controller/AdminBannerController.java  |  118 ++++++++++++++++
 15 files changed, 396 insertions(+), 3 deletions(-)

diff --git a/gc-core/src/main/java/com/xzx/gc/entity/BannerInfo.java b/gc-core/src/main/java/com/xzx/gc/entity/BannerInfo.java
index b3aedb9..526992e 100644
--- a/gc-core/src/main/java/com/xzx/gc/entity/BannerInfo.java
+++ b/gc-core/src/main/java/com/xzx/gc/entity/BannerInfo.java
@@ -8,7 +8,7 @@
 
 @Data
 @Table(name="xzx_sys_banner")
-public class BannerInfo {
+public class BannerInfo extends SysNews {
     @Id
     private Long id;
     @ApiModelProperty("图片名称")
@@ -26,6 +26,8 @@
 
     private String partnerId;
     private Integer cityId;
+    //状态 1:未上架 2:已上架
+    private Integer status;
 
 }
 
diff --git a/gc-shop/src/main/resources/sql b/gc-shop/src/main/resources/sql
index c6a337a..950c277 100644
--- a/gc-shop/src/main/resources/sql
+++ b/gc-shop/src/main/resources/sql
@@ -73,6 +73,11 @@
 ALTER TABLE `xzx_sys_news`
 ADD COLUMN `status`  int(1) NULL DEFAULT 1 COMMENT '状态 1:未发布 2:已发布' AFTER `sort`;
 
+ALTER TABLE `xzx_sys_banner`
+ADD COLUMN `status`  int(1) NULL DEFAULT 1 COMMENT '状态 1:未上架 2:已上架' AFTER `city_id`;
+
+
+
 
 
 
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/controller/AdminBannerController.java b/gc-sys/src/main/java/com/xzx/gc/system/controller/AdminBannerController.java
new file mode 100644
index 0000000..56f8ad3
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/controller/AdminBannerController.java
@@ -0,0 +1,118 @@
+package com.xzx.gc.system.controller;
+
+import cn.hutool.core.util.ObjectUtil;
+import com.xzx.gc.common.constant.CommonEnum;
+import com.xzx.gc.common.constant.Constants;
+import com.xzx.gc.common.dto.log.OperationAppLog;
+import com.xzx.gc.common.request.BaseController;
+import com.xzx.gc.entity.BannerInfo;
+import com.xzx.gc.model.JsonResult;
+import com.xzx.gc.system.dto.*;
+import com.xzx.gc.system.mapper.BannerMapper;
+import com.xzx.gc.system.service.BannerService;
+import com.xzx.gc.system.vo.SysBannerListVo;
+import com.xzx.gc.system.vo.ViewSysBannerVo;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import io.swagger.annotations.ApiResponse;
+import io.swagger.annotations.ApiResponses;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RestController;
+
+import javax.annotation.Resource;
+import javax.servlet.http.HttpServletRequest;
+import java.util.Date;
+import java.util.Map;
+
+@RestController
+@Api(tags = {"轮播图"})
+@Slf4j
+public class AdminBannerController extends BaseController {
+
+    @Autowired
+    private BannerService bannerService;
+
+    @Resource
+    BannerMapper bannerMapper;
+
+    @ApiOperation(value = "轮播图--列表")
+    @ApiResponses(
+            @ApiResponse(code = 200, message = "success", response = SysBannerListVo.class)
+    )
+    @PostMapping(value = Constants.ADMIN_VIEW_PREFIX + "/sysBanner/sysBannerList.json")
+    public JsonResult<Map<String, Object>> sysBannerList(@RequestBody SysBannerListDto sysBannerListDto) {
+        return JsonResult.success(bannerService.sysBannerList(sysBannerListDto));
+    }
+
+    @PostMapping(Constants.ADMIN_VIEW_PREFIX+"/sysBanner/addSysBanner.json")
+    @ApiOperation(value = "轮播图--添加", notes = "test: 仅0有正确返回")
+    public JsonResult<String> addSysBanner(@RequestBody AddSysBannerDto model, HttpServletRequest request) {
+
+        model.setCreateTime(new Date());
+        bannerService.addSysBanner(model);
+        OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request))
+                .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("轮播图--添加-").build();
+        mqUtil.sendApp(build);
+        return  JsonResult.success("操作成功!");
+    }
+
+    @PostMapping(Constants.ADMIN_VIEW_PREFIX + "/sysBanner/viewSysBanner.json")
+    @ApiResponses({@ApiResponse( code = 200, message = "success", response = ViewSysBannerVo.class)})
+    @ApiOperation(value="轮播图--查看详情", notes="test: 仅0有正确返回")
+    public JsonResult<ViewSysBannerVo> viewSysBanner(@RequestBody ViewSysBannerDto viewSysNewsDto) {
+        Long id = viewSysNewsDto.getId();
+        ViewSysBannerVo viewSysBannerVo = bannerService.viewSysBanner(id);
+        return JsonResult.success(viewSysBannerVo);
+    }
+
+    @PostMapping(Constants.ADMIN_VIEW_PREFIX + "/sysBanner/updateSysBanner.json")
+    @ApiOperation(value="轮播图--更新详情", notes="test: 仅0有正确返回")
+    public JsonResult updateSysBanner(@RequestBody UpdateSysBannerDto model, HttpServletRequest request) {
+        long id = model.getId();
+        BannerInfo bannerInfo = bannerMapper.selectBannerById(id);
+        if(ObjectUtil.isEmpty(bannerInfo)){
+            return JsonResult.failMessage("当前记录不存在!");
+        }
+        bannerService.updateSysBanner(model);
+        OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request))
+                .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("轮播图--更新详情-" + id).build();
+        mqUtil.sendApp(build);
+        return  JsonResult.success("操作成功!");
+    }
+
+    @PostMapping(Constants.ADMIN_VIEW_PREFIX + "/sysBanner/delSysBanner.json")
+    @ApiOperation(value="轮播图--删除", notes="test: 仅0有正确返回")
+    public JsonResult delSysBanner(@RequestBody DelSysBannerDto model, HttpServletRequest request) {
+        long id = model.getId();
+        BannerInfo bannerInfo = bannerMapper.selectBannerById(id);
+        if(ObjectUtil.isEmpty(bannerInfo)){
+            return JsonResult.failMessage("当前记录不存在!");
+        }
+        bannerService.delSysBanner(model);
+        OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request))
+                .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("轮播图--删除-" + id).build();
+        mqUtil.sendApp(build);
+        return  JsonResult.success("操作成功!");
+    }
+
+    @PostMapping(Constants.ADMIN_VIEW_PREFIX + "/sysBanner/onOffSysBanner.json")
+    @ApiOperation(value="轮播图--上下架", notes="test: 仅0有正确返回")
+    public JsonResult onOffSysBanner(@RequestBody OnSysBannerDto model, HttpServletRequest request) {
+        long id = model.getId();
+        BannerInfo bannerInfo = bannerMapper.selectBannerById(id);
+        if(ObjectUtil.isEmpty(bannerInfo)){
+            return JsonResult.failMessage("当前记录不存在!");
+        }
+        bannerService.onOffSysBanner(model);
+        OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request))
+                .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("轮播图--上下架-" + id).build();
+        mqUtil.sendApp(build);
+        return  JsonResult.success("操作成功!");
+    }
+
+
+
+}
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/controller/AdminSysNewsController.java b/gc-sys/src/main/java/com/xzx/gc/system/controller/AdminSysNewsController.java
index 2bdceef..e536c76 100644
--- a/gc-sys/src/main/java/com/xzx/gc/system/controller/AdminSysNewsController.java
+++ b/gc-sys/src/main/java/com/xzx/gc/system/controller/AdminSysNewsController.java
@@ -111,7 +111,7 @@
         }
         sysNewsService.onOffSysNews(model);
         OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request))
-                .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("广播通知--删除-" + id).build();
+                .methodName(Constants.SCORESHOP_MODUL_NAME).operateAction("广播通知--上下架-" + id).build();
         mqUtil.sendApp(build);
         return  JsonResult.success("操作成功!");
     }
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/dto/AddSysBannerDto.java b/gc-sys/src/main/java/com/xzx/gc/system/dto/AddSysBannerDto.java
new file mode 100644
index 0000000..e4063dd
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/dto/AddSysBannerDto.java
@@ -0,0 +1,26 @@
+package com.xzx.gc.system.dto;
+
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.util.Date;
+
+@Data
+public class AddSysBannerDto {
+
+    @ApiModelProperty("图片名称")
+    private String picName;
+
+    @ApiModelProperty("图片链接")
+    private String picUrl;
+
+    @ApiModelProperty("排序")
+    private Integer sort;
+
+    @ApiModelProperty(value="创建时间")
+    private Date createTime;
+
+    @ApiModelProperty("状态 1:未上架 2:已上架")
+    private Integer status;
+
+}
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/dto/DelSysBannerDto.java b/gc-sys/src/main/java/com/xzx/gc/system/dto/DelSysBannerDto.java
new file mode 100644
index 0000000..a3b5fb5
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/dto/DelSysBannerDto.java
@@ -0,0 +1,10 @@
+package com.xzx.gc.system.dto;
+
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+public class DelSysBannerDto {
+    @ApiModelProperty(value = "Id")
+    private long id;
+}
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/dto/OnSysBannerDto.java b/gc-sys/src/main/java/com/xzx/gc/system/dto/OnSysBannerDto.java
new file mode 100644
index 0000000..9cb840c
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/dto/OnSysBannerDto.java
@@ -0,0 +1,14 @@
+package com.xzx.gc.system.dto;
+
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+public class OnSysBannerDto {
+
+    @ApiModelProperty(value = "Id")
+    private long id;
+
+    @ApiModelProperty(value = "状态 1:未上架 2:已上架")
+    private Integer status;
+}
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/dto/SysBannerListDto.java b/gc-sys/src/main/java/com/xzx/gc/system/dto/SysBannerListDto.java
new file mode 100644
index 0000000..5a187b1
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/dto/SysBannerListDto.java
@@ -0,0 +1,14 @@
+package com.xzx.gc.system.dto;
+
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+public class SysBannerListDto {
+
+    @ApiModelProperty(value = "第几页", required = true)
+    private int page;
+
+    @ApiModelProperty(value = "每一页数量", required = true)
+    private int limit;
+}
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/dto/UpdateSysBannerDto.java b/gc-sys/src/main/java/com/xzx/gc/system/dto/UpdateSysBannerDto.java
new file mode 100644
index 0000000..a49a8fa
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/dto/UpdateSysBannerDto.java
@@ -0,0 +1,24 @@
+package com.xzx.gc.system.dto;
+
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+public class UpdateSysBannerDto {
+
+    @ApiModelProperty("id")
+    private Long id;
+
+    @ApiModelProperty("图片名称")
+    private String picName;
+
+//    @ApiModelProperty("图片路径")
+//    private String picPath;
+
+    @ApiModelProperty("图片链接")
+    private String picUrl;
+
+    @ApiModelProperty("排序")
+    private Integer sort;
+
+}
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/dto/ViewSysBannerDto.java b/gc-sys/src/main/java/com/xzx/gc/system/dto/ViewSysBannerDto.java
new file mode 100644
index 0000000..de3dd67
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/dto/ViewSysBannerDto.java
@@ -0,0 +1,8 @@
+package com.xzx.gc.system.dto;
+
+import lombok.Data;
+
+@Data
+public class ViewSysBannerDto {
+    private Long id;
+}
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/mapper/BannerMapper.java b/gc-sys/src/main/java/com/xzx/gc/system/mapper/BannerMapper.java
index 775cbe0..72040ac 100644
--- a/gc-sys/src/main/java/com/xzx/gc/system/mapper/BannerMapper.java
+++ b/gc-sys/src/main/java/com/xzx/gc/system/mapper/BannerMapper.java
@@ -3,7 +3,11 @@
 import com.xzx.gc.entity.BannerInfo;
 import com.xzx.gc.model.admin.BannerModel;
 import com.xzx.gc.model.system.ConfigInfoVo;
+import com.xzx.gc.system.dto.SysBannerListDto;
+import com.xzx.gc.system.vo.SysBannerListVo;
+import com.xzx.gc.system.vo.ViewSysBannerVo;
 import com.xzx.gc.util.GcMapper;
+import org.apache.ibatis.annotations.Param;
 import org.springframework.stereotype.Repository;
 
 import java.util.List;
@@ -42,5 +46,15 @@
      */
     int delBanner(String id);
 
+    List<SysBannerListVo> selectSysBanner(SysBannerListDto sysBannerListDto);
+
+    BannerInfo selectBannerById(@Param("id")Long id);
+
+    void updateBannerById(@Param("sort")Integer sort, @Param("picUrl")String picUrl,
+                          @Param("picName")String picName, @Param("id")Long id);
+
+    void delSysBannerById(@Param("id")long id);
+
+    void updateStatusById(@Param("id")long id, @Param("status")Integer status);
 }
 
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/service/BannerService.java b/gc-sys/src/main/java/com/xzx/gc/system/service/BannerService.java
index 98c9b53..4ada7e8 100644
--- a/gc-sys/src/main/java/com/xzx/gc/system/service/BannerService.java
+++ b/gc-sys/src/main/java/com/xzx/gc/system/service/BannerService.java
@@ -1,16 +1,23 @@
 package com.xzx.gc.system.service;
 
+import cn.hutool.core.convert.Convert;
 import cn.hutool.core.date.DateUtil;
 import com.github.pagehelper.PageHelper;
 import com.github.pagehelper.PageInfo;
+import com.xzx.gc.entity.BannerInfo;
 import com.xzx.gc.entity.CityPartner;
 import com.xzx.gc.entity.CoreUser;
 import com.xzx.gc.model.JsonResult;
 import com.xzx.gc.model.admin.BannerModel;
+import com.xzx.gc.system.dto.*;
 import com.xzx.gc.system.mapper.BannerMapper;
+import com.xzx.gc.system.vo.SysBannerListVo;
+import com.xzx.gc.system.vo.SysNewsListVo;
+import com.xzx.gc.system.vo.ViewSysBannerVo;
 import com.xzx.gc.util.SessionUtil;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.boot.Banner;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 
@@ -96,5 +103,53 @@
     public int delBannerApi(String id) {
         return bannerMapper.delBanner(id);
     }
-    
+
+    public Map<String, Object> sysBannerList(SysBannerListDto sysBannerListDto) {
+        PageHelper.startPage(sysBannerListDto.getPage(), sysBannerListDto.getLimit());
+        List<SysBannerListVo> sysBannerListVos = bannerMapper.selectSysBanner(sysBannerListDto);
+        PageInfo<SysBannerListVo> pageInfo = new PageInfo<>(sysBannerListVos);
+
+        Map<String, Object> data = new HashMap<>();
+        int count = Convert.toInt(pageInfo.getTotal());
+        data.put("data", sysBannerListVos);
+        data.put("count", count);
+        data.put("code", 0);
+        return data;
+    }
+
+    public void addSysBanner(AddSysBannerDto model) {
+        BannerInfo bannerInfo = new BannerInfo();
+        bannerInfo.setCreateTime(DateUtil.format(model.getCreateTime(),"yyyy-MM-dd HH:mm:ss"));
+        bannerInfo.setStatus(model.getStatus());
+        bannerInfo.setDelFlag(0);
+        bannerInfo.setPicName(model.getPicName());
+        bannerInfo.setPicUrl(model.getPicUrl());
+        bannerInfo.setSort(model.getSort());
+        bannerMapper.insertSelective(bannerInfo);
+    }
+
+    public ViewSysBannerVo viewSysBanner(Long id) {
+        BannerInfo bannerInfo = bannerMapper.selectBannerById(id);
+        ViewSysBannerVo viewSysBannerVo = new ViewSysBannerVo();
+        viewSysBannerVo.setSort(bannerInfo.getSort());
+        viewSysBannerVo.setStatus(bannerInfo.getStatus());
+        viewSysBannerVo.setCreateTime(bannerInfo.getCreateTime());
+        viewSysBannerVo.setId(bannerInfo.getId());
+        viewSysBannerVo.setPicName(bannerInfo.getPicName());
+        viewSysBannerVo.setPicUrl(bannerInfo.getPicUrl());
+        return viewSysBannerVo;
+    }
+
+    public void updateSysBanner(UpdateSysBannerDto model) {
+
+        bannerMapper.updateBannerById(model.getSort(),model.getPicUrl(),model.getPicName(),model.getId());
+    }
+
+    public void delSysBanner(DelSysBannerDto model) {
+        bannerMapper.delSysBannerById(model.getId());
+    }
+
+    public void onOffSysBanner(OnSysBannerDto model) {
+        bannerMapper.updateStatusById(model.getId(),model.getStatus());
+    }
 }
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/vo/SysBannerListVo.java b/gc-sys/src/main/java/com/xzx/gc/system/vo/SysBannerListVo.java
new file mode 100644
index 0000000..f15e058
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/vo/SysBannerListVo.java
@@ -0,0 +1,37 @@
+package com.xzx.gc.system.vo;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import javax.persistence.Id;
+
+@Data
+@ApiModel(value = "SysBannerListVo", description = "返回参数类")
+public class SysBannerListVo {
+
+    @ApiModelProperty("id")
+    private Long id;
+
+    @ApiModelProperty("图片名称")
+    private String picName;
+
+//    @ApiModelProperty("图片路径")
+//    private String picPath;
+
+    @ApiModelProperty("图片链接")
+    private String picUrl;
+
+    @ApiModelProperty("排序")
+    private Integer sort;
+
+    @ApiModelProperty("删除0:未删除,1:删除")
+    private Integer delFlag;
+
+    @ApiModelProperty("创建时间")
+    private String createTime;
+
+    @ApiModelProperty("状态 1:未上架 2:已上架")
+    private Integer status;
+
+}
diff --git a/gc-sys/src/main/java/com/xzx/gc/system/vo/ViewSysBannerVo.java b/gc-sys/src/main/java/com/xzx/gc/system/vo/ViewSysBannerVo.java
new file mode 100644
index 0000000..6322828
--- /dev/null
+++ b/gc-sys/src/main/java/com/xzx/gc/system/vo/ViewSysBannerVo.java
@@ -0,0 +1,35 @@
+package com.xzx.gc.system.vo;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+@ApiModel(value = "ViewSysBannerVo", description = "返回参数类")
+public class ViewSysBannerVo {
+
+    @ApiModelProperty("id")
+    private Long id;
+
+    @ApiModelProperty("图片名称")
+    private String picName;
+
+//    @ApiModelProperty("图片路径")
+//    private String picPath;
+
+    @ApiModelProperty("图片链接")
+    private String picUrl;
+
+    @ApiModelProperty("排序")
+    private Integer sort;
+
+    @ApiModelProperty("删除0:未删除,1:删除")
+    private Integer delFlag;
+
+    @ApiModelProperty("创建时间")
+    private String createTime;
+
+    @ApiModelProperty("状态 1:未上架 2:已上架")
+    private Integer status;
+
+}
diff --git a/gc-sys/src/main/resources/mapper/system/BannerMapper.xml b/gc-sys/src/main/resources/mapper/system/BannerMapper.xml
index 3a08b1d..339e9c6 100644
--- a/gc-sys/src/main/resources/mapper/system/BannerMapper.xml
+++ b/gc-sys/src/main/resources/mapper/system/BannerMapper.xml
@@ -89,4 +89,35 @@
         SET del_flag = 1
         WHERE id = #{id}
     </delete>
+
+    <select id="selectSysBanner" resultType="com.xzx.gc.system.vo.SysBannerListVo">
+        select * from xzx_sys_banner
+        order by sort ASC
+    </select>
+
+    <select id="selectBannerById" resultType="com.xzx.gc.entity.BannerInfo">
+        select * from xzx_sys_banner where id = #{id}
+        order by sort ASC
+    </select>
+
+    <update id="updateBannerById" parameterType="java.util.Map">
+        update xzx_sys_banner
+        set sort = #{sort},
+            pic_name = #{picName},
+            pic_url = #{picUrl}
+        where  id = #{id}
+    </update>
+
+    <update id="delSysBannerById" parameterType="java.util.Map">
+        update xzx_sys_banner
+        set del_flag = 1
+        where  id = #{id}
+    </update>
+
+
+    <update id="updateStatusById" parameterType="java.util.Map">
+        update xzx_sys_banner
+        set status = #{status}
+        where  id = #{id}
+    </update>
 </mapper>
\ No newline at end of file

--
Gitblit v1.9.1