#if !defined(AFX_UIIADORXSERVER_H__0D757B27_D77D_4FF7_B950_1FAC5E23F668__INCLUDED_)
#define AFX_UIIADORXSERVER_H__0D757B27_D77D_4FF7_B950_1FAC5E23F668__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif

#ifndef  __UIIVALUETABLE_H__
#include "UIIValueTable.h"
#endif

#ifndef __AFXTEMPL_H__
#include <afxtempl.h>
#endif

#include <comdef.h>
#include "UIITableField.h"

#include <map>
#include <vector>

class TGADOSRV_API CUIIADORXServer  
{

public:
			 CUIIADORXServer();
	virtual ~CUIIADORXServer();

			//建立连接、连接数据库，打开数据库[access本地]
			//示例 
			//mdb : sDbFileName="DRIVER={Microsoft Access Driver (*.mdb)};"
			//"DBQ=c:\\mydata.mdb;UID=sa;PWD=";

			//xls : Driver={Microsoft Excel Driver (*.xls)};"
			//"DBQ=c:\\mydata.xls;ReadOnly=false;"
	virtual BOOL	InitADOServer(LPCTSTR pszDbFileName);

			//建立连接、连接数据库，打开数据库
			//示例:
			//_bstr_t strCnn("Provider=sqloledb;Data Source=MyServer;"
			//"Initial Catalog=pubs;User Id=sa;Password=;");
			// ConnectOptionEnum OptionEnum = adConnectUnspecified
			// or 
			//sConnect.Format(_T("Driver=SQL Server;Server=%s;Database=%s;User Id=%s;Password=%s;"),
			//sSQLSrv,_T("SH-EarthWorm"),sUser,sPassword);
	virtual BOOL	InitADOServer(LPCTSTR pszConnection,bool bDisplayException, int OptionEnum = -1);

			//建立连接、连接数据库，打开数据库
			//示例:
			//_bstr_t strCnn("DSN=CAPP;UID=sa;PWD="
			// ConnectModeEnum eMode = adModeUnknown,CursorTypeEnum eCursor = adOpenUnspecified
	virtual BOOL	InitADOServer(LPCTSTR pszDSN,LPCTSTR pszUserID,LPCTSTR pszPassword, int eMode = 0, int eCursor = -1);

	virtual BOOL	GetConnection(CString& sConntion);

	virtual void	SetDatabase(LPCTSTR pszDatabase);

	virtual LPCTSTR GetDatabase();

	virtual void	AppendAssocDatabase(LPCTSTR pszKey,LPCTSTR pszAssocDb);

	virtual BOOL	AssocDatabase(LPCTSTR pszKey,CString& sAssocDb);

			//设置登录者的ID
	virtual void	SetLoginID(LPCTSTR pszLoginName);

			//获取登录者的ID
	virtual LPCTSTR GetLoginID();

			//设置登录的组ID
	virtual void	SetGroupID(LPCTSTR pszGroup);
			
			//获取登录的组ID
	virtual LPCTSTR GetGroupID();

	virtual BOOL	CreateOLEDBTable(LPCTSTR pszTableName,Ttable& arFields,LPCTSTR pszsDbName = NULL);

			//创建表及表的字段名
	virtual BOOL	CreateSQLSrvTable(LPCTSTR pszTableName,Ttable& arFields,LPCTSTR pszDbName = NULL);

	virtual BOOL	IsSQLSrvTableExist(LPCTSTR pszTableName,LPCTSTR pszDbName);

			//获取表的结构信息
	virtual BOOL	GetSQLSrvTableStru(LPCTSTR pszTableName,Ttable &arFields,LPCTSTR pszDbName = NULL);

			//获取表的结构信息
	virtual BOOL	GetSQLSrvTableStru(LPCTSTR pszTableName,CStringList &listField,LPCTSTR pszDbName = NULL);

			//获取表的结构信息
	virtual BOOL	GetTableStructInfoEx(LPCTSTR pszTableName,Ttable& arFields);

			//删除数据库中的表
	virtual BOOL	DeleteTable(LPCTSTR pszTableName);
	
			//删除数据库中的若干表
	virtual BOOL	DeleteTable(CStringArray& arTableNames);

			//删除表中若干字段名
	virtual BOOL	DeleteTableFields(LPCTSTR pszTableName,CStringArray& arFields,LPCTSTR pszDbName);

			//删除表中字段
	virtual BOOL	DeleteTableFields(LPCTSTR pszTableName,LPCTSTR pszFields,LPCTSTR pszDbName);

			//向表中增加若干字段名
	virtual BOOL	AppendTableFields(LPCTSTR pszTableName,Ttable &arFields,LPCTSTR pszDbName);

			//向表中增加字段
	virtual BOOL	AppendTableFields(LPCTSTR pszTableName, CUIITableField& arFields,LPCTSTR pszDbName);

			//获得一个数值
	virtual int		GetSelData(LPCTSTR pszStrSQL,CString& sValue);

			//把获得相应的信息填到数组中
	virtual int		GetSelData(LPCTSTR pszStrSQL,CStringArray &arStrValue);
	virtual int     GetSelData(LPCTSTR pszStrSQL,CStringArray &arStrValue,int nFr, int nTo);

	virtual int		GetSelData(LPCTSTR pszStrSQL, std::vector<CString>& arStrValue);

			//是否是空选择集
	virtual BOOL	IsSelEmpty(LPCTSTR pszStrSQL);
			
			//把获得相应的信息填到链表中
	virtual int		GetSelData(LPCTSTR pszStrSQL,CStringList &listStrValue,BOOL bMakeLower= TRUE);
	virtual int		GetSelData(LPCTSTR pszStrSQL,CStringList &listStrValue, int nFr, int nTo, BOOL bMakeLower= TRUE);

			//选取多个字段，把获得相应的信息填到'表'对象中
	virtual int		GetSelData(LPCTSTR pszStrSQL,CUIIValueTable &valueTable,BOOL bUpdateLable = TRUE);
	virtual int		GetSelData(LPCTSTR pszStrSQL,CUIIValueTable &valueTable, int nFr, int nTo, BOOL bUpdateLable = TRUE);

			//选取一个作为Key,和一个作为Value的SQL,取的记录添到map中
	virtual int		GetSelData(LPCTSTR pszSKey_ValueSQL,CMapStringToString &mapKey_Value);
	virtual int		GetSelData(LPCTSTR pszSKey_ValueSQL,std::map<CString, CString>& mapKey_Value);

			//选取一行,获得Field到对应数据的映射
	virtual int		GetSelDataEx(LPCTSTR pszSelectSQL,CMapStringToString &mapFieldToValue);
	virtual int		GetSelDataEx(LPCTSTR pszSelectSQL,std::map<CString, CString>& mapFieldToValue);
	virtual int		GetSelDataEx(LPCTSTR pszSelectSQL, std::vector<std::vector<CString>>& datas);
	virtual int		GetSelDataEx(LPCTSTR pszSelectSQL, std::vector<std::map<CString, CString>>& datas);

			//把获得相应的信息填到vResults中
	virtual int		GetSelData(LPCTSTR pszStrSQL,_variant_t &vResults,long &lAdoRow,long &lAdoCol);

			//获得数据库中所有的表名
	virtual void	GetSQLSrvTableNames(CStringList& listTables,LPCTSTR pszDbName);

			//获得数据库中所有的表名
	virtual void	GetSQLSrvTableNames(CStringArray& arTables,LPCTSTR pszDbName);

			//获得数据库中所有的表名
	virtual void	GetTableNameArray(CStringArray& arTables,LPCTSTR pszTableType = _T("TABLE"));

			//获得数据库中所有的表名
	virtual void	GetOLDBTableNameList(CStringList &listTables,LPCTSTR pszTableType = _T("TABLE"));

			//获得数据库中所有的表名
	virtual void	GetOLDBTableNameArray(CStringArray &arTables,LPCTSTR pszTableType = _T("TABLE"));

	//blob 操作
	//insert into table (id,name,picture) values (0,'namestr',?)
	//table 对应 id,name 的数据
	virtual int		InsertBlob(LPCTSTR pszSQL,void* pData,int nSize);
	virtual int		InsertBlob(LPCTSTR pszSQL,LPCTSTR pszFile);

	//update table set id=,name='namestr',picture=? where ...
	virtual int		UpdateBlob(LPCTSTR pszSQL,void* pData,int nSize);
	virtual int		UpdateBlob(LPCTSTR pszSQL,LPCTSTR pszFile);

	//select picture from table where id=...
	virtual int		GetSelBlob(LPCTSTR pszSQL,void*& pData,int& nSize);
	virtual int		GetSelBlob(LPCTSTR pszSQL,LPCTSTR pszFilePath);

			//执行SQL语句[如 删除，追加，更新]
	virtual BOOL	ExecuteSQL(LPCTSTR pszStrSQL);

			//判断数据库是否成功打开
	virtual BOOL	IsDatabaseOpen();

			//取得连接数据库指针
			// _ConnectionPtr pConnect(pDistch);
	virtual IDispatch* GetConnectionPtr();

	virtual void BeginTrans();

	virtual void RollbackTrans();

	virtual void CommitTrans();

private:
	
	LPVOID	m_pImp;
};

#endif //AFX_UIIADORXSERVER_H__0D757B27_D77D_4FF7_B950_1FAC5E23F668__INCLUDED_