addadmindlg.cpp

手机话费程序

// AddAdminDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MPhoneQuery.h"
#include "AddAdminDlg.h"
#include "MPhoneQueryView.h"
#include "MainFrm.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddAdminDlg dialog


CAddAdminDlg::CAddAdminDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddAdminDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddAdminDlg)
	m_strAdminId = _T("");
	m_strAdminAddr = _T("");
	m_strAdminName = _T("");
	m_strAdminPswd = _T("");
	m_strAdminSex = _T("");
	m_strIsManager = _T("");
	//}}AFX_DATA_INIT
}


void CAddAdminDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddAdminDlg)
	DDX_Text(pDX, IDC_ADD_IDNUMBER, m_strAdminId);
	DDX_Text(pDX, IDC_ADD_ADDRESS, m_strAdminAddr);
	DDX_Text(pDX, IDC_ADD_NAME, m_strAdminName);
	DDX_Text(pDX, IDC_ADD_PSWD, m_strAdminPswd);
	DDX_Text(pDX, IDC_ADD_SEX, m_strAdminSex);
	DDX_Text(pDX, IDC_ADD_ISMANAGER, m_strIsManager);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddAdminDlg, CDialog)
	//{{AFX_MSG_MAP(CAddAdminDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddAdminDlg message handlers

void CAddAdminDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	
	m_strAdminId.TrimRight(" ");
    m_strAdminName.TrimRight(" ");
	m_strAdminPswd.TrimRight(" ");
	m_strAdminSex.TrimRight(" ");
	m_strAdminAddr.TrimRight(" ");
	m_strIsManager.TrimRight(" ");
	
	
	// 确定所有输入有效
	CString sWarning="";
	if ( "" == m_strAdminId ) 
	{
		sWarning = _T("管理员编号");
	}
    else if ( "" == m_strAdminName )
	{
		sWarning = _T("管理员姓名名称");
	}
	else if ( "" == m_strAdminSex )
	{
		sWarning = _T("管理员性别");
	}
	else if ( "" == m_strIsManager)
	{
		sWarning = _T("是否高层管理员");
	}
	    
	if ( "" != sWarning ) 
	{
	   sWarning += _T("不能为空");
	   AfxMessageBox(sWarning, MB_ICONEXCLAMATION);
	   return;
	}	
		
	CString strSex;
	if ( m_strAdminSex == "男")
	{
		strSex = '1';
	}
	else if ( m_strAdminSex == "女")
	{
		strSex = '0';
	}

	if ( m_strIsManager == "是" )
	{
		m_strIsManager = '1';
	}
	else if ( m_strIsManager == "否")
	{
		m_strIsManager = '0';
	}

	_variant_t strQuery;

	if (m_bAppend)
	{
		// 判断管理员唯一性
		strQuery = "select * from staff where staff_id = '"+m_strAdminId+"'";
		theApp.ADOExecute(theApp.m_pADOSet, strQuery);
		int iCount = theApp.m_pADOSet->GetRecordCount();
		if ( iCount != 0 )
		{
			   AfxMessageBox(_T("已经存在该编号的纪录！"), MB_ICONEXCLAMATION);
			   return;
		}

		// 添加记录;	
		strQuery = "insert staff (staff_id, staff_name, staff_addr, staff_password, sex, is_manager) \
	         		values ('"+m_strAdminId+"', '"+m_strAdminName+"',\
					'"+m_strAdminPswd+"','"+m_strAdminAddr+"','"+strSex+"','"+m_strIsManager+"')";
		
		if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
		{
			AfxMessageBox(_T("添加记录成功！"), MB_ICONINFORMATION);
				
			// 清空输入数据
			m_strAdminId = m_strAdminName = m_strAdminAddr = m_strAdminSex = m_strAdminPswd = m_strIsManager = "";
			UpdateData(false);
		}
		else 
		{
			AfxMessageBox(_T("添加记录失败！"), MB_ICONEXCLAMATION);
		}
	}
	else
	{
		if ( m_strAdminId == m_strPreAdminId )
		{
			strQuery = "Update staff set staff_name = '"+m_strAdminName+"', staff_password = '"+m_strAdminPswd+"', \
				sex = '"+strSex+"', staff_addr = '"+m_strAdminAddr+"', is_manager = '"+m_strIsManager+"' \
				where staff_id = '"+m_strPreAdminId+"'";
		
			if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
			{
				AfxMessageBox(_T("修改记录成功！"), MB_ICONINFORMATION);
					
				// 清空输入数据
				m_strAdminId = m_strAdminName = m_strAdminAddr = m_strAdminSex = m_strAdminPswd = m_strIsManager = "";
				UpdateData(false);
			}
			else 
			{
				AfxMessageBox(_T("修改记录失败！"), MB_ICONEXCLAMATION);
			}
		}
		else
		{
			AfxMessageBox(_T("管理员编号不能被更改！"), MB_ICONEXCLAMATION);
		}
	}
	
	// Refresh RoomType List
	CMPhoneQueryView* p = (CMPhoneQueryView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView());
	p->RefreshAdmin();

	if (!m_bAppend) 
	{
		CDialog::OnOK();	
	}
}

BOOL CAddAdminDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	((CEdit*)GetDlgItem(IDC_ADD_ADDRESS)) ->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_ADD_NAME))    ->SetLimitText(15);
	((CEdit*)GetDlgItem(IDC_ADD_PSWD))    ->SetLimitText(10);
	((CEdit*)GetDlgItem(IDC_ADD_IDNUMBER))->SetLimitText(4);

	if (m_bAppend)
	{

		((CComboBox*)GetDlgItem(IDC_ADD_SEX)) ->SetCurSel(0);	
		((CComboBox*)GetDlgItem(IDC_ADD_ISMANAGER)) ->SetCurSel(0);
	}
	else
	{
		_variant_t strQuery, Holder;

		strQuery = "select * from staff where staff_id = '"+m_strAdminId+"'";
		theApp.ADOExecute(theApp.m_pADOSet, strQuery);

		theApp.m_pADOSet ->MoveFirst();	
		Holder = theApp.m_pADOSet ->GetCollect("sex");
		int iSexCount = Holder.intVal;
		if (iSexCount == 0)
		{	
			((CComboBox*)GetDlgItem(IDC_ADD_SEX)) ->SetCurSel(1);
		}
		else
		{
			((CComboBox*)GetDlgItem(IDC_ADD_SEX)) ->SetCurSel(0);
		}		

		Holder = theApp.m_pADOSet ->GetCollect("is_manager");
		int iManagerCount = Holder.intVal;
		if (iManagerCount == 0)
		{
			((CComboBox*)GetDlgItem(IDC_ADD_ISMANAGER)) ->SetCurSel(0);
		}
		else
		{
			((CComboBox*)GetDlgItem(IDC_ADD_ISMANAGER)) ->SetCurSel(1);
		}
		

	}

	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}