分步式调出单查询

杨乐

2022-01-04 ece775f860859e513b8f4e6b36b8f029e428cf46

分步式调出单查询

 WebTM/views/index.html

@@ -214,7 +214,7 @@
                                        <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>
                                        <dd><a lay-href="">分步式调出单维护n</a></dd>
                                        <dd><a lay-href="领料发货/分步式调出单/Fb_StepFoldOutBillList.html">分步式调出单维护</a></dd>
                                    </dl>
                                </dd>
                                <dd>

 WebTM/views/ÏúÊÛ¹ÜÀí/ÏúÊÛÍË»õµ¥/Add_Edit_Kf_ICStockBillMainList.html

@@ -40,7 +40,7 @@
                <form class="layui-form" lay-filter="component-form-group" action="">
                    <div class="layui-card-header">
                        <div class="layui-btn-group">
                            <button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Saver">保存</button>
                            <button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="set_SaveBill">保存</button>
                            <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">退出</button>
                        </div>
                    </div>
@@ -102,9 +102,6 @@
                                                </button>
                                            </div>
                                        </div>

                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">币别</label>
                                            <div class="layui-input-inline">
@@ -115,6 +112,9 @@
                                                </button>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row">

                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">汇率</label>
                                            <div class="layui-input-inline">
@@ -131,9 +131,6 @@
                                                </button>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="layui-row">
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">主管</label>
                                            <div class="layui-input-inline">
@@ -144,6 +141,9 @@
                                                </button>
                                            </div>
                                        </div>
                                    </div>

                                    <div class="layui-row">
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">源单类型</label>
                                            <div class="layui-input-inline">
@@ -163,14 +163,15 @@
                                                </button>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">交货地点</label>
                                            <div class="layui-input-inline">
                                                <input class="layui-input" name="HAddress" id="HAddress" autocomplete="off">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row">
                                     
                                        <div class="layui-col-xs4 layui-inline">
                                            <label class="layui-form-label">辅助字段</label>
                                            <div class="layui-input-inline">
@@ -188,7 +189,6 @@
                                    </div>
                                </div>
                            </div>


                            <!--制单信息-->
                            <div class="layui-tab-item">
@@ -386,38 +386,18 @@

            //选择选单号按钮
            form.on('submit(Xs_SeOutStockBackBillList)', function () {
                layer.open({
                    type: 2//弹窗类型
                    , skin: 'layui-layer-rim' //加上边框
                    , area: ['90%', '90%']//大小
                    , title: '退货通知单列表'//标题
                    , shift: 2//弹出动画
                    , content: ['../../销售管理/退货通知单/Xs_SeOutStockBackBillList.html', 'yes']
                    , btn: ['确定', '取消']
                    , btn1: function (index, layero) {//按钮【按钮一】的回调
                        var iframeWindow = window['layui-layer-iframe' + index]  //获取弹框页面
                        var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
                        alert(JSON.stringify(checkStatus))
                        if (checkStatus.data.length === 0) {
                            return layer.msg('请选择数据');
                        }
                        $("#HBillNo").val(checkStatus.data[0].HName);
                        $("#Hmainid").val(checkStatus.data[0].hmainid);
                        layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                    }
                    , btn2: function (index, layero) { }
                })
                get_CheckSeOutStockBackBill();
            });


            //保存按钮
            form.on('submit(set_SaveBill)', function (data) {
                if (!AllowLoadData())//数据验证
                if (AllowLoadData())//数据验证
                {
                    return false;
                    set_SaveBill(data);
                }
                else {
                    set_SaveBill(data);
                    return false;
                }
            });

@@ -554,7 +534,8 @@
            function set_SaveBill(data) {

                var sMainStr = JSON.stringify(data.field);

                alert(sMainStr)
                return false;
                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "Gy_Warehouse/ModifyByID", //方法所在页面和方法名
@@ -693,7 +674,7 @@
                })
            }

            //# ç›‘视下拉框是否源单
            //监视下拉框是否源单
            function set_CheckSelect() {

                Sctag = $("#HSourceBillType").val();
@@ -701,21 +682,44 @@
                switch (Sctag) {
                    //无源单新增
                    case '1':
                        $("#Hmainid").val("");
                        //$("#HMainSourceEntryID").val("0");
                        $('#Hbillid').attr("disabled", false);
                        $('#Xs_SeOutStockBackBillList').addClass("layui-btn-disabled").attr("disabled", true);
                        $("#Hmainid").val("0");//id
                        $("#Hbillid").val("");//文本
                        $('#Hbillid').attr("disabled", false);//文本框不禁用
                        $('#Xs_SeOutStockBackBillList').addClass("layui-btn-disabled").attr("disabled", true);//按钮禁用
                        OperationType = 1;
                        break;
                    //有源单新增
                    case '2':
                        $("#Hmainid").val("");
                        //$("#HMainSourceEntryID").val("0");
                        $('#Hbillid').attr("disabled", true);
                        $('#Xs_SeOutStockBackBillList').removeClass("layui-btn-disabled").attr("disabled", false);
                        $("#Hmainid").val("0");//id
                        $("#Hbillid").val("");//文本
                        $('#Hbillid').attr("disabled", true);//文本框禁用
                        $('#Xs_SeOutStockBackBillList').removeClass("layui-btn-disabled").attr("disabled", false);//按钮不禁用
                        OperationType = 2;
                        break;
                }
            }
            //选单号
            function get_CheckSeOutStockBackBill() {
                layer.open({
                    type: 2//弹窗类型
                    , skin: 'layui-layer-rim' //加上边框
                    , area: ['90%', '90%']//大小
                    , title: '退货通知单列表'//标题
                    , shift: 2//弹出动画
                    , content: ['../../销售管理/退货通知单/Xs_SeOutStockBackBillList.html', 'yes']
                    , btn: ['确定', '取消']
                    , btn1: function (index, layero) {//按钮【按钮一】的回调
                        var iframeWindow = window['layui-layer-iframe' + index]  //获取弹框页面
                        var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
                        if (checkStatus.data.length != 1) {
                            return layer.msg('请选择一条数据');
                        }
                        $("#Hbillid").val(checkStatus.data[0].单据号);
                        $("#Hmainid").val(checkStatus.data[0].hmainid);
                        layer.close(index); //它获取的始终是最新弹出的某个层，值是由layer内部动态递增计算的
                    }
                    , btn2: function (index, layero) { }
                })
            }

            function get_checkManager() {
@@ -749,7 +753,36 @@
            }
            //数据验证
            function AllowLoadData() {

               
                if ($("#HEmpID").val() == "" || $("#HEmpID").val() == null) {
                    layer.msg("业务员不能为空");
                    return false;
                }
                if ($("#HSupID").val() == "" || $("#HSupID").val() == null) {
                    layer.msg("供应商不能为空");
                    return false;
                }
                if ($("#HWHID").val() == "" || $("#HWHID").val() == null) {
                    layer.msg("仓库不能为空");
                    return false;
                }
                if ($("#HCurID").val() == "" || $("#HCurID").val() == null) {
                    layer.msg("币别不能为空");
                    return false;
                }
                if ($("#HDeptID").val() == "" || $("#HDeptID").val() == null) {
                    layer.msg("部门不能为空");
                    return false;
                }
                if ($("#HManagerID").val() == "" || $("#HManagerID").val() == null) {
                    layer.msg("主管不能为空");
                    return false;
                }
                if ($("#Hbillid").val() == "" || $("#Hbillid").val() == null) {
                    layer.msg("选单号不能为空");
                    return false;
                }
                return true;
            }

            //#endregion

 WebTM/views/ÁìÁÏ·¢»õ/·Ö²½Ê½µ÷³öµ¥/Fb_StepFoldOutBillList.html

New file
@@ -0,0 +1,342 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>分步式调出单维护</title>
    <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/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="date" class="layui-input" id="HBeginDate" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">结束日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HEndDate" 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="HBillNo" id="HBillNo" 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">
                                        <label class="layui-form-label">部门</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HDeptID" id="HDeptID" 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="MaterialCode" id="MaterialCode" style="width:190px;">
                                        </div>
                                    </div>
                                    <!--<hr />-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料名称</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="MaterialName" id="MaterialName" 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="SpecificationModel" id="SpecificationModel" 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="Warehouse" id="Warehouse" 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>
                            </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="btn-Add"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-view"><i class="layui-icon layui-icon-tips"></i>预览</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>打印</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-audit"><i class="layui-icon layui-icon-repeat"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Faudit"><i class="layui-icon layui-icon-refresh"></i>反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <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 () {

            //#region å…¬å…±å˜é‡
            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 = [];
            //#endregion

            //#region è¿›å…¥é¡µé¢åŠ è½½
            //初始化界面
            set_ClearBill();
            //#endregion

            //#region è§¦å‘事件：包括form.on(){}格式的所有点击事件、选择事件等
            // é‡ç½®æŒ‰é’®
            form.on('submit(btnReSearch)', function (data) {
                //清空过滤条件
                set_ClearQuery();
            });
            // æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
            });

            //#endregion

            //#region æ­¤é¡µé¢æ‰€æœ‰çš„方法
            // åˆå§‹åŒ–界面
            function set_ClearBill() {
                //初始化表格
                set_InitGrid();
                //查询
                get_Display(sWhere);
                //初始化日期
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
            }
            // åˆå§‹åŒ–表格方法
            function set_InitGrid() {
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , height: 'full-50'
                    , page: true
                    , cellMinWidth: 90
                    , limits: [50, 500, 1000, 5000, 10000]
                    , limit: 50
                    , cols: [[
                        { type: 'checkbox', fixed: 'left' }
                        , { field: 'hmainid', title: '单据ID', hide: true }
                        , { field: '日期', title: '日期', width: 125, templet: "<div>{{d.日期 ==null ?'':layui.util.toDateString(d.日期, 'yyyy-MM-dd')}}</div>" }
                        , { field: '单据号', title: '单据号', width: 195 }
                        , { field: '单据类型', title: '单据类型', width: 110 }
                        , { field: '物料代码', title: '物料代码', width: 110 }
                        , { field: '仓库代码', title: '仓库代码', width: 125 }
                        , { field: '仓库名称', title: '仓库', width: 125 }
                        , { field: '领料人代码', title: '领料人代码', width: 180 }
                        , { field: '领料人', title: '领料人', width: 125 }
                        , { field: '发料人代码', title: '发料人代码', width: 180 }
                        , { field: '发料人', title: '发料人', width: 125 }
                        , { field: 'HSecManagerID', title: 'HSecManagerID', width: 200, hide: true }
                        , { field: 'HKeeperID', title: 'HKeeperID', width: 200, hide: true }
                        , { field: 'HDeptID', title: 'HDeptID', width: 200, hide: true }
                        , { field: '部门代码', title: '部门代码', width: 115 }
                        , { field: '部门', title: '部门', width: 125 }
                        , { field: '摘要', title: '摘要', width: 125 }
                        , { field: '表头备注', title: '表头备注', width: 125 }
                        , { field: '内部单据号', title: '内部单据号', width: 115 }
                        , { field: 'HMaterID', title: 'HMaterID', width: 200, hide: true }
                        , { field: '规格型号', title: '规格型号', width: 125 }
                        , { field: 'HUnitID', title: 'Hunitid', width: 200, hide: true }
                        //, { field: '计量单位代码', title: '计量单位代码', width: 125 }
                        //, { field: '计量单位', title: '计量单位', width: 125 }
                        , { field: '调拨类型', title: '调拨类型', width: 100 }
                        , { field: '调入组织', title: '调入组织', width: 125 }
                        , { field: 'HWHID', title: 'HWHID', width: 200, hide: true }
                        , { field: '调入仓库代码', title: '调入仓库代码', width: 125 }
                        , { field: '调入仓库', title: '调入仓库', width: 125 }
                        , { field: 'HSPID', title: 'HSPID', width: 200, hide: true }
                        , { field: '调入仓位代码', title: '调入仓位代码', width: 125, hide: true }
                        , { field: '调入仓位', title: '调入仓位', width: 125, hide: true }
                        , { field: 'HSCWHID', title: 'HSCWHID', width: 200, hide: true }
                        , { field: '调出仓库代码', title: '调出仓库代码', width: 125 }
                        , { field: '调出仓库', title: '调出仓库', width: 125 }
                        , { field: 'HSCSPID', title: 'HSCSPID', width: 200, hide: true }
                        , { field: '调出仓位代码', title: '调出仓位代码', width: 125, hide: true }
                        , { field: '调出仓位', title: '调出仓位', width: 125, hide: true }
                        , { 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: '制单人', 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: 200, templet: "<div>{{d.审核日期 ==null ? '':layui.util.toDateString(d.审核日期, 'yyyy-MM-dd HH:mm:ss')}}</div>" }
                        , { 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: 200, templet: "<div>{{d.关闭日期 ==null ?'':layui.util.toDateString(d.关闭日期, 'yyyy-MM-dd HH:mm:ss')}}</div>" }
                        , { 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: 200, hide: true }
                        , { field: '源单子内码', title: '源单子内码', width: 200, hide: true }
                        , { field: '源单单号', title: '源单单号', width: 125 }
                        , { field: '源单类型', title: '源单类型', width: 125 }
                    ]]
                };
            }
            //进入页面显示的缓存列表
            function get_Display(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/Kf_StepFoldOutBill/GetStepFoldOutBillList',
                    type: "GET",
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], "Organization": sessionStorage["Organization"] },
                    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 });
                    }
                });
            }

            // å¿«é€Ÿè¿‡æ»¤
            function get_FastQuery() {
                var HDate = $("#HBeginDate").val();//开始日期
                var HDate1 = $("#HEndDate").val();//结束日期
                var HBillNo = $("#HBillNo").val();//单据号
                var HDeptID = $("#HDeptID").val();//部门
                var MaterialCode = $("#MaterialCode").val();//物料代码
                var MaterialName = $("#MaterialName").val();//物料名称
                var SpecificationModel = $("#SpecificationModel").val();//规格型号
                var HSourceBillNo = $("#HSourceBillNo").val();//源单单号
                var Warehouse = $("#Warehouse").val();//仓库
                var Hmaker = $("#Hmaker").val();//制单人
                if (HDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate + "'";
                }
                if (HDate1) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate1 + "'";
                }
                if (HBillNo) {
                    sWhere += " and å•æ®å· like '%" + HBillNo + "%'";
                }
                if (HDeptID) {
                    sWhere += " and éƒ¨é—¨ like '%" + HDeptID + "%'";
                }
                if (MaterialCode) {
                    sWhere += " and ç‰©æ–™ä»£ç  like '%" + MaterialCode + "%'";
                }
                if (MaterialName) {
                    sWhere += " and ç‰©æ–™åç§° like '%" + MaterialName + "%'";
                }
                if (SpecificationModel) {
                    sWhere += " and è§„格型号 like '%" + SpecificationModel + "%'";
                }
                if (HSourceBillNo) {
                    sWhere += " and æºå•å•å· like '%" + HSourceBillNo + "%'";
                }
                if (Warehouse) {
                    sWhere += " and ä»“库名称 like '%" + Warehouse + "%'";
                }
                if (Hmaker) {
                    sWhere += " and åˆ¶å•äºº like '%" + Hmaker + "%'";
                }
                get_Display(sWhere);
                sWhere = "";//调用接口后清空sWhere缓存
            }

            // é‡ç½®è¿‡æ»¤æ¡ä»¶
            function set_ClearQuery() {
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                $("#HBillNo").val("");//单据号
                $("#HDeptID").val();//部门
                $("#MaterialCode").val();//物料代码
                $("#MaterialName").val();//物料名称
                $("#SpecificationModel").val();//规格型号
                $("#HSourceBillNo").val();//源单单号
                $("#Warehouse").val();//仓库
                $("#Hmaker").val();//制单人
                sWhere = "";
                get_Display(sWhere);
            }

            //#endregion

            //以上是layui模块
        });
    </script>
</body>
</html>