boardingsysdlg.cpp

使用Visual C++ .NET实现简单了一个票务管理系统

// 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();
}