mainfrm.cpp

用户信息管理程序

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

#include "stdafx.h"
#include "Demo.h"

#include "MainFrm.h"
//查询对话框的引用说明
#include "UserSearchDlg.h"
//CUserRecordSet类的引用说明
#include "UserRecordSet.h"
//CUserDlg类的引用说明
#include "UserDlg.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_USER_ADD, OnUserAdd)
	ON_COMMAND(ID_USER_DEL, OnUserDel)
	ON_COMMAND(ID_USER_EDIT, OnUserEdit)
	ON_COMMAND(ID_USER_LIST, OnUserList)
	//}}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::OnUserAdd() 
{
	// TODO: Add your command handler code here
	//创建CUserDlg实例
	CUserDlg m_UserDlg;
	//弹出增加用户信息的对话框，如果点击“取消”按钮，则退出
	if(m_UserDlg.DoModal() !=IDOK)
		return;
	//如果点击“确定”按钮，则开始数据库操作
	//创建CUserRecordSet实例
	CUserRecordSet m_UserRecordSet;
	try 
	{
		if(m_UserRecordSet.IsOpen())
			m_UserRecordSet.Close();
		//设置查询条件“UserName=m_UserName”
		m_UserRecordSet.m_strFilter.Format("UserName='%s' order by UserID ASC",
			m_UserDlg.m_UserName.operator LPCTSTR());
		//执行查询
		m_UserRecordSet.Open(CUserRecordSet::snapshot,NULL,CUserRecordSet::none);
		//判断数据库中是否有同名用户，如果有，则退出
		if(!m_UserRecordSet.IsEOF())
		{
			//关闭记录集
			m_UserRecordSet.Close();
			//弹出警告信息
			AfxMessageBox("同名用户已经存在！");
			//退出函数处理
			return;
		}
		//如果没有同名用户，则执行正常的添加操作
		//增加一条新记录
		m_UserRecordSet.AddNew();
		//编辑该记录的内容
		m_UserRecordSet.m_UserAble=m_UserDlg.m_UserAble;
		m_UserRecordSet.m_UserAddr=m_UserDlg.m_UserAddr;
		m_UserRecordSet.m_UserDep=m_UserDlg.m_UserDep;
		m_UserRecordSet.m_UserInfo=m_UserDlg.m_UserInfo;
		m_UserRecordSet.m_UserName=m_UserDlg.m_UserName;
		m_UserRecordSet.m_UserPhone=m_UserDlg.m_UserPhone;
		m_UserRecordSet.m_UserPwd=m_UserDlg.m_UserPwd;
		m_UserRecordSet.m_UserSex=m_UserDlg.m_UserSex;
        m_UserRecordSet.m_UserTitle=m_UserDlg.m_UserTitle;
		m_UserRecordSet.m_UserEmail=m_UserDlg.m_UserEmail;
		//最后，将用户信息更新到数据库中
		//更新时，要判断当前是否能够进行更新操作
		if(m_UserRecordSet.CanUpdate())
		{
			m_UserRecordSet.Update();
		}
		//关闭记录集
		if(m_UserRecordSet.IsOpen())
			m_UserRecordSet.Close();
			//弹出添加成功的提示信息
			AfxMessageBox("用户信息增加成功！");
	}
		//意外捕获
	catch(CDBException *e)
	{
		e->ReportError();
		return;
	}


}

void CMainFrame::OnUserDel() 
{
	// TODO: Add your command handler code here
	//增加删除确认
	if(MessageBox("是否删除这条记录？","删除确认",MB_YESNO|MB_ICONQUESTION)==IDYES)
	{
		//调用DelCurUser操作，进行用户记录的删除操作
		m_ListView->DelCurUser();
	}
}

void CMainFrame::OnUserEdit() 
{
	// TODO: Add your command handler code here
	//调用EditCurUser操作，进行用户记录的编辑
	m_ListView->EditCurUser();
}

void CMainFrame::OnUserList() 
{
	// TODO: Add your command handler code here
	//调用CUserSearchDlg，输入查询条件
	//创建CUserSearchDlg实例
	CUserSearchDlg m_SearchDlg;
	//弹出查询对话框，如果点击了“取消”按钮，则退出
    if(m_SearchDlg.DoModal() !=IDOK)
		return;
	//如果点击了“确定”按钮，则执行以下操作，输出符合条件的用户信息
    m_ListView->ListUser(m_SearchDlg.m_strUserSearch);
	
}