<%@ 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>