internal static string EncodeSelectionMode(WorksheetSelectionMode selMode)
{
switch (selMode)
{
default:
case WorksheetSelectionMode.Range: return("range");
case WorksheetSelectionMode.Cell: return("cell");
case WorksheetSelectionMode.None: return("none");
case WorksheetSelectionMode.Row: return("row");
case WorksheetSelectionMode.Column: return("column");
}
}
/// <summary>
/// 初始化ReoGrid表格，注意：只会保留KeyName中Visible=true的列和"ID"列！
/// </summary>
/// <param name="reoGrid"></param>
/// <param name="keyNames"></param>
/// <param name="selectionMode"></param>
public static void InitReoGrid(ReoGridControl reoGrid, KeyName[] keyNames, WorksheetSelectionMode selectionMode = WorksheetSelectionMode.Row)
{
//初始化表格
reoGrid.SetSettings(WorkbookSettings.View_ShowSheetTabControl, false);
var worksheet = reoGrid.Worksheets[0];
worksheet.SelectionMode = selectionMode;
keyNames = (from kn in keyNames where kn.Visible == true || kn.Key == "ID" select kn).ToArray();
for (int i = 0; i < keyNames.Length; i++)
{
worksheet.ColumnHeaders[i].Text = keyNames[i].Name;
worksheet.ColumnHeaders[i].IsVisible = keyNames[i].Visible;
}
worksheet.Columns = keyNames.Length; //限制表的长度
}
