对巡检记录单,工序检验单,首件检验单优化,在巡检记录单的保存和添加的时候保存判定结论,在页面跟视图进行修改,添加头部要查询数据的字段内容,对部门设置添加按钮设置
5个文件已修改
315 ■■■■ 已修改文件
WebTM/views/基础资料/公用基础资料/Gy_DepartmentList.html 31 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/质量管理/巡检记录单/QC_Add_Edit_PatrolProcCheckBill.html 7 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/质量管理/巡检记录单/QC_PatrolProcCheckBillList.html 98 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/质量管理/工序检验单/QC_ProcessCheckBillList.html 88 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/质量管理/首件检验单/QC_FirstPieceCheckBillList.html 91 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/»ù´¡×ÊÁÏ/¹«Óûù´¡×ÊÁÏ/Gy_DepartmentList.html
@@ -13,6 +13,7 @@
    <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/HideButton.js"></script>
</head>
<body>
@@ -87,15 +88,16 @@
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit"><i class="layui-icon layui-icon-circle"></i>反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Stop"><i class="layui-icon layui-icon-radio"></i>禁用</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeStop"><i class="layui-icon layui-icon-radio"></i>反禁用</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AddNew" id="set_add"><i class="layui-icon layui-icon-file-b"></i>新增</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_ShowBill" id="set_show"><i class="layui-icon layui-icon-form"></i>编辑</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_DeleteBill" id="set_delete"><i class="layui-icon layui-icon-delete"></i>删除</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Refresh" id="get_ref"><i class="layui-icon layui-icon-refresh-3"></i>刷新</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Audit" id="btn_audit"><i class="layui-icon layui-icon-radio"></i>审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeAudit" id="btn_deaudit"><i class="layui-icon layui-icon-circle"></i>反审核</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Stop" id="btn_stop"><i class="layui-icon layui-icon-radio"></i>禁用</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-DeStop" id="btn_destop"><i class="layui-icon layui-icon-radio"></i>反禁用</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideColumn" id="set_hidecolumn"><i class="layui-icon layui-icon-form"></i>列设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>按钮设置</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                            </div>
                        </script>
@@ -180,6 +182,11 @@
                        break;
                    //列设置
                    case 'set_HideColumn': get_HideColumn();
                        break;
                    case 'set_HideButton':
                        var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                        var HBillType = "Gy_DepartmentList";
                        get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
                        break;
                };
            });
@@ -310,6 +317,12 @@
                            }
                            table.render(option);
                            //刷新按钮显示
                            var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                            var HBillType = "Gy_DepartmentList";
                            Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
                            //刷新表格数据
                            DisPlay_HideColumn();
WebTM/views/ÖÊÁ¿¹ÜÀí/Ѳ¼ì¼Ç¼µ¥/QC_Add_Edit_PatrolProcCheckBill.html
@@ -93,6 +93,13 @@
                                                        <input type="text" name="HMainProcName" id="HMainProcName" onkeyup="this.value=this.value.replace(/\D/g,'')" lay-verify="" autocomplete="off" class="layui-input" value="">
                                                    </div>
                                                </div>
                                                <div class="layui-inline">
                                                    <label class="layui-form-label">判断结论</label>
                                                    <div class="layui-input-block">
                                                        <input type="radio" name="HLastResult" id="HLastResult" value="1" title="合格" checked>
                                                        <input type="radio" name="HLastResult" id="HLastResult" value="0" title="不合格">
                                                    </div>
                                                </div>
                                                <div class="layui-colorpicker-xs" style="margin-top:15px">
                                                    <label class="layui-form-label"> å¤‡æ³¨</label>
                                                    <div class="layui-input-block">
WebTM/views/ÖÊÁ¿¹ÜÀí/Ѳ¼ì¼Ç¼µ¥/QC_PatrolProcCheckBillList.html
@@ -37,101 +37,97 @@
                                    </div>
                                    <!--第一层过滤-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label">单据号</label>
                                        <div class="layui-input-block" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">单据号</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <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" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">开始日期</label>
                                        <div class="layui-input-block" style="margin-left: 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" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">结束日期</label>
                                        <div class="layui-input-block" style="margin-left: 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" style="width:120px">
                                            <select name="HLastResult" id="HLastResult" lay-verify="HLastResult">
                                                <option value=""></option>
                                                <option value="合格">合格</option>
                                                <option value="不合格">不合格</option>
                                            </select>
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                    </button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                    <!--第二排过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <div class="layui-row" style="margin-top:5px">
                                    <div class="layui-colla-content">
                                        <!--第二排过滤-->
                                        <div class="layui-row" >
                                            <div class="layui-inline">
                                                <label class="layui-form-label">物料编码</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">物料编码</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">物料名称</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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:120px">
                                                <label class="layui-form-label" style="width: 85px;">规格型号</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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:120px">
                                                <label class="layui-form-label" style="width: 85px;">质检员</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName1" id="HName1">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <!--第三排过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <!--第三排过滤-->
                                        <div class="layui-row" style="margin-top:5px">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">检验项目</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">检验项目</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName2" id="HName2">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">生产名称</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">生产名称</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName3" id="HName3">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">工序流转卡</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">工序流转卡</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo">
                                                </div>
                                            </div>
                                            <div class="layui-inline" style="width: 85px;">
                                                <label class="layui-form-label">判定结论</label>
                                                <div class="layui-input-block" style="width:190px;">
                                                    <select name="HLastResult" id="HLastResult" lay-verify="HLastResult" >
                                                        <option value=""></option>
                                                        <option value="合格">合格</option>
                                                        <option value="不合格">不合格</option>
                                                    </select>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <!--自定义过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <!--自定义过滤-->
                                        <div class="layui-row" style="margin-top:5px">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline" style="width:120px">
                                            <div class="layui-inline">
                                                <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
                                                    <option value="0" selected="selected"></option>
                                                    <option value="=">=</option>
@@ -146,7 +142,7 @@
                                                    <option value="10">不包含</option>
                                                </select>
                                            </div>
                                            <div class="layui-inline" style="width:120px">
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
                                            </div>
                                        </div>
@@ -281,8 +277,12 @@
                    , { field: '表头备注 ', title: '表头备注', width: 105, sort: true }
                    , { field: '制单人', title: '制单人', width: 160, sort: true }
                    , { field: '制单日期', title: '制单日期', width: 160, 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 }
                    , { field: '产品内码', title: '产品内码', sort: true }
                    , { field: '产品名称', title: '产品名称', sort: true }
                    , { field: '产品型号', title: '产品型号', width: 115, sort: true }
@@ -514,21 +514,21 @@
                if (HBillNo)
                    sqlWhere += " and å•据号 like '%" + HBillNo + "%'";
                if (HNumber)
                    sqlWhere += " and ç‰©æ–™ç¼–码 like '%" + HNumber + "%'";
                    sqlWhere += " and äº§å“å†…码 like '%" + HNumber + "%'";
                if (HName)
                    sqlWhere += " and ç‰©æ–™åç§° like '%" + HName + "%'";
                    sqlWhere += " and äº§å“åç§° like '%" + HName + "%'";
                if (HModel)
                    sqlWhere += " and è§„格型号 like '%" + HModel + "%'";
                    sqlWhere += " and äº§å“åž‹å· like '%" + HModel + "%'";
                if (HLastResult)
                    sqlWhere += " and åˆ¤å®šç»“论 like '" + HLastResult + "%'";
                if (HName1)
                    sqlWhere += " and è´¨æ£€å‘˜åç§° like '%" + HName1 + "%'";
                    sqlWhere += " and æ£€éªŒå‘˜åç§° like '%" + HName1 + "%'";
                if (HName2)
                    sqlWhere += " and æ£€éªŒé¡¹ç›® like '%" + HName2 + "%'";
                    sqlWhere += " and æ£€éªŒé¡¹ç›®åç§° like '%" + HName2 + "%'";
                if (HName3)
                    sqlWhere += " and ç”Ÿäº§èµ„源名称 like '%" + HName3 + "%'";
                if (HProcExchBillNo)
                    sqlWhere += " and å·¥åºæµè½¬å¡ like '%" + HProcExchBillNo + "%'";
                    sqlWhere += " and å·¥åºæµè½¬å¡å· like '%" + HProcExchBillNo + "%'";
                if (HDate1) {
                    sqlWhere += " and æ—¥æœŸ >= '" + HDate1 + "'";
WebTM/views/ÖÊÁ¿¹ÜÀí/¹¤Ðò¼ìÑéµ¥/QC_ProcessCheckBillList.html
@@ -39,101 +39,97 @@
                                    </div>
                                    <!--第一层过滤-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label" >单据号</label>
                                        <div class="layui-input-block" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">单据号</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <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" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">开始日期</label>
                                        <div class="layui-input-block" style="margin-left: 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" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">结束日期</label>
                                        <div class="layui-input-block" style="margin-left: 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" style="width:120px">
                                            <select name="HLastResult" id="HLastResult" lay-verify="HLastResult">
                                                <option value=""></option>
                                                <option value="合格">合格</option>
                                                <option value="不合格">不合格</option>
                                            </select>
                                        </div>
                                    </div>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                        <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                    </button>
                                    <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                    <!--第二排过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <div class="layui-row" style="margin-top:5px">
                                    <div class="layui-colla-content">
                                        <!--第二排过滤-->
                                        <div class="layui-row">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">物料编码</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">物料编码</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">物料名称</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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:120px">
                                                <label class="layui-form-label" style="width: 85px;">规格型号</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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:120px">
                                                <label class="layui-form-label" style="width: 85px;">质检员</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName1" id="HName1">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <!--第三排过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <!--第三排过滤-->
                                        <div class="layui-row" style="margin-top:5px">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">检验项目</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">检验项目</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName2" id="HName2">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">生产名称</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">生产名称</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName3" id="HName3">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">工序流转卡</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">工序流转卡</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo">
                                                </div>
                                            </div>
                                            <div class="layui-inline" style="width: 85px;">
                                                <label class="layui-form-label">判定结论</label>
                                                <div class="layui-input-block" style="width:190px;">
                                                    <select name="HLastResult" id="HLastResult" lay-verify="HLastResult">
                                                        <option value=""></option>
                                                        <option value="合格">合格</option>
                                                        <option value="不合格">不合格</option>
                                                    </select>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <!--自定义过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <!--自定义过滤-->
                                        <div class="layui-row" style="margin-top:5px">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline" style="width:120px">
                                            <div class="layui-inline">
                                                <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
                                                    <option value="0" selected="selected"></option>
                                                    <option value="=">=</option>
@@ -148,7 +144,7 @@
                                                    <option value="10">不包含</option>
                                                </select>
                                            </div>
                                            <div class="layui-inline" style="width:120px">
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
                                            </div>
                                        </div>
@@ -333,7 +329,7 @@
                if (HBillNo)
                    sqlWhere += " and å•据号 like '%" + HBillNo + "%'";
                if (HNumber)
                    sqlWhere += " and ç‰©æ–™ç¼–码 like '%" + HNumber + "%'";
                    sqlWhere += " and ç‰©æ–™ä»£ç  like '%" + HNumber + "%'";
                if (HName)
                    sqlWhere += " and ç‰©æ–™åç§° like '%" + HName + "%'";
                if (HModel)
@@ -343,11 +339,11 @@
                if (HName1)
                    sqlWhere += " and è´¨æ£€å‘˜åç§° like '%" + HName1 + "%'";
                if (HName2)
                    sqlWhere += " and æ£€éªŒé¡¹ç›® like '%" + HName2 + "%'";
                    sqlWhere += " and æ£€éªŒé¡¹ç›®åç§° like '%" + HName2 + "%'";
                if (HName3)
                    sqlWhere += " and ç”Ÿäº§èµ„源名称 like '%" + HName3 + "%'";
                if (HProcExchBillNo)
                    sqlWhere += " and å·¥åºæµè½¬å¡ like '%" + HProcExchBillNo + "%'";
                    sqlWhere += " and å·¥åºæµè½¬å¡å· like '%" + HProcExchBillNo + "%'";
                if (HDate1) {
                    sqlWhere += " and æ—¥æœŸ >= '" + HDate1 + "'";
WebTM/views/ÖÊÁ¿¹ÜÀí/Ê×¼þ¼ìÑéµ¥/QC_FirstPieceCheckBillList.html
@@ -39,102 +39,99 @@
                                    </div>
                                    <!--第一层过滤-->
                                    <div class="layui-inline">
                                        <label class="layui-form-label">单据号</label>
                                        <div class="layui-input-block" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">单据号</label>
                                        <div class="layui-input-block" style="margin-left: 120px;">
                                            <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" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">开始日期</label>
                                        <div class="layui-input-block" style="margin-left: 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" style="width:120px">
                                        <label class="layui-form-label" style="width: 85px;">结束日期</label>
                                        <div class="layui-input-block" style="margin-left: 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" style="width:120px">
                                            <select name="HLastResult" id="HLastResult" lay-verify="HLastResult">
                                                <option value=""></option>
                                                <option value="合格">合格</option>
                                                <option value="不合格">不合格</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="f_Query" id="f_Query">
                                            <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                        </button>
                                    </div>
                                    <!--第二排过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <div class="layui-row" style="margin-top:5px">
                                    <div class="layui-colla-content">
                                        <!--第二排过滤-->
                                        <div class="layui-row">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">物料编码</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">物料编码</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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" style="width:120px" >
                                                <label class="layui-form-label" style="width: 85px;">物料名称</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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:120px">
                                                <label class="layui-form-label" style="width: 85px;">规格型号</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <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:120px">
                                                <label class="layui-form-label" style="width: 85px;">质检员</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName1" id="HName1">
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <!--第三排过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <!--第三排过滤-->
                                        <div class="layui-row" style="margin-top:5px">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">检验项目</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">检验项目</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName2" id="HName2">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">生产名称</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">生产名称</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HName3" id="HName3">
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <label class="layui-form-label">工序流转卡</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <label class="layui-form-label" style="width: 85px;">工序流转卡</label>
                                                <div class="layui-input-block" style="margin-left: 120px;">
                                                    <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo">
                                                </div>
                                            </div>
                                            <div class="layui-inline" style="width: 85px;">
                                                <label class="layui-form-label">判定结论</label>
                                                <div class="layui-input-block" style="width:190px;">
                                                    <select name="HLastResult" id="HLastResult" lay-verify="HLastResult">
                                                        <option value=""></option>
                                                        <option value="合格">合格</option>
                                                        <option value="不合格">不合格</option>
                                                    </select>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <!--自定义过滤-->
                                    <div class="layui-colla-content" style="padding: 0px; margin-left: 6%;">
                                        <!--自定义过滤-->
                                        <div class="layui-row" style="margin-top:5px">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block" style="width:120px">
                                                <div class="layui-input-block">
                                                    <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline" style="width:120px">
                                            <div class="layui-inline">
                                                <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
                                                    <option value="0" selected="selected"></option>
                                                    <option value="=">=</option>
@@ -148,8 +145,8 @@
                                                    <option value="9">右包含</option>
                                                    <option value="10">不包含</option>
                                                </select>
                                            </div>
                                            <div class="layui-inline" style="width:120px">
                                            </div>
                                            <div class="layui-inline" style="margin-left: 120px;">
                                                <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
                                            </div>
                                        </div>
@@ -792,7 +789,7 @@
                if (HBillNo)
                    sqlWhere += " and å•据号 like '%" + HBillNo+ "%'";
                if (HNumber)
                    sqlWhere += " and ç‰©æ–™ç¼–码 like '%" + HNumber + "%'";
                    sqlWhere += " and ç‰©æ–™ä»£ç  like '%" + HNumber + "%'";
                if (HName)
                    sqlWhere += " and ç‰©æ–™åç§° like '%" + HName + "%'";
                if (HModel)
@@ -802,11 +799,11 @@
                if (HName1)
                    sqlWhere += " and è´¨æ£€å‘˜åç§° like '%" + HName1 + "%'";
                if (HName2)
                    sqlWhere += " and æ£€éªŒé¡¹ç›® like '%" + HName2 + "%'";
                    sqlWhere += " and æ£€éªŒé¡¹ç›®åç§° like '%" + HName2 + "%'";
                if (HName3)
                    sqlWhere += " and ç”Ÿäº§èµ„源名称 like '%" + HName3 + "%'";
                if (HProcExchBillNo)
                    sqlWhere += " and å·¥åºæµè½¬å¡ like '%" + HProcExchBillNo + "%'";
                    sqlWhere += " and å·¥åºæµè½¬å¡å· like '%" + HProcExchBillNo + "%'";
                if (HDate1) {
                    sqlWhere += " and æ—¥æœŸ >= '" + HDate1 + "'";