adoconnaccess.h

带MD5摘要计算的登录程序,实现部分功能模块和部分界面

// ADOConnAccess.h: interface for the ADOConnAccess class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADOCONNACCESS_H__9F39B02F_D556_4912_B598_43B5795E852F__INCLUDED_)
#define AFX_ADOCONNACCESS_H__9F39B02F_D556_4912_B598_43B5795E852F__INCLUDED_

#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF") rename("BOF","adoBOF")

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

#include "SortListCtrl.h"

class ADOConnAccess  
{
public:
	BOOL LogOnValidate(CString strSuperAdministratorNo,CString strAdminPasswordDigest);
	BOOL LogOnAdminNoInit(CComboBox * pComboBox);
	BOOL PropertyRegisterShowSelPropertyTypeNo(CComboBox *pComboBox, CEdit *pEdit);
	BOOL PropertyRegisterPropertyTypeNameComboInit(CComboBox *pComboBox, CEdit *pEdit);
	BOOL EventQuery(CString strQueryKey,CSortListCtrl * pListCtrl);
	CString GetTagUserNo(CString strTagID);
	CString GetTagPropertyNo(CString strTagID);
	BOOL AddAlarmEventInfo(CTime tEventTime,CString strEventContent,CString strTagID,CString strPropertyNo,CString strUserNo);
	CString GetReaderLocation(CString strTagNo);
	BOOL ShowDetailEventReport(CString strTagID,CSortListCtrl * pListCtrl);
	CString GetTagPropertyName(CString strTagID);
	CString GetTagUserName(CString strTagID);
	BOOL TagGrantAddTagInfo(CString strTagID,CString strHomeReaderLocation,CString strAvgTransTime,CString strPropertyNo,CString strUserNo,CTime tTagGrantTime);
	CString TagGrantTagIDGeneration();
	BOOL TagGrantShowSelUserName(CComboBox * pComboBox,CEdit  * pEdit);
	BOOL TagGrantShowSelPropertyName(CComboBox * pComboBox,CEdit  * pEdit);
	BOOL TagGrantUserInfoInit(CComboBox * pComboBox,CEdit  * pEdit);
	BOOL TagGrantPropertyInfoInit(CComboBox * pComboBox,CEdit  * pEdit);
	BOOL TagGrantComboHomeReaderInit(CComboBox * pComboBox);
	BOOL ReaderDelete(CString strReaderNo);
	BOOL ReaderUpdate(CString strReaderNo,CString strIP,CString strLocation,BYTE bThreshold);
	BOOL ReaderUpdateShowSelInfo(CComboBox * pComboBox,CIPAddressCtrl * pIpAddrCtrl,CEdit * pEditLocation,CEdit * pEditThreshold);
	BOOL ReaderUpdateCombInit(CComboBox * pComboBox,CIPAddressCtrl * pIpAddrCtrl,CEdit * pEditLocation,CEdit * pEditThreshold);
	BOOL ReaderQuery(CString strReaderLocation,CListCtrl *  pListCtrl);
	BOOL ReaderQueryCombInit(CComboBox * pComboBox);
	BOOL ReaderRegister(CString strReaderNo,CString strReaderIP,CString strReaderLocation,BYTE bReaderThreshold);
	BOOL UserQuery(CString userName,CListCtrl * pListCtrl );
	BOOL UserRegister(CString userNo,CString userName,CString userAddress,CString  userPhone);
	BOOL PropertyQuery(CString strPropertyQueryKey,CListCtrl * pListCtrl );
	BOOL PropertyRegister(CString propertyNo, CString PropertyTypeNo, CString propertyName, CTime registerDate, CTime registerTime);
	_bstr_t strConnect;
	void ExitConnect();
	void OnInitADOConn();
	_ConnectionPtr m_pConnection;
	//_CommandPtr m_pCommandPtr;
	//_ParameterPtr m_pParameterPtr;
	_RecordsetPtr m_pRecordset;
	ADOConnAccess();
	virtual ~ADOConnAccess();

};

#endif // !defined(AFX_ADOCONNACCESS_H__9F39B02F_D556_4912_B598_43B5795E852F__INCLUDED_)