dbadmin.h

本源码为移动公司话费查询中间件TUXEDO使用的实例

#ifndef _DBADMI_H_KIN
#define _DBADMI_H_KIN

#import "c:\program files\common files\system\ado\msado15.dll" rename_namespace("ADODB") rename("EOF", "ADOEOF")
using namespace ADODB;

//////////////////////////////////////////////////////
class CDBAdmin
{
public:
	CDBAdmin();
	~CDBAdmin();
public:
	void	DBSQLError();
	int	DBConnectDatabase(char *pszLoginName, char *pszLoginPasswd, char *pszDBString);
	void	DBDisconnectDatabase();

	/*操作员管理*/
	int DBCheckOperPasswd(long nPrintId,  char *szUserName,char *szPasswd,int *pnPrivilege); //level check
    int DBChangeOperPasswd(long lPosNO,char *szUserName,char *szOldPasswd,char *szNewPasswd);

	//根据打印终端ip查询，pos_no,business_id,
	int DBQueryPosByIp(char *szPosIp, long &lPosNo, long &lBusinessId, char *szCaption, char *szBusinessAddr, char *szAreaCode, char *szFonts);

	/*有号码打印*/
	int DBAddPrintRecord(long lOperId,long lPrtPosId,char *szPhoneNumber,char *szAcctMonth,
				char *szCallType,char *szBeginTime, char *szEndTime,
				int nLineCount,long lCallFee, int nPrintedFee);

	/*统计该号码打印情况*/
	int DBPhonePrintInfoStat(char *PhoneNumber, char **rs);
	//该号码是否允许打印
	int DBQueryPhonePrintInfo(char *PhoneNumber, char *szAcctMonth , char *szCallType,int *pnPrintedCount);
	int DBQueryPhonePrintInfoReal(char *szPhoneNumber, char *szAcctMonth, int *pnPrintedCount);

	//查询全网的打印情况
	int DBQueryAllPrintInfo(int nMode, char *szTime, char **rs);
	int DBQuerysddrlist(char *phone,char *wsaddrlist);
		
	/////////////////////////////////////////////////////////////////////////////

	//增加一营业厅
	int DBAddBusiness(int &nBusinessId, char *szBusinessAddr);
	//删除一营业厅
	int DBDelBusiness(int nBusinessId, int nMode);
	//列出所有营业厅
	int DBListBusiness(char **rs);
	/*查询营业厅打印情况*/
	int DBQueryBusinessPrintInfo(long lBusinessId, int nMode, char *szTime, char **rs);

	/////////////////////////////////////////////////////////////////////////////
	//增加一打印终端
	int DBAddPrintPos(char *szPosIp, int nBusinessId, char *szPosName);
	//删除一打印终端
	int DBDelPrintPos(char *szPosIp, int nMode);
	//列出所有打印终端
	int DBListAllPrintPos(char **rs);
	//列出某一营业厅的所有打印终端
	int DBListPosInBusiness(int nBusinessId,char **rs);

	/*打印终端状态，打印情况*/

	//3,1,'200207',rs
	//日期\t人次\t行数\t用纸量(mm)\t打印话费
	//
	//总计\t人次\t行数\t用纸量(mm)\t打印话费

	/*
	//3,0,'20020726',rs
	//人次\t行数\t用纸量(mm)\t打印话费
	*/
	int DBQueryPrtposPrintInfo(long lPrintposId, int nMode, char *szTime, char **rs);
                int CDBAdmin::DBQueryPrtposPrintInfoScope(long lPrintposId, char *szBeginTime, char *szEndTime, char **rs) ;


	/*日打印详单*/
	//电话号\t打印时间\t目标月份\t打印条数\t打印话费
	int DBQueryPrtposPrintInfoDetail(long lPrintposId, char *szTime, char **rs);
               int DBQueryPrtposPrintInfoDetailScope(long lPrintposId, char *szBeginTime, char *szEndTime, char **rs);


	//int DBQueryPrtposPrintInfo(long lPrintposId, char *szBeginTime, char *szEndTime, char **rs);
	//int DBQueryPrtposPrintInfoDetail(long lPrintposId,char *szBeginTime, char *szEndTime, char **rs);

	int DBUpdatePrintposStatus(long lPrintposId, char *szStatusCode);
	int DBQueryPrintposStatus(long lPrintposId, char *szStatusCode);
	/////////////////////////////////////////////////////////////////////////////////

	/*日志记录*/
	int DBWriteLog(char *szLogTime,char *szLogDesc,long lOperId,char *szOperType);

	/*打印终端的功能模块*/
	int DBGetFuncInfo(long lFuncId,char *szFuncVer, char *szFuncPath);


public:
	int DBGetSystemPara(char *szAreaCode, char *szSysParaCode, char *szSysParaValue, char *szSysParaDesc);
	int DBGetCallType(char *szAreaCode, char *szRetParaString, int *pnParaCount);

	void DBFreeBuff(char *pBuff);
private:
	_ConnectionPtr m_pCon;
};

#endif /*_DBADMI_H_KIN*/