示例#1
0
        public bool ReadFromDB(int taskID)
        {
            DataTable       table;
            DatabaseCommand cmd = new DatabaseCommand(db);

            cmd.AppendFormat("Select * from TaskBackupSync where taskid = {0}", taskID);
            table = cmd.ExecuteSelectToTable(DatabaseCommandOptions.ThrowException | DatabaseCommandOptions.LogError);
            if (table == null || table.Rows.Count == 0)
            {
                return(false);
            }

            TaskID                   = Convert.ToInt32(table.Rows[0]["taskID"]);
            StartJobID               = DatabaseFieldConvert.ToInt32(table.Rows[0]["StartJobID"]);
            Type                     = (JobType)DatabaseFieldConvert.ToInt32(table.Rows[0]["JobType"]);
            StatTaskStart            = DatabaseFieldConvert.ToDateTime(table.Rows[0]["StartTS"]);
            StatTaskEnd              = DatabaseFieldConvert.ToDateTime(table.Rows[0]["EndTS"]);
            AgentMachineName         = table.Rows[0]["AgentMachineName"] as string;
            SourcePath               = table.Rows[0]["SourcePath"] as string;
            DestinationPath          = table.Rows[0]["DestinationPath"] as string;
            StatFileCount            = Convert.ToInt64(table.Rows[0]["FileCount"]);
            StatFileCreateCount      = Convert.ToInt64(table.Rows[0]["FileCreateCount"]);
            StatFileCopyCount        = Convert.ToInt64(table.Rows[0]["FileCopyCount"]);
            StatFileCopyOKCount      = Convert.ToInt64(table.Rows[0]["FileCopyOKCount"]);
            StatFileCopyErrorCount   = Convert.ToInt64(table.Rows[0]["FileCopyErrorCount"]);
            StatFileDeleteCount      = Convert.ToInt64(table.Rows[0]["FileDeleteCount"]);
            StatFileDeleteOKCount    = Convert.ToInt64(table.Rows[0]["FileDeleteOKCount"]);
            StatFileDeleteErrorCount = Convert.ToInt64(table.Rows[0]["FileDeleteErrorCount"]);
            StatDirCount             = Convert.ToInt64(table.Rows[0]["DirCount"]);
            StatDirCreateCount       = Convert.ToInt64(table.Rows[0]["DirCreateCount"]);
            StatDirCreateOKCount     = Convert.ToInt64(table.Rows[0]["DirCreateOKCount"]);
            StatDirCreateErrorCount  = Convert.ToInt64(table.Rows[0]["DirCreateErrorCount"]);
            StatDirDeleteCount       = Convert.ToInt64(table.Rows[0]["DirDeleteCount"]);
            StatDirDeleteOKCount     = Convert.ToInt64(table.Rows[0]["DirDeleteOKCount"]);
            StatDirDeleteErrorCount  = Convert.ToInt64(table.Rows[0]["DirDeleteErrorCount"]);
            StatByteCopyCount        = Convert.ToInt64(table.Rows[0]["ByteCopyCount"]);
            StatByteCopyOKCount      = Convert.ToInt64(table.Rows[0]["ByteCopyOKCount"]);
            StatErrorCount           = Convert.ToInt64(table.Rows[0]["ErrorCount"]);

            return(true);
        }
示例#2
0
		public bool ReadFromDB(int taskID)
		{
			DataTable table;
			DatabaseCommand cmd = new DatabaseCommand(db);

			cmd.AppendFormat("Select * from TaskBackupSync where taskid = {0}", taskID);
			table = cmd.ExecuteSelectToTable(DatabaseCommandOptions.ThrowException | DatabaseCommandOptions.LogError);
			if (table == null || table.Rows.Count == 0)
				return false;

			TaskID = Convert.ToInt32(table.Rows[0]["taskID"]);
			StartJobID = DatabaseFieldConvert.ToInt32(table.Rows[0]["StartJobID"]);
			Type = (JobType)DatabaseFieldConvert.ToInt32(table.Rows[0]["JobType"]);
			StatTaskStart = DatabaseFieldConvert.ToDateTime(table.Rows[0]["StartTS"]);
			StatTaskEnd = DatabaseFieldConvert.ToDateTime(table.Rows[0]["EndTS"]);
			AgentMachineName = table.Rows[0]["AgentMachineName"] as string;
			SourcePath = table.Rows[0]["SourcePath"] as string;
			DestinationPath = table.Rows[0]["DestinationPath"] as string;
			StatFileCount = Convert.ToInt64(table.Rows[0]["FileCount"]);
			StatFileCreateCount = Convert.ToInt64(table.Rows[0]["FileCreateCount"]);
			StatFileCopyCount = Convert.ToInt64(table.Rows[0]["FileCopyCount"]);
			StatFileCopyOKCount = Convert.ToInt64(table.Rows[0]["FileCopyOKCount"]);
			StatFileCopyErrorCount = Convert.ToInt64(table.Rows[0]["FileCopyErrorCount"]);
			StatFileDeleteCount = Convert.ToInt64(table.Rows[0]["FileDeleteCount"]);
			StatFileDeleteOKCount = Convert.ToInt64(table.Rows[0]["FileDeleteOKCount"]);
			StatFileDeleteErrorCount = Convert.ToInt64(table.Rows[0]["FileDeleteErrorCount"]);
			StatDirCount = Convert.ToInt64(table.Rows[0]["DirCount"]);
			StatDirCreateCount = Convert.ToInt64(table.Rows[0]["DirCreateCount"]);
			StatDirCreateOKCount = Convert.ToInt64(table.Rows[0]["DirCreateOKCount"]);
			StatDirCreateErrorCount = Convert.ToInt64(table.Rows[0]["DirCreateErrorCount"]);
			StatDirDeleteCount = Convert.ToInt64(table.Rows[0]["DirDeleteCount"]);
			StatDirDeleteOKCount = Convert.ToInt64(table.Rows[0]["DirDeleteOKCount"]);
			StatDirDeleteErrorCount = Convert.ToInt64(table.Rows[0]["DirDeleteErrorCount"]);
			StatByteCopyCount = Convert.ToInt64(table.Rows[0]["ByteCopyCount"]);
			StatByteCopyOKCount = Convert.ToInt64(table.Rows[0]["ByteCopyOKCount"]);
			StatErrorCount = Convert.ToInt64(table.Rows[0]["ErrorCount"]);

			return true;
		}