private void Dbaccess(string machineNo)
{
OdbcDbIf db = new OdbcDbIf();
DataTable tb;
db.Connect(dsn, dbn, uid, pas, -1);
string q = $"select {MachineNameRowName},{MachineSateRowName} from {tbl} where {MachineNoRowName}='{machineNo}'";
tb = db.ExecuteSql(q, -1);
if (tb.Rows.Count > 0)
{
MachineNameLabel.Content = tb.Rows[0][MachineNameRowName].ToString().Trim();
int state;
if (int.TryParse(tb.Rows[0][MachineSateRowName].ToString(), out state))
{
}
else
{
state = 0;
}
oldStatus = state;
ChangeStateButton(true, state);
}
else
{
MachineNameLabel.Content = "Machine No.異常";
}
db.Disconnect();
}
private void UpdateState(string machineNo, int state)
{
OdbcDbIf db = new OdbcDbIf();
db.Connect(dsn, dbn, uid, pas, -1);
db.BeginTransaction();
string q = $"update {tbl} set {MachineSateRowName}='{state.ToString()}' where {MachineNoRowName}='{machineNo}'";
db.ExecuteSql(q, -1);
db.CommitTransaction();
db.Disconnect();
String logmessage = $"{machineNo}:【{stateString[oldStatus]}】 → 【{stateString[state]}】 ";
MyLog.WriteTraceLog(logmessage);
Dbaccess(machineNo);
}
