From 64a177b3ee0f2b4a33b1a119d6c2d8451cc7065f Mon Sep 17 00:00:00 2001
From: jiang <1354748262@qq.com>
Date: 星期一, 15 一月 2024 08:48:11 +0800
Subject: [PATCH] 更新机型序号
---
jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/service/impl/BsModelNumberServiceImpl.java | 96 ++++
jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/controller/BsModelNumberController.java | 104 +++++
jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/domain/BsModelNumber.java | 221 +++++++++++
jcdm-ui/src/views/main/bs/modelNumber/index.vue | 445 ++++++++++++++++++++++
jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/mapper/BsModelNumberMapper.java | 61 +++
jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/service/IBsModelNumberService.java | 61 +++
jcdm-main/src/main/resources/mapper/bs/modelNumber/BsModelNumberMapper.xml | 124 ++++++
jcdm-ui/src/api/main/bs/modelNumber/modelNumber.js | 44 ++
8 files changed, 1,156 insertions(+), 0 deletions(-)
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/controller/BsModelNumberController.java b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/controller/BsModelNumberController.java
new file mode 100644
index 0000000..be44095
--- /dev/null
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/controller/BsModelNumberController.java
@@ -0,0 +1,104 @@
+package com.jcdm.main.bs.modelNumber.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.jcdm.common.annotation.Log;
+import com.jcdm.common.core.controller.BaseController;
+import com.jcdm.common.core.domain.AjaxResult;
+import com.jcdm.common.enums.BusinessType;
+import com.jcdm.main.bs.modelNumber.domain.BsModelNumber;
+import com.jcdm.main.bs.modelNumber.service.IBsModelNumberService;
+import com.jcdm.common.utils.poi.ExcelUtil;
+import com.jcdm.common.core.page.TableDataInfo;
+
+/**
+ * 鏈哄瀷搴忓彿Controller
+ *
+ * @author jiang
+ * @date 2024-01-15
+ */
+@RestController
+@RequestMapping("/bs/modelNumber")
+public class BsModelNumberController extends BaseController
+{
+ @Autowired
+ private IBsModelNumberService bsModelNumberService;
+
+ /**
+ * 鏌ヨ鏈哄瀷搴忓彿鍒楄〃
+ */
+ @PreAuthorize("@ss.hasPermi('bs:modelNumber:list')")
+ @GetMapping("/list")
+ public TableDataInfo list(BsModelNumber bsModelNumber)
+ {
+ startPage();
+ List<BsModelNumber> list = bsModelNumberService.selectBsModelNumberList(bsModelNumber);
+ return getDataTable(list);
+ }
+
+ /**
+ * 瀵煎嚭鏈哄瀷搴忓彿鍒楄〃
+ */
+ @PreAuthorize("@ss.hasPermi('bs:modelNumber:export')")
+ @Log(title = "鏈哄瀷搴忓彿", businessType = BusinessType.EXPORT)
+ @PostMapping("/export")
+ public void export(HttpServletResponse response, BsModelNumber bsModelNumber)
+ {
+ List<BsModelNumber> list = bsModelNumberService.selectBsModelNumberList(bsModelNumber);
+ ExcelUtil<BsModelNumber> util = new ExcelUtil<BsModelNumber>(BsModelNumber.class);
+ util.exportExcel(response, list, "鏈哄瀷搴忓彿鏁版嵁");
+ }
+
+ /**
+ * 鑾峰彇鏈哄瀷搴忓彿璇︾粏淇℃伅
+ */
+ @PreAuthorize("@ss.hasPermi('bs:modelNumber:query')")
+ @GetMapping(value = "/{id}")
+ public AjaxResult getInfo(@PathVariable("id") Long id)
+ {
+ return success(bsModelNumberService.selectBsModelNumberById(id));
+ }
+
+ /**
+ * 鏂板鏈哄瀷搴忓彿
+ */
+ @PreAuthorize("@ss.hasPermi('bs:modelNumber:add')")
+ @Log(title = "鏈哄瀷搴忓彿", businessType = BusinessType.INSERT)
+ @PostMapping
+ public AjaxResult add(@RequestBody BsModelNumber bsModelNumber)
+ {
+ return toAjax(bsModelNumberService.insertBsModelNumber(bsModelNumber));
+ }
+
+ /**
+ * 淇敼鏈哄瀷搴忓彿
+ */
+ @PreAuthorize("@ss.hasPermi('bs:modelNumber:edit')")
+ @Log(title = "鏈哄瀷搴忓彿", businessType = BusinessType.UPDATE)
+ @PutMapping
+ public AjaxResult edit(@RequestBody BsModelNumber bsModelNumber)
+ {
+ return toAjax(bsModelNumberService.updateBsModelNumber(bsModelNumber));
+ }
+
+ /**
+ * 鍒犻櫎鏈哄瀷搴忓彿
+ */
+ @PreAuthorize("@ss.hasPermi('bs:modelNumber:remove')")
+ @Log(title = "鏈哄瀷搴忓彿", businessType = BusinessType.DELETE)
+ @DeleteMapping("/{ids}")
+ public AjaxResult remove(@PathVariable Long[] ids)
+ {
+ return toAjax(bsModelNumberService.deleteBsModelNumberByIds(ids));
+ }
+}
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/domain/BsModelNumber.java b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/domain/BsModelNumber.java
new file mode 100644
index 0000000..e1ce965
--- /dev/null
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/domain/BsModelNumber.java
@@ -0,0 +1,221 @@
+package com.jcdm.main.bs.modelNumber.domain;
+
+import org.apache.commons.lang3.builder.ToStringBuilder;
+import org.apache.commons.lang3.builder.ToStringStyle;
+import com.jcdm.common.annotation.Excel;
+import com.jcdm.common.core.domain.BaseEntity;
+
+/**
+ * 鏈哄瀷搴忓彿瀵硅薄 bs_model_number
+ *
+ * @author jiang
+ * @date 2024-01-15
+ */
+public class BsModelNumber extends BaseEntity
+{
+ private static final long serialVersionUID = 1L;
+
+ /** ID */
+ private Long id;
+
+ /** 鏈哄瀷 */
+ @Excel(name = "鏈哄瀷")
+ private String model;
+
+ /** 鏃ユ湡 */
+ @Excel(name = "鏃ユ湡")
+ private String modelDate;
+
+ /** 鏈�澶у�� */
+ @Excel(name = "鏈�澶у��")
+ private String maxnumValue;
+
+ /** 淇濆瓨鏃堕棿 */
+ @Excel(name = "淇濆瓨鏃堕棿")
+ private String saveTime;
+
+ /** 涓婃鐨勭紪鍙� */
+ @Excel(name = "涓婃鐨勭紪鍙�")
+ private String lastNumber;
+
+ /** 鐘舵�� */
+ @Excel(name = "鐘舵��")
+ private String status;
+
+ /** 棰勭暀瀛楁1 */
+ @Excel(name = "棰勭暀瀛楁1")
+ private String spareField1;
+
+ /** 棰勭暀瀛楁2 */
+ @Excel(name = "棰勭暀瀛楁2")
+ private String spareField2;
+
+ /** 棰勭暀瀛楁3 */
+ @Excel(name = "棰勭暀瀛楁3")
+ private String spareField3;
+
+ /** 棰勭暀瀛楁4 */
+ @Excel(name = "棰勭暀瀛楁4")
+ private String spareField4;
+
+ /** 鍒涘缓鐢ㄦ埛 */
+ @Excel(name = "鍒涘缓鐢ㄦ埛")
+ private String createUser;
+
+ /** 鏇存敼鐢ㄦ埛 */
+ @Excel(name = "鏇存敼鐢ㄦ埛")
+ private String updateUser;
+
+ /** 澶囨敞 */
+ @Excel(name = "澶囨敞")
+ private String remarks;
+
+ public void setId(Long id)
+ {
+ this.id = id;
+ }
+
+ public Long getId()
+ {
+ return id;
+ }
+ public void setModel(String model)
+ {
+ this.model = model;
+ }
+
+ public String getModel()
+ {
+ return model;
+ }
+ public void setModelDate(String modelDate)
+ {
+ this.modelDate = modelDate;
+ }
+
+ public String getModelDate()
+ {
+ return modelDate;
+ }
+ public void setMaxnumValue(String maxnumValue)
+ {
+ this.maxnumValue = maxnumValue;
+ }
+
+ public String getMaxnumValue()
+ {
+ return maxnumValue;
+ }
+ public void setSaveTime(String saveTime)
+ {
+ this.saveTime = saveTime;
+ }
+
+ public String getSaveTime()
+ {
+ return saveTime;
+ }
+ public void setLastNumber(String lastNumber)
+ {
+ this.lastNumber = lastNumber;
+ }
+
+ public String getLastNumber()
+ {
+ return lastNumber;
+ }
+ public void setStatus(String status)
+ {
+ this.status = status;
+ }
+
+ public String getStatus()
+ {
+ return status;
+ }
+ public void setSpareField1(String spareField1)
+ {
+ this.spareField1 = spareField1;
+ }
+
+ public String getSpareField1()
+ {
+ return spareField1;
+ }
+ public void setSpareField2(String spareField2)
+ {
+ this.spareField2 = spareField2;
+ }
+
+ public String getSpareField2()
+ {
+ return spareField2;
+ }
+ public void setSpareField3(String spareField3)
+ {
+ this.spareField3 = spareField3;
+ }
+
+ public String getSpareField3()
+ {
+ return spareField3;
+ }
+ public void setSpareField4(String spareField4)
+ {
+ this.spareField4 = spareField4;
+ }
+
+ public String getSpareField4()
+ {
+ return spareField4;
+ }
+ public void setCreateUser(String createUser)
+ {
+ this.createUser = createUser;
+ }
+
+ public String getCreateUser()
+ {
+ return createUser;
+ }
+ public void setUpdateUser(String updateUser)
+ {
+ this.updateUser = updateUser;
+ }
+
+ public String getUpdateUser()
+ {
+ return updateUser;
+ }
+ public void setRemarks(String remarks)
+ {
+ this.remarks = remarks;
+ }
+
+ public String getRemarks()
+ {
+ return remarks;
+ }
+
+ @Override
+ public String toString() {
+ return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
+ .append("id", getId())
+ .append("model", getModel())
+ .append("modelDate", getModelDate())
+ .append("maxnumValue", getMaxnumValue())
+ .append("saveTime", getSaveTime())
+ .append("lastNumber", getLastNumber())
+ .append("status", getStatus())
+ .append("spareField1", getSpareField1())
+ .append("spareField2", getSpareField2())
+ .append("spareField3", getSpareField3())
+ .append("spareField4", getSpareField4())
+ .append("createUser", getCreateUser())
+ .append("createTime", getCreateTime())
+ .append("updateUser", getUpdateUser())
+ .append("updateTime", getUpdateTime())
+ .append("remarks", getRemarks())
+ .toString();
+ }
+}
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/mapper/BsModelNumberMapper.java b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/mapper/BsModelNumberMapper.java
new file mode 100644
index 0000000..102d748
--- /dev/null
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/mapper/BsModelNumberMapper.java
@@ -0,0 +1,61 @@
+package com.jcdm.main.bs.modelNumber.mapper;
+
+import java.util.List;
+import com.jcdm.main.bs.modelNumber.domain.BsModelNumber;
+
+/**
+ * 鏈哄瀷搴忓彿Mapper鎺ュ彛
+ *
+ * @author jiang
+ * @date 2024-01-15
+ */
+public interface BsModelNumberMapper
+{
+ /**
+ * 鏌ヨ鏈哄瀷搴忓彿
+ *
+ * @param id 鏈哄瀷搴忓彿涓婚敭
+ * @return 鏈哄瀷搴忓彿
+ */
+ public BsModelNumber selectBsModelNumberById(Long id);
+
+ /**
+ * 鏌ヨ鏈哄瀷搴忓彿鍒楄〃
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 鏈哄瀷搴忓彿闆嗗悎
+ */
+ public List<BsModelNumber> selectBsModelNumberList(BsModelNumber bsModelNumber);
+
+ /**
+ * 鏂板鏈哄瀷搴忓彿
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 缁撴灉
+ */
+ public int insertBsModelNumber(BsModelNumber bsModelNumber);
+
+ /**
+ * 淇敼鏈哄瀷搴忓彿
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 缁撴灉
+ */
+ public int updateBsModelNumber(BsModelNumber bsModelNumber);
+
+ /**
+ * 鍒犻櫎鏈哄瀷搴忓彿
+ *
+ * @param id 鏈哄瀷搴忓彿涓婚敭
+ * @return 缁撴灉
+ */
+ public int deleteBsModelNumberById(Long id);
+
+ /**
+ * 鎵归噺鍒犻櫎鏈哄瀷搴忓彿
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deleteBsModelNumberByIds(Long[] ids);
+}
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/service/IBsModelNumberService.java b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/service/IBsModelNumberService.java
new file mode 100644
index 0000000..0083572
--- /dev/null
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/service/IBsModelNumberService.java
@@ -0,0 +1,61 @@
+package com.jcdm.main.bs.modelNumber.service;
+
+import java.util.List;
+import com.jcdm.main.bs.modelNumber.domain.BsModelNumber;
+
+/**
+ * 鏈哄瀷搴忓彿Service鎺ュ彛
+ *
+ * @author jiang
+ * @date 2024-01-15
+ */
+public interface IBsModelNumberService
+{
+ /**
+ * 鏌ヨ鏈哄瀷搴忓彿
+ *
+ * @param id 鏈哄瀷搴忓彿涓婚敭
+ * @return 鏈哄瀷搴忓彿
+ */
+ public BsModelNumber selectBsModelNumberById(Long id);
+
+ /**
+ * 鏌ヨ鏈哄瀷搴忓彿鍒楄〃
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 鏈哄瀷搴忓彿闆嗗悎
+ */
+ public List<BsModelNumber> selectBsModelNumberList(BsModelNumber bsModelNumber);
+
+ /**
+ * 鏂板鏈哄瀷搴忓彿
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 缁撴灉
+ */
+ public int insertBsModelNumber(BsModelNumber bsModelNumber);
+
+ /**
+ * 淇敼鏈哄瀷搴忓彿
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 缁撴灉
+ */
+ public int updateBsModelNumber(BsModelNumber bsModelNumber);
+
+ /**
+ * 鎵归噺鍒犻櫎鏈哄瀷搴忓彿
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鏈哄瀷搴忓彿涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deleteBsModelNumberByIds(Long[] ids);
+
+ /**
+ * 鍒犻櫎鏈哄瀷搴忓彿淇℃伅
+ *
+ * @param id 鏈哄瀷搴忓彿涓婚敭
+ * @return 缁撴灉
+ */
+ public int deleteBsModelNumberById(Long id);
+}
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/service/impl/BsModelNumberServiceImpl.java b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/service/impl/BsModelNumberServiceImpl.java
new file mode 100644
index 0000000..7bc7022
--- /dev/null
+++ b/jcdm-main/src/main/java/com/jcdm/main/bs/modelNumber/service/impl/BsModelNumberServiceImpl.java
@@ -0,0 +1,96 @@
+package com.jcdm.main.bs.modelNumber.service.impl;
+
+import java.util.List;
+import com.jcdm.common.utils.DateUtils;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import com.jcdm.main.bs.modelNumber.mapper.BsModelNumberMapper;
+import com.jcdm.main.bs.modelNumber.domain.BsModelNumber;
+import com.jcdm.main.bs.modelNumber.service.IBsModelNumberService;
+
+/**
+ * 鏈哄瀷搴忓彿Service涓氬姟灞傚鐞�
+ *
+ * @author jiang
+ * @date 2024-01-15
+ */
+@Service
+public class BsModelNumberServiceImpl implements IBsModelNumberService
+{
+ @Autowired
+ private BsModelNumberMapper bsModelNumberMapper;
+
+ /**
+ * 鏌ヨ鏈哄瀷搴忓彿
+ *
+ * @param id 鏈哄瀷搴忓彿涓婚敭
+ * @return 鏈哄瀷搴忓彿
+ */
+ @Override
+ public BsModelNumber selectBsModelNumberById(Long id)
+ {
+ return bsModelNumberMapper.selectBsModelNumberById(id);
+ }
+
+ /**
+ * 鏌ヨ鏈哄瀷搴忓彿鍒楄〃
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 鏈哄瀷搴忓彿
+ */
+ @Override
+ public List<BsModelNumber> selectBsModelNumberList(BsModelNumber bsModelNumber)
+ {
+ return bsModelNumberMapper.selectBsModelNumberList(bsModelNumber);
+ }
+
+ /**
+ * 鏂板鏈哄瀷搴忓彿
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 缁撴灉
+ */
+ @Override
+ public int insertBsModelNumber(BsModelNumber bsModelNumber)
+ {
+ bsModelNumber.setCreateTime(DateUtils.getNowDate());
+ return bsModelNumberMapper.insertBsModelNumber(bsModelNumber);
+ }
+
+ /**
+ * 淇敼鏈哄瀷搴忓彿
+ *
+ * @param bsModelNumber 鏈哄瀷搴忓彿
+ * @return 缁撴灉
+ */
+ @Override
+ public int updateBsModelNumber(BsModelNumber bsModelNumber)
+ {
+ bsModelNumber.setUpdateTime(DateUtils.getNowDate());
+ return bsModelNumberMapper.updateBsModelNumber(bsModelNumber);
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎鏈哄瀷搴忓彿
+ *
+ * @param ids 闇�瑕佸垹闄ょ殑鏈哄瀷搴忓彿涓婚敭
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteBsModelNumberByIds(Long[] ids)
+ {
+ return bsModelNumberMapper.deleteBsModelNumberByIds(ids);
+ }
+
+ /**
+ * 鍒犻櫎鏈哄瀷搴忓彿淇℃伅
+ *
+ * @param id 鏈哄瀷搴忓彿涓婚敭
+ * @return 缁撴灉
+ */
+ @Override
+ public int deleteBsModelNumberById(Long id)
+ {
+ return bsModelNumberMapper.deleteBsModelNumberById(id);
+ }
+}
diff --git a/jcdm-main/src/main/resources/mapper/bs/modelNumber/BsModelNumberMapper.xml b/jcdm-main/src/main/resources/mapper/bs/modelNumber/BsModelNumberMapper.xml
new file mode 100644
index 0000000..3a6e219
--- /dev/null
+++ b/jcdm-main/src/main/resources/mapper/bs/modelNumber/BsModelNumberMapper.xml
@@ -0,0 +1,124 @@
+<?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.jcdm.main.bs.modelNumber.mapper.BsModelNumberMapper">
+
+ <resultMap type="BsModelNumber" id="BsModelNumberResult">
+ <result property="id" column="id" />
+ <result property="model" column="model" />
+ <result property="modelDate" column="model_date" />
+ <result property="maxnumValue" column="maxnum_value" />
+ <result property="saveTime" column="save_time" />
+ <result property="lastNumber" column="last_number" />
+ <result property="status" column="status" />
+ <result property="spareField1" column="spare_field_1" />
+ <result property="spareField2" column="spare_field_2" />
+ <result property="spareField3" column="spare_field_3" />
+ <result property="spareField4" column="spare_field_4" />
+ <result property="createUser" column="create_user" />
+ <result property="createTime" column="create_time" />
+ <result property="updateUser" column="update_user" />
+ <result property="updateTime" column="update_time" />
+ <result property="remarks" column="remarks" />
+ </resultMap>
+
+ <sql id="selectBsModelNumberVo">
+ select id, model, model_date, maxnum_value, save_time, last_number, status, spare_field_1, spare_field_2, spare_field_3, spare_field_4, create_user, create_time, update_user, update_time, remarks from bs_model_number
+ </sql>
+
+ <select id="selectBsModelNumberList" parameterType="BsModelNumber" resultMap="BsModelNumberResult">
+ <include refid="selectBsModelNumberVo"/>
+ <where>
+ <if test="model != null and model != ''"> and model = #{model}</if>
+ <if test="modelDate != null and modelDate != ''"> and model_date = #{modelDate}</if>
+ <if test="maxnumValue != null and maxnumValue != ''"> and maxnum_value = #{maxnumValue}</if>
+ <if test="saveTime != null and saveTime != ''"> and save_time = #{saveTime}</if>
+ <if test="lastNumber != null and lastNumber != ''"> and last_number = #{lastNumber}</if>
+ <if test="status != null and status != ''"> and status = #{status}</if>
+ <if test="spareField1 != null and spareField1 != ''"> and spare_field_1 = #{spareField1}</if>
+ <if test="spareField2 != null and spareField2 != ''"> and spare_field_2 = #{spareField2}</if>
+ <if test="spareField3 != null and spareField3 != ''"> and spare_field_3 = #{spareField3}</if>
+ <if test="spareField4 != null and spareField4 != ''"> and spare_field_4 = #{spareField4}</if>
+ <if test="createUser != null and createUser != ''"> and create_user = #{createUser}</if>
+ <if test="updateUser != null and updateUser != ''"> and update_user = #{updateUser}</if>
+ <if test="remarks != null and remarks != ''"> and remarks = #{remarks}</if>
+ </where>
+ </select>
+
+ <select id="selectBsModelNumberById" parameterType="Long" resultMap="BsModelNumberResult">
+ <include refid="selectBsModelNumberVo"/>
+ where id = #{id}
+ </select>
+
+ <insert id="insertBsModelNumber" parameterType="BsModelNumber" useGeneratedKeys="true" keyProperty="id">
+ insert into bs_model_number
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="model != null">model,</if>
+ <if test="modelDate != null">model_date,</if>
+ <if test="maxnumValue != null">maxnum_value,</if>
+ <if test="saveTime != null">save_time,</if>
+ <if test="lastNumber != null">last_number,</if>
+ <if test="status != null">status,</if>
+ <if test="spareField1 != null">spare_field_1,</if>
+ <if test="spareField2 != null">spare_field_2,</if>
+ <if test="spareField3 != null">spare_field_3,</if>
+ <if test="spareField4 != null">spare_field_4,</if>
+ <if test="createUser != null">create_user,</if>
+ <if test="createTime != null">create_time,</if>
+ <if test="updateUser != null">update_user,</if>
+ <if test="updateTime != null">update_time,</if>
+ <if test="remarks != null">remarks,</if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="model != null">#{model},</if>
+ <if test="modelDate != null">#{modelDate},</if>
+ <if test="maxnumValue != null">#{maxnumValue},</if>
+ <if test="saveTime != null">#{saveTime},</if>
+ <if test="lastNumber != null">#{lastNumber},</if>
+ <if test="status != null">#{status},</if>
+ <if test="spareField1 != null">#{spareField1},</if>
+ <if test="spareField2 != null">#{spareField2},</if>
+ <if test="spareField3 != null">#{spareField3},</if>
+ <if test="spareField4 != null">#{spareField4},</if>
+ <if test="createUser != null">#{createUser},</if>
+ <if test="createTime != null">#{createTime},</if>
+ <if test="updateUser != null">#{updateUser},</if>
+ <if test="updateTime != null">#{updateTime},</if>
+ <if test="remarks != null">#{remarks},</if>
+ </trim>
+ </insert>
+
+ <update id="updateBsModelNumber" parameterType="BsModelNumber">
+ update bs_model_number
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="model != null">model = #{model},</if>
+ <if test="modelDate != null">model_date = #{modelDate},</if>
+ <if test="maxnumValue != null">maxnum_value = #{maxnumValue},</if>
+ <if test="saveTime != null">save_time = #{saveTime},</if>
+ <if test="lastNumber != null">last_number = #{lastNumber},</if>
+ <if test="status != null">status = #{status},</if>
+ <if test="spareField1 != null">spare_field_1 = #{spareField1},</if>
+ <if test="spareField2 != null">spare_field_2 = #{spareField2},</if>
+ <if test="spareField3 != null">spare_field_3 = #{spareField3},</if>
+ <if test="spareField4 != null">spare_field_4 = #{spareField4},</if>
+ <if test="createUser != null">create_user = #{createUser},</if>
+ <if test="createTime != null">create_time = #{createTime},</if>
+ <if test="updateUser != null">update_user = #{updateUser},</if>
+ <if test="updateTime != null">update_time = #{updateTime},</if>
+ <if test="remarks != null">remarks = #{remarks},</if>
+ </trim>
+ where id = #{id}
+ </update>
+
+ <delete id="deleteBsModelNumberById" parameterType="Long">
+ delete from bs_model_number where id = #{id}
+ </delete>
+
+ <delete id="deleteBsModelNumberByIds" parameterType="String">
+ delete from bs_model_number where id in
+ <foreach item="id" collection="array" open="(" separator="," close=")">
+ #{id}
+ </foreach>
+ </delete>
+</mapper>
\ No newline at end of file
diff --git a/jcdm-ui/src/api/main/bs/modelNumber/modelNumber.js b/jcdm-ui/src/api/main/bs/modelNumber/modelNumber.js
new file mode 100644
index 0000000..528eab0
--- /dev/null
+++ b/jcdm-ui/src/api/main/bs/modelNumber/modelNumber.js
@@ -0,0 +1,44 @@
+import request from '@/utils/request'
+
+// 鏌ヨ鏈哄瀷搴忓彿鍒楄〃
+export function listModelNumber(query) {
+ return request({
+ url: '/bs/modelNumber/list',
+ method: 'get',
+ params: query
+ })
+}
+
+// 鏌ヨ鏈哄瀷搴忓彿璇︾粏
+export function getModelNumber(id) {
+ return request({
+ url: '/bs/modelNumber/' + id,
+ method: 'get'
+ })
+}
+
+// 鏂板鏈哄瀷搴忓彿
+export function addModelNumber(data) {
+ return request({
+ url: '/bs/modelNumber',
+ method: 'post',
+ data: data
+ })
+}
+
+// 淇敼鏈哄瀷搴忓彿
+export function updateModelNumber(data) {
+ return request({
+ url: '/bs/modelNumber',
+ method: 'put',
+ data: data
+ })
+}
+
+// 鍒犻櫎鏈哄瀷搴忓彿
+export function delModelNumber(id) {
+ return request({
+ url: '/bs/modelNumber/' + id,
+ method: 'delete'
+ })
+}
diff --git a/jcdm-ui/src/views/main/bs/modelNumber/index.vue b/jcdm-ui/src/views/main/bs/modelNumber/index.vue
new file mode 100644
index 0000000..03a57ce
--- /dev/null
+++ b/jcdm-ui/src/views/main/bs/modelNumber/index.vue
@@ -0,0 +1,445 @@
+<template>
+ <div class="app-container">
+ <el-card class="box-card">
+ <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
+ <el-form-item label="鏈哄瀷" prop="model">
+ <el-input
+ v-model="queryParams.model"
+ placeholder="璇疯緭鍏ユ満鍨�"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="鏃ユ湡" prop="modelDate">
+ <el-input
+ v-model="queryParams.modelDate"
+ placeholder="璇疯緭鍏ユ棩鏈�"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="鏈�澶у��" prop="maxnumValue">
+ <el-input
+ v-model="queryParams.maxnumValue"
+ placeholder="璇疯緭鍏ユ渶澶у��"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="涓婃鐨勭紪鍙�" prop="lastNumber">
+ <el-input
+ v-model="queryParams.lastNumber"
+ placeholder="璇疯緭鍏ヤ笂娆＄殑缂栧彿"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="鐘舵��" prop="status">
+ <el-select v-model="queryParams.status" placeholder="璇烽�夋嫨鐘舵��" clearable>
+
+ </el-select>
+ </el-form-item>
+ <el-form-item label="棰勭暀瀛楁1" prop="spareField1">
+ <el-input
+ v-model="queryParams.spareField1"
+ placeholder="璇疯緭鍏ラ鐣欏瓧娈�1"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="棰勭暀瀛楁2" prop="spareField2">
+ <el-input
+ v-model="queryParams.spareField2"
+ placeholder="璇疯緭鍏ラ鐣欏瓧娈�2"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="棰勭暀瀛楁3" prop="spareField3">
+ <el-input
+ v-model="queryParams.spareField3"
+ placeholder="璇疯緭鍏ラ鐣欏瓧娈�3"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="棰勭暀瀛楁4" prop="spareField4">
+ <el-input
+ v-model="queryParams.spareField4"
+ placeholder="璇疯緭鍏ラ鐣欏瓧娈�4"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="鍒涘缓鐢ㄦ埛" prop="createUser">
+ <el-input
+ v-model="queryParams.createUser"
+ placeholder="璇疯緭鍏ュ垱寤虹敤鎴�"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="鏇存敼鐢ㄦ埛" prop="updateUser">
+ <el-input
+ v-model="queryParams.updateUser"
+ placeholder="璇疯緭鍏ユ洿鏀圭敤鎴�"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item label="澶囨敞" prop="remarks">
+ <el-input
+ v-model="queryParams.remarks"
+ placeholder="璇疯緭鍏ュ娉�"
+ clearable
+ @keyup.enter.native="handleQuery"
+ />
+ </el-form-item>
+ <el-form-item style="float: right">
+ <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">鎼滅储</el-button>
+ <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">閲嶇疆</el-button>
+ </el-form-item>
+ </el-form>
+ </el-card>
+
+ <el-card style="margin-top: 10px" class="box-card">
+ <el-row :gutter="10" class="mb8">
+ <el-col :span="1.5">
+ <el-button
+ type="primary"
+ plain
+ icon="el-icon-plus"
+ size="mini"
+ @click="handleAdd"
+ v-hasPermi="['bs:modelNumber:add']"
+ >鏂板</el-button>
+ </el-col>
+ <el-col :span="1.5">
+ <el-button
+ type="success"
+ plain
+ icon="el-icon-edit"
+ size="mini"
+ :disabled="single"
+ @click="handleUpdate"
+ v-hasPermi="['bs:modelNumber:edit']"
+ >淇敼</el-button>
+ </el-col>
+ <el-col :span="1.5">
+ <el-button
+ type="danger"
+ plain
+ icon="el-icon-delete"
+ size="mini"
+ :disabled="multiple"
+ @click="handleDelete"
+ v-hasPermi="['bs:modelNumber:remove']"
+ >鍒犻櫎</el-button>
+ </el-col>
+ <el-col :span="1.5">
+ <el-button
+ type="warning"
+ plain
+ icon="el-icon-download"
+ size="mini"
+ @click="handleExport"
+ v-hasPermi="['bs:modelNumber:export']"
+ >瀵煎嚭</el-button>
+ </el-col>
+ <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
+ </el-row>
+
+ <el-table border v-loading="loading" :data="modelNumberList" @selection-change="handleSelectionChange">
+ <el-table-column type="selection" width="55" align="center" />
+ <el-table-column label="ID" align="center" prop="id" />
+ <el-table-column label="鏈哄瀷" align="center" prop="model">
+
+ </el-table-column>
+ <el-table-column label="鏃ユ湡" align="center" prop="modelDate">
+
+ </el-table-column>
+ <el-table-column label="鏈�澶у��" align="center" prop="maxnumValue">
+
+ </el-table-column>
+ <el-table-column label="淇濆瓨鏃堕棿" align="center" prop="saveTime">
+
+ </el-table-column>
+ <el-table-column label="涓婃鐨勭紪鍙�" align="center" prop="lastNumber">
+
+ </el-table-column>
+ <el-table-column label="鐘舵��" align="center" prop="status">
+
+ </el-table-column>
+ <el-table-column label="棰勭暀瀛楁1" align="center" prop="spareField1">
+
+ </el-table-column>
+ <el-table-column label="棰勭暀瀛楁2" align="center" prop="spareField2">
+
+ </el-table-column>
+ <el-table-column label="棰勭暀瀛楁3" align="center" prop="spareField3">
+
+ </el-table-column>
+ <el-table-column label="棰勭暀瀛楁4" align="center" prop="spareField4">
+
+ </el-table-column>
+ <el-table-column label="鍒涘缓鐢ㄦ埛" align="center" prop="createUser">
+
+ </el-table-column>
+ <el-table-column label="鏇存敼鐢ㄦ埛" align="center" prop="updateUser">
+
+ </el-table-column>
+ <el-table-column label="澶囨敞" align="center" prop="remarks">
+
+ </el-table-column>
+ <el-table-column fixed="right" width="200" label="鎿嶄綔" align="center" class-name="small-padding fixed-width">
+ <template slot-scope="scope">
+ <el-button
+ size="mini"
+ type="success"
+ plain
+ style="width: 72px"
+ icon="el-icon-edit"
+ @click="handleUpdate(scope.row)"
+ v-hasPermi="['bs:modelNumber:edit']"
+ >淇敼</el-button>
+ <el-button
+ size="mini"
+ type="danger"
+ plain
+ style="width: 72px"
+ icon="el-icon-delete"
+ @click="handleDelete(scope.row)"
+ v-hasPermi="['bs:modelNumber:remove']"
+ >鍒犻櫎</el-button>
+ </template>
+ </el-table-column>
+ </el-table>
+ </el-card>
+
+ <pagination
+ v-show="total>0"
+ :total="total"
+ :page.sync="queryParams.pageNum"
+ :limit.sync="queryParams.pageSize"
+ @pagination="getList"
+ />
+
+ <!-- 娣诲姞鎴栦慨鏀规満鍨嬪簭鍙峰璇濇 -->
+ <el-dialog v-dialogpop-up :title="title" :visible.sync="open" width="500px" append-to-body>
+ <span slot="title">
+ <i class="el-icon-s-order"></i>
+ {{titleName}}
+ </span>
+ <el-form ref="form" :model="form" :rules="rules" label-width="80px">
+ <el-form-item label="鏈哄瀷" prop="model">
+ <el-input v-model="form.model" placeholder="璇疯緭鍏ユ満鍨�" />
+ </el-form-item>
+ <el-form-item label="鏃ユ湡" prop="modelDate">
+ <el-input v-model="form.modelDate" placeholder="璇疯緭鍏ユ棩鏈�" />
+ </el-form-item>
+ <el-form-item label="鏈�澶у��" prop="maxnumValue">
+ <el-input v-model="form.maxnumValue" placeholder="璇疯緭鍏ユ渶澶у��" />
+ </el-form-item>
+ <el-form-item label="涓婃鐨勭紪鍙�" prop="lastNumber">
+ <el-input v-model="form.lastNumber" placeholder="璇疯緭鍏ヤ笂娆＄殑缂栧彿" />
+ </el-form-item>
+ <el-form-item label="鐘舵��" prop="status">
+ <el-radio-group v-model="form.status">
+
+ </el-radio-group>
+ </el-form-item>
+ <el-form-item label="棰勭暀瀛楁1" prop="spareField1">
+ <el-input v-model="form.spareField1" placeholder="璇疯緭鍏ラ鐣欏瓧娈�1" />
+ </el-form-item>
+ <el-form-item label="棰勭暀瀛楁2" prop="spareField2">
+ <el-input v-model="form.spareField2" placeholder="璇疯緭鍏ラ鐣欏瓧娈�2" />
+ </el-form-item>
+ <el-form-item label="棰勭暀瀛楁3" prop="spareField3">
+ <el-input v-model="form.spareField3" placeholder="璇疯緭鍏ラ鐣欏瓧娈�3" />
+ </el-form-item>
+ <el-form-item label="棰勭暀瀛楁4" prop="spareField4">
+ <el-input v-model="form.spareField4" placeholder="璇疯緭鍏ラ鐣欏瓧娈�4" />
+ </el-form-item>
+ <el-form-item label="鍒涘缓鐢ㄦ埛" prop="createUser">
+ <el-input v-model="form.createUser" placeholder="璇疯緭鍏ュ垱寤虹敤鎴�" />
+ </el-form-item>
+ <el-form-item label="鏇存敼鐢ㄦ埛" prop="updateUser">
+ <el-input v-model="form.updateUser" placeholder="璇疯緭鍏ユ洿鏀圭敤鎴�" />
+ </el-form-item>
+ <el-form-item label="澶囨敞" prop="remarks">
+ <el-input v-model="form.remarks" placeholder="璇疯緭鍏ュ娉�" />
+ </el-form-item>
+ </el-form>
+ <div slot="footer" class="dialog-footer">
+ <el-button type="primary" @click="submitForm">纭� 瀹�</el-button>
+ <el-button @click="cancel">鍙� 娑�</el-button>
+ </div>
+ </el-dialog>
+ </div>
+</template>
+
+<script>
+import { listModelNumber, getModelNumber, delModelNumber, addModelNumber, updateModelNumber } from "@/api/main/bs/modelNumber/modelNumber";
+
+export default {
+ name: "ModelNumber",
+ data() {
+ return {
+ // 閬僵灞�
+ loading: true,
+ titleName: "",
+ // 閫変腑鏁扮粍
+ ids: [],
+ // 闈炲崟涓鐢�
+ single: true,
+ // 闈炲涓鐢�
+ multiple: true,
+ // 鏄剧ず鎼滅储鏉′欢
+ showSearch: true,
+ // 鎬绘潯鏁�
+ total: 0,
+ // 鏈哄瀷搴忓彿琛ㄦ牸鏁版嵁
+ modelNumberList: [],
+ // 寮瑰嚭灞傛爣棰�
+ title: "",
+ // 鏄惁鏄剧ず寮瑰嚭灞�
+ open: false,
+ // 鏌ヨ鍙傛暟
+ queryParams: {
+ pageNum: 1,
+ pageSize: 10,
+ model: null,
+ modelDate: null,
+ maxnumValue: null,
+ saveTime: null,
+ lastNumber: null,
+ status: null,
+ spareField1: null,
+ spareField2: null,
+ spareField3: null,
+ spareField4: null,
+ createUser: null,
+ updateUser: null,
+ remarks: null
+ },
+ // 琛ㄥ崟鍙傛暟
+ form: {},
+ // 琛ㄥ崟鏍￠獙
+ rules: {
+ id: [
+ { required: true, message: "ID涓嶈兘涓虹┖", trigger: "blur" }
+ ],
+ }
+ };
+ },
+ created() {
+ this.getList();
+ },
+ methods: {
+ /** 鏌ヨ鏈哄瀷搴忓彿鍒楄〃 */
+ getList() {
+ this.loading = true;
+ listModelNumber(this.queryParams).then(response => {
+ this.modelNumberList = response.rows;
+ this.total = response.total;
+ this.loading = false;
+ });
+ },
+ // 鍙栨秷鎸夐挳
+ cancel() {
+ this.open = false;
+ this.reset();
+ },
+ // 琛ㄥ崟閲嶇疆
+ reset() {
+ this.form = {
+ id: null,
+ model: null,
+ modelDate: null,
+ maxnumValue: null,
+ saveTime: null,
+ lastNumber: null,
+ status: null,
+ spareField1: null,
+ spareField2: null,
+ spareField3: null,
+ spareField4: null,
+ createUser: null,
+ createTime: null,
+ updateUser: null,
+ updateTime: null,
+ remarks: null
+ };
+ this.resetForm("form");
+ },
+ /** 鎼滅储鎸夐挳鎿嶄綔 */
+ handleQuery() {
+ this.queryParams.pageNum = 1;
+ this.getList();
+ },
+ /** 閲嶇疆鎸夐挳鎿嶄綔 */
+ resetQuery() {
+ this.resetForm("queryForm");
+ this.handleQuery();
+ },
+ // 澶氶�夋閫変腑鏁版嵁
+ handleSelectionChange(selection) {
+ this.ids = selection.map(item => item.id)
+ this.single = selection.length!==1
+ this.multiple = !selection.length
+ },
+ /** 鏂板鎸夐挳鎿嶄綔 */
+ handleAdd() {
+ this.reset();
+ this.open = true;
+ this.titleName = "娣诲姞鏈哄瀷搴忓彿";
+ },
+ /** 淇敼鎸夐挳鎿嶄綔 */
+ handleUpdate(row) {
+ this.reset();
+ const id = row.id || this.ids
+ getModelNumber(id).then(response => {
+ this.form = response.data;
+ this.open = true;
+ this.titleName = "淇敼鏈哄瀷搴忓彿";
+ });
+ },
+ /** 鎻愪氦鎸夐挳 */
+ submitForm() {
+ this.$refs["form"].validate(valid => {
+ if (valid) {
+ if (this.form.id != null) {
+ updateModelNumber(this.form).then(response => {
+ this.$modal.msgSuccess("淇敼鎴愬姛");
+ this.open = false;
+ this.getList();
+ });
+ } else {
+ addModelNumber(this.form).then(response => {
+ this.$modal.msgSuccess("鏂板鎴愬姛");
+ this.open = false;
+ this.getList();
+ });
+ }
+ }
+ });
+ },
+ /** 鍒犻櫎鎸夐挳鎿嶄綔 */
+ handleDelete(row) {
+ const ids = row.id || this.ids;
+ this.$modal.confirm('鏄惁纭鍒犻櫎鏈哄瀷搴忓彿缂栧彿涓�"' + ids + '"鐨勬暟鎹」锛�').then(function() {
+ return delModelNumber(ids);
+ }).then(() => {
+ this.getList();
+ this.$modal.msgSuccess("鍒犻櫎鎴愬姛");
+ }).catch(() => {});
+ },
+ /** 瀵煎嚭鎸夐挳鎿嶄綔 */
+ handleExport() {
+ this.download('bs/modelNumber/export', {
+ ...this.queryParams
+ }, `modelNumber_${new Date().getTime()}.xlsx`)
+ }
+ }
+};
+</script>
--
Gitblit v1.9.3