YL
2022-01-13 a6f5342a067da7d863a7d8d76e7d55d639fdc9ac
WebTM/views/Éú²ú¹ÜÀí/Éú²ú°ü×°µ¥/Sc_PackUnionBill.html
@@ -35,15 +35,9 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <label class="layui-form-label">日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" 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" id="HDate1" style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
@@ -102,7 +96,6 @@
    <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>
        var cols_arr = []; //存储表格头的数组
        var table = null;
@@ -129,20 +122,12 @@
            var pageIndex = 1;//当前页码值
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            //初始化表单插件
            set_InitFrom();
            //初始化界面
            set_ClearBill(sWhere);
            //#endregion
            //#region åˆå§‹åŒ–表单
            function set_InitFrom() {
                laydate.render({
                    elem: '#HDate'
                });
                laydate.render({
                    elem: '#HDate1'
                });
            }
            //#endregion
            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
@@ -191,15 +176,17 @@
                get_FastQuery();
            });
            //初始化表单
            function set_InitFrom() {
                laydate.render({
                    elem: '#HDate'
                });
            }
            //初始化界面
            function set_ClearBill(sWhere) {
                resultTableHead = []; //清空表头列,防止重复渲染
                //初始查询
                //get_Display(sWhere);
                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));
                get_FastQuery();
                get_Display(sWhere);
            }
            //加载网格
            function get_Display(sWhere) {
@@ -207,7 +194,7 @@
                $.ajax({
                    url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList',
                    type: "GET",
                    data: { "page": 1, "limit": 10 ,"sWhere": sWhere},
                    data: { "sWhere": sWhere, "page": 1, "limit": 10 },
                    datatype: "json",
                    success: function (data1) {
                        console.log(data1);
@@ -234,22 +221,22 @@
                        switch (data[i].Type) {
                            //int
                            case 'Int32':
                                cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true,width: 100 };
                                cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true };
                                break;
                            //Decimal
                            case 'Decimal':
                                cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true, width: 200 };
                                cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', totalRow: true, sort: true };
                                break;
                            default:
                                cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200};
                                cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', sort: true };
                        }
                    }
                }
                //填充表格数据
                table.render({
                    elem: '#mainTable',
                    toolbar: '#toolbarDemo',
                    url: GetWEBURL() + '/Sc_PackUnionBill/Get_PackUnionBillList',
                    toolbar: '#toolbarDemo',
                    title: '组托单列表',
                    cols: cols_arr,    //填充表格头数据,
                    id: 'mainTable', //表格id
@@ -268,10 +255,48 @@
                    }
                });
            }
            //删除
            function set_DeleteBill() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length === 1) {
                    var InterID = data[0].hmainid.toString();
                    //逻辑删除方法
                    layer.confirm("确认要删除吗,删除后不能恢复", { title: "删除确认" }, function (index) {
                        var wait = layer.load();
                        $.ajax({
                            type: "GET",
                            url: GetWEBURL() + "/Sc_PackUnionBill/set_DeleteBill", //方法所在页面和方法名
                            data: { "HInterID": InterID, "user": sessionStorage["HUserName"] },
                            success: function (result) {
                                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();
                                    });
                                } else {
                                    layer.alert(result.code + result.Message, { icon: 5 });
                                }
                                layer.close(wait);
                            }, error: function () {
                                layer.close(wait);
                                layer.alert("接口请求失败!", { icon: 5 });
                            }
                        });
                    })
                }
                else {
                    layer.msg('请选择一行数据删除!');
                }
            }
            //快速过滤
            function get_FastQuery() {
                var HDate = $("#HDate").val();//开始日期
                var HDate1 = $("#HDate1").val();//结束日期
                var HBillNo = $("#HBillNo").val(); //单据号
                var HDepartName = $("#HDepartName").val();
                var HMaterNumber = $("#HMaterNumber").val();
@@ -279,9 +304,6 @@
                var HMakerMan = $("#HMakerMan").val();
                if (HDate) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) >= '" + HDate + "'";
                }
                if (HDate1) {
                    sWhere += " and CONVERT(varchar(100),日期, 23) <= '" + HDate1 + "'";
                }
                if (HBillNo) {
                    sWhere += " and å•据号 like '%" + HBillNo + "%'";
@@ -298,20 +320,19 @@
                if (HMakerMan) {
                    sWhere += " and åˆ¶å•人 like '%" + HMakerMan + "%'";
                }
                get_Display(sWhere);
                set_ClearBill(sWhere);
                sWhere = "";
            }
            //重置过滤条件
            function set_ClearQuery() {
                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));
                $("#HBillNo").val("");
                $("#HDepartName").val("");
                $("#HMaterNumber").val("");
                $("#HMaterName").val("");
                $("#HMakerMan").val("");
                sWhere = " ";
                get_FastQuery();
                sWhere = "";
                get_Display(sWhere);
            }
            //刷新
            function set_Refresh() {