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);
}
