CDSAtrdF.h 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  1. //---------------------------------------------------------------------------
  2. #ifndef CDSAtrdFH
  3. #define CDSAtrdFH
  4. //---------------------------------------------------------------------------
  5. #include <Classes.hpp>
  6. #include <ADODB.hpp>
  7. #include <DB.hpp>
  8. #include "cxCustomData.hpp"
  9. #include "LibSTLF.hpp"
  10. //---------------------------------------------------------------------------
  11. /*
  12. * TItsAtrdRoad class
  13. */
  14. class TItsAtrdRoad
  15. {
  16. public:
  17. TItsAtrdRoad();
  18. virtual ~TItsAtrdRoad();
  19. void Clear();
  20. private:
  21. bool FCompleted;
  22. int FEditMode;
  23. int FGridIndex;
  24. public:
  25. String ATRD_ID; //VARCHAR2(10) N 간선도로 ID
  26. String ROAD_ID; //NUMBER(10) N 도로 ID
  27. int ORD; //NUMBER(3) Y 0 순서
  28. String MEM_DEL;
  29. public:
  30. __property bool Completed = {read = FCompleted, write = FCompleted};
  31. __property int EditMode = {read = FEditMode, write = FEditMode };
  32. __property int GridIndex = {read = FGridIndex, write = FGridIndex };
  33. };
  34. //---------------------------------------------------------------------------
  35. /*
  36. * Atrd class
  37. */
  38. class TItsAtrd
  39. {
  40. public:
  41. TItsAtrd();
  42. virtual ~TItsAtrd();
  43. void Clear();
  44. private:
  45. bool FCompleted;
  46. int FEditMode;
  47. int FGridIndex;
  48. public:
  49. String ATRD_ID; //VARCHAR2(10) N 간선도로 ID
  50. String ATRD_NM; //VARCHAR2(30) Y 간선도로 명
  51. String DRCT_CD; //VARCHAR2(7) Y 방향 코드
  52. String AREA_CD; //VARCHAR2(7) Y 지역 코드
  53. String DEL_YN; //CHAR(1) Y 'N' 삭제 여부
  54. String DRCT_NM; //VARCHAR2(50) Y 방향 명칭
  55. String MEM_DEL;
  56. int LENGTH;
  57. IntMap<TItsAtrdRoad> FSubLists;
  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. };
  63. //---------------------------------------------------------------------------
  64. class TItsAtrdName
  65. {
  66. public:
  67. TItsAtrdName() { RowNo = 0; };
  68. virtual ~TItsAtrdName() {};
  69. public:
  70. String Name;
  71. int RowNo;
  72. bool IsUpAtrd;
  73. bool IsDnAtrd;
  74. String UpAtrdId;
  75. String DnAtrdId;
  76. String UpAtrdNm;
  77. String DnAtrdNm;
  78. };
  79. /*
  80. * Atrd Manager
  81. */
  82. class TItsAtrdManager
  83. {
  84. public:
  85. TItsAtrdManager();
  86. virtual ~TItsAtrdManager();
  87. public:
  88. ListMap<TItsAtrd> FLists;
  89. ListMap<TItsAtrdName> FNameLists;
  90. public:
  91. bool LoadFromDb(TADOConnection *ADbConn=NULL);
  92. bool LoadFromAtrdDb(TADOConnection *ADbConn=NULL);
  93. bool LoadFromAtrdRoadDb(TADOConnection *ADbConn=NULL);
  94. bool LoadAtrdLength(TADOConnection *ADbConn=NULL);
  95. bool DeleteAtrdRoad(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
  96. bool InsertAtrdRoad(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
  97. bool DeleteAtrd(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
  98. bool UpdateAtrd(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
  99. bool InsertAtrd(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
  100. };
  101. //---------------------------------------------------------------------------
  102. extern TItsAtrdManager *ItsAtrdManager;
  103. //---------------------------------------------------------------------------
  104. #endif