IPList.cshtml

@{
    ViewData["Title"] = "IPList";
    Layout = "~/Views/Shared/_Layout_layui.cshtml";
}

@section Css
{



}


<div class="demoTable layui-form" style="padding: 10px; background-color: #D4E7F0; ">
    <div class="layui-inline">
        <select name="Floor" id="sel_Floor" lay-verify="required" lay-filter="Floor" lay-search>
            <option value="">Select Floor</option>
        </select>
    </div>
    <div class="layui-input-inline">
        <select name="IP" id="sel_IP" lay-verify="required" lay-filter="IP" lay-search>
            <option value="">Select IP Segment</option>
        </select>
    </div>
    <div class="layui-input-inline">
        <select id="sel_SearchType" lay-verify="required" lay-filter="SearchType" lay-search>
            <option value="">Search Type</option>
            <option value="UserName">UserName</option>
            <option value="AssgnName">AssgnName</option>
            <option value="IPAddress">IPAddress</option>
            <option value="MacAddress">MacAddress</option>
            <option value="NodeName">NodeName</option>
        </select>
    </div>
    <div class="layui-inline">
        <input type="text" id="txt_SearchVal" name="SearchVal" required lay-verify="required" placeholder="Search Keywords" autocomplete="off" class="layui-input">
    </div>
    @*<div class="layui-inline">
            <input type="text" id="AssgnName" name="AssgnName" required lay-verify="required" placeholder="Assgn Name" autocomplete="off" class="layui-input">
        </div>
        <div class="layui-inline">
            <input type="text" id="IPAddress" name="IPAddress" required lay-verify="required" placeholder="IP Address" autocomplete="off" class="layui-input">
        </div>
        <div class="layui-inline">
            <input type="text" id="MacAddress" name="MacAddress" required lay-verify="required" placeholder="Mac Address" autocomplete="off" class="layui-input">
        </div>
        <div class="layui-inline">
            <input type="text" id="NodeName" name="NodeName" required lay-verify="required" placeholder="Node Name" autocomplete="off" class="layui-input">
        </div>*@
    <button class="layui-btn layui-btn-normal" id="btnSearch" data-type="reload" style="color:white;">Search</button>
    <button id="btnAdd" type="button" class="layui-btn layui-btn-primary layui-border-blue Add" style="margin-left:30px;">Assign</button>
    <button type="button" class="layui-btn layui-btn-primary layui-border-blue Add" id="btnUploadFiles" title="请使用规范模板填写规范数据导入" style=" margin-left: 0px;">
        <i class="layui-icon">&#xe67c;</i>导入
    </button>
    <button type="button" class="layui-btn layui-btn-primary layui-border-blue" id="btnExport" style=" margin-left: 0px;">
        <i class="layui-icon">&#xe67d;</i>导出
    </button>
    <a href="~/Downloads/IP管理导入模板.xlsx" class="layui-font-blue Add" target="_blank">导入模板</a>
</div>

<table class="layui-hide" id="tbList" lay-filter="tbList"></table>

<script type="text/html" id="tbListToolbar">

    <button type="button" title="edit" lay-event="edit" class="layui-btn layui-btn-primary layui-btn-sm Edit">
        <i class="layui-icon">&#xe642;</i>
    </button>
    <button type="button" title="delete" lay-event="del" class="layui-btn layui-btn-primary layui-btn-sm Delete">
        <i class="layui-icon">&#xe640;</i>
    </button>


</script>

@section Scripts
{
    <script src="~/lib/excel.js"></script>
    <script>

        layui.use(function () {
            var element = layui.element;
            var table = layui.table;
            var form = layui.form;
            var upload = layui.upload;

            var DataTable = [];
            var IPSegmentList = [];

            element.tabChange('docDemoTabBrief', 1);

            var tb = table.render({
                elem: '#tbList'
                , url: "/IPList/QueryablePageList"
                , height: 'full-180'
                , method: 'post'
                //, toolbar: true
                //, defaultToolbar: ['exports']
                //, title: 'IP管理数据表'
                , page: true
                , limits: [100, 200, 300, 500, 1000]
                , limit: 300 //每页默认显示的数量
                , cellMinWidth: 80 //全局定义常规单元格的最小宽度
                , where: {
                    Floor: "xxx"
                }
                //,
                //initSort: {
                //    field: 'Id' //排序字段，对应 cols 设定的各字段名
                //    , type: 'asc' //排序方式  asc: 升序、desc: 降序、null: 默认排序
                //}
                , cols: [[
                    /*{ type: 'numbers', width: 80, title: 'Number' }*/
                    , { field: 'Id', title: 'Id', hide: true }
                    , { field: 'IP', width: 140, title: 'IP' }
                    , { field: 'Floor', title: 'Floor' }
                    , { field: 'MacAddress', width: 140, title: 'MacAddress' }
                    , { field: 'NodeName', title: 'NodeName' }
                    , { field: 'UserName', title: 'UserName' }
                    , { field: 'Location', title: 'Location' }
                    , { field: 'PurposeName', title: 'PurposeName' }
                    , { field: 'Device', title: 'Device' }
                    /*, { field: 'ComputerName', title: 'ComputerName' }*/
                    , {
                        field: 'Assgn', title: 'Assgn', templet: function (d) {
                            var tstr = objValidate.IsNull(d.Assgn, "");
                            if (tstr != "") {
                                tstr = tstr.substring(tstr.lastIndexOf("|") + 1);
                            }
                            return tstr;
                        }
                    }
                    , {
                        field: 'Date', title: 'Date', width: 110, templet: function (d) {

                            return objDate.DateToStr(d.Date, "/", 10, '');
                        }
                    }
                    , {
                        field: 'Expired', title: 'Expired', width: 110, templet: function (d) {

                            return objDate.DateToStr(d.Expired, "/", 10, '');
                        }
                    }
                    , { field: 'Id', width: 130, title: 'Operate', toolbar: '#tbListToolbar' }

                ]]
                , done: function (res, curr, count) {
                    //console.log(res);
                    DataTable = res.data;
                    for (var i in res.data) {
                        $("tr[data-index=" + i + "]").css("background-color", res.data[i].Color);
                    }

                    ////得到当前页码
                    //console.log(curr);
                    ////得到数据总量
                    //console.log(count);

                    //功能权限控制
                    LoadFunJurisdiction();
                }
                , error: function (a, b) {
                    console.log(a);
                    console.log(b);
                }
            });

            var uploadInst = upload.render({
                elem: '#btnUploadFiles' //绑定元素
                , url: '/FileManage/UploadFile' //上传接口
                , data: { TargetTable: 'IPList' }
                , accept: 'file' //允许上传的文件类型
                , acceptMime: "xlsx/*"
                , exts: "xls|xlsx"
                , done: function (res) {
                    //上传完毕回调

                    $.ajax({
                        type: "Pst",
                        url: "/IPList/ExcelToTable",
                        async: true,
                        data: { FilePath: res.data.FilePath },
                        success: function (data) {

                            if (data.code == 0) {
                                layer.alert('导入成功!', { title: '提示', icon: 1 });
                                active.EditReload();
                            }
                            else if (data.code == -2) {

                                layer.alert('导入失败,IP:' + data.data + '存在不规范Mac地址!', { title: '提示', icon: 5 });
                            }
                            else if (data.code == -3) {
                                layer.alert('导入失败,表格中mac地址重复:' + data.data + '!', { title: '提示', icon: 5 });
                            }
                            else if (data.code == -4) {
                                layer.alert('导入失败,数据库中已存在同Floor重复mac地址:' + data.data + '!', { title: '提示', icon: 5 });
                            }
                            else {
                                layer.alert('导入失败,请检查模板规范,导入时不要打开文件占用进程!', { title: '提示', icon: 5 });
                            }


                        }
                    });

                }
                , error: function () {
                    //请求异常回调
                }
            });

            //$.ajax({
            //    type: "Pst",
            //    url: "/IPList/ExcelToTable",
            //    async: true,
            //    data: { FilePath: "" },
            //    success: function (data) {

            //        if (data.code == 0) {
            //            layer.alert('导入成功!', { title: '提示', icon: 1 });
            //            active.EditReload();
            //        }
            //        else if (data.code == -2) {

            //            layer.alert('导入失败,IP:' + data.data + '存在不规范Mac地址!', { title: '提示', icon: 5 });
            //        }
            //        else if (data.code == -3) {
            //            layer.alert('导入失败,表格中mac地址重复:' + data.data + '!', { title: '提示', icon: 5 });
            //        }
            //        else if (data.code == -4) {
            //            layer.alert('导入失败,数据库中已存在同Floor重复mac地址:' + data.data + '!', { title: '提示', icon: 5 });
            //        }
            //        else {
            //            layer.alert('导入失败,请检查模板规范,导入时不要打开文件占用进程!', { title: '提示', icon: 5 });
            //        }


            //    }
            //});

            var active = {
                reload: function () {

                    //Floor: $("#sel_Floor").val(), IP: $("#sel_IP").val(), UserName: $("#UserName").val(), AssgnName: $("#AssgnName").val()
                    //    , IPAddress: $("#IPAddress").val(), MacAddress: $("#MacAddress").val(), NodeName: $("#NodeName").val()

                    // 查询搜索用  数据重载
                    table.reloadData('tbList', {
                        where: {
                            Floor: $("#sel_Floor").val(), IP: $("#sel_IP").val(), SearchType: $("#sel_SearchType").val(), SearchVal: $("#txt_SearchVal").val()
                        }
                        , page: {
                            curr: 1 //重新从第 1 页开始
                        }
                    });
                },
                EditReload: function () {
                    //编辑时的重载，当前页码不变
                    table.reloadData('tbList', {
                        where: {
                            Floor: $("#sel_Floor").val(), IP: $("#sel_IP").val(), SearchType: $("#sel_SearchType").val(), SearchVal: $("#txt_SearchVal").val()
                        }
                    });
                }
                //加载Floor数据
                , LoadFloorList: function () {

                    $.ajax({
                        type: "Get",
                        url: "/SegmentList/QueryableNotDeletedDistinct",
                        async: true,
                        data: {},
                        success: function (data) {

                            $("#sel_Floor").empty();
                            var data = data.data;
                            var html = '<option value="">Select Floor</option>';
                            console.log(data);
                            for (var i = 0; i < data.length; i++) {
                                html += '<option value="' + data[i] + '">' + data[i] + '</option>';
                            }

                            $("#sel_Floor").append(html);
                            layui.form.render("select");

                        }
                    });

                }
                //加载IPSegment数据
                , LoadIPSegmentList: function () {

                    $.ajax({
                        type: "Get",
                        url: "/SegmentList/QueryableNotDeletedWhere",
                        async: true,
                        data: {},
                        success: function (data) {

                            $("#sel_IP").empty();

                            var data = data.data;
                            IPSegmentList = data;
                            var html = '<option value="">Select IP Segment</option>';
                            /*console.log(data);*/
                            $.each(data, function (i, v) {
                                //console.log(v.Floor + " | " + selVal);
                                //if (v.Floor == selVal) {
                                html += '<option value="' + v.IPSegment + '">' + v.IPSegment + '</option>';
                                //}

                            });

                            $("#sel_IP").append(html);
                            layui.form.render("select");

                        }
                    });

                }
                , AddSystemLog: function () {

                    $.post("/IPList/AddSystemLog", { OperateType: "export", OperateModule: "SearchIP", OperateFunction: "导出IP信息", OperatePage: "导出IP信息:IPList/Index" }, function (data) {

                    });

                }
            };

            //新增
            $("#btnAdd").click(function () {
                //window.location.href = "/IPList/Edit";
                layer.open({
                    type: 2,
                    title: 'Add IP Management',
                    shadeClose: true,
                    shade: false,
                    maxmin: true, //开启最大化最小化按钮
                    area: ['680px', '480px'],
                    content: '/IPList/Edit',
                    end: function () {
                        active.EditReload();
                    }
                });

            });

            table.on('tool(tbList)', function (obj) { // 双击 toolDouble
                var data = obj.data;
                //console.log(obj.data);
                //console.log(obj.data.id);
                if (obj.event === 'del') {
                    layer.confirm('确定要删除行吗?', { title: '提示', icon: 3 }, function (index) {

                        var Ids = [];
                        Ids.push(obj.data.Id);
                        var parameterData = { Id: obj.data.Id, MacAddress: "", Location: "", Device: "", NodeName: "", UserName: "", ComputerName: "", Expired: null, PurposeId: 0 };
                        //console.log(Ids);
                        $.post("/IPList/UpdateClearIP", parameterData, function (data) {

                            //console.log(ResponseData);
                            if (data.code == 0) {
                                //obj.del(); 为保证数据真实，此处改为重载
                                active.EditReload();
                                layer.close(index);
                            } else {
                                layer.alert('操作失败!', { title: '提示', icon: 5 });
                            }

                        });

                    });
                } else if (obj.event === 'edit') {
                    layer.open({
                        type: 2,
                        title: 'Edit Purpose',
                        shadeClose: true,
                        shade: false,
                        maxmin: true, //开启最大化最小化按钮
                        area: ['680px', '480px'],
                        content: '/IPList/Edit?Id=' + obj.data.Id + '',
                        end: function () {
                            active.EditReload();
                        }
                    });
                }
            });

            //选择Floor下拉框事件
            form.on('select(Floor)', function (data) {

                var selVal = data.value;
                var result = IPSegmentList.filter(function (item) {
                    return item.Floor == selVal;
                });


                $("#sel_IP").empty();

                var html = '<option value="">Select IP Segment</option>';


                if (!objValidate.NotNull(selVal)) {
                    result = IPSegmentList;
                }
                $.each(result, function (i, v) {

                    html += '<option value="' + v.IPSegment + '">' + v.IPSegment + '</option>';

                });

                $("#sel_IP").append(html);
                layui.form.render("select");

            });

            //选择IPSegment下拉框事件
            form.on('select(IP)', function (data) {

                console.log(data.value); //得到被选中的值
                var selVal = data.value;
                if (!objValidate.NotNull(selVal)) {
                    return false;
                }
                var result = IPSegmentList.find(function (item) {
                    return item.IPSegment == selVal;
                });

                $("#sel_Floor").val(result.Floor);
                layui.form.render("select");


            });


            //搜索
            $("#btnSearch").click(function () {

                active.reload();
            });


            //导出
            $("#btnExport").click(function () {

                //$.ajax({
                //    type: "Get",
                //    url: "/FileManage/ExportExcel2",
                //    async: true,
                //    data: {},
                //    success: function (data) {

                //        window.open('/Downloads/' + data.data, '_blank');
                //    }
                //});

                //console.log(tb);
                //console.log(DataTable);


                var ArrData = [];

                $.each(DataTable, function (i, v) {

                    var tstr = objValidate.IsNull(v.Assgn, "");
                    if (tstr != "") {
                        tstr = tstr.substring(tstr.lastIndexOf("|") + 1);
                    }


                    ArrData.push([v.IP, v.Floor, v.MacAddress, v.NodeName, v.UserName, v.Location, v.PurposeName, v.Device
                        , tstr, objDate.DateToStr(v.Date, "/", 10, ''), objDate.DateToStr(v.Expired, "/", 10, '')])
                });


                var exportData = []
                exportData.push.apply(exportData, [['IP', 'Floor', 'MacAddress', 'NodeName', 'UserName', 'Location', 'PurposeName', 'Device'
                    , 'Assgn', 'Date', 'Expired']]);
                exportData.push.apply(exportData, ArrData);


                LAY_EXCEL.exportExcel(exportData, 'IP管理表_' + objDate.GetCurrentDate() + '.xlsx', 'xlsx');

                active.AddSystemLog();

            });

            active.LoadFloorList();
            active.LoadIPSegmentList();

        });
    </script>

}