infoset.h

vc编译的酒店管理系统

#if !defined(AFX_INFOSET_H__E53BBFDD_D2A5_436A_91F9_A5659FFC24BE__INCLUDED_)
#define AFX_INFOSET_H__E53BBFDD_D2A5_436A_91F9_A5659FFC24BE__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// InfoSet.h : header file
//
#include<afxdb.h>
/////////////////////////////////////////////////////////////////////////////
// CGuestInfoSet recordset

class CGuestInfoSet : public CRecordset
{
public:
	CGuestInfoSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CGuestInfoSet)

// Field/Param Data
	//{{AFX_FIELD(CGuestInfoSet, CRecordset)
	CString	m_HandCode;
	CString	m_Name;
	CString	m_GuestType;
	CString	m_Sex;
	CString	m_Certificate;
	CString	m_CertifyCode;
//	CString m_StartTime;
	BOOL	m_IsMember;
	BOOL	m_IsMaster;
	CString	m_GroupID;
	long	m_GuestNum;
	CString	m_RoomNum;
	CString	m_RoomCode;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CGuestInfoSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};

/////////////////////////////////////////////////////////////////////////////
// CRoomInfoSet recordset

class CRoomInfoSet : public CRecordset
{
public:
	CRoomInfoSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CRoomInfoSet)

// Field/Param Data
	//{{AFX_FIELD(CRoomInfoSet, CRecordset)
	CString	m_RoomCode;
	CString	m_RoomType;
	int		m_Floor;
	CString	m_Phone;
	CString	m_RoomStatus;
	BOOL	m_PriceType;
	float	m_Price;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CRoomInfoSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};

class CCreateBillCode: public CObject  
{
public:
	CString GenereBillCodeForCheckOut();
	CString GenereBillCode();//自动产生帐单号码函数
	CCreateBillCode();
	virtual ~CCreateBillCode();
};

/////////////////////////////////////////////////////////////////////////////
// CBillInfoSet recordset

class CBillInfoSet : public CRecordset
{
public:
	CBillInfoSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CBillInfoSet)

// Field/Param Data
	//{{AFX_FIELD(CBillInfoSet, CRecordset)
	CString	m_BillCode;
	CString	m_HandCode;
	long	m_Sum;
	long	m_Paid;
	CString	m_Rebate;
	BOOL	m_Striked;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CBillInfoSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};
/////////////////////////////////////////////////////////////////////////////
// CServerInfoSet recordset

class CServerInfoSet : public CRecordset
{
public:
	CServerInfoSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CServerInfoSet)

// Field/Param Data
	//{{AFX_FIELD(CServerInfoSet, CRecordset)
	CString	m_ServerName;
	float	m_ServerPrice;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CServerInfoSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};
/////////////////////////////////////////////////////////////////////////////
// CFoodInfoSet recordset

class CFoodInfoSet : public CRecordset
{
public:
	CFoodInfoSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CFoodInfoSet)

// Field/Param Data
	//{{AFX_FIELD(CFoodInfoSet, CRecordset)
	CString	m_FoodName;
	float	m_FoodPrice;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CFoodInfoSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};
/////////////////////////////////////////////////////////////////////////////
// CEmployerInfoSet recordset

class CEmployerInfoSet : public CRecordset
{
public:
	CEmployerInfoSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CEmployerInfoSet)

// Field/Param Data
	//{{AFX_FIELD(CEmployerInfoSet, CRecordset)
	CString	m_EmployerCode;
	CString	m_Name;
	CString	m_Depart;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CEmployerInfoSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};
/////////////////////////////////////////////////////////////////////////////
// CBillContentInfoSet recordset

class CBillContentInfoSet : public CRecordset
{
public:
	CBillContentInfoSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CBillContentInfoSet)

// Field/Param Data
	//{{AFX_FIELD(CBillContentInfoSet, CRecordset)
	CString	m_BillCode;
	CString	m_BillContent;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CBillContentInfoSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};
/////////////////////////////////////////////////////////////////////////////
// CBillCheckoutInfoSet recordset

class CBillCheckoutInfoSet : public CRecordset
{
public:
	CBillCheckoutInfoSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CBillCheckoutInfoSet)

// Field/Param Data
	//{{AFX_FIELD(CBillCheckoutInfoSet, CRecordset)
	CString	m_BillCode;//帐单号码
	CString	m_HandCode;//手牌号码
	CTime	m_StartTime;//开始入住时间
	CTime	m_EndTime;  //离开时间
	CString	m_Sum;      //应付总费用
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CBillCheckoutInfoSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};
/////////////////////////////////////////////////////////////////////////////
// CRoomDestineSet recordset


/////////////////////////////////////////////////////////////////////////////
// CDestineRoomSet recordset

class CDestineRoomSet : public CRecordset
{
public:
	CDestineRoomSet(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CDestineRoomSet)

// Field/Param Data
	//{{AFX_FIELD(CDestineRoomSet, CRecordset)
	CString	m_BillCode;
	CString	m_Certificate;
	CString	m_CeritifyCode;
	CString	m_DestinerName;
	CString	m_DestinerSex;
	CString	m_DestineMoney;
	CString	m_DestineTime;
	CString	m_DestineEndTime;
	CString	m_DestineRoomCode;
	//}}AFX_FIELD


// Overrides
	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CDestineRoomSet)
	public:
	virtual CString GetDefaultConnect();    // Default connection string
	virtual CString GetDefaultSQL();    // Default SQL for Recordset
	virtual void DoFieldExchange(CFieldExchange* pFX);  // RFX support
	//}}AFX_VIRTUAL

// Implementation
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};
//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_INFOSET_H__E53BBFDD_D2A5_436A_91F9_A5659FFC24BE__INCLUDED_)