schoolmanagesys_2dlg.cpp

学校管理系统

/****************************************/
/*		SchoolManageSystem			    */
/*设计者：全佳营						*/
/*时间：2004.5.9-2004-5-18				*/
/*Email:[e-mail]				*/
/****************************************/

// SchoolManageSys_2Dlg.cpp : 实现文件
//

#include "stdafx.h"
#include "SchoolManageSys_2.h"
#include "SchoolManageSys_2Dlg.h"
#include ".\schoolmanagesys_2dlg.h"
#include "DialogAboutMe.h"
#include "DialogHelp.h"
#include "DataGridShow.h"
#include "Dialog_Login.h"
#include "Dialog_Amend_users.h"
#include "Dialog_Query.h"
#include "DialogNew.h"
#include "Dialog_DeleteData.h"
#include "DialogAmendData.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#endif


// 用于应用程序“关于”菜单项的 CAboutDlg 对话框

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();
	virtual BOOL OnInitDialog();
// 对话框数据
	enum { IDD = IDD_ABOUTBOX };

	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV 支持

// 实现
protected:
	DECLARE_MESSAGE_MAP()
};

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

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

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
END_MESSAGE_MAP()

BOOL CAboutDlg::OnInitDialog(){
	CDialog::OnInitDialog();
	theApp.m_pSkin->ApplySkin((int)m_hWnd);
	return TRUE;
}
// CSchoolManageSys_2Dlg 对话框



CSchoolManageSys_2Dlg::CSchoolManageSys_2Dlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSchoolManageSys_2Dlg::IDD, pParent)
{
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
	m_bsetskin1=FALSE;
	m_bsetskin2=FALSE;
	m_bsetskin3=FALSE;
	m_isstudent=FALSE;
	ischangephoto=FALSE;
}

void CSchoolManageSys_2Dlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_COMBO_QUERRY, m_ListQuery);
	DDX_Control(pDX, IDC_DATAGRID_INFO, m_Datagridinfo);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc1);
	DDX_Control(pDX, IDC_TREE_MAIN, m_Treeinfo);
	DDX_Control(pDX, IDC_LIST_INFO, m_Listinfo);
}

BEGIN_MESSAGE_MAP(CSchoolManageSys_2Dlg, CDialog)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	//}}AFX_MSG_MAP
	ON_COMMAND(ID_ABOUT, OnAbout)
	ON_COMMAND(ID_HELP_FILE, OnHelpFile)
	ON_BN_CLICKED(IDC_BUTTON_EXIT, OnBnClickedButtonExit)
	ON_COMMAND(ID_EXIT, OnExit)
	ON_BN_CLICKED(IDC_BUTTON_OK, OnBnClickedButtonOk)
	ON_COMMAND(ID_ABOUTME, OnAboutme)
	ON_CBN_SELCHANGE(IDC_COMBO_QUERRY, OnCbnSelchangeComboQuerry)
	ON_COMMAND(ID_DISPLAY_DATAGRID, OnDisplayDatagrid)
	ON_UPDATE_COMMAND_UI(ID_Menu, OnUpdateMenu)
	ON_COMMAND(ID_Menu, OnMenu)
	ON_COMMAND(ID_CHIZH, OnChizh)
	ON_UPDATE_COMMAND_UI(ID_CHIZH, OnUpdateChizh)
	ON_COMMAND(ID_DEFAULT, OnDefault)
	ON_UPDATE_COMMAND_UI(ID_DEFAULT, OnUpdateDefault)
	ON_COMMAND(ID_B, OnB)
	ON_UPDATE_COMMAND_UI(ID_B, OnUpdateB)
	ON_COMMAND(ID_GALAXY, OnGalaxy)
	ON_UPDATE_COMMAND_UI(ID_GALAXY, OnUpdateGalaxy)
	ON_COMMAND(ID_MAC, OnMac)
	ON_UPDATE_COMMAND_UI(ID_MAC, OnUpdateMac)
	ON_COMMAND(ID_MEDIA, OnMedia)
	ON_UPDATE_COMMAND_UI(ID_MEDIA, OnUpdateMedia)
	ON_COMMAND(ID_METALLIC, OnMetallic)
	ON_UPDATE_COMMAND_UI(ID_METALLIC, OnUpdateMetallic)
	ON_COMMAND(ID_PAPER, OnPaper)
	ON_UPDATE_COMMAND_UI(ID_PAPER, OnUpdatePaper)
	ON_COMMAND(ID_PASOMOD, OnPasomod)
	ON_UPDATE_COMMAND_UI(ID_PASOMOD, OnUpdatePasomod)
	ON_COMMAND(ID_GREEN, OnGreen)
	ON_UPDATE_COMMAND_UI(ID_GREEN, OnUpdateGreen)
	ON_COMMAND(ID_TOPSECRET, OnTopsecret)
	ON_UPDATE_COMMAND_UI(ID_TOPSECRET, OnUpdateTopsecret)
	ON_COMMAND(ID_WEB, OnWeb)
	ON_UPDATE_COMMAND_UI(ID_WEB, OnUpdateWeb)
	ON_COMMAND(ID_CONNECTION, OnConnection)
	ON_COMMAND(ID_DISCONNECTION, OnDisconnection)
	ON_COMMAND(ID_SET_LOGIN, OnSetLogin)
	ON_NOTIFY(TVN_SELCHANGED, IDC_TREE_MAIN, OnTvnSelchangedTreeMain)
	ON_NOTIFY(NM_RCLICK, IDC_TREE_MAIN, OnNMRclickTreeMain)
	ON_NOTIFY(LVN_ITEMACTIVATE, IDC_LIST_INFO, OnLvnItemActivateListInfo)
	ON_BN_CLICKED(IDC_BUTTON_CHANAGE_PHOTO, OnBnClickedButtonChanagePhoto)
	ON_BN_CLICKED(IDC_BUTTON_FLUSHNEW, OnBnClickedButtonFlushnew)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnBnClickedButtonQuery)
	ON_COMMAND(ID_DISPLAYSELECTED, OnDisplayselected)
	ON_WM_CONTEXTMENU()
	ON_BN_CLICKED(IDC_BUTTON_CHE, OnBnClickedButtonChe)
	ON_BN_CLICKED(IDC_BUTTON_HUI, OnBnClickedButtonHui)
	ON_COMMAND(ID_QUERY, OnQuery)
	ON_COMMAND(ID_NEWCLASS, OnNewclass)
	ON_COMMAND(ID_NEWSTUDENT, OnNewstudent)
	ON_COMMAND(ID_NEWTEACHER, OnNewteacher)
	ON_COMMAND(ID_NEWDEPARTMENT, OnNewdepartment)
	ON_COMMAND(ID_NEWCONSORTIUM, OnNewconsortium)
	ON_COMMAND(ID_NEWCOLLEGE, OnNewcollege)
	ON_COMMAND(ID_DELETE, OnDelete)
	ON_COMMAND(ID_AMEND, OnAmend)
END_MESSAGE_MAP()


// CSchoolManageSys_2Dlg 消息处理程序

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

	// 将\“关于...\”菜单项添加到系统菜单中。

	// IDM_ABOUTBOX 必须在系统命令范围内。
	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);
		}
	}
	
	//设置右键弹出菜单
	popmenu=new CMenu;
	BOOL bSuccess =popmenu->LoadMenu(IDR_MENU_POPUP);
	// 设置此对话框的图标。当应用程序主窗口不是对话框时，框架将自动
	//  执行此操作
	SetIcon(m_hIcon, TRUE);			// 设置大图标
	SetIcon(m_hIcon, FALSE);		// 设置小图标

	// TODO: 在此添加额外的初始化代码
	theApp.m_pSkin = GetDlgItem(IDC_SKIN21)->GetControlUnknown();
	theApp.m_pSkin->LoadSkin(L"winaqua.skn");
	theApp.m_pSkin->ApplySkin((int)m_hWnd);
	
	//连接数据库，身份验证
	CDialog_Login *dlg1 =new CDialog_Login;
	INT_PTR nResponse1=dlg1->DoModal();
	if(nResponse1==IDOK){

	}else {
		CDialog::OnCancel();
	}
	//Tree控件

	
	m_imagelist=new CImageList;
	m_imagelist->Create(IDB_BITMAP_1,0,0,RGB(0,0,0));
	
	bm.LoadBitmap(IDB_BITMAP_2);
	m_imagelist->Add(&bm,RGB(0,0,0));
	/*
	bm.DeleteObject();
	bm.LoadBitmap(IDB_BITMAP1);
	m_imagelist->Add(&bm,RGB(0,0,0));
	bm.DeleteObject();
	bm.LoadBitmap(IDB_BITMAP2);*/
	
	m_imagelist->Add(&bm,RGB(0,0,0));
	/*
	int count(0);
	CString tmp;
	count=m_imagelist->GetImageCount();
	tmp.Format("%d",count);
	AfxMessageBox(tmp);*/

	tvInsert.hParent = NULL;
	tvInsert.hInsertAfter = NULL;
	tvInsert.item.mask = TVIF_TEXT;
	tvInsert.item.pszText=_T("台州学院信息管理");

	m_Treeinfo.SetImageList(m_imagelist,TVSIL_NORMAL);

	h1=m_Treeinfo.InsertItem(&tvInsert);
	h2=m_Treeinfo.InsertItem("相关信息",0,1,h1,TVI_SORT);
	h3=m_Treeinfo.InsertItem("相关信息1",0,1,h1,TVI_SORT);
	m_Treeinfo.SetTextColor(RGB(128,0,200));
	//m_Treeinfo.SetItemImage(h1,0,1);

	/*样式
	long lStyle=
		::GetWindowLong(m_Treeinfo.GetSafeHwnd(),GWL_STYLE);
	lStyle |=TVS_EDITLABELS;
	::SetWindowLong(m_Treeinfo.GetSafeHwnd(),
		GWL_STYLE,
		lStyle);*/

	//**List控件
	
	DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | /*LVS_EX_SUBITEMIMAGES |*/
	m_Listinfo.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);						LVS_EX_HEADERDRAGDROP | LVS_EX_TRACKSELECT;
	LV_COLUMN lvColumn;
	lvColumn.mask = LVCF_FMT | LVCF_WIDTH | LVCF_TEXT | LVCF_SUBITEM;
	lvColumn.fmt = LVCFMT_LEFT;	lvColumn.cx = 67;
	
	CString temp ="初始化";
	int len=temp.GetLength(); 
	TCHAR* szBuffer = new TCHAR[len + 1];
	strcpy(szBuffer, temp.GetBuffer(len));
	temp.ReleaseBuffer();
	lvColumn.pszText = szBuffer;
	m_Listinfo.InsertColumn(0,&lvColumn);
	//**Datagrid控件
	
	//**连接SQL数据库
	
	if(m_AdoConnection.IsOpen()){
		//学院记录集
		m_AdoRecordSet_Collegeinfo.SetAdoConnection(&m_AdoConnection);
		m_AdoRecordSet_Collegeinfo.SetCursorLocation();
		m_AdoRecordSet_Collegeinfo.Open("collegerecord",adCmdTable);
		//系记录集
		m_AdoRecordSet_Departmentinfo.SetAdoConnection(&m_AdoConnection);
		m_AdoRecordSet_Departmentinfo.SetCursorLocation();
		m_AdoRecordSet_Departmentinfo.Open("departmentrecord",adCmdTable);
		//班级记录集
		m_AdoRecordSet_Classinfo.SetAdoConnection(&m_AdoConnection);
		m_AdoRecordSet_Classinfo.SetCursorLocation();
		m_AdoRecordSet_Classinfo.Open("classrecord",adCmdTable);
		//学生记录集
		m_AdoRecordSet_Studentinfo.SetAdoConnection(&m_AdoConnection);
		m_AdoRecordSet_Studentinfo.SetCursorLocation();
	//	m_AdoRecordSet_Studentinfo.Open("studentrecord",adCmdTable);
		//打开课程集
		m_AdoRecordSet_Lessoninfo.SetAdoConnection(&m_AdoConnection);
		m_AdoRecordSet_Lessoninfo.SetCursorLocation();
	//	m_AdoRecordSet_Lessoninfo.Open("lessonrecord",adCmdTable);
		
	}
	classnum=m_AdoRecordSet_Classinfo.GetRecordCount();
	//**列出查询项目
	m_ListQuery.AddString("学院分类");
	m_ListQuery.AddString("系别分类");
	m_ListQuery.SetCurSel(0);

	return TRUE;  // 除非设置了控件的焦点，否则返回 TRUE
}

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

// 如果向对话框添加最小化按钮，则需要下面的代码
//  来绘制该图标。对于使用文档/视图模型的 MFC 应用程序，
//  这将由框架自动完成。

void CSchoolManageSys_2Dlg::OnPaint() 
{
	CPaintDC dc(this);
	if (IsIconic())
	{
		 // 用于绘制的设备上下文

		SendMessage(WM_ICONERASEBKGND, reinterpret_cast<WPARAM>(dc.GetSafeHdc()), 0);

		// 使图标在工作矩形中居中
		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;

		// 绘制图标
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
	if(m_bitmap.GetSafeHandle()!=NULL){
		CDC memDC;
		BITMAP bm;
		m_bitmap.GetBitmap(&bm);
		memDC.CreateCompatibleDC(&dc);
		CBitmap *oldbitmap = memDC.SelectObject(&m_bitmap);
		
		dc.BitBlt(712, 297, 152, 145, &memDC, 0, 0, SRCCOPY);
		memDC.SelectObject(oldbitmap);
	}
}

void CSchoolManageSys_2Dlg::OnOK(){
	if(MessageBox("退出系统？","确定退出",MB_OKCANCEL|MB_ICONQUESTION)==IDOK){
		if(!m_AdoConnection.CommitTrans()){
			AfxMessageBox("执行操作失败");
			return;
		}
		//CDialog::OnOK();
	}
}

void CSchoolManageSys_2Dlg::OnCancel(){	
	if(MessageBox("退出系统？","确定退出",MB_OKCANCEL|MB_ICONQUESTION)==IDOK){
		CDialog::OnCancel();
	}
}
//当用户拖动最小化窗口时系统调用此函数取得光标显示。
HCURSOR CSchoolManageSys_2Dlg::OnQueryDragIcon()
{
	return static_cast<HCURSOR>(m_hIcon);
}

void CSchoolManageSys_2Dlg::OnAbout()
{
	// TODO: 在此添加命令处理程序代码
	CAboutDlg *dlg=new CAboutDlg;
	ASSERT(dlg);
	dlg->DoModal();
}

void CSchoolManageSys_2Dlg::OnHelpFile()
{