| | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="layui-row" style="margin: 10px 0 10px"> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">è¿æ»¤</label> |
| | | <div class="layui-input-block"> |
| | | <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;"> |
| | | </select> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;"> |
| | | <option value="0" selected="selected"></option> |
| | | <option value="=">=</option> |
| | | <option value=">=">>=</option> |
| | | <option value=">">></option> |
| | | <option value="<="><=</option> |
| | | <option value="<"><</option> |
| | | <option value="<>"><></option> |
| | | <option value="7">å
å«</option> |
| | | <option value="8">å·¦å
å«</option> |
| | | <option value="9">å³å
å«</option> |
| | | <option value="10">ä¸å
å«</option> |
| | | </select> |
| | | </div> |
| | | <div class="layui-inline"> |
| | | <input type="text" class="layui-input" value="" name="ColContent" id="ColContent"> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | , { field: 'ç产订åå·', title: 'æ¹å·', width: 160 } |
| | | , { field: 'ç©æåç§°', title: 'ç©æåç§°', width: 160 } |
| | | , { field: 'ç©æä»£ç ', title: 'ç©æä»£ç ', width: 160 } |
| | | , { field: 'å¼å·¥æ¥æ', title: 'ä¸è¾¾æ¥æ', width: 160, templet: "<div>{{d.å¼å·¥æ¥æ ==null ?'':layui.util.toDateString(d.å¼å·¥æ¥æ, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'è¦æ±å®å·¥', title: 'è¦æ±å®å·¥', width: 160, templet: "<div>{{d.è¦æ±å®å·¥ ==null ?'':layui.util.toDateString(d.è¦æ±å®å·¥, 'yyyy-MM-dd')}}</div>" } |
| | | , { field: 'å¼å·¥æ¥æ', title: 'ä¸è¾¾æ¥æ', width: 160, templet: "<div>{{d.å¼å·¥æ¥æ ==null ?'':layui.util.toDateString(d.å¼å·¥æ¥æ, 'yyyy-MM-dd HH:mm:ss')}}</div>" } |
| | | , { field: 'è¦æ±å®å·¥', title: 'è¦æ±å®å·¥', width: 160, templet: "<div>{{d.è¦æ±å®å·¥ ==null ?'':layui.util.toDateString(d.è¦æ±å®å·¥, 'yyyy-MM-dd HH:mm:ss')}}</div>" } |
| | | , { field: 'å
è£
æ è¯', title: 'å
è£
æ è¯', width: 200 } |
| | | , { field: 'æ´æ¹', title: 'æ´æ¹', width: 160, totalRow: true } |
| | | , { field: 'æ¥åºæ°é', title: 'æ¥åº', width: 160, totalRow: true} |
| | |
| | | // } |
| | | // } |
| | | //} |
| | | |
| | | if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") { |
| | | ColFilter(); |
| | | } |
| | | table.render(option); |
| | | layer.close(wait); |
| | | } else { |
| | |
| | | var HSTATUS = $("#HSTATUS").val();//ç产订åç¶æ |
| | | var HOrgID = sessionStorage["OrganizationID"]; |
| | | var checkWRuku = $("input[name='checkWRuku']").prop("checked");//å¤éæ¡ |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | | var sWhere1 = ""; |
| | | if (ColName != 0 && Comparator != 0) { |
| | | var com = ""; |
| | | switch (Comparator) { |
| | | case "7": |
| | | com = "like''%" + ColContent + "%''"; |
| | | break; |
| | | case "8": |
| | | com = "like''%" + ColContent + "''"; |
| | | break; |
| | | case "9": |
| | | com = "like''" + ColContent + "%''"; |
| | | break; |
| | | case "10": |
| | | com = "not like''%" + ColContent + "%''"; |
| | | break; |
| | | default: |
| | | com = "" + Comparator + "''" + ColContent + "''"; |
| | | break; |
| | | } |
| | | sWhere1 += " and " + ColName + " " + com; |
| | | } |
| | | |
| | | if (checkWRuku) { |
| | | checkWRuku = 1; |
| | |
| | | , IsTrue: checkWRuku |
| | | , HState: HState |
| | | , HSTATUS: HSTATUS |
| | | , sWhere1: sWhere1 |
| | | } |
| | | |
| | | get_Display(JSON.stringify(sWhere)); |
| | |
| | | } |
| | | //éç½®è¿æ»¤æ¡ä»¶ |
| | | function set_ClearQuery() { |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | $("#HBeginDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 10), "yyyy-MM-dd"));//å¼å§æ¥æ |
| | | $("#HEndDate").val(Format(new Date(), "yyyy-MM-dd"));//ç»ææ¥æ |
| | | $("#HICMOBillNo").val(""); |
| | | $("#HProcExchBillNo").val(""); |
| | |
| | | $("#HMaterNumber").val(""); |
| | | $("#F_BSV_WYID").val(""); |
| | | $("#HState").val("0") |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |
| | | $("input[name='checkWRuku']").prop("checked", false); |
| | | form.render() |
| | | sWhere = ""; |
| | |
| | | }) |
| | | } |
| | | |
| | | //åææ¾ç¤ºä¸ææ¡ |
| | | function ColFilter() { |
| | | var Organization = '<option value="0" selected="selected" ></option>'; |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | if (option.cols[0][i].hide != true) { |
| | | Organization += '<option style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>'; |
| | | } |
| | | } |
| | | $("#ColName").empty(); |
| | | $("#ColName").append(Organization); |
| | | form.render('select'); |
| | | } |
| | | |
| | | |
| | | //#endregion |
| | | }); |