扫码记录缓存报表

zzr99

2022-07-08 6fa59de585fcd153e54c129f10f91a2ce34afaaa

扫码记录缓存报表

 WebTM/WebTM.csproj

@@ -150,6 +150,7 @@
    <Content Include="views\仓存管理\委外用料单\WW_PPBomBillList.html" />
    <Content Include="views\仓存管理\扫码异常记录表\KF_PonderationBillList.html" />
    <Content Include="views\仓存管理\条码出入库记录表\Kf_ICStockBillSubList.html" />
    <Content Include="views\仓存管理\条码出入库记录表\KF_PonderationBillList_Query.html" />
    <Content Include="views\仓存管理\条码库存\KF_ICInventoryByMaterID.html" />
    <Content Include="views\仓存管理\条码库存\KF_ICInventoryList_WMS.html" />
    <Content Include="views\仓存管理\条码生成\Gy_BarCodeBill.html" />

 WebTM/views/index.html

@@ -83,7 +83,6 @@
                        <dl class="layui-nav-child">
                            <dd><a lay-href="set/user/info.html">基本资料</a></dd>
                            <dd><a lay-href="set/user/password.html">修改密码</a></dd>
                            <hr>
                            <dd layadmin-event="logout" style="text-align: center;"><a>退出</a></dd>
                        </dl>
                    </li>
@@ -106,7 +105,7 @@
                    </div>
                    <ul class="layui-nav layui-nav-tree" lay-shrink="all" id="LAY-system-side-menu" lay-filter="layadmin-system-side-menu">
                        <!-- é‡‡è´­ç®¡ç† -->
                        <!--<li data-name="set" class="layui-nav-item">
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>采购管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -150,9 +149,9 @@
                                    </dl>
                                </dd>
                            </dl>
                        </li>-->
                        </li>
                        <!-- é”€å”®ç®¡ç† -->
                        <!--<li data-name="set" class="layui-nav-item">
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>销售管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -188,7 +187,7 @@
                                    </dl>
                                </dd>
                            </dl>
                        </li>-->
                        </li>
                        <!-- ä»“存管理 -->
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>仓存管理</cite></a>
@@ -211,7 +210,7 @@
                                    <dl class="layui-nav-child">
                                        <dd><a lay-href="领料发货/领料出库/Kf_MateOutBillList.html">生产领料单维护</a></dd>
                                        <dd><a lay-href="领料发货/领料出库/Kf_MateOutBackBillList.html">生产退料单维护</a></dd>
                                        <!--<dd><a lay-href="">生产补料单维护n</a></dd>-->
                                        <dd><a lay-href="">生产补料单维护n</a></dd>
                                        <dd><a lay-href="领料发货/销售出库/Kf_SellOutBillList.html">销售出库单维护</a></dd>
                                        <dd><a lay-href="销售管理/销售退货单/Kf_ICStockBillMainList.html">销售退货单维护</a></dd>
                                        <dd><a lay-href="领料发货/其他出库/Kf_OtherOutBillList.html">其他出库单维护</a></dd>
@@ -231,7 +230,7 @@
                                <dd>
                                    <a>条码主档</a>
                                    <dl class="layui-nav-child">
                                        <!--<dd><a lay-href="仓存管理/条码生成/Gy_BarCodeBill.html">条码生成</a></dd>-->
                                        <dd><a lay-href="仓存管理/条码生成/Gy_BarCodeBill.html">条码生成</a></dd>
                                        <dd><a lay-href="模治具管理/模治具管理/Gy_BarCodeBillList.html">条码主档维护</a></dd>
                                    </dl>
                                </dd>
@@ -251,12 +250,13 @@
                                        <dd><a lay-href="仓存管理/条码出入库记录表/Kf_ICStockBillSubList.html">条码出入库记录表</a></dd>
                                        <dd><a lay-href="仓存管理/条码库存/KF_ICInventoryList_WMS.html">条码库存查询</a></dd>
                                        <dd><a lay-href="仓存管理/条码库存/KF_PonderationBillMain_Temp.html">条码出入库缓存列表</a></dd>
                                        <dd><a lay-href="仓存管理/条码出入库记录表/KF_PonderationBillList_Query.html">扫码记录缓存报表</a></dd>
                                    </dl>
                                </dd>
                            </dl>
                        </li>
                        <!-- è®¡åˆ’管理 -->
                        <!--<li data-name="set" class="layui-nav-item">
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>计划管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -299,9 +299,9 @@
                                <dd>
                                <dd><a lay-href="计划管理/工艺路线大类/Gy_RoutingGroupList.html">工艺路线大类</a></dd>
                            </dl>
                        </li>-->
                        </li>
                        <!-- ç”Ÿäº§ç®¡ç† -->
                        <!--<li data-name="set" class="layui-nav-item">
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>生产管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -381,9 +381,9 @@
                                        <dd>
                                            <a>日计划工单</a>
                                            <dl class="layui-nav-child">
                                                <dd><a lay-href="生产管理/生产日计划工单/JIT_DayPlanBillList.html" style="margin: 0 0 0 13px;">日计划工单列表</a></dd>-->
                                                <!--<dd><a lay-href="生产管理/生产日计划工单/JIT_DayPlanBillEdit.html" style="margin: 0 0 0 13px;">日计划工单</a></dd>-->
                                            <!--</dl>
                                                <dd><a lay-href="生产管理/生产日计划工单/JIT_DayPlanBillList.html" style="margin: 0 0 0 13px;">日计划工单列表</a></dd>
                                                <dd><a lay-href="生产管理/生产日计划工单/JIT_DayPlanBillEdit.html" style="margin: 0 0 0 13px;">日计划工单</a></dd>-->
                                             </dl>
                                        </dd>
                                        <dd>
                                            <a>要料计划</a>
@@ -426,7 +426,7 @@
                            </dl>
                        </li>-->
                        <!-- è½¦é—´ç®¡ç† -->
                        <!--<li data-name="set" class="layui-nav-item">
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>车间管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -497,9 +497,9 @@
                                    </dl>
                                </dd>
                            </dl>
                        </li>-->
                        </li>
                        <!-- è´¨é‡ç®¡ç† -->
                        <!--<li data-name="set" class="layui-nav-item">
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>质量管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -555,9 +555,9 @@
                                    </dl>
                                </dd>
                            </dl>
                        </li>-->
                        <!-- å™¨å…·ç®¡ç† -->
                        <!--<li data-name="set" class="layui-nav-item">
                        </li>
                         å™¨å…·ç®¡ç† 
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>器具管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -648,9 +648,9 @@
                                    </dl>
                                </dd>
                            </dl>
                        </li>-->
                        <!-- è®¾å¤‡ç®¡ç† -->
                        <!--<li data-name="set" class="layui-nav-item">
                        </li>
                         è®¾å¤‡ç®¡ç† 
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>设备管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -698,9 +698,9 @@
                                    </dl>
                                </dd>
                            </dl>
                        </li>-->
                        <!-- å·¥èµ„管理 -->
                        <!--<li data-name="set" class="layui-nav-item">
                        </li>
                         å·¥èµ„管理 
                        <li data-name="set" class="layui-nav-item">
                            <a><i class="layui-icon layui-icon-set"></i><cite>工资管理</cite></a>
                            <dl class="layui-nav-child">
                                <dd>
@@ -771,7 +771,7 @@
                                    </dl>
                                </dd>
                            </dl>
                        </li>-->
                        </li>
                        <!-- å¯è§†åŒ–看板 -->
                        <!--<li data-name="template" class="layui-nav-item">
                            <a href="javascript:;" lay-tips="可视化看板" lay-direction="2">

 WebTM/views/²Ö´æ¹ÜÀí/²Ö¿âµ÷²¦/Kf_MoveStockBill_Fast.html

@@ -1066,12 +1066,13 @@
                                        elem: '#wl-table'
                                        , url: GetWEBURL() + '/MoveStockBill/DisBillEntryList_Webs_Json'
                                        , toolbar: '#toolbarDemo'
                                        , totalRow: true
                                        , defaultToolbar: []
                                        , where: { HBillID: sInterID, HBillType: '1207', sWhere: '' }
                                        , cols: [[
                                            { type: 'radio' }
                                            , { field: 'HQty', title: '数量', width: 150 }
                                            , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                            , { field: 'HQty', title: '数量', width: 150, totalRow: true}
                                            , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true}
                                            , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                            , { field: 'HMaterName', title: '物料名称', width: 150 }
                                            , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -1259,12 +1260,13 @@
                                elem: '#wl-table'
                                , url: GetWEBURL() + '/MoveStockBill/DisBillEntryList_Webs_Json'
                                , toolbar: '#toolbarDemo'
                                , totalRow: true
                                , defaultToolbar: []
                                , where: { HBillID: sInterID, HBillType: '1207', sWhere: '' }
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', width: 150 }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                    , { field: 'HQty', title: '数量', width: 150, totalRow: true }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true}
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }

 WebTM/views/²Ö´æ¹ÜÀí/²Ö¿âµ÷²¦/Kf_MoveStockOutBill_Fast.html

@@ -992,12 +992,13 @@
                                        elem: '#wl-table'
                                        , url: GetWEBURL() + '/MoveStockBill/DisBillEntryList_Webs_Json'
                                        , toolbar: '#toolbarDemo'
                                        , totalRow: true
                                        , defaultToolbar: []
                                        , where: { HBillID: sInterID, HBillType: '1250', sWhere: '' }
                                        , cols: [[
                                            { type: 'radio' }
                                            , { field: 'HQty', title: '数量', width: 150 }
                                            , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                            , { field: 'HQty', title: '数量', width: 150, totalRow: true }
                                            , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true}
                                            , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                            , { field: 'HMaterName', title: '物料名称', width: 150 }
                                            , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -1159,12 +1160,13 @@
                                elem: '#wl-table'
                                , url: GetWEBURL() + '/MoveStockBill/DisBillEntryList_Webs_Json'
                                , toolbar: '#toolbarDemo'
                                , totalRow: true
                                , defaultToolbar: []
                                , where: { HBillID: sInterID, HBillType: '1250', sWhere: '' }
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', width: 150 }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                    , { field: 'HQty', title: '数量', width: 150, totalRow: true}
                                    , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true}
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }

 WebTM/views/²Ö´æ¹ÜÀí/ÌõÂë³öÈë¿â¼Ç¼±í/KF_PonderationBillList_Query.html

New file
@@ -0,0 +1,401 @@
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>扫码记录缓存报表</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
    <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all">
    <!--<script src="../../../layuiadmin/layui/layui.js"></script>-->
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/layui/layui.js"></script>
    <script src="../../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <style type="text/css">
        input.layui-input.layui-unselect {
            padding-right: 0;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
            <div class="layui-card" style="padding: 1px">
                <div class="layui-card-body" style="padding: 1px;">
                    <form class="layui-form" action="" lay-filter="component-form-group">
                        <div class="layui-collapse">
                            <div class="layui-colla-item">
                                <div class="layui-colla-title layui-inline">
                                    <div class="layui-inline">
                                        <span>更多</span>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">提交标记</label>
                                    <div class="layui-input-block">
                                        <select name="HRelationInterID" id="HRelationInterID" lay-verify="required" lay-search class="layui-input">
                                            <option value="0" selected>全部</option>
                                            <option value="未提交">未提交</option>
                                            <option value="已提交">已提交</option>
                                        </select>

                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">物料代码</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HMaterNum" id="HMaterNum" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">物料名称</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HMaterName" id="HMaterName" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">规格型号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HModel" id="HModel" style="width:190px;">
                                    </div>
                                </div>

                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>

                                <div class="layui-colla-content">
                                    <div class="layui-inline">
                                        <div class="layui-inline">
                                            <span>其他条件></span>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">仓库</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HWhName" id="HWhName" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">仓位</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HStockPlaceName" id="HStockPlaceName" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">调出仓库</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HSCWHName" id="HSCWHName" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">调出仓位</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HOutStockPlaceName" id="HOutStockPlaceName" style="width:190px;">
                                        </div>
                                    </div>

                                    <div class="layui-inline">
                                        <label class="layui-form-label">条形码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HBarCode" id="HBarCode" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">托条码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HBarCode_Pack" id="HBarCode_Pack" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">批次</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HBatchNo" id="HBatchNo" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">MTO号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HMTONo" id="HMTONo" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">源单号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HSourceBillNo" id="HSourceBillNo" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">制单人</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HMaker" id="HMaker" style="width:190px;">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">库存组织</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HStockOrgName" id="HStockOrgName" style="width:190px;">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <script>
        layui.config({
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , table = layui.table
                , form = layui.form
                , element = layui.element
                , laypage = layui.laypage
                , laydate = layui.laydate
                , util = layui.util
            //查询条件
            var sWhere = "";
            var option = [];
            //初始化界面
            set_ClearBill();

            //#endregion

            //#region é‡ç½®æŒ‰é’®
            form.on('submit(btnReSearch)', function (data) {
                //清空过滤条件
                set_ClearQuery();
            });
            //#endregion

            //#region æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery(table, option);
            });
            //#endregion

            //#region åˆå§‹åŒ–界面
            function set_ClearBill() {
                //初始化表格
                set_InitGrid();
                //查询
                get_Display(sWhere);
            }
            //#endregion

            //#region åˆå§‹åŒ–表格方法
            function set_InitGrid() {
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-50'
                    , page: true
                    , cellMinWidth: 90
                    , limits: [50, 500, 5000, 20000]
                    ,limit: 50
                    , cols: [[
                         { type: 'checkbox', fixed: 'left' }
                        , { field: 'HInterID', title: '单据ID', hide: true }
                        , { field: '单据号', title: '单据号', width: 195 }
                        , { field: '单据类型', title: '单据类型', width: 110 }
                        , { field: '物料代码', title: '物料代码', width: 110 }
                        , { field: '物料名称', title: '物料名称', width: 110 }
                        , { field: '规格型号', title: '规格型号', width: 110 }
                        , { field: '辅助数量', title: '辅助数量', width: 110 }
                        , { field: '应发数量', title: '应发数量', width: 110 }
                        , { field: '实发数量', title: '实发数量', width: 110 }
                        , { field: '仓库', title: '仓库', width: 125 }
                        , { field: '仓位', title: '仓位', width: 125 }
                        , { field: '调出仓库', title: '调出仓库', width: 125 }
                        , { field: '调出仓位', title: '调出仓位', width: 125 }
                        , { field: '条形码', title: '条形码', width: 125 }
                        , { field: '托条码', title: '托条码', width: 125 }
                        , { field: '批次', title: '批次', width: 125 }
                        , { field: 'MTO号', title: 'MTO号', width: 125 }
                        , { field: '源单主内码', title: '源单主内码', width: 200, hide: true }
                        , { field: '源单子内码', title: '源单子内码', width: 200, hide: true }
                        , { field: '源单号', title: '源单号', width: 125 }
                        , { field: '源单类型', title: '源单类型', width: 125, hide: true }
                        , { field: '工序', title: '工序', width: 125 }
                        , { field: '班组', title: '班组', width: 125 }
                        , { field: '制单人', title: '制单人', width: 125 }
                        , { field: '制单日期', title: '制单日期', width: 200, templet: "<div>{{d.制单日期 ==null ?'':layui.util.toDateString(d.制单日期, 'yyyy-MM-dd HH:mm:ss')}}</div>" }
                        , { field: '提交标记', title: '提交标记', width: 125 }
                        , { field: '红蓝字标记', title: '红蓝字标记', width: 125 }
                        , { field: '库存组织', title: '库存组织', width: 125 }
                        , { field: '货主', title: '货主', width: 125 }
                        , { field: '其他组织', title: '其他组织', width: 125 }
                        , { field: '客户标签', title: '客户标签', width: 125 }
                    ]]
                };
            }

            //进入页面显示的缓存列表
            function get_Display(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Kf_ICStockInOutBill/GetKF_PonderationBillMain_Temp',
                    type: "GET",
                    data: { "sWhere": sWhere},
                    success: function (data1) {
                        if (data1.count == 1) {
                            option.data = data1.data;
                            table.render(option);
                            layer.close(ajaxLoad);
                        } else {
                            layer.close(ajaxLoad);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(ajaxLoad);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });
            }

            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                var checkStatus = table.checkStatus(obj.config.id);
                switch (obj.event) {
                    //刷新
                    case 'get_Refresh': get_Refresh();
                        break;
                    //退出按钮
                    case 'get_Exit': Pub_Close(2);
                        break;
                };
            });

            //#region å¿«é€Ÿè¿‡æ»¤
            function get_FastQuery(table, option) {
                var HBillNo = $("#HBillNo").val();//单据号
                var HMaterNum = $("#HMaterNum").val();//物料代码
                var HMaterName = $("#HMaterName").val();//物料名称
                var HModel = $("#HModel").val();//规格型号
                var HWhName = $("#HWhName").val();//仓库
                var HStockPlaceName = $("#HStockPlaceName").val();//仓位
                var HSCWHName = $("#HSCWHName").val();//调出仓库
                var HOutStockPlaceName = $("#HOutStockPlaceName").val();//调出仓位
                var HBarCode = $("#HBarCode").val();//条形码
                var HBarCode_Pack = $("#HBarCode_Pack").val();//托条码
                var HBatchNo = $("#HBatchNo").val();//批号
                var HMTONo = $("#HMTONo").val();//MTO
                var HSourceBillNo = $("#HSourceBillNo").val();//源单号
                var HMaker = $("#HMaker").val();//制单人
                var HStockOrgName = $("#HStockOrgName").val();//库存组织
                var HRelationInterID = $("#HRelationInterID").val();//库存组织

                
                if (HBillNo) {
                    sWhere += " and å•æ®å· like '%" + HBillNo + "%'";
                }
                if (HMaterNum) {
                    sWhere += " and ç‰©æ–™ä»£ç  like '%" + HMaterNum + "%'";
                }
                if (HMaterName) {
                    sWhere += " and ç‰©æ–™åç§° like '%" + HMaterName + "%'";
                }
                if (HModel) {
                    sWhere += " and è§„格型号 like '%" + HModel + "%'";
                }
                if (HWhName) {
                    sWhere += " and ä»“库 like '%" + HWhName + "%'";
                }
                if (HStockPlaceName) {
                    sWhere += " and ä»“位 like '%" + HStockPlaceName + "%'";
                }
                if (HSCWHName) {
                    sWhere += " and è°ƒå‡ºä»“库 like '%" + HSCWHName + "%'";
                }
                if (HOutStockPlaceName) {
                    sWhere += " and è°ƒå‡ºä»“位 like '%" + HOutStockPlaceName + "%'";
                }
                if (HBarCode) {
                    sWhere += " and æ¡å½¢ç  like '%" + HBarCode + "%'";
                }
                if (HBarCode_Pack) {
                    sWhere += " and æ‰˜æ¡ç  like '%" + HBarCode_Pack + "%'";
                }
                if (HBatchNo) {
                    sWhere += " and æ‰¹æ¬¡ like '%" + HBatchNo + "%'";
                }
                if (HMTONo) {
                    sWhere += " and MTO号 like '%" + HMTONo + "%'";
                }
                if (HSourceBillNo) {
                    sWhere += " and æºå•å· like '%" + HSourceBillNo + "%'";
                }
                if (HMaker) {
                    sWhere += " and åˆ¶å•äºº like '%" + HMaker + "%'";
                }
                if (HStockOrgName) {
                    sWhere += " and åº“存组织 like '%" + HStockOrgName + "%'";
                }
                if (HRelationInterID && HRelationInterID != 0) {
                    sWhere += " and æäº¤æ ‡è®° like '%" + HRelationInterID + "%'";
                }
                get_Display(sWhere);
                sWhere = "";
            }
            //#endregion
            //#region é‡ç½®è¿‡æ»¤æ¡ä»¶
            function set_ClearQuery() {
                $("#HBillNo").val("");//单据类型
                $("#HMaterNum").val("");//条码
                $("#HMaterName").val("");//单据号
                $("#HModel").val("");//单据号
                $("#HWhName").val("");//单据号
                $("#HStockPlaceName").val("");//单据号
                $("#HOutStockPlaceName").val("");//单据号
                $("#HBarCode").val("");//单据号
                $("#HBarCode_Pack").val("");//单据号
                $("#HBatchNo").val("");//单据号
                $("#HMTONo").val("");//单据号
                $("#HSourceBillNo").val("");//单据号
                $("#HMaker").val("");//单据号
                $("#HStockOrgName").val("");//单据号
                $('#HRelationInterID').val("");
                sWhere = "";
                get_Display(sWhere);
            }
            //#endregion

            //#region åˆ·æ–°
            function get_Refresh() {
                set_ClearQuery();
                get_Display(sWhere);
            }
            //#endregion


        });

    </script>
</body>
</html>

 WebTM/views/Éú²ú¹ÜÀí/Éú²ú»ã±¨µ¥/Sc_ICMOReportBill_FastNew.html

@@ -817,10 +817,11 @@
                                                , url: GetWEBURL() + '/POStockInBill/DisBillEntryList_Webs_Json'
                                                  , where: { HBillID: sInterID, HBillType: '3711', sWhere: '' }
                                                  , cellMinWidth : 115
                                                , totalRow: true
                                                  , cols: [[
                                                      { type: 'radio' }
                                                    , { field: 'HQty', title: '数量', sort: true }
                                                    , { field: 'HQtyMust', title: '应收数量', sort: true  }
                                                      , { field: 'HQty', title: '数量', sort: true, totalRow: true}
                                                      , { field: 'HQtyMust', title: '应收数量', sort: true, totalRow: true}
                                                    , { field: 'HMaterNumber', title: '物料代码', sort: true }
                                                    , { field: 'HMaterName', title: '物料名称', sort: true }
                                                    , { field: 'HMaterModel', title: '规格型号', sort: true }
@@ -881,14 +882,15 @@
                            table.render({
                                elem: '#wl-table'
                                , cellMinWidth: 80
                                , totalRow: true
                              //, url: 'http://61.130.49.162:9090/WMSAPI///POStockInBill/DisBillEntryList_Webs_Json'
                                , url: GetWEBURL() + '/POStockInBill/DisBillEntryList_Webs_Json'
                              //, toolbar: '#toolbarDemo'
                              , where: { HBillID: sInterID, HBillType: '3711', sWhere: '' }
                              , cols: [[
                                  { type: 'radio' }
                                , { field: 'HQty', title: '数量', sort: true }
                                , { field: 'HQtyMust', title: '应收数量', sort: true }
                                  , { field: 'HQty', title: '数量', sort: true, totalRow: true}
                                  , { field: 'HQtyMust', title: '应收数量', sort: true, totalRow: true}
                                , { field: 'HMaterNumber', title: '物料代码', sort: true }
                                , { field: 'HMaterName', title: '物料名称', sort: true }
                                , { field: 'HMaterModel', title: '规格型号', sort: true }

 WebTM/views/ÁìÁÏ·¢»õ/ÆäËû³ö¿â/Kf_OtherOutBill_Check.html

@@ -848,12 +848,13 @@
            var listOption = {
                elem: '#wl-table'
                , toolbar: '#toolbarDemo'
                , totalRow: true
                , cellMinWidth: 90
                , cols: [[
                    { type: 'radio' }
                    , { field: 'HSNO', title: '序号', width: 60 }
                    , { field: 'HQty', title: '数量', width: 80 }
                    , { field: 'HQtyMust', title: '应发数量', width: 80 }
                    , { field: 'HQty', title: '数量', width: 80, totalRow: true}
                    , { field: 'HQtyMust', title: '应发数量', width: 80, totalRow: true }
                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                    , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -901,14 +902,15 @@
                            table.render({
                                elem: '#wl-table'
                                , cellMinWidth: 80
                                , totalRow: true
                                //, url: 'http://61.130.49.162:9090/WMSAPI///POStockInBill/DisBillEntryList_Webs_Json'
                                , url: GetWEBURL() + '/POStockInBill/DisBillEntryList_Webs_Json'
                                //, toolbar: '#toolbarDemo'
                                , where: { HBillID: sInterID, HBillType: '1201', sWhere: '' }
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', sort: true, width: 100 }
                                    , { field: 'HQtyMust', title: '应收数量', sort: true, width: 100 }
                                    , { field: 'HQty', title: '数量', sort: true, width: 100, totalRow: true}
                                    , { field: 'HQtyMust', title: '应收数量', sort: true, width: 100, totalRow: true}
                                    , { field: 'HMaterNumber', title: '物料代码', sort: true, width: 200 }
                                    , { field: 'HMaterName', title: '物料名称', sort: true, width: 200 }
                                    , { field: 'HMaterModel', title: '规格型号', sort: true, width: 200 }

 WebTM/views/ÁìÁÏ·¢»õ/ÆäËû³ö¿â/Kf_OtherOutBill_Fast.html

@@ -923,10 +923,11 @@
                                // , url: 'http://61.130.49.162:9090/WMSAPI///OtherOutBill/DisBillEntryList_Webs_Json'
                                , url: GetWEBURL() + '/MateOutBill/DisBillEntryList_Webs_New_Json1'
                                , toolbar: '#toolbarDemo'
                                , totalRow: true
                                , where: { HBillID: sInterID, HBillNo: sBillNo, HBillType: '1206', sMouldManagerCtl: sMouldManagerCtl, sFIFOCtl: sFIFOCtl }
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '重量', width: 150 }
                                    , { field: 'HQty', title: '重量', width: 150, totalRow: true}
                                    , { field: 'HAuxQty', title: '箱数', width: 150, totalRow: true }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }

 WebTM/views/ÁìÁÏ·¢»õ/ίÍâ³ö¿â/Kf_EntrustOutBill_Fast.html

@@ -862,12 +862,13 @@
                                elem: '#wl-table'
                                , url: GetWEBURL() + '/EntrustOut/DisBillEntryList_Entrust_Webs_Json'
                                , toolbar: '#toolbarDemo'
                                , totalRow: true
                                , where: { HBillID: sInterID, HBillType: '1211', sWhere: '' }
                                , cellMinWidth: 90
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', width: 150 }
                                    , { field: 'HQtyMust', title: '应发数量', width: 150 }
                                    , { field: 'HQty', title: '数量', width: 150, totalRow: true }
                                    , { field: 'HQtyMust', title: '应发数量', width: 150, totalRow: true }
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -950,11 +951,12 @@
                                // , url: 'http://61.130.49.162:9090/WMSAPI///EntrustOut/DisBillEntryList_Entrust_Webs_Json'
                                , url: GetWEBURL() + '/EntrustOut/DisBillEntryList_Entrust_Webs_Json'
                                , toolbar: '#toolbarDemo'
                                , totalRow: true
                                , where: { HBillID: sInterID, HBillType: '1211', sWhere: '' }
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', width: 150 }
                                    , { field: 'HQtyMust', title: '应发数量', width: 150 }
                                    , { field: 'HQty', title: '数量', width: 150, totalRow: true}
                                    , { field: 'HQtyMust', title: '应发数量', width: 150, totalRow: true}
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }

 WebTM/views/ÁìÁÏ·¢»õ/ÁìÁϳö¿â/Kf_MateOutBackBill_Fast.html

@@ -1078,13 +1078,14 @@
                , toolbar: '#toolbarDemo'
                , cellMinWidth: 90
                , limit: 50
                , totalRow: true
                , limits: [50, 500, 5000, 20000]
                , page: true
                , cols: [[
                    { type: 'radio' }
                    , { field: 'HSNO', title: '序号', width: 60 }
                    , { field: 'HQty', title: '数量', width: 80 }
                    , { field: 'HQtyMust', title: '应发数量', width: 80 }
                    , { field: 'HQty', title: '数量', width: 80, totalRow: true}
                    , { field: 'HQtyMust', title: '应发数量', width: 80, totalRow: true }
                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                    , { field: 'HMaterModel', title: '规格型号', width: 150 }

 WebTM/views/ÁìÁÏ·¢»õ/ÁìÁϳö¿â/Kf_MateOutBill_Fast.html

@@ -1140,14 +1140,15 @@
                elem: '#wl-table'
                , toolbar: '#toolbarDemo'
                , cellMinWidth: 90
                , totalRow: true
                , limit: 50
                , limits: [50, 500, 5000, 20000]
                , page: true
                    , cols: [[
                        { type: 'radio' }
                        , { field: 'HSNO', title: '序号', width: 60 }
                        , { field: 'HQty', title: '数量', width: 80 }
                        , { field: 'HQtyMust', title: '应发数量', width: 80 }
                        , { field: 'HQty', title: '数量', width: 80, totalRow: true}
                        , { field: 'HQtyMust', title: '应发数量', width: 80, totalRow: true}
                        , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                        , { field: 'HMaterName', title: '物料名称', width: 150 }
                        , { field: 'HMaterModel', title: '规格型号', width: 150 }

 WebTM/views/ÑéÊÕÈë¿â/²úÆ·Èë¿â/Kf_ProductInBackBill.html

@@ -705,11 +705,12 @@
                                elem: '#wl-table'
                                  , url: GetWEBURL() + '/ProductIn/DisBillEntryList_Webs_Json'
                                  , toolbar: '#toolbarDemo'
                                , totalRow: true
                                  , where: { HBillID: sInterID, HBillType: '1245', sWhere: '' }
                                  , cols: [[
                                        { type: 'radio' }
                                    , { field: 'HQty', title: '数量', width: 150 }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                      , { field: 'HQty', title: '数量', width: 150, totalRow: true}
                                      , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true}
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -757,14 +758,15 @@
                            element.tabChange('tab-ProductlnBackBill', '2');
                            table.render({
                                elem: '#wl-table'
                                , totalRow: true
                                //, url: 'http://61.130.49.162:9090/WMSAPI///ProductIn/DisBillEntryList_Webs_Json'
                              , url: GetWEBURL() + '/ProductInBackBill/DisBillEntryList_Webs_Json'
                              , toolbar: '#toolbarDemo'
                              , where: { HBillID: sInterID, HBillType: '1245', sWhere: '' }
                              , cols: [[
                                  { type: 'radio' }
                                , { field: 'HQty', title: '数量', width: 150 }
                                , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                  , { field: 'HQty', title: '数量', width: 150, totalRow: true}
                                  , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true}
                                , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                , { field: 'HMaterName', title: '物料名称', width: 150 }
                                , { field: 'HMaterModel', title: '规格型号', width: 150 }

 WebTM/views/ÑéÊÕÈë¿â/²úÆ·Èë¿â/Kf_ProductInBill_Fast.html

@@ -1358,11 +1358,12 @@
            var listOption = {
                elem: '#wl-table'
                , toolbar: '#toolbarDemo'
                , totalRow: true
                , cellMinWidth: 90
                , cols: [[
                    { type: 'radio' }
                    , { field: 'HQty', title: '数量', width: 150 }
                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                    , { field: 'HQty', title: '数量', width: 150, totalRow: true}
                    , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true }
                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                    , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -1439,12 +1440,13 @@
                                //, url: 'http://61.130.49.162:9090/WMSAPI///ProductIn/DisBillEntryList_Webs_Json'
                                , url: GetWEBURL() + '/ProductIn/DisBillEntryList_Webs_Json'
                                , toolbar: '#toolbarDemo'
                                , totalRow: true
                                , defaultToolbar: []
                                , where: { HBillID: sInterID, HBillType: '1202', sWhere: '' }
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', width: 150 }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                    , { field: 'HQty', title: '数量', width: 150, totalRow: true}
                                    , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true}
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }

 WebTM/views/ÑéÊÕÈë¿â/ÆäËûÈë¿â/Kf_OtherInBill_Fast.html

@@ -1052,7 +1052,7 @@
                , totalRow: true
                , cols: [[
                    { type: 'radio' }
                    , { field: 'HQty', title: '重量', width: 150, totalRow: true }
                    , { field: 'HQty', title: '数量', width: 150, totalRow: true }
                    , { field: 'HAuxQty', title: '箱数', width: 150, totalRow: true }
                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }

 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/Kf_POStockInBackBill.html

@@ -861,11 +861,12 @@
                                                    elem: '#wl-table' 
                                                  , url: GetWEBURL() + '/POStockInBackBill/DisBillEntryList_Webs_Json'
                                                  , toolbar: '#toolbarDemo'
                                                , totalRow: true
                                                  , where: { HBillID: sInterID, HBillType: '1239', sWhere: '' }
                                                  , cols: [[
                                                      { type: 'radio' }
                                                     , { field: 'HQty', title: '数量', width: 150 }
                                                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                                      , { field: 'HQty', title: '数量', width: 150, totalRow: true }
                                                      , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true }
                                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -923,14 +924,15 @@
                            element.tabChange('tab-POStockInBackBill', '2');
                            table.render({
                                elem: '#wl-table'
                                , totalRow: true
                                //, url: 'http://61.130.49.162:9090/WMSAPI///POStockInBackBill/DisBillEntryList_Webs_Json'
                               , url: GetWEBURL() + '/POStockInBackBill/DisBillEntryList_Webs_Json'
                                //, toolbar: '#toolbarDemo'
                              , where: { HBillID: sInterID, HBillType: '1239', sWhere: '' }
                              , cols: [[
                                  { type: 'radio' }
                                , { field: 'HQty', title: '数量', width: 80 }
                                , { field: 'HQtyMust', title: '应收数量', width: 80 }
                                  , { field: 'HQty', title: '数量', width: 80, totalRow: true}
                                  , { field: 'HQtyMust', title: '应收数量', width: 80, totalRow: true }
                                , { field: 'HMaterNumber', title: '物料代码', width: 100 }
                                , { field: 'HMaterName', title: '物料名称', width: 100 }
                                , { field: 'HMaterModel', title: '规格型号', width: 100 }

 WebTM/views/ÑéÊÕÈë¿â/Í⹺Èë¿â/Kf_POStockInBill_Fast.html

@@ -1104,12 +1104,13 @@
            var listOption = {
                elem: '#wl-table'
                , toolbar: '#toolbarDemo'
                , totalRow: true
                , cellMinWidth: 90
                , cols: [[
                    { type: 'radio' }
                    , { field: 'HSNO', title: '序号', width: 60 }
                    , { field: 'HQty', title: '数量', width: 80 }
                    , { field: 'HQtyMust', title: '应发数量', width: 80 }
                    , { field: 'HQty', title: '数量', width: 80, totalRow: true }
                    , { field: 'HQtyMust', title: '应发数量', width: 80, totalRow: true}
                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                    , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -1159,14 +1160,15 @@
                            table.render({
                                elem: '#wl-table'
                                , cellMinWidth: 80
                                , totalRow: true
                                //, url: 'http://61.130.49.162:9090/WMSAPI///POStockInBill/DisBillEntryList_Webs_Json'
                                , url: GetWEBURL() + '/POStockInBill/DisBillEntryList_Webs_Json'
                                //, toolbar: '#toolbarDemo'
                                , where: { HBillID: sInterID, HBillType: '1201', sWhere: '' }
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', sort: true, width: 100 }
                                    , { field: 'HQtyMust', title: '应收数量', sort: true, width: 100 }
                                    , { field: 'HQty', title: '数量', sort: true, width: 100, totalRow: true}
                                    , { field: 'HQtyMust', title: '应收数量', sort: true, width: 100, totalRow: true}
                                    , { field: 'HMaterNumber', title: '物料代码', sort: true, width: 200 }
                                    , { field: 'HMaterName', title: '物料名称', sort: true, width: 200 }
                                    , { field: 'HMaterModel', title: '规格型号', sort: true, width: 200 }

 WebTM/views/ÑéÊÕÈë¿â/ίÍâÈë¿â/Kf_EntrustInBill_Fast.html

@@ -858,12 +858,13 @@
                                elem: '#wl-table'
                                , url: GetWEBURL() + '/Kf_EntrustInBill/DisBillEntryList_Webs_Json'
                                , toolbar: '#toolbarDemo'
                                , totalRow: true
                                , where: { HBillID: sInterID, HBillType: '1210', sWhere: '' }
                                , cellMinWidth: 90
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', width: 150 }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                    , { field: 'HQty', title: '数量', width: 150, totalRow: true}
                                    , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true}
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }
@@ -932,11 +933,12 @@
                                //, url: 'http://61.130.49.162:9090/WMSAPI///Kf_EntrustInBill/DisBillEntryList_Webs_Json'
                                , url: GetWEBURL() + '/Kf_EntrustInBill/DisBillEntryList_Webs_Json'
                                , toolbar: '#toolbarDemo'
                                , totalRow: true
                                , where: { HBillID: sInterID, HBillType: '1210', sWhere: '' }
                                , cols: [[
                                    { type: 'radio' }
                                    , { field: 'HQty', title: '数量', width: 150 }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150 }
                                    , { field: 'HQty', title: '数量', width: 150, totalRow: true }
                                    , { field: 'HQtyMust', title: '应收数量', width: 150, totalRow: true }
                                    , { field: 'HMaterNumber', title: '物料代码', width: 150 }
                                    , { field: 'HMaterName', title: '物料名称', width: 150 }
                                    , { field: 'HMaterModel', title: '规格型号', width: 150 }