adodatabase_sqlserver.h

这是一个加油站管理系统

#if !defined __ADO_DATABASE_SQLSERVER
#define __ADO_DATABASE_SQLSERVER

#include "ADODataBase.h"

class CADODataBase_SQLServer:public CADODataBase
{

public:
	int GetStorages(CString strDepot, CString strGasType, CStringArray &strDepotName, CStringArray &strGasTypeName, CStringArray &strAmount);

	BOOL AddNewStockRecord(CString strTime, CString strGasType, CString strDepot, float fAmount, float fPrice, int nWorker);
	int GetStockRecords(CStringArray &strTime, CStringArray &strGasType, CStringArray &strDepot, CStringArray &strAmount, CStringArray &strPrice, CStringArray &strWorker);
	int GetStockRecordsEx(CStringArray &strTime, CStringArray &strGasType, CStringArray &strDepot, CStringArray &strAmount, CStringArray &strPrice, CStringArray &strWorker, CString strTimeStart, CString strTimeEnd);
	BOOL AddNewSellRecord(CString strTime, CString strGasType, CString strDepot, float fAmount, float fPrice, int nWorker, int nMember, float fAgio);
	int GetSellRecordsEx(CStringArray &strTime, CStringArray &strGasType, CStringArray &strDepot, CStringArray &strAmount, CStringArray &strPrice, CStringArray &strWorker, CStringArray &strClient, CStringArray &strAgio, CString strTimeStart, CString strTimeEnd);

	BOOL RemoveMemberLevel(int nNumber);
	BOOL GetMemberLevel(int nNumber, CString &strName, float &fAgio, float &fExp);
	int GetMemberLevels(CStringArray &strNumber, CStringArray &strName, CStringArray &strAgio, CStringArray &strExp);
	BOOL AddNewMemberLevel(int nNumber, CString strName, float &fAgio, float &fExp);
	BOOL ModifyMemberLevel(int nNumber, CString strName, float &fAgio, float &fExp);

	BOOL RemoveGasType(int nNumber);
	BOOL GetGasType(int nNumber, CString &strName, float &fPrice);
	BOOL GetGasTypeByName(CString strName, int &nNumber, float &fPrice);
	int GetGasTypes(CStringArray &strNumber, CStringArray &strName, CStringArray &strPrice);
	BOOL AddNewGasType(int nNumber, CString strName, float &fPrice);
	BOOL ModifyGasType(int nNumber, CString strName, float &fPrice);

	BOOL RemoveMember(int nNumber);
	BOOL GetMember(int nNumber, CString &strName, CString &strID, CString &strCarNumber, float &fExp);
	BOOL GetMemberAgio(int nNumber, float &fAgio);
	int GetMembers(CStringArray &strNumber, CStringArray &strName, CStringArray &strID, CStringArray &strCarNumber, CStringArray &strExp);
	BOOL AddNewMember(int nNumber, CString strName, CString strID, CString strCarNumber, float &fExp);
	BOOL ModifyMember(int nNumber, CString strName, CString strID, CString strCarNumber, float &fExp);

	BOOL GetCurrentContent(int nDepotNumber, int nGasTypeNumber, float &fCurContent);
	BOOL RemoveDepot(int nNumber);
	BOOL GetDepot(int nNumber, CString &strName, CString &strLocation, float &fCapacity);
	BOOL GetDepotByName(CString strName, int &nNumber, CString &strLocation, float &fCapacity);
	int GetDepots(CStringArray &strNumber, CStringArray &strName, CStringArray &strLocation, CStringArray &strCapacity);
	BOOL AddNewDepot(int nNumber, CString strName, CString strLocation, float &fCapacity);
	BOOL ModifyDepot(int nNumber, CString strName, CString strLocation, float &fCapacity);
	
	BOOL RemoveWorker(int nNumber);
	BOOL GetWorker(int nNumber, CString &strName, CString &strID, int &nType, CString &strPassword);
	int GetWorkers(CStringArray &strNumber, CStringArray &strName, CStringArray &strID, CStringArray &strType, CStringArray &strPassword);
	BOOL AddNewWorker(int nNumber, CString strName, CString strID, int nType, CString strPassword);
	BOOL ModifyWorker(int nNumber, CString strName, CString strID, int nType, CString strPassword);

	int GetWorkerType(int nNumber);
	BOOL IsValidWorkerPassword(int nNumber, CString strPassword);
	BOOL AutoAssignNumber(CString strTableName, int &nNumber);

	BOOL IsEndOfFile();
	BOOL Query(CString strQuery);
	HRESULT GetOneRow(long lColumns);
	_RecordsetPtr ExecuteQuery(CString strQuery);
	HRESULT Init();
private:
	TCHAR m_lpQuery[1024];	
	_variant_t m_var[10];
};

#endif