CDSVmsEvspF.h 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106
  1. //---------------------------------------------------------------------------
  2. #ifndef CDSVmsEvspFH
  3. #define CDSVmsEvspFH
  4. //---------------------------------------------------------------------------
  5. #include <Classes.hpp>
  6. #include <stdio.h>
  7. #include <ADODB.hpp>
  8. #include <DB.hpp>
  9. #include "ITSLibF.h"
  10. #include "ITSDbF.h"
  11. //---------------------------------------------------------------------------
  12. class TVmsEvspIfsc
  13. {
  14. public:
  15. TVmsEvspIfsc();
  16. ~TVmsEvspIfsc();
  17. public:
  18. int VMS_EVSP_ID;
  19. String IFSC_ID;
  20. int ORD;
  21. String IFSC_NM;
  22. };
  23. class TVmsEvspLink
  24. {
  25. public:
  26. TVmsEvspLink();
  27. ~TVmsEvspLink();
  28. public:
  29. int VMS_EVSP_ID;
  30. String LINK_ID;
  31. int ORD;
  32. String LINK_NM;
  33. };
  34. //---------------------------------------------------------------------------
  35. class TVmsEvsp
  36. {
  37. public:
  38. TVmsEvsp();
  39. ~TVmsEvsp();
  40. private:
  41. bool FCompleted;
  42. int FEditMode;
  43. int FGridIndex;
  44. String FMEM_DEL;
  45. public:
  46. int VMS_EVSP_ID; //NUMBER(10) N VMS 긴급차량우선신호구간 ID
  47. String VMS_EVSP_NM; ///VARCHAR2(60) Y VMS 긴급차량우선신호구간 명
  48. String DSPL_STRT_NODE_NM; //VARCHAR2(30) Y 표출 시작 노드 명
  49. String DSPL_END_NODE_NM; //VARCHAR2(30) Y 표출 종료 노드 명
  50. int DETR_ID; //NUMBER(10) Y 우회도로 ID
  51. String USE_YN; //CHAR(1) Y 사용 여부
  52. String ROAD_NM; //VARCHAR2(30) Y 도로명
  53. String SPOT_NM; //VARCHAR2(30) Y 지점명
  54. String AXIS_YN; //CHAR(1) Y 'N' 축정보 생성용
  55. String DEL_YN;
  56. public:
  57. TItsMap<int, TVmsEvspLink*> FLists;
  58. public:
  59. __property bool Completed = {read = FCompleted, write = FCompleted};
  60. __property int EditMode = {read = FEditMode, write = FEditMode };
  61. __property int GridIndex = {read = FGridIndex, write = FGridIndex };
  62. __property String MEM_DEL = {read = FMEM_DEL, write = FMEM_DEL };
  63. };
  64. //---------------------------------------------------------------------------
  65. class TVmsEvspManager
  66. {
  67. public:
  68. TVmsEvspManager();
  69. ~TVmsEvspManager();
  70. private:
  71. public:
  72. TItsMap<int, TVmsEvsp*> FLists;
  73. public:
  74. bool LoadFromDb(TADOConnection *ADbConn=NULL);
  75. bool LoadSubFromDb(TADOConnection *ADbConn=NULL);
  76. bool GetNextVmsEvspId(int &AEvspId, TADOConnection *ADbConn=NULL);
  77. bool DeleteVmsEvsp(TVmsEvsp *AObj, TADOConnection *ADbConn=NULL);
  78. bool InsertVmsEvsp(TVmsEvsp *AObj, TADOConnection *ADbConn=NULL);
  79. bool UpdateVmsEvsp(TVmsEvsp *AObj, TADOConnection *ADbConn=NULL);
  80. bool MergeVmsEvsp(TVmsEvsp *AObj, TADOConnection *ADbConn=NULL);
  81. };
  82. //---------------------------------------------------------------------------
  83. extern TVmsEvspManager *VmsEvspManager;
  84. //---------------------------------------------------------------------------
  85. #endif