meidu2021/daju/src-xcgl/main/java/com/xcgl/cloud/dao/CloudBaseDataSyncDao.java

package com.xcgl.cloud.dao;

import java.util.List;

import org.jeecgframework.minidao.annotation.MiniDao;
import org.jeecgframework.minidao.annotation.Param;
import org.jeecgframework.minidao.annotation.Sql;
import org.springframework.stereotype.Repository;

import com.xcgl.device.entity.DeviceEntity;
import com.xcgl.devicetype.entity.DeviceTypeEntity;
import com.xcgl.sensormonitorpoint.entity.SensorMonitorPointEntity;
import com.xcgl.sensortype.entity.SensorTypeEntity;

@Repository
@MiniDao
public interface CloudBaseDataSyncDao {
// id,type_code, type_name, description, icon, system_abbreviate, state
	@Sql("select * from p_device_type ")
	public List<DeviceTypeEntity> getAllDevicetype();
	
	@Sql("select * from p_sensor_type ")
	public List<SensorTypeEntity> getAllSensortype();
	
	@Sql("select * from p_device where projectid = :pid ")
	public List<DeviceEntity> getDevicebyProject(@Param("pid") String pid);
	
	@Sql("select * from p_sensor_monitor_point where  projectid = :pid  ")
	public List<SensorMonitorPointEntity> getSensorbyProject(@Param("pid") String pid);
}