From 0f9bec54c299a9c35cc14edaa249bd822de70e22 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期一, 04 三月 2024 17:12:28 +0800
Subject: [PATCH] 运维单位
---
ycl-pojo/src/main/java/com/ycl/system/domain/form/YwUnitForm.java | 58 ++++
ycl-pojo/src/main/java/com/ycl/system/Result.java | 122 +++++++++
ycl-server/src/main/resources/mapper/system/YwUnitMapper.xml | 90 ++++++
ycl-pojo/src/main/java/com/ycl/system/domain/vo/YwUnitVO.java | 50 +++
ycl-pojo/src/main/java/com/ycl/system/domain/entity/YwUnit.java | 51 +++
ycl-server/src/main/java/com/ycl/system/controller/zgyw/YwUnitController.java | 74 +++++
ycl-pojo/src/main/java/com/ycl/system/domain/query/YwUnitQuery.java | 22 +
ycl-server/src/main/java/com/ycl/system/service/impl/YwUnitServiceImpl.java | 140 ++++++++++
ycl-pojo/src/main/java/com/ycl/system/page/PageUtil.java | 29 ++
ycl-server/src/main/java/com/ycl/system/mapper/YwUnitMapper.java | 19 +
ycl-server/src/main/java/com/ycl/system/service/YwUnitService.java | 67 +++++
11 files changed, 722 insertions(+), 0 deletions(-)
diff --git a/ycl-pojo/src/main/java/com/ycl/system/Result.java b/ycl-pojo/src/main/java/com/ycl/system/Result.java
new file mode 100644
index 0000000..d9fc6f6
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/system/Result.java
@@ -0,0 +1,122 @@
+package com.ycl.system;
+
+import org.springframework.lang.NonNull;
+
+import java.util.HashMap;
+
+
+/**
+ * 鏂扮殑鍝嶅簲绫�
+ * @author xp
+ * @date 2022/12/2
+ */
+public class Result extends HashMap<String, Object> {
+
+ private static final long serialVersionUID = 1L;
+
+ private static final String TOTAL = "total";
+
+ public static final String DATA = "data";
+
+ private static final String MSG = "msg";
+
+ private static final String CODE = "code";
+
+ public Result() {
+ put(MSG, "success");
+ put(CODE, 200);
+ }
+
+ /**
+ * 鎴愬姛锛屽暐涔熶笉鍋�
+ * @return
+ */
+ public static Result ok() {
+ return new Result();
+ }
+
+ /**
+ * 鎴愬姛锛岃嚜瀹氫箟鎻愮ず淇℃伅
+ * @param msg
+ * @return
+ */
+ public static Result ok(String msg) {
+ Result result = new Result();
+ result.put(MSG, msg);
+ return result;
+ }
+
+ /**
+ * 澶辫触锛屽暐涔熶笉鍋�
+ * @return
+ */
+ public static Result error() {
+ Result result = new Result();
+ result.put(CODE, 500);
+ result.put(MSG, "鎿嶄綔澶辫触");
+ return result;
+ }
+
+ /**
+ * 澶辫触锛岃嚜瀹氫箟閿欒鎻愮ず
+ * @param msg
+ * @return
+ */
+ public static Result error(String msg) {
+ Result result = new Result();
+ result.put(CODE, 500);
+ result.put(MSG, msg);
+ return result;
+ }
+
+ /**
+ * 澶辫触锛岃嚜瀹氫箟閿欒鐮�
+ * @param code
+ * @return
+ */
+ public static Result error(@NonNull Integer code) {
+ Result result = new Result();
+ result.put(CODE, code);
+ result.put(MSG, "鎿嶄綔澶辫触");
+ return result;
+ }
+
+ /**
+ * 澶辫触锛岃嚜瀹氫箟閿欒鐮佸拰閿欒鎻愮ず
+ * @param code
+ * @param msg
+ * @return
+ */
+ public static Result error(@NonNull Integer code, String msg) {
+ Result result = new Result();
+ result.put(CODE, code);
+ result.put(MSG, msg);
+ return result;
+ }
+
+ /**
+ * 娣诲姞鏁版嵁
+ * @param data
+ * @return
+ */
+ public Result data(Object data) {
+ this.put(DATA, data);
+ return this;
+ }
+
+ /**
+ * 娣诲姞鎬绘潯鏁�
+ * @param total
+ * @return
+ */
+ public Result total(long total) {
+ this.put(TOTAL, total);
+ return this;
+ }
+
+ @Override
+ public Result put(String key, Object value) {
+ super.put(key, value);
+ return this;
+ }
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/system/domain/entity/YwUnit.java b/ycl-pojo/src/main/java/com/ycl/system/domain/entity/YwUnit.java
new file mode 100644
index 0000000..c2bfd5b
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/system/domain/entity/YwUnit.java
@@ -0,0 +1,51 @@
+package com.ycl.system.domain.entity;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.ycl.system.domain.base.AbsEntity;
+import java.io.Serializable;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 杩愮淮鍗曚綅
+ *
+ * @author xp
+ * @since 2024-03-04
+ */
+@Data
+@Accessors(chain = true)
+@TableName("t_yw_unit")
+@ApiModel(value = "YwUnit瀵硅薄", description = "杩愮淮鍗曚綅")
+public class YwUnit extends AbsEntity {
+
+ private static final long serialVersionUID = 1L;
+
+ @ApiModelProperty("鍗曚綅缂栫爜")
+ @TableField("unit_code")
+ private String unitCode;
+
+ @ApiModelProperty("鍗曚綅鍚嶇О")
+ @TableField("unit_name")
+ private String unitName;
+
+ @ApiModelProperty("鍗曚綅鑱旂郴浜�")
+ @TableField("unit_contact")
+ private String unitContact;
+
+ @ApiModelProperty("鍗曚綅鑱旂郴浜虹數璇�")
+ @TableField("unit_contact_phone")
+ private String unitContactPhone;
+
+ @ApiModelProperty("鍗曚綅绠＄悊鍛樿处鍙�")
+ @TableField("unit_admin_account")
+ private String unitAdminAccount;
+
+ @ApiModelProperty("澶囨敞")
+ @TableField("remark")
+ private String remark;
+
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/system/domain/form/YwUnitForm.java b/ycl-pojo/src/main/java/com/ycl/system/domain/form/YwUnitForm.java
new file mode 100644
index 0000000..f0978fa
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/system/domain/form/YwUnitForm.java
@@ -0,0 +1,58 @@
+package com.ycl.system.domain.form;
+
+import com.ycl.system.domain.entity.YwUnit;
+import com.ycl.system.domain.group.Update;
+import com.ycl.system.domain.group.Add;
+import com.ycl.system.domain.base.AbsForm;
+import jakarta.validation.constraints.NotBlank;
+import org.springframework.beans.BeanUtils;
+import org.springframework.lang.NonNull;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 杩愮淮鍗曚綅琛ㄥ崟
+ *
+ * @author xp
+ * @since 2024-03-04
+ */
+@Data
+@Accessors(chain = true)
+@ApiModel(value = "YwUnit琛ㄥ崟", description = "杩愮淮鍗曚綅琛ㄥ崟")
+public class YwUnitForm extends AbsForm {
+
+ @NotBlank(message = "鍗曚綅缂栫爜涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍗曚綅缂栫爜")
+ private String unitCode;
+
+ @NotBlank(message = "鍗曚綅鍚嶇О涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍗曚綅鍚嶇О")
+ private String unitName;
+
+ @NotBlank(message = "鍗曚綅鑱旂郴浜轰笉鑳戒负绌�", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍗曚綅鑱旂郴浜�")
+ private String unitContact;
+
+ @NotBlank(message = "鍗曚綅鑱旂郴浜虹數璇濅笉鑳戒负绌�", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍗曚綅鑱旂郴浜虹數璇�")
+ private String unitContactPhone;
+
+ @NotBlank(message = "鍗曚綅绠＄悊鍛樿处鍙蜂笉鑳戒负绌�", groups = {Add.class, Update.class})
+ @ApiModelProperty("鍗曚綅绠＄悊鍛樿处鍙�")
+ private String unitAdminAccount;
+
+ @NotBlank(message = "澶囨敞涓嶈兘涓虹┖", groups = {Add.class, Update.class})
+ @ApiModelProperty("澶囨敞")
+ private String remark;
+
+ public static YwUnit getEntityByForm(@NonNull YwUnitForm form, YwUnit entity) {
+ if(entity == null) {
+ entity = new YwUnit();
+ }
+ BeanUtils.copyProperties(form, entity);
+ return entity;
+ }
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/system/domain/query/YwUnitQuery.java b/ycl-pojo/src/main/java/com/ycl/system/domain/query/YwUnitQuery.java
new file mode 100644
index 0000000..784cfc9
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/system/domain/query/YwUnitQuery.java
@@ -0,0 +1,22 @@
+package com.ycl.system.domain.query;
+
+import com.ycl.system.domain.base.AbsQuery;
+import java.util.List;
+import org.springframework.lang.NonNull;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 杩愮淮鍗曚綅鏌ヨ
+ *
+ * @author xp
+ * @since 2024-03-04
+ */
+@Data
+@Accessors(chain = true)
+@ApiModel(value = "YwUnit鏌ヨ", description = "杩愮淮鍗曚綅鏌ヨ")
+public class YwUnitQuery extends AbsQuery {
+}
+
diff --git a/ycl-pojo/src/main/java/com/ycl/system/domain/vo/YwUnitVO.java b/ycl-pojo/src/main/java/com/ycl/system/domain/vo/YwUnitVO.java
new file mode 100644
index 0000000..d7229ad
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/system/domain/vo/YwUnitVO.java
@@ -0,0 +1,50 @@
+package com.ycl.system.domain.vo;
+
+import com.ycl.system.domain.base.AbsVo;
+import java.util.List;
+
+import com.ycl.system.domain.entity.YwUnit;
+import org.springframework.lang.NonNull;
+import org.springframework.beans.BeanUtils;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.experimental.Accessors;
+
+/**
+ * 杩愮淮鍗曚綅灞曠ず
+ *
+ * @author xp
+ * @since 2024-03-04
+ */
+@Data
+@Accessors(chain = true)
+public class YwUnitVO extends AbsVo {
+
+ /** 鍗曚綅缂栫爜 */
+ private String unitCode;
+
+ /** 鍗曚綅鍚嶇О */
+ private String unitName;
+
+ /** 鍗曚綅鑱旂郴浜� */
+ private String unitContact;
+
+ /** 鍗曚綅鑱旂郴浜虹數璇� */
+ private String unitContactPhone;
+
+ /** 鍗曚綅绠＄悊鍛樿处鍙� */
+ private String unitAdminAccount;
+
+ /** 澶囨敞 */
+ private String remark;
+
+ public static YwUnitVO getVoByEntity(@NonNull YwUnit entity, YwUnitVO vo) {
+ if(vo == null) {
+ vo = new YwUnitVO();
+ }
+ BeanUtils.copyProperties(entity, vo);
+ return vo;
+ }
+
+}
diff --git a/ycl-pojo/src/main/java/com/ycl/system/page/PageUtil.java b/ycl-pojo/src/main/java/com/ycl/system/page/PageUtil.java
new file mode 100644
index 0000000..0a69621
--- /dev/null
+++ b/ycl-pojo/src/main/java/com/ycl/system/page/PageUtil.java
@@ -0,0 +1,29 @@
+package com.ycl.system.page;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ycl.system.domain.base.AbsEntity;
+import com.ycl.system.domain.base.AbsQuery;
+
+/**
+ * 鍒嗛〉宸ュ叿绫�
+ * @author xp
+ * @date 2022/12/2
+ */
+public class PageUtil {
+
+ /**
+ * 鑾峰彇plus鐨勫垎椤靛璞�
+ * @param q
+ * @param <T> 瀹炰綋绫�
+ * @param <Q> 鏌ヨ绫�
+ * @return
+ */
+ public static <T extends AbsEntity, Q extends AbsQuery> IPage<T> getPage(Q q, Class<T> c) {
+ Page<T> page = new Page<T>()
+ .setCurrent(q.getCurrentPage())
+ .setSize(q.getPageSize());
+ return page;
+ }
+
+}
diff --git a/ycl-server/src/main/java/com/ycl/system/controller/zgyw/YwUnitController.java b/ycl-server/src/main/java/com/ycl/system/controller/zgyw/YwUnitController.java
new file mode 100644
index 0000000..ee3d0c6
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/system/controller/zgyw/YwUnitController.java
@@ -0,0 +1,74 @@
+package com.ycl.system.controller.zgyw;
+
+import com.ycl.system.Result;
+import com.ycl.system.domain.form.YwUnitForm;
+import com.ycl.system.domain.group.Update;
+import com.ycl.system.domain.group.Add;
+import com.ycl.system.domain.query.YwUnitQuery;
+import com.ycl.system.service.YwUnitService;
+import org.springframework.validation.annotation.Validated;
+import lombok.RequiredArgsConstructor;
+import java.util.List;
+
+import jakarta.validation.constraints.NotEmpty;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.web.bind.annotation.*;
+
+/**
+ * 杩愮淮鍗曚綅 鍓嶇鎺у埗鍣�
+ *
+ * @author xp
+ * @since 2024-03-04
+ */
+@Validated
+@RequiredArgsConstructor
+@Api(value = "杩愮淮鍗曚綅", tags = "杩愮淮鍗曚綅绠＄悊")
+@RestController
+@RequestMapping("/yw-unit")
+public class YwUnitController {
+
+ private final YwUnitService ywUnitService;
+
+ @PostMapping
+ @ApiOperation(value = "娣诲姞", notes = "娣诲姞")
+ public Result add(@RequestBody @Validated(Add.class) YwUnitForm form) {
+ return ywUnitService.add(form);
+ }
+
+ @PutMapping
+ @ApiOperation(value = "淇敼", notes = "淇敼")
+ public Result update(@RequestBody @Validated(Update.class) YwUnitForm form) {
+ return ywUnitService.update(form);
+ }
+
+ @DeleteMapping("/{id}")
+ @ApiOperation(value = "ID鍒犻櫎", notes = "ID鍒犻櫎")
+ public Result removeById(@PathVariable("id") String id) {
+ return ywUnitService.removeById(id);
+ }
+
+ @DeleteMapping("/batch")
+ @ApiOperation(value = "鎵归噺鍒犻櫎", notes = "鎵归噺鍒犻櫎")
+ public Result remove(@RequestBody @NotEmpty(message = "璇烽�夋嫨鏁版嵁") List<String> ids) {
+ return ywUnitService.remove(ids);
+ }
+
+ @GetMapping("/page")
+ @ApiOperation(value = "鍒嗛〉", notes = "鍒嗛〉")
+ public Result page(YwUnitQuery query) {
+ return ywUnitService.page(query);
+ }
+
+ @GetMapping("/{id}")
+ @ApiOperation(value = "璇︽儏", notes = "璇︽儏")
+ public Result detail(@PathVariable("id") String id) {
+ return ywUnitService.detail(id);
+ }
+
+ @GetMapping("/list")
+ @ApiOperation(value = "鍒楄〃", notes = "鍒楄〃")
+ public Result list() {
+ return ywUnitService.all();
+ }
+}
diff --git a/ycl-server/src/main/java/com/ycl/system/mapper/YwUnitMapper.java b/ycl-server/src/main/java/com/ycl/system/mapper/YwUnitMapper.java
new file mode 100644
index 0000000..4d807fd
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/system/mapper/YwUnitMapper.java
@@ -0,0 +1,19 @@
+package com.ycl.system.mapper;
+
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import java.util.List;
+
+import com.ycl.system.domain.entity.YwUnit;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * 杩愮淮鍗曚綅 Mapper 鎺ュ彛
+ *
+ * @author xp
+ * @since 2024-03-04
+ */
+@Mapper
+public interface YwUnitMapper extends BaseMapper<YwUnit> {
+
+}
diff --git a/ycl-server/src/main/java/com/ycl/system/service/YwUnitService.java b/ycl-server/src/main/java/com/ycl/system/service/YwUnitService.java
new file mode 100644
index 0000000..3666724
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/system/service/YwUnitService.java
@@ -0,0 +1,67 @@
+package com.ycl.system.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+
+import com.ycl.system.Result;
+import com.ycl.system.domain.entity.YwUnit;
+import com.ycl.system.domain.form.YwUnitForm;
+import com.ycl.system.domain.query.YwUnitQuery;
+
+import java.util.List;
+
+/**
+ * 杩愮淮鍗曚綅 鏈嶅姟绫�
+ *
+ * @author xp
+ * @since 2024-03-04
+ */
+public interface YwUnitService extends IService<YwUnit> {
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ Result add(YwUnitForm form);
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ Result update(YwUnitForm form);
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ Result remove(List<String> ids);
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ Result removeById(String id);
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ Result page(YwUnitQuery query);
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ Result detail(String id);
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ Result all();
+}
diff --git a/ycl-server/src/main/java/com/ycl/system/service/impl/YwUnitServiceImpl.java b/ycl-server/src/main/java/com/ycl/system/service/impl/YwUnitServiceImpl.java
new file mode 100644
index 0000000..949e16e
--- /dev/null
+++ b/ycl-server/src/main/java/com/ycl/system/service/impl/YwUnitServiceImpl.java
@@ -0,0 +1,140 @@
+package com.ycl.system.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import java.util.List;
+import com.ycl.system.Result;
+import com.ycl.system.domain.entity.YwUnit;
+import com.ycl.system.domain.form.YwUnitForm;
+import com.ycl.system.domain.query.YwUnitQuery;
+import com.ycl.system.domain.vo.YwUnitVO;
+import com.ycl.system.mapper.YwUnitMapper;
+import com.ycl.system.page.PageUtil;
+import com.ycl.system.service.YwUnitService;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.springframework.stereotype.Service;
+import org.springframework.beans.BeanUtils;
+import org.springframework.util.Assert;
+import java.util.stream.Collectors;
+import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
+import lombok.RequiredArgsConstructor;
+
+/**
+ * 杩愮淮鍗曚綅 鏈嶅姟瀹炵幇绫�
+ *
+ * @author xp
+ * @since 2024-03-04
+ */
+@Service
+@RequiredArgsConstructor
+public class YwUnitServiceImpl extends ServiceImpl<YwUnitMapper, YwUnit> implements YwUnitService {
+
+ private final YwUnitMapper ywUnitMapper;
+
+ /**
+ * 娣诲姞
+ * @param form
+ * @return
+ */
+ @Override
+ public Result add(YwUnitForm form) {
+ YwUnit entity = YwUnitForm.getEntityByForm(form, null);
+ if(baseMapper.insert(entity) > 0) {
+ return Result.ok("娣诲姞鎴愬姛");
+ }
+ return Result.error("娣诲姞澶辫触");
+ }
+
+ /**
+ * 淇敼
+ * @param form
+ * @return
+ */
+ @Override
+ public Result update(YwUnitForm form) {
+
+ YwUnit entity = baseMapper.selectById(form.getId());
+
+ // 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊
+ Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
+ BeanUtils.copyProperties(form, entity);
+ if (baseMapper.updateById(entity) > 0) {
+ return Result.ok("淇敼鎴愬姛");
+ }
+ return Result.error("淇敼澶辫触");
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎
+ * @param ids
+ * @return
+ */
+ @Override
+ public Result remove(List<String> ids) {
+ if(baseMapper.deleteBatchIds(ids) > 0) {
+ return Result.ok("鍒犻櫎鎴愬姛");
+ }
+ return Result.error("鍒犻櫎澶辫触");
+ }
+
+ /**
+ * id鍒犻櫎
+ * @param id
+ * @return
+ */
+ @Override
+ public Result removeById(String id) {
+ if(baseMapper.deleteById(id) > 0) {
+ return Result.ok("鍒犻櫎鎴愬姛");
+ }
+ return Result.error("鍒犻櫎澶辫触");
+ }
+
+ /**
+ * 鍒嗛〉鏌ヨ
+ * @param query
+ * @return
+ */
+ @Override
+ public Result page(YwUnitQuery query) {
+
+ IPage<YwUnit> page = new LambdaQueryChainWrapper<>(baseMapper)
+ .orderByDesc(YwUnit::getCreateTime)
+ .page(PageUtil.getPage(query, YwUnit.class));
+
+ List<YwUnitVO> vos = page.getRecords().stream()
+ .map(
+ entity -> YwUnitVO.getVoByEntity(entity, null)
+ )
+ .collect(Collectors.toList());
+ return Result.ok().data(vos).total(page.getTotal());
+ }
+
+ /**
+ * 鏍规嵁id鏌ユ壘
+ * @param id
+ * @return
+ */
+ @Override
+ public Result detail(String id) {
+
+ YwUnit entity = baseMapper.selectById(id);
+ Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
+ YwUnitVO vo = YwUnitVO.getVoByEntity(entity, null);
+ return Result.ok().data(vo);
+ }
+
+ /**
+ * 鍒楄〃
+ * @return
+ */
+ @Override
+ public Result all() {
+ List<YwUnit> entities = baseMapper.selectList(null);
+ List<YwUnitVO> vos = entities.stream()
+ .map(
+ entity -> YwUnitVO.getVoByEntity(entity, null)
+ )
+ .collect(Collectors.toList());
+ return Result.ok().data(vos);
+ }
+}
diff --git a/ycl-server/src/main/resources/mapper/system/YwUnitMapper.xml b/ycl-server/src/main/resources/mapper/system/YwUnitMapper.xml
new file mode 100644
index 0000000..85d67c1
--- /dev/null
+++ b/ycl-server/src/main/resources/mapper/system/YwUnitMapper.xml
@@ -0,0 +1,90 @@
+<?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.ycl.system.mapper.YwUnitMapper">
+
+ <resultMap type="YwUnit" id="YwUnitResult">
+ <result property="id" column="id" />
+ <result property="unitCode" column="unit_code" />
+ <result property="unitName" column="unit_name" />
+ <result property="unitContact" column="unit_contact" />
+ <result property="unitContactPhone" column="unit_contact_phone" />
+ <result property="unitAdminAccount" column="unit_admin_account" />
+ <result property="remark" column="remark" />
+ <result property="createTime" column="create_time" />
+ <result property="updateTime" column="update_time" />
+ <result property="deleted" column="deleted" />
+ </resultMap>
+
+ <sql id="selectYwUnitVo">
+ select id, unit_code, unit_name, unit_contact, unit_contact_phone, unit_admin_account, remark, create_time, update_time, deleted from t_yw_unit
+ </sql>
+
+ <select id="selectYwUnitList" parameterType="YwUnit" resultMap="YwUnitResult">
+ <include refid="selectYwUnitVo"/>
+ <where>
+ <if test="unitCode != null and unitCode != ''"> and unit_code = #{unitCode}</if>
+ <if test="unitName != null and unitName != ''"> and unit_name like concat('%', #{unitName}, '%')</if>
+ <if test="params.beginCreateTime != null and params.beginCreateTime != '' and params.endCreateTime != null and params.endCreateTime != ''"> and create_time between #{params.beginCreateTime} and #{params.endCreateTime}</if>
+ </where>
+ </select>
+
+ <select id="selectYwUnitById" parameterType="Long" resultMap="YwUnitResult">
+ <include refid="selectYwUnitVo"/>
+ where id = #{id}
+ </select>
+
+ <insert id="insertYwUnit" parameterType="YwUnit" useGeneratedKeys="true" keyProperty="id">
+ insert into t_yw_unit
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="unitCode != null and unitCode != ''">unit_code,</if>
+ <if test="unitName != null and unitName != ''">unit_name,</if>
+ <if test="unitContact != null and unitContact != ''">unit_contact,</if>
+ <if test="unitContactPhone != null and unitContactPhone != ''">unit_contact_phone,</if>
+ <if test="unitAdminAccount != null and unitAdminAccount != ''">unit_admin_account,</if>
+ <if test="remark != null">remark,</if>
+ <if test="createTime != null">create_time,</if>
+ <if test="updateTime != null">update_time,</if>
+ <if test="deleted != null">deleted,</if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="unitCode != null and unitCode != ''">#{unitCode},</if>
+ <if test="unitName != null and unitName != ''">#{unitName},</if>
+ <if test="unitContact != null and unitContact != ''">#{unitContact},</if>
+ <if test="unitContactPhone != null and unitContactPhone != ''">#{unitContactPhone},</if>
+ <if test="unitAdminAccount != null and unitAdminAccount != ''">#{unitAdminAccount},</if>
+ <if test="remark != null">#{remark},</if>
+ <if test="createTime != null">#{createTime},</if>
+ <if test="updateTime != null">#{updateTime},</if>
+ <if test="deleted != null">#{deleted},</if>
+ </trim>
+ </insert>
+
+ <update id="updateYwUnit" parameterType="YwUnit">
+ update t_yw_unit
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="unitCode != null and unitCode != ''">unit_code = #{unitCode},</if>
+ <if test="unitName != null and unitName != ''">unit_name = #{unitName},</if>
+ <if test="unitContact != null and unitContact != ''">unit_contact = #{unitContact},</if>
+ <if test="unitContactPhone != null and unitContactPhone != ''">unit_contact_phone = #{unitContactPhone},</if>
+ <if test="unitAdminAccount != null and unitAdminAccount != ''">unit_admin_account = #{unitAdminAccount},</if>
+ <if test="remark != null">remark = #{remark},</if>
+ <if test="createTime != null">create_time = #{createTime},</if>
+ <if test="updateTime != null">update_time = #{updateTime},</if>
+ <if test="deleted != null">deleted = #{deleted},</if>
+ </trim>
+ where id = #{id}
+ </update>
+
+ <delete id="deleteYwUnitById" parameterType="Long">
+ delete from t_yw_unit where id = #{id}
+ </delete>
+
+ <delete id="deleteYwUnitByIds" parameterType="String">
+ delete from t_yw_unit where id in
+ <foreach item="id" collection="array" open="(" separator="," close=")">
+ #{id}
+ </foreach>
+ </delete>
+</mapper>
\ No newline at end of file
--
Gitblit v1.8.0