| | |
|---|
| | | void csymxmxzqtyybcjk(@Param("tjh")String tjNum,@Param("xmid") String proId,@Param("yy") String yy, |
|---|
| | | @Param("kslx") String orgType,@Param("czy") String czy,@Param("czydm") String czydm); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("call newpacsJianChaData(#{tjnumber,mode=IN},0)") |
|---|
| | | List<TjOrderRemark> newpacsJianChaData(String tjnumber); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select(" SELECT CONCAT(CONCAT('共',COUNT(*),'项'),': '," + |
|---|
| | | "TRIM(GROUP_CONCAT(b.pro_name ORDER BY b.pro_name SEPARATOR ' | '))) AS xmm" + |
|---|
| | | " FROM tj_order_remark a LEFT JOIN tj_project b ON b.pro_id=a.pro_id" + |
|---|
| | | " WHERE a.tj_number=#{tjNumber} AND a.type !=2 AND a.deleted=0") |
|---|
| | | String getTjxm(String tjNumber); |
|---|
| | | } |
|---|
