mainfrm.cpp

一个用户信息管理模块

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

#include "stdafx.h"
#include "Demo02.h"

#include "MainFrm.h"

//增加CUserSearchDlg的引用申明
#include "UserSearchDlg.h"

//增加CDemo02View的引用申明
#include "Demo02View.h"

//增加CUserDlg的引用申明
#include "UserDlg.h"

//增加CDemo02View的引用申明
#include "UserRecordSet.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)
	ON_COMMAND(ID_BUTTON_USER_ADD, OnButtonUserAdd)
	ON_COMMAND(ID_BUTTON_USER_DEL, OnButtonUserDel)
	ON_COMMAND(ID_BUTTON_USER_EDIT, OnButtonUserEdit)
	ON_COMMAND(ID_BUTTON_USER_LIST, OnButtonUserList)
	//}}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=strUserName"
		m_UserRecordSet.m_strFilter.Format("UserName = '%s' order by UserID ASC",
			m_UserDlg.m_UserName.operator LPCTSTR());
		//执行查询
		m_UserRecordSet.Open(CRecordset::snapshot,NULL,CRecordset::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_UserEmail = m_UserDlg.m_UserEmail;
		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;
		//最后，将用户信息更新到数据库中
		//更新时，要判断当前是否能够进行更新操作
        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
	//增加删除确认，用户选择“确定”之后，方删除记录
	if (MessageBox("是否删除这条记录？","删除确认",MB_YESNO|MB_ICONQUESTION)==IDYES)
	{
		//执行删除操作
		m_ListView->DelCurUser();	
	}
}

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

void CMainFrame::OnUserList() 
{
	// TODO: Add your command handler code here

	//调用CUserSearchDlg，输入查询条件。

	//创建CUserSearchDlg的实例
	CUserSearchDlg m_SearchDlg;
	//弹出查询对话框,如果点击了"取消按钮",则退出
	if(m_SearchDlg.DoModal() == IDOK)
	{
		BOOL bIsFirst = TRUE;
		CString strSql,strUserSearch,strUserID;
		if(m_SearchDlg.m_strUserSearch!="")
		{
			strUserSearch="strUserSearch='"+m_SearchDlg.m_strUserSearch+"'";
			bIsFirst=FALSE;
		}
		else if
			strUserSearch="";
		if(m_SearchDlg.m_strUserID!="")
		{
			if( bIsFirst == TRUE )
				strUserID="strUserID='"+m_SearchDlg.m_strUserID+"'";
			else
				strUserID="and strUserID='"+m_SearchDlg.m_strUserID+"'";
			bIsFirst = FALSE;
		}
	if( bIsFirst == TRUE )	//没有输入任何条件
			strSql = "select * from pUser";
	else
			strSql = "select * from pUser where" + strUserSearch + strUserID; 
	//如果选择了"确定"按钮,则执行以下操作,输出符合条件的用户信息
	m_ListView->ListUser(strSql);
}

void CMainFrame::OnButtonUserAdd() 
{
	// TODO: Add your command handler code here
	OnUserAdd();
}

void CMainFrame::OnButtonUserDel() 
{
	// TODO: Add your command handler code here
	OnUserDel();
}

void CMainFrame::OnButtonUserEdit() 
{
	// TODO: Add your command handler code here
	OnUserEdit();	
}

void CMainFrame::OnButtonUserList() 
{
	// TODO: Add your command handler code here
	OnUserList();
}