番外-Easyui批量添加

作者: 通灵路耳 | 来源:发表于2020-12-27 20:10 被阅读0次

1、JS与HTML页面

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>叶片管理</title>
    <link rel="stylesheet" type="text/css" href="/static/jquery-easyui-1.3.3/themes/default/easyui.css"></link>
    <link rel="stylesheet" type="text/css" href="/static/jquery-easyui-1.3.3/themes/icon.css"></link>
    <script type="text/javascript" src="/static/jquery-easyui-1.3.3/jquery.min.js"></script>
    <script type="text/javascript" src="/static/jquery-easyui-1.3.3/jquery.easyui.min.js"></script>
    <script type="text/javascript" src="/static/jquery-easyui-1.3.3/locale/easyui-lang-zh_CN.js"></script>
    <script type="text/javascript" src="/static/js/date.js"></script>
    <script type="text/javascript">

        var url;

        function closeProductDialog() {
            $("#dlg").dialog("close");
            resetValue();
        }

        /**
         * 弃用
         */
        function saveProduct() {

            $("#dg1").form("submit", {
                url: url,
                onSubmit: function () {
                    return $(this).form("validate");
                },
                success: function (result) {
                    var result = eval("(" + result + ")");
                    if (result.success == 1) {
                        $.messager.alert("系统提示", "保存成功！");
                        resetValue();
                        $("#dlg").dialog("close");
                        $("#dg").datagrid("reload");
                    } else {
                        $.messager.alert("系统提示", result.errorInfo);
                    }
                }
            });
        }


        <!----------------------------打开新增框-------------------------------------->
        function openProductAddDialog() {
            $("#dlg").dialog("open").dialog("setTitle", "添加叶片信息");
            url = "/bas/ye/save";
        }


        <!----------------------------打开修改框除-------------------------------------->
        function openProductModifyDialog() {
            var selectedRows = $("#dg").datagrid("getSelections");
            if (selectedRows.length != 1) {
                $.messager.alert("系统提示", "请选择一条要修改的数据！");
                return;
            }
            //修改后保存
            var row = selectedRows[0];
            $("#dlg").dialog("open").dialog("setTitle", "修改物品信息");
            $("#fm").form("load", row);
            $('#product_id').textbox('textbox').attr('readonly',true);
            url = "/bas/product/update";
            $("#dg").datagrid("reload");
        }

        <!----------------------------删除-------------------------------------->

        function deleteProduct() {

            var selectedRows = $("#dg").datagrid("getSelections");
            if (selectedRows.length != 1) {
                $.messager.alert("系统提示", "请选择一条要删除的数据！");
                return;
            }
            var guid = selectedRows[0].product_guid;
            $.messager.confirm("系统提示", "您确定要删除这条数据吗?", function (r) {
                if (r) {
                    $.post("/bas/product/delete?product_guid="+guid, function (result) {//删除
                        if (result.success) {
                            $.messager.alert("系统提示", "数据已成功删除！");
                            $("#dg").datagrid("reload");
                        } else {
                            $("#dg").datagrid("reload")
                        }
                    }, "json");
                }
            });
        }

        <!----------------------------双击单行数据打开修改框-------------------------------------->

        $(document).ready(function () {

            $("#dg").datagrid({
                onDblClickRow: function (index, row) {
                    $("#dlg").dialog("open").dialog("setTitle", "修改物资信息");
                    $("#fm").form("load", row);
                    $('#product_id').textbox('textbox').attr('readonly',true);
                    url = "/bas/product/update";
                }
            });

        });

        <!----------------------------查询物资信息-------------------------------------->
        function searchProduct() {
            var a = $("#s_product_id").val();
            var opts = $("#dg").datagrid("options");
            opts.url = "/bas/ye/all?yeGroupId=" + a;
            $('#dg').datagrid('reload');
        }

        function resetValue() {
            $("#yeGroupId").textbox('setValue', "");
            $("#productId").textbox('setValue', "");
            $("#theOrder").textbox('setValue', "");
            $("#quantity").textbox('setValue', "");
        }


        //<!--------------------------------------批量添加------------------------------------------>
        //编辑的行
        var editIndex = undefined;
        function endEditing() {
            if (editIndex == undefined){return true}
            $('#dg1').datagrid('endEdit', editIndex);
            editIndex = undefined;
            return true;
        }

        function onClickCell(index, field){
            if (editIndex != index) {
                if (endEditing()) {
                    $('#dg1').datagrid('selectRow', index)
                        .datagrid('beginEdit', index);
                    var ed = $('#dg1').datagrid('getEditor', { index: index, field: field });
                    if (ed) {
                        ($(ed.target).data('textbox') ? $(ed.target).textbox('textbox') : $(ed.target)).focus();
                    }
                    editIndex = index;
                } else {
                    setTimeout(function () {
                        $('#dg1').datagrid('selectRow', editIndex);
                    }, 0);
                }
            }
        }
        function onEndEdit(index, row){
            var ed = $(this).datagrid('getEditor', {
                index: index,
                field: 'productId'
            });
        }
        //批量添加按钮
        function append(){
            var index = $('#dg1').datagrid('getRowIndex', $('#dg').datagrid('getSelected'));
            if (index == -1)
                index = 0;
            $("#dg1").datagrid("insertRow", {
                index: index+1,
                row: {oper: "<a href='javascript:append()'>+<a> <a href='javascript:removeit()'>-<a>",status:'P'}
            });
        }
        //删除
        function removeit(){
            if (editIndex == undefined){return}
            $('#dg1').datagrid('selectRow', editIndex);

            $('#dg1').datagrid('cancelEdit', editIndex)
                .datagrid('deleteRow', editIndex);
            editIndex = undefined;
        }
        //批量添加数据，Ajax提交
        function accept(){
            if (endEditing()){
                var $dg = $('#dg1');
                var rows = $dg.datagrid('getChanges');
                if (rows.length) {
                    var inserted = $dg.datagrid('getChanges', "inserted");
                    var deleted = $dg.datagrid('getChanges', "deleted");
                    var updated = $dg.datagrid('getChanges', "updated");
                    var effectRow = new Object();
                    if (inserted.length) {
                        effectRow["inserted"] = JSON.stringify(inserted);
                    }
                    if (deleted.length) {
                        effectRow["deleted"] = JSON.stringify(deleted);

                    }
                    if (updated.length) {
                        effectRow["updated"] = JSON.stringify(updated);
                    }
                }
            }
            $.ajax({
                url: '/bas/ye/save',
                type: "post",
                async: true,
                dataType: 'text',
                data: { 'sper':effectRow["inserted"]},
                success: function (data) {
                    if(data.message=='ok'){
                        alert(data.message);
                    }else{
                        alert(data.message);
                        return;
                    }
                    //重新加载表格数据
                    $('#dg').datagrid('reload');
                }
            });
        }
        //其他设置
        function reject(){
            $('#dg').datagrid('rejectChanges');
            editIndex = undefined;
        }
        function getChanges(){
            var rows = $('#dg').datagrid('getChanges');
            alert(rows.length+' rows are changed!');
        }
        function contains(arr, obj) {
            var i = arr.length;
            while (i--) {
                if (arr[i] === obj) {
                    return true;
                }
            }
            return false;
        }
        //<!--------------------------------------批量添加到此打住------------------------------------------>

    </script>
</head>
<body style="margin: 1px">
<table id="dg" class="easyui-datagrid" rownumbers="false"
       fitColumns="true" pagination="true" singleSelect="true"
       fit="true" toolbar="#tb" firstload="false">
    <thead>
    <th field="yeGroupGuid" width="100" align="center" hidden="hidden"></th>
    <th field="yeGroupId" width="100" align="center">叶片组型号</th>
    <th field="productId" width="100" align="center">叶片型号</th>
    <th field="theOrder" width="150" align="center">序号</th>
    <th field="quantity" width="50" align="center" >数量</th>
    </thead>
</table>

<div id="tb">
    <fieldset style="border-color: #E7F0FF">
        <div>
            <a href="javascript:openProductAddDialog()" class="easyui-linkbutton" iconCls="icon-add"
               plain="true">添加</a>
            <a href="javascript:openProductModifyDialog()" class="easyui-linkbutton" iconCls="icon-edit"
               plain="true">修改</a>
            <a href="javascript:deleteProduct()" class="easyui-linkbutton" iconCls="icon-remove" plain="true">删除</a>
        </div>
        <div>
            &nbsp;叶片组编号：&nbsp;<input type="text" id="s_product_id" size="20"
                                    onkeydown="if(event.keyCode==13) searchProduct()"/>
            <a href="javascript:searchProduct()" class="easyui-linkbutton" iconCls="icon-search" plain="true">搜索</a>
        </div>
    </fieldset>
</div>

<div id="dlg" class="easyui-dialog" style="width: 850px;height: 400px;padding: 10px 20px"
     closed="true" buttons="#dlg-buttons" data-options="onClose:function(){resetValue()}">

<!-----------------------------批量添加------------------------------->

    <table id="dg1" class="easyui-datagrid" title="批量添加" style="width:800px;height:auto"
           data-options="
    iconCls: 'icon-edit',
    singleSelect: true,
    toolbar: '#tb1',
    url: 'datagrid_data1.json',
    method: 'get',
    onClickCell: onClickCell,
    onEndEdit: onEndEdit
   ">
        <thead>
        <tr>
            <th data-options="field:'oper',width:80">操作</th>
            <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',

       }
      }">Product</th>-->
            <th data-options="field:'theOrder',width:80,align:'right',editor:'numberbox'">序号</th>
            <th data-options="field:'quantity',width:80,align:'right',editor:'numberbox'">数量</th>
            <th data-options="field:'productId',width:250,editor:'textbox'">叶片型号</th>
            <th data-options="field:'status',width:250,align:'center',editor:{type:'checkbox',options:{on:'P',off:''}}">状态为P-才能添加</th>
        </tr>
        </thead>
    </table>

    <div id="tb1" style="height:auto">
        <a href="javascript:void(0)" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" class="easyui-linkbutton" data-options="iconCls:'icon-add',plain:true" onclick="append()">Append</a>
        <a href="javascript:void(0)" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" class="easyui-linkbutton" data-options="iconCls:'icon-remove',plain:true" onclick="removeit()">Remove</a>
    </div>
</div>

<div id="dlg-buttons">
    <a href="javascript:accept()" class="easyui-linkbutton" iconCls="icon-ok">保存</a>
    <a href="javascript:closeProductDialog()" class="easyui-linkbutton" iconCls="icon-cancel">关闭</a>
</div>

</body>
</html>

2、controller层

package com.mf.controller.bas;
import com.mf.entity.bas.BasYeGroup;
import com.mf.service.bas_service.BasYeService;
import com.mf.util.GetIp;
import com.mf.util.ResponseResult;
import com.mf.util.StringUtil;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.web.bind.annotation.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;

@RestController
@RequestMapping("/bas/ye")
public class BasYeController {

    @Autowired
    private BasYeService basYeService;

    @RequestMapping  ("/save")
    public ResponseResult<Void> yeAdd(HttpServletResponse response, HttpServletRequest request, String sper) throws Exception{
        String IP = GetIp.getip(request, response);
        //1、sper字符串接收数据
        System.out.println("数据"+sper);
        //2、首先把字符串转成 JSONArray 对象
        JSONArray backBodyJson = JSONArray.fromObject(sper);
        //3、遍历 jsonarray 数组，把每一个对象转成 json 对象
        BasYeGroup basYeGroup = new BasYeGroup();
        if (backBodyJson.size() > 0) {
            for (int i = 0; i < backBodyJson.size(); i++) {
                //4、开始拆分
                JSONObject job = backBodyJson.getJSONObject(i);
                //5、拿到叶片型号
                String productId=(String) job.get("productId");
                basYeGroup.setProductId(productId);
                //3-1、如果叶片型号为空，忽略不添加
                if(productId.equals("")){
                    continue;
                }
                //6、拿到序号
                Integer theOrder=Integer.parseInt((String) job.get("theOrder"));
                basYeGroup.setTheOrder(theOrder);
                //7、拿到数量
                Integer quantity=Integer.parseInt((String) job.get("quantity"));
                basYeGroup.setQuantity(quantity);
                //8、开始添加
                basYeService.addYe(basYeGroup,IP);
                System.out.println("所有数据："+basYeGroup); // 得到 每个对象中的属性值
            }
        }
        return new ResponseResult<Void>(1,"添加成功！");
    }
 
}

3、Service

package com.mf.service.bas_service;

import com.mf.entity.bas.BasProduct;
import com.mf.entity.bas.BasYeGroup;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;

import java.util.List;

public interface BasYeService {

    /**
     * 添加叶片
     * @param basYeGroup
     * @param ip
     */
    void addYe(BasYeGroup basYeGroup, String ip);
}

4、serviceImpl实现类

package com.mf.service.bas_impl;

import com.mf.entity.SysUserLog;
import com.mf.entity.bas.BasYeGroup;
import com.mf.repository.bas.BasYeRepository;
import com.mf.service.SysLogService;
import com.mf.service.bas_service.BasYeService;
import com.mf.util.StringUtil;
import com.mf.util.UtilId;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.data.domain.Sort.Direction;
import org.springframework.data.domain.Sort.Order;
import org.springframework.data.jpa.domain.Specification;
import org.springframework.stereotype.Service;

import javax.persistence.criteria.*;
import java.util.ArrayList;
import java.util.List;

@Service
public class BasYeServiceImpl implements BasYeService {

    @Autowired
    BasYeRepository basYeRepository;

    @Autowired
    SysLogService sysLogService;

    /**
     * 叶片添加
     * @param basYeGroup
     * @param ip
     */
    @Override
    public void addYe(BasYeGroup basYeGroup, String ip) {
        basYeGroup.setYeGroupGuid(UtilId.uuids());
        basYeRepository.save(basYeGroup);
        sysLogService.save(new SysUserLog(SysUserLog.ADD_ACTION,"添加物资信息："+basYeGroup.getYeGroupId(),ip));

    }
}

5、dao层

package com.mf.repository.bas;

import com.mf.entity.bas.BasYeGroup;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

public interface BasYeRepository extends JpaRepository<BasYeGroup,String>, JpaSpecificationExecutor<BasYeGroup> {
 
}

6、实体类

package com.mf.entity.bas;

import lombok.Data;
import org.springframework.data.domain.Sort;

import javax.persistence.*;
import java.io.Serializable;

/**
 * 叶片
 */
@Data
@Entity//实体
@Table(name = "bas_ye_group")
@NamedQuery(name = "BasYeGroup.findAll",query = "select b from BasYeGroup b")
public class BasYeGroup implements Serializable {

    @Id
    @Column(name = "ye_group_guid")
    public String  yeGroupGuid;

    @Column(name = "ye_group_id")
    public String  yeGroupId;

    @Column(name = "product_id")
    public String  productId;

    @Column(name = "the_order")
    public Integer  theOrder;

    @Column(name = "quantity")
    public Integer  quantity;

    public BasYeGroup(){}

    public String getYeGroupGuid() {
        return yeGroupGuid;
    }

    public void setYeGroupGuid(String yeGroupGuid) {
        this.yeGroupGuid = yeGroupGuid;
    }

    public String getYeGroupId() {
        return yeGroupId;
    }

    public void setYeGroupId(String yeGroupId) {
        this.yeGroupId = yeGroupId;
    }

    public String getProductId() {
        return productId;
    }

    public void setProductId(String productId) {
        this.productId = productId;
    }

    public Integer getTheOrder() {
        return theOrder;
    }

    public void setTheOrder(Integer theOrder) {
        this.theOrder = theOrder;
    }

    public Integer getQuantity() {
        return quantity;
    }

    public void setQuantity(Integer quantity) {
        this.quantity = quantity;
    }

    @Override
    public String toString() {
        return "BasYeGroup{" +
                "yeGroupGuid='" + yeGroupGuid + '\'' +
                ", yeGroupId='" + yeGroupId + '\'' +
                ", productId='" + productId + '\'' +
                ", theOrder=" + theOrder +
                ", quantity=" + quantity +
                '}';
    }
}

番外-Easyui批量添加

相关文章

网友评论

延伸阅读

深度阅读

栏目导航

热点阅读