operdb.h

RFID 的实用例子,登陆使用了标准动态库类

// OperDb.h: interface for the COperDb class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_OPERDB_H__7E89F11C_9CD6_4D57_A88B_118BC697246B__INCLUDED_)
#define AFX_OPERDB_H__7E89F11C_9CD6_4D57_A88B_118BC697246B__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include <comdef.h>
#include "ClassUsed.h"

#ifndef DLL_FILE
#define DLL_FILE
#endif

#ifdef DLL_FILE
class _declspec(dllexport) COperDb //导出类
#else
class _declspec(dllimport) COperDb //导入类
#endif
{
public:
		//查询两个不能重复的字段.当其中的的关键字段(整形)唯一的时候, 另一个唯一字段值是否与其他记录重复.
	int GetRecCountOneIntegerKey(CString strTableName, CString strKeyFieldName, CString strNormalFieldName, CString strKeyValue, CString strNormalValue);
	//删除记录
	int DelRec(CString strTableName,CString strKeyFieldName,CString strKeyValue);
	//查询两个不能重复的字段.当其中的的关键字段唯一的时候, 另一个唯一字段值是否与其他记录重复.
	int GetRecCountOneKey(CString strTableName,CString strKeyFieldName,CString strNormalFieldName,CString  strKeyValue,CString strNormalValue);
//	int GetCount(CString strTableName,CString strFieldName,CString strValue);
	COperDb();
	virtual ~COperDb();
	//1.打开关闭数据库
	BOOL OpenDb();
	void CloseDb();
	//2.数据类型转换
	CString CrackStrVariant(const _variant_t &var);
	int ConvertHexToInt(char *chData, int b, int e);
	int ConvertIntToHexBlock(CString &strReturn, CString strBuf, int no);
	CString ConvertHexToByte(char *chData, int b, int e);
	long HexStrToLong(CString str);
	int Byte1ToInt(CString str);
	void Str2Char(CString inStr, char* outChar);
	CString IntToCString(int n);
	//3.时间转换
	long CmpTime(CString stime1,CString stime2);
	CTime StrToTime(CString str);
	CString CurrTimeToStr();
	int Caltime(CString strBegintime, CString strEndtime);
	//4.数据库内查找

	void TranslationInDB(CString strTableName, CString strSourceName, CString strDestinationName, CString strSource, CString &strDestination);	
	void ExcuteSQLWithNoReturnValue(CString strBuf);
	void ReadProductInfoFromDB(int sn,  CProductInfo &pPro);
	void ReadProductInfoByCode(CString str, CProductInfo &pPro);
	void FindEmployee(CString strCardUid, CString &strName, int &nNo);
	int GetCount(CString strTableName);
	int GetRecCount(CString strTableName, CString strFieldName, CString strValue);
	int GetMaxCount(CString strTableName, CString strFieldName);
	int GetCountADay(CString strTableName, CString strFieldName);
	int GetCountAMonth(CString strTableName, CString strFieldName);

	//5.特殊数据库操作
	int WriteToWarehouseDB(CProductInfo &pPro, COperatorInfo &pOperInfo,CProcedureOperate &pOper,CPlanInfo &pPlan);
	int GetWarehouseItemCount(CString code);

	//6.电子标签操作
	int ReadFromCardAndDB(int nMSN,	CProductInfo &pPro, COperatorInfo &pOperInfo, CProcedureOperate &pOper);
	void ReadECard(CString &strName, int &nNo);
	void ReadERole(CString &strName, CString &strUserNo, CString &strRoleCode);
	void FindEmployeeRoleID(CString strCardUid,CString &strName, CString &strUserNo, CString &RoleID);
	void FindEmployeeRoleID2(CString &strEmployeenNo, CString &strPassword, CString &RoleID);

	_ConnectionPtr pConn;
	_RecordsetPtr pRecordset;
	_CommandPtr pCommand;
	//7.test
private:

};

#endif // !defined(AFX_OPERDB_H__7E89F11C_9CD6_4D57_A88B_118BC697246B__INCLUDED_)