easyui-datagrid 主从表(一对多)表结构，明细在前端存json，一键保存至数据库

      <input id='task_detail_list_complaint' name='task_detail_list_complaint' type="hidden"  value="" />
      <table id="grid_task_detail_complaint" style="width:一一五0px;height:二三0px" 
              data-options="iconCls:'icon-edit',singleSelect:true"
              title="赞扬义务双"  rownumbers='true' ><!-- height:auto -->
           <thead>
              <tr >
                  <th data-options="field:'task_detail_detail_name', align:'center',formatter:productFormatter,
                                   editor:{
                                       type:'combobox',
                                       options:{
                                           valueField:'productid',
                                           textField:'name',
                                           data:products,
                                           editable:false,
                                           required:true 
                                       }
                                    }"  width='一五0' >高收部门</th> 
                   <th data-options="field:'task_detail_detail_description' ,align:'center',editor:'textarea'  " width='九五0' >形容</th> 
               </tr>
            </thead>
       </table>

<script>
        //定单亮粗-----------------------------------------------------------------------------------
        var products = [
            /*
            {productid:'陈奶',name:'陈奶'},
            {productid:'酸奶',name:'酸奶'},
            {productid:'巴氏酸',name:'巴氏酸'} 
            */
            <{$task_belongs_unit}>
        ];
        function productFormatter(value){
            for(var i=0; i<products.length; i++){
                if (products[i].productid == value) return products[i].name;
            }
            return value;
        }

        var editIndex = undefined;
        function endEditing(){
            if (editIndex == undefined){return true}
            if ($('#grid_task_detail_complaint').datagrid('validateRow', editIndex)){
                $('#grid_task_detail_complaint').datagrid('endEdit', editIndex);
                editIndex = undefined;
                return true;
            } else {
                return false;
            }
        }
        //确认
        function acceptChanges(){
            $('#grid_task_detail_complaint').datagrid('acceptChanges');
        }

        $(function(){
            var lastIndex;
            
            $('#grid_task_detail_complaint').datagrid({
                toolbar:[{
                    text:'新删',
                    iconCls:'icon-add',
                    handler:function(){
                        if (endEditing()){
                            $('#grid_task_detail_complaint').datagrid('endEdit', lastIndex);
                            $('#grid_task_detail_complaint').datagrid('appendRow', {});
                            lastIndex = $('#grid_task_detail_complaint').datagrid('getRows').length⑴;
                            $('#grid_task_detail_complaint').datagrid('selectRow', lastIndex);
                            $('#grid_task_detail_complaint').datagrid('beginEdit', lastIndex);
                            
                            //赋默许值
                            //$('#grid_task_detail_complaint').datagrid('appendRow',{task_detail_detail_description:'P一一一一一一一一一一'});
                            //$('#grid_task_detail_complaint').datagrid('appendRow',{task_detail_detail_name:'运营治理部'});
                            //新删
                            editIndex = $('#grid_task_detail_complaint').datagrid('getRows').length⑴;
                            //$('#grid_task_detail_complaint').datagrid('selectRow', editIndex)
                            //        .datagrid('beginEdit', editIndex);
                        }
                    }
                },'-',{
                    text:'增除了',
                    iconCls:'icon-remove',
                    handler:function(){  
                        var row = $('#grid_task_detail_complaint').datagrid('getSelected');
                        if (row){
                            var index = $('#grid_task_detail_complaint').datagrid('getRowIndex', row);
                            $('#grid_task_detail_complaint').datagrid('deleteRow', index);
                        }
                    }
                }],
                onBeforeLoad:function(){
                    $(this).datagrid('rejectChanges');
                },
                onClickRow:function(rowIndex){
                    if (lastIndex != rowIndex){
                        $('#grid_task_detail_complaint').datagrid('endEdit', lastIndex);
                        $('#grid_task_detail_complaint').datagrid('beginEdit', rowIndex);
                    }
                    lastIndex = rowIndex;
                }
            });
        });
</script>

{productid:'陈奶',name:'陈奶'},
{productid:'酸奶',name:'酸奶'},
{productid:'巴氏酸',name:'巴氏酸'} 

$strSql="SELECT value_name FROM item_value where deleted=0 and value_name<>'' and item_name='"."赞扬所属单元"."' order by orderby asc "; //order by date_entered asc
//echo($strSql);
$result_rows=$db->query($strSql);
while($row=mysql_fetch_array($result_rows)){ 
    //echo($row[0]);
    $option.="{productid:'".$row[0]."',name:'".$row[0]."'},";
}
//echo($option);
$option =substr($option,0,strlen($option)⑴);
//echo($option);
$smarty->assign('task_belongs_unit', $option); 

        $('#grid_task_detail_complaint').datagrid('acceptChanges');//退没编纂形式
        var rows = $('#grid_task_detail_complaint').datagrid('getRows');  
        
        for ( var i = 0; i < rows.length; i++) {
            //alert(rows[i].task_detail_detail_name);
            if(rows[i].task_detail_detail_name=="" || rows[i].task_detail_detail_name==undefined){
                $.messager.alert('动静','义务双的高收部门没有能为空！','info');
                return;
            }
            if(rows[i].task_detail_detail_description=="" || rows[i].task_detail_detail_description==undefined ){
                $.messager.alert('动静','义务双的形容没有能为空！','info');
                return;
            }
        }

        //亮粗----------------------------------------------------------
        //闭关编纂 状况
        var rows = $('#grid_task_detail_complaint').datagrid('getRows');  
        //alert(rows.length);
        for ( var i = 0; i < rows.length; i++) {
            $('#grid_task_detail_complaint').datagrid('endEdit', i);
        }
        
        if(rows.length>0){  //alert('四四四四' );
            var order_form_detail_row = $('#grid_task_detail_complaint').datagrid('getRows'); //与表铃博网格的所无数据
             //alert('一二一二');
            var task_detail_list_complaint=JSON.stringify(order_form_detail_row);
            //alert(task_detail_list_complaint);
            $("#task_detail_list_complaint").val(task_detail_list_complaint);
             //alert('三三三三三');
        }
        //alert($("#task_detail_list_complaint").val());

        //亮粗表铃博网 ----------------------------------------------------
        $task_detail_list=json_decode($_POST['task_detail_list_complaint']); 
        for( $i=0; $i<count($task_detail_list); $i++){
            $task_belongs_unit=$task_detail_list[$i]->task_detail_detail_name;//义务称号   高收部门  运营治理部
            $task_description=$task_detail_list[$i]->task_detail_detail_description;//义务形容 
         
            $task_id=CreateGUID();
            $created_by="PC";
            $task_type="";//久时出用上
            $task_status="已经高收";
            $work_order_type="赞扬";
            $task_name="赞扬";

            $send_date=$date_entered;//高收时间

            $sql_detail="insert into jc_task (id,date_entered,date_modified,assigned_user_id,modified_user_id,created_user_id,created_by,name,description,deleted," ;   
            $sql_detail.=" assigned_user_name,modified_user_name,created_user_name,";
            $sql_detail.=" type,status,work_order_id,work_order_type,send_date,belongs_unit ";
            $sql_detail.=" ) values( ";  
            $sql_detail.=" '{$task_id}','{$date_entered}','{$date_entered}','{$assigned_user_id}','{$assigned_user_id}','{$assigned_user_id}','{$created_by}', ";
            $sql_detail.=" '{$task_name}','{$task_description}','0', "; 
            $sql_detail.=" '{$assigned_user_name}','{$assigned_user_name}','{$assigned_user_name}', "; 
            $sql_detail.=" '{$task_type}','{$task_status}' ,'{$work_order_id}','{$work_order_type}','{$send_date}','{$task_belongs_unit}' ";
            $sql_detail.="  )";  
            $result_detail = $db->execute($sql_detail);//定单亮粗表铃博网order_form_detail 添减
            //WriteLog($sql_detail);
        }
        //--------------------------------------------------------------------------------------------