|
[index.cshtml]
<ejs-grid id="Grid" dataSource="@ViewBag.DataSource" allowFiltering="true" allowPaging="true" allowGrouping="true" allowPdfExport="true" allowExcelExport="true" allowSorting="true" toolbarClick="toolbarClick"
toolbar="@(new List<string>() { "PdfExport",
"ExcelExport"})" queryCellInfo="queryCellInfo" pdfQueryCellInfo="pdfQueryCellInfo" excelQueryCellInfo="excelQueryCellInfo" height="300">
<e-grid-columns>
<e-grid-column type="checkbox" width="100"></e-grid-column>
<e-grid-column field="SerialNo" headerText="S/NO" allowFiltering="false" allowSorting="false" width="100"></e-grid-column>
</e-grid-columns>
</ejs-grid>
<script>
var serialNo;
function
queryCellInfo(args){
if ( args.column.field=="SerialNo" ) {
// bind the index of the record based on current page
args.cell.innerText
= parseInt(args.cell.getAttribute('index')) + 1 + (this.pageSettings.currentPage - 1) * this.pageSettings.pageSize;
}
}
function
toolbarClick(args) {
var gridObj
= document.getElementById("Grid").ej2_instances[0];
if
(args.item.id === 'Grid_excelexport') {
serialNo = 0; // initialize the serial No
gridObj.excelExport();
}
if
(args.item.id === 'Grid_pdfexport') {
serialNo = 0; // initialize the serial No
gridObj.pdfExport();
}
}
function
excelQueryCellInfo(args){
if
(args.column.field == "SerialNo") {
args.value = serialNo +
1; // bind the serial No in the
excel cell
serialNo++; // increase the serial No
}
}
function
pdfQueryCellInfo(args){
if
(args.column.field == "SerialNo") {
args.value = (serialNo +
1).toString(); // bind the serial
No in the pdf cell
serialNo++; // increase the serial No
}
}
</script>
|
