scorebdlg.cpp

这是一个课程设计

// ScorebDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Scoremanager.h"
#include "ScorebDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CScorebDlg dialog

int flag;
CScorebDlg::CScorebDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CScorebDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CScorebDlg)
	//}}AFX_DATA_INIT
}


void CScorebDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CScorebDlg)
	DDX_Control(pDX, IDCANCEL1, m_can1);
	DDX_Control(pDX, IDCANCEL, m_can);
	DDX_Control(pDX, IDC_SCORE_EDIT, m_bEdit);
	DDX_Control(pDX, IDC_SCORE_DEL, m_bDel);
	DDX_Control(pDX, IDC_SCORE_ADD, m_bAdd);
	DDX_Control(pDX, ID_SCORE_OK, m_bConfirm);
	DDX_Control(pDX, IDC_COURSENAME, m_strCoursename);
	DDX_Control(pDX, IDC_STUDNETNAME, m_strStudentName);
	DDX_Control(pDX, IDC_SCOREPEACE, m_strPeace);
	DDX_Control(pDX, IDC_SCOREEXAM, m_strExam);
	DDX_Control(pDX, IDC_LIST_SCORE, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CScorebDlg, CDialog)
	//{{AFX_MSG_MAP(CScorebDlg)
	ON_BN_CLICKED(IDC_SCORE_ADD, OnScoreAdd)
	ON_BN_CLICKED(IDC_SCORE_DEL, OnScoreDel)
	ON_NOTIFY(NM_CLICK, IDC_LIST_SCORE, OnClickListScore)
	ON_BN_CLICKED(IDC_SCORE_EDIT, OnScoreEdit)
	ON_BN_CLICKED(ID_SCORE_OK, OnScoreOk)
	ON_BN_CLICKED(IDCANCEL1, OnCancel1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CScorebDlg message handlers


 BOOL CScorebDlg::OnInitDialog()
 {
 	CDialog::OnInitDialog();
      if(!m_database.IsOpen())
	  {
        
           m_database.Open(_T("Scoremanager"));
           m_recordSet.m_pDatabase=&m_database;
	  }
               
	 m_list.InsertColumn(0,"编号");
     m_list.InsertColumn(1,"学生名");
     m_list.InsertColumn(2,"课程名");
     m_list.InsertColumn(3,"平时成绩");
     m_list.InsertColumn(4,"考试成绩");
	 m_list.InsertColumn(5,"总成绩");
     RECT rectList;
	 m_list.GetWindowRect(&rectList);
	 int wid=rectList.right-rectList.left-4;
 	 for(int i=0;i<6;i++)
	 m_list.SetColumnWidth(i,wid/6);
	 m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
     RefreshList();
	 CString strSQL;
	 strSQL.Format("select course_name from course where active_status='Y'");
	 m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	 for(int j=0;j<m_recordSet.GetRecordCount();j++)
	 {
		 CString temp;
		 m_recordSet.GetFieldValue("course_name",temp);
		 m_strCoursename.AddString(temp);
		 m_recordSet.MoveNext();
	 }
     m_recordSet.Close();
     m_strCoursename.SetCurSel(1);
	 strSQL.Format("select student_name from student where active_status='Y'");
	 m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	 for(int k=0;k<m_recordSet.GetRecordCount();k++)
	 {
		 CString temp;
		 m_recordSet.GetFieldValue("student_name",temp);
		 m_strStudentName.AddString(temp);
		 m_recordSet.MoveNext();
	 }


	 m_recordSet.Close();
	 m_strStudentName.SetCurSel(1);
     ResetButton();
         return true;
 }

void CScorebDlg::RefreshList()
{
m_list.DeleteAllItems();
CString strSQL;
strSQL.Format("select* from student,course,score  where student.student_no=score.student_no and course.course_no=score.course_no and score.active_status='Y'");
m_recordSet.Open(CRecordset::forwardOnly,strSQL);
for(int i=0;i<m_recordSet.GetRecordCount();i++)
{
CString temp;

temp.Format(_T("%d"),i+10);
 
m_list.InsertItem(i,temp);
m_recordSet.GetFieldValue("student_name",temp);
m_list.SetItemText(i,1,temp);
m_recordSet.GetFieldValue("course_name",temp);
m_list.SetItemText(i,2,temp);
m_recordSet.GetFieldValue("score_peacetime",temp);
m_list.SetItemText(i,3,temp);
int a;
a=atoi(temp);

m_recordSet.GetFieldValue("score_exam",temp);
m_list.SetItemText(i,4,temp);
int b;
b=atoi(temp);

int c=a*0.3+b*0.7;
temp.Format(_T("%d"),c); 
m_list.SetItemText(i,5,temp);
m_recordSet.MoveNext();
}
m_recordSet.Close();
}


void CScorebDlg::OnScoreAdd() 
{
m_strCoursename.EnableWindow(true);
m_strStudentName.EnableWindow(true);
m_strPeace.EnableWindow(true);
m_strExam.EnableWindow(true);
m_bAdd.EnableWindow(false);
m_bConfirm.EnableWindow(true);
m_bDel.EnableWindow(false);
m_bEdit.EnableWindow(false);
m_strPeace.SetWindowText("");
m_strExam.SetWindowText("");
	 flag=1;
	
}

void CScorebDlg::OnScoreDel() 
{

 int row=m_list.GetSelectionMark();
 CString s=m_list.GetItemText(row,1);
 CString s1=m_list.GetItemText(row,2); 

   if(s=="")
       MessageBox("请选择要删除的记录");
   else
   {  
	   if(MessageBox("确定要删除该记录吗？","删除询问",MB_OKCANCEL|MB_ICONQUESTION)==IDOK)	
	   {
	   CString strSQL;
	   strSQL.Format("update score set active_status='N' where score.student_no=(select student.student_no from student where student_name='%s') and score.course_no =(select  course.course_no from course where course_name='%s')", s,s1);
	   m_database.ExecuteSQL(strSQL);
	   }
   }
   RefreshList();
}	


void CScorebDlg::OnClickListScore(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int row=m_list.GetSelectionMark();
	CString s;
	s=m_list.GetItemText(row,1);
	m_strStudentName.SetWindowText(s);
	s=m_list.GetItemText(row,2);
	m_strCoursename.SetWindowText(s);
	s=m_list.GetItemText(row,3);
    m_strPeace.SetWindowText(s);
    s=m_list.GetItemText(row,4);
    m_strExam.SetWindowText(s);
    *pResult = 0;
}

void CScorebDlg::OnScoreEdit() 
{

	int row=m_list.GetSelectionMark();
        CString s=m_list.GetItemText(row,1);
        CString s1=m_list.GetItemText(row,2); 
       if(s=="")
	   MessageBox("请选择要修改的记录");
       
	   else
	   {m_strCoursename.EnableWindow(true);
        m_strStudentName.EnableWindow(true);
        m_strPeace.EnableWindow(true);
         m_strExam.EnableWindow(true);
        m_bAdd.EnableWindow(false);
        m_bConfirm.EnableWindow(true);
        m_bDel.EnableWindow(false);
        m_bEdit.EnableWindow(false);
        flag=2;
	   }	
}

void CScorebDlg::OnScoreOk() 
{
CString student,course,score_peacetime,score_exam,student_no,course_no;
m_strStudentName.GetWindowText(student);
m_strCoursename.GetWindowText(course);
m_strPeace.GetWindowText(score_peacetime);
m_strExam.GetWindowText(score_exam);
if(score_peacetime==""||score_exam=="")
{
	MessageBox("请输入成绩");
}
else
{
	CString strSQL;
	strSQL.Format("select*from student where active_status='Y' and student_name='%s'",student);
	CRecordset m_recordSet=&m_database;
    m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	m_recordSet.GetFieldValue("student_no",student_no);
	m_recordSet.Close();
	strSQL.Format("select*from course where active_status='Y' and course_name='%s'",course);
	
    m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	m_recordSet.GetFieldValue("course_no",course_no);
	m_recordSet.Close();
	if(flag==1)
	{
		strSQL.Format("insert into score(student_no,course_no,score_peacetime,active_status,score_exam) values('%s','%s','%s','Y','%s')",student_no,course_no,score_peacetime,score_exam);
		m_database.ExecuteSQL(strSQL);
        MessageBox("插入成功！");
	}
	else if(flag==2)
	{ 
		int row=m_list.GetSelectionMark();
        CString s=m_list.GetItemText(row,1);
        CString s1=m_list.GetItemText(row,2); 
       if(s=="")
       MessageBox("请选择");
    else
    {  
	   if(MessageBox("确定要修改该记录吗？","修改询问",MB_OKCANCEL|MB_ICONQUESTION)==IDOK)	
	   {
	   CString strSQL;
	   strSQL.Format("update score set student_no='%s',course_no='%s',score_peacetime='%s',score_exam='%s' where score.student_no=(select student.student_no from student where student_name='%s') and score.course_no =(select  course.course_no from course where course_name='%s')", student_no,course_no,score_peacetime,score_exam,s,s1);
	   m_database.ExecuteSQL(strSQL);
	   MessageBox("修改成功");
	   }
   }
   
}
}
RefreshList();
ResetButton();
}

void CScorebDlg::ResetButton()
{
m_strCoursename.EnableWindow(false);
m_strStudentName.EnableWindow(false);
m_strPeace.EnableWindow(false);
m_strExam.EnableWindow(false);
m_bAdd.EnableWindow(true);
m_bConfirm.EnableWindow(false);
m_bDel.EnableWindow(true);
m_bEdit.EnableWindow(true);
}

void CScorebDlg::OnCancel1() 
{
	ResetButton();
	
}

void CScorebDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	EndDialog(IDD_SCORE);
	//CDialog::OnCancel();
}