| public ReadRowsByRange ( Gurux.DLMS.Objects.GXDLMSProfileGeneric it, System.DateTime start, System.DateTime end ) : object[] | ||
| it | Gurux.DLMS.Objects.GXDLMSProfileGeneric | |
| start | System.DateTime | |
| end | System.DateTime | |
| return | object[] | |
static void Main(string[] args)
{
IGXMedia media = null;
GXCommunicatation comm = null;
try
{
TextWriter logFile = new StreamWriter(File.Open("LogFile.txt", FileMode.Create));
////////////////////////////////////////
//Handle command line parameters.
String sn, client = "", server = "", id = "", host = "", port = "", pw = "";
bool trace = false, iec = true;
bool hdlc = true, ln = true;
Authentication auth = Authentication.None;
foreach (string it in args)
{
String item = it.Trim().ToLower();
if (string.Compare(item, "/u", true) == 0)//Update
{
//Get latest manufacturer settings from Gurux web server.
GXManufacturerCollection.UpdateManufactureSettings();
}
else if (item.StartsWith("/sn="))//Serial number.
{
sn = item.Replace("/sn=", "");
}
else if (string.Compare(item, "/wrapper", true) == 0)//Wrapper is used.
{
hdlc = false;
}
else if (item.StartsWith("/r="))//referencing
{
id = item.Replace("/r=", "");
}
else if (item.StartsWith("/m="))//Manufacturer
{
id = item.Replace("/m=", "");
}
else if (item.StartsWith("/client="))//Client address
{
client = item.Replace("/client=", "");
}
else if (item.StartsWith("/server="))//Server address
{
server = item.Replace("/server=", "");
}
else if (item.StartsWith("/h=")) //Host
{
host = item.Replace("/h=", "");
}
else if (item.StartsWith("/p="))// TCP/IP Port
{
media = new Gurux.Net.GXNet();
port = item.Replace("/p=", "");
}
else if (item.StartsWith("/sp="))//Serial Port
{
port = item.Replace("/sp=", "");
media = new GXSerial();
}
else if (item.StartsWith("/t"))//Are messages traced.
{
trace = true;
}
else if (item.StartsWith("/s="))//Start
{
String tmp = item.Replace("/s=", "");
iec = string.Compare(tmp, "dlms", true) != 0;
}
else if (item.StartsWith("/a="))//Authentication
{
auth = (Authentication)Enum.Parse(typeof(Authentication), it.Trim().Replace("/a=", ""));
}
else if (item.StartsWith("/pw="))//Password
{
pw = it.Trim().Replace("/pw=", "");
}
else
{
ShowHelp();
return;
}
}
if (string.IsNullOrEmpty(id) || string.IsNullOrEmpty(port) || (media is GXNet && string.IsNullOrEmpty(host)))
{
ShowHelp();
return;
}
////////////////////////////////////////
//Initialize connection settings.
if (media is GXSerial)
{
GXSerial serial = media as GXSerial;
serial.PortName = port;
if (iec)
{
serial.BaudRate = 300;
serial.DataBits = 7;
serial.Parity = System.IO.Ports.Parity.Even;
serial.StopBits = System.IO.Ports.StopBits.One;
}
else
{
serial.BaudRate = 9600;
serial.DataBits = 8;
serial.Parity = System.IO.Ports.Parity.None;
serial.StopBits = System.IO.Ports.StopBits.One;
}
}
else if (media is GXNet)
{
Gurux.Net.GXNet net = media as GXNet;
net.Port = Convert.ToInt32(port);
net.HostName = host;
net.Protocol = Gurux.Net.NetworkType.Tcp;
}
else
{
throw new Exception("Unknown media type.");
}
////////////////////////////////////////
//Update manufacturer depended settings.
GXManufacturerCollection Manufacturers = new GXManufacturerCollection();
GXManufacturerCollection.ReadManufacturerSettings(Manufacturers);
GXManufacturer man = Manufacturers.FindByIdentification(id);
if (man == null)
{
throw new Exception("Unknown manufacturer: " + id);
}
GXDLMSSecureClient dlms = new GXDLMSSecureClient();
//Update Obis code list so we can get right descriptions to the objects.
dlms.CustomObisCodes = man.ObisCodes;
comm = new GXCommunicatation(dlms, media, iec, auth, pw);
comm.Trace = trace;
comm.InitializeConnection(man);
GXDLMSObjectCollection objects = null;
string path = host.Replace('.', '_') + "_" + port.ToString() + ".xml";
List<Type> extraTypes = new List<Type>(Gurux.DLMS.GXDLMSClient.GetObjectTypes());
extraTypes.Add(typeof(GXDLMSAttributeSettings));
extraTypes.Add(typeof(GXDLMSAttribute));
XmlSerializer x = new XmlSerializer(typeof(GXDLMSObjectCollection), extraTypes.ToArray());
//You can save association view, but make sure that it is not change.
//Save Association view to the cache so it is not needed to retrieve every time.
/*
if (File.Exists(path))
{
try
{
using (Stream stream = File.Open(path, FileMode.Open))
{
Console.WriteLine("Get available objects from the cache.");
objects = x.Deserialize(stream) as GXDLMSObjectCollection;
stream.Close();
}
}
catch (Exception ex)
{
if (File.Exists(path))
{
File.Delete(path);
}
throw ex;
}
}
else
*/
{
Console.WriteLine("Get available objects from the device.");
objects = comm.GetAssociationView();
GXDLMSObjectCollection objs = objects.GetObjects(new ObjectType[] { ObjectType.Register, ObjectType.ExtendedRegister, ObjectType.DemandRegister });
Console.WriteLine("Read scalers and units from the device.");
List<KeyValuePair<GXDLMSObject, int>> list = new List<KeyValuePair<GXDLMSObject, int>>();
try
{
foreach (GXDLMSObject it in objs)
{
if (it is GXDLMSRegister)
{
list.Add(new KeyValuePair<GXDLMSObject, int>(it, 3));
}
if (it is GXDLMSDemandRegister)
{
list.Add(new KeyValuePair<GXDLMSObject, int>(it, 4));
}
}
comm.ReadList(list);
}
catch
{
//If this fails meter is not supporting reading read by list method.
//Read values one by one.
foreach (GXDLMSObject it in objs)
{
try
{
if (it is GXDLMSRegister)
{
Console.WriteLine(it.Name);
comm.Read(it, 3);
}
if (it is GXDLMSDemandRegister)
{
Console.WriteLine(it.Name);
comm.Read(it, 4);
}
}
catch
{
//Actaric SL7000 can return error here. Continue reading.
}
}
}
//Read Profile Generic columns first.
foreach (GXDLMSObject it in objects.GetObjects(ObjectType.ProfileGeneric))
{
try
{
Console.WriteLine(it.Name);
comm.Read(it, 3);
GXDLMSObject[] cols = (it as GXDLMSProfileGeneric).GetCaptureObject();
TraceLine(logFile, "Profile Generic " + it.Name + " Columns:");
StringBuilder sb = new StringBuilder();
bool First = true;
foreach (GXDLMSObject col in cols)
{
if (!First)
{
sb.Append(" | ");
}
First = false;
sb.Append(col.Name);
sb.Append(" ");
sb.Append(col.Description);
}
TraceLine(logFile, sb.ToString());
}
catch (Exception ex)
{
TraceLine(logFile, "Err! Failed to read columns:" + ex.Message);
//Continue reading.
}
}
try
{
using (Stream stream = File.Open(path, FileMode.Create))
{
TextWriter writer = new StreamWriter(stream);
x.Serialize(writer, objects);
writer.Close();
stream.Close();
}
}
catch (Exception ex)
{
if (File.Exists(path))
{
File.Delete(path);
}
throw ex;
}
Console.WriteLine("--- Available objects ---");
foreach (GXDLMSObject it in objects)
{
Console.WriteLine(it.Name + " " + it.Description);
}
}
foreach (GXDLMSObject it in objects)
{
// Profile generics are read later because they are special cases.
// (There might be so lots of data and we so not want waste time to read all the data.)
if (it is GXDLMSProfileGeneric)
{
continue;
}
if (!(it is IGXDLMSBase))
{
//If interface is not implemented.
//Example manufacturer spesific interface.
Console.WriteLine("Unknown Interface: " + it.ObjectType.ToString());
continue;
}
TraceLine(logFile, "-------- Reading " + it.GetType().Name + " " + it.Name + " " + it.Description);
foreach (int pos in (it as IGXDLMSBase).GetAttributeIndexToRead())
{
try
{
object val = comm.Read(it, pos);
//If data is array.
if (val is byte[])
{
val = GXCommon.ToHex((byte[])val, true);
}
else if (val is Array)
{
string str = "";
for (int pos2 = 0; pos2 != (val as Array).Length; ++pos2)
{
if (str != "")
{
str += ", ";
}
if ((val as Array).GetValue(pos2) is byte[])
{
str += GXCommon.ToHex((byte[])(val as Array).GetValue(pos2), true);
}
else
{
str += (val as Array).GetValue(pos2).ToString();
}
}
val = str;
}
else if (val is System.Collections.IList)
{
string str = "[";
bool empty = true;
foreach (object it2 in val as System.Collections.IList)
{
if (!empty)
{
str += ", ";
}
empty = false;
if (it2 is byte[])
{
str += GXCommon.ToHex((byte[])it2, true);
}
else
{
str += it2.ToString();
}
}
str += "]";
val = str;
}
TraceLine(logFile, "Index: " + pos + " Value: " + val);
}
catch (Exception ex)
{
TraceLine(logFile, "Error! Index: " + pos + " " + ex.Message);
}
}
}
//Find profile generics and read them.
foreach (GXDLMSObject it in objects.GetObjects(ObjectType.ProfileGeneric))
{
TraceLine(logFile, "-------- Reading " + it.GetType().Name + " " + it.Name + " " + it.Description);
long entriesInUse = Convert.ToInt64(comm.Read(it, 7));
long entries = Convert.ToInt64(comm.Read(it, 8));
TraceLine(logFile, "Entries: " + entriesInUse + "/" + entries);
//If there are no columns or rows.
if (entriesInUse == 0 || (it as GXDLMSProfileGeneric).CaptureObjects.Count == 0)
{
continue;
}
try
{
//Read first row from Profile Generic.
object[] rows = comm.ReadRowsByEntry(it as GXDLMSProfileGeneric, 1, 1);
StringBuilder sb = new StringBuilder();
foreach (object[] row in rows)
{
foreach (object cell in row)
{
if (cell is byte[])
{
sb.Append(GXCommon.ToHex((byte[])cell, true));
}
else
{
sb.Append(Convert.ToString(cell));
}
sb.Append(" | ");
}
sb.Append("\r\n");
}
Trace(logFile, sb.ToString());
}
catch (Exception ex)
{
TraceLine(logFile, "Error! Failed to read first row: " + ex.Message);
//Continue reading.
}
try
{
//Read last day from Profile Generic.
object[] rows = comm.ReadRowsByRange(it as GXDLMSProfileGeneric, DateTime.Now.Date, DateTime.MaxValue);
StringBuilder sb = new StringBuilder();
foreach (object[] row in rows)
{
foreach (object cell in row)
{
if (cell is byte[])
{
sb.Append(GXCommon.ToHex((byte[])cell, true));
}
else
{
sb.Append(Convert.ToString(cell));
}
sb.Append(" | ");
}
sb.Append("\r\n");
}
Trace(logFile, sb.ToString());
}
catch (Exception ex)
{
TraceLine(logFile, "Error! Failed to read last day: " + ex.Message);
//Continue reading.
}
}
logFile.Flush();
logFile.Close();
}
catch (Exception ex)
{
if (comm != null)
{
comm.Close();
}
Console.WriteLine(ex.Message);
if (!System.Diagnostics.Debugger.IsAttached)
{
Console.ReadKey();
}
}
finally
{
if (comm != null)
{
comm.Close();
}
if (System.Diagnostics.Debugger.IsAttached)
{
Console.WriteLine("Ended. Press any key to continue.");
Console.ReadKey();
}
}
}
static void Main(string[] args)
{
IGXMedia media = null;
GXCommunicatation comm = null;
try
{
TextWriter logFile = new StreamWriter(File.Open("LogFile.txt", FileMode.Create));
////////////////////////////////////////
//Handle command line parameters.
String id = "", host = "", port = "", pw = "";
bool trace = false, iec = true;
Authentication auth = Authentication.None;
foreach (string it in args)
{
String item = it.Trim().ToLower();
if (string.Compare(item, "/u", true) == 0)//Update
{
//Get latest manufacturer settings from Gurux web server.
GXManufacturerCollection.UpdateManufactureSettings();
}
else if (item.StartsWith("/m="))//Manufacturer
{
id = item.Replace("/m=", "");
}
else if (item.StartsWith("/h=")) //Host
{
host = item.Replace("/h=", "");
}
else if (item.StartsWith("/p="))// TCP/IP Port
{
media = new Gurux.Net.GXNet();
port = item.Replace("/p=", "");
}
else if (item.StartsWith("/sp="))//Serial Port
{
port = item.Replace("/sp=", "");
media = new GXSerial();
}
else if (item.StartsWith("/t"))//Are messages traced.
{
trace = true;
}
else if (item.StartsWith("/s="))//Start
{
String tmp = item.Replace("/s=", "");
iec = string.Compare(tmp, "dlms", true) != 0;
}
else if (item.StartsWith("/a="))//Authentication
{
auth = (Authentication)Enum.Parse(typeof(Authentication), it.Trim().Replace("/a=", ""));
}
else if (item.StartsWith("/pw="))//Password
{
pw = it.Trim().Replace("/pw=", "");
}
else
{
ShowHelp();
return;
}
}
if (string.IsNullOrEmpty(id) || string.IsNullOrEmpty(port) || (media is GXNet && string.IsNullOrEmpty(host)))
{
ShowHelp();
return;
}
////////////////////////////////////////
//Initialize connection settings.
if (media is GXSerial)
{
GXSerial serial = media as GXSerial;
serial.PortName = port;
if (iec)
{
serial.BaudRate = 300;
serial.DataBits = 7;
serial.Parity = System.IO.Ports.Parity.Even;
serial.StopBits = System.IO.Ports.StopBits.One;
}
else
{
serial.BaudRate = 9600;
serial.DataBits = 8;
serial.Parity = System.IO.Ports.Parity.None;
serial.StopBits = System.IO.Ports.StopBits.One;
}
}
else if (media is GXNet)
{
Gurux.Net.GXNet net = media as GXNet;
net.Port = Convert.ToInt32(port);
net.HostName = host;
net.Protocol = Gurux.Net.NetworkType.Tcp;
}
else
{
throw new Exception("Unknown media type.");
}
////////////////////////////////////////
//Update manufacturer depended settings.
GXManufacturerCollection Manufacturers = new GXManufacturerCollection();
GXManufacturerCollection.ReadManufacturerSettings(Manufacturers);
GXManufacturer man = Manufacturers.FindByIdentification(id);
if (man == null)
{
throw new Exception("Unknown manufacturer: " + id);
}
GXDLMSClient dlms = new GXDLMSClient();
//Update Obis code list so we can get right descriptions to the objects.
dlms.CustomObisCodes = man.ObisCodes;
comm = new GXCommunicatation(dlms, media, iec, auth, pw);
comm.Trace = trace;
comm.InitializeConnection(man);
GXDLMSObjectCollection objects = null;
string path = host.Replace('.', '_') + "_" + port.ToString() + ".xml";
List <Type> extraTypes = new List <Type>(Gurux.DLMS.GXDLMSClient.GetObjectTypes());
extraTypes.Add(typeof(GXDLMSAttributeSettings));
extraTypes.Add(typeof(GXDLMSAttribute));
XmlSerializer x = new XmlSerializer(typeof(GXDLMSObjectCollection), extraTypes.ToArray());
//You can save association view, but make sure that it is not change.
//Save Association view to the cache so it is not needed to retrieve every time.
/*
* if (File.Exists(path))
* {
* try
* {
* using (Stream stream = File.Open(path, FileMode.Open))
* {
* Console.WriteLine("Get available objects from the cache.");
* objects = x.Deserialize(stream) as GXDLMSObjectCollection;
* stream.Close();
* }
* }
* catch (Exception ex)
* {
* if (File.Exists(path))
* {
* File.Delete(path);
* }
* throw ex;
* }
* }
* else
*/
{
Console.WriteLine("Get available objects from the device.");
objects = comm.GetAssociationView();
GXDLMSObjectCollection objs = objects.GetObjects(new ObjectType[] { ObjectType.Register, ObjectType.ExtendedRegister, ObjectType.DemandRegister });
Console.WriteLine("Read scalers and units from the device.");
Thread.Sleep(1000);
foreach (GXDLMSObject it in objs)
{
if (it is GXDLMSRegister)
{
Console.WriteLine(it.Name);
comm.Read(it, 3);
}
if (it is GXDLMSDemandRegister)
{
Console.WriteLine(it.Name);
comm.Read(it, 4);
}
}
Thread.Sleep(1000);
//Read Profile Generic columns first.
foreach (GXDLMSObject it in objects.GetObjects(ObjectType.ProfileGeneric))
{
try
{
Console.WriteLine(it.Name);
comm.Read(it, 3);
GXDLMSObject[] cols = (it as GXDLMSProfileGeneric).GetCaptureObject();
TraceLine(logFile, "Profile Generic " + it.Name + " Columns:");
StringBuilder sb = new StringBuilder();
bool First = true;
foreach (GXDLMSObject col in cols)
{
if (!First)
{
sb.Append(" | ");
}
First = false;
sb.Append(col.Name);
sb.Append(" ");
sb.Append(col.Description);
}
TraceLine(logFile, sb.ToString());
}
catch (Exception ex)
{
TraceLine(logFile, "Err! Failed to read columns:" + ex.Message);
//Continue reading.
}
}
try
{
using (Stream stream = File.Open(path, FileMode.Create))
{
TextWriter writer = new StreamWriter(stream);
x.Serialize(writer, objects);
writer.Close();
stream.Close();
}
}
catch (Exception ex)
{
if (File.Exists(path))
{
File.Delete(path);
}
throw ex;
}
Console.WriteLine("--- Available objects ---");
foreach (GXDLMSObject it in objects)
{
Console.WriteLine(it.Name + " " + it.Description);
}
}
Thread.Sleep(1000);
foreach (GXDLMSObject it in objects)
{
// Profile generics are read later because they are special cases.
// (There might be so lots of data and we so not want waste time to read all the data.)
if (it is GXDLMSProfileGeneric)
{
continue;
}
if (!(it is IGXDLMSBase))
{
//If interface is not implemented.
//Example manufacturer spesific interface.
Console.WriteLine("Unknown Interface: " + it.ObjectType.ToString());
continue;
}
TraceLine(logFile, "-------- Reading " + it.GetType().Name + " " + it.Name + " " + it.Description);
foreach (int pos in (it as IGXDLMSBase).GetAttributeIndexToRead())
{
try
{
object val = comm.Read(it, pos);
//If data is array.
if (val is byte[])
{
val = GXCommon.ToHex((byte[])val, true);
}
else if (val is Array)
{
string str = "";
for (int pos2 = 0; pos2 != (val as Array).Length; ++pos2)
{
if (str != "")
{
str += ", ";
}
if ((val as Array).GetValue(pos2) is byte[])
{
str += GXCommon.ToHex((byte[])(val as Array).GetValue(pos2), true);
}
else
{
str += (val as Array).GetValue(pos2).ToString();
}
}
val = str;
}
else if (val is System.Collections.IList)
{
string str = "[";
bool empty = true;
foreach (object it2 in val as System.Collections.IList)
{
if (!empty)
{
str += ", ";
}
empty = false;
if (it2 is byte[])
{
str += GXCommon.ToHex((byte[])it2, true);
}
else
{
str += it2.ToString();
}
}
str += "]";
val = str;
}
TraceLine(logFile, "Index: " + pos + " Value: " + val);
}
catch (Exception ex)
{
TraceLine(logFile, "Error! Index: " + pos + " " + ex.Message);
}
}
}
Thread.Sleep(1000);
//Find profile generics and read them.
foreach (GXDLMSObject it in objects.GetObjects(ObjectType.ProfileGeneric))
{
TraceLine(logFile, "-------- Reading " + it.GetType().Name + " " + it.Name + " " + it.Description);
long entriesInUse = Convert.ToInt64(comm.Read(it, 7));
long entries = Convert.ToInt64(comm.Read(it, 8));
TraceLine(logFile, "Entries: " + entriesInUse + "/" + entries);
//If there are no columns or rows.
if (entriesInUse == 0 || (it as GXDLMSProfileGeneric).CaptureObjects.Count == 0)
{
continue;
}
try
{
//Read first row from Profile Generic.
object[] rows = comm.ReadRowsByEntry(it as GXDLMSProfileGeneric, 0, 1);
StringBuilder sb = new StringBuilder();
foreach (object[] row in rows)
{
foreach (object cell in row)
{
if (cell is byte[])
{
sb.Append(GXCommon.ToHex((byte[])cell, true));
}
else
{
sb.Append(Convert.ToString(cell));
}
sb.Append(" | ");
}
sb.Append("\r\n");
}
Trace(logFile, sb.ToString());
}
catch (Exception ex)
{
TraceLine(logFile, "Error! Failed to read first row: " + ex.Message);
//Continue reading.
}
try
{
//Read last day from Profile Generic.
object[] rows = comm.ReadRowsByRange(it as GXDLMSProfileGeneric, DateTime.Now.Date, DateTime.MaxValue);
StringBuilder sb = new StringBuilder();
foreach (object[] row in rows)
{
foreach (object cell in row)
{
if (cell is byte[])
{
sb.Append(GXCommon.ToHex((byte[])cell, true));
}
else
{
sb.Append(Convert.ToString(cell));
}
sb.Append(" | ");
}
sb.Append("\r\n");
}
Trace(logFile, sb.ToString());
}
catch (Exception ex)
{
TraceLine(logFile, "Error! Failed to read last day: " + ex.Message);
//Continue reading.
}
}
logFile.Flush();
logFile.Close();
}
catch (Exception ex)
{
if (comm != null)
{
comm.Close();
}
Console.WriteLine(ex.Message);
if (!System.Diagnostics.Debugger.IsAttached)
{
Console.ReadKey();
}
}
finally
{
if (comm != null)
{
comm.Close();
}
if (System.Diagnostics.Debugger.IsAttached)
{
Console.WriteLine("Ended. Press any key to continue.");
Console.ReadKey();
}
}
}