| | |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.flow.mapper.ChongZhMapper; |
| | | import com.flow.mapper.ManagerMapper; |
| | | import com.flow.mapper.TbFuwuqiMapper; |
| | | import com.flow.mapper.zongInvoicesMapper; |
| | | import com.flow.pojo.Chongzhi; |
| | | import com.flow.pojo.Manager; |
| | | import com.flow.pojo.TbFuwuqi; |
| | | import com.flow.pojo.Zonginvoices; |
| | | import com.flow.service.zongInvoicesService; |
| | | import com.github.pagehelper.PageHelper; |
| | |
| | | |
| | | public PageInfo<Zonginvoices> findinvoicesjilu(Integer page, Integer limit) { |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | queryWrapper.eq("none", "0"); |
| | | PageHelper.startPage(page, limit); |
| | | List<Zonginvoices> cardList = ((zongInvoicesMapper)this.baseMapper).selectList(queryWrapper); |
| | | PageInfo<Zonginvoices> info = new PageInfo(cardList); |
| | |
| | | |
| | | public PageInfo<Zonginvoices> findinvoicesjilu(Integer page, Integer limit, Zonginvoices zonginvoices) { |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | queryWrapper.eq("none", "0"); |
| | | queryWrapper.eq("company", zonginvoices.getCompany()); |
| | | PageHelper.startPage(page, limit); |
| | | List<Zonginvoices> cardList = ((zongInvoicesMapper)this.baseMapper).selectList(queryWrapper); |
| | |
| | | queryWrapper.eq("sqnum", zonginvoices.getSqnum()); |
| | | return (Zonginvoices)((zongInvoicesMapper)this.baseMapper).selectOne(queryWrapper); |
| | | } |
| | | public int UpdateKaiPiao(Zonginvoices zonginvoices) { |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | queryWrapper.eq("sqnum", zonginvoices.getSqnum()); |
| | | // TbFuwuqi tbFuwuqi1 = (TbFuwuqi)((TbFuwuqiMapper)this.baseMapper).selectOne(queryWrapper); |
| | | // OperationLog operationLog = new OperationLog(); |
| | | // operationLog.setCaozuotype("修改"); |
| | | // operationLog.setCaozuocontent("修改服务器:"+tbFuwuqi1.getServername()); |
| | | // operationLogService.addOperationLog(operationLog); |
| | | |
| | | return ((zongInvoicesMapper) this.baseMapper).update(zonginvoices, queryWrapper); |
| | | } |
| | | |
| | | |
| | | public int DeleteKaiPiao(String kaipiaoId) { |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | queryWrapper.eq("sqnum", kaipiaoId); |
| | | Zonginvoices zonginvoices = new Zonginvoices(); |
| | | zonginvoices.setNone("1"); |
| | | // Company company1 = (Company)((CompanyMapper)this.baseMapper).selectOne(queryWrapper); |
| | | // OperationLog operationLog = new OperationLog(); |
| | | // operationLog.setCaozuotype("删除"); |
| | | // operationLog.setCaozuocontent("删除公司:"+company1.getCompanyname()); |
| | | // operationLogService.addOperationLog(operationLog); |
| | | return ((zongInvoicesMapper)this.baseMapper).update(zonginvoices, queryWrapper); |
| | | } |
| | | |
| | | public int adddanhao(Zonginvoices zonginvoices) { |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | queryWrapper.eq("sqnum", zonginvoices.getSqnum()); |
| | | return ((zongInvoicesMapper)this.baseMapper).update(zonginvoices, queryWrapper); |
| | | } |
| | | |
| | | public PageInfo<Zonginvoices> tableSearch(Zonginvoices manager, int page, int limit) throws Exception { |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | PageHelper.startPage(page, limit); |
| | | PageInfo<Zonginvoices> info = null; |
| | | queryWrapper.like("fptt", manager.getFptt()); |
| | | queryWrapper.eq("none", 0); |
| | | info = new PageInfo(((zongInvoicesMapper) this.baseMapper).selectList(queryWrapper)); |
| | | |
| | | |
| | | return info; |
| | | } |
| | | |
| | | } |