BillDetailMapper.java 3.88 KB
Newer Older
chase's avatar
chase committed
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 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128
package pwc.taxtech.atms.vat.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.session.RowBounds;
import pwc.taxtech.atms.MyVatMapper;
import pwc.taxtech.atms.dpo.BillDetailDto;
import pwc.taxtech.atms.vat.entity.BillDetail;
import pwc.taxtech.atms.vat.entity.BillDetailExample;

import java.math.BigDecimal;
import java.util.List;

@Mapper
public interface BillDetailMapper extends MyVatMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    long countByExample(BillDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    int deleteByExample(BillDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    int deleteByPrimaryKey(Long id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    int insert(BillDetail record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    int insertSelective(BillDetail record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    List<BillDetail> selectByExampleWithRowbounds(BillDetailExample example, RowBounds rowBounds);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    List<BillDetail> selectByExample(BillDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    BillDetail selectByPrimaryKey(Long id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    int updateByExampleSelective(@Param("record") BillDetail record, @Param("example") BillDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    int updateByExample(@Param("record") BillDetail record, @Param("example") BillDetailExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    int updateByPrimaryKeySelective(BillDetail record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table bill_detail
     *
     * @mbg.generated
     */
    int updateByPrimaryKey(BillDetail record);

    List<BillDetailDto> queryBillWithRevenueConf(
            @Param("billType") String billType,
            @Param("customer") String customer,
            @Param("billNumber") String billNumber,
            @Param("revenueCofId") Long revenueCofId,
            @Param("billContent") String billContent,
            @Param("department") String department,
            @Param("billTaxRat") BigDecimal billTaxRat,
            @Param("billDate") String  billDate,
            @Param("projectId") String projectId,
            @Param("period") Integer period,
            @Param("queryDate") String queryDate);

    List<String> queryBillTypeGroupBy(@Param("projectId") String projectId,
                                      @Param("period") Integer period);

}