/// <summary> /// Получает набор значений соответствующих условиям отбора одной точки /// </summary> /// <param name="DataPoint">Условия отбора одной точки</param> /// <returns></returns> public static List <SGSPointData> GetPointData(OnePointData DataPoint) { var res = new UniversalModel <SGSPointData>(); res.QParameters.Add(new SqlParameter("@Point", DataPoint.ToXMLString())); return(res.GetFromDBList("GetPointData")); }
public void OPDToXMLStringTest() { var exam = @" <OnePointData xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema""> <Id>1</Id> <DateFrom>2020-06-04T20:15:00</DateFrom> <DateTo>2020-06-04T20:35:00</DateTo> </OnePointData>"; var point = new OnePointData { Id = 1, DateFrom = new DateTime(2020, 06, 4, 20, 15, 0), DateTo = new DateTime(2020, 06, 4, 20, 35, 0) }; Console.WriteLine(point.ToXMLString()); Assert.AreEqual(exam, point.ToXMLString()); exam = @" <OnePointData xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema""> <Id>1</Id> <DateFrom>2020-06-04T20:15:00</DateFrom> </OnePointData>"; point = new OnePointData { Id = 1, DateFrom = new DateTime(2020, 06, 4, 20, 15, 0) }; Console.WriteLine(point.ToXMLString()); Assert.AreEqual(exam, point.ToXMLString()); exam = @" <OnePointData xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema""> <Id>1</Id> </OnePointData>"; point = new OnePointData { Id = 1 }; Console.WriteLine(point.ToXMLString()); Assert.AreEqual(exam, point.ToXMLString()); }
public void GetDataSetTest_GetPointData_onePoint_pid_1_DT_2020_04_01_07_39_0_0() { var res = new QueryExecutor("GetPointData"); var opd = new OnePointData { Id = 1, DateFrom = new DateTime(2020, 4, 1, 7, 39, 0, 0), DateTo = new DateTime(2020, 4, 1, 7, 39, 0, 0) }; res.Parameters.Add(new SqlParameter("@Point", opd.ToXMLString())); var ds = res.GetDataSet; foreach (DataRow row in ds.Tables[0].Rows) { foreach (DataColumn cn in row.Table.Columns) { Console.Write($"{cn.ColumnName}:{row[cn]}| "); } Console.WriteLine(); Console.WriteLine("________________________________________________________________________________________________________"); } Assert.AreEqual(1, ds.Tables[0].Rows.Count); }
public void GetDataSetTest_GetPointData_onePoint_pid1() { var res = new QueryExecutor("GetPointData"); var opd = new OnePointData { Id = 1 }; res.Parameters.Add(new SqlParameter("@Point", opd.ToXMLString())); var ds = res.GetDataSet; foreach (DataRow row in ds.Tables[0].Rows) { foreach (DataColumn cn in row.Table.Columns) { Console.Write($"{cn.ColumnName}:{row[cn]}| "); } Console.WriteLine(); Console.WriteLine("________________________________________________________________________________________________________"); } Assert.AreEqual(670, ds.Tables[0].Rows.Count); }