devicedbsdlg.h

通过VC++6.0连接数据库,实现的是一个公司设备管理系统,采购设备,借出和归还设备的详细记录,提高库存管理.

// DeviceDBSDlg.h : header file
//

#if !defined(AFX_DEVICEDBSDLG_H__396B4B37_8534_4AC6_8B75_08F3BA224152__INCLUDED_)
#define AFX_DEVICEDBSDLG_H__396B4B37_8534_4AC6_8B75_08F3BA224152__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

/////////////////////////////////////////////////////////////////////////////
// CDeviceDBSDlg dialog

class CDeviceDBSDlg : public CDialog
{
// Construction
public:
	CDeviceDBSDlg(CWnd* pParent = NULL);	// standard constructor

// Dialog Data
	//{{AFX_DATA(CDeviceDBSDlg)
	enum { IDD = IDD_DEVICEDBS_DIALOG };
	CListCtrl	m_listLend;
	CListCtrl	m_listDevice;
	CComboBox	m_comboName;
	CComboBox	m_comboCode;
	COleDateTime	m_oleOperDate;
	COleDateTime	m_oleOperTime;
	CString	m_strBorrower;
	CString	m_strBuyer;
	CString	m_strDescription;
	CString	m_strDeviceCode;
	CString	m_strDeviceName;
	CString	m_strSelectedName;
	CString	m_strSelectedCode;
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CDeviceDBSDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	HICON m_hIcon;

	// Generated message map functions
	//{{AFX_MSG(CDeviceDBSDlg)
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	afx_msg void OnBtnDeviceAdd();
	afx_msg void OnClickListDevice(NMHDR* pNMHDR, LRESULT* pResult);
	afx_msg void OnBtnDeviceMod();
	afx_msg void OnBtnDeviceDel();
	afx_msg void OnCloseupComboName();
	afx_msg void OnBtnLend();
	afx_msg void OnBtnReturn();
	afx_msg void OnBtnLendList();
	afx_msg void OnBtnFrequencyList();
	afx_msg void OnBtnLentDevice();
	virtual void OnOK();
	afx_msg void OnSysExit();
	virtual void OnCancel();
	afx_msg void OnEditProfile();
	afx_msg void OnEditUser();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
private:
	//使用DeviceDBS.ini配置文件获取连接数据库的参数
	void ConnectDB();
	//初始化列表控件.
	void InitControl();
	//从数据库获取设备信息并更新到控件中
	void InitCtrlData();
	//更新设备名称和设备编号组合框的信息
	void RefreshComboNameData();
	//向设备信息控件中添加信息
	void InsertDeviceInfoItem(CString code, CString name, CString date, CString buyer, CString description);
	//向借出信息控件中添加借出信息	
	void InsertLendInfoItem(int id,CString code,CString name,CString borrower,CString lendDate,CString returnDate);
};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_DEVICEDBSDLG_H__396B4B37_8534_4AC6_8B75_08F3BA224152__INCLUDED_)