科技LED、公司简称

hjg

2023-11-22 975c04c0181b3da82a79cb04abe6a2f1799eb363

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
package com.mandi.fendan.mapper;
 
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 com.mandi.fendan.persist.Fd_Bsheetitem;
 
 
 
 
 
public interface Fd_BsheetitemMapper {
    @Select("select a.* from fd_sheetitem a where a.id=#{id}")
    public Fd_Bsheetitem getbyId(String id);
    @Select("select top 1 *  from fd_sheetitem where tdmx_tdls=#{tdmx_tdls} and tdmx_tdfl=#{tdmx_tdfl} and tdmx_tdbh=#{tdmx_tdbh} order by ctime desc ")
    public Fd_Bsheetitem getbyLsandFl(@Param("tdmx_tdls")String tdmx_tdls,@Param("tdmx_tdfl")String tdmx_tdfl,@Param("tdmx_tdbh") String tdmx_tdbh);
    @Select("select top 1 *  from fd_sheetitem where barcode=#{barcode} and tdmx_fdywbh=#{tdmx_fdywbh}  order by ctime desc ")
    public Fd_Bsheetitem getbyNoandCode(@Param("barcode")String barcode,@Param("tdmx_fdywbh")String tdmx_fdywbh);
    @Select("select top 1 *  from fd_sheetitem where tdmx_pch=#{tdmx_pch} and tdmx_fdywbh=#{tdmx_fdywbh}  order by ctime desc ")
    public Fd_Bsheetitem getbypchandNo(@Param("tdmx_fdywbh")String tdmx_fdywbh,@Param("tdmx_pch")String pch);
    
    @Delete("delete  from fd_sheetitem where id=#{id}")
    public int delbyId(String id);
    @Delete("delete  from fd_sheetitem where tdmx_tdls=#{tdmx_tdls} and tdmx_tdfl=#{tdmx_tdfl} and tdmx_tdbh=#{tdmx_tdbh} ")
    public int delbyLsandFl(@Param("tdmx_tdls")String tdmx_tdls,@Param("tdmx_tdfl")String tdmx_tdfl,@Param("tdmx_tdbh") String tdmx_tdbh);
    @Delete("delete  from fd_sheetitem where tdmx_tdbh=#{tdmx_tdbh}")
    public int delbyTDNo(String tdmx_tdbh);
    @Delete("delete  from fd_sheetitem where tdmx_tdbh=#{tdmx_tdbh} and tdmx_cph=#{tdmx_cph} and tdmx_fdywbh=#{tdmx_fdywbh}")
    public int delbyTDNoandVhId(@Param("tdmx_tdbh") String tdmx_tdbh,@Param("tdmx_cph") String tdmx_cph,@Param("tdmx_fdywbh") String tdmx_fdywbh);
    @Delete("delete  from fd_sheetitem where tdmx_fdywbh=#{tdmx_fdywbh} ")
    public int delbyBsNo(@Param("tdmx_fdywbh") String tdmx_fdywbh);
    
    @Select("select * from fd_sheetitem where tdmx_fdywbh=#{tdmx_fdywbh}")
    public List<Fd_Bsheetitem> getlistbyNo(String tdmx_fdywbh);
    
    @Update("update fd_sheetitem set companyName=#{companyName},companyNo=#{companyNo},"
            + "createName=#{createName},createid=#{createid},ctime=#{ctime},barcode=#{barcode},tdmx_wlbh=#{tdmx_wlbh},"
            + "tdmx_wlmc=#{tdmx_wlmc},tdmx_tdfl=#{tdmx_tdfl},tdmx_tdls=#{tdmx_tdls},tdmx_hjzt=#{tdmx_hjzt},tdmx_dwmc=#{tdmx_dwmc},tdmx_pch=#{tdmx_pch},"
            + "tdmx_bhse=#{tdmx_bhse},tdmx_mz=#{tdmx_mz},tdmx_pz=#{tdmx_pz},"
            + "tdmx_jz=#{tdmx_jz},tdmx_shdw=#{tdmx_shdw},tdmx_fhdw=#{tdmx_fhdw},tdmx_tdlx=#{tdmx_tdlx},"
            + "tdmx_sl=#{tdmx_sl},tdmx_ggxh=#{tdmx_ggxh},tdmx_hwbh=#{tdmx_hwbh},"
            + "tdmx_zpbz=#{tdmx_zpbz},tdmx_sfzc=#{tdmx_sfzc},tdmx_fdbz=#{tdmx_fdbz},tdmx_cph=#{tdmx_cph},"
            + "tdmx_zccph=#{tdmx_zccph},tdmx_fdywbh=#{tdmx_fdywbh},tdmx_tdbh=#{tdmx_tdbh} where id=#{id}")
    public int update(Fd_Bsheetitem fd_bsheetitem);
    
    
    @Insert("insert into fd_sheetitem("
            + "id,companyName,companyNo,createName,createid,ctime,barcode,tdmx_wlbh,"
            + "tdmx_wlmc,tdmx_tdfl,tdmx_tdls,tdmx_hjzt,tdmx_dwmc,tdmx_pch,"
            + "tdmx_bhse,tdmx_mz,tdmx_pz,tdmx_jz,tdmx_shdw,tdmx_fhdw,tdmx_tdlx,"
            + "tdmx_sl,tdmx_ggxh,tdmx_hwbh,tdmx_zpbz,tdmx_sfzc,tdmx_fdbz,tdmx_cph,"
            + "tdmx_zccph,tdmx_fdywbh,tdmx_tdbh) values "
            + "(#{id},#{companyName},#{companyNo},#{createName},#{createid},#{ctime},#{barcode},#{tdmx_wlbh},"
            + "#{tdmx_wlmc},#{tdmx_tdfl},#{tdmx_tdls},#{tdmx_hjzt},#{tdmx_dwmc},#{tdmx_pch},"
            + "#{tdmx_bhse},#{tdmx_mz},#{tdmx_pz},#{tdmx_jz},#{tdmx_shdw},#{tdmx_fhdw},#{tdmx_tdlx},"
            + "#{tdmx_sl},#{tdmx_ggxh},#{tdmx_hwbh},#{tdmx_zpbz},#{tdmx_sfzc},#{tdmx_fdbz},#{tdmx_cph},"
            + "#{tdmx_zccph},#{tdmx_fdywbh},#{tdmx_tdbh})")
    public int insert(Fd_Bsheetitem fd_bsheetitem);
}