/// <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 IEnumerable <SGSPointData> GetQ(int id)
{
var opd = new OnePointData {
Id = id
};
return(SGSPointData.GetPointData(opd));
}
public void SGSPDGetPointDataTest_pid_1Z()
{
var opd = new OnePointData {
Id = 1
};
var res = SGSPointData.GetPointData(opd);
Assert.IsTrue(res.Count > 0);
foreach (var m in res)
{
Console.WriteLine(m);
}
}
public void SGSPDGetPointDataTest_pid_1_DT_2020_04_01_07_39_0_0_Z()
{
var contDT = new DateTime(2020, 4, 1, 7, 39, 0, 0);
var opd = new OnePointData {
Id = 1, DateFrom = contDT, DateTo = contDT
};
var res = SGSPointData.GetPointData(opd);
Assert.AreEqual(1, res.Count);
foreach (var m in res)
{
Console.WriteLine(m);
}
}
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);
}
public IEnumerable <SGSPointData> Post([FromBody] OnePointData onePointData, long id)
{
return(SGSPointData.GetPointData(id, onePointData.DateFrom, onePointData.DateTo));
}
public IEnumerable <SGSPointData> PostQ([FromBody] OnePointData onePointData, long id)
{
onePointData.Id = id;
return(SGSPointData.GetPointData(onePointData));
}
