// QueryScoreDlg.cpp : implementation file
//

#include "stdafx.h"
#include "AthleteInfo.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_LIST_QUERY_SCORE, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQueryScoreDlg, CDialog)
	//{{AFX_MSG_MAP(CQueryScoreDlg)
	ON_BN_CLICKED(IDOK, OnScoreQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

BOOL CQueryScoreDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	//如果數據庫未打開，則打開數據庫
	if(!m_database.IsOpen())
	{
		m_database.Open(_T("athleteinfo"));
	    m_recordSet.m_pDatabase=&m_database;
	}
	//用來標識CRadio
	
  return true;

}

void CQueryScoreDlg::OnScoreQuery() 
{
	// TODO: Add your control notification handler code here
	BOOL bSuccess=true;
	CEdit* pName=(CEdit*) this->GetDlgItem(IDC_QUERY_NAME);
	CString m_name;
	pName->GetWindowText(m_name);
    if(bSuccess)
	{
		CString strSQL;
		strSQL.Format("select * from item,score where athlete_no in (select athlete_no from athlete where athlete_name='%s') and item.item_no=score.item_no and score.active_status='Y'",m_name); 
		//m_list.DeleteColumn(2);
		m_list.DeleteColumn(1);
		m_list.DeleteColumn(0);
		m_list.DeleteAllItems();
        //m_list.InsertColumn(0,"運動員姓名");
		m_list.InsertColumn(0,"項目名稱");
		m_list.InsertColumn(1,"運動員成績");

		RECT rectList;
		m_list.GetWindowRect(&rectList);
		int wid=rectList.right-rectList.left-4;
		for(int i=0;i<2;i++)
			m_list.SetColumnWidth(i,wid/2);
		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("item_name",temp);
			m_list.InsertItem(j,temp);
			m_recordSet.GetFieldValue("score",temp);
			m_list.SetItemText(j,1,temp);
			m_recordSet.MoveNext();
			}
        m_recordSet.Close();
	}
	
}