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.apache.ibatis.annotations.Update;
|
import org.springframework.stereotype.Repository;
|
|
import com.slcf.bean.MatCodeCondition;
|
import com.slcf.pojo.LocDetailBean;
|
import com.slcf.pojo.MatCodeBean;
|
import com.slcf.pojo.WorkDetailBean;
|
|
@Repository
|
public interface MatCodeDao {
|
|
/**
|
* 添加
|
* @param matCode
|
* @return
|
*/
|
@Insert("insert into bas_mat_code(mat_no,mat_name,str1,str2,str3,str4,str5,"
|
+ " str6,str7,str8,str9,str10,str11,str12,str13,str14,str15, "
|
+ " str16,str17,str18,str19,str20,str21,str22,str23, "
|
+ " num1,num2,num3,num4,num5,num6,date1,barcode) "
|
+ " values(#{mat_no},#{mat_name},#{str1},#{str2},#{str3},#{str4},#{str5},"
|
+ " #{str6},#{str7},#{str8},#{str9},#{str10},#{str11},#{str12},#{str13},#{str14},#{str15}, "
|
+ " #{str16},#{str17},#{str18},#{str19},#{str20},#{str21},#{str22},#{str23},"
|
+ " #{num1},#{num2},#{num3},#{num4},#{num5},#{num6},#{date1},#{barcode})")
|
public int insertMatCode(MatCodeBean MatCode);
|
|
/**
|
* 分页查询所有信息
|
* @param matCodeCon
|
* @return
|
*/
|
public List<MatCodeBean> queryMatCodeList(MatCodeCondition matCodeCon);
|
|
/**
|
* 根据箱号查询
|
* @param matCodeCon
|
* @return
|
*/
|
@Select("select * from bas_mat_code where mat_no=#{mat_no}")
|
public List<MatCodeBean> queryMatCodeByNo(MatCodeCondition matCodeCon);
|
|
@Select("select count(*) from bas_mat_code where mat_no=#{mat_no}")
|
public int getMatCountByNo(MatCodeCondition matCodeCon);
|
|
/**
|
* 不分页查询所有信息，用于excel导出
|
* @param matCodeCon
|
* @return
|
*/
|
public List<MatCodeBean> getMatCodeAll(MatCodeCondition matCodeCon);
|
|
// //统计所有数据总数量
|
// @Select("select count(*) from bas_mat_code")
|
// public int getMatCodeCount();
|
|
//根据过滤条件统计总数量
|
public int getMatCodeCount(MatCodeCondition matCodeCon);
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from bas_mat_code order by mat_no asc")
|
public List<MatCodeBean> getMatCodeList();
|
|
/**
|
* 根据id查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select * from bas_mat_code where mat_no=#{id}")
|
public MatCodeBean getMatCodeById(String id);
|
|
/**
|
* 根据barcode查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select * from bas_mat_code where barcode=#{id}")
|
public MatCodeBean getMatCodeByBarcode(String id);
|
|
//更新
|
@Update("update bas_mat_code set mat_name=#{mat_name},str1=#{str1},str2=#{str2},str3=#{str3}, "
|
+ " str4=#{str4},str5=#{str5},str6=#{str6},str7=#{str7},str8=#{str8},str9=#{str9}, "
|
+ " str10=#{str10},num1=#{num1},num2=#{num2},num3=#{num3},num4=#{num4},num5=#{num5}, "
|
+ " modi_user=#{modi_user},modi_time=getdate() where mat_no=#{mat_no}")
|
public int upMatCode(MatCodeBean MatCode);
|
|
//组托，更新条码
|
@Update("update bas_mat_code set barcode=#{barcode},modi_time=getdate() where mat_no=#{mat_no}")
|
public int upMatBarcode(MatCodeBean MatCode);
|
|
//根据id删除工作信息
|
@Delete("delete from bas_mat_code where mat_no=#{id}")
|
public int delMatCodeById(String id);
|
|
//根据id删除工作信息
|
@Delete("delete from bas_mat_code where mat_no in (#{id})")
|
public int delMatCodesById(String id);
|
|
/**
|
* 查询库存中物料号是否存在
|
* @return
|
*/
|
@Select("select * from asr_loc_detl where mat_no=#{mat_no}")
|
public List<LocDetailBean> getLocMatNoList(String mat_no);
|
|
/**
|
* 查询工作档中物料号是否存在
|
* @return
|
*/
|
@Select("select * from asr_wrk_detl where mat_no=#{mat_no}")
|
public List<WorkDetailBean> getWrkMatNoList(String mat_no);
|
}
|
