| | |
| | | " order by hmainid"; |
| | | } else if (this.$route.query.Type == "HGyStockPlaceBarCode") { |
| | | let condition = decodeURI(this.handleMessage.linterid.toString()); |
| | | sql = `SELECT |
| | | CEILING(CAST(t.row_num AS FLOAT) / 2) AS orderid, |
| | | MAX(CASE WHEN t.row_num % 2 = 1 THEN t.条码编号 END) AS 条码编号1, |
| | | MAX(CASE WHEN t.row_num % 2 = 1 THEN t.仓位名称 END) AS 仓位名称1, |
| | | MAX(CASE WHEN t.row_num % 2 = 0 THEN t.条码编号 END) AS 条码编号2, |
| | | MAX(CASE WHEN t.row_num % 2 = 0 THEN t.仓位名称 END) AS 仓位名称2 |
| | | FROM ( |
| | | SELECT |
| | | 条码编号, 仓位名称, |
| | | ROW_NUMBER() OVER (ORDER BY t1.HItemID) AS row_num |
| | | FROM h_v_IF_StockPlaceList t1 where 条码编号 in (${condition}) |
| | | ) AS t |
| | | GROUP BY CEILING(CAST(t.row_num AS FLOAT) / 2) |
| | | ORDER BY orderid;`; |
| | | condition = condition.split(',').map(e => `'${e}'`).join(',') |
| | | sql = `exec h_p_GetSPBarCode_Swell N'${condition}'`; |
| | | } |
| | | try{ |
| | | let res = await axios.get(this.baseUrl + "/CommonModel/searchMethod", { |