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 + ""; } }