public static void PrepareEventMessage(ExcelResult result, string eventName, bool isCancel)
{
if (isCancel)
{
result.ExcelMessages.Add(GenerateEvent(string.Format("在事件{0}中被取消", eventName), true));
result.Result = ExcelResultType.Canceled;
}
}
public static void PrepareAreaMessage(ExcelResult result, string sheetName, AreaStatus areaStatus, string eventName)
{
switch (areaStatus)
{
case AreaStatus.Canceled:
result.ExcelMessages.Add(ExcelMessageFactory.GenerateEvent(
string.Format("工作表：{0}在事件{1}中被取消", sheetName, eventName), true));
result.Result = ExcelResultType.Canceled;
break;
case AreaStatus.Skip:
result.ExcelMessages.Add(ExcelMessageFactory.GenerateEvent(
string.Format("工作表：{0}在事件{1}中被跳过", sheetName, eventName), false));
break;
}
}
public static bool PrepareCellMessage(ExcelResult result, int iLoopRow, int jLoopCol, CellStatus cellStatus, string eventName)
{
bool breakFromIngore = false;
switch (cellStatus)
{
case CellStatus.Canceled:
result.ExcelMessages.Add(GenerateEvent(
string.Format("第 {0} 行第 {1} 列在事件{2}中被取消", iLoopRow, jLoopCol, eventName), true));
result.Result = ExcelResultType.Canceled;
break;
case CellStatus.IngoreRow:
result.ExcelMessages.Add(GenerateEvent(
string.Format("第 {0} 行第 {1} 列在事件{2}中被忽略", iLoopRow, jLoopCol, eventName), false));
breakFromIngore = true;
break;
}
return(breakFromIngore);
}
public static void PrepareRowMessage(ExcelResult result, int iLoopRow, RowStatus rowStatus, string eventName)
{
switch (rowStatus)
{
case RowStatus.Canceled:
result.ExcelMessages.Add(GenerateEvent(
string.Format("第 {0} 行在事件{1}中被取消", iLoopRow, eventName), true));
result.Result = ExcelResultType.Canceled;
break;
case RowStatus.Finish:
result.ExcelMessages.Add(GenerateEvent(
string.Format("第 {0} 行在事件{1}中被完成", iLoopRow, eventName), false));
break;
case RowStatus.Skip:
result.ExcelMessages.Add(GenerateEvent(
string.Format("第 {0} 行在事件{1}中被跳过", iLoopRow, eventName), false));
break;
}
}