or
col 1 | col 2 | col 3 | col 4
p1 | p2 | p3 | p4 |
c1 | c2 | c3 | c4 |
c1 | c2 | c3 | c4 |
col 1 | col 2 | col 3 |
p1 | p2 | p3 |
c1 | c2 | c3 | c4 |
c1 | c2 | c3 | c4 |
<
telerik:RadGrid
ID
=
"grdNotes"
runat
=
"server"
OnColumnCreated
=
"grdNotes_ColumnCreated"
OnItemCreated
=
"grdNotes_ItemCreated"
OnItemDataBound
=
"grdNotes_ItemDataBound"
OnNeedDataSource
=
"grdNotes_NeedDataSource"
OnPreRender
=
"grdNotes_PreRender"
AutoGenerateColumns
=
"false"
SkinID
=
"HierarchicalGrid"
GridLines
=
"None"
AllowCustomPaging
=
"True"
ShowStatusBar
=
"True"
PageSize
=
"20"
EnableLinqExpressions
=
"False"
Width
=
"99%"
>
<
MasterTableView
HierarchyDefaultExpanded
=
"true"
HierarchyLoadMode
=
"Client"
AllowSorting
=
"true"
DataKeyNames
=
"Id,ParentId,Token,IsRoot,Replies,NoteCreator"
ClientDataKeyNames
=
"Id,ParentId,Token,IsRoot,Replies,NoteCreator"
NoDetailRecordsText
=
""
EnableNoRecordsTemplate
=
"False"
TableLayout
=
"Auto"
Width
=
"100%"
HorizontalAlign
=
"Right"
>
<
SelfHierarchySettings
ParentKeyName
=
"ParentId"
KeyName
=
"Id"
MaximumDepth
=
"20"
/>
<
RowIndicatorColumn
Visible
=
"False"
FilterControlAltText
=
"Filter RowIndicator column"
></
RowIndicatorColumn
>
<
ExpandCollapseColumn
Visible
=
"True"
FilterControlAltText
=
"Filter ExpandColumn column"
></
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridClientSelectColumn
DataTextField
=
"Id"
HeaderAbbr
=
"Select"
HeaderButtonType
=
"TextButton"
HeaderText
=
"Select"
HeaderTooltip
=
"Select/Deselect"
Text
=
"Select"
Visible
=
"false"
UniqueName
=
"asgSelect"
Exportable
=
"false"
>
</
telerik:GridClientSelectColumn
>
<
telerik:GridBoundColumn
DataField
=
"Id"
SortExpression
=
"Id"
UniqueName
=
"Id"
Exportable
=
"true"
>
<
HeaderStyle
Width
=
"50px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Title"
SortExpression
=
"Title"
UniqueName
=
"Title"
Exportable
=
"true"
HtmlEncode
=
"true"
>
<
HeaderStyle
Width
=
"150px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Body"
SortExpression
=
"Body"
UniqueName
=
"Body"
HtmlEncode
=
"False"
Exportable
=
"true"
>
<
HeaderStyle
Width
=
"350px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CreatedBy"
SortExpression
=
"CreatedBy"
UniqueName
=
"CreatedBy"
Exportable
=
"true"
>
<
HeaderStyle
Width
=
"150px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CreatedDate"
SortExpression
=
"CreatedDate"
UniqueName
=
"CreatedOn"
Exportable
=
"true"
>
<
HeaderStyle
Width
=
"150px"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ParentId"
HeaderText
=
"Parent Id"
SortExpression
=
"ParentId"
Exportable
=
"false"
UniqueName
=
"ParentId"
Visible
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"Token"
HeaderText
=
"Token"
SortExpression
=
"Token"
Exportable
=
"false"
UniqueName
=
"Token"
Visible
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"IsRoot"
HeaderText
=
"Is Root"
SortExpression
=
"IsRoot"
Exportable
=
"false"
UniqueName
=
"IsRoot"
Visible
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"Replies"
HeaderText
=
"Replies"
SortExpression
=
"Replies"
Exportable
=
"false"
UniqueName
=
"Replies"
Visible
=
"false"
/>
<
telerik:GridBoundColumn
DataField
=
"NoteCreator"
HeaderText
=
"NoteCreator"
SortExpression
=
"NoteCreator"
Exportable
=
"false"
UniqueName
=
"NoteCreator"
Visible
=
"false"
/>
<
telerik:GridTemplateColumn
UniqueName
=
"Actions"
Visible
=
"false"
Exportable
=
"false"
>
<
ItemTemplate
>
<
telerik:RadToolBar
ID
=
"rtbNoteActions"
runat
=
"server"
SkinID
=
"ActionToolbar"
OnButtonClick
=
"NotesGridToolbarButtonClicked"
OnClientButtonClicking
=
"NoteActionToolbarClicking"
>
<
Items
>
<
telerik:RadToolBarButton
Text
=
"Properties"
CommandName
=
"Properties"
ImageUrl
=
"~/Images/page_view.gif"
/>
<
telerik:RadToolBarButton
Text
=
"Reply"
CommandName
=
"Reply"
ImageUrl
=
"~/Images/page_edit.gif"
/>
<
telerik:RadToolBarButton
Text
=
"Security"
CommandName
=
"Security"
ImageUrl
=
"~/Images/shield16.gif"
/>
<
telerik:RadToolBarButton
Text
=
"Delete"
CommandName
=
"Delete"
ImageUrl
=
"~/Images/delete16.gif"
/>
</
Items
>
</
telerik:RadToolBar
>
</
ItemTemplate
>
<
HeaderStyle
Width
=
"15%"
></
HeaderStyle
>
</
telerik:GridTemplateColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
>
</
EditFormSettings
>
<
PagerStyle
AlwaysVisible
=
"True"
></
PagerStyle
>
</
MasterTableView
>
<
HeaderContextMenu
EnableTheming
=
"True"
>
<
CollapseAnimation
Type
=
"OutQuint"
Duration
=
"200"
></
CollapseAnimation
>
</
HeaderContextMenu
>
<
ExportSettings
ExportOnlyData
=
"True"
IgnorePaging
=
"True"
>
</
ExportSettings
>
<
ClientSettings
Selecting-AllowRowSelect
=
"true"
Resizing-AllowColumnResize
=
"true"
>
<
Selecting
AllowRowSelect
=
"True"
></
Selecting
>
<
ClientEvents
OnRowSelected
=
"NoteRowSelected"
OnRowContextMenu
=
"NoteContextMenu"
OnRowDblClick
=
"grdNotes_OnRowDblClick"
OnGridCreated
=
"NotePageLoad"
OnTableCreated
=
"ResizeAllNoteColumns"
OnColumnResized
=
"ResizeAllNoteColumns"
/>
<
Resizing
AllowColumnResize
=
"True"
></
Resizing
>
</
ClientSettings
>
<
PagerStyle
Position
=
"Bottom"
AlwaysVisible
=
"True"
Mode
=
"NextPrevAndNumeric"
Wrap
=
"False"
BackColor
=
"White"
Font-Size
=
"Large"
/>
</
telerik:RadGrid
>
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DashboardContabilidade.aspx.cs" Inherits="GaragemMaintenance.DashboardContabilidade" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%--<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>--%>
<!DOCTYPE html>
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
id
=
"Head1"
runat
=
"server"
>
<
title
>Dashboard Estapar</
title
>
<
script
src
=
"Scripts/jquery-2.0.3.js"
></
script
>
<%--<
script
src
=
"Scripts/jquery-ui-1.10.3.js"
></
script
>--%>
<%--<
link
href
=
"Content/themes/base/jquery-ui.css"
rel
=
"stylesheet"
type
=
"text/css"
/>--%>
<%--<
link
type
=
"text/css"
rel
=
"stylesheet"
href
=
"Content/themes/css/style.css"
/>--%>
<%--<
link
rel
=
'stylesheet'
type
=
'text/css'
href
=
'Styles/StaticHeader.css'
/>--%>
<
style
>
.hidden
{
display: none;
}
body
{
/*background: #FFF;
color: #000;*/
font: normal normal 12px Verdana, Geneva, Arial, Helvetica, sans-serif;
/*margin: 10px;*/
padding: 0;
}
td
{
font: normal normal 9px Verdana, Geneva, Arial, Helvetica, sans-serif;
}
th
{
font: normal normal 9px Verdana, Geneva, Arial, Helvetica, sans-serif;
}
.ImageButtons
{
padding-top: 5px;
padding-right: 5px;
}
</
style
>
<
script
>
function onRequestStart(sender, args) {
if (args.get_eventTarget().indexOf("Export") >= 0) {
args.set_enableAjax(false);
}
}
</
script
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
style
=
"background-color: white;"
>
<
input
id
=
"scrollPos"
runat
=
"server"
type
=
"hidden"
value
=
"0"
/>
<
div
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
<
Scripts
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQueryInclude.js"
/>
</
Scripts
>
<
Services
>
<
asp:ServiceReference
Path
=
"DataManager.svc"
/>
</
Services
>
</
telerik:RadScriptManager
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
ClientEvents
OnRequestStart
=
"onRequestStart"
/>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"radGrdContabil_GridHeader"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"pnlGrid"
LoadingPanelID
=
"loadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"radGrdContabil"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"radGrdContabil"
LoadingPanelID
=
"loadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"btnFiltrar"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"pnlMain"
LoadingPanelID
=
"loadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"btnExportExcel"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"btnExportExcel"
LoadingPanelID
=
"loadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"btnExportPdf"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"btnExportPdf"
LoadingPanelID
=
"loadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"btnExportWord"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"btnExportWord"
LoadingPanelID
=
"loadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
<
telerik:AjaxSetting
AjaxControlID
=
"btnExportCsv"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"btnExportCsv"
LoadingPanelID
=
"loadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadAjaxLoadingPanel
ID
=
"loadingPanel"
runat
=
"server"
Height
=
"75px"
Width
=
"75px"
Transparency
=
"25"
>
<
img
alt
=
"Carregando..."
style
=
"border:0;"
src='<%= RadAjaxLoadingPanel.GetWebResourceUrl(Page, "Telerik.Web.UI.Skins.Default.Ajax.loading.gif") %>' />
</
telerik:RadAjaxLoadingPanel
>
<
telerik:RadFormDecorator
ID
=
"RadFormDecorator1"
DecoratedControls
=
"All"
runat
=
"server"
Skin
=
"Office2010Silver"
EnableRoundedCorners
=
"true"
/>
<
telerik:RadNotification
ID
=
"radNotification"
runat
=
"server"
EnableRoundedCorners
=
"true"
EnableShadow
=
"true"
Position
=
"Center"
Title
=
"Aviso"
Width
=
"400"
Height
=
"150"
Text
=
"A execução desta consulta sem filtro retorna mais linhas do que o ERP consegue exportar, por favor selecione algum outro filtro."
>
</
telerik:RadNotification
>
<
telerik:RadNotification
ID
=
"radNotificationData"
runat
=
"server"
EnableRoundedCorners
=
"true"
Position
=
"Center"
Title
=
"Aviso"
Width
=
"400"
Height
=
"150"
EnableShadow
=
"true"
Text
=
"A execução desta consulta exige ao menos um filtro de data."
>
</
telerik:RadNotification
>
<
div
>
<
asp:Label
ID
=
"Label1"
runat
=
"server"
Text
=
"DashBoard Contabilidade"
Font-Bold
=
"True"
Font-Size
=
"20pt"
></
asp:Label
>
</
div
>
<
telerik:RadAjaxPanel
runat
=
"server"
ID
=
"pnlMain"
>
<
div
>
<
table
style
=
"width: 1100px"
>
<
tr
>
<
td
>
<
table
class
=
""
style
=
"width: 700px"
>
<
tr
>
<
td
colspan
=
"5"
>
<
p
></
p
>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"4"
>
<
asp:Label
ID
=
"Label5"
runat
=
"server"
Text
=
"Datas:"
></
asp:Label
>
</
td
>
<
td
rowspan
=
"8"
>
<
table
style
=
"width: 150px; position: relative"
>
<
tr
>
<
td
style
=
"width: 50px"
>
<
asp:ImageButton
runat
=
"server"
ID
=
"btnExportExcel"
OnClick
=
"btnExportExcel_Click"
CssClass
=
"ImageButtons"
ImageUrl
=
"~/Images/file-extension-xls-html-icon.png"
/>
</
td
>
<
td
style
=
"width: 50px"
>
<
asp:ImageButton
runat
=
"server"
ID
=
"btnExportPdf"
OnClick
=
"btnExportPdf_Click"
CssClass
=
"ImageButtons"
ImageUrl
=
"~/Images/file-extension-pdf-icon.png"
/>
</
td
>
<
td
style
=
"width: 50px"
>
<
asp:ImageButton
runat
=
"server"
ID
=
"btnExportWord"
OnClick
=
"btnExportWord_Click"
CssClass
=
"ImageButtons"
ImageUrl
=
"~/Images/file-extension-doc-icon.png"
/>
</
td
>
<
td
style
=
"width: 50px"
>
<
asp:ImageButton
runat
=
"server"
ID
=
"btnExportCsv"
OnClick
=
"btnExportCsv_Click"
CssClass
=
"ImageButtons"
ImageUrl
=
"~/Images/file-extension-csv-icon.png"
/>
</
td
>
</
tr
>
</
table
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
asp:Label
ID
=
"Label4"
runat
=
"server"
Text
=
"Mês De:"
></
asp:Label
>
</
td
>
<
td
>
<
telerik:RadMonthYearPicker
ID
=
"mesDe"
runat
=
"server"
Culture
=
"pt-BR"
DateInput-Culture
=
"pt-BR"
DateInput-DateFormat
=
"MM/yyyy"
Skin
=
"Office2010Silver"
MonthYearNavigationSettings-TodayButtonCaption
=
"Hoje"
Width
=
"95px"
/>
</
td
>
<
td
>
<
asp:Label
ID
=
"Label6"
runat
=
"server"
Text
=
"Mês Até:"
></
asp:Label
></
td
>
<
td
>
<
telerik:RadMonthYearPicker
ID
=
"mesAte"
runat
=
"server"
Culture
=
"pt-BR"
DateInput-Culture
=
"pt-BR"
DateInput-DateFormat
=
"MM/yyyy"
Skin
=
"Office2010Silver"
MonthYearNavigationSettings-TodayButtonCaption
=
"Hoje"
Width
=
"95px"
/>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"4"
>
<
asp:Label
ID
=
"Label9"
runat
=
"server"
Text
=
"Contas:"
></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
asp:Label
ID
=
"Label7"
runat
=
"server"
Text
=
"De:"
></
asp:Label
>
</
td
>
<
td
>
<
asp:DropDownList
ID
=
"ddlContasDe"
runat
=
"server"
Font-Size
=
"9px"
Font-Names
=
"Verdana"
DataTextField
=
"Descricao"
DataValueField
=
"CT1_CONTA"
Width
=
"300px"
/>
</
td
>
<
td
>
<
asp:Label
ID
=
"Label8"
runat
=
"server"
Text
=
"Até:"
></
asp:Label
></
td
>
<
td
>
<
asp:DropDownList
ID
=
"ddlContasAte"
runat
=
"server"
Font-Size
=
"9px"
Font-Names
=
"Verdana"
DataTextField
=
"Descricao"
DataValueField
=
"CT1_CONTA"
Width
=
"300px"
/>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"4"
>
<
asp:Label
ID
=
"Label13"
runat
=
"server"
Text
=
"Centro de Custo:"
></
asp:Label
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
asp:Label
ID
=
"Label12"
runat
=
"server"
Text
=
"De:"
></
asp:Label
>
</
td
>
<
td
>
<
asp:DropDownList
ID
=
"ddlCentrosDe"
runat
=
"server"
Font-Size
=
"9px"
Font-Names
=
"Verdana"
DataTextField
=
"Descricao"
DataValueField
=
"CTT_CUSTO"
Width
=
"300px"
/>
</
td
>
<
td
>
<
asp:Label
ID
=
"Label2"
runat
=
"server"
Text
=
"Até:"
></
asp:Label
>
</
td
>
<
td
>
<
asp:DropDownList
ID
=
"ddlCentrosAte"
runat
=
"server"
Font-Size
=
"9px"
Font-Names
=
"Verdana"
DataTextField
=
"Descricao"
DataValueField
=
"CTT_CUSTO"
Width
=
"300px"
/>
</
td
>
</
tr
>
<
tr
>
<
td
style
=
"width: 50px"
></
td
>
<
td
>
<
asp:Button
ID
=
"btnFiltrar"
runat
=
"server"
Text
=
"Filtrar"
OnClick
=
"btnFiltrar_Click"
/>
</
td
>
<
td
>
<
asp:Button
ID
=
"btnLimpar"
runat
=
"server"
Text
=
"Limpar"
OnClick
=
"btnLimpar_Click"
/>
</
td
>
<
td
>
<
asp:Button
ID
=
"btnMenu"
runat
=
"server"
Text
=
"Menu"
OnClick
=
"btnMenu_Click"
/>
</
td
>
</
tr
>
</
table
>
</
td
>
</
tr
>
</
table
>
<
p
></
p
>
<
telerik:RadGrid
ID
=
"radGrdContabil"
runat
=
"server"
Skin
=
"Office2010Blue"
Width
=
"95%"
Height
=
"500px"
AutoGenerateColumns
=
"True"
CellSpacing
=
"0"
GridLines
=
"None"
AllowPaging
=
"true"
ShowHeader
=
"true"
Style
=
"margin-left: 20px"
ShowStatusBar
=
"true"
StatusBarSettings-LoadingText
=
"Carregando"
PageSize
=
"200"
OnSortCommand
=
"radGrdContabil_SortCommand"
OnPageIndexChanged
=
"radGrdContabil_PageIndexChanged"
OnPageSizeChanged
=
"radGrdContabil_PageSizeChanged"
>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"true"
SaveScrollPosition
=
"true"
UseStaticHeaders
=
"true"
/>
</
ClientSettings
>
<
MasterTableView
AutoGenerateColumns
=
"True"
EnableColumnsViewState
=
"false"
AllowSorting
=
"true"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
></
PagerStyle
>
<
NoRecordsTemplate
>
<
div
>Não existem registros para os filtros selecionados!</
div
>
</
NoRecordsTemplate
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
div
>
</
telerik:RadAjaxPanel
>
</
div
>
</
form
>
</
body
>
</
html
>
using
System;
using
System.Collections.Generic;
using
System.Data;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
Telerik.Web.UI;
/* adicionar o namespace para o .NET carregar o método extendido AuthRedirect */
using
Estapar.Security;
using
Estapar.Security.Web;
namespace
GaragemMaintenance
{
public
partial
class
DashboardContabilidade : EstaparPage
{
public
bool
rebind =
false
;
private
const
string
sessionDataID =
"ContabilData"
;
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!Page.IsPostBack)
{
mesDe.SelectedDate = DateTime.Now;
mesAte.SelectedDate = DateTime.Now;
ddlContasDe.DataSource = DAO.GetContasCorrentes();
ddlContasDe.DataBind();
ddlContasDe.Items.Insert(0,
new
ListItem(
"Selecione..."
,
""
));
ddlContasAte.DataSource = DAO.GetContasCorrentes();
ddlContasAte.DataBind();
ddlContasAte.Items.Insert(0,
new
ListItem(
"Selecione..."
,
""
));
ddlCentrosDe.DataSource = DAO.GetCentroCustos();
ddlCentrosDe.DataBind();
ddlCentrosDe.Items.Insert(0,
new
ListItem(
"Selecione..."
,
""
));
ddlCentrosAte.DataSource = DAO.GetCentroCustos();
ddlCentrosAte.DataBind();
ddlCentrosAte.Items.Insert(0,
new
ListItem(
"Selecione..."
,
""
));
FillGrid(
false
);
}
}
private
void
FillGrid(
bool
useCache)
{
DataTable res =
new
DataTable();
try
{
if
(!useCache || Session[sessionDataID] ==
null
)
{
res = DAO.GetDashboardDataContabilCC(mesDe.SelectedDate.Value, mesAte.SelectedDate.Value, ddlContasDe.SelectedValue, ddlContasAte.SelectedValue, ddlCentrosDe.SelectedValue, ddlCentrosAte.SelectedValue);
Session[sessionDataID] = res;
}
else
{
res = (DataTable)Session[sessionDataID];
}
radGrdContabil.DataSource = res;
radGrdContabil.ColumnCreated += radGrdContabil_ColumnCreated;
radGrdContabil.DataBind();
}
catch
(Exception Ex)
{
radNotification.Show(Ex.Message);
}
}
private
bool
NenhumaData()
{
return
((!mesDe.SelectedDate.HasValue) && (!mesAte.SelectedDate.HasValue));
}
protected
void
btnFiltrar_Click(
object
sender, EventArgs e)
{
radNotification.Visible =
false
;
if
(NenhumaData())
{
radNotificationData.Show();
return
;
}
FillGrid(
false
);
}
void
radGrdContabil_ColumnCreated(
object
sender, GridColumnCreatedEventArgs e)
{
var col = e.Column;
if
(col.UniqueName ==
"ExpandColumn"
)
e.Column.Visible =
false
;
if
(col.UniqueName ==
"CONTA"
)
{
col.HeaderStyle.Width =
new
Unit(
"60px"
);
col.HeaderText =
"Conta"
;
}
else
if
(col.UniqueName ==
"DESC_CONTA"
)
{
col.HeaderStyle.Width =
new
Unit(
"250px"
);
col.HeaderText =
"Nome Conta"
;
}
else
if
(col.UniqueName ==
"CENTRO_CUSTO"
)
{
col.HeaderStyle.Width =
new
Unit(
"60px"
);
col.HeaderText =
"Centro"
;
}
else
if
(col.UniqueName ==
"DESC_CC"
)
{
col.HeaderStyle.Width =
new
Unit(
"250px"
);
col.HeaderText =
"Nome Centro"
;
}
else
if
(col.UniqueName ==
"TOTAL"
)
{
col.HeaderStyle.Width =
new
Unit(
"60px"
);
col.HeaderText =
"Total"
;
}
else
if
(col.UniqueName.StartsWith(
"M"
))
{
col.HeaderStyle.Width =
new
Unit(
"60px"
);
col.HeaderText = col.UniqueName.Remove(0, 1).Insert(4,
"-"
);
}
}
protected
void
btnLimpar_Click(
object
sender, EventArgs e)
{
mesDe.SelectedDate = DateTime.Now;
mesAte.SelectedDate = DateTime.Now;
ddlContasDe.SelectedIndex = 0;
ddlContasAte.SelectedIndex = 0;
ddlCentrosDe.SelectedIndex = 0;
ddlCentrosAte.SelectedIndex = 0;
}
private
RadGrid PrepareGridToExport()
{
rebind =
true
;
FillGrid(
true
);
RadGrid gv = radGrdContabil;
gv.ExportSettings.OpenInNewWindow =
true
;
gv.ExportSettings.UseItemStyles =
true
;
gv.ExportSettings.ExportOnlyData =
true
;
gv.ExportSettings.FileName =
"ControleContabil"
;
gv.ExportSettings.IgnorePaging =
true
;
gv.MasterTableView.AllowPaging =
false
;
return
gv;
}
protected
void
btnExportExcel_Click(
object
sender, ImageClickEventArgs e)
{
RadGrid gv = PrepareGridToExport();
if
(gv !=
null
)
{
gv.ExportSettings.Excel.Format = GridExcelExportFormat.Biff;
gv.MasterTableView.ExportToExcel();
}
}
protected
void
btnExportPdf_Click(
object
sender, ImageClickEventArgs e)
{
RadGrid gv = PrepareGridToExport();
if
(gv !=
null
)
{
gv.ExportSettings.Pdf.FontType = Telerik.Web.Apoc.Render.Pdf.FontType.Subset;
gv.ExportSettings.Pdf.PaperSize = GridPaperSize.Letter;
gv.ExportSettings.Pdf.PageHeight = Unit.Parse(
"210mm"
);
gv.ExportSettings.Pdf.PageWidth = Unit.Parse(
"397mm"
);
gv.ExportSettings.Pdf.Title =
"DashBoard"
;
gv.MasterTableView.ExportToPdf();
}
}
protected
void
btnExportWord_Click(
object
sender, ImageClickEventArgs e)
{
RadGrid gv = PrepareGridToExport();
if
(gv !=
null
)
gv.MasterTableView.ExportToWord();
}
protected
void
btnExportCsv_Click(
object
sender, ImageClickEventArgs e)
{
RadGrid gv = PrepareGridToExport();
if
(gv !=
null
)
gv.MasterTableView.ExportToCSV();
}
protected
void
radGrdContabil_PageIndexChanged(
object
sender, GridPageChangedEventArgs e)
{
radGrdContabil.CurrentPageIndex = e.NewPageIndex;
FillGrid(
true
);
}
protected
void
radGrdContabil_SortCommand(
object
sender, GridSortCommandEventArgs e)
{
//radGrdContabil.MasterTableView.SortExpressions.Add(e.NewSortOrder);
FillGrid(
true
);
}
protected
void
radGrdContabil_PageSizeChanged(
object
sender, GridPageSizeChangedEventArgs e)
{
//radGrdContabil.PageSize = e.NewPageSize;
FillGrid(
true
);
}
protected
void
btnMenu_Click(
object
sender, EventArgs e)
{
Response.AuthRedirect(
"Menu.aspx"
,
this
.UsuarioLogado.UserName);
}
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
></
title
>
<
telerik:RadStyleSheetManager
ID
=
"RadStyleSheetManager1"
runat
=
"server"
/>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
<
Scripts
>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQueryInclude.js"
/>
</
Scripts
>
</
telerik:RadScriptManager
>
<
script
type
=
"text/javascript"
>
//Put your JavaScript code here.
</
script
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
</
telerik:RadAjaxManager
>
<
div
>
<
telerik:RadGrid
ID
=
"RadGridOtherMembersStateList"
runat
=
"server"
Width
=
"100%"
OnItemDataBound
=
"RadGridOtherMembersStateList_ItemDataBound"
>
<
MasterTableView
AutoGenerateColumns
=
"false"
AllowSorting
=
"false"
AllowPaging
=
"false"
AllowNaturalSort
=
"false"
AllowCustomPaging
=
"false"
AllowCustomSorting
=
"false"
CommandItemDisplay
=
"None"
TableLayout
=
"Auto"
>
<
Columns
>
<
telerik:GridHyperLinkColumn
HeaderText
=
"State"
DataTextField
=
"StateName"
UniqueName
=
"StateName"
ItemStyle-HorizontalAlign
=
"Left"
>
</
telerik:GridHyperLinkColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Count"
DataField
=
"StateCount"
UniqueName
=
"StateCount"
HeaderStyle-Width
=
"100"
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-HorizontalAlign
=
"Right"
>
</
telerik:GridBoundColumn
>
</
Columns
>
<
NoRecordsTemplate
>
<
div
class
=
"divNoRecordsTemplateLayout"
>
No records found.
</
div
>
</
NoRecordsTemplate
>
</
MasterTableView
>
<
ClientSettings
>
<
Scrolling
AllowScroll
=
"true"
UseStaticHeaders
=
"true"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
</
div
>
</
form
>
</
body
>
</
html
>
This is the code in the .aspx page
<
asp:Button
ID
=
"Button1"
runat
=
"server"
Text
=
"Exportar a Excel"
onclick
=
"Button1_Click"
/>
<
br
/><
br
/>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
>
</
telerik:RadGrid
>
//This is the .aspx.cs code
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!IsPostBack)
{
ds = obj_concentrador.ALE_ConcentradorLogros_Select(
"7"
,
"2011"
,
"6"
,
"1"
,
"1"
);
RadGrid1.DataSource = ds.Tables[0].DefaultView;
RadGrid1.MasterTableView.DataKeyNames =
new
string
[] {
"Alum_Id"
};
RadGrid1.ExportSettings.HideStructureColumns =
false
;
RadGrid1.ExportSettings.ExportOnlyData =
false
;
RadGrid1.ExportSettings.IgnorePaging =
true
;
RadGrid1.ExportSettings.OpenInNewWindow =
true
;
RadGrid1.ExportSettings.FileName =
"Concentrador"
;
//RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Html;
RadGrid1.Width = Unit.Percentage(98);
RadGrid1.PageSize = 5;
RadGrid1.AllowPaging =
true
;
RadGrid1.PagerStyle.Mode = GridPagerMode.NextPrevAndNumeric;
RadGrid1.AutoGenerateColumns =
false
;
RadGrid1.ShowHeader =
true
;
RadGrid1.ShowStatusBar =
true
;
//Add Customers table
RadGrid1.MasterTableView.PageSize = 50;
RadGrid1.MasterTableView.Width = Unit.Percentage(100);
RadGrid1.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Top;
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToWordButton =
false
;
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToExcelButton =
true
;
RadGrid1.MasterTableView.CommandItemSettings.ExportToExcelText =
"Exportar a Excel"
;
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToPdfButton =
true
;
RadGrid1.MasterTableView.CommandItemSettings.ExportToPdfText =
"Exportar a Pdf"
;
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToCsvButton =
false
;
RadGrid1.ItemDataBound +=
new
GridItemEventHandler(RadGrid1_ItemDataBound);
GridBoundColumn boundColumn1;
boundColumn1 =
new
GridBoundColumn();
RadGrid1.MasterTableView.Columns.Add(boundColumn1);
boundColumn1.DataField =
"Alum_Id"
;
boundColumn1.HeaderText =
"Alum_Id"
;
boundColumn1.Visible =
false
;
GridBoundColumn boundColumn2;
boundColumn2 =
new
GridBoundColumn();
RadGrid1.MasterTableView.Columns.Add(boundColumn2);
boundColumn2.DataField =
"Alum_NomApellidos"
;
boundColumn2.HeaderText =
"Estudiante"
;
boundColumn2.ItemStyle.Width = Unit.Percentage(20);
string
templateColumnName =
"materiaName"
;
string
templateColumnLogros =
"logrosName"
;
GridTemplateColumn templateColum;
templateColum =
new
GridTemplateColumn();
RadGrid1.MasterTableView.Columns.Add(templateColum);
templateColum.ItemStyle.Width = Unit.Percentage(80);
templateColum.ItemTemplate =
new
MyTemplate(templateColumnName, ds);
templateColum.HeaderTemplate =
new
MyTemplate2(templateColumnLogros, ds);
templateColum.UniqueName =
"TemplateColumn"
;
templateColum.InitializeTemplatesFirst =
false
;
}
}
public
class
MyTemplate : ITemplate
{
private
string
colname;
protected
Label lControl;
private
DataSet ds;
public
MyTemplate(
string
cName, DataSet datos)
{
colname = cName;
ds = datos;
}
public
void
InstantiateIn(System.Web.UI.Control container)
{
lControl =
new
Label();
lControl.ID =
"lControl"
;
lControl.DataBinding +=
new
EventHandler(lControl_DataBinding);
container.Controls.Add(lControl);
}
public
void
lControl_DataBinding(
object
sender, EventArgs e)
{
Label l = (Label)sender;
GridDataItem container = (GridDataItem)l.NamingContainer;
string
sItem =
string
.Empty;
sItem =
"<table width='100%' border='0' cellpadding='0' cellspacing='0'><tr>"
;
float
ancho = 80 / (ds.Tables[0].Columns.Count - 2);
for
(
int
i = 2; i < ds.Tables[0].Columns.Count; i++)
{
sItem +=
"<td align='center' style='width:"
+ ancho.ToString() +
"%'>"
+ ((DataRowView)container.DataItem)[ds.Tables[0].Columns[i].ColumnName].ToString() +
"</td>"
;
}
sItem +=
"</tr></table>"
;
l.Text = sItem;
}
}
public
class
MyTemplate2 : ITemplate
{
private
DataSet ds;
private
string
colname;
protected
Label lControl;
public
MyTemplate2(
string
cName, DataSet datos)
{
colname = cName;
ds = datos;
}
public
void
InstantiateIn(System.Web.UI.Control container)
{
lControl =
new
Label();
lControl.ID =
"lControl"
;
lControl.DataBinding +=
new
EventHandler(lControl_DataBinding);
container.Controls.Add(lControl);
}
public
void
lControl_DataBinding(
object
sender, EventArgs e)
{
Label l = (Label)sender;
GridHeaderItem container = (GridHeaderItem)l.NamingContainer;
string
sHeader =
string
.Empty;
sHeader =
"<table id='Table1' width='100%' border='0' cellpadding='0' cellspacing='0'><tr>"
;
sHeader +=
"<td colspan='"
+ (ds.Tables[0].Columns.Count - 2).ToString() +
"' align='center'>Nombres de Materias</td></tr><tr>"
;
float
ancho = 80 / (ds.Tables[0].Columns.Count - 2);
for
(
int
i = 2; i < ds.Tables[0].Columns.Count; i++)
{
sHeader +=
"<td align='center' style='width:"
+ ancho.ToString() +
"%'>"
+ ds.Tables[0].Columns[i].ColumnName +
"</td>"
;
}
sHeader +=
"</tr></table>"
;
l.Text = sHeader;
}
}
protected
void
Button1_Click(
object
sender, EventArgs e)
{
RadGrid1.MasterTableView.Columns.FindByUniqueName(
"TemplateColumn"
).Visible =
true
;
RadGrid1.ExportSettings.ExportOnlyData =
true
;
RadGrid1.ExportSettings.IgnorePaging =
true
;
RadGrid1.ExportSettings.OpenInNewWindow =
true
;
RadGrid1.ExportSettings.FileName =
"Concentrador"
;
RadGrid1.MasterTableView.ExportToExcel();
}