| | |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HCusID" id="HCusID" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline" style="display:none;"> |
| | | <label class="layui-form-label">é¨é¨</label> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æä»£ç </label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HDeptID" id="HDeptID" style="width:190px;"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HMaterNumber" id="HMaterNumber" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline" style="display:none;"> |
| | | <label class="layui-form-label">主管</label> |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label">ç©æåç§°</label> |
| | | <div class="layui-input-block"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HMangerID" id="HMangerID" style="width:190px;"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HMaterName" id="HMaterName" style="width:190px;"> |
| | | </div> |
| | | </div> |
| | | |
| | |
| | | var HEndDate = $("#HEndDate").val();//ç»ææ¥æ |
| | | var HBillNo = $("#HBillNo").val();//åæ®å· |
| | | var HCusID = $("#HCusID").val(); |
| | | var HDeptID = $("#HDeptID").val(); |
| | | var HMangerID = $("#HMangerID").val(); |
| | | var HMaterNumber = $("#HMaterNumber").val(); |
| | | var HMaterName = $("#HMaterName").val(); |
| | | var ColName = $("#ColName").val();//å¤éæ¡ |
| | | var Comparator = $("#Comparator").val() |
| | | var ColContent = $("#ColContent").val(); |
| | |
| | | if (HCusID) { |
| | | sWhere += " and å®¢æ· like '%" + HCusID + "%'"; |
| | | } |
| | | //if (HDeptID) { |
| | | // sWhere += " and é¨é¨ like '%" + HDeptID + "%'"; |
| | | //} |
| | | //if (HMangerID) { |
| | | // sWhere += " and 主管 like '%" + HMangerID + "%'"; |
| | | //} |
| | | if (HMaterNumber) { |
| | | sWhere += " and ç©æä»£ç like '%" + HMaterNumber + "%'"; |
| | | } |
| | | if (HMaterName) { |
| | | sWhere += " and ç©æåç§° like '%" + HMaterName + "%'"; |
| | | } |
| | | |
| | | //æ ¹æ®ç¨æ·è¿æ»¤ç¨æ·å
³è客æ·çè®°å½ |
| | | sWhere += getSWhereByHUser(); |
| | |
| | | $("#HEndDate").val("");//ç»ææ¥æ |
| | | $("#HBillNo").val("");// |
| | | $("#HCusID").val(""); |
| | | $("#HDeptID").val(""); |
| | | $("#HMangerID").val(""); |
| | | $("#HMaterNumber").val(""); |
| | | $("#HMaterName").val(""); |
| | | $("#ColContent").val(""); |
| | | $("#ColName").val("0"); |
| | | $("#Comparator").val("0"); |