/// <summary>
///
/// </summary>
/// <param name="BackupServerFile"></param>
/// <param name="conn"></param>
/// <returns></returns>
public int InsertBackupServerFile(BackupServerFile BackupServerFile, OdbcConnection conn)
{
try
{
return(db.insert(BackupServerFile, "backupServerFile", conn));
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
///
/// </summary>
/// <param name="BackupServerFile"></param>
/// <returns></returns>
public int InsertBackupServerFile(BackupServerFile BackupServerFile)
{
OdbcConnection conn;
int count = 0;
using (conn = OdbcHelper.CreateConntion())
{
conn.Open();
count = BackupServerFileDal.InsertBackupServerFile(BackupServerFile, conn);
conn.Close();
}
return(count);
}
/// <summary>
///
/// </summary>
/// <param name="BackupServerFile"></param>
/// <param name="conn"></param>
/// <returns></returns>
public int UpdateBackupServerFile(BackupServerFile BackupServerFile, OdbcConnection conn)
{
int result = -1;
string sql = "UPDATE backupServerFile SET backupServerGroupID = ?,"
+ " backupServerID = ?,"
+ " backupServerFileName = ?, "
+ " backupServerFilePath = ?,"
+ " backupServerFileType = ?,"
+ " backupServerFileSize = ?,"
+ " backupStartTime = ?,"
+ " backupEndTime = ?,"
+ " backupTime = ?,"
+ " backupFlg = ?,"
+ " copyStartTime = ?,"
+ " copyEndTime = ?,"
+ " copyTime = ?,"
+ " copyFlg = ?,"
+ " updater = ?,"
+ " updateDate = ?"
+ " WHERE id = ?";
OdbcParameter[] para = new OdbcParameter[] {
new OdbcParameter("@backupServerGroupID", BackupServerFile.backupServerGroupID),
new OdbcParameter("@backupServerID", BackupServerFile.backupServerID),
new OdbcParameter("@backupServerFileName", BackupServerFile.backupServerFileName),
new OdbcParameter("@backupServerFilePath", BackupServerFile.backupServerFilePath),
new OdbcParameter("@backupServerFileType", BackupServerFile.backupServerFileType),
new OdbcParameter("@backupServerFileSize", BackupServerFile.backupServerFileSize),
new OdbcParameter("@backupStartTime", BackupServerFile.backupStartTime),
new OdbcParameter("@backupEndTime", BackupServerFile.backupEndTime),
new OdbcParameter("@backupTime", BackupServerFile.backupTime),
new OdbcParameter("@backupFlg", BackupServerFile.backupFlg),
new OdbcParameter("@copyStartTime", BackupServerFile.copyStartTime),
new OdbcParameter("@copyEndTime", BackupServerFile.copyEndTime),
new OdbcParameter("@copyTime", BackupServerFile.copyTime),
new OdbcParameter("@copyFlg", BackupServerFile.copyFlg),
new OdbcParameter("@updater", BackupServerFile.updater),
new OdbcParameter("@updateDate", BackupServerFile.updateDate),
new OdbcParameter("@id", BackupServerFile.id)
};
try
{
result = db.Udaquery(sql, conn, para);
}
catch (Exception e)
{
throw e;
}
return(result);
}
public int UpdateBackupServerFile(BackupServerFile BackupServerFile, SqlConnection conn)
{
int result = -1;
string sql = "UPDATE backupServerFile SET backupServerGroupID = @servergroupid,"
+ " backupServerID = @serverid,"
+ " backupServerFileName = @serverfilename, "
+ " backupServerFilePath =@serverfilepath,"
+ " backupServerFileType =@serverfiletype,"
+ " backupServerFileSize =@serverfilesize,"
+ " backupStartTime =@backupstarttime,"
+ " backupEndTime =@backupendtime"
+ " backupTime = @backuptime"
+ " backupFlg = @backupflg"
+ " copyStartTime = @copystarttime"
+ " copyEndTime = @copyendtime"
+ " copyTime = @coptime"
+ " copyFlg = @copyflg"
+ " updater =@updater,"
+ " updateDate =@updateDate"
+ " WHERE id = @id";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@servergroupid", BackupServerFile.backupServerGroupID),
new SqlParameter("@serverid", BackupServerFile.backupServerID),
new SqlParameter("@serverfilename", BackupServerFile.backupServerFileName),
new SqlParameter("@serverfilepath", BackupServerFile.backupServerFilePath),
new SqlParameter("@serverfiletype", BackupServerFile.backupServerFileType),
new SqlParameter("@serverfilesize", BackupServerFile.backupServerFileSize),
new SqlParameter("@backupstarttime", BackupServerFile.backupStartTime),
new SqlParameter("@backupendtime", BackupServerFile.backupEndTime),
new SqlParameter("@backuptime", BackupServerFile.backupTime),
new SqlParameter("@backupflg", BackupServerFile.backupFlg),
new SqlParameter("@copystarttime", BackupServerFile.copyStartTime),
new SqlParameter("@copyendtime", BackupServerFile.copyEndTime),
new SqlParameter("@coptime", BackupServerFile.copyTime),
new SqlParameter("@copyflg", BackupServerFile.copyFlg),
new SqlParameter("@updater", BackupServerFile.updater),
new SqlParameter("@updateDate", BackupServerFile.updateDate),
new SqlParameter("@id", BackupServerFile.id)
};
try
{
result = db.Udaquery(sql, conn, para);
}
catch (Exception e)
{
throw e;
}
return(result);
}
/// <summary>
/// insert log and backupserverfile
/// </summary>
/// <param name="file"></param>
/// <param name="backup"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="timespan"></param>
/// <param name="transferFlg"></param>
private void InsertTransferInfo(MonitorServerFile file, BackupServer backup, DateTime startTime, DateTime endTime, TimeSpan timespan, int transferFlg)
{
//insert log
try
{
Log Log = new Log();
Log.monitorServerID = file.monitorServerID;
Log.monitorFileName = file.monitorFileName;
Log.monitorFilePath = file.monitorFilePath;
Log.monitorFileType = file.monitorFileType;
Log.monitorFileSize = file.monitorFileSize;
Log.monitorTime = file.monitorStartTime;
Log.transferFlg = transferFlg;
Log.backupServerGroupID = Int32.Parse(_backupgroupid);
Log.backupServerID = Int32.Parse(backup.id);
Log.backupServerFileName = file.monitorFileName;
Log.backupServerFilePath = backup.startFile;
Log.backupServerFileType = file.monitorFileType;
Log.backupServerFileSize = file.monitorFileSize;
Log.backupStartTime = startTime.ToString();
Log.backupEndTime = endTime.ToString();
Log.backupTime = timespan.TotalMilliseconds.ToString() + "ms";
Log.backupFlg = transferFlg;
Log.copyStartTime = startTime.ToString();
Log.copyEndTime = endTime.ToString();
Log.copyTime = timespan.TotalMilliseconds.ToString() + "ms";
Log.copyFlg = transferFlg;
Log.deleteFlg = DEFAULTINT_VALUE;
Log.deleter = DEFAULTCHAR_VALUE;
Log.deleteDate = DEFAULTDATETIME_VALUE;
Log.creater = "exe";
Log.createDate = CommonUtil.DateTimeNowToString();
Log.updater = "exe";
Log.updateDate = CommonUtil.DateTimeNowToString();
Log.restorer = DEFAULTCHAR_VALUE;
Log.restoreDate = DEFAULTDATETIME_VALUE;
LogService.InsertLog(Log);
//insert backupserverfile
BackupServerFile BackupServerFile = new BackupServerFile();
BackupServerFile.backupServerGroupID = Int32.Parse(_backupgroupid);
BackupServerFile.backupServerID = Int32.Parse(backup.id);
BackupServerFile.backupServerFileName = file.monitorFileName;
BackupServerFile.backupServerFilePath = backup.startFile;
BackupServerFile.backupServerFileType = file.monitorFileType;
BackupServerFile.backupServerFileSize = file.monitorFileSize;
BackupServerFile.backupStartTime = startTime.ToString();
BackupServerFile.backupEndTime = endTime.ToString();
BackupServerFile.backupTime = timespan.TotalMilliseconds.ToString() + "ms";
BackupServerFile.backupFlg = transferFlg;
BackupServerFile.copyStartTime = startTime.ToString();
BackupServerFile.copyEndTime = endTime.ToString();
BackupServerFile.copyTime = timespan.TotalMilliseconds.ToString() + "ms";
BackupServerFile.copyFlg = transferFlg;
BackupServerFile.deleteFlg = DEFAULTINT_VALUE;
BackupServerFile.deleter = DEFAULTCHAR_VALUE;
BackupServerFile.deleteDate = DEFAULTDATETIME_VALUE;
BackupServerFile.creater = "exe";
BackupServerFile.createDate = CommonUtil.DateTimeNowToString();
BackupServerFile.updater = "exe";
BackupServerFile.updateDate = CommonUtil.DateTimeNowToString();
BackupServerFile.restorer = DEFAULTCHAR_VALUE;
BackupServerFile.restoreDate = DEFAULTDATETIME_VALUE;
BackupServerFileService.InsertBackupServerFile(BackupServerFile);
}
catch (Exception e)
{
logger.Error(e.Message);
}
}
