YL
2022-02-24 46f0ff7b0ec76be726946b6bda4097dcfa337763
WebTM/views/PublicPage/HSourceReportHtml.html
@@ -93,7 +93,6 @@
            var OperationType = params[params[0]];//操作类型
            var linterid = params[params[1]];//源单id
            var HSouceBillType =  decodeURI(params[params[2]]);//源单类型
            console.log(HSouceBillType);
        }
        var cols_arr = []; //存储表格头的数组
        var table = null;
@@ -200,7 +199,6 @@
                    async: false,
                    dataType: "json",//数据类型可以为 text xml json  script  jsonp
                    success: function (data1) {
                        console.log(data1);
                        for (var key in data1.list) {
                            resultTableHead.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });
                        }
@@ -220,7 +218,7 @@
                cols_arr[0] = [];
                cols_arr[0][0] = { checkbox: true, fixed: true, totalRowText: '合计' };
                for (var i = 0; i < data.length; i++) {
                    if (data[i].name.substr(0, 1) == 'H') {
                    if (data[i].name.substr(0, 1) == 'H' || data[i].name.substr(0, 1) == 'h') {
                        cols_arr[0][i + 1] = { field: data[i].id, title: data[i].name, align: 'center', hide: true }; //隐藏id列
                    }
                    else {
@@ -248,7 +246,7 @@
                    id: 'layTable', //表格id
                    where: { sWhere: sWhere, HSouceBillType: HSouceBillType, HOrgID: linterid }, //扩展参数,可以传数据到后台
                    page: true,   //开启分页
                    totalRow: true, //开启合计
                    totalRow: false, //开启合计
                    limit: 50,     //一页能够显示的最大数目
                    limits: [50, 500, 2000, 20000], //控制多少行一页(默认五条一页)
                    method: 'get',  //提交方式
@@ -284,15 +282,51 @@
                        return sWhere;
                        break;
                    case '生产汇报单':
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        return sWhere;
                        break;
                    case '采购订单':
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        return sWhere;
                        break;
                    case '收料通知单':
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        return sWhere;
                        break;
                    case '委外订单':
                        if (HBillNo) {
                            sWhere += " and 单据号 like '%" + HBillNo + "%'";
                        }
                        if (PartNumber) {
                            sWhere += " and 物料代码 like '%" + PartNumber + "%'";
                        }
                        if (PartName) {
                            sWhere += " and 物料名称 like '%" + PartName + "%'";
                        }
                        return sWhere;
                        break;
                    case '退货通知单':