CDSDsrcF.h 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. //---------------------------------------------------------------------------
  2. #ifndef CDSDsrcFH
  3. #define CDSDsrcFH
  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. #include "CDSObjectF.h"
  12. //---------------------------------------------------------------------------
  13. #include "CenterCommF.h"
  14. //---------------------------------------------------------------------------
  15. /*
  16. * Dsrc class
  17. */
  18. class TItsDsrc : public TCDSObject
  19. {
  20. public:
  21. TItsDsrc();
  22. virtual ~TItsDsrc();
  23. public:
  24. #if 0
  25. String CTLR_NMBR; // N NUMBER(10) N VMS 제어기 번호
  26. String CTLR_ID; // N VARCHAR2(10) Y VMS 제어기 ID
  27. String NAME; // N VARCHAR2(40) Y VMS 명칭
  28. String CTLR_IP; // N VARCHAR2(20) Y VMS 제어기 아이피
  29. int CTLR_PORT; // N NUMBER(5) Y 0 VMS 제어기 포트
  30. int CTLR_LOCAL_NO; // N NUMBER(5) Y 0 VMS 제어기 지역번호
  31. String TYPE_CD; // N VARCHAR2(7) Y VMS 유형 코드
  32. String ISTL_LCTN_NM; // N VARCHAR2(40) Y 설치 위치 명
  33. String ISTL_LCTN_ADDR; // N VARCHAR2(200) Y 설치 위치 주소
  34. double X_CRDN; // N NUMBER(11,8) Y X 좌표
  35. double Y_CRDN; // N NUMBER(10,8) Y Y 좌표
  36. String DEL_YN; // N CHAR(1) Y 'N' 삭제 여부
  37. #endif
  38. String ROAD_SPOT_ID;
  39. String LOG_CNNC_ID;
  40. String LOG_CNNC_PW;
  41. String MNFC_CMPY_CD;
  42. int CLCT_ABNR_BASI; //TODO: 세종시 추가
  43. public:
  44. INT_DSRC_STATE STATE;
  45. public:
  46. #if 0
  47. __property String DSRC_CTLR_NMBR = { read = CTLR_NMBR, write = CTLR_NMBR };
  48. __property String DSRC_CTLR_ID = { read = CTLR_ID, write = CTLR_ID };
  49. __property String DSRC_NM = { read = NAME, write = NAME };
  50. #endif
  51. };
  52. //---------------------------------------------------------------------------
  53. /*
  54. * Dsrc Manager
  55. */
  56. class TItsDsrcManager
  57. {
  58. public:
  59. TItsDsrcManager();
  60. virtual ~TItsDsrcManager();
  61. public:
  62. TItsMap<String, TItsDsrc*> FLists;
  63. public:
  64. bool LoadFromDb(TADOConnection *ADbConn=NULL);
  65. bool LoadStatusFromDb(TADOConnection *ADbConn=NULL);
  66. bool GetNextDsrcId(String &ANewId, TADOConnection *ADbConn=NULL);
  67. bool DeleteDsrc(TItsDsrc *AObj, TADOConnection *ADbConn=NULL);
  68. bool UpdateDsrc(String AOldRseId, TItsDsrc *AObj, TADOConnection *ADbConn=NULL);
  69. bool InsertDsrc(TItsDsrc *AObj, TADOConnection *ADbConn=NULL);
  70. bool UpdateClctAbnrBasi(int AClctAbnrBasi, TADOConnection *ADbConn=NULL);
  71. };
  72. //---------------------------------------------------------------------------
  73. extern TItsDsrcManager *ItsDsrcManager;
  74. //---------------------------------------------------------------------------
  75. #endif