1

yusijie

2024-08-16 08447b2355d97698faac7536e22edce3959dd61b

 WebTM/views/ÖÊÁ¿¹ÜÀí/¿â´æ¼ìÑéµ¥/QC_StockCheckBillList.html

@@ -93,6 +93,14 @@
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HName1" id="HName1">
                                            </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="HProject" id="HProject" class=" ForFilteringSchemes" lay-verify="HProject">
                                                    <!--动态渲染组织-->
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
@@ -455,7 +463,12 @@

            //#region æŸ¥è¯¢æŒ‰é’®
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery();
                if ($("#HProject").val() == 0) {
                    get_FastQuery();
                } else {
                    get_FastQuery(2);
                }

            });
            //#endregion
            //日期间隔下拉列表监听
@@ -506,8 +519,8 @@
                $("#HDate2").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化表格
                set_InitGrid();
                //查询
                //RoadHBillNo(sql);
                //获取项目号
                Get_HProject();
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();

@@ -649,9 +662,10 @@


            //#region å¿«é€Ÿè¿‡æ»¤
            function get_FastQuery() {
            function get_FastQuery(number) {
                var sqlWhere = " and 1=1 ";
                var HBillNo = $("#HBillNo").val();//单据号
                var HProject = $("#HProject").val();//项目号
                var HNumber = $("#HNumber").val();//物料编码
                var HName = $("#HName").val();//物料名称
                var HModel = $("#HModel").val();//规格型号
@@ -755,10 +769,16 @@
                    sqlWhere += " and å·¥åºæµè½¬å¡å· like '%" + HProcExchBillNo + "%'";

                if (HDate1) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate1 + "'";
                    sqlWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate1 + "'";
                }
                if (HDate2) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate2 + "'";
                    sqlWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate2 + "'";
                }
                if (number==2) {

                    if (HProject) {
                        sqlWhere += " and é¡¹ç›®å· like '%" + HProject + "%'";
                    }
                }
                RoadHBillNo(sqlWhere);
            }
@@ -774,7 +794,7 @@
                $("#HName").val("");
                $("#HReceiveEmp").val("");
                $("#HBillStatus").val("");

                $("#HProject").val("");
                $("#HNumber").val("");
                $("#HModel").val("");
                $("#HName1").val("");
@@ -798,6 +818,31 @@
            }
            //#endregion

            //#region èŽ·å–项目号
            function Get_HProject() {
                //获取项目号
                var HProjectList = '<option value="0" style="color:red;" selected></option>';
                $.ajax({
                    type: "get",
                    url: GetWEBURL() + "/Gy_Material/Get_HProject",
                    async: false,
                    data: { "HOrgID": sessionStorage["OrganizationID"] },
                    success: function (result) {
                        if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                            var data = result.data;
                            for (var i = 0; i < data.length; i++) {
                                HProjectList += '<option  style="color:blue;"  value="' + data[i].HName + '" >' + data[i].HName + '</option>';
                            }
                            $("#HProject").append(HProjectList);
                            form.render('select');

                        }
                        layer.closeAll("loading");
                    }
                })
            }
            //#endregion

            //新增
            function set_AddNew() {
                layer.open({