private DataTable GetProgramData(SensorDataHeadEntity eHead) { DataRow[] rowsProgramNo = null; DataRow[] rowsProgramName = null; DataRow[] rowsProgramPhase = null; if (mIsCompressed) { rowsProgramNo = mSensorCompressedData.GetSensorSeriesValues(SystemData.ProgramNo.ToString()); rowsProgramName = mSensorCompressedData.GetSensorSeriesValues(SystemData.ProgramName.ToString()); rowsProgramPhase = mSensorCompressedData.GetSensorSeriesValues(SystemData.ProgramPhase.ToString()); } else { SensorDataLineValueBll bllLineValue = new SensorDataLineValueBll(); DataTable dtProgramNo = bllLineValue.GetSensorSeriesValues(eHead.SensorDataHeadID.ToString().ToUpper(), SystemData.ProgramNo.ToString()); if (mSyncLast == null) { mSyncLast = Convert.ToDateTime(dtProgramNo.Rows[dtProgramNo.Rows.Count - 1]["ReceivedDate"]); rowsProgramNo = dtProgramNo.Select(); } else { rowsProgramNo = dtProgramNo.Select("ReceivedDate <= '" + mSyncLast.Value.ToString("yyyy-MM-dd HH:mm:ss.fff") + "'"); } DataTable dtProgramName = bllLineValue.GetSensorSeriesValues(eHead.SensorDataHeadID.ToString().ToUpper(), SystemData.ProgramName.ToString()); rowsProgramName = dtProgramName.Select("ReceivedDate <= '" + mSyncLast.Value.ToString("yyyy-MM-dd HH:mm:ss.fff") + "'"); DataTable dtProgramPhase = bllLineValue.GetSensorSeriesValues(eHead.SensorDataHeadID.ToString().ToUpper(), SystemData.ProgramPhase.ToString()); rowsProgramPhase = dtProgramPhase.Select("ReceivedDate <= '" + mSyncLast.Value.ToString("yyyy-MM-dd HH:mm:ss.fff") + "'"); } DataTable dtProgramData = new DataTable("ProgramData"); dtProgramData.Columns.Add("ReceivedDate", typeof(DateTime)); dtProgramData.Columns.Add("SensorDate", typeof(DateTime)); dtProgramData.Columns.Add(Properties.Resource.ProgramNo, typeof(string)); dtProgramData.Columns.Add(Properties.Resource.ProgramName, typeof(string)); dtProgramData.Columns.Add(Properties.Resource.ProgramPhase, typeof(string)); dtProgramData.BeginLoadData(); for (int i = 0; i < rowsProgramNo.Length; i++) { DataRow row = dtProgramData.NewRow(); row["ReceivedDate"] = rowsProgramNo[i]["ReceivedDate"]; row["SensorDate"] = rowsProgramNo[i]["SensorDate"]; row[Properties.Resource.ProgramNo] = rowsProgramNo[i]["ContentString"]; row[Properties.Resource.ProgramName] = rowsProgramName[i]["ContentString"]; row[Properties.Resource.ProgramPhase] = rowsProgramPhase[i]["ContentString"]; dtProgramData.Rows.Add(row); } dtProgramData.EndLoadData(); return(dtProgramData); }
public static IList <ErrorItemDTO> GetSensorErrors(SensorDataHeadEntity eHead, DateTime?dtSyncLast) { SensorDataLineValueBll bllLineValue = new SensorDataLineValueBll(); DataTable dt = bllLineValue.GetSensorSeriesValues(eHead.SensorDataHeadID.ToString().ToUpper(), SystemData.ErrorNo.ToString()); if (dt != null) { DataRow[] rows; if (dtSyncLast == null && !dtSyncLast.HasValue) { rows = dt.Select(); } else { rows = dt.Select("ReceivedDate <= '" + dtSyncLast.Value.ToString("yyyy-MM-dd HH:mm:ss.fff") + "'"); } IList <ErrorItemDTO> lstError = new List <ErrorItemDTO>(); foreach (DataRow row in rows) { ErrorItemDTO item = new ErrorItemDTO(); item.BeginDateTime = ParseHelper.ParseToDateTime(row["SensorDate"]); item.ErrorNo = ParseHelper.ParseString(row["ContentString"]); lstError.Add(item); } return(lstError); } return(null); }
private SeriesDTO GetSeries(SensorDataHeadEntity eHead, SystemData valueType, string seriesName) { SensorDataLineValueBll bllLineValue = new SensorDataLineValueBll(); DataTable dt = bllLineValue.GetSensorSeriesValues(eHead.SensorDataHeadID.ToString().ToUpper(), valueType.ToString()); DataRow[] rows; if (mSyncLast == null) { mSyncLast = Convert.ToDateTime(dt.Rows[dt.Rows.Count - 1]["ReceivedDate"]); rows = dt.Select(); } else { rows = dt.Select("ReceivedDate <= '" + mSyncLast.Value.ToString("yyyy-MM-dd HH:mm:ss.fff") + "'"); } mDataDic.Add(seriesName, rows); return(ToSeriesDTO(eHead, seriesName, rows)); }