dway.cpp

用VC+SQL实现的物流管理系统 “RxMediaPlayer” 文件夹中存放《物流综合管理系统》中《媒体播放平台》源程序 “数据库设置”文件夹中存放《物流综合管理系统》辅助工具《数据库设置》源程

// DWay.cpp : implementation file
//

#include "stdafx.h"
#include "MyProject.h"
#include "DWay.h"
#include "ExternDllHeader.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDWay dialog


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


void CDWay::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDWay)
	DDX_Control(pDX, IDC_EDTRETURN, m_EdtReturn);
	DDX_Control(pDX, IDC_STAID, m_StaID);
	DDX_Control(pDX, IDC_EDTNAME, m_EdtName);
	DDX_Control(pDX, IDC_BUTSURE, m_ButSure);
	DDX_Control(pDX, IDC_BUTEXIT, m_ButExit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDWay, CDialog)
	//{{AFX_MSG_MAP(CDWay)
	ON_EN_SETFOCUS(IDC_EDTRETURN, OnSetfocusEdtreturn)
	ON_BN_CLICKED(IDC_BUTSURE, OnButsure)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDWay message handlers

void CDWay::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

void CDWay::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}

BOOL CDWay::OnInitDialog() 
{
	CDialog::OnInitDialog();
	this->m_EdtName.Initialize(this->GetParent());
	CString sSQL;
	sSQL.Format("SELECT * FROM 驾驶员信息表 WHERE 回厂标志=1");
	RxRecordset rst;
	rst.Open(sSQL,adCmdText);
	m_EdtName.SetRecordset(rst);
	m_EdtName.SetSelectField("姓名");
	CTime time;
	time=time.GetCurrentTime();
	CString sDate;
	sDate=CTimeToCString(time); 
	m_StaID.SetWindowText(sDate);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDWay::OnSetfocusEdtreturn() 
{
	
}

void CDWay::OnButsure() 
{	
	CString sName,sDate,sReturn;
	m_EdtName.GetWindowText(sName);
	sName=ado.FieldToOtherField("驾驶员信息表","姓名",sName,"编号",1);
	m_StaID.GetWindowText(sDate);
	m_EdtReturn.GetWindowText(sReturn);
	RxRecordset rst;
	CString sSQL;
	sSQL.Format("DELETE 在途反馈表 WHERE 司机编号=%s",sName);
	rst.Open(sSQL,adCmdText);
	sSQL.Format("INSERT INTO 在途反馈表 VALUES(%s,'%s','%s')",sName,sDate,sReturn);
	rst.Open(sSQL,adCmdText);
	MessageBox("反馈成功！","系统提示",MB_OK|MB_ICONINFORMATION);
	this->m_EdtReturn.SetWindowText("");
	this->m_EdtName.SetCaption("");
	this->m_EdtName.SetFocus();
}

void CDWay::OnButexit() 
{
	this->OnCancel();	
}