数采临时表根据时间查询

pzy

2024-09-18 9596b181496994e301d8070960319ab1f3d56daa

数采临时表根据时间查询

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_InspectValue.html

@@ -201,9 +201,6 @@
                });
            })

            //获取登录组织
            Organ();

            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            //初始化界面
            set_ClearBill();
@@ -829,28 +826,6 @@
                })
            }
            //#endregion

            //获取组织
            function Organ() {
                //获取登录页组织列
                $.ajax({
                    type: "get",
                    url: GetWEBURL() + "/Web/GetOrganizations",
                    success: function (result) {
                        var Organization = "";
                        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 ColFilter() {

 WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_QualityStd.html

@@ -216,8 +216,6 @@
            function set_ClearBill() {
                //初始化表格
                set_InitGrid();
                //组织
                Organ();
                //查询
                get_Display(sWhere);
            }
@@ -334,28 +332,6 @@
                    }
                });
                layer.close(index);
            }

            //获取组织
            function Organ() {
                //获取登录页组织列
                $.ajax({
                    type: "get",
                    url: GetWEBURL() + "/Web/GetOrganizations",
                    success: function (result) {
                        var Organization = "";
                        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");
                    }
                })
            }

            //导入

 WebTM/views/É豸¹ÜÀí/É豸±¨±í/Sb_EquipMentCollectionTechParam.html

@@ -42,14 +42,14 @@
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" style="width:190px;">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HDate" 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 ForFilteringSchemes" id="HEndDate" style="width:190px;">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HDate1" style="width:190px;">
                                    </div>
                                </div>

@@ -328,17 +328,17 @@
                var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
                //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择
                if (HInitTimeCycle != -1) {
                    $('#HBeginDate').prop('disabled', true);
                    $('#HEndDate').prop('disabled', true);
                    $('#HDate').prop('disabled', true);
                    $('#HDate1').prop('disabled', true);

                    $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
                    $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                    $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
                    $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));

                    //执行查询方法
                    get_FastQuery();
                } else {
                    $('#HBeginDate').prop('disabled', false);
                    $('#HEndDate').prop('disabled', false);
                    $('#HDate').prop('disabled', false);
                    $('#HDate1').prop('disabled', false);
                }
            });

@@ -349,15 +349,15 @@
                //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择
                var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
                if (HInitTimeCycle != -1) {
                    $('#HBeginDate').prop('disabled', true);
                    $('#HEndDate').prop('disabled', true);
                    $('#HDate').prop('disabled', true);
                    $('#HDate1').prop('disabled', true);
                } else {
                    $('#HBeginDate').prop('disabled', false);
                    $('#HEndDate').prop('disabled', false);
                    $('#HDate').prop('disabled', false);
                    $('#HDate1').prop('disabled', false);
                }
                //根据日期间隔设置开始时间与结束时间
                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
                $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));
                //初始化表格
                set_InitGrid();
                //直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
@@ -554,7 +554,8 @@
            //快速过滤
            function get_FastQuery(table, option,number) {
                var HSourceCode = $("#HSourceCode").val();//设备编码
                var HTechParamName = $("#HTechParamName").val();//结束日期
                var HDate = $("#HDate").val();//开始日期
                var HDate1 = $("#HDate1").val();//结束日期
                //任意字段过滤
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
@@ -637,7 +638,12 @@
                if (HTechParamName) {
                    sWhere += " and å·¥è‰ºå‚数名称 like '%" + HTechParamName + "%'";
                }

                if (HDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate + "'";
                }
                if (HDate1) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate1 + "'";
                }
                sWhere += addSWhereByOpenType();
                //添加查询条件，根据当前登录用户关联职员返回数据
                //sWhere += " and HUserID =" + sessionStorage["Czybm"]
@@ -650,7 +656,8 @@
            //重置过滤条件
            function set_ClearQuery() {
                $("#HSourceCode").val("");
                $("#HTechParamName ").val("");
                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd")); //开始日期
                $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));  //结束日期
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
@@ -763,18 +770,18 @@
                            var HInitTimeCycle = $("#HInitTimeCycle").val() * 1;
                            //若日期间隔不为 ä»»æ„é—´éš”，则禁用开始日期与结束日期的选择
                            if (HInitTimeCycle != -1) {
                                $('#HBeginDate').prop('disabled', true);
                                $('#HEndDate').prop('disabled', true);
                                $('#HDate').prop('disabled', true);
                                $('#HDate1').prop('disabled', true);

                                $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
                                $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * HInitTimeCycle), "yyyy-MM-dd"));
                                $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));


                                //执行查询方法
                                get_FastQuery();
                            } else {
                                $('#HBeginDate').prop('disabled', false);
                                $('#HEndDate').prop('disabled', false);
                                $('#HDate').prop('disabled', false);
                                $('#HDate1').prop('disabled', false);
                            }

                            //执行查询方法

 WebTM/views/É豸¹ÜÀí/É豸±¨±í/Sb_EquipMentCollectionTechParam_Temp.html

@@ -393,7 +393,8 @@
                $.ajax({
                    url: GetWEBURL() + 'EquipMentCollectionTemp/list',
                    type: "GET",
                    data: { "sWhere": sWhere  , "user": sessionStorage["HUserName"]},
                    async: false,
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
@@ -500,7 +501,9 @@
            //快速过滤
            function get_FastQuery(table, option,number) {
                var HSourceCode = $("#HSourceCode").val();//设备编码
                var HTechParamName = $("#HTechParamName").val();//结束日期
                var HBeginDate = $("#HBeginDate").val(); //开始日期
                var HEndDate = $("#HEndDate").val(); //结束日期
                var HTechParamName = $("#HTechParamName").val(); //工艺参数名称
                //任意字段过滤
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
@@ -583,7 +586,12 @@
                if (HTechParamName) {
                    sWhere += " and å·¥è‰ºå‚数名称 like '%" + HTechParamName + "%'";
                }

                if (HBeginDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HBeginDate + "'";
                }
                if (HEndDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HEndDate + "'";
                }
                sWhere += addSWhereByOpenType();
                //添加查询条件，根据当前登录用户关联职员返回数据
                //sWhere += " and HUserID =" + sessionStorage["Czybm"]
@@ -597,6 +605,8 @@
            function set_ClearQuery() {
                $("#HSourceCode").val("");
                $("#HTechParamName ").val("");
                $("#HBeginDate").val("");
                $("#HEndDate").val("");
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");