报表前端

jhz

2023-05-04 c16ece70619d3a32f632e92db447d94b80095726

 WebTM/views/³µ¼ä¹ÜÀí/±¨±í·ÖÎö/Sc_StationInBillList.html

@@ -309,33 +309,34 @@
            //Excel表格导出
            function SetExcel() {
                layer.confirm("确定导出所有数据吗", { title: "导出确认" }, function (index) {
                    window.location.href = GetWEBURL() + "/Sc_PackUnionBill/Sc_StationInBillSetExcel";
                    //var wait = layer.load();
                    //$.ajax({
                    //    type: "GET",
                    //    url: GetWEBURL() + "/Sc_PackUnionBill/Sc_StationInBillSetExcel",
                    //    success: function (result) {
                    //        window.location.reload();
                    //        //if (result.count == 1) {
                    //        //    layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                    //        //        // å¾—到frame索引
                    //        //        var index = layer.getFrameIndex(window.name);
                    //        //        //关闭当前frame
                    //        //        layer.close(index);
                    //        //        //修改为功后刷新界面
                    //        //        window.location.reload();
                    //        //    });
                    var HBeginDate = $("#HBeginDate").val();//开始日期
                    var HEndDate = $("#HEndDate").val();//结束日期
                    var HICMOBillNo = $("#HICMOBillNo").val(); //单据号
                    var HProcExchBillNo = $("#HProcExchBillNo").val();
                    var HName = $("#HName").val();

                    //        //} else {
                    //        //    layer.alert(result.code + result.Message, { icon: 5 });
                    //        //}
                    //        //layer.close(wait);
                    //    }, error: function () {
                    //        layer.close(wait);
                    //        layer.alert("接口请求失败!", { icon: 5 });
                    //    }
                    //});
                    if (HBeginDate) {
                        sWhere += " and CONVERT(varchar(100),进站时间, 23) >= '" + HBeginDate + "'";
                    }
                    if (HEndDate) {
                        sWhere += " and CONVERT(varchar(100),进站时间, 23) <= '" + HEndDate + "'";
                    }
                    if (HICMOBillNo) {
                        sWhere += " and è¿›ç«™ç”Ÿäº§è®¢å•å· like '%" + HICMOBillNo + "%'";
                    }
                    if (HProcExchBillNo) {
                        sWhere += " and æµè½¬å¡å· like '%" + HProcExchBillNo + "%'";
                    }
                    if (HName) {
                        sWhere += " and å·¥åºå like '%" + HName + "%'";
                    }
                    window.location.href = GetWEBURL() + "/Sc_PackUnionBill/Sc_StationInBillSetExcel?sWhere=" + sWhere;
                    // å¾—到frame索引
                    //var index = layer.getFrameIndex(window.name);
                    //关闭当前frame
                    layer.close(index);
                })
                sWhere = " where 1=1 ";
            }

            //预览
@@ -485,6 +486,7 @@
                $("#HEndDate").val("");
                $("#HICMOBillNo").val("");
                $("#HProcExchBillNo").val("");
                $("#HName").val("");
                sWhere = " where 1 = 1 ";
                get_Display(sWhere);
            }