| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> |
| | | <title>å·¥åºè¿ç«æ¥æ¶åå表</title> |
| | | <meta name="renderer" content="webkit"> |
| | | <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=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> |
| | | |
| | | <script src="../../layuiadmin/layui/lay/modules/util.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> |
| | | |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | </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="date" class="layui-input" id="HDate"> |
| | | <input type="date" class="layui-input" id="è¿ç«æ¶é´"> |
| | | </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="date" class="layui-input" id="HDate1"> |
| | | <input type="text" class="layui-input" name="ä»»å¡å" id="ä»»å¡å"> |
| | | </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="HOrderProcNO" id="HOrderProcNO"> |
| | | <input type="text" class="layui-input" name="åæ®å·" id="åæ®å·"> |
| | | </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"> |
| | |
| | | </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="WorkCenter" id="WorkCenter"> |
| | | <input type="text" class="layui-input" name="å·¥åºæµè½¬å¡å·" id="å·¥åºæµè½¬å¡å·"> |
| | | </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="HProcExchBillNo" id="HProcExchBillNo"> |
| | | <input type="text" class="layui-input" name="产ååç§°" id="产ååç§°"> |
| | | </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="HMaker" id="HMaker"> |
| | | <input type="text" class="layui-input" name="ç产çç»" id="ç产çç»"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | </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="hname" id="hname"> |
| | | <input type="text" class="layui-input" name="æä½å" id="æä½å"> |
| | | </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="hnumber" id="hnumber"> |
| | | <input type="text" class="layui-input" name="客æ·ä¿¡æ¯" id="客æ·ä¿¡æ¯"> |
| | | </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="hmodel" id="hmodel"> |
| | | <input type="text" class="layui-input" name="è系人信æ¯" id="è系人信æ¯"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <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 type="text/html" id="toolBar"> |
| | | <a class="layui-btn layui-btn-xs" lay-event="del" style="background-color: red;">å é¤</a> |
| | | </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','util'], function () { |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | | , table = layui.table |
| | | , form = layui.form |
| | | , element = layui.element |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , 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 = " 产å代ç = 'BX0002'"; |
| | | var sWhere = ""; |
| | | |
| | | var option = { |
| | | elem: '#mainTable' |
| | | //, toolbar: '#toolbarDemo' |
| | | ,height: 'full-50' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , cols: [[ |
| | | //{ field: 'HEmpID', title: 'HEmpID', sort: true, width: 110 } |
| | |
| | | //, { field: 'HMaterID', title: 'HMaterID', sort: true, width: 165 } |
| | | //, { field: 'HProcID', title: 'HProcID', width: 175 } |
| | | //, { field: 'HSourceID', title: 'HSourceID', width: 170 } |
| | | { field: 'è¿ç«æ¶é´', title: 'è¿ç«æ¶é´', width: 120 } |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 80 } |
| | | , { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 165 } |
| | | , { field: '产å代ç ', title: '产å代ç ', width: 100 } |
| | | , { field: '产ååç§°', title: '产ååç§°', width: 100 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 100 } |
| | | , { field: 'å½åå·¥åº', title: 'å½åå·¥åº', width: 100 } |
| | | , { field: 'LOTæ°é', title: 'è®¢åæ°é', width: 100 } |
| | | , { field: 'æ¥æ¶æ°é', title: 'æ¥æ¶æ°é', width: 100 } |
| | | , { field: 'ç产çç»', title: 'ç产çç»', width: 100 } |
| | | { |
| | | field: 'è¿ç«æ¶é´', title: 'è¿ç«æ¶é´', width: 105, templet: function (d) { |
| | | if (d.è¿ç«æ¶é´ == null) { |
| | | return ""; |
| | | } |
| | | return util.toDateString(d.è¿ç«æ¶é´, "yyyy-MM-dd"); |
| | | } |
| | | } |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 100 } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', width: 140 } |
| | | , { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 145 } |
| | | , { field: '产å代ç ', title: '产å代ç ', width: 145 } |
| | | , { field: '产ååç§°', title: '产ååç§°', width: 160 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·', width: 90 } |
| | | , { field: 'å½åå·¥åº', title: 'å½åå·¥åº', width: 90 } |
| | | , { field: 'LOTæ°é', title: 'è®¢åæ°é', width: 90 } |
| | | , { field: 'æ¥æ¶æ°é', title: 'æ¥æ¶æ°é', width: 90 } |
| | | , { field: 'ç产çç»', title: 'ç产çç»', width: 90 } |
| | | , { field: 'çäº§èµæº', title: 'çäº§èµæº', width: 100 } |
| | | , { field: 'æä½å', title: 'æä½å', width: 100 } |
| | | , { field: 'æä½å', title: 'æä½å', width: 80 } |
| | | , { field: '客æ·ä¿¡æ¯', title: '客æ·ä¿¡æ¯', width: 250 } |
| | | , { field: 'è系人信æ¯', title: 'è系人信æ¯', width: 100 } |
| | | , { toolbar: '#toolBar', width: 65, fixed: 'right' } |
| | | //, { field: 'hmainid', title: 'hmainid', width: 160 } |
| | | //, { field: 'å½åå·¥åºä»£ç ', title: 'å½åå·¥åºä»£ç ', width: 80 } |
| | | //, { field: 'æä½å代ç ', title: 'æä½å代ç ', width: 80 } |
| | | //, { field: 'ç产çç»ä»£ç ', title: 'ç产çç»ä»£ç ', width: 80 } |
| | | //, { field: 'çäº§èµæºä»£ç ', title: 'çäº§èµæºä»£ç ', width: 105 } |
| | | |
| | | ]] |
| | | }; |
| | | |
| | | //çå¬è¡¨æ ¼ä¸è¡å·¥å
·äºä»¶ |
| | | table.on('tool(mainTable)', function (obj) { //注ï¼tool æ¯å·¥å
·æ¡äºä»¶åï¼test æ¯ table åå§å®¹å¨ç屿§ lay-filter="对åºçå¼" |
| | | var data = obj.data //è·å¾å½åè¡æ°æ® |
| | | , layEvent = obj.event; //è·å¾ lay-event 对åºçå¼ |
| | | if (layEvent === 'detail') { |
| | | layer.msg('æ¥çæä½'); |
| | | } else if (layEvent === 'del') { |
| | | layer.confirm('ççå é¤è¡ä¹', function (index) { |
| | | layer.msg(JSON.stringify(obj.data), { icon: 1, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨æç¤º" }); |
| | | obj.del(); //å é¤å¯¹åºè¡ï¼trï¼çDOMç»æ |
| | | layer.close(index); |
| | | //åæå¡ç«¯åéå 餿令 |
| | | }); |
| | | } else if (layEvent === 'edit') { |
| | | layer.msg('ç¼è¾æä½'); |
| | | } |
| | | }); |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL1() + '/api/newBill/getStationInBillList', |
| | | url: GetWEBURL() + '/api/newBill/getStationInBillList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | |
| | | skin: 'layui-layer-lan', title: "温馨æç¤º" |
| | | }); |
| | | } |
| | | }); |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | $("#HDate").val("");//å¼å§æ¥æ |
| | | $("#HDate1").val("");//ç»ææ¥æ |
| | | $("#HOrderProcNO").val("");//订åè·è¸ªå· |
| | | $("#WorkCenter").val("");//å·¥ä½ä¸å¿ |
| | | $("#HProcExchBillNo").val("");//æµè½¬å¡å· |
| | | $("#HMaker").val("");//å¶å人 |
| | | $("#hname").val("");//产ååç§° |
| | | $("#hnumber").val("");//产å代ç |
| | | $("#hmodel").val("");//è§æ ¼åå· |
| | | $("#è¿ç«æ¶é´").val("");//è¿ç«æ¶é´ |
| | | $("#ä»»å¡å").val("");//ä»»å¡å |
| | | $("#åæ®å·").val("");//åæ®å· |
| | | $("#å·¥åºæµè½¬å¡å·").val("");//å·¥åºæµè½¬å¡å· |
| | | $("#产ååç§°").val("");//产ååç§° |
| | | $("#ç产çç»").val("");//ç产çç» |
| | | $("#æä½å").val("");//æä½å |
| | | $("#客æ·ä¿¡æ¯").val("");//客æ·ä¿¡æ¯ |
| | | $("#è系人信æ¯").val("");//èç³»äººä¿¡æ¯ |
| | | $("#btnSearch").click(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ |
| | | var HDate = $("#HDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HDate1").val();//ç»ææ¥æ |
| | | var HOrderProcNO = $("#HOrderProcNO").val();//订åè·è¸ªå· |
| | | var WorkCenter = $("#WorkCenter").val();//å·¥ä½ä¸å¿ |
| | | var HProcExchBillNo = $("#HProcExchBillNo").val();//æµè½¬å¡å· |
| | | var HMaker = $("#HMaker").val();//å¶å人 |
| | | var hname = $("#hname").val();//产ååç§° |
| | | var hnumber = $("#hnumber").val();//产å代ç |
| | | var hmodel = $("#hmodel").val();//è§æ ¼åå· |
| | | if (HDate) { |
| | | sWhere += " and æ¥æ >= '" + HDate + "'"; |
| | | var è¿ç«æ¶é´ = $("#è¿ç«æ¶é´").val();//è¿ç«æ¶é´ |
| | | var ä»»å¡å = $("#ä»»å¡å").val();//ä»»å¡å |
| | | var åæ®å· = $("#åæ®å·").val();//åæ®å· |
| | | var å·¥åºæµè½¬å¡å· = $("#å·¥åºæµè½¬å¡å·").val();//å·¥åºæµè½¬å¡å· |
| | | var 产ååç§° = $("#产ååç§°").val();//产ååç§° |
| | | var ç产çç» = $("#ç产çç»").val();//ç产çç» |
| | | var æä½å = $("#æä½å").val();//æä½å |
| | | var 客æ·ä¿¡æ¯ = $("#客æ·ä¿¡æ¯").val();//客æ·ä¿¡æ¯ |
| | | var èç³»äººä¿¡æ¯ = $("#è系人信æ¯").val();//èç³»äººä¿¡æ¯ |
| | | if (è¿ç«æ¶é´) { |
| | | sWhere += " and CONVERT(varchar(100),è¿ç«æ¶é´, 23) = '" + è¿ç«æ¶é´ + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and æ¥æ <= '" + HDate1 + "'"; |
| | | if (ä»»å¡å) { |
| | | sWhere += " and ä»»å¡å like '%" + ä»»å¡å + "%'"; |
| | | } |
| | | if (HOrderProcNO) { |
| | | sWhere += " and 订åè·è¸ªå· like '%" + HOrderProcNO + "%'"; |
| | | if (åæ®å·) { |
| | | sWhere += " and åæ®å· like '%" + åæ®å· + "%'"; |
| | | } |
| | | if (WorkCenter) { |
| | | sWhere += " and å·¥ä½ä¸å¿ like '%" + WorkCenter + "%'"; |
| | | if (å·¥åºæµè½¬å¡å·) { |
| | | sWhere += " and å·¥åºæµè½¬å¡å· like '%" + å·¥åºæµè½¬å¡å· + "%'"; |
| | | } |
| | | if (HProcExchBillNo) { |
| | | sWhere += " and æµè½¬å¡å· like '%" + HProcExchBillNo + "%'"; |
| | | if (产ååç§°) { |
| | | sWhere += " and 产ååç§° like '%" + 产ååç§° + "%'"; |
| | | } |
| | | if (HMaker) { |
| | | sWhere += " and å¶å人 like '%" + HMaker + "%'"; |
| | | if (ç产çç») { |
| | | sWhere += " and ç产çç» like '%" + ç产çç» + "%'"; |
| | | } |
| | | if (hname) { |
| | | sWhere += " and 产ååç§° like '%" + hname + "%'"; |
| | | if (æä½å) { |
| | | sWhere += " and æä½å like '%" + æä½å + "%'"; |
| | | } |
| | | if (hnumber) { |
| | | sWhere += " and 产å代ç like '%" + hnumber + "%'"; |
| | | if (客æ·ä¿¡æ¯) { |
| | | sWhere += " and 客æ·ä¿¡æ¯ like '%" + 客æ·ä¿¡æ¯ + "%'"; |
| | | } |
| | | if (hmodel) { |
| | | sWhere += " and è§æ ¼åå· like '%" + hmodel + "%'"; |
| | | if (è系人信æ¯) { |
| | | sWhere += " and èç³»äººä¿¡æ¯ like '%" + èç³»äººä¿¡æ¯ + "%'"; |
| | | } |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL1() + '/api/newBill/getStationInBillList', |
| | | url: GetWEBURL() + '/api/newBill/getStationInBillList', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | </script> |