public static SqlConnection GetDBConnection(Model.SettingClass settingClass) { //string datasource = @"FS-35686\SQLEXPRESS"; //string database = "ERPSOFT"; //string username = "******"; //string password = "******"; string datasource = ""; string database = ""; string username = ""; string password = ""; datasource = settingClass.OfflineServer == null? "172.16.0.12": settingClass.OfflineServer; database = "ERPSOFT"; username = settingClass.userOffline == null? "ERPUSER" : settingClass.userOffline; password = settingClass.password == null ?"12345": settingClass.password; //string datasource = @"172.16.1.222\LOCALSQL"; //string database = "MQCMES"; //string username = "******"; //string password = "******"; return(DBSQLServerUtils.GetDBConnection(datasource, database, username, password)); }
public static SqlConnection GetLocalPLCConnection(string _datasource, string _database, string _user, string _pass) { //Data Source = LONG; Initial Catalog = TEST; Integrated Security = True string datasource = _datasource; string database = _database; string username = _user; string password = _pass; return(DBSQLServerUtils.GetLocalPLCConnection(datasource, database, username, password)); }
public static SqlConnection GetERPTargetBConnection() { //Data Source = LONG; Initial Catalog = TEST; Integrated Security = True string datasource = "172.16.0.11"; string database = "SOT"; string username = "******"; string password = "******"; return(DBSQLServerUtils.GetSFTDBConnection(datasource, database, username, password)); }
public static SqlConnection GetSFTDBConnection() { //Data Source = LONG; Initial Catalog = TEST; Integrated Security = True string datasource = "172.16.0.11"; string database = "SFT_TECHLINK"; string username = "******"; string password = "******"; return(DBSQLServerUtils.GetSFTDBConnection(datasource, database, username, password)); }
public static SqlConnection GetDBConnection() { string datasource = "172.16.0.12"; string database = "ERPSOFT"; string username = "******"; string password = "******"; return(DBSQLServerUtils.GetDBConnection(datasource, database, username, password)); }