From 7f8b679d1643c546bb061882f99668d9639d56cc Mon Sep 17 00:00:00 2001 From: liusheng <337615773@qq.com> Date: 星期三, 26 二月 2025 10:06:44 +0800 Subject: [PATCH] 代码提交 --- smartor/src/main/java/com/smartor/mapper/BaseDictOperationMapper.java | 63 +++++ ruoyi-admin/src/main/resources/application-druid.yml | 16 smartor/smartor.iml | 1 smartor/src/main/java/com/smartor/service/IBaseDictOperationService.java | 61 +++++ smartor/src/main/java/com/smartor/domain/BaseDictOperation.java | 105 ++++++++ ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/BaseDictOperationController.java | 113 +++++++++ smartor/src/main/java/com/smartor/service/impl/BaseDictOperationServiceImpl.java | 96 ++++++++ smartor/src/main/resources/mapper/smartor/BaseDictOperationMapper.xml | 264 ++++++++++++++++++++++ 8 files changed, 710 insertions(+), 9 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/BaseDictOperationController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/BaseDictOperationController.java new file mode 100644 index 0000000..38490eb --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/BaseDictOperationController.java @@ -0,0 +1,113 @@ +package com.ruoyi.web.controller.smartor; + +import java.util.List; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import javax.servlet.http.HttpServletResponse; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.smartor.domain.BaseDictOperation; +import com.smartor.service.IBaseDictOperationService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 鎵嬫湳鍩虹淇℃伅Controller + * + * @author lihu + * @date 2025-02-26 + */ +@Api("鎵嬫湳鍩虹淇℃伅") +@RestController +@RequestMapping("/smartor/baseopera") +public class BaseDictOperationController extends BaseController +{ + @Autowired + private IBaseDictOperationService baseDictOperationService; + + /** + * 鏌ヨ鎮h�呮鏌ユ楠岃褰曞瓙鍒楄〃 + */ + @ApiOperation("鏌ヨ鎮h�呮鏌ユ楠岃褰曞瓙鍒楄〃") + //@PreAuthorize("@ss.hasPermi('smartor:operation:list')") + @PostMapping("/list") + public TableDataInfo list(BaseDictOperation baseDictOperation) + { + startPage(); + List<BaseDictOperation> list = baseDictOperationService.selectBaseDictOperationList(baseDictOperation); + return getDataTable(list); + } + + /** + * 瀵煎嚭鎮h�呮鏌ユ楠岃褰曞瓙鍒楄〃 + */ + @ApiOperation("瀵煎嚭鎮h�呮鏌ユ楠岃褰曞瓙鍒楄〃") + //@PreAuthorize("@ss.hasPermi('smartor:operation:export')") + @Log(title = "鎮h�呮鏌ユ楠岃褰曞瓙", businessType = BusinessType.EXPORT) + @PostMapping("/export") + public void export(HttpServletResponse response, BaseDictOperation baseDictOperation) + { + List<BaseDictOperation> list = baseDictOperationService.selectBaseDictOperationList(baseDictOperation); + ExcelUtil<BaseDictOperation> util = new ExcelUtil<BaseDictOperation>(BaseDictOperation.class); + util.exportExcel(response, list, "鎮h�呮鏌ユ楠岃褰曞瓙鏁版嵁"); + } + + /** + * 鑾峰彇鎮h�呮鏌ユ楠岃褰曞瓙璇︾粏淇℃伅 + */ + @ApiOperation("鑾峰彇鎮h�呮鏌ユ楠岃褰曞瓙璇︾粏淇℃伅") + //@PreAuthorize("@ss.hasPermi('smartor:operation:query')") + @GetMapping(value = "/getInfo/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) + { + return success(baseDictOperationService.selectBaseDictOperationById(id)); + } + + /** + * 鏂板鎮h�呮鏌ユ楠岃褰曞瓙 + */ + @ApiOperation("鏂板鎮h�呮鏌ユ楠岃褰曞瓙") + //@PreAuthorize("@ss.hasPermi('smartor:operation:add')") + @Log(title = "鎮h�呮鏌ユ楠岃褰曞瓙", businessType = BusinessType.INSERT) + @PostMapping("/add") + public AjaxResult add(@RequestBody BaseDictOperation baseDictOperation) + { + return toAjax(baseDictOperationService.insertBaseDictOperation(baseDictOperation)); + } + + /** + * 淇敼鎮h�呮鏌ユ楠岃褰曞瓙 + */ + @ApiOperation("淇敼鎮h�呮鏌ユ楠岃褰曞瓙") + //@PreAuthorize("@ss.hasPermi('smartor:operation:edit')") + @Log(title = "鎮h�呮鏌ユ楠岃褰曞瓙", businessType = BusinessType.UPDATE) + @PostMapping("/edit") + public AjaxResult edit(@RequestBody BaseDictOperation baseDictOperation) + { + return toAjax(baseDictOperationService.updateBaseDictOperation(baseDictOperation)); + } + + /** + * 鍒犻櫎鎮h�呮鏌ユ楠岃褰曞瓙 + */ + @ApiOperation("鍒犻櫎鎮h�呮鏌ユ楠岃褰曞瓙") + //@PreAuthorize("@ss.hasPermi('smartor:operation:remove')") + @Log(title = "鎮h�呮鏌ユ楠岃褰曞瓙", businessType = BusinessType.DELETE) + @GetMapping("/remove/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(baseDictOperationService.deleteBaseDictOperationByIds(ids)); + } +} diff --git a/ruoyi-admin/src/main/resources/application-druid.yml b/ruoyi-admin/src/main/resources/application-druid.yml index 1ff5cb5..b9380a5 100644 --- a/ruoyi-admin/src/main/resources/application-druid.yml +++ b/ruoyi-admin/src/main/resources/application-druid.yml @@ -13,10 +13,10 @@ # 鍏徃 # url: jdbc:mysql://192.168.2.9:3308/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 # 涓芥按 - url: jdbc:mysql://127.0.0.1:3308/smartor-lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 - username: smartor - password: Smartor.2023 - driverClassName: com.mysql.cj.jdbc.Driver +# url: jdbc:mysql://127.0.0.1:3308/smartor-lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 + # username: smartor + # password: Smartor.2023 + # driverClassName: com.mysql.cj.jdbc.Driver # 鏂板崕 # url: jdbc:mysql://192.168.191.181:3308/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 # username: smartor @@ -24,10 +24,10 @@ # driverClassName: com.mysql.cj.jdbc.Driver # 鍏徃浜� -# url: jdbc:mysql://116.62.18.175:6002/smartor_lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 -# username: hxsoft -# password: Hxerp2000 -# driverClassName: com.mysql.cj.jdbc.Driver + url: jdbc:mysql://116.62.18.175:6002/smartor_lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 + username: hxsoft + password: Hxerp2000 + driverClassName: com.mysql.cj.jdbc.Driver # 浠庡簱鏁版嵁婧� slave: diff --git a/smartor/smartor.iml b/smartor/smartor.iml index 07406fc..6014cad 100644 --- a/smartor/smartor.iml +++ b/smartor/smartor.iml @@ -32,7 +32,6 @@ <orderEntry type="library" name="Maven: com.aliyun:tea:1.2.0" level="project" /> <orderEntry type="library" name="Maven: com.aliyun:tea-rpc-util:0.1.2" level="project" /> <orderEntry type="library" name="Maven: dom4j:dom4j:1.6.1" level="project" /> - <orderEntry type="library" name="Maven: xml-apis:xml-apis:1.0.b2" level="project" /> <orderEntry type="library" name="Maven: com.sun.xml.bind:jaxb-core:2.3.0" level="project" /> <orderEntry type="library" name="Maven: com.sun.xml.bind:jaxb-impl:2.3.0" level="project" /> <orderEntry type="library" name="Maven: com.aliyun:tea-openapi:0.2.8" level="project" /> diff --git a/smartor/src/main/java/com/smartor/domain/BaseDictOperation.java b/smartor/src/main/java/com/smartor/domain/BaseDictOperation.java new file mode 100644 index 0000000..5099800 --- /dev/null +++ b/smartor/src/main/java/com/smartor/domain/BaseDictOperation.java @@ -0,0 +1,105 @@ +package com.smartor.domain; + +import com.fasterxml.jackson.annotation.JsonFormat; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.util.Date; + +/** + * 鎮h�呮鏌ユ楠岃褰曞瓙瀵硅薄 base_dict_operation + * + * @author lihu + * @date 2025-02-26 + */ +@Data +@ApiModel("鎮h�呮鏌ユ楠岃褰曞瓙") +public class BaseDictOperation extends BaseEntity + { +private static final long serialVersionUID = 1L; + + /** 鑷ID */ + @ApiModelProperty("鑷ID") + //鏁版嵁搴撹嚜澧炴敼鎴怈TableId(type = IdType.AUTO) + private Long id; + + /** his鎵嬫湳id */ + @ApiModelProperty("his鎵嬫湳id") + @Excel(name = "his鎵嬫湳id") + private Long opid; + + /** 鎵嬫湳鍚嶇ОID */ + @ApiModelProperty("鎵嬫湳鍚嶇ОID") + @Excel(name = "鎵嬫湳鍚嶇ОID") + private String opcode; + + /** 鎵嬫湳鍚嶇О */ + @ApiModelProperty("鎵嬫湳鍚嶇О") + @Excel(name = "鎵嬫湳鍚嶇О") + private String opdesc; + + /** 鍒囧彛绫诲埆浠g爜 */ + @ApiModelProperty("鍒囧彛绫诲埆浠g爜") + @Excel(name = "鍒囧彛绫诲埆浠g爜") + private String incitypecode; + + /** 鍒囧彛绫诲埆鍚嶇О */ + @ApiModelProperty("鍒囧彛绫诲埆鍚嶇О") + @Excel(name = "鍒囧彛绫诲埆鍚嶇О") + private String incitypedesc; + + /** 鎵嬫湳绾у埆浠g爜 */ + @ApiModelProperty("鎵嬫湳绾у埆浠g爜") + @Excel(name = "鎵嬫湳绾у埆浠g爜") + private String oplevelcode; + + /** 鎵嬫湳绾у埆鍚嶇О */ + @ApiModelProperty("鎵嬫湳绾у埆鍚嶇О") + @Excel(name = "鎵嬫湳绾у埆鍚嶇О") + private String opleveldesc; + + /** 鎵嬫湳閮ㄤ綅 */ + @ApiModelProperty("鎵嬫湳閮ㄤ綅") + @Excel(name = "鎵嬫湳閮ㄤ綅") + private String opposition; + + /** 鍒犻櫎鏍囧織锛�0锛氭湭鍒犻櫎 1锛氬凡鍒犻櫎锛� */ + @ApiModelProperty("鍒犻櫎鏍囧織锛�0锛氭湭鍒犻櫎 1锛氬凡鍒犻櫎锛�") + private String delFlag; + + /** 涓婁紶鏍囧織锛�0锛氭湭涓婁紶 1锛氬凡涓婁紶锛� */ + @ApiModelProperty("涓婁紶鏍囧織锛�0锛氭湭涓婁紶 1锛氬凡涓婁紶锛�") + @Excel(name = "涓婁紶鏍囧織", readConverterExp = "0=锛氭湭涓婁紶,1=锛氬凡涓婁紶") + private Long isupload; + + /** 涓婁紶鏃堕棿 */ + @ApiModelProperty("涓婁紶鏃堕棿") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "涓婁紶鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date uploadTime; + + /** 鍖婚櫌鏈烘瀯ID */ + @ApiModelProperty("鍖婚櫌鏈烘瀯ID") + @Excel(name = "鍖婚櫌鏈烘瀯ID") + private String orgid; + + /** 鐖禛UID */ + @ApiModelProperty("鐖禛UID") + @Excel(name = "鐖禛UID") + private String pguid; + + /** GUID */ + @ApiModelProperty("GUID") + @Excel(name = "GUID") + private String guid; + + /** 鐖禝D */ + @ApiModelProperty("鐖禝D") + @Excel(name = "鐖禝D") + private Long pid; + + } + diff --git a/smartor/src/main/java/com/smartor/mapper/BaseDictOperationMapper.java b/smartor/src/main/java/com/smartor/mapper/BaseDictOperationMapper.java new file mode 100644 index 0000000..9e15099 --- /dev/null +++ b/smartor/src/main/java/com/smartor/mapper/BaseDictOperationMapper.java @@ -0,0 +1,63 @@ +package com.smartor.mapper; + +import java.util.List; +import org.apache.ibatis.annotations.Mapper; +import com.smartor.domain.BaseDictOperation; + +/** + * 鎮h�呮鏌ユ楠岃褰曞瓙Mapper鎺ュ彛 + * + * @author lihu + * @date 2025-02-26 + */ +@Mapper +public interface BaseDictOperationMapper +{ + /** + * 鏌ヨ鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param id 鎮h�呮鏌ユ楠岃褰曞瓙涓婚敭 + * @return 鎮h�呮鏌ユ楠岃褰曞瓙 + */ + public BaseDictOperation selectBaseDictOperationById(Long id); + + /** + * 鏌ヨ鎮h�呮鏌ユ楠岃褰曞瓙鍒楄〃 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 鎮h�呮鏌ユ楠岃褰曞瓙闆嗗悎 + */ + public List<BaseDictOperation> selectBaseDictOperationList(BaseDictOperation baseDictOperation); + + /** + * 鏂板鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 缁撴灉 + */ + public int insertBaseDictOperation(BaseDictOperation baseDictOperation); + + /** + * 淇敼鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 缁撴灉 + */ + public int updateBaseDictOperation(BaseDictOperation baseDictOperation); + + /** + * 鍒犻櫎鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param id 鎮h�呮鏌ユ楠岃褰曞瓙涓婚敭 + * @return 缁撴灉 + */ + public int deleteBaseDictOperationById(Long id); + + /** + * 鎵归噺鍒犻櫎鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteBaseDictOperationByIds(Long[] ids); +} diff --git a/smartor/src/main/java/com/smartor/service/IBaseDictOperationService.java b/smartor/src/main/java/com/smartor/service/IBaseDictOperationService.java new file mode 100644 index 0000000..2fcb9c6 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/IBaseDictOperationService.java @@ -0,0 +1,61 @@ +package com.smartor.service; + +import java.util.List; +import com.smartor.domain.BaseDictOperation; + +/** + * 鎮h�呮鏌ユ楠岃褰曞瓙Service鎺ュ彛 + * + * @author lihu + * @date 2025-02-26 + */ +public interface IBaseDictOperationService +{ + /** + * 鏌ヨ鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param id 鎮h�呮鏌ユ楠岃褰曞瓙涓婚敭 + * @return 鎮h�呮鏌ユ楠岃褰曞瓙 + */ + public BaseDictOperation selectBaseDictOperationById(Long id); + + /** + * 鏌ヨ鎮h�呮鏌ユ楠岃褰曞瓙鍒楄〃 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 鎮h�呮鏌ユ楠岃褰曞瓙闆嗗悎 + */ + public List<BaseDictOperation> selectBaseDictOperationList(BaseDictOperation baseDictOperation); + + /** + * 鏂板鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 缁撴灉 + */ + public int insertBaseDictOperation(BaseDictOperation baseDictOperation); + + /** + * 淇敼鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 缁撴灉 + */ + public int updateBaseDictOperation(BaseDictOperation baseDictOperation); + + /** + * 鎵归噺鍒犻櫎鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param ids 闇�瑕佸垹闄ょ殑鎮h�呮鏌ユ楠岃褰曞瓙涓婚敭闆嗗悎 + * @return 缁撴灉 + */ + public int deleteBaseDictOperationByIds(Long[] ids); + + /** + * 鍒犻櫎鎮h�呮鏌ユ楠岃褰曞瓙淇℃伅 + * + * @param id 鎮h�呮鏌ユ楠岃褰曞瓙涓婚敭 + * @return 缁撴灉 + */ + public int deleteBaseDictOperationById(Long id); +} diff --git a/smartor/src/main/java/com/smartor/service/impl/BaseDictOperationServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/BaseDictOperationServiceImpl.java new file mode 100644 index 0000000..c939f85 --- /dev/null +++ b/smartor/src/main/java/com/smartor/service/impl/BaseDictOperationServiceImpl.java @@ -0,0 +1,96 @@ +package com.smartor.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.smartor.mapper.BaseDictOperationMapper; +import com.smartor.domain.BaseDictOperation; +import com.smartor.service.IBaseDictOperationService; + +/** + * 鎮h�呮鏌ユ楠岃褰曞瓙Service涓氬姟灞傚鐞� + * + * @author lihu + * @date 2025-02-26 + */ +@Service +public class BaseDictOperationServiceImpl implements IBaseDictOperationService +{ + @Autowired + private BaseDictOperationMapper baseDictOperationMapper; + + /** + * 鏌ヨ鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param id 鎮h�呮鏌ユ楠岃褰曞瓙涓婚敭 + * @return 鎮h�呮鏌ユ楠岃褰曞瓙 + */ + @Override + public BaseDictOperation selectBaseDictOperationById(Long id) + { + return baseDictOperationMapper.selectBaseDictOperationById(id); + } + + /** + * 鏌ヨ鎮h�呮鏌ユ楠岃褰曞瓙鍒楄〃 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 鎮h�呮鏌ユ楠岃褰曞瓙 + */ + @Override + public List<BaseDictOperation> selectBaseDictOperationList(BaseDictOperation baseDictOperation) + { + return baseDictOperationMapper.selectBaseDictOperationList(baseDictOperation); + } + + /** + * 鏂板鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 缁撴灉 + */ + @Override + public int insertBaseDictOperation(BaseDictOperation baseDictOperation) + { + baseDictOperation.setCreateTime(DateUtils.getNowDate()); + return baseDictOperationMapper.insertBaseDictOperation(baseDictOperation); + } + + /** + * 淇敼鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param baseDictOperation 鎮h�呮鏌ユ楠岃褰曞瓙 + * @return 缁撴灉 + */ + @Override + public int updateBaseDictOperation(BaseDictOperation baseDictOperation) + { + baseDictOperation.setUpdateTime(DateUtils.getNowDate()); + return baseDictOperationMapper.updateBaseDictOperation(baseDictOperation); + } + + /** + * 鎵归噺鍒犻櫎鎮h�呮鏌ユ楠岃褰曞瓙 + * + * @param ids 闇�瑕佸垹闄ょ殑鎮h�呮鏌ユ楠岃褰曞瓙涓婚敭 + * @return 缁撴灉 + */ + @Override + public int deleteBaseDictOperationByIds(Long[] ids) + { + return baseDictOperationMapper.deleteBaseDictOperationByIds(ids); + } + + /** + * 鍒犻櫎鎮h�呮鏌ユ楠岃褰曞瓙淇℃伅 + * + * @param id 鎮h�呮鏌ユ楠岃褰曞瓙涓婚敭 + * @return 缁撴灉 + */ + @Override + public int deleteBaseDictOperationById(Long id) + { + return baseDictOperationMapper.deleteBaseDictOperationById(id); + } +} diff --git a/smartor/src/main/resources/mapper/smartor/BaseDictOperationMapper.xml b/smartor/src/main/resources/mapper/smartor/BaseDictOperationMapper.xml new file mode 100644 index 0000000..ad265b4 --- /dev/null +++ b/smartor/src/main/resources/mapper/smartor/BaseDictOperationMapper.xml @@ -0,0 +1,264 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper + PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" + "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.smartor.mapper.BaseDictOperationMapper"> + + <resultMap type="com.smartor.domain.BaseDictOperation" id="BaseDictOperationResult"> + <result property="id" column="id"/> + <result property="opid" column="opid"/> + <result property="opcode" column="opcode"/> + <result property="opdesc" column="opdesc"/> + <result property="incitypecode" column="incitypecode"/> + <result property="incitypedesc" column="incitypedesc"/> + <result property="oplevelcode" column="oplevelcode"/> + <result property="opleveldesc" column="opleveldesc"/> + <result property="opposition" column="opposition"/> + <result property="delFlag" column="del_flag"/> + <result property="updateBy" column="update_by"/> + <result property="updateTime" column="update_time"/> + <result property="createBy" column="create_by"/> + <result property="createTime" column="create_time"/> + <result property="isupload" column="isupload"/> + <result property="uploadTime" column="upload_time"/> + <result property="orgid" column="orgid"/> + <result property="pguid" column="pguid"/> + <result property="guid" column="guid"/> + <result property="pid" column="pid"/> + </resultMap> + + <sql id="selectBaseDictOperationVo"> + select id, opid, opcode, opdesc, incitypecode, incitypedesc, oplevelcode, opleveldesc, opposition, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time, orgid, pguid, guid, pid + from base_dict_operation + </sql> + + <select id="selectBaseDictOperationList" parameterType="com.smartor.domain.BaseDictOperation" + resultMap="BaseDictOperationResult"> + <include refid="selectBaseDictOperationVo"/> + <where> + <if test="opid != null "> + and opid = #{opid} + </if> + <if test="opcode != null and opcode != ''"> + and opcode = #{opcode} + </if> + <if test="opdesc != null and opdesc != ''"> + and opdesc = #{opdesc} + </if> + <if test="incitypecode != null and incitypecode != ''"> + and incitypecode = #{incitypecode} + </if> + <if test="incitypedesc != null and incitypedesc != ''"> + and incitypedesc = #{incitypedesc} + </if> + <if test="oplevelcode != null and oplevelcode != ''"> + and oplevelcode = #{oplevelcode} + </if> + <if test="opleveldesc != null and opleveldesc != ''"> + and opleveldesc = #{opleveldesc} + </if> + <if test="opposition != null and opposition != ''"> + and opposition = #{opposition} + </if> + <if test="isupload != null "> + and isupload = #{isupload} + </if> + <if test="uploadTime != null "> + and upload_time = #{uploadTime} + </if> + <if test="orgid != null and orgid != ''"> + and orgid = #{orgid} + </if> + <if test="pguid != null and pguid != ''"> + and pguid = #{pguid} + </if> + <if test="guid != null and guid != ''"> + and guid = #{guid} + </if> + <if test="pid != null "> + and pid = #{pid} + </if> + </where> + </select> + + <select id="selectBaseDictOperationById" parameterType="Long" + resultMap="BaseDictOperationResult"> + <include refid="selectBaseDictOperationVo"/> + where id = #{id} + </select> + + <insert id="insertBaseDictOperation" parameterType="com.smartor.domain.BaseDictOperation"> + insert into base_dict_operation + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="id != null">id, + </if> + <if test="opid != null">opid, + </if> + <if test="opcode != null">opcode, + </if> + <if test="opdesc != null">opdesc, + </if> + <if test="incitypecode != null">incitypecode, + </if> + <if test="incitypedesc != null">incitypedesc, + </if> + <if test="oplevelcode != null">oplevelcode, + </if> + <if test="opleveldesc != null">opleveldesc, + </if> + <if test="opposition != null">opposition, + </if> + <if test="delFlag != null">del_flag, + </if> + <if test="updateBy != null">update_by, + </if> + <if test="updateTime != null">update_time, + </if> + <if test="createBy != null">create_by, + </if> + <if test="createTime != null">create_time, + </if> + <if test="isupload != null">isupload, + </if> + <if test="uploadTime != null">upload_time, + </if> + <if test="orgid != null">orgid, + </if> + <if test="pguid != null">pguid, + </if> + <if test="guid != null">guid, + </if> + <if test="pid != null">pid, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="id != null">#{id}, + </if> + <if test="opid != null">#{opid}, + </if> + <if test="opcode != null">#{opcode}, + </if> + <if test="opdesc != null">#{opdesc}, + </if> + <if test="incitypecode != null">#{incitypecode}, + </if> + <if test="incitypedesc != null">#{incitypedesc}, + </if> + <if test="oplevelcode != null">#{oplevelcode}, + </if> + <if test="opleveldesc != null">#{opleveldesc}, + </if> + <if test="opposition != null">#{opposition}, + </if> + <if test="delFlag != null">#{delFlag}, + </if> + <if test="updateBy != null">#{updateBy}, + </if> + <if test="updateTime != null">#{updateTime}, + </if> + <if test="createBy != null">#{createBy}, + </if> + <if test="createTime != null">#{createTime}, + </if> + <if test="isupload != null">#{isupload}, + </if> + <if test="uploadTime != null">#{uploadTime}, + </if> + <if test="orgid != null">#{orgid}, + </if> + <if test="pguid != null">#{pguid}, + </if> + <if test="guid != null">#{guid}, + </if> + <if test="pid != null">#{pid}, + </if> + </trim> + </insert> + + <update id="updateBaseDictOperation" parameterType="com.smartor.domain.BaseDictOperation"> + update base_dict_operation + <trim prefix="SET" suffixOverrides=","> + <if test="opid != null">opid = + #{opid}, + </if> + <if test="opcode != null">opcode = + #{opcode}, + </if> + <if test="opdesc != null">opdesc = + #{opdesc}, + </if> + <if test="incitypecode != null">incitypecode = + #{incitypecode}, + </if> + <if test="incitypedesc != null">incitypedesc = + #{incitypedesc}, + </if> + <if test="oplevelcode != null">oplevelcode = + #{oplevelcode}, + </if> + <if test="opleveldesc != null">opleveldesc = + #{opleveldesc}, + </if> + <if test="opposition != null">opposition = + #{opposition}, + </if> + <if test="delFlag != null">del_flag = + #{delFlag}, + </if> + <if test="updateBy != null">update_by = + #{updateBy}, + </if> + <if test="updateTime != null">update_time = + #{updateTime}, + </if> + <if test="createBy != null">create_by = + #{createBy}, + </if> + <if test="createTime != null">create_time = + #{createTime}, + </if> + <if test="isupload != null">isupload = + #{isupload}, + </if> + <if test="uploadTime != null">upload_time = + #{uploadTime}, + </if> + <if test="orgid != null">orgid = + #{orgid}, + </if> + <if test="pguid != null">pguid = + #{pguid}, + </if> + <if test="guid != null">guid = + #{guid}, + </if> + <if test="pid != null">pid = + #{pid}, + </if> + </trim> + where id = #{id} + </update> + + <update id="deleteBaseDictOperationById" parameterType="Long"> + update base_dict_operation + <trim prefix="SET" suffixOverrides=","> + del_flag =1 + </trim> + where id = #{id} + </update> + + <update id="deleteBaseDictOperationByIds" parameterType="String"> + update base_dict_operation + <trim prefix="SET" suffixOverrides=","> + del_flag =1 + </trim> + where id in + <foreach item="id" collection="array" open="(" separator="," close=")"> + #{id} + </foreach> + </update> + + + + +</mapper> -- Gitblit v1.9.3