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(); */ }