routelistdlg.cpp

VC++6.0基于CAN协议的车辆控制

// RouteListDlg.cpp : implementation file
//

#include "stdafx.h"
#include "PROJECTPMU.h"
#include "RouteListDlg.h"
#include "EditRouteListDlg.h"
#include "ConfirmRouteListDelDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CRouteListDlg dialog


CRouteListDlg::CRouteListDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRouteListDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRouteListDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CRouteListDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRouteListDlg)
	DDX_Control(pDX, IDC_LIST1, m_RouteListList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRouteListDlg, CDialog)
	//{{AFX_MSG_MAP(CRouteListDlg)
	ON_BN_CLICKED(IDC_Add_Button, OnAddButton)
	ON_BN_CLICKED(IDC_Alter_Button, OnAlterButton)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDC_DeleteButton, OnDeleteButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRouteListDlg message handlers

BOOL CRouteListDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	::SendMessage(m_RouteListList.m_hWnd, LVM_SETEXTENDEDLISTVIEWSTYLE,
	  LVS_EX_FULLROWSELECT, LVS_EX_FULLROWSELECT);//点击一整行
	// TODO: Add extra initialization here
	//得到应用程序所在文件夹路径
	CAdoRecordSet pRS;
    if(NULL != GetModuleFileName(NULL,mDir_Path,256))  
    {		
		int n=strlen(mDir_Path);
		for (int i=n; i>=0; i--)
		{
			if   (mDir_Path[i]   ==   '\\')   
			{   
				mDir_Path[i]   =   '\0';   
				break;   
			}   
		}
		strcpy(mMDB_Path,mDir_Path);
		strcat(mMDB_Path,"\\PIS.mdb"); // 数据库路径
	}

	m_RouteListList.SetExtendedStyle(m_RouteListList.GetExtendedStyle()|LVS_EX_GRIDLINES); 
	//////////为列表控件添加列//////////
    m_RouteListList.InsertColumn(0,"TrainCode",LVCFMT_LEFT,80);
    m_RouteListList.InsertColumn(1,"OriginalStationEn",LVCFMT_LEFT,150);
    m_RouteListList.InsertColumn(2,"OriginalStationCh",LVCFMT_LEFT,150);
    m_RouteListList.InsertColumn(3,"LastStationEn",LVCFMT_LEFT,150);
    m_RouteListList.InsertColumn(4,"LastStationCh",LVCFMT_LEFT,150);
    m_RouteListList.InsertColumn(5,"PassStationEn",LVCFMT_LEFT,150);
	m_RouteListList.InsertColumn(6,"PassStationCh",LVCFMT_LEFT,150);
    m_RouteListList.InsertColumn(7,"StartTime",LVCFMT_LEFT,120);
    m_RouteListList.InsertColumn(8,"EndTime",LVCFMT_LEFT,120);
	m_RouteListList.InsertColumn(9,"RunTime",LVCFMT_LEFT,120);
	//调用读取数据库中的信息函数
    ReadDataFromDB();
	m_listPosSel=-1;
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CRouteListDlg::ReadDataFromDB()
{//////////读取数据库中的信息添加到列表控件///////////
	if (m_pConnection.ConnectAccess(mMDB_Path,"sri"))
	{
		int nItem;
		CAdoRecordSet pRS0;
		pRS0.SetAdoConnection(&m_pConnection);
		pRS0.Open("SELECT * FROM RouteList order by id",adCmdText);//按自动编号读取数据
		while(!pRS0.IsEOF())
		{
			pRS0.GetCollect("TrainCode",m_sTrainCode);
			pRS0.GetCollect("OriginalStationEn",m_sOriginalStationEn);
			pRS0.GetCollect("OriginalStationCh",m_sOriginalStationCh);
			pRS0.GetCollect("LastStationEn",m_sLastStationEn);
			pRS0.GetCollect("LastStationCh",m_sLastStationCh);
			pRS0.GetCollect("PassStationEn",m_sPassStationEn);
			pRS0.GetCollect("PassStationCh",m_sPassStationCh);
			pRS0.GetCollect("StartTime",m_sStartTime);
			pRS0.GetCollect("EndTime",m_sEndTime);
            pRS0.GetCollect("RunTime",m_sRunTime);
            m_sTrainCode.TrimRight();
			m_sOriginalStationEn.TrimRight();
			m_sOriginalStationCh.TrimRight();
			m_sLastStationEn.TrimRight();
			m_sLastStationCh.TrimRight();
			m_sPassStationEn.TrimRight();
			m_sPassStationCh.TrimRight();
			m_sStartTime.TrimRight();
			m_sEndTime.TrimRight();
			m_sRunTime.TrimRight();
            nItem=m_RouteListList.InsertItem(0xffff,"");

			m_RouteListList.SetItem(nItem,0,1,(m_sTrainCode==VT_NULL)?"":m_sTrainCode,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,1,1,(m_sOriginalStationEn==VT_NULL)?"":m_sOriginalStationEn,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,2,1,(m_sOriginalStationCh==VT_NULL)?"":m_sOriginalStationCh,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,3,1,(m_sLastStationEn==VT_NULL)?"":m_sLastStationEn,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,4,1,(m_sLastStationCh==VT_NULL)?"":m_sLastStationCh,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,5,1,(m_sPassStationEn==VT_NULL)?"":m_sPassStationEn,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,6,1,(m_sPassStationCh==VT_NULL)?"":m_sPassStationCh,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,7,1,(m_sStartTime==VT_NULL)?"":m_sStartTime,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,8,1,(m_sEndTime==VT_NULL)?"":m_sEndTime,NULL,0,0,0);
			m_RouteListList.SetItem(nItem,9,1,(m_sRunTime==VT_NULL)?"":m_sRunTime,NULL,0,0,0);
			pRS0.MoveNext();
		}
		pRS0.Close();
	}
   

    m_pConnection.Close();

}
void CRouteListDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
   POSITION pos;
   pos = m_RouteListList.GetFirstSelectedItemPosition();
   // 得到项目索引
   IndexInFieldList = m_RouteListList.GetNextSelectedItem(pos);
   m_listPosSel=IndexInFieldList;
   if(m_listPosSel>-1)
   {
	   m_sTrainCode=m_RouteListList.GetItemText(IndexInFieldList, 0);
	   m_sOriginalStationEn=m_RouteListList.GetItemText(IndexInFieldList, 1);
	   m_sOriginalStationCh=m_RouteListList.GetItemText(IndexInFieldList, 2);
	   m_sLastStationEn=m_RouteListList.GetItemText(IndexInFieldList, 3);
	   m_sLastStationCh=m_RouteListList.GetItemText(IndexInFieldList, 4);
	   m_sPassStationEn=m_RouteListList.GetItemText(IndexInFieldList, 5);
	   m_sPassStationCh=m_RouteListList.GetItemText(IndexInFieldList, 6);
	   m_sStartTime=m_RouteListList.GetItemText(IndexInFieldList, 7);
	   m_sEndTime=m_RouteListList.GetItemText(IndexInFieldList, 8);
	   m_sRunTime=m_RouteListList.GetItemText(IndexInFieldList, 9);
   }
  // AfxMessageBox(m_sLongitude);
	*pResult = 0;
}
//添加表RouteList中数据
void CRouteListDlg::OnAddButton() 
{
	// TODO: Add your control notification handler code here
	//重新读取数据库中的信息添加到列表控件
	CEditRouteListDlg dlg;
	dlg.m_bADD = true;//判断添加还是修改数据的条件，true是添加，false是修改
	if(dlg.DoModal() == IDOK)
	{
       // MessageBox("ok");
		m_RouteListList.DeleteAllItems();
		ReadDataFromDB();
	}
}
//修改表RouteList中数据
void CRouteListDlg::OnAlterButton() 
{
	// TODO: Add your control notification handler code here
	if(m_listPosSel>-1)
	{
		CEditRouteListDlg dlg;
		dlg.m_bADD = false;//判断添加还是修改数据的条件，true是添加，false是修改
		dlg.TrainCode=m_sTrainCode;
		dlg.OriginalStationEn=m_sOriginalStationEn;
		dlg.OriginalStationCh=m_sOriginalStationCh;
		dlg.LastStationEn=m_sLastStationEn;
		dlg.LastStationCh=m_sLastStationCh;
		dlg.PassStationEn=m_sPassStationEn;
		dlg.PassStationCh=m_sPassStationCh;
		dlg.StartTime=m_sStartTime;
		dlg.EndTime=m_sEndTime;
		dlg.RunTime=m_sRunTime;
		//重新读取数据库中的信息添加到列表控件
		if(dlg.DoModal() == IDOK)
		{
			// MessageBox("ok");
			m_RouteListList.DeleteAllItems();//清空
			ReadDataFromDB();
		}
	}
	else
	{
        AfxMessageBox("请选择要修改的信息");
	}
}

//删除表RouteList中数据
void CRouteListDlg::OnDeleteButton() 
{
	// TODO: Add your control notification handler code here
if( m_listPosSel > -1 )
	{
		CConfirmRouteListDelDlg dlg;
	    dlg.TrainCode=m_sTrainCode;
	    dlg.OriginalStationEn=m_sOriginalStationEn;
	//	 MessageBox(m_sTrainCode);
	    if(dlg.DoModal() == IDOK)
		{
			// MessageBox("ok");
			m_RouteListList.DeleteAllItems();
			ReadDataFromDB();
		}
	}
	else
	{
        AfxMessageBox("请选择要修改的信息");
	}
	/*	CString str1,str2,sqldelete;
	str1=m_sTrainCode;
	str2=m_sOriginalStationEn;
	AfxMessageBox(m_sTrainCode);
	str1.TrimLeft();
    str1.TrimRight();
    str2.TrimLeft();
    str2.TrimRight();
	if(m_pConnection.ConnectAccess(mMDB_Path,"sri"))
	sqldelete.Format("delete from RouteList where (TrainCode='%s') and (OriginalStationEn='%s')",str1,str2);
	AfxMessageBox(sqldelete);
	m_pConnection.Execute(sqldelete);
	m_RouteListList.DeleteAllItems();
    ReadDataFromDB();*/
	
}