Vc++对数据库的动态刷新和多表切换

// mytestView.cpp : implementation of the CMytestView class // #include "stdafx.h" #include "mytest.h" #include "mytestSet.h" #include "mytestDoc.h" #include "mytestView.h" #include "zyxxset.h" #include "zyxxView.h" #include "dialogfilter.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CMytestView IMPLEMENT_DYNCREATE(CMytestView, CRecordView) BEGIN_MESSAGE_MAP(CMytestView, CRecordView) //{{AFX_MSG_MAP(CMytestView) ON_COMMAND(ID_RECORD_ADD, OnRecordAdd) ON_COMMAND(ID_RECORD_DELETE, OnRecordDelete) ON_COMMAND(ID_RECORD_FIRST, OnRecordFirst) ON_COMMAND(ID_RECORD_LAST, OnRecordLast) ON_COMMAND(ID_RECORD_NEXT, OnRecordNext) ON_COMMAND(ID_RECORD_PREV, OnRecordPrev) ON_COMMAND(ID_RECORD_SAVE, OnRecordSave) ON_COMMAND(ID_SORT_COUNT, OnSortCount) ON_COMMAND(ID_SORT_ID, OnSortId) ON_COMMAND(ID_SORT_BIRTHDAY, OnSortBirthday) ON_CBN_DROPDOWN(IDC_SPECIALITY, OnDropdownSpeciality) ON_COMMAND(ID_FILTER, OnFilter) //}}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() ///////////////////////////////////////////////////////////////////////////// // CMytestView construction/destruction CMytestView::CMytestView() : CRecordView(CMytestView::IDD) { //{{AFX_DATA_INIT(CMytestView) m_pSet = NULL; m_count = 0; m_total_number = 0; m_total_id = 0; m_pSet1=NULL; //}}AFX_DATA_INIT // TODO: add construction code here m_bAdd = false; } CMytestView::~CMytestView() { } void CMytestView::DoDataExchange(CDataExchange* pDX) { CRecordView::DoDataExchange(pDX); //{{AFX_DATA_MAP(CMytestView) DDX_Control(pDX, IDC_SPECIALITY, m_ctlType); DDX_Control(pDX, IDC_ID, m_ctlNo); DDX_Text(pDX, IDC_EDIT6, m_count); DDX_Text(pDX, IDC_TOTAL_NUMBER, m_total_number); DDX_Text(pDX, IDC_TOTAL_ID, m_total_id); DDX_DateTimeCtrl(pDX, IDC_BIRTHDAY, m_pSet->m_birthday); DDX_FieldText(pDX, IDC_ENGLISH, m_pSet->m_english, m_pSet); DDX_FieldText(pDX, IDC_ID, m_pSet->m_ID, m_pSet); DDX_FieldText(pDX, IDC_MATH, m_pSet->m_math, m_pSet); DDX_FieldText(pDX, IDC_MEMO, m_pSet->m_memo, m_pSet); DDX_FieldText(pDX, IDC_NAME, m_pSet->m_name, m_pSet); DDX_FieldText(pDX, IDC_PHYSICS, m_pSet->m_physics, m_pSet); DDX_FieldCBString(pDX, IDC_SEX, m_pSet->m_sex, m_pSet); DDX_FieldCBString(pDX, IDC_SPECIALITY, m_pSet->m_speciality, m_pSet); DDX_FieldCheck(pDX, IDC_PARTY, m_pSet->m_partymember, m_pSet); //}}AFX_DATA_MAP } BOOL CMytestView::PreCreateWindow(CREATESTRUCT& cs) { // TODO: Modify the Window class or styles here by modifying // the CREATESTRUCT cs return CRecordView::PreCreateWindow(cs); } void CMytestView::OnInitialUpdate() { m_pSet = &GetDocument()->m_mytestSet; CRecordView::OnInitialUpdate(); GetParentFrame()->RecalcLayout(); ResizeParentToFit(); CMytestSet myset; myset.Open(); nRecordNumber=0; while(!myset.IsEOF()) { nRecordNumber++; myset.MoveNext(); } myset.Close(); m_total_number = nRecordNumber; m_count = m_pSet->m_english+m_pSet->m_math+m_pSet->m_physics; m_total_id=1; UpdateData(FALSE); // } ///////////////////////////////////////////////////////////////////////////// // CMytestView printing BOOL CMytestView::OnPreparePrinting(CPrintInfo* pInfo) { // default preparation return DoPreparePrinting(pInfo); } void CMytestView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/) { // TODO: add extra initialization before printing } void CMytestView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/) { // TODO: add cleanup after printing } ///////////////////////////////////////////////////////////////////////////// // CMytestView diagnostics #ifdef _DEBUG void CMytestView::AssertValid() const { CRecordView::AssertValid(); } void CMytestView::Dump(CDumpContext& dc) const { CRecordView::Dump(dc); } CMytestDoc* CMytestView::GetDocument() // non-debug version is inline { ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CMytestDoc))); return (CMytestDoc*)m_pDocument; } #endif //_DEBUG ///////////////////////////////////////////////////////////////////////////// // CMytestView database support CRecordset* CMytestView::OnGetRecordset() { return m_pSet; } ///////////////////////////////////////////////////////////////////////////// // CMytestView message handlers void CMytestView::OnRecordAdd() { // TODO: Add your command handler code here m_pSet->AddNew(); m_bAdd = true; CEdit* pCtrl = (CEdit*)GetDlgItem(IDC_ID); int result = pCtrl->SetReadOnly(FALSE); m_count =0; UpdateData(FALSE); } void CMytestView::OnRecordDelete() { // TODO: Add your command handler code here m_pSet->Delete(); m_pSet->Requery(); UpdateData(false); } void CMytestView::OnRecordFirst() { // TODO: Add your command handler code here m_pSet->MoveFirst(); m_count = m_pSet->m_english+m_pSet->m_math+m_pSet->m_physics; m_total_id=1; UpdateData(FALSE); } void CMytestView::OnRecordLast() { // TODO: Add your command handler code here m_pSet->MoveLast(); m_count = m_pSet->m_english+m_pSet->m_math+m_pSet->m_physics; m_total_id= nRecordNumber; UpdateData(FALSE); } void CMytestView::OnRecordNext() { // TODO: Add your command handler code here if(!m_pSet->IsEOF()) { m_pSet->MoveNext(); m_count = m_pSet->m_english+m_pSet->m_math+m_pSet->m_physics; m_total_id++; UpdateData(FALSE); } else { m_total_id--; } } void CMytestView::OnRecordPrev() { // TODO: Add your command handler code here m_pSet->MovePrev(); m_count = m_pSet->m_english+m_pSet->m_math+m_pSet->m_physics; m_total_id--; UpdateData(FALSE); } void CMytestView::OnRecordSave() { // TODO: Add your command handler code here UpdateData(true); //用控件值更新成员变量； m_pSet->Update(); CEdit* pCtrl = (CEdit*)GetDlgItem(IDC_ID); int result = pCtrl->SetReadOnly(TRUE); } void CMytestView::OnSortCount() { // TODO: Add your command handler code here m_pSet->Close(); m_pSet->m_strSort="math+english+physics"; m_pSet->Open(); UpdateData(false); } void CMytestView::OnSortId() { // TODO: Add your command handler code here m_pSet->Close(); m_pSet->m_strSort="ID"; m_pSet->Open(); UpdateData(false); } void CMytestView::OnSortBirthday() { // TODO: Add your command handler code here m_pSet->Close(); m_pSet->m_strSort="birthday"; m_pSet->Open(); UpdateData(false); } void CMytestView::OnDropdownSpeciality() { // TODO: Add your control notification handler code here CMytestDoc *pDoc = (CMytestDoc *)GetDocument(); m_pSet1 = &pDoc->m_ZyxxSet; m_pSet1->m_strSort = "sp_ID"; m_pSet1->m_pDatabase = pDoc->GetDatabase(); CRecordView::OnInitialUpdate(); GetParentFrame()->RecalcLayout(); ResizeParentToFit(); CZyxxSet cZyxxSet; if(cZyxxSet.m_pDatabase == NULL) cZyxxSet.m_pDatabase = pDoc->GetDatabase(); try { cZyxxSet.Open(); } catch (CDBException *e) { AfxMessageBox(e->m_strError); e->Delete(); return; } // Fill in the type Of product m_ctlType.ResetContent(); if (cZyxxSet.IsOpen()) { while (!cZyxxSet.IsEOF()) { m_ctlType.AddString(cZyxxSet.m_sp_name); cZyxxSet.MoveNext(); } } m_ctlType.SetCurSel(0); cZyxxSet.Close(); } BOOL CMytestView::OnMove(UINT nIDMoveCommand) { // TODO: Add your specialized code here and/or call the base class if(m_bAdd) { m_bAdd = false; UpdateData(true); if(m_pSet->CanAppend()) m_pSet->Update(); m_pSet->Requery(); UpdateData(false); CEdit* pCtrl = (CEdit*)GetDlgItem(IDC_ID); int r