/// <summary>
/// 查询符合时间段的预警信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void _btnQuery_Click(object sender, EventArgs e)
{
//获取选择的时间范围
var dateStartYear = _dtpStartTime.Value.Year.ToString();
var dateStartMonth = _dtpStartTime.Value.Month < 10
? "0" + _dtpStartTime.Value.Month
: _dtpStartTime.Value.Month.ToString();
var dateStartDay = _dtpStartTime.Value.Day < 10
? "0" + _dtpStartTime.Value.Day
: _dtpStartTime.Value.Day.ToString();
var dateEndYear = _dtpEndTime.Value.Year.ToString();
var dateEndMonth = _dtpEndTime.Value.Month < 10
? "0" + _dtpEndTime.Value.Month
: _dtpEndTime.Value.Month.ToString();
var dateEndDay = _dtpEndTime.Value.Day < 10 ? "0" + _dtpEndTime.Value.Day : _dtpEndTime.Value.Day.ToString();
//自行转换成数据库中合适的类型
var dateStart = dateStartYear + "-" + dateStartMonth + "-" + dateStartDay + " 00:00:00";
var dateEnd = dateEndYear + "-" + dateEndMonth + "-" + dateEndDay + " 23:59:59";
//根据日期查询结果
//if (_cbxSelWorkSurface.SelectedItem != null)
//{
var workingFace = _cbxSelWorkSurface.SelectedItem.ToString() == "全部"
? ""
: _cbxSelWorkSurface.SelectedItem.ToString();
PreWarningResultQueryBLL.PreWarningResultSort(dateStart, dateEnd, _tsProgressBar, workingFace,
cbWarningType.SelectedItem.ToString());
//调取填充Farpoint的事件
LoadTunelInformation();
}
/// <summary>
/// 加载巷道信息
/// </summary>
private void LoadTunelInformation()
{
//设置控件是否启用
dataPager1.Enabled = true;
//实例化分页控件
//维护查询结果的记录
//List<PreWarningHistoryResultEnt> historyResultEnt = PreWarningResultQueryBLL.GetSortedPreWarningData();
//int iRecordCount = historyResultEnt == null ? 0 : historyResultEnt.Count;
var iRecordCount = PreWarningResultQueryBLL.GetPreWarningDataCount();
dataPager1.PageControlInit(iRecordCount);
var iStartIndex = dataPager1.getStartIndex();
var iEndIndex = dataPager1.getEndIndex();
//根据分页控件选择数据
var _ents = PreWarningResultQueryBLL.GetSortedPreWarningData(iStartIndex, iEndIndex);
#region 除垃圾数据
while (_fpTunelInfo.ActiveSheet.Rows.Count > 0)
{
_fpTunelInfo.ActiveSheet.Rows.Remove(0, 1);
}
#endregion
if (_ents == null)
{
return;
}
var iSelCnt = _ents.Count;
#region 除垃圾数据
while (_fpTunelInfo.ActiveSheet.Rows.Count > 0)
{
_fpTunelInfo.ActiveSheet.Rows.Remove(0, 1);
}
#endregion
for (var i = 0; i < iSelCnt; i++)
{
//添加新的行
_fpTunelInfo.ActiveSheet.Rows.Add(i, 1);
_fpTunelInfo.ActiveSheet.Rows[i].Height = 30;
_fpTunelInfo.ActiveSheet.Rows[i].Locked = true;
//巷道名称
summaryCells[i, COLUMN_TUNNEL_NAME].Value = _ents[i].TunelName;
summaryCells[i, COLUMN_TUNNEL_NAME].HorizontalAlignment = CellHorizontalAlignment.Center;
summaryCells[i, COLUMN_TUNNEL_NAME].VerticalAlignment = CellVerticalAlignment.Center;
//日期
summaryCells[i, COLUMN_DATE_TIME].Value = _ents[i].DateTime.ToShortDateString();
summaryCells[i, COLUMN_DATE_TIME].HorizontalAlignment = CellHorizontalAlignment.Center;
summaryCells[i, COLUMN_DATE_TIME].VerticalAlignment = CellVerticalAlignment.Center;
//班次
summaryCells[i, COLUMN_DATE_SHIFT].Value = _ents[i].Date_Shift;
summaryCells[i, COLUMN_DATE_SHIFT].HorizontalAlignment = CellHorizontalAlignment.Center;
summaryCells[i, COLUMN_DATE_SHIFT].VerticalAlignment = CellVerticalAlignment.Center;
//超限预警
FpUtil.setCellImg(summaryCells[i, COLUMN_WARNING_RESULT_OVERLIMIT],
_ents[i].OverLimitWarningResult.WarningResult);
//突出预警
FpUtil.setCellImg(summaryCells[i, COLUMN_WARNING_RESULT_OUTBURST],
_ents[i].OutBrustWarningResult.WarningResult);
//瓦斯
FpUtil.setCellImg(summaryCells[i, _iOverLimitGas], _ents[i].OverLimitWarningResult.Gas);
//煤层
FpUtil.setCellImg(summaryCells[i, _iOverLimitCoal], _ents[i].OverLimitWarningResult.Coal);
//地质
FpUtil.setCellImg(summaryCells[i, _iOverLimitGeology], _ents[i].OverLimitWarningResult.Geology);
//通风
FpUtil.setCellImg(summaryCells[i, _iOverLimitVentilation], _ents[i].OverLimitWarningResult.Ventilation);
//管理
FpUtil.setCellImg(summaryCells[i, _iOverLimitManagement], _ents[i].OverLimitWarningResult.Management);
//瓦斯
FpUtil.setCellImg(summaryCells[i, _iOutBurstGas], _ents[i].OutBrustWarningResult.Gas);
//煤层
FpUtil.setCellImg(summaryCells[i, _iOutBurstCoal], _ents[i].OutBrustWarningResult.Coal);
//地质
FpUtil.setCellImg(summaryCells[i, _iOutBurstGeology], _ents[i].OutBrustWarningResult.Geology);
//通风
FpUtil.setCellImg(summaryCells[i, _iOutBurstVentilation], _ents[i].OutBrustWarningResult.Ventilation);
//管理
FpUtil.setCellImg(summaryCells[i, _iOutBurstManagement], _ents[i].OutBrustWarningResult.Management);
//记录巷道ID
summaryCells[i, COLUMN_TUNNEL_ID].Text = _ents[i].TunnelID.ToString().Trim();
}
//设置焦点
_fpTunelInfo.ActiveSheet.SetActiveCell(0, 0);
//传入默认值，使得右侧详细信息随之改变
_fpTunelInfo_SelectionChanged(null, null);
}
