| | |
|---|
| | | |
|---|
| | | |
|---|
| | | @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='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) |
|---|
| | | " 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,251,271) ")//and a.dept_id in (269,270,253,254,255,257) |
|---|
| | | List<TjOrderRemark> getRemarkListByTjNumAndType(String tjNumber); |
|---|
| | | |
|---|
| | | |
|---|
| | |
|---|
| | | @Select("call pro_lis_sqdbgd(0,#{tjnumber,mode=IN})") |
|---|
| | | // @Select("select * from test_remark") |
|---|
| | | List<TjOrderRemark> addHuaYanTable(@Param("tjnumber") String tjnumber); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Update("UPDATE tj_order_remark a SET a.type=2 WHERE a.tj_number=#{tjnumber} AND a.pro_id=#{proId}") |
|---|
| | | void updateTjOrderRemark(@Param("tjnumber")String tjnumber,@Param("proId")String proId); |
|---|
| | | } |
|---|
