优化巡检路线查询sql

mrzcc

2020-02-19 b09e1a8b036553d1e161d127aa738a504593490a

 CommunityService/src/main/java/com/java110/community/smo/impl/ServiceInnerServiceSMOImpl.java

@@ -1,19 +1,18 @@
package com.java110.community.smo.impl;


import com.java110.common.util.BeanConvertUtil;
import com.java110.utils.util.BeanConvertUtil;
import com.java110.community.dao.IServiceServiceDao;
import com.java110.core.base.smo.BaseServiceSMO;
import com.java110.core.smo.service.IServiceInnerServiceSMO;
import com.java110.core.smo.user.IUserInnerServiceSMO;
import com.java110.dto.PageDto;
import com.java110.dto.UserDto;
import com.java110.dto.service.ServiceDto;
import com.java110.dto.service.ServiceProvideDto;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;

import java.util.ArrayList;
import java.util.List;

/**
@@ -42,7 +41,6 @@

        if (page != PageDto.DEFAULT_PAGE) {
            serviceDto.setPage((page - 1) * serviceDto.getRow());
            serviceDto.setRow(page * serviceDto.getRow());
        }

        List<ServiceDto> services = BeanConvertUtil.covertBeanList(serviceServiceDaoImpl.getServiceInfo(BeanConvertUtil.beanCovertMap(serviceDto)), ServiceDto.class);
@@ -90,4 +88,46 @@
    public void setUserInnerServiceSMOImpl(IUserInnerServiceSMO userInnerServiceSMOImpl) {
        this.userInnerServiceSMOImpl = userInnerServiceSMOImpl;
    }


    @Override
    public List<ServiceProvideDto> queryServiceProvides(@RequestBody ServiceProvideDto serviceProvideDto) {

        //校验是否传了 分页信息

        int page = serviceProvideDto.getPage();

        if (page != PageDto.DEFAULT_PAGE) {
            serviceProvideDto.setPage((page - 1) * serviceProvideDto.getRow());
        }

        List<ServiceProvideDto> services = BeanConvertUtil.covertBeanList(serviceServiceDaoImpl.getServiceProvideInfo(BeanConvertUtil.beanCovertMap(serviceProvideDto)), ServiceProvideDto.class);


        return services;
    }



    @Override
    public int queryServiceProvidesCount(@RequestBody ServiceProvideDto serviceProvideDto) {
        return serviceServiceDaoImpl.queryServiceProvidesCount(BeanConvertUtil.beanCovertMap(serviceProvideDto));
    }


    @Override
    public int updateServiceProvide(@RequestBody ServiceProvideDto serviceProvideDto) {
        return serviceServiceDaoImpl.updateServiceProvideInfo(BeanConvertUtil.beanCovertMap(serviceProvideDto));
    }

    @Override
    public int saveServiceProvide(@RequestBody ServiceProvideDto serviceProvideDto) {
        return serviceServiceDaoImpl.saveServiceProvideInfo(BeanConvertUtil.beanCovertMap(serviceProvideDto));
    }

    @Override
    public int deleteServiceProvide(@RequestBody ServiceProvideDto serviceProvideDto) {
        serviceProvideDto.setStatusCd("1");
        return serviceServiceDaoImpl.updateServiceProvideInfo(BeanConvertUtil.beanCovertMap(serviceProvideDto));
    }
}