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