providermgrdlg.cpp

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

// ProviderMgrDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "ProviderMgrDlg.h"
#include "ProviderAddDlg.h"
#include "ProviderModiDlg.h"
#include "Columns.h"
#include "Column.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProviderMgrDlg dialog


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


void CProviderMgrDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProviderMgrDlg)
	DDX_Control(pDX, IDC_ADODC1, m_ad);
	DDX_Control(pDX, IDC_DATAGRID1, m_dg);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProviderMgrDlg, CDialog)
	//{{AFX_MSG_MAP(CProviderMgrDlg)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	ON_BN_CLICKED(IDC_BTN_DEL, OnBtnDel)
	ON_BN_CLICKED(IDC_BTN_MODI, OnBtnModi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProviderMgrDlg message handlers

void CProviderMgrDlg::OnBtnAdd() 
{
	CProviderAddDlg dlg;
	dlg.DoModal();
	m_ad.Refresh();
}

void CProviderMgrDlg::OnBtnDel() 
{
	CColumns columns;
	columns=m_dg.GetColumns();
	CColumn column;

	VARIANT index;
	index.vt=VT_INT;
	
	index.lVal=0;
	column=columns.GetItem(index);
	CString strID;
	strID=column.GetText();

	index.lVal=1;
	column=columns.GetItem(index);
	CString strProvider;
	strProvider=column.GetText();
	
	CString sql,prompt,pid;
	sql.Format("Select providerID from 书籍信息表 where providerID=%d",atoi(strID));
	g_adoDB.ExecuteQueryValue(sql,pid);
	if(!pid.IsEmpty())
	{
		MessageBox("目前还有该供应商的书籍, 不能删除!","错误");
		return;
	}
	prompt.Format("确定要删除供应商: %s 吗?",strProvider);
	if(MessageBox(prompt,"提示",MB_OKCANCEL)==IDOK)
	{
		sql.Format("delete from 供应商表 where providerId=%d",atoi(strID));
		g_adoDB.Execute(sql);

		m_ad.Refresh();
	}

}

void CProviderMgrDlg::OnBtnModi() 
{
	CProviderModiDlg dlg;

	CColumns columns;
	columns=m_dg.GetColumns();

	VARIANT index;
	CColumn column;
	index.vt=VT_INT;
	index.lVal=0;
	column=columns.GetItem(index);
	dlg.pid=column.GetText();//供应商编号
	index.lVal=1;
	column=columns.GetItem(index);
	dlg.m_name=column.GetText();//供应商名称
	index.lVal=2;
	column=columns.GetItem(index);
	dlg.m_addr=column.GetText();//供应商地址
	index.lVal=3;
	column=columns.GetItem(index);
	dlg.m_post=column.GetText();//邮编
	index.lVal=4;
	column=columns.GetItem(index);
	dlg.m_contact=column.GetText();//联系人
	index.lVal=5;
	column=columns.GetItem(index);
	dlg.m_tel=column.GetText();//电话
	index.lVal=6;
	column=columns.GetItem(index);
	dlg.m_remark=column.GetText();//备注

	dlg.DoModal();
	m_ad.Refresh();
	
}