provideradddlg.cpp

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

// ProviderAddDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "ProviderAddDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProviderAddDlg dialog


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


void CProviderAddDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProviderAddDlg)
	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_TEL, m_tel);
	DDV_MaxChars(pDX, m_tel, 20);
	DDX_Text(pDX, IDC_EDIT_REMARK, m_remark);
	DDV_MaxChars(pDX, m_remark, 100);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProviderAddDlg, CDialog)
	//{{AFX_MSG_MAP(CProviderAddDlg)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProviderAddDlg message handlers

void CProviderAddDlg::OnBtnAdd() 
{
	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'",m_name);
	g_adoDB.ExecuteQueryValue(sql,name);//查询该供应商名称是否已经存在
	if(!name.IsEmpty())	//如果已经存在
	{
		MessageBox("该供应商名称已经存在!","错误");
		return;
	}

	CString strID;
	g_adoDB.ExecuteQueryValue("Select max(providerID) from 供应商表",strID);
	int newID=atoi(strID)+1;

	sql.Format("Insert into 供应商表 values(%d,'%s','%s','%s','%s','%s','%s')"
		,newID,m_name,m_addr,m_post,m_contact,m_tel,m_remark);
	g_adoDB.Execute(sql);
	
	OnCancel();	
}