qryreaderdlg.cpp

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

// QryReaderDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "QryReaderDlg.h"
#include "ReaderModiDlg.h"
#include "Columns.h"
#include "Column.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQryReaderDlg dialog


CQryReaderDlg::CQryReaderDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQryReaderDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQryReaderDlg)
	m_name = _T("");
	m_readerid = _T("");
	//}}AFX_DATA_INIT
}


void CQryReaderDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQryReaderDlg)
	DDX_Text(pDX, IDC_EDIT_NAME, m_name);
	DDV_MaxChars(pDX, m_name, 10);
	DDX_Text(pDX, IDC_EDIT_READERID, m_readerid);
	DDX_Control(pDX, IDC_DATAGRID1, m_dg);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQryReaderDlg, CDialog)
	//{{AFX_MSG_MAP(CQryReaderDlg)
	ON_BN_CLICKED(IDC_BTN_QRY, OnBtnQry)
	ON_BN_CLICKED(IDC_BTN_DEL, OnBtnDel)
	ON_BN_CLICKED(IDC_BTN_MODI, OnBtnModi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQryReaderDlg message handlers

void CQryReaderDlg::OnBtnQry() 
{
	if(!UpdateData()) return;
	
	CString sql;
	sql="Select * from 读者表 where ";
	if(!m_readerid.IsEmpty())
		sql=sql+" readerID="+m_readerid+" and ";
	if(!m_name.IsEmpty())
		sql=sql+" 姓名 like '%"+m_name+"%'";

	if(sql.Right(6)=="where ")
	{
		MessageBox("必须至少输入一个条件!","提示");
		return;
	}
	if(sql.Right(4)=="and ")
		sql=sql.Left(sql.GetLength()-4);

	m_pRecordset=g_adoDB.ExecuteQuery(sql);
	m_dg.SetRefDataSource(NULL);   
	m_dg.SetRefDataSource((LPUNKNOWN)m_pRecordset);   
	m_dg.Refresh(); 


}

void CQryReaderDlg::OnBtnDel() 
{
	if(m_pRecordset==NULL ||
		(m_pRecordset->adoEOF && m_pRecordset->BOF)) return;

	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 strName;
	strName=column.GetText();
	
	CString sql,prompt;
	prompt.Format("确定要删除读者: %s 吗?",strName);
	if(MessageBox(prompt,"提示",MB_OKCANCEL)!=IDOK) return;
	sql.Format("delete from 读者表 where readerId=%d",atoi(strID));
	g_adoDB.Execute(sql);

	m_pRecordset->Requery(adCmdText);
	m_dg.Refresh(); 

}

void CQryReaderDlg::OnBtnModi() 
{
	if(m_pRecordset==NULL ||
		(m_pRecordset->adoEOF && m_pRecordset->BOF)) return;

	CReaderModiDlg dlg;

	CColumns columns;
	columns=m_dg.GetColumns();

	VARIANT index;
	CColumn column;
	index.vt=VT_INT;
	index.lVal=0;
	column=columns.GetItem(index);
	dlg.rid=column.GetText();//读者编号(ID)

	index.lVal=1;
	column=columns.GetItem(index);
	dlg.m_name=column.GetText();//读者姓名
	
	index.lVal=2;
	column=columns.GetItem(index);
	dlg.m_sex=(column.GetText()=="男")?0:1;//性别

	index.lVal=3;
	column=columns.GetItem(index);
	dlg.m_age=atoi(column.GetText());//年龄
	
	index.lVal=4;
	column=columns.GetItem(index);
	dlg.m_duty=column.GetText();//职务
	
	index.lVal=5;
	column=columns.GetItem(index);
	dlg.m_depart=column.GetText();//科室
	
	index.lVal=6;
	column=columns.GetItem(index);
	dlg.m_tel=column.GetText();//电话

	index.lVal=7;
	column=columns.GetItem(index);
	dlg.m_cert=column.GetText();//证件号

	index.lVal=8;
	column=columns.GetItem(index);
	dlg.m_remark=column.GetText();//备注

	dlg.DoModal();

	m_pRecordset->Requery(adCmdText);
	m_dg.Refresh(); 
}

BOOL CQryReaderDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	if(strUserLevel=="普通用户")
	{
		((CButton*)GetDlgItem(IDC_BTN_DEL))->EnableWindow(FALSE);//禁用删除按钮
		((CButton*)GetDlgItem(IDC_BTN_MODI))->EnableWindow(FALSE);//禁用修改按钮
	}	
	return TRUE;  
}