/// <summary> /// 更新 PLC 或 DB 連線狀態 /// </summary> /// <param name="Connect"></param> /// <param name="lblConnect"></param> private void funShowConnect(bool Connect, ref Label lblConnect) { bool bolLastConnect = lblConnect.Text == "已連線"; bool bolFlag = lblConnect.Text == "None"; clsTraceLogEventArgs SystemTraceLog = new clsTraceLogEventArgs(enuTraceLog.System); switch (Connect) { case true: lblConnect.Text = "已連線"; lblConnect.BackColor = Color.Lime; //if(!bolLastConnect || bolFlag) //{ // SystemTraceLog.LogMessage = // lblConnect.Name.Contains("DB") ? "Connection DB Success!" : "Connection " + lblConnect.Name.Substring(3, 5) + " Success!"; // funShowSystemTrace(lsbSystemTrace, SystemTraceLog, true); //} break; case false: default: lblConnect.Text = "未連線"; lblConnect.BackColor = Color.Red; //if(bolLastConnect || bolFlag) //{ // SystemTraceLog.LogMessage = // lblConnect.Name.Contains("DB") ? "Connection DB Fail!" : "Connection " + lblConnect.Name.Substring(3, 5) + " Fail!"; // funShowSystemTrace(lsbSystemTrace, SystemTraceLog, true); //} break; } }
/// <summary> /// 取得 Crane Mode 並更新 /// </summary> private void funReadCraneMode() { string strSQL = "SELECT * FROM EQUMODELOG WHERE ENDDT IN ('',' ')"; string strEM = string.Empty; DataTable objDataTable = new DataTable(); try { if (clsSystem.gobjDB.funGetDT(strSQL, ref objDataTable, ref strEM) == ErrDef.ProcSuccess) { for (int intCount = 0; intCount < objDataTable.Rows.Count; intCount++) { if (tlpCraneSts.Controls.ContainsKey("lblCrane" + objDataTable.Rows[intCount]["EQUNO"].ToString() + "Mode")) { Label objLabel = (Label)tlpCraneSts.Controls["lblCrane" + objDataTable.Rows[intCount]["EQUNO"].ToString() + "Mode"]; string strCurrentCraneMode = objDataTable.Rows[intCount]["EQUMODE"].ToString(); string strLastCraneMode = objLabel.Text.Substring(0, 1); string strCraneNo = objDataTable.Rows[intCount]["EQUNO"].ToString(); if (strLastCraneMode != strCurrentCraneMode) { funShowCraneMode(strCurrentCraneMode, ref objLabel); clsTraceLogEventArgs SystemTraceLog = new clsTraceLogEventArgs(enuTraceLog.System); SystemTraceLog.LogMessage = "Crane " + strCraneNo + " Mode Change"; SystemTraceLog.CraneNo = strCraneNo; SystemTraceLog.CraneMode = strCurrentCraneMode; SystemTraceLog.CraneModeLast = strLastCraneMode; funShowSystemTrace(lsbSystemTrace, SystemTraceLog, true); } } } } } catch (Exception ex) { var varObject = MethodBase.GetCurrentMethod(); clsSystem.funWriteExceptionLog(varObject.DeclaringType.FullName, varObject.Name, ex.Message); } finally { if (objDataTable != null) { objDataTable.Clear(); objDataTable.Dispose(); objDataTable = null; } } }