#pragma once
#include "DAO.h"

namespace DBPlatformSpace
{
	/// 2D ∫·œÚ∞º‹
	class D2_TransPanelDAO :	public subDBDAO
	{
	public:
		int   		_appID;				///<∞º‹±‡∫≈
		string		_description;		///<∞º‹√Ë ˆ
		int   		_geomID;			///<À˘ Ù∂‡±fl–Œid
		string		_geometryIDs;		///<º∏∫ŒIDs
		string		_longPanelInIDs;	///<ƒ⁄±flΩÁ◊›œÚ∞º‹IDs
		string		_longPanelOutIDs;	///<Õ‚±flΩÁ◊›œÚ∞º‹IDs
		string		_longStiffenerIDs;	///<LongStiffenerIDs
		string		_seamIDs;			///<∞Â∑ÏIDs
		int   		_sectionID;			///<À˘ Ù∫·∆ √ÊID∫≈
		string		_shipStructureID;	///<¥¨≤∞Ω·ππ¿‡–Õ±‡¬Î
		int   		_type;				///<¿‡–Õ 1 - ◊›œÚ∞º‹ 2 - ∫·œÚ∞º‹ 3 - ÀÆ∆Ω∞º‹

		string		_holeIDs;		///<∫·œÚ∞º‹ø™ø◊IDs

		ODI D2_TransPanelDAO();
		ODI ~D2_TransPanelDAO();


		ODI virtual Mapper* createMapper();
		ODI static DAO* createObject();
		
		//_longStiffenerIDs
		ODI ResultMsg saveLongStiffenerIDs(list<int> longStiffenerIDlist);
		ODI ResultMsg getLongStiffenerIDs(list<int>& longStiffenerIDlist);

		//_geometryIDs
		ODI ResultMsg saveGeometryIDs(list<int> geoIDlist);
		ODI ResultMsg getGeometryIDs(list<int>& geoIDlist);

		//_longPanelInIDs
		ODI ResultMsg saveLongPanelInIDs(list<int> longPanelInIDlist);
		ODI ResultMsg getLongPanelInIDs(list<int>& longPanelInIDlist);
		
		//_longPanelOutIDs
		ODI ResultMsg saveLongPanelOutIDs(list<int> longPanelOutIDlist);
		ODI ResultMsg getLongPanelOutIDs(list<int>& longPanelOutIDlist);
		
		//_seamIDs
		ODI ResultMsg saveSeamIDs(list<int> longSeamIDlist);
		ODI ResultMsg getSeamIDs(list<int>& longSeamIDlist);

		//_holeIDs
		ODI ResultMsg saveHoleIDs(list<int> longHoleIDlist);
		ODI ResultMsg getHoleIDs(list<int>& longHoleIDlist);
		
		static ODI ResultMsg FindAll(list<D2_TransPanelDAO*> & pnewlist);

		static ODI ResultMsg FindByID(int id, D2_TransPanelDAO * &pnewdao);

		static ResultMsg ODI FindBySectionID(int    sectionID, list<D2_TransPanelDAO*>&newlist);

		static ResultMsg ODI FindByType(int    type, list<D2_TransPanelDAO*>&newlist);
	};
}