public void back_data()
{
var sqls = Common.Class1_pub.get1();
DateTime dtime1 = DateTime.Now;
if (dtime1.Hour == 23)
{
string sj = DateTime.Now.ToString("yyyyMMddHHmmss") + "_";
for (int i = 0; i < sqls.Count; i++)
{
//
try
{
string cmd = "BACKUP DATABASE " + sqls[i].code + " TO DISK = 'D:\\日备份\\" + sj + sqls[i].code + ".bak'";
SqlConnection sqlcon1 = new SqlConnection(sqls[i].get_constring());
SqlCommand sqlCommand1 = new SqlCommand(cmd, sqlcon1);
sqlcon1.Open();
sqlCommand1.ExecuteNonQuery();
sqlcon1.Close();
}
catch (Exception ex)
{
}
}
}
DateTime dtime2 = DateTime.Now.AddDays(-3.1);
var files = GetAllFiles(@"D:\日备份");
foreach (var fileInfo in files)
{
if (fileInfo.CreationTime < dtime2)
{
System.IO.File.Delete(fileInfo.FullName);
}
}
}
private FileInfo[] GetAllFiles(string path)
{
try
{
var files = new List<FileInfo>();
files.AddRange(new DirectoryInfo(path).GetFiles());//获取文件夹下所有文件
var tmpdics = new DirectoryInfo(path).GetDirectories();//获取文件夹下所有子文件夹
foreach (var dic in tmpdics)
{
files.AddRange(GetAllFiles(dic.FullName));//递归获取文件
}
return files.ToArray();
}
catch (Exception)
{
return null;
}
}