public string SourceSql(int ID) { return("select top " + Properties.Settings.Default.TopNumber + @" [id] ,[backupServerGroupName] ,[monitorServerID] ,[memo] ,[deleteFlg] ,[deleter] ,[deleteDate] ,[creater] ,[createDate] ,[updater] ,[updateDate] ,[restorer] ,[restoreDate] ,[synchronismFlg] from [backupServerGroup] " + TableHelper.GetWhereCondCommon(ID)); }
public string SourceSql(int ID) { return("select top " + Properties.Settings.Default.TopNumber + @" [id] ,[monitorServerID] ,[monitorFileName] ,[monitorFileStatus] ,[monitorFilePath] ,[monitorFileType] ,[monitorFileSize] ,[monitorTime] ,[transferFlg] ,[backupServerGroupID] ,[backupServerID] ,[backupServerFileName] ,[backupServerFilePath] ,[backupServerFileType] ,[backupServerFileSize] ,[backupStartTime] ,[backupEndTime] ,[backupTime] ,[backupFlg] ,[copyStartTime] ,[copyEndTime] ,[copyTime] ,[copyFlg] ,[deleteFlg] ,[deleter] ,[deleteDate] ,[creater] ,[createDate] ,[updater] ,[updateDate] ,[restorer] ,[restoreDate] ,[synchronismFlg] from [log] " + TableHelper.GetWhereCond(ID)); }