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