¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.jcdm.main.bs.processFile.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.processFile.domain.BsProcessFile; |
| | | import com.jcdm.main.bs.processFile.service.IBsProcessFileService; |
| | | import com.jcdm.common.utils.poi.ExcelUtil; |
| | | import com.jcdm.common.core.page.TableDataInfo; |
| | | |
| | | /** |
| | | * å·¥èºææ¡£Controller |
| | | * |
| | | * @author Yi |
| | | * @date 2024-01-03 |
| | | */ |
| | | @RestController |
| | | @RequestMapping("/bs/processFile") |
| | | public class BsProcessFileController extends BaseController |
| | | { |
| | | @Autowired |
| | | private IBsProcessFileService bsProcessFileService; |
| | | |
| | | /** |
| | | * æ¥è¯¢å·¥èºææ¡£å表 |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('bs:processFile:list')") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(BsProcessFile bsProcessFile) |
| | | { |
| | | startPage(); |
| | | List<BsProcessFile> list = bsProcessFileService.selectBsProcessFileList(bsProcessFile); |
| | | return getDataTable(list); |
| | | } |
| | | |
| | | /** |
| | | * 导åºå·¥èºææ¡£å表 |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('bs:processFile:export')") |
| | | @Log(title = "å·¥èºææ¡£", businessType = BusinessType.EXPORT) |
| | | @PostMapping("/export") |
| | | public void export(HttpServletResponse response, BsProcessFile bsProcessFile) |
| | | { |
| | | List<BsProcessFile> list = bsProcessFileService.selectBsProcessFileList(bsProcessFile); |
| | | ExcelUtil<BsProcessFile> util = new ExcelUtil<BsProcessFile>(BsProcessFile.class); |
| | | util.exportExcel(response, list, "å·¥èºææ¡£æ°æ®"); |
| | | } |
| | | |
| | | /** |
| | | * è·åå·¥èºæ档详ç»ä¿¡æ¯ |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('bs:processFile:query')") |
| | | @GetMapping(value = "/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") Long id) |
| | | { |
| | | return success(bsProcessFileService.selectBsProcessFileById(id)); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢å·¥èºææ¡£ |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('bs:processFile:add')") |
| | | @Log(title = "å·¥èºææ¡£", businessType = BusinessType.INSERT) |
| | | @PostMapping |
| | | public AjaxResult add(@RequestBody BsProcessFile bsProcessFile) |
| | | { |
| | | return toAjax(bsProcessFileService.insertBsProcessFile(bsProcessFile)); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹å·¥èºææ¡£ |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('bs:processFile:edit')") |
| | | @Log(title = "å·¥èºææ¡£", businessType = BusinessType.UPDATE) |
| | | @PutMapping |
| | | public AjaxResult edit(@RequestBody BsProcessFile bsProcessFile) |
| | | { |
| | | return toAjax(bsProcessFileService.updateBsProcessFile(bsProcessFile)); |
| | | } |
| | | |
| | | /** |
| | | * å é¤å·¥èºææ¡£ |
| | | */ |
| | | @PreAuthorize("@ss.hasPermi('bs:processFile:remove')") |
| | | @Log(title = "å·¥èºææ¡£", businessType = BusinessType.DELETE) |
| | | @DeleteMapping("/{ids}") |
| | | public AjaxResult remove(@PathVariable Long[] ids) |
| | | { |
| | | return toAjax(bsProcessFileService.deleteBsProcessFileByIds(ids)); |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.jcdm.main.bs.processFile.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_process_file |
| | | * |
| | | * @author Yi |
| | | * @date 2024-01-03 |
| | | */ |
| | | public class BsProcessFile extends BaseEntity |
| | | { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** id */ |
| | | private Long id; |
| | | |
| | | /** 产åç¼å· */ |
| | | @Excel(name = "产åç¼å·") |
| | | private String productCode; |
| | | |
| | | /** 产åå称 */ |
| | | @Excel(name = "产åå称") |
| | | private String productName; |
| | | |
| | | /** å·¥åºç¼å· */ |
| | | @Excel(name = "å·¥åºç¼å·") |
| | | private String processesCode; |
| | | |
| | | /** å·¥åºå称 */ |
| | | @Excel(name = "å·¥åºå称") |
| | | private String processesName; |
| | | |
| | | /** æ件ç¼å· */ |
| | | @Excel(name = "æ件ç¼å·") |
| | | private String fileCode; |
| | | |
| | | /** æ件å称 */ |
| | | @Excel(name = "æ件å称") |
| | | private String fileName; |
| | | |
| | | /** æ件å°å */ |
| | | @Excel(name = "æ件å°å") |
| | | private String fileAddress; |
| | | |
| | | /** ç¶æ */ |
| | | @Excel(name = "ç¶æ") |
| | | private String status; |
| | | |
| | | /** å建人 */ |
| | | @Excel(name = "å建人") |
| | | private String createUser; |
| | | |
| | | /** æ´æ°äºº */ |
| | | @Excel(name = "æ´æ°äºº") |
| | | private String updateUser; |
| | | |
| | | /** é¢çå段1 */ |
| | | private String spareField1; |
| | | |
| | | /** é¢çå段2 */ |
| | | private String spareField2; |
| | | |
| | | /** é¢çå段3 */ |
| | | private String spareField3; |
| | | |
| | | /** é¢çå段4 */ |
| | | private String spareField4; |
| | | |
| | | /** å¤æ³¨ */ |
| | | @Excel(name = "å¤æ³¨") |
| | | private String remarks; |
| | | |
| | | public void setId(Long id) |
| | | { |
| | | this.id = id; |
| | | } |
| | | |
| | | public Long getId() |
| | | { |
| | | return id; |
| | | } |
| | | public void setProductCode(String productCode) |
| | | { |
| | | this.productCode = productCode; |
| | | } |
| | | |
| | | public String getProductCode() |
| | | { |
| | | return productCode; |
| | | } |
| | | public void setProductName(String productName) |
| | | { |
| | | this.productName = productName; |
| | | } |
| | | |
| | | public String getProductName() |
| | | { |
| | | return productName; |
| | | } |
| | | public void setProcessesCode(String processesCode) |
| | | { |
| | | this.processesCode = processesCode; |
| | | } |
| | | |
| | | public String getProcessesCode() |
| | | { |
| | | return processesCode; |
| | | } |
| | | public void setProcessesName(String processesName) |
| | | { |
| | | this.processesName = processesName; |
| | | } |
| | | |
| | | public String getProcessesName() |
| | | { |
| | | return processesName; |
| | | } |
| | | public void setFileCode(String fileCode) |
| | | { |
| | | this.fileCode = fileCode; |
| | | } |
| | | |
| | | public String getFileCode() |
| | | { |
| | | return fileCode; |
| | | } |
| | | public void setFileName(String fileName) |
| | | { |
| | | this.fileName = fileName; |
| | | } |
| | | |
| | | public String getFileName() |
| | | { |
| | | return fileName; |
| | | } |
| | | public void setFileAddress(String fileAddress) |
| | | { |
| | | this.fileAddress = fileAddress; |
| | | } |
| | | |
| | | public String getFileAddress() |
| | | { |
| | | return fileAddress; |
| | | } |
| | | public void setStatus(String status) |
| | | { |
| | | this.status = status; |
| | | } |
| | | |
| | | public String getStatus() |
| | | { |
| | | return status; |
| | | } |
| | | 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 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 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("productCode", getProductCode()) |
| | | .append("productName", getProductName()) |
| | | .append("processesCode", getProcessesCode()) |
| | | .append("processesName", getProcessesName()) |
| | | .append("fileCode", getFileCode()) |
| | | .append("fileName", getFileName()) |
| | | .append("fileAddress", getFileAddress()) |
| | | .append("status", getStatus()) |
| | | .append("createUser", getCreateUser()) |
| | | .append("createTime", getCreateTime()) |
| | | .append("updateUser", getUpdateUser()) |
| | | .append("updateTime", getUpdateTime()) |
| | | .append("spareField1", getSpareField1()) |
| | | .append("spareField2", getSpareField2()) |
| | | .append("spareField3", getSpareField3()) |
| | | .append("spareField4", getSpareField4()) |
| | | .append("remarks", getRemarks()) |
| | | .toString(); |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.jcdm.main.bs.processFile.mapper; |
| | | |
| | | import java.util.List; |
| | | import com.jcdm.main.bs.processFile.domain.BsProcessFile; |
| | | |
| | | /** |
| | | * å·¥èºææ¡£Mapperæ¥å£ |
| | | * |
| | | * @author Yi |
| | | * @date 2024-01-03 |
| | | */ |
| | | public interface BsProcessFileMapper |
| | | { |
| | | /** |
| | | * æ¥è¯¢å·¥èºææ¡£ |
| | | * |
| | | * @param id å·¥èºææ¡£ä¸»é® |
| | | * @return å·¥èºææ¡£ |
| | | */ |
| | | public BsProcessFile selectBsProcessFileById(Long id); |
| | | |
| | | /** |
| | | * æ¥è¯¢å·¥èºææ¡£å表 |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return å·¥èºææ¡£éå |
| | | */ |
| | | public List<BsProcessFile> selectBsProcessFileList(BsProcessFile bsProcessFile); |
| | | |
| | | /** |
| | | * æ°å¢å·¥èºææ¡£ |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return ç»æ |
| | | */ |
| | | public int insertBsProcessFile(BsProcessFile bsProcessFile); |
| | | |
| | | /** |
| | | * ä¿®æ¹å·¥èºææ¡£ |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return ç»æ |
| | | */ |
| | | public int updateBsProcessFile(BsProcessFile bsProcessFile); |
| | | |
| | | /** |
| | | * å é¤å·¥èºææ¡£ |
| | | * |
| | | * @param id å·¥èºææ¡£ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteBsProcessFileById(Long id); |
| | | |
| | | /** |
| | | * æ¹éå é¤å·¥èºææ¡£ |
| | | * |
| | | * @param ids éè¦å é¤çæ°æ®ä¸»é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteBsProcessFileByIds(Long[] ids); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.jcdm.main.bs.processFile.service; |
| | | |
| | | import java.util.List; |
| | | import com.jcdm.main.bs.processFile.domain.BsProcessFile; |
| | | |
| | | /** |
| | | * å·¥èºææ¡£Serviceæ¥å£ |
| | | * |
| | | * @author Yi |
| | | * @date 2024-01-03 |
| | | */ |
| | | public interface IBsProcessFileService |
| | | { |
| | | /** |
| | | * æ¥è¯¢å·¥èºææ¡£ |
| | | * |
| | | * @param id å·¥èºææ¡£ä¸»é® |
| | | * @return å·¥èºææ¡£ |
| | | */ |
| | | public BsProcessFile selectBsProcessFileById(Long id); |
| | | |
| | | /** |
| | | * æ¥è¯¢å·¥èºææ¡£å表 |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return å·¥èºææ¡£éå |
| | | */ |
| | | public List<BsProcessFile> selectBsProcessFileList(BsProcessFile bsProcessFile); |
| | | |
| | | /** |
| | | * æ°å¢å·¥èºææ¡£ |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return ç»æ |
| | | */ |
| | | public int insertBsProcessFile(BsProcessFile bsProcessFile); |
| | | |
| | | /** |
| | | * ä¿®æ¹å·¥èºææ¡£ |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return ç»æ |
| | | */ |
| | | public int updateBsProcessFile(BsProcessFile bsProcessFile); |
| | | |
| | | /** |
| | | * æ¹éå é¤å·¥èºææ¡£ |
| | | * |
| | | * @param ids éè¦å é¤çå·¥èºæ档主é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteBsProcessFileByIds(Long[] ids); |
| | | |
| | | /** |
| | | * å é¤å·¥èºææ¡£ä¿¡æ¯ |
| | | * |
| | | * @param id å·¥èºææ¡£ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteBsProcessFileById(Long id); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.jcdm.main.bs.processFile.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.processFile.mapper.BsProcessFileMapper; |
| | | import com.jcdm.main.bs.processFile.domain.BsProcessFile; |
| | | import com.jcdm.main.bs.processFile.service.IBsProcessFileService; |
| | | |
| | | /** |
| | | * å·¥èºææ¡£Serviceä¸å¡å±å¤ç |
| | | * |
| | | * @author Yi |
| | | * @date 2024-01-03 |
| | | */ |
| | | @Service |
| | | public class BsProcessFileServiceImpl implements IBsProcessFileService |
| | | { |
| | | @Autowired |
| | | private BsProcessFileMapper bsProcessFileMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢å·¥èºææ¡£ |
| | | * |
| | | * @param id å·¥èºææ¡£ä¸»é® |
| | | * @return å·¥èºææ¡£ |
| | | */ |
| | | @Override |
| | | public BsProcessFile selectBsProcessFileById(Long id) |
| | | { |
| | | return bsProcessFileMapper.selectBsProcessFileById(id); |
| | | } |
| | | |
| | | /** |
| | | * æ¥è¯¢å·¥èºææ¡£å表 |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return å·¥èºææ¡£ |
| | | */ |
| | | @Override |
| | | public List<BsProcessFile> selectBsProcessFileList(BsProcessFile bsProcessFile) |
| | | { |
| | | return bsProcessFileMapper.selectBsProcessFileList(bsProcessFile); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢å·¥èºææ¡£ |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int insertBsProcessFile(BsProcessFile bsProcessFile) |
| | | { |
| | | bsProcessFile.setCreateTime(DateUtils.getNowDate()); |
| | | return bsProcessFileMapper.insertBsProcessFile(bsProcessFile); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹å·¥èºææ¡£ |
| | | * |
| | | * @param bsProcessFile å·¥èºææ¡£ |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int updateBsProcessFile(BsProcessFile bsProcessFile) |
| | | { |
| | | bsProcessFile.setUpdateTime(DateUtils.getNowDate()); |
| | | return bsProcessFileMapper.updateBsProcessFile(bsProcessFile); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤å·¥èºææ¡£ |
| | | * |
| | | * @param ids éè¦å é¤çå·¥èºææ¡£ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int deleteBsProcessFileByIds(Long[] ids) |
| | | { |
| | | return bsProcessFileMapper.deleteBsProcessFileByIds(ids); |
| | | } |
| | | |
| | | /** |
| | | * å é¤å·¥èºææ¡£ä¿¡æ¯ |
| | | * |
| | | * @param id å·¥èºææ¡£ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int deleteBsProcessFileById(Long id) |
| | | { |
| | | return bsProcessFileMapper.deleteBsProcessFileById(id); |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?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.processFile.mapper.BsProcessFileMapper"> |
| | | |
| | | <resultMap type="BsProcessFile" id="BsProcessFileResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="productCode" column="product_code" /> |
| | | <result property="productName" column="product_name" /> |
| | | <result property="processesCode" column="processes_code" /> |
| | | <result property="processesName" column="processes_name" /> |
| | | <result property="fileCode" column="file_code" /> |
| | | <result property="fileName" column="file_name" /> |
| | | <result property="fileAddress" column="file_address" /> |
| | | <result property="status" column="status" /> |
| | | <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="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="remarks" column="remarks" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectBsProcessFileVo"> |
| | | select id, product_code, product_name, processes_code, processes_name, file_code, file_name, file_address, status, create_user, create_time, update_user, update_time, spare_field_1, spare_field_2, spare_field_3, spare_field_4, remarks from bs_process_file |
| | | </sql> |
| | | |
| | | <select id="selectBsProcessFileList" parameterType="BsProcessFile" resultMap="BsProcessFileResult"> |
| | | <include refid="selectBsProcessFileVo"/> |
| | | <where> |
| | | <if test="productCode != null and productCode != ''"> and product_code = #{productCode}</if> |
| | | <if test="productName != null and productName != ''"> and product_name like concat('%', #{productName}, '%')</if> |
| | | <if test="processesCode != null and processesCode != ''"> and processes_code = #{processesCode}</if> |
| | | <if test="processesName != null and processesName != ''"> and processes_name like concat('%', #{processesName}, '%')</if> |
| | | <if test="fileCode != null and fileCode != ''"> and file_code = #{fileCode}</if> |
| | | <if test="fileName != null and fileName != ''"> and file_name like concat('%', #{fileName}, '%')</if> |
| | | <if test="fileAddress != null and fileAddress != ''"> and file_address = #{fileAddress}</if> |
| | | <if test="status != null and status != ''"> and status = #{status}</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="selectBsProcessFileById" parameterType="Long" resultMap="BsProcessFileResult"> |
| | | <include refid="selectBsProcessFileVo"/> |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertBsProcessFile" parameterType="BsProcessFile" useGeneratedKeys="true" keyProperty="id"> |
| | | insert into bs_process_file |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="productCode != null">product_code,</if> |
| | | <if test="productName != null">product_name,</if> |
| | | <if test="processesCode != null">processes_code,</if> |
| | | <if test="processesName != null">processes_name,</if> |
| | | <if test="fileCode != null">file_code,</if> |
| | | <if test="fileName != null">file_name,</if> |
| | | <if test="fileAddress != null">file_address,</if> |
| | | <if test="status != null">status,</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="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="remarks != null">remarks,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="productCode != null">#{productCode},</if> |
| | | <if test="productName != null">#{productName},</if> |
| | | <if test="processesCode != null">#{processesCode},</if> |
| | | <if test="processesName != null">#{processesName},</if> |
| | | <if test="fileCode != null">#{fileCode},</if> |
| | | <if test="fileName != null">#{fileName},</if> |
| | | <if test="fileAddress != null">#{fileAddress},</if> |
| | | <if test="status != null">#{status},</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="spareField1 != null">#{spareField1},</if> |
| | | <if test="spareField2 != null">#{spareField2},</if> |
| | | <if test="spareField3 != null">#{spareField3},</if> |
| | | <if test="spareField4 != null">#{spareField4},</if> |
| | | <if test="remarks != null">#{remarks},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateBsProcessFile" parameterType="BsProcessFile"> |
| | | update bs_process_file |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="productCode != null">product_code = #{productCode},</if> |
| | | <if test="productName != null">product_name = #{productName},</if> |
| | | <if test="processesCode != null">processes_code = #{processesCode},</if> |
| | | <if test="processesName != null">processes_name = #{processesName},</if> |
| | | <if test="fileCode != null">file_code = #{fileCode},</if> |
| | | <if test="fileName != null">file_name = #{fileName},</if> |
| | | <if test="fileAddress != null">file_address = #{fileAddress},</if> |
| | | <if test="status != null">status = #{status},</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="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="remarks != null">remarks = #{remarks},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteBsProcessFileById" parameterType="Long"> |
| | | delete from bs_process_file where id = #{id} |
| | | </delete> |
| | | |
| | | <delete id="deleteBsProcessFileByIds" parameterType="String"> |
| | | delete from bs_process_file where id in |
| | | <foreach item="id" collection="array" open="(" separator="," close=")"> |
| | | #{id} |
| | | </foreach> |
| | | </delete> |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | import request from '@/utils/request' |
| | | |
| | | // æ¥è¯¢å·¥èºææ¡£å表 |
| | | export function listProcessFile(query) { |
| | | return request({ |
| | | url: '/bs/processFile/list', |
| | | method: 'get', |
| | | params: query |
| | | }) |
| | | } |
| | | |
| | | // æ¥è¯¢å·¥èºææ¡£è¯¦ç» |
| | | export function getProcessFile(id) { |
| | | return request({ |
| | | url: '/bs/processFile/' + id, |
| | | method: 'get' |
| | | }) |
| | | } |
| | | |
| | | // æ°å¢å·¥èºææ¡£ |
| | | export function addProcessFile(data) { |
| | | return request({ |
| | | url: '/bs/processFile', |
| | | method: 'post', |
| | | data: data |
| | | }) |
| | | } |
| | | |
| | | // ä¿®æ¹å·¥èºææ¡£ |
| | | export function updateProcessFile(data) { |
| | | return request({ |
| | | url: '/bs/processFile', |
| | | method: 'put', |
| | | data: data |
| | | }) |
| | | } |
| | | |
| | | // å é¤å·¥èºææ¡£ |
| | | export function delProcessFile(id) { |
| | | return request({ |
| | | url: '/bs/processFile/' + id, |
| | | method: 'delete' |
| | | }) |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <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="fileCode"> |
| | | <el-input |
| | | v-model="queryParams.fileCode" |
| | | placeholder="请è¾å
¥æ件ç¼å·" |
| | | clearable |
| | | @keyup.enter.native="handleQuery" |
| | | /> |
| | | </el-form-item> |
| | | <el-form-item label="æ件å称" prop="fileName"> |
| | | <el-input |
| | | v-model="queryParams.fileName" |
| | | placeholder="请è¾å
¥æ件å称" |
| | | clearable |
| | | @keyup.enter.native="handleQuery" |
| | | /> |
| | | </el-form-item> |
| | | <el-form-item label="æ件å°å" prop="fileAddress"> |
| | | <el-input |
| | | v-model="queryParams.fileAddress" |
| | | 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 type="warning" icon="el-icon-copy-document" size="mini" @click="advancedQuery">é«çº§æ¥è¯¢</el-button>--> |
| | | <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">éç½®</el-button> |
| | | </el-form-item> |
| | | <el-form :model="queryParams" ref="queryParams" size="small" :inline="true" v-show="advancedShowSearch" label-width="68px"> |
| | | </el-form> |
| | | </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:processFile: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:processFile: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:processFile: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:processFile:export']" |
| | | >导åº</el-button> |
| | | </el-col> |
| | | <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> |
| | | </el-row> |
| | | |
| | | <el-table border v-loading="loading" :data="processFileList" @selection-change="handleSelectionChange" v-if="processFileList.length > 0"> |
| | | <el-table-column type="selection" width="55" align="center" /> |
| | | <el-table-column label="产åç¼å·" align="center" prop="productCode"> |
| | | </el-table-column> |
| | | <el-table-column label="产åå称" align="center" prop="productName"> |
| | | </el-table-column> |
| | | <el-table-column label="å·¥åºç¼å·" align="center" prop="processesCode"> |
| | | </el-table-column> |
| | | <el-table-column label="å·¥åºå称" align="center" prop="processesName"> |
| | | </el-table-column> |
| | | <el-table-column label="æ件ç¼å·" align="center" prop="fileCode"> |
| | | </el-table-column> |
| | | <el-table-column label="æ件å称" align="center" prop="fileName"> |
| | | </el-table-column> |
| | | <el-table-column label="æ件å°å" align="center" prop="fileAddress"> |
| | | </el-table-column> |
| | | <el-table-column label="ç¶æ" align="center" prop="status"> |
| | | <template slot-scope="scope"> |
| | | <dict-tag :options="dict.type.sys_normal_disable" :value="scope.row.status"/> |
| | | </template> |
| | | </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:processFile:edit']" |
| | | >ä¿®æ¹</el-button> |
| | | <el-button |
| | | size="mini" |
| | | type="danger" |
| | | plain |
| | | style="width: 72px" |
| | | icon="el-icon-delete" |
| | | @click="handleDelete(scope.row)" |
| | | v-hasPermi="['bs:processFile:remove']" |
| | | >å é¤</el-button> |
| | | </template> |
| | | </el-table-column> |
| | | </el-table> |
| | | <el-empty v-else> |
| | | <span slot="description">ææ æ°æ®</span> |
| | | </el-empty> |
| | | </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="productCode"> |
| | | <el-input v-model="form.productCode" placeholder="请éæ©äº§å" > |
| | | <el-button slot="append" @click="handleSelectProduct" icon="el-icon-search"></el-button> |
| | | </el-input> |
| | | <ItemSelect ref="itemSelect" @onSelected="onItemSelected" > </ItemSelect> |
| | | </el-form-item> |
| | | <el-form-item label="产åå称" prop="productName"> |
| | | <el-input disabled v-model="form.productName" placeholder="请è¾å
¥äº§åå称" /> |
| | | </el-form-item> |
| | | <el-form-item label="å·¥åºç¼å·" prop="processesCode"> |
| | | <el-select style="width: 100%" @change="handleSelectChangeprocessesCode(form.processesCode)" v-model="form.processesCode" placeholder="请éæ©å·¥åºç¼å·"> |
| | | <el-option |
| | | v-for="item in options" |
| | | :key="item.processesCode" |
| | | :label="item.processesCode" |
| | | :value="item.processesCode"> |
| | | </el-option> |
| | | </el-select> |
| | | </el-form-item> |
| | | <el-form-item label="å·¥åºå称" prop="processesName"> |
| | | <el-input disabled v-model="form.processesName" placeholder="请è¾å
¥å·¥åºå称" /> |
| | | </el-form-item> |
| | | <el-form-item label="æ件ç¼å·" prop="fileCode"> |
| | | <el-input v-model="form.fileCode" placeholder="请è¾å
¥æ件ç¼å·" /> |
| | | </el-form-item> |
| | | <el-form-item label="æ件å称" prop="fileName"> |
| | | <el-input v-model="form.fileName" placeholder="请è¾å
¥æ件å称" /> |
| | | </el-form-item> |
| | | <el-form-item label="æ件å°å" prop="fileAddress"> |
| | | <el-input v-model="form.fileAddress" placeholder="请è¾å
¥æ件å°å" /> |
| | | </el-form-item> |
| | | <el-form-item label="ç¶æ" prop="status"> |
| | | <el-radio-group v-model="form.status"> |
| | | <el-radio |
| | | v-for="dict in dict.type.sys_normal_disable" |
| | | :key="dict.value" |
| | | :label="dict.value" |
| | | >{{dict.label}}</el-radio> |
| | | </el-radio-group> |
| | | </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 { listProcessFile, getProcessFile, delProcessFile, addProcessFile, updateProcessFile } from "@/api/main/bs/processFile/processFile"; |
| | | import {listProductBom} from "@/api/main/bs/ProductBom/ProductBom"; |
| | | import {listProcesses} from "@/api/main/bs/processes/processes"; |
| | | import ItemSelect from "@/components/itemSelect/single.vue"; |
| | | import {listTechnologyRoute} from "@/api/main/bs/technologyRoute/technologyRoute"; |
| | | |
| | | |
| | | export default { |
| | | name: "ProcessFile", |
| | | components: {ItemSelect}, |
| | | dicts: ['sys_normal_disable'], |
| | | data() { |
| | | return { |
| | | // é®ç½©å± |
| | | loading: true, |
| | | titleName: "", |
| | | // éä¸æ°ç» |
| | | ids: [], |
| | | options: [], |
| | | // éå个ç¦ç¨ |
| | | single: true, |
| | | // éå¤ä¸ªç¦ç¨ |
| | | multiple: true, |
| | | // æ¾ç¤ºæç´¢æ¡ä»¶ |
| | | showSearch: true, |
| | | // æ»æ¡æ° |
| | | total: 0, |
| | | // å·¥èºææ¡£è¡¨æ ¼æ°æ® |
| | | processFileList: [], |
| | | // å¼¹åºå±æ é¢ |
| | | title: "", |
| | | // æ¯å¦æ¾ç¤ºå¼¹åºå± |
| | | open: false, |
| | | advancedShowSearch: false, |
| | | // æ¥è¯¢åæ° |
| | | queryParams: { |
| | | pageNum: 1, |
| | | pageSize: 10, |
| | | productCode: null, |
| | | productName: null, |
| | | processesCode: null, |
| | | processesName: null, |
| | | fileCode: null, |
| | | fileName: null, |
| | | fileAddress: null, |
| | | status: null, |
| | | createUser: null, |
| | | updateUser: null, |
| | | remarks: null |
| | | }, |
| | | productCodeQueryParams:{ |
| | | pageNum: 1, |
| | | pageSize: 10, |
| | | productCode: null, |
| | | }, |
| | | processesCodeQueryParams:{ |
| | | pageNum: 1, |
| | | pageSize: 10, |
| | | processesCode: null, |
| | | }, |
| | | // 表ååæ° |
| | | form: {}, |
| | | // 表åæ ¡éª |
| | | rules: { |
| | | id: [ |
| | | { required: true, message: "idä¸è½ä¸ºç©º", trigger: "blur" } |
| | | ], |
| | | productCode: [ |
| | | { required: true, message: "产åç¼å·ä¸è½ä¸ºç©º", trigger: "blur" } |
| | | ], |
| | | processesCode: [ |
| | | { required: true, message: "å·¥åºç¼å·ä¸è½ä¸ºç©º", trigger: "blur" } |
| | | ], |
| | | fileCode: [ |
| | | { required: true, message: "æ件ç¼ç ä¸è½ä¸ºç©º", trigger: "blur" } |
| | | ], |
| | | fileName: [ |
| | | { required: true, message: "æ件å称ä¸è½ä¸ºç©º", trigger: "blur" } |
| | | ], |
| | | } |
| | | }; |
| | | }, |
| | | created() { |
| | | this.getList(); |
| | | this.initProcesses(); |
| | | }, |
| | | methods: { |
| | | |
| | | handleSelectChangeprocessesCode(selectedOption) { |
| | | this.processesCodeQueryParams.processesCode = selectedOption; |
| | | listProcesses(this.queryParams).then(response => { |
| | | this.form.processesName = response.rows[0].processesName; |
| | | }); |
| | | }, |
| | | initProcesses(){ |
| | | listProcesses(this.queryParams).then(response => { |
| | | this.options = response.rows; |
| | | }); |
| | | }, |
| | | //ç©æéæ©å¼¹åºæ¡ |
| | | onItemSelected(obj){ |
| | | if(obj !== undefined && obj !== null){ |
| | | let productCode = obj.materialCode; |
| | | this.form.productCode = productCode; |
| | | this.form.productName = obj.materialName; |
| | | this.queryParams.productCode = productCode |
| | | listTechnologyRoute(this.queryParams).then(response => { |
| | | this.form.routeCode = response.rows[0].routeCode; |
| | | }); |
| | | listProductBom(this.queryParams).then(response => { |
| | | this.form.bomCode = response.rows[0].bomCode; |
| | | }); |
| | | } |
| | | }, |
| | | handleSelectProduct(){ |
| | | this.$refs.itemSelect.showFlag = true; |
| | | }, |
| | | |
| | | advancedQuery(){ |
| | | this.advancedShowSearch = (this.advancedShowSearch) ? this.advancedShowSearch = false : this.advancedShowSearch = true; |
| | | }, |
| | | /** æ¥è¯¢å·¥èºææ¡£å表 */ |
| | | getList() { |
| | | this.loading = true; |
| | | listProcessFile(this.queryParams).then(response => { |
| | | this.processFileList = response.rows; |
| | | this.total = response.total; |
| | | this.loading = false; |
| | | }); |
| | | }, |
| | | // åæ¶æé® |
| | | cancel() { |
| | | this.open = false; |
| | | this.reset(); |
| | | }, |
| | | // 表åéç½® |
| | | reset() { |
| | | this.form = { |
| | | id: null, |
| | | productCode: null, |
| | | productName: null, |
| | | processesCode: null, |
| | | processesName: null, |
| | | fileCode: null, |
| | | fileName: null, |
| | | fileAddress: null, |
| | | status: "0", |
| | | createUser: null, |
| | | createTime: null, |
| | | updateUser: null, |
| | | updateTime: null, |
| | | spareField1: null, |
| | | spareField2: null, |
| | | spareField3: null, |
| | | spareField4: 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 |
| | | getProcessFile(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) { |
| | | updateProcessFile(this.form).then(response => { |
| | | this.$modal.msgSuccess("ä¿®æ¹æå"); |
| | | this.open = false; |
| | | this.getList(); |
| | | }); |
| | | } else { |
| | | addProcessFile(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 delProcessFile(ids); |
| | | }).then(() => { |
| | | this.getList(); |
| | | this.$modal.msgSuccess("å é¤æå"); |
| | | }).catch(() => {}); |
| | | }, |
| | | /** 导åºæé®æä½ */ |
| | | handleExport() { |
| | | this.download('bs/processFile/export', { |
| | | ...this.queryParams |
| | | }, `processFile_${new Date().getTime()}.xlsx`) |
| | | } |
| | | } |
| | | }; |
| | | </script> |