| | |
|---|
| | | "LEFT JOIN sys_dept c ON c.dept_id=b.dept_id \n" + |
|---|
| | | " WHERE a.deleted=0 AND a.order_id=#{orderId} and b.pro_parent_id = 0 AND c.org_type=1") |
|---|
| | | List<TjOrderDetail> getCaiYangDengJi(Long orderId); |
|---|
| | | |
|---|
| | | @Select("SELECT a.* FROM tj_order_detail a LEFT JOIN tj_project b ON a.pro_id=b.pro_id \n" + |
|---|
| | | "LEFT JOIN sys_dept c ON c.dept_id=b.dept_id \n" + |
|---|
| | | " WHERE a.deleted=0 AND a.order_id=#{orderId} and b.pro_parent_id = 0 AND c.org_type=1 AND a.jxbz = #{jxbz}") |
|---|
| | | List<TjOrderDetail> getCaiYangDengJiJxbz(@Param("orderId") Long orderId,@Param("jxbz") String jxbz); |
|---|
| | | } |
|---|
