modifydlg.cpp

公交查询生成系统 Find.exe可以查询指定站点间的转站方案（可实现无限转）

// ModifyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Modify.h"
#include "ModifyDlg.h"
#include "ModifyLine1Dlg.h"
#include "Add1Dlg.h"
#include "YesDlg.h"
#include "InputLineDlg.h"
#include "InputStationDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

extern CModifyApp theApp;       // 在此引用应用类中的theApp来获取库连接指针
/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

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

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

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

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

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CModifyDlg dialog

CModifyDlg::CModifyDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CModifyDlg::IDD, pParent)
{

	deleteline = true; 
	addline = true;
	being = true;
	line = "";
	//{{AFX_DATA_INIT(CModifyDlg)
	m_combo = _T("");
	m_edit = _T("");
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CModifyDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CModifyDlg)
	DDX_Control(pDX, IDC_LIST2, m_list2);
	DDX_Control(pDX, IDC_LIST1, m_list1);
	DDX_CBString(pDX, IDC_COMBO1, m_combo);
	DDX_Text(pDX, IDC_EDIT, m_edit);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CModifyDlg, CDialog)
	//{{AFX_MSG_MAP(CModifyDlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_ABOUT, OnAbout)
	ON_BN_CLICKED(IDC_LOOK, OnLook)
	ON_BN_CLICKED(IDC_ADDLINE, OnAddline)
	ON_BN_CLICKED(IDC_DELETELINE, OnDeleteline)
	ON_BN_CLICKED(IDC_MODIFYLINE, OnModifyline)
	ON_BN_CLICKED(IDC_MODIFYSTATION, OnModifystation)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CModifyDlg message handlers

BOOL CModifyDlg::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

	m_pConnection.CreateInstance(__uuidof(Connection));

	// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
	// 因为它有时会经常出现一些想不到的错误。
	try                 
	{	
		// 打开本地Access库Demo.mdb
		m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=公交查询.mdb","","",adModeUnknown);
		
	}
	catch(_com_error e)
	{
		AfxMessageBox("数据库连接失败，确认数据库公交查询.mdb是否在当前路径下!");
		return FALSE;
	} 
/////////////////////////////////////////////////////////////////////////////////
	m_font.CreateFont(15, 0,0,0,FW_NORMAL, 0,0,0,
					DEFAULT_CHARSET, OUT_CHARACTER_PRECIS, CLIP_CHARACTER_PRECIS,
					DEFAULT_QUALITY, DEFAULT_PITCH | FF_DONTCARE, "Arial");
	m_list1.SetFont(&m_font);
	m_list1.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
//	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);//行有效
//	m_list.SetExtendedStyle(LVS_EX_GRIDLINES);//方格
//	m_list.SetBkColor(RGB(247,247,255));
	m_list1.SetTextColor(RGB(0,0,255));
	m_list1.SetTextBkColor(RGB(247,247,255));

	m_list2.SetFont(&m_font);
	m_list2.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
//	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);//行有效
//	m_list.SetExtendedStyle(LVS_EX_GRIDLINES);//方格
//	m_list.SetBkColor(RGB(247,247,255));
	m_list2.SetTextColor(RGB(0,0,255));
	m_list2.SetTextBkColor(RGB(247,247,255));

	return TRUE;  // return TRUE  unless you set the focus to a control
}

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

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CModifyDlg::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();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CModifyDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CModifyDlg::OnAbout() 
{
	// TODO: Add your control notification handler code here
	CAboutDlg dlg;
	dlg.DoModal();	
}

void CModifyDlg::OnLook() 
{
	// TODO: Add your control notification handler code here
	being = true;
	UpdateData(TRUE);//更新视图	
	m_list1.DeleteAllItems();//删除列中个项
	m_list2.DeleteAllItems();
	
	m_list1.DeleteColumn(0);//删除第一行
	m_list1.DeleteColumn(0);	
	m_list2.DeleteColumn(0);

	int n = 0;
	bool have = false;
	_variant_t var;
	CString v;

	if(m_edit == "")
	{
		AfxMessageBox("请输入 线路 或 站点!");
		return;
	}
	if(m_combo == "")
	{
		AfxMessageBox("请选择查询的是 线路 或 站点!");
		return;
	}
	else if(m_combo == "站点")//查询的是站点
		{			
			//////////////////////////////////////////////////////////////////
			//获取站点信息 添加m_list1
			try
			{
				m_pRecordset.CreateInstance(__uuidof(Recordset));
				m_pRecordset->Open(_variant_t("SELECT * FROM 站点总表"),                // 查询站点表中所有字段
										theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
										adOpenDynamic,
										adLockOptimistic,
										adCmdText);
				if(!m_pRecordset->BOF)
					m_pRecordset->MoveFirst();
				else
				{
					AfxMessageBox(m_edit+"站表内数据为空");
					return;
				}
				while(!m_pRecordset->adoEOF)
				{
					var = m_pRecordset->GetCollect("站点");
					if(m_edit ==(LPCSTR)_bstr_t(var))
					{
						have = true;
						break;
					}
					m_pRecordset->MoveNext();
				}
				if(have == false)
				{
					AfxMessageBox("不存在该站点!");
					being = false;
					return;
				}
				m_pRecordset.CreateInstance(__uuidof(Recordset));
				m_pRecordset->Open(_variant_t("SELECT * FROM " + m_edit),                // 查询站点表中所有字段
										theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
										adOpenDynamic,
										adLockOptimistic,
										adCmdText);
				////////////////////////////////////////////////////////////////
				m_list1.InsertColumn(0, "              经过路线", LVCFMT_CENTER, 150);
				
				if(!m_pRecordset->BOF)
					m_pRecordset->MoveFirst();
				else
				{
					AfxMessageBox(m_edit+"站表内数据为空");
					return;
				}
				while(!m_pRecordset->adoEOF)
				{
					var = m_pRecordset->GetCollect("线路");
					v = (LPCSTR)_bstr_t(var);
					v = "                " + v ;
					m_list1.InsertItem(n++, v);
					m_pRecordset->MoveNext();
				}
			}
			catch(_com_error e)
			{
				AfxMessageBox(e.Description()); 
				return;
			}
			//////////////////////////////////////////////////////////////////
			//获取同义词信息 添加m_list2
			try
			{
				m_pRecordset.CreateInstance(__uuidof(Recordset));
				m_pRecordset->Open("SELECT * FROM 同义站点表",                // 查询站点表中所有字段
										theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
										adOpenDynamic,
										adLockOptimistic,
										adCmdText);
				m_list2.InsertColumn(0, "          同义站点", LVCFMT_CENTER, 127);
				
				if(!m_pRecordset->BOF)
					m_pRecordset->MoveFirst();
				else
				{
					AfxMessageBox(m_edit+"站表内数据为空");
					return;
				}
				while(!m_pRecordset->adoEOF)
				{
					var = m_pRecordset->GetCollect("ID");
					v = (LPCSTR)_bstr_t(var);
					if(v == m_edit)
					{
						var = m_pRecordset->GetCollect("站点名");
						v = (LPCSTR)_bstr_t(var);
						v = "         " + v ;
						m_list2.InsertItem(n++, v);
						
					}
					m_pRecordset->MoveNext();
				}
			}
			catch(_com_error e)
			{
				AfxMessageBox(e.Description()); 
				return;
			}
		}
		else if(m_combo == "线路")//查询的是线路
			{	
				try
				{//判断是否存在该线路
					m_pRecordset.CreateInstance(__uuidof(Recordset));
					m_pRecordset->Open(_variant_t("SELECT * FROM 线路总表"),                // 查询站点表中所有字段
											theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
											adOpenDynamic,
											adLockOptimistic,
											adCmdText);
					if(!m_pRecordset->BOF)
						m_pRecordset->MoveFirst();
					else
					{
						AfxMessageBox(m_edit+"站表内数据为空");
						return;
					}
					while(!m_pRecordset->adoEOF)
					{
						var = m_pRecordset->GetCollect("线路");
						if(m_edit ==(LPCSTR)_bstr_t(var))
						{
							have = true;
							break;
						}
						m_pRecordset->MoveNext();
					}
					if(have == false)
					{
						AfxMessageBox("不存在该线路!");
						being = false;
						return;
					}
					///////////////////
					//添加m_list1
					m_pRecordset.CreateInstance(__uuidof(Recordset));
					m_pRecordset->Open(_variant_t("SELECT * FROM 线路总表"),                // 查询站点表中所有字段
											theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
											adOpenDynamic,
											adLockOptimistic,