| | |
|---|
| | | "</script>" |
|---|
| | | }) |
|---|
| | | BigDecimal getLisPriceByTjNumAndInParentProId(@Param("tjNum") String tjNum, @Param("parentProId") List<String> 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" + |
|---|
| | | "\n" + |
|---|
| | | "WHERE b.pro_id IN(SELECT DISTINCT a.parent_pro_id FROM tb_transition a WHERE a.cus_id=#{idCard} AND ISNULL(a.tj_num))" + |
|---|
| | | "AND b.pac_id=#{pacId}") |
|---|
| | | String panduantaocanshifouchongfu(@Param("idCard") String idCard,@Param("pacId") Long pacId); |
|---|
| | | } |
|---|
