| | |
| | | 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; |
| | |
| | | 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 }); |
| | | } |
| | |
| | | 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 { |
| | |
| | | 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', //提交方式 |
| | |
| | | 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 '退货通知单': |