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