#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);

	//根據(jù)打印終端ip查詢，pos_no,business_id,
	int DBQueryPosByIp(char *szPosIp, long &lPosNo, long &lBusinessId, char *szCaption, char *szBusinessAddr, char *szAreaCode, char *szFonts);

	/*有號(hào)碼打印*/
	int DBAddPrintRecord(long lOperId,long lPrtPosId,char *szPhoneNumber,char *szAcctMonth,
				char *szCallType,char *szBeginTime, char *szEndTime,
				int nLineCount,long lCallFee, int nPrintedFee);

	/*統(tǒng)計(jì)該號(hào)碼打印情況*/
	int DBPhonePrintInfoStat(char *PhoneNumber, char **rs);
	//該號(hào)碼是否允許打印
	int DBQueryPhonePrintInfo(char *PhoneNumber, char *szAcctMonth , char *szCallType,int *pnPrintedCount);
	int DBQueryPhonePrintInfoReal(char *szPhoneNumber, char *szAcctMonth, int *pnPrintedCount);

	//查詢?nèi)W(wǎng)的打印情況
	int DBQueryAllPrintInfo(int nMode, char *szTime, char **rs);
	int DBQuerysddrlist(char *phone,char *wsaddrlist);
		
	/////////////////////////////////////////////////////////////////////////////

	//增加一營(yíng)業(yè)廳
	int DBAddBusiness(int &nBusinessId, char *szBusinessAddr);
	//刪除一營(yíng)業(yè)廳
	int DBDelBusiness(int nBusinessId, int nMode);
	//列出所有營(yíng)業(yè)廳
	int DBListBusiness(char **rs);
	/*查詢營(yíng)業(yè)廳打印情況*/
	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);
	//列出某一營(yíng)業(yè)廳的所有打印終端
	int DBListPosInBusiness(int nBusinessId,char **rs);

	/*打印終端狀態(tài)，打印情況*/

	//3,1,'200207',rs
	//日期\t人次\t行數(shù)\t用紙量(mm)\t打印話費(fèi)
	//
	//總計(jì)\t人次\t行數(shù)\t用紙量(mm)\t打印話費(fèi)

	/*
	//3,0,'20020726',rs
	//人次\t行數(shù)\t用紙量(mm)\t打印話費(fèi)
	*/
	int DBQueryPrtposPrintInfo(long lPrintposId, int nMode, char *szTime, char **rs);
                int CDBAdmin::DBQueryPrtposPrintInfoScope(long lPrintposId, char *szBeginTime, char *szEndTime, char **rs) ;


	/*日打印詳單*/
	//電話號(hào)\t打印時(shí)間\t目標(biāo)月份\t打印條數(shù)\t打印話費(fèi)
	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*/