public void testgetTurnN()
{
List <PValue> list = new List <PValue>();
PValue p1 = new PValue();
p1.Value = 5;
PValue p2 = new PValue();
p2.Value = 1;
PValue p3 = new PValue();
p3.Value = 4;
PValue p4 = new PValue();
p4.Value = 6;
PValue p5 = new PValue();
p5.Value = 7;
list.Add(p1);
list.Add(p2);
list.Add(p3);
list.Add(p4);
list.Add(p5);
PValue res = BaseCalcu.getTurnN(list);
Console.WriteLine("翻转次数：" + res.Value);
Console.Read();
}
public void testgetTopDown()
{
int a = 6;
Console.WriteLine(5 % 2);
List <PValue> list = new List <PValue>();
PValue p1 = new PValue();
PValue p2 = new PValue();
PValue p3 = new PValue();
PValue p4 = new PValue();
PValue p5 = new PValue();
PValue p6 = new PValue();
PValue p7 = new PValue();
PValue p8 = new PValue();
PValue p9 = new PValue();
PValue p10 = new PValue();
p1.Value = 0;
p2.Value = 5;
p3.Value = 2;
p4.Value = 4;
p5.Value = 2;
p6.Value = 1;
p7.Value = 3;
p8.Value = 3;
p9.Value = 1;
p10.Value = 0;
list.Add(p1);
list.Add(p2);
list.Add(p3);
list.Add(p4);
list.Add(p5);
list.Add(p6);
list.Add(p7);
list.Add(p8);
list.Add(p9);
list.Add(p10);
List <PValue> res = BaseCalcu.getTopDown(list);
Console.WriteLine("最凸点；" + res[0].Value + " 点号：" + res[1].Value + " 最凹点：" + res[2].Value + " 点号：" + res[3].Value);
Console.Read();
}
public void MethodTest()
{
DbHelper helper = new DbHelper();
helper.ConnTest();
String sqlStr = "use psldb;select * from psldata201911 where tagid=10052";// where psltagid=10052";
IDataReader reader = helper.ExecuteReader(sqlStr);
List <PValue> items = new List <PValue>();
while (reader.Read())
{
PValue item = new PValue();
try { item.Tagid = Convert.ToInt32(reader["tagid"]); }
catch { };
try { item.Timestamp = new DateTime(Convert.ToInt64(reader["tagstarttime"])); }
catch { };
try { item.Endtime = new DateTime(Convert.ToInt64(reader["tagendtime"])); }
catch { };
try { item.Value = Convert.ToDouble(reader["tagvalue"]); }
catch { item.Value = 0; };
try { item.Status = Convert.ToInt64(reader["tagstatus"]); }
catch { item.Status = 0; };
Console.WriteLine("value:" + item.Value);
items.Add(item);
}
Console.WriteLine(items.Count);
// MHarMean
PValue Max = BaseCalcu.getMax(items);
PValue Min = BaseCalcu.getMin(items);
Console.WriteLine("最大值：" + Max.Value);
Console.WriteLine("最小值：" + Min.Value);
Console.WriteLine("最大值标签:" + Max.Tagid);
Console.Read();
/*
*
* Console.WriteLine("start test================================");
* DbHelper helper = new DbHelper();
* helper.ConnTest();
* String sqlStr = "use psldb;select * from psldata201911";
* //var sqlTimer = Stopwatch.StartNew(); //用于测试读取一个月分钟数据的sql执行所耗时长。一个月分钟数据45000条左右，在公司服务测试结果是耗时4ms-5ms
* IDataReader reader = helper.ExecuteReader(sqlStr);
* List<PValue> items = new List<PValue>();
* while (reader.Read())
* {
* PValue item = new PValue();
* try { item.Timestamp = new DateTime(Convert.ToInt64(reader["tagstarttime"])); }
* catch { };
* try { item.Endtime = new DateTime(Convert.ToInt64(reader["tagendtime"])); }
* catch { };
* try { item.Value = Convert.ToDouble(reader["tagvalue"]); }
* catch { item.Value = 0; };
* try { item.Status = Convert.ToInt64(reader["tagstatus"]); }
* catch { item.Status = 0; };
* items.Add(item);
*
* }
* Console.WriteLine(items.Count);
* Console.Read();
*/
}
