1

yxj

2023-09-05 950157be58f7a635aa59dbe5c87bb2a2d5914be1

 WebTM/views/ÖÊÁ¿¹ÜÀí/Ê×¼þ¼ìÑéµ¥/QC_FirstPieceCheckBillList.html

@@ -59,9 +59,18 @@
                        </form>
                        <!--</div>-->
                    </div>


                    <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table>
                    <div class="layui-tab layui-tab-card">
                        <ul class="layui-tab-title">
                            <li class="layui-this">检测值</li>                          
                        </ul>
                        <div class="layui-tab-content">
                            <div class="layui-tab-item layui-show">
                                <!--检测值-->
                                <table class="layui-hide" id="mainTable_Value" lay-filter="mainTable_Value"></table>
                            </div>                           
                        </div>
                    </div>
                    <script type="text/html" id="toolbarDemo">
                        <div class="layui-btn-container">
                            <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-form"></i>新增</button>
@@ -83,6 +92,9 @@
    <script>
        var _cur_page = 1;
        var sql = " ";
        var titleData = ["hmainid", "hentryid", "HEntryID", "HSourceID", "HMaterID", "HFirstCheckEmp", "HQCCheckItemID", "HUnitID", "HSampleSchemeID"];
        var checkobj = ""; //复选框
        var trindex = ""; //默认选中行下标
        //var options = document.getElementById('HStatus').children;
        function getUrlVars() {
            var vars = [], hash;
@@ -142,6 +154,8 @@
            //公用变量
            var option = [];
            var HModName = "QC_FirstPieceCheckBillList";
            //不需要显示的字段 å¯æ‰©å±• ï¼ˆæ£€æµ‹å€¼ï¼‰
            var titleData_Value = [];
            //隐藏勾选字段
            DisPlay_HideColumn();
            //常规用法
@@ -286,41 +300,189 @@
            });

            ///加载显示数据
            //function RoadHBillNo(sqlWhere) {
            //    where = sqlWhere;
            //    var index0 = layer.load();
            //    $.ajax({
            //        type: "get",
            //        url: GetWEBURL() +"/QC_Management/MES_QC_FirstPieceCheckBillList_Json",
            //        async: true,
            //        data: { "sqlWhere": sqlWhere, "user": sessionStorage["HUserName"] },//"HSupNo": sessionStorage["HUserName"],
            //        success: function (result) {
            //            if (result.count == 1) {
            //            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) {

            //                }
            //            });
            //            layer.close(index0);
            //        } else {
            //                layer.close(index0);
            //                layer.alert(result.code + result.Message, { icon: 5 });
            //        }

            //        },
            //        error: function (result) {
            //            layer.close(index0);
            //        layer.alert("接口请求失败!", { icon: 5 });
            //        }
            //    });
            //};

            // æŸ¥è¯¢
            function RoadHBillNo(sqlWhere) {
                where = sqlWhere;
                var index0 = layer.load();
                var ajaxLoad = layer.load();
                $.ajax({
                    type: "get",
                    url: GetWEBURL() +"/QC_Management/MES_QC_FirstPieceCheckBillList_Json",
                    async: true,
                    data: { "sqlWhere": sqlWhere, "user": sessionStorage["HUserName"] },//"HSupNo": sessionStorage["HUserName"],
                    success: function (result) {
                        if (result.count == 1) {
                        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) {
                    url: GetWEBURL() + '/QC_FirstPieceCheckBill/QC_FirstPieceCheckBillList',
                    type: "GET",
                    data: { "sWhere": sqlWhere, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            layer.close(ajaxLoad);

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

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

            }

            //点击主表带出从表数据
            table.on('rowDouble(mainTable)', function (obj) { //注：tool æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„属性 lay-filter="对应的值"
                //选中行改变颜色
                check_row(obj);

                var datas = obj.data; //获得当前行数据
                HBillNo = datas["单据号"].toString();
                var HInterID = datas.hmainid;
                var HEntryID = datas.hsubid;
                var wait = layer.load();
                $.ajax({
                    url: GetWEBURL() + '/QC_ValueTable/getValueList',
                    type: "GET",
                    data: { "HInterID": HInterID, "HEntryID": HEntryID, "user": sessionStorage["HUserName"] },
                    async: false,                  
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];
                            var col = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
                                data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData_Value) > -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 HH:mm:ss')}}</div>", width: 200 });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
                                    }
                                }
                            }

                            //动态显示列名
                            option_Value = {
                                elem: '#mainTable_Value'
                                //, toolbar: '#toolbarDemo2'
                                , cols: [col]
                                , data: data1.data
                                , height: 550
                                , page: true
                                , cellMinWidth: 90
                                , limit: 50
                                , limits: [50, 500, 5000, 20000]
                            }
                            table.render(option_Value);

                            //刷新表格数据
                            //DisPlay_HideColumn();

                            layer.close(wait);
                            //layer.alert("查询成功", { icon: 1 });
                        } else {
                            option_Value = {
                                elem: '#mainTable_Value'
                                //, toolbar: '#toolbarDemo2'
                                , cols: []
                                , data: ""
                                , height: 550
                                , page: true
                                , cellMinWidth: 90
                                , limit: 50
                                , limits: [50, 500, 5000, 20000]
                            }
                            table.render(option_Value);
                            layer.close(wait);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(wait);
                        layer.alert("接口请求失败!", { icon: 5 });
                    }
                });            
            });

            form.on('submit(f_Query)', function (data) {//查询
                var sqlWhere = " and 1=1 ";
                //if ($("#HStatus").val() != "")
@@ -395,6 +557,32 @@
                _cur_page = 1;
                RoadHBillNo(sqlWhere);
            });

            //改变选中行颜色
            function check_row(obj) {
                if (checkobj != "") {
                    checkobj.tr.find('.layui-form-checkbox').removeClass('layui-form-checked');//取消复选框选中样式
                    checkobj.tr.find(':checkbox:first').prop('checked', false);//取消复选框选中样式
                    $(checkobj.tr.selector).attr({ "style": "background:" });//取消当前tr颜色
                }

                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背景颜色和字体颜色
                    checkobj = obj;
                } 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 set_AddNew() {
@@ -495,12 +683,14 @@


                            var dataCol = [];//数据库查询出的列数据
                            var titleData = ["hmainid", "hsubid", "作废人"];//不需要显示的字段 å¯æ‰©å±•
                            var titleData = ["hmainid", "hentryid", "HEntryID", "HSourceID", "HMaterID", "HFirstCheckEmp", "HQCCheckItemID", "HUnitID", "HSampleSchemeID"];//不需要显示的字段 å¯æ‰©å±•

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

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