| | |
| | | <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"> |
| | | <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i> |
| | | </button> |
| | |
| | | , { 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 + "'"; |
| | | } |