| | |
| | | <html> |
| | | <head> |
| | | <meta charset="utf-8" /> |
| | | <title>å·¥åºæ±æ¥å
¥åºå表</title> |
| | | <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"> |
| | |
| | | <label class="layui-form-label">åºç«æ¶é´</label> |
| | | <div class="layui-input-block"> |
| | | <input type="date" class="layui-input" id="HDate" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">åæ¥ç¶æ</label> |
| | | <div class="layui-input-block" style="margin-left: 125px;width:55%;"> |
| | | <select name="HRelationQty" lay-filter="aihao" id="HRelationQty"> |
| | | <option value="1" selected="selected">å
¨é¨</option> |
| | | <option value="2">已忥</option> |
| | | <option value="3">æªåæ¥</option> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch"> |
| | |
| | | , { field: 'ä»»å¡å', title: 'ä»»å¡å', width: 125 } |
| | | , { field: 'åæ®å·', title: 'åæ®å·', width: 190 } |
| | | , { field: 'å·¥åºæµè½¬å¡å·', title: 'å·¥åºæµè½¬å¡å·', width: 125 } |
| | | , { field: 'åæ¥ç¶æ', title: 'åæ¥ç¶æ' } |
| | | , { field: 'HProcID', title: 'HProcID', hide: true } |
| | | , { field: 'å½åå·¥åºä»£ç ', title: 'å½åå·¥åºä»£ç ', width: 125 } |
| | | , { field: 'å½åå·¥åº', title: 'å½åå·¥åº' } |
| | |
| | | |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HWorkBillNo").val(); |
| | | $("#HWorkBillNo").val(""); |
| | | $("#HBillNo").val(""); |
| | | $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd")); |
| | | $("#HProcExchBillNo").val(""); |
| | | $("#HRelationQty").val("1") |
| | | form.render("select"); |
| | | } |
| | | |
| | | //å¿«éè¿æ»¤ |
| | |
| | | var HWorkBillNo = $("#HWorkBillNo").val(); |
| | | var HBillNo = $("#HBillNo").val(); |
| | | var HProcExchBillNo = $("#HProcExchBillNo").val(); |
| | | var HRelationQty = $("#HRelationQty").val(); |
| | | switch (HRelationQty) { |
| | | case "1": |
| | | sWhere += ""; |
| | | break; |
| | | case "2": |
| | | sWhere += " and åæ¥ç¶æ = '已忥'"; |
| | | break; |
| | | case "3": |
| | | sWhere += " and åæ¥ç¶æ = ''"; |
| | | break; |
| | | } |
| | | if (HDate) { |
| | | sWhere += " and CONVERT(varchar(100),åºç«æ¶é´, 23) = '" + HDate + "'"; |
| | | } |