//---------------------------------------------------------------------------

#ifndef CDSAtrdFH
#define CDSAtrdFH
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <ADODB.hpp>
#include <DB.hpp>
#include "cxCustomData.hpp"
#include "LibSTLF.hpp"
//---------------------------------------------------------------------------


/*
*  TItsAtrdRoad class
*/
class TItsAtrdRoad
{
public:
    TItsAtrdRoad();
    virtual ~TItsAtrdRoad();
    void Clear();
private:
    bool    FCompleted;
    int     FEditMode;
	int     FGridIndex;

public:

    String ATRD_ID;     //VARCHAR2(10)	N			°£¼±µµ·Î ID
    String ROAD_ID;     //NUMBER(10)	N			µµ·Î ID
    int    ORD;         //NUMBER(3)	Y	0		¼ø¼­
    String MEM_DEL;

public:
    __property bool   Completed = {read = FCompleted, write = FCompleted};
	__property int    EditMode  = {read = FEditMode,  write = FEditMode };
	__property int    GridIndex = {read = FGridIndex, write = FGridIndex };
};
//---------------------------------------------------------------------------

/*
*  Atrd class
*/
class TItsAtrd
{
public:
    TItsAtrd();
    virtual ~TItsAtrd();
    void Clear();
private:
    bool    FCompleted;
    int     FEditMode;
	int     FGridIndex;

public:

    String ATRD_ID;     //VARCHAR2(10)	N			°£¼±µµ·Î ID
    String ATRD_NM;     //VARCHAR2(30)	Y			°£¼±µµ·Î ¸í
    String DRCT_CD;     //VARCHAR2(7)	Y			¹æÇâ ÄÚµå
    String AREA_CD;     //VARCHAR2(7)	Y			Áö¿ª ÄÚµå
    String DEL_YN;      //CHAR(1)	    Y	'N'		»èÁ¦ ¿©ºÎ
    String DRCT_NM;     //VARCHAR2(50)	Y			¹æÇâ ¸íĪ
    String MEM_DEL;

    int    LENGTH;

    IntMap<TItsAtrdRoad>   FSubLists;
    
public:
    __property bool   Completed = {read = FCompleted, write = FCompleted};
	__property int    EditMode  = {read = FEditMode,  write = FEditMode };
	__property int    GridIndex = {read = FGridIndex, write = FGridIndex };
};
//---------------------------------------------------------------------------

class TItsAtrdName
{
public:
    TItsAtrdName() { RowNo = 0; };
    virtual ~TItsAtrdName() {};
public:
    String  Name;
    int     RowNo;
    bool    IsUpAtrd;
    bool    IsDnAtrd;
    String  UpAtrdId;
    String  DnAtrdId;
    String  UpAtrdNm;
    String  DnAtrdNm;
};

/*
* Atrd Manager
*/
class TItsAtrdManager
{
public:
    TItsAtrdManager();
    virtual ~TItsAtrdManager();

public:
    ListMap<TItsAtrd>       FLists;
    ListMap<TItsAtrdName>   FNameLists;

public:
    bool LoadFromDb(TADOConnection *ADbConn=NULL);
    bool LoadFromAtrdDb(TADOConnection *ADbConn=NULL);
    bool LoadFromAtrdRoadDb(TADOConnection *ADbConn=NULL);
    bool LoadAtrdLength(TADOConnection *ADbConn=NULL);

    bool DeleteAtrdRoad(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
    bool InsertAtrdRoad(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
    bool DeleteAtrd(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
    bool UpdateAtrd(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
    bool InsertAtrd(TItsAtrd *AObj, TADOConnection *ADbConn=NULL);
};
//---------------------------------------------------------------------------
extern TItsAtrdManager *ItsAtrdManager;
//---------------------------------------------------------------------------

#endif