optiondlg.cpp

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

// OptionDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "OptionDlg.h"
#include "TypeAddDlg.h"
#include "Columns.h"
#include "Column.h"

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

/////////////////////////////////////////////////////////////////////////////
// COptionDlg dialog

COptionDlg::COptionDlg(CWnd* pParent /*=NULL*/)
	: CDialog(COptionDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(COptionDlg)
	m_expire = expire;
	m_maxqty = maxqty;
	//}}AFX_DATA_INIT
}


void COptionDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(COptionDlg)
	DDX_Text(pDX, IDC_EDIT_EXPIRE, m_expire);
	DDV_MinMaxInt(pDX, m_expire, 1, 60);
	DDX_Text(pDX, IDC_EDIT_MAXQTY, m_maxqty);
	DDV_MinMaxInt(pDX, m_maxqty, 1, 10);
	DDX_Control(pDX, IDC_ADODC1, m_ad);
	DDX_Control(pDX, IDC_DATAGRID1, m_dg);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(COptionDlg, CDialog)
	//{{AFX_MSG_MAP(COptionDlg)
	ON_BN_CLICKED(IDC_BTN_TYPE_ADD, OnBtnTypeAdd)
	ON_BN_CLICKED(IDC_BTN_TYPE_DEL, OnBtnTypeDel)
	ON_BN_CLICKED(IDC_BTN_SAVE, OnBtnSave)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// COptionDlg message handlers

void COptionDlg::OnBtnTypeAdd() 
{
	CTypeAddDlg dlg;
	dlg.DoModal();
	m_ad.Refresh();	
}

void COptionDlg::OnBtnTypeDel() 
{
	CColumns columns;
	columns=m_dg.GetColumns();

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

	CString sql,tid;
	sql.Format("select typeID from 书籍信息表 where typeId=%d",strTypeid);
	g_adoDB.ExecuteQueryValue(sql,tid);
	if(!tid.IsEmpty())
	{
		MessageBox("该类别下还有书籍,不能删除!","错误");
		return;
	}

	sql.Format("Delete from 书籍类别表 where typeID='%s'",strTypeid);
	g_adoDB.Execute(sql);

	m_ad.Refresh();

}

void COptionDlg::OnBtnSave() 
{
	if(!UpdateData()) return;
	expire=m_expire;
	maxqty=m_maxqty;
	SaveConfig();
}