dbproc.h.bak

是上一个SMS消费机的充值机程序

#ifndef __DB_PROC_H__

#ifdef __cplusplus
extern "C" {
#endif

#define __DB_PROC_H__

#define RT_DB_INDEX         0 
#define BL_DB_INDEX         1
#define TD_DB_INDEX1         2
#define TD_DB_INDEX2         3
#define TD_DB_INDEX3         4

typedef struct _CardStruct
{
	unsigned char cDirSector;
	unsigned char cPublishSector;
	unsigned char cMoneySector;
	unsigned char cHistorySector[3];
	unsigned char cPublicSector;
	unsigned char cOddTimesSector;
	unsigned char cEveTimesSector;
} sttCardStruct;

typedef struct _CardKey
{
	unsigned long lSerialNo;
	unsigned char cKeyA[16][6];
	unsigned char cKeyB[16][6];
} sttCardKey;

typedef struct _CardInfo
{
	unsigned long lSerialNo;
	unsigned char cKeyVersion;
	sttCardStruct stCardStruct;
	unsigned char cCityCode[2];
	unsigned char cTradeCode[2];
	unsigned long lCardNo;
	unsigned char cAuthenCode[4];
	unsigned char cUsageFlag;
	unsigned char cCardType;
	unsigned char cCardVer;
	unsigned char cNewDate[4];
	unsigned char cLimitDate[4];
	unsigned char cUseDate[4];
	unsigned int  iPreMoney;
	unsigned char cLastChargeDateTime[4];
	unsigned long lLastMoney;
	unsigned int  iLastChargeMoney;
	unsigned char cLastChargeWorker[2];
	unsigned long lMoneySum;
	unsigned long lCurMoney;
	unsigned char cChargeDevice[4];
	unsigned long lMoney;
	unsigned long lMoneyBak;
	unsigned char cHistroyTime[4];
	unsigned long lHistroyMoney;
	unsigned long lHistroyChargeMoney;
	unsigned char cHistroyType;
	unsigned char cHistroyPSAMNo[4];
	unsigned char cHisCharge;
	unsigned int  iMoneyTotleTimes;
	unsigned char cChargeStep;
	unsigned int  iTimesTotleTimes;
	unsigned char cBlackListFlag;
	unsigned char cFileFlag;
	unsigned int  iGetInfoFinished;
} sttCardInfo;

typedef struct _ChargeRecord
{
	unsigned char cSerialNo[4];
	unsigned char cCityCode[2];
	unsigned char cTradeCode[2];
	unsigned char cCardNo[4];
	unsigned char cCardAuthenCode[4];
	unsigned char cCardType;
	unsigned char cTotleChargeTimes[2];
	unsigned char cMoneyOrTimes[4];
	unsigned char cChargeMoneyOrTimes[3];
	unsigned char cChargeDateTime[7];
	unsigned char cChargeType;
	unsigned char cData[2];
	unsigned char cTAC[4];
} sttChargeRecord;

typedef struct _SysRunTime
{
	unsigned short sSysVersion;              //系统版本号
	unsigned char  cLastTradeHandleDb;
	unsigned long  lLastTradeHandle;         //最后加入交易纪录的下一个位置
	unsigned char  cLastGatherFromDb; 
	unsigned long  lLastGatherFrom;          //最后采集从
	unsigned char  cLastGatherToDb;
	unsigned long  lLastGatherTo;		 //最后采集到，这个区间是[lLastGatherFrom,lLastGatherTo)
	unsigned char  cLastGatherDateTime[7];   //最后采集日期时间
	unsigned char  cLastBLDateTime[7];	 //最后黑名单日期时间
	
	unsigned int iTradeTimes;		//交易次数总数
	unsigned long lTradeMoney;		//交易金额总额
	//unsigned char  reserver[995];	         //保留
} sttSysRunTime;

//typedef struct _PacketHead
//{
//	unsigned char  cBuildDateTime[7];
//	unsigned char  cSAMNo[8];
//	unsigned short sSerial;
//	unsigned long  lTradeSerialNo;
//	unsigned short sRecordNumber;
//	unsigned char  cBcc;	 
//} sttPacketHead;
//
//typedef struct _BlackListHead
//{
//	unsigned char  cBuildDateTime[7];
//	unsigned short sSerial;
//	unsigned long  lBlackNumber;
//	unsigned char  cBcc;
//} sttBlackListHead;

typedef struct _PacketHead
{
	unsigned char  cBuildDateTime[7];
	unsigned char  cSAMNo[8];
	unsigned char  cSerial[2];
	unsigned char  cTradeSerialNo[4];
	unsigned char  cRecordNumber[2];
	unsigned char  cBcc;	 
} sttPacketHead;

typedef struct _BlackListHead
{
	unsigned char  cBuildDateTime[7];
	unsigned char  cSerial[2];
	unsigned char  cBlackNumber[2];
	unsigned char  cBcc;
} sttBlackListHead;

extern short initDb();
extern short getSysRunTime(sttSysRunTime *srt);
extern short updateSysRunTime(sttSysRunTime *srt);
extern short updateBlackList(unsigned char * blPacket);
extern short findBlackList(unsigned char * cardNo);
extern short wrapTradeRecord(unsigned char *inBuf, int serialNo, sttSysRunTime *pSrt);
extern short appendTradeRecord(sttChargeRecord *cr);
extern void getBCDDateTime(unsigned char *dt);

#ifdef __cplusplus
}
#endif

#endif /* __DB_PROC_H__ */