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