public override bool Load() { bool ret = true; //List<long> idlist = new List<long>(); if (Common.Conn == null) { Common.Conn = new SQLiteConnection(Common.ConnectionString); Common.Conn.Open(); } SQLiteDataReader myReader = null; SQLiteCommand myCommand = new SQLiteCommand(); try { myReader = null; myCommand.CommandText = @"SELECT * FROM [tblAlarm] where VarNameID = " + m_VarNameID_tblVariable.VarNameID + ";"; myCommand.Connection = Common.Conn; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { tblAlarm tblalarm = new tblAlarm(); tblalarm.m_VarNameID_tblVariable = this.m_VarNameID_tblVariable; tblalarm.AddFromRecordSet(myReader); this.Add(tblalarm); } myReader.Close(); myCommand.Dispose(); //int count = idlist.Count; //foreach (long id in idlist)// (int i = 0; i < count ; i++) //{ // tblAlarm tblalarm = new tblAlarm(); // tblalarm.ID = id;// idlist[i]; // tblalarm.m_VarNameID_tblVariable = this.m_VarNameID_tblVariable; // tblalarm.Select(); // this.Add(tblalarm); //} } catch (SQLiteException ae) { MessageBox.Show(ae.Message.ToString()); return(false); // } return(ret); }
//public AlarmObject( ) //{ //} public AlarmObject(tblAlarm tocopy) { AlarmGroups = new List <IAlarmGroup>(); FillAlarmGroups(); ID = tocopy.ID; VarNameID = tocopy.VarNameID; StatusBit = (AlarmStatusBit)tocopy.StatusBit; Type = (AlarmGroupType)tocopy.Type; //AlarmGroupID = tocopy.AlarmGroupID; this._IAlarmGroup = InitAlarmGroup(tocopy.AlarmGroupID); EnableTagID = tocopy.EnableTagID; EnableTagDirection = tocopy.EnableTagDirection; EnableTagDelayOn = tocopy.EnableTagDelayOn; EnableTagDirection = tocopy.EnableTagDirection; EnableTagDelayOn = tocopy.EnableTagDelayOn; EnableTagDealyOff = tocopy.EnableTagDealyOff; DelayOn = tocopy.DelayOn; DelayOff = tocopy.DelayOff; SourceAlarmTagID = tocopy.SourceAlarmTagID; FirstOutGroupID = tocopy.FirstOutGroupID; hysteresis = tocopy.hysteresis; UpperLevelGroupID = tocopy.UpperLevelGroupID; }
public void CopyVariableGrid(VariableGrid tocopy) { this.VarName = tocopy.VarName; this.VarNameID = tocopy.VarNameID; this.pouID = tocopy.pouID; this.Description = tocopy.Description; this.InitialVal = tocopy.InitialVal; this.Type = tocopy.Type; this.Option = (int)tocopy.Option; this.PlantStructureID = tocopy.PlantStructureID; this.DispalyID = tocopy.DispalyID; this.AEB = tocopy.AEB; this.ALB = tocopy.ALB; this.SampleTime = tocopy.SampleTime; this.RTT = tocopy.RTT; this.Interval = tocopy.Interval; this.Archive = tocopy.Archive; this.ArchiveInterval = tocopy.ArchiveInterval; bool found = false; tblAlarm tblaralm; int count = m_tblAlarmCollection.Count; for (int i = count - 1; i >= 0; i--) { found = false; tblaralm = m_tblAlarmCollection[i]; foreach (AlarmObject alarmobject in tocopy.m_AlarmCollection) { if (tblaralm.ID == alarmobject.ID) { found = true; break; } } if (!found) { tblaralm.Delete(); m_tblAlarmCollection.Remove(tblaralm); } } foreach (AlarmObject alarmobject in tocopy.m_AlarmCollection) { if (alarmobject.ID == -1) { tblAlarm tblalarm = new tblAlarm(); tblalarm.AlarmObjectCopy(alarmobject); tblalarm.Insert(); m_tblAlarmCollection.Add(tblalarm); } else { foreach (tblAlarm tblalarm in m_tblAlarmCollection) { if (tblalarm.ID == alarmobject.ID) { tblalarm.AlarmObjectCopy(alarmobject); tblalarm.Update(); } } } } }
public bool Contains(tblAlarm item) { return(List.Contains(item)); }
public int IndexOf(tblAlarm item) { return(List.IndexOf(item)); }
public void Insert(int index, tblAlarm item) { List.Insert(index, item); this.OntblAlarmChanged(EventArgs.Empty); }
public void Remove(tblAlarm item) { List.Remove(item); this.OntblAlarmChanged(EventArgs.Empty); }
public void Add(tblAlarm item) { List.Add(item); this.OntblAlarmChanged(EventArgs.Empty); }