From ba838ee8414324524b33ca6a06163cea6a995dbd Mon Sep 17 00:00:00 2001
From: yxh <172933527@qq.com>
Date: 星期六, 04 三月 2023 18:00:06 +0800
Subject: [PATCH] yxh
---
smartor/src/main/java/com/smartor/domain/HeLocallibrary.java | 282 ++++++++++++
smartor/src/main/java/com/smartor/mapper/HeLocallibraryMapper.java | 61 ++
smartor/src/main/java/com/smartor/service/impl/HeCategoryServiceImpl.java | 96 ++++
smartor/src/main/java/com/smartor/mapper/HeCategoryMapper.java | 61 ++
smartor/src/main/java/com/smartor/service/IHeLocallibraryService.java | 61 ++
smartor/src/main/java/com/smartor/service/IHeCategoryService.java | 61 ++
smartor/src/main/java/com/smartor/service/impl/HeLocallibraryServiceImpl.java | 96 ++++
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeCategoryController.java | 104 ++++
ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeLocallibraryController.java | 104 ++++
smartor/src/main/resources/mapper/smartor/HeLocallibraryMapper.xml | 151 ++++++
smartor/src/main/resources/mapper/smartor/HeCategoryMapper.xml | 89 ++++
smartor/src/main/java/com/smartor/domain/HeCategory.java | 110 +++++
12 files changed, 1,276 insertions(+), 0 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeCategoryController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeCategoryController.java
new file mode 100644
index 0000000..0967405
--- /dev/null
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeCategoryController.java
@@ -0,0 +1,104 @@
+package com.smartor.controller;
+
+import java.util.List;
+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.HeCategory;
+import com.smartor.service.IHeCategoryService;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.common.core.page.TableDataInfo;
+
+/**
+ * 瀹ｆ暀鍒嗙被Controller
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+@RestController
+@RequestMapping("/smartor/hecategory")
+public class HeCategoryController extends BaseController
+{
+ @Autowired
+ private IHeCategoryService heCategoryService;
+
+ /**
+ * 鏌ヨ瀹ｆ暀鍒嗙被鍒楄〃
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:hecategory:list')")
+ @GetMapping("/list")
+ public TableDataInfo list(HeCategory heCategory)
+ {
+ startPage();
+ List<HeCategory> list = heCategoryService.selectHeCategoryList(heCategory);
+ return getDataTable(list);
+ }
+
+ /**
+ * 瀵煎嚭瀹ｆ暀鍒嗙被鍒楄〃
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:hecategory:export')")
+ @Log(title = "瀹ｆ暀鍒嗙被", businessType = BusinessType.EXPORT)
+ @PostMapping("/export")
+ public void export(HttpServletResponse response, HeCategory heCategory)
+ {
+ List<HeCategory> list = heCategoryService.selectHeCategoryList(heCategory);
+ ExcelUtil<HeCategory> util = new ExcelUtil<HeCategory>(HeCategory.class);
+ util.exportExcel(response, list, "瀹ｆ暀鍒嗙被鏁版嵁");
+ }
+
+ /**
+ * 鑾峰彇瀹ｆ暀鍒嗙被璇︾粏淇℃伅
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:hecategory:query')")
+ @GetMapping(value = "/{id}")
+ public AjaxResult getInfo(@PathVariable("id") Long id)
+ {
+ return success(heCategoryService.selectHeCategoryById(id));
+ }
+
+ /**
+ * 鏂板瀹ｆ暀鍒嗙被
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:hecategory:add')")
+ @Log(title = "瀹ｆ暀鍒嗙被", businessType = BusinessType.INSERT)
+ @PostMapping
+ public AjaxResult add(@RequestBody HeCategory heCategory)
+ {
+ return toAjax(heCategoryService.insertHeCategory(heCategory));
+ }
+
+ /**
+ * 淇敼瀹ｆ暀鍒嗙被
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:hecategory:edit')")
+ @Log(title = "瀹ｆ暀鍒嗙被", businessType = BusinessType.UPDATE)
+ @PutMapping
+ public AjaxResult edit(@RequestBody HeCategory heCategory)
+ {
+ return toAjax(heCategoryService.updateHeCategory(heCategory));
+ }
+
+ /**
+ * 鍒犻櫎瀹ｆ暀鍒嗙被
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:hecategory:remove')")
+ @Log(title = "瀹ｆ暀鍒嗙被", businessType = BusinessType.DELETE)
+ @DeleteMapping("/{ids}")
+ public AjaxResult remove(@PathVariable Long[] ids)
+ {
+ return toAjax(heCategoryService.deleteHeCategoryByIds(ids));
+ }
+}
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeLocallibraryController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeLocallibraryController.java
new file mode 100644
index 0000000..5b0340b
--- /dev/null
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/HeLocallibraryController.java
@@ -0,0 +1,104 @@
+package com.smartor.controller;
+
+import java.util.List;
+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.HeLocallibrary;
+import com.smartor.service.IHeLocallibraryService;
+import com.ruoyi.common.utils.poi.ExcelUtil;
+import com.ruoyi.common.core.page.TableDataInfo;
+
+/**
+ * 瀹ｆ暀搴揅ontroller
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+@RestController
+@RequestMapping("/smartor/helibrary")
+public class HeLocallibraryController extends BaseController
+{
+ @Autowired
+ private IHeLocallibraryService heLocallibraryService;
+
+ /**
+ * 鏌ヨ瀹ｆ暀搴撳垪琛�
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:helibrary:list')")
+ @GetMapping("/list")
+ public TableDataInfo list(HeLocallibrary heLocallibrary)
+ {
+ startPage();
+ List<HeLocallibrary> list = heLocallibraryService.selectHeLocallibraryList(heLocallibrary);
+ return getDataTable(list);
+ }
+
+ /**
+ * 瀵煎嚭瀹ｆ暀搴撳垪琛�
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:helibrary:export')")
+ @Log(title = "瀹ｆ暀搴�", businessType = BusinessType.EXPORT)
+ @PostMapping("/export")
+ public void export(HttpServletResponse response, HeLocallibrary heLocallibrary)
+ {
+ List<HeLocallibrary> list = heLocallibraryService.selectHeLocallibraryList(heLocallibrary);
+ ExcelUtil<HeLocallibrary> util = new ExcelUtil<HeLocallibrary>(HeLocallibrary.class);
+ util.exportExcel(response, list, "瀹ｆ暀搴撴暟鎹�");
+ }
+
+ /**
+ * 鑾峰彇瀹ｆ暀搴撹缁嗕俊鎭�
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:helibrary:query')")
+ @GetMapping(value = "/{id}")
+ public AjaxResult getInfo(@PathVariable("id") Long id)
+ {
+ return success(heLocallibraryService.selectHeLocallibraryById(id));
+ }
+
+ /**
+ * 鏂板瀹ｆ暀搴�
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:helibrary:add')")
+ @Log(title = "瀹ｆ暀搴�", businessType = BusinessType.INSERT)
+ @PostMapping
+ public AjaxResult add(@RequestBody HeLocallibrary heLocallibrary)
+ {
+ return toAjax(heLocallibraryService.insertHeLocallibrary(heLocallibrary));
+ }
+
+ /**
+ * 淇敼瀹ｆ暀搴�
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:helibrary:edit')")
+ @Log(title = "瀹ｆ暀搴�", businessType = BusinessType.UPDATE)
+ @PutMapping
+ public AjaxResult edit(@RequestBody HeLocallibrary heLocallibrary)
+ {
+ return toAjax(heLocallibraryService.updateHeLocallibrary(heLocallibrary));
+ }
+
+ /**
+ * 鍒犻櫎瀹ｆ暀搴�
+ */
+ @PreAuthorize("@ss.hasPermi('smartor:helibrary:remove')")
+ @Log(title = "瀹ｆ暀搴�", businessType = BusinessType.DELETE)
+ @DeleteMapping("/{ids}")
+ public AjaxResult remove(@PathVariable Long[] ids)
+ {
+ return toAjax(heLocallibraryService.deleteHeLocallibraryByIds(ids));
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/domain/HeCategory.java b/smartor/src/main/java/com/smartor/domain/HeCategory.java
new file mode 100644
index 0000000..dec2109
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/domain/HeCategory.java
@@ -0,0 +1,110 @@
+package com.smartor.domain;
+
+import java.util.Date;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import org.apache.commons.lang3.builder.ToStringBuilder;
+import org.apache.commons.lang3.builder.ToStringStyle;
+import com.ruoyi.common.annotation.Excel;
+import com.ruoyi.common.core.domain.BaseEntity;
+
+/**
+ * 瀹ｆ暀鍒嗙被瀵硅薄 he_category
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+public class HeCategory extends BaseEntity
+{
+ private static final long serialVersionUID = 1L;
+
+ /** 鑷ID */
+ private Long id;
+
+ /** 鍒嗙被鍚嶇О */
+ @Excel(name = " 鍒嗙被鍚嶇О ")
+ private String categoryname;
+
+ /** 鏈烘瀯ID */
+ @Excel(name = " 鏈烘瀯ID ")
+ private String orgid;
+
+ /** 鍒犻櫎鏍囪 */
+ private String delFlag;
+
+ /** 涓婁紶鏍囪 */
+ private Long isupload;
+
+ /** 涓婁紶鏃堕棿 */
+ private Date uploadTime;
+
+ public void setId(Long id)
+ {
+ this.id = id;
+ }
+
+ public Long getId()
+ {
+ return id;
+ }
+ public void setCategoryname(String categoryname)
+ {
+ this.categoryname = categoryname;
+ }
+
+ public String getCategoryname()
+ {
+ return categoryname;
+ }
+ public void setOrgid(String orgid)
+ {
+ this.orgid = orgid;
+ }
+
+ public String getOrgid()
+ {
+ return orgid;
+ }
+ public void setDelFlag(String delFlag)
+ {
+ this.delFlag = delFlag;
+ }
+
+ public String getDelFlag()
+ {
+ return delFlag;
+ }
+ public void setIsupload(Long isupload)
+ {
+ this.isupload = isupload;
+ }
+
+ public Long getIsupload()
+ {
+ return isupload;
+ }
+ public void setUploadTime(Date uploadTime)
+ {
+ this.uploadTime = uploadTime;
+ }
+
+ public Date getUploadTime()
+ {
+ return uploadTime;
+ }
+
+ @Override
+ public String toString() {
+ return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
+ .append("id", getId())
+ .append("categoryname", getCategoryname())
+ .append("orgid", getOrgid())
+ .append("delFlag", getDelFlag())
+ .append("updateBy", getUpdateBy())
+ .append("updateTime", getUpdateTime())
+ .append("createBy", getCreateBy())
+ .append("createTime", getCreateTime())
+ .append("isupload", getIsupload())
+ .append("uploadTime", getUploadTime())
+ .toString();
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/domain/HeLocallibrary.java b/smartor/src/main/java/com/smartor/domain/HeLocallibrary.java
new file mode 100644
index 0000000..c13df71
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/domain/HeLocallibrary.java
@@ -0,0 +1,282 @@
+package com.smartor.domain;
+
+import java.math.BigDecimal;
+import java.util.Date;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import org.apache.commons.lang3.builder.ToStringBuilder;
+import org.apache.commons.lang3.builder.ToStringStyle;
+import com.ruoyi.common.annotation.Excel;
+import com.ruoyi.common.core.domain.BaseEntity;
+
+/**
+ * 瀹ｆ暀搴撳璞� he_locallibrary
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+public class HeLocallibrary extends BaseEntity
+{
+ private static final long serialVersionUID = 1L;
+
+ /** 鑷ID */
+ private Long id;
+
+ /** 瀹ｆ暀鍒嗙被 */
+ @Excel(name = " 瀹ｆ暀鍒嗙被 ")
+ private Long preachcategoryid;
+
+ /** 瀹ｆ暀鍚嶇О */
+ @Excel(name = " 瀹ｆ暀鍚嶇О ")
+ private String preachname;
+
+ /** 鐗堟湰 */
+ @Excel(name = " 鐗堟湰 ")
+ private BigDecimal version;
+
+ /** 瀹ｆ暀褰㈠紡 */
+ @Excel(name = " 瀹ｆ暀褰㈠紡 ")
+ private Long preachform;
+
+ /** 瀹ｆ暀鎻忚堪 */
+ @Excel(name = " 瀹ｆ暀鎻忚堪 ")
+ private String preachdescription;
+
+ /** 瀹ｆ暀鍐呭 */
+ @Excel(name = " 瀹ｆ暀鍐呭 ")
+ private String preachcontent;
+
+ /** 妯℃澘ID */
+ @Excel(name = " 妯℃澘ID ")
+ private Long templateid;
+
+ /** 瀹ｆ暀浠ｇ爜 */
+ @Excel(name = " 瀹ｆ暀浠ｇ爜 ")
+ private String preachcode;
+
+ /** 涓績搴揑D */
+ @Excel(name = " 涓績搴揑D ")
+ private Long centerlibraryid;
+
+ /** 鏄惁鍚敤 */
+ @Excel(name = " 鏄惁鍚敤 ")
+ private Long isenable;
+
+ /** 鏈烘瀯ID */
+ @Excel(name = " 鏈烘瀯ID ")
+ private String orgid;
+
+ /** 鍒犻櫎鏍囪 */
+ private String delFlag;
+
+ /** 涓婁紶鏍囪 */
+ @Excel(name = " 涓婁紶鏍囪 ")
+ private Long isupload;
+
+ /** 涓婁紶鏃堕棿 */
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd")
+ private Date uploadTime;
+
+ /** 瀹ｆ暀鍒嗙被 */
+ @Excel(name = " 瀹ｆ暀鍒嗙被 ")
+ private String classification;
+
+ /** 鏄惁鏈湴 */
+ @Excel(name = " 鏄惁鏈湴 ")
+ private Long islocal;
+
+ /** 涓績搴撲唬鐮� */
+ @Excel(name = " 涓績搴撲唬鐮� ")
+ private String centerlibrarycode;
+
+ public void setId(Long id)
+ {
+ this.id = id;
+ }
+
+ public Long getId()
+ {
+ return id;
+ }
+ public void setPreachcategoryid(Long preachcategoryid)
+ {
+ this.preachcategoryid = preachcategoryid;
+ }
+
+ public Long getPreachcategoryid()
+ {
+ return preachcategoryid;
+ }
+ public void setPreachname(String preachname)
+ {
+ this.preachname = preachname;
+ }
+
+ public String getPreachname()
+ {
+ return preachname;
+ }
+ public void setVersion(BigDecimal version)
+ {
+ this.version = version;
+ }
+
+ public BigDecimal getVersion()
+ {
+ return version;
+ }
+ public void setPreachform(Long preachform)
+ {
+ this.preachform = preachform;
+ }
+
+ public Long getPreachform()
+ {
+ return preachform;
+ }
+ public void setPreachdescription(String preachdescription)
+ {
+ this.preachdescription = preachdescription;
+ }
+
+ public String getPreachdescription()
+ {
+ return preachdescription;
+ }
+ public void setPreachcontent(String preachcontent)
+ {
+ this.preachcontent = preachcontent;
+ }
+
+ public String getPreachcontent()
+ {
+ return preachcontent;
+ }
+ public void setTemplateid(Long templateid)
+ {
+ this.templateid = templateid;
+ }
+
+ public Long getTemplateid()
+ {
+ return templateid;
+ }
+ public void setPreachcode(String preachcode)
+ {
+ this.preachcode = preachcode;
+ }
+
+ public String getPreachcode()
+ {
+ return preachcode;
+ }
+ public void setCenterlibraryid(Long centerlibraryid)
+ {
+ this.centerlibraryid = centerlibraryid;
+ }
+
+ public Long getCenterlibraryid()
+ {
+ return centerlibraryid;
+ }
+ public void setIsenable(Long isenable)
+ {
+ this.isenable = isenable;
+ }
+
+ public Long getIsenable()
+ {
+ return isenable;
+ }
+ public void setOrgid(String orgid)
+ {
+ this.orgid = orgid;
+ }
+
+ public String getOrgid()
+ {
+ return orgid;
+ }
+ public void setDelFlag(String delFlag)
+ {
+ this.delFlag = delFlag;
+ }
+
+ public String getDelFlag()
+ {
+ return delFlag;
+ }
+ public void setIsupload(Long isupload)
+ {
+ this.isupload = isupload;
+ }
+
+ public Long getIsupload()
+ {
+ return isupload;
+ }
+ public void setUploadTime(Date uploadTime)
+ {
+ this.uploadTime = uploadTime;
+ }
+
+ public Date getUploadTime()
+ {
+ return uploadTime;
+ }
+ public void setClassification(String classification)
+ {
+ this.classification = classification;
+ }
+
+ public String getClassification()
+ {
+ return classification;
+ }
+ public void setIslocal(Long islocal)
+ {
+ this.islocal = islocal;
+ }
+
+ public Long getIslocal()
+ {
+ return islocal;
+ }
+ public void setCenterlibrarycode(String centerlibrarycode)
+ {
+ this.centerlibrarycode = centerlibrarycode;
+ }
+
+ public String getCenterlibrarycode()
+ {
+ return centerlibrarycode;
+ }
+
+ @Override
+ public String toString() {
+ return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
+ .append("id", getId())
+ .append("preachcategoryid", getPreachcategoryid())
+ .append("preachname", getPreachname())
+ .append("version", getVersion())
+ .append("preachform", getPreachform())
+ .append("preachdescription", getPreachdescription())
+ .append("preachcontent", getPreachcontent())
+ .append("templateid", getTemplateid())
+ .append("preachcode", getPreachcode())
+ .append("centerlibraryid", getCenterlibraryid())
+ .append("isenable", getIsenable())
+ .append("orgid", getOrgid())
+ .append("updateBy", getUpdateBy())
+ .append("updateTime", getUpdateTime())
+ .append("delFlag", getDelFlag())
+ .append("createBy", getCreateBy())
+ .append("createTime", getCreateTime())
+ .append("isupload", getIsupload())
+ .append("uploadTime", getUploadTime())
+ .append("classification", getClassification())
+ .append("islocal", getIslocal())
+ .append("centerlibrarycode", getCenterlibrarycode())
+ .toString();
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/mapper/HeCategoryMapper.java b/smartor/src/main/java/com/smartor/mapper/HeCategoryMapper.java
new file mode 100644
index 0000000..098d575
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/mapper/HeCategoryMapper.java
@@ -0,0 +1,61 @@
+package com.smartor.mapper;
+
+import java.util.List;
+import com.smartor.domain.HeCategory;
+
+/**
+ * 瀹ｆ暀鍒嗙被Mapper鎺ュ彛
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+public interface HeCategoryMapper
+{
+ /**
+ * 鏌ヨ瀹ｆ暀鍒嗙被
+ *
+ * @param id 瀹ｆ暀鍒嗙被涓婚敭
+ * @return 瀹ｆ暀鍒嗙被
+ */
+ public HeCategory selectHeCategoryById(Long id);
+
+ /**
+ * 鏌ヨ瀹ｆ暀鍒嗙被鍒楄〃
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 瀹ｆ暀鍒嗙被闆嗗悎
+ */
+ public List<HeCategory> selectHeCategoryList(HeCategory heCategory);
+
+ /**
+ * 鏂板瀹ｆ暀鍒嗙被
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 缁撴灉
+ */
+ public int insertHeCategory(HeCategory heCategory);
+
+ /**
+ * 淇敼瀹ｆ暀鍒嗙被
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 缁撴灉
+ */
+ public int updateHeCategory(HeCategory heCategory);
+
+ /**
+ * 鍒犻櫎瀹ｆ暀鍒嗙被
+ *
+ * @param id 瀹ｆ暀鍒嗙被涓婚敭
+ * @return 缁撴灉
+ */
+ public int deleteHeCategoryById(Long id);
+
+ /**
+ * 鎵归噺鍒犻櫎瀹ｆ暀鍒嗙被
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deleteHeCategoryByIds(Long[] ids);
+}
diff --git a/smartor/src/main/java/com/smartor/mapper/HeLocallibraryMapper.java b/smartor/src/main/java/com/smartor/mapper/HeLocallibraryMapper.java
new file mode 100644
index 0000000..7bdb56b
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/mapper/HeLocallibraryMapper.java
@@ -0,0 +1,61 @@
+package com.smartor.mapper;
+
+import java.util.List;
+import com.smartor.domain.HeLocallibrary;
+
+/**
+ * 瀹ｆ暀搴揗apper鎺ュ彛
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+public interface HeLocallibraryMapper
+{
+ /**
+ * 鏌ヨ瀹ｆ暀搴�
+ *
+ * @param id 瀹ｆ暀搴撲富閿�
+ * @return 瀹ｆ暀搴�
+ */
+ public HeLocallibrary selectHeLocallibraryById(Long id);
+
+ /**
+ * 鏌ヨ瀹ｆ暀搴撳垪琛�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 瀹ｆ暀搴撻泦鍚�
+ */
+ public List<HeLocallibrary> selectHeLocallibraryList(HeLocallibrary heLocallibrary);
+
+ /**
+ * 鏂板瀹ｆ暀搴�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 缁撴灉
+ */
+ public int insertHeLocallibrary(HeLocallibrary heLocallibrary);
+
+ /**
+ * 淇敼瀹ｆ暀搴�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 缁撴灉
+ */
+ public int updateHeLocallibrary(HeLocallibrary heLocallibrary);
+
+ /**
+ * 鍒犻櫎瀹ｆ暀搴�
+ *
+ * @param id 瀹ｆ暀搴撲富閿�
+ * @return 缁撴灉
+ */
+ public int deleteHeLocallibraryById(Long id);
+
+ /**
+ * 鎵归噺鍒犻櫎瀹ｆ暀搴�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deleteHeLocallibraryByIds(Long[] ids);
+}
diff --git a/smartor/src/main/java/com/smartor/service/IHeCategoryService.java b/smartor/src/main/java/com/smartor/service/IHeCategoryService.java
new file mode 100644
index 0000000..4123bdc
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/IHeCategoryService.java
@@ -0,0 +1,61 @@
+package com.smartor.service;
+
+import java.util.List;
+import com.smartor.domain.HeCategory;
+
+/**
+ * 瀹ｆ暀鍒嗙被Service鎺ュ彛
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+public interface IHeCategoryService
+{
+ /**
+ * 鏌ヨ瀹ｆ暀鍒嗙被
+ *
+ * @param id 瀹ｆ暀鍒嗙被涓婚敭
+ * @return 瀹ｆ暀鍒嗙被
+ */
+ public HeCategory selectHeCategoryById(Long id);
+
+ /**
+ * 鏌ヨ瀹ｆ暀鍒嗙被鍒楄〃
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 瀹ｆ暀鍒嗙被闆嗗悎
+ */
+ public List<HeCategory> selectHeCategoryList(HeCategory heCategory);
+
+ /**
+ * 鏂板瀹ｆ暀鍒嗙被
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 缁撴灉
+ */
+ public int insertHeCategory(HeCategory heCategory);
+
+ /**
+ * 淇敼瀹ｆ暀鍒嗙被
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 缁撴灉
+ */
+ public int updateHeCategory(HeCategory heCategory);
+
+ /**
+ * 鎵归噺鍒犻櫎瀹ｆ暀鍒嗙被
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑瀹ｆ暀鍒嗙被涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deleteHeCategoryByIds(Long[] ids);
+
+ /**
+ * 鍒犻櫎瀹ｆ暀鍒嗙被淇℃伅
+ *
+ * @param id 瀹ｆ暀鍒嗙被涓婚敭
+ * @return 缁撴灉
+ */
+ public int deleteHeCategoryById(Long id);
+}
diff --git a/smartor/src/main/java/com/smartor/service/IHeLocallibraryService.java b/smartor/src/main/java/com/smartor/service/IHeLocallibraryService.java
new file mode 100644
index 0000000..4948c6b
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/IHeLocallibraryService.java
@@ -0,0 +1,61 @@
+package com.smartor.service;
+
+import java.util.List;
+import com.smartor.domain.HeLocallibrary;
+
+/**
+ * 瀹ｆ暀搴揝ervice鎺ュ彛
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+public interface IHeLocallibraryService
+{
+ /**
+ * 鏌ヨ瀹ｆ暀搴�
+ *
+ * @param id 瀹ｆ暀搴撲富閿�
+ * @return 瀹ｆ暀搴�
+ */
+ public HeLocallibrary selectHeLocallibraryById(Long id);
+
+ /**
+ * 鏌ヨ瀹ｆ暀搴撳垪琛�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 瀹ｆ暀搴撻泦鍚�
+ */
+ public List<HeLocallibrary> selectHeLocallibraryList(HeLocallibrary heLocallibrary);
+
+ /**
+ * 鏂板瀹ｆ暀搴�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 缁撴灉
+ */
+ public int insertHeLocallibrary(HeLocallibrary heLocallibrary);
+
+ /**
+ * 淇敼瀹ｆ暀搴�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 缁撴灉
+ */
+ public int updateHeLocallibrary(HeLocallibrary heLocallibrary);
+
+ /**
+ * 鎵归噺鍒犻櫎瀹ｆ暀搴�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑瀹ｆ暀搴撲富閿泦鍚�
+ * @return 缁撴灉
+ */
+ public int deleteHeLocallibraryByIds(Long[] ids);
+
+ /**
+ * 鍒犻櫎瀹ｆ暀搴撲俊鎭�
+ *
+ * @param id 瀹ｆ暀搴撲富閿�
+ * @return 缁撴灉
+ */
+ public int deleteHeLocallibraryById(Long id);
+}
diff --git a/smartor/src/main/java/com/smartor/service/impl/HeCategoryServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/HeCategoryServiceImpl.java
new file mode 100644
index 0000000..60d5bff
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/impl/HeCategoryServiceImpl.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.HeCategoryMapper;
+import com.smartor.domain.HeCategory;
+import com.smartor.service.IHeCategoryService;
+
+/**
+ * 瀹ｆ暀鍒嗙被Service涓氬姟灞傚鐞�
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+@Service
+public class HeCategoryServiceImpl implements IHeCategoryService
+{
+ @Autowired
+ private HeCategoryMapper heCategoryMapper;
+
+ /**
+ * 鏌ヨ瀹ｆ暀鍒嗙被
+ *
+ * @param id 瀹ｆ暀鍒嗙被涓婚敭
+ * @return 瀹ｆ暀鍒嗙被
+ */
+ @Override
+ public HeCategory selectHeCategoryById(Long id)
+ {
+ return heCategoryMapper.selectHeCategoryById(id);
+ }
+
+ /**
+ * 鏌ヨ瀹ｆ暀鍒嗙被鍒楄〃
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 瀹ｆ暀鍒嗙被
+ */
+ @Override
+ public List<HeCategory> selectHeCategoryList(HeCategory heCategory)
+ {
+ return heCategoryMapper.selectHeCategoryList(heCategory);
+ }
+
+ /**
+ * 鏂板瀹ｆ暀鍒嗙被
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 缁撴灉
+ */
+ @Override
+ public int insertHeCategory(HeCategory heCategory)
+ {
+ heCategory.setCreateTime(DateUtils.getNowDate());
+ return heCategoryMapper.insertHeCategory(heCategory);
+ }
+
+ /**
+ * 淇敼瀹ｆ暀鍒嗙被
+ *
+ * @param heCategory 瀹ｆ暀鍒嗙被
+ * @return 缁撴灉
+ */
+ @Override
+ public int updateHeCategory(HeCategory heCategory)
+ {
+ heCategory.setUpdateTime(DateUtils.getNowDate());
+ return heCategoryMapper.updateHeCategory(heCategory);
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎瀹ｆ暀鍒嗙被
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑瀹ｆ暀鍒嗙被涓婚敭
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteHeCategoryByIds(Long[] ids)
+ {
+ return heCategoryMapper.deleteHeCategoryByIds(ids);
+ }
+
+ /**
+ * 鍒犻櫎瀹ｆ暀鍒嗙被淇℃伅
+ *
+ * @param id 瀹ｆ暀鍒嗙被涓婚敭
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteHeCategoryById(Long id)
+ {
+ return heCategoryMapper.deleteHeCategoryById(id);
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/service/impl/HeLocallibraryServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/HeLocallibraryServiceImpl.java
new file mode 100644
index 0000000..0b5c998
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/impl/HeLocallibraryServiceImpl.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.HeLocallibraryMapper;
+import com.smartor.domain.HeLocallibrary;
+import com.smartor.service.IHeLocallibraryService;
+
+/**
+ * 瀹ｆ暀搴揝ervice涓氬姟灞傚鐞�
+ *
+ * @author smartor
+ * @date 2023-03-04
+ */
+@Service
+public class HeLocallibraryServiceImpl implements IHeLocallibraryService
+{
+ @Autowired
+ private HeLocallibraryMapper heLocallibraryMapper;
+
+ /**
+ * 鏌ヨ瀹ｆ暀搴�
+ *
+ * @param id 瀹ｆ暀搴撲富閿�
+ * @return 瀹ｆ暀搴�
+ */
+ @Override
+ public HeLocallibrary selectHeLocallibraryById(Long id)
+ {
+ return heLocallibraryMapper.selectHeLocallibraryById(id);
+ }
+
+ /**
+ * 鏌ヨ瀹ｆ暀搴撳垪琛�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 瀹ｆ暀搴�
+ */
+ @Override
+ public List<HeLocallibrary> selectHeLocallibraryList(HeLocallibrary heLocallibrary)
+ {
+ return heLocallibraryMapper.selectHeLocallibraryList(heLocallibrary);
+ }
+
+ /**
+ * 鏂板瀹ｆ暀搴�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 缁撴灉
+ */
+ @Override
+ public int insertHeLocallibrary(HeLocallibrary heLocallibrary)
+ {
+ heLocallibrary.setCreateTime(DateUtils.getNowDate());
+ return heLocallibraryMapper.insertHeLocallibrary(heLocallibrary);
+ }
+
+ /**
+ * 淇敼瀹ｆ暀搴�
+ *
+ * @param heLocallibrary 瀹ｆ暀搴�
+ * @return 缁撴灉
+ */
+ @Override
+ public int updateHeLocallibrary(HeLocallibrary heLocallibrary)
+ {
+ heLocallibrary.setUpdateTime(DateUtils.getNowDate());
+ return heLocallibraryMapper.updateHeLocallibrary(heLocallibrary);
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎瀹ｆ暀搴�
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑瀹ｆ暀搴撲富閿�
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteHeLocallibraryByIds(Long[] ids)
+ {
+ return heLocallibraryMapper.deleteHeLocallibraryByIds(ids);
+ }
+
+ /**
+ * 鍒犻櫎瀹ｆ暀搴撲俊鎭�
+ *
+ * @param id 瀹ｆ暀搴撲富閿�
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteHeLocallibraryById(Long id)
+ {
+ return heLocallibraryMapper.deleteHeLocallibraryById(id);
+ }
+}
diff --git a/smartor/src/main/resources/mapper/smartor/HeCategoryMapper.xml b/smartor/src/main/resources/mapper/smartor/HeCategoryMapper.xml
new file mode 100644
index 0000000..0c33367
--- /dev/null
+++ b/smartor/src/main/resources/mapper/smartor/HeCategoryMapper.xml
@@ -0,0 +1,89 @@
+<?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.HeCategoryMapper">
+
+ <resultMap type="HeCategory" id="HeCategoryResult">
+ <result property="id" column="id" />
+ <result property="categoryname" column="categoryname" />
+ <result property="orgid" column="orgid" />
+ <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" />
+ </resultMap>
+
+ <sql id="selectHeCategoryVo">
+ select id, categoryname, orgid, del_flag, update_by, update_time, create_by, create_time, isupload, upload_time from he_category
+ </sql>
+
+ <select id="selectHeCategoryList" parameterType="HeCategory" resultMap="HeCategoryResult">
+ <include refid="selectHeCategoryVo"/>
+ <where>
+ <if test="categoryname != null and categoryname != ''"> and categoryname like concat('%', #{categoryname}, '%')</if>
+ <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if>
+ </where>
+ </select>
+
+ <select id="selectHeCategoryById" parameterType="Long" resultMap="HeCategoryResult">
+ <include refid="selectHeCategoryVo"/>
+ where id = #{id}
+ </select>
+
+ <insert id="insertHeCategory" parameterType="HeCategory" useGeneratedKeys="true" keyProperty="id">
+ insert into he_category
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="categoryname != null">categoryname,</if>
+ <if test="orgid != null">orgid,</if>
+ <if test="delFlag != null and delFlag != ''">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>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="categoryname != null">#{categoryname},</if>
+ <if test="orgid != null">#{orgid},</if>
+ <if test="delFlag != null and delFlag != ''">#{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>
+ </trim>
+ </insert>
+
+ <update id="updateHeCategory" parameterType="HeCategory">
+ update he_category
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="categoryname != null">categoryname = #{categoryname},</if>
+ <if test="orgid != null">orgid = #{orgid},</if>
+ <if test="delFlag != null and delFlag != ''">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>
+ </trim>
+ where id = #{id}
+ </update>
+
+ <delete id="deleteHeCategoryById" parameterType="Long">
+ delete from he_category where id = #{id}
+ </delete>
+
+ <delete id="deleteHeCategoryByIds" parameterType="String">
+ delete from he_category where id in
+ <foreach item="id" collection="array" open="(" separator="," close=")">
+ #{id}
+ </foreach>
+ </delete>
+</mapper>
\ No newline at end of file
diff --git a/smartor/src/main/resources/mapper/smartor/HeLocallibraryMapper.xml b/smartor/src/main/resources/mapper/smartor/HeLocallibraryMapper.xml
new file mode 100644
index 0000000..e1293e2
--- /dev/null
+++ b/smartor/src/main/resources/mapper/smartor/HeLocallibraryMapper.xml
@@ -0,0 +1,151 @@
+<?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.HeLocallibraryMapper">
+
+ <resultMap type="HeLocallibrary" id="HeLocallibraryResult">
+ <result property="id" column="id" />
+ <result property="preachcategoryid" column="preachcategoryid" />
+ <result property="preachname" column="preachname" />
+ <result property="version" column="version" />
+ <result property="preachform" column="preachform" />
+ <result property="preachdescription" column="preachdescription" />
+ <result property="preachcontent" column="preachcontent" />
+ <result property="templateid" column="templateid" />
+ <result property="preachcode" column="preachcode" />
+ <result property="centerlibraryid" column="centerlibraryid" />
+ <result property="isenable" column="isenable" />
+ <result property="orgid" column="orgid" />
+ <result property="updateBy" column="update_by" />
+ <result property="updateTime" column="update_time" />
+ <result property="delFlag" column="del_flag" />
+ <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="classification" column="classification" />
+ <result property="islocal" column="islocal" />
+ <result property="centerlibrarycode" column="centerlibrarycode" />
+ </resultMap>
+
+ <sql id="selectHeLocallibraryVo">
+ select id, preachcategoryid, preachname, version, preachform, preachdescription, preachcontent, templateid, preachcode, centerlibraryid, isenable, orgid, update_by, update_time, del_flag, create_by, create_time, isupload, upload_time, classification, islocal, centerlibrarycode from he_locallibrary
+ </sql>
+
+ <select id="selectHeLocallibraryList" parameterType="HeLocallibrary" resultMap="HeLocallibraryResult">
+ <include refid="selectHeLocallibraryVo"/>
+ <where>
+ <if test="preachcategoryid != null "> and preachcategoryid = #{preachcategoryid}</if>
+ <if test="preachname != null and preachname != ''"> and preachname like concat('%', #{preachname}, '%')</if>
+ <if test="version != null "> and version = #{version}</if>
+ <if test="preachform != null "> and preachform = #{preachform}</if>
+ <if test="preachdescription != null and preachdescription != ''"> and preachdescription = #{preachdescription}</if>
+ <if test="preachcontent != null and preachcontent != ''"> and preachcontent = #{preachcontent}</if>
+ <if test="templateid != null "> and templateid = #{templateid}</if>
+ <if test="preachcode != null and preachcode != ''"> and preachcode = #{preachcode}</if>
+ <if test="centerlibraryid != null "> and centerlibraryid = #{centerlibraryid}</if>
+ <if test="isenable != null "> and isenable = #{isenable}</if>
+ <if test="orgid != null and orgid != ''"> and orgid = #{orgid}</if>
+ <if test="isupload != null "> and isupload = #{isupload}</if>
+ <if test="uploadTime != null "> and upload_time = #{uploadTime}</if>
+ <if test="classification != null and classification != ''"> and classification = #{classification}</if>
+ <if test="islocal != null "> and islocal = #{islocal}</if>
+ <if test="centerlibrarycode != null and centerlibrarycode != ''"> and centerlibrarycode = #{centerlibrarycode}</if>
+ </where>
+ </select>
+
+ <select id="selectHeLocallibraryById" parameterType="Long" resultMap="HeLocallibraryResult">
+ <include refid="selectHeLocallibraryVo"/>
+ where id = #{id}
+ </select>
+
+ <insert id="insertHeLocallibrary" parameterType="HeLocallibrary" useGeneratedKeys="true" keyProperty="id">
+ insert into he_locallibrary
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="preachcategoryid != null">preachcategoryid,</if>
+ <if test="preachname != null">preachname,</if>
+ <if test="version != null">version,</if>
+ <if test="preachform != null">preachform,</if>
+ <if test="preachdescription != null">preachdescription,</if>
+ <if test="preachcontent != null">preachcontent,</if>
+ <if test="templateid != null">templateid,</if>
+ <if test="preachcode != null">preachcode,</if>
+ <if test="centerlibraryid != null">centerlibraryid,</if>
+ <if test="isenable != null">isenable,</if>
+ <if test="orgid != null">orgid,</if>
+ <if test="updateBy != null">update_by,</if>
+ <if test="updateTime != null">update_time,</if>
+ <if test="delFlag != null and delFlag != ''">del_flag,</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="classification != null">classification,</if>
+ <if test="islocal != null">islocal,</if>
+ <if test="centerlibrarycode != null">centerlibrarycode,</if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="preachcategoryid != null">#{preachcategoryid},</if>
+ <if test="preachname != null">#{preachname},</if>
+ <if test="version != null">#{version},</if>
+ <if test="preachform != null">#{preachform},</if>
+ <if test="preachdescription != null">#{preachdescription},</if>
+ <if test="preachcontent != null">#{preachcontent},</if>
+ <if test="templateid != null">#{templateid},</if>
+ <if test="preachcode != null">#{preachcode},</if>
+ <if test="centerlibraryid != null">#{centerlibraryid},</if>
+ <if test="isenable != null">#{isenable},</if>
+ <if test="orgid != null">#{orgid},</if>
+ <if test="updateBy != null">#{updateBy},</if>
+ <if test="updateTime != null">#{updateTime},</if>
+ <if test="delFlag != null and delFlag != ''">#{delFlag},</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="classification != null">#{classification},</if>
+ <if test="islocal != null">#{islocal},</if>
+ <if test="centerlibrarycode != null">#{centerlibrarycode},</if>
+ </trim>
+ </insert>
+
+ <update id="updateHeLocallibrary" parameterType="HeLocallibrary">
+ update he_locallibrary
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="preachcategoryid != null">preachcategoryid = #{preachcategoryid},</if>
+ <if test="preachname != null">preachname = #{preachname},</if>
+ <if test="version != null">version = #{version},</if>
+ <if test="preachform != null">preachform = #{preachform},</if>
+ <if test="preachdescription != null">preachdescription = #{preachdescription},</if>
+ <if test="preachcontent != null">preachcontent = #{preachcontent},</if>
+ <if test="templateid != null">templateid = #{templateid},</if>
+ <if test="preachcode != null">preachcode = #{preachcode},</if>
+ <if test="centerlibraryid != null">centerlibraryid = #{centerlibraryid},</if>
+ <if test="isenable != null">isenable = #{isenable},</if>
+ <if test="orgid != null">orgid = #{orgid},</if>
+ <if test="updateBy != null">update_by = #{updateBy},</if>
+ <if test="updateTime != null">update_time = #{updateTime},</if>
+ <if test="delFlag != null and delFlag != ''">del_flag = #{delFlag},</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="classification != null">classification = #{classification},</if>
+ <if test="islocal != null">islocal = #{islocal},</if>
+ <if test="centerlibrarycode != null">centerlibrarycode = #{centerlibrarycode},</if>
+ </trim>
+ where id = #{id}
+ </update>
+
+ <delete id="deleteHeLocallibraryById" parameterType="Long">
+ delete from he_locallibrary where id = #{id}
+ </delete>
+
+ <delete id="deleteHeLocallibraryByIds" parameterType="String">
+ delete from he_locallibrary where id in
+ <foreach item="id" collection="array" open="(" separator="," close=")">
+ #{id}
+ </foreach>
+ </delete>
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.3