| | |
| | | */ |
| | | private String clock; |
| | | /** |
| | | * 蒸汽发生 |
| | | * 蒸汽发生/总产生 |
| | | */ |
| | | private BigDecimal steamP; |
| | | /** |
| | | * 蒸汽消耗 |
| | | * 吨焦产蒸汽 |
| | | */ |
| | | private BigDecimal djSteamP; |
| | | /** |
| | | * 蒸汽消耗/总耗 |
| | | */ |
| | | private BigDecimal steamC; |
| | | /** |
| | | * 蒸汽单耗 |
| | | */ |
| | | private BigDecimal steamOnlyC; |
| | | /** |
| | | * 蒸汽量 |
| | | */ |
| | |
| | | */ |
| | | private BigDecimal gasC; |
| | | /** |
| | | * 电力消耗 |
| | | * 电力消耗/总耗 |
| | | */ |
| | | private BigDecimal powerC; |
| | | /** |
| | | * 电力单耗 |
| | | */ |
| | | private BigDecimal powerOnlyC; |
| | | /** |
| | | * 电耗基准 |
| | | */ |
| | | private BigDecimal powerCStandard; |
| | | /** |
| | | * 空转时间 |
| | | */ |
| | | private BigDecimal idleTime; |
| | | /** |
| | | * BFG消耗 |
| | | * BFG消耗/总耗 |
| | | */ |
| | | private BigDecimal bfgC; |
| | | /** |
| | | * cog回收 |
| | | * COG回收 |
| | | */ |
| | | private BigDecimal cogP; |
| | | /** |
| | | * cog消耗 |
| | | * COG消耗/总耗 |
| | | */ |
| | | private BigDecimal cogC; |
| | | |
| | |
| | | QueryWrapper<CokingOverviewEntity> queryWrapperMonth = new QueryWrapper<>(); |
| | | queryWrapperMonth.eq("process_type", processType); |
| | | queryWrapperMonth.like("clock", month); |
| | | queryWrapperMonth.select("sub_process_type","SUM(steam_p) as steam_p","SUM(steam_c) as steam_c","SUM(steam_v) as steam_v","SUM(gas_p) as gas_p","SUM(gas_c) as gas_c","SUM(power_c) as power_c","SUM(idle_time) as idle_time","SUM(bfg_c) as bfg_c","SUM(cog_p) as cog_p","SUM(cog_c) as cog_c","SUM(bfg_only_c) as bfg_only_c","SUM(cog_only_c) as cog_only_c") |
| | | queryWrapperMonth.select("sub_process_type","SUM(steam_p) as steam_p","SUM(dj_steam_p) as dj_steam_p","SUM(steam_c) as steam_c","SUM(steam_only_c) as steam_only_c","SUM(steam_v) as steam_v","SUM(gas_p) as gas_p","SUM(gas_c) as gas_c","SUM(power_c) as power_c","SUM(power_only_c) as power_only_c","SUM(power_c_standard) as power_c_standard","SUM(idle_time) as idle_time","SUM(bfg_c) as bfg_c","SUM(cog_p) as cog_p","SUM(cog_c) as cog_c","SUM(bfg_only_c) as bfg_only_c","SUM(cog_only_c) as cog_only_c") |
| | | .groupBy("sub_process_type"); |
| | | |
| | | List<CokingOverviewEntity> monthList = cokingOverviewDao.selectList(queryWrapperMonth); |