葡萄插件 整理2 数据导出

<%@ Page Title="" Language="C#" MasterPageFile="~/Wijmo.Master" AutoEventWireup="true" CodeBehind="ExportingExcel.aspx.cs" Inherits="ControlExplorer.C1GridView.ExportingExcel" %>

<%@ Register Assembly="C1.Web.Wijmo.Controls.3" Namespace="C1.Web.Wijmo.Controls.C1GridView" TagPrefix="wijmo" %>


<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<wijmo:C1GridView runat="server" ID="C1GridView1" AutogenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<wijmo:C1Band HeaderText="产品信息">
<Columns>
<wijmo:C1BoundField DataField="产品名称" HeaderText="产品名" SortExpression="产品名称">
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="单价" HeaderText="单价" SortExpression="单价">
</wijmo:C1BoundField>
</Columns>
</wijmo:C1Band>
<wijmo:C1Band HeaderText="订单信息">
<Columns>
<wijmo:C1BoundField DataField="数量" HeaderText="数量" SortExpression="数量">
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="折扣" HeaderText="折扣" SortExpression="折扣">
</wijmo:C1BoundField>
</Columns>
</wijmo:C1Band>
<wijmo:C1Band HeaderText="订单细节">
<Columns>
<wijmo:C1BoundField DataField="订购日期" HeaderText="订购日期" SortExpression="订购日期">
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="货主名称" HeaderText="发货源" SortExpression="货主名称">
</wijmo:C1BoundField>
</Columns>
</wijmo:C1Band>




</Columns>
</wijmo:C1GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:C1NWindConnectionString_CN %>" ProviderName="<%$ ConnectionStrings:C1NWindConnectionString_CN.ProviderName %>" SelectCommand="SELECT top 15 [订单明细].订单ID, [订单明细].单价, [订单明细].数量, [订单明细].折扣, 产品.产品名称, 订单.订购日期, 订单.货主名称 FROM ((产品 INNER JOIN [订单明细] ON 产品.产品ID = [订单明细].产品ID) INNER JOIN 订单 ON [订单明细].订单ID = 订单.订单ID)"></asp:SqlDataSource>
<script type="text/javascript">
    $(function() {
        $("#exportExcel").click(exportExcel);
    });


    function exportExcel() {
        var fileName = $("#fileName").val();
        var type = $("#excelFileFormats > option:selected").val();
        var excelSetting = {
            showGridLines: $("#showGridLines").prop('checked'),
            autoRowHeight: $("#autoRowHeight").prop('checked'),
            author: $("#xlsAuthor").val()
        };
        var url = $("#serverUrl").val() + "/exportapi/grid";
        $("#<%=C1GridView1.ClientID%>").c1gridview("exportGrid", fileName, type, excelSetting, url);
    }
</script>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Description" runat="server">
<p>
此示例演示了如何通过设置输出服务来输出<strong>C1GridView</strong>为Excel(Xls/Xlsx)文件。
</p>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="ControlOptions" runat="server">
<div class="settingcontainer">
    <div class="settingcontent">
   <ul>
   <li class="fullwidth"><input type="button" value="输出" id="exportExcel"/></li>
   <li>
   <label>文件格式：</label>
   <select id="excelFileFormats">
   <option selected="selected" value="xls">Xls</option>
   <option value="xlsx">Xlsx</option>
   </select> 
   </li>
   <li><label>作者:</label><input type="text" id="xlsAuthor" value="ComponentOne"/></li>
   <li><input type="checkbox" id="autoRowHeight"/><label class="widelabel">自动行高</label></li>
   <li><input type="checkbox" id="showGridLines" checked="checked"/><label class="widelabel">显示网格线</label></li>
            <li class="longinput">
<label>服务器 Url:</label>
<input type="text" id="serverUrl" value="http://demos.componentone.com/ASPNET/ExportService">
</li>
            <li>
<label>文件名：</label>
<input type="text" id="fileName" value="export">
</li>
   </ul>
    </div>
</div>
</asp:Content>