sql 优化

linwei

2026-01-23 fefe259f19a251d90d17d8a42e04f6332a4cad3e

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdWorkOrderMapper.java

@@ -17,6 +17,8 @@
package org.sxkj.gd.workorder.mapper;

import org.sxkj.gd.workorder.entity.GdWorkOrderEntity;
import org.sxkj.gd.workorder.param.WorkOrderAddParam;
import org.sxkj.gd.workorder.param.WorkOrderPageParam;
import org.sxkj.gd.workorder.vo.GdWorkOrderVO;
import org.sxkj.gd.workorder.excel.GdWorkOrderExcel;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -40,7 +42,7 @@
    * @param gdWorkOrder
    * @return
    */
   List<GdWorkOrderVO> selectGdWorkOrderPage(IPage page, GdWorkOrderVO gdWorkOrder);
   List<GdWorkOrderVO> selectGdWorkOrderPage(IPage page, WorkOrderPageParam gdWorkOrder);


   /**
@@ -51,4 +53,23 @@
    */
   List<GdWorkOrderExcel> exportGdWorkOrder(@Param("ew") Wrapper<GdWorkOrderEntity> queryWrapper);

   /**
    *
    * @param gdWorkOrder
    * @return
    */
   GdWorkOrderEntity getWorkOrderDetail(GdWorkOrderEntity gdWorkOrder);

   /**
    *
    * @param workOrderParam
    */
   Integer saveWorkOrder(@Param("workOrderParam") GdWorkOrderEntity workOrderParam);

   /**
    *
    * @param workOrderParam
    * @return
    */
   Integer updateWorkOrderById(@Param("workOrderParam") GdWorkOrderEntity workOrderParam);
}