providermodidlg.cpp

自己编写的迷你图书馆的完整程序.VC6MFC编写的,Windows界面.数据采用了Sqlserver2000.压缩包中已包括了数据库.先附加数据库再运行.

// ProviderModiDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "ProviderModiDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProviderModiDlg dialog


CProviderModiDlg::CProviderModiDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CProviderModiDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CProviderModiDlg)
	m_addr = _T("");
	m_contact = _T("");
	m_name = _T("");
	m_post = _T("");
	m_remark = _T("");
	m_tel = _T("");
	//}}AFX_DATA_INIT
}


void CProviderModiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProviderModiDlg)
	DDX_Text(pDX, IDC_EDIT_ADDR, m_addr);
	DDV_MaxChars(pDX, m_addr, 100);
	DDX_Text(pDX, IDC_EDIT_CONTACT, m_contact);
	DDV_MaxChars(pDX, m_contact, 20);
	DDX_Text(pDX, IDC_EDIT_NAME, m_name);
	DDV_MaxChars(pDX, m_name, 30);
	DDX_Text(pDX, IDC_EDIT_POST, m_post);
	DDV_MaxChars(pDX, m_post, 6);
	DDX_Text(pDX, IDC_EDIT_REMARK, m_remark);
	DDV_MaxChars(pDX, m_remark, 100);
	DDX_Text(pDX, IDC_EDIT_TEL, m_tel);
	DDV_MaxChars(pDX, m_tel, 20);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProviderModiDlg, CDialog)
	//{{AFX_MSG_MAP(CProviderModiDlg)
	ON_BN_CLICKED(IDC_BTN_MODI, OnBtnModi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProviderModiDlg message handlers

void CProviderModiDlg::OnBtnModi() 
{
	if(!UpdateData()) return;
	if(m_name.IsEmpty())
	{
		MessageBox("请输入供应商名称!","错误");
		return;
	}
	if(m_addr.IsEmpty())
	{
		MessageBox("请输入地址!","错误");
		return;
	}
	if(m_post.IsEmpty())
	{
		MessageBox("请输入邮编!","错误");
		return;
	}
	if(m_contact.IsEmpty())
	{
		MessageBox("请输入联系人!","错误");
		return;
	}

	if(m_tel.IsEmpty())
	{
		MessageBox("请输入联系电话!","错误");
		return;
	}

	CString sql,name;
	sql.Format("Select 名称 from 供应商表 where 名称='%s' and providerID!=%d",m_name,atoi(pid));
	g_adoDB.ExecuteQueryValue(sql,name);
	if(!name.IsEmpty())
	{
		MessageBox("该供应商名称已经存在!","错误");//供应商名称必须唯一
		return;
	}

	sql.Format("Update 供应商表 set 名称='%s',地址='%s',邮编='%s',联系人='%s',电话='%s',备注='%s' "
		" where providerID=%d "
		,m_name,m_addr,m_post,m_contact,m_tel,m_remark,atoi(pid));
	g_adoDB.Execute(sql);

	OnCancel();	
}