dialogwaretype.cpp

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CDialogWareType

IMPLEMENT_DYNCREATE(CDialogWareType, CDialog)

CDialogWareType::CDialogWareType()
	: CDialog(CDialogWareType::IDD)
{
	//{{AFX_DATA_INIT(CDialogWareType)
	m_strWareType = _T("");
	m_strId = _T("");
	m_strWarePurpose = _T("");
	m_strUnit = _T("");
	//}}AFX_DATA_INIT
}

void CDialogWareType::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialogWareType)
	DDX_Control(pDX, IDC_LIST_TYPE, m_List);
	DDX_Control(pDX, IDC_COMBO_WARE_PURPOSE, m_ComboWarePurpose);
	DDX_Text(pDX, IDC_WARETYPE, m_strWareType);
	DDX_Text(pDX, IDC_ID, m_strId);
	DDX_CBString(pDX, IDC_COMBO_WARE_PURPOSE, m_strWarePurpose);
	DDX_Text(pDX, IDC_UNIT, m_strUnit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialogWareType, CDialog)
	//{{AFX_MSG_MAP(CDialogWareType)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	ON_BN_CLICKED(IDC_BTN_DEL, OnBtnDel)
	ON_BN_CLICKED(IDC_BTN_EDIT, OnBtnEdit)
	ON_CBN_SELCHANGE(IDC_COMBO_WARE_PURPOSE, OnSelchangeComboWarePurpose)
	ON_NOTIFY(NM_CLICK, IDC_LIST_TYPE, OnClickListType)
	ON_BN_CLICKED(IDC_BTN_MODE, OnBtnMode)
    ON_MESSAGE(WM_KICKIDLE, OnKickIdle)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialogWareType diagnostics

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

#endif //_DEBUG

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

	m_pWarePurposeSet->MoveFirst();
	while(!m_pWarePurposeSet->IsEOF())
	{
		if(m_pWarePurposeSet->m_WarePurpose == m_strWarePurpose)
			break;

		m_pWarePurposeSet->MoveNext();
	}

	m_pWareTypeSet->AddNew( );
	m_pWareTypeSet->m_WareType = m_strWareType;
	m_pWareTypeSet->m_Unit = m_strUnit;
	m_pWareTypeSet->m_WarePurposeId = m_pWarePurposeSet->m_Id;
	m_pWareTypeSet->m_OperatorId = m_strOperatorId;
	m_pWareTypeSet->Update();

	OnSelchangeComboWarePurpose();
}

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

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

	m_pWarePurposeSet->MoveFirst();
	while(!m_pWarePurposeSet->IsEOF())
	{
		if(m_pWarePurposeSet->m_WarePurpose == m_strWarePurpose)
			break;

		m_pWarePurposeSet->MoveNext();
	}

	CString strSql;
	strSql.Format("SELECT * from [WareType] where [Id] = %s", m_strId);
	if(m_pWareTypeSet->IsOpen())
		m_pWareTypeSet->Close();
	m_pWareTypeSet->Open(CRecordset::snapshot, strSql);
	m_pWareTypeSet->Edit( );
	m_pWareTypeSet->m_WareType = m_strWareType;
	m_pWareTypeSet->m_Unit = m_strUnit;
	m_pWareTypeSet->m_WarePurposeId = m_pWarePurposeSet->m_Id;
	m_pWareTypeSet->m_OperatorId = m_strOperatorId;
	m_pWareTypeSet->Update();

	OnSelchangeComboWarePurpose();
}

BOOL CDialogWareType::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,120,-1);
	m_List.InsertColumn(2,"计量单位",LVCFMT_LEFT,100,-1);
	m_List.InsertColumn(3,"维护人",LVCFMT_LEFT,100,-1);

	if(m_pWarePurposeSet->IsOpen())
		m_pWarePurposeSet->Close();
	m_pWarePurposeSet->Open();
	while(!m_pWarePurposeSet->IsEOF())
 	{
		m_ComboWarePurpose.AddString(m_pWarePurposeSet->m_WarePurpose);

		m_pWarePurposeSet->MoveNext();
	}
	m_ComboWarePurpose.SetCurSel(0);
	OnSelchangeComboWarePurpose();

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

void CDialogWareType::OnSelchangeComboWarePurpose()
{
	UpdateData();

	m_pWarePurposeSet->MoveFirst();
	while(!m_pWarePurposeSet->IsEOF())
	{
		if(m_pWarePurposeSet->m_WarePurpose == m_strWarePurpose)
		{
			CString strSql;
			int i = 0;
			strSql.Format("select * from [WareType] where [WarePurposeId] = %d", m_pWarePurposeSet->m_Id); 
			if(m_pWareTypeSet->IsOpen())
				m_pWareTypeSet->Close();
			m_pWareTypeSet->Open(CRecordset::snapshot, strSql);
			m_List.DeleteAllItems();
			while(!m_pWareTypeSet->IsEOF())
 			{
				strSql.Format("%d", m_pWareTypeSet->m_Id);
				m_List.InsertItem(i, strSql);
				m_List.SetItemText(i, 1,  m_pWareTypeSet->m_WareType );
				m_List.SetItemText(i, 2,  m_pWareTypeSet->m_Unit );
				m_List.SetItemText(i, 3,  m_pWareTypeSet->m_OperatorId );

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

			break;
		}
		m_pWarePurposeSet->MoveNext();
	}
	
	m_strWareType = "";
	m_strId = "";
	UpdateData(FALSE);
}

void CDialogWareType::OnBtnDel() 
{
	// 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 [WareType] where [id] = %s", m_strId);
	m_pWareTypeSet->m_pDatabase->ExecuteSQL(strSql);

	OnSelchangeComboWarePurpose();	
}

void CDialogWareType::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);
	m_strUnit = m_List.GetItemText(nItem, 2);
	UpdateData(FALSE);
	
	*pResult = 0;
}

#include "DialogWareMode.h"
void CDialogWareType::OnBtnMode() 
{
	// TODO: Add your command handler code here
	if(m_strId.IsEmpty())
		return;

	CDialogWareMode dlg;
	dlg.m_pWareModeSet = m_pWareModeSet;
	dlg.m_nWarePurposeId = m_pWarePurposeSet->m_Id;
	dlg.m_strWareTypeId = m_strId;
	dlg.m_strWareType = m_strWareType;
	dlg.m_pOperatorSet = m_pOperatorSet;
	dlg.m_strOperatorId = m_strOperatorId;
	dlg.DoModal();
}

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