getDetailsListByDataTable(DataTable dt)
{
List <WarningResultDetail> list = new
List <WarningResultDetail>();
for (int i = 0; i < dt.Rows.Count; i++)
{
WarningResultDetail ent = new WarningResultDetail
{
Id =
dt.Rows[i][PreWarningDetailsViewDbConstName.ID].ToString(),
WarningId =
dt.Rows[i][PreWarningDetailsViewDbConstName.WARNING_ID].ToString(),
HandleStatus =
dt.Rows[i][PreWarningResultDBConstNames.HANDLE_STATUS].ToString(),
DateTime =
dt.Rows[i][PreWarningResultDBConstNames.DATA_TIME].ToString(),
WarningType =
dt.Rows[i][PreWarningResultDBConstNames.WARNING_TYPE].ToString(),
WarningLevel =
dt.Rows[i][PreWarningRulesDbConstNames.WARNING_LEVEL].ToString(),
RuleCode =
dt.Rows[i][PreWarningRulesDbConstNames.RULE_CODE].ToString(),
RuleType =
dt.Rows[i][PreWarningRulesDbConstNames.RULE_TYPE].ToString(),
RuleDescription =
dt.Rows[i][PreWarningRulesDbConstNames.RULE_DESCRIPTION].ToString(),
Threshold =
dt.Rows[i][PreWarningDetailsViewDbConstName.THRESHOLD].ToString(),
ActualValue =
dt.Rows[i][PreWarningDetailsViewDbConstName.ACTUAL_VALUE].ToString(),
Actions =
dt.Rows[i][PreWarningDetailsViewDbConstName.ACTIONS].ToString(),
ActionsPerson =
dt.Rows[i][PreWarningDetailsViewDbConstName.ACTIONS_PERSON].ToString(),
ActionsDateTime =
dt.Rows[i][PreWarningDetailsViewDbConstName.ACTIONS_DATE_TIME].ToString(),
Comments =
dt.Rows[i][PreWarningDetailsViewDbConstName.COMMENTS].ToString(),
CommentsPerson =
dt.Rows[i][PreWarningDetailsViewDbConstName.COMMENTS_PERSON].ToString(),
CommentsDateTime =
dt.Rows[i][PreWarningDetailsViewDbConstName.COMMENTS_DATE_TIME].ToString(),
LiftPerson =
dt.Rows[i][PreWarningDetailsViewDbConstName.LIFT_PERSON].ToString(),
LiftDateTime =
dt.Rows[i][PreWarningDetailsViewDbConstName.LIFT_DATE_TIME].ToString(),
RuleId =
dt.Rows[i][PreWarningDetailsViewDbConstName.RULE_ID].ToString(),
DataId =
dt.Rows[i][PreWarningDetailsViewDbConstName.DATA_ID].ToString()
};
list.Add(ent);
}
return(list);
}
/// <summary>
/// 向指定的FpSpread中添加一行
/// </summary>
/// <param name="entity"></param>
/// <param name="rowType"></param>
private void addOneRowToFpSpread(int rowIdx, WarningResultDetail entity, FpSpread fp)
{
fp.ActiveSheet.Rows.Add(rowIdx, 1);
fp.ActiveSheet.Rows[rowIdx].Height = 30;
fp.ActiveSheet.Rows[rowIdx].Locked = true;
sHandleStatus = entity.HandleStatus;
lblStatus.Text = getReadableHandleStatus(entity.HandleStatus); // 处理状态
// 编号合并信息
var idSpanInfo = new SpanCell(fp);
idSpanInfo.RowIdx = rowIdx;
idSpanInfo.ColIdx = COLUMN_INDEX_ID;
idSpanInfo.SpanColCnt = 1;
idSpanInfo.setText((rowIdx - 1).ToString());
// 时间合并信息
var dateSpanInfo = new SpanCell(fp);
dateSpanInfo.RowIdx = rowIdx;
dateSpanInfo.ColIdx = COLUMN_INDEX_DATE_TIME;
dateSpanInfo.SpanColCnt = 1;
//设置时间
string time = null;
if (entity.DateTime != null)
{
time = entity.DateTime.Split(' ')[1];
}
else
{
time = _txtDateTime.Text;
}
dateSpanInfo.setText(time);
//预警类型合并信息
var warningTypeSpanInfo = new SpanCell(fp);
warningTypeSpanInfo.RowIdx = rowIdx;
warningTypeSpanInfo.ColIdx = COLUMN_INDEX_WANRING_TYPE; //超限/突出
warningTypeSpanInfo.SpanColCnt = 1;
if (entity.WarningType == "0")
{
warningTypeSpanInfo.setText(WarningTypeCHN.超限预警.ToString());
}
if (entity.WarningType == "1")
{
warningTypeSpanInfo.setText(WarningTypeCHN.突出预警.ToString());
}
// 规则类型/预警依据：瓦斯，煤层赋存......
var ruleTypeSpanInfo = new SpanCell(fp);
ruleTypeSpanInfo.RowIdx = rowIdx;
ruleTypeSpanInfo.ColIdx = COLUMN_INDEX_RULE_TYPE;
ruleTypeSpanInfo.SpanColCnt = 1;
ruleTypeSpanInfo.setText(entity.RuleType);
// 预警级别/预警结果
FpUtil.setCellImg(cells[rowIdx, COLUMN_INDEX_WARNING_LEVEL], getWarningLevel(entity.WarningLevel));
//预警编号单元格样式
cells[rowIdx, COLUMN_INDEX_ID].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_ID].VerticalAlignment = CellVerticalAlignment.Center;
//预警类型单元格样式
cells[rowIdx, COLUMN_INDEX_WANRING_TYPE].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_WANRING_TYPE].VerticalAlignment = CellVerticalAlignment.Center;
//预警依据单元格样式
cells[rowIdx, COLUMN_INDEX_RULE_TYPE].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_RULE_TYPE].VerticalAlignment = CellVerticalAlignment.Center;
// 规则编码
cells[rowIdx, COLUMN_INDEX_RULE_CODE].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_RULE_CODE].Locked = true;
cells[rowIdx, COLUMN_INDEX_RULE_CODE].Text = entity.RuleCode;
cells[rowIdx, COLUMN_INDEX_RULE_CODE].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_RULE_CODE].VerticalAlignment = CellVerticalAlignment.Center;
// 时间
cells[rowIdx, COLUMN_INDEX_DATE_TIME].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_DATE_TIME].Locked = true;
cells[rowIdx, COLUMN_INDEX_DATE_TIME].Text = entity.DateTime;
cells[rowIdx, COLUMN_INDEX_DATE_TIME].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_DATE_TIME].VerticalAlignment = CellVerticalAlignment.Center;
//规则描述
cells[rowIdx, COLUMN_INDEX_RULE_DESCRIPTION].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_RULE_DESCRIPTION].Locked = true;
cells[rowIdx, COLUMN_INDEX_RULE_DESCRIPTION].Text = entity.RuleDescription;
cells[rowIdx, COLUMN_INDEX_RULE_DESCRIPTION].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_RULE_DESCRIPTION].VerticalAlignment = CellVerticalAlignment.Center;
//标准值
cells[rowIdx, COLUMN_INDEX_STANDARD_VALUE].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_STANDARD_VALUE].Locked = true;
cells[rowIdx, COLUMN_INDEX_STANDARD_VALUE].Text = entity.Threshold;
cells[rowIdx, COLUMN_INDEX_STANDARD_VALUE].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_STANDARD_VALUE].VerticalAlignment = CellVerticalAlignment.Center;
//实际值
cells[rowIdx, COLUMN_INDEX_ACTUAL_VALUE].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_ACTUAL_VALUE].Locked = true;
cells[rowIdx, COLUMN_INDEX_ACTUAL_VALUE].Text = entity.ActualValue;
cells[rowIdx, COLUMN_INDEX_ACTUAL_VALUE].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_ACTUAL_VALUE].VerticalAlignment = CellVerticalAlignment.Center;
// 解除措施
cells[rowIdx, COLUMN_INDEX_ACTIONS].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_ACTIONS].Locked = isHistory;
cells[rowIdx, COLUMN_INDEX_ACTIONS].Text = entity.Actions;
cells[rowIdx, COLUMN_INDEX_ACTIONS].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_ACTIONS].VerticalAlignment = CellVerticalAlignment.Center;
// 解除措施录入人
cells[rowIdx, COLUMN_INDEX_ACTIONS_PERSON].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_ACTIONS_PERSON].Locked = true; //this.isHistory;
cells[rowIdx, COLUMN_INDEX_ACTIONS_PERSON].Text = entity.ActionsPerson;
cells[rowIdx, COLUMN_INDEX_ACTIONS_PERSON].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_ACTIONS_PERSON].VerticalAlignment = CellVerticalAlignment.Center;
// 解除措施录入时间
cells[rowIdx, COLUMN_INDEX_ACTIONS_DATE_TIME].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_ACTIONS_DATE_TIME].Locked = true; //this.isHistory;
cells[rowIdx, COLUMN_INDEX_ACTIONS_DATE_TIME].Text = entity.ActionsDateTime;
cells[rowIdx, COLUMN_INDEX_ACTIONS_DATE_TIME].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_ACTIONS_DATE_TIME].VerticalAlignment = CellVerticalAlignment.Center;
// 措施评价
cells[rowIdx, COLUMN_INDEX_COMMENTS].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_COMMENTS].Locked = isHistory;
cells[rowIdx, COLUMN_INDEX_COMMENTS].Text = entity.Comments;
cells[rowIdx, COLUMN_INDEX_COMMENTS].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_COMMENTS].VerticalAlignment = CellVerticalAlignment.Center;
// 措施评价人
cells[rowIdx, COLUMN_INDEX_COMMENTS_PERSON].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_COMMENTS_PERSON].Locked = true; //this.isHistory;
cells[rowIdx, COLUMN_INDEX_COMMENTS_PERSON].Text = entity.CommentsPerson;
cells[rowIdx, COLUMN_INDEX_COMMENTS_PERSON].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_COMMENTS_PERSON].VerticalAlignment = CellVerticalAlignment.Center;
// 措施评价日期
cells[rowIdx, COLUMN_INDEX_COMMENTS_DATE_TIME].CellType = new TextCellType();
cells[rowIdx, COLUMN_INDEX_COMMENTS_DATE_TIME].Locked = true; //this.isHistory;
cells[rowIdx, COLUMN_INDEX_COMMENTS_DATE_TIME].Text = entity.CommentsDateTime;
cells[rowIdx, COLUMN_INDEX_COMMENTS_DATE_TIME].HorizontalAlignment = CellHorizontalAlignment.Center;
cells[rowIdx, COLUMN_INDEX_COMMENTS_DATE_TIME].VerticalAlignment = CellVerticalAlignment.Center;
// DataId--此列隐藏
cells[rowIdx, COLUMN_INDEX_HIDE_DATA_ID].Text = entity.Id;
cells[rowIdx, COLUMN_INDEX_HIDE_WARNING_ID].Text = entity.WarningId;
////合并预警类型, 设置预警依据
//warningTypeSpanInfo.applyCellsSpan();
//warningTypeSpanInfo.setText(entity.WarningType);
////合并时间
//dateSpanInfo.SpanRowCnt = warningTypeSpanInfo.SpanRowCnt;
//dateSpanInfo.applyCellsSpan();
////合并编号
//idSpanInfo.SpanRowCnt = warningTypeSpanInfo.SpanRowCnt;
//idSpanInfo.applyCellsSpan();
////设置编号
//idSpanInfo.setText(entity.WirePointName.ToString());
//背景色设置为淡绿
//设置背景颜色,采取白与RGB（200, 250, 160）交替设置
if (!_bChangeBackClolor)
{
for (var iRow = idSpanInfo.RowIdx; iRow < idSpanInfo.RowIdx + idSpanInfo.SpanRowCnt; iRow++)
{
fp.ActiveSheet.Rows[iRow].BackColor = Color.FromArgb(200, 250, 160);
}
fp.ActiveSheet.Rows[rowIdx].BackColor = Color.FromArgb(200, 250, 160);
_bChangeBackClolor = true;
}
else
{
_bChangeBackClolor = false;
}
}
