data.h

VC++ 开发的一个大型进销存管理系统,并附带有Visio的数据库开发模型,商品采用分类管理.但是各位同仁需要注意,本系统的开发过程是基于VC++6.0 SQL Server2000的基础之上开发的.

// Data.h: interface for the CData class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_DATA_H__9025000D_CC9B_46CE_90A9_E1B5A94D63A7__INCLUDED_)
#define AFX_DATA_H__9025000D_CC9B_46CE_90A9_E1B5A94D63A7__INCLUDED_

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

class CData  
{
public:
	CData();
	virtual ~CData();

	BOOL ExecuteOther(CString SQL);
	int GetRecordCount(_RecordsetPtr rs);
	void FreeData();
	CString AutoNumber(CString sTable,CString sFieldName,CString sCode,int nStyle);
	BOOL ExecuteSQL(CString sql);
	void SetAsInteger(CString FieldName,int FieldValue);
	void SetAsString(CString FieldName,CString FieldValue);
	int GetAsInteger(CString FieldName);
	CString GetAsString(CString FieldName);
	int GetRecordCount();
	void MoveFirst();
	void MoveLast();
	void MovePrev();
	void MoveNext();
	BOOL IsEOF();
	BOOL IsBOF();
	BOOL InitData();
	_RecordsetPtr m_pRs;
	_ConnectionPtr m_pConn;
public:
	float GetAsFloat(CString FieldName);
	BOOL isActived;


};

#endif // !defined(AFX_DATA_H__9025000D_CC9B_46CE_90A9_E1B5A94D63A7__INCLUDED_)