/// <summary>
///
/// </summary>
/// <param name="partner"></param>
/// <returns></returns>
public ChartDTO GetTopCustomerChartData(string partner)
{
ChartDTO retVal = new ChartDTO();
try
{
DataSet ds = new ProjectDB(Utility.ConfigurationHelper.GPD_Connection).GetTopCustomerChartData(partner);
if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
retVal.Lines.Add(new LinesDTO()
{
Name = dr["M_NAME"].ToString(),
Dates = new List <string>(new string[] { "" }),
Values = new List <int>(new int[] { Convert.ToInt32(dr["P_COUNT"].ToString()) })
});
}
}
}
catch (Exception exc)
{
log.Error("Unable to get data for top application. ERROR: " + exc.ToString());
}
//retVal.Lines.Add(new LinesDTO()
//{
// Name = "Delta",
// Values = new List<int>(new int[] { 560 })
//});
return(retVal);
}
/*
* // GET: api/values
* [HttpGet("pdf/{grafico}")]
*
* public IActionResult pdf(string grafico, [FromQuery]DateTime? start, [FromQuery]DateTime? end, string filtro, int? id)
* {
* PdfDocument document = null;
* string nome = "";
* switch (grafico.ToUpper())
* {
* case "VOLUNTARIODIADASEMANA":
* document = PfdVoluntarioDiaDaSemana();
* break;
* case "DESPESAPORITEMNOPERIODO":
* document = PfdDespesaPorItemNoPeriodo(start.Value, end.Value, filtro);
* break;
* case "DOACOESMENSAISNOPERIODO":
* document = PfdDoacoesMensaisNoPeriodo(start.Value, end.Value);
* break;
* case "DOACOESMENSAISPORDOADORNOPERIODO":
* document = PfdDoacoesMensaisPorDoadorNoPeriodo(start.Value, end.Value, id.Value);
* break;
*
* }
*
* if (document != null) {
* MemoryStream ms = new MemoryStream();
* document.Save(ms);
* //If the position is not set to '0' then the PDF will be empty.
* ms.Position = 0;
*
* //Download the PDF document in the browser.
* FileStreamResult fileStreamResult = new FileStreamResult(ms, "application/pdf");
* fileStreamResult.FileDownloadName = nome;
* return fileStreamResult;
* }
* return new NoContentResult();
*
*
* }
*
* private PdfDocument PfdDoacoesMensaisPorDoadorNoPeriodo(DateTime value1, DateTime value2, int value3)
* {
* throw new NotImplementedException();
* }
*
* private PdfDocument PfdDoacoesMensaisNoPeriodo(DateTime value1, DateTime value2)
* {
* throw new NotImplementedException();
* }
*
* private PdfDocument PfdDespesaPorItemNoPeriodo(DateTime start, DateTime end, string filtro)
* {
* PdfDocument document;
* PdfPage page;
* Color gray = Color.FromArgb(255, 77, 77, 77);
* Color black = Color.FromArgb(255, 0, 0, 0);
* Color white = Color.FromArgb(255, 255, 255, 255);
* Color violet = Color.FromArgb(255, 151, 108, 174);
*
* var query = from q in _context.Despesa
* where q.Tipo == filtro
* && q.DataDaCompra >= start && q.DataDaCompra <= end
* group q by q.Item into g
* orderby g.Key.Nome
* select new
* {
* item = g.Key,
* valorTotal = g.Sum(v => v.Quantidade * v.ValorUnitario)
* };
*
* document = new PdfDocument();
*
*
* //Setting margin
* document.PageSettings.Margins.All = 0;
* //Adding a new page
* page = document.Pages.Add();
* PdfGraphics g = page.Graphics;
*
* //Creating font instances
* PdfFont headerFont = new PdfStandardFont(PdfFontFamily.TimesRoman, 35);
* PdfFont subHeadingFont = new PdfStandardFont(PdfFontFamily.TimesRoman, 16);
*
*
*
*
*
*
*
*
*
*
*
* return document;
*
* }
*
* private PdfDocument PfdVoluntarioDiaDaSemana()
* {
* throw new NotImplementedException();
* }
*/
private ChartDTO DespesaPorItemNoPeriodo(DateTime start, DateTime end, string filtro)
{
ChartDTO chart = new ChartDTO();
SerieDTO serie = new SerieDTO()
{
Name = "Despesas",
Type = "bar",
datapoints = new List <IDataPoint>()
};
chart.Data.Add(serie);
var query = from q in _context.Despesa
where q.Tipo == filtro &&
q.DataDaCompra >= start && q.DataDaCompra <= end
group q by q.Item.Nome into g
orderby g.Key
select new
{
item = g.Key,
valorTotal = g.Sum(v => v.Quantidade * v.ValorUnitario)
};
foreach (var q in query)
{
serie.datapoints.Add(new DataPointString()
{
x = q.item,
y = q.valorTotal
});
}
return(chart);
}
public object Get(int petId)
{
var Pet = db.Pets.Find(petId);
var Caracacteristic = Pet.Caracteristics.OrderByDescending(x => x.Date).Select(x => new CompareDTO {
Id = x.Id,
Weight = x.Weight,
Height = x.Height,
Date = x.Date
}).ToList();
var References = db.References.Where(x => x.BreedId == Pet.BreedId).Select(x => new CompareDTO {
Id = x.Id,
Height = x.RefHeight,
Weight = x.RefWeight
}).ToList();
var result = new ChartDTO();
result.Caracteristics = Caracacteristic;
result.References = References;
//result.Caracteristic = Caracacteristic.Height;
//result.Caracteristic = Caracacteristic.Weight;
//result.Reference = References.RefHeight;
//result.Reference = References.RefWeight;
//result.CompareHeight = (result.Caracteristic >= result.Reference && result.Caracteristic <= result.Reference);
//result.CompareWeight = (result.Caracteristic >= result.Reference && result.Caracteristic <= result.Reference);
//return result;
return(result);
}
public ChartDTO GetYTDSales()
{
var bLbs = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year > 2016).GroupBy(x => x.Date_2.Value.Month)
.Select(lg => new ChartDTO.SeriesPie.dataitem
{
ordering = lg.Key,
name = lg.Key.ToString(),
y = lg.Sum(w => w.GrossSalesAmt != null ? w.GrossSalesAmt.Value : 0)
}).OrderBy(o => o.ordering).ToArray();
var seriesData1 = new ChartDTO.SeriesPie
{
data = bLbs.ToArray(),
color = "rgba(165,170,217,1)",
name = "Month",
yAxis = 0
};
ChartDTO.SeriesPie[] seriesarray = new ChartDTO.SeriesPie[1];
seriesarray[0] = seriesData1;
//seriesarray[3] = seriesData4;
var cht = new ChartDTO();
cht.ChartSeriesPie = seriesarray;
return(cht);
}
public ChartDTO GetAvgSellingPrice()
{
var bLbs = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year > 2016).GroupBy(x => x.Date_2.Value.Month)
.Select(lg => new ChartDTO.SeriesDec.dataitem
{
ordering = lg.Key,
name = lg.Key.ToString(),
y = lg.Sum(w => w.GrossSalesAmt != null ? w.GrossSalesAmt.Value : 0) / lg.Sum(w => w.NetQtySold != null && w.NetQtySold != 0 ? w.NetQtySold.Value : 1)
}).OrderBy(o => o.ordering).ToArray();
var seriesData1 = new ChartDTO.SeriesDec
{
data = bLbs.ToArray(),
color = "rgba(165,170,217,1)",
name = "ASP",
pointPadding = 0.26M,
pointPlacement = -0.2M,
yAxis = 0
};
ChartDTO.SeriesDec[] seriesarray = new ChartDTO.SeriesDec[1];
seriesarray[0] = seriesData1;
//seriesarray[3] = seriesData4;
var cht = new ChartDTO();
cht.ChartSeriesDec = seriesarray;
return(cht);
}
public List <ChartDTO> TrendChartInfoForDepartment(int DepartmentId, int CategoryId, int StationeryId)
{
List <RequisitionDetail> RequisitionDetailsList = requisitionDetailRepo.GetRequisitionDetailsByDepartmentIdByCategoryIdByStationeryId(DepartmentId, CategoryId, StationeryId);
IEnumerable <SupplierTender> SupplierTendersList = supplierTenderRepo.FindBy(x => x.StationeryId == StationeryId);
List <ChartDTO> chartDTOs = new List <ChartDTO>();
foreach (RequisitionDetail rdl in RequisitionDetailsList)
{
foreach (SupplierTender st in SupplierTendersList)
{
if (rdl.StationeryId == st.StationeryId && rdl.Stationery.CategoryId == CategoryId && rdl.StationeryId == StationeryId && rdl.Requisition.Employee.DepartmentId == DepartmentId)
{
ChartDTO chartDTO = new ChartDTO()
{
RequisitionDetailId = rdl.Id,
RequisitionId = rdl.RequisitionId,
RequisitionStationeryId = rdl.StationeryId,
RequisitionQuantityOrdered = rdl.QuantityOrdered,
RequisitionQuantityDelivered = rdl.QuantityDelivered == null ? 0 : (int)rdl.QuantityDelivered,
RequisitionDateTime = rdl.Requisition.DateTime,
RequisitionEmployeeDepartmentId = rdl.Requisition.Employee.DepartmentId,
RequisitionEmployeeDepartmentName = rdl.Requisition.Employee.Department.DepartmentName,
RequisitionEmployeeId = rdl.Requisition.EmployeeId,
RequisitionEmployeeName = rdl.Requisition.Employee.Name,
RequisitionStationeryCategoryId = rdl.Stationery.CategoryId,
RequisitionStationeryCategoryType = rdl.Stationery.Category.Type,
RequisitionStationeryName = rdl.Stationery.Description,
RequisitionStationeryItemPrice = st.Price,
};
chartDTOs.Add(chartDTO);
}
}
}
return(chartDTOs);
}
/// <summary>
///
/// </summary>
/// <param name="partner"></param>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
/// <returns></returns>
public ChartDTO GetProjectChartData(string partner, string fromDate, string toDate)
{
//dynamic MyDynamic = new System.Dynamic.ExpandoObject();
ChartDTO retVal = new ChartDTO();
try
{
DataSet ds = new ProjectDB(Utility.ConfigurationHelper.GPD_Connection).GetProjectChartData(partner, fromDate, toDate);
if (ds != null && ds.Tables.Count == 1 && ds.Tables[0].Rows.Count > 0)
{
string tempAppType = "";
LinesDTO line = new LinesDTO();
foreach (DataRow dr in ds.Tables[0].Rows)
{
string appType = dr["APP_TYPE"].ToString();
if (appType.ToUpper() != tempAppType)
{
tempAppType = appType.ToUpper();
line = new LinesDTO();
line.Name = appType;
retVal.Lines.Add(line);
}
line.Dates.Add(((DateTime)dr["C_DATE"]).ToString("yyyy-MM-dd"));
line.Values.Add(Convert.ToInt32(dr["P_COUNT"].ToString()));
}
}
}
catch (Exception exc)
{
log.Error("Unable to get data for project-chart. ERROR: " + exc.ToString());
}
return(retVal);
}
private ChartDTO VoluntarioDiaDaSemana()
{
ChartDTO chart = new ChartDTO();
SerieDTO serie = new SerieDTO()
{
Name = "Dias da Semana",
Type = "pie",
datapoints = new List <IDataPoint>()
};
chart.Data.Add(serie);
if (_context.Voluntario.Any())
{
serie.datapoints.Add(new DataPointString()
{
x = "Domingo",
y = _context.Voluntario.Where(q => q.Domingo == true && q.IsDeletado == false).Count()
});
serie.datapoints.Add(new DataPointString()
{
x = "Segunda-feira",
y = _context.Voluntario.Where(q => q.SegundaFeira == true && q.IsDeletado == false).Count()
});
serie.datapoints.Add(new DataPointString()
{
x = "Terça-feira",
y = _context.Voluntario.Where(q => q.TercaFeira == true && q.IsDeletado == false).Count()
});
serie.datapoints.Add(new DataPointString()
{
x = "Quarta-feira",
y = _context.Voluntario.Where(q => q.QuartaFeira == true && q.IsDeletado == false).Count()
});
serie.datapoints.Add(new DataPointString()
{
x = "Quinta-feira",
y = _context.Voluntario.Where(q => q.QuintaFeira == true && q.IsDeletado == false).Count()
});
serie.datapoints.Add(new DataPointString()
{
x = "Sexta-feira",
y = _context.Voluntario.Where(q => q.SextaFeira == true && q.IsDeletado == false).Count()
});
serie.datapoints.Add(new DataPointString()
{
x = "Sábado",
y = _context.Voluntario.Where(q => q.Sabado == true && q.IsDeletado == false).Count()
});
}
return(chart);
}
public void Edit(ChartDTO chart)
{
if (chart == null)
{
throw new ValidationException("Не установлено id класса", "");
}
var mapper = new MapperConfiguration(cfg => cfg.CreateMap <UserDataDTO, UserData>()).CreateMapper();
var _chart = mapper.Map <ChartDTO, Chart>(chart);
Database.Charts.Update(_chart);
Database.Save();
}
private ChartDTO GetSterilizerChartDataInc(SensorDataHeadEntity eHead, DateTime lastReceivedDate)
{
SeriesDTO s1 = GetSeriesInc(eHead, SystemData.MeasurementSensor1, Properties.Resource.SterilizerSeries1, lastReceivedDate);
SeriesDTO s2 = GetSeriesInc(eHead, SystemData.MeasurementSensor2, Properties.Resource.SterilizerSeries2, lastReceivedDate);
SeriesDTO s3 = GetSeriesInc(eHead, SystemData.MeasurementSensor4, Properties.Resource.SterilizerSeries3, lastReceivedDate);
SeriesDTO s4 = GetSeriesInc(eHead, SystemData.MeasurementSensor5, Properties.Resource.SterilizerSeries4, lastReceivedDate);
SeriesDTO s5 = GetSeriesInc(eHead, SystemData.MeasurementSensor6, Properties.Resource.SterilizerSeries5, lastReceivedDate);
SeriesDTO s6 = GetSeriesInc(eHead, SystemData.MeasurementSensor7, Properties.Resource.SterilizerSeries6, lastReceivedDate);
if (s1 == null || s1.Points == null || s1.Points.Count == 0)
{
return(null);
}
MergeSterilizerSensorData();
Dictionary <string, SeriesDTO> dicSeriesTemp = new Dictionary <string, SeriesDTO>();
dicSeriesTemp.Add(Properties.Resource.SterilizerSeries1, s1);
dicSeriesTemp.Add(Properties.Resource.SterilizerSeries2, s2);
Dictionary <string, SeriesDTO> dicSeriesPressure = new Dictionary <string, SeriesDTO>();
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries3, s3);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries4, s4);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries5, s5);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries6, s6);
ChartDTO chartData = new ChartDTO();
string temp = string.Empty;
if (s2 != null && s2.Points.Count > 0)
{
temp = s2.Points[s2.Points.Count - 1].Values[0].ToString("#.0");
}
string p2 = string.Empty;
if (s4 != null && s4.Points.Count > 0)
{
p2 = s4.Points[s4.Points.Count - 1].Values[0].ToString("0");
}
chartData.ChartTitle = GetChartTitle();
chartData.RealtimeInfo = string.Format("温度：{0}\n压力：{1}", temp, p2);
chartData.SeriesDictionary.Add(AxesName.Temperature.ToString(), dicSeriesTemp);
chartData.SeriesDictionary.Add(AxesName.Pressure.ToString(), dicSeriesPressure);
chartData.Comment = GetComment(eHead, s1);
chartData.ErrorData = Utility.GetSensorErrors(eHead, mSyncLast);
return(chartData);
}
public ChartDTO GetChartDataInc(DateTime?lastReceivedDate, bool canChangeHead)
{
//mSyncLast = null;
IsNew = false;
// 刷新状态
SensorHelper <object> helper = new SensorHelper <object>();
mSensor = helper.SelectSingle <SensorEntity>(string.Format("SensorID = '{0}'", mSensor.SensorID.ToString().ToUpper()), string.Empty);
SensorDataHeadBll bllHead = new SensorDataHeadBll();
SensorDataHeadEntity eHead = bllHead.GetNewestSensorDataHeadBySensorID(Sensor.SensorID.ToString().ToUpper());
if (eHead == null)
{
return(null);
}
else
{
if (eHead.IsCompressed != null && eHead.IsCompressed.HasValue && eHead.IsCompressed.Value)
{
ChartDTO chartData = new ChartDTO();
chartData.IsAxisXCustomLabels = false;
chartData.ChartTitle = GetChartTitle();
chartData.IsReset = true;
return(chartData);
}
if (mHeadEntity != null && eHead.SensorDataHeadID == mHeadEntity.SensorDataHeadID && lastReceivedDate != null && lastReceivedDate.HasValue)
{
return(GetChartDataInc(eHead, lastReceivedDate.Value));
}
else
{
if (canChangeHead)
{
mSensorData = null;
ChartDTO dtoChart = GetChartDataByHead(eHead);
dtoChart.IsReset = true;
IsNew = true;
return(dtoChart);
}
else
{
return(null);
}
}
}
}
private ChartDTO GetSterilizerChartData(MonitorCollectDataEntity eHead, IList <MonitorCollectDataEntryEntity> lstDetail)
{
SeriesDTO s1 = GetSeries(lstDetail, "FValue1", Properties.Resource.SterilizerSeries1);
SeriesDTO s2 = GetSeries(lstDetail, "FValue2", Properties.Resource.SterilizerSeries2);
SeriesDTO s3 = GetSeries(lstDetail, "FValue3", Properties.Resource.SterilizerSeries3);
SeriesDTO s4 = GetSeries(lstDetail, "FValue4", Properties.Resource.SterilizerSeries4);
SeriesDTO s5 = GetSeries(lstDetail, "FValue5", Properties.Resource.SterilizerSeries5);
SeriesDTO s6 = GetSeries(lstDetail, "FValue6", Properties.Resource.SterilizerSeries6);
AxesDTO axesTemp = new AxesDTO(AxesName.Temperature.ToString());
axesTemp.AxisYProperty.Add(AxesDTO.AxisProperty.MinValueSerializable.ToString(), Properties.Resource.TempMinValue);
axesTemp.AxisYProperty.Add(AxesDTO.AxisProperty.MaxValueSerializable.ToString(), Properties.Resource.TempMaxValue);
axesTemp.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.TempUnit);
AxesDTO axesPressure = new AxesDTO(AxesName.Pressure.ToString());
if (Properties.Resource.PressureMinValue.Equals(Properties.Resource.PressureMaxValue))
{
axesPressure.AxisYProperty.Add(AxesDTO.AxisProperty.MinValueSerializable.ToString(), Properties.Resource.PressureMinValue);
axesPressure.AxisYProperty.Add(AxesDTO.AxisProperty.MaxValueSerializable.ToString(), Properties.Resource.PressureMaxValue);
}
axesPressure.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.PressureUnit);
Dictionary <string, SeriesDTO> dicSeriesTemp = new Dictionary <string, SeriesDTO>();
dicSeriesTemp.Add(Properties.Resource.SterilizerSeries1, s1);
dicSeriesTemp.Add(Properties.Resource.SterilizerSeries2, s2);
Dictionary <string, SeriesDTO> dicSeriesPressure = new Dictionary <string, SeriesDTO>();
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries3, s3);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries4, s4);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries5, s5);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries6, s6);
ChartDTO chartData = new ChartDTO();
chartData.ChartTitle = GetChartTitle(eHead);
chartData.AxesDictionary.Add(AxesName.Temperature.ToString(), axesTemp);
chartData.AxesDictionary.Add(AxesName.Pressure.ToString(), axesPressure);
chartData.SeriesDictionary.Add(AxesName.Temperature.ToString(), dicSeriesTemp);
chartData.SeriesDictionary.Add(AxesName.Pressure.ToString(), dicSeriesPressure);
chartData.Comment = GetComment(eHead, s1);
return(chartData);
}
public ChartDTO GetChartDataForToday()
{
ChartDTO chartDTO = new ChartDTO();
var testHeaderData = this.GetTestHeadersForToday().GroupBy(x => x.Name).Select(x => x.Key).ToList();
if (testHeaderData.Count == 0)
{
return(chartDTO);
}
chartDTO.labels = new List <string>();
foreach (var item in testHeaderData)
{
chartDTO.labels.Add(item);
}
chartDTO.datasets = new List <ChartDataset>();
chartDTO.datasets.Add(new ChartDataset()
{
label = "Failed", backgroundColor = "#FF6384", data = null, maxBarThickness = 4
});
chartDTO.datasets.Add(new ChartDataset()
{
label = "Success", backgroundColor = "#4BC0C0", data = null, maxBarThickness = 4
});
var testCountFailed = this.GetTestHeadersAll().Where(x => !x.IsTestPassed).GroupBy(x => x.Name).Select(x => new { TestName = x.Key, Count = x.Count() }).ToList();
chartDTO.datasets[0].data = new double[testCountFailed.Count()];
int count = 0;
foreach (var item in testCountFailed)
{
chartDTO.datasets[0].data[count] = item.Count;
count++;
}
var testCountPassed = this.GetTestHeadersAll().Where(x => x.IsTestPassed).GroupBy(x => x.Name).Select(x => new { TestName = x.Key, Count = x.Count() }).ToList();
chartDTO.datasets[1].data = new double[testCountPassed.Count()];
count = 0;
foreach (var item in testCountPassed)
{
chartDTO.datasets[1].data[count] = item.Count;
count++;
}
return(chartDTO);
}
public List <ChartDTO> TrendChartInfoForSupplier(int SupplierId, int CategoryId, int StationeryId)
{
List <PurchaseOrderDetail> PurchaseOrderDetailsList = purchaseOrderDetailRepo.GetPurchaseOrderDetailsBySupplierId(SupplierId);
IEnumerable <SupplierTender> SupplierTendersList = supplierTenderRepo.FindBy(x => x.SupplierId == SupplierId);
List <ChartDTO> chartDTOs = new List <ChartDTO>();
foreach (PurchaseOrderDetail pod in PurchaseOrderDetailsList)
{
foreach (SupplierTender st in SupplierTendersList)
{
if (pod.StationeryId == st.StationeryId && pod.PurchaseOrder.SupplierId == st.SupplierId && pod.Stationery.CategoryId == CategoryId && pod.StationeryId == StationeryId)
{
ChartDTO chartDTO = new ChartDTO()
{
PubchaseOrderDetailId = pod.Id,
PurchaseOrderId = pod.PurchaseOrderId,
SupplierChartStationeryId = pod.StationeryId,
SupplierChartCategoryId = pod.Stationery.Category.Id,
QuantityOrdered = pod.QuantityOrdered,
QuantityDelivered = pod.QuantityDelivered == null ? 0 : (int)pod.QuantityDelivered,
ItemName = pod.Stationery.Description,
ItemType = pod.Stationery.Category.Type,
UnitOfMeasure = pod.Stationery.UnitOfMeasure,
OrderDateTime = pod.PurchaseOrder.OrderDateTime,
SupplierName = pod.PurchaseOrder.Supplier.Name,
ItemUnitPrice = st.Price,
EmployeeId = pod.PurchaseOrder.Employee.Id,
EmployeeName = pod.PurchaseOrder.Employee.Name,
SupplierId = pod.PurchaseOrder.SupplierId,
PurchaseOrderDetailForChart = pod,
EmployeeForChart = pod.PurchaseOrder.Employee,
SupplierForChart = pod.PurchaseOrder.Supplier,
StationeryForChart = pod.Stationery,
PurchaseOrderForChart = pod.PurchaseOrder,
SupplierTenderForChart = st,
CategoryForChart = pod.Stationery.Category,
};
chartDTOs.Add(chartDTO);
}
}
}
return(chartDTOs);
}
private ChartDTO GetWasherChartData(MonitorCollectDataEntity eHead, IList <MonitorCollectDataEntryEntity> lstDetail)
{
SeriesDTO s1 = GetSeries(lstDetail, "FValue1", Properties.Resource.WasherSeries1); //Med
SeriesDTO s2 = GetSeries(lstDetail, "FValue2", Properties.Resource.WasherSeries2); //CT
SeriesDTO s3 = GetSeries(lstDetail, "FValue3", Properties.Resource.WasherSeries3); //CDNo
SeriesDTO s5 = GetSeries(lstDetail, "FValue4", Properties.Resource.WasherSeries5); //Ao
SeriesDTO s4 = GetSeries(lstDetail, "FValue5", Properties.Resource.WasherSeries4); //DosV
AxesDTO axesTemp = new AxesDTO(AxesName.Temperature.ToString());
axesTemp.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.TempUnit);
//axesTemp.SeriesList.Add(sTempIndepCham);
AxesDTO axesAo = new AxesDTO(AxesName.AoValue.ToString());
axesAo.AxisYProperty.Add(AxesDTO.AxisProperty.MinValueSerializable.ToString(), Properties.Resource.A0MinValue);
axesAo.AxisYProperty.Add(AxesDTO.AxisProperty.MaxValueSerializable.ToString(), Properties.Resource.A0MaxValue);
Dictionary <string, SeriesDTO> dicSeriesTemp = new Dictionary <string, SeriesDTO>();
dicSeriesTemp.Add(Properties.Resource.WasherSeries2, s2);
Dictionary <string, SeriesDTO> dicSeriesAo = new Dictionary <string, SeriesDTO>();
dicSeriesAo.Add(Properties.Resource.WasherSeries5, s5);
dicSeriesAo.Add(Properties.Resource.WasherSeries1, s1);
dicSeriesAo.Add(Properties.Resource.WasherSeries3, s3);
dicSeriesAo.Add(Properties.Resource.WasherSeries4, s4);
ChartDTO chartData = new ChartDTO();
chartData.ChartTitle = GetChartTitle(eHead);
chartData.AxesDictionary.Add(AxesName.Temperature.ToString(), axesTemp);
chartData.AxesDictionary.Add(AxesName.AoValue.ToString(), axesAo);
chartData.SeriesDictionary.Add(AxesName.Temperature.ToString(), dicSeriesTemp);
chartData.SeriesDictionary.Add(AxesName.AoValue.ToString(), dicSeriesAo);
chartData.Comment = GetComment(eHead, s1);
//chartData.ErrorData = Utility.GetSensorErrors(eHead, mSyncLast);
return(chartData);
}
public ChartDTO GetChartData()
{
mSyncLast = null;
mDataDic = new Dictionary <string, DataRow[]>();
IsNew = true;
mProgramData = null;
mShowPropertyDic = GetShowPropertyData();
// 刷新状态
SensorHelper <object> helper = new SensorHelper <object>();
mSensor = helper.SelectSingle <SensorEntity>(string.Format("SensorID = '{0}'", mSensor.SensorID.ToString().ToUpper()), string.Empty);
SensorDataHeadBll bllHead = new SensorDataHeadBll();
SensorDataHeadEntity eHead = bllHead.GetNewestSensorDataHeadBySensorID(Sensor.SensorID.ToString().ToUpper());
if (eHead == null)
{
ChartDTO chartData = new ChartDTO();
chartData.ChartTitle = GetChartTitle();
return(chartData);
}
else
{
if (eHead.IsCompressed != null && eHead.IsCompressed.HasValue && eHead.IsCompressed.Value)
{
ChartDTO chartData = new ChartDTO();
chartData.ChartTitle = GetChartTitle();
return(chartData);
}
//SensorDataLineBll bllLine = new SensorDataLineBll();
//mSectionList = bllLine.GetSensorDataLineByDataType(eHead.SensorDataHeadID.ToString(), Utility.GetEnumValue(DataType.Body_SectionTitle));
mProgramData = GetProgramData(eHead);
return(GetChartDataByHead(eHead));
}
}
public ChartDTO GetChartData()
{
//mSyncLast = null;
IsNew = true;
mShowPropertyDic = GetShowPropertyData();
// 刷新状态
SensorHelper <object> helper = new SensorHelper <object>();
mSensor = helper.SelectSingle <SensorEntity>(string.Format("SensorID = '{0}'", mSensor.SensorID.ToString().ToUpper()), string.Empty);
SensorDataHeadBll bllHead = new SensorDataHeadBll();
SensorDataHeadEntity eHead = bllHead.GetNewestSensorDataHeadBySensorID(Sensor.SensorID.ToString().ToUpper());
if (eHead == null)
{
ChartDTO chartData = new ChartDTO();
chartData.IsAxisXCustomLabels = false;
chartData.ChartTitle = GetChartTitle();
return(chartData);
}
else
{
if (eHead.IsCompressed != null && eHead.IsCompressed.HasValue && eHead.IsCompressed.Value)
{
ChartDTO chartData = new ChartDTO();
chartData.IsAxisXCustomLabels = false;
chartData.ChartTitle = GetChartTitle();
return(chartData);
}
return(GetChartDataByHead(eHead));
}
}
public ChartDTO GetYTDGroup()
{
var bLbs = DbContext.AD_WeekData.GroupBy(x => x.AD_WeekEnd)
.Select(lg => new ChartDTO.Series.dataitem
{
name = lg.Key.ToString().Replace(" 12:00AM", ""),
y = lg.Sum(w => w.AD_BudgetLbs != null ? w.AD_BudgetLbs.Value : 0),
drilldown = "BudgetLbs" + lg.Key.ToString().Replace(" 12:00AM", "")
}).ToArray();
var bDollars = DbContext.AD_WeekData.GroupBy(x => x.AD_WeekEnd)
.Select(lg => new ChartDTO.Series.dataitem
{
name = lg.Key.ToString().Replace(" 12:00AM", ""),
y = (int)lg.Sum(w => w.AD_BudgetDollars != null ? w.AD_BudgetDollars.Value : 0),
drilldown = "BudgetDollars" + lg.Key.ToString().Replace(" 12:00AM", "")
}).ToArray();
var aLbs = DbContext.AD_WeekData.GroupBy(x => x.AD_WeekEnd)
.Select(lg => new ChartDTO.Series.dataitem
{
name = lg.Key.ToString().Replace(" 12:00AM", ""),
y = lg.Sum(w => w.AD_ActualLbs != null ? w.AD_ActualLbs.Value : 0),
drilldown = "ActualLbs" + lg.Key.ToString().Replace(" 12:00AM", "")
}).ToArray();
var aDollars = DbContext.AD_WeekData.GroupBy(x => x.AD_WeekEnd)
.Select(lg => new ChartDTO.Series.dataitem
{
name = lg.Key.ToString().Replace(" 12:00AM", ""),
y = (int)lg.Sum(w => w.AD_ActualDollars != null ? w.AD_ActualDollars.Value : 0),
drilldown = "ActualDollars" + lg.Key.ToString().Replace(" 12:00AM", "")
}).ToArray();
var seriesData1 = new ChartDTO.Series
{
data = bLbs.ToArray(),
color = "rgba(165,170,217,1)",
name = "Budget Lbs",
pointPadding = 0.26M,
pointPlacement = -0.2M,
yAxis = 1
};
var seriesData2 = new ChartDTO.Series
{
data = bDollars.ToArray(),
color = "rgba(126,86,134,.9)",
name = "Actual Lbs",
pointPadding = 0.4M,
pointPlacement = -0.2M,
yAxis = 1
};
var seriesData3 = new ChartDTO.Series
{
data = aLbs.ToArray(),
color = "rgba(248,161,63,1)",
name = "Budget Dollars",
pointPadding = 0.26M,
pointPlacement = 0.1M,
yAxis = 1
};
var seriesData4 = new ChartDTO.Series
{
data = aDollars.ToArray(),
color = "rgba(186,60,61,.9)",
name = "Actual Dollars",
pointPadding = 0.4M,
pointPlacement = 0.1M,
yAxis = 1
};
ChartDTO.Series[] seriesarray = new ChartDTO.Series[4];
seriesarray[0] = seriesData1;
seriesarray[1] = seriesData2;
seriesarray[2] = seriesData3;
seriesarray[3] = seriesData4;
var cht = new ChartDTO();
cht.ChartSeries = seriesarray;
//var allDates = DbContext.AD_WeekData.GroupBy(x => x.AD_WeekEnd)
//.Select(lg => lg.FirstOrDefault().AD_WeekEnd);
//ChartDTO.DrillDown thisdd = new ChartDTO.DrillDown();
//foreach (var date in allDates)
//{
// ChartDTO.DrillDown.SeriesItem thisseriesitem = new ChartDTO.DrillDown.SeriesItem();
// thisseriesitem.id = "BudgetLbs" + date.ToString();
// var prods = DbContext.AD_WeekData.Where(x => x.AD_WeekEnd == date).ToList();
//}
return(cht);
}
public ChartDTO GetSalesStats()
{
var bLbs = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year > 2000).GroupBy(x => x.Date_2.Value.Year)
.Select(lg => new ChartDTO.Series.dataitem
{
name = lg.Key.ToString(),
y = lg.Sum(w => w.GrossSalesAmt != null ? w.GrossSalesAmt.Value : 0),
drilldown = "GYear" + lg.Key.ToString()
}).OrderBy(o => o.name).ToArray();
var bDollars = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year > 2000).GroupBy(x => x.Date_2.Value.Year)
.Select(lg => new ChartDTO.Series.dataitem
{
name = lg.Key.ToString(),
y = lg.Sum(w => w.NetSalesAmt != null ? w.NetSalesAmt.Value : 0),
drilldown = "NYear" + lg.Key.ToString()
}).OrderBy(o => o.name).ToArray();
var asps = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year > 2000).GroupBy(x => x.Date_2.Value.Year)
.Select(lg => new ChartDTO.Series.dataitem
{
name = lg.Key.ToString(),
y = lg.Sum(w => w.NetSalesAmt != null ? w.NetSalesAmt.Value : 0) / lg.Sum(w => w.NetQtySold != null ? w.NetQtySold.Value : 0)
}).OrderBy(o => o.name).ToArray();
var aDollars = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year > 2000).GroupBy(x => x.Date_2.Value.Year)
.Select(lg => new ChartDTO.Series.dataitem
{
name = lg.Key.ToString(),
y = lg.Sum(w => w.NetQtySold != null ? w.NetQtySold.Value : 0),
drilldown = "QYear" + lg.Key.ToString()
}).OrderBy(o => o.name).ToArray();
var seriesData1 = new ChartDTO.Series
{
data = bLbs.ToArray(),
color = "rgba(165,170,217,1)",
name = "Gross Sales",
pointPadding = 0.26M,
pointPlacement = -0.2M,
yAxis = 0,
type = "column"
};
var seriesData2 = new ChartDTO.Series
{
data = bDollars.ToArray(),
color = "rgba(126,86,134,.9)",
name = "Net Sales",
pointPadding = 0.4M,
pointPlacement = -0.2M,
yAxis = 0,
type = "column"
};
var seriesData3 = new ChartDTO.Series
{
data = aDollars.ToArray(),
color = "rgba(248,161,63,1)",
name = "Net Quantity",
pointPadding = 0.26M,
pointPlacement = 0.1M,
yAxis = 0,
type = "column"
};
var seriesData4 = new ChartDTO.Series
{
data = asps.ToArray(),
type = "spline",
color = "rgba(186,60,61,.9)",
name = "ASP",
yAxis = 1
};
ChartDTO.Series[] seriesarray = new ChartDTO.Series[4];
seriesarray[0] = seriesData1;
seriesarray[1] = seriesData2;
seriesarray[2] = seriesData3;
seriesarray[3] = seriesData4;
var cht = new ChartDTO();
cht.ChartSeries = seriesarray;
List <ChartDTO.Series> drillDownSeries = new List <ChartDTO.Series>();
foreach (int year in bLbs.Select(x => int.Parse(x.name)))
{
var ddGross = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year == year).GroupBy(x => x.Date_2.Value.Month)
.Select(lg => new ChartDTO.Series.dataitem
{
ordering = lg.Key,
name = lg.Key.ToString(),
y = lg.Sum(w => w.GrossSalesAmt != null ? w.GrossSalesAmt.Value : 0),
drilldown = "Month" + lg.Key.ToString()
}).OrderBy(o => o.ordering).ToArray();
var ddNet = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year == year).GroupBy(x => x.Date_2.Value.Month)
.Select(lg => new ChartDTO.Series.dataitem
{
ordering = lg.Key,
name = lg.Key.ToString(),
y = lg.Sum(w => w.NetSalesAmt != null ? w.NetSalesAmt.Value : 0),
drilldown = "Month" + lg.Key.ToString()
}).OrderBy(o => o.ordering).ToArray();
var ddQty = DbContext.ADAGIOSalesStatitics.Where(x => x.Date_2.Value.Year == year).GroupBy(x => x.Date_2.Value.Month)
.Select(lg => new ChartDTO.Series.dataitem
{
ordering = lg.Key,
name = lg.Key.ToString(),
y = lg.Sum(w => w.NetQtySold != null ? w.NetQtySold.Value : 0),
drilldown = "Month" + lg.Key.ToString()
}).OrderBy(o => o.ordering).ToArray();
var ddseriesData1 = new ChartDTO.Series
{
data = ddGross.ToArray(),
color = "rgba(165,170,217,1)",
name = "Gross Sales",
pointPadding = 0.26M,
pointPlacement = -0.2M,
yAxis = 1,
id = "GYear" + year.ToString()
};
var ddseriesData2 = new ChartDTO.Series
{
data = ddNet.ToArray(),
color = "rgba(126,86,134,.9)",
name = "Net Sales",
pointPadding = 0.4M,
pointPlacement = -0.2M,
yAxis = 1,
id = "NYear" + year.ToString()
};
var ddseriesData3 = new ChartDTO.Series
{
data = ddQty.ToArray(),
color = "rgba(248,161,63,1)",
name = "Net Quantity",
pointPadding = 0.26M,
pointPlacement = 0.1M,
yAxis = 1,
id = "QYear" + year.ToString()
};
drillDownSeries.Add(ddseriesData1);
drillDownSeries.Add(ddseriesData2);
drillDownSeries.Add(ddseriesData3);
}
ChartDTO.DrillDown ddData = new ChartDTO.DrillDown();
ddData.DrillDownSeries = drillDownSeries.ToArray();
cht.DrillDownData = ddData;
return(cht);
}
public ChartDTO GetChartDataInc(DateTime?lastReceivedDate, bool canChangeHead)
{
mSyncLast = null;
mDataDic = new Dictionary <string, DataRow[]>();
IsNew = false;
mProgramData = null;
// 刷新状态
SensorHelper <object> helper = new SensorHelper <object>();
mSensor = helper.SelectSingle <SensorEntity>(string.Format("SensorID = '{0}'", mSensor.SensorID.ToString().ToUpper()), string.Empty);
SensorDataHeadBll bllHead = new SensorDataHeadBll();
SensorDataHeadEntity eHead = bllHead.GetNewestSensorDataHeadBySensorID(Sensor.SensorID.ToString().ToUpper());
if (eHead == null)
{
return(null);
}
else
{
if (mHeadEntity != null && eHead.SensorDataHeadID != mHeadEntity.SensorDataHeadID && !canChangeHead)
{
return(null);
}
if (eHead.IsCompressed != null && eHead.IsCompressed.HasValue && eHead.IsCompressed.Value)
{
if (canChangeHead)
{
ChartDTO chartData = new ChartDTO();
chartData.ChartTitle = GetChartTitle();
chartData.IsReset = true;
return(chartData);
}
else
{
return(null);
}
}
//SensorDataLineBll bllLine = new SensorDataLineBll();
//mSectionList = bllLine.GetSensorDataLineByDataType(eHead.SensorDataHeadID.ToString(), Utility.GetEnumValue(DataType.Body_SectionTitle));
if (mHeadEntity != null && eHead.SensorDataHeadID == mHeadEntity.SensorDataHeadID && lastReceivedDate != null && lastReceivedDate.HasValue)
{
mProgramData = GetProgramDataInc(eHead, lastReceivedDate.Value);
if (Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.Sterilizer)))
{
// 灭菌
return(GetSterilizerChartDataInc(eHead, lastReceivedDate.Value));
}
else if (Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.Washer)))
{
// 清洗
return(GetWasherChartDataInc(eHead, lastReceivedDate.Value));
}
else
{
logger.WarnFormat("未处理的设备类型（[传感器：{0}，设备类型：{1}]）", Sensor.SensorKey, Sensor.SensorType);
return(null);
}
}
else
{
if (canChangeHead)
{
mSensorData = null;
ChartDTO dtoChart = GetChartDataByHead(eHead);
dtoChart.IsReset = true;
IsNew = true;
return(dtoChart);
}
else
{
return(null);
}
}
}
}
private ChartDTO GetChartDataInc(SensorDataHeadEntity eHead, DateTime lastReceivedDate)
{
IList <SensorDataLineEntity> lstLine = null;
SensorHelper <object> helper = new SensorHelper <object>();
if (mIsCompressed)
{
lstLine = mSensorCompressedData.GetSensorDataLine();
}
else
{
string strWhere = string.Empty;
if (CommonValue.DatabaseType == CommonValue.DatabaseFlag.Oracle)
{
strWhere = string.Format("SensorDataHeadID = '{0}' AND to_char(ReceivedDate, 'YYYY-MM-DD HH24:MI:SS.FF3') > '{1}'", eHead.SensorDataHeadID.ToString().ToUpper(), lastReceivedDate.ToString("yyyy-MM-dd HH:mm:ss.fff"));
}
else
{
strWhere = string.Format("SensorDataHeadID = '{0}' AND ReceivedDate > '{1}'", eHead.SensorDataHeadID.ToString().ToUpper(), lastReceivedDate.ToString("yyyy-MM-dd HH:mm:ss.fff"));
}
lstLine = helper.SelectList <SensorDataLineEntity>(strWhere, "ReceivedDate");
}
SeriesDTO sTemperature = null;
SeriesDTO sPressure = null;
SeriesDTO sHumidity = null;
SeriesDTO sVoltage = null;
GetSeriesDto(lstLine, ref sTemperature, ref sPressure, ref sHumidity, ref sVoltage);
MakeSensorData(lstLine);
ChartDTO chartData = new ChartDTO();
chartData.IsAxisXCustomLabels = false;
if (Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.Temperature)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperatureHumidity)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperaturePressure)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperaturePressureAccurate)))
{
// 温度
Dictionary <string, SeriesDTO> dicSeriesTemperature = new Dictionary <string, SeriesDTO>();
dicSeriesTemperature.Add(Properties.Resource.TemperatureSeries, sTemperature);
chartData.SeriesDictionary.Add(Properties.Resource.TemperatureSeries, dicSeriesTemperature);
}
if (Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.Humidity)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperatureHumidity)))
{
// 湿度
Dictionary <string, SeriesDTO> dicSeriesHumidity = new Dictionary <string, SeriesDTO>();
dicSeriesHumidity.Add(Properties.Resource.HumiditySeries, sHumidity);
chartData.SeriesDictionary.Add(Properties.Resource.HumiditySeries, dicSeriesHumidity);
}
if (Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.Pressure)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperaturePressure)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperaturePressureAccurate)))
{
// 气压
Dictionary <string, SeriesDTO> dicSeriesPressure = new Dictionary <string, SeriesDTO>();
dicSeriesPressure.Add(Properties.Resource.PressureSeries, sPressure);
chartData.SeriesDictionary.Add(Properties.Resource.PressureSeries, dicSeriesPressure);
}
chartData.ChartTitle = GetChartTitle();
chartData.RealtimeInfo = GetRealtimeInfo(lstLine);
chartData.Comment = GetComment(chartData.SeriesDictionary);
chartData.ErrorData = null;
return(chartData);
}
private ChartDTO GetChartDataByHead(SensorDataHeadEntity eHead)
{
mHeadEntity = eHead;
if (mHeadEntity == null)
{
return(null);
}
IList <SensorDataLineEntity> lstLine = null;
SensorHelper <object> helper = new SensorHelper <object>();
if (mIsCompressed)
{
lstLine = mSensorCompressedData.GetSensorDataLine();
}
else
{
string strWhere = string.Format("SensorDataHeadID = '{0}'", eHead.SensorDataHeadID.ToString().ToUpper());
lstLine = helper.SelectList <SensorDataLineEntity>(strWhere, "ReceivedDate");
}
SeriesDTO sTemperature = null;
SeriesDTO sPressure = null;
SeriesDTO sHumidity = null;
SeriesDTO sVoltage = null;
GetSeriesDto(lstLine, ref sTemperature, ref sPressure, ref sHumidity, ref sVoltage);
MakeSensorData(lstLine);
ChartDTO chartData = new ChartDTO();
chartData.IsAxisXCustomLabels = false;
if (Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.Temperature)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperatureHumidity)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperaturePressure)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperaturePressureAccurate)))
{
// 温度
AxesDTO axesTemperature = new AxesDTO(Properties.Resource.TemperatureSeries);
axesTemperature.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.TemperatureUnit);
Dictionary <string, SeriesDTO> dicSeriesTemperature = new Dictionary <string, SeriesDTO>();
dicSeriesTemperature.Add(Properties.Resource.TemperatureSeries, sTemperature);
chartData.AxesDictionary.Add(Properties.Resource.TemperatureSeries, axesTemperature);
chartData.SeriesDictionary.Add(Properties.Resource.TemperatureSeries, dicSeriesTemperature);
}
if (Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.Humidity)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperatureHumidity)))
{
// 湿度
AxesDTO axesHumidity = new AxesDTO(Properties.Resource.HumiditySeries);
axesHumidity.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.HumidityUnit);
Dictionary <string, SeriesDTO> dicSeriesHumidity = new Dictionary <string, SeriesDTO>();
dicSeriesHumidity.Add(Properties.Resource.HumiditySeries, sHumidity);
chartData.AxesDictionary.Add(Properties.Resource.HumiditySeries, axesHumidity);
chartData.SeriesDictionary.Add(Properties.Resource.HumiditySeries, dicSeriesHumidity);
}
if (Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.Pressure)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperaturePressure)) ||
Convert.ToInt32(Sensor.SensorType).Equals(Convert.ToInt32(Common.Consts.SensorType.TemperaturePressureAccurate)))
{
// 气压
AxesDTO axesPressure = new AxesDTO(Properties.Resource.PressureSeries);
axesPressure.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.PressureUnit);
Dictionary <string, SeriesDTO> dicSeriesPressure = new Dictionary <string, SeriesDTO>();
dicSeriesPressure.Add(Properties.Resource.PressureSeries, sPressure);
chartData.AxesDictionary.Add(Properties.Resource.PressureSeries, axesPressure);
chartData.SeriesDictionary.Add(Properties.Resource.PressureSeries, dicSeriesPressure);
}
chartData.ChartTitle = GetChartTitle();
chartData.RealtimeInfo = GetRealtimeInfo(lstLine);
chartData.Comment = GetComment(chartData.SeriesDictionary);
chartData.ErrorData = null;
return(chartData);
}
private ChartDTO GetWasherChartData(SensorDataHeadEntity eHead)
{
SeriesDTO s1 = null;
SeriesDTO s2 = null;
SeriesDTO s3 = null;
SeriesDTO s4 = null;
SeriesDTO s5 = null;
if (mIsCompressed)
{
s1 = GetCompressedSeries(eHead, SystemData.MeasurementSensor1, Properties.Resource.WasherSeries1);
s2 = GetCompressedSeries(eHead, SystemData.MeasurementSensor2, Properties.Resource.WasherSeries2);
s3 = GetCompressedSeries(eHead, SystemData.MeasurementSensor3, Properties.Resource.WasherSeries3);
s4 = GetCompressedSeries(eHead, SystemData.MeasurementSensor4, Properties.Resource.WasherSeries4);
s5 = GetCompressedSeries(eHead, SystemData.MeasurementSensor5, Properties.Resource.WasherSeries5);
}
else
{
s1 = GetSeries(eHead, SystemData.MeasurementSensor1, Properties.Resource.WasherSeries1);
s2 = GetSeries(eHead, SystemData.MeasurementSensor2, Properties.Resource.WasherSeries2);
s3 = GetSeries(eHead, SystemData.MeasurementSensor3, Properties.Resource.WasherSeries3);
s4 = GetSeries(eHead, SystemData.MeasurementSensor4, Properties.Resource.WasherSeries4);
s5 = GetSeries(eHead, SystemData.MeasurementSensor5, Properties.Resource.WasherSeries5);
}
MergeWasherSensorData();
AxesDTO axesTemp = new AxesDTO(AxesName.Temperature.ToString());
axesTemp.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.TempUnit);
//axesTemp.SeriesList.Add(sTempIndepCham);
AxesDTO axesAo = new AxesDTO(AxesName.AoValue.ToString());
axesAo.AxisYProperty.Add(AxesDTO.AxisProperty.MinValueSerializable.ToString(), Properties.Resource.A0MinValue);
axesAo.AxisYProperty.Add(AxesDTO.AxisProperty.MaxValueSerializable.ToString(), Properties.Resource.A0MaxValue);
Dictionary <string, SeriesDTO> dicSeriesTemp = new Dictionary <string, SeriesDTO>();
dicSeriesTemp.Add(Properties.Resource.WasherSeries2, s2);
Dictionary <string, SeriesDTO> dicSeriesAo = new Dictionary <string, SeriesDTO>();
dicSeriesAo.Add(Properties.Resource.WasherSeries5, s5);
dicSeriesAo.Add(Properties.Resource.WasherSeries1, s1);
dicSeriesAo.Add(Properties.Resource.WasherSeries3, s3);
dicSeriesAo.Add(Properties.Resource.WasherSeries4, s4);
ChartDTO chartData = new ChartDTO();
string temp = string.Empty;
if (s2 != null && s2.Points.Count > 0)
{
temp = s2.Points[s2.Points.Count - 1].Values[0].ToString("#.0");
}
string a0 = string.Empty;
if (s5 != null && s5.Points.Count > 0)
{
a0 = s5.Points[s5.Points.Count - 1].Values[0].ToString("0");
}
chartData.ChartTitle = GetChartTitle();
chartData.RealtimeInfo = string.Format("温度：{0}\nA0：{1}", temp, a0);
chartData.AxesDictionary.Add(AxesName.Temperature.ToString(), axesTemp);
chartData.AxesDictionary.Add(AxesName.AoValue.ToString(), axesAo);
chartData.SeriesDictionary.Add(AxesName.Temperature.ToString(), dicSeriesTemp);
chartData.SeriesDictionary.Add(AxesName.AoValue.ToString(), dicSeriesAo);
chartData.Comment = GetComment(eHead, s1);
chartData.ErrorData = Utility.GetSensorErrors(eHead, mSyncLast);
return(chartData);
}
private ChartDTO GetSterilizerChartData(SensorDataHeadEntity eHead)
{
SeriesDTO s1 = null;
SeriesDTO s2 = null;
SeriesDTO s3 = null;
SeriesDTO s4 = null;
SeriesDTO s5 = null;
SeriesDTO s6 = null;
if (mIsCompressed)
{
s1 = GetCompressedSeries(eHead, SystemData.MeasurementSensor1, Properties.Resource.SterilizerSeries1);
s2 = GetCompressedSeries(eHead, SystemData.MeasurementSensor2, Properties.Resource.SterilizerSeries2);
s3 = GetCompressedSeries(eHead, SystemData.MeasurementSensor4, Properties.Resource.SterilizerSeries3);
s4 = GetCompressedSeries(eHead, SystemData.MeasurementSensor5, Properties.Resource.SterilizerSeries4);
s5 = GetCompressedSeries(eHead, SystemData.MeasurementSensor6, Properties.Resource.SterilizerSeries5);
s6 = GetCompressedSeries(eHead, SystemData.MeasurementSensor7, Properties.Resource.SterilizerSeries6);
}
else
{
s1 = GetSeries(eHead, SystemData.MeasurementSensor1, Properties.Resource.SterilizerSeries1);
s2 = GetSeries(eHead, SystemData.MeasurementSensor2, Properties.Resource.SterilizerSeries2);
s3 = GetSeries(eHead, SystemData.MeasurementSensor4, Properties.Resource.SterilizerSeries3);
s4 = GetSeries(eHead, SystemData.MeasurementSensor5, Properties.Resource.SterilizerSeries4);
s5 = GetSeries(eHead, SystemData.MeasurementSensor6, Properties.Resource.SterilizerSeries5);
s6 = GetSeries(eHead, SystemData.MeasurementSensor7, Properties.Resource.SterilizerSeries6);
}
MergeSterilizerSensorData();
AxesDTO axesTemp = new AxesDTO(AxesName.Temperature.ToString());
axesTemp.AxisYProperty.Add(AxesDTO.AxisProperty.MinValueSerializable.ToString(), Properties.Resource.TempMinValue);
axesTemp.AxisYProperty.Add(AxesDTO.AxisProperty.MaxValueSerializable.ToString(), Properties.Resource.TempMaxValue);
axesTemp.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.TempUnit);
AxesDTO axesPressure = new AxesDTO(AxesName.Pressure.ToString());
if (!Properties.Resource.PressureMinValue.Equals(Properties.Resource.PressureMaxValue))
{
axesPressure.AxisYProperty.Add(AxesDTO.AxisProperty.MinValueSerializable.ToString(), Properties.Resource.PressureMinValue);
axesPressure.AxisYProperty.Add(AxesDTO.AxisProperty.MaxValueSerializable.ToString(), Properties.Resource.PressureMaxValue);
}
axesPressure.AxisYProperty.Add(AxesDTO.AxisProperty.EndText.ToString(), Properties.Resource.PressureUnit);
Dictionary <string, SeriesDTO> dicSeriesTemp = new Dictionary <string, SeriesDTO>();
dicSeriesTemp.Add(Properties.Resource.SterilizerSeries1, s1);
dicSeriesTemp.Add(Properties.Resource.SterilizerSeries2, s2);
Dictionary <string, SeriesDTO> dicSeriesPressure = new Dictionary <string, SeriesDTO>();
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries3, s3);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries4, s4);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries5, s5);
dicSeriesPressure.Add(Properties.Resource.SterilizerSeries6, s6);
ChartDTO chartData = new ChartDTO();
string temp = string.Empty;
if (s2 != null && s2.Points.Count > 0)
{
temp = s2.Points[s2.Points.Count - 1].Values[0].ToString("#.0");
}
string p2 = string.Empty;
if (s4 != null && s4.Points.Count > 0)
{
p2 = s4.Points[s4.Points.Count - 1].Values[0].ToString("0");
}
chartData.ChartTitle = GetChartTitle();
chartData.RealtimeInfo = string.Format("温度：{0}\n压力：{1}", temp, p2);
chartData.AxesDictionary.Add(AxesName.Temperature.ToString(), axesTemp);
chartData.AxesDictionary.Add(AxesName.Pressure.ToString(), axesPressure);
chartData.SeriesDictionary.Add(AxesName.Temperature.ToString(), dicSeriesTemp);
chartData.SeriesDictionary.Add(AxesName.Pressure.ToString(), dicSeriesPressure);
chartData.Comment = GetComment(eHead, s1);
chartData.ErrorData = Utility.GetSensorErrors(eHead, mSyncLast);
return(chartData);
}
