editstationinfodlg.cpp

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

// EditStationInfoDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CEditStationInfoDlg dialog


CEditStationInfoDlg::CEditStationInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CEditStationInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEditStationInfoDlg)
	m_stationEn_Edit = _T("");
	m_stationCh_Edit = _T("");
	m_Longitude_Edit = _T("");
	m_Latitude_Edit = _T("");
	m_AudioEn_Edit = _T("");
	m_AudioCh_Edit = _T("");
	m_EnglishWave_Edit = _T("");
	m_ChineseWave_Edit = _T("");
//	m_Active_Edit = _T("");
	//}}AFX_DATA_INIT
}


void CEditStationInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEditStationInfoDlg)
	DDX_Text(pDX, IDC_EDIT1, m_stationEn_Edit);
	DDX_Text(pDX, IDC_EDIT2, m_stationCh_Edit);
	DDX_Text(pDX, IDC_EDIT3, m_Longitude_Edit);
	DDX_Text(pDX, IDC_EDIT4, m_Latitude_Edit);
	DDX_Text(pDX, IDC_EDIT5, m_AudioEn_Edit);
	DDX_Text(pDX, IDC_EDIT6, m_AudioCh_Edit);
	DDX_Text(pDX, IDC_EDIT7, m_EnglishWave_Edit);
	DDX_Text(pDX, IDC_EDIT8, m_ChineseWave_Edit);
//	DDX_Text(pDX, IDC_EDIT9, m_Active_Edit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEditStationInfoDlg, CDialog)
	//{{AFX_MSG_MAP(CEditStationInfoDlg)
	ON_BN_CLICKED(IDC_Save_Button, OnSaveButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEditStationInfoDlg message handlers
BOOL CEditStationInfoDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	// 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_stationEn_Edit=StationNameEn;
	m_stationCh_Edit=StationNameCh;
    m_Longitude_Edit=Longitude;
	m_Latitude_Edit=Latitude;
	m_AudioEn_Edit=AudioDescriptionEn;
	m_AudioCh_Edit=AudioDescriptionCh;
	m_EnglishWave_Edit=EnglishWave;
	m_ChineseWave_Edit=ChineseWave;
	m_Active_Edit=Active;
    UpdateData(FALSE);//显示出来
    return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CEditStationInfoDlg::OnSaveButton() 
{
   // TODO: Add your control notification handler code here
   CString sStationNameEn="",sStationNameCh="",sLongitude="",sLatitude="",sAudioDescriptionEn="",\
		   sAudioDescriptionCh="",sEnglishWave="",sChineseWave="",sActive="",sqlupdate="",sqladd="",\
		   sqladd1="",sqlupdate1="";
   //BOOL bAcitve;
   CString str1, str2,str3;
   //str1 = dlg.m_StationInfoList.GetItemText(IndexInFieldList, 0);
   //str2 = dlg.m_StationInfoList.GetItemText(IndexInFieldList, 1);
   str1=m_stationEn_Edit;
   AfxMessageBox(str1);
   str2=m_stationCh_Edit;
   str1.TrimRight();
   str2.TrimRight();
  
   //读取文本框中的数据并赋值给定义的字符串
   ((CEdit *)GetDlgItem(IDC_EDIT1))->GetWindowText(sStationNameEn);
   AfxMessageBox(sStationNameEn);
   ((CEdit *)GetDlgItem(IDC_EDIT2))->GetWindowText(sStationNameCh);
   ((CEdit *)GetDlgItem(IDC_EDIT3))->GetWindowText(sLongitude);
   ((CEdit *)GetDlgItem(IDC_EDIT4))->GetWindowText(sLatitude);
   ((CEdit *)GetDlgItem(IDC_EDIT5))->GetWindowText(sAudioDescriptionEn);
   ((CEdit *)GetDlgItem(IDC_EDIT6))->GetWindowText(sAudioDescriptionCh);
   ((CEdit *)GetDlgItem(IDC_EDIT7))->GetWindowText(sEnglishWave);
   ((CEdit *)GetDlgItem(IDC_EDIT8))->GetWindowText(sChineseWave);
  // ((CEdit *)GetDlgItem(IDC_EDIT9))->GetWindowText(sActive);
  //  bAcitve=atoi(sActive);  //字符串转布尔形
   sqlupdate.Format("update StationInfo set StationNameEn='%s',StationNameCh='%s',Longitude='%s',Latitude='%s',\
                AudioDescriptionEn='%s',AudioDescriptionCh='%s',EnglishWave='%s',ChineseWave='%s' where (StationNameEn='%s') and (StationNameCh='%s')", sStationNameEn,sStationNameCh,\
				sLongitude,sLongitude,sAudioDescriptionEn,sAudioDescriptionCh,sEnglishWave,sChineseWave,\
				str1,str2);//修改StationInfo数据
   
  sqladd.Format("insert into StationInfo(StationNameEn,StationNameCh,Longitude,Latitude,\
		    AudioDescriptionEn, AudioDescriptionCh,EnglishWave,ChineseWave) values ('%s','%s','%s',\
			'%s','%s','%s','%s','%s')",sStationNameEn,sStationNameCh,sLongitude,sLongitude,\
			sAudioDescriptionEn,sAudioDescriptionCh,sEnglishWave,sChineseWave);//添加StationInfo数据
   /*sqladd1.Format("insert into ServerMessages(AudioDescriptionEn,AudioDescriptionCh,\
	        EnglishWave,ChineseWave) values ('%s','%s','%s','%s')",sAudioDescriptionEn,\
			sAudioDescriptionCh,sEnglishWave,sChineseWave);//添加ServerMessages数据*/
  //  AfxMessageBox(sqladd);
    if (m_pConnection.ConnectAccess(mMDB_Path,"sri"))
	{   
		if(m_bADD)//添加数据，条件区分是修改数据还是添加数据
		{
			m_pConnection.Execute(sqladd);
	       // m_pConnection.Execute(sqladd1);
		}
        else
		{
			m_pConnection.Execute(sqlupdate);
		    
		}
	//	m_pConnection.Execute(sqlupdate1);
		//m_pConnection.Execute(_bstr_t(sqlStr),adCmdText);
	}

    Sleep(500);//延时,等数据库更改后再执行下面语句
	CEditStationInfoDlg::OnOK();//将修改后的数据保存到上一个窗体中的控件中
 }