MdoMapper.java 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. package com.miniframe.model.mdo.dao;
  2. import org.apache.ibatis.annotations.Mapper;
  3. import org.apache.ibatis.annotations.Select;
  4. import org.apache.poi.ss.formula.functions.T;
  5. import java.util.List;
  6. public interface MdoMapper extends Mapper {
  7. /**
  8. * fsi 输入参数查询 FFD,TACS,ADFLOW
  9. * @param pid
  10. * @return
  11. */
  12. @Select("select DISTINCT uid from mdo_project_variate where pid =#{pid} and comtype in(2,3,5)")
  13. public List<String> selectFsiVuids(String pid );
  14. @Select("select DISTINCT uid from mdo_project_constraint where pid =#{pid} and comtype in(2,3,5)")
  15. public List<String> selectFsiCuids(String pid );
  16. @Select("select DISTINCT uid from mdo_project_objfun where pid =#{pid} and comtype in(2,3,5)")
  17. public List<String> selectFsiOuids(String pid );
  18. /**
  19. * xfoil 输入参数查询 CST,XFOIL
  20. * @param pid
  21. * @return
  22. */
  23. @Select("select DISTINCT uid from mdo_project_variate where pid =#{pid} and comtype in(0,1)")
  24. public List<String> selectXfoilVuids(String pid );
  25. @Select("select DISTINCT uid from mdo_project_constraint where pid =#{pid} and comtype in(0,1)")
  26. public List<String> selectXfoilCuids(String pid );
  27. @Select("select DISTINCT uid from mdo_project_objfun where pid =#{pid} and comtype in(0,1)")
  28. public List<String> selectXfoilOuids(String pid );
  29. /**
  30. * adflow 输入参数查询 FFD,ADFLOW
  31. * @param pid
  32. * @return
  33. */
  34. @Select("select DISTINCT uid from mdo_project_variate where pid =#{pid} and comtype in(2,3)")
  35. public List<String> selectAdflowVuids(String pid );
  36. @Select("select DISTINCT uid from mdo_project_constraint where pid =#{pid} and comtype in(2,3)")
  37. public List<String> selectAdflowCuids(String pid );
  38. @Select("select DISTINCT uid from mdo_project_objfun where pid =#{pid} and comtype in(2,3)")
  39. public List<String> selectAdflowOuids(String pid );
  40. /**
  41. * 查询所有 out param
  42. * @param pid
  43. * @return
  44. */
  45. @Select("select DISTINCT uid from mdo_project_constraint where pid =#{pid} " +
  46. "UNION " +
  47. "select DISTINCT uid from mdo_project_objfun where pid =#{pid} ")
  48. public List<String> selectAllOutUid(String pid);
  49. }