[已处理] 列SORT问题

点击文件名下载附件

当双击列头时，进入FpsAsset_SortColumnCommand事件，可用FpsAsset.ActiveSheetView.Columns[FpsAsset.ActiveSheetView.ActiveColumn].SortIndicator取排序是升序还是降序好像都不正确。
请问要怎 么解决？

protected void FpsAsset_SortColumnCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
    {
        string sSort = "ASC";

        if (FpsAsset.ActiveSheetView.Columns[FpsAsset.ActiveSheetView.ActiveColumn].SortIndicator == FarPoint.Web.Spread.Model.SortIndicator.Descending)
        {
            sSort = "Desc";

        }

        if (FpsAsset.ActiveSheetView.ActiveColumn == 1)
        {
            ssortby = "[BARCODE] " + sSort;
        }

        else if (FpsAsset.ActiveSheetView.ActiveColumn == 2)
        {
            ssortby = "[INVENTORYNO] " + sSort;
        }
        else if (FpsAsset.ActiveSheetView.ActiveColumn == 3)
        {
            ssortby = "[IDESC] " + sSort;
        }
        else if (FpsAsset.ActiveSheetView.ActiveColumn == 4)
        {
            ssortby = "[CATEGORY_NAME] " + sSort;
        }
        else if (FpsAsset.ActiveSheetView.ActiveColumn == 5)
        {
            ssortby = "[MODEL_NAME] " + sSort;
        }
        else if (FpsAsset.ActiveSheetView.ActiveColumn == 6)
        {
            ssortby = "[ROOM_NAME] " + sSort;
        }
        else if (FpsAsset.ActiveSheetView.ActiveColumn == 7)
        {
            ssortby = "[OWNER_NAME] " + sSort;
        }
        else if (FpsAsset.ActiveSheetView.ActiveColumn == 8)
        {
            ssortby = "[ECASH_VALUE] " + sSort;
        }
        else if (FpsAsset.ActiveSheetView.ActiveColumn == 8)
        {
            ssortby = "[Status] " + sSort;
        }


         toPage(CurrPage);
        
    }