| WebTM/views/质量管理/巡检记录单/QC_PatrolProcCheckBillList.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/质量管理/工序检验单/QC_ProcessCheckBillList.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebTM/views/质量管理/首件检验单/QC_FirstPieceCheckBillList.html | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebTM/views/ÖÊÁ¿¹ÜÀí/Ѳ¼ì¼Ç¼µ¥/QC_PatrolProcCheckBillList.html
@@ -30,29 +30,127 @@ <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" style="width: 85px;">åæ®å·</label> <div class="layui-input-block" style="margin-left: 120px;"> <label class="layui-form-label">åæ®å·</label> <div class="layui-input-block" style="width:120px"> <input type="text" class="layui-input" name="HBillNo" id="HBillNo"> </div> </div> <div class="layui-inline"> <label class="layui-form-label" style="width: 85px;">å¼å§æ¥æ</label> <div class="layui-input-block" style="margin-left: 100px;"> <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" style="width: 85px;">ç»ææ¥æ</label> <div class="layui-input-block" style="margin-left: 100px;"> <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" 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-inline"> <label class="layui-form-label">ç©æç¼ç </label> <div class="layui-input-block" style="width: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"> <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"> <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"> <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"> <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"> <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"> <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo"> </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"> <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline" style="width:120px"> <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline" style="width:120px"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> </div> </div> </div> <table class="layui-hide" id="mainTable" lay-filter="mainTable"></table> @@ -63,6 +161,14 @@ <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="btn-Delete" lay-event="btn-Delete"><i class="layui-icon layui-icon-form"></i>å é¤</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_HideColumn" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Refresh" id="RefreshButton"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Audit" id="AuditButton"><i class="layui-icon layui-icon-radio"></i>å®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeAudit" id="DeAuditButton"><i class="layui-icon layui-icon-circle"></i>åå®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Close" id="btn-Close"><i class="layui-icon layui-icon-radio"></i>å ³é</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeClose" id="btn-DeClose"><i class="layui-icon layui-icon-radio"></i>åå ³é</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Drop" id="btn-Drop"><i class="layui-icon layui-icon-radio"></i>ä½åº</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeDrop" id="btn-DeDrop"><i class="layui-icon layui-icon-radio"></i>åä½åº</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Exit" id="ExitButton"><i class="layui-icon layui-icon-logout"></i>éåº</button> </div> </script> </form> @@ -187,8 +293,8 @@ , { field: 'å ³é人', title: 'å ³é人', width: 160, sort: true } , { field: 'å ³éæ¥æ', title: 'å ³éæ¥æ', width: 160, sort: true } , { field: 'ä½åºäºº', title: 'ä½åºäºº', hide: true, width: 160, sort: true } , { field: 'ä½åºæ¥æ ', title: 'ä½åºæ¥æ', width: 215, sort: true } , { field: 'åæ®ç±»å ', title: 'åæ®ç±»å ', width: 115, sort: true } , { field: 'ä½åºæ¥æ', title: 'ä½åºæ¥æ', width: 215, sort: true } , { field: 'åæ®ç±»å', title: 'åæ®ç±»å', width: 115, sort: true } ]] //, skin: 'row' //è¡¨æ ¼é£æ ¼ // , even: true @@ -284,9 +390,42 @@ var HBillType = "7506"; get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); break; //å·æ° case 'get_Refresh': get_Refresh(); break; //éåºæé® case 'get_Exit': Pub_Close(2); break; //å®¡æ ¸æé® case 'btn-Audit': set_CheckBill(0); break; //åå®¡æ ¸æé® case 'btn-DeAudit': set_CheckBill(1); break; //å ³éæé® ï¼1:å ³éã2:åå ³éï¼ case 'btn-Close': set_CloseBill(1); break; //åå ³éæé® case 'btn-DeClose': set_CloseBill(2); break; //ä½åºæé® ï¼1:ä½åºã2:åä½åºï¼ case 'btn-Drop': set_DropBill(1); break; //åä½åºæé® case 'btn-DeDrop': set_DropBill(2); break; }; }); //å·æ° function get_Refresh() { $("#btnSearch").trigger('click'); } ///å è½½æ¾ç¤ºæ°æ® function RoadHBillNo(sqlWhere) { var ajaxLoad = layer.load(); @@ -311,6 +450,11 @@ } }); layer.close(ajaxLoad); //è¿æ»¤ if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } //å·æ°æé®æ¾ç¤º var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "7506"; @@ -331,11 +475,60 @@ form.on('submit(btnSearch)', function (data) {//æ¥è¯¢ var sqlWhere = " and 1=1 "; var HBillNo = $("#HBillNo").val();//åæ®å· var HNumber = $("#HNumber").val();//ç©æç¼ç var HName = $("#HName").val();//ç©æåç§° var HModel = $("#HModel").val();//è§æ ¼åå· var HDate1 = $("#HDate1").val();//å¼å§æ¥æ var HDate2 = $("#HDate2").val();//ç»ææ¥æ var HDate2 = $("#HDate2").val();//ç»ææ¥æ var HLastResult = $("#HLastResult").val();//å¤å®ç»è®º var HName1 = $("#HName1").val();//è´¨æ£ååç§° var HName2 = $("#HName2").val();//æ£éªé¡¹ç® var HName3 = $("#HName3").val();//çäº§èµæºåç§° var HProcExchBillNo = $("#HProcExchBillNo").val();//å·¥åºæµè½¬å¡ var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); if (ColName != 0 && Comparator != 0) { var com = ""; switch (Comparator) { case "7": com = "like'%" + ColContent + "%'"; break; case "8": com = "like'%" + ColContent + "'"; break; case "9": com = "like'" + ColContent + "%'"; break; case "10": com = "not like'%" + ColContent + "%'"; break; default: com = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName + " " + com; } if (HBillNo) sqlWhere += " and åæ®å· like '%" + HBillNo + "%'"; if (HNumber) sqlWhere += " and ç©æç¼ç like '%" + HNumber + "%'"; if (HName) sqlWhere += " and ç©æåç§° like '%" + HName + "%'"; if (HModel) sqlWhere += " and è§æ ¼åå· like '%" + HModel + "%'"; if (HLastResult) sqlWhere += " and å¤å®ç»è®º like '" + HLastResult + "%'"; if (HName1) sqlWhere += " and è´¨æ£ååç§° like '%" + HName1 + "%'"; if (HName2) sqlWhere += " and æ£éªé¡¹ç® like '%" + HName2 + "%'"; if (HName3) sqlWhere += " and çäº§èµæºåç§° like '%" + HName3 + "%'"; if (HProcExchBillNo) sqlWhere += " and å·¥åºæµè½¬å¡ like '%" + HProcExchBillNo + "%'"; if (HDate1) { sqlWhere += " and æ¥æ >= '" + HDate1 + "'"; @@ -417,6 +610,112 @@ var type = $(this).data('type'); active[type] ? active[type].call(this) : ''; }); //#region åå®¡æ ¸/å®¡æ ¸æ°æ® function set_CheckBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_Management/QC_PatrolProcCheckBillMainValue", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "IsAudit": num, "CurUserName": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#btnSearch").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } //#region åå ³é/å ³éæ°æ® function set_CloseBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_Management/CloseQC_PatrolProcCheckBillMain", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "Type": num, "user": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#btnSearch").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } //#region åä½åº/ä½åºæ°æ® function set_DropBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_Management/DropQC_PatrolProcCheckBillMain", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "Type": num, "user": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#btnSearch").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } //æ°å¢ function set_AddNew() { @@ -565,6 +864,33 @@ }) } //#region åææ¾ç¤ºä¸ææ¡ function ColFilter() { var Organization = '<option value="0" selected="selected" ></option>'; for (var i = 1; i < option.cols[0].length; i++) { if (option.cols[0][i].hide != true) { Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; } } $("#ColName").empty(); $("#ColName").append(Organization); form.render('select'); } //éåº function Pub_Close(closeType) { if (closeType == 1) { //å ³éå¼¹çª var index = parent.layer.getFrameIndex(window.name); parent.layer.close(index); } else if (closeType == 2) { //å ³éé¡µç¾ parent.layui.admin.events.closeThisTabs(); } } }); </script> </body> WebTM/views/ÖÊÁ¿¹ÜÀí/¹¤Ðò¼ìÑéµ¥/QC_ProcessCheckBillList.html
@@ -16,6 +16,7 @@ <script src="../../../layuiadmin/PubCustom.js"></script> <script src="../../../layuiadmin/HideButton.js"></script> <script src="../../../layuiadmin/soulTable.slim.js"></script> <!--<style type="text/css"> input.layui-input.layui-unselect { padding-right: 0; @@ -24,56 +25,175 @@ </head> <body> <div class="layui-fluid"> <div class="layui-col-md12"> <div class="layui-card" style="padding: 1px"> <div class="layui-card-body" style="padding: 1px;"> <form class="layui-form" action="" lay-filter="component-form-group"> <div class="layui-collapse"> <div class="layui-colla-item"> <div class="layui-inline"> <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 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" style="width: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"> <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"> <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-inline"> <label class="layui-form-label">ç©æç¼ç </label> <div class="layui-input-block" style="width: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"> <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"> <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"> <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"> <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"> <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"> <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo"> </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"> <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline" style="width:120px"> <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline" style="width:120px"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> </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> </div> <table class="" id="mainTable" lay-filter="mainTable"></table> <script type="text/html" id="toolbarDemo"> <div class="layui-btn-container"> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_AddNew" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>æ°å¢</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_ShowBill" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_DeleteBill" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>å é¤</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="get_Refresh" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_HideColumn" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_HideButton" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="get_Exit" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> </div> </script> <!--<div style="padding: 10px;"> <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" style="display:none;" id="set_AddNew" lay-event="set_AddNew"><i class="layui-icon layui-icon-file-b"></i>æ°å¢</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_ShowBill" lay-event="set_ShowBill"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_DeleteBill" lay-event="set_DeleteBill"><i class="layui-icon layui-icon-delete"></i>å é¤</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="get_Refresh" lay-event="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_HideColumn" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_HideButton" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Audit" id="AuditButton"><i class="layui-icon layui-icon-radio"></i>å®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeAudit" id="DeAuditButton"><i class="layui-icon layui-icon-circle"></i>åå®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Close" id="btn-Close"><i class="layui-icon layui-icon-radio"></i>å ³é</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeClose" id="btn-DeClose"><i class="layui-icon layui-icon-radio"></i>åå ³é</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Drop" id="btn-Drop"><i class="layui-icon layui-icon-radio"></i>ä½åº</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeDrop" id="btn-DeDrop"><i class="layui-icon layui-icon-radio"></i>åä½åº</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="get_Exit" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> </div> </script> <!--<div style="padding: 10px;"> <button type="button" lay-submit="" class="layui-btn layui-btn-radius" lay-filter="btnReSearch" style="padding:0 5px">éç½®</button> <button type="button" lay-submit="" class="layui-btn layui-btn-radius" lay-filter="btndelete" style="padding:0 5px">å é¤</button>--> <!--<button type="button" lay-submit="" class="layui-btn layui-btn-radius" lay-filter="btnAdd" style="padding:0 5px">æ°å¢</button>--> <!--<button type="button" lay-submit="" class="layui-btn layui-btn-radius" lay-filter="btnModify" style="padding:0 5px">ä¿®æ¹</button> <!--<button type="button" lay-submit="" class="layui-btn layui-btn-radius" lay-filter="btnAdd" style="padding:0 5px">æ°å¢</button>--> <!--<button type="button" lay-submit="" class="layui-btn layui-btn-radius" lay-filter="btnModify" style="padding:0 5px">ä¿®æ¹</button> <button type="button" lay-submit="" class="layui-btn layui-btn-radius" lay-filter="btnJY" style="padding:0 5px">ç¦ç¨</button> <button type="button" lay-submit="" class="layui-btn layui-btn-radius" lay-filter="btnFJY" style="padding:0 5px">åç¦ç¨</button> </div>--> </form> </form> </div> </div> </div> </div> </div> <!--<script src="../../../layuiadmin/layui/layui.js"></script> <!--<script src="../../../layuiadmin/layui/layui.js"></script> <script src="../../../layuiadmin/Scripts/json2.js"></script> <script src="../../../layuiadmin/Scripts/jquery-1.4.1.js"></script> <script src="../../../layuiadmin/Scripts/webConfig.js"></script>--> <script> <script> layui.config({ base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ }).extend({ @@ -101,7 +221,12 @@ //#endregion //#region å¤´å·¥å ·æ äºä»¶ laydate.render({ elem: '#HDate1' }); laydate.render({ elem: '#HDate2' }); table.on('toolbar(mainTable)', function (obj) { switch (obj.event) { //æ°å¢ @@ -115,6 +240,33 @@ break; //å·æ° case 'get_Refresh': get_Refresh(); break; //éåºæé® case 'get_Exit': Pub_Close(2); break; //å®¡æ ¸æé® case 'btn-Audit': set_CheckBill(0); break; //åå®¡æ ¸æé® case 'btn-DeAudit': set_CheckBill(1); break; //å ³éæé® ï¼1:å ³éã2:åå ³éï¼ case 'btn-Close': set_CloseBill(1); break; //åå ³éæé® case 'btn-DeClose': set_CloseBill(2); break; //ä½åºæé® ï¼1:ä½åºã2:åä½åºï¼ case 'btn-Drop': set_DropBill(1); break; //åä½åºæé® case 'btn-DeDrop': set_DropBill(2); break; //å设置 case 'set_HideColumn': get_HideColumn(); @@ -140,9 +292,79 @@ //#region æ¥è¯¢æé® form.on('submit(btnSearch)', function (data) { get_FastQuery(); var sqlWhere = " "; var HBillNo = $("#HBillNo").val();//åæ®å· var HNumber = $("#HNumber").val();//ç©æç¼ç var HName = $("#HName").val();//ç©æåç§° var HModel = $("#HModel").val();//è§æ ¼åå· var HDate1 = $("#HDate1").val();//å¼å§æ¥æ var HDate2 = $("#HDate2").val();//ç»ææ¥æ var HLastResult = $("#HLastResult").val();//å¤å®ç»è®º var HName1 = $("#HName1").val();//è´¨æ£ååç§° var HName2 = $("#HName2").val();//æ£éªé¡¹ç® var HName3 = $("#HName3").val();//çäº§èµæºåç§° var HProcExchBillNo = $("#HProcExchBillNo").val();//å·¥åºæµè½¬å¡ var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); if (ColName != 0 && Comparator != 0) { var com = ""; switch (Comparator) { case "7": com = "like'%" + ColContent + "%'"; break; case "8": com = "like'%" + ColContent + "'"; break; case "9": com = "like'" + ColContent + "%'"; break; case "10": com = "not like'%" + ColContent + "%'"; break; default: com = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName + " " + com; } if (HBillNo) sqlWhere += " and åæ®å· like '%" + HBillNo + "%'"; if (HNumber) sqlWhere += " and ç©æç¼ç like '%" + HNumber + "%'"; if (HName) sqlWhere += " and ç©æåç§° like '%" + HName + "%'"; if (HModel) sqlWhere += " and è§æ ¼åå· like '%" + HModel + "%'"; if (HLastResult) sqlWhere += " and å¤å®ç»è®º like '" + HLastResult + "%'"; if (HName1) sqlWhere += " and è´¨æ£ååç§° like '%" + HName1 + "%'"; if (HName2) sqlWhere += " and æ£éªé¡¹ç® like '%" + HName2 + "%'"; if (HName3) sqlWhere += " and çäº§èµæºåç§° like '%" + HName3 + "%'"; if (HProcExchBillNo) sqlWhere += " and å·¥åºæµè½¬å¡ like '%" + HProcExchBillNo + "%'"; if (HDate1) { sqlWhere += " and æ¥æ >= '" + HDate1 + "'"; } if (HDate2) { sqlWhere += " and æ¥æ <= '" + HDate2 + "'"; } get_FastQuery(sqlWhere); }); //#endregion //å·æ° function get_Refresh() { $("#btnSearch").trigger('click'); } //#region åå§åçé¢ function set_ClearBill() { @@ -285,9 +507,9 @@ DisPlay_HideColumn(); table.render(option); //if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { // ColFilter(); //} if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } //å·æ°æé®æ¾ç¤º var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ @@ -327,8 +549,8 @@ // } //}); //#region å¿«éè¿æ»¤ function get_FastQuery() { var HBillNo = $("#HBillNo").val();//åæ®å· function get_FastQuery(sWhere) { //var HBillNo = $("#HBillNo").val();//åæ®å· get_Display(sWhere); sWhere = "";//è°ç¨æ¥å£åæ¸ ç©ºsWhereç¼å @@ -341,6 +563,113 @@ sWhere = ""; } //#endregion //#region åå®¡æ ¸/å®¡æ ¸æ°æ® function set_CheckBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_ProcessCheckBill/QC_ProcessCheckBillMainValue", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "IsAudit": num, "CurUserName": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#btnSearch").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } //#region åå ³é/å ³éæ°æ® function set_CloseBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_ProcessCheckBill/CloseQC_ProcessCheckBillMain", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "Type": num, "user": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#btnSearch").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } //#region åä½åº/ä½åºæ°æ® function set_DropBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_ProcessCheckBill/DropQC_ProcessCheckBillMain", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "Type": num, "user": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#btnSearch").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } //#region æ°å¢ function set_AddNew() { @@ -630,6 +959,31 @@ }) } //#region åææ¾ç¤ºä¸ææ¡ function ColFilter() { var Organization = '<option value="0" selected="selected" ></option>'; for (var i = 1; i < option.cols[0].length; i++) { if (option.cols[0][i].hide != true) { Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; } } $("#ColName").empty(); $("#ColName").append(Organization); form.render('select'); } //éåº function Pub_Close(closeType) { if (closeType == 1) { //å ³éå¼¹çª var index = parent.layer.getFrameIndex(window.name); parent.layer.close(index); } else if (closeType == 2) { //å ³éé¡µç¾ parent.layui.admin.events.closeThisTabs(); } } ////æ¥è¯¢æé® //form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ // //var HBillType = $("#HBillType").val();//åæ®ç±»å @@ -700,7 +1054,7 @@ </script> </script> </body> </html> WebTM/views/ÖÊÁ¿¹ÜÀí/Ê×¼þ¼ìÑéµ¥/QC_FirstPieceCheckBillList.html
@@ -29,32 +29,133 @@ <div class="layui-card-body"> <!--<div class="test-table-reload-btn" style="margin-bottom: 10px;">--> <form class="layui-form" action=""> <div class="layui-form-item"> <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"> <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" style="width: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"> <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"> <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-inline"> <label class="layui-form-label">ç©æç¼ç </label> <div class="layui-input-block" style="width: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" > <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"> <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"> <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"> <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"> <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"> <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo"> </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"> <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> </select> </div> </div> <div class="layui-inline" style="width:120px"> <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;"> <option value="0" selected="selected"></option> <option value="=">=</option> <option value=">=">>=</option> <option value=">">></option> <option value="<="><=</option> <option value="<"><</option> <option value="<>"><></option> <option value="7">å å«</option> <option value="8">å·¦å å«</option> <option value="9">å³å å«</option> <option value="10">ä¸å å«</option> </select> </div> <div class="layui-inline" style="width:120px"> <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> </div> </div> </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"> <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> </button> </div> </div> </form> @@ -79,6 +180,14 @@ <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="btn-Delete" lay-event="btn-Delete"><i class="layui-icon layui-icon-form"></i>å é¤</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" id="set_HideColumn" lay-event="set_HideColumn"><i class="layui-icon layui-icon-form"></i>å设置</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_HideButton" id="HideButton"><i class="layui-icon layui-icon-form"></i>æé®è®¾ç½®</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Refresh" id="RefreshButton"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Audit" id="AuditButton"><i class="layui-icon layui-icon-radio"></i>å®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeAudit" id="DeAuditButton"><i class="layui-icon layui-icon-circle"></i>åå®¡æ ¸</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Close" id="btn-Close"><i class="layui-icon layui-icon-radio"></i>å ³é</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeClose" id="btn-DeClose"><i class="layui-icon layui-icon-radio"></i>åå ³é</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-Drop" id="btn-Drop"><i class="layui-icon layui-icon-radio"></i>ä½åº</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="btn-DeDrop" id="btn-DeDrop"><i class="layui-icon layui-icon-radio"></i>åä½åº</button> <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="get_Exit" id="ExitButton"><i class="layui-icon layui-icon-logout"></i>éåº</button> </div> </script> </div> @@ -306,8 +415,147 @@ var HBillType = "7505"; get_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]); break; //å·æ° case 'get_Refresh': get_Refresh(); break; //éåºæé® case 'get_Exit': Pub_Close(2); break; //å®¡æ ¸æé® case 'btn-Audit': set_CheckBill(0); break; //åå®¡æ ¸æé® case 'btn-DeAudit': set_CheckBill(1); break; //å ³éæé® ï¼1:å ³éã2:åå ³éï¼ case 'btn-Close': set_CloseBill(1); break; //åå ³éæé® case 'btn-DeClose': set_CloseBill(2); break; //ä½åºæé® ï¼1:ä½åºã2:åä½åºï¼ case 'btn-Drop': set_DropBill(1); break; //åä½åºæé® case 'btn-DeDrop': set_DropBill(2); break; }; }); //å·æ° function get_Refresh() { $("#f_Query").trigger('click'); } //#region åå®¡æ ¸/å®¡æ ¸æ°æ® function set_CheckBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_ValueTable/QC_FirstPieceCheckValue", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "IsAudit": num, "CurUserName": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#f_Query").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } //#region åå ³é/å ³éæ°æ® function set_CloseBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_ValueTable/CloseQC_FirstPieceCheckBill", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "Type": num, "user": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#f_Query").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } //#region åä½åº/ä½åºæ°æ® function set_DropBill(num) { var checkStatus = table.checkStatus('mainTable') , data = checkStatus.data; if (checkStatus.data.length === 1) { var InterID = data[0].hmainid.toString(); //é»è¾å®¡æ ¸æ¹æ³ $.ajax({ type: "GET", url: GetWEBURL() + "/QC_ValueTable/DropQC_FirstPieceCheckBills", //æ¹æ³æå¨é¡µé¢åæ¹æ³å data: { "HInterID": InterID, "Type": num, "user": 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); //ä¿®æ¹ä¸ºååå·æ°çé¢ $("#f_Query").trigger('click'); }); } else { layer.alert(result.code + result.Message, { icon: 5 }); } }, error: function () { layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); } }); } else { layer.msg('è¯·éæ©ä¸è¡æ°æ®å®¡æ ¸ï¼'); } } ///å è½½æ¾ç¤ºæ°æ® //function RoadHBillNo(sqlWhere) { @@ -397,9 +645,9 @@ DisPlay_HideColumn(); table.render(option); //if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { // ColFilter(); //} if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { ColFilter(); } //å·æ°æé®æ¾ç¤º var btns = document.getElementsByTagName("button"); //è·åæ¬é¡µæææé®å¯¹è±¡ var HBillType = "7505"; @@ -505,24 +753,61 @@ //if ($("#HStatus").val() != "") // sqlWhere += " and ç¶æ like ^^%" + $("#HStatus").val() + "%^^"; var HBillNo = $("#HBillNo").val();//åæ®å· var HNumber = $("#HNumber").val();//ç©æä»£ç var HNumber = $("#HNumber").val();//ç©æç¼ç var HName = $("#HName").val();//ç©æåç§° var HModel = $("#HModel").val();//è§æ ¼åå· var HDate1 = $("#HDate1").val();//å¼å§æ¥æ var HDate2 = $("#HDate2").val();//ç»ææ¥æ var HDate2 = $("#HDate2").val();//ç»ææ¥æ var HLastResult = $("#HLastResult").val();//å¤å®ç»è®º var HName1 = $("#HName1").val();//è´¨æ£ååç§° var HName2 = $("#HName2").val();//æ£éªé¡¹ç® var HName3 = $("#HName3").val();//çäº§èµæºåç§° var HProcExchBillNo = $("#HProcExchBillNo").val();//å·¥åºæµè½¬å¡ var ColName = $("#ColName").val();//å¤éæ¡ var Comparator = $("#Comparator").val() var ColContent = $("#ColContent").val(); if (ColName != 0 && Comparator != 0) { var com = ""; switch (Comparator) { case "7": com = "like'%" + ColContent + "%'"; break; case "8": com = "like'%" + ColContent + "'"; break; case "9": com = "like'" + ColContent + "%'"; break; case "10": com = "not like'%" + ColContent + "%'"; break; default: com = "" + Comparator + "'" + ColContent + "'"; break; } sWhere += " and " + ColName + " " + com; } if (HBillNo) sqlWhere += " and åæ®å· like '%" + HBillNo+ "%'"; if (HNumber) sqlWhere += " and ç©æä»£ç like '%" + HNumber + "%'"; sqlWhere += " and ç©æç¼ç like '%" + HNumber + "%'"; if (HName) sqlWhere += " and ç©æåç§° like '%" + HName + "%'"; if (HModel) sqlWhere += " and è§æ ¼åå· like '%" + HModel + "%'"; //if ($("#HClStatus").val() != "") // sqlWhere += " and å ³éç¶æ like ^^%" + $("#HClStatus").val() + "%^^"; //if ($("#HPURCHASEORGID").val() != "") // sqlWhere += " and éè´ç»ç» like ^^%" + $("#HPURCHASEORGID").val() + "%^^"; if (HLastResult) sqlWhere += " and å¤å®ç»è®º like '" + HLastResult + "%'"; if (HName1) sqlWhere += " and è´¨æ£ååç§° like '%" + HName1 + "%'"; if (HName2) sqlWhere += " and æ£éªé¡¹ç® like '%" + HName2 + "%'"; if (HName3) sqlWhere += " and çäº§èµæºåç§° like '%" + HName3 + "%'"; if (HProcExchBillNo) sqlWhere += " and å·¥åºæµè½¬å¡ like '%" + HProcExchBillNo + "%'"; if (HDate1) { sqlWhere += " and æ¥æ >= '" + HDate1 + "'"; } @@ -538,7 +823,10 @@ // sqlWhere += " and æªå ³èæ°é > 0"; // } //} //if ($("#HClStatus").val() != "") // sqlWhere += " and å ³éç¶æ like ^^%" + $("#HClStatus").val() + "%^^"; //if ($("#HPURCHASEORGID").val() != "") // sqlWhere += " and éè´ç»ç» like ^^%" + $("#HPURCHASEORGID").val() + "%^^"; var Time = $("#Time").val(); var dd = new Date(); @@ -778,6 +1066,19 @@ } }) } //#region åææ¾ç¤ºä¸ææ¡ function ColFilter() { var Organization = '<option value="0" selected="selected" ></option>'; for (var i = 1; i < option.cols[0].length; i++) { if (option.cols[0][i].hide != true) { Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; } } $("#ColName").empty(); $("#ColName").append(Organization); form.render('select'); } }); </script> </body>