MES-WEB-LayUI.git

parent: 461fe354 | 补丁 | 提交 | ignore whitespace

wtt

2025-01-04 bc88246fc9233fc74c5474b55e0eed2b0d7b9b58

添加仓库出入库报表

2个文件已添加

1个文件已修改

	WebTM/WebTM.csproj	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/仓存管理/条码报表/KF_StockInOutEntryReport.html	355 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/仓存管理/条码报表/KF_StockInOutRecordReport.html	393 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 WebTM/WebTM.csproj

@@ -368,6 +368,8 @@
    <Content Include="views\ä»åç®¡ç\ä»åºè°æ¨\Add_Edit_Kf_MoveStockBill.html" />
    <Content Include="views\ä»åç®¡ç\åæ¥å¼è°å¥å\Fb_StepFoldinBillEdit.html" />
    <Content Include="views\ä»åç®¡ç\æ¡ç åºå\KF_PonderationBillMain_Temp.html" />
    <Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\KF_StockInOutEntryReport.html" />
    <Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\KF_StockInOutRecordReport.html" />
    <Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\Kf_SellOutBarTraceReport.html" />
    <Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\KF_ICinventoryQueryReport.html" />
    <Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\Kf_StockInOutSumQueryReport.html" />

 WebTM/views/²Ö´æ¹ÜÀí/ÌõÂë±¨±í/KF_StockInOutEntryReport.html

New file
@@ -0,0 +1,355 @@
ï»¿<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<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/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/SetColumn.js"></script>
    <style>
        .layui-form-select .layui-input {
            padding-right: 15px;
            cursor: pointer;
        }
    </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="HMaterNumber" id="HMaterNumber" 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-row">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">ç©æç¼ç </label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" 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>
                                    </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_Export" id="Export"><i class="layui-icon layui-icon-export"></i>å¯¼åº</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>æ¥è¯¢</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <script>
        //#region æå æ³¨é
        //#endregion
        layui.config({
            base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
        }).extend({
            index: 'lib/index', //ä¸»å¥å£æ¨¡å
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], 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
                , soulTable = layui.soulTable
            var sWhere = "";
            var option = [];
            var ins;                        //ç¨äºå¯¼åºexcel
            var columns = "";
            var HModName = "KF_StockInOutEntryReport";
            var titleData = [];     //ä¸éè¦æ¾ç¤ºçåæ®µ
        //#endregion

        //#region è¿å¥é¡µé¢å³å è½½

            //åå§åçé¢
            set_ClearBill();

            //#region åå§åçé¢
            function set_ClearBill() {
                //è·åå¼å§æ¥æãç»ææ¥æ
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                //åå§åè¡¨æ ¼
                set_InitGrid();
                //æ¥è¯¢
                get_FastQuery();
            }
            //#endregion

            //#region åå§åè¡¨æ ¼
            function set_InitGrid() {
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , page: false
                    , totalRow: true
                    , height: 'full-50'
                    , cellMinWidth: 90
                    , limit: Number.MAX_VALUE
                    , done: function (res, curr, count) {
                        soulTable.render(this);
                    }
                };
            }
            //#endregion

            //#region ç¹å»è¡éä¸é«äº®
            table.on('row(mainTable)', function (obj) {
                //éä¸è¡æ¹åé¢è²
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //è®¾ç½®å¤éæ¡éä¸æ ·å¼
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è²
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡éä¸æ ·å¼
                    $(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è²
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨ææ¤å¤å¦æIDä¸æ£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤éä¸æªéä¸æ ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è²
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            //#endregion

        //#endregion

        //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³

            //#region å·¥å·æ äºä»¶
            table.on('toolbar(mainTable)', function (obj) {
                switch (obj.event) {
                    //å¯¼åºæé®
                    case 'btn_Export': get_Export();
                        break;
                    //æ¥è¯¢æé®
                    case 'btn_Query': get_FastQuery();
                        break;
                    //åè®¾ç½®
                    case 'btn_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option,get_FastQuery);
                        break;
                };
            });
            //#endregion

            //è¾å¥æ¡åè½¦æ¹æ³
            $('input').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });

            //æ¥è¯¢æé®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();

            });

            //#region å¯¼åºExecel
            function get_Export() {
                option.data.forEach((item) => {
                    for (let itemobj in item) {
                        if (item[itemobj] == null) {
                            item[itemobj] = "";
                        }
                        if (item[itemobj].length > 0) {  // åè®¾åæ®µåä¸ºfield
                            item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
                        }
                    }
                });

                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion

            //å¿«éè¿æ»¤
            function get_FastQuery() {
                var HBeginDate = $("#HBeginDate").val();        //å¼å§æ¥æ
                var HEndDate = $("#HEndDate").val();            //ç»ææ¥æ
                var HMaterNumber = $("#HMaterNumber").val();          //ç©æä»£ç 
                var HMaterName = $("#HMaterName").val();          //ç©æåç§°
                var HModel = $("#HModel").val();          //ç©æè§æ ¼åå·

                sWhere = "'" + HBeginDate + "','" + HEndDate + "','"  + HMaterName + "','" + HMaterNumber + "','" + HModel + "'";

                get_Display(sWhere);
                //è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
                sWhere = "";
            }

            //#region æ¥è¯¢
            function get_Display(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + '/WEBSController/GetKF_StockInOutEntryReport_Json',
                    async: false,    //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
                    data: { "sWhere": sWhere },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            //ç»ç©ºçæ°ç»èµå¼
                            for (var key in data1.list) {
                                //å¨æè·ååè¡¨ææåå
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //è·åä¸éè¦æ¾ç¤ºçåï¼Hå¼å¤´çåä¸æ¾ç¤ºï¼
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //å¨åè¡¨å·¦è¾¹æ·»å å¾éæ¡
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'åè®¡' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                            break;
                                        default:
                                            if (data[i].name == 'æ°é') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
                                            } else {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
                                            }
                                    }
                                }
                            }
                            option.cols = [col];
                            option.data = data1.data;
                            option.totalRow = true;
                            ins = table.render(option);
                            //åè®¾ç½®
                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], 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 });
                    }
                });
            }
            //#endregion

            //#region éç½®æé®
            form.on('submit(btnReSearch)', function (data) {
                //æ¸ç©ºè¿æ»¤æ¡ä»¶
                set_ClearQuery();
                get_FastQuery();
            });

            //éç½®è¿æ»¤æ¡ä»¶
            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"));   //ç»ææ¥æ
                $("#HMaterName").val("");           //ç©æ
                $("#HMaterNumber").val("");           //ç©æ
                $("#HModel").val("");           //ç©æ
                form.render('select');
            }

            //#endregion

        //#endregion


        });




    </script>

</body>
</html>

 WebTM/views/²Ö´æ¹ÜÀí/ÌõÂë±¨±í/KF_StockInOutRecordReport.html

New file
@@ -0,0 +1,393 @@
ï»¿<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<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/Scripts/json2.js"></script>
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/SetColumn.js"></script>
    <style>
        .layui-form-select .layui-input {
            padding-right: 15px;
            cursor: pointer;
        }
    </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" style="display:none">
                                    <label class="layui-form-label" style="width: 85px;">åæ®ç±»å</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                        <select name="HBillType" id="HBillType" lay-verify="HBillType" lay-filter="HBillType">
                                            <!--å¨ææ¸²æç»ç»-->
                                        </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="HMaterNumber" id="HMaterNumber" 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>
                            </div>
                        </div>
                        <div class="layui-tab layui-tab-card" lay-filter="test-handle">
                            <ul class="layui-tab-title">
                                <li class="layui-this">å¨é¨</li>
                                
                            </ul>
                        </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_Export" id="Export"><i class="layui-icon layui-icon-export"></i>å¯¼åº</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>æ¥è¯¢</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <script>
        //#region æå æ³¨é
        //#endregion
        layui.config({
            base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
        }).extend({
            index: 'lib/index', //ä¸»å¥å£æ¨¡å
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], 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
                , soulTable = layui.soulTable
            var sWhere = "";
            var option = [];
            var ins;                        //ç¨äºå¯¼åºexcel
            var HModName = "KF_StockInOutRecordReport";
            var titleData = [];     //ä¸éè¦æ¾ç¤ºçåæ®µ
        //#endregion

        //#region è¿å¥é¡µé¢å³å è½½

            //åå§åçé¢
            set_ClearBill();

            //#region åå§åçé¢
            function set_ClearBill() {
                //è·åå¼å§æ¥æãç»ææ¥æ
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                //è·ååæ®ç±»å
                BillType();
                //åå§åè¡¨æ ¼
                set_InitGrid();
                //æ¥è¯¢
                get_FastQuery();
            }
            //#endregion

            //#region   è·ååæ®ç±»å
            function BillType() {
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + "/WEBSController/GetICStockBill_BillType_Json",
                    async: false,    //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
                    success: function (result) {
                        var HBillType = "";
                        /*var li = "";*/
                        HBillType += '<option  style="color:blue;" value="å¨é¨">å¨é¨</option>';
                        if (result.count == 1) { // è¯´æéªè¯æåäºï¼
                            var data = result.data;
                            for (var i = 0; i < data.length; i++) {
                                HBillType += '<option  style="color:blue;" value="' + data[i].HBillTypeName + '">' + data[i].HBillTypeName + '</option>';
                                //æ·»å å¨æéé¡¹å¡
                                element.tabAdd('test-handle', {
                                    title: data[i].HBillTypeName,
                                    content: 'åå®¹-' + data[i].HBillTypeName,
                                    id: new Date().getTime(), // å®éä½¿ç¨ä¸è¬æ¯è§å®å¥½çidï¼è¿éä»¥æ¯«ç§æ°æ¨¡æ
                                    change: true // æ¯å¦æ·»å å®æ¯åå³èªå¨åæ¢
                                })
                                /*li += '<li>' + data[i].HBillTypeName + '</li>';*/
                            }
                            $("#HBillType").append(HBillType);
                            /*$(".layui-tab-title").append(li);*/
                            $("#HBillType").val("å¨é¨")
                            form.render('select');
                        }
                        layer.closeAll("loading");
                    }
                })
            }
            //#endregion

            //#region åå§åè¡¨æ ¼
            function set_InitGrid() {
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , page: false
                    , totalRow: true
                    , height: 'full-50'
                    , cellMinWidth: 90
                    , limit: Number.MAX_VALUE
                    , limits: [50, 500, 5000, 20000]
                    , done: function (res, curr, count) {
                        soulTable.render(this);
                    }
                };
            }
            //#endregion

            //#region ç¹å»è¡éä¸é«äº®
            table.on('row(mainTable)', function (obj) {
                //éä¸è¡æ¹åé¢è²
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //è®¾ç½®å¤éæ¡éä¸æ ·å¼
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è²
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡éä¸æ ·å¼
                    $(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è²
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨ææ¤å¤å¦æIDä¸æ£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤éä¸æªéä¸æ ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è²
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            })
            //#endregion

        //#endregion

        //#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³

            //#region å·¥å·æ äºä»¶
            table.on('toolbar(mainTable)', function (obj) {
                switch (obj.event) {
                    //å¯¼åºæé®
                    case 'btn_Export': get_Export();
                        break;
                    //æ¥è¯¢æé®
                    case 'btn_Query': get_FastQuery();
                        break;
                    //åè®¾ç½®
                    case 'btn_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option,get_FastQuery);
                        break;
                };
            });
            //#endregion

            //è¾å¥æ¡åè½¦æ¹æ³
            $('input').on('keydown', function (event) {
                if (event.keyCode == 13) {
                    get_FastQuery();
                }
            });
            //æ¥è¯¢æé®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();

            });
            form.on('select(HBillType)', function (data) {
                get_FastQuery();
            });
            // tab åæ¢äºä»¶
            element.on('tab(test-handle)', function (data) {
                $("#HBillType").val($(this).text());
                form.render('select');
                get_FastQuery();
            });
            //#region å¯¼åºExecel
            function get_Export() {
                option.data.forEach((item) => {
                    for (let itemobj in item) {
                        if (item[itemobj] == null) {
                            item[itemobj] = "";
                        }
                        if (item[itemobj].length > 0) {  // åè®¾åæ®µåä¸ºfield
                            item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, '');  // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
                        }
                    }
                });

                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion

            //å¿«éè¿æ»¤
            function get_FastQuery() {
                var HBeginDate = $("#HBeginDate").val();        //å¼å§æ¥æ
                var HEndDate = $("#HEndDate").val();            //ç»ææ¥æ
                var HBillType = $("#HBillType").val();          //åæ®ç±»å
                var HMaterNumber = $("#HMaterNumber").val();          //ç©æä»£ç 
                var HMaterName = $("#HMaterName").val();          //ç©æåç§°
                var HModel = $("#HModel").val();          //ç©æè§æ ¼åå·

                sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HBillType + "','" + HMaterName + "','" + HMaterNumber + "','" + HModel + "'";

                get_Display(sWhere);
                //è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
                sWhere = "";
            }

            //#region æ¥è¯¢
            function get_Display(sWhere) {
                var ajaxLoad = layer.load();
                $.ajax({
                    type: "GET",
                    url: GetWEBURL() + '/WEBSController/GetKF_StockInOutRecordReport_Json',
                    async: false,    //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
                    data: { "sWhere": sWhere },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            //ç»ç©ºçæ°ç»èµå¼
                            for (var key in data1.list) {
                                //å¨æè·ååè¡¨ææåå
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                                //è·åä¸éè¦æ¾ç¤ºçåï¼Hå¼å¤´çåä¸æ¾ç¤ºï¼
                                var patrn = new RegExp(/^h/i);
                                if (patrn.test(data1.list[key].ColmCols)) {
                                    titleData[key] = data1.list[key].ColmCols;
                                }
                            }
                            //å¨åè¡¨å·¦è¾¹æ·»å å¾éæ¡
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'åè®¡' });
                            for (var i = 0; i < data.length; i++) {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå
                                }
                                else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                            break;
                                        default:
                                            if (data[i].name == 'æ°é') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
                                            } else {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
                                            }
                                    }
                                }
                            }
                            option.cols = [col];
                            option.data = data1.data;
                            option.totalRow = true;
                            ins = table.render(option);
                            //åè®¾ç½®
                            DisPlay_HideColumn(HModName, sessionStorage["HUserName"], 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 });
                    }
                });
            }
            //#endregion

            //#region éç½®æé®
            form.on('submit(btnReSearch)', function (data) {
                //æ¸ç©ºè¿æ»¤æ¡ä»¶
                set_ClearQuery();
                get_FastQuery();
            });

            //éç½®è¿æ»¤æ¡ä»¶
            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"));   //ç»ææ¥æ
                $("#HBillType").val("å¨é¨");    //åæ®ç±»å
                $("#HMaterName").val("");           //ç©æ
                $("#HMaterNumber").val("");           //ç©æ
                $("#HModel").val("");           //ç©æ
                form.render('select');
            }

            //#endregion

        //#endregion


        });




    </script>

</body>
</html>

			@@ -368,6 +368,8 @@
			<Content Include="views\ä»åç®¡ç\ä»åºè°æ¨\Add_Edit_Kf_MoveStockBill.html" />
			<Content Include="views\ä»åç®¡ç\åæ¥å¼è°å¥å\Fb_StepFoldinBillEdit.html" />
			<Content Include="views\ä»åç®¡ç\æ¡ç åºå\KF_PonderationBillMain_Temp.html" />
			<Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\KF_StockInOutEntryReport.html" />
			<Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\KF_StockInOutRecordReport.html" />
			<Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\Kf_SellOutBarTraceReport.html" />
			<Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\KF_ICinventoryQueryReport.html" />
			<Content Include="views\ä»åç®¡ç\æ¡ç æ¥è¡¨\Kf_StockInOutSumQueryReport.html" />

New file
			@@ -0,0 +1,355 @@
			ï»¿<!DOCTYPE html>
			<html xmlns="http://www.w3.org/1999/xhtml">
			<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/Scripts/json2.js"></script>
			<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
			<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
			<script src="../../../layuiadmin/PubCustom.js"></script>
			<script src="../../../layuiadmin/HideButton.js"></script>
			<script src="../../../layuiadmin/soulTable.slim.js"></script>
			<script src="../../../layuiadmin/SetColumn.js"></script>
			<style>
			.layui-form-select .layui-input {
			padding-right: 15px;
			cursor: pointer;
			}
			</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="HMaterNumber" id="HMaterNumber" 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-row">
			<div class="layui-inline">
			<label class="layui-form-label">ç©æç¼ç </label>
			<div class="layui-input-block">
			<input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber" 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>
			</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_Export" id="Export"><i class="layui-icon layui-icon-export"></i>å¯¼åº</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>æ¥è¯¢</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button>
			</div>
			</script>
			</form>
			</div>
			</div>
			</div>
			</div>
			<script>
			//#region æå æ³¨é
			//#endregion
			layui.config({
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], 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
			, soulTable = layui.soulTable
			var sWhere = "";
			var option = [];
			var ins; //ç¨äºå¯¼åºexcel
			var columns = "";
			var HModName = "KF_StockInOutEntryReport";
			var titleData = []; //ä¸éè¦æ¾ç¤ºçåæ®µ
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½

			//åå§åçé¢
			set_ClearBill();

			//#region åå§åçé¢
			function set_ClearBill() {
			//è·åå¼å§æ¥æãç»ææ¥æ
			$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
			$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
			//åå§åè¡¨æ ¼
			set_InitGrid();
			//æ¥è¯¢
			get_FastQuery();
			}
			//#endregion

			//#region åå§åè¡¨æ ¼
			function set_InitGrid() {
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, page: false
			, totalRow: true
			, height: 'full-50'
			, cellMinWidth: 90
			, limit: Number.MAX_VALUE
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			};
			}
			//#endregion

			//#region ç¹å»è¡éä¸é«äº®
			table.on('row(mainTable)', function (obj) {
			//éä¸è¡æ¹åé¢è²
			var flag = !obj.tr.find(':checkbox:first').prop('checked');
			obj.tr.find(':checkbox').prop('checked', flag);
			if (flag) {
			obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //è®¾ç½®å¤éæ¡éä¸æ ·å¼
			$(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è²
			} else {
			obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡éä¸æ ·å¼
			$(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è²
			}
			//mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æIDä¸æ£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤éä¸æªéä¸æ ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è²
			layui.each(table.cache.mainTable, function (i, l) {
			if (obj.tr.index() == l.LAY_TABLE_INDEX) {
			l.LAY_CHECKED = flag;
			}
			});
			})
			//#endregion

			//#endregion

			//#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³

			//#region å·¥å·æ äºä»¶
			table.on('toolbar(mainTable)', function (obj) {
			switch (obj.event) {
			//å¯¼åºæé®
			case 'btn_Export': get_Export();
			break;
			//æ¥è¯¢æé®
			case 'btn_Query': get_FastQuery();
			break;
			//åè®¾ç½®
			case 'btn_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option,get_FastQuery);
			break;
			};
			});
			//#endregion

			//è¾å¥æ¡åè½¦æ¹æ³
			$('input').on('keydown', function (event) {
			if (event.keyCode == 13) {
			get_FastQuery();
			}
			});

			//æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {
			get_FastQuery();

			});

			//#region å¯¼åºExecel
			function get_Export() {
			option.data.forEach((item) => {
			for (let itemobj in item) {
			if (item[itemobj] == null) {
			item[itemobj] = "";
			}
			if (item[itemobj].length > 0) { // åè®¾åæ®µåä¸ºfield
			item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			}
			}
			});

			table.exportFile(ins.config.id, option.data, "xls");
			}
			//#endregion

			//å¿«éè¿æ»¤
			function get_FastQuery() {
			var HBeginDate = $("#HBeginDate").val(); //å¼å§æ¥æ
			var HEndDate = $("#HEndDate").val(); //ç»ææ¥æ
			var HMaterNumber = $("#HMaterNumber").val(); //ç©æä»£ç
			var HMaterName = $("#HMaterName").val(); //ç©æåç§°
			var HModel = $("#HModel").val(); //ç©æè§æ ¼åå·

			sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HMaterName + "','" + HMaterNumber + "','" + HModel + "'";

			get_Display(sWhere);
			//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			sWhere = "";
			}

			//#region æ¥è¯¢
			function get_Display(sWhere) {
			var ajaxLoad = layer.load();
			$.ajax({
			type: "GET",
			url: GetWEBURL() + '/WEBSController/GetKF_StockInOutEntryReport_Json',
			async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
			data: { "sWhere": sWhere },
			success: function (data1) {
			if (data1.count == 1) {
			var data = [];
			var col = [];
			//ç»ç©ºçæ°ç»èµå¼
			for (var key in data1.list) {
			//å¨æè·ååè¡¨ææåå
			data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
			//è·åä¸éè¦æ¾ç¤ºçåï¼Hå¼å¤´çåä¸æ¾ç¤ºï¼
			var patrn = new RegExp(/^h/i);
			if (patrn.test(data1.list[key].ColmCols)) {
			titleData[key] = data1.list[key].ColmCols;
			}
			}
			//å¨åè¡¨å·¦è¾¹æ·»å å¾éæ¡
			col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'åè®¡' });
			for (var i = 0; i < data.length; i++) {
			if ($.inArray(data[i].name, titleData) > -1) {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå
			}
			else {
			switch (data[i].Type) {
			//int
			case 'DateTime':
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
			break;
			default:
			if (data[i].name == 'æ°é') {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
			} else {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
			}
			}
			}
			}
			option.cols = [col];
			option.data = data1.data;
			option.totalRow = true;
			ins = table.render(option);
			//åè®¾ç½®
			DisPlay_HideColumn(HModName, sessionStorage["HUserName"], 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 });
			}
			});
			}
			//#endregion

			//#region éç½®æé®
			form.on('submit(btnReSearch)', function (data) {
			//æ¸ç©ºè¿æ»¤æ¡ä»¶
			set_ClearQuery();
			get_FastQuery();
			});

			//éç½®è¿æ»¤æ¡ä»¶
			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")); //ç»ææ¥æ
			$("#HMaterName").val(""); //ç©æ
			$("#HMaterNumber").val(""); //ç©æ
			$("#HModel").val(""); //ç©æ
			form.render('select');
			}

			//#endregion

			//#endregion


			});




			</script>

			</body>
			</html>

New file
			@@ -0,0 +1,393 @@
			ï»¿<!DOCTYPE html>
			<html xmlns="http://www.w3.org/1999/xhtml">
			<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/Scripts/json2.js"></script>
			<script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
			<script src="../../../layuiadmin/Scripts/webConfig.js"></script>
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
			<script src="../../../layuiadmin/PubCustom.js"></script>
			<script src="../../../layuiadmin/HideButton.js"></script>
			<script src="../../../layuiadmin/soulTable.slim.js"></script>
			<script src="../../../layuiadmin/SetColumn.js"></script>
			<style>
			.layui-form-select .layui-input {
			padding-right: 15px;
			cursor: pointer;
			}
			</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" style="display:none">
			<label class="layui-form-label" style="width: 85px;">åæ®ç±»å</label>
			<div class="layui-input-block" style="margin-left: 120px; width: 185px;">
			<select name="HBillType" id="HBillType" lay-verify="HBillType" lay-filter="HBillType">
			<!--å¨ææ¸²æç»ç»-->
			</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="HMaterNumber" id="HMaterNumber" 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>
			</div>
			</div>
			<div class="layui-tab layui-tab-card" lay-filter="test-handle">
			<ul class="layui-tab-title">
			<li class="layui-this">å¨é¨</li>

			</ul>
			</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_Export" id="Export"><i class="layui-icon layui-icon-export"></i>å¯¼åº</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Query" id="Query"><i class="layui-icon layui-icon-search"></i>æ¥è¯¢</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_HideColumn" id="HideColumn"><i class="layui-icon layui-icon-form"></i>åè®¾ç½®</button>
			<button type="button" class="layui-btn layui-btn-sm" lay-event="btn_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button>
			</div>
			</script>
			</form>
			</div>
			</div>
			</div>
			</div>
			<script>
			//#region æå æ³¨é
			//#endregion
			layui.config({
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			}).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], 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
			, soulTable = layui.soulTable
			var sWhere = "";
			var option = [];
			var ins; //ç¨äºå¯¼åºexcel
			var HModName = "KF_StockInOutRecordReport";
			var titleData = []; //ä¸éè¦æ¾ç¤ºçåæ®µ
			//#endregion

			//#region è¿å¥é¡µé¢å³å è½½

			//åå§åçé¢
			set_ClearBill();

			//#region åå§åçé¢
			function set_ClearBill() {
			//è·åå¼å§æ¥æãç»ææ¥æ
			$("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
			$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
			//è·ååæ®ç±»å
			BillType();
			//åå§åè¡¨æ ¼
			set_InitGrid();
			//æ¥è¯¢
			get_FastQuery();
			}
			//#endregion

			//#region è·ååæ®ç±»å
			function BillType() {
			$.ajax({
			type: "GET",
			url: GetWEBURL() + "/WEBSController/GetICStockBill_BillType_Json",
			async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
			success: function (result) {
			var HBillType = "";
			/var li = "";/
			HBillType += '<option style="color:blue;" value="å¨é¨">å¨é¨</option>';
			if (result.count == 1) { // è¯´æéªè¯æåäºï¼
			var data = result.data;
			for (var i = 0; i < data.length; i++) {
			HBillType += '<option style="color:blue;" value="' + data[i].HBillTypeName + '">' + data[i].HBillTypeName + '</option>';
			//æ·»å å¨æéé¡¹å¡
			element.tabAdd('test-handle', {
			title: data[i].HBillTypeName,
			content: 'åå®¹-' + data[i].HBillTypeName,
			id: new Date().getTime(), // å®éä½¿ç¨ä¸è¬æ¯è§å®å¥½çidï¼è¿éä»¥æ¯«ç§æ°æ¨¡æ
			change: true // æ¯å¦æ·»å å®æ¯åå³èªå¨åæ¢
			})
			/li += '<li>' + data[i].HBillTypeName + '</li>';/
			}
			$("#HBillType").append(HBillType);
			/$(".layui-tab-title").append(li);/
			$("#HBillType").val("å¨é¨")
			form.render('select');
			}
			layer.closeAll("loading");
			}
			})
			}
			//#endregion

			//#region åå§åè¡¨æ ¼
			function set_InitGrid() {
			option = {
			elem: '#mainTable'
			, toolbar: '#toolbarDemo'
			, page: false
			, totalRow: true
			, height: 'full-50'
			, cellMinWidth: 90
			, limit: Number.MAX_VALUE
			, limits: [50, 500, 5000, 20000]
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			};
			}
			//#endregion

			//#region ç¹å»è¡éä¸é«äº®
			table.on('row(mainTable)', function (obj) {
			//éä¸è¡æ¹åé¢è²
			var flag = !obj.tr.find(':checkbox:first').prop('checked');
			obj.tr.find(':checkbox').prop('checked', flag);
			if (flag) {
			obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked'); //è®¾ç½®å¤éæ¡éä¸æ ·å¼
			$(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//æ¹åå½åtrèæ¯é¢è²ååä½é¢è²
			} else {
			obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//åæ¶å¤éæ¡éä¸æ ·å¼
			$(obj.tr.selector).attr({ "style": "background:" });//åæ¶å½åtré¢è²
			}
			//mainTable ä¸ºè¡¨æ ¼ID æ³¨ææ¤å¤å¦æIDä¸æ£ç¡®å°å¯¼è´ä½ å¨çå¬å¤éæ¡æ¶è·åä¸å°ä½ éæ©çæ°æ®ï¼åé¢çåªæ¯æ·»å æå é¤éä¸æªéä¸æ ·å¼ä»¥åè®¾ç½®èæ¯è²ï¼åä½é¢è²
			layui.each(table.cache.mainTable, function (i, l) {
			if (obj.tr.index() == l.LAY_TABLE_INDEX) {
			l.LAY_CHECKED = flag;
			}
			});
			})
			//#endregion

			//#endregion

			//#region æ¬é¡µé¢ææè¢«è°ç¨çæ¹æ³

			//#region å·¥å·æ äºä»¶
			table.on('toolbar(mainTable)', function (obj) {
			switch (obj.event) {
			//å¯¼åºæé®
			case 'btn_Export': get_Export();
			break;
			//æ¥è¯¢æé®
			case 'btn_Query': get_FastQuery();
			break;
			//åè®¾ç½®
			case 'btn_HideColumn': get_HideColumnNoPage(HModName, sessionStorage["HUserName"], option,get_FastQuery);
			break;
			};
			});
			//#endregion

			//è¾å¥æ¡åè½¦æ¹æ³
			$('input').on('keydown', function (event) {
			if (event.keyCode == 13) {
			get_FastQuery();
			}
			});
			//æ¥è¯¢æé®
			form.on('submit(btnSearch)', function (data) {
			get_FastQuery();

			});
			form.on('select(HBillType)', function (data) {
			get_FastQuery();
			});
			// tab åæ¢äºä»¶
			element.on('tab(test-handle)', function (data) {
			$("#HBillType").val($(this).text());
			form.render('select');
			get_FastQuery();
			});
			//#region å¯¼åºExecel
			function get_Export() {
			option.data.forEach((item) => {
			for (let itemobj in item) {
			if (item[itemobj] == null) {
			item[itemobj] = "";
			}
			if (item[itemobj].length > 0) { // åè®¾åæ®µåä¸ºfield
			item[itemobj] = item[itemobj].toString().replace(/[\r\n]+/g, ''); // å°æ¢è¡ç¬¦æ¿æ¢ä¸ºç©ºåç¬¦ä¸²
			}
			}
			});

			table.exportFile(ins.config.id, option.data, "xls");
			}
			//#endregion

			//å¿«éè¿æ»¤
			function get_FastQuery() {
			var HBeginDate = $("#HBeginDate").val(); //å¼å§æ¥æ
			var HEndDate = $("#HEndDate").val(); //ç»ææ¥æ
			var HBillType = $("#HBillType").val(); //åæ®ç±»å
			var HMaterNumber = $("#HMaterNumber").val(); //ç©æä»£ç
			var HMaterName = $("#HMaterName").val(); //ç©æåç§°
			var HModel = $("#HModel").val(); //ç©æè§æ ¼åå·

			sWhere = "'" + HBeginDate + "','" + HEndDate + "','" + HBillType + "','" + HMaterName + "','" + HMaterNumber + "','" + HModel + "'";

			get_Display(sWhere);
			//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			sWhere = "";
			}

			//#region æ¥è¯¢
			function get_Display(sWhere) {
			var ajaxLoad = layer.load();
			$.ajax({
			type: "GET",
			url: GetWEBURL() + '/WEBSController/GetKF_StockInOutRecordReport_Json',
			async: false, //asyncç¨äºæ§å¶ï¼falseï¼åæ¥åï¼trueï¼å¼æ¥ï¼é»è®¤çæ¯trueï¼å³è¯·æ±é»è®¤çæ¯å¼æ¥è¯·æ±
			data: { "sWhere": sWhere },
			success: function (data1) {
			if (data1.count == 1) {
			var data = [];
			var col = [];
			//ç»ç©ºçæ°ç»èµå¼
			for (var key in data1.list) {
			//å¨æè·ååè¡¨ææåå
			data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
			//è·åä¸éè¦æ¾ç¤ºçåï¼Hå¼å¤´çåä¸æ¾ç¤ºï¼
			var patrn = new RegExp(/^h/i);
			if (patrn.test(data1.list[key].ColmCols)) {
			titleData[key] = data1.list[key].ColmCols;
			}
			}
			//å¨åè¡¨å·¦è¾¹æ·»å å¾éæ¡
			col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'åè®¡' });
			for (var i = 0; i < data.length; i++) {
			if ($.inArray(data[i].name, titleData) > -1) {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå
			}
			else {
			switch (data[i].Type) {
			//int
			case 'DateTime':
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
			break;
			default:
			if (data[i].name == 'æ°é') {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
			} else {
			col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true });
			}
			}
			}
			}
			option.cols = [col];
			option.data = data1.data;
			option.totalRow = true;
			ins = table.render(option);
			//åè®¾ç½®
			DisPlay_HideColumn(HModName, sessionStorage["HUserName"], 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 });
			}
			});
			}
			//#endregion

			//#region éç½®æé®
			form.on('submit(btnReSearch)', function (data) {
			//æ¸ç©ºè¿æ»¤æ¡ä»¶
			set_ClearQuery();
			get_FastQuery();
			});

			//éç½®è¿æ»¤æ¡ä»¶
			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")); //ç»ææ¥æ
			$("#HBillType").val("å¨é¨"); //åæ®ç±»å
			$("#HMaterName").val(""); //ç©æ
			$("#HMaterNumber").val(""); //ç©æ
			$("#HModel").val(""); //ç©æ
			form.render('select');
			}

			//#endregion

			//#endregion


			});




			</script>

			</body>
			</html>