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();
|
|
}
|
