| | |
| | | // 保存订单明细历史档 |
| | | int saveOrderDetlLog = jdbcTemplate.update("insert into man_order_detl_log select * from man_order_detl where order_id=" + order.getId()); |
| | | if (saveOrderDetlLog == 0) { |
| | | throw new CoolException("保存订单历史档失败"); |
| | | throw new CoolException("保存订单明细历史档失败"); |
| | | } |
| | | // 删除订单 |
| | | int delOrder = jdbcTemplate.update("delete from man_order where id=" + order.getId()); |
| | |
| | | List<Map<String, Object>> retentionList = jdbcTemplate.queryForList("select top 7 CONVERT(decimal, DATEDIFF(second, man_loc_detl.create_time, GETDATE()) / 86400.0, 9) AS stayDays, * from man_loc_detl order by create_time desc"); |
| | | for (int i=0;i<retentionList.size();i++) { |
| | | retentionList.get(i).put("no", i+1); |
| | | Object create_time = combList.get(i).get("create_time"); |
| | | Object create_time = retentionList.get(i).get("create_time"); |
| | | retentionList.get(i).put("createTime", String.valueOf(create_time).substring(0, 11)); |
| | | } |
| | | |
| | |
| | | public Pakout() {} |
| | | |
| | | public Pakout(String wrkNo,Long wrkSts,String zpallet,Double anfme,Long nodeId,String locNo,String matnr,String maktx,String name,String specs,String model,String batch,String unit,String barcode,Long docId,String docNum,String custName,Integer itemNum,Integer count,Double weight,Integer status,Long createBy,Date createTime,Long updateBy,Date updateTime,String memo) { |
| | | this.wrkNo = wrkNo; |
| | | this.wrkSts = wrkSts; |
| | | this.zpallet = zpallet; |
| | | this.anfme = anfme; |
| | |
| | | <!-- 导航栏 --> |
| | | <ul class="nav"> |
| | | <li><a id="pakin" onclick="nav(this.id)" class="nav-select" href="#">入库</a></li> |
| | | <li><a id="pakout" onclick="nav(this.id)" class="nav-unselect" href="#">出库</a></li> |
| | | <!-- <li><a id="pakout" onclick="nav(this.id)" class="nav-unselect" href="#">出库</a></li>--> |
| | | <li><a id="stockOut" onclick="nav(this.id)" class="nav-unselect" href="#">拣货</a></li> |
| | | <li><a id="stockCheck" onclick="nav(this.id)" class="nav-unselect" href="#">盘点</a></li> |
| | | <!-- <li><a id="comb" onclick="nav(this.id)" class="nav-unselect" href="#">组托</a></li>--> |
| | | <!-- <li><a id="stockIn" onclick="nav(this.id)" class="nav-unselect" href="#">上架</a></li>--> |
| | | <li><a id="comb" onclick="nav(this.id)" class="nav-unselect" href="#">组托</a></li> |
| | | <li><a id="stockIn" onclick="nav(this.id)" class="nav-unselect" href="#">上架</a></li> |
| | | </ul> |
| | | |
| | | <!-- 主体内容 --> |