| | |
| | | */ |
| | | private BigDecimal number; |
| | | |
| | | private String deviceBrand; |
| | | |
| | | private String storageLocation; |
| | | |
| | | /** |
| | | * 含税单价 |
| | | */ |
| | |
| | | */ |
| | | private BigDecimal unTaxIncludingPriceTotal; |
| | | |
| | | private String deviceBrand; |
| | | |
| | | private String storageLocation; |
| | | |
| | | /** |
| | | * 录入时间 |
| | | */ |
| | |
| | | |
| | | <select id="queryPage" resultType="com.ruoyi.device.dto.DeviceLedgerDto"> |
| | | SELECT |
| | | dl.id, |
| | | dl.device_name, |
| | | dl.device_model, |
| | | dl.supplier_name, |
| | | dl.unit, |
| | | dl.number, |
| | | dl.status, |
| | | dl.plan_runtime_time, |
| | | dl.start_runtime_time, |
| | | dl.end_runtime_time, |
| | | dl.runtime_duration, |
| | | dl.tax_including_price_unit, |
| | | dl.tax_including_price_total, |
| | | dl.tax_rate, |
| | | dl.un_tax_including_price_total, |
| | | dl.create_time, |
| | | dl.update_time , |
| | | su.user_name AS createUser, |
| | | dl.update_user, |
| | | dl.tenant_id |
| | | dl.*, |
| | | su.user_name AS createUser |
| | | FROM device_ledger dl |
| | | left join sys_user su on dl.create_user = su.user_id |
| | | <where> |