package com.slcf.dao;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import com.slcf.pojo.WorkMastLogBean;
|
import com.slcf.bean.WorkDetailLogCondition;
|
import com.slcf.bean.WorkMastLogCondition;
|
import com.slcf.pojo.WorkDetailLogBean;
|
|
@Repository
|
public interface WorkFileLogDao {
|
|
//-------------------主档------------------------------//
|
/**
|
* 分页查询主档信息
|
* @param workMastCon
|
* @return
|
*/
|
public List<WorkMastLogBean> queryWorkMastLogList(WorkMastLogCondition workMastLogCon);
|
|
//根据过滤条件统计总数量
|
public int getWorkMastLogCount(WorkMastLogCondition workMastLogCon);
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from asr_wrk_mast_log order by wrk_no asc")
|
public List<WorkMastLogBean> getWorkMastLogList();
|
|
/**
|
* 根据id查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select *,wrk_desc wrk_sts_name from asr_wrk_mast_log a,asr_bas_wrk_status b where a.wrk_sts=b.wrk_sts and wrk_no=#{id}")
|
public WorkMastLogBean getWorkMastLogById(int id);
|
|
//-------------------明细------------------------------//
|
/**
|
* 分页查询明细档信息
|
* @param workDetailCon
|
* @return
|
*/
|
public List<WorkDetailLogBean> queryWorkDetailLogList(WorkDetailLogCondition workDetailLogCon);
|
|
//根据过滤条件统计总数量
|
public int getWorkDetailLogCount(WorkDetailLogCondition workDetailLogCon);
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from asr_wrk_detl_log order by wrk_no,mat_no asc")
|
public List<WorkDetailLogBean> getWorkDetailLogList();
|
|
/**
|
* 根据id查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select * from asr_wrk_detl_log where wrk_no=#{id}")
|
public WorkDetailLogBean getWorkDetlLogById(int id);
|
}
|
