| | |
| | | <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/Scripts/json2.js"></script> |
| | | <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/zgqCustom/zgqCustom.js"></script> |
| | | </head> |
| | | <body> |
| | | <div class="layui-fluid"> |
| | |
| | | <div class="layui-inline"> |
| | | <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="HBeginDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" 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="HOrderProcNO" id="HOrderProcNO"> |
| | | </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> |
| | | <input type="date" class="layui-input" id="HEndDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <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="HBillNo" id="HBillNo" style="width:190px;"> |
| | | </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 class="layui-colla-content"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">é¨é¨</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æä»£ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="MaterialCode" id="MaterialCode" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <!--<hr />--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æåç§°</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="MaterialName" id="MaterialName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è§æ ¼åå·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="SpecificationModel" id="SpecificationModel" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æºååå·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HSourceBillNo" id="HSourceBillNo" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä»åº</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="Warehouse" id="Warehouse" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¶å人</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="Hmaker" id="Hmaker" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </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" lay-event="btn-getCheckData"><i class="layui-icon layui-icon-tips"></i>é¢è§</button>--> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="btn-reload"><i class="layui-icon layui-icon-refresh"></i>å·æ°</button>--> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-form"></i>æ·»å </button> |
| | | <!--<button type="button" class="layui-btn layui-btn-sm" lay-event="add"><i class="layui-icon"></i>æ·»å </button>--> |
| | | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></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-view"><i class="layui-icon layui-icon-tips"></i>é¢è§</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>æå°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | |
| | | </div> |
| | | </div> |
| | | |
| | | <script type="text/html" id="barDemo"> |
| | | <!--<script type="text/html" id="barDemo"> |
| | | <a class="layui-btn layui-btn-xs" lay-event="edit">ç¼è¾</a> |
| | | <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">å é¤</a> |
| | | </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({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage','laydate'], function () { |
| | | |
| | | //#region å
Œ
±åé |
| | | |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | |
| | | , laydate = layui.laydate |
| | | //var sWhere = " 产å代ç = 'BX0002'"; |
| | | var sWhere = ""; |
| | | var option = []; |
| | | |
| | | var option = { |
| | | //#endregion |
| | | |
| | | //#region åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | var checkStatus = table.checkStatus(obj.config.id); |
| | | switch (obj.event) { |
| | | case 'btn-Add': |
| | | layer.open({ |
| | | type: 2 //Pageå±ç±»å |
| | | , area: ['100%', '100%'] |
| | | , title: 'æ°å¢æ´¾å·¥å' |
| | | , shade: 0.6 //é®ç½©éæåº¦ |
| | | , maxmin: false //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../å¢å ä¸è¯è¯å®¡å/QC_Add_NoPassProdCheckBill.html', 'yes'] |
| | | , resize: false |
| | | , cancel: function () { |
| | | //$(".layui-btn").removeClass("layui-btn-disabled"); |
| | | } |
| | | |
| | | }); |
| | | break; |
| | | case '': |
| | | layer.msg(''); |
| | | break; |
| | | |
| | | }; |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | //åå§åæ¥æ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | } |
| | | |
| | | //è¡¨æ ¼æ°æ® |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | ,height: 'full-50' |
| | |
| | | ,cellMinWidth: 90 |
| | | , cols: [[ |
| | | //{ type: 'checkbox' } |
| | | |
| | | { field: 'hmainid', title: 'hmainid', sort: true, fixed: true, hide: true } |
| | | , { field: 'æ¥æ', title: 'æ¥æ', sort: true, width: 120 } |
| | | , { field: 'æ¥æ', title: 'æ¥æ', sort: true, width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', sort: true, width: 170 } |
| | | , { field: 'è¡¨å¤´å¤æ³¨', title: 'è¡¨å¤´å¤æ³¨' } |
| | | , { field: 'çäº§èµæºåç§° ', title: 'çäº§èµæºåç§° ', width: 115 } |
| | | , { field: 'çäº§èµæºä»£ç ', title: 'çäº§èµæºä»£ç ' } |
| | | , { field: 'ç©æå
ç ', title: 'ç©æå
ç ', width: 100 } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°' } |
| | | , { field: 'æºååå·', title: 'æºååå·' } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·' } |
| | | , { field: 'æ£éªå代ç ', title: 'æ£éªå代ç ' } |
| | | , { field: 'æ£éªååç§°', title: 'æ£éªååç§°' } |
| | | , { field: 'åä½ä»£ç ', title: 'åä½ä»£ç ' } |
| | |
| | | , { field: 'ä¸è¯åå 代ç ', title: 'ä¸è¯åå 代ç ' } |
| | | , { field: 'ä¸è¯åå ', title: 'ä¸è¯åå ' } |
| | | , { field: 'å¶å人', title: 'å¶å人' } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ' } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>"} |
| | | , { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº' } |
| | | , { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ' } |
| | | , { field: 'ä¿®æ¹äºº', title: 'ä¿®æ¹äºº' } |
| | | , { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ' } |
| | | , { field: 'ä¿®æ¹æ¥æ', title: 'ä¿®æ¹æ¥æ', width: 120, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'å
³é人', title: 'å
³é人' } |
| | | , { field: 'å
³éæ¥æ', title: 'å
³éæ¥æ' } |
| | | , { field: 'ä½åºäºº', title: 'ä½åºäºº' } |
| | |
| | | //,{fixed: 'right', title:'æä½', toolbar: '#barDemo', width:150} |
| | | ]] |
| | | }; |
| | | } |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | function get_Display(sWhere) { |
| | | var index0 = layer.load(0, { shade: false }); |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL() + '/Sc_ProcessMangement/MES_QC_NoPassProdCheckBill_Json', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.close(index0); |
| | | } else { |
| | | layer.close(index0); |
| | | layer.msg(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(index0); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | // å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HDeptID = $("#HDeptID").val();//é¨é¨ |
| | | var MaterialCode = $("#MaterialCode").val();//ç©æä»£ç |
| | | var MaterialName = $("#MaterialName").val();//ç©æåç§° |
| | | var SpecificationModel = $("#SpecificationModel").val();//è§æ ¼åå· |
| | | var HSourceBillNo = $("#HSourceBillNo").val();//æºååå· |
| | | var Warehouse = $("#Warehouse").val();//ä»åº |
| | | var Hmaker = $("#Hmaker").val();//å¶å人 |
| | | |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | } |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HDeptID) { |
| | | sWhere += " and é¨é¨ like '%" + HDeptID + "%'"; |
| | | } |
| | | if (MaterialCode) { |
| | | sWhere += " and ç©æä»£ç like '%" + MaterialCode + "%'"; |
| | | } |
| | | if (MaterialName) { |
| | | sWhere += " and ç©æåç§° like '%" + MaterialName + "%'"; |
| | | } |
| | | if (SpecificationModel) { |
| | | sWhere += " and è§æ ¼åå· like '%" + SpecificationModel + "%'"; |
| | | } |
| | | if (HSourceBillNo) { |
| | | sWhere += " and æºååå· like '%" + HSourceBillNo + "%'"; |
| | | } |
| | | if (Warehouse) { |
| | | sWhere += " and åè´§ä»åº like '%" + Warehouse + "%'"; |
| | | } |
| | | if (Hmaker) { |
| | | sWhere += " and å¶å人 like '%" + Hmaker + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | |
| | | // éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBillNo").val("");//åæ®å· |
| | | $("#HDeptID").val("");//é¨é¨ |
| | | $("#MaterialCode").val("");//ç©æä»£ç |
| | | $("#MaterialName").val("");//ç©æåç§° |
| | | $("#SpecificationModel").val("");//è§æ ¼åå· |
| | | $("#HSourceBillNo").val("");//æºååå· |
| | | $("#Warehouse").val("");//ä»åº |
| | | $("#Hmaker").val("");//å¶å人 |
| | | |
| | | sWhere = ""; |
| | | } |
| | | |
| | | //#endregion |
| | | |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | |
| | | //çå¬è¡å·¥å
·äºä»¶ |
| | |
| | | // //layer.alert('ææ¯ç¼è¾ä¸'); |
| | | // } |
| | | //}); |
| | | //头工å
·æ äºä»¶ |
| | | table.on('toolbar(mainTable)', function (obj) { |
| | | var checkStatus = table.checkStatus(obj.config.id); |
| | | switch (obj.event) { |
| | | case 'btn-Pushdown': |
| | | // var checkStatus = table.checkStatus('mainTable') |
| | | // , data = checkStatus.data; |
| | | // ajaxLabelData = data; |
| | | // var rows = ''; |
| | | // var HEntry = ''; |
| | | // for (var i = 0; i < data.length; i++) { |
| | | // rows += data[i].hmainid.toString() + ',' ; |
| | | |
| | | // } |
| | | |
| | | // if (checkStatus.data.length < 1) |
| | | // { |
| | | // layer.msg('è¯·éæ©ä¸è¡æ°æ®ä¸æ¨'); |
| | | // } else |
| | | // { |
| | | |
| | | ////页é¢å± |
| | | //layer.open({ |
| | | // type: 2 //Pageå±ç±»å |
| | | // ,area: ['100%', '100%'] |
| | | // ,title: 'æ°å¢æ´¾å·¥å' |
| | | // ,shade: 0.6 //é®ç½©éæåº¦ |
| | | // ,maxmin: false //å
许å
¨å±æå°å |
| | | // , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | // , content: ['../å·¥åºæ´¾å·¥å/Sc_Add_ProcessSendWork.html?HInterID=' + data[0].hmainid.toString() + '&lentryid=' + rows.toString().substring(0, rows.length - 1), '&PlanBeginDate=' + data[0].计åå¼å·¥æ¥æ.toString(), '&PlanEndDate=' + data[0].计åå®å·¥æ¥æ.toString(), 'yes'] |
| | | // , resize: false |
| | | // , cancel: function () { |
| | | // //$(".layui-btn").removeClass("layui-btn-disabled"); |
| | | // } |
| | | |
| | | // }); |
| | | |
| | | // } |
| | | layer.msg('åååï¼ï¼ï¼ï¼ï¼ï¼'); |
| | | break; |
| | | case 'btn-Add': |
| | | layer.open({ |
| | | type: 2 //Pageå±ç±»å |
| | | ,area: ['100%', '100%'] |
| | | ,title: 'æ°å¢æ´¾å·¥å' |
| | | ,shade: 0.6 //é®ç½©éæåº¦ |
| | | ,maxmin: false //å
许å
¨å±æå°å |
| | | , anim: 0 //0-6çå¨ç»å½¢å¼ï¼-1ä¸å¼å¯ |
| | | , content: ['../å¢å ä¸è¯è¯å®¡å/QC_Add_NoPassProdCheckBill.html' , 'yes'] |
| | | , resize: false |
| | | , cancel: function () { |
| | | //$(".layui-btn").removeClass("layui-btn-disabled"); |
| | | } |
| | | |
| | | }); |
| | | break; |
| | | case '': |
| | | layer.msg(''); |
| | | break; |
| | | |
| | | }; |
| | | }); |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | var index0 = layer.load(0, { shade: false }); |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL() + '/Sc_ProcessMangement/MES_QC_NoPassProdCheckBill_Json', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.close(index0); |
| | | } else { |
| | | layer.close(index0); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.close(index0); |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | $("#HDate").val("");//å¼å§æ¥æ |
| | | $("#HDate1").val("");//ç»ææ¥æ |
| | | //$("#HOrderProcNO").val("");//订åè·è¸ªå· |
| | | //$("#WorkCenter").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();//åæ®å· |
| | | if (HDate) { |
| | | sWhere += " and æ¥æ >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and æ¥æ <= '" + HDate1 + "'"; |
| | | } |
| | | //if (HOrderProcNO) { |
| | | // sWhere += " and 订åè·è¸ªå· like '%" + HOrderProcNO + "%'"; |
| | | //} |
| | | //if (WorkCenter) { |
| | | // sWhere += " and HBillNo like '%" + WorkCenter + "%'"; |
| | | //} |
| | | var index = layer.load(0, { shade: false }); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/Sc_ProcessMangement/MES_QC_NoPassProdCheckBill_Json', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | 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ç¼å |
| | | }); |
| | | |
| | | |
| | | //laydate.render({ |
| | | // elem: '#HDate' |
| | | // , type: 'datetime' |
| | | // , trigger: 'click' |
| | | // , format:'yyyy-MM-dd HH:mm' |
| | | //}); |
| | | |
| | | |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| | |
| | | <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/Scripts/json2.js"></script> |
| | | <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/zgqCustom/zgqCustom.js"></script> |
| | | |
| | | </head> |
| | | <body> |
| | |
| | | <div class="layui-colla-item"> |
| | | <div class="layui-colla-title layui-inline"> |
| | | <div class="layui-inline"> |
| | | <span></span> |
| | | <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;"> |
| | | <input type="text" class="layui-input" name="HBillNo" id="HBillNo"> |
| | | <label class="layui-form-label">å¼å§æ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HBeginDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <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="HMaterialName" id="HMaterialName"> |
| | | <label class="layui-form-label">ç»ææ¥æ</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HEndDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <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" style="width:190px;"> |
| | | </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"> |
| | | <label class="layui-form-label">é¨é¨</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æä»£ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="MaterialCode" id="MaterialCode" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <!--<hr />--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æåç§°</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="MaterialName" id="MaterialName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è§æ ¼åå·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="SpecificationModel" id="SpecificationModel" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">æºååå·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HSourceBillNo" id="HSourceBillNo" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä»åº</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="Warehouse" id="Warehouse" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¶å人</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="Hmaker" id="Hmaker" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-back" id="btn_back"><i class="layui-icon layui-icon-close-fill"></i>驳å</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-details"><i class="layui-icon layui-icon-form"></i>详æ
</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-generate"><i class="layui-icon layui-icon-file"></i>çæéè´§å</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-file-b"></i>æ°å¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></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-view"><i class="layui-icon layui-icon-tips"></i>é¢è§</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>æå°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | |
| | | </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> |
| | | layui.config({ |
| | | base: '../../../layuiadmin/' //éæèµæºæå¨è·¯å¾ |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage','laydate'], function () { |
| | | |
| | | //#region å
Œ
±åé |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | var sWhere = ""; |
| | | var option = []; |
| | | //#endregion |
| | | |
| | | var option = { |
| | | //#region åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | //åå§åæ¥æ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | } |
| | | |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | //, toolbar: '#toolbarDemo' |
| | | , toolbar: '#toolbarDemo' |
| | | ,height: 'full-50' |
| | | , page: true |
| | | ,cellMinWidth: 90 |
| | | , cols: [[ |
| | | { field: 'hmainid', title: 'hmainid', sort: true, hide: true } |
| | | , { field: 'æ¥æ', title: 'æ¥æ' } |
| | | , { field: 'åæ®å·', title: 'åæ®å·' } |
| | | , { field: 'æ¥æ', title: 'æ¥æ', width: 150, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', width: 150 } |
| | | , { field: 'HDeptID', title: 'HDeptID', hide: true } |
| | | , { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ' } |
| | | , { field: 'é¨é¨ä»£ç ', title: 'é¨é¨ä»£ç ', width: 150 } |
| | | , { field: 'é¨é¨', title: 'é¨é¨' } |
| | | , { field: 'HMaterID', title: 'HMaterID', hide: true } |
| | | , { field: '产å代ç ', title: '产å代ç ' } |
| | | , { field: '产ååç§°', title: '产ååç§°' } |
| | | , { field: '产åè§æ ¼', title: '产åè§æ ¼' } |
| | | , { field: 'æºååå·', title: 'æºååå·', width: 150 } |
| | | , { field: 'HUnitID', title: 'HUnitID', hide: true } |
| | | , { field: '主表计éåä½ä»£ç ', title: '主表计éåä½ä»£ç ' } |
| | | , { field: '主表计éåä½', title: '主表计éåä½' } |
| | |
| | | , { field: 'hsubid', title: 'hsubid', hide: true } |
| | | , { field: 'hmaterid2', title: 'hmaterid2', hide: true } |
| | | , { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ' } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°' } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 150 } |
| | | , { field: 'è§æ ¼åå·', title: 'è§æ ¼åå·' } |
| | | , { field: 'hunitid2', title: 'hunitid2', hide: true } |
| | | , { field: '计éåä½ä»£ç ', title: '计éåä½ä»£ç ' } |
| | |
| | | , { field: 'HSPID', title: 'HSPID', hide: true } |
| | | , { field: 'ä»ä½ä»£ç ', title: 'ä»ä½ä»£ç ' } |
| | | , { field: 'ä»ä½', title: 'ä»ä½' } |
| | | , { field: 'ç产任å¡åå·', title: 'ç产任å¡åå·' } |
| | | , { field: 'ç产任å¡åå·', title: 'ç产任å¡åå·', width: 150 } |
| | | , { field: 'å¶å人', title: 'å¶å人' } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ' } |
| | | , { field: 'å¶åæ¥æ', title: 'å¶åæ¥æ', width: 150, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'å®¡æ ¸äºº', title: 'å®¡æ ¸äºº' } |
| | | , { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ' } |
| | | , { field: 'å®¡æ ¸æ¥æ', title: 'å®¡æ ¸æ¥æ', width: 150, templet: "<div>{{d.æ¥æ ==null ?'':layui.util.toDateString(d.æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: '计åè·è¸ªå·', title: '计åè·è¸ªå·' } |
| | | , { field: 'è®¡åæ¨¡å¼', title: 'è®¡åæ¨¡å¼' } |
| | | ]] |
| | | }; |
| | | } |
| | | |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | function get_Display(sWhere) { |
| | | var index = layer.load(0, { shade: false }); |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | $.ajax({ |
| | |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | $("#HNumber").val(""); |
| | | $("#HName").val(""); |
| | | $("#btnSearch").click(); |
| | | }); |
| | | // å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HDeptID = $("#HDeptID").val();//é¨é¨ |
| | | var MaterialCode = $("#MaterialCode").val();//ç©æä»£ç |
| | | var MaterialName = $("#MaterialName").val();//ç©æåç§° |
| | | var SpecificationModel = $("#SpecificationModel").val();//è§æ ¼åå· |
| | | var HSourceBillNo = $("#HSourceBillNo").val();//æºååå· |
| | | var Warehouse = $("#Warehouse").val();//ä»åº |
| | | var Hmaker = $("#Hmaker").val();//å¶å人 |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | var HBillNo = $("#HBillNo").val(); |
| | | var HMaterialName = $("#HMaterialName").val(); |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | } |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HMaterialName) { |
| | | sWhere += " and ç©æåç§° like '%" + HMaterialName + "%'"; |
| | | if (HDeptID) { |
| | | sWhere += " and é¨é¨ like '%" + HDeptID + "%'"; |
| | | } |
| | | $.ajax({ |
| | | //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum", |
| | | url: GetWEBURL() + '/Sc_PPBomBill/list', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | if (MaterialCode) { |
| | | sWhere += " and ç©æä»£ç like '%" + MaterialCode + "%'"; |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£è¯·æ±å¤±è´¥!", { icon: 5 }); |
| | | if (MaterialName) { |
| | | sWhere += " and ç©æåç§° like '%" + MaterialName + "%'"; |
| | | } |
| | | }); |
| | | if (SpecificationModel) { |
| | | sWhere += " and è§æ ¼åå· like '%" + SpecificationModel + "%'"; |
| | | } |
| | | if (HSourceBillNo) { |
| | | sWhere += " and æºååå· like '%" + HSourceBillNo + "%'"; |
| | | } |
| | | if (Warehouse) { |
| | | sWhere += " and åè´§ä»åº like '%" + Warehouse + "%'"; |
| | | } |
| | | if (Hmaker) { |
| | | sWhere += " and å¶å人 like '%" + Hmaker + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | }); |
| | | } |
| | | |
| | | // éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBillNo").val("");//åæ®å· |
| | | $("#HDeptID").val("");//é¨é¨ |
| | | $("#MaterialCode").val("");//ç©æä»£ç |
| | | $("#MaterialName").val("");//ç©æåç§° |
| | | $("#SpecificationModel").val("");//è§æ ¼åå· |
| | | $("#HSourceBillNo").val("");//æºååå· |
| | | $("#Warehouse").val("");//ä»åº |
| | | $("#Hmaker").val("");//å¶å人 |
| | | |
| | | //laydate.render({ |
| | | // elem: '#HDate' |
| | | // , type: 'datetime' |
| | | // , trigger: 'click' |
| | | // , format:'yyyy-MM-dd HH:mm' |
| | | //}); |
| | | sWhere = ""; |
| | | } |
| | | |
| | | |
| | | //#endregion |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | |
| | | |
| | | |
| | | </script> |
| | | |
| | |
| | | <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/PubCustom.js"></script> |
| | | <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script> |
| | | |
| | | </head> |
| | | <body> |
| | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" name="å¼å§æ¶é´" id="å¼å§æ¶é´"> |
| | | <input type="date" class="layui-input" name="HBeginDate" id="HBeginDate"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" name="ç»ææ¶é´" id="ç»ææ¶é´"> |
| | | <input type="date" class="layui-input" name="HEndDate" id="HEndDate"> |
| | | </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="ç»æåå·" id="ç»æåå·"> |
| | | <input type="text" class="layui-input" name="HBillNo" id="HBillNo" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | |
| | | <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> |
| | | <label class="layui-form-label">ç»æåå·</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="å¶å人" id="å¶å人"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»æåå¯ä¸æ¡ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="ç»æåå¯ä¸æ¡ç " id="ç»æåå¯ä¸æ¡ç "> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-colla-content"> |
| | | <div class="layui-inline"> |
| | | <div class="layui-inline"> |
| | | <span>å
¶ä»æ¡ä»¶></span> |
| | | <input type="text" class="layui-input" name="ç»æåå·" id="ç»æåå·"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | <input type="text" class="layui-input" name="å
è£
åå¯ä¸æ¡ç " id="å
è£
åå¯ä¸æ¡ç "> |
| | | </div> |
| | | </div> |
| | | <!--<div class="layui-inline"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»æåå¯ä¸æ¡ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="ç»æåå¯ä¸æ¡ç " id="ç»æåå¯ä¸æ¡ç "> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">é¨é¨</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HDeptID" id="HDeptID" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æä»£ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="MaterialCode" id="MaterialCode" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <!--<hr />--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æåç§°</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="MaterialName" id="MaterialName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <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="SpecificationModel" id="SpecificationModel" style="width:190px;"> |
| | | </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="HSourceBillNo" id="HSourceBillNo" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ä»åº</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="Warehouse" id="Warehouse" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¶å人</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="Hmaker" id="Hmaker" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | </div> |
| | | </div> |
| | | <table class="layui-form-item" id="mainTable" lay-filter="mainTable"></table> |
| | | <script type="text/html" id="toolbarDemo"> |
| | | <div class="layui-btn-container layui-form-item"> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="Print" id="Print"> |
| | | <i class="layui-icon layui-icon-file"></i>æå° |
| | | </button> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="Print" id="Print"><i class="layui-icon layui-icon-file"></i>æå° </button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Add"><i class="layui-icon layui-icon-file-b"></i>æ°å¢</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Edit"><i class="layui-icon layui-icon-form"></i>ç¼è¾</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Delete"><i class="layui-icon layui-icon-delete"></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-view"><i class="layui-icon layui-icon-tips"></i>é¢è§</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-print"><i class="layui-icon layui-icon-print"></i>æå°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | </div> |
| | | </script> |
| | | </form> |
| | |
| | | }).extend({ |
| | | index: 'lib/index', //主å
¥å£æ¨¡å |
| | | }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () { |
| | | |
| | | //#region å
Œ
±åé |
| | | |
| | | var $ = layui.$ |
| | | , admin = layui.admin |
| | | , layer = layui.layer |
| | |
| | | , laypage = layui.laypage |
| | | , laydate = layui.laydate |
| | | , util = layui.util; |
| | | //var sWhere = " 产å代ç = 'BX0002'"; |
| | | var sWhere = ""; |
| | | var option = []; |
| | | |
| | | var option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , cols: [[ |
| | | { type: 'radio' } |
| | | , { field: 'ç»æåç±»å', title: 'ç»æåç±»å', sort: true, hide: true } |
| | | , { field: 'ç»æå主ID', title: 'ç»æå主ID', sort: true, hide: true } |
| | | , { field: 'ç»æåå·', title: 'ç»æåå·', sort: true, width:155 } |
| | | , { field: 'å¶å人', title: 'å¶å人', sort: true } |
| | | , { |
| | | field: 'å¶åæ¶é´', title: 'ç»ææ¶é´', sort: true, templet: function (d) { |
| | | if (d.å¶åæ¶é´ == null) { |
| | | return ""; |
| | | } |
| | | return util.toDateString(d.å¶åæ¶é´, "yyyy-MM-dd"); |
| | | } |
| | | } |
| | | , { field: 'ç»æåå¯ä¸æ¡ç ', title: 'ç»æç ', sort: true } |
| | | , { field: 'å
è£
åå·', title: 'å
è£
åå·', sort: true } |
| | | , { field: 'å
è£
åç±»å', title: 'å
è£
åç±»å', hide: true } |
| | | , { field: 'å
è£
åå¯ä¸æ¡ç ', title: 'å
è£
ç ', width: 165 } |
| | | , { toolbar: '#toolBar', title: 'æä½', width: 115, fixed: 'right' } |
| | | ]] |
| | | , text: { |
| | | none: 'ææ ç¸å
³æ°æ®ï¼' |
| | | } |
| | | }; |
| | | //#endregion |
| | | |
| | | option.data = []; |
| | | table.render(option); |
| | | //#region åå§åçé¢ |
| | | set_ClearBill(); |
| | | //#endregion |
| | | |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçå表 |
| | | layer.load(3); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/GroupOrderBill/List', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.closeAll("loading"); |
| | | } else { |
| | | layer.closeAll("loading"); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£å¤±æ!", { icon: 5 }); |
| | | } |
| | | }); |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | $("#å¼å§æ¶é´").val(""); |
| | | $("#ç»ææ¶é´").val(""); |
| | | $("#ç»æåå·").val(""); |
| | | $("#å¶å人").val(""); |
| | | $("#ç»æåå¯ä¸æ¡ç ").val(""); |
| | | $("#å
è£
åå·").val(""); |
| | | $("#å
è£
åå¯ä¸æ¡ç ").val(""); |
| | | $("#btnSearch").click(); |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) { |
| | | var å¼å§æ¶é´ = $("#å¼å§æ¶é´").val(); |
| | | var ç»ææ¶é´ = $("#ç»ææ¶é´").val(); |
| | | var ç»æåå· = $("#ç»æåå·").val(); |
| | | var å¶å人 = $("#å¶å人").val(); |
| | | var ç»æåå¯ä¸æ¡ç = $("#ç»æåå¯ä¸æ¡ç ").val(); |
| | | var å
è£
åå· = $("#å
è£
åå·").val(); |
| | | var å
è£
åå¯ä¸æ¡ç = $("#å
è£
åå¯ä¸æ¡ç ").val(); |
| | | if (å¼å§æ¶é´) { |
| | | sWhere += " and å¶åæ¶é´ > '" + å¼å§æ¶é´ + "'"; |
| | | } |
| | | if (ç»ææ¶é´) { |
| | | sWhere += " and å¶åæ¶é´ < '" + ç»ææ¶é´ + "'"; |
| | | } |
| | | if (ç»æåå·) { |
| | | sWhere += " and ç»æåå· like '%" + ç»æåå· + "%'"; |
| | | } |
| | | if (å¶å人) { |
| | | sWhere += " and å¶å人 like '%" + å¶å人 + "%'"; |
| | | } |
| | | if (ç»æåå¯ä¸æ¡ç ) { |
| | | sWhere += " and ç»æåå¯ä¸æ¡ç like '%" + ç»æåå¯ä¸æ¡ç + "%'"; |
| | | } |
| | | if (å
è£
åå·) { |
| | | sWhere += " and å
è£
åå· like '%" + å
è£
åå· + "%'"; |
| | | } |
| | | if (å
è£
åå¯ä¸æ¡ç ) { |
| | | sWhere += " and å
è£
åå¯ä¸æ¡ç like '%" + å
è£
åå¯ä¸æ¡ç + "%'"; |
| | | } |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/GroupOrderBill/List', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | //layer.alert("æ¥è¯¢æå", { icon: 1 }); |
| | | } else { |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£å¤±æ!", { icon: 5 }); |
| | | } |
| | | }); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | get_FastQuery(); |
| | | |
| | | }); |
| | | //è·åéä¸è¡æ°æ® |
| | | table.on('row(mainTable)', function (obj) { |
| | |
| | | } |
| | | }); |
| | | |
| | | //#endregion |
| | | |
| | | //以䏿¯layui模å |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | | //åå§åè¡¨æ ¼ |
| | | set_InitGrid(); |
| | | //æ¥è¯¢ |
| | | get_Display(sWhere); |
| | | //åå§åæ¥æ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | } |
| | | //è¡¨æ ¼æ°æ® |
| | | function set_InitGrid() { |
| | | option = { |
| | | elem: '#mainTable' |
| | | , toolbar: '#toolbarDemo' |
| | | , height: 'full-50' |
| | | , page: true |
| | | , cellMinWidth: 90 |
| | | , cols: [[ |
| | | { type: 'radio' } |
| | | , { field: 'ç»æåç±»å', title: 'ç»æåç±»å', sort: true, hide: true } |
| | | , { field: 'ç»æå主ID', title: 'ç»æå主ID', sort: true, hide: true } |
| | | , { field: 'ç»æåå·', title: 'ç»æåå·', sort: true, width: 155 } |
| | | , { field: 'å¶å人', title: 'å¶å人', sort: true } |
| | | , { |
| | | field: 'å¶åæ¶é´', title: 'ç»ææ¶é´', sort: true, templet: function (d) { |
| | | if (d.å¶åæ¶é´ == null) { |
| | | return ""; |
| | | } |
| | | return util.toDateString(d.å¶åæ¶é´, "yyyy-MM-dd"); |
| | | } |
| | | } |
| | | , { field: 'ç»æåå¯ä¸æ¡ç ', title: 'ç»æç ', sort: true } |
| | | , { field: 'å
è£
åå·', title: 'å
è£
åå·', sort: true } |
| | | , { field: 'å
è£
åç±»å', title: 'å
è£
åç±»å', hide: true } |
| | | , { field: 'å
è£
åå¯ä¸æ¡ç ', title: 'å
è£
ç ', width: 165 } |
| | | , { toolbar: '#toolBar', title: 'æä½', width: 115, fixed: 'right' } |
| | | ]] |
| | | , text: { |
| | | none: 'ææ ç¸å
³æ°æ®ï¼' |
| | | } |
| | | }; |
| | | } |
| | | |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | function get_Display(sWhere) { |
| | | layer.load(3); |
| | | $.ajax({ |
| | | url: GetWEBURL() + '/GroupOrderBill/List', |
| | | type: "GET", |
| | | data: { "sWhere": sWhere }, |
| | | success: function (data1) { |
| | | if (data1.count == 1) { |
| | | option.data = data1.data; |
| | | table.render(option); |
| | | layer.closeAll("loading"); |
| | | } else { |
| | | layer.closeAll("loading"); |
| | | layer.alert(data1.code + data1.Message, { icon: 5 }); |
| | | } |
| | | }, error: function () { |
| | | layer.alert("æ¥å£å¤±æ!", { icon: 5 }); |
| | | } |
| | | }); |
| | | } |
| | | |
| | | // å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HDate = $("#HBeginDate").val();//å¼å§æ¥æ |
| | | var HDate1 = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HDeptID = $("#HDeptID").val();//é¨é¨ |
| | | var MaterialCode = $("#MaterialCode").val();//ç©æä»£ç |
| | | var MaterialName = $("#MaterialName").val();//ç©æåç§° |
| | | var SpecificationModel = $("#SpecificationModel").val();//è§æ ¼åå· |
| | | var HSourceBillNo = $("#HSourceBillNo").val();//æºååå· |
| | | var Warehouse = $("#Warehouse").val();//ä»åº |
| | | var Hmaker = $("#Hmaker").val();//å¶å人 |
| | | |
| | | var ç»æåå· = $("#ç»æåå·").val(); |
| | | var ç»æåå¯ä¸æ¡ç = $("#ç»æåå¯ä¸æ¡ç ").val(); |
| | | var å
è£
åå· = $("#å
è£
åå·").val(); |
| | | var å
è£
åå¯ä¸æ¡ç = $("#å
è£
åå¯ä¸æ¡ç ").val(); |
| | | |
| | | if (ç»æåå·) { |
| | | sWhere += " and ç»æåå· like '%" + ç»æåå· + "%'"; |
| | | } |
| | | |
| | | if (ç»æåå¯ä¸æ¡ç ) { |
| | | sWhere += " and ç»æåå¯ä¸æ¡ç like '%" + ç»æåå¯ä¸æ¡ç + "%'"; |
| | | } |
| | | if (å
è£
åå·) { |
| | | sWhere += " and å
è£
åå· like '%" + å
è£
åå· + "%'"; |
| | | } |
| | | if (å
è£
åå¯ä¸æ¡ç ) { |
| | | sWhere += " and å
è£
åå¯ä¸æ¡ç like '%" + å
è£
åå¯ä¸æ¡ç + "%'"; |
| | | } |
| | | |
| | | |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + HDate + "'"; |
| | | } |
| | | if (HDate1) { |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= '" + HDate1 + "'"; |
| | | } |
| | | if (HBillNo) { |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HDeptID) { |
| | | sWhere += " and é¨é¨ like '%" + HDeptID + "%'"; |
| | | } |
| | | if (MaterialCode) { |
| | | sWhere += " and ç©æä»£ç like '%" + MaterialCode + "%'"; |
| | | } |
| | | if (MaterialName) { |
| | | sWhere += " and ç©æåç§° like '%" + MaterialName + "%'"; |
| | | } |
| | | if (SpecificationModel) { |
| | | sWhere += " and è§æ ¼åå· like '%" + SpecificationModel + "%'"; |
| | | } |
| | | if (HSourceBillNo) { |
| | | sWhere += " and æºååå· like '%" + HSourceBillNo + "%'"; |
| | | } |
| | | if (Warehouse) { |
| | | sWhere += " and åè´§ä»åº like '%" + Warehouse + "%'"; |
| | | } |
| | | if (Hmaker) { |
| | | sWhere += " and å¶å人 like '%" + Hmaker + "%'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | |
| | | // éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#ç»æåå·").val(""); |
| | | $("#ç»æåå¯ä¸æ¡ç ").val(""); |
| | | $("#å
è£
åå·").val(""); |
| | | $("#å
è£
åå¯ä¸æ¡ç ").val(""); |
| | | $("#btnSearch").click(); |
| | | |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBillNo").val("");//åæ®å· |
| | | $("#HDeptID").val("");//é¨é¨ |
| | | $("#MaterialCode").val("");//ç©æä»£ç |
| | | $("#MaterialName").val("");//ç©æåç§° |
| | | $("#SpecificationModel").val("");//è§æ ¼åå· |
| | | $("#HSourceBillNo").val("");//æºååå· |
| | | $("#Warehouse").val("");//ä»åº |
| | | $("#Hmaker").val("");//å¶å人 |
| | | |
| | | sWhere = ""; |
| | | } |
| | | |
| | | function Print(data) { |
| | | console.log("data=", data); |
| | | } |
| | | |
| | | //#endregion |
| | | //option.data = []; |
| | | //table.render(option); |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | </script> |
| | | |
| | |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | $("#HBillNo").val("");//åæ®å· |
| | | $("#HCusID").val("");//å®¢æ· |
| | | $("#HDeptID").val();//é¨é¨ |
| | | $("#MaterialCode").val();//ç©æä»£ç |
| | | $("#MaterialName").val();//ç©æåç§° |
| | | $("#SpecificationModel").val();//è§æ ¼åå· |
| | | $("#HSourceBillNo").val();//æºååå· |
| | | $("#Warehouse").val();//ä»åº |
| | | $("#Hmaker").val();//å¶å人 |
| | | $("#HDeptID").val("");//é¨é¨ |
| | | $("#MaterialCode").val("");//ç©æä»£ç |
| | | $("#MaterialName").val("");//ç©æåç§° |
| | | $("#SpecificationModel").val("");//è§æ ¼åå· |
| | | $("#HSourceBillNo").val("");//æºååå· |
| | | $("#Warehouse").val("");//ä»åº |
| | | $("#Hmaker").val("");//å¶å人 |
| | | |
| | | sWhere = ""; |
| | | } |