-
jQuery EasyUI Tutorial
jEasyUI application
- jEasyUI Create a CRUD application
- jEasyUI Create a CRUD data grid
- jEasyUI Form CRUD application
- jEasyUI Create an RSS reader
jEasyUI Drag and drop
- jEasyUI Basic drag and drop
- jEasyUI Create a drag-and-drop shopping cart
- jEasyUI Create a school curriculum
jEasyUI Menus and buttons
- jEasyUI Create a simple menu
- jEasyUI Create a link button
- jEasyUI Create a menu button
- jEasyUI Create a split button
jEasyUI layout
- jEasyUI Create a border layout
- jEasyUI Create a complex layout
- jEasyUI Creates a fold panel
- jEasyUI Create a tab page
- jEasyUI Dynamically add a tab
- jEasyUI Add the AutoPlay tab
- jEasyUI Create the XP style left panel
jEasyUI Data grid
- jEasyUI Convert HTML tables to data grids
- jEasyUI Get the selected row data
- jEasyUI Add the query function
- jEasyUI Add a toolbar
- jEasyUI Create complex toolbars
- jEasyUI Sets the frozen column
- jEasyUI Dynamically change columns
- jEasyUI Format the column
- jEasyUI Set sort
- jEasyUI Custom sorting
- jEasyUI Create a column combination
- jEasyUI Add a check box
- jEasyUI Custom tab
- jEasyUI Enable in-line editing
- jEasyUI Extension editor
- jEasyUI Column operation
- jEasyUI Merge Cells
- jEasyUI Create a custom view
- jEasyUI Create a footer summary
- jEasyUI Condition Sets the line background color
- jEasyUI Create an attribute grid
- jEasyUI The extended line shows the details
- jEasyUI Create a subgrid
- jEasyUI Display massive data
- jEasyUI Add a paging component
jEasyUI window
- jEasyUI Create a simple window
- jEasyUI Customize the Window Toolbar
- jEasyUI Window and layout
- jEasyUI Create a dialog box
- jEasyUI Customize the dialog box
jEasyUI Tree menu
- jEasyUI Use the markup to create a tree menu
- jEasyUI Create an asynchronous tree menu
- jEasyUI Tree menu to add nodes
- jEasyUI Create a tree menu with check boxes
- jEasyUI Tree menu drag and drop control
- jEasyUI The Tree menu loads the parent / child nodes
- jEasyUI Create the base tree grid
- jEasyUI Create a complex tree grid
- jEasyUI Dynamic loading of tree
- jEasyUI The tree grid adds pagination
- jEasyUI Tree-lazy lazy-loading node
jEasyUI Form
- jEasyUI Create an asynchronous submission form
- jEasyUI Form validation
- jEasyUI Create a tree drop-down box
- jEasyUI Format the drop-down box
- jEasyUI Filter down the data grid
jEasyUI Reference Manual
jQuery EasyUI Data Grid - column operation
In this tutorial, you will learn how to include a column in the operation of editable data grid (datagrid) in. An operational column typically contains values from one or more other columns operation.
First, create an editable data grid (datagrid). Here we create some editable column, 'listprice', 'amount' and 'unitcost' column defined as numberbox edit type. Operation column is 'unitcost' field, will be the result of multiplying the amount listprice column.
<Table id = "tt" style = "width: 600px; height: auto"
title = "Editable DataGrid with Calculated Column" iconCls = "icon-edit" singleSelect = "true"
idField = "itemid" url = "data / datagrid_data.json">
<Thead>
<Tr>
<Th field = "itemid" width = "80"> Item ID </ th>
<Th field = "listprice" width = "80" align = "right" editor = "{type: 'numberbox', options: {precision: 1}}"> List Price </ th>
<Th field = "amount" width = "80" align = "right" editor = "{type: 'numberbox', options: {precision: 0}}"> Amount </ th>
<Th field = "unitcost" width = "80" align = "right" editor = "numberbox"> Unit Cost </ th>
<Th field = "attr1" width = "150" editor = "text"> Attribute </ th>
<Th field = "status" width = "60" align = "center" editor = "{type: 'checkbox', options: {on: 'P', off: ''}}"> Status </ th>
</ Tr>
</ Thead>
</ Table>
When the user clicks on a row, we started an edit action.
var lastIndex;
$ ( '# Tt'). Datagrid ({
onClickRow: function (rowIndex) {
if (lastIndex! = rowIndex) {
$ ( '# Tt') datagrid ( 'endEdit', lastIndex).;
$ ( '# Tt') datagrid ( 'beginEdit', rowIndex).;
setEditing (rowIndex);
}
lastIndex = rowIndex;
}
});
To create a relationship between the operation of some columns, we should get the current editors, and bind them to some of the events above.
function setEditing (rowIndex) {
var editors = $ ( '# tt') datagrid ( 'getEditors', rowIndex).;
var priceEditor = editors [0];
var amountEditor = editors [1];
var costEditor = editors [2];
priceEditor.target.bind ( 'change', function () {
calculate ();
});
amountEditor.target.bind ( 'change', function () {
calculate ();
});
function calculate () {
var cost = priceEditor.target.val () * amountEditor.target.val ();
$ (CostEditor.target) .numberbox ( 'setValue', cost);
}
}