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.Select;
import org.springframework.stereotype.Repository;

import com.slcf.bean.SysLogCondition;
import com.slcf.pojo.SysLogBean;

@Repository
public interface SysLogDao {

	/**
	 * 添加
	 * @param sysLog
	 * @return
	 */
	@Insert("insert into sys_tts_mast(login_no,login_date,machine_ip,form_no,tts_keyname,modi_user,modi_time) "
			+ " values(#{login_no},getdate(),#{machine_ip},#{form_no},#{tts_keyname},#{modi_user},getdate())")
	public int insertSysLog(SysLogBean sysLog);
	
	/**
	 * 分页查询所有信息 	
	 * @param sysLogCon
	 * @return
	 */
	public List<SysLogBean> querySysLogList(SysLogCondition sysLogCon);
	
	/**
	 * 不分页查询所有信息，用于excel导出 
	 * @param sysLogCon
	 * @return
	 */
	public List<SysLogBean> getSysLogAll(SysLogCondition sysLogCon);
	
	//根据过滤条件统计总数量
	public int getSysLogCount(SysLogCondition sysLogCon);
	
	/**
	 * 查询所有
	 * @return
	 */
	@Select("select * from sys_tts_mast order by login_date desc")
	public List<SysLogBean> getSysLogList();
	
	/**
	 * 根据id查询信息
	 * @param id
	 * @return
	 */
	@Select("select * from sys_tts_mast where log_id=#{id}")
	public SysLogBean getSysLogById(int id);
	
//	//更新
//	@Update("update sys_tts_mast set loc_sts=#{loc_sts},crn_no=#{crn_no},row1=#{row1},bay1=#{bay1},"
//			+ " lev1=#{lev1},loc_type=#{loc_type},modi_user=#{modi_user},modi_time=getdate() "
//			+ " where log_id=#{log_id}")
//	public int upSysLog(SysLogBean sysLog);
	
	//根据id删除
	@Delete("delete from sys_tts_mast where log_id=#{id}")
	public int delSysLogById(int id);
	
	//删除所有日志
	@Delete("delete from sys_tts_mast")
	public int resetSysLog();
	
}