public string SourceSql(int ID)
{
return("select top " + Properties.Settings.Default.TopNumber + @"
[id]
,[monitorServerName]
,[monitorServerIP]
,[monitorSystem]
,[memo]
,[account]
,[password]
,[startFile]
,[monitorDrive]
,[monitorDriveP]
,[monitorMacPath]
,[monitorLocalPath]
,[copyInit]
,[deleteFlg]
,[deleter]
,[deleteDate]
,[creater]
,[createDate]
,[updater]
,[updateDate]
,[restorer]
,[restoreDate]
,[synchronismFlg]
from [monitorServer] " + TableHelper.GetWhereCondCommon(ID));
}
public string SourceSql(int ID)
{
return("select top " + Properties.Settings.Default.TopNumber + @"
[id]
,[monitorServerID]
,[monitorFileName]
,[monitorType]
,[monitorServerIP]
,[sharePoint]
,[monitorLocalPath]
,[monitorFileRelativeDirectory]
,[monitorFileRelativeFullPath]
,[monitorFileLastWriteTime]
,[monitorFileSize]
,[monitorFileExtension]
,[monitorFileCreateTime]
,[monitorFileLastAccessTime]
,[monitorStatus]
,[monitorFileStartTime]
,[monitorFileEndTime]
,[deleteFlg]
,[deleter]
,[deleteDate]
,[creater]
,[createDate]
,[updater]
,[updateDate]
,[synchronismFlg]
from [monitorFileListen] " + TableHelper.GetWhereCondCommon(ID));
}
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));
}
