到期日期比生产日期早一天，询价单，报价单，excel生成送货单

yusijie

2023-08-03 c3f90af33300eb54fe704060068a32a84aac0737

到期日期比生产日期早一天，询价单，报价单，excel生成送货单

 WebSRM/WebSRM.csproj

@@ -727,6 +727,7 @@
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\useradmin.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\modules\workorder.js" />
    <None Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\jquery-1.4.1-vsdoc.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\general.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\jquery-1.4.1.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\jquery-1.4.1.min.js" />
    <Content Include="layuiAdmin.std-v1.2.1\src\layuiadmin\Scripts\json2.js" />
@@ -861,6 +862,7 @@
    <Content Include="layuiAdmin.std-v1.2.1\src\views\set\user\password.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\set\说明.txt" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\HBarPlanPrint.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_AskPriceBillList.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_BarCodeBill_Bak.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POInStockBackBillList.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POInStockBill_Edit.html" />
@@ -874,6 +876,7 @@
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_EntrustOrderTrackBill.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POInStockTrackBill.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POOrderBillList_Excel.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_QuotePriceBillList.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_SystemLogList.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POOrderTrackBill.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POOrderBillList.html" />

 WebSRM/layuiAdmin.std-v1.2.1/src/layuiadmin/Scripts/general.js

New file
@@ -0,0 +1,93 @@
/**
 *格式化时间
 *
 */
function Format(datetime, fmt) {
    if (parseInt(datetime) == datetime) {
        if (datetime.length == 10) {
            datetime = parseInt(datetime) * 1000;
        } else if (datetime.length == 13) {
            datetime = parseInt(datetime);
        }
    }
    datetime = new Date(datetime);
    var o = {
        "M+": datetime.getMonth() + 1,                 //月份   
        "d+": datetime.getDate(),                    //日   
        "h+": datetime.getHours(),                   //小时   
        "m+": datetime.getMinutes(),                 //分   
        "s+": datetime.getSeconds(),                 //秒   
        "q+": Math.floor((datetime.getMonth() + 3) / 3), //季度   
        "S": datetime.getMilliseconds()             //毫秒   
    };
    if (/(y+)/.test(fmt))
        fmt = fmt.replace(RegExp.$1, (datetime.getFullYear() + "").substr(4 - RegExp.$1.length));
    for (var k in o)
        if (new RegExp("(" + k + ")").test(fmt))
            fmt = fmt.replace(RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length)));
    return fmt;
}



/**
 *格式化时间
 *
 */
function Pub_Format(datetime, fmt) {
    if (parseInt(datetime) == datetime) {
        if (datetime.length == 10) {
            datetime = parseInt(datetime) * 1000;
        } else if (datetime.length == 13) {
            datetime = parseInt(datetime);
        }
    }
    datetime = new Date(datetime);
    var o = {
        "M+": datetime.getMonth() + 1,                 //月份   
        "d+": datetime.getDate(),                    //日   
        "h+": datetime.getHours(),                   //小时   
        "m+": datetime.getMinutes(),                 //分   
        "s+": datetime.getSeconds(),                 //秒   
        "q+": Math.floor((datetime.getMonth() + 3) / 3), //季度   
        "S": datetime.getMilliseconds()             //毫秒   
    };
    if (/(y+)/.test(fmt))
        fmt = fmt.replace(RegExp.$1, (datetime.getFullYear() + "").substr(4 - RegExp.$1.length));
    for (var k in o)
        if (new RegExp("(" + k + ")").test(fmt))
            fmt = fmt.replace(RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length)));
    return fmt;
}

/**
 *退出
 *
 *
 */
function Pub_Close(closeType) {
    if (closeType == 1) {
        //关闭弹窗
        var index = parent.layer.getFrameIndex(window.name);
        parent.layer.close(index);
    } else if (closeType == 2) {
        //关闭页签
        parent.layui.admin.events.closeThisTabs();
    }
}

/**
 *获取解析参数
 *
 * 
 */
function get_UrlVars() {
    var vars = [], hash;
    var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');
    for (var i = 0; i < hashes.length; i++) {
        hash = hashes[i].split('=');
        vars.push(hash[0]);
        vars[hash[0]] = hash[1];
    }
    return vars;
}

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_AskPriceBillList.html

New file
@@ -0,0 +1,624 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>供应商询价单列表</title>
    <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
    <script src="../../layuiadmin/layui/layui.js"></script>
    <script src="../../../../Scripts/webConfig.js"></script>
    <script src="../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
            <div class="layui-card" style="padding: 1px">
                <div class="layui-card-body" style="padding: 1px;">
                    <form class="layui-form" action="" lay-filter="component-form-group">
                        <div class="layui-collapse">
                            <div class="layui-colla-item">
                                <div class="layui-colla-title layui-inline">
                                    <div class="layui-inline">
                                        <span>更多</span>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HDate">
                                    </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">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HBillNo" id="HBillNo">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <div class="layui-colla-content">
                                    <div class="layui-row" style=" margin-bottom: 10px;">
                                        <label class="layui-form-label">业务类型</label>
                                        <div class="layui-input-inline">
                                            <select id="HProcType" name="HProcType" lay-filter="">
                                                <option value="" selected>请选择</option>
                                                <option value="外购入库">外购入库</option>
                                                <option value="委外加工">委外加工</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">物料代码</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">物料名称</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HMaterName" id="HMaterName">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">                                                              
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>                              
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>
<script>
    layui.config({
        base: '../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index', //主入口模块
    }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {

        //#region 公共变量
        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , element = layui.element
            , laypage = layui.laypage
            , laydate = layui.laydate
        var sWhere = "";
        var titleData = ["hmainid", "hentryid", "HEntryID", "HDeptID", "HMaterID", "HSupID", "HEmpID", "HPayConditionID", "HCurID","HUnitID"];
        var option = [];
        var HModName = "Sup_AskPriceBillList";

        //#endregion

        //#region 进入页面即加载

        //初始化界面
        set_ClearBill();

        //#endregion

        //#region 触发事件：包括form.on(){}格式的所有点击事件、选择事件等
        //头工具栏事件
        table.on('toolbar(mainTable)', function (obj) {
            switch (obj.event) {
                //新增
                case 'set_AddNew': set_AddNew();
                    break;
                //编辑
                case 'set_Edit': set_Edit();
                    break;
                //删除
                case 'set_DeleteBill': set_DeleteBill();
                    break;              
                //刷新
                case 'get_Refresh': get_Refresh();
                    break;              
                //退出按钮
                case 'get_Exit': Pub_Close(2);
                //列设置
                case 'set_HideColumn':
                    get_HideColumn();
                    break;
            };
        });

        //重置按钮
        form.on('submit(btnReSearch)', function (data) {
            set_ClearQuery();

        });

        //查询按钮
        form.on('submit(btnSearch)', function (data) {
            get_FastQuery();
        });


        //#endregion

        //#region 此页面所有的方法

        // 初始化界面
        function set_ClearBill() {
            $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//开始日期
            $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));;//结束日期
            //查询
            get_Display("");           
            //初始化表格
            //DisPlay_HideColumn();
        }       

        // 查询
        function get_Display(sWhere) {
            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Sup_AskPriceBill/Sup_AskPriceBillList',
                type: "GET",
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        layer.close(ajaxLoad);

                        var data = [];
                        var col = [];
                        //给空的数组赋值
                        for (var key in data1.list) {
                            data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                        }
                        //在列表左边添加勾选框
                        col.push({ type: 'checkbox', fixed: 'left' });
                        for (var i = 0; i < data.length; i++) {
                            if ($.inArray(data[i].name, titleData) > -1) {
                                col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                            }
                            else {
                                switch (data[i].Type) {
                                    //int
                                    case 'DateTime':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                }
                            }
                        }
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            , height: 'full-50'
                            , page: true //开启分页
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , cols: [col]
                            , data: data1.data
                        };
                        //初始化表格
                        DisPlay_HideColumn();
                        table.render(option);

                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            ColFilter();
                        }
                    } else {
                        layer.close(ajaxLoad);
                        layer.msg(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            });

        }

        // 快速过滤
        function get_FastQuery() {
            var HDate = $("#HDate").val();;//开始日期
            var HDate1 = $("#HDate1").val();//结束日期
            var HBillNo = $("#HBillNo").val();//单据号
            var HProcType = $("#HProcType").val();//业务类型
            var HMaterNumber = $("#HMaterNumber").val();//物料代码
            var HMaterName = $("#HMaterName").val();//物料名称
            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();

            if (ColName != 0 && Comparator != 0) {
                var com = "";
                switch (Comparator) {
                    case "7":
                        com = "like'%" + ColContent + "%'";
                        break;
                    case "8":
                        com = "like'%" + ColContent + "'";
                        break;
                    case "9":
                        com = "like'" + ColContent + "%'";
                        break;
                    case "10":
                        com = "not like'%" + ColContent + "%'";
                        break;
                    default:
                        com = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName + " " + com;
            }



            if (HDate) {
                sWhere += " and 日期 >= '" + HDate + "'";
            }
            if (HDate1) {
                sWhere += " and 日期 <= '" + HDate1 + "'";
            }

            if (HBillNo) {
                sWhere += " and 单据号 like '%" + HBillNo + "%'";
            }
            if (HProcType && HProcType != "") {
                sWhere += " and 业务类型 = '" + HProcType + "'";
            }
            if (HMaterNumber) {
                sWhere += " and 物料代码 like '%" + HMaterNumber + "%'";
            }
            if (HMaterName) {
                sWhere += " and 物料名称 like '%" + HMaterName + "%'";
            }

            get_Display(sWhere);
            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("");//单据号
            $("#HProcType").val("");//业务类型
            $("#HMaterNumber").val("");//物料代码
            $("#HMaterName").val("");//物料名称
            $("#ColContent").val("");
            $("#ColName").val("0");
            $("#Comparator").val("0");
            form.render('select');
            $("#btnSearch").click();
            sWhere = "";
        }

        //新增
        function set_AddNew() {
            layer.open({
                type: 2
                , skin: 'layui-layer-rim' //加上边框
                , area: ['100%', '100%']
                , title: '供应商询价单新增'
                , shift: 0//弹出动画
                , content: '../询价单/Sup_AskPriceBillEdit.html?OperationType=1&linterid='
                , end: function () {
                    //刷新页面,
                    location.reload();
                }
            })
        }

        // 编辑
        function set_Edit() {
            var checkStatus = table.checkStatus('mainTable')
                , data = checkStatus.data;
            if (checkStatus.data.length === 1) {
                var linterid = data[0].hmainid;

                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '供应商询价单编辑'
                    , shift: 0//弹出动画
                    , content: '../询价单/Sup_AskPriceBillEdit.html?OperationType=3&linterid=' + linterid + '&HEntryID=-1'
                    , end: function () {
                        //刷新页面,
                        location.reload();
                    }
                })
            } else {
                layer.msg('请选择一行数据编辑！');
            }
        }

        // 删除
        function set_DeleteBill() {
            var checkStatus = table.checkStatus('mainTable')
                , data = checkStatus.data;
            if (checkStatus.data.length === 1) {
                var hmainid = data[0].hmainid;
                layer.confirm("确认要删除吗，删除后不能恢复", { title: "删除确认" }, function (index) {
                    var wait = layer.load();
                    //逻辑删除方法
                    $.ajax({
                        url: GetWEBURL() + '/Sup_AskPriceBill/DelAskPriceBill',
                        type: "GET",
                        data: { "HInterID": hmainid, "user": sessionStorage["HUserName"] },
                        success: function (result) {
                            if (result.count == 1) {
                                //关闭当前frame
                                layer.close(wait);
                                layer.msg(result.Message);
                                //修改为功后刷新界面
                                get_FastQuery();

                            } else {
                                layer.alert(result.code + result.Message, { icon: 5 });
                                layer.close(wait);
                            }
                        }, error: function () {
                            layer.alert("接口请求失败!", { icon: 5 });
                            layer.close(wait);
                        }
                    });
                })
            }
            else {
                layer.msg('请选择一行数据删除！');
            }

        }                    

        // 刷新
        function get_Refresh() {
            set_ClearQuery();
            get_Display(sWhere);
        }       

        function Format(datetime, fmt) {
            if (parseInt(datetime) == datetime) {
                if (datetime.length == 10) {
                    datetime = parseInt(datetime) * 1000;
                } else if (datetime.length == 13) {
                    datetime = parseInt(datetime);
                }
            }
            datetime = new Date(datetime);
            var o = {
                "M+": datetime.getMonth() + 1,                 //月份   
                "d+": datetime.getDate(),                    //日   
                "h+": datetime.getHours(),                   //小时   
                "m+": datetime.getMinutes(),                 //分   
                "s+": datetime.getSeconds(),                 //秒   
                "q+": Math.floor((datetime.getMonth() + 3) / 3), //季度   
                "S": datetime.getMilliseconds()             //毫秒   
            };
            if (/(y+)/.test(fmt))
                fmt = fmt.replace(RegExp.$1, (datetime.getFullYear() + "").substr(4 - RegExp.$1.length));
            for (var k in o)
                if (new RegExp("(" + k + ")").test(fmt))
                    fmt = fmt.replace(RegExp.$1, (RegExp.$1.length == 1) ? (o[k]) : (("00" + o[k]).substr(("" + o[k]).length)));
            return fmt;
        }

        function Pub_Close(closeType) {
            if (closeType == 1) {
                //关闭弹窗
                var index = parent.layer.getFrameIndex(window.name);
                parent.layer.close(index);
            } else if (closeType == 2) {
                //关闭页签
                parent.layui.admin.events.closeThisTabs();
            }
        }

        //隐藏列设置
        function get_HideColumn() {
            var colName = "";
            var contentUrl = "";
            for (var i = 1; i < option.cols[0].length - 1; i++) {
                colName += option.cols[0][i]["title"] + ",";
            }
            var urlStr = window.document.location.pathname;//获取文件路径
            var urlLen = urlStr.split('/');
            for (var i = 0; i < urlLen.length - 4; i++) {
                contentUrl += "../";
            }
            colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI 进行编码

            contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;

            layer.open({
                type: 2
                , skin: "layui-layer-rim" //加上边框
                , title: "隐藏列设置"  //标题
                , closeBtn: 1  //窗体右上角关闭 的 样式
                , shift: 2 //弹出动画
                , area: ["50%", "90%"] //窗体大小
                , maxmin: true //设置最大最小按钮是否显示
                , content: [contentUrl, "yes"]
                , btn: ["确定", "取消"]
                , btn1: function (index, laero) {
                    //刷新表格数据
                    DisPlay_HideColumn();
                    //更新表格缓存的数据
                    layer.close(index);//关闭弹窗
                }
            })
        }

        //显示列数据
        function DisPlay_HideColumn() {
            $.ajax({
                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.data.length != 0) {


                        var dataCol = [];//数据库查询出的列数据
                        var titleData = ["hmainid", "hentryid", "HEntryID", "HDeptID", "HMaterID", "HSupID", "HEmpID", "HPayConditionID", "HCurID", "HUnitID"];//不需要显示的字段 可扩展

                        dataCol = data1.data[0].HGridString.split(',');

                        for (var i = 0; i < option.cols[0].length - 2; i++) {
                            if (dataCol[i]) {
                                var dataCols = dataCol[i].split('|');
                            }
                            //隐藏列
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                            }
                            //设置列宽
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];

                                switch (option.cols[0][i + 1]["field"]) {
                                    case '日期':
                                        option.cols[0][i + 1]["width"] = 110;
                                        break;
                                    case '单据号':
                                        option.cols[0][i + 1]["width"] = 140;
                                        break;
                                    case '业务类型':
                                        option.cols[0][i + 1]["width"] = 105;
                                        break;
                                    case '采购员代码':
                                        option.cols[0][i + 1]["width"] = 135;
                                        break;
                                    case '采购员名称':
                                        option.cols[0][i + 1]["width"] = 135;
                                        break;
                                    case '部门代码':
                                        option.cols[0][i + 1]["width"] = 140;
                                        break;
                                    case '部门名称':
                                        option.cols[0][i + 1]["width"] = 160;
                                        break;
                                }
                            }
                            //设置内容字体大小
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                            }
                            //设置列宽
                            //if (data1.data[0].HColumnWidth != 0) {
                            //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //} else {
                            //    option.cols[0][i + 1]["width"] = "";
                            //}
                            //显示列
                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                option.cols[0][i + 1]["hide"] = false;
                            }
                            //字体所在位置(左 居中 右)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }

                        //取消冻结列
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
                            }
                        }
                        //冻结列
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                    } else {
                        table.render(option);
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            })
        }

        //列明显示下拉框
        function ColFilter() {
            var Organization = '<option  value="0" selected="selected" ></option>';
            for (var i = 1; i < option.cols[0].length; i++) {
                if (option.cols[0][i].hide != true) {
                    Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                }
            }
            $("#ColName").empty();
            $("#ColName").append(Organization);
            form.render('select');
        }

        //#endregion







        //以上是layui模块
    });

</script>

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_BarCodeBill.html

@@ -153,6 +153,12 @@
            if (days == undefined || days == '') {
                days = 1;
            }
            
            var havingLeapYear = isDecimal(days / 365); //如果days不能被365整除，则为闰年，需要减少一天
            if (havingLeapYear) {
                days--;//经验证，天数只需要减少一次即可，存在多个闰年不需要循环递减
            }  
                                    
            var date = new Date(date);
            date.setDate(date.getDate() + days);
            var month = date.getMonth() + 1;
@@ -190,6 +196,10 @@
            }
            return vars;
        }
        //判断是否为小数
        function isDecimal(days) {
            return days % 1 != 0
        }
        var params = getUrlVars();
        var linterid = params[params[0]];
        var lentryid = params[params[1]];

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POInStockBill_Edit.html

@@ -25,7 +25,7 @@
                        <div class="layui-card-header">
                            <div class="layui-btn-group">
                                <button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Saver">保存</button>
                                <!--<button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Aduit">审核</button>-->
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Aduit">审核</button>
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Print">打印</button>
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">退出</button>
                            </div>
@@ -276,10 +276,10 @@
                    , { field: 'HUnitNumber', title: '计量单位代码', width: 100, hide: true }
                    , { field: 'HUnitID', title: '计量单位ID', width: 100, hide: true }
                    , { field: 'FPrintCount', title: '打印条码数量', width: 120 }
                    , { field: 'HQty', title: '送货数量', width: 100, edit: 'text' , event: "inputHQty"}
                    , { field: 'HQty', title: '送货数量', width: 100, edit: 'text', event: "inputHQty" }
                    , { field: 'HRQty', title: '可发货数量', width: 100 }
                    , { field: 'HSQty', title: '源单数量', width: 100 }
                    , { field: 'HBatchNo', title: '批次', width: 120,edit: 'text',}
                    , { field: 'HBatchNo', title: '批次', width: 120, edit: 'text', }
                    , { field: 'HKFDate', title: '生产日期', align: 'center', width: 150, data_field: 'HKFDate', event: "chooseHKFDate" }
                    , { field: 'HKFPeriod', title: '保质期', width: 100 }
                    , { field: 'HDate', title: '预计到货日期', align: 'center', width: 150, data_field: 'HDate', event: "chooseHDate", hide: true }
@@ -296,8 +296,10 @@
                    , { field: 'HBillType', title: '单据类型', width: 100, hide: true }
                    , { field: 'HSourceBillType', title: '源单类型', width: 100, hide: true }
                    , { field: 'HSourceBillNo', title: '源单单号', width: 200 }
                    , { field: 'HExpressNumberSub', title: '物流单号', width: 200, edit: true }
                    , { field: 'HExpressSupplierSub', title: '物流公司', width: 200, edit: true }
                    , { field: 'HExpressNumberSub', title: '物流单号', width: 200, edit: true }//瑞琪
                    , { field: 'HExpressSupplierSub', title: '物流公司', width: 200, edit: true }//瑞琪
                    , { field: 'HPlanArrivalDate', title: '到货日期', width: 200, data_field: 'HPlanArrivalDate', event: "PlanArrivalDate" }//瑞琪
                    , { field: 'HBoxNumber', title: '箱号', width: 200, edit: true }//瑞琪
                    , { field: 'HSourceInterID', title: '源单主内码', width: 150, hide: true }
                    , { field: 'HSourceEntryID', title: '源单子内码', width: 150, hide: true }
                ]]
@@ -385,7 +387,8 @@
                                                        , "HSourceEntryID": data[i].HSourceEntryID
                                                        , "FSHDD": data[i].FSHDD
                                                        , "F_xbkf_Combo": data[i].F_xbkf_Combo
                                                    }                                                                                                            
                                                        , "HPlanArrivalDate": data[i].HPlanArrivalDate
                                                    }
                                                    //oldData.push(data1);
                                                    oldData.splice(dataindex, 0, data1);
                                                };
@@ -470,6 +473,20 @@
                    });

                }
                else if (obj.event === 'PlanArrivalDate') {
                    var field = $(this).data('field');
                    laydate.render({
                        elem: this.firstChild
                        , show: true //直接显示
                        , closeStop: this
                        , done: function (value, date) {
                            data[field] = value;
                            obj.update(data);

                        }
                    });

                }
                else if (obj.event == 'inputHQty') {
                    $(obj.tr).find(".layui-table-edit").keyup(function () {
                        var $input = $(this), val = $input.val();
@@ -524,18 +541,25 @@
                    async: true,
                    data: { sMsg: linterid, sMsg2: lentryid, sMsg3: lSourceBillType },
                    success: function (result) {
                        ajaxReturnData = JSON.parse(JSON.stringify(result)).data;
                        table.reload('mainTable', {
                            data: ajaxReturnData
                            , height: 'full-10'
                            , loading: false
                            , done: function (index, res) {
                                layer.closeAll("loading");
                            }
                        });
                        if (result.count == 10000) {
                            ajaxReturnData = JSON.parse(JSON.stringify(result)).data;
                            table.reload('mainTable', {
                                data: ajaxReturnData
                                , height: 'full-10'
                                , loading: false
                                , done: function (index, res) {
                                    layer.closeAll("loading");
                                }
                            });
                        } else {
                            layer.closeAll("loading");
                            layer.msg(result.Message, { icon: 2, time: 4000 });
                        }
                        
                    },
                    error: function (result) {
                        console.log(result);
                        layer.closeAll("loading");
                        //layer.msg('获取委外订单出现异常', { icon: 2, time: 2000 });
                    }
                });
@@ -544,7 +568,7 @@
                //debugger;
                var sMainStr = JSON.stringify(data.field);
                var sSubStr = JSON.stringify(table.cache['mainTable']);
                var sMainSub = sMainStr + ';' + sSubStr;
                var sMainSub = sMainStr + ';' + sSubStr;                

                if (!AllowLoadData(sSubStr))//数据验证
                {
@@ -671,35 +695,35 @@
                            layer.msg("明细记录第" + (i + 1) + "行,送货数量为空!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            return Result = false;
                        }
                        //瑞琪没有这项控制
                        if (sSubStr[i].FPrintCount == 0) {
                            layer.msg("明细记录第" + (i + 1) + "行,没有进行条码打印，不能生成送货单!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            return Result = false;
                        } 
                        ////瑞琪没有这项控制
                        //if (sSubStr[i].FPrintCount == 0) {
                        //    layer.msg("明细记录第" + (i + 1) + "行,没有进行条码打印，不能生成送货单!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        //    return Result = false;
                        //}
                        ////送货数量 + （源单数量-可发货数量 = 已生成送货单数量） > 打印条码数量 时限制
                        //if (parseFloat(sSubStr[i].HQty) > parseFloat(sSubStr[i].FPrintCount)) {
                        //    layer.msg("明细记录第" + (i + 1) + "行,送货单数量不能超过已生成条码数量!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        //    return Result = false;
                        //}
                        //送货数量 
                        //送货数量
                        if (parseFloat(sSubStr[i].HQty) > parseFloat(sSubStr[i].HRQty)) {
                            layer.msg("明细记录第" + (i + 1) + "行,送货单数量不能超过可发货数量!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            return Result = false;
                        }
                        ////送货数量 
                        if (parseFloat(sSubStr[i].HQty) > parseFloat(sSubStr[i].FPrintCount)) {
                            layer.msg("明细记录第" + (i + 1) + "行,送货单数量不能超过打印条码数量!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            return Result = false;
                        }
                        //////送货数量
                        //if (parseFloat(sSubStr[i].HQty) > parseFloat(sSubStr[i].FPrintCount)) {
                        //    layer.msg("明细记录第" + (i + 1) + "行,送货单数量不能超过打印条码数量!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        //    return Result = false;
                        //}
                        ////送货数量 + （源单数量-可发货数量 = 已生成送货单数量） > 打印条码数量 时限制
                        //if (parseFloat(sSubStr[i].HQty) + parseFloat(sSubStr[i].HSQty) - parseFloat(sSubStr[i].HRQty) > parseFloat(sSubStr[i].FPrintCount)) {
                        //    layer.msg("明细记录第" + (i + 1) + "行,送货单数量不能超过已生成条码数量!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        //    return Result = false;
                        //}
                        if (sSubStr[i].HBatchNo == "") {
                            layer.msg("明细记录第" + (i + 1) + "行,批次为空!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            return Result = false;
                        }
                        //if (sSubStr[i].HBatchNo == "") {
                        //    layer.msg("明细记录第" + (i + 1) + "行,批次为空!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        //    return Result = false;
                        //}
                    }
                }
                else {

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList_Excel.html

@@ -149,6 +149,10 @@
            columns.push({ field: '物料编码', title: '物料编码', width: 150 });
            columns.push({ field: '数量', title: '数量', width: 150 });
            columns.push({ field: '包装标识', title: '包装标识', width: 150 });
            columns.push({ field: '到货日期', title: '到货日期', width: 150 });
            columns.push({ field: '物流单号', title: '物流单号', width: 150 });
            columns.push({ field: '物流公司', title: '物流公司', width: 150 });
            columns.push({ field: '箱号', title: '箱号', width: 150 });
            //columns.push({ fixed: 'right', title: '操作', toolbar: '#barDemo' });

            option = {

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_QuotePriceBillList.html

New file
@@ -0,0 +1,587 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title>供应商询价单列表</title>
    <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
    <script src="../../layuiadmin/layui/layui.js"></script>
    <script src="../../../../Scripts/webConfig.js"></script>
    <script src="../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../layuiadmin/Scripts/general.js"></script>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
            <div class="layui-card" style="padding: 1px">
                <div class="layui-card-body" style="padding: 1px;">
                    <form class="layui-form" action="" lay-filter="component-form-group">
                        <div class="layui-collapse">
                            <div class="layui-colla-item">
                                <div class="layui-colla-title layui-inline">
                                    <div class="layui-inline">
                                        <span>更多</span>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HDate">
                                    </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">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HBillNo" id="HBillNo">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <div class="layui-colla-content">
                                    <div class="layui-row" style=" margin-bottom: 10px;">
                                        <label class="layui-form-label">业务类型</label>
                                        <div class="layui-input-inline">
                                            <select id="HProcType" name="HProcType" lay-filter="">
                                                <option value="" selected>请选择</option>
                                                <option value="外购入库">外购入库</option>
                                                <option value="委外加工">委外加工</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">物料代码</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HMaterNumber" id="HMaterNumber">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">物料名称</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HMaterName" id="HMaterName">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="layui-row">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">过滤</label>
                                            <div class="layui-input-block">
                                                <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
                                                <option value="0" selected="selected"></option>
                                                <option value="=">=</option>
                                                <option value=">=">>=</option>
                                                <option value=">">></option>
                                                <option value="<="><=</option>
                                                <option value="<"><</option>
                                                <option value="<>"><></option>
                                                <option value="7">包含</option>
                                                <option value="8">左包含</option>
                                                <option value="9">右包含</option>
                                                <option value="10">不包含</option>
                                            </select>
                                        </div>
                                        <div class="layui-inline">
                                            <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_Edit"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                            </div>
                        </script>
                    </form>
                </div>
            </div>
        </div>
    </div>
</body>
</html>
<script>
    layui.config({
        base: '../../layuiadmin/' //静态资源所在路径
    }).extend({
        index: 'lib/index', //主入口模块
    }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {

        //#region 公共变量
        var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , element = layui.element
            , laypage = layui.laypage
            , laydate = layui.laydate
        var sWhere = "";
        var titleData = ["hmainid", "hentryid", "HEntryID", "HDeptID", "HMaterID", "HSupID", "HEmpID", "HPayConditionID", "HCurID","HUnitID"];
        var option = [];
        var HModName = "Sup_QuotePriceBillList";

        //#endregion

        //#region 进入页面即加载

        //初始化界面
        set_ClearBill();

        //#endregion

        //#region 触发事件：包括form.on(){}格式的所有点击事件、选择事件等
        //头工具栏事件
        table.on('toolbar(mainTable)', function (obj) {
            switch (obj.event) {
                //新增
                case 'set_AddNew': set_AddNew();
                    break;
                //编辑
                case 'set_Edit': set_Edit();
                    break;
                //删除
                case 'set_DeleteBill': set_DeleteBill();
                    break;
                //刷新
                case 'get_Refresh': get_Refresh();
                    break;
                //退出按钮
                case 'get_Exit': Pub_Close(2);
                //列设置
                case 'set_HideColumn':
                    get_HideColumn();
                    break;
            };
        });

        //重置按钮
        form.on('submit(btnReSearch)', function (data) {
            set_ClearQuery();

        });

        //查询按钮
        form.on('submit(btnSearch)', function (data) {
            get_FastQuery();
        });


        //#endregion

        //#region 此页面所有的方法

        // 初始化界面
        function set_ClearBill() {
            $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//开始日期
            $("#HDate1").val(Format(new Date(), "yyyy-MM-dd"));;//结束日期
            //查询
            get_Display("");
            //初始化表格
            //DisPlay_HideColumn();
        }

        // 查询
        function get_Display(sWhere) {
            var ajaxLoad = layer.load();
            $.ajax({
                url: GetWEBURL() + '/Sup_QuotePriceBill/Sup_QuotePriceBillList',
                type: "GET",
                data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.count == 1) {
                        layer.close(ajaxLoad);

                        var data = [];
                        var col = [];
                        //给空的数组赋值
                        for (var key in data1.list) {
                            data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                        }
                        //在列表左边添加勾选框
                        col.push({ type: 'checkbox', fixed: 'left' });
                        for (var i = 0; i < data.length; i++) {
                            if ($.inArray(data[i].name, titleData) > -1) {
                                col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                            }
                            else {
                                switch (data[i].Type) {
                                    //int
                                    case 'DateTime':
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                        break;
                                    default:
                                        col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                }
                            }
                        }
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            , height: 'full-50'
                            , page: true //开启分页
                            , limit: 50
                            , limits: [50, 500, 5000, 20000]
                            , cols: [col]
                            , data: data1.data
                        };
                        //初始化表格
                        DisPlay_HideColumn();
                        table.render(option);

                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            ColFilter();
                        }
                    } else {
                        layer.close(ajaxLoad);
                        layer.msg(data1.code + data1.Message, { icon: 5 });
                    }
                }, error: function () {
                    layer.close(ajaxLoad);
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            });

        }

        // 快速过滤
        function get_FastQuery() {
            var HDate = $("#HDate").val();;//开始日期
            var HDate1 = $("#HDate1").val();//结束日期
            var HBillNo = $("#HBillNo").val();//单据号
            var HProcType = $("#HProcType").val();//业务类型
            var HMaterNumber = $("#HMaterNumber").val();//物料代码
            var HMaterName = $("#HMaterName").val();//物料名称
            var ColName = $("#ColName").val();//复选框
            var Comparator = $("#Comparator").val()
            var ColContent = $("#ColContent").val();

            if (ColName != 0 && Comparator != 0) {
                var com = "";
                switch (Comparator) {
                    case "7":
                        com = "like'%" + ColContent + "%'";
                        break;
                    case "8":
                        com = "like'%" + ColContent + "'";
                        break;
                    case "9":
                        com = "like'" + ColContent + "%'";
                        break;
                    case "10":
                        com = "not like'%" + ColContent + "%'";
                        break;
                    default:
                        com = "" + Comparator + "'" + ColContent + "'";
                        break;
                }
                sWhere += " and " + ColName + " " + com;
            }



            if (HDate) {
                sWhere += " and 日期 >= '" + HDate + "'";
            }
            if (HDate1) {
                sWhere += " and 日期 <= '" + HDate1 + "'";
            }

            if (HBillNo) {
                sWhere += " and 单据号 like '%" + HBillNo + "%'";
            }
            if (HProcType && HProcType != "") {
                sWhere += " and 业务类型 = '" + HProcType + "'";
            }
            if (HMaterNumber) {
                sWhere += " and 物料代码 like '%" + HMaterNumber + "%'";
            }
            if (HMaterName) {
                sWhere += " and 物料名称 like '%" + HMaterName + "%'";
            }

            get_Display(sWhere);
            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("");//单据号
            $("#HProcType").val("");//业务类型
            $("#HMaterNumber").val("");//物料代码
            $("#HMaterName").val("");//物料名称
            $("#ColContent").val("");
            $("#ColName").val("0");
            $("#Comparator").val("0");
            form.render('select');
            $("#btnSearch").click();
            sWhere = "";
        }

        //新增
        function set_AddNew() {
            layer.open({
                type: 2
                , skin: 'layui-layer-rim' //加上边框
                , area: ['100%', '100%']
                , title: '供应商询价单新增'
                , shift: 0//弹出动画
                , content: '../报价单/Sup_QuotePriceBillEdit.html?OperationType=1&linterid='
                , end: function () {
                    //刷新页面,
                    location.reload();
                }
            })
        }

        // 编辑
        function set_Edit() {
            var checkStatus = table.checkStatus('mainTable')
                , data = checkStatus.data;
            if (checkStatus.data.length === 1) {
                var linterid = data[0].hmainid;

                layer.open({
                    type: 2
                    , area: ['100%', '100%']
                    , title: '供应商询价单编辑'
                    , shift: 0//弹出动画
                    , content: '../报价单/Sup_QuotePriceBillEdit.html?OperationType=3&linterid=' + linterid + '&HEntryID=-1'
                    , end: function () {
                        //刷新页面,
                        location.reload();
                    }
                })
            } else {
                layer.msg('请选择一行数据编辑！');
            }
        }

        // 删除
        function set_DeleteBill() {
            var checkStatus = table.checkStatus('mainTable')
                , data = checkStatus.data;
            if (checkStatus.data.length === 1) {
                var hmainid = data[0].hmainid;
                layer.confirm("确认要删除吗，删除后不能恢复", { title: "删除确认" }, function (index) {
                    var wait = layer.load();
                    //逻辑删除方法
                    $.ajax({
                        url: GetWEBURL() + '/Sup_QuotePriceBill/DelQuotePriceBill',
                        type: "GET",
                        data: { "HInterID": hmainid, "user": sessionStorage["HUserName"] },
                        success: function (result) {
                            if (result.count == 1) {
                                //关闭当前frame
                                layer.close(wait);
                                layer.msg(result.Message);
                                //修改为功后刷新界面
                                get_FastQuery();

                            } else {
                                layer.alert(result.code + result.Message, { icon: 5 });
                                layer.close(wait);
                            }
                        }, error: function () {
                            layer.alert("接口请求失败!", { icon: 5 });
                            layer.close(wait);
                        }
                    });
                })
            }
            else {
                layer.msg('请选择一行数据删除！');
            }

        }

        // 刷新
        function get_Refresh() {
            set_ClearQuery();
            get_Display(sWhere);
        }


        //隐藏列设置
        function get_HideColumn() {
            var colName = "";
            var contentUrl = "";
            for (var i = 1; i < option.cols[0].length - 1; i++) {
                colName += option.cols[0][i]["title"] + ",";
            }
            var urlStr = window.document.location.pathname;//获取文件路径
            var urlLen = urlStr.split('/');
            for (var i = 0; i < urlLen.length - 4; i++) {
                contentUrl += "../";
            }
            colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI 进行编码

            contentUrl += '基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName;

            layer.open({
                type: 2
                , skin: "layui-layer-rim" //加上边框
                , title: "隐藏列设置"  //标题
                , closeBtn: 1  //窗体右上角关闭 的 样式
                , shift: 2 //弹出动画
                , area: ["50%", "90%"] //窗体大小
                , maxmin: true //设置最大最小按钮是否显示
                , content: [contentUrl, "yes"]
                , btn: ["确定", "取消"]
                , btn1: function (index, laero) {
                    //刷新表格数据
                    DisPlay_HideColumn();
                    //更新表格缓存的数据
                    layer.close(index);//关闭弹窗
                }
            })
        }

        //显示列数据
        function DisPlay_HideColumn() {
            $.ajax({
                url: GetWEBURL() + '/Xt_grdAlignment_WMES/grdAlignmentWMESList',
                type: "GET",
                data: { "HModName": HModName, "user": sessionStorage["HUserName"] },
                success: function (data1) {
                    if (data1.data.length != 0) {


                        var dataCol = [];//数据库查询出的列数据
                        var titleData = ["hmainid", "hentryid", "HEntryID", "HDeptID", "HMaterID", "HSupID", "HEmpID", "HPayConditionID", "HCurID", "HUnitID"];//不需要显示的字段 可扩展

                        dataCol = data1.data[0].HGridString.split(',');

                        for (var i = 0; i < option.cols[0].length - 2; i++) {
                            if (dataCol[i]) {
                                var dataCols = dataCol[i].split('|');
                            }
                            //隐藏列
                            if (dataCols[1] == 1) {
                                option.cols[0][i + 1]["hide"] = true;
                            }
                            //设置列宽
                            if (dataCols[3] > 0) {
                                option.cols[0][i + 1]["width"] = dataCols[3];

                                switch (option.cols[0][i + 1]["field"]) {
                                    case '日期':
                                        option.cols[0][i + 1]["width"] = 110;
                                        break;
                                    case '单据号':
                                        option.cols[0][i + 1]["width"] = 140;
                                        break;
                                    case '业务类型':
                                        option.cols[0][i + 1]["width"] = 105;
                                        break;
                                    case '采购员代码':
                                        option.cols[0][i + 1]["width"] = 135;
                                        break;
                                    case '采购员名称':
                                        option.cols[0][i + 1]["width"] = 135;
                                        break;
                                    case '部门代码':
                                        option.cols[0][i + 1]["width"] = 140;
                                        break;
                                    case '部门名称':
                                        option.cols[0][i + 1]["width"] = 160;
                                        break;
                                }
                            }
                            //设置内容字体大小
                            if (data1.data[0].HFontSize != 0) {
                                option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;";
                            } else {
                                option.cols[0][i + 1]["style"] = "font-size:100%";
                            }
                            //设置列宽
                            //if (data1.data[0].HColumnWidth != 0) {
                            //    option.cols[0][i + 1]["width"] = data1.data[0].HColumnWidth + "px;";
                            //} else {
                            //    option.cols[0][i + 1]["width"] = "";
                            //}
                            //显示列
                            if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                option.cols[0][i + 1]["hide"] = false;
                            }
                            //字体所在位置(左 居中 右)
                            switch (dataCols[2]) {
                                case "L":
                                    option.cols[0][i + 1]["align"] = "left";
                                    break;
                                case "M":
                                    option.cols[0][i + 1]["align"] = "center";
                                    break;
                                case "R":
                                    option.cols[0][i + 1]["align"] = "right";
                                    break;
                            }
                        }

                        //取消冻结列
                        for (var i = 1; i < option.cols[0].length - 1; i++) {
                            if (option.cols[0][i]["fixed"] != null) {
                                option.cols[0][i]["fixed"] = null;
                            }
                            else {
                                break;
                            }
                        }
                        //冻结列
                        if (data1.data[0].HFixCols != 0) {
                            for (var i = 0; i < data1.data[0].HFixCols; i++) {
                                if ($.inArray(option.cols[0][i + 1]["title"], titleData) != -1) {
                                    data1.data[0].HFixCols += 1;
                                }
                                option.cols[0][i + 1]["fixed"] = "left";
                            }
                        }
                        table.render(option);
                    } else {
                        table.render(option);
                    }
                }, error: function () {
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            })
        }

        //列明显示下拉框
        function ColFilter() {
            var Organization = '<option  value="0" selected="selected" ></option>';
            for (var i = 1; i < option.cols[0].length; i++) {
                if (option.cols[0][i].hide != true) {
                    Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                }
            }
            $("#ColName").empty();
            $("#ColName").append(Organization);
            form.render('select');
        }

        //#endregion


        //以上是layui模块
    });

</script>

 WebSRM/layuiAdmin.std-v1.2.1/src/views/index.html

@@ -113,8 +113,28 @@
                                    <a lay-href="SRM/SRM_POInStockBackBillList.html?type=UnConfirm">待确认退货列表</a>
                                </dd>
                                <!--<dd data-name="console">
                <a lay-href="SRM/SRM_EmpMessageBillList.html">消息列表</a>
            </dd>-->
                                    <a lay-href="SRM/SRM_EmpMessageBillList.html">消息列表</a>
                                </dd>-->
                            </dl>
                        </li>
                        <li data-name="home" class="layui-nav-item">
                            <a href="javascript:;" lay-tips="询价" lay-direction="2">
                                <i class="layui-icon layui-icon-component"></i>
                                <cite>询价管理</cite>
                            </a>
                            <dl class="layui-nav-child">
                                <dd>
                                    <a>询价单</a>
                                    <dl class="layui-nav-child">
                                        <dd data-name="SRM_AskPriceBillList"><a lay-href="SRM/SRM_AskPriceBillList.html">询价单列表</a></dd>    
                                    </dl>
                                </dd>
                                <dd>
                                    <a>报价单列表</a>
                                    <dl class="layui-nav-child">
                                        <dd data-name="SRM_QuotePriceBillList"><a lay-href="SRM/SRM_QuotePriceBillList.html">报价单列表</a></dd>
                                    </dl>
                                </dd>
                            </dl>
                        </li>
                        <li data-name="home" class="layui-nav-item">

 WebSRM/login.html

@@ -93,19 +93,26 @@
                }
            })
            form.on('submit(LAY-user-login-submit)', function (obj) {//登录
                loging(obj); 
            })

            function loging(obj) {
                if ($("#edu").val() == 0) {
                    layer.msg("请选择组织！");
                    return;
                }
                var user = obj.field;
                if (user.username == '') {
                //var user = obj.field;
                var UserName = $("#LAY-user-login-username").val();
                var PassWord = $("#LAY-user-login-password").val();

                if (UserName == '') {
                    layer.msg("用户名不能为空~", {
                        icon: 5,
                        shade: [0.8, '#2F4F4F'] // 透明度  颜色
                    });
                    return false;
                }
                if (user.password == '') {
                if (PassWord == '') {
                    layer.msg("密码不能为空~", {
                        icon: 5,
                        shade: [0.8, '#2F4F4F'] // 透明度  颜色
@@ -115,7 +122,7 @@
                $.ajax({
                    type: "get",
                    url: GetWEBURL() + "GetUser",
                    data: { "UserName": user.username, "PassWord": user.password, "HOrgName": $("#edu").val() },
                    data: { "UserName": UserName, "PassWord": PassWord, "HOrgName": $("#edu").val() },
                    success: function (result) {
                        if (result.count == 1) { // 说明验证成功了，
                            layer.msg(result.Message, { icon: 1, });
@@ -131,7 +138,20 @@
                        }
                        layer.closeAll("loading");
                    }
                })
                })    
            }

            //密码框回车执行登录
            $('#LAY-user-login-password').on('keydown', function (e) {
                if (e.keyCode == 13) {
                    loging();
                }
            });
            //用户名框回车光标移到密码框
            $('#LAY-user-login-username').on('keydown', function (e) {
                if (e.keyCode == 13) {
                    $("#LAY-user-login-password").focus();
                }
            })
        });
    </script>