| | |
|---|
| | | }) |
|---|
| | | BigDecimal getLisPriceByTjNumAndInParentProId(@Param("tjNum") String tjNum, @Param("parentProId") List<String> parentProId); |
|---|
| | | |
|---|
| | | @Select({ |
|---|
| | | "<script>", |
|---|
| | | "SELECT SUM(now_price) FROM `tb_transition`", |
|---|
| | | "WHERE `tj_num` = #{tjNum}", |
|---|
| | | "AND `pro_id` IN", |
|---|
| | | "<foreach item='item' index='index' collection='proId' open='(' separator=',' close=')'>", |
|---|
| | | "#{item}", |
|---|
| | | "</foreach>", |
|---|
| | | "</script>" |
|---|
| | | }) |
|---|
| | | BigDecimal getLisPriceByTjNumAndInProId(@Param("tjNum") String tjNum, @Param("proId") List<Long> parentProId); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT GROUP_CONCAT(c.pro_name SEPARATOR ' ; ' ) FROM tj_package_project b JOIN tj_project c ON c.pro_id=b.pro_id\n" + |
|---|
