MES-WEB-LayUI.git

parent: 1ac73ee5 | 补丁 | 提交 | ignore whitespace

duhe

2025-06-06 45ac01dd54a732ea785f7526cad68dda5d69a1c1

宝工：提料计划报表

2个文件已修改

1个文件已添加

	WebTM/Properties/PublishProfiles/LAYUI.pubxml.user	14 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/WebTM.csproj	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebTM/views/生产管理/宝工排产/ReportPODemandPlanBillList_S.html	508 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 WebTM/Properties/PublishProfiles/LAYUI.pubxml.user

@@ -29,11 +29,11 @@
    </File>
    <File Include="bin/WebTM.dll">
      <publishTime>04/27/2021 20:31:08</publishTime>
      <publishTime>06/06/2025 10:35:48</publishTime>
      <publishTime>06/06/2025 13:13:09</publishTime>
    </File>
    <File Include="bin/WebTM.pdb">
      <publishTime>04/27/2021 20:31:08</publishTime>
      <publishTime>06/06/2025 10:35:48</publishTime>
      <publishTime>06/06/2025 13:13:09</publishTime>
    </File>
    <File Include="HtmlPage1.html">
      <publishTime>04/11/2023 16:34:42</publishTime>
@@ -5545,6 +5545,12 @@
    <File Include="views/çäº§ç®¡ç/å®å·¥æäº§/JIT_UnLockRequestBillList.html">
      <publishTime>02/20/2025 16:33:50</publishTime>
    </File>
    <File Include="views/çäº§ç®¡ç/å®å·¥æäº§/ReportPODemandPlanBillList.html">
      <publishTime>06/06/2025 11:20:51</publishTime>
    </File>
    <File Include="views/çäº§ç®¡ç/å®å·¥æäº§/ReportPODemandPlanBillList_S.html">
      <publishTime>06/06/2025 13:13:04</publishTime>
    </File>
    <File Include="views/çäº§ç®¡ç/å®¢æ·æ ç¾/Sc_CustomerTagInfoEdit.html">
      <publishTime>06/03/2025 16:35:43</publishTime>
    </File>
@@ -5771,10 +5777,10 @@
      <publishTime>06/03/2025 16:35:43</publishTime>
    </File>
    <File Include="views/çäº§ç®¡ç/æ¥è®¡åæ¥è¡¨/ReportPODemandPlanBillList.html">
      <publishTime>06/06/2025 11:15:02</publishTime>
      <publishTime>06/06/2025 11:20:49</publishTime>
    </File>
    <File Include="views/çäº§ç®¡ç/æ¥è®¡åæ¥è¡¨/ReportPODemandPlanBillList_S.html">
      <publishTime>06/03/2025 16:35:43</publishTime>
      <publishTime>06/06/2025 13:13:00</publishTime>
    </File>
    <File Include="views/çäº§ç®¡ç/æ¥è®¡åæ¥è¡¨/ReportWorkDemandPlanBillList.html">
      <publishTime>06/03/2025 16:35:43</publishTime>

 WebTM/WebTM.csproj

@@ -613,6 +613,7 @@
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_DayPlanPlatForm.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_LockRequestBillList.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\ReportPODemandPlanBillList.html" />
    <Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\ReportPODemandPlanBillList_S.html" />
    <Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoExcel.html" />
    <Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoEdit.html" />
    <Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoList.html" />

 WebTM/views/Éú²ú¹ÜÀí/±¦¹¤ÅÅ²ú/ReportPODemandPlanBillList_S.html

New file
@@ -0,0 +1,508 @@
ï»¿<!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">
    <link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all">
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.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/SetColumn.js"></script>
    <!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--><!--æ é¢çéä¸è½å¼ç¨æ¤jsæä»¶-->
</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" style="width: 85px;">ç»ç»</label>
                                    <div class="layui-input-block" style="margin-left: 120px; width: 185px;">
                                        <select name="HORGID" id="HORGID" lay-verify="HORGID">
                                            <!--å¨ææ¸²æç»ç»-->
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">æææ¥æ</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="date" class="layui-input" lay-verify="HBEGINDATE" name="HBEGINDATE" id="HBEGINDATE" style="padding-left: 78px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width: 85px;">è³:</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <input type="date" class="layui-input" lay-verify="HENDDATE" name="HENDDATE" id="HENDDATE" style="padding-left: 78px;">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">æ¥è¯¢</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">éç½®</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">å¯¼åº</button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="bthHideColumn" id="bthHideColumn">åè®¾ç½®</button>
                                <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                    <div class="layui-row" style="margin-top:10px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">äº§åç¼ç </label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                                </button>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;padding: 9px 18px;">ä¾åºå</label>
                                            <div class="layui-input-block" style="margin-left: 77px;">
                                                <input type="hidden" class="layui-input" lay-verify="HSUPPLIERID" name="HSUPPLIERID" id="HSUPPLIERID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <input type="text" class="layui-input" lay-verify="HSUPPLIERNAME" name="HSUPPLIERNAME" id="HSUPPLIERNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
                                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHSUPPLIERID" id="btnHSUPPLIERID" style="padding: 0 10px;float: right;margin-right: 3px;">
                                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                                </button>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">éæ±åå·</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HXQD" id="HXQD">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin: 10px 0 10px;">
                                        <div class="layui-inline">
                                            <label class="layui-form-label" style="width: 85px;">éè´è®¢åå·</label>
                                            <div class="layui-input-block" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" name="HPURORDERNO" id="HPURORDERNO">
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                    </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>
<script>
    var treeCkData = { id: 0 };
    var TagId = "";
    var TagParentId = "";
    layui.config({
        base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
    }).extend({
        index: 'lib/index', //ä¸»å¥å£æ¨¡å
        soulTable: '../ext/soulTable',
    }).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable','flow'], 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
            , tree = layui.tree
            , util = layui.util
            , soulTable = layui.soulTable
            , flow = layui.flow
        var sWhere = " where 1=1 ";
        var option = [];
        var ins;                        //ç¨äºå¯¼åºexcel
        var HModName = "ReportPODemandPlanBillList_S";
        //#endregion

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

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

        //#endregion

        //#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

        //#region äº§åç¼ç 
        form.on('submit(btnHMATERIALID)', function (data) {
            btnHMATERIALID();
        });
        //#endregion

        //#region ä¾åºå
        form.on('submit(btnHSUPPLIERID)', function (data) {
            btnHSUPPLIERID();
        });
        //#endregion

        //#region éç½®æé®
        form.on('submit(btnReSearch)', function (data) {
            set_ClearQuery();
        });
        //#endregion

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

        //#region å¯¼åºæé®
        form.on('submit(btnExport)', function (data) {
            getExportData();
        });
        //#endregion       

        //#region åè®¾ç½®æé®
        form.on('submit(bthHideColumn)', function (data) {
            get_HideColumnNoPageForPlan(HModName, option, get_FastQuery);
        });
        //#endregion

        //#endregion

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

        //#region åå§åçé¢
        function set_ClearBill() {
            //åå§åæ¥æ
            $("#HBEGINDATE").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 25), "yyyy-MM-dd"));//æææ¥æ
            var HEndDate = Format(new Date().setDate(new Date().getDate() + 25), "yyyy-MM-dd");
            $("#HENDDATE").val(HEndDate);//è³
            //çäº§ç»ç»å è½½
            Organ();
          
            //å¿«éè¿æ»¤
            get_FastQuery(1);

            ColFilter();
        }
        //#endregion

        //#region åå§åè¡¨æ ¼æ¹æ³
        function set_InitGrid() {
            var columns = [];

            columns.push({ type: 'checkbox', fixed: 'left', sort: true});
            columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true, filter: true });
            columns.push({ field: 'FMATERIALNAME', title: 'ç©æåç§°', sort: true, filter: true });
            columns.push({ field: 'FSPECIFICATION', title: 'ç©æè§æ ¼', sort: true, filter: true });
            columns.push({ field: 'FNAME', title: 'ä¾åºå', sort: true, filter: true  });
            columns.push({ field: 'FSUMQTY', title: 'åè®¡', sort: true, hide: true, filter: true  });
            columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true, hide: true, filter: true  });
            columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·', sort: true, hide: true, filter: true  });
            //columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦' });
            //columns.push({ field: 'HPOOrderBillNote', title: 'å¤æ³¨' });
            //columns.push({ field: 'éè´å', title: 'éè´å' });
            columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ', sort: true, filter: true });
            columns.push({ field: 'è®¡éåä½åç§°', title: 'è®¡éåä½', sort: true, filter: true });
            columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true });
            columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true });
            columns.push({ field: 'é¾ææææ»å', title: 'é¾ææææ»å', sort: true, totalRow: true, filter: true });
            columns.push({ field: 'æææ»å', title: 'æææ»å', sort: true, totalRow: true, filter: true });
            //è·åä¸¤ä¸ªææä¹é´çç¸å·®
            var time1 = Date.parse(new Date());//å¼å§æ¶é´
            var time2 = Date.parse(new Date($("#HENDDATE").val()));//ç»ææ¶é´
            var Days = Math.abs(parseInt((time2 - time1) / 1000 / 3600 / 24));
            //è·åå¹´
            var yyyy = new Date().getFullYear();
            //è·åæä»½
            var MM = new Date().getMonth() + 1;
            //è·åå¼å§æä»½çæå¤§å¤©æ°
            var SumMonth = new Date(yyyy, MM, 0).getDate(); //å¨æä¸¤æä¹å·®
            //è·åå¼å§æ¥æçå¤©æ°
            var HBEGINDATE = new Date(new Date()).getDate(); //è·åå¼å§æ¥æå¤©æ°

            var k = 0;//æ¶éå¾ªç¯æ¬¡æ°
            for (var j = 0; j <= (Days - k); j++) {
                var time_temp = Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd');
                if (isValidDate(time_temp)) {
                    columns.push({
                        field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true, filter: true, templet: function (d) {
                            //è·åå½åä»å¤©æå¤©åå¤©ä¸å¤©çæ¥æåç¬¦ä¸²
                            const dates = [];
                            const today = new Date();
                            for (let i = 0; i < 3; i++) {
                                const date = new Date(today);
                                date.setDate(today.getDate() + i);
                                const dateStr = date.toISOString().slice(0, 10);
                                dates.push(`${dateStr}`);
                            }
                            // å¦æè¡æ¥æå¨å½åæ¥æä¸å¤©åï¼ååå®¹æ çº¢
                            if ((this.field == dates[0] || this.field == dates[1]) && d[this.field] != null) {
                                return '<span style="color:Orange">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>';
                            }
                            else if ((this.field == dates[2]) && d[this.field] != null) {
                                return '<span style="color:red">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>';
                            }
                            else {
                                return d[this.field] == null ? 0 : d[this.field]
                            }
                        } })
                } else {
                    columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true, filter: true })
                }

                
                //è·¨å¹´çè¯ ä¼ä»ä¸æä¸å·å¼å§
                if (MM == 12 && (HBEGINDATE + j) == 31) {
                    yyyy += 1;
                    MM = 1;
                    SumMonth = new Date(yyyy, MM, 0).getDate();
                    HBEGINDATE = 0;
                    k += j;
                    j = 0;
                } else if ((HBEGINDATE + j) == SumMonth) { //è·¨æ ææ°å ä¸  å¤©æ°ä»ä¸å¼å§
                    HBEGINDATE = 0;
                    MM += 1;
                    SumMonth = new Date(yyyy, MM, 0).getDate();
                    k += j;
                    j = 0;
                }
            }
            columns.push({ field: 'ææè®¡ååè®¡', title: 'ææè®¡ååè®¡', filter: true  });

            option = {
                elem: '#mainTable'
                //, toolbar: '#toolbarDemo'
                , height: 'full-50'
                , page: true
                , cellMinWidth: 90
                , limit: 1000
                , limits: [50, 500,1000, 5000, 20000]
                , totalRow: true
                , loading: false
                , cols: [columns]
                , done: function (res, curr, count) {
                    soulTable.render(this);
                }
            };
        }
        //#endregion

        //è·åç»ç»
        function Organ() {
            //è·åç»å½é¡µç»ç»å
            var Organization = '';
            $.ajax({
                type: "get",
                url: GetWEBURL() + "/Web/GetOrganizations",
                success: function (result) {
                    if (result.count == 1) { // è¯´æéªè¯æåäºï¼
                        var data = result.data;
                        for (var i = 0; i < data.length; i++) {
                            Organization += '<option  style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';
                        }
                        $("#HORGID").append(Organization);
                        $("#HORGID").val(sessionStorage["OrganizationID"])
                        form.render('select');
                    }
                    layer.closeAll("loading");
                }
            })
        }

        //#region æ¥è¯¢
        function get_Display(sWhere) {
            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/JIT_Cg_PODemandPlanBill/ReportPODemandPlanBillList_S',
                type: "GET",
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], HBEGINDATE: $("#HBEGINDATE").val(), HENDDATE: $("#HENDDATE").val() },
                success: function (result) {
                    if (result.count == 1) {                      

                        option.data = result.data;
                        //åè®¾ç½®
                        DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option);
                        ins = table.render(option);
                        layer.close(ajaxLoad);
                        //layer.alert("æ¥è¯¢æå", { icon: 1 });
                    } else {
                        layer.close(ajaxLoad);
                        layer.alert(result.code + result.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
                }
            });
        }

        //#endregion

        //#region è·åå¯¼åºæ°æ®
        function getExportData() {
            data = option.data;
            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, data, "xls");
        }
        //#endregion

        //#region å¿«éè¿æ»¤
        function get_FastQuery(number) {
            var HORGID = "";
            if (number == 1) {
                HORGID = sessionStorage["OrganizationID"];
            }
            else {
                HORGID = $("#HORGID").val();//ç»ç»
            }
            var HBEGINDATE = $("#HBEGINDATE").val();//æææ¥æ
            var HENDDATE = $("#HENDDATE").val();//è³
            var HMATERIALID = $("#HMATERIALID").val();//ç©æ/äº§å
            var HSUPPLIERID = $("#HSUPPLIERID").val();//ä¾åºå
            var HXQD = $("#HXQD").val();//éæ±åå·
            var HPURORDERNO = $("#HPURORDERNO").val();//éè´è®¢åå·

            if (HBEGINDATE > HENDDATE) {
                return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!");
            }

            if (HORGID != "") {
                sWhere += " and a.HPURCHASEORGID= " + HORGID+" ";
            }

            if (HBEGINDATE != null && HENDDATE != null) {
                sWhere += " and HDate between ''" + HBEGINDATE + "'' and ''" + HENDDATE + "'' ";
            }
            if (HMATERIALID!=0) {
                sWhere += " and B.HMaterID= " + HMATERIALID+" ";
            }
            if (HSUPPLIERID!=0) {
                sWhere += " and A.HSupplierID= " + HSUPPLIERID + " ";
            }
            if (HXQD) {
                sWhere += " and HSeOrderBillNo like''% " + HXQD + "%'' ";
            }
            if (HPURORDERNO) {
                sWhere += " and HPOOrderBillNo like''%" + HPURORDERNO + "%'' ";
            }
            //åå§åè¡¨æ ¼
            set_InitGrid();
            get_Display(sWhere);
            sWhere = " where 1=1 ";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
        }
        //#endregion

        //#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³
        function set_ClearQuery() {
            $("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç»
            $("#HBEGINDATE").val(Format(new Date(new Date()), "yyyy-MM-dd"));//æææ¥æ
            $("#HENDDATE").val(Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + 30), "yyyy-MM-dd"));//è³
            $("#HMATERIALID").val("");//ç©æ/äº§å
            $("#HMATERIALNAME").val("");
            $("#HSUPPLIERID").val("");//ä¾åºå
            $("#HSUPPLIERNAME").val("");
            $("#HXQD").val("");//éæ±åå·
            $("#HPURORDERNO").val("");//éè´è®¢åå·
            form.render('select');
            sWhere = " where 1=1 ";
        }
        //#endregion

        //ç©æåè¡¨
        function btnHMATERIALID() {
            layer.open({
                type: 2 //ç±»å
                , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡
                , area: ['90%', '90%']//å¤§å°
                , title: 'ç©æåè¡¨'//æ é¢
                , shift: 2//å¼¹åºå¨ç»
                , content: ['../../åºç¡èµæ/å¬ç¨åºç¡èµæ/Gy_Material.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 === 0) {
                        return layer.msg('è¯·éæ©æ°æ®');
                    }
                    //è·åæ°æ®
                    $("#HMATERIALID").val(checkStatus.data[0].HItemID);
                    $("#HMATERIALNAME").val(checkStatus.data[0].ç©æåç§°);
                    layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
                }
                , btn2: function (index, layero) { }
            })
        }

        //ä¾åºå
        function btnHSUPPLIERID() {
            layer.open({
                type: 2 //ç±»å
                , skin: 'layui-layer-rim'//å ä¸è¾¹æ¡
                , area: ['90%', '90%']//å¤§å°
                , title: 'ä¾åºååè¡¨'//æ é¢
                , shift: 2//å¼¹åºå¨ç»
                , content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html?Type=HSup', '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 === 0) {
                        return layer.msg('è¯·éæ©æ°æ®');
                    }
                    //è·åæ°æ®
                    $("#HSUPPLIERID").val(checkStatus.data[0].HItemID);
                    $("#HSUPPLIERNAME").val(checkStatus.data[0].ä¾åºååç§°);
                    layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
                }
                , btn2: function (index, layero) { }
            })
        }

        //åææ¾ç¤ºä¸ææ¡
        function ColFilter() {
            var Organization = '<option  value="0" selected="selected" ></option>';
            for (var i = 1; i < option.cols[0].length; i++) {
                if (option.cols[0][i].hide != true) {
                    Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                }
            }
            $("#ColName").empty();
            $("#ColName").append(Organization);
            $("#ColName1").empty();
            $("#ColName1").append(Organization);
            $("#ColName2").empty();
            $("#ColName2").append(Organization);

            form.render('select');
        }

        //#endregion
        //ä»¥ä¸æ¯layuiæ¨¡å
    });
    function GetHSupNameValue(obj) {
        $("#HSUPPLIERID").val(obj[0].HItemID);
        $("#HSUPPLIERNAME").val(obj[0].ä¾åºååç§°);
    }
    function GetGyMaterial(obj) {
        $("#HMATERIALID").val(obj.HItemID);
        $("#HMATERIALNAME").val(obj.ç©æåç§°);
    }
</script>

			@@ -29,11 +29,11 @@
			</File>
			<File Include="bin/WebTM.dll">
			<publishTime>04/27/2021 20:31:08</publishTime>
			<publishTime>06/06/2025 10:35:48</publishTime>
			<publishTime>06/06/2025 13:13:09</publishTime>
			</File>
			<File Include="bin/WebTM.pdb">
			<publishTime>04/27/2021 20:31:08</publishTime>
			<publishTime>06/06/2025 10:35:48</publishTime>
			<publishTime>06/06/2025 13:13:09</publishTime>
			</File>
			<File Include="HtmlPage1.html">
			<publishTime>04/11/2023 16:34:42</publishTime>
			@@ -5545,6 +5545,12 @@
			<File Include="views/çäº§ç®¡ç/å®å·¥æäº§/JIT_UnLockRequestBillList.html">
			<publishTime>02/20/2025 16:33:50</publishTime>
			</File>
			<File Include="views/çäº§ç®¡ç/å®å·¥æäº§/ReportPODemandPlanBillList.html">
			<publishTime>06/06/2025 11:20:51</publishTime>
			</File>
			<File Include="views/çäº§ç®¡ç/å®å·¥æäº§/ReportPODemandPlanBillList_S.html">
			<publishTime>06/06/2025 13:13:04</publishTime>
			</File>
			<File Include="views/çäº§ç®¡ç/å®¢æ·æ ç¾/Sc_CustomerTagInfoEdit.html">
			<publishTime>06/03/2025 16:35:43</publishTime>
			</File>
			@@ -5771,10 +5777,10 @@
			<publishTime>06/03/2025 16:35:43</publishTime>
			</File>
			<File Include="views/çäº§ç®¡ç/æ¥è®¡åæ¥è¡¨/ReportPODemandPlanBillList.html">
			<publishTime>06/06/2025 11:15:02</publishTime>
			<publishTime>06/06/2025 11:20:49</publishTime>
			</File>
			<File Include="views/çäº§ç®¡ç/æ¥è®¡åæ¥è¡¨/ReportPODemandPlanBillList_S.html">
			<publishTime>06/03/2025 16:35:43</publishTime>
			<publishTime>06/06/2025 13:13:00</publishTime>
			</File>
			<File Include="views/çäº§ç®¡ç/æ¥è®¡åæ¥è¡¨/ReportWorkDemandPlanBillList.html">
			<publishTime>06/03/2025 16:35:43</publishTime>

			@@ -613,6 +613,7 @@
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_DayPlanPlatForm.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\JIT_LockRequestBillList.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\ReportPODemandPlanBillList.html" />
			<Content Include="views\çäº§ç®¡ç\å®å·¥æäº§\ReportPODemandPlanBillList_S.html" />
			<Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoExcel.html" />
			<Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoEdit.html" />
			<Content Include="views\çäº§ç®¡ç\å®¢æ·æ ç¾\Sc_CustomerTagInfoList.html" />

New file
			@@ -0,0 +1,508 @@
			ï»¿<!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">
			<link rel="stylesheet" href="../../../layuiadmin/ext/soulTable.css" media="all">
			<script src="../../../layuiadmin/zgqCustom/zgqCustom.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/SetColumn.js"></script>
			<!--<script src="../../../layuiadmin/soulTable.slim.js"></script>--><!--æ é¢çéä¸è½å¼ç¨æ¤jsæä»¶-->
			</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" style="width: 85px;">ç»ç»</label>
			<div class="layui-input-block" style="margin-left: 120px; width: 185px;">
			<select name="HORGID" id="HORGID" lay-verify="HORGID">
			<!--å¨ææ¸²æç»ç»-->
			</select>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">æææ¥æ</label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="date" class="layui-input" lay-verify="HBEGINDATE" name="HBEGINDATE" id="HBEGINDATE" style="padding-left: 78px;">
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">è³:</label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="date" class="layui-input" lay-verify="HENDDATE" name="HENDDATE" id="HENDDATE" style="padding-left: 78px;">
			</div>
			</div>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">æ¥è¯¢</button>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch">éç½®</button>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnExport" id="btnExport">å¯¼åº</button>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="bthHideColumn" id="bthHideColumn">åè®¾ç½®</button>
			<div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
			<div class="layui-row" style="margin-top:10px;">
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;padding: 9px 18px;">äº§åç¼ç </label>
			<div class="layui-input-block" style="margin-left: 77px;">
			<input type="hidden" class="layui-input" lay-verify="HMATERIALID" name="HMATERIALID" id="HMATERIALID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
			<input type="text" class="layui-input" lay-verify="HMATERIALNAME" name="HMATERIALNAME" id="HMATERIALNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHMATERIALID" id="btnHMATERIALID" style="padding: 0 10px;float: right;margin-right: 3px;">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;padding: 9px 18px;">ä¾åºå</label>
			<div class="layui-input-block" style="margin-left: 77px;">
			<input type="hidden" class="layui-input" lay-verify="HSUPPLIERID" name="HSUPPLIERID" id="HSUPPLIERID" value="0" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
			<input type="text" class="layui-input" lay-verify="HSUPPLIERNAME" name="HSUPPLIERNAME" id="HSUPPLIERNAME" value="" style="background-color:#efefef4d;width: 60%;display: inline-block;" readonly>
			<button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnHSUPPLIERID" id="btnHSUPPLIERID" style="padding: 0 10px;float: right;margin-right: 3px;">
			<i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
			</button>
			</div>
			</div>
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">éæ±åå·</label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="text" class="layui-input" name="HXQD" id="HXQD">
			</div>
			</div>
			</div>
			<div class="layui-row" style="margin: 10px 0 10px;">
			<div class="layui-inline">
			<label class="layui-form-label" style="width: 85px;">éè´è®¢åå·</label>
			<div class="layui-input-block" style="margin-left: 120px;">
			<input type="text" class="layui-input" name="HPURORDERNO" id="HPURORDERNO">
			</div>
			</div>
			</div>
			</div>
			</div>
			</div>
			<table class="" id="mainTable" lay-filter="mainTable"></table>
			</form>
			</div>
			</div>
			</div>
			</div>
			</body>
			</html>
			<script>
			var treeCkData = { id: 0 };
			var TagId = "";
			var TagParentId = "";
			layui.config({
			base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾
			}).extend({
			index: 'lib/index', //ä¸»å¥å£æ¨¡å
			soulTable: '../ext/soulTable',
			}).use(['tree', 'index', 'form', 'table', 'element', 'laypage', 'laydate', 'util','soulTable','flow'], 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
			, tree = layui.tree
			, util = layui.util
			, soulTable = layui.soulTable
			, flow = layui.flow
			var sWhere = " where 1=1 ";
			var option = [];
			var ins; //ç¨äºå¯¼åºexcel
			var HModName = "ReportPODemandPlanBillList_S";
			//#endregion

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

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

			//#endregion

			//#region è§¦åäºä»¶ï¼åæ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç

			//#region äº§åç¼ç
			form.on('submit(btnHMATERIALID)', function (data) {
			btnHMATERIALID();
			});
			//#endregion

			//#region ä¾åºå
			form.on('submit(btnHSUPPLIERID)', function (data) {
			btnHSUPPLIERID();
			});
			//#endregion

			//#region éç½®æé®
			form.on('submit(btnReSearch)', function (data) {
			set_ClearQuery();
			});
			//#endregion

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

			//#region å¯¼åºæé®
			form.on('submit(btnExport)', function (data) {
			getExportData();
			});
			//#endregion

			//#region åè®¾ç½®æé®
			form.on('submit(bthHideColumn)', function (data) {
			get_HideColumnNoPageForPlan(HModName, option, get_FastQuery);
			});
			//#endregion

			//#endregion

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

			//#region åå§åçé¢
			function set_ClearBill() {
			//åå§åæ¥æ
			$("#HBEGINDATE").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 25), "yyyy-MM-dd"));//æææ¥æ
			var HEndDate = Format(new Date().setDate(new Date().getDate() + 25), "yyyy-MM-dd");
			$("#HENDDATE").val(HEndDate);//è³
			//çäº§ç»ç»å è½½
			Organ();

			//å¿«éè¿æ»¤
			get_FastQuery(1);

			ColFilter();
			}
			//#endregion

			//#region åå§åè¡¨æ ¼æ¹æ³
			function set_InitGrid() {
			var columns = [];

			columns.push({ type: 'checkbox', fixed: 'left', sort: true});
			columns.push({ field: 'ç»ç»', title: 'éè´ç»ç»', sort: true, filter: true });
			columns.push({ field: 'FMATERIALNAME', title: 'ç©æåç§°', sort: true, filter: true });
			columns.push({ field: 'FSPECIFICATION', title: 'ç©æè§æ ¼', sort: true, filter: true });
			columns.push({ field: 'FNAME', title: 'ä¾åºå', sort: true, filter: true });
			columns.push({ field: 'FSUMQTY', title: 'åè®¡', sort: true, hide: true, filter: true });
			columns.push({ field: 'HPOOrderBillNo', title: 'éè´è®¢åå·', sort: true, hide: true, filter: true });
			columns.push({ field: 'HSeOrderBillNo', title: 'éæ±åå·', sort: true, hide: true, filter: true });
			//columns.push({ field: 'HPOOrderBillRemark', title: 'æè¦' });
			//columns.push({ field: 'HPOOrderBillNote', title: 'å¤æ³¨' });
			//columns.push({ field: 'éè´å', title: 'éè´å' });
			columns.push({ field: 'FNUMBER', title: 'ç©æç¼ç ', sort: true, filter: true });
			columns.push({ field: 'è®¡éåä½åç§°', title: 'è®¡éåä½', sort: true, filter: true });
			columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true });
			columns.push({ field: 'TQSUM', title: 'æææææ°é', sort: true, totalRow: true, filter: true });
			columns.push({ field: 'é¾ææææ»å', title: 'é¾ææææ»å', sort: true, totalRow: true, filter: true });
			columns.push({ field: 'æææ»å', title: 'æææ»å', sort: true, totalRow: true, filter: true });
			//è·åä¸¤ä¸ªææä¹é´çç¸å·®
			var time1 = Date.parse(new Date());//å¼å§æ¶é´
			var time2 = Date.parse(new Date($("#HENDDATE").val()));//ç»ææ¶é´
			var Days = Math.abs(parseInt((time2 - time1) / 1000 / 3600 / 24));
			//è·åå¹´
			var yyyy = new Date().getFullYear();
			//è·åæä»½
			var MM = new Date().getMonth() + 1;
			//è·åå¼å§æä»½çæå¤§å¤©æ°
			var SumMonth = new Date(yyyy, MM, 0).getDate(); //å¨æä¸¤æä¹å·®
			//è·åå¼å§æ¥æçå¤©æ°
			var HBEGINDATE = new Date(new Date()).getDate(); //è·åå¼å§æ¥æå¤©æ°

			var k = 0;//æ¶éå¾ªç¯æ¬¡æ°
			for (var j = 0; j <= (Days - k); j++) {
			var time_temp = Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd');
			if (isValidDate(time_temp)) {
			columns.push({
			field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true, filter: true, templet: function (d) {
			//è·åå½åä»å¤©æå¤©åå¤©ä¸å¤©çæ¥æåç¬¦ä¸²
			const dates = [];
			const today = new Date();
			for (let i = 0; i < 3; i++) {
			const date = new Date(today);
			date.setDate(today.getDate() + i);
			const dateStr = date.toISOString().slice(0, 10);
			dates.push(`${dateStr}`);
			}
			// å¦æè¡æ¥æå¨å½åæ¥æä¸å¤©åï¼ååå®¹æ çº¢
			if ((this.field == dates[0] \|\| this.field == dates[1]) && d[this.field] != null) {
			return '<span style="color:Orange">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>';
			}
			else if ((this.field == dates[2]) && d[this.field] != null) {
			return '<span style="color:red">' + (d[this.field] == null ? 0 : d[this.field]) + '</span>';
			}
			else {
			return d[this.field] == null ? 0 : d[this.field]
			}
			} })
			} else {
			columns.push({ field: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'yyyy-MM-dd'), title: Format(yyyy + '/' + MM + '/' + (HBEGINDATE + j), 'MM.dd'), width: 70, totalRow: true, filter: true })
			}


			//è·¨å¹´çè¯ ä¼ä»ä¸æä¸å·å¼å§
			if (MM == 12 && (HBEGINDATE + j) == 31) {
			yyyy += 1;
			MM = 1;
			SumMonth = new Date(yyyy, MM, 0).getDate();
			HBEGINDATE = 0;
			k += j;
			j = 0;
			} else if ((HBEGINDATE + j) == SumMonth) { //è·¨æ ææ°å ä¸ å¤©æ°ä»ä¸å¼å§
			HBEGINDATE = 0;
			MM += 1;
			SumMonth = new Date(yyyy, MM, 0).getDate();
			k += j;
			j = 0;
			}
			}
			columns.push({ field: 'ææè®¡ååè®¡', title: 'ææè®¡ååè®¡', filter: true });

			option = {
			elem: '#mainTable'
			//, toolbar: '#toolbarDemo'
			, height: 'full-50'
			, page: true
			, cellMinWidth: 90
			, limit: 1000
			, limits: [50, 500,1000, 5000, 20000]
			, totalRow: true
			, loading: false
			, cols: [columns]
			, done: function (res, curr, count) {
			soulTable.render(this);
			}
			};
			}
			//#endregion

			//è·åç»ç»
			function Organ() {
			//è·åç»å½é¡µç»ç»å
			var Organization = '';
			$.ajax({
			type: "get",
			url: GetWEBURL() + "/Web/GetOrganizations",
			success: function (result) {
			if (result.count == 1) { // è¯´æéªè¯æåäºï¼
			var data = result.data;
			for (var i = 0; i < data.length; i++) {
			Organization += '<option style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';
			}
			$("#HORGID").append(Organization);
			$("#HORGID").val(sessionStorage["OrganizationID"])
			form.render('select');
			}
			layer.closeAll("loading");
			}
			})
			}

			//#region æ¥è¯¢
			function get_Display(sWhere) {
			var ajaxLoad = layer.load();
			$.ajax({
			url: GetWEBURL() + '/JIT_Cg_PODemandPlanBill/ReportPODemandPlanBillList_S',
			type: "GET",
			data: { "sWhere": sWhere, "user": sessionStorage["HUserName"], HBEGINDATE: $("#HBEGINDATE").val(), HENDDATE: $("#HENDDATE").val() },
			success: function (result) {
			if (result.count == 1) {

			option.data = result.data;
			//åè®¾ç½®
			DisPlay_HideColumnForPlan(HModName, sessionStorage["HUserName"], option);
			ins = table.render(option);
			layer.close(ajaxLoad);
			//layer.alert("æ¥è¯¢æå", { icon: 1 });
			} else {
			layer.close(ajaxLoad);
			layer.alert(result.code + result.Message, { icon: 5 });
			}
			}, error: function () {
			layer.close(ajaxLoad);
			layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 });
			}
			});
			}

			//#endregion

			//#region è·åå¯¼åºæ°æ®
			function getExportData() {
			data = option.data;
			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, data, "xls");
			}
			//#endregion

			//#region å¿«éè¿æ»¤
			function get_FastQuery(number) {
			var HORGID = "";
			if (number == 1) {
			HORGID = sessionStorage["OrganizationID"];
			}
			else {
			HORGID = $("#HORGID").val();//ç»ç»
			}
			var HBEGINDATE = $("#HBEGINDATE").val();//æææ¥æ
			var HENDDATE = $("#HENDDATE").val();//è³
			var HMATERIALID = $("#HMATERIALID").val();//ç©æ/äº§å
			var HSUPPLIERID = $("#HSUPPLIERID").val();//ä¾åºå
			var HXQD = $("#HXQD").val();//éæ±åå·
			var HPURORDERNO = $("#HPURORDERNO").val();//éè´è®¢åå·

			if (HBEGINDATE > HENDDATE) {
			return layer.msg("å¼å§æ¥æä¸è½å°äºç»ææ¥æ!");
			}

			if (HORGID != "") {
			sWhere += " and a.HPURCHASEORGID= " + HORGID+" ";
			}

			if (HBEGINDATE != null && HENDDATE != null) {
			sWhere += " and HDate between ''" + HBEGINDATE + "'' and ''" + HENDDATE + "'' ";
			}
			if (HMATERIALID!=0) {
			sWhere += " and B.HMaterID= " + HMATERIALID+" ";
			}
			if (HSUPPLIERID!=0) {
			sWhere += " and A.HSupplierID= " + HSUPPLIERID + " ";
			}
			if (HXQD) {
			sWhere += " and HSeOrderBillNo like''% " + HXQD + "%'' ";
			}
			if (HPURORDERNO) {
			sWhere += " and HPOOrderBillNo like''%" + HPURORDERNO + "%'' ";
			}
			//åå§åè¡¨æ ¼
			set_InitGrid();
			get_Display(sWhere);
			sWhere = " where 1=1 ";//è°ç¨æ¥å£åæ¸ç©ºsWhereç¼å
			}
			//#endregion

			//#region éç½®è¿æ»¤æ¡ä»¶æ¹æ³
			function set_ClearQuery() {
			$("#HORGID").val(sessionStorage["OrganizationID"]);//ç»ç»
			$("#HBEGINDATE").val(Format(new Date(new Date()), "yyyy-MM-dd"));//æææ¥æ
			$("#HENDDATE").val(Format(new Date($("#HBEGINDATE").val()).setDate(new Date($("#HBEGINDATE").val()).getDate() + 30), "yyyy-MM-dd"));//è³
			$("#HMATERIALID").val("");//ç©æ/äº§å
			$("#HMATERIALNAME").val("");
			$("#HSUPPLIERID").val("");//ä¾åºå
			$("#HSUPPLIERNAME").val("");
			$("#HXQD").val("");//éæ±åå·
			$("#HPURORDERNO").val("");//éè´è®¢åå·
			form.render('select');
			sWhere = " where 1=1 ";
			}
			//#endregion

			//ç©æåè¡¨
			function btnHMATERIALID() {
			layer.open({
			type: 2 //ç±»å
			, skin: 'layui-layer-rim'//å ä¸è¾¹æ¡
			, area: ['90%', '90%']//å¤§å°
			, title: 'ç©æåè¡¨'//æ é¢
			, shift: 2//å¼¹åºå¨ç»
			, content: ['../../åºç¡èµæ/å¬ç¨åºç¡èµæ/Gy_Material.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 === 0) {
			return layer.msg('è¯·éæ©æ°æ®');
			}
			//è·åæ°æ®
			$("#HMATERIALID").val(checkStatus.data[0].HItemID);
			$("#HMATERIALNAME").val(checkStatus.data[0].ç©æåç§°);
			layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
			}
			, btn2: function (index, layero) { }
			})
			}

			//ä¾åºå
			function btnHSUPPLIERID() {
			layer.open({
			type: 2 //ç±»å
			, skin: 'layui-layer-rim'//å ä¸è¾¹æ¡
			, area: ['90%', '90%']//å¤§å°
			, title: 'ä¾åºååè¡¨'//æ é¢
			, shift: 2//å¼¹åºå¨ç»
			, content: ['../../åºç¡èµæ/éè´åºç¡èµæ/Gy_Supplier.html?Type=HSup', '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 === 0) {
			return layer.msg('è¯·éæ©æ°æ®');
			}
			//è·åæ°æ®
			$("#HSUPPLIERID").val(checkStatus.data[0].HItemID);
			$("#HSUPPLIERNAME").val(checkStatus.data[0].ä¾åºååç§°);
			layer.close(index); //å®è·åçå§ç»æ¯ææ°å¼¹åºçæä¸ªå±ï¼å¼æ¯ç±layeråé¨å¨æéå¢è®¡ç®ç
			}
			, btn2: function (index, layero) { }
			})
			}

			//åææ¾ç¤ºä¸ææ¡
			function ColFilter() {
			var Organization = '<option value="0" selected="selected" ></option>';
			for (var i = 1; i < option.cols[0].length; i++) {
			if (option.cols[0][i].hide != true) {
			Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
			}
			}
			$("#ColName").empty();
			$("#ColName").append(Organization);
			$("#ColName1").empty();
			$("#ColName1").append(Organization);
			$("#ColName2").empty();
			$("#ColName2").append(Organization);

			form.render('select');
			}

			//#endregion
			//ä»¥ä¸æ¯layuiæ¨¡å
			});
			function GetHSupNameValue(obj) {
			$("#HSUPPLIERID").val(obj[0].HItemID);
			$("#HSUPPLIERNAME").val(obj[0].ä¾åºååç§°);
			}
			function GetGyMaterial(obj) {
			$("#HMATERIALID").val(obj.HItemID);
			$("#HMATERIALNAME").val(obj.ç©æåç§°);
			}
			</script>