ZyqxxService.java 2.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
  1. package com.cxfws.gkjcxx.service.impl;
  2. import java.util.ArrayList;
  3. import java.util.List;
  4. import javax.jws.WebMethod;
  5. import javax.jws.WebResult;
  6. import javax.jws.WebService;
  7. import javax.persistence.criteria.CriteriaBuilder;
  8. import javax.persistence.criteria.CriteriaQuery;
  9. import javax.persistence.criteria.Predicate;
  10. import javax.persistence.criteria.Root;
  11. import net.sf.json.JSONArray;
  12. import org.springframework.beans.factory.annotation.Autowired;
  13. import org.springframework.data.jpa.domain.Specification;
  14. import org.springframework.stereotype.Service;
  15. import com.cxfws.gkjcxx.service.IZyqxxService;
  16. import com.xt.jygl.common.BaseWebCtl;
  17. import com.xt.jygl.gkjcxx.zyq.dao.ZyqDao;
  18. import com.xt.jygl.gkjcxx.zyq.entity.ZyqEntity;
  19. import com.xtframe.sec.common.BaseEntity;
  20. import com.xtframe.sec.common.QueryService;
  21. import com.xtframe.util.StringUtils;
  22. /**
  23. *作业区信息查询
  24. */
  25. @Service("zyqWebService")
  26. @WebService(targetNamespace = "http://service.web.jsjty.com/", portName = "zyqWebServicePort", serviceName = "zyqWebService")
  27. public class ZyqxxService extends BaseWebCtl implements IZyqxxService{
  28. @Autowired
  29. private QueryService query;
  30. @Autowired
  31. private ZyqDao dao;
  32. /**
  33. * 根据所在港区,所在港口,所在地,作业区名称查询
  34. */
  35. @Override
  36. @WebMethod(operationName = "findZyq", action = "http://service.web.jsjty.com/findZyq")
  37. @WebResult(name = "result", targetNamespace = "http://service.web.jsjty.com/")
  38. public String findZyq(final String zyqmc, final String szgkid, final String szgqid, final String szdid) {
  39. if (!this.checkUser()){
  40. return BaseWebCtl.NOLOGIN;
  41. }
  42. //封装查询条件
  43. Specification<ZyqEntity> spec = new Specification<ZyqEntity>() {
  44. @Override
  45. public Predicate toPredicate(Root<ZyqEntity> root, CriteriaQuery<?> query, CriteriaBuilder cb) {
  46. List<Predicate> list = new ArrayList<Predicate>();
  47. if (StringUtils.isNotEmpty(zyqmc)) {
  48. list.add(cb.like(root.get("zyqmc").as(String.class), "%" + zyqmc + "%"));
  49. }
  50. if (StringUtils.isNotEmpty(szgkid)) {
  51. list.add(cb.like(root.get("szgk").get("id").as(String.class), "%" + szgkid + "%"));
  52. }
  53. if (StringUtils.isNotEmpty(szgqid)) {
  54. list.add(cb.like(root.get("szgq").get("id").as(String.class), "%" + szgqid + "%"));
  55. }
  56. if (StringUtils.isNotEmpty(szdid)) {
  57. list.add(cb.like(root.get("szd").get("id").as(String.class), "%" + szdid + "%"));
  58. }
  59. list.add(cb.notEqual(root.get("recordStatus").as(String.class), BaseEntity.RECORD_STATE_DELETE));
  60. return cb.and(list.toArray(new Predicate[] {}));
  61. }
  62. };
  63. List<ZyqEntity> zyqlist = query.findAll(spec, ZyqEntity.class);
  64. JSONArray jsons=JSONArray.fromObject(zyqlist);
  65. return jsons.toString();
  66. }
  67. /**
  68. * 根据id查询作业区
  69. */
  70. @Override
  71. public String findOne(String id) {
  72. ZyqEntity zyq = dao.findOne(id);
  73. JSONArray jsons=JSONArray.fromObject(zyq);
  74. return jsons.toString();
  75. }
  76. }