zrg
2024-06-17 48b598fdf2a2408ef4e075e0fa1d88324f75def8
WebTM/views/²É¹º¹ÜÀí/²É¹º±¨±í/Cg_POOrderBillProcessSumReport.html
@@ -36,7 +36,7 @@
                                <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">
@@ -320,7 +320,7 @@
                    var com = "";
                    switch (Comparator) {
                        case "7":
                            com = "like''%" + ColContent + "%''";
                            com = "like '%" + ColContent + "%'";
                            break;
                        case "8":
                            com = "like''%" + ColContent + "''";
@@ -338,13 +338,13 @@
                    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 + "%''";