/// <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); } }