| | |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM tj_order_remark a LEFT JOIN tj_project b ON a.pro_id=b.pro_id WHERE a.tj_number=#{tjNumber}" + |
|---|
| | | " AND a.type =1 AND a.deleted=0 AND b.need_report='N' AND b.deleted=0") |
|---|
| | | " AND a.type =1 AND a.deleted=0 AND b.need_report='Y' AND b.deleted=0 and a.dept_id in (269,270,253,254,255,257) ")//and a.dept_id in (269,270,253,254,255,257) |
|---|
| | | List<TjOrderRemark> getRemarkListByTjNumAndType(String tjNumber); |
|---|
| | | |
|---|
| | | |
|---|
| | |
|---|
| | | "\tLEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" + |
|---|
| | | "\tLEFT JOIN sys_user us ON us.user_id = re.doctor_name \n" + |
|---|
| | | "WHERE\n" + |
|---|
| | | "\tre.type != 2 and pro.need_report='Y' \n" + |
|---|
| | | "\tre.type != 2 \n" +//and pro.need_report='Y' |
|---|
| | | "\tAND re.tj_number =#{tjNumber}") |
|---|
| | | List<CsProVo> cSWebGetProByTjNumAndOrderId(String tjNumber); |
|---|
| | | |
|---|
