public void cmdOk_Click(ItemEvent pEvent, bool bubleevent)
{
try
{
var grdCompany = GetItem(UniqueID.itmCompany).Specific
as SAPbouiCOM.Grid;
if (grdCompany.Rows.Count == 0)
{
throw new Exception("Selecione uma empresa");
}
var rowSel = grdCompany.Rows.SelectedRows.Item(
0, SAPbouiCOM.BoOrderType.ot_RowOrder);
var entitiID = grdCompany.DataTable.GetValue("Codigo", rowSel).To <Int32>();
var spID = grdCompany.DataTable.GetValue("ConnID", rowSel).To <Int32>();
//EntitySelection.Instace.SetCompany( entitiID, spID );
FormBind.Close();
}
catch (Exception ex)
{
SboApp.SetStatusBarMessage(ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, true);
}
}
/// <summary>
/// Formulário Customizado
/// </summary>
/// <param name="pType"></param>
public FormSystem(SAPbouiCOM.BoFormBorderStyle pBorderStyle)
: this()
{
var creationPackage = SboApp.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_FormCreationParams)
as SAPbouiCOM.FormCreationParams;
creationPackage.UniqueID = this.GetHashCode().ToString();
creationPackage.FormType = string.Format("{0}_{1}",
Application.GetInstance().NameSpace, this.GetType().Name);
creationPackage.BorderStyle = pBorderStyle;
FormBind = SboApp.Forms.AddEx(creationPackage) as SAPbouiCOM.Form;
GetEvents();
FormSystemManager.Instance().AddFormOpen(this);
}
/// <summary>
/// Get generated connection string from app settings in App.config
/// </summary>
/// <returns></returns>
public static ConnectionStringSettings GetConnectionString()
{
var serverType = SboApp.GetServiceType(ConfigurationManager.AppSettings["Sbo:ServerType"]);
var serverName = ConfigurationManager.AppSettings["Sbo:ServerName"];
var companyDb = ConfigurationManager.AppSettings["Sbo:CompanyDb"];
var dbUsername = ConfigurationManager.AppSettings["Sbo:DbUsername"];
var dbPassword = ConfigurationManager.AppSettings["Sbo:DbPassword"];
if (serverType == BoDataServerTypes.dst_HANADB)
{
return(new ConnectionStringSettings("SBO", $"Server={serverName};UserName={dbUsername};Password={dbPassword};CS={companyDb}", "Sap.Data.Hana"));
}
return(new ConnectionStringSettings("SBO", $"Server={serverName};User Id={dbUsername};Password={dbPassword};Database={companyDb}", "System.Data.SqlClient"));
}
public static void Init(TestContext textContext)
{
SboApp.Connect(SboApp.DebugConnectionString);
SboRecordset.NonQuery("DELETE FROM [@ITCO_FW_SETTINGS] WHERE [Code] LIKE 'test%'");
}
public void ShowMessageError(Exception ex)
{
SboApp.SetStatusBarMessage(ex.Message, SAPbouiCOM.BoMessageTime.bmt_Short, true);
}
public void DiConnectFromAppConfig_Test()
{
SboApp.DiConnectFromAppConfig();
}
