teachdlg.cpp

这是一个课程设计

// TeachDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Scoremanager.h"
#include "TeachDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTeachDlg dialog

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


void CTeachDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTeachDlg)
	DDX_Control(pDX, IDCANCEL1, m_can1);
	DDX_Control(pDX, IDCANCEL, m_can);
	DDX_Control(pDX, IDC_TEACH_EDIT, m_bEdit);
	DDX_Control(pDX, IDC_TEACH_DEL, m_bDel);
	DDX_Control(pDX, IDC_TEACH_ADD, m_bAdd);
	DDX_Control(pDX, ID_TEACH_OK, m_bConfirm);
	DDX_Control(pDX, IDC_TEACHER_NAME, m_strTeacherName);
	DDX_Control(pDX, IDC_LIST_TEACH, m_list);
	DDX_Control(pDX, IDC_COURSE_NAME, m_strCourseName);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTeachDlg, CDialog)
	//{{AFX_MSG_MAP(CTeachDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST_TEACH, OnClickListTeach)
	ON_BN_CLICKED(IDC_TEACH_ADD, OnTeachAdd)
	ON_BN_CLICKED(IDC_TEACH_EDIT, OnTeachEdit)
	ON_BN_CLICKED(IDC_TEACH_DEL, OnTeachDel)
	ON_BN_CLICKED(ID_TEACH_OK, OnTeachOk)
	ON_BN_CLICKED(IDCANCEL1, OnCancel1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTeachDlg message handlers

BOOL CTeachDlg::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,"课程名");
     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);
     RefeshList();
	 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 teacher_name from teacher where active_status='Y'");
	 m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	 for(int k=0;k<m_recordSet.GetRecordCount();k++)
	 {
		 CString temp;
		 m_recordSet.GetFieldValue("teacher_name",temp);
		 m_strTeacherName.AddString(temp);
		 m_recordSet.MoveNext();
	 }


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

void CTeachDlg::RefeshList()
{
m_list.DeleteAllItems();
CString strSQL;
strSQL.Format("select* from teacher,course,teach  where teacher.teacher_no=teach.teacher_no and course.course_no=teach.course_no and teach.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+1); 

m_list.InsertItem(i,temp);
m_recordSet.GetFieldValue("teacher_name",temp);
m_list.SetItemText(i,1,temp);
m_recordSet.GetFieldValue("course_name",temp);
m_list.SetItemText(i,2,temp);
m_recordSet.MoveNext();
}
m_recordSet.Close();
}

void CTeachDlg::ResetButton()
{
m_strCourseName.EnableWindow(false);
m_strTeacherName.EnableWindow(false);
m_bAdd.EnableWindow(true);
m_bConfirm.EnableWindow(false);
m_bDel.EnableWindow(true);
m_bEdit.EnableWindow(true);
}

void CTeachDlg::OnClickListTeach(NMHDR* pNMHDR, LRESULT* pResult) 
{
	int row=m_list.GetSelectionMark();
	CString s;
	s=m_list.GetItemText(row,1);
	m_strTeacherName.SetWindowText(s);
	s=m_list.GetItemText(row,2);
	m_strCourseName.SetWindowText(s);
    *pResult = 0;
}

void CTeachDlg::OnTeachAdd() 
{
m_strCourseName.EnableWindow(true);
m_strTeacherName.EnableWindow(true);
m_bAdd.EnableWindow(false);
m_bConfirm.EnableWindow(true);
m_bDel.EnableWindow(false);
m_bEdit.EnableWindow(false);
flag1=1;
	
}

void CTeachDlg::OnTeachEdit() 
{
	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_strTeacherName.EnableWindow(true);
        m_bAdd.EnableWindow(false);
        m_bConfirm.EnableWindow(true);
        m_bDel.EnableWindow(false);
        m_bEdit.EnableWindow(false);
        flag1=2;
	   }
	
}

void CTeachDlg::OnTeachDel() 
{
 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 teach set active_status='N' where teach.teacher_no=(select teacher.teacher_no from teacher where teacher_name='%s') and teach.course_no =(select  course.course_no from course where course_name='%s')", s,s1);
	   m_database.ExecuteSQL(strSQL);
       MessageBox("删除成功");
	   }
   }
   RefeshList();
	
}

void CTeachDlg::OnTeachOk() 
{
CString teacher,course,teacher_no,course_no;
m_strTeacherName.GetWindowText(teacher);
m_strCourseName.GetWindowText(course);




	CString strSQL;
	strSQL.Format("select*from teacher where active_status='Y' and teacher_name='%s'",teacher);
	CRecordset m_recordSet=&m_database;
    m_recordSet.Open(CRecordset::forwardOnly,strSQL);
	m_recordSet.GetFieldValue("teacher_no",teacher_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(flag1==1)
	{
		strSQL.Format("insert into teach(teacher_no,course_no,active_status) values('%s','%s','Y')",teacher_no,course_no);
		m_database.ExecuteSQL(strSQL);
        MessageBox("插入成功！");
	}
	else if(flag1==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 teach set teacher_no='%s',course_no='%s' where teach.teacher_no=(select teacher.teacher_no from teacher where teacher_name='%s') and teach.course_no =(select  course.course_no from course where course_name='%s')", teacher_no,course_no,s,s1);
	   m_database.ExecuteSQL(strSQL);
	   MessageBox("修改成功");
	   }
   
   
}
}
RefeshList();
ResetButton();
	
}

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