shoupiao.rar_MFC_MFC影院售票_网上售票系统

#include "stdafx.h" #include "网上售票系统.h" #include "网上售票系统Dlg.h" #include "afxmt.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif CCriticalSection cs; class CAboutDlg : public CDialog { public: CAboutDlg(); enum { IDD = IDD_ABOUTBOX }; protected: virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support 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() CMyDlg::CMyDlg(CWnd* pParent /*=NULL*/) : CDialog(CMyDlg::IDD, pParent) { //{{AFX_DATA_INIT(CMyDlg) m_Edit1 = _T(""); m_Edit2 = _T(""); m_Edit3 = _T(""); //}}AFX_DATA_INIT // Note that LoadIcon does not require a subsequent DestroyIcon in Win32 m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME); } void CMyDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CMyDlg) DDX_Control(pDX, IDC_COMBO4, m_Combo4); DDX_Control(pDX, IDC_COMBO3, m_Combo3); DDX_Control(pDX, IDC_BUTTON1, m_Ok); DDX_Control(pDX, IDC_COMBO2, m_Combo); DDX_Control(pDX, IDC_STATIC1, m_Static1); DDX_Text(pDX, IDC_EDIT1, m_Edit1); DDX_Text(pDX, IDC_EDIT2, m_Edit2); DDX_Text(pDX, IDC_EDIT3, m_Edit3); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CMyDlg, CDialog) //{{AFX_MSG_MAP(CMyDlg) ON_WM_SYSCOMMAND() ON_WM_PAINT() ON_WM_QUERYDRAGICON() ON_WM_DESTROY() ON_BN_CLICKED(IDC_BUTTON1, OnButton1) ON_BN_CLICKED(IDC_BUTTON5, OnButton5) ON_BN_CLICKED(IDC_BUTTON2, OnButton2) ON_BN_CLICKED(IDC_BUTTON3, OnButton3) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CMyDlg message handlers BOOL CMyDlg::OnInitDialog() { CDialog::OnInitDialog(); // Add "About..." menu item to system menu. // IDM_ABOUTBOX must be in the system command range. 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); } } // Set the icon for this dialog. The framework does this automatically // when the application's main window is not a dialog SetIcon(m_hIcon, TRUE); // Set big icon SetIcon(m_hIcon, FALSE); // Set small icon // TODO: Add extra initialization here CFont * f; f = new CFont; f->CreateFont(40, // nHeight 0, // nWidth 0, // nEscapement 0, // nOrientation FW_BOLD, // nWeight TRUE, // bItalic FALSE, // bUnderline 0, // cStrikeOut ANSI_CHARSET, // nCharSet OUT_DEFAULT_PRECIS, // nOutPrecision CLIP_DEFAULT_PRECIS, // nClipPrecision DEFAULT_QUALITY, // nQuality DEFAULT_PITCH | FF_SWISS, // nPitchAndFamily _T("Arial")); m_Static1.SetFont(f); m_Combo.AddString("和平->广州"); m_Combo.AddString("广州->江门"); m_Combo.AddString("广州->和平"); m_Combo.AddString("江门->广州"); CoInitialize(NULL); m_pConn.CreateInstance(__uuidof(Connection)); m_pRs.CreateInstance(__uuidof(Recordset)); m_pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=售票.mdb;Persist Security Info=False","","",adModeUnknown);/// return TRUE; // return TRUE unless you set the focus to a control } void CMyDlg::OnSysCommand(UINT nID, LPARAM lParam) { if ((nID & 0xFFF0) == IDM_ABOUTBOX) { CAboutDlg dlgAbout; dlgAbout.DoModal(); } else { CDialog::OnSysCommand(nID, lParam); } } void CMyDlg::OnPaint() { if (IsIconic()) { CPaintDC dc(this); // device context for painting SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0); // Center icon in client rectangle 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; // Draw the icon dc.DrawIcon(x, y, m_hIcon); } else { CDialog::OnPaint(); } } HCURSOR CMyDlg::OnQueryDragIcon() { return (HCURSOR) m_hIcon; } void CMyDlg::OnDestroy() { CDialog::OnDestroy(); m_pRs.Release(); m_pConn.Release(); CoUninitialize(); } void CMyDlg::OnButton1() { int i; CString st; i=m_Combo.GetCurSel(); _variant_t vField; m_Combo.GetWindowText(st); if(st=="") { MessageBox("请选择路径"); } else if(i==0) { HRESULT hr=m_pRs->Open(_variant_t("表1"), m_pConn.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdTable); if(SUCCEEDED(hr)) { m_pRs->MoveFirst(); m_Combo3.ResetContent(); m_Combo4.ResetContent(); m_Edit1="班次 时间 剩票 价格\r\n"; while (!m_pRs->GetEndOfFile()) { vField=m_pRs->GetCollect("班次"); m_Combo3.AddString(_bstr_t(vField)); m_Combo4.AddString(_bstr_t(vField)); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("时间"); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("剩票"); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("价格"); m_Edit1+=_bstr_t(vField)+_T(" \r\n"); m_pRs->MoveNext(); } UpdateData(false); } hr=m_pRs->Close(); } else if(i==1) { HRESULT hr=m_pRs->Open(_variant_t("表2"), m_pConn.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdTable); if(SUCCEEDED(hr)) { m_pRs->MoveFirst(); m_Combo3.ResetContent(); m_Combo3.ResetContent(); m_Edit1="班次 时间 剩票 价格\r\n"; while (!m_pRs->GetEndOfFile()) { vField=m_pRs->GetCollect("班次"); m_Combo3.AddString(_bstr_t(vField)); m_Combo4.AddString(_bstr_t(vField)); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("时间"); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("剩票"); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("价格"); m_Edit1+=_bstr_t(vField)+_T(" \r\n"); m_pRs->MoveNext(); } UpdateData(false); hr=m_pRs->Close(); } } else if(i==2) { HRESULT hr=m_pRs->Open(_variant_t("表3"), m_pConn.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdTable); if(SUCCEEDED(hr)) { m_pRs->MoveFirst(); m_Combo3.ResetContent(); m_Combo3.ResetContent(); m_Edit1="班次 时间 剩票 价格\r\n"; while (!m_pRs->GetEndOfFile()) { vField=m_pRs->GetCollect("班次"); m_Combo3.AddString(_bstr_t(vField)); m_Combo4.AddString(_bstr_t(vField)); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("时间"); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("剩票"); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("价格"); m_Edit1+=_bstr_t(vField)+_T(" \r\n"); m_pRs->MoveNext(); } UpdateData(false); } hr=m_pRs->Close(); } else if(i==3) { HRESULT hr=m_pRs->Open(_variant_t("表4"), m_pConn.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdTable); if(SUCCEEDED(hr)) { m_pRs->MoveFirst(); m_Combo3.ResetContent(); m_Combo3.ResetContent(); m_Edit1="班次 时间 剩票 价格\r\n"; while (!m_pRs->GetEndOfFile()) { vField=m_pRs->GetCollect("班次"); m_Combo3.AddString(_bstr_t(vField)); m_Combo4.AddString(_bstr_t(vField)); m_Edit1+=_bstr_t(vField)+_T(" "); vField=m_pRs->GetCollect("时间"); m_Edit1+=_bstr_t(vField)+_T("