or
<telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server" Visible="False"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="UPPantalla"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="GridAlbaranes" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="GridAlbaranes"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="GridAlbaranes" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManagerProxy> <div id="box_Cabecera"> <div id="datos_Izquierda"> <ol> <li><asp:Label ID="LblProveedor" runat="server" Text="Proveedor: " Font-Names="Trebuchet MS" Font-Size="Small" CssClass="literal"></asp:Label> <telerik:RadComboBox runat="server" ID="CmbProveedor" DataTextField="LargeName" DataValueField="Account" AllowCustomText="True" width="300px" Filter="Contains" MarkFirstMatch="True" ></telerik:RadComboBox ></li> <li><asp:Label ID="LblAno" runat="server" Text="Año: " Font-Names="Trebuchet MS" Font-Size="Small" CssClass="literal"></asp:Label> <telerik:RadNumericTextBox ID="TxbYear" Runat="server" ShowSpinButtons="True" Font-Names="Trebuchet MS" Font-Size="Small" > <NumberFormat DecimalDigits="0" GroupSeparator="" /> </telerik:RadNumericTextBox></li> </ol> </div> <div id="datos_Derecha"> <ol> <li><asp:Label ID="LblCentro" runat="server" Text="Centro: " Font-Names="Trebuchet MS" Font-Size="Small" CssClass="literal"></asp:Label> <telerik:RadComboBox runat="server" ID="CmbCentro" DataTextField="ProfitCenterLargeName" DataValueField="ProfitCenterCode" AllowCustomText="True" Width="300px" height="200px" Filter="Contains" Skin="Sunset" ></telerik:RadComboBox> </li> <li> <telerik:RadButton ID="BtnSoloSinValidar" runat="server" AutoPostBack="False" BorderStyle="Groove" Checked="True" Skin="Sunset" Text="Solo Albaranes no validados" ToggleType="CheckBox"> </telerik:RadButton></li> </ol> </div></div> <div id="Grid"> <telerik:RadGrid runat="server" Skin="Sunset" Width="90%" ID="GridAlbaranes" AutoGenerateColumns="False" GridLines="None"> <MasterTableView> <CommandItemSettings ExportToPdfText="Export to Pdf" /> <RowIndicatorColumn> <HeaderStyle Width="20px" /> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px" /> </ExpandCollapseColumn> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton"> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn DataField="PCNameComplet" HeaderText="Centro" UniqueName="PCNameComplet"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SupplierName" HeaderText="Proveedor" UniqueName="SupplierName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="IdGRN" HeaderText="Albarán" UniqueName="IdGRN"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Year" HeaderText="Año" UniqueName="year"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Cuenta" HeaderText="Cuenta" UniqueName="Cuenta"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SupplierAccount" HeaderText="Codigo Proveedor" UniqueName="SupplierAccount" Visible="False"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ProfitCenterCode" HeaderText="ProfitCenter" UniqueName="ProfitCenter"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Amount" HeaderText="Importe" UniqueName="Amount"> </telerik:GridBoundColumn> </Columns> <EditFormSettings UserControlName="../UserControl/CuGRN.ascx" EditFormType="WebUserControl"> <EditColumn UniqueName="EditCommandColumn"> </EditColumn> </EditFormSettings> </MasterTableView> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Sunset" EnableImageSprites="True"> </HeaderContextMenu> </telerik:RadGrid> </div>Public Class ListadoAlbaranes Inherits System.Web.UI.Page Protected WithEvents Mymaster As Site Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Mymaster = Me.Master If Not Me.IsPostBack Then LoadCombos() Me.TxbYear.Text = Today.Date.Year CargarGrid() End If End Sub Public Sub LoadCombos() '+----------------------------------------------------- '| Comments: Used to load combos. '+----------------------------------------------------- Dim Usuario As ClUsuario = New ClUsuario Usuario = CType(Session("Usuario"), ClUsuario) Dim c As New AraSql c.SqlServer = Usuario.SqlServer("Cotejador") c.CommandText = "Ara_CargaMaeSupandProfCen" c.Ejecutar() c.Tables(0).Rows.Add("0", "Todos") CmbProveedor.DataSource = c.Tables(0) CmbProveedor.DataBind() CmbProveedor.SelectedValue = "0" c.Tables(1).Rows.Add("0", "Todos") CmbCentro.DataSource = c.Tables(1) CmbCentro.DataBind() CmbCentro.SelectedValue = 0 End Sub Private Sub CargarGrid() Try Dim usuario As ClUsuario = New ClUsuario Dim c As New AraSql c.SqlServer = usuario.SqlServer("Cotejador") c.CommandText = "Ara_ListGRNs" If CmbCentro.SelectedValue <> "0" Then c.NewParameter("@ProfitCenterCode", SqlDbType.VarChar, Me.CmbCentro.SelectedValue) End If If CmbProveedor.SelectedValue <> "0" Then c.NewParameter("@SupplierAccount", SqlDbType.VarChar, Me.CmbProveedor.SelectedValue) End If c.NewParameter("@Onlyopen", SqlDbType.Bit, Me.BtnSoloSinValidar.Checked) c.NewParameter("@year", SqlDbType.VarChar, Me.TxbYear.Value) c.Ejecutar() Me.GridAlbaranes.Dispose() Me.GridAlbaranes.DataSource = c.Tables(0) Catch ex As Exception End Try End Sub Private Sub ReloadGrid() Handles Mymaster.MasterFind GridAlbaranes.DataSource = Nothing GridAlbaranes.Rebind() End Sub Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles GridAlbaranes.NeedDataSource CargarGrid() End Sub End Classprivate void HeaderContextMenu_PreRender(object sender, EventArgs e){ GridHeaderContextMenu menu = sender as GridHeaderContextMenu; foreach (RadMenuItem item in menu.Items) if (item.Text == "Columns") { item.Visible = false; }}| size | date |
| 224 | 1-5-10 |
| 250 | 1-10-10 |
| 156 | 1-22-10 |
| <telerik:RadChart ID="RadChart1" runat="server" DataSourceID="SqlDataSource1" |
| DefaultType="Line" Skin="Default"> |
| <Series> |
| <telerik:ChartSeries Name="Size" DataYColumn="size" Type="Line" |
| DataXColumn="size"> |
| <Appearance> |
| <FillStyle MainColor="213, 247, 255"> |
| </FillStyle> |
| </Appearance> |
| </telerik:ChartSeries> |
| </Series> |
| <PlotArea> |
| <XAxis AutoScale="False" DataLabelsColumn="size"> |
| </XAxis> |
| </PlotArea> |
| </telerik:RadChart> |
<telerik:RadGrid ID="grdReport" runat="server" AllowSorting="True" GridLines="None" AllowPaging="True" Font-Names="Arial" Font-Size="10pt" Skin="Outlook" AllowFilteringByColumn="true" PageSize="30" ShowHeader="false" EnableViewState="true" OnPreRender="grdReport_PreRender" OnNeedDataSource="grdReport_NeedDataSource" OnItemCommand="grdReport_ItemCommand" OnItemCreated="grdReport_ItemCreated"> <ExportSettings IgnorePaging="True" OpenInNewWindow="True"> <Pdf PageWidth="210mm" PageHeight="297mm" Author="VoltTrack" Creator="VoltTrack" Producer="VoltTrack" PageLeftMargin="0.5in" PageRightMargin="0.5in" /> </ExportSettings> <PagerStyle Position="Top"/> <MasterTableView CommandItemDisplay="Top" EnableViewState="true" TableLayout="Fixed"> <PagerStyle Mode="NextPrevNumericAndAdvanced" /> <CommandItemSettings ShowExportToPdfButton="True" ShowAddNewRecordButton="False" /> <ItemTemplate> <%# (((GridItem)Container).ItemIndex != 0)? "</td></tr></table>" : "" %> <asp:Panel ID="ItemContainer" CssClass='<%# (((GridItem)Container).ItemType == GridItemType.Item)? "item" : "alternatingItem" %>' runat="server"> <b><%# Eval("C_Name")%></b> <br /> SSN: <b><%# Eval("SSN")%></b> W/E: <b><%# Eval("Weekend_Date")%></b> <br /> Branch: <b><%# Eval("Branch")%></b> Job#: <b><%# Eval("Job_Number")%></b> <br /> <b><%# Eval("Cust_Name")%></b> </asp:Panel> </ItemTemplate> </MasterTableView> <HeaderStyle HorizontalAlign="Center" /> <ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True"> <Scrolling EnableVirtualScrollPaging="True" /> </ClientSettings> </telerik:RadGrid>protected void grdReport_PreRender(object sender, EventArgs e) { int itemCount = (sender as RadGrid).MasterTableView.GetItems(GridItemType.Item).Length + (sender as RadGrid).MasterTableView.GetItems(GridItemType.AlternatingItem).Length; foreach (GridItem item in (sender as RadGrid).Items) { if (item is GridDataItem && item.ItemIndex < itemCount - 1) { ((item as GridDataItem)["C_Name"] as TableCell).Controls.Add(new LiteralControl("<table style='display:none;width: 730px'><colgroup><col /><col /><col /></colgroup><tr><td>")); } } }| <%@ WebHandler Language="C#" Class="Telerik.Web.Examples.FileExplorer.FilterAndDownloadFiles.Handler" %> |
| using System; |
| using System.Data; |
| using System.Configuration; |
| using System.Web; |
| using System.Text; |
| using Telerik.Web.UI; |
| namespace Telerik.Web.Examples.FileExplorer.FilterAndDownloadFiles |
| { |
| [RadCompressionSettings(HttpCompression = CompressionType.None)] // Disable RadCompression for this page ; |
| public class Handler : IHttpHandler |
| { |
| #region IHttpHandler Members |
| private HttpContext _context; |
| private HttpContext Context |
| { |
| get |
| { |
| return _context; |
| } |
| set |
| { |
| _context = value; |
| } |
| } |
| public void ProcessRequest(HttpContext context) |
| { |
| Context = context; |
| string filePath = context.Request.QueryString["path"]; |
| filePath = context.Server.MapPath(filePath); |
| if (filePath == null) |
| { |
| return; |
| } |
| System.IO.StreamReader streamReader = new System.IO.StreamReader(filePath); |
| System.IO.BinaryReader br = new System.IO.BinaryReader(streamReader.BaseStream); |
| byte[] bytes = new byte[streamReader.BaseStream.Length]; |
| br.Read(bytes, 0, (int)streamReader.BaseStream.Length); |
| if (bytes == null ) |
| { |
| return; |
| } |
| streamReader.Close(); |
| br.Close(); |
| string extension = System.IO.Path.GetExtension(filePath); |
| string fileName = System.IO.Path.GetFileName(filePath); |
| if (extension == ".jpg") |
| { |
| WriteFile(bytes, fileName, "image/jpeg jpeg jpg jpe", context.Response); |
| } |
| else if (extension == ".gif") |
| { |
| WriteFile(bytes, fileName, "image/gif gif", context.Response); |
| } |
| else if (extension == ".png") |
| { |
| WriteFile(bytes, fileName, "image/x-png", context.Response); |
| } |
| else if (extension == ".tif") |
| { |
| WriteFile(bytes, fileName, "image/tiff", context.Response); |
| } |
| else if (extension == ".pdf") |
| { |
| WriteFile(bytes, fileName, "application/pdf", context.Response); |
| } |
| else if (extension == ".png") |
| { |
| WriteFile(bytes, fileName, "image/x-png", context.Response); |
| } |
| else if (extension == ".txt") |
| { |
| WriteFile(bytes, fileName, "text/plain", context.Response); |
| } |
| else if (extension == ".zip") |
| { |
| WriteFile(bytes, fileName, "application/zip", context.Response); |
| } |
| } |
| /// <summary> |
| /// Sends a byte array to the client |
| /// </summary> |
| /// <param name="content">binary file content</param> |
| /// <param name="fileName">the filename to be sent to the client</param> |
| /// <param name="contentType">the file content type</param> |
| private void WriteFile(byte[] content, string fileName, string contentType, HttpResponse response) |
| { |
| response.Buffer = true; |
| response.Clear(); |
| response.ContentType = contentType; |
| response.AddHeader("content-disposition", "attachment; filename=" + fileName); |
| response.BinaryWrite(content); |
| response.Flush(); |
| response.End(); |
| } |
| public bool IsReusable |
| { |
| get |
| { |
| return false; |
| } |
| } |
| #endregion |
| } |
| } |
Riga 109: response.AddHeader("content-disposition", "attachment; filename=" + fileName);
|
