// FlightPlanDlg.cpp : 實現文件
//

#include "stdafx.h"
#include "FlightPlan.h"
#include "FlightPlanDlg.h"
#include ".\flightplandlg.h"
#include "DBSetDlg.h"
#include "Tools.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


// 用于應用程序“關于”菜單項的 CAboutDlg 對話框

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// 對話框數據
	enum { IDD = IDD_ABOUTBOX };

	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV 支持

// 實現
protected:
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
END_MESSAGE_MAP()


// CFlightPlanDlg 對話框



CFlightPlanDlg::CFlightPlanDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CFlightPlanDlg::IDD, pParent)
	, m_Fi(_T(""))
	, m_An(_T(""))
	, m_Length(0)
	, m_StartCity(_T(""))
	, m_StartAir(_T(""))
	, m_EndCity(_T(""))
	, m_EndAir(_T(""))
	, m_MaxPassenger(0)
	, m_Passanger(0)
{
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
	char c[256];
	CString temp;
	::GetCurrentDirectory( 256, c );
	temp.Format("%s\\", c );
	m_IniFile = temp + "FlightPlane.ini";
	m_Index = NULL;
	m_CurSlt = -1;
	m_Sql = "";
}
CFlightPlanDlg::~CFlightPlanDlg()
{
	SAFE_DELARRAY(m_Index);
}
void CFlightPlanDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_FIINFOLIST, m_FiInfo);
	DDX_Control(pDX, IDC_DATETIMEPICKERSTR, m_SltTime);
	DDX_Control(pDX, IDC_DATETIMEPICKER1, m_FlightDate);
	DDX_Text(pDX, IDC_EDIT1, m_Fi);
	DDX_Text(pDX, IDC_EDIT2, m_An);
	DDX_Text(pDX, IDC_EDIT3, m_Length);
	DDX_Text(pDX, IDC_EDIT4, m_StartCity);
	DDX_Text(pDX, IDC_EDIT5, m_StartAir);
	DDX_Text(pDX, IDC_EDIT6, m_EndCity);
	DDX_Text(pDX, IDC_EDIT7, m_EndAir);
	DDX_Control(pDX, IDC_DATETIMEPICKER2, m_StartTime);
	DDX_Control(pDX, IDC_DATETIMEPICKER3, m_EndTime);
	DDX_Text(pDX, IDC_EDIT14, m_MaxPassenger);
	DDX_Text(pDX, IDC_EDIT15, m_Passanger);
}

BEGIN_MESSAGE_MAP(CFlightPlanDlg, CDialog)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	//}}AFX_MSG_MAP
	ON_BN_CLICKED(IDC_BTDBSET, OnBnClickedBtdbset)
	ON_BN_CLICKED(IDC_BTSLT, OnBnClickedBtslt)
	ON_BN_CLICKED(IDOK, OnBnClickedOk)
	ON_BN_CLICKED(IDC_BTADDFI, OnBnClickedBtaddfi)
	ON_NOTIFY(LVN_ITEMCHANGED, IDC_FIINFOLIST, OnLvnItemchangedFiinfolist)
	ON_BN_CLICKED(IDC_BTADDFI2, OnBnClickedBtaddfi2)
	ON_BN_CLICKED(IDC_BTADDFI3, OnBnClickedBtaddfi3)
END_MESSAGE_MAP()


// CFlightPlanDlg 消息處理程序

BOOL CFlightPlanDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// 讀去配置參數
	LoadDBSet();

	// IDM_ABOUTBOX 必須在系統命令范圍內。
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// 設置此對話框的圖標。當應用程序主窗口不是對話框時，框架將自動
	//  執行此操作
	SetIcon(m_hIcon, TRUE);			// 設置大圖標
	SetIcon(m_hIcon, FALSE);		// 設置小圖標

	// TODO: 在此添加額外的初始化代碼
	Init();
	
	return TRUE;  // 除非設置了控件的焦點，否則返回 TRUE
}

void CFlightPlanDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// 如果向對話框添加最小化按鈕，則需要下面的代碼
//  來繪制該圖標。對于使用文檔/視圖模型的 MFC 應用程序，
//  這將由框架自動完成。

void CFlightPlanDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // 用于繪制的設備上下文

		SendMessage(WM_ICONERASEBKGND, reinterpret_cast<WPARAM>(dc.GetSafeHdc()), 0);

		// 使圖標在工作矩形中居中
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// 繪制圖標
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

//當用戶拖動最小化窗口時系統調用此函數取得光標顯示。
HCURSOR CFlightPlanDlg::OnQueryDragIcon()
{
	return static_cast<HCURSOR>(m_hIcon);
}

void CFlightPlanDlg::OnBnClickedBtdbset()
{
	CDBSetDlg dlg;
	dlg.SetData(m_DBData.type,m_DBData.Source,m_DBData.UserName,m_DBData.PassWord,m_IniFile );
	if( dlg.DoModal() == IDOK )
	{
		LoadDBSet();
	}
}
// 讀去數據庫配置參數
void CFlightPlanDlg::LoadDBSet()
{
	char tmp[256];
	GetPrivateProfileString("DBSET","DBTYPE","0",tmp,256,m_IniFile);
	m_DBData.type = atol(tmp);
	GetPrivateProfileString("DBSET","DBSOURCE","",tmp,256,m_IniFile);
	m_DBData.Source = tmp;
	m_DBData.Source.Trim();
	GetPrivateProfileString("DBSET","USERNAME","",tmp,256,m_IniFile);
	m_DBData.UserName = tmp;
	m_DBData.UserName.Trim();
	CTools * ptool = NULL;
	GetPrivateProfileString("DBSET","PASSWORD","",tmp,256,m_IniFile);
	m_DBData.PassWord = ptool->GetPriString( tmp, false );

	if( m_DBData.Source != "" )
	{
		CString jet = "";
		switch( m_DBData.type )
		{
		case 0: // Access
			jet = "Microsoft.Jet.OLEDB.4.0";
			break;
		case 1: // Oracle
			jet = "MSDAORA";
			break;
		default:
			jet = "Microsoft.Jet.OLEDB.4.0";
			break;
		}
		m_DBData.Linkbuf.Format( "Provider=%s;Data Source=%s",jet,m_DBData.Source);
	}
}
// 初始化配置
void CFlightPlanDlg::Init()
{
	m_FiInfo.SetExtendedStyle( LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT | LVS_EX_HEADERDRAGDROP );
	m_FiInfo.InsertColumn(0,"航班號",LVCFMT_LEFT,50);
	m_FiInfo.InsertColumn(1,"日期",LVCFMT_CENTER,80);
	m_FiInfo.InsertColumn(2,"始發城市",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(3,"目的城市",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(4,"起飛機場",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(5,"降落機場",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(6,"起飛時間",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(7,"降落時間",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(8,"機尾號",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(9,"最大人數",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(10,"實際人數",LVCFMT_LEFT,61);
	m_FiInfo.InsertColumn(11,"距離",LVCFMT_LEFT,61);

	m_StartTime.SetFormat("HH:mm");
	m_EndTime.SetFormat("HH:mm");
	m_FlightDate.SetFormat("yyyy-hh-dd");

	LoadPlan();
}

void CFlightPlanDlg::OnBnClickedOk()
{
	// TODO: 在此添加控件通知處理程序代碼
	OnOK();
}
// 添加航班
void CFlightPlanDlg::OnBnClickedBtaddfi()
{
	if( UpdateData() == false )
	{
		return ;
	}
	if( m_Fi == "" )
	{
		MessageBox("必須填寫航班號");
		return;
	}
	if( AddNote() == false)
	{
		MessageBox("記錄添加失敗");
	}
	else
	{
		MessageBox("記錄添加成功");
		LoadPlan();
	}
}
// 添加記錄
bool CFlightPlanDlg::AddNote()
{
	//指向Connection對象的指針，用于連接到數據庫
	_ConnectionPtr pConnection;
	//Recordset 指針， 記錄集指針
	_RecordsetPtr pRecordset;

	try
	{
		HRESULT hr;

		// 創建Connection對象
		hr = pConnection.CreateInstance("ADODB.Connection");
		if( SUCCEEDED( hr ) )
		{
			// 連接數據庫
			hr = pConnection->Open(m_DBData.Linkbuf.GetBuffer(),
				m_DBData.UserName.GetBuffer(),m_DBData.PassWord.GetBuffer(),
				adModeUnknown);
		}
		else
		{
			MessageBox("創建數據庫連接失敗","失敗",MB_OK);
			return false;
		}
	}
	catch( ... )
	{
		MessageBox( "連接數據庫失敗","失敗",MB_OK);
		return false;
	}

	try
	{
		// 生成Recordset實例
		pRecordset.CreateInstance("ADODB.Recordset");

		// 察看全部
		pRecordset->Open("SELECT * FROM FlightIDInfo",   // 查詢所有語句
			_variant_t((IDispatch*)pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	}
	catch( _com_error * e )
	{
		pConnection->Close();
		MessageBox( e->ErrorMessage(),"異常",MB_OK );
		return false;
	}

	try
	{
		COleDateTime t,t1;
		CString temp;

		pRecordset->AddNew();
		m_FlightDate.GetTime( t1 );
		t.SetDate(t1.GetYear(),t1.GetMonth(),t1.GetDay());
		pRecordset->PutCollect( "Date", _variant_t(t) );
		pRecordset->PutCollect( "FlightID", _variant_t(m_Fi) );
		// 起飛時間
		m_StartTime.GetTime(t1);
		t.SetTime(t1.GetHour(),t1.GetMinute(),0);
		pRecordset->PutCollect( "TakeoffTime", _variant_t(t) );
		// 降落時間
		m_EndTime.GetTime(t);
		t.SetTime(t1.GetHour(),t1.GetMinute(),0);
		pRecordset->PutCollect( "LandingTime", _variant_t(t) );
		// 出發城市
		pRecordset->PutCollect( "TakeoffPlace", _variant_t(m_StartCity) );
		// 降落城市
		pRecordset->PutCollect( "LandingPlace", _variant_t(m_EndCity) );
		// 起飛機場
		pRecordset->PutCollect( "TakeoffAir", _variant_t(m_StartAir) );
		// 降落機場
		pRecordset->PutCollect( "LandingAir", _variant_t(m_EndAir) );

		pRecordset->PutCollect( "Plane", _variant_t(m_An) );
		pRecordset->PutCollect( "MaxPassengerNum", _variant_t(m_MaxPassenger) );
		pRecordset->PutCollect( "PassengerNum", _variant_t(m_Passanger) );
		pRecordset->PutCollect( "Distance", _variant_t(m_Length) );
		pRecordset->Update();
	}
	catch(...)
	{
		MessageBox("添加記錄異常","異常",MB_OK );
		pRecordset->Close();
		pConnection->Close();
		return false;
	}

	try
	{
		pRecordset->Close();
		pConnection->Close();
	}
	catch( _com_error * e )
	{
		MessageBox(e->ErrorMessage(),"失敗",MB_OK );
	}
	return true;
}

// 讀入航班計劃,寫入List
bool CFlightPlanDlg::LoadPlan()
{
	if( m_Sql == "" )
	{
		// 得到當天的航班計劃
		CString temp;
		SYSTEMTIME t;
		GetLocalTime(&t);
		temp.Format("DateSerial(%d,%d,%d)",t.wYear,t.wMonth,t.wDay );

		m_Sql.Format("SELECT * FROM FlightIDInfo WHERE (Date = %s)",temp);
	}
	_ConnectionPtr pConnection;
	_RecordsetPtr pRecordset;

	try
	{
		HRESULT hr;

		// 創建Connection對象
		hr = pConnection.CreateInstance("ADODB.Connection");
		if( SUCCEEDED( hr ) )
		{
			// 連接數據庫
			hr = pConnection->Open(m_DBData.Linkbuf.GetBuffer(),
				m_DBData.UserName.GetBuffer(),m_DBData.PassWord.GetBuffer(),
				adModeUnknown);
		}
		else
		{
			MessageBox("創建數據庫連接失敗","失敗",MB_OK);
			return false;
		}
	}
	catch( ... )
	{
		MessageBox( "連接數據庫失敗","失敗",MB_OK);
		return false;
	}

	try
	{
		// 生成Recordset實例
		pRecordset.CreateInstance("ADODB.Recordset");

		pRecordset->Open( m_Sql.GetBuffer(),
			_variant_t((IDispatch*)pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	}
	catch( _com_error * e )
	{
		pConnection->Close();
		MessageBox( e->ErrorMessage(),"異常",MB_OK );
		return false;
	}

	// 統計記錄數
	m_CurNum = 0;
	try
	{
		if( !pRecordset->BOF )
			pRecordset->MoveFirst();

		while( !pRecordset->adoEOF )
		{
			m_CurNum++;
			pRecordset->MoveNext();
		}
	}
	catch(...)
	{
		MessageBox("讀記錄計數異常","異常",MB_OK );
		return false;
	}
	m_FiInfo.DeleteAllItems();

	if( m_CurNum > 0 )
	{
		_variant_t value;
		COleDateTime t;
		CString temp;
		try
		{
			SAFE_DELARRAY(m_Index);
			m_Index = new long[m_CurNum];

			if( !pRecordset->BOF )
				pRecordset->MoveFirst();
			for( int i = 0; i < m_CurNum; i++ )
			{