private void load() { string query = "SELECT [PKEY],[BACK_TYPE],[NAME],[HOST_NAME],[SAVE_PATH1],[SAVE_PATH2],[REASON],[NOTE]"; query += ",[BACKUP_TIME],[STATE] FROM [dbo].[BASE_DB_BACKUP_RECORD] ORDER BY PKEY"; m_dbBackupList.Clear(); using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, query)) { foreach (DataRow row in dataTable.Rows) { DbBackupRecordTable record = new DbBackupRecordTable(); record.pkey = DbDataConvert.ToInt32(row["PKEY"]); record.backType = DbDataConvert.ToInt32(row["BACK_TYPE"]); record.name = DbDataConvert.ToString(row["NAME"]); record.hostName = DbDataConvert.ToString(row["HOST_NAME"]); record.savePath1 = DbDataConvert.ToString(row["SAVE_PATH1"]); record.savePath2 = DbDataConvert.ToString(row["SAVE_PATH2"]); record.reason = DbDataConvert.ToString(row["REASON"]); record.note = DbDataConvert.ToString(row["NOTE"]); record.backupTime = DbDataConvert.ToString(row["BACKUP_TIME"]); record.state = DbDataConvert.ToString(row["STATE"]); m_dbBackupList.Add(m_dbBackupList.Count, record); } } }
public void insert(DbBackupRecordTable record) { string sql = "INSERT INTO [dbo].[BASE_DB_BACKUP_RECORD]([BACK_TYPE],[NAME],[HOST_NAME],"; sql += "[SAVE_PATH1],[SAVE_PATH2],[REASON],[NOTE],[STATE]) VALUES("; sql += "0,"; // 代表手动备份 sql += "'" + record.name + "',"; sql += "'" + record.hostName + "',"; sql += "'" + record.savePath1 + "',"; sql += "'" + record.savePath2 + "',"; sql += "'" + record.reason + "',"; sql += "'" + record.note + "','备份成功')"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, sql); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }