delete suo sdf

w1146869587

2022-01-24 479b1995ef435713c2cf4f0da8de3a6af6c30922

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
#pragma once
 
#include "MBNetDiskWebCMgr.h"
#include "MBThreadSyncDb.h"
#include "MBThreadFireSyncDb.h"
/************************************************************************/
/* ËùÓÐÊý¾Ý¿â±íµÄ¹ÜÀí                                                   */
/************************************************************************/ 
class CMBVaultDbMgr
{
public:
    CMBVaultDbMgr(void);
    ~CMBVaultDbMgr(void);
private: 
    CString                m_strUserID;
    CString                   m_strUserName;
    CString                   m_strPwd;        
    CString                m_strSvrIP; 
    int                    m_nPort;
    bool                   m_bSyncInit;          // ÇëÏȽøÐÐͬ²½³õʼ»¯
    bool                   m_bDbInit;            // Êý¾Ý¿â³õʼ»¯±êʶ
private:
    CString                   m_strUserSessionID;   // Óû§sessionID
    CString                   m_strCfgPath;         // ÅäÖÃÎļþ·¾¶
    CString                m_strExePath;         // Ö´ÐгÌÐò·¾¶
private:
    CString                m_strParam;           // ²ÎÊý
private:
    CDBConnect               m_db;                 // Ê¹ÓÃÁË ´®ÐÐģʽ£¬¶àÏ߳̿ÉÈÎÒâʹÓà
    CMBThreadSyncDb       *m_pThreadSyncDb;      // Êý¾Ýͬ²½Ïß³Ì
    CMBThreadFireSyncDb   *m_pThreadFireSyncDb;
private:
    CMBNetDiskWebCMgr     *m_pNDWebCMgr;
    HWND                   m_hWnd;
private:
    CMBFireAppExtParam    *m_pAppExtParm;
public:
    void     SetUserSessionID( CString strUserSessionID );
    void     SetSvrInfo( CString strSvrIP,int nPort,CString strUserID,CString strUserName,CString strPwd );
    void     SetDbPath(CString strExePath,CString strCfgPath);  // ÉèÖÃ×ÊԴ·¾¶
    CString  GetExePath();
    CString  GetCfgPath();
    void     SetParam(CString strParam);
    CString  GetFireParam();
public: // OI_VAULT 
public: // OI_VAULT_ACE 
public: // OI_VAULT_CATALOG_LOG
public: // OI_VAULT_CATALOG_ACE
public: // OI_VAULT_CATALOG_HLINK
public: // OI_VAULT_PREARCHIVE 
public:  // ³õʼ»¯
    bool DbInit(CString &strErrInfo);
    bool DelDb( CString &strErrInfo ); // É¾³ýÊý¾Ý
public: // Êý¾Ýͬ²½Ïà¹Ø£¬ÐèÒªÁ¬½Ó·þÎñ 
    void SetParam( HWND hWnd,CMBNetDiskWebCMgr *pNDWebCMgr );  // ÉèÖòÎÊý
    bool SyncInit( CString &strErrInfo  );                     // Êý¾Ýͬ²½,ndµÇ¼Ïà¹Ø
    bool SyncDb( CString &strErrInfo );                        // µ÷Óýӿڣ¬Í¬²½±¾µØÊý¾Ý¿â
    bool FireSyncDb( CString strParam,CString &strErrInfo );       // µ÷Óýӿڣ¬Í¬²½±¾µØÊý¾Ý¿â
public: // OI_VAULT
    bool IsExsitVaultInDb( CString strVaultID,CString &strErrInfo );  // ´æÔÚµç×Ó²Ö¿â
    bool InsertVaultToDb(CMBVault *pVault,CString &strErrInfo);       // ²åÈëOI_VAULT
    bool UpdateVaultToDb(CMBVault *pVault,CString &strErrInfo);          // ¸üÐÂOI_VAULT
    bool SetVaultToDb(CMBVault *pVault,CString &strErrInfo);          // ÉèÖÃVaultµ½Db
public: // OI_VAULT_CATALOG
    bool IsExsitVaultCatalogInDb( CString strVaultCatalogID,CString &strErrInfo );   
    bool InsertVaultCatalogToDb(CMBVaultCatalog *pVaultCatalog,CString &strErrInfo);       
    bool UpdateVaultCatalogToDb(CMBVaultCatalog *pVaultCatalog,CString &strErrInfo);          
    bool SetVaultCatalogToDb(CMBVaultCatalog *pVaultCatalog,CString &strErrInfo);    
public: // TN_XXX
    bool IsExsitTableInDb( CString strTableName,CString &strErrInfo );    // ÅжϱíÊÇ·ñ´æÔÚ
    bool DropTableInDb(  CString strTableName,CString &strErrInfo  );      // É¾³ý±í
    bool CreateTableInDb( CString strTableSql,CString &strErrInfo );      // ´´½¨±í
    bool CreateTableInDb( CString strTableName,CString strTableSql,CString &strErrInfo );      // ´´½¨±í
    bool CreateTableInDb2( CString strTableName,CString strTableSql,CString &strErrInfo );      // ´´½¨±í
    bool InsertTableInDb( CString strInsertSql,CString &strErrInfo  );    // ²åÈë±í
    bool RunSQLInDb(CString strSql,CString &strErrInfo);
    bool IsExsitDataInDb(CString strSql,CString &strErrInfo);
public: // OI_VAULT_CATALOG_HLINK
    bool DelVaultCatalogHlink( CString &strErrInfo  );   // ÇåÀí±íµÄÊý¾Ý
    bool InsertVaultCatalogHlink( CMBVaultCatalogHlink *pVaultCatalogHlink,CString &strErrInfo  );
public: // Load
    bool LoadVaultCataLog( CDBRecord  &dbRecord,CMBVaultCatalogMgr  *pVaultCatalogMgr, CString &strErrInfo );
    bool LoadVault( CDBRecord  &dbRecord,CMBVault  *pVault, CString &strErrInfo );    
    bool LoadVault( CDBRecord  &dbRecord,CMBVaultMgr  *pVaultMgr, CString &strErrInfo );    
    bool LoadTNXXXObj( CDBRecord  &dbRecord,CString &strTNXXXXml, CString &strErrInfo );
    bool LoadTNXXXObj2( CDBRecord  &dbRecord,CString &strTNXXXXml, CString &strErrInfo );
    bool LoadTNXXXObj2( CDBRecord  &dbRecord,CString &strTNXXXXml,CStringArray &arIDs, CString &strErrInfo );
public: // TN_XXX_XXX±í 
    bool CreateTN_MClsID_DClsID( CString strTableName,CString strTableSql,CString &strErrInfo );
public:
    bool  VaultCatalogSubCount(CString strVaultID,CString strCatalogID,int &nSubCount,CString &strErrInfo);
    bool  VaultCatalogObjCount(CString strVaultID,CString strCatalogID,int &nObjCount,CString &strErrInfo);
    bool  VaultCatalogSubAndObjCount(CString strVaultID,CMBVaultCatalogMgr  *pVaultCatalogMgr,CString &strErrInfo );
    bool  VaultSubAndObjCount(CMBVaultMgr *pVaultMgr,CString &strErrInfo );
public:        
    // µÃµ½Êý¾Ý²Ö¿âÁÐ±í£¬Èç¹ûÖ¸¶¨ËùÊôID£¬ÔòÖ»·µ»Ø´ËËùÊôµÄÊý¾Ý²Ö¿â£¬·ñÔò·µ»ØÈ«²¿ 
    bool VaultGetList( CString &strVaultList,CString &strErrInfo,bool bNeedAce = false, short nVaultType = -1 ); 
    // µÃµ½Êý¾Ý²Ö¿âÐÅÏ¢
    bool VaultGetInfo( CString strVaultID, CString &strVaultInfo,CString &strErrInfo );
    // µÃµ½Ï¼¶Ä¿Â¼Áбí
    bool VaultCatalogGetList( CString strVaultID, CString strParentID, CString &strCatalogList,CString &strErrInfo ); 
    // µÃµ½Ä¿Â¼ÏµÄÊý¾Ý¶ÔÏó
    bool VaultQueryCatalogObj( CString strClsID,CString strVaultID, CString strCatalogID, CString &strResult,CString &strErrInfo );     
    //  Ä¿Â¼²éѯ
    bool VaultQueryCatalogList( CString strVaultID, CString strQueryContent, CString &strCatalogList,CString &strErrInfo );
public: //TN_XXX_XXX±í
    bool LoadTNXXXXXX( CDBRecord  &dbRecord,CString strKeyFiledName,CMBTNXXXXXXMgr *pTN6XMgr, CString &strErrInfo);
    bool LoadTNXXXXXX2( CDBRecord  &dbRecord,CMBTNXXXXXXMgr *pTN6XMgr, CString &strErrInfo);
public: //TN_XXX_XXX±í
    bool IsExsitDataInTNXXXXXX(bool &bExsit,CString &strErrInfo);  // ´æÔÚÊý¾Ý    
    bool TNXXXXXXQueryKey( CString strKey,CString &strResult,CString &strErrInfo );    
    bool TNXXXXXXQueryByID( CString strKeyValue,CStringArray &arID,CString &strErrInfo );
    bool TNXXXXXXQueryByID( CString strMID,CString strSID,CString &strResult,CString &strErrInfo );
    bool TNXXXXXXQueryMID( int nCurPage,int nPageSize,CString &strMIDs,CString &strErrInfo );
    bool TNXXXXXXDeleteByMID( CString strMIDs,CString &strErrInfo );
public:
    bool TNXXXQueryByKeyValue( CString strKeyValue,CString &strResult,CString &strErrInfo );
public:// OI_VERSION
    bool SetVersionToDb( CString strType,CString strTime,CString &strErrInfo );
    bool IsExsitVesionInDb(CString strType,bool &bExsit,CString &strErrInfo);
    bool InsertVersionToDb( CString strType,CString strTime,CString &strErrInfo );
    bool UpdateVersionToDb( CString strType,CString strTime,CString &strErrInfo );
    bool GetVersionFromDb( CString strType,CString &strTime,CString &strErrInfo );
};
 
//private:
//    CMBVaultMgr                 *m_pVaultMgr;
//    CMBVaultAceMgr             *m_pVaultAceMgr;
//    CMBVaultCatalogMgr       *m_pVaultCatalogMgr;
//    CMBVaultCatalogLogMgr    *m_pVaultCatalogLogMgr;
//    CMBVaultCatalogAceMgr     *m_pVaultCatalogAceMgr;
//    CMBVaultCatalogHlinkMgr  *m_pVaultCatalogHlinkMgr;
//    CMBVaultPreArchiveMgr    *m_pVaultPreArchiveMgr;