| | |
| | | <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-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="get_Refresh"><i class="layui-icon layui-icon-refresh-3"></i>å·æ°</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit"><i class="layui-icon layui-icon-logout"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-confirm" id="btn_confirm"><i class="layui-icon layui-icon-ok-circle"></i>确认</button> |
| | | <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-exit"><i class="layui-icon layui-icon-return"></i>éåº</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_CheckBill"><i class="layui-icon layui-icon-search"></i>å®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="set_AbandonCheck"><i class="layui-icon layui-icon-search"></i>åå®¡æ ¸</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event="get_PrintReport"><i class="layui-icon layui-icon-search"></i>é¢è§</button> |
| | | <button type="button" class="layui-btn layui-btn-sm" lay-event=""><i class="layui-icon layui-icon-search"></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> |
| | | </div> |
| | | </script> |
| | | </form> |
| | |
| | | |
| | | //åå§åçé¢ |
| | | set_ClearBill(); |
| | | |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd")); |
| | | |
| | | //#endregion |
| | | |
| | | //#region 触åäºä»¶ï¼å
æ¬form.on(){}æ ¼å¼çææç¹å»äºä»¶ãéæ©äºä»¶ç |
| | | |
| | | //éç½®æé® |
| | | //form.on('submit(btnReSearch)', function (data) { |
| | | // $("#HBillType").val("");//åæ®ç±»å |
| | | // $("#HBillNo").val("");//åæ®å· |
| | | // $("#HSourceBillNo").val("");//æºåå· |
| | | // $("#HCreateBy").val("");//å¶å人 |
| | | // $("#BenginHCreateDate").val("");//å¼å§å¶åæ¶é´ |
| | | // $("#EndHCreateDate").val("");//ç»æå¶åæ¶é´ |
| | | // $("#btnSearch").click(); |
| | | //}); |
| | | |
| | | //æ¥è¯¢æé® |
| | | form.on('submit(btnSearch)', function (data) {//éæ©ä»ä½ |
| | | //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 (HCreateBy) { |
| | | // sWhere += " and HCreateBy like '%" + HCreateBy + "%'"; |
| | | //} |
| | | //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() + '/Kf_EntrustInBill/GetEntrustInBill', |
| | | // 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 = ""; |
| | | //$("#HBillType").val("");//åæ®ç±»å |
| | | //$("#HBillNo").val("");//åæ®å· |
| | | //$("#HSourceBillNo").val("");//æºåå· |
| | | //$("#HCreateBy").val("");//å¶å人 |
| | | //$("#BenginHCreateDate").val("");//å¼å§å¶åæ¶é´ |
| | | //$("#EndHCreateDate").val("");//ç»æå¶åæ¶é´ |
| | | form.on('submit(btnSearch)', function (data) { |
| | | get_FastQuery(); |
| | | }); |
| | | // éç½®æé® |
| | | form.on('submit(btnReSearch)', function (data) { |
| | | //æ¸
ç©ºè¿æ»¤æ¡ä»¶ |
| | | set_ClearQuery(); |
| | | }); |
| | | |
| | | //çå¬è¡åå»äºä»¶ |
| | | table.on('rowDouble(mainTable)', function (obj) { |
| | | layer.alert("åå»äºä»¶", { icon: 1 }); |
| | | }); |
| | | |
| | | //#endregion |
| | | //#endregion |
| | | |
| | | //#region æ¤é¡µé¢ææçæ¹æ³ |
| | | |
| | |
| | | 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 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 |
| | | |
| | | //laydate.render({ |
| | | // elem: '#HDate' |
| | | // , type: 'datetime' |
| | | // , trigger: 'click' |
| | | // , format:'yyyy-MM-dd HH:mm' |
| | | //}); |
| | | //以䏿¯layui模å |
| | | |
| | | //以䏿¯layui模å |
| | | }); |
| | | |
| | | |
| | | |
| | | }) |
| | | |
| | | </script> |
| | | |
| | | </body> |
| | | </html> |