一后端

1:entity

package com.woniu.community.entity;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;@Data
@AllArgsConstructor
@NoArgsConstructor
public class Records {private int  id;private int typeId;private Double num;private Double num2;private int  houseId;private String upTime;private String onTime;private String checkTime;private String meter;private String remarks;private String userName;private String numbers;private String typeName;}

2:RecordsMapper

package com.woniu.community.mapper;import com.woniu.community.entity.PropertyInfo;
import com.woniu.community.entity.Records;import java.util.List;public interface RecordsMapper {List selectAll(int start, int size , String numbers, String typeName);int  count(String numbers,String typeName);int  insertRecords(Records records);int  deleteRecords(int id);}

3:IRecordsService

package com.woniu.community.service;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.Records;import java.util.List;public interface IRecordsService {HttpResult selectAll(int pageIndex, int pageSize , String numbers, String typeName);HttpResult  insertRecords(Records records);HttpResult  deleteRecords(int id);}

4:RecordsServiceImpl

package com.woniu.community.service.impl;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.Records;
import com.woniu.community.mapper.RecordsMapper;
import com.woniu.community.service.IRecordsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;@Service
public class RecordsServiceImpl implements IRecordsService {@Autowired(required = false)private RecordsMapper recordsMapper;@Overridepublic HttpResult selectAll(int pageIndex, int pageSize, String numbers, String typeName) {HttpResult result=null;List records = recordsMapper.selectAll((pageIndex - 1) * pageSize, pageSize, numbers, typeName);int count = recordsMapper.count(numbers, typeName);if (records!=null&&records.size()>0){result  =new HttpResult(records,count,200,null);}else{result  =new HttpResult(null,0,500,"没有更多数据");}return result;}@Overridepublic HttpResult insertRecords(Records records) {HttpResult result=null;int count = recordsMapper.insertRecords(records);if (count>0){result=new HttpResult(null,0,200,"添加成功");}else{result=new HttpResult(null,0,500,"添加失败");}return result;}@Overridepublic HttpResult deleteRecords(int id) {HttpResult result=null;int count = recordsMapper.deleteRecords(id);if (count>0){result=new HttpResult(null,0,200,"删除成功");}else{result=new HttpResult(null,0,500,"删除失败");}return result;}
}

5:RecordsController

package com.woniu.community.controller;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.Records;
import com.woniu.community.service.IRecordsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;@RestController
@RequestMapping("/records")
@CrossOrigin(origins = "*")
public class RecordsController {@Autowiredprivate IRecordsService iRecordsService;@RequestMapping("/list")HttpResult selectAll(int pageIndex, int pageSize , String numbers, String typeName){return  iRecordsService.selectAll(pageIndex,pageSize,numbers,typeName);}@PostMapping("add")HttpResult  insertRecords(@RequestBody  Records records){return iRecordsService.insertRecords(records);}@RequestMapping("/delete")HttpResult  deleteRecords(int id){return iRecordsService.deleteRecords(id);}
}

6:RecordsMapper.xml

select h.numbers,o.username,r.*,p.namefrom  house h left join  owner o ono.house_id=h.idleft join records r onr.house_id=h.idleft join property_type p onr.type_id=p.idand  numbers=#{numbers}and  name=#{typeName}limit #{start},#{size}select count(r.id)from  house h left join  owner o ono.house_id=h.idleft join records r onr.house_id=h.idleft join property_type p onr.type_id=p.idand  numbers=#{numbers}and  name=#{typeName}insert  into records(house_id,type_id,num,num2,check_time,meter)values (#{houseId},#{typeId},#{num},#{num2},#{checkTime},#{meter})delete from records where  id=#{id}

二 前端代码

门牌号:费用类型:搜索
新增
抄表管理
门牌号
户主
费用类型
上次度数
本次度数
登记时间
抄表员
操作
{{o.numbers}}
{{o.userName}}
{{o.typeName}}
{{o.num}}
{{o.num2}}
{{o.checkTime}}
{{o.meter}}
删除
{{p}}
{{p}}

{{title}}
门牌号:{{h.numbers}}
费用类型:水费电费物业费停车费
上次度数:
本次度数:
登记时间:抄表员:
保存取消

三 页面效果