dialogdepartment.cpp

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

// SystemParameterView.cpp : implementation file
//
#include "stdafx.h"
#include "DialogDepartment.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDialogDepartment

IMPLEMENT_DYNCREATE(CDialogDepartment, CDialog)

CDialogDepartment::CDialogDepartment()
	: CDialog(CDialogDepartment::IDD)
{
	//{{AFX_DATA_INIT(CDialogDepartment)
	m_strAddress = _T("");
	m_strDepartment = _T("");
	m_strFunction = _T("");
	m_strId = _T("");
	m_strTel = _T("");
	//}}AFX_DATA_INIT
}

void CDialogDepartment::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialogDepartment)
	DDX_Control(pDX, IDC_LIST, m_List);
	DDX_Text(pDX, IDC_ADDRESS, m_strAddress);
	DDX_Text(pDX, IDC_DEPARTMENT, m_strDepartment);
	DDX_Text(pDX, IDC_FUNCTION, m_strFunction);
	DDX_Text(pDX, IDC_ID, m_strId);
	DDX_Text(pDX, IDC_TEL, m_strTel);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialogDepartment, CDialog)
	//{{AFX_MSG_MAP(CDialogDepartment)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	ON_BN_CLICKED(IDC_BTN_DEL, OnBtnDel)
	ON_BN_CLICKED(IDC_BTN_EDIT, OnBtnEdit)
	ON_NOTIFY(NM_CLICK, IDC_LIST, OnClickList)
    ON_MESSAGE(WM_KICKIDLE, OnKickIdle)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialogDepartment diagnostics

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

#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CDialogDepartment message handlers

void CDialogDepartment::OnBtnAdd() 
{
	// TODO: Add your control notification handler code here
 	int i = MessageBox("确认增加？", "确认增加", MB_OKCANCEL);
 	if(i != IDOK)
 		return;

	UpdateData();
	m_pDepartmentSet->AddNew( );
	m_pDepartmentSet->m_Department = m_strDepartment;
	m_pDepartmentSet->m_Address = m_strAddress;
	m_pDepartmentSet->m_ConnectMan = m_strFunction;
	m_pDepartmentSet->m_Telephone = m_strTel;
	m_pDepartmentSet->m_OperatorId = m_strOperatorId;
	TRY
	{
		m_pDepartmentSet->Update();
	}
	CATCH_ALL(e)
	{
		MessageBox("名称不能重复或为空");
		return;
	}	
    END_CATCH_ALL;

	FillList();	

	m_strId.Empty();
	UpdateData(FALSE);
}

void CDialogDepartment::OnBtnEdit() 
{
	// TODO: Add your control notification handler code here
 	int i = MessageBox("确认修改？", "确认修改", MB_OKCANCEL);
 	if(i != IDOK)
 		return;

	UpdateData();
	if(m_strId.IsEmpty())
		return;

	CString strSql;
	strSql.Format("SELECT * from [Department] where [Id] = %s", m_strId);
	if(m_pDepartmentSet->IsOpen())
		m_pDepartmentSet->Close();
	m_pDepartmentSet->Open(CRecordset::snapshot, strSql);
	m_pDepartmentSet->Edit( );
	m_pDepartmentSet->m_Department = m_strDepartment;
	m_pDepartmentSet->m_Address = m_strAddress;
	m_pDepartmentSet->m_ConnectMan = m_strFunction;
	m_pDepartmentSet->m_Telephone = m_strTel;
	m_pDepartmentSet->m_OperatorId = m_strOperatorId;
	TRY
	{
		m_pDepartmentSet->Update();
	}
	CATCH_ALL(e)
	{
		MessageBox("名称不能重复");
		return;
	}	
    END_CATCH_ALL;

	FillList();	
}


void CDialogDepartment::OnBtnDel() 
{
	// TODO: Add your control notification handler code here
 	int i = MessageBox("确认删除？", "确认删除", MB_OKCANCEL);
 	if(i != IDOK)
 		return;

	UpdateData();

	CString strSql;
	strSql.Format("delete from [Department] where [Id] = %s", m_strId);
	m_pDepartmentSet->m_pDatabase->ExecuteSQL(strSql);

	FillList();

	m_strId.Empty();
	UpdateData(FALSE);
}

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

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

	m_List.InsertColumn(0,"ID",LVCFMT_LEFT,60,-1);
	m_List.InsertColumn(1,"名称",LVCFMT_LEFT,120,-1);
	m_List.InsertColumn(2,"地址",LVCFMT_LEFT,140,-1);
	m_List.InsertColumn(3,"联系人",LVCFMT_LEFT,80,-1);
	m_List.InsertColumn(4,"联系电话",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(5,"更新人",LVCFMT_LEFT,80,-1);

	FillList();

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

//////////////////
// Handle MFC private message WM_KICKIDLE. LPARAM is the idle count. 
// Return TRUE/FALSE continue/discontinue idle processing.
//

void CDialogDepartment::OnClickList(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_strDepartment = m_List.GetItemText(nItem, 1);
	m_strAddress = m_List.GetItemText(nItem, 2);
	m_strFunction = m_List.GetItemText(nItem, 3);
	m_strTel = m_List.GetItemText(nItem, 4);

	UpdateData(FALSE);
	
	*pResult = 0;
}

LRESULT CDialogDepartment::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 CDialogDepartment::FillList() 
{
	// TODO: Add your control notification handler code here
	CWaitCursor cursor; // this will automatically display a wait cursor

	CString	strSql;
	int nRow = 0;

	m_List.DeleteAllItems();
	if(m_pDepartmentSet->IsOpen())
		m_pDepartmentSet->Close();
	m_pDepartmentSet->Open();
	while(!m_pDepartmentSet->IsEOF())
 	{
		strSql.Format("%d", m_pDepartmentSet->m_Id);
		m_List.InsertItem(nRow, strSql);
		m_List.SetItemText(nRow, 1,	m_pDepartmentSet->m_Department);
		m_List.SetItemText(nRow, 2,	m_pDepartmentSet->m_Address);
		m_List.SetItemText(nRow, 3,	m_pDepartmentSet->m_ConnectMan);
		m_List.SetItemText(nRow, 4,	m_pDepartmentSet->m_Telephone);
		m_List.SetItemText(nRow, 5,	m_pDepartmentSet->m_OperatorId);
		nRow++;

		m_pDepartmentSet->MoveNext();
	}
	
}