| | |
| | | |
| | | /** |
| | | * 获取ebom信息 |
| | | * @param parentOid 上级信息 |
| | | * @param productNo 产品编号 |
| | | * @param productOid 产品主键 |
| | | * @param parentOid 上级零件主键 |
| | | * @return |
| | | */ |
| | | @VciUnCheckRight |
| | |
| | | baseResult.setCode(200); |
| | | return baseResult; |
| | | } |
| | | |
| | | /** |
| | | * 获取下级零件信息 |
| | | * @param productOid 产品主键 |
| | | * @param parentOid 上级零件主键 |
| | | * @return |
| | | */ |
| | | @VciUnCheckRight |
| | | @GetMapping("/getChildInfo") |
| | | public BaseResult getChildInfo(String productOid, String parentOid){ |
| | | if(StringUtils.isBlank(productOid)){ |
| | | return BaseResult.fail("产品主键为空!"); |
| | | } |
| | | if(StringUtils.isBlank(parentOid)){ |
| | | return BaseResult.fail("零件上级主键为空!"); |
| | | } |
| | | String sql = "select p.*,e.oid as eoid from platformbtm_part p left join platformlt_ebom e on p.oid = e.t_oid \n" + |
| | | "where e.f_oid = '"+parentOid+"' and e.workcontextoid = '"+productOid+"' \n" + |
| | | "and p.islastr = '1' and p.islastv = '1' order by p.code asc"; |
| | | List<Map> ebomList = boServiceI.queryByOnlySqlForMap(sql); |
| | | BaseResult baseResult = new BaseResult(); |
| | | baseResult.setData(ebomList); |
| | | baseResult.setSuccess(true); |
| | | return baseResult; |
| | | } |
| | | |
| | | /** |
| | | * 获取零件实例信息 |
| | | * @param productOid 产品主键 |
| | | * @param partOid 零件主键 |
| | | * @param eoid 树节点上的扩展属性eoid的值 |
| | | * @return |
| | | */ |
| | | @VciUnCheckRight |
| | | @GetMapping("/getPartInstance") |
| | | public BaseResult getPartInstance(String productOid, String partOid, String eoid){ |
| | | if(StringUtils.isBlank(productOid)){ |
| | | return BaseResult.fail("产品主键为空!"); |
| | | } |
| | | if(StringUtils.isBlank(partOid)){ |
| | | return BaseResult.fail("零件主键为空!"); |
| | | } |
| | | if(StringUtils.isBlank(eoid)){ |
| | | return BaseResult.fail("EBOM关系主键为空!"); |
| | | } |
| | | String sql = "select t.* from platformbtm_partinstance t where t.partoid = '"+partOid+"' \n" + |
| | | "and t.workcontextoid = '"+productOid+"' and t.ebomoid = '"+eoid+"'"; |
| | | List<Map> mapList = boServiceI.queryByOnlySqlForMap(sql); |
| | | BaseResult baseResult = new BaseResult(); |
| | | baseResult.setData(mapList); |
| | | baseResult.setSuccess(true); |
| | | return baseResult; |
| | | } |
| | | |
| | | /** |
| | | * 获取零件基本信息 |
| | | * @param partOid 零件主键 |
| | | * @return |
| | | */ |
| | | @GetMapping("/getPartInfo") |
| | | public BaseResult getPartInfo(String partOid){ |
| | | if(StringUtils.isBlank(partOid)){ |
| | | return BaseResult.fail("零件主键为空!"); |
| | | } |
| | | String sql = "select * from platformbtm_part where oid = '"+partOid+"'"; |
| | | List<Map> mapList = boServiceI.queryByOnlySqlForMap(sql); |
| | | BaseResult baseResult = new BaseResult(); |
| | | baseResult.setData(mapList); |
| | | baseResult.setSuccess(true); |
| | | return baseResult; |
| | | } |
| | | } |