public static PackageBody CreatePackage1()
{
PackageBody body = new PackageBody();
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new SaveDateTime()
{
Value = DateTime.Now,
ResultName = "dtnow"
},
new FormatDateTime()
{
DateTimeValue = DateTime.Now,
FormatString = "ddMMyyyy",
ResultName = "formatteddate",
UseCurrent = true
},
new CMExecuteSQLQuery()
{
CommandText = "select * from t1",
CommandTimeout = 201,
CommandType = CommandType.Text,
ConnectionString = CONNECTION_STRING1,
ParameterNames = new List<SqlParameterName>()
{
new SqlParameterName()
{
ParameterName = "par1"
},
new SqlParameterName()
{
ParameterName = "par2"
}
},
ResultName = "sql_result"
},
new CreateTextFile()
{
SourceFilePath = @"C:\_test\conn.txt",
DestFilePath = @"C:\_test\conn2.txt",
Substitutes = new List<StringSubstitute>()
{
new StringSubstitute()
{
Key = "{SERVER}",
Value = "sdb14"
},
new StringSubstitute()
{
Key = "{BASE}",
Value = "GRBS_437_RAP"
}
}
}
}
};
return body;
}
public PackageBuilder(PackageBody body, PackageContentType contentType)
{
body.ContentType = contentType;
_content = PackageContent.PackageContent.Create(contentType);
Errors = new List<PackageErrorInfo>();
_body = body;
}
public PackageBuilder(PackageBody body, PackageContentType contentType)
{
body.ContentType = contentType;
_content = PackageContent.PackageContent.Create(contentType);
Errors = new List <PackageErrorInfo>();
_body = body;
}
private void InternalLoadPackageBody()
{
string xmlFilePath = _content.GetBody();
_context.Log.AddLogInformation("XML-конфигурация ожидается в '" + xmlFilePath + "'");
_body = GinSerializer.Deserialize <PackageBody>(xmlFilePath);
_context.Log.AddLogInformation("XML-конфигурация загружена");
}
public static PackageBody CreatePackage11()
{
PackageBody body = new PackageBody();
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new CMInstallSQLInstance()
{
ResultName = "sqlInstallResult",
SAPassword = "******",
InstanceName = "OSBB",
SetupFilePath = @"D:\work\minfin\Setup\SetupOSBB\INSTALL\SQLEXPR_RUS.EXE"
}
}
};
return body;
}
public static PackageBody CreatePackage5()
{
PackageBody body = new PackageBody();
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new CreateDirectoryContent()
{
DestPath = @"C:\_test\proj\",
SourcePath = @"D:\work\_projects\Gin.Installer\gin-installer\AuxPackages\TestPackage\"
}
}
};
return body;
}
/// <summary>
/// Пакет инсталлятора
/// </summary>
public static PackageBody CreatePackageInstaller()
{
PackageBody body = new PackageBody();
body.Height = 250;
body.Width = 500;
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new UserInputForm()
{
FormCaption = "Папка установки ППО Сводная отчетность",
BeforeCreate = new CommandSequence()
{
Commands = new List<Command>()
{
new ReadEnvironment()
{
VariableName = "PROGRAMFILES",
ResultName = "program_files"
},
new SaveString()
{
Value = @"%program_files%\Avicomp\OSBB\",
ResultName = "osbb_folder_init"
}
}
},
InputControls = new List<UserInputControl>()
{
new UserInputBrowseDirectoryDialog()
{
Caption = "Выберите папку установки ППО Сводная отчетность",
ResultName = "osbb_install_folder",
InitialValue = @"%osbb_folder_init%"
},
new UserInputCheckBox()
{
Caption = "Создать ярлык на рабочем столе",
InitialValue = true,
ResultName = "create_desktop_shortcut"
},
new UserInputCheckBox()
{
Caption = "Создать ярлык в меню Пуск",
InitialValue = false,
ResultName = "create_start_shortcut"
},
new UserInputCheckBox()
{
Caption = "Сделать ярлыки доступными всем пользователям",
InitialValue = true,
ResultName = "create_allusers_shortcut"
}
}
},
new UserInputForm()
{
FormCaption = "Выбор экземпляра SQL сервера",
BeforeCreate = new CommandSequence()
{
Commands = new List<Command>()
{
new ReadEnvironment()
{
VariableName = "SYSTEMDRIVE",
ResultName = "system_drive"
},
new SaveString()
{
Value = @"%system_drive%\OSBB_SQL\",
ResultName = "data_sql_folder"
}
}
},
InputControls = new List<UserInputControl>()
{
new ICChooseSQLInstance()
{
ResultName = "choose_sql_instance",
InitialValue = new ICSQLInstance()
{
InstallNewInstance = true,
InstanceName = @".\OSBB",
SqlDataDirectory = @"%data_sql_folder%"
}
}
},
AfterComplete = new CommandSequence()
{
Commands = new List<Command>()
{
new CMParseResult()
{
ArgumentName = "%choose_sql_instance%"
}
}
}
},
new UserInputForm()
{
InputControls = new List<UserInputControl>()
{
new ICSQLConnection()
{
ResultName = "sql_connection",
FixedInstanceName = true,
FixedUserName = "******",
FixedSqlAuth = "%choose_sql_instance.InstallNewInstance%",
FixedDBName = false,
InitialValue = new SQLConnectionProperties()
{
InstanceName = "%choose_sql_instance.InstanceName%",
DBName = "OSBB",
SqlAuthentication = true,
UserName = "******",
Password = ""
}
}
},
FormCaption = "Параметры подключения",
AfterComplete = new CommandSequence()
{
Commands = new List<Command>()
{
new CMParseResult()
{
ArgumentName = "%sql_connection%"
}
}
}
}/*,
new CommandSequence()
{
Commands = new List<Command>()
{
new ExecuteIf()
{
ArgumentName = "%choose_sql_instance.InstallNewInstance%",
Then = new CMInstallSQLInstance()
{
SetupFilePath = @"D:\install\msoe2007kg.exe",
InstanceName = "%choose_sql_instance.InstanceName%"
}
},
new CMRestoreSQLBackup()
{
BackupFilePath = @"C:\_test\_GinDB.bak",
ConnectionString = "%sql_connection.ConnectionString%",
DatabaseName = "%sql_connection.DBName%"
},
new CreateDirectoryContent()
{
SourcePath = @"C:\_test\osbb\",
DestPath = @"%osbb_install_folder%"
},
new CreateTextFile()
{
SourceFilePath = @"%osbb_install_folder%\options.ini",
DestFilePath = @"%osbb_install_folder%\options.ini",
Substitutes = new List<StringSubstitute>()
{
new StringSubstitute()
{
Key = "SERVER_NAME",
Value = "%sql_connection.InstanceName%"
},
new StringSubstitute()
{
Key = "DB_NAME",
Value = "%sql_connection.DBName%"
},
}
},
new ExecuteIf()
{
ArgumentName = "%create_desktop_shortcut%",
Then = new CreateShortcut()
{
AllUsers = "%create_allusers_shortcut%",
Place = ShortcutPlace.Desktop,
ShortcutName = "Сводная отчетность",
FilePath = @"%osbb_install_folder%\SvodOsbb.exe"
}
},
new ExecuteIf()
{
ArgumentName = "%create_start_shortcut%",
Then = new CreateShortcut()
{
AllUsers = "%create_allusers_shortcut%",
Place = ShortcutPlace.StartMenu,
ShortcutName = "Сводная отчетность",
FilePath = @"%osbb_install_folder%\SvodOsbb.exe"
}
}
}
}*/
}
};
return body;
}
/// <summary>
/// Пакет апдейтера
/// </summary>
public static PackageBody CreatePackageUpdater436()
{
PackageBody body = new PackageBody();
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new UserInputForm()
{
InputControls= new List<UserInputControl>()
{
new ICSQLConnection()
{
InitialValue= new SQLConnectionProperties()
{
DBName = "GRBS_186",
InstanceName = ".",
UserName = "******",
SqlAuthentication = true,
Password = "******"
},
ResultName = "sql_connection"
}
},
FormCaption = "Подключение к БД",
AfterComplete = new CMParseResult()
{
ArgumentName = "%sql_connection%"
}
},
new UserInputForm()
{
BeforeCreate = new CommandSequence()
{
Commands = new List<Command>()
{
new ReadEnvironment()
{
VariableName = "SYSTEMDRIVE",
ResultName = "system_drive"
},
new FormatDateTime()
{
FormatString = "yyyyMMdd",
UseCurrent = true,
ResultName = "date_time_string"
},
new SaveString()
{
Value = "%sql_connection.DBName%_%date_time_string%_1.bak",
ResultName = "backup_filename_before"
},
new SaveString()
{
Value = "%sql_connection.DBName%_%date_time_string%_2.bak",
ResultName = "backup_filename_after"
}
}
},
InputControls = new List<UserInputControl>()
{
new UserInputBrowseDirectoryDialog()
{
Caption = "Папка для сохранения бэкапов",
InitialValue = "%system_drive%",
ResultName = "backups_folder"
},
new UserInputCheckBox()
{
Caption = "Будем бэкапить до выполнения?",
InitialValue = true,
ResultName = "need_backup_before"
},
new UserInputTextBox()
{
Caption = "Имя бэкапа до выполнения",
InitialValue = "%backup_filename_before%",
ResultName = "backup_filename_before"
},
new UserInputCheckBox()
{
Caption = "Будем бэкапить после выполнения?",
InitialValue = true,
ResultName = "need_backup_after"
},
new UserInputTextBox()
{
Caption = "Имя бэкапа после выполнения",
InitialValue = "%backup_filename_after%",
ResultName = "backup_filename_after"
}
},
AfterComplete = new CommandSequence()
{
Commands = new List<Command>()
{
new SaveString()
{
Value = @"%backups_folder%\%backup_filename_before%",
ResultName = "backup_full_filename_before",
IsPathCombine = true
},
new SaveString()
{
Value = @"%backups_folder%\%backup_filename_after%",
ResultName = "backup_full_filename_after",
IsPathCombine = true
}
}
}
},
new CommandSequence()
{
Commands = new List<Command>()
{
new CreateDirectoryContent()
{
SourcePath = @"D:\20120312_UPDATE_436_new\included_\58a2a46323c8431d867460a47a196061.cnt\",
DestPath = @"%PACKAGE_CONTENT%\SCRIPTS",
MoveFast = true
},
new CreateDirectoryContent()
{
SourcePath = @"D:\20120312_UPDATE_436_new\included_\c5dc8301e71a4d6eba5cca089cd97376.cnt\",
DestPath = @"%PACKAGE_CONTENT%\FILES",
MoveFast = true
},
new CreateDirectoryContent()
{
SourcePath = @"D:\20120312_UPDATE_436_new\included_\f018a57096354cb889d261bd3274dab2.cnt\",
DestPath = @"%PACKAGE_CONTENT%\DTS",
MoveFast = true
},
new ExecuteIf()
{
ArgumentName = "%need_backup_before%",
Then = new CMCreateSQLBackup()
{
ConnectionString = "%sql_connection.ConnectionString%",
CommandTimeout = 3600,
DatabaseName = "%sql_connection.DBName%",
BackupFilePath = "%backup_full_filename_before%"
}
},
new CMSynchronize()
{
ConnectionString = "%sql_connection.ConnectionString%",
ConnectionStringEtalon = "",
DTSDirectoryPath = @"%PACKAGE_CONTENT%\DTS",
SyncType = OSBBSynchronizationType.TextFile,
CheckFormulaDiapasons = true,
LoadHierarchy = false,
UpdateSetStrings = false,
PackagePath = @"%PACKAGE_CONTENT%\FILES\29",
LoadPick = false,
UpdateDisplayCode = false
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\1_UPD_StringIndex.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\2_Update_OuterConrol.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\3_UpdateModelFilters.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\4_BuildFormulas.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new ExecuteIf()
{
ArgumentName = "%need_backup_after%",
Then = new CMCreateSQLBackup()
{
ConnectionString = "%sql_connection.ConnectionString%",
CommandTimeout = 3600,
DatabaseName = "%sql_connection.DBName%",
BackupFilePath = "%backup_full_filename_after%"
}
},
#region commented
/*
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ДОХОДЫ_год.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 2873,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ДОХОДЫ_год"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ДОХОДЫ.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 3663,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ДОХОДЫ"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ИФД.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 528,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ИФД"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ИФД_год.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 540,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ИФД_год"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_РАСХОДЫ.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 4182,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_РАСХОДЫ"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_РАСХОДЫ_год.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 4182,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_РАСХОДЫ_год"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ДОХОДЫ_210_2011.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 58,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ДОХОДЫ_210_2011"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ДОХОДЫ_284_2011.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 69,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ДОХОДЫ_284_2011"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ИФД_284_2011.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 70,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ИФД_284_2011"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ДОХОДЫ_284_2012.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 67,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ДОХОДЫ_284_2012"
},
new CMImportSets()
{
ExcelFilePath = @"%PACKAGE_CONTENT%\EXCEL\БР_ИФД_284_2012.xls",
WorksheetName = "1",
StartRowNumber = 5,
EndRowNumber = 59,
ConnectionString = @"%sql_connection.ConnectionString%",
DTSFilePath = @"%PACKAGE_CONTENT%\DTS\rp_ImportExcel.dts",
IgnoreDuplicates = false,
DeletePreviousSets = true,
NSIVersion = 2,
Secret = SecretType.NoSecret,
SetName = "БР_ИФД_284_2012"
},*/
#endregion
}
}
}
};
return body;
}
public static PackageBody CreatePackage8()
{
PackageBody body = new PackageBody();
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
/* new IsMSIInstalled()
{
SearchType = MSISearchType.ProductName,
Product = "Microsoft SQL Server 2005",
ResultName = "sqlexpr2005IsInstalled"
},
new ExecuteIf()
{
ArgumentName = "%sqlexpr2005IsInstalled%",
Else = new CommandSequence()
{
Commands = new List<Command>()
{
new CreateFile()
{
SourcePath = @"D:\install\DTS\SQLEXPR.EXE",
DestPath = @"%PACKAGE_CONTENT%\SQLEXPR.EXE"
},
new ExecuteProgram()
{
ProgramExePath = @"%PACKAGE_CONTENT%\SQLEXPR.EXE",
WindowType = Gin.Util.ProgramWindowType.WinForms,
IntResultName = "sqlexprInstallExitCode"
}
}
}
},
*/
new IsMSIInstalled()
{
SearchType = MSISearchType.ProductName,
Product = "SQL Server 2000 DTS Designer Components",
ResultName = "dts2005IsInstalled"
},
new ExecuteIf()
{
ArgumentName = "%dts2005IsInstalled%",
Then = new ShowMessage()
{
MessageText = "DTS Designer Components был установлен ранее"
},
Else = new CommandSequence()
{
Commands = new List<Command>()
{
new CreateFile()
{
SourcePath = @"D:\install\DTS\SQLServer2005_DTS.msi",
DestPath = @"%PACKAGE_CONTENT%\SQLServer2005_DTS.msi"
},
new ExecuteProgram()
{
ProgramExePath = @"%PACKAGE_CONTENT%\SQLServer2005_DTS.msi",
WindowType = Gin.Util.ProgramWindowType.WinForms,
IntResultName = "dtsInstallExitCode"
}
}
}
},
/*
new IsMSIInstalled()
{
SearchType = MSISearchType.ProductName,
Product = "Microsoft SQL Server 2005 Backward compatibility",
ResultName = "bc2005IsInstalled"
},
new ExecuteIf()
{
ArgumentName = "%bc2005IsInstalled%",
Else = new CommandSequence()
{
Commands = new List<Command>()
{
new CreateFile()
{
SourcePath = @"D:\install\DTS\SQLServer2005_BC.msi",
DestPath = @"%PACKAGE_CONTENT%\SQLServer2005_BC.msi"
},
new ExecuteProgram()
{
ProgramExePath = @"%PACKAGE_CONTENT%\SQLServer2005_BC.msi",
WindowType = Gin.Util.ProgramWindowType.WinForms,
IntResultName = "bcInstallExitCode"
}
}
}
}*/
}
};
return body;
}
/// <summary>
/// Пакет апдейтера
/// </summary>
public static PackageBody CreatePackageUpdaterRAP()
{
PackageBody body = new PackageBody();
body.PackageName = "Обновление 20120301_UPDATE_RAP";
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new UserInputForm()
{
InputControls= new List<UserInputControl>()
{
new ICSQLConnection()
{
InitialValue= new SQLConnectionProperties()
{
DBName = "RAP",
InstanceName = "ssun111",
UserName = "******",
SqlAuthentication = true,
Password = ""
},
ResultName = "sql_connection"
}
},
FormCaption = "Подключение к БД",
AfterComplete = new CMParseResult()
{
ArgumentName = "%sql_connection%"
}
},
new UserInputForm()
{
BeforeCreate = new CommandSequence()
{
Commands = new List<Command>()
{
new ReadEnvironment()
{
VariableName = "SYSTEMDRIVE",
ResultName = "system_drive"
},
new FormatDateTime()
{
FormatString = "yyyyMMdd",
UseCurrent = true,
ResultName = "date_time_string"
},
new SaveString()
{
Value = "%sql_connection.DBName%_%date_time_string%.bak",
ResultName = "backup_filename"
},
new SaveString()
{
Value = @"%system_drive%\%backup_filename%",
ResultName = "backup_full_filename"
}
}
},
InputControls = new List<UserInputControl>()
{
new UserInputSaveFileDialog()
{
Caption = "Папка для сохранения бэкапа",
InitialValue = "%backup_full_filename%",
ResultName = "backup_full_filename"
},
new UserInputCheckBox()
{
Caption = "Будем бэкапить?",
InitialValue = true,
ResultName = "need_backup"
}
}
},
new CommandSequence()
{
Commands = new List<Command>()
{
new CreateDirectoryContent()
{
SourcePath = @"D:\20120301_UPDATE_RAP\SCRIPTS\",
DestPath = @"%PACKAGE_CONTENT%\SCRIPTS",
MoveFast = true
},
new CreateDirectoryContent()
{
SourcePath = @"D:\20120301_UPDATE_RAP\FILES\",
DestPath = @"%PACKAGE_CONTENT%\FILES",
MoveFast = true
},
new CreateDirectoryContent()
{
SourcePath = @"D:\work\_projects\Gin.Installer\gin-installer\AuxPackages\DTS\",
DestPath = @"%PACKAGE_CONTENT%\DTS",
MoveFast = true
},
new ExecuteIf()
{
ArgumentName = "%need_backup%",
Then = new CMCreateSQLBackup()
{
ConnectionString = "%sql_connection.ConnectionString%",
CommandTimeout = 3600,
DatabaseName = "%sql_connection.DBName%",
BackupFilePath = "%backup_full_filename%"
}
},
new CMSynchronize()
{
ConnectionString = "%sql_connection.ConnectionString%",
ConnectionStringEtalon = "",
DTSDirectoryPath = @"%PACKAGE_CONTENT%\DTS",
SyncType = OSBBSynchronizationType.TextFile,
CheckFormulaDiapasons = true,
LoadHierarchy = false,
UpdateSetStrings = false,
PackagePath = @"%PACKAGE_CONTENT%\FILES\29",
LoadPick = false,
UpdateDisplayCode = false
},
new CMSynchronize()
{
ConnectionString = "%sql_connection.ConnectionString%",
ConnectionStringEtalon = "",
DTSDirectoryPath = @"%PACKAGE_CONTENT%\DTS",
SyncType = OSBBSynchronizationType.TextFile,
CheckFormulaDiapasons = true,
LoadHierarchy = false,
UpdateSetStrings = false,
PackagePath = @"%PACKAGE_CONTENT%\FILES\30",
LoadPick = false,
UpdateDisplayCode = false
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\1_UPD_StringIndex.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\2_Update_OuterConrol.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\3_Replace_ObjectCode.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\4_Update_FilterValue_RAP.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\5_UpdateModelFilters.sql",
CommandType = System.Data.CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\6_BuildFormulas.sql",
CommandType = CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
}/*,
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\7_UpdateModelFilters.sql",
CommandType = CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
},
new CMExecuteSQLNonQuery()
{
ScriptFilePath = @"%PACKAGE_CONTENT%\SCRIPTS\8_BuildFormulas.sql",
CommandType = CommandType.Text,
ConnectionString = "%sql_connection.ConnectionString%"
}*/
}
}
}
};
return body;
}
public static PackageBody CreatePackage6()
{
PackageBody body = new PackageBody();
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new CreateDirectoryContent()
{
DestPath = @"%my_dir%",
SourcePath = @"D:\install\TotalCmd 6.0\"
},
new CreateFile()
{
SourcePath = @"D:\install\berkleydb\db-5.2.36.msi",
DestPath = @"%my_dir%\db-5.2.36.msi"
},
new ExecuteProgram()
{
IntResultName = "bdb_res",
ProgramExePath = @"%my_dir%\db-5.2.36.msi",
WindowType = Gin.Util.ProgramWindowType.WinForms
},
new ExecuteProgram()
{
IntResultName = "tc_res",
ProgramExePath = @"%my_dir%\Total Commander 6.0 Russian.exe",
WindowType = Gin.Util.ProgramWindowType.WinForms
}
}
};
return body;
}
public static PackageBody CreatePackage7()
{
PackageBody body = new PackageBody();
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new IsCOMInstalled()
{
ClassId = "{78BEC353-56DD-4152-AB5D-A4BE89DB4160}",
ResultName = "isInstalled"
}
}
};
return body;
}
private void InternalLoadPackageBody()
{
string xmlFilePath = _content.GetBody();
_context.Log.AddLogInformation("XML-конфигурация ожидается в '" + xmlFilePath + "'");
_body = GinSerializer.Deserialize<PackageBody>(xmlFilePath);
_context.Log.AddLogInformation("XML-конфигурация загружена");
}
public static PackageBody CreatePackage4()
{
PackageBody body = new PackageBody();
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new UserInputForm()
{
FormCaption = "Тестируем контролы",
InputControls = new List<UserInputControl>()
{
new ICSQLConnection()
{
ResultName = "sql_server_cs"
}
},
AfterComplete = new CMExecuteSQLQuery()
{
CommandText = "select * from [values]",
CommandType = CommandType.Text,
ConnectionString = "%sql_server_cs%",
ResultName = "sql_list"
}
},
new UserInputForm()
{
FormCaption = "Тестируем контролы",
InputControls = new List<UserInputControl>()
{
new UserInputComboBox()
{
Caption = "Вот оно",
ResultName = "listbox_1",
ListDataName = "%sql_list%",
DropDownOnly = true,
DisplayMember = "val",
ValueMember = "id"
}
}
}
}
};
return body;
}
public static PackageBody CreatePackage3()
{
PackageBody body = new PackageBody();
body.PackageName = "Офигенский тестовый пакет";
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new UserInputForm()
{
BeforeCreate = new CMExecuteSQLQuery()
{
CommandText = "select * from [values]",
CommandType = CommandType.Text,
ConnectionString = CONNECTION_STRING1,
ResultName = "sql_list"
},
FormCaption = "Тестируем контролы",
InputControls = new List<UserInputControl>()
{
new UserInputComboBox()
{
Caption = "Вы уверены?",
ResultName = "listbox_1",
ListDataName = "%sql_list%",
DropDownOnly = true,
DisplayMember = "val",
ValueMember = "id"
}
},
AfterComplete = new ExtractDataRowField()
{
DataRowName = "%listbox_1%",
FieldName = "id",
ResultName ="listbox_1_value"
}
},
new UserInputForm()
{
FormCaption = "Еще форма",
InputControls = new List<UserInputControl>()
{
new UserInputTextBox()
{
Caption = "вот что вы выбрали",
InitialValue = "%listbox_1_value%",
ResultName = "textbox_2"
}
}
}
}
};
return body;
}
/// <summary>
/// Пакет апдейтера
/// </summary>
public static PackageBody CreatePackageUpdaterTestXLT()
{
PackageBody body = new PackageBody();
body.PackageName = "Обновление 20120216_UPDATE_RAP";
body.Command = new CommandSequence()
{
Commands = new List<Command>()
{
new UserInputForm()
{
InputControls= new List<UserInputControl>()
{
new ICSQLConnection()
{
InitialValue= new SQLConnectionProperties()
{
DBName = "GRBS_437",
InstanceName = ".",
UserName = "******",
SqlAuthentication = true,
Password = "******"
},
ResultName = "sql_connection"
}
},
FormCaption = "Подключение к БД",
AfterComplete = new CMParseResult()
{
ArgumentName = "%sql_connection%"
}
},
new CommandSequence()
{
Commands = new List<Command>()
{
new CreateDirectoryContent()
{
SourcePath = @"D:\20120216_UPDATE_RAP\FILES\",
DestPath = @"%PACKAGE_CONTENT%\FILES",
MoveFast = true
},
new CMSynchronize()
{
ConnectionString = "%sql_connection.ConnectionString%",
ConnectionStringEtalon = "",
DTSDirectoryPath = @"%PACKAGE_CONTENT%\DTS",
SyncType = OSBBSynchronizationType.TextFile,
CheckFormulaDiapasons = false,
LoadHierarchy = false,
UpdateSetStrings = false,
PackagePath = @"%PACKAGE_CONTENT%\FILES\29",
LoadPick = false,
UpdateDisplayCode = false
}
}
}
}
};
return body;
}
public static PackageBody CreatePackage2()
{
PackageBody body = new PackageBody();
body.Command = new TransactionContainer()
{
TransactionName = "create_backup",
Command = new CommandSequence()
{
Commands = new List<Command>()
{
new UserInputForm()
{
FormCaption = "Подключение к БД",
InputControls = new List<UserInputControl>()
{
new ICSQLConnection()
{
InitialValue = new SQLConnectionProperties()
{
DBName = "GRBS_437",
InstanceName = ".",
Password = "******",
SqlAuthentication = true,
UserName = "******"
},
ResultName = "sql_connection_string"
}
},
AfterComplete = new CMParseResult()
{
ArgumentName = "%sql_connection_string%"
}
},
new UserInputForm()
{
FormCaption = "Куда сохранять",
InputControls = new List<UserInputControl>()
{
new UserInputBrowseDirectoryDialog()
{
Caption = "Куда сохраняем",
InitialValue = @"C:\_test\",
ResultName = "backup_path"
}
}
},
new FormatDateTime()
{
UseCurrent = true,
FormatString = "yyyyMMddHHmmss",
ResultName = "date_time_string"
},
new SaveString()
{
IsPathCombine = true,
Value = @"%backup_path%\%date_time_string%_%sql_connection_string.DBName%.bak",
ResultName = "backup_full_path"
},
new CMCreateSQLBackup()
{
BackupFilePath = "%backup_full_path%",
CommandTimeout = 3600,
ConnectionString = "%sql_connection_string.ConnectionString%",
DatabaseName = "%sql_connection_string.DBName%"
}
}
}
};
return body;
}
