| | |
| | | <!DOCTYPE html> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| | | <title>设å¤ç¹æ£è®°å½åå表</title> |
| | | <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"> |
| | | <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> |
| | |
| | | <option value="ZHSJ">䏿¶å½è¿å</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | </div>--> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åæ®å·</label> |
| | | <div class="layui-input-block"> |
| | |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input" name="HCreateBy" id="HCreateBy"> |
| | | </div> |
| | | </div>--> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">å¼å§æ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" name="BenginHCreateDate" id="BenginHCreateDate"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" name="EndHCreateDate" id="EndHCreateDate"> |
| | | </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"> |
| | | <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="date" class="layui-input" name="BenginHCreateDate" id="BenginHCreateDate"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç»ææ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" name="EndHCreateDate" id="EndHCreateDate"> |
| | | </div> |
| | | </div> |
| | | </div>--> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <table class="" id="mainTable" lay-filter="mainTable"></table> |
| | |
| | | } |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | var HBillType = $("#HBillType").val();//åæ®ç±»å |
| | | //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 + "%'"; |
| | | sWhere += " and åæ®å· like '%" + HBillNo + "%'"; |
| | | } |
| | | if (HCreateBy) { |
| | | sWhere += " and HCreateBy like '%" + HCreateBy + "%'"; |
| | | sWhere += " and å¶å人 like '%" + HCreateBy + "%'"; |
| | | } |
| | | if (BenginHCreateDate) { |
| | | sWhere += " and CONVERT(varchar(100),HCreateDate, 23) >= '" + BenginHCreateDate + "'"; |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + BenginHCreateDate + "'"; |
| | | } |
| | | if (EndHCreateDate) { |
| | | sWhere += " and CONVERT(varchar(100),HCreateDate, 23) <= '" + EndHCreateDate + "'"; |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= '" + EndHCreateDate + "'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | | } |
| | | //éç½®è¿æ»¤æ¡ä»¶æ¹æ³ |
| | | function set_ClearQuery() { |
| | | $("#HBillType").val("");//åæ®ç±»å |
| | | //$("#HBillType").val("");//åæ®ç±»å |
| | | $("#HBillNo").val("");//åæ®å· |
| | | $("#HSourceBillNo").val("");//æºåå· |
| | | $("#HCreateBy").val("");//å¶å人 |
| | | $("#BenginHCreateDate").val("");//å¼å§å¶åæ¶é´ |
| | | $("#EndHCreateDate").val("");//ç»æå¶åæ¶é´ |
| | | sWhere = ""; |
| | | $("#btnSearch").click(); |
| | | } |
| | | //å·æ° |
| | | function get_Refresh() { |
| | |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | |
| | | |
| | | |
| | | //以䏿¯layui模å |
| | | }); |
| | | |