public NCodebook() { // SQLConnector connector = new SQLConnector(); //SqlDataReader reader = connector.GetCodeBook(); // while (reader.Read()) // { // Console.WriteLine(String.Format("{0} {1} {2}", reader[0], reader[1], reader[2])); // } List<Codebook> codebooks = new List<Codebook>(); using (CodeBookEntity db = new CodeBookEntity()) { var items = db.OutputViews.ToList(); foreach (OutputView m in items) { ICodebook w = new NCodebook(); w.Start = m.Start.UshortConverter(); w.End = m.End.NullableUshortConverter(); //if (m.Definition_Id == 5) //{ // var f = w.Start - w.End; //} w.NumberOfPoints = (w.End == null) ? (ushort)1 : (ushort)(uint)(w.End - w.Start + 1);// +1 means include address w.Write = m.Write?[0]; w.Read = m.Read?[0]; w.Channel = m.Channel; w.Request_Id = m.Request_Id; w.Definition_Id = m.Definition_Id; w.Definition = m.Definition; w.Format = m.Format; w.Definition = m.Definition; w.DefaultValue = m.DefaultValue; this.Add(w); } } }
protected Codebooks() { List <Codebook> codebooks = new List <Codebook>(); using (CodeBookEntity db = new CodeBookEntity()) { var items = db.OutputViews.ToList(); foreach (OutputView m in items) { var w = new Codebook(); w.Start = m.Start.UshortConverter(); w.End = m.End.NullableUshortConverter(); //if (m.Definition_Id == 5) //{ // var f = w.Start - w.End; //} w.NumberOfPoints = (w.End == null) ? (ushort)1 : (ushort)(uint)(w.End - w.Start + 1);// +1 means include address w.Write = m.Write?[0]; w.Read = m.Read?[0]; w.Channel = m.Channel; w.Request_Id = m.Request_Id; w.Definition_Id = m.Definition_Id; w.Definition = m.Definition; w.Format = m.Format; w.Definition = m.Definition; w.DefaultValue = m.DefaultValue; codebooks.Add(w); } } _codebooks = codebooks; }