/// <summary>
/// 添加数据库备份恢复记录
/// </summary>
/// <param name="Type">类型：备份、恢复</param>
/// <param name="File">文件名</param>
/// <param name="Size">文件大小</param>
/// <param name="CreateUserName">创建用户</param>
/// <param name="DB">所属数据库</param>
/// <param name="Memo">备注</param>
/// <returns></returns>
public void Add_Backup_Restore_Log(string Type, string File, string Size, string CreateUserName, string DB, string Memo)
{
LogHelper Logger = new LogHelper("Backup_Restore_Log");
Hashtable ht = new Hashtable();
StringBuilder sb = new StringBuilder();
sb.Append(Type + "∫");
sb.Append(File + "∫");
sb.Append(Size + "∫");
sb.Append(CreateUserName + "∫");
sb.Append(DB + "∫");
sb.Append(Memo + "∫");
sb.Append(DateTime.Now + "∫");
sb.Append("∮");
Logger.WriteLog(sb.ToString());
}
/// <summary>
/// 数据库备份还原记录
/// </summary>
/// <returns></returns>
public DataTable GetBackup_Restore_Log_List()
{
LogHelper Logger = new LogHelper("Backup_Restore_Log");
string filepath = ConfigHelper.GetAppSettings("LogFilePath") + "/Backup_Restore_Log.log";
StreamReader sr = new StreamReader(filepath, Encoding.GetEncoding("UTF-8"));//取得这txt文件的编码
string[] strvalue = sr.ReadToEnd().ToString().Split('∮');
sr.Close();
DataTable dt = new DataTable();
dt.Columns.Add("Backup_Restore_Type", Type.GetType("System.String"));
dt.Columns.Add("Backup_Restore_File", Type.GetType("System.String"));
dt.Columns.Add("Backup_Restore_Size", Type.GetType("System.String"));
dt.Columns.Add("CreateUserName", Type.GetType("System.String"));
dt.Columns.Add("Backup_Restore_DB", Type.GetType("System.String"));
dt.Columns.Add("Backup_Restore_Memo", Type.GetType("System.String"));
dt.Columns.Add("CreateDate", Type.GetType("System.String"));
foreach (string item in strvalue)
{
if (item.Length > 6)
{
string[] str_item = item.Split('∫');
DataRow row = dt.NewRow();
string[] Typeitem = str_item[0].Split(']');
row["Backup_Restore_Type"] = Typeitem[1].Trim();
row["Backup_Restore_File"] = str_item[1];
row["Backup_Restore_Size"] = str_item[2];
row["CreateUserName"] = str_item[3];
row["Backup_Restore_DB"] = str_item[4];
row["Backup_Restore_Memo"] = str_item[5];
row["CreateDate"] = str_item[6];
dt.Rows.Add(row);
}
}
dt.DefaultView.Sort = "CreateDate DESC";//DataTable排序
DataTable dtTemp = dt.DefaultView.ToTable();
return dtTemp;
}
