From 08d963298148327571feeaea057185d6cbfb0965 Mon Sep 17 00:00:00 2001
From: w1146869587 <wah1146869587@126.com>
Date: 星期三, 10 十一月 2021 11:59:19 +0800
Subject: [PATCH] bak insert back adj

---
 mbwatch/mbwatchdb.h |   36 ++++++++++++++++++++++++++++++++----
 1 files changed, 32 insertions(+), 4 deletions(-)

diff --git a/mbwatch/mbwatchdb.h b/mbwatch/mbwatchdb.h
index 696bf63..d46d828 100644
--- a/mbwatch/mbwatchdb.h
+++ b/mbwatch/mbwatchdb.h
@@ -26,7 +26,7 @@
 private:
     bool         execSql( QString sql,QString &errInfo );  // 鎵цsql
     bool         execSql(QSqlDatabase &db,QString sql,QString &errInfo );  // 鎵цsql
-    bool         getTmpFiledSql( QString sql,QString &tmpValue,QString &errInfo );  // 鑾峰彇tmp瀛楁鐨勫�
+    bool         getFiledValueSql( QString sql,QString &tmpValue,QString tmpFiled,QString &errInfo );  // 鑾峰彇tmp瀛楁鐨勫�
     bool         exsitSql( QString sql,bool &bExsit,QString &errInfo );
     bool         isTableExist(QString table);
 private:
@@ -38,13 +38,41 @@
     bool         loadDB(QSqlQuery &query);
 public:
     bool         queryDB(QString &errInfo);
+private: // log db
+    bool         exsitLogDB(QString fileName,bool &bExsit,QString &errInfo);
+    bool         updateLogDB(QString fileName,QString lastMdfTime,QString &errInfo);         // 鏇存柊DB
+    bool         insertLogDB(QString fileName,QString lastMdfTime,QString &errInfo);         // 鎻掑叆DB
+    bool         getLastMdfTimeLogDB(QString fileName,QString &lastMdfTime,QString &errInfo);
 public:
+    bool         setLogDB(QString &cmd,bool &bOpDB,QString fileName,QString lastMdfTime, QString &errInfo);
+    bool         setLogDB(bool &bOpDB,QString fileName,QString lastMdfTime, QString &errInfo);
+private: // backup db
     bool         insertBackupDirDB(QString opType,QString fileName,
                                    QString newFileName,QString svrPath,
-                                   QString lastMdfTime);
-    bool         insertBackupDirDB(QString fileName,
+                                   QString svrFlag,QString &errInfo);
+    bool         exsitFileNameBackupDirDB(QString fileName,bool &bExsit,QString &errInfo);
+private:
+    bool         delBackupDirDB(QString fileName,QString &errInfo);
+    bool         renameBakcupDirDB(QString opType,QString fileName,
                                    QString newFileName,QString svrPath,
-                                   QString lastMdfTime);
+                                   QString svrFlag,QString &errInfo);
+    bool         newBakcupDirDB(QString opType,QString fileName,
+                                   QString newFileName,QString svrPath,
+                                   QString svrFlag,QString &errInfo);
+    bool         mdyBakcupDirDB(QString opType,QString fileName,
+                                   QString newFileName,QString svrPath,
+                                   QString svrFlag,QString &errInfo);
+public:
+    bool         setBackupDirDB(QString opType,QString fileName,
+                                QString newFileName,QString svrPath,
+                                QString lastMdfTime,QString svrFlag,QString &errInfo);
+public: // 璋冩暣鏁版嵁搴�+    bool         adjDB(QString opType,QString fileName,
+                                   QString newFileName,QString svrPath,
+                                   QString lastMdfTime,QString svrFlag,QString &errInfo);
+    bool         adjDB(QString fileName,
+                                   QString newFileName,QString svrPath,
+                                   QString lastMdfTime,QString svrFlag,QString &errInfo);
 };
 
 #endif // MBWATCHDB_H

--
Gitblit v1.9.1