| | |
| | | </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" style="width:190px;"> |
| | | <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="HEndDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | //#region å½å页é¢å è½½æææ¹æ³ |
| | | // åå§åçé¢ |
| | | function set_ClearBill() { |
| | | $("#HDate").val(Format(new Date(new Date()), "yyyy-MM-dd")); |
| | | $("#HBeginDate").val(Format(new Date(new Date()), "yyyy-MM-dd")); |
| | | $("#HEndDate").val(Format(new Date(new Date()), "yyyy-MM-dd")); |
| | | //åå§åè¡¨æ ¼(主表) |
| | | set_InitGrid(); |
| | | //åå§åè¡¨æ ¼(å表) |
| | |
| | | //æ¥è¯¢ |
| | | function get_Display(sWhere) { |
| | | var ajaxLoad = layer.load(); |
| | | var HDate = $("#HDate").val();//ç»ææ¥æ |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),å¶åæ¥æ, 23) >= '" + HDate + "'"; |
| | | var HBeginDate = $("#HBeginDate").val();//ç»ææ¥æ |
| | | if (HBeginDate) { |
| | | sWhere += " and HDeptID=113546 and å¶å人='" + sessionStorage["HUserName"] + " and CONVERT(varchar(100),å¶åæ¥æ, 23) >= '" + HBeginDate + "'"; |
| | | |
| | | } |
| | | //è¿å
¥é¡µé¢æ¾ç¤ºçç¼åå表 |
| | | $.ajax({ |
| | |
| | | |
| | | //å¿«éè¿æ»¤ |
| | | function get_FastQuery() { |
| | | |
| | | var HBarCode = $("#HBarCode").val();//åæ®å· |
| | | var HMaterName = $("#HMaterName").val(); |
| | | var HSourceBillNo = $("#HSourceBillNo").val(); |
| | | var HMakerName = $("#HMakerName").val(); |
| | | var HDate = $("#HDate").val();//ç»æå¶åæ¶é´ |
| | | var HBeginDate = $("#HBeginDate").val();//å¼å§å¶åæ¶é´ |
| | | var HEndDate = $("#HEndDate").val();//å¼å§å¶åæ¶é´ |
| | | if (HBarCode) { |
| | | sWhere += " and HBarCode like '%" + HBarCode + "%'"; |
| | | } |
| | |
| | | if (HMakerName) { |
| | | sWhere += " and å¶å人 like '%" + HMakerName + "%'"; |
| | | } |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),å¶åæ¥æ, 23) >= '" + HDate + "'"; |
| | | if (HBeginDate) { |
| | | sWhere += " and CONVERT(varchar(100),å¶åæ¥æ, 23) >= '" + HBeginDate + "'"; |
| | | } |
| | | if (HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),å¶åæ¥æ, 23) <= '" + HEndDate + "'"; |
| | | } |
| | | get_Display(sWhere); |
| | | sWhere = "";//è°ç¨æ¥å£åæ¸
空sWhereç¼å |
| | |
| | | $("#HMaterName").val("");//åæ®å· |
| | | $("#HSourceBillNo").val("");//éå®è®¢åå· |
| | | $("#HMakerName").val("");//å¶å人 |
| | | $("#HDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//æ¶é´ |
| | | $("#HBeginDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//æ¶é´ |
| | | $("#HEndDate").val(Format(new Date(new Date()), "yyyy-MM-dd"));//æ¶é´ |
| | | sWhere = ""; |
| | | get_Display(sWhere); |
| | | } |