| | |
|---|
| | | |
|---|
| | | @Select("SELECT count(*) FROM tj_order WHERE tj_number = #{tjNum}") |
|---|
| | | int getOrderCountByTjNum(String tjNum); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | //存储过程专用接口(总检) |
|---|
| | | List<List<?>> getEsjCunChuGuoChengCustomerList(Map<String,Object> map); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM tj_order WHERE tj_number = card_id ") |
|---|
| | | List<TjOrder> getOrderListBypiliangqiandaofasong(); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT COUNT(*) FROM tj_order a WHERE a.deleted=0 AND " + |
|---|
| | | "(a.firm_id=#{compId} OR a.team_no=#{teamNo}) AND a.pac_id=#{pacId}") |
|---|
| | | Integer getTjTeamSelectRecordCount(@Param("teamNo") String teamNo,@Param("compId") String compId,@Param("pacId") String pacId); |
|---|
| | | } |
|---|
