queryscoredlg.cpp

最后的成品vc考勤ACCSEE数据库做的 还有文档 希望大家多多指点[e-mail]

// QueryScoreDlg.cpp : implementation file
//

#include "stdafx.h"
#include "studentscore.h"
#include "QueryScoreDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQueryScoreDlg dialog


CQueryScoreDlg::CQueryScoreDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQueryScoreDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQueryScoreDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CQueryScoreDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQueryScoreDlg)
	DDX_Control(pDX, IDC_COMBO_BY, m_compara);
	DDX_Control(pDX, IDC_LIST_QUERY_SCORE, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQueryScoreDlg, CDialog)
	//{{AFX_MSG_MAP(CQueryScoreDlg)
	ON_BN_CLICKED(IDC_RADIO1, OnRadio1)
	ON_BN_CLICKED(IDC_RADIO2, OnRadio2)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQueryScoreDlg message handlers

BOOL CQueryScoreDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	if(!m_database.IsOpen())
	{
		m_database.Open(_T("studentscore"));
		m_recordSet.m_pDatabase=&m_database;
	}
	sortBy=0;


	// return TRUE unless you set the focus to a control
	m_compara.AddString("大于");
	m_compara.AddString("小于");
	m_compara.AddString("等于");
    m_compara.SelectString(0,"大于");
	return TRUE;  	// EXCEPTION: OCX Property Pages should return FALSE
}

void CQueryScoreDlg::OnRadio1() 
{
	// TODO: Add your control notification handler code here
	sortBy=1;
}

void CQueryScoreDlg::OnRadio2() 
{
	// TODO: Add your control notification handler code here
	sortBy=2;
}

void CQueryScoreDlg::OnOK() 
{
	// TODO: Add extra validation here
//	CDialog::OnOK();
	bool bSuccess=true;
		if(sortBy==0)
		{
			MessageBox("请选择 查询条件");

		}
     if(sortBy==1)
	 {
		CEdit* pName=(CEdit*)this->GetDlgItem(IDC_QUERY_NAME);
		CEdit* pScore=(CEdit*)this->GetDlgItem(IDC_QUERY_SCORE);
	    CComboBox* pFilter=(CComboBox*)this->GetDlgItem(IDC_COMBO_BY);
		CString m_name,m_score,m_filter;
		pName->GetWindowText(m_name);
		pScore->GetWindowText(m_score);
		pFilter->GetWindowText(m_filter);
		if(m_name=="")
		{
			MessageBox("请输入学生的姓名");
		}
        if(m_filter=="大于")
		{
		   m_filter='>';
		}
	    else if(m_filter=="等于") 
		{
		   m_filter="=";
         
		}
	     else if(m_filter=="小于") 
		 {
		   m_filter="<";
         
		 }
	    if(bSuccess)
		{
		   CString strSQL;
		   if(m_score==""||m_filter=="")
	      strSQL.Format("select * from score,course where student_no in (select student_no from student where student_name='%s') and course.course_no=score.course_no",m_name);
           else 
	        strSQL.Format("select * from score,course where student_no in (select student_no from student where student_name='%s') and course.course_no=score.course_no and score.score%s%d",m_name,m_filter,atoi(m_score));
		     
		     m_list.DeleteColumn(2);
		     m_list.DeleteColumn(0);
			 m_list.DeleteColumn(1);
	        
			 m_list.DeleteAllItems();
			 m_list.InsertColumn(0,"课程名");
			 m_list.InsertColumn(1,"考勤分数");
			m_list.InsertColumn(2,"情况说明");

             RECT rectList;
             m_list.GetWindowRect(&rectList);
             int wid=rectList.right-rectList.left-4;
             for(int i=0;i<3;i++)
             m_list.SetColumnWidth(i,wid/3);
	         m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
			 m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	         for(int j=0;j<m_recordSet.GetRecordCount();j++)
			 {
		        CString temp;
		         m_recordSet.GetFieldValue("course_name",temp);
		         m_list.InsertItem(j,temp);
                 m_recordSet.GetFieldValue("score",temp);
		         m_list.SetItemText(j,1,temp);

                m_recordSet.GetFieldValue("beizhu",temp);
		         m_list.SetItemText(j,2,temp);


		         m_recordSet.MoveNext();
			 }
	        m_recordSet.Close();
		}

	 }
    if(sortBy==2)
	{
		CEdit* pCourse=(CEdit*)this->GetDlgItem(IDC_QUERY_COURSE);
		
		CString m_course;
		pCourse->GetWindowText(m_course);
		//pScore->GetWindowText(m_score);
		//pFilter->GetWindowText(m_filter);
		if(m_course=="")
		{
			MessageBox("请输入课名");
		}
        
	    else
		{
		   CString strSQL;
		   strSQL.Format("select * from student,score where student.student_no =score.student_no and course_no in (select course_no from course where course_name='%s')",m_course);
         m_list.DeleteColumn(2);
		   m_list.DeleteColumn(1);

		 m_list.DeleteColumn(0);
		 m_list.DeleteAllItems();
		 m_list.InsertColumn(0,"学生名");
		 m_list.InsertColumn(1,"考勤分数");
	     m_list.InsertColumn(2,"说明");

		  RECT rectList;
		  m_list.GetWindowRect(&rectList);
		  int wid=rectList.right-rectList.left-4;
		  for(int i=0;i<3;i++)
		  m_list.SetColumnWidth(i,wid/3);
		  m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);



		  m_recordSet.Open(CRecordset::forwardOnly,strSQL);
		  for(int j=0;j<m_recordSet.GetRecordCount();j++)
		  {
		  CString temp;
		  m_recordSet.GetFieldValue("student_name",temp);
		  m_list.InsertItem(j,temp);
          m_recordSet.GetFieldValue("score",temp);
		  m_list.SetItemText(j,1,temp);
          m_recordSet.GetFieldValue("beizhu",temp);
		  m_list.SetItemText(j,2,temp);


		  m_recordSet.MoveNext();
		  }
	    m_recordSet.Close();
		}
	}

}

void CQueryScoreDlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
		sortBy=2;
		CDialog::OnCancel();
}