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));
}
