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