| | |
|---|
| | | @Update("update fd_xstdmx set tdmx_ggxh=#{tdmx_ggxh} where tdmx_tdfl=#{tdmx_tdfl}") |
|---|
| | | public int updateMXGG(Fd_XSTDMX mx); |
|---|
| | | |
|---|
| | | //明晟 LED 装车 |
|---|
| | | @Select({"select hw.name tdmx_hwmc,mx.* from fd_xstdmx mx " , |
|---|
| | | " left join nc_hw hw on mx.tdmx_hwbh=hw.pkid and hw.state=1 " , |
|---|
| | | " join fd_bsheet on bsNo=tdmx_fdywbh and status='在办' where SdepartNo=#{sdepartNo} " |
|---|
| | | " join xs_taskmonitor xt on mx.tdmx_fdywbh = xt.businessNo ", |
|---|
| | | " join fd_bsheet on bsNo=tdmx_fdywbh and status='在办' " , |
|---|
| | | " where SdepartNo=#{sdepartNo} and xt.firstgbtime is not null and xt.lastgbtime is null" |
|---|
| | | }) |
|---|
| | | public List<Map> getHwList(String sdepartNo); |
|---|
| | | |
|---|
| | | /** 义瑞、科技LED显示 序号 车号 装车区 状态 **/ |
|---|
| | | @Select({ |
|---|
| | | "select bs.numberplates,businessNo,zcWz,firstzxhtime," , |
|---|
| | | "case WHEN EXISTS ( SELECT * FROM bussinessitems WHERE bussinessNo = x.businessNo ) THEN '在装'" , |
|---|
| | | " when x.firstgbtime is not null then '待装' else '完成' end zcStatus " , |
|---|
| | | " from xs_taskmonitor x" , |
|---|
| | | " join bussinesssheet bs on x.businessNo=bs.bussinessNo and bs.sstatus='在办' " , |
|---|
| | | " where sdepartNo=#{sdepartNo} and firstgbtime is not null and x.lastgbtime is null order by jctime" |
|---|
| | | }) |
|---|
| | | public List<Map> yRZcList(String sdepartNo); |
|---|
| | | |
|---|
| | | } |
|---|
