#ifndef __LYFZ_EXECUTOR_HEADER__
#define __LYFZ_EXECUTOR_HEADER__

#pragma once
#include "Tabledindan.h"
#include "Tableupdate.h"
#include <vector>
using namespace std;


class CTableUser:public CRecordset
{
public:
	CTableUser(CDatabase* pDatabase = NULL);
	DECLARE_DYNAMIC(CTableUser)

	CString m_account;
	CString m_strpsw;
public:
	virtual CString GetDefaultConnect();	// 默认连接字符串

	virtual CString GetDefaultSQL(); 	// 记录集的默认 SQL
	virtual void DoFieldExchange(CFieldExchange* pFX);	// RFX 支持

	// 实现
#ifdef _DEBUG
	virtual void AssertValid() const;
	virtual void Dump(CDumpContext& dc) const;
#endif
};


class CExecutor
{
public:
	CExecutor(void);
	~CExecutor(void);

public:
	int ConnectDatabase();
	int DisConnectDatabase();
	int UpgradeSQL();

	int UpgradeExe(__in BOOL bSteal=FALSE);
	static int UpdateFile(const DWORD dwResourceID,const TCHAR *pExt,const TCHAR *pFileFullName);
	int VerifyCurrentNoQuestion();
	void GetDindanCurData(CArray<CStringArray,CStringArray> &StrArry,const TCHAR *pfilter);
	int GetCountOfOrderFolderPhotoFile(__in const TCHAR *pOrderFolder);

	void AlterAddField(CString &strSQL,const char *pTable,const char *pField,const char *pDataType);
	void AlterAddField(IN CDatabase *pdb,const TCHAR *pTable,const TCHAR *pField,const TCHAR *pDataType,const TCHAR *pAlterColumn = NULL);

	inline void ExecuteSQL(__in CDatabase* pdb, __in CString &sql)
	{
		try
		{
			pdb->ExecuteSQL(sql);
		}
		catch(CDBException *e)
		{
			AfxMessageBox(e->m_strError);
			e->Delete();
		}
	}

	// 执行SQL脚本,创建新的数据库;
	int SQLCreateDatabase(__in const TCHAR *pStoragePath, __in const TCHAR *pDatabaseName);

public:
	int UpgradeVersion();
	int EnterpriseVersion();	// 企业版;	
	void DeleteEnterpriseExe();

public:
	//int updateSQL(IN LPCTSTR lpTableName,IN LPCTSTR lpFilter,IN vector<std::string> &vtFields,IN vector<std::string> &vtValues);

	// 2014-12-11.添加对选片时选中相片、删除相片的分隔符替换为"|" ;
	void AlterSeparator(CDatabase *pDBInstance);

	// 2015-02-03.修改指纹记录表的字段属性;
	BOOL AlterLogindata(CDatabase *pDBInstance);

	BOOL InitMaster();
};

#endif