public static DeviceRec CreateDeviceRec(GCDevice device) { if (device == null) { return(null); } DeviceRec rec = new DeviceRec(); rec.ID = device.DeviceID; rec.Folder = device.FolderPath; rec.IndexFile = DeviceDirManager.IndexFileName; rec.Name = device.Directory.Header.Name; rec.Type = ((int)device.Directory.Header.Type).ToString(); rec.Description = device.Directory.Header.Description; switch (device.Directory.Header.Direction) { case DirectionType.INBOUND: rec.Direction = "I"; break; case DirectionType.OUTBOUND: rec.Direction = "O"; break; case DirectionType.BIDIRECTIONAL: rec.Direction = "B"; break; } return(rec); }
public bool DeleteDevice(int deviceID) { DeviceRec rec = new DeviceRec(); rec.ID = deviceID; return(Delete(rec)); }
public bool UpdateDevice(GCDevice device) { DeviceRec rec = DataHelper.CreateDeviceRec(device); if (rec == null) { return(false); } return(Update(rec)); }
public GCDevice GetDeviceByID(int deviceID) { string sql = "SELECT * FROM " + TableName + " WHERE DEVICE_ID=" + deviceID.ToString(); DObjectCollection dlist = Select(sql); if (dlist == null || dlist.Count < 1) { return(null); } DeviceRec rec = dlist[0] as DeviceRec; return(new GCDeviceAgent(rec)); }
public bool HasSameDevice(GCDevice device) { DeviceRec rec = DataHelper.CreateDeviceRec(device); if (rec == null) { return(true); } string sql = "SELECT * FROM " + TableName + " WHERE DEVICE_DIRECT='" + rec.Direction + "' AND DEVICE_TYPE='" + rec.Type + "' AND DEVICE_NAME='" + rec.Name + "'"; DObjectCollection dlist = Select(sql); if (dlist == null) { return(true); //db query failed. } if (dlist.Count > 0) { return(true); } return(false); }