/// <summary>
/// Setup connection to the SFCS traceability system.
/// </summary>
/// <returns></returns>true: sucessfully connected. false: failed to connect.
public override bool Connect()
{
SFCSconnection = new GeneralLinkSql.GeneralLinkSql();
SFCSconnectionLocal = new GeneralLinkSqlLocal.GeneralLinkSqlLocal();
int connectionInfo = 99;
try
{
if (!CyBLE_MTK_Application.Properties.Settings.Default.GeneralLinkSqlLocalDebug)
{
connectionInfo = SFCSconnection.IsConnect();
}
else
{
connectionInfo = SFCSconnectionLocal.IsConnect();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "SFCSconnection Error");
}
switch (connectionInfo)
{
case 0:
SqlConnected = false;
LastError = "SFCS: SFCS cannot login.";
break;
case 1:
SqlConnected = true;
break;
//case 9:
// connected = false;
// connect_error = "SFCS: Cannot find SFCS database.";
// break;
//case 10:
// connected = false;
// connect_error = "SFCS: SFCS connection time out.";
// break;
//case 11:
// connected = false;
// connect_error = "SFCS: Failed to connect SFCS.";
// break;
default:
SqlConnected = false;
LastError = "SFCS: Unkown error when trying to connect SFCS.";
break;
}
return(SqlConnected);
}
/// <summary>
/// Setup connection to the SFCS traceability system.
/// </summary>
/// <returns></returns>true: sucessfully connected. false: failed to connect.
public bool SFCS_Connect()
{
SFCSconnection = new GeneralLinkSql.GeneralLinkSql();
bool connected = false;
int connectionInfo = SFCSconnection.IsConnect();
switch (connectionInfo)
{
case 0:
connected = false;
connect_error = "SFCS: SFCS cannot login.";
break;
case 1:
connected = true;
break;
//case 9:
// connected = false;
// connect_error = "SFCS: Cannot find SFCS database.";
// break;
//case 10:
// connected = false;
// connect_error = "SFCS: SFCS connection time out.";
// break;
//case 11:
// connected = false;
// connect_error = "SFCS: Failed to connect SFCS.";
// break;
default:
connected = false;
connect_error = "SFCS: Unkown error when trying to connect SFCS.";
break;
}
return(connected);
}
/// <summary>
/// Setup connection to the SFCS traceability system.
/// </summary>
/// <returns></returns>true: sucessfully connected. false: failed to connect.
public override bool Connect()
{
SFCSconnection = new GeneralLinkSql.GeneralLinkSql();
SFCSconnectionLocal = new GeneralLinkSqlLocal.GeneralLinkSqlLocal();
int connectionInfo = 99;
try
{
if (!CyBLE_MTK_Application.Properties.Settings.Default.GeneralLinkSqlLocalDebug)
{
//connectionInfo = SFCSconnection.IsConnect();
Thread connection_thread = new Thread(() => connectionInfo = SFCSconnection.IsConnect());
connection_thread.Name = "SFCSConnecting";
connection_thread.Start();
//SFCSconnection.IsConnect() waiting time
for (int i = 0; i < 30; i++)
{
if (connectionInfo != 99)
{
break;
}
Thread.Sleep(100);
}
}
else
{
connectionInfo = SFCSconnectionLocal.IsConnect();
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString(), "SFCSconnection Error");
}
switch (connectionInfo)
{
case 0:
SqlConnected = false;
LastError = "SFCS: SFCS cannot login.";
break;
case 1:
SqlConnected = true;
break;
//case 9:
// connected = false;
// connect_error = "SFCS: Cannot find SFCS database.";
// break;
//case 10:
// connected = false;
// connect_error = "SFCS: SFCS connection time out.";
// break;
//case 11:
// connected = false;
// connect_error = "SFCS: Failed to connect SFCS.";
// break;
default:
SqlConnected = false;
LastError = "SFCS: Unkown error when trying to connect SFCS.";
break;
}
return(SqlConnected);
}
