codbcdlg.cpp

教学管理系统

// COdbcDlg.cpp : implementation file
//

#include "stdafx.h"
#include "COdbc.h"
#include "COdbcDlg.h"
#include "StudentsDlg.h"
#include "StudentSee.h"
#include "StudentQryidDlg.h"
#include "StudentGet.h"
#include "StudentCountAgeDlg.h"
#include "StudentCountClassDlg.h"
#include "StudentCountSexDlg.h"
#include "TeacherCtrDlg.h"
#include "TeacherSee.h"
#include "GetTeacherQuery.h"
#include "TeacherQueryDlg.h"
#include "TeacherCountCDlg.h"
#include "TeacherCountCourse.h"
#include "TeacherCountDepartDlg.h"
#include "TeacherCountLevelDlg.h"
#include "CourseCtrDlg.h"
#include "CourseSeeDlg.h"
#include "CourseQueryName.h"
#include "ChoseCourseCtr.h"
#include "CourseQueryType.h"
#include "CourseQueryTypeGet.h"
#include "ChoseCourseSee.h"
#include "ChoseCourseQueryName.h"
#include "ChoseCourseCname.h"
#include "ChoseCountCname.h"
#include "ChoseCountClass.h"
#include "Score.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCOdbcDlg dialog

CCOdbcDlg::CCOdbcDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCOdbcDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCOdbcDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CCOdbcDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCOdbcDlg)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CCOdbcDlg, CDialog)
	//{{AFX_MSG_MAP(CCOdbcDlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_COMMAND(ID_STUDENT_CONTROL, OnStudentControl)
	ON_COMMAND(ID_SEE, OnSee)
	ON_COMMAND(ID_QUERY_STUDENT_ID, OnQueryStudentId)
	ON_COMMAND(ID_QUERY_STUDENT_NAME, OnQueryStudentName)
	ON_COMMAND(ID_QUERY_STUDENT_AGE, OnQueryStudentAge)
	ON_COMMAND(ID_QUERY_STUDENT_SEX, OnQueryStudentSex)
	ON_COMMAND(ID_QUERY_STUDENT_CLASS, OnQueryStudentClass)
	ON_COMMAND(ID_QUERY_STUDENT_DEPARTMENT, OnQueryStudentDepartment)
	ON_COMMAND(ID_COUNT_STUDENT_SEX, OnCountStudentSex)
	ON_COMMAND(ID_COUNT_STUDENT_AGE, OnCountStudentAge)
	ON_COMMAND(ID_COUNT_STUDENT_CLASS, OnCountStudentClass)
	ON_COMMAND(ID_TEACHER_CONTROL, OnTeacherControl)
	ON_COMMAND(ID_TEACHER_SEE, OnTeacherSee)
	ON_COMMAND(ID_QUERY_TEACHER_NAME, OnQueryTeacherName)
	ON_COMMAND(ID_QUERY_TEACHER_DE, OnQueryTeacherDe)
	ON_COMMAND(ID_QUERY_TEACHER_JOB, OnQueryTeacherJob)
	ON_COMMAND(ID_QUERY_TEACHER_COURSE, OnQueryTeacherCourse)
	ON_COMMAND(ID_QUERY_TEACHER_CLASS, OnQueryTeacherClass)
	ON_COMMAND(ID_COUNT_TEACHER_DE, OnCountTeacherDe)
	ON_COMMAND(ID_COUNT_TEACHER_CLASS, OnCountTeacherClass)
	ON_COMMAND(ID_COUNT_TEACHER_COURSE, OnCountTeacherCourse)
	ON_COMMAND(ID_COUNT_TEACHER_JOB, OnCountTeacherJob)
	ON_COMMAND(ID_CHOSECOURSE_CONTROL, OnChosecourseControl)
	ON_COMMAND(ID_CHOSECOURSE_COUNTCLASS, OnChosecourseCountclass)
	ON_COMMAND(ID_CHOSECOURSE_COUNTCNAME, OnChosecourseCountcname)
	ON_COMMAND(ID_CHOSECOURSE_QUERYCLASS, OnChosecourseQueryclass)
	ON_COMMAND(ID_CHOSECOURSE_QUERYCNAME, OnChosecourseQuerycname)
	ON_COMMAND(ID_CHOSECOURSE_QUERYNAME, OnChosecourseQueryname)
	ON_COMMAND(ID_CHOSECOURSE_SEE, OnChosecourseSee)
	ON_COMMAND(ID_COURSE_CONTROL, OnCourseControl)
	ON_COMMAND(ID_COURSE_QUERYID, OnCourseQueryid)
	ON_COMMAND(ID_COURSE_QUERYNAME, OnCourseQueryname)
	ON_COMMAND(ID_COURSE_QUERYTYPE, OnCourseQuerytype)
	ON_COMMAND(ID_COURSE_SEE, OnCourseSee)
	ON_COMMAND(ID_SCORE, OnScore)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCOdbcDlg message handlers

BOOL CCOdbcDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// Add "About..." menu item to system menu.

	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE  unless you set the focus to a control
}

void CCOdbcDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CCOdbcDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CCOdbcDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CCOdbcDlg::OnStudentControl() 
{
	// TODO: Add your command handler code here
	CStudentsDlg pDlg;
	pDlg.DoModal();
}

void CCOdbcDlg::OnSee() 
{
	// TODO: Add your command handler code here
	CStudentSee dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnQueryStudentId() 
{
	// TODO: Add your command handler code here
	CString pstr="学号:";
	CStudentGet gdlg(NULL,TRUE,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CStudentQryidDlg dlg;
		title="id";
		dlg.OnitialCustom(title,str,endstr);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryStudentName() 
{
	// TODO: Add your command handler code here
	CString pstr="姓名:";
	CStudentGet gdlg(NULL,FALSE,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CStudentQryidDlg dlg;
		title="name";
		dlg.OnitialCustom(title,str);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryStudentAge() 
{
	// TODO: Add your command handler code here
	CString pstr="年龄:";
	CStudentGet gdlg(NULL,TRUE,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CStudentQryidDlg dlg;
		title="age";
		dlg.OnitialCustom(title,str,endstr);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryStudentSex() 
{
	// TODO: Add your command handler code here
	CString pstr="性别:";
	CStudentGet gdlg(NULL,FALSE,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CStudentQryidDlg dlg;
		title="sex";
		dlg.OnitialCustom(title,str);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryStudentClass() 
{
	// TODO: Add your command handler code here
	CString pstr="班级:";
	CStudentGet gdlg(NULL,TRUE,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CStudentQryidDlg dlg;
		title="class";
		dlg.OnitialCustom(title,str,endstr);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryStudentDepartment() 
{
	// TODO: Add your command handler code here
	CString pstr="系别:";
	CStudentGet gdlg(NULL,TRUE,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CStudentQryidDlg dlg;
		title="department";
		dlg.OnitialCustom(title,str,endstr);
		dlg.DoModal();
	}
}
void CCOdbcDlg::GetInum(CString lstr,CString rstr)
{
	str=lstr;
	if(rstr=="")
		endstr=str;
	else endstr=rstr;
}

void CCOdbcDlg::OnCountStudentSex() 
{
	// TODO: Add your command handler code here
	CStudentCountSexDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCountStudentAge() 
{
	// TODO: Add your command handler code here
	CStudentCountAgeDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCountStudentClass() 
{
	// TODO: Add your command handler code here
	CStudentCountClassDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnTeacherControl() 
{
	// TODO: Add your command handler code here
	CTeacherCtrDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnTeacherSee() 
{
	// TODO: Add your command handler code here
	CTeacherSee dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnQueryTeacherName() 
{
	// TODO: Add your command handler code here
	CString pstr="姓名:";
	CGetTeacherQuery gdlg(NULL,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CTeacherQueryDlg dlg;
		title="name";
		dlg.OnitialCustom(title,str);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryTeacherDe() 
{
	// TODO: Add your command handler code here
	CString pstr="系别:";
	CGetTeacherQuery gdlg(NULL,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CTeacherQueryDlg dlg;
		title="department";
		dlg.OnitialCustom(title,str);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryTeacherJob() 
{
	// TODO: Add your command handler code here
	CString pstr="职称:";
	CGetTeacherQuery gdlg(NULL,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CTeacherQueryDlg dlg;
		title="level";
		dlg.OnitialCustom(title,str);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryTeacherCourse() 
{
	// TODO: Add your command handler code here
	CString pstr="课程:";
	CGetTeacherQuery gdlg(NULL,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CTeacherQueryDlg dlg;
		title="Course";
		dlg.OnitialCustom(title,str);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnQueryTeacherClass() 
{
	// TODO: Add your command handler code here
	CString pstr="班级:";
	CGetTeacherQuery gdlg(NULL,pstr);
	if(gdlg.DoModal()!=IDCANCEL)
	{
		CTeacherQueryDlg dlg;
		title="Class";
		dlg.OnitialCustom(title,str);
		dlg.DoModal();
	}
}

void CCOdbcDlg::OnCountTeacherDe() 
{
	// TODO: Add your command handler code here
	CTeacherCountDepartDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCountTeacherClass() 
{
	// TODO: Add your command handler code here
	CTeacherCountCDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCountTeacherCourse() 
{
	// TODO: Add your command handler code here
	CTeacherCountCourse dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCountTeacherJob() 
{
	// TODO: Add your command handler code here
	CTeacherCountLevelDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnChosecourseControl() 
{
	// TODO: Add your command handler code here
	CChoseCourseCtr dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnChosecourseCountclass() 
{
	// TODO: Add your command handler code here
	CChoseCountClass dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnChosecourseCountcname() 
{
	// TODO: Add your command handler code here
	CChoseCountCname dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnChosecourseQueryclass() 
{
	// TODO: Add your command handler code here
	
}

void CCOdbcDlg::OnChosecourseQuerycname() 
{
	// TODO: Add your command handler code here
	CChoseCourseCname dlg;
	dlg.DoModal();

}

void CCOdbcDlg::OnChosecourseQueryname() 
{
	// TODO: Add your command handler code here
	CChoseCourseQueryName dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnChosecourseSee() 
{
	// TODO: Add your command handler code here
	CChoseCourseSee dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCourseControl() 
{
	// TODO: Add your command handler code here
	CCourseCtrDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCourseQueryid() 
{
	// TODO: Add your command handler code here
	
}

void CCOdbcDlg::OnCourseQueryname() 
{
	// TODO: Add your command handler code here
	CCourseQueryName dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCourseQuerytype() 
{
	// TODO: Add your command handler code here
	CCourseQueryType dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnCourseSee() 
{
	// TODO: Add your command handler code here
	CCourseSeeDlg dlg;
	dlg.DoModal();
}

void CCOdbcDlg::OnScore() 
{
	// TODO: Add your command handler code here
	CScore dlg;
	dlg.DoModal();
}