projectmanageview.h

主要用在管理系统,一个工程维护管理用vc++ 8.0 accesss数据库

// ProjectManageView.h : CProjectManageView 类的接口
//


#pragma once
#include "User.h"
#include "TabSheet.h"
#include "BaseInfo.h"
#include "UserCost.h"
#include "CarList.h"
#include "StuffList.h"
#include	"../codex/cdxCSizingFormView.h"
class CProjectManageDoc;

class CProjectManageView : public cdxCSizingFormView
{
protected: // 仅从序列化创建
	CProjectManageView();
	DECLARE_DYNCREATE(CProjectManageView)
    CADOStorage m_Storage;    //数据库连接
	CADOConnection m_Conn;
	CString     m_TblName;    //表名称
// 属性
public:
	
	enum{IDD = IDD_FORMVIEW_LIST };
	_ConnectionPtr m_pConnection;
    //CListCtrl	m_oListmateriel;

	CEdit	m_oClassname;
	CString	m_classname;
	int		m_radiodiscount;
	long	m_tempid;
	CTabSheet	m_BasicInfoTabPage;
	CTabSheet	m_ItemTabPage;
	CListCtrl	m_oListmateriel;
	CStatic	m_wndPlaceholder;
	CButton  m_Box;
// 操作  
public:
	CProjectManageDoc* GetDocument() const;
    CMultiDocTemplate* m_pDocTemplate;
// 重写
public:
	CBaseInfo m_oBaseInfodlg;
	CUserCost m_oStuffList;
    CCarList m_oCarList;
	CStuffList m_oSutffList;
	

public:
	virtual void OnDraw(CDC* pDC);  // 重写以绘制该视图
	virtual BOOL PreCreateWindow(CREATESTRUCT& cs);
protected:
	virtual BOOL OnPreparePrinting(CPrintInfo* pInfo);
	virtual void OnBeginPrinting(CDC* pDC, CPrintInfo* pInfo);
	virtual void OnEndPrinting(CDC* pDC, CPrintInfo* pInfo);

// 实现
public:
	virtual ~CProjectManageView();
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif

protected:

// 生成的消息映射函数
protected:
	DECLARE_MESSAGE_MAP()
public:
	virtual void OnInitialUpdate();
	void InitListHead();
	
	void AddSubTree(CString ParTree, HTREEITEM hPartItem);
	int TreeSumRecordCount(CString strFieldValue);
	CString VariantToCString(VARIANT var);
protected:
	virtual void DoDataExchange(CDataExchange* pDX);
public:

	afx_msg void OnNMClickList1(NMHDR *pNMHDR, LRESULT *pResult);
	void LoadListViewData();
	void LoadData(CString sSql);
	afx_msg void OnSize(UINT nType, int cx, int cy);
	void OnWriteexcel(CString spath);
};

#ifndef _DEBUG  // ProjectManageView.cpp 中的调试版本
inline CProjectManageDoc* CProjectManageView::GetDocument() const
   { return reinterpret_cast<CProjectManageDoc*>(m_pDocument); }
#endif