private void load()
{
string query = "SELECT [PKEY],[NAME],[HOST_NAME],[FILE_NAME],[REASON],[ROLLBACK_TIME]";
query += ",[STATE] FROM [dbo].[BASE_DB_ROLLBACK_RECORD]";
m_dbRollbackList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, query))
{
foreach (DataRow row in dataTable.Rows)
{
DbRollbackRecordTable record = new DbRollbackRecordTable();
record.pkey = DbDataConvert.ToInt32(row["PKEY"]);
record.name = DbDataConvert.ToString(row["NAME"]);
record.hostName = DbDataConvert.ToString(row["HOST_NAME"]);
record.fileName = DbDataConvert.ToString(row["FILE_NAME"]);
record.reason = DbDataConvert.ToString(row["REASON"]);
record.dateTime = DbDataConvert.ToString(row["ROLLBACK_TIME"]);
record.state = DbDataConvert.ToString(row["STATE"]);
m_dbRollbackList.Add(m_dbRollbackList.Count, record);
}
}
}
public void insert(DbRollbackRecordTable record)
{
string sql = "INSERT INTO [dbo].[BASE_DB_ROLLBACK_RECORD]([NAME],[HOST_NAME]";
sql += ",[FILE_NAME],[REASON],[STATE]) VALUES(";
sql += "'" + record.name + "',";
sql += "'" + record.hostName + "',";
sql += "'" + record.fileName + "',";
sql += "'" + record.reason + "',";
sql += "'恢复成功')";
try
{
DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, sql);
load();
}
catch (Exception error)
{
MessageBoxExtend.messageWarning(error.Message);
return;
}
}
