?? boardingsysdlg.cpp

?? 使用Visual C++ .NET實現簡單了一個票務管理系統
?? CPP
字號:
// BoardingSysDlg.cpp : 實現文件
//

#include "stdafx.h"
#include "BoardingSys.h"
#include "BoardingSysDlg.h"
#include ".\boardingsysdlg.h"
#include "Tools.h"
#include "DBSetDlg.h"
#include "AssociatorDlg.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()


// CBoardingSysDlg 對話框



CBoardingSysDlg::CBoardingSysDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBoardingSysDlg::IDD, pParent)
	, m_Fi(_T(""))
	, m_Date(_T(""))
	, m_CardID(_T(""))
	, m_SeatType(_T(""))
	, m_Boarding(_T(""))
	, m_TicketID(0)
	, m_BoardingID(0)
	, m_BaggageID(_T(""))
	, m_Weight(0)
	, m_SeatNum(_T(""))
	, m_Remark(_T(""))
{
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
	char c[256];
	CString temp;
	::GetCurrentDirectory( 256, c );
	temp.Format("%s\\", c );
	m_IniFile = temp + "BoardingSys.ini";
}

void CBoardingSysDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT2, m_Fi);
	DDX_Text(pDX, IDC_EDIT3, m_Date);
	DDX_Text(pDX, IDC_EDIT4, m_CardID);
	DDX_Text(pDX, IDC_EDIT5, m_SeatType);
	DDX_Text(pDX, IDC_EDIT6, m_Boarding);
	DDX_Text(pDX, IDC_EDIT1, m_TicketID);
	DDX_Control(pDX, IDC_EDIT1, m_kTicketID);
	DDX_Control(pDX, IDC_BUTTON3, m_BtBoarding);
	DDX_Text(pDX, IDC_EDIT7, m_BoardingID);
	DDX_Text(pDX, IDC_EDIT10, m_BaggageID);
	DDX_Text(pDX, IDC_EDIT11, m_Weight);
	DDX_Text(pDX, IDC_EDIT12, m_SeatNum);
	DDX_Text(pDX, IDC_EDIT13, m_Remark);
	DDX_Control(pDX, IDC_BUTTON2, m_kBtAsso);
}

BEGIN_MESSAGE_MAP(CBoardingSysDlg, CDialog)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	//}}AFX_MSG_MAP
	ON_BN_CLICKED(IDC_BUTTON4, OnBnClickedButton4)
	ON_BN_CLICKED(IDC_BUTTON1, OnBnClickedButton1)
	ON_BN_CLICKED(IDC_BUTTON3, OnBnClickedButton3)
	ON_BN_CLICKED(IDC_BUTTON2, OnBnClickedButton2)
END_MESSAGE_MAP()


// CBoardingSysDlg 消息處理程序

BOOL CBoardingSysDlg::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: 在此添加額外的初始化代碼
	m_kBtAsso.EnableWindow(false);

	return TRUE;  // 除非設置了控件的焦點，否則返回 TRUE
}

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

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

void CBoardingSysDlg::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 CBoardingSysDlg::OnQueryDragIcon()
{
	return static_cast<HCURSOR>(m_hIcon);
}

// 讀去數據庫配置參數
void CBoardingSysDlg::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 CBoardingSysDlg::OnBnClickedButton4()
{
	CDBSetDlg dlg;
	dlg.SetData(m_DBData.type,m_DBData.Source,m_DBData.UserName,m_DBData.PassWord,m_IniFile );
	if( dlg.DoModal() == IDOK )
	{
		LoadDBSet();
	}
}
// 檢索機票信息
void CBoardingSysDlg::OnBnClickedButton1()
{
	if( UpdateData() == false )
		return;
	if( m_TicketID == 0 )
	{
		MessageBox("請輸入機票編號");
		return;
	}
	if( !LoadTicketInfo(m_TicketID) )
	{
		MessageBox("機票信息檢索失敗");
	}
	else
		m_kBtAsso.EnableWindow(true);
}
// 讀取機票信息，填寫信息框
bool CBoardingSysDlg::LoadTicketInfo(long id)
{
	bool b = true;
	_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;
	}

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

		temp.Format("SELECT * FROM SaleTicketNote WHERE (ID = %d)",id);
		pRecordset->Open( temp.GetBuffer(),
			_variant_t((IDispatch*)pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	}
	catch( _com_error * e )
	{
		pConnection->Close();
		MessageBox( e->ErrorMessage(),"異常",MB_OK );
		return false;
	}

	if( !pRecordset->adoEOF )
	{
		try
		{
			_variant_t value;
			COleDateTime time;
			CString temp;
			value = pRecordset->GetCollect("FlightID");
			if( value.vt != VT_NULL )
				temp = value.bstrVal;
			else
				temp = "";
			m_Fi = temp.Trim();

			value = pRecordset->GetCollect("Date");
			if( value.vt != VT_NULL )
				time = value.date;
			m_Date.Format("%4d-%02d-%02d",time.GetYear(),time.GetMonth(),time.GetDay());

			value = pRecordset->GetCollect("IDCard");
			if( value.vt != VT_NULL )
				temp = value.bstrVal;
			else
				temp = "";
			m_CardID = temp.Trim();
			value = pRecordset->GetCollect("SeatType");
			if( value.vt != VT_NULL )
				temp = value.bstrVal;
			else
				temp = "";
			m_SeatType = temp.Trim();

			BOOL bBoard = false;
			value = pRecordset->GetCollect("Boarding");
			if( value.vt != VT_NULL )
				bBoard = value.boolVal;
			if( bBoard )
			{
				m_Boarding = "已辦理";
			}
			else
			{
				m_Boarding = "未辦理";
			}
			m_BtBoarding.EnableWindow(!bBoard);

			UpdateData(false);
		}
		catch(...)
		{
			MessageBox("讀取記錄異常","異常",MB_OK );
			b = false;
		}
	}
	else
	{
		MessageBox("沒有該機票信息");
		b = false;
	}
	try
	{
		pRecordset->Close();
		pConnection->Close();
	}
	catch( _com_error * e )
	{
		MessageBox(e->ErrorMessage(),"失敗",MB_OK );
	}
	return b;
}

void CBoardingSysDlg::OnBnClickedButton3()
{
	if( UpdateData() == false )
		return;
	if( m_SeatNum == "" )
	{
		MessageBox("必須填寫座位號");
		return;
	}
	// 辦理登機牌
	if( AddBoardingInfo() )
	{
		MessageBox("登機牌辦理成功");
		// 改變機票中登機牌辦理情況
		ChangeTicket();
		// 改變顯示狀態
		OnBnClickedButton1();
	}
	else
	{
		MessageBox("登機牌辦理失敗");
	}
}
// 添加登記牌信息
bool CBoardingSysDlg::AddBoardingInfo()
{
	_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;
	}

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

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

	try
	{
		pRecordset->AddNew();
		pRecordset->PutCollect( "SeatNum", _variant_t(m_SeatNum) );
		pRecordset->PutCollect( "ID", _variant_t(m_TicketID) );
		pRecordset->PutCollect( "IDCard", _variant_t(m_CardID) );
		pRecordset->PutCollect( "BOnPlane", _variant_t(false) );
		if( m_BaggageID != "" )
		{
			pRecordset->PutCollect( "BaggageID", _variant_t(m_BaggageID) );
			pRecordset->PutCollect( "WeightBaggate", _variant_t(m_Weight) );
		}
		if( m_Remark != "" )
		{
			pRecordset->PutCollect( "Remark", _variant_t(m_Remark) );
		}
		pRecordset->Update();
	}
	catch(...)
	{
		MessageBox("插入記錄異常","異常",MB_OK );
		return false;
	}
	// 得到登機牌編號
	try
	{
		_variant_t value;
		value = pRecordset->GetCollect("BoardingID");
		if( value.vt != VT_NULL )
			m_BoardingID = value.lVal;
		else
			m_BoardingID = 0;
		UpdateData(false);
	}
	catch(...)
	{
		MessageBox("讀取記錄異常");
		return false;
	}
	try
	{
		pRecordset->Close();
		pConnection->Close();
	}
	catch( _com_error * e )
	{
		MessageBox(e->ErrorMessage(),"失敗",MB_OK );
		return false;
	}
	return true;
}
// 更改機票中登機牌辦理情況
bool CBoardingSysDlg::ChangeTicket( bool b )
{
	_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;
	}

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

		temp.Format("SELECT * FROM SaleTicketNote WHERE (ID = %d)",m_TicketID);
		pRecordset->Open( temp.GetBuffer(),
			_variant_t((IDispatch*)pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	}
	catch( _com_error * e )
	{
		pConnection->Close();
		MessageBox( e->ErrorMessage(),"異常",MB_OK );
		return false;
	}

	if( !pRecordset->adoEOF )
	{
		try
		{
			pRecordset->PutCollect( "Boarding", _variant_t(b) );
			pRecordset->Update();
		}
		catch(...)
		{
			MessageBox("更改記錄異常","異常",MB_OK );
			b = false;
		}
	}
	else
	{
		MessageBox("沒有該機票信息");
		b = false;
	}

	try
	{
		pRecordset->Close();
		pConnection->Close();
	}
	catch( _com_error * e )
	{
		MessageBox(e->ErrorMessage(),"失敗",MB_OK );
	}
	return b;
}
// 會員服務
void CBoardingSysDlg::OnBnClickedButton2()
{
	CAssociatorDlg dlg;
	dlg.SetMyOwner( this );
	dlg.SetTicketID( m_TicketID );
	dlg.DoModal();
}
?? 文件大小 1168 K
?? 上傳用戶 bilika
?? 所屬分類其他數據庫
??? 相關標簽

#Visual #NET #管理系統
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? boardingsysdlg.cpp

?? 快捷鍵說明
