mainfrm.cpp

学生信息管理的系统

// MainFrm.cpp : implementation of the CMainFrame class
//

#include "stdafx.h"
#include "member.h"

#include "MainFrm.h"
#include "MemberSearchDlg.h"
#include "MemberDialog.h"
#include "MemberReSet.h"
#include "MemberEditDlg.h"
#include "UserAddDlg.h"
#include "UserRecordSet.h"
#include "UserDelDlg.h"
#include "LeftTreeView.h"
#include "ScoreDlg.h"
#include "MemberAdd.h"
#include "SearchScoreDlg.h"
#include "HelpDlg.h"
#include "ScoreAddDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMainFrame

IMPLEMENT_DYNCREATE(CMainFrame, CFrameWnd)

BEGIN_MESSAGE_MAP(CMainFrame, CFrameWnd)
	//{{AFX_MSG_MAP(CMainFrame)
	ON_WM_CREATE()
	ON_COMMAND(ID_MEMBER_ADD, OnMemberAdd)
	ON_COMMAND(ID_MEMBER_EDIT, OnMemberEdit)
	ON_COMMAND(ID_MEMBER_DEL, OnMemberDel)
	ON_COMMAND(ID_MEMBER_LIST, OnMemberList)
	ON_COMMAND(ID_USER_ADD, OnUserAdd)
	ON_COMMAND(ID_USER_DEL, OnUserDel)
	ON_COMMAND(ID_MEMBER_MORE, OnMemberMore)
	ON_COMMAND(ID_ONPAINT, OnOnpaint)
	ON_COMMAND(ID_SCORE_LIST, OnScoreList)
	ON_COMMAND(ID_SEARCH_SCORE, OnSearchScore)
	ON_COMMAND(IDC_HELP_DIALOG, OnHelpDialog)
	ON_COMMAND(ID_SCORE_ADD, OnScoreAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

static UINT indicators[] =
{
	ID_SEPARATOR,           // status line indicator
	ID_INDICATOR_CAPS,
	ID_INDICATOR_NUM,
	ID_INDICATOR_SCRL,
};

/////////////////////////////////////////////////////////////////////////////
// CMainFrame construction/destruction

CMainFrame::CMainFrame()
{
	// TODO: add member initialization code here
   
}

CMainFrame::~CMainFrame()
{
}

int CMainFrame::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
	if (CFrameWnd::OnCreate(lpCreateStruct) == -1)
		return -1;
	
	if (!m_wndToolBar.CreateEx(this, TBSTYLE_FLAT, WS_CHILD | WS_VISIBLE | CBRS_TOP
		| CBRS_GRIPPER | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_SIZE_DYNAMIC) ||
		!m_wndToolBar.LoadToolBar(IDR_MAINFRAME))
	{
		TRACE0("Failed to create toolbar\n");
		return -1;      // fail to create
	}

	if (!m_wndStatusBar.Create(this) ||
		!m_wndStatusBar.SetIndicators(indicators,
		  sizeof(indicators)/sizeof(UINT)))
	{
		TRACE0("Failed to create status bar\n");
		return -1;      // fail to create
	}

	// TODO: Delete these three lines if you don't want the toolbar to
	//  be dockable
	m_wndToolBar.EnableDocking(CBRS_ALIGN_ANY);
	EnableDocking(CBRS_ALIGN_ANY);
	DockControlBar(&m_wndToolBar);

	return 0;
}

BOOL CMainFrame::PreCreateWindow(CREATESTRUCT& cs)
{
	if( !CFrameWnd::PreCreateWindow(cs) )
		return FALSE;
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return TRUE;
}

/////////////////////////////////////////////////////////////////////////////
// CMainFrame diagnostics

#ifdef _DEBUG
void CMainFrame::AssertValid() const
{
	CFrameWnd::AssertValid();
}

void CMainFrame::Dump(CDumpContext& dc) const
{
	CFrameWnd::Dump(dc);
}

#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CMainFrame message handlers


void CMainFrame::OnMemberAdd() 
{
	// TODO: Add your command handler code here
	m_ListView->MemberAdd();
}

void CMainFrame::OnMemberEdit() 
{
	// TODO: Add your command handler code here
   	m_ListView->EditCurUser();
}

void CMainFrame::OnMemberDel() 
{
	// TODO: Add your command handler code here
	
   m_ListView->DelCurUser();
}
 
void CMainFrame::OnMemberList() 
{
	// TODO: Add your command handler code here
    //个人信息查询
    CMemberSearchDlg m_SearchDlg;
	//取消按扭，则退出
	if(m_SearchDlg.DoModal()==IDOK)
	//确定按扭输出用户信息
	{
		m_ListView->ListMember(m_SearchDlg.m_strSearch,m_SearchDlg.m_strMemberSearch);
	//	return;
	}
}
    
void CMainFrame::OnUserAdd() 
{
	// TODO: Add your command handler code here
	//创建CUserDlg的实例
	CUserAddDlg m_UserAdd;
	//弹出增加用户信息的对话框,如果点击了"取消按钮",则退出
	if(m_UserAdd.DoModal() != IDOK)
		return;
	//如果点击了确定按钮，则开始数据库操作

	//创建CUserRecordSet的实例
	CUserRecordSet m_UserRecordSet;
	try
	{
		if(m_UserRecordSet.IsOpen())
			m_UserRecordSet.Close();
		
		//设置查询条件"UserName=strUserName"
		m_UserRecordSet.m_strFilter.Format("UserName = '%s' order by UserName ASC",
			m_UserAdd.m_UserName.operator LPCTSTR());
		//执行查询
		m_UserRecordSet.Open(CRecordset::snapshot,NULL,CRecordset::none);
		//判断数据库中是否有同名用户，如果有，则退出
		if(!m_UserRecordSet.IsEOF())
		{
			//关闭记录集
			m_UserRecordSet.Close();
			//弹出警告信息
			AfxMessageBox("用户名已经存在");
			//退出函数处理
			return;
		}
		//如果没有同名用户，则执行正常的添加操作
		if(m_UserAdd.m_UserPwd.GetLength()<3)
		{
			//关闭记录集
			m_UserRecordSet.Close();
			//弹出警告信息
			AfxMessageBox("密码至少3位");
			//退出函数处理
			return;
		}
		
		//首先增加一条新记录
		m_UserRecordSet.AddNew();
		//然后编辑该条记录的内容
		m_UserRecordSet.m_UserName = m_UserAdd.m_UserName;
		m_UserRecordSet.m_UserPwd = m_UserAdd.m_UserPwd;
		//更新时，要判断当前是否能够进行更新操作
        if(m_UserRecordSet.CanUpdate())
		{
			m_UserRecordSet.Update();			
		}
		//关闭记录集
		if(m_UserRecordSet.IsOpen())
			m_UserRecordSet.Close();
		//弹出“添加成功”的提示信息
		AfxMessageBox("添加成功！");
	}
	//意外捕获
	catch(CDBException*e)
	{
		e->ReportError ();
		//e->Delete ();
		return;
	}

}

void CMainFrame::OnUserDel() 
{
	// TODO: Add your command handler code here
	CUserDelDlg m_UserDel;
	if(m_UserDel.DoModal()==IDCANCEL)
	{
		return;
	}
}

void CMainFrame::OnMemberMore() 
{
	// TODO: Add your command handler code here
   	m_ListView->EditCurUser();
	//刷新全部信息
    m_ListView->RemoveAll();
    m_ListView->OnPaint();
}


BOOL CMainFrame::OnCreateClient(LPCREATESTRUCT lpcs, CCreateContext* pContext) 
{
	// TODO: Add your specialized code here and/or call the base class
	if(!m_wndSplitter.CreateStatic(this,1,2))
		return FALSE;
	if(!m_wndSplitter.CreateView(0,0,RUNTIME_CLASS(CLeftTreeView),CSize(150,150),pContext))
		return FALSE;
	if(!m_wndSplitter.CreateView(0,1,RUNTIME_CLASS(CMemberView),CSize(150,150),pContext))
		return FALSE;
	m_pLeftView = (CLeftTreeView*)m_wndSplitter.GetPane(0,0);
	m_ListView = (CMemberView*)m_wndSplitter.GetPane(0,1);

	return TRUE;

}

void CMainFrame::OnOnpaint() 
{
	// TODO: Add your command handler code here
		m_ListView->OnPaint();
	
}

void CMainFrame::OnScoreList() 
{
	// TODO: Add your command handler code here
	CString sql,str;
	str=m_ListView->FindPosition();
	if(str=="")
		return;
	sql.Format("select * from score where MemID='%s'",str);
//	AfxMessageBox(sql);
	CScoreDlg m_ScoreDlg;
    m_ScoreDlg.AddPosition(sql);
	// m_ScoreDlg.ListScore(cstring);
    if(m_ScoreDlg.DoModal()!=IDOK)
		return;
}

void CMainFrame::OnSearchScore() 
{
	// TODO: Add your command handler code here
    CSearchScoreDlg m_SearchScoreDlg;
	CString strsql,sqlcourse,strCourse,strSQL;
	BOOL temp=FALSE;
	//取消按扭，则退出
	if(m_SearchScoreDlg.DoModal()!=IDOK)
		return;
	//无关键字输入提示
	if(m_SearchScoreDlg.m_Course==""&&m_SearchScoreDlg.m_Score==0)
	{
	    AfxMessageBox("请输入查询条件");
	    return;
	}
	//选择课程查询条件
	if(m_SearchScoreDlg.m_SearchCourse=="课程编号")
	    strCourse="CourseID";
	else if(m_SearchScoreDlg.m_SearchCourse=="课程名称")
	    strCourse="CourseName";
   	else
	{
	   	AfxMessageBox("请选择正确的课程查询条件");
	    return;
	}
	//合并查询条件
	if(m_SearchScoreDlg.m_Course!="")
	{
		sqlcourse.Format("%s='%s'",strCourse,m_SearchScoreDlg.m_Course);
	    temp=TRUE;
	}
   	if(m_SearchScoreDlg.m_Score!=0)
	{
		if(temp)
		strsql.Format("%s and Score%s%d",sqlcourse,m_SearchScoreDlg.m_SearchScore,m_SearchScoreDlg.m_Score);
		else
		strsql.Format("Score%s%d",m_SearchScoreDlg.m_SearchScore,m_SearchScoreDlg.m_Score);
	}
	else
		strsql=sqlcourse;
		strSQL="select * from score where "+strsql;
	CScoreDlg m_ScoreDlg;	
	m_ScoreDlg.AddPosition(strSQL);	
   	if(m_ScoreDlg.DoModal()!=IDOK)
		return;
	CButton* button=(CButton*)GetDlgItem(IDC_SCORE_ADD);   
    if(button)   
	{   
        button->EnableWindow(FALSE);   
	}
}

void CMainFrame::OnHelpDialog() 
{
	// TODO: Add your command handler code here
	CHelpDlg m_HelpDlg;
 	if(m_HelpDlg.DoModal()!=IDOK)
	  return;
	
}

void CMainFrame::OnScoreAdd() 
{
	// TODO: Add your command handler code here
	CScoreAddDlg m_ScoreAddDlg;
	if(m_ScoreAddDlg.DoModal()!=IDOK)
	  return;
}