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