| File was renamed from WebTM/views/²Ö´æ¹ÜÀí/²Ö¿âµ÷²¦/Cc_LookingForBillList.html |
| | |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| | | <title>䏿¶æ¾è´§åå表</title> |
| | | <title>æ¾è´§åå表</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/layui/css/layui.css" media="all"> |
| | | <link rel="stylesheet" href="../../../layuiadmin/style/admin.css" media="all"> |
| | | <script src="../../../layuiadmin/layui/layui.js"></script> |
| | | |
| | | <style type="text/css"> |
| | | input.layui-input.layui-unselect { |
| | | padding-right: 0; |
| | | } |
| | | </style> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width:60px;padding-left:0px;">åæ®ç±»å</label> |
| | | <label class="layui-form-label">åæ®ç±»å</label> |
| | | <div class="layui-input-block"> |
| | | <select name="HBillType" id="HBillType"> |
| | | <option value="">ææ</option> |
| | | <option value="ZHXJ">䏿¶æ¾è´§å</option> |
| | | <option value="ZHSJ">䏿¶å½è¿å</option> |
| | | </select> |
| | |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æºåå·</label> |
| | | <label class="layui-form-label">å¶å人</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HSourceBillNo" id="HSourceBillNo"> |
| | | <input type="text" class="layui-input" name="HCreateBy" id="HCreateBy"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">éç½®</button> |
| | | |
| | | <div class="layui-colla-content"> |
| | | <div class="layui-inline"> |
| | | <div class="layui-inline"> |
| | | <span>å
¶ä»æ¡ä»¶></span> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¶å人</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HCreateBy" id="HCreateBy"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | <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 src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | <script> |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage','laydate'], function () { |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | | , table = layui.table |
| | | , form = layui.form |
| | | , element = layui.element |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | //var sWhere = " 产å代ç = 'BX0002'"; |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | | , table = layui.table |
| | | , form = layui.form |
| | | , element = layui.element |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , util = layui.util |
| | | //æ¥è¯¢æ¡ä»¶ |
| | | var sWhere = ""; |
| | | |
| | | var option = { |
| | | elem: '#mainTable' |
| | | //, toolbar: '#toolbarDemo' |
| | | ,height: 'full-50' |
| | | , height: 'full-50' |
| | | , page: true |
| | | ,cellMinWidth: 90 |
| | | , cellMinWidth: 90 |
| | | , cols: [[ |
| | | //{ field: 'hmainid', title: 'hmainid', width: 110 } |
| | | { field: 'åæ®å·', title: 'åæ®å·', sort: true, width: 165 } |
| | | , { field: 'åæ®ç±»å', title: 'åæ®ç±»å' } |
| | | , { field: 'å·¥èºåç§°', title: 'å·¥èºåç§°', width: 170 } |
| | | //, { field: 'hmaterid', title: 'hmaterid', width: 165 } |
| | | , { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 160 } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 160 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 215 } |
| | | , { field: '计éåä½ä»£ç ', title: '计éåä½ä»£ç ', width: 115 } |
| | | , { field: '计éåä½', title: '计éåä½' } |
| | | , { field: 'é»è®¤å·¥èº', title: 'é»è®¤å·¥èº' } |
| | | , { field: 'è¡¨å¤´å¤æ³¨', title: 'è¡¨å¤´å¤æ³¨' } |
| | | //, { field: 'hsubid', title: 'hsubid', width: 80 } |
| | | , { field: 'å·¥åºå·', title: 'å·¥åºå·' } |
| | | , { field: 'å§å¤æ è®°', title: 'å§å¤æ è®°' } |
| | | //, { field: 'hprocid', title: 'hprocid', width: 105 } |
| | | , { field: 'å·¥åºä»£ç ', title: 'å·¥åºä»£ç ' } |
| | | , { field: 'å·¥åº', title: 'å·¥åº' } |
| | | //, { field: 'HSupID', title: 'HSupID', width: 105 } |
| | | , { field: 'ä¾åºå代ç ', title: 'ä¾åºå代ç ' } |
| | | , { field: 'ä¾åºå', title: 'ä¾åºå' } |
| | | //, { field: 'HCenterID', title: 'HCenterID', width: 105 } |
| | | , { field: 'å·¥ä½ä¸å¿ä»£ç ', title: 'å·¥ä½ä¸å¿ä»£ç ', width: 115 } |
| | | , { field: 'å·¥ä½ä¸å¿åç§°', title: 'å·¥ä½ä¸å¿åç§°', width: 115 } |
| | | , { field: 'æ¶é´åä½', title: 'æ¶é´åä½' } |
| | | , { field: 'è¿è¡æ¶é´', title: 'è¿è¡æ¶é´' } |
| | | , { field: 'å å·¥æ°é', title: 'å å·¥æ°é' } |
| | | , { field: 'å夿¶é´', title: 'å夿¶é´' } |
| | | , { field: 'æéæ¶é´', title: 'æéæ¶é´' } |
| | | , { field: '转移æ¶é´', title: '转移æ¶é´' } |
| | | , { field: 'è¯ç', title: 'è¯ç' } |
| | | , { field: '累计è¯ç', title: '累计è¯ç' } |
| | | , { field: '表ä½å¤æ³¨', title: '表ä½å¤æ³¨' } |
| | | , { field: 'å¶å人', title: 'å¶å人' } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ' } |
| | | , { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº' } |
| | | , { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ' } |
| | | , { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº' } |
| | | , { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ' } |
| | | , { field: 'ä½åºäºº', title: 'ä½åºäºº' } |
| | | , { field: 'ä½åºæ¥æ', title: 'ä½åºæ¥æ' } |
| | | //, { field: 'HDayWorkQty', title: 'HDayWorkQty', width: 105 } |
| | | //, { field: 'HGroupID', title: 'HGroupID', width: 105 } |
| | | //, { field: 'HWorkerID', title: 'HWorkerID', width: 105 } |
| | | //, { field: 'HSourceID', title: 'HSourceID', width: 105 } |
| | | , { field: 'å å·¥åä»·', title: 'å å·¥åä»·' } |
| | | //, { field: 'HNextProcFlag', title: 'HNextProcFlag', width: 105 } |
| | | , { field: 'ä¸éæµè½¬å·¥åº', title: 'ä¸éæµè½¬å·¥åº'} |
| | | , { field: 'æµè½¬å·¥åº', title: 'æµè½¬å·¥åº' } |
| | | { field: 'HInterID', title: '忮ID', hide: true } |
| | | , { field: 'HBillNo', title: 'åæ®å·',width: 160 } |
| | | , { field: 'HStatus', title: 'å¨åºç¶æ', width: 200 } |
| | | , { field: 'HGroupID', title: 'çç»ID', hide: true } |
| | | , { field: 'HGroup', title: 'çç»' } |
| | | , { field: 'HSourceID', title: 'çäº§èµæºID', hide: true } |
| | | , { field: 'HSource', title: 'çäº§èµæº', width: 115 } |
| | | , { field: 'HCreateBy', title: 'å¶å人' } |
| | | , { |
| | | field: 'HCreateDate', title: 'å¶åæ¶é´', width: 110, templet: function (d) { |
| | | if (d.HCreateDate == null) { |
| | | return ""; |
| | | } |
| | | return util.toDateString(d.HCreateDate, "yyyy-MM-dd"); |
| | | } |
| | | } |
| | | , { field: 'HMaterID', title: 'ç©æID', hide: true } |
| | | , { field: 'HMaterNumber', title: 'ç©æç¼ç ', width: 130 } |
| | | , { field: 'HMaterName', title: 'ç©æåç§°', width: 120 } |
| | | , { field: 'HMaterModel', title: 'è§æ ¼åå·' } |
| | | , { field: 'HBarCode', title: 'æ¡ç ', width: 175 } |
| | | , { field: 'HBarCodeType', title: 'æ¡ç ç±»å' } |
| | | ]] |
| | | }; |
| | | |
| | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL() + '/LEMS/MES_Gy_RoutingBillList_Json', |
| | | url: GetWEBURL() + '/LookingFor/GetLookingForBillList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | data: { "sWhere": sWhere, "HBillType": "" }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | |
| | | layer.close(index); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | $("#WorkCenter").val("");//åæ®å· |
| | | $("#hnumber").val("");//ç©æ |
| | | $("#HOrderProcNO").val("");//åæ®ç±»å |
| | | $("#HBillType").val("");//åæ®ç±»å |
| | | $("#HBillNo").val("");//åæ®å· |
| | | $("#HSourceBillNo").val("");//æºåå· |
| | | $("#HCreateBy").val("");//å¶å人 |
| | | $("#BenginHCreateDate").val("");//å¼å§å¶åæ¶é´ |
| | | $("#EndHCreateDate").val("");//ç»æå¶åæ¶é´ |
| | | $("#btnSearch").click(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ |
| | | var HOrderProcNO = $("#HOrderProcNO").val();//åæ®ç±»å |
| | | var hnumber = $("#hnumber").val();//ç©æ |
| | | var WorkCenter = $("#WorkCenter").val();//åæ®å· |
| | | if (HOrderProcNO) { |
| | | sWhere += " and åæ®ç±»å like '%" + HOrderProcNO + "%'"; |
| | | var HBillType = $("#HBillType").val();//åæ®ç±»å |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HCreateBy = $("#HCreateBy").val();//å¶å人 |
| | | var BenginHCreateDate = $("#BenginHCreateDate").val();//å¼å§å¶åæ¶é´ |
| | | var EndHCreateDate = $("#EndHCreateDate").val();//ç»æå¶åæ¶é´ |
| | | if (HBillNo) { |
| | | sWhere += " and HBillNo like '%" + HBillNo + "%'"; |
| | | } |
| | | if (hnumber) { |
| | | sWhere += " and ç©æä»£ç like '%" + hnumber + "%' or ç©æåç§° like '%" + hnumber + "%'" |
| | | if (HCreateBy) { |
| | | sWhere += " and HCreateBy like '%" + HCreateBy + "%'"; |
| | | } |
| | | if (WorkCenter) { |
| | | sWhere += " and åæ®å· like '%" + WorkCenter + "%'"; |
| | | if (BenginHCreateDate) { |
| | | sWhere += " and CONVERT(varchar(100),HCreateDate, 23) >= '" + BenginHCreateDate + "'"; |
| | | } |
| | | if (EndHCreateDate) { |
| | | sWhere += " and CONVERT(varchar(100),HCreateDate, 23) <= '" + EndHCreateDate + "'"; |
| | | } |
| | | var index = layer.load(0); |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL1() + '/LEMS/MES_Gy_RoutingBillList_Json', |
| | | url: GetWEBURL1() + '/LookingFor/GetLookingForBillList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | data: { "sWhere": sWhere, "HBillType": HBillType }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.close(index); |
| | | layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } else { |
| | | layer.close(index); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(index); |
| | | layer.alert("æ¥å£å¤±æ!", { icon: 5 }); |
| | | } |
| | | }); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | //è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | sWhere = ""; |
| | | //$("#HBillType").val("");//åæ®ç±»å |
| | | //$("#HBillNo").val("");//åæ®å· |
| | | //$("#HSourceBillNo").val("");//æºåå· |
| | | //$("#HCreateBy").val("");//å¶å人 |
| | | //$("#BenginHCreateDate").val("");//å¼å§å¶åæ¶é´ |
| | | //$("#EndHCreateDate").val("");//ç»æå¶åæ¶é´ |
| | | }); |
| | | |
| | | //çå¬è¡åå»äºä»¶ |
| | | table.on('rowDouble(mainTable)', function (obj) { |
| | | layer.alert("åå»äºä»¶", { icon: 1 }); |
| | | }); |
| | | |
| | | |
| | |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | </script> |