package com.slcf.dao;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import com.slcf.pojo.AdjDetailBean;
|
|
@Repository
|
public interface AdjDetailDao {
|
|
/**
|
* 添加
|
* @param adjDetail
|
* @return
|
*/
|
@Insert("insert into asr_adj_detl(loc_no,mat_no,qty,ctns,wt,memo,modi_user,modi_time, "
|
+ " s_qty,s_ctns,s_wt,adj_qty,adj_ctns,adj_wt) "
|
+ " values(#{loc_no},#{mat_no},#{qty},#{ctns},#{wt},#{memo},#{modi_user},getdate(), "
|
+ " #{s_qty},#{s_ctns},#{s_wt},#{adj_qty},#{adj_ctns},#{adj_wt})"
|
)
|
public int insertAdjDetail(AdjDetailBean adjDetail);
|
|
//分页查询所有信息
|
// @Select("select top (#{epage}) * from asr_adj_detl where loc_no not in "
|
// @Select("select top (#{epage}) a.*,b.loc_desc loc_sts_name from asr_adj_detl a,asr_bas_loc_type b where a.loc_sts=b.loc_sts and loc_no not in "
|
// + " (select top (#{spage}) loc_no from asr_adj_detl order by loc_no asc) order by loc_no asc")
|
// public List<AdjDetailBean> queryLocationList(@Param("spage")int spage,@Param("epage")int epage);
|
// public List<AdjDetailBean> queryAdjDetailList(AdjDetailCondition adjDetailCon);
|
|
// //统计所有数据总数量
|
// @Select("select count(*) from asr_adj_detl")
|
// public int getLocationCount();
|
|
//根据过滤条件统计总数量
|
// public int getAdjDetailCount(AdjDetailCondition adjDetailCon);
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from asr_adj_detl order by adj_id desc")
|
public List<AdjDetailBean> getAdjDetailList();
|
|
/**
|
* 根据id查询信息
|
* @param id
|
* @return
|
*/
|
@Select("select * from asr_adj_detl where adj_id=#{id}")
|
public AdjDetailBean getAdjDetailById(int id);
|
|
// //更新
|
// @Update("update asr_adj_detl set mat_no=#{mat_no},qty=#{qty},ctns=#{ctns},wt=#{wt},memo=#{memo},modi_user=#{modi_user},modi_time=getdate(), "
|
// + " bystr1=#{bystr1}, bystr2=#{bystr2},bystr3=#{bystr3},bystr4=#{bystr4},bystr5=#{bystr5}, "
|
// + " bynum1=#{bynum1}, bynum2=#{bynum2},bynum3=#{bynum3},bynum4=#{bynum4},bynum5=#{bynum5} "
|
// + " where loc_no=#{loc_no}")
|
// public int upAdjDetail(AdjDetailBean adjDetail);
|
|
// //根据id删除工作信息
|
// @Delete("delete from asr_adj_detl where loc_no=#{id}")
|
// public int delAdjDetailById(int id);
|
}
|
