public JsonResult Backfile()
{
string[] connstr = UtilConf.GetConnectionString("SqlDSN").Split(';');
dbname = connstr[3].Split('=')[1];
string filename = DateTime.Today.ToString("yyyy-MM-dd") + ".bak";
string finame = filename;
string oldpath = Utils.GetMapPath(filepath);
int file_append = 0;
while (System.IO.File.Exists(oldpath + filename))
{
file_append++;
filename = System.IO.Path.GetFileNameWithoutExtension(finame) + "(" + file_append.ToString() + ")" + System.IO.Path.GetExtension(finame).ToLower();
}
try
{
//DataManager.Backup(dbname);
DataManager.Backup(dbname, Utils.GetMapPath(filepath) + filename);
strStatus = "1";
strMsg = "备份成功！";
return(Json(new { status = strStatus, msg = strMsg }));
}
catch (Exception ex)
{
strStatus = "0";
strMsg = "生成异常！" + ex.Message;
return(Json(new { status = strStatus, msg = strMsg }));
}
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="strDSN">数据库连接串名</param>
public Helper(string strDSN)
{
dsn = UtilConf.GetConnectionString(strDSN);
string encrypt = UtilConf.GetConnectionString("encrypt");
if (encrypt == "true")//解密
{
dsn = Crypto.DES.Decrypt(dsn);
}
}
public ActionResult DataInfo()
{
string[] connstr = UtilConf.GetConnectionString("SqlDSN").Split(';');
dbname = connstr[3].Split('=')[1];
DataTable DataStatus = DataManager.GetDataStatus(dbname); //状态信息
DataTable FileInfo = DataManager.GetFileInfo(dbname); //状态信息
DataTable Configure = DataManager.GetConfigure(dbname); //配置信息
//DataTable TableStatus = DataManager.GetTableStatus(dbname);//表信息
ViewBag.DataStatus = DataStatus;
ViewBag.FileInfo = FileInfo;
ViewBag.Configure = Configure;
//ViewBag.TableStatus = TableStatus;
return(View());
}
public JsonResult Restfile(string fname)
{
var path = Utils.GetMapPath(filepath + fname);
try
{
string[] connstr = UtilConf.GetConnectionString("SqlDSN").Split(';');
dbname = connstr[3].Split('=')[1];
DataManager.Restore(dbname, path);
strStatus = "1";
strMsg = "恢复备份成功！";
return(Json(new { status = strStatus, msg = strMsg }));
}
catch (Exception ex)
{
strStatus = "0";
strMsg = "恢复备份异常！" + ex.Message;
return(Json(new { status = strStatus, msg = strMsg }));
}
}
public DbCommand(string strDSN)
{
Log.LogInformation(strDSN);
//dsn = Configuration.GetConnectionString(strDSN);
dsn = UtilConf.GetConnectionString(strDSN);
}
/// <summary>
/// 构造函数
/// </summary>
public DbCommand()
{
//dsn = Encrypt.Dec(dsn); //解密
//dsn = Configuration.GetConnectionString("SqlDSN");
dsn = UtilConf.GetConnectionString("SqlDSN");
}
