SPREAD for ASP.NETデモアプリケーション

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Drawing;
using FarPoint.Web.Spread;

public partial class CodeSample_Selection : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
      string js = "var spid='" + FpSpread1.ClientID + "';";
      ClientScript.RegisterStartupScript(this.GetType(), "onStartUpScript", js, true);
      FpSpread1.ButtonCommand += new FarPoint.Web.Spread.SpreadCommandEventHandler(FpSpread1_ButtonCommand);

      if (IsPostBack) return;

      // SPREADの設定
      InitSpread(FpSpread1);

      // シート設定
      InitSheet(FpSpread1.ActiveSheetView);
    }

    private void InitSpread(FarPoint.Web.Spread.FpSpread spread)
    {
        //データ連結
        System.Data.DataSet ds = new System.Data.DataSet();
        ds.ReadXml(MapPath("../App_Data/data50.xml"));
        spread.DataSource = ds;

        spread.CssClass = "spreadStyle";
    }

    private void InitSheet(FarPoint.Web.Spread.SheetView sheet)
    {
      sheet.DefaultStyle.Font.Size = FontUnit.Parse("80%");
      sheet.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%");
      sheet.RowHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%");
      sheet.SheetCorner.DefaultStyle.Font.Size = FontUnit.Parse("80%");

      sheet.ColumnCount = 9;
      sheet.RowCount = 30;
      sheet.PageSize = 30;
    }


    void FpSpread1_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
    {
      if (e.CommandName.StartsWith("SetSelectionGripperBackColor"))
      {
        string[] strCom = e.CommandName.Split('.');

        System.Drawing.Color bc = System.Drawing.ColorTranslator.FromHtml(strCom[1]);
        FpSpread1.TouchInfo.SelectionGripperBackColor = bc;
      }
      else if (e.CommandName.StartsWith("SetSelectionGripperLineColor"))
      {
        string[] strCom = e.CommandName.Split('.');

        System.Drawing.Color bc = System.Drawing.ColorTranslator.FromHtml(strCom[1]);
        FpSpread1.TouchInfo.SelectionGripperLineColor = bc;
      }
      else if (e.CommandName.StartsWith("SetSelectionGripperThickness"))
      {
        string[] strCom = e.CommandName.Split('.');
        if(strCom.Length > 1)
        {
          FpSpread1.TouchInfo.SelectionGripperThickness = Int16.Parse(strCom[1]);
        }
      }
    }
}

Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Drawing
Imports FarPoint.Web.Spread

Partial Public Class CodeSample_Selection
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(sender As Object, e As EventArgs)
        Dim js As String = "var spid='" + FpSpread1.ClientID & "';"
        ClientScript.RegisterStartupScript(Me.[GetType](), "onStartUpScript", js, True)

        If IsPostBack Then
            Return
        End If

        ' SPREADの設定
        InitSpread(FpSpread1)

        'シート設定
        InitSheet(FpSpread1.ActiveSheetView)
    End Sub

    Private Sub InitSpread(spread As FarPoint.Web.Spread.FpSpread)
        'データ連結
        Dim ds As New System.Data.DataSet()
        ds.ReadXml(MapPath("../App_Data/data50.xml"))
        spread.DataSource = ds

        spread.CssClass = "spreadStyle"
    End Sub

    Private Sub InitSheet(sheet As FarPoint.Web.Spread.SheetView)
        sheet.DefaultStyle.Font.Size = FontUnit.Parse("80%")
        sheet.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%")
        sheet.RowHeader.DefaultStyle.Font.Size = FontUnit.Parse("80%")
        sheet.SheetCorner.DefaultStyle.Font.Size = FontUnit.Parse("80%")

        sheet.ColumnCount = 9
        sheet.RowCount = 30
        sheet.PageSize = 30
    End Sub

    Protected Sub FpSpread1_ButtonCommand(sender As Object, e As SpreadCommandEventArgs) Handles FpSpread1.ButtonCommand
        If e.CommandName.StartsWith("SetSelectionGripperBackColor") Then
            Dim strCom As String() = e.CommandName.Split("."c)

            Dim bc As System.Drawing.Color = System.Drawing.ColorTranslator.FromHtml(strCom(1))
            FpSpread1.TouchInfo.SelectionGripperBackColor = bc
        ElseIf e.CommandName.StartsWith("SetSelectionGripperLineColor") Then
            Dim strCom As String() = e.CommandName.Split("."c)

            Dim bc As System.Drawing.Color = System.Drawing.ColorTranslator.FromHtml(strCom(1))
            FpSpread1.TouchInfo.SelectionGripperLineColor = bc
        ElseIf e.CommandName.StartsWith("SetSelectionGripperThickness") Then
            Dim strCom As String() = e.CommandName.Split("."c)
            If strCom.Length > 1 Then
                FpSpread1.TouchInfo.SelectionGripperThickness = Int16.Parse(strCom(1))
            End If
        End If
    End Sub
End Class

<%@ Page MasterPageFile="~/MasterPage.master" Language="c#" AutoEventWireup="true" CodeFile="Selection.aspx.cs" Inherits="CodeSample_Selection" %>

<%@ Register Assembly="FarPoint.Web.SpreadJ" Namespace="FarPoint.Web.Spread" TagPrefix="FarPoint" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeaderPlaceHolder1" runat="Server">
  <script type="text/javascript">
    function SetSelectionGripperBackColor(color) {
      var spread = document.getElementById(spid);
      spread.CallBack("SetSelectionGripperBackColor." + color);
    }
    function SetSelectionGripperLineColor(color) {
      var spread = document.getElementById(spid);
      spread.CallBack("SetSelectionGripperLineColor." + color);
    }
    function SetSelectionGripperThickness(val) {
      var spread = document.getElementById(spid);
      spread.CallBack("SetSelectionGripperThickness." + val);
    }
  </script>

</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <table>
        <tr>
            <td style="width: 200px;">
            選択グリッパーの線の太さ
            </td>
            <td>
              <select style="width: 200px" tabindex="-1" onchange="SetSelectionGripperThickness(this[this.selectedIndex].value);">
              <option value="1">1</option>
              <option value="2" selected="selected">2</option>
              <option value="3">3</option>
              <option value="4">4</option>
              <option value="5">5</option>
              </select>
            </td>
        </tr>
        <tr>
            <td style="width: 200px;">
            選択グリッパーの線の色
            </td>
            <td>
            <select style="width: 200px" tabindex="-1" onchange="SetSelectionGripperLineColor(this[this.selectedIndex].value);">
              <option style="color: #ffffff; background-color: black" value="#000000" selected="selected">Black</option>
              <option style="background-color: #808080" value="#808080">Gray</option>
              <option style="background-color: #A9A9A9" value="#A9A9A9">DarkGray</option>
              <option style="background-color: #D3D3D3" value="#D3D3D3">LightGray</option>
              <option style="background-color: #FFFFFF" value="#FFFFFF">White</option>
              <option style="background-color: #7FFFD4" value="#7FFFD4">Aquamarine</option>
              <option style="background-color: #0000FF" value="#0000FF">Blue</option>
              <option style="color: #ffffff; background-color: #000080" value="#000080">Navy</option>
              <option style="color: #ffffff; background-color: #800080" value="#800080">Purple</option>
              <option style="background-color: #FF1493" value="#FF1493">DeepPink</option>
              <option style="background-color: #EE82EE" value="#EE82EE">Violet</option>
              <option style="background-color: #FFC0CB" value="#FFC0CB">Pink</option>
              <option style="color: #ffffff; background-color: #006400" value="#006400">DarkGreen</option>
              <option style="color: #ffffff; background-color: #008000" value="#008000">Green</option>
              <option style="background-color: #9ACD32" value="#9ACD32">YellowGreen</option>
              <option style="background-color: #FFFF00" value="#FFFF00">Yellow</option>
              <option style="background-color: #FFA500" value="#FFA500">Orange</option>
              <option style="background-color: #FF0000" value="#FF0000">Red</option>
              <option style="background-color: #A52A2A" value="#A52A2A">Brown</option>
              <option style="background-color: #DEB887" value="#DEB887">BurlyWood</option>
              <option style="background-color: #F5F5DC" value="#F5F5DC">Beige</option>
            </select>
            </td>
        </tr>
        <tr>
            <td style="width: 200px;">
            選択グリッパーの背景色
            </td>
            <td>
            <select style="width: 200px" tabindex="-1" onchange="SetSelectionGripperBackColor(this[this.selectedIndex].value);">
              <option style="color: #ffffff; background-color: black" value="#000000">Black</option>
              <option style="background-color: #808080" value="#808080">Gray</option>
              <option style="background-color: #A9A9A9" value="#A9A9A9">DarkGray</option>
              <option style="background-color: #D3D3D3" value="#D3D3D3">LightGray</option>
              <option style="background-color: #FFFFFF" value="#FFFFFF" selected="selected">White</option>
              <option style="background-color: #7FFFD4" value="#7FFFD4">Aquamarine</option>
              <option style="background-color: #0000FF" value="#0000FF">Blue</option>
              <option style="color: #ffffff; background-color: #000080" value="#000080">Navy</option>
              <option style="color: #ffffff; background-color: #800080" value="#800080">Purple</option>
              <option style="background-color: #FF1493" value="#FF1493">DeepPink</option>
              <option style="background-color: #EE82EE" value="#EE82EE">Violet</option>
              <option style="background-color: #FFC0CB" value="#FFC0CB">Pink</option>
              <option style="color: #ffffff; background-color: #006400" value="#006400">DarkGreen</option>
              <option style="color: #ffffff; background-color: #008000" value="#008000">Green</option>
              <option style="background-color: #9ACD32" value="#9ACD32">YellowGreen</option>
              <option style="background-color: #FFFF00" value="#FFFF00">Yellow</option>
              <option style="background-color: #FFA500" value="#FFA500">Orange</option>
              <option style="background-color: #FF0000" value="#FF0000">Red</option>
              <option style="background-color: #A52A2A" value="#A52A2A">Brown</option>
              <option style="background-color: #DEB887" value="#DEB887">BurlyWood</option>
              <option style="background-color: #F5F5DC" value="#F5F5DC">Beige</option>
            </select>
            </td>
        </tr>
    </table>
  
  <FarPoint:FpSpread ID="FpSpread1" runat="server" BorderColor="#A0A0A0" BorderStyle="Solid" BorderWidth="1px">
    <CommandBar BackColor="#F6F6F6" ButtonFaceColor="Control" ButtonHighlightColor="ControlLightLight" ButtonShadowColor="ControlDark"></CommandBar>
    <Sheets>
      <FarPoint:SheetView SheetName="Sheet1"></FarPoint:SheetView>
    </Sheets>
  </FarPoint:FpSpread>

</asp:Content>