public SQLHelper(string TransDB, string DBName, string UserName, string password)
{
oCompany = new Company();
oCompany.language = SAPbobsCOM.BoSuppLangs.ln_English;
oCompany.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_HANADB;
DecryptEncrypt decryptEncrypt = new DecryptEncrypt();
string server = "10.7.4.52:30015";
oCompany.Server = server;
string DbUserName = "******";
oCompany.UserName = UserName;
string DbPassword = decryptEncrypt.DecryptString("ewkuUzieRFmtZ+8oOt7jlw==");
oCompany.Password = password;
string Password = decryptEncrypt.DecryptString("r9Vme0oG3tk=");
CompanyDB = DBName;
oCompany.CompanyDB = DBName;
if (DBName == "SBOCOMMON") //如果是加载登录界面时获取帐套列表时，看配置文件里面的companyDB是否为空，不为空，则CompanyDB赋值，用于绑定帐套列表默认值
{
CompanyDB = "SBOCOMMON";
}
ServiceLayerUrl = "https://10.7.4.53:50000/b1s/v1/";
oCompany.LicenseServer = "10.7.4.53:40000";
if (Environment.Is64BitProcess)
{
connectionString = "Driver={HDBODBC};SERVERNODE={" + server + "};Database=" + DBName + ";uid=" + DbUserName + ";PWD=" + DbPassword + "";
}
else
{
connectionString = "Driver={HDBODBC32};SERVERNODE={" + server + "};Database=" + DBName + ";uid=" + DbUserName + ";PWD=" + DbPassword + "";
}
int lRetCode = oCompany.Connect();
string msg = oCompany.GetLastErrorDescription();
}
/// <summary>
/// 连接数据库
/// </summary>
/// <param name="DBName"></param>
public SQLHelper(string DBName)
{
DecryptEncrypt decryptEncrypt = new DecryptEncrypt();
string DbUserName = "******";
string DbPassword = decryptEncrypt.DecryptString("ewkuUzieRFmtZ+8oOt7jlw==");
string Password = decryptEncrypt.DecryptString("r9Vme0oG3tk=");
CompanyDB = DBName;
string server = "10.7.4.52:30015";
if (DBName == "SBOCOMMON") //如果是加载登录界面时获取帐套列表时，看配置文件里面的companyDB是否为空，不为空，则CompanyDB赋值，用于绑定帐套列表默认值
{
CompanyDB = "SBOCOMMON";
}
ServiceLayerUrl = "https://10.7.4.53:50000/b1s/v1/";
if (Environment.Is64BitProcess)
{
connectionString = "Driver={HDBODBC};SERVERNODE={" + server + "};Database=" + DBName + ";uid=" + DbUserName + ";PWD=" + DbPassword + "";
}
else
{
connectionString = "Driver={HDBODBC32};SERVERNODE={" + server + "};Database=" + DBName + ";uid=" + DbUserName + ";PWD=" + DbPassword + "";
}
}
