?? dbadmin.h
字號(hào):
#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*/
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -