package com.slcf.dao;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
import org.springframework.stereotype.Repository;
|
|
import com.slcf.bean.MeetingCondition;
|
import com.slcf.pojo.ConsumerBean;
|
import com.slcf.pojo.GroupBean;
|
import com.slcf.pojo.MeetingBean;
|
import com.slcf.pojo.MeetingConsumerBean;
|
|
/**
|
* 会议Dao映射层
|
* @author Administrator
|
* @date 2018年8月14日
|
*/
|
@Repository
|
public interface MeetingDao {
|
/**
|
* 根据会议编号验证是否唯一
|
* @param meetingNo
|
* @return
|
*/
|
@Select("select * from tb_meeting where f_MeetingNo=#{meetingNo}")
|
public MeetingBean getMeetingByNo(String meetingNo);
|
|
/**
|
* 分页查询所有会议
|
* @param spage
|
* @param epage
|
* @return
|
*/
|
// @Select("select top (#{epage}) * from tb_meeting a,tb_meeting_room b where a.f_RoomId=b.f_RoomId and f_MeetingNo not in "
|
// + "(select top (#{spage}) f_MeetingNo from tb_meeting order by f_MeetingDateTime desc) order by f_MeetingDateTime desc")
|
// public List<MeetingBean> getMeetingList(@Param("spage")int spage,@Param("epage")int epage);
|
public List<MeetingBean> getMeetingList(MeetingCondition meeting);
|
|
/**
|
* 统计会议数量
|
* @return
|
*/
|
// @Select("select count(*) from tb_meeting")
|
// public int getCount();
|
public int getCount(MeetingCondition meeting);
|
|
/**
|
* 添加会议
|
* @param meetingBean
|
* @return
|
*/
|
@Insert("insert into tb_meeting(f_MeetingNo,f_MeetingName,f_RoomId,f_MeetingDateTime, "
|
+ " f_MeetingEndDate,f_SignStartTime,f_SignEndTime,f_Content,f_Notes) "
|
+ " values(#{f_MeetingNo},#{f_MeetingName},#{f_RoomId}, "
|
+ " CONVERT(datetime,#{f_MeetingDateTime},120), "
|
+ " CONVERT(datetime,#{f_MeetingEndDate},120), "
|
+ " CONVERT(datetime,#{f_SignStartTime},120), "
|
+ " CONVERT(datetime,#{f_SignEndTime},120), "
|
+ " #{f_Content},#{f_Notes})")
|
public int saveMeeting(MeetingBean meetingBean);
|
|
/**
|
* 根据No删除
|
* @param meetingNo
|
* @return
|
*/
|
@Delete("delete from tb_meeting where f_MeetingNo=#{meetingNo}")
|
public int delMeetingByNo(String meetingNo);
|
|
/**
|
* 根据会议编号查找
|
* @param meetingNo
|
* @return
|
*/
|
@Select("select * from tb_meeting where f_MeetingNo=#{meetingNo}")
|
public MeetingBean quertMeetingByNo(String meetingNo);
|
|
/**
|
* 更新会议
|
* @param meetingBean
|
* @return
|
*/
|
@Update("update tb_meeting set "
|
+ " f_MeetingName=#{f_MeetingName}, "
|
+ " f_RoomId=#{f_RoomId}, "
|
+ " f_MeetingDateTime=#{f_MeetingDateTime}, "
|
+ " f_MeetingEndDate=#{f_MeetingEndDate}, "
|
+ " f_SignStartTime=#{f_SignStartTime}, "
|
+ " f_SignEndTime=#{f_SignEndTime}, "
|
+ " f_Content=#{f_Content}, "
|
+ " f_Notes=#{f_Notes} "
|
+ " where f_MeetingNo=#{f_MeetingNo}")
|
public int upMeeting(MeetingBean meetingBean);
|
|
/**
|
* 检查会议时间是否占用
|
* @return
|
*/
|
@Select("select count(*) from tb_meeting "
|
+ " where f_RoomId=#{f_RoomId} and ((#{f_SignStartTime}>f_SignStartTime and #{f_SignStartTime}<f_MeetingEndDate) "
|
+ " or (#{f_MeetingEndDate}>f_SignStartTime and #{f_MeetingEndDate}<f_MeetingEndDate))")
|
public int checkMeetingDate(MeetingBean meetingBean);
|
|
/**
|
* 查询会议参会人员id
|
* @param rid
|
* @return
|
*/
|
@Select("select f_ConsumerID from tb_meeting_consumer where f_MeetingNO=#{rid}")
|
public List<Integer> queryConsumerByNo(String rid);
|
|
/**
|
* 查询所有部门
|
* @return
|
*/
|
@Select("select * from t_b_Group")
|
public List<GroupBean> getGroupList();
|
|
/**
|
* 查询部门下所有人员信息
|
* @return
|
*/
|
@Select("select * from t_b_Consumer where f_GroupID=#{Gid}")
|
public List<ConsumerBean> queryConsumerByGid(Long Gid);
|
|
/**
|
* 根据会议编号查询参会人员
|
* @param meetingNo
|
* @return
|
*/
|
@Select("select * from tb_meeting_consumer where f_MeetingNO=#{meetingNo}")
|
public List<MeetingConsumerBean> queryMeetingConsumer(String meetingNo);
|
|
/**
|
* 删除会议人员信息
|
* @param meetingNo
|
* @return
|
*/
|
@Delete("delete from tb_meeting_consumer where f_MeetingNO=#{meetingNo}")
|
public int delMeetingConsumer(String meetingNo);
|
|
/**
|
* 添加会议人员
|
* @param meetingNo
|
* @param mid
|
* @return
|
*/
|
@Insert("insert into tb_meeting_consumer(f_MeetingNO,f_ConsumerID) values(#{meetingNo},#{mid})")
|
public int saveMeetingConsumer(@Param("meetingNo")String meetingNo,@Param("mid")int mid);
|
}
|
