?? scoredlg.cpp
字號:
// ScoreDlg.cpp : implementation file
//
#include "stdafx.h"
#include "StuManage.h"
#include "ScoreDlg.h"
#include "Columns.h"
#include "Column.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CScoreDlg dialog
extern CStuManageApp theApp;
CScoreDlg::CScoreDlg(CWnd* pParent /*=NULL*/)
: CDialog(CScoreDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CScoreDlg)
m_nScore = 0;
m_strCourseId = _T("");
m_strRemark = _T("");
m_strId = _T("");
m_strName = _T("");
m_nLookType = -1;
m_strCourseName = _T("");
//}}AFX_DATA_INIT
}
void CScoreDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CScoreDlg)
DDX_Control(pDX, IDC_DATAGRID_SCORE, m_dgScore);
DDX_Control(pDX, IDC_DATAGRID_RESULT, m_dgResult);
DDX_Text(pDX, IDC_EDIT_SCORE, m_nScore);
DDX_Text(pDX, IDC_EDIT_SCORE_COURSEID, m_strCourseId);
DDX_Text(pDX, IDC_EDIT_REMARK, m_strRemark);
DDX_Text(pDX, IDC_EDIT_SCORE_ID, m_strId);
DDX_Text(pDX, IDC_EDIT_SCORE_NAME, m_strName);
DDX_Radio(pDX, IDC_RADIO_STUDENTID, m_nLookType);
DDX_Text(pDX, IDC_EDIT_COURSE_NAME, m_strCourseName);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CScoreDlg, CDialog)
//{{AFX_MSG_MAP(CScoreDlg)
ON_BN_CLICKED(IDC_PUTIN_SCORE_BTN, OnPutinScoreBtn)
ON_BN_CLICKED(IDC_MODIFY_SCORE_BTN, OnModifyScoreBtn)
ON_BN_CLICKED(IDC_LOOKFOR_SCORE_BTN, OnLookforScoreBtn)
ON_BN_CLICKED(ID_EXECUTE_SCORE_BTN, OnExecuteScoreBtn)
ON_BN_CLICKED(IDC_DEL_SCORE_BTN, OnDelScoreBtn)
ON_EN_CHANGE(IDC_EDIT_SCORE_ID, OnChangeEditScoreId)
ON_EN_CHANGE(IDC_EDIT_SCORE_COURSEID, OnChangeEditScoreCourseid)
ON_BN_CLICKED(ID_LOOKFOR_SCORE_BTN, OnLookforScoreBtn)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CScoreDlg message handlers
BOOL CScoreDlg::OnInitDialog()
{
CDialog::OnInitDialog();
m_nLookType = 0;
// TODO: Add extra initialization here
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open("SELECT * FROM Score",_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
m_dgScore.SetRefDataSource(NULL);
m_dgScore.SetRefDataSource((LPUNKNOWN)m_pRecordset);
m_dgScore.SetColumnHeaders(2) ;
_variant_t var;
var = long(0);
m_dgScore.GetColumns().GetItem(var).SetCaption("學號");
m_dgScore.GetColumns().GetItem(var).SetWidth(50);
var = long(1);
m_dgScore.GetColumns().GetItem(var).SetCaption("姓名");
m_dgScore.GetColumns().GetItem(var).SetWidth(50);
var = long(2);
m_dgScore.GetColumns().GetItem(var).SetCaption("課程編號");
m_dgScore.GetColumns().GetItem(var).SetWidth(50);
var = long(3);
m_dgScore.GetColumns().GetItem(var).SetCaption("課程名稱");
m_dgScore.GetColumns().GetItem(var).SetWidth(50);
var = long(4);
m_dgScore.GetColumns().GetItem(var).SetCaption("分數");
m_dgScore.GetColumns().GetItem(var).SetWidth(30);
var = long(5);
m_dgScore.GetColumns().GetItem(var).SetCaption("備注");
m_dgScore.GetColumns().GetItem(var).SetWidth(50);
m_dgScore.Refresh();
UpdateData(FALSE);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CScoreDlg::OnPutinScoreBtn()
{
// TODO: Add your control notification handler code here
if(theApp.m_Level != 1)
{
AfxMessageBox("您無權錄入成績");
return;
}
m_nScore = 0;
m_strCourseId = "";
m_strRemark = "";
m_strId = "";
m_strName = "";
m_strCourseName = "";
AfxMessageBox("請輸入新的成績記錄");
action = 1;
UpdateData(FALSE);
}
void CScoreDlg::OnModifyScoreBtn()
{
// TODO: Add your control notification handler code here
if(theApp.m_Level != 1)
{
AfxMessageBox("您無權修改成績");
return;
}
if(AfxMessageBox("確定修改此成績嗎？",MB_YESNO)==IDYES)
action = 2;
}
void CScoreDlg::OnLookforScoreBtn()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
if(m_nLookType == 0)
{
m_strId = "";
AfxMessageBox("請輸入您要查找的學號");
return;
}
else if(m_nLookType == 1)
{
m_strCourseId = "";
AfxMessageBox("請輸入您要查找的課程號");
return;
}
UpdateData(FALSE);
}
void CScoreDlg::OnExecuteScoreBtn()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CString sql,str,studentid,courseid;
sql = "select * from Score ";
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
switch(action)
{
case 1:
m_pRecordset->AddNew();
m_pRecordset->PutCollect("CourseID",(_variant_t)m_strCourseId);
m_pRecordset->PutCollect("Remark",(_variant_t)m_strRemark);
m_pRecordset->PutCollect("ID",(_variant_t)m_strId);
m_pRecordset->PutCollect("Name",(_variant_t)m_strName);
m_pRecordset->PutCollect("CourseName",(_variant_t)m_strCourseName);
str.Format("%d",m_nScore);
m_pRecordset->PutCollect("Score",(_variant_t)str);
m_pRecordset->Update();
break;
case 2:
if(m_pRecordset->GetRecordCount()!=0)
{
m_pRecordset->MoveFirst();
while(!m_pRecordset->adoEOF)
{
studentid=m_pRecordset->GetCollect("ID").bstrVal;
courseid = m_pRecordset->GetCollect("CourseID").bstrVal;
if(studentid.CompareNoCase(m_strId) == 0 && courseid.CompareNoCase(m_strCourseId) == 0)
{
m_pRecordset->PutCollect("Remark",(_variant_t)m_strRemark);
str.Format("%d",m_nScore);
m_pRecordset->PutCollect("Score",(_variant_t)str);
}
m_pRecordset->MoveNext();
}
}
break;
case 3:
if(m_pRecordset->GetRecordCount()!=0)
{
m_pRecordset->MoveFirst();
while(!m_pRecordset->adoEOF)
{
studentid=m_pRecordset->GetCollect("ID").bstrVal;
courseid = m_pRecordset->GetCollect("CourseID").bstrVal;
if(studentid.CompareNoCase(m_strId) == 0 && courseid.CompareNoCase(m_strCourseId) == 0)
m_pRecordset->Delete(adAffectCurrent);
m_pRecordset->MoveNext();
}
}
break;
default:
break;
}
m_pRecordset->Close();
OnInitDialog();
UpdateData(FALSE);
action = 0;
}
void CScoreDlg::OnDelScoreBtn()
{
// TODO: Add your control notification handler code here
if(theApp.m_Level != 1)
{
AfxMessageBox("您無權刪除成績");
return;
}
if(AfxMessageBox("確定刪除此成績嗎？",MB_YESNO)==IDYES)
action = 3;
}
void CScoreDlg::OnChangeEditScoreId()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CString sql,str;
if(m_nLookType != 0)
return;
sql = "select * from Score where ID = '"+m_strId+"' ";
m_pRecordset_result.CreateInstance("ADODB.Recordset");
m_pRecordset_result->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
m_dgResult.SetRefDataSource(NULL);
m_dgResult.SetRefDataSource((LPUNKNOWN)m_pRecordset_result);
m_dgResult.SetColumnHeaders(2) ;
_variant_t var;
var = long(0);
m_dgResult.GetColumns().GetItem(var).SetCaption("學號");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
var = long(1);
m_dgResult.GetColumns().GetItem(var).SetCaption("姓名");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
var = long(2);
m_dgResult.GetColumns().GetItem(var).SetCaption("課程編號");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
var = long(3);
m_dgResult.GetColumns().GetItem(var).SetCaption("課程名稱");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
var = long(4);
m_dgResult.GetColumns().GetItem(var).SetCaption("分數");
m_dgResult.GetColumns().GetItem(var).SetWidth(30);
var = long(5);
m_dgResult.GetColumns().GetItem(var).SetCaption("備注");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
m_dgResult.Refresh();
UpdateData(FALSE);
}
void CScoreDlg::OnChangeEditScoreCourseid()
{
// TODO: Add your control notification handler code here
UpdateData(TRUE);
CString sql,str;
if(m_nLookType != 1)
return;
sql = "select * from Score where CourseID = '"+m_strCourseId+"' ";
m_pRecordset_result.CreateInstance("ADODB.Recordset");
m_pRecordset_result->Open((_variant_t)sql,_variant_t((IDispatch *)theApp.m_pConnection,true),adOpenDynamic,adLockPessimistic,adCmdText);
m_dgResult.SetRefDataSource(NULL);
m_dgResult.SetRefDataSource((LPUNKNOWN)m_pRecordset_result);
m_dgResult.SetColumnHeaders(2) ;
_variant_t var;
var = long(0);
m_dgResult.GetColumns().GetItem(var).SetCaption("學號");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
var = long(1);
m_dgResult.GetColumns().GetItem(var).SetCaption("姓名");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
var = long(2);
m_dgResult.GetColumns().GetItem(var).SetCaption("課程編號");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
var = long(3);
m_dgResult.GetColumns().GetItem(var).SetCaption("課程名稱");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
var = long(4);
m_dgResult.GetColumns().GetItem(var).SetCaption("分數");
m_dgResult.GetColumns().GetItem(var).SetWidth(30);
var = long(5);
m_dgResult.GetColumns().GetItem(var).SetCaption("備注");
m_dgResult.GetColumns().GetItem(var).SetWidth(50);
m_dgResult.Refresh();
UpdateData(FALSE);
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -