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.WorkMastCondition;
|
import com.slcf.pojo.WorkMastBean;
|
import com.slcf.bean.WorkDetailCondition;
|
import com.slcf.pojo.WorkDetailBean;
|
|
@Repository
|
public interface WorkFileDao {
|
|
//-------------------主档------------------------------//
|
/**
|
* 插入主档
|
* @param workMast
|
* @return
|
*/
|
@Insert("insert into asr_wrk_mast(wrk_no,io_time,wrk_sts,io_type,io_pri,crn_no, "
|
+ " source_sta_no,sta_no,source_loc_no,loc_no,full_plt,picking, "
|
+ " barcode,exit_mk,empty_mk,link_mis,memo,modi_user,modi_time) "
|
+ " values(#{wrk_no},#{io_time},#{wrk_sts},#{io_type},#{io_pri},#{crn_no}, "
|
+ " #{source_sta_no},#{sta_no},#{source_loc_no}, #{loc_no},#{full_plt},#{picking}, "
|
+ " #{barcode},#{exit_mk},#{empty_mk},#{link_mis},#{memo},#{modi_user},getdate())")
|
public int insertWorkMast(WorkMastBean workMast);
|
|
/**
|
* 分页查询主档信息
|
* @param workMastCon
|
* @return
|
*/
|
public List<WorkMastBean> queryWorkMastList(WorkMastCondition workMastCon);
|
|
//根据过滤条件统计总数量
|
public int getWorkMastCount(WorkMastCondition workMastCon);
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from asr_wrk_mast order by wrk_no asc")
|
public List<WorkMastBean> getWorkMastList();
|
|
/**
|
* 根据id查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select *,wrk_desc wrk_sts_name from asr_wrk_mast a,asr_bas_wrk_status b where a.wrk_sts=b.wrk_sts and wrk_no=#{id}")
|
public WorkMastBean getWorkMastById(int id);
|
|
//更新
|
@Update("update asr_wrk_mast set wrk_sts=#{wrk_sts},io_pri=#{io_pri},barcode=#{barcode}, "
|
+ " modi_user=#{modi_user},modi_time=getdate() "
|
+ " where wrk_no=#{wrk_no}")
|
public int upWorkMast(WorkMastBean workMast);
|
|
//根据id删除工作信息
|
@Delete("delete from asr_wrk_mast where wrk_no=#{id}")
|
public int delWorkMastById(int id);
|
|
//根据过滤条件统计总数量
|
@Select("select count(*) from asr_wrk_mast where source_sta_no=#{dev_no} and (wrk_sts=1 or wrk_sts=6)")
|
public int getStoreWorkCount(int dev_no);
|
|
//-------------------明细------------------------------//
|
/**
|
* 插入明细档
|
* @param workDetail
|
* @return
|
*/
|
@Insert("insert into asr_wrk_detl(wrk_no,io_time,matnr,lgnum,tbnum,tbpos,zmatid,maktx,werks,anfme,altme,zpallet,bname,memo,modi_user,modi_time) "
|
+ " values(#{wrk_no},#{io_time},#{matnr},#{lgnum},#{tbnum},#{tbpos},#{zmatid},#{maktx},#{werks},#{anfme},#{altme},#{zpallet},#{bname},#{memo},#{modi_user},getdate())")
|
public int insertWorkDetail(WorkDetailBean workDetail);
|
|
/**
|
* 分页查询明细档信息
|
* @param workDetailCon
|
* @return
|
*/
|
public List<WorkDetailBean> queryWorkDetailList(WorkDetailCondition workDetailCon);
|
|
//根据过滤条件统计总数量
|
public int getWorkDetailCount(WorkDetailCondition workDetailCon);
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from asr_wrk_detl order by wrk_no,mat_no asc")
|
public List<WorkDetailBean> getWorkDetailList();
|
|
// /**
|
// * 根据id查询信息
|
// * @param id
|
// * @return
|
// */
|
// @Select("select * from asr_wrk_detl where wrk_no=#{id}")
|
// public WorkDetailBean getWorkDetlById(int id);
|
|
//删除工作档资料，先插入日志档
|
@Insert("insert into asr_wrk_detl_log select * from asr_wrk_detl where wrk_no=#{wrk_no};"
|
+ " insert into asr_wrk_mast_log select * from asr_wrk_mast where wrk_no=#{wrk_no};")
|
public int insertLog(int wrk_no);
|
|
//根据id删除工作信息
|
@Delete("delete from asr_wrk_detl where wrk_no=#{wrk_no};delete from asr_wrk_mast where wrk_no=#{wrk_no};")
|
public int delWorkFileById(int wrk_no);
|
|
/**
|
* 根据工作号、物料号查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select * from asr_wrk_detl where wrk_no=#{wrk_no} and mat_no=#{mat_no}")
|
public WorkDetailBean getWorkDetlByIdNo(@Param("wrk_no")int wrk_no,@Param("mat_no")String mat_no);
|
|
@Select("select * from asr_wrk_detl where mat_no=#{mat_no}")
|
public WorkDetailBean getWorkDetlByMatNo(@Param("mat_no")String mat_no);
|
|
//更新
|
@Update("update asr_wrk_detl set "// wrk_sts=#{wrk_sts},io_pri=#{io_pri}, "
|
+ " modi_user=#{modi_user},modi_time=getdate() "
|
+ " where wrk_no=#{wrk_no} and mat_no=#{mat_no}}")
|
public int upWorkDetail(WorkDetailBean workDetail);
|
|
/**
|
* 根据工作号、物料代号查询工作档明细
|
* @param wrk_no
|
* @param matnr
|
* @return
|
*/
|
@Select("select * from asr_wrk_detl where wrk_no=#{wrk_no} and lgnum=#{lgnum} and tbnum=#{tbnum} and tbpos=#{tbpos} and matnr=#{matnr}")
|
public WorkDetailBean getWorkDetlById(WorkDetailBean workDetail);
|
|
/**
|
* 更新实际拣料数量
|
* @param workDetl
|
* @return
|
*/
|
@Update("update asr_wrk_detl set nista=#{nista} "
|
+ " where wrk_no=#{wrk_no} and lgnum=#{lgnum} and tbnum=#{tbnum} and tbpos=#{tbpos} and matnr=#{matnr}")
|
public int upWorkDetl(WorkDetailBean workDetl);
|
|
/**
|
* 根据托盘码查询工作明细List
|
* @return
|
*/
|
@Select("select * from asr_wrk_detl where zpallet=#{zpallet} order by wrk_no asc")
|
public List<WorkDetailBean> getWorkDetlList(String zpallet);
|
}
|
