art: 技术状态鉴定工单-数据库设计修改

zhangherong

2025-07-10 16cd6a3d63f3352c1a20abb5fc73f48a4204bc62

 lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamTechnicalStatusEvaluationOrderController.java

@@ -1,6 +1,6 @@
package org.jeecg.modules.eam.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import cn.hutool.core.collection.CollectionUtil;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import io.swagger.annotations.Api;
@@ -9,16 +9,15 @@
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.aspect.annotation.AutoLog;
import org.jeecg.common.system.base.controller.JeecgController;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.modules.eam.constant.BusinessCodeConst;
import org.jeecg.modules.eam.constant.OrderCreationMethodEnum;
import org.jeecg.modules.eam.entity.EamTechnicalStatusEvaluationOrder;
import org.jeecg.modules.eam.request.EamTechnicalStatusEvaluationOrderQuery;
import org.jeecg.modules.eam.request.EamTechnicalStatusEvaluationOrderRequest;
import org.jeecg.modules.eam.service.IEamTechnicalStatusEvaluationOrderService;
import org.jeecg.modules.system.service.ISysBusinessCodeRuleService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Arrays;

 /**
 * @Description: 技术状态鉴定工单
@@ -33,119 +32,80 @@
public class EamTechnicalStatusEvaluationOrderController extends JeecgController<EamTechnicalStatusEvaluationOrder, IEamTechnicalStatusEvaluationOrderService> {
   @Autowired
   private IEamTechnicalStatusEvaluationOrderService eamTechnicalStatusEvaluationOrderService;
	
    @Autowired
    private ISysBusinessCodeRuleService businessCodeRuleService;
   /**
    * 分页列表查询
    *
    * @param eamTechnicalStatusEvaluationOrder
    * @param query
    * @param pageNo
    * @param pageSize
    * @param req
    * @return
    */
   @ApiOperation(value="技术状态鉴定工单-分页列表查询", notes="技术状态鉴定工单-分页列表查询")
   @GetMapping(value = "/list")
   public Result<?> queryPageList(EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder,
   public Result<?> queryPageList(EamTechnicalStatusEvaluationOrderQuery query,
                           @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
                           @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
                           HttpServletRequest req) {
      QueryWrapper<EamTechnicalStatusEvaluationOrder> queryWrapper = QueryGenerator.initQueryWrapper(eamTechnicalStatusEvaluationOrder, req.getParameterMap());
                           @RequestParam(name="pageSize", defaultValue="10") Integer pageSize) {
      Page<EamTechnicalStatusEvaluationOrder> page = new Page<EamTechnicalStatusEvaluationOrder>(pageNo, pageSize);
      IPage<EamTechnicalStatusEvaluationOrder> pageList = eamTechnicalStatusEvaluationOrderService.page(page, queryWrapper);
      IPage<EamTechnicalStatusEvaluationOrder> pageList = eamTechnicalStatusEvaluationOrderService.queryPageList(page, query);
      return Result.OK(pageList);
   }
   
   /**
    * 添加
    *
    * @param eamTechnicalStatusEvaluationOrder
    * @param request
    * @return
    */
   @AutoLog(value = "技术状态鉴定工单-添加")
   @ApiOperation(value="技术状态鉴定工单-添加", notes="技术状态鉴定工单-添加")
   @PostMapping(value = "/add")
   public Result<?> add(@RequestBody EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder) {
      eamTechnicalStatusEvaluationOrderService.save(eamTechnicalStatusEvaluationOrder);
   public Result<?> add(@RequestBody EamTechnicalStatusEvaluationOrderRequest request) {
      if (request == null) {
         return Result.error("添加的对象不能为空！");
      }
      if (CollectionUtil.isEmpty(request.getTableDetailList())) {
         return Result.error("检查项不能为空！");
      }
      String codeSeq = businessCodeRuleService.generateBusinessCodeSeq(BusinessCodeConst.TECHNICAL_STATUS_EVALUATION_ORDER_CODE_RULE);
      request.setOrderNum(codeSeq);
      request.setCreationMethod(OrderCreationMethodEnum.MANUAL.name());
      boolean b = eamTechnicalStatusEvaluationOrderService.addTechnicalStatusEvaluationOrder(request);
      if (!b) {
         return Result.error("添加失败！");
      }
      return Result.OK("添加成功！");
   }
	
   /**
    * 编辑
    *
    * @param eamTechnicalStatusEvaluationOrder
    * @return
    */
   @AutoLog(value = "技术状态鉴定工单-编辑")
   @ApiOperation(value="技术状态鉴定工单-编辑", notes="技术状态鉴定工单-编辑")
   @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
   public Result<?> edit(@RequestBody EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder) {
      eamTechnicalStatusEvaluationOrderService.updateById(eamTechnicalStatusEvaluationOrder);
      return Result.OK("编辑成功!");
   }
	
   /**
    * 通过id删除
    *
    * @param id
    * @return
    */
   @AutoLog(value = "技术状态鉴定工单-通过id删除")
   @ApiOperation(value="技术状态鉴定工单-通过id删除", notes="技术状态鉴定工单-通过id删除")
   @DeleteMapping(value = "/delete")
   public Result<?> delete(@RequestParam(name="id",required=true) String id) {
      eamTechnicalStatusEvaluationOrderService.removeById(id);
      return Result.OK("删除成功!");
   }
	
   /**
    * 批量删除
    *
    * @param ids
    * @return
    */
   @AutoLog(value = "技术状态鉴定工单-批量删除")
   @ApiOperation(value="技术状态鉴定工单-批量删除", notes="技术状态鉴定工单-批量删除")
   @DeleteMapping(value = "/deleteBatch")
   public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
      this.eamTechnicalStatusEvaluationOrderService.removeByIds(Arrays.asList(ids.split(",")));
      return Result.OK("批量删除成功！");
   }
	
   /**

    /**
     * 通过id领取
     *
     * @param id
     * @return
     */
    @AutoLog(value = "技术状态鉴定工单-领取")
    @ApiOperation(value = "技术状态鉴定工单-领取", notes = "技术状态鉴定工单-领取")
    @GetMapping(value = "/collect")
    public Result<?> collect(@RequestParam(name = "id", required = true) String id) {
       boolean b = eamTechnicalStatusEvaluationOrderService.collect(id);
       if (!b) {
          Result.OK("领取失败!");
       }
       return Result.OK("领取成功!");
    }


    /**
    * 通过id查询
    *
    * @param id
    * @return
    */
   @AutoLog(value = "技术状态鉴定工单-通过id查询")
   @ApiOperation(value="技术状态鉴定工单-通过id查询", notes="技术状态鉴定工单-通过id查询")
   @GetMapping(value = "/queryById")
   public Result<?> queryById(@RequestParam(name="id",required=true) String id) {
      EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder = eamTechnicalStatusEvaluationOrderService.getById(id);
      return Result.OK(eamTechnicalStatusEvaluationOrder);
   }

  /**
   * 导出excel
   *
   * @param request
   * @param eamTechnicalStatusEvaluationOrder
   */
  @RequestMapping(value = "/exportXls")
  public ModelAndView exportXls(HttpServletRequest request, EamTechnicalStatusEvaluationOrder eamTechnicalStatusEvaluationOrder) {
      return super.exportXls(request, eamTechnicalStatusEvaluationOrder, EamTechnicalStatusEvaluationOrder.class, "技术状态鉴定工单");
  }

  /**
   * 通过excel导入数据
   *
   * @param request
   * @param response
   * @return
   */
  @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
  public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
      return super.importExcel(request, response, EamTechnicalStatusEvaluationOrder.class);
  }

}