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(String id) 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<String> ids) throws DataAccessException;

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

    public SysProject getProjectByProId(String projectId) throws DataAccessException;

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

    void insertBatch(List<?> list);

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

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