package com.nanometer.smartlab.dao;

import com.nanometer.smartlab.entity.SysProject;
import org.springframework.dao.DataAccessException;

import java.util.List;
import java.util.Map;

public interface SysProjectDao {
    public SysProject getSysProject(Long id) throws DataAccessException;

    public SysProject getSysProjectByName(String projectName) throws DataAccessException;
    public List<SysProject> getSysProjectList(Map params) throws DataAccessException;
    public int getSysProjectTotalCount(Map params) throws DataAccessException;

    public int insertSysProject(SysProject SysProject) throws DataAccessException;
    public int updateSysProject(SysProject SysProject) throws DataAccessException;
    public int deleteSysProjects(List<Long> ids) throws DataAccessException;

    public List<SysProject> getSysProjectListUpdate(Map params) throws DataAccessException;
    public int getSysProjectTotalCountUpdate(Map params) throws DataAccessException;

    public SysProject getProjectByProNo(String projectNo) throws DataAccessException;

    public List<SysProject> getSysProjectListByProjectNo(Map params) throws DataAccessException;

    public SysProject getSysProjectListByProjectId(Long id);

    void insertBatch(List<?> list);

    //获取不重复的课题组名
    List<SysProject> selectDistinctProjects();

    //课题组是否存在
    int selectByProject(String project);

    List<SysProject> getProjectByIds(List<Long> ids);
}