mainfrm.cpp

VC6.0下开发的Access数据库小区管理系统

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

#include "stdafx.h"
#include "INhabitants.h"
#include "LeftTreeView.h"
#include "UsersListView.h"
#include "UserinfoView.h"
#include "AddUserDlg.h"
#include "QueryDlg.h"

#include "MainFrm.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_OPERATE_ADDUSER, OnOperateAdduser)
	ON_COMMAND(ID_OPERATE_QUERY, OnOperateQuery)
	//}}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);

	//设置程序运行时的大，小图标
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
	SetIcon(m_hIcon, TRUE);
	SetIcon(m_hIcon, FALSE);

	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


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(180, 100), pContext))
		return FALSE;
	if(!m_wndSplitter.CreateView(0, 1, RUNTIME_CLASS(CUsersListView), 
		CSize(100, 100), pContext))
		return FALSE;
	m_pLeftView = (CLeftTreeView *)m_wndSplitter.GetPane(0, 0);
	m_pUsersView = (CUsersListView *)m_wndSplitter.GetPane(0, 1);
	
	return TRUE;
}

void CMainFrame::SwitchToView(int nViewType)
{
	CView * pView = (CView *)m_wndSplitter.GetPane(0, 1);
	CRect rcRight;
	pView->GetClientRect(&rcRight);
	switch(nViewType){
	case USERSVIEW:
		{
			if(!pView->IsKindOf(RUNTIME_CLASS(CUsersListView))){
				m_wndSplitter.DeleteView(0, 1);
				m_wndSplitter.CreateView(0, 1, RUNTIME_CLASS(CUsersListView),
					CSize(rcRight.Width(), rcRight.Height()), NULL);
				m_wndSplitter.RecalcLayout();
				m_pUsersView = (CUsersListView *)m_wndSplitter.GetPane(0, 1);
			}
			break;
		}
	case USERINFOVIEW:
		{
			if(!pView->IsKindOf(RUNTIME_CLASS(CUserinfoView))){
				m_wndSplitter.DeleteView(0, 1);
				m_wndSplitter.CreateView(0, 1, RUNTIME_CLASS(CUserinfoView),
					CSize(rcRight.Width(), rcRight.Height()), NULL);
				m_wndSplitter.RecalcLayout();
				m_pUserinfoView = (CUserinfoView *)m_wndSplitter.GetPane(0, 1);
			}
			break;
		}
	default:
		break;
	}
}

void CMainFrame::OnOperateAdduser() 
{
	// TODO: Add your command handler code here
	CAddUserDlg dlg;
	dlg.DoModal();
}

void CMainFrame::OnOperateQuery() 
{
	// TODO: Add your command handler code here
	CQueryDlg dlg;
	if(dlg.DoModal() == IDOK){
		BOOL bIsFirst = TRUE;
		CString strSql, strSectionname, strBuildingnum, strCellnum,
			strRoomnum, strHousemaster, strHomeTel, strOffice, strOfficeTel, 
			strBeeppager, strMobile, strEmail;
		//小区
		if(dlg.m_strSectionName != ""){
			strSectionname = "sectionname = '" + dlg.m_strSectionName + "'";
			bIsFirst = FALSE;
		}
		//楼号
		if(dlg.m_nBuildingNum != 0){
			if(bIsFirst == TRUE)
				strBuildingnum.Format("buildingnum = %d", dlg.m_nBuildingNum);
			else
				strBuildingnum.Format(" and buildingnum = %d", dlg.m_nBuildingNum);
			bIsFirst = FALSE;
		}
		//单元
		if(dlg.m_nCellNum != 0){
			if(bIsFirst == TRUE)
				strCellnum.Format("cellnum = %d", dlg.m_nCellNum);
			else
				strCellnum.Format(" and cellnum = %d", dlg.m_nCellNum);
			bIsFirst = FALSE;
		}
		//房间号
		if(dlg.m_nRoomNum != 0){
			if(bIsFirst == TRUE)
				strRoomnum.Format("roomnum = %d", dlg.m_nRoomNum);
			else
				strRoomnum.Format(" and roomnum = %d", dlg.m_nRoomNum);
			bIsFirst = FALSE;
		}
		//户主姓名
		if(dlg.m_strHousemaster != ""){
			if(bIsFirst == TRUE)
				strHousemaster = "housemaster = '" + dlg.m_strHousemaster + "'";
			else
				strHousemaster = " and housemaster = '" + dlg.m_strHousemaster + "'";
			bIsFirst = FALSE;
		}
		//家庭电话
		if(dlg.m_strHomeTel != ""){
			if(bIsFirst == TRUE)
				strHomeTel = "hometel = '" + dlg.m_strHomeTel + "'";
			else
				strHomeTel = " and hometel = '" + dlg.m_strHomeTel + "'";
			bIsFirst = FALSE;
		}
		//办公室
		if(dlg.m_strOffice != ""){
			if(bIsFirst == TRUE)
				strOffice = "office = '" + dlg.m_strOffice + "'";
			else
				strOffice = " and office = '" + dlg.m_strOffice + "'";
			bIsFirst = FALSE;
		}
		//办公室电话
		if(dlg.m_strOfficeTel != ""){
			if(bIsFirst == TRUE)
				strOfficeTel = "officetel = '" + dlg.m_strOfficeTel + "'";
			else
				strOfficeTel = " and officetel = '" + dlg.m_strOfficeTel + "'";
			bIsFirst = FALSE;
		}
		//寻呼机
		if(dlg.m_strBeeppager != ""){
			if(bIsFirst == TRUE)
				strBeeppager = "beeppager = '" + dlg.m_strBeeppager + "'";
			else
				strBeeppager = " and beeppager = '" + dlg.m_strBeeppager + "'";
			bIsFirst = FALSE;
		}
		//手机
		if(dlg.m_strMobile != ""){
			if(bIsFirst == TRUE)
				strMobile = "mobile = '" + dlg.m_strMobile + "'";
			else
				strMobile = " and mobile = '" + dlg.m_strMobile + "'";
			bIsFirst = FALSE;
		}
		//Email
		if(dlg.m_strEmail != ""){
			if(bIsFirst == TRUE)
				strEmail = "email = '" + dlg.m_strEmail + "'";
			else
				strEmail = " and email = '" + dlg.m_strEmail + "'";
			bIsFirst = FALSE;
		}
		
		if(bIsFirst == TRUE)
			strSql = "select * from house";
		else
			strSql = "select * from house where " + strSectionname + strBuildingnum +
				strCellnum + strRoomnum + strHousemaster + strHomeTel + strOffice +
				strOfficeTel + strBeeppager + strMobile + strEmail;
		SwitchToView(USERSVIEW);
		m_pUsersView->ShowUsers(strSql);
	}
}