| | |
| | | <div class="layui-inline"> |
| | | <label class="layui-form-label" style="width: 85px;">éè´è®¢åå·è®¢åå·</label> |
| | | <div class="layui-input-block" style="margin-left: 120px;"> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="" id=""> |
| | | <input type="text" class="layui-input ForFilteringSchemes" name="HBillNo" id="HBillNo"> |
| | | </div> |
| | | </div> |
| | | <div class="layui-inline"> |
| | |
| | | var com = ""; |
| | | switch (Comparator) { |
| | | case "7": |
| | | com = "like''%" + ColContent + "%''"; |
| | | com = "like '%" + ColContent + "%'"; |
| | | break; |
| | | case "8": |
| | | com = "like''%" + ColContent + "''"; |
| | |
| | | sWhere += " and " + ColName + " " + com; |
| | | } |
| | | if (HBillNo) { |
| | | sWhere += " and éå®è®¢åå· like ''%" + HBillNo + "%''"; |
| | | sWhere += " and éè´è®¢åå· like ''%" + HBillNo + "%''"; |
| | | } |
| | | if (HBeginDate) { |
| | | sWhere += " and CONVERT(varchar(100),å¼å§æ¶é´, 23) >= ''" + HBeginDate + "''"; |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= ''" + HBeginDate + "''"; |
| | | } |
| | | if (HEndDate) { |
| | | sWhere += " and CONVERT(varchar(100),å
³éæ¶é´, 23) <= ''" + HEndDate + "''"; |
| | | sWhere += " and CONVERT(varchar(100),æ¥æ, 23) <= ''" + HEndDate + "''"; |
| | | } |
| | | if (HName) { |
| | | sWhere += " and ä¾åºååç§° like ''%" + HName + "%''"; |