dialogoperator.cpp

以前给一个印刷厂开发的业务管理软件

// AddOperatorView.cpp : implementation file
//

#include "stdafx.h"
#include "DialogOperator.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDialogOperator

IMPLEMENT_DYNCREATE(CDialogOperator, CDialog)

CDialogOperator::CDialogOperator()
	: CDialog(CDialogOperator::IDD)
{
	//{{AFX_DATA_INIT(CDialogOperator)
	m_strId = _T("");
	m_strOperator = _T("");
	m_strPasswd = _T("");
	m_strFunction = _T("");
	m_strTel = _T("");
	m_strDepartment = _T("");
	//}}AFX_DATA_INIT
}

void CDialogOperator::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialogOperator)
	DDX_Control(pDX, IDC_COMBO_DEPARTMENT, m_ComboDepartment);
	DDX_Control(pDX, IDC_LIST_OPERATOR_LIST, m_List);
	DDX_Text(pDX, IDC_EDIT_ID, m_strId);
	DDX_Text(pDX, IDC_EDIT_OPERATOR, m_strOperator);
	DDX_Text(pDX, IDC_EDIT_PASSWD, m_strPasswd);
	DDX_Text(pDX, IDC_EDIT_FUNCTION, m_strFunction);
	DDX_Text(pDX, IDC_EDIT_TEL, m_strTel);
	DDX_CBString(pDX, IDC_COMBO_DEPARTMENT, m_strDepartment);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialogOperator, CDialog)
	//{{AFX_MSG_MAP(CDialogOperator)
	ON_BN_CLICKED(ID_BUTTON_ADD_OPERATOR, OnButtonAddOperator)
	ON_BN_CLICKED(ID_BUTTON_EDIT_OPERATOR, OnButtonEditOperator)
	ON_BN_CLICKED(ID_BUTTON_DELETE_OPERATOR, OnButtonDeleteOperator)
	ON_NOTIFY(NM_CLICK, IDC_LIST_OPERATOR_LIST, OnClickListOperatorList)
    ON_MESSAGE(WM_KICKIDLE, OnKickIdle)
	ON_CBN_SELCHANGE(IDC_COMBO_DEPARTMENT, OnSelchangeComboDepartment)
	ON_WM_CLOSE()
	ON_BN_CLICKED(ID_BUTTON_MIGHT, OnButtonMight)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialogOperator diagnostics

#ifdef _DEBUG
void CDialogOperator::AssertValid() const
{
	CDialog::AssertValid();
}

void CDialogOperator::Dump(CDumpContext& dc) const
{
	CDialog::Dump(dc);
}

#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CDialogOperator message handlers

void CDialogOperator::OnButtonAddOperator() 
{
	// TODO: Add your control notification handler code here
	int answer = MessageBox("确定增加？","确定增加", MB_OKCANCEL);
	if(answer != IDOK)
		return;

	UpdateData();

	if(!m_strDepartment.IsEmpty())
	{
		m_pDepartmentSet->MoveFirst();
		while(!m_pDepartmentSet->IsEOF())
		{
			if(m_pDepartmentSet->m_Department == m_strDepartment)
				break;

			m_pDepartmentSet->MoveNext();
		}
	}	

	m_pOperatorSet->AddNew();
	m_pOperatorSet->m_Id = m_strId;
	m_pOperatorSet->m_Operator = m_strOperator;
	m_pOperatorSet->m_Passwd = m_strPasswd;
	m_pOperatorSet->m_DepartmentId = m_pDepartmentSet->m_Id;
	m_pOperatorSet->m_Tel = m_strTel;
	m_pOperatorSet->m_Responce = m_strFunction;
	m_pOperatorSet->m_OperatorId = m_strOperatorId;
	if(!m_pOperatorSet->Update())
		return;
	
 	OnSelchangeComboDepartment();
}

void CDialogOperator::OnButtonEditOperator() 
{
	// TODO: Add your control notification handler code here
	int answer = MessageBox("确定修改？","确定修改", MB_OKCANCEL);
	if(answer != IDOK)
		return;

	UpdateData();

	if(!m_strDepartment.IsEmpty())
	{
		m_pDepartmentSet->MoveFirst();
		while(!m_pDepartmentSet->IsEOF())
		{
			if(m_pDepartmentSet->m_Department == m_strDepartment)
				break;

			m_pDepartmentSet->MoveNext();
		}
	}	
	
	CString str;
	str.Format("select * from [Operator] where [Id] = '%s'" , m_strId);
	if(m_pOperatorSet->IsOpen())
		m_pOperatorSet->Close();
	m_pOperatorSet->Open(CRecordset::snapshot, str);
	if(!m_pOperatorSet->IsEOF())
	{
		m_pOperatorSet->Edit();
		m_pOperatorSet->m_Operator = m_strOperator;
		if(!m_strPasswd.IsEmpty())
			m_pOperatorSet->m_Passwd = m_strPasswd;
		m_pOperatorSet->m_Tel = m_strTel;
		m_pOperatorSet->m_DepartmentId = m_pDepartmentSet->m_Id;
		m_pOperatorSet->m_Responce = m_strFunction;
		m_pOperatorSet->m_OperatorId = m_strOperatorId;
		m_pOperatorSet->Update();
	}
	
	OnSelchangeComboDepartment();
}

void CDialogOperator::OnButtonDeleteOperator() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strId.IsEmpty())
		return;

	int answer = MessageBox("确定删除该操作员？","确定删除", MB_OKCANCEL);
	if(answer != IDOK)
		return;

	CString strSql;
 #if !defined(_ACCESS_DB)
   strSql.Format("delete from [Might] where [OperatorId] = '%s' \
		delete from [Operator] where [Id] = '%s'", m_strId, m_strId);
    m_pOperatorSet->m_pDatabase->ExecuteSQL(strSql);
#endif
#if defined(_ACCESS_DB)
   strSql.Format("delete from [Might] where [OperatorId] = '%s'", m_strId);
    m_pOperatorSet->m_pDatabase->ExecuteSQL(strSql);

   strSql.Format("delete from [Operator] where [Id] = '%s'", m_strId);
    m_pOperatorSet->m_pDatabase->ExecuteSQL(strSql);
#endif

	OnSelchangeComboDepartment();
}

BOOL CDialogOperator::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CenterWindow();

	if(m_pOperatorSet->IsOpen())
		m_pOperatorSet->Close();

	m_List.SetExtendedStyle
	   (m_List.GetExtendedStyle() | LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);

	m_List.InsertColumn(0,"Id",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(1,"姓名",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(2,"联系电话",LVCFMT_LEFT,120,-1);
	m_List.InsertColumn(3,"职责",LVCFMT_LEFT,100,-1);

	CString strSql;
	if(m_pDepartmentSet->IsOpen())
		m_pDepartmentSet->Close();
	m_pDepartmentSet->Open();
	while(!m_pDepartmentSet->IsEOF())
 	{
		m_ComboDepartment.AddString(m_pDepartmentSet->m_Department);

		m_pDepartmentSet->MoveNext();
	}
	m_ComboDepartment.SetCurSel(0);
	OnSelchangeComboDepartment();

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

void CDialogOperator::OnClickListOperatorList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int nItem = 0;
	POSITION pos = m_List.GetFirstSelectedItemPosition();
	if (pos != NULL)
	{
	   while (pos)
	   {
			nItem = m_List.GetNextSelectedItem(pos);
	   }
	}
	else
		return;

	m_strId = m_List.GetItemText(nItem, 0);
	m_strOperator = m_List.GetItemText(nItem, 1);
	m_strTel = m_List.GetItemText(nItem, 2);
	m_strFunction = m_List.GetItemText(nItem, 3);

	UpdateData(FALSE);	

	*pResult = 0;
}

LRESULT CDialogOperator::OnKickIdle(WPARAM, LPARAM lCount)
{
       // Do idle processing here, just like CWinApp::OnIdle
       //
	Sleep(100); //1ms

	if(lCount >= 6000) //5分钟5*60*1000=3000*100
	{
		CDialogEnter dlg;
		dlg.m_strUser = m_strOperatorId;
		dlg.m_pOperatorSet = m_pOperatorSet;
		dlg.DoModal();
		return FALSE;
	}
   return TRUE;
}

void CDialogOperator::OnSelchangeComboDepartment() 
{
	// TODO: Add your control notification handler code here
	UpdateData();

	if(!m_strDepartment.IsEmpty())
	{
		m_pDepartmentSet->MoveFirst();
		while(!m_pDepartmentSet->IsEOF())
		{
			if(m_pDepartmentSet->m_Department == m_strDepartment)
			{
				CString strSql;
				int i = 0;
				strSql.Format("select * from [Operator] where [DepartmentId] = %d", m_pDepartmentSet->m_Id); 
				if(m_pOperatorSet->IsOpen())
					m_pOperatorSet->Close();
				m_pOperatorSet->Open(CRecordset::snapshot, strSql);
				m_List.DeleteAllItems();
				while(!m_pOperatorSet->IsEOF())
 				{
					m_List.InsertItem(i, m_pOperatorSet->m_Id);
					m_List.SetItemText(i, 1,  m_pOperatorSet->m_Operator );
					m_List.SetItemText(i, 2,  m_pOperatorSet->m_Tel );
					m_List.SetItemText(i, 3,  m_pOperatorSet->m_Responce );

					i++;
					m_pOperatorSet->MoveNext();
				}

				break;
			}
			m_pDepartmentSet->MoveNext();
		}
	}	
	
}

void CDialogOperator::PostNcDestroy() 
{
	// TODO: Add your specialized code here and/or call the base class
	
	CMDIChild::DelClassChild(this);
	CDialog::PostNcDestroy();
}

void CDialogOperator::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	
	CDialog::OnClose();
	DestroyWindow();
}

void CDialogOperator::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
	DestroyWindow();
}

#include "DialogMight.h"
void CDialogOperator::OnButtonMight() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strId.IsEmpty())
		return;

	CDialogMight dlg;
	dlg.m_pOperatorSet = m_pOperatorSet;
	dlg.m_pMightSet = m_pMightSet;
	dlg.m_strOperatorId = m_strOperatorId;
	dlg.m_strId = m_strId;
	dlg.m_strOperator = m_strOperator;
	dlg.DoModal();
}