dbview.cpp

数据库操作程序,不错的,

// DBView.cpp : implementation of the CDBView class
//

#include "stdafx.h"
#include "DB.h"

#include "DBSet.h"
#include "DBDoc.h"
#include "DBView.h"
#include "ADDDLG.h"
#include "SORTDLG.h"
#include "JGLDLG.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDBView

IMPLEMENT_DYNCREATE(CDBView, CRecordView)

BEGIN_MESSAGE_MAP(CDBView, CRecordView)
	//{{AFX_MSG_MAP(CDBView)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_MODIFY, OnModify)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_SORT, OnSort)
	ON_BN_CLICKED(IDC_SEARCH, OnSearch)
	ON_BN_CLICKED(IDC_XUANKEGL, OnXuankegl)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, CRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CRecordView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDBView construction/destruction

CDBView::CDBView()
	: CRecordView(CDBView::IDD)
{
	//{{AFX_DATA_INIT(CDBView)
	m_pSet = NULL;
	//}}AFX_DATA_INIT
	// TODO: add construction code here

}

CDBView::~CDBView()
{
}

void CDBView::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDBView)
	DDX_FieldText(pDX, IDC_SNO, m_pSet->m_sno, m_pSet);
	DDX_FieldText(pDX, IDC_SNAME, m_pSet->m_sname, m_pSet);
	DDX_FieldText(pDX, IDC_SAGE, m_pSet->m_sage, m_pSet);
	//}}AFX_DATA_MAP
}

BOOL CDBView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return CRecordView::PreCreateWindow(cs);
}

void CDBView::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_dBSet;
	CRecordView::OnInitialUpdate();
	GetParentFrame()->RecalcLayout();
	ResizeParentToFit();
	if(m_quanxian=="非管理员")
	{
		GetDlgItem(IDC_ADD)->EnableWindow(false);
		GetDlgItem(IDC_DELETE)->EnableWindow(false);
		GetDlgItem(IDC_MODIFY)->EnableWindow(false);
	}
	else
	{
		GetDlgItem(IDC_ADD)->EnableWindow(true);
		GetDlgItem(IDC_DELETE)->EnableWindow(true);
		GetDlgItem(IDC_MODIFY)->EnableWindow(true);
	}


}

/////////////////////////////////////////////////////////////////////////////
// CDBView printing

BOOL CDBView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// default preparation
	return DoPreparePrinting(pInfo);
}

void CDBView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add extra initialization before printing
}

void CDBView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add cleanup after printing
}

/////////////////////////////////////////////////////////////////////////////
// CDBView diagnostics

#ifdef _DEBUG
void CDBView::AssertValid() const
{
	CRecordView::AssertValid();
}

void CDBView::Dump(CDumpContext& dc) const
{
	CRecordView::Dump(dc);
}

CDBDoc* CDBView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CDBDoc)));
	return (CDBDoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CDBView database support
CRecordset* CDBView::OnGetRecordset()
{
	return m_pSet;
}


/////////////////////////////////////////////////////////////////////////////
// CDBView message handlers

void CDBView::OnAdd() 
{
	
	ADDDLG mydlg;
again:	if(mydlg.DoModal()==IDOK)
	{
		if(mydlg.m_sno=="")
        {
			AfxMessageBox("请输入学号!");
			goto again;
		}
		if(mydlg.m_sname=="")
		{
			AfxMessageBox("请输入姓名!");
			goto again;
		}
	
		m_pSet->AddNew();
		m_pSet->m_sage=mydlg.m_sage;
		m_pSet->m_sname=mydlg.m_sname;
		m_pSet->m_sno=mydlg.m_sno;
		m_pSet->Update();
		m_pSet->Requery();
		m_pSet->MoveLast();
		UpdateData(FALSE);
	}
	
}

void CDBView::OnModify() 
{
	ADDDLG mydlg;
	mydlg.m_sage=m_pSet->m_sage;
	mydlg.m_sname=m_pSet->m_sname;
	mydlg.m_sno=m_pSet->m_sno;
	UpdateData(FALSE);
again:	if(mydlg.DoModal()==IDOK)
	{
		if(mydlg.m_sno=="")
        {
			AfxMessageBox("请输入学号!");
			goto again;
		}
		if(mydlg.m_sname=="")
		{
			AfxMessageBox("请输入姓名!");
			goto again;
		}
	
		m_pSet->Edit();
		m_pSet->m_sage=mydlg.m_sage;
		m_pSet->m_sname=mydlg.m_sname;
		m_pSet->m_sno=mydlg.m_sno;
		m_pSet->Update();
		m_pSet->Requery();
	}
	
}

void CDBView::OnDelete() 
{
	if(MessageBox("确认要删除吗？","提示",MB_YESNO|MB_ICONINFORMATION)==IDYES)
	{
		if(!m_pSet->IsEOF())
			m_pSet->Delete();
		m_pSet->Requery();
		UpdateData(FALSE);
	}


}

void CDBView::OnSort() 
{
	showflag=false;
	SORTDLG mydlg;
	if(mydlg.DoModal()==IDOK)
	{
	m_pSet->m_strSort=mydlg.strtemp;
	m_pSet->Requery();
	UpdateData(FALSE);
	}

	
}

void CDBView::OnSearch() 
{
	showflag=true;
	SORTDLG mydlg;
	if(mydlg.DoModal()==IDOK)
	{
	m_pSet->m_strSort=mydlg.strtemp;
	m_pSet->Requery();
	UpdateData(FALSE);
	}

}

void CDBView::OnXuankegl() 
{
	CJGLDLG mydlg;
	mydlg.DoModal();


	
}