easyui datagrid数据编辑

<!DOCTYPE html>

<html>

<head>

    <meta charset="UTF-8">

    <title>Row Editing in DataGrid - jQuery EasyUI Demo</title>

    <link rel="stylesheet" type="text/css" href="../../themes/default/easyui.css">

    <link rel="stylesheet" type="text/css" href="../../themes/icon.css">

    <link rel="stylesheet" type="text/css" href="../demo.css">

    <script type="text/javascript" src="../../jquery.min.js"></script>

    <script type="text/javascript" src="../../jquery.easyui.min.js"></script>

</head>

<body>

    <h2>Row Editing in DataGrid</h2>

    <p>Click the row to start editing.</p>

    <div style="margin:20px 0;"></div>

    

    <table id="dg" class="easyui-datagrid" title="Row Editing in DataGrid" style="width:700px;height:auto"

            data-options="

                iconCls: 'icon-edit',

                singleSelect: true,

                toolbar: '#tb',

                url: 'datagrid_data1.json',

                method: 'get',

                onClickCell: onClickCell,

                onEndEdit: onEndEdit

            ">

        <thead>

            <tr>

                <th data-options="field:'itemid',width:80">Item ID</th>

                <th data-options="field:'productid',width:100,

                        formatter:function(value,row){

                            return row.productname;

                        },

                        editor:{

                            type:'combobox',

                            options:{

                                valueField:'productid',

                                textField:'productname',

                                method:'get',

                                url:'products.json',

                                required:true

                            }

                        }">Product</th>

                <th data-options="field:'listprice',width:80,align:'right',editor:{type:'numberbox',options:{precision:2}}">List Price</th>

                <th data-options="field:'unitcost',width:80,align:'right',editor:{type:'numberbox',options:{precision:2}}">Unit Cost</th>

                <th data-options="field:'attr1',width:250,editor:'textbox'">Attribute</th>

                <th data-options="field:'status',width:60,align:'center',editor:{type:'checkbox',options:{on:'P',off:''}}">Status</th>

            </tr>

        </thead>

    </table>

 

    <div id="tb" style="height:auto">

        <a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true" onclick="append()">Append</a>

        <a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-remove',plain:true" onclick="removeit()">Remove</a>

        <a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-save',plain:true" onclick="acceptit()">Accept</a>

        <a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-undo',plain:true" onclick="reject()">Reject</a>

        <a href="javascript:void(0)" class="easyui-linkbutton" data-options="iconCls:'icon-search',plain:true" onclick="getChanges()">GetChanges</a>

    </div>

    

    <script type="text/javascript">

        var editIndex = undefined;

        function endEditing(){

            if (editIndex == undefined){return true}

            if ($('#dg').datagrid('validateRow', editIndex)){

                $('#dg').datagrid('endEdit', editIndex);

                editIndex = undefined;

                return true;

            } else {

                return false;

            }

        }

        function onClickCell(index, field){

            if (editIndex != index){

                if (endEditing()){

                    $('#dg').datagrid('selectRow', index)

                            .datagrid('beginEdit', index);

                    var ed = $('#dg').datagrid('getEditor', {index:index,field:field});

                    if (ed){

                        ($(ed.target).data('textbox') ? $(ed.target).textbox('textbox') : $(ed.target)).focus();

                    }

                    editIndex = index;

                } else {

                    setTimeout(function(){

                        $('#dg').datagrid('selectRow', editIndex);

                    },0);

                }

            }

        }

        function onEndEdit(index, row){

            var ed = $(this).datagrid('getEditor', {

                index: index,

                field: 'productid'

            });

            row.productname = $(ed.target).combobox('getText');

        }

        function append(){

            if (endEditing()){

                $('#dg').datagrid('appendRow',{status:'P'});

                editIndex = $('#dg').datagrid('getRows').length-1;

                $('#dg').datagrid('selectRow', editIndex)

                        .datagrid('beginEdit', editIndex);

            }

        }

        function removeit(){

            if (editIndex == undefined){return}

            $('#dg').datagrid('cancelEdit', editIndex)

                    .datagrid('deleteRow', editIndex);

            editIndex = undefined;

        }

        function acceptit(){

            if (endEditing()){

                $('#dg').datagrid('acceptChanges');

            }

        }

        function reject(){

            $('#dg').datagrid('rejectChanges');

            editIndex = undefined;

        }

        function getChanges(){

            var rows = $('#dg').datagrid('getChanges');

            alert(rows.length+' rows are changed!');

        }

    </script>

</body>

</html>

  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <metacharset="UTF-8">
  5. <title>Row Editing in DataGrid - jQuery EasyUI Demo</title>
  6. <linkrel="stylesheet"type="text/css"href="../../themes/default/easyui.css">
  7. <linkrel="stylesheet"type="text/css"href="../../themes/icon.css">
  8. <linkrel="stylesheet"type="text/css"href="../demo.css">
  9. <scripttype="text/javascript"src="../../jquery.min.js"></script>
  10. <scripttype="text/javascript"src="../../jquery.easyui.min.js"></script>
  11. </head>
  12. <body>
  13. <h2>Row Editing in DataGrid</h2>
  14. <p>Click the row to start editing.</p>
  15. <divstyle="margin:20px0;"></div>
  17. <tableid="dg"class="easyui-datagrid"title="Row Editing in DataGrid"style="width:700px;height:auto"
  18. data-options="
  19. iconCls: 'icon-edit',
  20. singleSelect: true,
  21. toolbar: '#tb',
  22. url: 'datagrid_data1.json',
  23. method: 'get',
  24. onClickCell: onClickCell,
  25. onEndEdit: onEndEdit
  26. ">
  27. <thead>
  28. <tr>
  29. <thdata-options="field:'itemid',width:80">Item ID</th>
  30. <thdata-options="field:'productid',width:100,
  31. formatter:function(value,row){
  32. return row.productname;
  33. },
  34. editor:{
  35. type:'combobox',
  36. options:{
  37. valueField:'productid',
  38. textField:'productname',
  39. method:'get',
  40. url:'products.json',
  41. required:true
  42. }
  43. }">Product</th>
  44. <thdata-options="field:'listprice',width:80,align:'right',editor:{type:'numberbox',options:{precision:2}}">List Price</th>
  45. <thdata-options="field:'unitcost',width:80,align:'right',editor:{type:'numberbox',options:{precision:2}}">Unit Cost</th>
  46. <thdata-options="field:'attr1',width:250,editor:'textbox'">Attribute</th>
  47. <thdata-options="field:'status',width:60,align:'center',editor:{type:'checkbox',options:{on:'P',off:''}}">Status</th>
  48. </tr>
  49. </thead>
  50. </table>
  51.  
  52. <divid="tb"style="height:auto">
  53. <ahref="javascript:void(0)"class="easyui-linkbutton"data-options="iconCls:'icon-add',plain:true"onclick="append()">Append</a>
  54. <ahref="javascript:void(0)"class="easyui-linkbutton"data-options="iconCls:'icon-remove',plain:true"onclick="removeit()">Remove</a>
  55. <ahref="javascript:void(0)"class="easyui-linkbutton"data-options="iconCls:'icon-save',plain:true"onclick="acceptit()">Accept</a>
  56. <ahref="javascript:void(0)"class="easyui-linkbutton"data-options="iconCls:'icon-undo',plain:true"onclick="reject()">Reject</a>
  57. <ahref="javascript:void(0)"class="easyui-linkbutton"data-options="iconCls:'icon-search',plain:true"onclick="getChanges()">GetChanges</a>
  58. </div>
  60. <scripttype="text/javascript">
  61. var editIndex =undefined;
  62. function endEditing(){
  63. if(editIndex ==undefined){returntrue}
  64. if($('#dg').datagrid('validateRow', editIndex)){
  65. $('#dg').datagrid('endEdit', editIndex);
  66. editIndex =undefined;
  67. returntrue;
  68. }else{
  69. returnfalse;
  70. }
  71. }
  72. function onClickCell(index, field){
  73. if(editIndex != index){
  74. if(endEditing()){
  75. $('#dg').datagrid('selectRow', index)
  76. .datagrid('beginEdit', index);
  77. var ed = $('#dg').datagrid('getEditor',{index:index,field:field});
  78. if(ed){
  79. ($(ed.target).data('textbox')? $(ed.target).textbox('textbox'): $(ed.target)).focus();
  80. }
  81. editIndex = index;
  82. }else{
  83. setTimeout(function(){
  84. $('#dg').datagrid('selectRow', editIndex);
  85. },0);
  86. }
  87. }
  88. }
  89. function onEndEdit(index, row){
  90. var ed = $(this).datagrid('getEditor',{
  91. index: index,
  92. field:'productid'
  93. });
  94. row.productname = $(ed.target).combobox('getText');
  95. }
  96. function append(){
  97. if(endEditing()){
  98. $('#dg').datagrid('appendRow',{status:'P'});
  99. editIndex = $('#dg').datagrid('getRows').length-1;
  100. $('#dg').datagrid('selectRow', editIndex)
  101. .datagrid('beginEdit', editIndex);
  102. }
  103. }
  104. function removeit(){
  105. if(editIndex ==undefined){return}
  106. $('#dg').datagrid('cancelEdit', editIndex)
  107. .datagrid('deleteRow', editIndex);
  108. editIndex =undefined;
  109. }
  110. function acceptit(){
  111. if(endEditing()){
  112. $('#dg').datagrid('acceptChanges');
  113. }
  114. }
  115. function reject(){
  116. $('#dg').datagrid('rejectChanges');
  117. editIndex =undefined;
  118. }
  119. function getChanges(){
  120. var rows = $('#dg').datagrid('getChanges');
  121. alert(rows.length+' rows are changed!');
  122. }
  123. </script>
  124. </body>
  125. </html>
posted @ 2020-02-29 07:59  新云优  阅读(177)  评论(0)  编辑  收藏  举报