public static LineChartSeries GetWattData(string fromDate, string toDate, string selectedMachineId, string durationType, string durationVal) { double[] Data = null; List <double[]> DataList = new List <double[]>(); List <string> datetimes = new List <string>(); List <double> data = new List <double>(); DateTime fromdateTime = DateTime.Now; DateTime todateTime = DateTime.Now; fromdateTime = DateTime.ParseExact(fromDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture); todateTime = DateTime.ParseExact(toDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture); fromDate = fromdateTime.ToString("yyyy-MM-dd HH:mm:ss"); toDate = todateTime.ToString("yyyy-MM-dd HH:mm:ss"); var WattLineChart = new LineChartSeries(); var WattSeries = new DataSeries(); DataTable dt = DataBaseAccess.GetEnergyData(fromDate, toDate, selectedMachineId); try { if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { datetimes.Add(dt.Rows[i]["gtime"].ToString()); data.Add(Convert.ToDouble(dt.Rows[i]["watt"].ToString())); } for (int i = 0; i < data.Count; i++) { Data = new double[2]; DateTime dtime = new DateTime(); DateTime.TryParseExact(datetimes[i], "dd-MM-yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime); Data[1] = data[i]; Data[0] = (double)(dtime.ToUniversalTime() - new DateTime(1970, 1, 1)).TotalMilliseconds; DataList.Add(Data); } List <long> cat = new List <long>(); WattSeries.data = DataList; WattSeries.name = "Watt"; WattLineChart.series = new List <DataSeries>(); WattLineChart.series.Add(WattSeries); WattLineChart.Category = cat; } else { } } catch (Exception ex) { Logger.WriteErrorLog(ex.Message); } return(WattLineChart); }
public static LineChartSeries GetVoltData(string fromDate, string toDate, string selectedMachineId, string durationType, string durationVal) { double[] DataV1 = null; double[] DataV2 = null; double[] DataV3 = null; List <double[]> DataListV1 = new List <double[]>(); List <double[]> DataListV2 = new List <double[]>(); List <double[]> DataListV3 = new List <double[]>(); //List<string> datetimes = new List<string>(); //List<double> Rdata = new List<double>(); //List<double> Ydata = new List<double>(); //List<double> Bdata = new List<double>(); DateTime fromdateTime = DateTime.Now; DateTime todateTime = DateTime.Now; fromdateTime = DateTime.ParseExact(fromDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture); todateTime = DateTime.ParseExact(toDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture); fromDate = fromdateTime.ToString("yyyy-MM-dd HH:mm:ss"); toDate = todateTime.ToString("yyyy-MM-dd HH:mm:ss"); var VoltLineChart = new LineChartSeries(); var SeriesV1 = new DataSeries(); var SeriesV2 = new DataSeries(); var SeriesV3 = new DataSeries(); DataTable dt = DataBaseAccess.GetEnergyData(fromDate, toDate, selectedMachineId); try { if (dt != null && dt.Rows.Count > 0) { //for (int i = 0; i < dt.Rows.Count; i++) //{ // datetimes.Add(dt.Rows[i]["gtime"].ToString()); // Rdata.Add(Convert.ToDouble(dt.Rows[i]["AmpereR"].ToString())); // Ydata.Add(Convert.ToDouble(dt.Rows[i]["AmpereY"].ToString())); // Bdata.Add(Convert.ToDouble(dt.Rows[i]["AmpereB"].ToString())); //} for (int i = 0; i < dt.Rows.Count; i++) { DataV1 = new double[2]; DataV2 = new double[2]; DataV3 = new double[2]; DateTime dtime = new DateTime(); DateTime.TryParseExact(dt.Rows[i]["gtime"].ToString(), "dd-MM-yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime); DataV1[1] = Convert.ToDouble(dt.Rows[i]["Volt1"].ToString()); DataV1[0] = (double)(dtime.ToUniversalTime() - new DateTime(1970, 1, 1)).TotalMilliseconds; DataListV1.Add(DataV1); DataV2[1] = Convert.ToDouble(dt.Rows[i]["Volt2"].ToString()); DataV2[0] = (double)(dtime.ToUniversalTime() - new DateTime(1970, 1, 1)).TotalMilliseconds; DataListV2.Add(DataV2); DataV3[1] = Convert.ToDouble(dt.Rows[i]["Volt3"].ToString()); DataV3[0] = (double)(dtime.ToUniversalTime() - new DateTime(1970, 1, 1)).TotalMilliseconds; DataListV3.Add(DataV3); } List <long> cat = new List <long>(); SeriesV1.data = DataListV1; SeriesV1.name = "Volt1"; SeriesV2.data = DataListV2; SeriesV2.name = "Volt2"; SeriesV3.data = DataListV3; SeriesV3.name = "Volt3"; VoltLineChart.series = new List <DataSeries>(); VoltLineChart.series.Add(SeriesV1); VoltLineChart.series.Add(SeriesV2); VoltLineChart.series.Add(SeriesV3); VoltLineChart.Category = cat; } else { } } catch (Exception ex) { Logger.WriteErrorLog(ex.Message); } return(VoltLineChart); }
public static LineChartSeries GetAmpereData(string fromDate, string toDate, string selectedMachineId, string durationType, string durationVal) { double[] rData = null; double[] yData = null; double[] bData = null; List <double[]> rDataList = new List <double[]>(); List <double[]> yDataList = new List <double[]>(); List <double[]> bDataList = new List <double[]>(); //List<string> datetimes = new List<string>(); //List<double> Rdata = new List<double>(); //List<double> Ydata = new List<double>(); //List<double> Bdata = new List<double>(); DateTime fromdateTime = DateTime.Now; DateTime todateTime = DateTime.Now; fromdateTime = DateTime.ParseExact(fromDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture); todateTime = DateTime.ParseExact(toDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture); fromDate = fromdateTime.ToString("yyyy-MM-dd HH:mm:ss"); toDate = todateTime.ToString("yyyy-MM-dd HH:mm:ss"); var AmpereLineChart = new LineChartSeries(); var RSeries = new DataSeries(); var YSeries = new DataSeries(); var BSeries = new DataSeries(); DataTable dt = DataBaseAccess.GetEnergyData(fromDate, toDate, selectedMachineId); try { if (dt != null && dt.Rows.Count > 0) { //for (int i = 0; i < dt.Rows.Count; i++) //{ // datetimes.Add(dt.Rows[i]["gtime"].ToString()); // Rdata.Add(Convert.ToDouble(dt.Rows[i]["AmpereR"].ToString())); // Ydata.Add(Convert.ToDouble(dt.Rows[i]["AmpereY"].ToString())); // Bdata.Add(Convert.ToDouble(dt.Rows[i]["AmpereB"].ToString())); //} for (int i = 0; i < dt.Rows.Count; i++) { rData = new double[2]; yData = new double[2]; bData = new double[2]; DateTime dtime = new DateTime(); DateTime.TryParseExact(dt.Rows[i]["gtime"].ToString(), "dd-MM-yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime); rData[1] = Convert.ToDouble(dt.Rows[i]["AmpereR"].ToString()); rData[0] = (double)(dtime.ToUniversalTime() - new DateTime(1970, 1, 1)).TotalMilliseconds; rDataList.Add(rData); yData[1] = Convert.ToDouble(dt.Rows[i]["AmpereY"].ToString()); yData[0] = (double)(dtime.ToUniversalTime() - new DateTime(1970, 1, 1)).TotalMilliseconds; yDataList.Add(yData); bData[1] = Convert.ToDouble(dt.Rows[i]["AmpereB"].ToString()); bData[0] = (double)(dtime.ToUniversalTime() - new DateTime(1970, 1, 1)).TotalMilliseconds; bDataList.Add(bData); } List <long> cat = new List <long>(); RSeries.data = rDataList; RSeries.name = "AmpereR"; YSeries.data = yDataList; YSeries.name = "AmpereY"; BSeries.data = bDataList; BSeries.name = "AmpereB"; AmpereLineChart.series = new List <DataSeries>(); AmpereLineChart.series.Add(RSeries); AmpereLineChart.series.Add(YSeries); AmpereLineChart.series.Add(BSeries); AmpereLineChart.Category = cat; } else { } } catch (Exception ex) { Logger.WriteErrorLog(ex.Message); } return(AmpereLineChart); }