HGSRM/WMS-BS/NFine.Web/Areas/DHAY/Views/IQCQuality/Item2CheckItemGroupQuery.cshtml

@{
    ViewBag.Title = "Index";
    Layout = "~/Views/Shared/_Index.cshtml";
}

<script src="~/Content/js/datepicker/WdatePicker.js"></script>
<!--引入 element-ui 的样式，-->
<link rel="stylesheet" href="~/Content/element-ui/lib/theme-chalk/index.css">
<script src="~/Content/vue/dist/vue.js"></script>
<script src="~/Content/element-ui/lib/index.js"></script>

<script src="~/Content/axios.min.js"></script>
<style>
</style>
<form id="form1">
    <div id="app">
        <div class="topPanel" style="height:100px;">
            <div class="toolbar">
                <div class="btn-group">
                    <input id="FileUp" name="FileUp" type="file" style="display:none;" accept=".csv, application/vnd.ms-excel, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" />
                    <input id='FileUp2' type='file' style="display: none" />
                    <a id="NF-Add" authorize="yes" style="margin-left:3px;" class="btn btn-primary" onclick="btn_Add()"><i class="fa fa-pencil-square-o"></i>新增</a>
                    <a id="NF-Remove" authorize="yes" style="margin-left:3px;" class="btn btn-primary" onclick="btn_Remove()"><i class="fa fa-pencil-square-o"></i>删除</a>
                    <a id="NF-Edit" authorize="yes" style="margin-left:3px;" class="btn btn-primary" onclick="btn_Edit()"><i class="fa fa-pencil-square-o"></i>修改</a>
                    <a id="NF-Introduction" authorize="yes" class="btn btn-primary dropdown-text" onclick="btn_UPload()">导入</a>
                    <a href="~/File/IQC/物料关联检验项目.xlsx" id="NF-IntroductionMould" authorize="no" class="btn btn-primary dropdown-text"><i class="fa fa-file-excel-o"></i>导入模板下载</a>
                    <a id="NF-ExportAll" authorize="no" class="btn btn-primary"><i class="fa fa-download"></i>导出</a>
                    <a class="btn btn-primary" onclick="$.reload()"><span class="glyphicon glyphicon-refresh"></span></a>

                </div>
                <div class="btn-group" style="display:block;padding-left:2px;">
                    <a class="btn btn-primary" id="downPrintControl" href="~/PrintActivex.exe" style="display:none">点击下载打印组件</a>
                </div>
                @*<script>$('.toolbar').authorizeButton()</script>*@
            </div>
            <div class="search">
                <table>
                    <tr>
                        <td class="HideItems" style="text-align:right;"><label class="lglabel  HideItems" for="txt_InvCode">&nbsp;&nbsp;&nbsp;&nbsp;物料编码</label>：</td>
                        <td class="HideItems">
                            <div class="input-group  HideItems">
                                <input id="txt_InvCode" type="text" class="form-control  HideItems" style="width: 200px;">
                            </div>
                        </td>
                        <td class="HideItems" style="text-align:right;"><label class="lglabel  HideItems" for="txt_InvName">&nbsp;&nbsp;&nbsp;&nbsp;物料名称</label>：</td>
                        <td class="HideItems">
                            <div class="input-group  HideItems">
                                <input id="txt_InvName" type="text" class="form-control  HideItems" style="width: 200px;">
                            </div>
                        </td>
                        <td class="HideItems" style="text-align:right;"><label class="lglabel  HideItems" for="txt_GroupCode">&nbsp;&nbsp;&nbsp;&nbsp;检验项目组编码</label>：</td>
                        <td class="HideItems">
                            <div class="input-group  HideItems">
                                <input id="txt_GroupCode" type="text" class="form-control  HideItems" style="width: 200px;">
                            </div>
                        </td>
                        <td class="HideItems" style="text-align:right;"><label class="lglabel  HideItems" for="txt_GroupName">&nbsp;&nbsp;&nbsp;&nbsp;检验项目组名称</label>：</td>
                        <td class="HideItems">
                            <div class="input-group  HideItems">
                                <input id="txt_GroupName" type="text" class="form-control  HideItems" style="width: 200px;">
                            </div>
                        </td>
                        <td>
                            <span class="input-group-btn">
                                <button id="btn_search" type="button" class="btn  btn-primary"><i class="fa fa-search"></i></button>
                            </span>
                        </td>
                    </tr>
                </table>
            </div>
        </div>
        <div class="gridPanel">
            <table id="gridList"></table>
            <div id="gridPager"></div>
        </div>
    </div>
</form>

<script type="text/javascript">
    function btn_UPload() {
        $("#FileUp").click();
    }

    function UpLoadClick() {
        var ids = $("#gridList").jqGrid('getGridParam', 'selarrrow');
        if (ids.length != 1) {
            $.modalAlertNew("WMS00050");
            return;
        }
        $("#FileUp2").click();
    }

    $(function () {
        var service = {
            isCanEditDate: false,
            Init: function () {
                var that = this;
                that.initControl();
                that.loadGrid();
                that.loadEvent();
            },
            initControl: function () {
                let that = this;
                let userName = '@NFine.Code.OperatorProvider.Provider.GetCurrent().UserName';
            },
            // 1. 主表加载：仅保留物料核心字段，开启子表
            loadGrid: function () {
                var that = this;
                var queryJson = {
                    InvCode: $("#txt_InvCode").val(),
                    InvName: $("#txt_InvName").val(),
                    GroupCode: $("#txt_GroupCode").val(),
                    GroupName: $("#txt_GroupName").val(),
                    // 筛选条件简化：仅保留物料相关，检验项目筛选移到子表（如需子表筛选需额外开发）
                }

                var $gridList = $("#gridList");
                $gridList.dataGrid({
                    url: "/DHAY/IQCQuality/GetItemMainGridJson" + "?" + Math.random(), // 主表接口：需返回汇总后的物料数据
                    postData: { queryJson: JSON.stringify(queryJson) },
                    mtype: "POST",
                    height: $(window).height() - 200,
                    width: $(window).width() - 300,
                    cellEdit: false, // 主表仅展示，关闭单元格编辑
                    cellsubmit: "clientArray",
                    colModel: [
                        { label: "物料编码", name: "InvCode", width: 120, align: 'left', sortable: true },
                        { label: "物料名称", name: "InvName", width: 180, align: 'left', sortable: true },
                        { label: "检验项目组编码", name: "GroupCode", width: 180, align: 'left', sortable: true },
                        { label: "检验项目组名称", name: "GroupName", width: 180, align: 'left', sortable: true },
                        { label: "维护人", name: "MUSERName", width: 100, align: 'left' },
                        { label: "维护时间", name: "MTIME", width: 160, align: 'left', formatter: "datetime", formatoptions: { newformat: "Y-m-d H:i:s" } }
                    ],
                    shrinkToFit: true,
                    width: "100%",
                    autowidth: true,
                    gridComplete: function () {
                        // 主表加载完成后无额外操作（如需高亮等可在此添加）
                    },
                    pager: "#gridPager",
                    sortname: 'MTIME',
                    sortorder: "desc",
                    viewrecords: true,
                    multiselect: true,
                    subGrid: true, // 2. 开启子表功能
                    // 3. 子表展开事件：加载当前物料的检验项目数据
                    subGridRowExpanded: function (subgrid_id, rowid) {
                        // 取消主表行选中（避免冲突）
                        $("#gridList").jqGrid("setSelection", rowid, false);
                        // 加载子表
                        that.bindSubGrid(subgrid_id, rowid);
                    }
                });
            },
            // 4. 子表加载：原主表的检验项目字段全部移到子表
            bindSubGrid: function (subgrid_id, rowid) {
                var that = this;
                // 子表容器ID和分页容器ID
                var subgrid_table_id = subgrid_id + "_t";
                var subgrid_pager_id = subgrid_id + "_pgr";

                // 创建子表DOM结构
                $("#" + subgrid_id).html("<table id='" + subgrid_table_id + "' class='scroll'></table><div id='" + subgrid_pager_id + "' class='scroll'></div>");

                // 获取主表当前行的物料编码（子表查询条件）
                var invCode = $("#gridList").jqGrid('getRowData', rowid).InvCode;
                var invName = $("#gridList").jqGrid('getRowData', rowid).InvName;

                // 子表初始化：原主表的所有检验项目字段移到这里
                $("#" + subgrid_table_id).dataGrid({
                    url: "/DHAY/IQCQuality/GetItemSubGridJson" + "?" + Math.random(), // 子表接口：按物料编码查检验项目
                    postData: {
                        InvCode: invCode,  // 子表查询条件：物料编码
                        InvName: invName   // 可选：物料名称辅助筛选
                    },
                    mtype: "POST",
                    height: "auto", // 子表高度自适应内容
                    width: $("#gridList").width() - 40, // 子表宽度比主表略窄（避免滚动条）
                    cellEdit: false, // 子表仅展示（如需编辑需额外开发）
                    cellsubmit: "clientArray",
                    colModel: [
                        { label: "检验项目主键", name: "ID", hidden: true, key: true }, // 子表唯一标识
                        { label: "检验类型（编码）", name: "EATTRIBUTE6", width: 100, align: 'left', hidden: true },
                        { label: "检验类型", name: "Type", width: 100, align: 'left' },
                        { label: "检验项目代码", name: "ListCode", width: 120, align: 'left' },
                        { label: "检验项目名称", name: "ListName", width: 180, align: 'left' },
                        { label: "标准下限", name: "SetValueMin", width: 100, align: 'left' },
                        { label: "标准上限", name: "SetValueMax", width: 100, align: 'left' },
                        { label: "单位", name: "Unit", width: 80, align: 'left' },
                        { label: "检验标准", name: "EATTRIBUTE1", width: 150, align: 'left' },
                        { label: "抽样水准", name: "EATTRIBUTE2", width: 100, align: 'left' },
                        { label: "允收标准", name: "EATTRIBUTE3", width: 100, align: 'left' },
                        { label: "必填标识（编码）", name: "EATTRIBUTE4", width: 100, align: 'left', hidden: true },
                        { label: "抽检实际值是否必填", name: "CEATTRIBUTE4", width: 150, align: 'left' },
                        { label: "AQL代码", name: "EATTRIBUTE5", width: 100, align: 'left' },
                        { label: "是否可用", name: "CEnable", width: 100, align: 'left' },
                        { label: "维护人", name: "MUSERName", width: 100, align: 'left' },
                        { label: "维护时间", name: "MTIME", width: 160, align: 'left', formatter: "date", formatoptions: { newformat: "Y-m-d H:i:s" } }
                    ],
                    shrinkToFit: true,
                    multiselect: false, // 子表不支持多选（避免与主表冲突）
                    viewrecords: true,
                    pager: subgrid_pager_id, // 子表独立分页
                    rowNum: 10, // 子表每页条数
                    sortname: 'ListCode',
                    sortorder: "asc"
                });
            },
            // 5. 搜索逻辑：仅筛选主表的物料数据
            query: function () {
                var queryJson = {
                    InvCode: $("#txt_InvCode").val(),
                    InvName: $("#txt_InvName").val(),
                    GroupCode: $("#txt_GroupCode").val(),
                    GroupName: $("#txt_GroupName").val(),
                }
                $("#gridList").jqGrid('setGridParam', {
                    postData: { queryJson: JSON.stringify(queryJson) },
                }).trigger('reloadGrid');
            },
            // 6. 事件绑定：保持原逻辑不变（编辑仍传物料编码）
            loadEvent: function () {
                var that = this;
                // 搜索按钮
                $("#btn_search").click(function () {
                    that.query();
                });
                // 新增按钮
                $("#NF-Add").click(function () {
                    $.modalOpen({
                        id: "Form",
                        title: "物料关联检验项目",
                        url: "/DHAY/IQCQuality/Item2CheckItemGroupBind",
                        width: "1200px",
                        height: "800px",
                        callBack: function (iframeId) {
                            top.frames[iframeId].submitForm();
                        }
                    });
                });
                // 编辑按钮：仍按物料编码打开子页面
                $("#NF-Edit").click(function () {
                    var ids = $("#gridList").jqGrid('getGridParam', 'selarrrow');
                    if (ids.length != 1) {
                        $.modalMsg("请选择一条数据", "warning");
                        return;
                    }
                    var selectInvCode = $("#gridList").jqGrid('getRowData', ids[0]).InvCode;
                    $.modalOpen({
                        id: "Form",
                        title: "编辑",
                        url: "/DHAY/IQCQuality/Item2CheckItemGroupEdit?INVCode=" + selectInvCode + "",
                        width: "1000px",
                        height: "800px",
                        callBack: function (iframeId) {
                            top.frames[iframeId].submitForm();
                        }
                    });
                });
                // 删除按钮：按主表选中行删除（需确保接口支持按物料编码批量删除）
                $("#NF-Remove").click(function () {
                    var ids = $("#gridList").jqGrid('getGridParam', 'selarrrow');
                    if (ids.length < 1) {
                        $.modalMsg("请选择数据", "warning");
                        return;
                    }
                    // 收集选中行的物料编码（而非原主键）
                    let invCodeList = [];
                    for (var i = 0; i < ids.length; i++) {
                        var invCode = $("#gridList").jqGrid('getRowData', ids[i]).InvCode;
                        invCodeList.push(invCode);
                    }
                    $.ajax({
                        url: "/DHAY/IQCQuality/DeleteItem2CheckItem",
                        type: "POST",
                        dataType: "json",
                        async: false,
                        data: {
                            keyValue: JSON.stringify(invCodeList) // 传物料编码列表到接口
                        },
                        success: function (data) {
                            if (data.state == "success") {
                                $.modalMsg("操作成功", "success");
                                that.query();
                            } else {
                                $.modalMsg(data.message, "warning");
                            }
                        }
                    });
                });
                // 导出按钮：按物料筛选条件导出（如需导出子表需额外处理）
                $("#NF-ExportAll").click(function () {
                    let queryJson = {
                        InvCode: $("#txt_InvCode").val(),
                        InvName: $("#txt_InvName").val(),
                    };
                    var postData = "&InvCode=" + queryJson.InvCode + "";
                    postData += "&InvName=" + queryJson.InvName;
                    $.download("/DHAY/IQCQuality/ExportAllItem2CheckItem" + "?" + Math.random(), postData, 'post');
                });
                // 导入按钮：保持原逻辑
                $("#FileUp").on("change", function (up) {
                    var form = new FormData(document.getElementById("form1"));
                    $.ajax({
                        url: "/DHAY/IQCQuality/ImportItem2CheckGroup?" + Math.random(),
                        type: "post",
                        data: form,
                        contentType: false,
                        processData: false,
                        success: function (data) {
                            if (data == "true" || data == true) {
                                alert("导入成功");
                                that.query();
                            } else {
                                alert(data);
                            }
                        },
                        error: function (aa) {
                            alert("导入失败：" + aa);
                        }
                    });
                });
                // FileUp2上传：保持原逻辑（需确保接口支持按物料编码关联文件）
                $("#FileUp2").on("change", function (e) {
                    var objList = $("#gridList").jqGrid('getGridParam', 'selarrrow');
                    if (objList.length != 1) {
                        $.modalMsg("请选择一条数据", "warning");
                        return;
                    }
                    var rowData = $("#gridList").jqGrid('getRowData', objList[0]);
                    var invCode = rowData.InvCode; // 传物料编码而非原ID
                    var files = e.target.files;
                    if (files.length == 0) return;
                    var data = new FormData();
                    jQuery.each(jQuery('#FileUp2')[0].files, function (i, file) {
                        data.append('file-' + i, file);
                    });
                    data.append("InvCode", invCode); // 传物料编码到接口
                    $.modalConfirm("确定上传文件吗？", function (r) {
                        if (r) {
                            $.ajax({
                                url: "/DHAY/IQCQuality/UpLoadItemRuleFile" + "?" + Math.random(),
                                type: "post",
                                data: data,
                                contentType: false,
                                processData: false,
                                dataType: "json",
                                success: function (data) {
                                    if (data.message == "上传成功！") {
                                        $.modalMsg("操作成功", "success");
                                        that.query();
                                    } else {
                                        $.modalMsg(data.message, "warning");
                                    }
                                },
                                error: function (aa) {
                                    $.modalAlertNew("WMS00016", aa);
                                }
                            });
                        }
                    });
                });
                // 查看文件按钮：保持原逻辑（需接口支持按物料编码查文件）
                $("#NF-ViewFile").click(function () {
                    var ids = $("#gridList").jqGrid('getGridParam', 'selarrrow');
                    if (ids.length != 1) {
                        $.modalMsg("请选择一条数据", "warning");
                        return;
                    }
                    var invCode = $("#gridList").jqGrid('getRowData', ids[0]).InvCode;
                    $.modalOpen({
                        id: "Form",
                        title: "质量履历文件查看",
                        url: "/DHAY/IQCQuality/Item2AqlFileView?invCode=" + invCode + "", // 传物料编码
                        width: "1200px",
                        height: "400px",
                        callBack: function (iframeId) {
                            top.frames[iframeId].submitForm();
                        }
                    });
                });
            }
        }
        service.Init();
    })
</script>