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.pojo.StationBean;
|
|
@Repository
|
public interface StationDao {
|
|
/**
|
* 添加
|
* @param station
|
* @return
|
*/
|
@Insert("insert into asr_bas_devp(dev_no,dec_desc,in_enable,out_enable,ctn_type,barcode,gross_wt,modi_user,modi_time) "
|
+ " values(#{dev_no},#{dec_desc},#{in_enable},#{out_enable},#{ctn_type},#{barcode},#{gross_wt},#{modi_user},getdate())")
|
public int insertStation(StationBean station);
|
|
|
//分页查询所有信息
|
// @Select("select * from tb_dept ORDER BY dept_id desc LIMIT #{spage},#{epage}")
|
@Select("select top (#{epage}) * from asr_bas_devp where dev_no not in "
|
+ " (select top (#{spage}) dev_no from asr_bas_devp order by dev_no asc) order by dev_no asc")
|
public List<StationBean> queryStationList(@Param("spage")int spage,@Param("epage")int epage);
|
|
//统计所有数据总数量
|
@Select("select count(*) from asr_bas_devp")
|
public int getStationCount();
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from asr_bas_devp order by dev_no asc")
|
public List<StationBean> getStationList();
|
|
/**
|
* 根据id查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select * from asr_bas_devp where dev_no=#{id}")
|
public StationBean getStationById(int id);
|
|
// //更新
|
// @Update("update asr_bas_devp set dec_desc=#{dec_desc},wrk_no=#{wrk_no},in_enable=#{in_enable},out_enable=#{out_enable},ctn_type=#{ctn_type},"
|
// + " barcode=#{barcode},gross_wt=#{gross_wt},modi_user=#{modi_user},modi_time=getdate() "
|
// + " where dev_no=#{dev_no}")
|
//更新
|
@Update("update asr_bas_devp set dec_desc=#{dec_desc},wrk_no=#{wrk_no},in_enable=#{in_enable},out_enable=#{out_enable},"
|
+ " barcode=#{barcode},modi_user=#{modi_user},modi_time=getdate() "
|
+ " where dev_no=#{dev_no}")
|
public int upStation(StationBean station);
|
|
//根据id删除
|
@Delete("delete from asr_bas_devp where dev_no=#{id}")
|
public int delStationById(int id);
|
|
//删除所有站点
|
@Delete("delete from asr_bas_devp")
|
public int resetStation();
|
}
|
