www.pudn.com > vc++ODBC+student.zip > NaDilalog.cpp

// NaDilalog.cpp : implementation file 
// 
 
#include "stdafx.h" 
#include "lhwy.h" 
#include "NaDilalog.h" 
 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#undef THIS_FILE 
static char THIS_FILE[] = __FILE__; 
#endif 
 
///////////////////////////////////////////////////////////////////////////// 
// CNaDilalog dialog 
 
 
CNaDilalog::CNaDilalog(CWnd* pParent /*=NULL*/) 
	: CDialog(CNaDilalog::IDD, pParent) 
{  for(int i=0;i<5;i++) 
   for(int j=0;j<5;j++) 
	   score[i][j]=0; 
	//{{AFX_DATA_INIT(CNaDilalog) 
	//}}AFX_DATA_INIT 
} 
 
 
void CNaDilalog::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
	//{{AFX_DATA_MAP(CNaDilalog) 
	DDX_Control(pDX, IDC_SHOW, m_ShowButton); 
	DDX_Control(pDX, IDC_LIST2, m_ListCtrlj); 
	DDX_Control(pDX, IDC_LIST1, m_ListCtrlx); 
	DDX_Control(pDX, IDC_FIND, m_FindButton); 
	DDX_Control(pDX, IDC_ALL, m_AllButton); 
	//}}AFX_DATA_MAP 
} 
 
 
BEGIN_MESSAGE_MAP(CNaDilalog, CDialog) 
	//{{AFX_MSG_MAP(CNaDilalog) 
	ON_BN_CLICKED(IDC_ALL, OnAll) 
	ON_BN_CLICKED(IDC_FIND, OnFind) 
	ON_BN_CLICKED(IDC_SHOW, OnShow) 
	 
	//}}AFX_MSG_MAP 
END_MESSAGE_MAP() 
 
///////////////////////////////////////////////////////////////////////////// 
// CNaDilalog message handlers 
 
BOOL CNaDilalog::OnInitDialog()  
{ 
	CDialog::OnInitDialog(); 
 
   CDRecordset m_Set(&theApp.m_DB); 
   CBRecordset m_bSet(&theApp.m_DB); 
	// TODO: Add extra initialization here 
    unsigned i=0; 
	CODBCFieldInfo Info; 
	m_Set.Open(); 
	m_ListCtrlx.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES); 
	for( i=0;iEnableWindow(FALSE); 
     
 
	return TRUE;  // return TRUE unless you set the focus to a control 
	              // EXCEPTION: OCX Property Pages should return FALSE 
} 
int CNaDilalog::Show() 
{ 
	 
  int k=0; 
  
  do 
  {   
  CString s; 
  s.Format("%d",m_Set.m_column1); 
  m_ListCtrlx.InsertItem(k,s,0); 
  m_ListCtrlx.SetItemText(k,1,m_Set.m_column2); 
  s.Format("%.1f",m_Set.m_column3); 
  m_ListCtrlx.SetItemText(k,2,s); 
  s.Format("%.1f",m_Set.m_column4); 
  m_ListCtrlx.SetItemText(k,3,s); 
  s.Format("%.1f",m_Set.m_column5); 
  m_ListCtrlx.SetItemText(k,4,s); 
  s.Format("%.1f",m_Set.m_column6); 
  m_ListCtrlx.SetItemText(k,5,s); 
  s.Format("%.1f",m_Set.m_column7); 
  m_ListCtrlx.SetItemText(k,6,s); 
  s.Format("%.1f",m_Set.m_column8); 
  m_ListCtrlx.SetItemText(k,7,s); 
  s.Format("%.2f",m_Set.m_column9); 
  m_ListCtrlx.SetItemText(k,8,s); 
		 
  k++; 
  m_Set.MoveNext(); 
		 
  }  while(!m_Set.IsEOF()); 
  m_Set.Close(); 
  return k; 
   
} 
 
 
void CNaDilalog::OnAll()  
{ 
	// TODO: Add your control notification handler code here 
	if(m_Set.IsOpen()) 
	m_Set.Close(); 
	m_ListCtrlx.DeleteAllItems(); 
	m_Set.m_strFilter.Empty(); 
	m_Set.Open(); 
	m_nRecordCount=this->Show(); 
	m_Set.Open(AFX_DB_USE_DEFAULT_TYPE,"[NO2STUDENT]"); 
	m_nRecordCount+=this->Show(); 
	CString s; 
	s.Format("%d",m_nRecordCount); 
	GetDlgItem(IDC_STATICALL)->SetWindowText(s); 
	GetDlgItem(IDC_SHOW)->EnableWindow(TRUE); 
 
} 
 
 
 
void CNaDilalog::Select() 
{ 
 if(dlg.m_Getstring2==">=") 
 m_Set.m_strFilter.Format("[%s]>=%.2f",dlg.m_Getstring1,dlg.m_find); 
 if(dlg.m_Getstring2=="=") 
 m_Set.m_strFilter.Format("[%s]=%.2f",dlg.m_Getstring1,dlg.m_find); 
 if(dlg.m_Getstring2=="<=") 
 m_Set.m_strFilter.Format("[%s]<=%.2f",dlg.m_Getstring1,dlg.m_find); 
 m_Set.Requery(); 
 if(m_Set.IsEOF()) 
 {  
 m_Set.Close(); 
 return ; 
 } 
 else 
 { 
 this->Show(); 
 JS=TRUE; 
 } 
 
} 
void CNaDilalog::OnFind()  
{ 
if(m_Set.IsOpen()) 
m_Set.Close(); 
m_ListCtrlx.DeleteAllItems(); 
 JS=FALSE; 
if( dlg.DoModal()==IDOK) 
{  
m_Set.Open(); 
this->Select(); 
m_Set.Open(AFX_DB_USE_DEFAULT_TYPE,"[NO2STUDENT]"); 
this->Select(); 
if(JS==FALSE) 
AfxMessageBox("没有符合条件的记录"); 
} 
} 
 
 
 
void CNaDilalog::OnShow()  
{ 
	// TODO: Add your control notification handler code here 
	m_ListCtrlj.DeleteAllItems(); 
    CString s;    
    m_bSet.Open(); 
    int i=0; 
    m_bSet.MoveFirst(); 
    do 
	 {   
    m_ListCtrlj.InsertItem(i,m_bSet.m_column1,0); 
    i++; 
    m_bSet.MoveNext(); 
	} while(!m_bSet.IsEOF()); 
   m_bSet.MoveFirst(); 
   for(i=0;i<=4;i++) 
   {		   
    score[i][1]=m_bSet.m_column2; 
    score[i][3]=(float)m_bSet.m_column4; 
    score[i][4]=(float)m_bSet.m_column5; 
    if(i!=4) 
    m_bSet.MoveNext(); 
   } 
    m_bSet.Close(); 
 
   m_bSet.Open(AFX_DB_USE_DEFAULT_TYPE,"[NO2OBJECT]"); 
   for(i=0;i<5;i++) 
   { 
	score[i][1]+=m_bSet.m_column2; 
	score[i][2]=score[i][1]/m_nRecordCount; 
	score[i][3]+=(float)m_bSet.m_column4; 
	score[i][4]+=(float)m_bSet.m_column5; 
	if(!m_bSet.IsEOF()) 
   m_bSet.MoveNext(); 
   } 
   m_bSet.Close(); 
  for(i=0;i<5;i++) 
  {  
	s.Format("%.1f",score[i][1]); 
	m_ListCtrlj.SetItemText(i,1,s); 
	s.Format("%.2f",score[i][2]); 
    m_ListCtrlj.SetItemText(i,2,s); 
    s.Format("%d",(int)score[i][3]); 
   m_ListCtrlj.SetItemText(i,3,s); 
    s.Format("%d",(int)score[i][4]); 
    m_ListCtrlj.SetItemText(i,4,s); 
	} 
	   
	 
}