生成条码时修改计算有效期至逻辑，新增生产日期不可为空控制；条码列表改为动态加载，新增列设置按钮；退货单模块；送货单列表新增凯贝修改前备份文件；送货单编...

yusijie

2024-01-02 2f1e5bde1de562bcc0ee334714b7799d1eec0ea8

生成条码时修改计算有效期至逻辑，新增生产日期不可为空控制；条码列表改为动态加载，新增列设置按钮；退货单模块；送货单列表新增凯贝修改前备份文件；送货单编辑模块新增选源单功能；采购订单列表备份；excel导入生成送货单添加行合计；

 WebSRM/WebSRM.csproj

@@ -865,6 +865,7 @@
    <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_POInStockBillList备份.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POInStockBill_Edit.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POInStockBillList.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POInStockBill.html" />
@@ -875,6 +876,9 @@
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_PODemandPlanBillList.html" />
    <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备份.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POStockOutBillList.html" />
    <Content Include="layuiAdmin.std-v1.2.1\src\views\SRM\SRM_POStockInBillList.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" />

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

@@ -24,7 +24,7 @@
                                <!--<button type="button" 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="HBarcodeSaverPZ">生成品种码</button>
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="HBarcodeSaverWY">生成唯一码</button>-->
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="HBarcodeSaverBox">生成内外箱条码</button>
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="HBarcodeSaverBox" id="HBarcodeSaverBox">生成内外箱条码</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>

@@ -115,6 +115,7 @@
    <script src="../../layuiadmin/Scripts/json2.js" type="text/javascript"></script>
    <script src="../../layuiadmin/Scripts/jquery-1.4.1.js" type="text/javascript"></script>
    <script src="../../../../Scripts/webConfig.js"></script>
    <script src="../../layuiadmin/Scripts/general.js"></script>
    <!--<script src="../../../../Scripts/jquery-1.8.2.js"></script>-->
    <script>
        function f_alert(sMsg) {
@@ -149,33 +150,57 @@
                }
            }
        }
        function addDate(date, days) {
            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;
            var day = date.getDate();
            var mm = "'" + month + "'";
            var dd = "'" + day + "'";
        function addDate(date, days, HExpUnit, HKFPeriod) {
            //计算有效期至
            if (HExpUnit == "Y") {//å¹´
                date = new Date(date);
                console.log(date.getFullYear(date));
                date.setYear(date.getFullYear(date) + HKFPeriod);
                console.log(Format(date, "yyyy-MM-dd"));

            //单位数前面加0
            if (mm.length == 3) {
                month = "0" + month;
                return Format(date, "yyyy-MM-dd");
            }
            if (dd.length == 3) {
                day = "0" + day;
            if (HExpUnit == "M") {//月
                date = new Date(date);
                date.setMonth(date.getMonth(date) + HKFPeriod);

                return Format(date, "yyyy-MM-dd");
            }
            if (HExpUnit == "D") {//日
                date = new Date(date);
                date.setDate(date.getDate(date) + HKFPeriod);
                console.log(Format(date, "yyyy-MM-dd"));
                return Format(date, "yyyy-MM-dd");
            }
            else { //安瑞计算方式          
                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;
                var day = date.getDate();
                var mm = "'" + month + "'";
                var dd = "'" + day + "'";

                //单位数前面加0
                if (mm.length == 3) {
                    month = "0" + month;
                }
                if (dd.length == 3) {
                    day = "0" + day;
                }

                var time = date.getFullYear() + "-" + month + "-" + day
                return time;
            }

            var time = date.getFullYear() + "-" + month + "-" + day
            return time;
        }
        function DateDiff(sDate1, sDate2) {    //sDate1和sDate2是2002-12-18格式
            var aDate, oDate1, oDate2, iDays
@@ -396,7 +421,7 @@
                    });
                return false;
            });
            //生成内外箱码            
            //生成内外箱码

            //获取当前数据所在数组的下标
            function findIndex(HMaterNumber, HMaterModel, array) {
@@ -428,8 +453,8 @@
                        layer.msg("明细记录第" + (i + 1) + "行,本次生成条码数量不能超出未生成条码数量!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        return Result = false;
                    }
                    if (_sSubStr[i].HQty > 0 && (_sSubStr[i].HBatchNo == "" || _sSubStr[i].HKFDate == "")) {
                        layer.msg("明细记录第" + (i + 1) + "行,批次或生产日期不能为空!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                    if (_sSubStr[i].HQty > 0 && _sSubStr[i].HISKFPERIOD == 1 && (/*_sSubStr[i].HBatchNo == "" ||*/ _sSubStr[i].HKFDate == "")) {
                        layer.msg("明细记录第" + (i + 1) + "行,生产日期不能为空!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        return Result = false;
                    }
                    //获取下标
@@ -439,9 +464,11 @@
                        newArray.push(_sSubStr[i]);

                    } else {
                        //如果数组中有和当前数据中物料代码、规格型号一致的信息，则将他们的数量累加
                        newArray[index].HQty = Number(newArray[index].HQty) + Number(_sSubStr[i].HQty);
                    }                             
                        if (newArray[index].HPOOrderBillNo == _sSubStr[i].HPOOrderBillNo) {
                            //如果数组中有和当前数据中物料代码、规格型号一致的信息，则将他们的数量累加
                            newArray[index].HQty = Number(newArray[index].HQty) + Number(_sSubStr[i].HQty);
                        }                       
                    }
                }

                for (let i = 0; i < newArray.length; i++) {
@@ -463,6 +490,8 @@
                                layer.msg(data.Message, { icon: 1 });
                                element.tabDelete('tabDemo', '2'); //删除
                                element.tabDelete('tabDemo', '3'); //删除

                                $('#HBarcodeSaverBox').addClass("layui-btn-disabled").attr("disabled", true);//生成条码按钮禁用

                                element.tabAdd('tabDemo', {
                                    title: '外箱条码'
@@ -595,7 +624,7 @@
                        , shade: 0.6 //遮罩透明度
                        , maxmin: false //允许全屏最小化
                        , anim: 0 //0-6的动画形式，-1不开启
                        , content: ['../../views/BaseSet/SRM_OpenTmpList.html?linterid=' + sessionStorage["HUserName"] + '&HBarcode=&Type=' + openTmpListType, 'yes']
                        , content: ['../../views/BaseSet/SRM_OpenTmpList.html?linterid=' + sessionStorage["linterid"] + '&HBarcode=&Type=SRM_POOrderBillList', 'yes']
                        , resize: false
                        //, cancel: function () {
                        //    $(".layui-btn").removeClass("layui-btn-disabled");
@@ -647,13 +676,17 @@
                    , { field: 'HWBQty', title: '外箱数', width: 100 }
                    , { field: 'HPrice', title: '单价', width: 100, hide: true }
                    , { field: 'HMoney', title: '金额', width: 100, hide: true }
                    , { field: 'HMTONO', title: '计划跟踪单号', width: 100 }
                    , { field: 'HBatchNo', title: '生产日期D/C', width: 100, edit: 'text' }
                    , { field: 'HMTONO', title: '计划跟踪单号', width: 100, hide: true }
                    , { field: 'HBatchNo', title: '批号', width: 100 }
                    , { field: 'HISKFPERIOD', title: '是否启用保质期', width: 100, edit: 'text', hide: true }
                    , { field: 'HEXPUNIT', title: '保质期单位', width: 100, edit: 'text', hide: true }
                    , { field: 'HKFDate', title: '生产日期', align: 'center', width: 150, data_field: 'HKFDate' }//, event: "chooseHKFDate"
                    , { field: 'HKFPeriod', title: '保质期', width: 100 }//
                    , { field: 'HKFDQDate', title: '到期日期', align: 'center', width: 150, data_field: 'HKFDQDate' }//, event: "chooseHKFDQDate"
                    , { field: 'HSupMaterNumber', title: '供应商料号', width: 100, edit: 'text' }
                    , { field: 'HSupBatchNo', title: '供应商批次', width: 100, edit: 'text' }
                    //, { field: 'HBeginDate', title: '生产日期', width: 120, data_field: 'HBeginDate', event: "chooseHBeginDate" }
                    //, { field: 'HEndDate', title: '失效日期', width: 120, data_field: 'HEndDate', event: "chooseHEndDate" }
                    , { field: 'HKFDate', title: '生产日期', align: 'center', width: 150, data_field: 'HKFDate', event: "chooseHKFDate", hide: true}//
                    , { field: 'HKFPeriod', title: '保质期', width: 100, hide: true }//
                    , { field: 'HKFDQDate', title: '到期日期', align: 'center', width: 150, data_field: 'HKFDQDate', hide: true}//, event: "chooseHKFDQDate"
                    //, { field: 'HDate', title: '要求交货日期', width: 150 }
                    , { field: 'HPOOrderInterID', title: '采购订单主内码', width: 150, hide: true }
                    , { field: 'HPOOrderEntryID', title: '采购订单子内码', width: 150, hide: true }
@@ -661,7 +694,7 @@
                    , { field: 'HWWOrderInterID', title: '委外订单主内码', width: 150, hide: true }
                    , { field: 'HWWOrderEntryID', title: '委外订单子内码', width: 150, hide: true }
                    , { field: 'HWWOrderDetaiLID    ', title: '委外订单明细内码', width: 150, hide: true }
                    , { field: 'HWWOrderBillNo', title: '委外订单单号', width: 200 }
                    , { field: 'HWWOrderBillNo', title: '委外订单单号', width: 200, hide: true }
                    , { field: 'HSourceBillType', title: '源单类型', width: 100 }
                    , { field: 'HSourceBillNo', title: '源单单号', width: 200 }
                    , { field: 'HSourceEntryID', title: '源单子内码', width: 150, hide: true }
@@ -754,6 +787,8 @@
                                                        , "HSourceInterID": data[i].HSourceInterID
                                                        , "HSupID": data[i].HSupID
                                                        , "HSupName": data[i].HSupName
                                                        , "HSupBatchNo": data[i].HSupBatchNo
                                                        , "HSupMaterNumber": data[i].HSupMaterNumber
                                                    }
                                                    //oldData.push(data1);
                                                    oldData.splice(dataindex, 0, data1);
@@ -876,6 +911,15 @@
                var data = obj.data;
                if (obj.event === 'chooseHKFDate') {
                    var field = $(this).data('field');
                    var HExpUnit = data.HEXPUNIT; //保质期单位
                    var HKFPeriod = data.HKFPeriod; //保质期
                    if (HExpUnit != 'Y' && HExpUnit != 'M' && HExpUnit != 'D') {
                        layer.msg("此物料没有启用保质期！");
                        obj.update({
                            HKFDate: '',
                        });
                        return;
                    }
                    laydate.render({
                        elem: this.firstChild
                        , show: true //直接显示
@@ -884,7 +928,7 @@
                            data[field] = value;
                            obj.update(data);
                            if (parseInt(obj.data.HKFPeriod) >= 0) {
                                var sKFDQDate = addDate(value, parseInt(obj.data.HKFPeriod));
                                var sKFDQDate = addDate(value, parseInt(obj.data.HKFPeriod), HExpUnit, HKFPeriod);
                                obj.update({
                                    HKFDQDate: sKFDQDate,
                                });

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

@@ -118,6 +118,7 @@
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back"><i class="layui-icon layui-icon-close-fill"></i>驳回</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button>-->
                              <button type="button" class="layui-btn layui-btn-sm" id="btn_HideColumn" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>条码打印</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>删除</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
@@ -190,6 +191,11 @@
                , table = layui.table
                , form = layui.form
                , element = layui.element;

            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["HItemID", "HParentID", "单据号", "日期", "数量", "状态", "单位", "金额"];
            var HModName = "SRM_BarCodeBillList";
            var option = [];
            //常规用法
            laydate.render({
                elem: '#HDate1'
@@ -212,7 +218,8 @@
                // , where: { msg: "", NowPage: 1, OnePage: 10 }
                , cellMinWidth: 100
                , cols: [[
                    { checkbox: true/*, fixed: true*/ }
                    { type: 'checkbox', fixed: 'left', totalRowText: '合计' }
                    //{ checkbox: true/*, fixed: true*/ }
                    , { field: 'sorderid', title: '序号', width: 80/*, fixed: true*/ }
                    , { field: 'HItemID', title: '主键', width: 100, hide: true }
                    , { field: '状态', title: '状态', width: 100, sort: true/*, fixed: true*/ }
@@ -306,7 +313,7 @@
                                , shade: 0.6 //遮罩透明度
                                , maxmin: false //允许全屏最小化
                                , anim: 0 //0-6的动画形式，-1不开启
                                , content: ['../../views/BaseSet/SRM_OpenTmpList.html?linterid=' + sessionStorage["HUserName"] + '&HBarcode=&Type=SRM_POOrderBillList', 'yes']// å®‰ç‘ž type ='SRM_POOrderBillList' åŽŸtype = 'HBarCodePrint'
                                , content: ['../../views/BaseSet/SRM_OpenTmpList.html?linterid=' + sessionStorage["linterid"] + '&HBarcode=&Type=SRM_POOrderBillList', 'yes']// å®‰ç‘ž type ='SRM_POOrderBillList' åŽŸtype = 'HBarCodePrint'
                                , resize: false
                            })
                        }
@@ -351,35 +358,112 @@
                                }
                            });
                        })


                        break;
                    case 'btn-HideColumn':
                        get_HideColumn();
                        break;
                    case 'btn-exit':
                        parent.layui.admin.events.closeThisTabs();
                        break;
                };
            });

            //行监听事件
            table.on('row(mainTable)', function (obj) {
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            });

            ///加载显示数据
            function RoadHBillNo(sqlWhere) {
                var wait = layer.load();//遮罩
                where = sqlWhere;
                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "GetBarCodeShowList",
                    async: true,
                    data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
                    success: function (result) {
                        ajaxReturnData = JSON.parse(JSON.stringify(result)).data;
                        table.reload('mainTable', {
                            data: ajaxReturnData
                            , height: 'full-10'
                            , page: {
                                curr: _cur_page //必须从第 1 é¡µå¼€å§‹
                            }
                            , loading: false
                            , done: function (index, res) {
                    success: function (data1) {
                        //ajaxReturnData = JSON.parse(JSON.stringify(result)).data;
                        //table.reload('mainTable', {
                        //    data: ajaxReturnData
                        //    , height: 'full-10'
                        //    , page: {
                        //        curr: _cur_page //必须从第 1 é¡µå¼€å§‹
                        //    }
                        //    , loading: false
                        //    , done: function (index, res) {

                        //    }
                        //});
                        if (data1.Message == "获取成功") {
                            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', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if (data[i].name.indexOf('id') > -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:
                                            if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
                                            } else if (data[i].name == '供应商交期回复') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' });
                                            } else {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                            }
                                    }
                                }
                            }
                            //动态显示列名
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data
                                , height: 'full-80'
                                , totalRow: true
                                , page: true
                                , cellMinWidth: 90
                                , limit: 500
                                , limits: [50, 500, 5000, 20000]
                            }
                            table.render(option);
                            //刷新表格数据
                            DisPlay_HideColumn();
                            layer.close(wait);
                        } else {
                            layer.close(wait);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    },
                    error: function (result) {
                        console.log(result);
@@ -426,6 +510,115 @@
                var type = $(this).data('type');
                active[type] ? active[type].call(this) : '';
            });

            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//数据库查询出的列数据
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < dataCol.length; i++) {
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;
                                }
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                    option.cols[0][i + 1]["hide"] = false;
                                }
                                //隐藏id
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    if (option.cols[0][i + 1]["field"] == '供应商交期回复') {
                                        option.cols[0][i + 1]["width"] = 120;
                                    } else {
                                        option.cols[0][i + 1]["width"] = dataCols[3];
                                    }
                                }
                                //设置内容字体大小
                                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"] = "";
                                //}

                                //字体所在位置(å·¦ å±…中 å³)
                                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 });
                    }
                })
            }
        });
    </script>
</body>

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

@@ -30,7 +30,7 @@
                    <div class="layui-card-body">
                        <form class="layui-form" action="">
                            <div class="layui-form-item">
                                <div class="layui-inline">
                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">订单状态</label>
                                    <div class="layui-input-block">
                                        <select name="HStatus" id="HStatus" lay-filter="">
@@ -38,40 +38,6 @@
                                            <option value="未确认">未确认</option>
                                            <option value="已确认">已确认</option>
                                            <option value="已驳回">已驳回</option>
                                        </select>
                                    </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>
                                <div class="layui-inline">
                                    <label class="layui-form-label">物料代码</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HNumber" id="HNumber">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">产品名称</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HName" id="HName">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">规格型号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HModel" id="HModel">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">关闭状态</label>
                                    <div class="layui-input-block">
                                        <select id="HClStatus" name="HClStatus" lay-filter="">
                                            <option value="">全部</option>
                                            <option value="未关闭" selected="">未关闭</option>
                                            <option value="已关闭">已关闭</option>
                                        </select>
                                    </div>
                                </div>
@@ -87,16 +53,73 @@
                                        <input type="text" class="layui-input" name="HDate2" id="HDate2">
                                    </div>
                                </div>

                                <div class="layui-inline">
                                    <label class="layui-form-label">采购组织</label>
                                    <label class="layui-form-label">物料编码</label>
                                    <div class="layui-input-block">
                                        <select id="HPURCHASEORGID" name="HPURCHASEORGID" lay-filter="">
                                            <option value="">组织1</option>
                                            <option value="">组织2</option>
                                        <input type="text" class="layui-input" name="HNumber" id="HNumber">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">供应商对应物料代码</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HSupNumber" id="HSupNumber" style="margin-top:10px">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">规格型号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HModel" id="HModel">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">退料方式</label>
                                    <div class="layui-input-block" style="width:185px;">
                                        <select id="HReturnMethod" name="HReturnMethod" lay-filter="">
                                            <option value="" selected="">全部</option>
                                            <option value="退料补料">退料补料</option>
                                            <option value="退料并扣款">退料并扣款</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">供应商</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HSupName" id="HSupName">
                                    </div>
                                </div>

                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HBillNo" id="HBillNo">
                                    </div>
                                </div>

                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">产品名称</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HName" id="HName">
                                    </div>
                                </div>

                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">关闭状态</label>
                                    <div class="layui-input-block">
                                        <select id="HClStatus" name="HClStatus" lay-filter="">
                                            <option value="" selected="">全部</option>
                                            <option value="未关闭">未关闭</option>
                                            <option value="已关闭">已关闭</option>
                                        </select>
                                    </div>
                                </div>

                                <div class="layui-inline" style="display:none;">
                                    <label class="layui-form-label">退料组织</label>
                                    <div class="layui-input-block">
                                        <select id="HSTOCKORGID" name="HSTOCKORGID" lay-filter="">
                                        </select>
                                    </div>
                                </div>                                
                                <div class="layui-inline">
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
@@ -112,12 +135,13 @@
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>-->
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认收货</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back"><i class="layui-icon layui-icon-close-fill"></i>收货异常</button>-->
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button>-->
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>打印退货单</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成条码</button>-->
                              <button type="button" class="layui-btn layui-btn-sm" id="btn_HideColumn" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>

                        </div>
@@ -195,7 +219,29 @@
                elem: '#HDate2'
            });
            //layui.code();
            RoadHBillNo(sql);
            //RoadHBillNo(sql);

            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["hsupid","FSTOCKORGID"];
            var option = [];
            var HModName = "SRM_POInStockBackBillList";

            set_ClearBill();
            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
            function set_ClearBill() {
                //渲染退料组织
                var Organization = '<option value=' + sessionStorage["OrganizationID"] + ' style="color:red;">' + sessionStorage["Organization"] + '</option>';
                $("#HSTOCKORGID").append(Organization);
                form.render('select');
                //初始化表格
                //set_InitGrid();
                //显示列数据
                //DisPlay_HideColumn();
                //直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
                get_FastQuery(table, option)
            }           

            //get_Display(sql);
            layer.load(3)
            //方法级渲染
            table.render({
@@ -293,8 +339,88 @@
                    case 'btn-exit': 
                        parent.layui.admin.events.closeThisTabs();
                        break;
                    case 'btn-HideColumn':
                        get_HideColumn();
                        break;
                };
            });

            //加载显示数据
            function get_Display(sqlWhere) {
                var wait = layer.load();//遮罩
                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "GetPOInStockBackBill",
                    async: true,
                    data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
                    success: function (data1) {
                        if (data1.Message == "获取成功") {
                            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', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if (data[i].name.indexOf('id') > -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:
                                            if ( data[i].name == '实退数量') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
                                            } else if (data[i].name == '单据编号' || data[i].name == '退料日期') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 135 });
                                            } else if (data[i].name == '供应商' ) {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 220 });
                                            } else if (data[i].name == '规格型号' || data[i].name == '备注') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 515 });
                                            } else {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                            }
                                    }
                                }
                            }
                            //动态显示列名
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data
                                , height: 'full-80'
                                , totalRow: true
                                , page: true
                                , cellMinWidth: 90
                                , limit: 500
                                , limits: [50, 500, 5000, 20000]
                            }
                            table.render(option);
                            //刷新表格数据
                            DisPlay_HideColumn();
                            layer.close(wait);
                        } else {
                            layer.close(wait);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    },
                    error: function (result) {
                        layer.close(wait);
                        layer.alert(result.Message, { icon: 5 });
                    }
                });
            };


            ///加载显示数据
            function RoadHBillNo(sqlWhere) {
@@ -324,33 +450,48 @@
                    }
                });
            };
            form.on('submit(f_Query)', function (data) {//查询

            function get_FastQuery(table, option) {
                var sqlWhere = " ";
                if ($("#HStatus").val() != "")
                    sqlWhere += " and çŠ¶æ€ like ^^%" + $("#HStatus").val() + "%^^";
                if ($("#HBillNo").val() != "")
                    sqlWhere += " and å•æ®å· like ^^%" + $("#HBillNo").val() + "%^^";
                if ($("#HNumber").val() != "")
                    sqlWhere += " and ç‰©æ–™ä»£ç  like ^^%" + $("#HNumber").val() + "%^^";
                if ($("#HName").val() != "")
                    sqlWhere += " and ç‰©æ–™åç§° like ^^%" + $("#HName").val() + "%^^";
                if ($("#HModel").val() != "")
                    sqlWhere += " and è§„格型号 like ^^%" + $("#HModel").val() + "%^^";
                if ($("#HClStatus").val() != "")
                    sqlWhere += " and å…³é—­çŠ¶æ€ like ^^%" + $("#HClStatus").val() + "%^^";
                if ($("#HPURCHASEORGID").val() != "")
                    sqlWhere += " and é‡‡è´­ç»„织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^";
                if ($("#HDate1").val() != "") {
                    sqlWhere += " and æ—¥æœŸ >= ^^" + $("#HDate1").val() + "^^";
                    sqlWhere += " and é€€æ–™æ—¥æœŸ >= ^^" + $("#HDate1").val() + "^^";
                }
                if ($("#HDate2").val() != "") {
                    sqlWhere += " and æ—¥æœŸ <= ^^" + $("#HDate2").val() + "^^";
                    sqlWhere += " and é€€æ–™æ—¥æœŸ <= ^^" + $("#HDate2").val() + "^^";
                }
                if ($("#HNumber").val() != "")
                    sqlWhere += " and ç‰©æ–™ç¼–码 like ^^%" + $("#HNumber").val() + "%^^";
                if ($("#HSupNumber").val() != "")
                    sqlWhere += " and ä¾›åº”商对应物料代码 like ^^%" + $("#HSupNumber").val() + "%^^";
                if ($("#HModel").val() != "")
                    sqlWhere += " and è§„格型号 like ^^%" + $("#HModel").val() + "%^^";
                if ($("#HReturnMethod").val() != "")
                    sqlWhere += " and é€€æ–™æ–¹å¼ like ^^%" + $("#HReturnMethod").val() + "%^^";
                if ($("#HSupName").val() != "")
                    sqlWhere += " and ä¾›åº”商 like ^^%" + $("#HSupName").val() + "%^^";

                if ($("#HSTOCKORGID").val() != "" && $("#HSTOCKORGID option:selected").text() != "安瑞集团")
                    sqlWhere += " and FSTOCKORGID = ^^" + $("#HSTOCKORGID").val() + "^^";
                //if ($("#HStatus").val() != "")
                //    sqlWhere += " and çŠ¶æ€ like ^^%" + $("#HStatus").val() + "%^^";
                //if ($("#HBillNo").val() != "")
                //    sqlWhere += " and å•æ®å· like ^^%" + $("#HBillNo").val() + "%^^";
                //if ($("#HName").val() != "")
                //    sqlWhere += " and ç‰©æ–™åç§° like ^^%" + $("#HName").val() + "%^^";
                //if ($("#HClStatus").val() != "")
                //    sqlWhere += " and å…³é—­çŠ¶æ€ like ^^%" + $("#HClStatus").val() + "%^^";
                //if ($("#HPURCHASEORGID").val() != "")
                //    sqlWhere += " and é‡‡è´­ç»„织 like ^^%" + $("#HPURCHASEORGID").val() + "%^^";

                sql = sqlWhere;
                //从第一页开始
                _cur_page = 1;
                RoadHBillNo(sqlWhere);
                //RoadHBillNo(sqlWhere);
                get_Display(sqlWhere);
            }

            form.on('submit(f_Query)', function (data) {//查询
                get_FastQuery(table, option);
            });
            var $ = layui.$, active = {
                reload: function () {
@@ -374,6 +515,116 @@
                var type = $(this).data('type');
                active[type] ? active[type].call(this) : '';
            });

            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//数据库查询出的列数据
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < dataCol.length; i++) {
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;
                                }
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                    option.cols[0][i + 1]["hide"] = false;
                                }
                                //隐藏id
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    if (option.cols[0][i + 1]["field"] == '供应商交期回复') {
                                        option.cols[0][i + 1]["width"] = 120;
                                    } else {
                                        option.cols[0][i + 1]["width"] = dataCols[3];
                                    }
                                }
                                //设置内容字体大小
                                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"] = "";
                                //}

                                //字体所在位置(å·¦ å±…中 å³)
                                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 });
                    }
                })
            }

        });
    </script>
</body>

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

@@ -289,28 +289,42 @@
                    // , { field: 'HMTONO', title: '计划跟踪单号', width: 100,, sort: true, fixed: true edit: 'text', hide: true }
                    , { field: 'HMaterID', title: '物料ID', width: 100, edit: 'text', hide: true }
                    , { field: 'HMaterNumber', title: '物料编码', width: 120 }
                    , { field: 'HOldMaterNumber', title: '旧物料编码', width: 120 }
                    , { field: 'HSubjoin', title: '物料代码', width: 120 }
                    , { field: 'HOldMaterNumber', title: '旧物料编码', width: 120, hide: true }
                    , { field: 'HSubjoin', title: '物料代码', width: 120, hide: true }
                    , { field: 'HMaterName', title: '物料名称', width: 120 }
                    , { field: 'HMaterModel', title: '规格型号', width: 120 }
                    , { field: 'HUnitName', title: '计量单位', width: 100 }

                    , { field: 'HUnitName', title: '计量单位', width: 120 }
                    , { field: 'HBatChNo', title: '批号', width: 120 }
                    , { field: 'HKFDate', title: '生产日期', width: 100 }
                    , { field: 'HSourceQty', title: '源单数量', width: 100 }
                    , { field: 'HQty', title: '送货数量', width: 100 }
                    , { field: 'HPOOrderBillNo', title: '采购订单号', width: 100 }
                    , { field: '未生成条码数量', title: '未生成条码数量', width: 100 }
                    , { field: '收货地址', title: '收货地址', width: 100 }
                    , { field: '供应商料号', title: '供应商料号', width: 100 }
                    , { field: '供应商批次', title: '供应商批次', width: 100 }
                    , { field: '供应商', title: '供应商', width: 100 }
                    , { field: '含税单价', title: '含税单价', width: 100 }
                    , { field: '金额', title: '金额', width: 100 }
                    , { field: 'HSourceBillNo', title: '源单单号', width: 200 }

                    , { field: 'HUnitNumber', title: '计量单位代码', width: 100, hide: true }
                    , { field: 'HUnitID', title: '计量单位ID', width: 100, hide: true }
                    , { field: 'HQty', title: '数量', width: 100 }
                    , { field: 'HPrice', title: '单价', width: 100, hide: true}
                    , { field: 'HMoney', title: '金额', width: 100, hide: true}
                    , { field: 'HWHName', title: '收料仓库', width: 100 }
                    , { field: 'HQty', title: '数量', width: 100, hide: true }
                    , { field: 'HPrice', title: '单价', width: 100, hide: true }
                    , { field: 'HMoney', title: '金额', width: 100, hide: true }
                    , { field: 'HWHName', title: '收料仓库', width: 100, hide: true }
                    , { field: 'HWHNumber', title: '收料仓库代码', width: 100, hide: true }
                    , { field: 'HWHID', title: '收料仓库ID', width: 100, hide: true }
                    , { field: 'HPOOrderInterID', title: '采购订单主内码', width: 150, hide: true }
                    , { field: 'HPOOrderEntryID', title: '采购订单子内码', width: 150, hide: true }
                    , { field: 'HPOOrderBillNo', title: '采购订单号', width: 200 }
                    , { field: 'HPOOrderBillNo', title: '采购订单号', width: 200, hide: true }
                    , { field: 'HWWOrderInterID', title: '委外订单主内码', width: 150, hide: true }
                    , { field: 'HWWOrderEntryID', title: '委外订单子内码', width: 150, hide: true }
                    , { field: 'HWWOrderDetaiLID', title: '委外订单明细内码', width: 150, hide: true }
                    , { field: 'HWWOrderBillNo', title: '委外订单号', width: 200 }
                    , { field: 'HWWOrderBillNo', title: '委外订单号', width: 200, hide: true }
                    , { field: 'HSourceBillType', title: '源单类型', width: 100, hide: true }
                    , { field: 'HSourceBillNo', title: '源单单号', width: 200 }
                    , { field: 'HSourceEntryID', title: '源单子内码', width: 150, hide: true }
                    , { field: 'HSourceInterID', title: '源单主内码', width: 150, hide: true }
                ]]

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

@@ -32,42 +32,53 @@
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">订单状态</label>
                                        <div class="layui-input-block">
                                            <select name="HStatus" id="HStatus" lay-filter="">
                                                <option value="" selected="">全部</option>
                                                <option value="未打印">未打印</option>
                                                <option value="未到货">未到货</option>
                                                <option value="已到货">已到货</option>
                                                <option value="未生成条码">未生成条码</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">单据号</label>
                                        <div class="layui-input-block">
                                        <div class="layui-input-block" style="width:150px;">
                                            <input type="text" class="layui-input" name="HBillNo" id="HBillNo">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">源单单号</label>
                                        <div class="layui-input-block">
                                        <label class="layui-form-label">采购订单号</label>
                                        <div class="layui-input-block" style="width:150px;">
                                            <input type="text" class="layui-input" name="HBillNoFrom" id="HBillNoFrom">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">送货单号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HInnerBillNo" id="HInnerBillNo">
                                        <label class="layui-form-label">开始日期</label>
                                        <div class="layui-input-block" style="width:120px;">
                                            <input type="text" class="layui-input" name="HDate1" 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="HNumber" id="HNumber">
                                        <label class="layui-form-label">结束日期</label>
                                        <div class="layui-input-block" style="width:120px;">
                                            <input type="text" class="layui-input" name="HDate2" id="HDate2">
                                        </div>
                                    </div>

                                    <div class="layui-inline">
                                        <label class="layui-form-label">单据状态</label>
                                        <div class="layui-input-block">
                                            <select id="HClStatus" name="HClStatus" lay-filter="">
                                                <option value=""  selected="">全部</option>
                                                <option value="未审核">未审核</option>
                                                <option value="已审核">已审核</option>
                                                <option value="未关闭">未关闭</option>
                                                <option value="已关闭">已关闭</option>
                                            </select>
                                        </div>
                                    </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="HName" id="HName">
                                        </div>
                                    </div>                                   
                                    <div class="layui-inline">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
@@ -75,21 +86,9 @@
                                    </div>
                                    <div class="layui-colla-content" style="padding-left:82px">
                                        <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="HOldMaterNumber" id="HOldMaterNumber">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">物料名称</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HName" id="HName">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
@@ -98,16 +97,28 @@
                                                <input type="text" class="layui-input" name="HModel" id="HModel">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">单据状态</label>
                                        <div class="layui-inline" style="display:none">
                                            <label class="layui-form-label">订单状态</label>
                                            <div class="layui-input-block">
                                                <select id="HClStatus" name="HClStatus" lay-filter="">
                                                    <option value="">全部</option>
                                                    <option value="审核">审核</option>
                                                    <option value="审核">反审核</option>
                                                    <option value="未关闭" selected="">未关闭</option>
                                                    <option value="已关闭">已关闭</option>
                                                <select name="HStatus" id="HStatus" lay-filter="">
                                                    <option value="" selected="">全部</option>
                                                    <option value="未打印">未打印</option>
                                                    <option value="未到货">未到货</option>
                                                    <option value="已到货">已到货</option>
                                                    <option value="未生成条码">未生成条码</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline" style="display:none">
                                            <label class="layui-form-label">送货单号</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HInnerBillNo" id="HInnerBillNo">
                                            </div>
                                        </div>
                                        <div class="layui-inline" style="display:none;">
                                            <label class="layui-form-label">物料代码</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HNumber" id="HNumber">
                                            </div>
                                        </div>
                                    </div>
@@ -213,6 +224,8 @@
            });
            var option = [];
            var HModName = "SRM_POInStockBillList";
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["HItemID", "HParentID", "hmainid","hsubid","F_xbkf_Combo","FSHDD","HPrintId"];
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            set_ClearBill();
            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
@@ -315,7 +328,7 @@
                    success: function (data1) {
                        if (data1.data.length != 0) {
                            var dataCol = [];//数据库查询出的列数据
                            var titleData = [];//不需要显示的字段 å¯æ‰©å±•
                            var titleData = ["HItemID", "HParentID", "hmainid", "hsubid", "F_xbkf_Combo", "FSHDD", "HPrintId"];//不需要显示的字段 å¯æ‰©å±•

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

@@ -389,19 +402,87 @@
            ///加载显示数据
            function get_Display(sqlWhere) {
                var wait = layer.load();//遮罩
                //$.ajax({
                //    type: "POST",
                //    url: GetWEBURL() + "GetPOInStockBill",
                //    async: false,
                //    data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
                //    success: function (result) {
                //        if (result.Message == "获取成功") {
                //            option.data = result.data;
                //            table.render(option);
                //            layer.close(wait);
                //        } else {
                //            layer.close(wait);
                //            layer.alert(result.Message, { icon: 5 });
                //        }
                //    },
                //    error: function (result) {
                //        layer.close(wait);
                //        layer.alert(result.Message, { icon: 5 });
                //    }
                //});

                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "GetPOInStockBill",
                    async: false,
                    async: true,
                    data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
                    success: function (result) {
                        if (result.Message == "获取成功") {
                            option.data = result.data;
                    success: function (data1) {
                        if (data1.Message == "获取成功") {
                            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', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {
                                    col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                                }
                                else if (data[i].name.indexOf('id') > -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:
                                            if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
                                            } else if (data[i].name == '回复交期') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' });
                                            } else {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                            }
                                    }
                                }
                            }
                            //动态显示列名
                            option = {
                                elem: '#mainTable'
                                , toolbar: '#toolbarDemo'
                                , cols: [col]
                                , data: data1.data
                                , height: 'full-80'
                                , totalRow: true
                                , page: true
                                , cellMinWidth: 90
                                , limit: 500
                                , limits: [50, 500, 5000, 20000]
                            }
                            table.render(option);
                            //刷新表格数据
                            DisPlay_HideColumn();
                            layer.close(wait);
                        } else {
                            layer.close(wait);
                            layer.alert(result.Message, { icon: 5 });
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    },
                    error: function (result) {
@@ -443,6 +524,12 @@
                    sqlWhere += " and è§„格型号 like ^^%" + $("#HModel").val() + "%^^";
                if ($("#HClStatus").val() != "")
                    sqlWhere += " and å•æ®çŠ¶æ€ like ^^%" + $("#HClStatus").val() + "%^^";
                if ($("#HDate1").val() != "") {
                    sqlWhere += " and æ—¥æœŸ >= ^^" + $("#HDate1").val() + "^^";
                }
                if ($("#HDate2").val() != "") {
                    sqlWhere += " and æ—¥æœŸ <= ^^" + $("#HDate2").val() + "^^";
                }
                sql = sqlWhere;
                _cur_page = 1;
                get_Display(sqlWhere);
@@ -587,8 +674,12 @@
                    case 'btn-print':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        if (data.length == 0) {
                            layer.msg("请选择数据", { icon: 5 });
                        if (data.length != 1) {
                            layer.msg("请选择一条数据", { icon: 5 });
                            return;
                        }
                        if (data[0].单据状态 != '已审核') {
                            layer.msg("请审核送货单后在进行打印( Â´â—”︎ â€¸â—”︎`)", { icon: 5 });
                            return;
                        }
                        //for (var i = 0; i < data.length; i++) {
@@ -642,6 +733,25 @@
                        break;
                };
            });

            //行监听事件
            table.on('row(mainTable)', function (obj) {
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            });
        });
    </script>
</body>

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POInStockBillList±¸·Ý.html

New file
@@ -0,0 +1,648 @@


<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>送货单列表</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
    <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
    <link rel="stylesheet" href="../../layuiadmin/layui/css/style-self.css" media="all">
    <style type="text/css">
        .layui-input-block {
            width: 190px;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-row layui-col-space15">
            <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">
                                            <select name="HStatus" id="HStatus" lay-filter="">
                                                <option value="" selected="">全部</option>
                                                <option value="未打印">未打印</option>
                                                <option value="未到货">未到货</option>
                                                <option value="已到货">已到货</option>
                                                <option value="未生成条码">未生成条码</option>
                                            </select>
                                        </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>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">源单单号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HBillNoFrom" id="HBillNoFrom">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">送货单号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HInnerBillNo" id="HInnerBillNo">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料代码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HNumber" id="HNumber">
                                        </div>
                                    </div>

                                    <div class="layui-inline">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                        </button>
                                    </div>
                                    <div class="layui-colla-content" style="padding-left:82px">
                                        <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="HOldMaterNumber" id="HOldMaterNumber">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">物料名称</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HName" id="HName">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">规格型号</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HModel" id="HModel">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">单据状态</label>
                                            <div class="layui-input-block">
                                                <select id="HClStatus" name="HClStatus" lay-filter="">
                                                    <option value="">全部</option>
                                                    <option value="审核">审核</option>
                                                    <option value="审核">反审核</option>
                                                    <option value="未关闭" selected="">未关闭</option>
                                                    <option value="已关闭">已关闭</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>

                                </div>
                            </div>
                        </form>
                    </div>
                    <table class="layui-hide" 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="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back"><i class="layui-icon layui-icon-close-fill"></i>驳回</button>-->
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-changebg"><i class="layui-icon layui-icon-form"></i>变更</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>打印送货单</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></i>删除</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成条码</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                        </div>
                    </script>
                </div>
            </div>
        </div>
    </div>
    <!--<script src="../../layuiadmin/layui/lay/modules/mobile/jquery-3.3.1.min.js"></script>-->
    <script src="../../layuiadmin/layui/layui.js"></script>
    <script src="../CreateControl.js"></script>
    <script src="../GRInstall.js"></script>
    <script src="../GRUtility.js"></script>
    <script src="../../../../Scripts/webConfig.js"></script>
    <script>
        var _cur_page = 1;
        var sql = "";
        var options = document.getElementById('HStatus').children;
        function getUrlVars() {
            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;
        }
        function f_alert(sMsg) {
            layer.alert(sMsg, { icon: 5 });
            //layer.open({
            //    type: 1
            //  , offset: 'auto' //具体配置参考：http://www.layui.com/doc/modules/layer.html#offset
            //  , id: 'layerDemo' //防止重复弹出
            //  , content: '<div style="padding: 20px 100px;">' + sMsg + '</div>'
            //  , shade: 0 //不显示遮罩
            //  , yes: function () {
            //      layer.closeAll();
            //  }
            //});
        }
        var params = getUrlVars();
        var type = params[params[0]];
        switch (type) {
            case "UnPrint":
                options[1].selected = true;
                sql += " and çŠ¶æ€ like ^^%未打印%^^";
                break;
            case "UnArrival":
                options[2].selected = true;
                sql += " and çŠ¶æ€ like ^^%未到货%^^";
                break;
            case "ReArrival":
                options[3].selected = true;
                sql += " and çŠ¶æ€ like ^^%已到货%^^";
                break;
            case "UnBarCode":
                options[4].selected = true;
                sql += " and çŠ¶æ€ like ^^%未生成条码%^^";
                break;
        }
        //CreateReport("Report");  //打印
        //Report.LoadFromURL("送货单(A4纸).grf");//打印
        layui.config({
            base: '../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer'], function () {
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , laydate = layui.laydate
                , table = layui.table
                , form = layui.form
                , element = layui.element;
            //常规用法
            laydate.render({
                elem: '#HDate1'
            });
            laydate.render({
                elem: '#HDate2'
            });
            var option = [];
            var HModName = "SRM_POInStockBillList";
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            set_ClearBill();
            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
            function set_ClearBill() {
                //初始化表格
                set_InitGrid();
                //显示列数据
                DisPlay_HideColumn();
                //直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
                get_FastQuery(table, option)
            }
            function set_InitGrid() {
                var columns = [
                    { checkbox: true, fixed: 'left', totalRowText: '合计'/*, fixed: true*/ }
                    , { field: 'sorderid', title: '序号', width: 80/*, fixed: true*/ }
                    , { field: 'hmainid', title: 'hmainid', sort: true/*, fixed: true*/, hide: true }
                    , { field: 'hsubid', title: 'hsubid', sort: true/*, fixed: true*/, hide: true }
                    , { field: '状态', title: '状态', width: 100, sort: true/*, fixed: true*/ }
                    , { field: '单据状态', title: '单据状态', sort: true/*, fixed: true*/ }
                    , { field: '单据号', title: '单据号', width: 135, sort: true/*, fixed: true*/ }
                    , { field: '送货单号', title: '送货单号', width: 135, sort: true/*, fixed: true*/ }
                    , { field: 'F_xbkf_Combo', title: '自定义标识', width: 135 }
                    , { field: '源单单号', title: '源单单号', width: 135 }
                    , { field: '包装标识', title: '包装标识', width: 135 }
                    //, { field: '物流单号', title: '物流单号', width: 150, sort: true/*, fixed: true*/ }
                    , { field: '物料编码', title: '物料编码', width: 120, sort: true }
                    , { field: '旧物料编码', title: '旧物料编码', width: 120, sort: true }
                    , { field: '物料代码', title: '物料代码', width: 120, sort: true }
                    , { field: '物料名称', title: '物料名称', width: 120, sort: true }
                    , { field: '规格型号', title: '规格型号', width: 120, sort: true }
                    , { field: '计量单位', title: '计量单位', width: 80, sort: true }
                    , { field: '数量', title: '订货数量', width: 100, sort: true, totalRow: true  }
                    , { field: '未生成条码数量', title: '未生成条码数量', width: 100, sort: true, totalRow: true  }
                    , { field: '合格数量', title: '合格数量', width: 100, sort: true, totalRow: true  }
                    , { field: '不合格数量', title: '不合格数量', width: 100, sort: true, totalRow: true  }
                    , { field: '含税单价', title: '含税单价', width: 100, sort: true, hide: true }
                    , { field: '金额', title: '金额', width: 100, sort: true, hide: true }
                    , { field: '日期', title: '日期', width: 150, sort: true }
                    , { field: '批次', title: '批次', width: 150, sort: true }
                    , { field: '生产日期', title: '生产日期', width: 150, sort: true, hide: true }
                    , { field: '预计到货日期', title: '预计到货日期', width: 150, sort: true, hide: true }
                    , { field: '源单主内码', title: '源单主ID', width: 100, hide: true }
                    , { field: '源单子内码', title: '源单子ID', width: 100, hide: true }
                    , { field: 'FSHDD', title: '送货地点', width: 120 }
                    , { field: '源单类型', title: '源单类型', width: 80, hide: true }
                    , { field: '采购订单号', title: '采购订单号', width: 180, sort: true, hide: true }
                    , { field: '委外订单号', title: '委外订单号', width: 180, sort: true, hide: true }
                    , { field: '变更状态', title: '变更状态', sort: true }
                    , { field: '收料组织', title: '收料组织', sort: true, hide: true }
                    , { field: '采购组织', title: '采购组织', sort: true, hide: true }
                    , { field: '需求组织', title: '需求组织', sort: true, hide: true }
                ];
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , page: true
                    //, cellMinWidth: 120
                    , totalRow: true
                    , limit: 500
                    , height: 'full-50'
                    , cols: [columns]
                    , limits: [500, 5000, 20000]
                    , done: function (res, curr, count) {

                    }
                };
            }
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//不需要显示的字段 å¯æ‰©å±•

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

                            for (var i = 0; i < dataCol.length; 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];
                                }
                                //设置内容字体大小
                                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 get_Display(sqlWhere) {
                var wait = layer.load();//遮罩
                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "GetPOInStockBill",
                    async: false,
                    data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
                    success: function (result) {
                        if (result.Message == "获取成功") {
                            option.data = result.data;
                            table.render(option);
                            layer.close(wait);
                        } else {
                            layer.close(wait);
                            layer.alert(result.Message, { icon: 5 });
                        }
                    },
                    error: function (result) {
                        layer.close(wait);
                        layer.alert(result.Message, { icon: 5 });
                    }
                });
            };
            //查询按钮
            form.on('submit(btnSearch)', function (data) {//查询
                get_FastQuery(table, option);
            });
            //查询条件
            function get_FastQuery(table, option) {
                var sqlWhere = "";
                if ($("#HStatus").val() != "")
                    if ($("#HStatus").val() == "未生成条码") {
                        sqlWhere += " and æœªç”Ÿæˆæ¡ç æ•°é‡ > 0";
                    }
                    else {
                        sqlWhere += " and çŠ¶æ€ like ^^%" + $("#HStatus").val() + "%^^";
                    }

                if ($("#HBillNo").val() != "")
                    sqlWhere += " and å•æ®å· like ^^%" + $("#HBillNo").val() + "%^^";
                if ($("#HBillNoFrom").val() != "")
                    sqlWhere += " and æºå•å•å· like ^^%" + $("#HBillNoFrom").val() + "%^^";
                if ($("#HInnerBillNo").val() != "")
                    sqlWhere += " and é€è´§å•å· like ^^%" + $("#HInnerBillNo").val() + "%^^";
                if ($("#HOldMaterNumber").val() != "")
                    sqlWhere += " and æ—§ç‰©æ–™ç¼–码 like ^^%" + $("#HOldMaterNumber").val() + "%^^";
                if ($("#HMaterNumber").val() != "")
                    sqlWhere += " and ç‰©æ–™ç¼–码 like ^^%" + $("#HMaterNumber").val() + "%^^";
                if ($("#HNumber").val() != "")
                    sqlWhere += " and ç‰©æ–™ä»£ç  like ^^%" + $("#HNumber").val() + "%^^";
                if ($("#HName").val() != "")
                    sqlWhere += " and ç‰©æ–™åç§° like ^^%" + $("#HName").val() + "%^^";
                if ($("#HModel").val() != "")
                    sqlWhere += " and è§„格型号 like ^^%" + $("#HModel").val() + "%^^";
                if ($("#HClStatus").val() != "")
                    sqlWhere += " and å•æ®çŠ¶æ€ like ^^%" + $("#HClStatus").val() + "%^^";
                sql = sqlWhere;
                _cur_page = 1;
                get_Display(sqlWhere);
            }
            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                var checkStatus = table.checkStatus(obj.config.id);
                switch (obj.event) {
                    case 'btn-getCheckData':
                        var data = checkStatus.data;
                        layer.alert(JSON.stringify(data));
                        break;
                    //case 'getCheckLength':
                    //    var data = checkStatus.data;
                    //    layer.msg('选中了：' + data.length + ' ä¸ª');
                    //    break;
                    //case 'isAll':
                    //    layer.msg(checkStatus.isAll ? '全选' : '未全选');
                    //    break;
                    //审核
                    case 'btn-Audit':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        var InterID = "";
                        if (checkStatus.data.length > 0) {
                            for (var i = 0; i < checkStatus.data.length; i++) {
                                InterID += data[i].hmainid.toString() + ",";
                            }
                            InterID = InterID.substring(0, InterID.length - 1);

                            var HBillNo = data[0].单据号;
                            //逻辑审核方法
                            $.ajax({
                                type: "GET",
                                url: GetWEBURL() + "/AuditPOInStockBill",
                                data: { "HInterID": InterID, "CurUserName": sessionStorage["HUserName"], "HBillNo": HBillNo },
                                success: function (result) {
                                    if (result.count == 1) {
                                        layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                            // å¾—到frame索引
                                            var index = layer.getFrameIndex(window.name);
                                            //关闭当前frame
                                            layer.close(index);
                                            //修改为功后刷新界面
                                            get_Display(sql);
                                        });

                                    } else {
                                        layer.alert(result.Message, { icon: 5 });
                                    }
                                }, error: function () {
                                    layer.alert("接口请求失败!", { icon: 5 });
                                }
                            });
                        }
                        else {
                            layer.msg('请选择数据！');
                        }
                    //自定义头工具栏右侧图标 - æç¤º
                    case 'btn-reload':
                        _cur_page = $(".layui-laypage-em").next().html();
                        get_Display(sql);
                        //    });
                        break;
                    case 'btn-HideColumn':
                        get_HideColumn();
                        break;
                    case 'btn-details':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;

                        var linterid = data[0].hmainid.toString();
                        //if (AllowLoadData(sSubStr) != false) {//非空验证
                        layer.open({
                            type: 2
                            , area: ['100%', '100%']
                            , title: '送货单'
                            , shade: 0.6 //遮罩透明度
                            , maxmin: true //允许全屏最小化
                            , anim: 0 //0-6的动画形式，-1不开启
                            , content: '../../../src/views/SRM/SRM_POInStockBill.html?linterid=' + linterid
                            , resize: false
                            , cancel: function () {
                                //$(".layui-btn").removeClass("layui-btn-disabled");
                            }
                        })
                        break;
                    case 'btn-changebg':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;

                        var linterid = data[0].hmainid.toString();
                        //if (AllowLoadData(sSubStr) != false) {//非空验证
                        layer.open({
                            type: 2
                            , area: ['100%', '100%']
                            , title: '送货单'
                            , shade: 0.6 //遮罩透明度
                            , maxmin: true //允许全屏最小化
                            , anim: 0 //0-6的动画形式，-1不开启
                            , content: '../../../src/views/SRM/SRM_POInStockBill.html?linterid=' + linterid + '&type =changebg'
                            , resize: false
                            , cancel: function () {
                                //$(".layui-btn").removeClass("layui-btn-disabled");
                            }
                        })
                        break;
                    case 'btn-Delete':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        var InterID = "";
                        for (i = 0; i < data.length; i++) {
                            InterID += data[i].hmainid.toString() + ",";
                        }
                        InterID = InterID.substring(0, InterID.length - 1)
                        //逻辑删除方法
                        layer.confirm("确认要删除吗，删除后不能恢复", { title: "删除确认" }, function (index) {
                            $.ajax({
                                type: "GET",
                                url: GetWEBURL() + "/DeltetPOInStockBill", //方法所在页面和方法名
                                data: { "HInterID": InterID, "HUserName": sessionStorage["HUserName"] },
                                success: function (result) {
                                    if (result.count == 1) {
                                        layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                            // å¾—到frame索引
                                            var index = layer.getFrameIndex(window.name);
                                            //关闭当前frame
                                            layer.close(index);
                                            //修改为功后刷新界面
                                            window.location.reload();
                                        });

                                    } else {
                                        layer.alert(result.Message, { icon: 5 });
                                    }
                                }, error: function () {
                                    layer.alert("接口请求失败!", { icon: 5 });
                                }
                            });
                        })
                        break;
                    case 'btn-print':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        if (data.length == 0) {
                            layer.msg("请选择数据", { icon: 5 });
                            return;
                        }
                        //for (var i = 0; i < data.length; i++) {
                        //    if (data[i].单据状态 != "审核") {
                        //        layer.msg("选中行未审核", { icon: 5 });
                        //        return;
                        //    }
                        //}
                        layer.open({
                            type: 2
                            , area: ['50%', '50%']
                            , title: '打印模版选择'
                            , shade: 0.6 //遮罩透明度
                            , maxmin: false //允许全屏最小化
                            , anim: 0 //0-6的动画形式，-1不开启
                            , content: ['../../views/BaseSet/SRM_OpenTmpList.html?linterid=' + data[0].hmainid.toString() + '&MyMsg=' + data[0].hmainid.toString() + '&Type=SRM_POInStockBillList', 'yes']
                            , resize: false
                            //, cancel: function () {
                            //    $(".layui-btn").removeClass("layui-btn-disabled");
                            //}
                        })

                        break;
                    case 'btn-generate':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        if (data[0].未生成条码数量 <= 0) {
                            layer.msg("选中行已生成条码！", { icon: 5 });
                        }
                        else {
                            layer.open({
                                type: 2
                                , area: ['100%', '100%']
                                , title: '条码生成'
                                , shade: 0.6 //遮罩透明度
                                , maxmin: false //允许全屏最小化
                                , anim: 0 //0-6的动画形式，-1不开启
                                , content: ['../../views/SRM/SRM_BarCodeBill.html?linterid=' + data[0].hmainid + '&lentryid=' + data[0].hsubid, 'yes']
                                , resize: false
                                , cancel: function () {
                                    $(".layui-btn").removeClass("layui-btn-disabled");
                                }
                            })
                        }
                        break;
                    case 'btn-exit':
                        //var index = parent.layer.getFrameIndex(window.name);
                        //element.tabDelete('layadmin-layout-tabs', this);
                        parent.layui.admin.events.closeThisTabs();
                        //parent.layer.close(index);
                        break;
                };
            });
        });
    </script>
</body>
</html>

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

@@ -27,6 +27,7 @@
                                <button type="button" id="add-btn" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Saver">保存</button>
                                <button type="button" id="aduit-btn" 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="ChooseSource">选源单</button>
                                <button type="button" class="layui-btn layui-btn-normal layui-btn-radius" lay-submit="" lay-filter="Exit">退出</button>
                            </div>
                        </div>
@@ -92,7 +93,7 @@
                                                    </div>
                                                </div>

                                                <div class="layui-col-xs3">
                                                <div class="layui-col-xs3" style="display:none;">
                                                    <label class="layui-form-label"> éƒ¨    é—¨ï¼š</label>
                                                    <div class="layui-input-inline">
                                                        <input class="layui-input" name="HDeptName" lay-verify="HDeptName" id="HDeptName" readonly="readonly" autocomplete="off">
@@ -127,9 +128,9 @@
                                                    <div class="layui-input-inline">
                                                        <input class="layui-input" name="HInnerBillNo" id="HInnerBillNo" autocomplete="off">
                                                    </div>
                                                </div>                                               
                                                </div>
                                            </div>
                                        </div>                                        
                                        </div>
                                        <div class="layui-form-item">
                                            <div class="layui-row">
                                                <div class="layui-col-xs3">
@@ -145,9 +146,31 @@
                                                    </div>
                                                </div>
                                                <div class="layui-col-xs3">
                                                    <label class="layui-form-label"> è”系方式：</label>
                                                    <label class="layui-form-label"> è”系方式(收)：</label>
                                                    <div class="layui-input-inline">
                                                        <input class="layui-input" name="HReceiveGoodsLink" id="HReceiveGoodsLink" autocomplete="off">
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="layui-form-item">
                                            <div class="layui-row">
                                                <div class="layui-col-xs3">
                                                    <label class="layui-form-label"> é€è´§äººï¼š</label>
                                                    <div class="layui-input-inline">
                                                        <input class="layui-input" name="HSendGoodsMan" id="HSendGoodsMan" autocomplete="off">
                                                    </div>
                                                </div>
                                                <div class="layui-col-xs3">
                                                    <label class="layui-form-label"> é€è´§åœ°å€ï¼š</label>
                                                    <div class="layui-input-inline">
                                                        <input class="layui-input" name="HSendGoodsAddr" id="HSendGoodsAddr" autocomplete="off">
                                                    </div>
                                                </div>
                                                <div class="layui-col-xs3">
                                                    <label class="layui-form-label"> è”系方式(送)：</label>
                                                    <div class="layui-input-inline">
                                                        <input class="layui-input" name="HSendGoodsLink" id="HSendGoodsLink" autocomplete="off">
                                                    </div>
                                                </div>
                                            </div>
@@ -222,6 +245,7 @@
    <script src="../../layuiadmin/Scripts/jquery-1.4.1.js" type="text/javascript"></script>
    <!--<script src="../../../../Scripts/jquery-1.8.2.js"></script>-->
    <script src="../../../../Scripts/webConfig.js"></script>
    <script src="../../layuiadmin/Scripts/general.js"></script>
    <script>
        function getUrlVars() {
            var vars = [], hash;
@@ -274,6 +298,9 @@
                $("#HManagerName").val(d.data[0].HManagerName);
                $("#HPURCHASEORGID").val(d.data[0].FPURCHASEORGID);
                $("#HPURCHASEORGName").val(d.data[0].HOrgName);
                $("#HReceiveGoodsMan").val(d.data[0].HReceiveGoodsMan);
                $("#HAddress").val(d.data[0].HAddress);
                //$("#HSendGoodsAddr").val(d.data[0].HPROVIDERADDRESS);
            }
        });

@@ -289,6 +316,7 @@
                , layer = layui.layer
                , laydate = layui.laydate
                , element = layui.element; //Tab的切换功能，切换事件监听等，需要依赖element模块
            window.table = layui.table
            //常规用法
            laydate.render({
                elem: '#HDHDate'
@@ -296,7 +324,10 @@
            RoadHBillSub();
            layer.load(3)

            var HIsAduit = false;

            var HModName = "SRM_POInStockBill_Edit";
            window.HSubData = "";//全局变量
            var option = {
                elem: '#mainTable'
                , toolbar: '#toolbarDemo'
@@ -314,26 +345,27 @@
                    , { field: 'HUnitNumber', title: '计量单位代码', width: 100, hide: true }
                    , { field: 'HUnitID', title: '计量单位ID', width: 100, hide: true }
                    , { field: 'FPrintCount', title: '打印条码数量', width: 120, hide: true }
                    , { 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: '生产日期D/C', width: 120, edit: 'text' }
                    , { field: 'HKFDate', title: '生产日期', align: 'center', width: 150, data_field: 'HKFDate', event: "chooseHKFDate", hide: true }
                    , { field: 'HBatchNo', title: '批号', width: 120, edit: 'text' }
                    , { field: 'HKFDate', title: '生产日期', align: 'center', width: 150, data_field: 'HKFDate', event: "chooseHKFDate" }
                    , { field: 'HKFPeriod', title: '保质期', width: 100, hide: true }
                    , { field: 'HDate', title: '预计到货日期', align: 'center', width: 150, data_field: 'HDate', event: "chooseHDate", hide: true }
                    , { field: 'HPrice', title: '单价', width: 100, hide: true }
                    , { field: 'HMoney', title: '金额', width: 100, hide: true }
                    , { field: 'HRemark', title: '备注', width: 200, edit: true }
                    , { field: 'HTAXPRICE_T', title: '含税重量单价/吨', width: 200, edit: true, hide: true}                    
                    //, { field: 'HRemark', title: '备注', width: 100 }
                    , { field: 'HPOOrderInterID', title: '采购订单主内码', width: 150, hide: true }
                    , { field: 'HPOOrderEntryID', title: '采购订单子内码', width: 150, hide: true }
                    , { field: 'HPOOrderBillNo', title: '采购订单号', width: 200 }
                    , { field: 'HWWOrderInterID', title: '委外订单主内码', width: 150, hide: true }
                    , { field: 'HWWOrderEntryID', title: '委外订单子内码', width: 150, hide: true }
                    , { field: 'HWWOrderBillNo', title: '委外订单号', width: 200 }
                    , { field: 'HWWOrderBillNo', title: '委外订单号', width: 200, hide: true }
                    , { field: 'HBillType', title: '单据类型', width: 100, hide: true }
                    , { field: 'HSourceBillType', title: '源单类型', width: 100, hide: true }
                    , { field: 'HSourceBillNo', title: '源单单号', width: 200 }
                    , { field: 'HSourceBillNo', title: '源单单号', width: 200, hide: true }
                    , { field: 'HSupMaterNumber', title: '供应商料号', width: 200, edit: 'text' }
                    , { field: 'HSupBatchNo', title: '供应商批次', width: 200, edit: 'text' }
                    , { field: 'HExpressNumberSub', title: '物流单号', width: 200, edit: true, hide: true }//瑞琪,凯贝
@@ -484,7 +516,7 @@
                    //列设置
                    case 'set_HideColumn':
                        get_HideColumn();
                        break; 
                        break;
                };
            });
            //监听行工具事件
@@ -588,9 +620,11 @@
                    success: function (result) {
                        if (result.count == 10000) {
                            for (let i = 0; i < result.data.length; i++) {
                                result.data[i].HBatchNo = result.data[i].HBatchNo.substring(0,6);
                                result.data[i].HBatchNo = result.data[i].HBatchNo.substring(0, 6);
                            }
                            ajaxReturnData = JSON.parse(JSON.stringify(result)).data;
                            HSubData = ajaxReturnData;
                            console.log(ajaxReturnData);
                            table.reload('mainTable', {
                                data: ajaxReturnData
                                , height: 'full-10'
@@ -654,6 +688,7 @@
                        dataType: "json",
                        success: function (data) {
                            if (data.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                                HIsAduit = true;
                                $('#aduit-btn').addClass("layui-btn-disabled").attr("disabled", true);
                                layer.msg(data.Message, { icon: 1 });
                            }
@@ -667,7 +702,11 @@
                        }
                    });
            });
            form.on('submit(Print)', function (data) {//审核
            form.on('submit(Print)', function (data) {//打印
                if (HIsAduit == false) {
                    layer.msg("请审核送货单后在进行打印( Â´â—”︎ â€¸â—”︎`)", { icon: 5 });
                    return;
                }
                $.ajax(
                    {
                        type: "GET",
@@ -701,7 +740,24 @@
                        }
                    });
            });
            form.on('submit(Exit)', function (data) {//保存

            form.on('submit(ChooseSource)', function (data) {
                layer.open({
                    type: 2
                    , area: ['95%', '95%']
                    , title: '采购订单列表'
                    , shade: 0.6 //遮罩透明度
                    , maxmin: false //允许全屏最小化
                    , anim: 0 //0-6的动画形式，-1不开启
                    , content: ['../../views/SRM/SRM_POOrderBillList.html?Type=AddRow', 'yes']
                    , resize: false
                    //, cancel: function () {
                    //    $(".layui-btn").removeClass("layui-btn-disabled");
                    //}
                })
            });

            form.on('submit(Exit)', function (data) {//退出
                var index = parent.layer.getFrameIndex(window.name); //先得到当前iframe层的索引
                parent.layer.close(index); //再执行关闭
            });
@@ -773,9 +829,14 @@
                        //    layer.msg("明细记录第" + (i + 1) + "行,批次为空!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        //    return Result = false;
                        //}
                        if (sSubStr[i].HBatchNo == "") {
                        if (sSubStr[i].HKFDate == "") {
                            //凯贝
                            layer.msg("明细记录第" + (i + 1) + "行,生产日期D/C为空!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            layer.msg("明细记录第" + (i + 1) + "行,生产日期为空!", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            return Result = false;
                        }
                        if (sSubStr[i].HKFDate > Format(new Date(), "yyyy-MM-dd")) {
                            //凯贝
                            layer.msg("明细记录第" + (i + 1) + "行,生产日期大于当前日期，请重新选择！", { icon: 5, btn: ['确认'], time: 2000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                            return Result = false;
                        }
                    }
@@ -907,6 +968,49 @@
            //}

        });

        function GetPoorderValue(obj) {
            var Batchno = Format(new Date(), "yyyy-MM-dd").replaceAll('-', '').substr(2,6);//6位数当前日期
            
            var HSubLen = HSubData.length + 1;
            var a = [];
            for (let i = 0; i < obj.length; i++) {
                var row_options = {
                    //"sorderid": HSubLen, "HPOOrderInterID": obj[i].hmainid, "HPOOrderEntryID": obj[i].hentryid, "HPOOrderBillNo": obj[i].单据号, "HWWOrderInterID": 0,
                    //"HWWOrderEntryID": 0, "HWWOrderDetaiLID": 0., "HWWOrderBillNo": '', "HBillType": "1102", "HBatchNo": obj[i].HBatchNo, "HMaterID": obj[i].hmaterid,
                    //"HMaterNumber": obj[i].物料代码, "HOldMaterNumber": obj[i].旧物料编码, "HMaterShortNumber": obj[i].物料编码, "HMaterName": obj[i].物料名称,
                    //"HMaterModel": obj[i].规格型号, "HUnitID": obj[i].hunitid, "HUnitNumber": obj[i].计量单位代码, "HUnitName": obj[i].计量单位, "HQty": obj[i].可发货数量,
                    //"HRQty": obj[i].可发货数量, "HSQty": obj[i].订单数量, "HPrice": obj[i].单价, "HMoney": obj[i].金额, "HDate": new Date(), "HKFDate": new Date(),
                    //"HKFPeriod": 0, "HSourceInterID": obj[i].hmainid, "HSourceEntryID": obj[i].hentryid, "HSourceBillType": "1102", "HSourceBillNo": obj[i].单据号,
                    //"HMTONO": obj[i].HBatchNo, "F_xbkf_Combo": '', "FSHDD": '', "FPrintCount": obj[i].打印条码数量, "HPlanArrivalDate": new Date()

                    "sorderid": HSubLen, "HPOOrderInterID": obj[i].hmainid, "HPOOrderEntryID": obj[i].hsubid, "HPOOrderBillNo": obj[i].订单单号, "HWWOrderInterID": 0,
                    "HWWOrderEntryID": 0, "HWWOrderDetaiLID": 0., "HWWOrderBillNo": '', "HBillType": "1102", "HBatchNo": Batchno, "HMaterID": obj[i].hmaterid,
                    "HMaterNumber": obj[i].物料代码, "HOldMaterNumber": obj[i].旧物料编码, "HMaterShortNumber": obj[i].物料编码, "HMaterName": obj[i].物料名称,
                    "HMaterModel": obj[i].规格型号, "HUnitID": obj[i].hunitid, "HUnitNumber": obj[i].计量单位代码, "HUnitName": obj[i].采购单位, "HQty": obj[i].未关联数量,
                    "HRQty": obj[i].未关联数量, "HSQty": obj[i].采购数量, "HPrice": obj[i].单价, "HMoney": obj[i].金额, "HDate": Format(new Date(), "yyyy-MM-dd"), "HKFDate": '',
                    "HKFPeriod": 0, "HSourceInterID": obj[i].hmainid, "HSourceEntryID": obj[i].hsubid, "HSourceBillType": "1102", "HSourceBillNo": obj[i].订单单号,
                    "HMTONO": obj[i].HBatchNo, "F_xbkf_Combo": '', "FSHDD": '', "FPrintCount": obj[i].打印条码数量, "HPlanArrivalDate": new Date(),
                    "HTAXPRICE_T": obj[i].含税重量单价吨
                };
                HSubData.push(row_options);
                HSubLen++;

                //var NewRow = {
                //    "HMTONO": "", "HMaterID": 0, "HMaterNumber": "", "HOldMaterNumber": "", "HMaterShortNumber": "", "HMaterName": 0, "HMaterModel": "", "HUnitName": "0", "HUnitNumber": "",
                //    "HUnitID": "0", "FPrintCount": "0", "HRQty": "0", "HSQty": "", "HBatchNo": "", "HKFDate": "", "HKFPeriod": "", "HDate": "", "HPrice": "", "HMoney": "", "HRemark": "", "HPOOrderInterID": "", "HPOOrderEntryID": "", "HPOOrderBillNo": "", "HWWOrderInterID": "", "HWWOrderEntryID": "", "HWWOrderBillNo": "", "HBillType": "", "HSourceBillType": "", "HSourceBillNo": "", "HSupMaterNumber": "", "HSupBatchNo": "", "HExpressNumberSub": "", "HExpressSupplierSub": "", "HPlanArrivalDate": "", "HBoxNumber": "", "HSourceInterID": "", "HSourceEntryID": ""
                //};
            };
            table.reload('mainTable', {
                data: HSubData
                , height: 'full-10'
                , loading: false
                , done: function (index, res) {
                    layer.closeAll("loading");
                }
            });
        }

    </script>
</body>
</html>

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

@@ -31,26 +31,26 @@
                                            <span>更多</span>
                                        </div>
                                    </div>
                                  

                                    <div class="layui-inline">
                                        <label class="layui-form-label">单据号</label>
                                        <div class="layui-input-block">
                                        <label class="layui-form-label">订单单号</label>
                                        <div class="layui-input-block" style="width:130px;">
                                            <input type="text" class="layui-input" name="HBillNo" id="HBillNo">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料编码</label>
                                        <div class="layui-input-block">
                                        <div class="layui-input-block" style="width:130px;">
                                            <input type="text" class="layui-input" name="HShortNumber" id="HShortNumber">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                    <div class="layui-inline" style="display:none">
                                        <label class="layui-form-label">旧物料编码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HOldMaterNumber" id="HOldMaterNumber">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                    <div class="layui-inline" style="display:none">
                                        <label class="layui-form-label">物料代码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HNumber" id="HNumber">
@@ -58,11 +58,74 @@
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料名称</label>
                                        <div class="layui-input-block">
                                        <div class="layui-input-block" style="width:130px;">
                                            <input type="text" class="layui-input" name="HName" id="HName">
                                        </div>
                                    </div>

                                    <div class="layui-inline">
                                        <label class="layui-form-label">开始日期</label>
                                        <div class="layui-input-block" style="width:100px;">
                                            <input type="text" class="layui-input" name="HDate1" id="HDate1">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">结束日期</label>
                                        <div class="layui-input-block" style="width:100px;">
                                            <input type="text" class="layui-input" name="HDate2" id="HDate2">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">状态</label>
                                        <div class="layui-input-block" style="width:120px">
                                            <select name="HStatus" id="HStatus" lay-filter="">
                                                <option value="" selected="">全部</option>
                                                <option value="未确认">未确认</option>
                                                <option value="已确认">已确认</option>
                                                <option value="已驳回">已驳回</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">关闭状态</label>
                                        <div class="layui-input-block" style="width:120px">
                                            <select id="HClStatus" name="HClStatus" lay-filter="">
                                                <option value="" selected>全部</option>
                                                <option value="未关闭">未关闭</option>
                                                <option value="已关闭">已关闭</option>
                                            </select>
                                        </div>
                                    </div>
                                    <!--瑞琪,凯贝-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label">业务状态</label>
                                        <div class="layui-input-block" style="width:120px">
                                            <select id="HIsClose" name="HIsClose" lay-filter="">
                                                <option value="全部" selected>全部</option>
                                                <option value="正常">正常</option>
                                                <option value="业务关闭">业务关闭</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">冻结状态</label>
                                        <div class="layui-input-block" style="width:120px">
                                            <select id="HIsFreeze" name="HIsFreeze" lay-filter="">
                                                <option value="全部" selected>全部</option>
                                                <option value="正常">正常</option>
                                                <option value="业务冻结">业务冻结</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">完成状态</label>
                                        <div class="layui-input-block" style="width:120px">
                                            <select name="HFinishStatus" id="HFinishStatus" lay-filter="">
                                                <option value="">全部</option>
                                                <option value="未完成" selected="">未完成</option>
                                                <option value="已完成">已完成</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
@@ -73,28 +136,6 @@
                                            <label class="layui-form-label">规格型号</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HModel" id="HModel">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">关闭状态</label>
                                            <div class="layui-input-block">
                                                <select id="HClStatus" name="HClStatus" lay-filter="">
                                                    <option value="" selected>全部</option>
                                                    <option value="未关闭">未关闭</option>
                                                    <option value="已关闭">已关闭</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">开始日期</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HDate1" 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="HDate2" id="HDate2">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
@@ -130,38 +171,6 @@
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">订单状态</label>
                                            <div class="layui-input-block">
                                                <select name="HStatus" id="HStatus" lay-filter="">
                                                    <option value="" selected="">全部</option>
                                                    <option value="未确认">未确认</option>
                                                    <option value="已确认">已确认</option>
                                                    <option value="已驳回">已驳回</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">完成状态</label>
                                            <div class="layui-input-block">
                                                <select name="HFinishStatus" id="HFinishStatus" lay-filter="">
                                                    <option value="">全部</option>
                                                    <option value="未完成" selected="">未完成</option>
                                                    <option value="已完成">已完成</option>
                                                </select>
                                            </div>
                                        </div>
                                        <!--瑞琪-->
                                        <div class="layui-inline">
                                            <label class="layui-form-label">业务关闭</label>
                                            <div class="layui-input-block">
                                                <select id="HIsClose" name="HIsClose" lay-filter="">
                                                    <option value="全部" selected>全部</option>
                                                    <option value="是">是</option>
                                                    <option value="否">否</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
@@ -171,17 +180,21 @@
                    <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                            <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
                                <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                            </button>
                            <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
                            <button type="button" class="layui-btn layui-btn-sm" id="btn_reload" lay-submit="" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>驳回</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-report" id="btn_report"><i class="layui-icon layui-icon-close-fill"></i>汇报</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-barcode"><i class="layui-icon layui-icon-file"></i>生成条码</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>导出</button>
                            <button type="button" class="layui-btn layui-btn-sm" id="btn_details" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button>
                            <button type="button" class="layui-btn layui-btn-sm" id="btn_barcode" lay-event="btn-barcode"><i class="layui-icon layui-icon-file"></i>生成条码</button>
                            <button type="button" class="layui-btn layui-btn-sm" id="btn_generate" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button>
                            <button type="button" class="layui-btn layui-btn-sm" id="btn_backData" lay-event="btn_backData"><i class="layui-icon layui-icon-add-1"></i>返回数据</button>
                            <button type="button" class="layui-btn layui-btn-sm" id="btn_exit" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                            <button type="button" class="layui-btn layui-btn-sm" id="btn_HideColumn" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                            <button type="button" class="layui-btn layui-btn-sm" id="set_dao" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>导出</button>
                        </div>
                    </script>
                </div>
@@ -189,6 +202,8 @@
        </div>
    </div>
    <script src="../../layuiadmin/layui/layui.js" charset="utf-8"></script>
    <script src="../../layuiadmin/Scripts/json2.js" type="text/javascript"></script>
    <script src="../../layuiadmin/Scripts/jquery-1.4.1.js" type="text/javascript"></script>
    <script src="../../../../Scripts/webConfig.js"></script>
    <script>
        var _cur_page = 1;
@@ -210,22 +225,7 @@
        }
        var params = getUrlVars();
        var type = params[params[0]];
        switch (type) {
            case "UnConfirm":
                options[1].selected = true;
                sql += " and çŠ¶æ€ like ^^%未确认%^^";
                //$("#HStatus").attr("disabled", true)
                break;
            case "ReConfirm":
                options[2].selected = true;
                sql += " and çŠ¶æ€ like ^^%已确认%^^";
                sql += " and æœªå…³è”数量 > 0";
                break;
            case "ReBack":
                options[3].selected = true;
                sql += " and çŠ¶æ€ like ^^%已驳回%^^";
                break;
        }

        layui.config({
            base: '../../layuiadmin/' //静态资源所在路径
        }).extend({
@@ -246,11 +246,46 @@
            laydate.render({
                elem: '#HDate2'
            });

            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["HItemID", "HParentID"];
            var titleData = ["HItemID", "HParentID", "单据号", "日期", "数量", "状态", "单位", "金额"];
            var option = [];
            var HModName = "SRM_POOrderBillList";
            var sqlWhere = "";
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            switch (type) {
                case "UnConfirm":
                    options[1].selected = true;
                    sql += " and çŠ¶æ€ like ^^%未确认%^^";
                    //$("#HStatus").attr("disabled", true)
                    break;
                case "ReConfirm":
                    options[2].selected = true;
                    sql += " and çŠ¶æ€ like ^^%已确认%^^";
                    sql += " and æœªå…³è”数量 > 0";
                    break;
                case "ReBack":
                    options[3].selected = true;
                    sql += " and çŠ¶æ€ like ^^%已驳回%^^";
                    break;
                //case "AddRow":
                //    $("#HStatus").attr("disabled", "disabled");
                //    $("#HStatus").val('已确认');
                //    $("#HFinishStatus").attr("disabled", "disabled");
                //    form.render('select');
                //    sqlWhere += " and çŠ¶æ€ like ^^%已确认%^^";
                //    sqlWhere += " and å®ŒæˆçŠ¶æ€ like ^^%" + $("#HFinishStatus").val() + "%^^";
                //    $('#btn_reload').addClass("layui-btn-disabled").attr("visibility", "hidden");
                //    $('#btn_confirm').addClass("layui-btn-disabled").attr("disabled", true);
                //    $('#btn_back').addClass("layui-btn-disabled").attr("disabled", true);
                //    $('#btn_report').addClass("layui-btn-disabled").attr("disabled", true);
                //    $('#btn_details').addClass("layui-btn-disabled").attr("disabled", true);
                //    $('#btn_barcode').addClass("layui-btn-disabled").attr("disabled", true);
                //    $('#btn_generate').addClass("layui-btn-disabled").attr("disabled", true);
                //    $('#set_dao').addClass("layui-btn-disabled").attr("disabled", true);
                //    break;
            }
          
            set_ClearBill();
            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
            function set_ClearBill() {
@@ -373,7 +408,7 @@
                                //隐藏id
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    if (option.cols[0][i + 1]["field"] == '回复交期') {
                                    if (option.cols[0][i + 1]["field"] == '供应商交期回复') {
                                        option.cols[0][i + 1]["width"] = 120;
                                    } else {
                                        option.cols[0][i + 1]["width"] = dataCols[3];
@@ -468,7 +503,7 @@
                                    default:
                                        if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
                                        } else if (data[i].name == '回复交期') {
                                        } else if (data[i].name == '供应商交期回复') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' });
                                        } else {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
@@ -532,10 +567,10 @@
                if ($("#HPURCHASEORGID").val() != "" && $("#HPURCHASEORGID option:selected").text() != "安瑞集团")
                    sqlWhere += " and HPURCHASEORGID = ^^" + $("#HPURCHASEORGID").val() + "^^";
                if ($("#HDate1").val() != "") {
                    sqlWhere += " and æ—¥æœŸ >= ^^" + $("#HDate1").val() + "^^";
                    sqlWhere += " and é‡‡è´­æ—¥æœŸ >= ^^" + $("#HDate1").val() + "^^";
                }
                if ($("#HDate2").val() != "") {
                    sqlWhere += " and æ—¥æœŸ <= ^^" + $("#HDate2").val() + "^^";
                    sqlWhere += " and é‡‡è´­æ—¥æœŸ <= ^^" + $("#HDate2").val() + "^^";
                }
                if ($("#HISGenerate").val() != "") {
                    if ($("#HISGenerate").val() == "是") {
@@ -547,11 +582,19 @@
                }
                /*瑞琪*/
                if ($("#HIsClose").val() != "") {
                    if ($("#HIsClose").val() == "是") {
                        sqlWhere += " and ä¸šåŠ¡å…³é—­ = ^^已关闭^^";
                    if ($("#HIsClose").val() == "正常") {
                        sqlWhere += " and ä¸šåŠ¡å…³é—­ = ^^正常^^";
                    }
                    else if ($("#HIsClose").val() == "否") {
                        sqlWhere += " and ä¸šåŠ¡å…³é—­ = ^^未关闭^^";
                    else if ($("#HIsClose").val() == "业务关闭") {
                        sqlWhere += " and ä¸šåŠ¡å…³é—­ = ^^业务关闭^^";
                    }
                }
                if ($("#HIsFreeze").val() != "") {
                    if ($("#HIsFreeze").val() == "正常") {
                        sqlWhere += " and ä¸šåŠ¡å†»ç»“ = ^^正常^^";
                    }
                    else if ($("#HIsFreeze").val() == "业务冻结") {
                        sqlWhere += " and ä¸šåŠ¡å†»ç»“ = ^^业务冻结^^";
                    }
                }
                var Time = $("#Time").val();
@@ -598,11 +641,11 @@
                    layer.prompt({
                        formType: 2
                        , area: ['400px', '50px'] //自定义文本域宽高
                        , title: '修改订单号为 ã€ ' +  data.单据号 + ' ã€‘ ï¼Œç‰©æ–™ä»£ç ä¸º ã€ ' + data.物料代码 + ' ã€‘ çš„回复交期'
                        , value: data.回复交期
                        , title: '修改订单号为 ã€ ' + data.单据号 + ' ã€‘ ï¼Œç‰©æ–™ä»£ç ä¸º ã€ ' + data.物料代码 + ' ã€‘ çš„供应商交期回复'
                        , value: data.供应商交期回复
                    }, function (value, index) {
                        layer.close(index);
                        //更新回复交期
                        //更新供应商交期回复
                        $.ajax({
                            type: "GET",
                            url: GetWEBURL() + "Cg_Poorder/UpdateSupSendGoodsDateRemark",
@@ -612,7 +655,7 @@
                                if (result.code == 1) {
                                    //同步更新表格和缓存对应的值
                                    obj.update({
                                        å›žå¤äº¤æœŸ: value
                                        ä¾›åº”商交期回复: value
                                    });
                                } else {
                                    layer.alert(result.Message, { icon: 5 });
@@ -621,7 +664,7 @@
                            error: function (result) {
                                layer.alert(result.Message, { icon: 5 });
                            }
                        });                       
                        });
                    });
                }
            });
@@ -948,9 +991,35 @@
                            sheet1: data
                        }, '采购订单列表.xlsx', 'xlsx');
                        break;
                    case 'btn_backData':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        parent.GetPoorderValue(data);
                        var index = parent.layer.getFrameIndex(window.name);
                        parent.layer.close(index);
                        break;
                };
            });

            //行监听事件
            table.on('row(mainTable)', function (obj) {
                var flag = !obj.tr.find(':checkbox:first').prop('checked');
                obj.tr.find(':checkbox').prop('checked', flag);
                if (flag) {
                    obj.tr.find('.layui-form-checkbox').addClass('layui-form-checked');  //设置复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:#ceedfa;color:black" });//改变当前tr背景颜色和字体颜色
                } else {
                    obj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    $(obj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }
                //mainTable ä¸ºè¡¨æ ¼ID   æ³¨æ„æ­¤å¤„如果ID不正确将导致你在监听复选框时获取不到你选择的数据，前面的只是添加或删除选中未选中样式以及设置背景色，字体颜色
                layui.each(table.cache.mainTable, function (i, l) {
                    if (obj.tr.index() == l.LAY_TABLE_INDEX) {
                        l.LAY_CHECKED = flag;
                    }
                });
            });

        });
    </script>
</body>

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

@@ -142,12 +142,12 @@
        //初始化表格  å¯¼å…¥ä¿¡æ¯
        function set_InitGrid1() {
            var columns = [];
            columns.push({ type: 'checkbox', fixed: 'left' });
            columns.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
            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, totalRow: true});
            columns.push({ field: '包装标识', title: '包装标识', width: 150 });
            columns.push({ field: '到货日期', title: '到货日期', width: 150 });
            columns.push({ field: '物流单号', title: '物流单号', width: 150 });
@@ -160,6 +160,7 @@
                , toolbar: '#toolbarDemo'
                , height: 'full-190'
                , page: true
                , totalRow: true
                , cellMinWidth: 90
                , limit: 50
                , limits: [50, 500, 5000, 20000]

 WebSRM/layuiAdmin.std-v1.2.1/src/views/SRM/SRM_POOrderBillList±¸·Ý.html

New file
@@ -0,0 +1,967 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>采购订单列表</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
    <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
    <!--<link rel="stylesheet" href="../../layuiadmin/layui/css/layui-blue.css" media="all">-->
    <link rel="stylesheet" href="../../layuiadmin/layui/css/style-self.css" media="all">
    <style type="text/css">
        .layui-input-block {
            width: 190px;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-row layui-col-space15">
            <div class="layui-col-md12">
                <div class="layui-card" style="padding: 1px">
                    <div class="layui-card-body" style="padding: 1px;">
                        <!--<div class="test-table-reload-btn" style="margin-bottom: 10px;">-->
                        <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="text" class="layui-input" name="HBillNo" id="HBillNo">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料编码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HShortNumber" id="HShortNumber">
                                        </div>
                                    </div>
                                    <div class="layui-inline" style="display:none">
                                        <label class="layui-form-label">旧物料编码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HOldMaterNumber" id="HOldMaterNumber">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料代码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HNumber" id="HNumber">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料名称</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HName" id="HName">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">规格型号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HModel" id="HModel">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">供应商</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HSupplier" id="HSupplier">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                        </button>
                                    </div>
                                    <div class="layui-colla-content" style="padding-left:82px">

                                        <div class="layui-inline">
                                            <label class="layui-form-label">关闭状态</label>
                                            <div class="layui-input-block">
                                                <select id="HClStatus" name="HClStatus" lay-filter="">
                                                    <option value="" selected>全部</option>
                                                    <option value="未关闭">未关闭</option>
                                                    <option value="已关闭">已关闭</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">开始日期</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HDate1" 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="HDate2" id="HDate2">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">交货时间</label>
                                            <div class="layui-input-block">
                                                <select id="Time" name="Time" lay-filter="">
                                                    <option value="0" selected>全部</option>
                                                    <option value="1">一周内交货</option>
                                                    <option value="2">二周内交货</option>
                                                    <option value="3">一月内交货</option>
                                                    <option value="4">两月内交货</option>
                                                    <option value="5">三月内交货</option>
                                                    <option value="6">半年内交货</option>
                                                    <option value="7">一年内交货</option>
                                                    <option value="8">长期交货</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">采购组织</label>
                                            <div class="layui-input-block">
                                                <select id="HPURCHASEORGID" name="HPURCHASEORGID" lay-filter="">
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">是否已下推</label>
                                            <div class="layui-input-block">
                                                <select id="HISGenerate" name="HISGenerate" lay-filter="">
                                                    <option value="全部" selected>全部</option>
                                                    <option value="是">是</option>
                                                    <option value="否">否</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">订单状态</label>
                                            <div class="layui-input-block">
                                                <select name="HStatus" id="HStatus" lay-filter="">
                                                    <option value="" selected="">全部</option>
                                                    <option value="未确认">未确认</option>
                                                    <option value="已确认">已确认</option>
                                                    <option value="已驳回">已驳回</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">完成状态</label>
                                            <div class="layui-input-block">
                                                <select name="HFinishStatus" id="HFinishStatus" lay-filter="">
                                                    <option value="">全部</option>
                                                    <option value="未完成" selected="">未完成</option>
                                                    <option value="已完成">已完成</option>
                                                </select>
                                            </div>
                                        </div>
                                        <!--瑞琪-->
                                        <div class="layui-inline">
                                            <label class="layui-form-label">业务关闭</label>
                                            <div class="layui-input-block">
                                                <select id="HIsClose" name="HIsClose" lay-filter="">
                                                    <option value="全部" selected>全部</option>
                                                    <option value="是">是</option>
                                                    <option value="否">否</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </form>
                        <!--</div>-->
                    </div>
                    <table class="layui-hide" 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="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>驳回</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-report" id="btn_report"><i class="layui-icon layui-icon-close-fill"></i>汇报</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详情</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-barcode"><i class="layui-icon layui-icon-file"></i>生成条码</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>生成送货单</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="set_dao"><i class="layui-icon layui-icon-form"></i>导出</button>
                        </div>
                    </script>
                </div>
            </div>
        </div>
    </div>
    <script src="../../layuiadmin/layui/layui.js" charset="utf-8"></script>
    <script src="../../../../Scripts/webConfig.js"></script>
    <script>
        var _cur_page = 1;
        var sql = "";
        var options = document.getElementById('HStatus').children;
        function getUrlVars() {
            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;
        }

        function f_alert(sMsg) {
            layer.alert(sMsg, { icon: 5 });
        }
        var params = getUrlVars();
        var type = params[params[0]];
        switch (type) {
            case "UnConfirm":
                options[1].selected = true;
                sql += " and çŠ¶æ€ like ^^%未确认%^^";
                //$("#HStatus").attr("disabled", true)
                break;
            case "ReConfirm":
                options[2].selected = true;
                sql += " and çŠ¶æ€ like ^^%已确认%^^";
                sql += " and æœªå…³è”数量 > 0";
                break;
            case "ReBack":
                options[3].selected = true;
                sql += " and çŠ¶æ€ like ^^%已驳回%^^";
                break;
        }
        layui.config({
            base: '../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer','excel'], function () {
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , laydate = layui.laydate
                , table = layui.table
                , form = layui.form
                , element = layui.element
                , excel = layui.excel;
            //常规用法
            laydate.render({
                elem: '#HDate1'
            });
            laydate.render({
                elem: '#HDate2'
            });
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["HItemID", "HParentID"];
            var option = [];
            var HModName = "SRM_POOrderBillList";
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            set_ClearBill();
            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
            function set_ClearBill() {
                //渲染采购组织
                var Organization = '<option value=' + sessionStorage["OrganizationID"] + ' style="color:red;">' + sessionStorage["Organization"] + '</option>';
                $("#HPURCHASEORGID").append(Organization);
                form.render('select');
                //初始化表格
                //set_InitGrid();
                //显示列数据
                //DisPlay_HideColumn();
                //直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
                get_FastQuery(table, option)
            }
            function set_InitGrid() {
                //$("#HBeginDate").val("2022-03-14");
                //$("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));
                var columns = [
                    { type: 'checkbox', fixed: 'left', totalRowText: '合计' }
                    //{ type: 'radio', fixed: true }
                    , { field: 'sorderid', title: '序号', width: 80/*, fixed: true */ }
                    , { field: 'hmainid', title: 'hmainid', sort: true, /*fixed: true,*/ hide: true }
                    , { field: 'hsubid', title: 'hsubid', sort: true, /*fixed: true,*/ hide: true }
                    , { field: '状态', title: '状态', sort: true/*, fixed: true */ }
                    , { field: '反馈状态', title: '反馈状态', width: 100/*, fixed: true */}
                    //, { field: '优先级', title: '优先级', width: 100/*, fixed: true */}
                    , { field: '单据号', title: '单据号', width: 150, sort: true/*, fixed: 'left' */ }
                    , { field: '计划跟踪单号', title: '计划跟踪单号', sort: true, hide: true }
                    , { field: '自定义标识', title: '自定义标识', width: 120 }
                    , { field: '送货地点', title: '送货地点', width: 120 }
                    , { field: '包装标识', title: '包装标识', width: 120 }
                    , { field: '唯一ID', title: '唯一ID', width: 120 }
                    //, { field: '物料编码', title: '物料编码', width: 120, sort: true }
                    , { field: '物料代码', title: '物料编码', width: 120, sort: true }
                    , { field: '物料名称', title: '物料名称', width: 120, sort: true }
                    , { field: '计量单位', title: '计量单位', width: 80, sort: true }
                    , { field: '数量', title: '订单数量', sort: true }
                    , { field: '打印条码数量', title: '打印条码数量', sort: true }
                    , { field: '已发货数量', title: '已发货数量', sort: true, totalRow: true }
                    , { field: '可发货数量', title: '可发货数量', sort: true, totalRow: true}
                    , { field: '交货地点', title: '交货地点', sort: true }
                    , { field: '交货日期', title: '交货日期', width: 180, sort: true }
                    , { field: '日期', title: '日期', width: 120, sort: true/*, fixed: 'left' */ }
                    , { field: 'HSupID', title: 'HSupID', width: 180, hide: true }
                    , { field: '供应商', title: '供应商', width: 180, sort: true/*, fixed: 'left' */ }
                    , { field: '规格型号', title: '规格型号', width: 120, sort: true }
                    , { field: '剩余入库数量', title: '剩余入库数量', sort: true }
                    , { field: '剩余收料数量', title: '剩余收料数量', sort: true }
                    , { field: '关闭状态', title: '关闭状态', sort: true }
                    , { field: '变更状态', title: '变更状态', sort: true }
                    , { field: '采购组织', title: '采购组织', sort: true }
                    , { field: '确认人', title: '确认人', sort: true, hide: true }
                    , { field: '确认日期', title: '确认日期', sort: true, hide: true }
                    , { field: '驳回人', title: '驳回人', sort: true, hide: true }
                    , { field: '驳回日期', title: '驳回日期', sort: true, hide: true }
                    , { field: '驳回理由', title: '驳回理由', sort: true, hide: true }

                ];
                option = {
                    elem: '#mainTable'
                    , toolbar: '#toolbarDemo'
                    , page: true
                    //, cellMinWidth: 120
                    , totalRow: true
                    , limit: 500
                    , height: 'full-50'
                    //, cols: [columns]
                    , limits: [500, 5000, 20000]
                    , done: function (res, curr, count) {

                    }
                };
            }
            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }

                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//数据库查询出的列数据
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < dataCol.length; i++) {
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;
                                }
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                    option.cols[0][i + 1]["hide"] = false;
                                }
                                //隐藏id
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    if (option.cols[0][i + 1]["field"] == '回复交期') {
                                        option.cols[0][i + 1]["width"] = 120;
                                    } else {
                                        option.cols[0][i + 1]["width"] = dataCols[3];
                                    }
                                }
                                //设置内容字体大小
                                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"] = "";
                                //}

                                //字体所在位置(å·¦ å±…中 å³)
                                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 get_Display(sqlWhere) {
                var wait = layer.load();//遮罩
                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "GetPOOrderBill",
                    async: true,
                    data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
                    success: function (data1) {
                        if (data1.Message == "获取成功") {
                        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', totalRowText: '合计' });
                        for (var i = 0; i < data.length; i++) {
                            // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                            if ($.inArray(data[i].name, titleData) > -1) {
                                col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                            }
                            else if (data[i].name.indexOf('id') > -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:
                                        if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
                                        } else if (data[i].name == '回复交期') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' });
                                        } else {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                        }
                                }
                            }
                        }
                        //动态显示列名
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            , cols: [col]
                            , data: data1.data
                            , height: 'full-80'
                            ,totalRow: true
                            , page: true
                            , cellMinWidth: 90
                            , limit: 500
                            , limits: [50, 500, 5000, 20000]
                        }
                        table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();
                            layer.close(wait);
                        } else {
                            layer.close(wait);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    },
                    error: function (result) {
                        layer.close(wait);
                        layer.alert(result.Message, { icon: 5 });
                    }
                });
            };
            //查询按钮
            form.on('submit(btnSearch)', function (data) {//查询
                get_FastQuery(table, option);
            });
            //查询条件
            function get_FastQuery(table, option) {
                var sqlWhere = "";
                if ($("#HFinishStatus").val() != "")
                    sqlWhere += " and å®ŒæˆçŠ¶æ€ like ^^%" + $("#HFinishStatus").val() + "%^^";
                if ($("#HStatus").val() != "")
                    sqlWhere += " and çŠ¶æ€ like ^^%" + $("#HStatus").val() + "%^^";
                if ($("#HBillNo").val() != "")
                    sqlWhere += " and å•æ®å· like ^^%" + $("#HBillNo").val() + "%^^";
                if ($("#HShortNumber").val() != "")
                    sqlWhere += " and ç‰©æ–™ç¼–码 like ^^%" + $("#HShortNumber").val() + "%^^";
                if ($("#HOldMaterNumber").val() != "")
                    sqlWhere += " and æ—§ç‰©æ–™ç¼–码 like ^^%" + $("#HOldMaterNumber").val() + "%^^";
                if ($("#HNumber").val() != "")
                    sqlWhere += " and ç‰©æ–™ä»£ç  like ^^%" + $("#HNumber").val() + "%^^";
                if ($("#HName").val() != "")
                    sqlWhere += " and ç‰©æ–™åç§° like ^^%" + $("#HName").val() + "%^^";
                if ($("#HModel").val() != "")
                    sqlWhere += " and è§„格型号 like ^^%" + $("#HModel").val() + "%^^";
                if ($("#HClStatus").val() != "")
                    sqlWhere += " and å…³é—­çŠ¶æ€ like ^^%" + $("#HClStatus").val() + "%^^";
                if ($("#HPURCHASEORGID").val() != "" && $("#HPURCHASEORGID option:selected").text() != "安瑞集团")
                    sqlWhere += " and HPURCHASEORGID = ^^" + $("#HPURCHASEORGID").val() + "^^";
                if ($("#HDate1").val() != "") {
                    sqlWhere += " and æ—¥æœŸ >= ^^" + $("#HDate1").val() + "^^";
                }
                if ($("#HDate2").val() != "") {
                    sqlWhere += " and æ—¥æœŸ <= ^^" + $("#HDate2").val() + "^^";
                }
                if ($("#HISGenerate").val() != "") {
                    if ($("#HISGenerate").val() == "是") {
                        sqlWhere += " and æœªå…³è”数量 <= 0";
                    }
                    else if ($("#HISGenerate").val() == "否") {
                        sqlWhere += " and æœªå…³è”数量 > 0";
                    }
                }
                /*瑞琪*/
                if ($("#HIsClose").val() != "") {
                    if ($("#HIsClose").val() == "是") {
                        sqlWhere += " and ä¸šåŠ¡å…³é—­ = ^^已关闭^^";
                    }
                    else if ($("#HIsClose").val() == "否") {
                        sqlWhere += " and ä¸šåŠ¡å…³é—­ = ^^未关闭^^";
                    }
                }
                if ($("#HSupplier").val() != "")
                    sqlWhere += " and ä¾›åº”商 like ^^%" + $("#HSupplier").val() + "%^^";
                
                var Time = $("#Time").val();
                if (Time > 0) {
                    var dd = new Date();
                    var dt;
                    switch (Time) {
                        case 1: dd = new Date(dd.setDate(dd.getDate() + 7));
                        case 2: dd = new Date(dd.setDate(dd.getDate() + 14));
                        case 3: dd = new Date(dd.setMonth(dd.getMonth() + 1));
                        case 4: dd = new Date(dd.setMonth(dd.getMonth() + 2));
                        case 5: dd = new Date(dd.setMonth(dd.getMonth() + 3));
                        case 6: dd = new Date(dd.setMonth(dd.getMonth() + 6));
                        case 7: dd = new Date(dd.setMonth(dd.getMonth() + 12));
                        default: dd = new Date(dd.setDate(dd.getDate()));
                    }
                    dt = dd.getFullYear().toString();
                    if (dd.getMonth() + 1 < 10) {
                        dt = dt + "-0" + (dd.getMonth() + 1).toString();
                    }
                    else {
                        dt = dt + "-0" + (dd.getMonth() + 1).toString();
                    }
                    if (dd.getDate() < 10) {
                        dt = dt + "-0" + dd.getDate().toString();
                    }
                    else {
                        dt = dt + "-" + dd.getDate().toString();
                    }
                    if (Time != 8) {
                        sqlWhere += " and äº¤è´§æ—¥æœŸ <= ^^" + dt + "^^";
                    }
                }
                sql = sqlWhere;
                //从第一页开始
                _cur_page = 1;
                get_Display(sqlWhere);
            }

            //监听单元格事件
            table.on('tool(mainTable)', function (obj) {
                var data = obj.data;
                if (obj.event === 'HSupSendGoodsDateRemark') {
                    layer.prompt({
                        formType: 2
                        , area: ['400px', '50px'] //自定义文本域宽高
                        , title: '修改订单号为 ã€ ' +  data.单据号 + ' ã€‘ ï¼Œç‰©æ–™ä»£ç ä¸º ã€ ' + data.物料代码 + ' ã€‘ çš„回复交期'
                        , value: data.回复交期
                    }, function (value, index) {
                        layer.close(index);
                        //更新回复交期
                        $.ajax({
                            type: "GET",
                            url: GetWEBURL() + "Cg_Poorder/UpdateSupSendGoodsDateRemark",
                            async: false,
                            data: { "HInterID": data.hmainid, "HEntryID": data.hsubid, "HSupSendGoodsDateRemark": value},
                            success: function (result) {
                                if (result.code == 1) {
                                    //同步更新表格和缓存对应的值
                                    obj.update({
                                        å›žå¤äº¤æœŸ: value
                                    });
                                } else {
                                    layer.alert(result.Message, { icon: 5 });
                                }
                            },
                            error: function (result) {
                                layer.alert(result.Message, { icon: 5 });
                            }
                        });                       
                    });
                }
            });

            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                var checkStatus = table.checkStatus(obj.config.id);
                switch (obj.event) {
                    case 'btn-getCheckData':
                        var data = checkStatus.data;
                        layer.alert(JSON.stringify(data));
                        break;
                    case 'btn-reload':
                        _cur_page = $(".layui-laypage-em").next().html();
                        get_Display(sql);
                        break;
                    case 'btn-HideColumn':
                        get_HideColumn();
                        break;
                    case 'btn-confirm':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        _cur_page = $(".layui-laypage-em").next().html();

                        var HInterIDArr = "";
                        var HBillNoArr = "";
                        var HBillInter = "";

                        for (let i = 0; i < data.length; i++) {
                            HInterIDArr += data[i].hmainid.toString() + ",";
                            HBillNoArr += "'" + data[i].单据号.toString() + "'" + ",";
                            HBillInter += data[i].单据号.toString() + "@" + data[i].hmainid.toString() + ",";
                        }

                        HInterIDArr = HInterIDArr.substring(0, HInterIDArr.length - 1)//内码
                        HBillNoArr = HBillNoArr.substring(0, HBillNoArr.length - 1)//单据号
                        HBillInter = HBillInter.substring(0, HBillInter.length - 1)//单据号 + @ + å†…码拼接

                        var oData = JSON.stringify(HInterIDArr) + ";" + JSON.stringify(HBillInter) + ";" + sessionStorage["HUserName"];

                        layer.confirm('是否确认单据?', { icon: 3, title: '提示' }, function (index) {
                            $.ajax({
                                type: "post",
                                url: GetWEBURL() + "POOrderAccept",
                                data: { "oData": oData },
                                success: function (result) {
                                    if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                                        layer.msg(result.Message, { icon: 1 });
                                        get_FastQuery(table, option);
                                    }
                                    else {
                                        // $("#verifycode").click();
                                        layer.msg(result.Message, { icon: 5 });
                                    }
                                    layer.closeAll("loading");
                                }
                            })
                            layer.close(index);
                        });

                        break;
                    case 'btn-back':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        _cur_page = $(".layui-laypage-em").next().html();
                        var HBackRemark;
                        if (data[0]["状态"] == "未确认") {

                            layer.prompt({
                                formType: 2,
                                //value: '',
                                title: '请输入驳回理由',
                                area: ['400px', '200px'] //自定义文本域宽高
                            }, function (value, index, elem) {
                                HBackRemark = value.toString();
                                $.ajax({
                                    type: "get",
                                    url: GetWEBURL() + "POOrderRefuse",
                                    data: { "HInterID": data[0]["hmainid"].toString(), "HBillNo": data[0]["单据号"].toString(), "HUser": sessionStorage["HUserName"], "HBackRemark": HBackRemark },
                                    success: function (result) {
                                        if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                                            layer.msg("拒绝成功！", { icon: 1 });
                                        }
                                        else {
                                            // $("#verifycode").click();
                                            layer.msg(result.Message, { icon: 5 });
                                        }
                                        layer.closeAll("loading");
                                    }
                                })
                                //alert(value); //得到value
                                layer.close(index);
                            });

                        }
                        else {
                            layer.msg("必须是未确认单据才能进行驳回操作！", { icon: 5 });
                        }
                        break;
                    case 'btn-details':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;

                        var linterid = data[0].hmainid.toString();
                        //if (AllowLoadData(sSubStr) != false) {//非空验证
                        layer.open({
                            type: 2
                            , area: ['100%', '100%']
                            , title: '采购订单'
                            , shade: 0.6 //遮罩透明度
                            , maxmin: true //允许全屏最小化
                            , anim: 0 //0-6的动画形式，-1不开启
                            , content: '../../../src/views/SRM/SRM_POOrderBill.html?linterid=' + linterid
                            , resize: false
                            , cancel: function () {
                                //$(".layui-btn").removeClass("layui-btn-disabled");
                            }
                        })
                        break;
                    case 'btn-generate':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        if (data.length == 0) {
                            layer.alert("请选择数据", { icon: 5 });
                            return;
                        }
                        if (data[0].完成状态 == "已完成") {
                            return layer.msg('订单已完成！')
                        }
                        ajaxLabelData = data;
                        //根据选中的采购订单，重新从金蝶云同步采购订单关联数量过来。考虑采购订单删除和关闭状态，同步状态
                        var ids = "";
                        var entryids = "";
                        $.each(data, function (obj) {
                            ids += data[obj].hmainid + ",";
                            entryids += data[obj].hsubid + ",";
                        })
                        ids = ids.substring(0, ids.length - 1);
                        entryids = entryids.substring(0, entryids.length - 1);
                        var hasPrivileage = true;
                        $.ajax({
                            url: GetWEBURL() + 'TestSaverPOInStock',
                            type: 'get',
                            async: false,
                            traditional: true,   //重点
                            data: {
                                "ids": ids,
                                "entryids": entryids //重点
                            },
                            success: function (data) {
                                if (data.code == "0") {
                                    layer.alert(data.Message, { icon: 5 });
                                    get_FastQuery(table, option);
                                    hasPrivileage = false;
                                    table.reload('mainTable', {
                                        height: 'full-10'
                                        , page: {
                                            curr: _cur_page //必须从第 1 é¡µå¼€å§‹
                                        }
                                        , loading: false
                                        , done: function (index, res) {

                                        }
                                    });
                                    return hasPrivileage;
                                }
                            },
                            error: function (e) {
                                layer.alert(e.Message, { icon: 5 });
                            }
                        });
                        if (!hasPrivileage) {
                            return;
                        }
                        var rows = '';
                        var HEntry = '';
                        for (var i = 0; i < data.length; i++) {
                            if (data[i]["状态"] == "已确认") {
                                rows += data[i].hmainid.toString() + ',' + data[i].hsubid.toString() + ';';
                            }
                            else {
                                HEntry += (i + 1) + ',';
                            }
                        }
                        if (HEntry != '') {
                            HEntry = HEntry.substring(0, HEntry.length - 1);
                            layer.msg("第" + HEntry + "行未确认！", { icon: 5 });
                        }
                        else {
                            layer.open({
                                type: 2
                                , area: ['100%', '100%']
                                , title: '送货单'
                                , shade: 0.6 //遮罩透明度
                                , maxmin: false //允许全屏最小化
                                , anim: 0 //0-6的动画形式，-1不开启
                                , content: ['../../views/SRM/SRM_POInStockBill_Edit.html?linterid=' + data[0].hmainid.toString() + '&lentryid=' + rows.toString() + '&lSourceBillType=1102', 'yes']
                                , resize: false
                                ,end: function () {
                                    get_FastQuery(table, option)
                                }
                            })
                        }
                        break;
                    case 'btn-barcode':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        if (data.length == 0) {
                            return layer.msg('请选择数据')
                        }
                        if (data[0].完成状态 == "已完成") {
                            return layer.msg('订单已完成！')
                        }
                        layer.open({
                            type: 2
                            , area: ['100%', '100%']
                            , title: '条码生成'
                            , shade: 0.6 //遮罩透明度
                            , maxmin: false //允许全屏最小化
                            , anim: 0 //0-6的动画形式，-1不开启
                            , content: ['../../views/SRM/SRM_BarCodeBill.html?linterid=' + data[0].hmainid + '&lentryid=' + data[0].hsubid + '&type =SRM_POOrderBillList', 'yes']
                            , resize: false
                            , cancel: function () {
                                $(".layui-btn").removeClass("layui-btn-disabled");
                            }
                        })
                        break;
                    case 'btn-exit':
                        //var index = parent.layer.getFrameIndex(window.name);
                        //element.tabDelete('layadmin-layout-tabs', this);
                        parent.layui.admin.events.closeThisTabs();
                        //parent.layer.close(index);
                        break;
                    case 'btn-report':
                        var checkStatus = table.checkStatus('mainTable')
                            , data = checkStatus.data;
                        _cur_page = $(".layui-laypage-em").next().html();
                        var arr = new Array();
                        var checkStatus = table.checkStatus('mainTable'),
                            data = checkStatus.data;
                        if (checkStatus.data.length == 0) {
                            return layer.msg('请选择数据');
                        }
                        for (var i = 0; i < data.length; i++) {
                            arr.push(data[i].hmainid + '-' + data[i].hsubid);
                        }
                        var OrderBackId = "";
                        layer.open({
                            type: 2,
                            skin: 'layui-layer-rim', //加上边框
                            title: '订单反馈状态',
                            closeBtn: 1,
                            shift: 2,
                            area: ['80%', '80%'],
                            maxmin: true,
                            content: ['../PublicPage/OrderBackInfomation.html', 'yes'],
                            btn: ['确定', '取消']
                            , btn1: function (index, layero) {

                                //按钮【按钮一】的回调
                                var iframeWindow = window['layui-layer-iframe' + index]  //获取弹框页面
                                var checkStatus = iframeWindow.layui.table.checkStatus('mainTable');//获取table的elem:"#test"
                                if (checkStatus.data.length === 0) {
                                    return layer.msg('请选择数据');
                                }
                                OrderBackId = checkStatus.data[0].HItemID.toString();

                                $.ajax({
                                    url: GetWEBURL() + 'POOrderBack',
                                    //url: 'http://localhost:8082/LuBaoAPI/' + 'POOrderBack',
                                    async: false,
                                    type: "GET",
                                    dataType: "json",
                                    data: { "HmainidList": arr.toString(), "OrderBackId": OrderBackId },
                                    success: function (data1) {
                                        if (data1.Message.indexOf("成功") > 0) {
                                            layer.msg("操作成功", { time: 3 * 1000, icon: 1 }, function () {
                                                var index = layer.getFrameIndex(window.name);
                                                //关闭当前frame
                                                layer.close(index);
                                                //修改为功后刷新界面
                                                window.location.reload();
                                            });
                                        } else {
                                            layer.alert(data1.Message, { icon: 5 });
                                        }
                                    }, error: function (e) {
                                        layer.alert(data1.Message, { icon: 5 });
                                    }
                                });
                            }
                            , btn2: function (index, layero) {
                                //按钮【按钮二】的回调
                                //return false å¼€å¯è¯¥ä»£ç å¯ç¦æ­¢ç‚¹å‡»è¯¥æŒ‰é’®å…³é—­
                            },
                            end: function () {
                            },
                            success: function (layero, index) {

                            }
                        });
                        break;
                    case 'set_dao':
                        //获取列表列数据源
                        var ColName = [];
                        for (var i = 1; i < option.cols[0].length; i++) {
                            if (option.cols[0][i]["hide"] != true) {
                                ColName.push(option.cols[0][i]["field"]);
                            }
                        }
                        //绑定数据
                        var data = excel.filterExportData(option.data, ColName)

                        //赋值于表头列名
                        var Title = [];
                        for (var i = 0; i < ColName.length; i++) {
                            Title.push("\"" + ColName[i] + "\":\"" + ColName[i] + "\"");
                        }
                        var TitleName = JSON.parse("{" + Title.toString() + "}");
                        data.unshift(TitleName);

                        //导出 sheet1 å·¥ä½œè¡¨å
                        excel.exportExcel({
                            sheet1: data
                        }, '采购订单列表.xlsx', 'xlsx');
                        break;
                };
            });

        });
    </script>
</body>

</html>

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

New file
@@ -0,0 +1,426 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>采购入库单列表</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
    <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
    <!--<link rel="stylesheet" href="../../layuiadmin/layui/css/layui-blue.css" media="all">-->
    <link rel="stylesheet" href="../../layuiadmin/layui/css/style-self.css" media="all">
    <style type="text/css">
        .layui-input-block {
            width: 190px;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-row layui-col-space15">
            <div class="layui-col-md12">
                <div class="layui-card" style="padding: 1px">
                    <div class="layui-card-body" style="padding: 1px;">
                        <!--<div class="test-table-reload-btn" style="margin-bottom: 10px;">-->
                        <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="text" class="layui-input" name="HBillNo" id="HBillNo">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料编码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HShortNumber" id="HShortNumber">
                                        </div>
                                    </div>                                   
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料名称</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HName" id="HName">
                                        </div>
                                    </div>

                                    <div class="layui-inline">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                        </button>
                                    </div>
                                    <div class="layui-colla-content" style="padding-left:82px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">规格型号</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HModel" id="HModel">
                                            </div>
                                        </div>                                      
                                        <div class="layui-inline">
                                            <label class="layui-form-label">开始日期</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HDate1" 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="HDate2" id="HDate2">
                                            </div>
                                        </div>                                        
                                        <div class="layui-inline">
                                            <label class="layui-form-label">采购组织</label>
                                            <div class="layui-input-block">
                                                <select id="HPURCHASEORGID" name="HPURCHASEORGID" lay-filter="">
                                                </select>
                                            </div>
                                        </div>                                                                              
                                    </div>
                                </div>
                            </div>
                        </form>
                        <!--</div>-->
                    </div>
                    <table class="layui-hide" 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="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                        </div>
                    </script>
                </div>
            </div>
        </div>
    </div>
    <script src="../../layuiadmin/layui/layui.js" charset="utf-8"></script>
    <script src="../../../../Scripts/webConfig.js"></script>
    <script>
        var _cur_page = 1;
        var sql = "";
        function getUrlVars() {
            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;
        }

        function f_alert(sMsg) {
            layer.alert(sMsg, { icon: 5 });
        }
        var params = getUrlVars();
        var type = params[params[0]];
      
        layui.config({
            base: '../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer','excel'], function () {
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , laydate = layui.laydate
                , table = layui.table
                , form = layui.form
                , element = layui.element
                , excel = layui.excel;
            //常规用法
            laydate.render({
                elem: '#HDate1'
            });
            laydate.render({
                elem: '#HDate2'
            });
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["FID","FSupplierID","FMaterialID","FUnitID","FStockID"];
            var option = [];
            var HModName = "SRM_POStockInBillList";
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            set_ClearBill();
            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
            function set_ClearBill() {
                //渲染采购组织
                var Organization = '<option value=' + sessionStorage["OrganizationID"] + ' style="color:red;">' + sessionStorage["Organization"] + '</option>';
                $("#HPURCHASEORGID").append(Organization);
                form.render('select');
                //初始化表格
                //set_InitGrid();
                //显示列数据
                //DisPlay_HideColumn();
                //直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
                get_FastQuery(table, option)
            }
                       
            //加载显示数据
            function get_Display(sqlWhere) {
                var wait = layer.load();//遮罩
                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "GetPOInStockInBillList",
                    async: true,
                    data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
                    success: function (data1) {
                        if (data1.Message == "获取成功") {
                        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', totalRowText: '合计' });
                        for (var i = 0; i < data.length; i++) {
                            // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                            if ($.inArray(data[i].name, titleData) > -1) {
                                col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                            }
                            else if (data[i].name.indexOf('id') > -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:
                                        if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
                                        } else if (data[i].name == '回复交期') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' });
                                        } else {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                        }
                                }
                            }
                        }
                        //动态显示列名
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            , cols: [col]
                            , data: data1.data
                            , height: 'full-80'
                            ,totalRow: true
                            , page: true
                            , cellMinWidth: 90
                            , limit: 500
                            , limits: [50, 500, 5000, 20000]
                        }
                        table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();
                        layer.close(wait);
                        } else {
                            table.render(option);
                            layer.close(wait);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    },
                    error: function (result) {
                        layer.close(wait);
                        layer.alert(result.Message, { icon: 5 });
                    }
                });
            };
            //查询按钮
            form.on('submit(btnSearch)', function (data) {//查询
                get_FastQuery(table, option);
            });
            //查询条件
            function get_FastQuery(table, option) {
                var sqlWhere = "";
               
                if ($("#HBillNo").val() != "")
                    sqlWhere += " and å•æ®å· like ^^%" + $("#HBillNo").val() + "%^^";
                if ($("#HShortNumber").val() != "")
                    sqlWhere += " and ç‰©æ–™ç¼–码 like ^^%" + $("#HShortNumber").val() + "%^^";
                if ($("#HOldMaterNumber").val() != "")
                if ($("#HName").val() != "")
                    sqlWhere += " and ç‰©æ–™åç§° like ^^%" + $("#HName").val() + "%^^";
                if ($("#HModel").val() != "")
                    sqlWhere += " and è§„格型号 like ^^%" + $("#HModel").val() + "%^^";
                
                if ($("#HDate1").val() != "") {
                    sqlWhere += " and å…¥åº“日期 >= ^^" + $("#HDate1").val() + "^^";
                }
                if ($("#HDate2").val() != "") {
                    sqlWhere += " and å…¥åº“日期 <= ^^" + $("#HDate2").val() + "^^";
                }
                    
                var Time = $("#Time").val();
                if (Time > 0) {
                    var dd = new Date();
                    var dt;
                    switch (Time) {
                        case 1: dd = new Date(dd.setDate(dd.getDate() + 7));
                        case 2: dd = new Date(dd.setDate(dd.getDate() + 14));
                        case 3: dd = new Date(dd.setMonth(dd.getMonth() + 1));
                        case 4: dd = new Date(dd.setMonth(dd.getMonth() + 2));
                        case 5: dd = new Date(dd.setMonth(dd.getMonth() + 3));
                        case 6: dd = new Date(dd.setMonth(dd.getMonth() + 6));
                        case 7: dd = new Date(dd.setMonth(dd.getMonth() + 12));
                        default: dd = new Date(dd.setDate(dd.getDate()));
                    }
                    dt = dd.getFullYear().toString();
                    if (dd.getMonth() + 1 < 10) {
                        dt = dt + "-0" + (dd.getMonth() + 1).toString();
                    }
                    else {
                        dt = dt + "-0" + (dd.getMonth() + 1).toString();
                    }
                    if (dd.getDate() < 10) {
                        dt = dt + "-0" + dd.getDate().toString();
                    }
                    else {
                        dt = dt + "-" + dd.getDate().toString();
                    }                   
                }
                sql = sqlWhere;
                //从第一页开始
                _cur_page = 1;
                get_Display(sqlWhere);
            }
            
            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                var checkStatus = table.checkStatus(obj.config.id);
                switch (obj.event) {                  
                    case 'btn-HideColumn':
                        get_HideColumn();
                        break;
                    case 'btn-exit':
                        //var index = parent.layer.getFrameIndex(window.name);
                        //element.tabDelete('layadmin-layout-tabs', this);
                        parent.layui.admin.events.closeThisTabs();
                        //parent.layer.close(index);
                        break;
                };
            });

            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }
                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//数据库查询出的列数据
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < dataCol.length; i++) {
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;
                                }
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                    option.cols[0][i + 1]["hide"] = false;
                                }
                                //隐藏id
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    if (option.cols[0][i + 1]["field"] == '回复交期') {
                                        option.cols[0][i + 1]["width"] = 120;
                                    } else {
                                        option.cols[0][i + 1]["width"] = dataCols[3];
                                    }
                                }
                                //设置内容字体大小
                                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"] = "";
                                //}

                                //字体所在位置(å·¦ å±…中 å³)
                                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 });
                    }
                })
            }

        });
    </script>
</body>

</html>

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

New file
@@ -0,0 +1,424 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>采购退料单列表</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=0">
    <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
    <!--<link rel="stylesheet" href="../../layuiadmin/layui/css/layui-blue.css" media="all">-->
    <link rel="stylesheet" href="../../layuiadmin/layui/css/style-self.css" media="all">
    <style type="text/css">
        .layui-input-block {
            width: 190px;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-row layui-col-space15">
            <div class="layui-col-md12">
                <div class="layui-card" style="padding: 1px">
                    <div class="layui-card-body" style="padding: 1px;">
                        <!--<div class="test-table-reload-btn" style="margin-bottom: 10px;">-->
                        <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="text" class="layui-input" name="HBillNo" id="HBillNo">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料编码</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HShortNumber" id="HShortNumber">
                                        </div>
                                    </div>                                  
                                    <div class="layui-inline">
                                        <label class="layui-form-label">物料名称</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HName" id="HName">
                                        </div>
                                    </div>

                                    <div class="layui-inline">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                        </button>
                                    </div>
                                    <div class="layui-colla-content" style="padding-left:82px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">规格型号</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HModel" id="HModel">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">开始日期</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input" name="HDate1" 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="HDate2" id="HDate2">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">采购组织</label>
                                            <div class="layui-input-block">
                                                <select id="HPURCHASEORGID" name="HPURCHASEORGID" lay-filter="">
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </form>
                        <!--</div>-->
                    </div>
                    <table class="layui-hide" 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="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>预览</button>-->
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>刷新</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>退出</button>
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-HideColumn"><i class="layui-icon layui-icon-return"></i>隐藏列设置</button>
                        </div>
                    </script>
                </div>
            </div>
        </div>
    </div>
    <script src="../../layuiadmin/layui/layui.js" charset="utf-8"></script>
    <script src="../../../../Scripts/webConfig.js"></script>
    <script>
        var _cur_page = 1;
        var sql = "";
        function getUrlVars() {
            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;
        }

        function f_alert(sMsg) {
            layer.alert(sMsg, { icon: 5 });
        }
        var params = getUrlVars();
        var type = params[params[0]];

        layui.config({
            base: '../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index' //主入口模块
        }).use(['index', 'form', 'laydate', 'code', 'table', 'element', 'layer','excel'], function () {
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
                , laydate = layui.laydate
                , table = layui.table
                , form = layui.form
                , element = layui.element
                , excel = layui.excel;
            //常规用法
            laydate.render({
                elem: '#HDate1'
            });
            laydate.render({
                elem: '#HDate2'
            });
            //不需要显示的字段 å¯æ‰©å±•
            var titleData = ["FID", "FSupplierID", "FMaterialID", "FUnitID", "FStockID", "FStockOrgID"];
            var option = [];
            var HModName = "SRM_POStockInBillList";
            //#region è¿›å…¥é¡µé¢æ—¢åŠ è½½
            set_ClearBill();
            //#region æ­¤é¡µé¢æ‰€æœ‰æ–¹æ³•
            function set_ClearBill() {
                //渲染采购组织
                var Organization = '<option value=' + sessionStorage["OrganizationID"] + ' style="color:red;">' + sessionStorage["Organization"] + '</option>';
                $("#HPURCHASEORGID").append(Organization);
                form.render('select');
                //初始化表格
                //set_InitGrid();
                //显示列数据
                //DisPlay_HideColumn();
                //直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
                get_FastQuery(table, option)
            }

            //加载显示数据
            function get_Display(sqlWhere) {
                var wait = layer.load();//遮罩
                $.ajax({
                    type: "POST",
                    url: GetWEBURL() + "GetPOInStockOutBillList",
                    async: true,
                    data: { "HSupNo": sessionStorage["HUserName"], "sqlWhere": sqlWhere },
                    success: function (data1) {
                        if (data1.Message == "获取成功") {
                        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', totalRowText: '合计' });
                        for (var i = 0; i < data.length; i++) {
                            // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                            if ($.inArray(data[i].name, titleData) > -1) {
                                col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //隐藏id列
                            }
                            else if (data[i].name.indexOf('id') > -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:
                                        if (data[i].name == '订单数量' || data[i].name == '已发货数量' || data[i].name == '未发货数量') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, totalRow: true });
                                        } else if (data[i].name == '回复交期') {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200, event: 'HSupSendGoodsDateRemark' });
                                        } else {
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                        }
                                }
                            }
                        }
                        //动态显示列名
                        option = {
                            elem: '#mainTable'
                            , toolbar: '#toolbarDemo'
                            , cols: [col]
                            , data: data1.data
                            , height: 'full-80'
                            ,totalRow: true
                            , page: true
                            , cellMinWidth: 90
                            , limit: 500
                            , limits: [50, 500, 5000, 20000]
                        }
                        table.render(option);
                        //刷新表格数据
                        DisPlay_HideColumn();
                            layer.close(wait);
                        } else {
                            layer.close(wait);
                            layer.alert(data1.Message, { icon: 5 });
                        }
                    },
                    error: function (result) {
                        layer.close(wait);
                        layer.alert(result.Message, { icon: 5 });
                    }
                });
            };
            //查询按钮
            form.on('submit(btnSearch)', function (data) {//查询
                get_FastQuery(table, option);
            });
            //查询条件
            function get_FastQuery(table, option) {
                var sqlWhere = "";

                if ($("#HBillNo").val() != "")
                    sqlWhere += " and å•æ®å· like ^^%" + $("#HBillNo").val() + "%^^";
                if ($("#HShortNumber").val() != "")
                    sqlWhere += " and ç‰©æ–™ç¼–码 like ^^%" + $("#HShortNumber").val() + "%^^";
                if ($("#HName").val() != "")
                    sqlWhere += " and ç‰©æ–™åç§° like ^^%" + $("#HName").val() + "%^^";
                if ($("#HModel").val() != "")
                    sqlWhere += " and è§„格型号 like ^^%" + $("#HModel").val() + "%^^";

                if ($("#HDate1").val() != "") {
                    sqlWhere += " and é€€æ–™æ—¥æœŸ >= ^^" + $("#HDate1").val() + "^^";
                }
                if ($("#HDate2").val() != "") {
                    sqlWhere += " and é€€æ–™æ—¥æœŸ <= ^^" + $("#HDate2").val() + "^^";
                }

                var Time = $("#Time").val();
                if (Time > 0) {
                    var dd = new Date();
                    var dt;
                    switch (Time) {
                        case 1: dd = new Date(dd.setDate(dd.getDate() + 7));
                        case 2: dd = new Date(dd.setDate(dd.getDate() + 14));
                        case 3: dd = new Date(dd.setMonth(dd.getMonth() + 1));
                        case 4: dd = new Date(dd.setMonth(dd.getMonth() + 2));
                        case 5: dd = new Date(dd.setMonth(dd.getMonth() + 3));
                        case 6: dd = new Date(dd.setMonth(dd.getMonth() + 6));
                        case 7: dd = new Date(dd.setMonth(dd.getMonth() + 12));
                        default: dd = new Date(dd.setDate(dd.getDate()));
                    }
                    dt = dd.getFullYear().toString();
                    if (dd.getMonth() + 1 < 10) {
                        dt = dt + "-0" + (dd.getMonth() + 1).toString();
                    }
                    else {
                        dt = dt + "-0" + (dd.getMonth() + 1).toString();
                    }
                    if (dd.getDate() < 10) {
                        dt = dt + "-0" + dd.getDate().toString();
                    }
                    else {
                        dt = dt + "-" + dd.getDate().toString();
                    }
                }
                sql = sqlWhere;
                //从第一页开始
                _cur_page = 1;
                get_Display(sqlWhere);
            }

            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                var checkStatus = table.checkStatus(obj.config.id);
                switch (obj.event) {
                    case 'btn-HideColumn':
                        get_HideColumn();
                        break;
                    case 'btn-exit':
                        //var index = parent.layer.getFrameIndex(window.name);
                        //element.tabDelete('layadmin-layout-tabs', this);
                        parent.layui.admin.events.closeThisTabs();
                        //parent.layer.close(index);
                        break;
                };
            });

            //隐藏列设置
            function get_HideColumn() {
                var colName = "";
                for (var i = 1; i < option.cols[0].length - 1; i++) {
                    colName += option.cols[0][i]["title"] + ",";
                }
                colName = encodeURI(colName.substring(0, colName.length - 1));//对 URI è¿›è¡Œç¼–码
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "隐藏列设置"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["50%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../基础资料/隐藏列设置/Gy_GridView_Hide.html?HModName=' + HModName + '&colName=' + colName, "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 = [];//数据库查询出的列数据
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < dataCol.length; i++) {
                                var dataCols = dataCol[i].split('|');
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;
                                }
                                //显示列
                                if (dataCols[1] == 0 && $.inArray(option.cols[0][i + 1]["title"], titleData) == -1) {
                                    option.cols[0][i + 1]["hide"] = false;
                                }
                                //隐藏id
                                //设置列宽
                                if (dataCols[3] > 0) {
                                    if (option.cols[0][i + 1]["field"] == '回复交期') {
                                        option.cols[0][i + 1]["width"] = 120;
                                    } else {
                                        option.cols[0][i + 1]["width"] = dataCols[3];
                                    }
                                }
                                //设置内容字体大小
                                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"] = "";
                                //}

                                //字体所在位置(å·¦ å±…中 å³)
                                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 });
                    }
                })
            }

        });
    </script>
</body>

</html>

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

@@ -162,6 +162,18 @@
                                        <dd data-name="SRM_EntrustOrderBillList_ReBack"><a lay-href="SRM/SRM_EntrustOrderBillList.html?type=ReBack">已驳回委外订单</a></dd>
                                    </dl>
                                </dd>
                                <dd>
                                    <a>采购入库记录</a>
                                    <dl class="layui-nav-child">
                                        <dd data-name="SRM_POStockInBillList"><a lay-href="SRM/SRM_POStockInBillList.html">采购入库单列表</a></dd>
                                    </dl>
                                </dd>
                                <dd>
                                    <a>采购退库记录</a>
                                    <dl class="layui-nav-child">
                                        <dd data-name="SRM_POStockOutBillList"><a lay-href="SRM/SRM_POStockOutBillList.html">采购退料单列表</a></dd>
                                    </dl>
                                </dd>
                            </dl>
                        </li>
                        <li data-name="home" class="layui-nav-item">