dialogwarepurpose.cpp

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CDialogWarePurpose

IMPLEMENT_DYNCREATE(CDialogWarePurpose, CDialog)

CDialogWarePurpose::CDialogWarePurpose()
	: CDialog(CDialogWarePurpose::IDD)
{
	//{{AFX_DATA_INIT(CDialogWarePurpose)
	m_strWareType = _T("");
	m_strId = _T("");
	//}}AFX_DATA_INIT
}

void CDialogWarePurpose::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialogWarePurpose)
	DDX_Control(pDX, IDC_LIST_TYPE, m_List);
	DDX_Text(pDX, IDC_WARETYPE, m_strWareType);
	DDX_Text(pDX, IDC_ID, m_strId);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialogWarePurpose, CDialog)
	//{{AFX_MSG_MAP(CDialogWarePurpose)
	ON_BN_CLICKED(IDC_ADD_TYPE, OnAddType)
	ON_BN_CLICKED(IDC_EDIT_TYPE, OnEditType)
	ON_BN_CLICKED(IDC_DEL_TYPE, OnDelType)
	ON_NOTIFY(NM_CLICK, IDC_LIST_TYPE, OnClickListType)
    ON_MESSAGE(WM_KICKIDLE, OnKickIdle)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialogWarePurpose diagnostics

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

#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CDialogWarePurpose message handlers
void CDialogWarePurpose::OnAddType() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strWareType.IsEmpty())
	{
		MessageBox("请填写完全");
		return;
	}

	CString strSql;

	m_pWarePurposeSet->AddNew( );
	m_pWarePurposeSet->m_WarePurpose = m_strWareType;
	m_pWarePurposeSet->Update();

	FillList();
}

void CDialogWarePurpose::OnEditType() 
{
	// 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 [WarePurpose] where [Id] = %s", m_strId);
	if(m_pWarePurposeSet->IsOpen())
		m_pWarePurposeSet->Close();
	m_pWarePurposeSet->Open(CRecordset::snapshot, strSql);
	m_pWarePurposeSet->Edit( );
	m_pWarePurposeSet->m_WarePurpose = m_strWareType;
	m_pWarePurposeSet->Update();

	FillList();

}

BOOL CDialogWarePurpose::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,50,-1);
	m_List.InsertColumn(1,"用途",LVCFMT_LEFT,140,-1);

	FillList();

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

void CDialogWarePurpose::FillList()
{
	m_List.DeleteAllItems();

	CString str;
	int nRow = 0;
	if(m_pWarePurposeSet->IsOpen())
		m_pWarePurposeSet->Close();
	m_pWarePurposeSet->Open();
	while(!m_pWarePurposeSet->IsEOF())
 	{
		str.Format("%d", m_pWarePurposeSet->m_Id);
		m_List.InsertItem(nRow, str);
		m_List.SetItemText(nRow, 1,	m_pWarePurposeSet->m_WarePurpose);

		nRow++;
		m_pWarePurposeSet->MoveNext();
	}
}

void CDialogWarePurpose::OnDelType() 
{
	// 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("delete from [WarePurpose] where [Id] = %s", m_strId);
	m_pWarePurposeSet->m_pDatabase->ExecuteSQL(strSql);

	FillList();	
}


void CDialogWarePurpose::OnClickListType(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_strWareType = m_List.GetItemText(nItem, 1);
	UpdateData(FALSE);
	
	*pResult = 0;
}

LRESULT CDialogWarePurpose::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;
}