dcompany.cpp

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

// DCompany.cpp : implementation file
//

#include "stdafx.h"
#include "MyProject.h"
#include "DCompany.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDCompany dialog


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


void CDCompany::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDCompany)
	DDX_Control(pDX, IDC_BUTSAVE, m_ButSave);
	DDX_Control(pDX, IDC_BUTEXIT, m_ButExit);
	DDX_Control(pDX, IDC_BUTCHANGE, m_ButChange);
	DDX_Control(pDX, IDC_EDTTEL, m_EdtTel);
	DDX_Control(pDX, IDC_EDTNAME, m_EdtName);
	DDX_Control(pDX, IDC_EDTMAN, m_EdtMan);
	DDX_Control(pDX, IDC_EDTADDR, m_EdtAddr);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDCompany, CDialog)
	//{{AFX_MSG_MAP(CDCompany)
	ON_BN_CLICKED(IDC_BUTCHANGE, OnButchange)
	ON_BN_CLICKED(IDC_BUTSAVE, OnButsave)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDCompany message handlers

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

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

void CDCompany::Enabled(bool bEnabled)
{
	m_EdtAddr.EnableWindow(bEnabled);
	m_EdtName.EnableWindow(bEnabled);
	m_EdtTel.EnableWindow(bEnabled);
	m_EdtMan.EnableWindow(bEnabled);
	m_ButSave.EnableWindow(bEnabled);
	m_ButChange.EnableWindow(!bEnabled);
	m_ButExit.EnableWindow(!bEnabled);

}

void CDCompany::Display()
{
	RxRecordset rRst;
	rRst.Open("公司设置表");
	CString sName,sTel,sAddr,sMan;
	sName=rRst.GetFieldValue("公司名称");
	sTel=rRst.GetFieldValue("电话");
	sAddr=rRst.GetFieldValue("详细地址");
	sMan=rRst.GetFieldValue("联系人");
	m_EdtAddr.SetWindowText(sAddr);
	m_EdtName.SetWindowText(sName);
	m_EdtTel.SetWindowText(sTel);
	m_EdtMan.SetWindowText(sMan);	
}

void CDCompany::OnButchange() 
{
	this->Enabled(true);
	this->m_EdtName.SetFocus();

}

void CDCompany::OnButsave() 
{
	if(MessageBox("确定要保存修改吗？","系统提示",MB_OK|MB_ICONQUESTION)!=1)
		return;
	CString sName,sTel,sAddr,sMan;
	m_EdtAddr.GetWindowText(sAddr);
	m_EdtName.GetWindowText(sName);
	m_EdtTel.GetWindowText(sTel);
	m_EdtMan.GetWindowText(sMan);	
	CString sSQL;
	sSQL.Format("UPDATE 公司设置表 SET 公司名称='%s',详细地址='%s',联系人='%s',电话='%s'",sName,sAddr,sMan,sTel);
	RxRecordset rst;
	rst.Open(sSQL,adCmdText);
	this->Enabled(false);
	this->m_ButChange.SetFocus();

}

BOOL CDCompany::OnInitDialog() 
{
	CDialog::OnInitDialog();
	Display();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

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