stationinfodlg.cpp

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

// StationInfoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "PROJECTPMU.h"
#include "StationInfoDlg.h"
#include "EditStationInfoDlg.h"
#include "ConfirmStationInfoDelDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CStationInfoDlg dialog


CStationInfoDlg::CStationInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CStationInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CStationInfoDlg)
	//}}AFX_DATA_INIT
}


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


BEGIN_MESSAGE_MAP(CStationInfoDlg, CDialog)
	//{{AFX_MSG_MAP(CStationInfoDlg)
	ON_BN_CLICKED(IDC_Alter_Button, OnAlterButton)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDC_AddStation_Button, OnAddStationButton)
	ON_BN_CLICKED(IDC_DeleteStationButton, OnDeleteStationButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CStationInfoDlg message handlers

BOOL CStationInfoDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	::SendMessage(m_StationInfoList.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_StationInfoList.SetExtendedStyle(m_StationInfoList.GetExtendedStyle()|LVS_EX_GRIDLINES); 
	//////////为列表控件添加列//////////
    m_StationInfoList.InsertColumn(0,"StationNameEn",LVCFMT_LEFT,150);
    m_StationInfoList.InsertColumn(1,"StationNameCh",LVCFMT_LEFT,150);
    m_StationInfoList.InsertColumn(2,"Longitude",LVCFMT_LEFT,100);
    m_StationInfoList.InsertColumn(3,"Latitude",LVCFMT_LEFT,100);
    m_StationInfoList.InsertColumn(4,"AudioDescriptionEn",LVCFMT_LEFT,150);
    m_StationInfoList.InsertColumn(5,"AudioDescriptionCh",LVCFMT_LEFT,150);
	m_StationInfoList.InsertColumn(6,"EnglishWave",LVCFMT_LEFT,120);
    m_StationInfoList.InsertColumn(7,"ChineseWave",LVCFMT_LEFT,120);
   // m_StationInfoList.InsertColumn(8,"Active",LVCFMT_LEFT,80);
	//调用读取数据库中的信息函数
    ReadDataFromDB();
	m_listPosSel=-1;
    return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CStationInfoDlg::ReadDataFromDB()
{//////////读取数据库中的信息添加到列表控件///////////
	if (m_pConnection.ConnectAccess(mMDB_Path,"sri"))
	{
		int nItem;
		CAdoRecordSet pRS0;
		pRS0.SetAdoConnection(&m_pConnection);
		pRS0.Open("SELECT * FROM StationInfo order by id",adCmdText);//按自动编号读取数据
		while(!pRS0.IsEOF())
		{
			pRS0.GetCollect("StationNameEn",m_sStationNameEn);
			pRS0.GetCollect("StationNameCh",m_sStationNameCh);
			pRS0.GetCollect("Longitude",m_sLongitude);
			pRS0.GetCollect("latitude",m_sLatitude);
			pRS0.GetCollect("AudioDescriptionEn",m_sAudioDescriptionEn);
			pRS0.GetCollect("AudioDescriptionh",m_sAudioDescriptionCh);
			pRS0.GetCollect("EnglishWave",m_sEnglishWave);
			pRS0.GetCollect("ChineseWave",m_sChineseWave);
		//	pRS0.GetCollect("Active",m_sActive);

            m_sStationNameEn.TrimRight();
			m_sStationNameCh.TrimRight();
			m_sLongitude.TrimRight();
			m_sLatitude.TrimRight();
			m_sAudioDescriptionEn.TrimRight();
			m_sAudioDescriptionCh.TrimRight();
			m_sEnglishWave.TrimRight();
			m_sChineseWave.TrimRight();


			nItem=m_StationInfoList.InsertItem(0xffff,"");

			m_StationInfoList.SetItem(nItem,0,1,(m_sStationNameEn==VT_NULL)?"":m_sStationNameEn,NULL,0,0,0);
			m_StationInfoList.SetItem(nItem,1,1,(m_sStationNameCh==VT_NULL)?"":m_sStationNameCh,NULL,0,0,0);
			m_StationInfoList.SetItem(nItem,2,1,(m_sLongitude==VT_NULL)?"":m_sLongitude,NULL,0,0,0);
			m_StationInfoList.SetItem(nItem,3,1,(m_sLatitude==VT_NULL)?"":m_sLatitude,NULL,0,0,0);
			m_StationInfoList.SetItem(nItem,4,1,(m_sAudioDescriptionEn==VT_NULL)?"":m_sAudioDescriptionEn,NULL,0,0,0);
			m_StationInfoList.SetItem(nItem,5,1,(m_sAudioDescriptionCh==VT_NULL)?"":m_sAudioDescriptionCh,NULL,0,0,0);
			m_StationInfoList.SetItem(nItem,6,1,(m_sEnglishWave==VT_NULL)?"":m_sEnglishWave,NULL,0,0,0);
			m_StationInfoList.SetItem(nItem,7,1,(m_sChineseWave==VT_NULL)?"":m_sChineseWave,NULL,0,0,0);
	//		m_StationInfoList.SetItem(nItem,8,1,(m_sActive==VT_NULL)?"":m_sActive,NULL,0,0,0);
			pRS0.MoveNext();
		}
	}
   m_pConnection.Close();

}



void CStationInfoDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
   POSITION pos;
   pos = m_StationInfoList.GetFirstSelectedItemPosition();
   // 得到项目索引
   IndexInFieldList = m_StationInfoList.GetNextSelectedItem(pos);
   m_listPosSel=IndexInFieldList;
   if( m_listPosSel > -1 )  //如果选中一行
   {
	   m_sStationNameEn=m_StationInfoList.GetItemText(IndexInFieldList, 0);
	   m_sStationNameCh=m_StationInfoList.GetItemText(IndexInFieldList, 1);
	   m_sLongitude=m_StationInfoList.GetItemText(IndexInFieldList, 2);
	   m_sLatitude=m_StationInfoList.GetItemText(IndexInFieldList, 3);
	   m_sAudioDescriptionEn=m_StationInfoList.GetItemText(IndexInFieldList, 4);
	   m_sAudioDescriptionCh=m_StationInfoList.GetItemText(IndexInFieldList, 5);
	   m_sEnglishWave=m_StationInfoList.GetItemText(IndexInFieldList, 6);
	   m_sChineseWave=m_StationInfoList.GetItemText(IndexInFieldList, 7);
	 //  m_sActive=m_StationInfoList.GetItemText(IndexInFieldList, 8);
   }
  // AfxMessageBox(m_sLongitude);
	*pResult = 0;
}

//修改表StationInfo中数据
void CStationInfoDlg::OnAlterButton() 
{
	// TODO: Add your control notification handler code here
	//将一个对话框的数据传到另一个关联的对话框中
	if( m_listPosSel > -1 ) 
	{   
		CEditStationInfoDlg dlg;
		dlg.m_bADD = false;//判断添加还是修改数据的条件，true是添加，false是修改
		dlg.StationNameEn=m_sStationNameEn;
		dlg.StationNameCh=m_sStationNameCh;
		dlg.Longitude=m_sLongitude;
		dlg.Latitude=m_sLatitude;
		dlg.AudioDescriptionEn=m_sAudioDescriptionEn;
		dlg.AudioDescriptionCh=m_sAudioDescriptionCh;
		dlg.EnglishWave=m_sEnglishWave;
		dlg.ChineseWave=m_sChineseWave;
	//	dlg.Active=m_sActive;
		//重新读取数据库中的信息添加到列表控件
		if(dlg.DoModal() == IDOK)
		{
			// MessageBox("ok");
			m_StationInfoList.DeleteAllItems();
			ReadDataFromDB();
		}
	}
	else
	{
        AfxMessageBox("请选择要修改的信息");
	}
}

//添加表StationInfo中数据
void CStationInfoDlg::OnAddStationButton() 
{
	// TODO: Add your control notification handler code here
	//重新读取数据库中的信息添加到列表控件
	CEditStationInfoDlg dlg;
	dlg.m_bADD = true;//判断添加还是修改数据的条件，true是添加，false是修改
	if(dlg.DoModal() == IDOK)
	{
       // MessageBox("ok");
		m_StationInfoList.DeleteAllItems();
		ReadDataFromDB();
	}
//	CEditStationInfoDlg dlg;
//	dlg.DoModal();

}

//删除表StationInfo中数据
void CStationInfoDlg::OnDeleteStationButton() 
{
	// TODO: Add your control notification handler code here
	if( m_listPosSel > -1 )
	{
		CConfirmStationInfoDelDlg dlg;
	    dlg.StationNameEn=m_sStationNameEn;
	    dlg.StationNameCh=m_sStationNameCh;
		// MessageBox(m_sStationNameEn);
	    if(dlg.DoModal() == IDOK)
		{
			// MessageBox("ok");
			m_StationInfoList.DeleteAllItems();
			ReadDataFromDB();
		}
	}
	else
	{
        AfxMessageBox("请选择要修改的信息");
	}
	/*CString str1,str2,sqldelete;
	str1=m_sStationNameEn;
	str2=m_sStationNameCh;
	AfxMessageBox(m_sStationNameEn);
	str1.TrimLeft();
    str1.TrimRight();
    str2.TrimLeft();
    str2.TrimRight();
	if(m_pConnection.ConnectAccess(mMDB_Path,"sri"))
	sqldelete.Format("delete from StationInfo where (StationNameEn='%s') and (StationNameCh='%s')",str1,str2);
	AfxMessageBox(sqldelete);
	m_pConnection.Execute(sqldelete);
	m_StationInfoList.DeleteAllItems();
    ReadDataFromDB();*/
}