| | |
| | | * æ¥è¯¢æç®å¨å®ç§»æ¤å表 |
| | | */ |
| | | @ApiOperation("æ¥è¯¢æç®å¨å®ç§»æ¤å表") |
| | | // @PreAuthorize("@ss.hasPermi('project:donatecomporgan:list')") |
| | | @PreAuthorize("@ss.hasPermi('project:donatecomporgan:list')") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(ServiceDonatecomporgan serviceDonatecomporgan) { |
| | | startPage(); |
| | |
| | | * å¯¼åºæç®å¨å®ç§»æ¤å表 |
| | | */ |
| | | @ApiOperation("å¯¼åºæç®å¨å®ç§»æ¤å表") |
| | | // @PreAuthorize("@ss.hasPermi('project:donatecomporgan:export')") |
| | | @PreAuthorize("@ss.hasPermi('project:donatecomporgan:export')") |
| | | @Log(title = "æç®å¨å®ç§»æ¤", businessType = BusinessType.EXPORT) |
| | | @GetMapping("/export") |
| | | public AjaxResult export(ServiceDonatecomporgan serviceDonatecomporgan) { |
| | |
| | | * è·åæç®å¨å®ç§»æ¤è¯¦ç»ä¿¡æ¯ |
| | | */ |
| | | @ApiOperation("è·åæç®å¨å®ç§»æ¤è¯¦ç»ä¿¡æ¯") |
| | | // @PreAuthorize("@ss.hasPermi('project:donatecomporgan:query')") |
| | | @PreAuthorize("@ss.hasPermi('project:donatecomporgan:query')") |
| | | @GetMapping(value = "/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") Long id) { |
| | | return AjaxResult.success(serviceDonatecomporganService.getById(id)); |
| | |
| | | * æ°å¢æç®å¨å®ç§»æ¤ |
| | | */ |
| | | @ApiOperation("æ°å¢æç®å¨å®ç§»æ¤") |
| | | // @PreAuthorize("@ss.hasPermi('project:donatecomporgan:add')") |
| | | @PreAuthorize("@ss.hasPermi('project:donatecomporgan:add')") |
| | | @Log(title = "æç®å¨å®ç§»æ¤", businessType = BusinessType.INSERT) |
| | | @PostMapping("/add") |
| | | @RepeatSubmit |
| | |
| | | * ä¿®æ¹æç®å¨å®ç§»æ¤ |
| | | */ |
| | | @ApiOperation("ä¿®æ¹æç®å¨å®ç§»æ¤") |
| | | // @PreAuthorize("@ss.hasPermi('project:donatecomporgan:edit')") |
| | | @PreAuthorize("@ss.hasPermi('project:donatecomporgan:edit')") |
| | | @Log(title = "æç®å¨å®ç§»æ¤", businessType = BusinessType.UPDATE) |
| | | @PostMapping("/edit") |
| | | @RepeatSubmit |
| | |
| | | * å 餿ç®å¨å®ç§»æ¤ |
| | | */ |
| | | @ApiOperation("å 餿ç®å¨å®ç§»æ¤") |
| | | // @PreAuthorize("@ss.hasPermi('project:donatecomporgan:remove')") |
| | | @PreAuthorize("@ss.hasPermi('project:donatecomporgan:remove')") |
| | | @Log(title = "æç®å¨å®ç§»æ¤", businessType = BusinessType.DELETE) |
| | | @GetMapping("/remove/{ids}") |
| | | public AjaxResult remove(@PathVariable Long[] ids) { |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.web.controller.project; |
| | | |
| | | import com.ruoyi.common.annotation.Log; |
| | | import com.ruoyi.common.annotation.RepeatSubmit; |
| | | import com.ruoyi.common.core.controller.BaseController; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.core.page.TableDataInfo; |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.project.domain.ServiceDonateorganstatics; |
| | | import com.ruoyi.project.service.IServiceDonateorganstaticsService; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.security.access.prepost.PreAuthorize; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.util.Arrays; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®åController |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | @Api("æç®æ¡ä¾å¨å®å") |
| | | @RestController |
| | | @RequestMapping("/project/donateorganstatics") |
| | | public class ServiceDonateorganstaticsController extends BaseController |
| | | { |
| | | @Autowired |
| | | private IServiceDonateorganstaticsService serviceDonateorganstaticsService; |
| | | |
| | | /** |
| | | * æ¥è¯¢æç®æ¡ä¾å¨å®åå表 |
| | | */ |
| | | @ApiOperation("æ¥è¯¢æç®æ¡ä¾å¨å®åå表") |
| | | @PreAuthorize("@ss.hasPermi('project:donateorganstatics:list')") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(ServiceDonateorganstatics serviceDonateorganstatics) |
| | | { |
| | | startPage(); |
| | | List<ServiceDonateorganstatics> list = serviceDonateorganstaticsService.queryList(serviceDonateorganstatics); |
| | | return getDataTable(list); |
| | | } |
| | | |
| | | /** |
| | | * å¯¼åºæç®æ¡ä¾å¨å®åå表 |
| | | */ |
| | | @ApiOperation("å¯¼åºæç®æ¡ä¾å¨å®åå表") |
| | | @PreAuthorize("@ss.hasPermi('project:donateorganstatics:export')") |
| | | @Log(title = "æç®æ¡ä¾å¨å®å", businessType = BusinessType.EXPORT) |
| | | @GetMapping("/export") |
| | | public AjaxResult export(ServiceDonateorganstatics serviceDonateorganstatics) |
| | | { |
| | | List<ServiceDonateorganstatics> list = serviceDonateorganstaticsService.queryList(serviceDonateorganstatics); |
| | | ExcelUtil<ServiceDonateorganstatics> util = new ExcelUtil<ServiceDonateorganstatics>(ServiceDonateorganstatics.class); |
| | | return util.exportExcel(list, "æç®æ¡ä¾å¨å®åæ°æ®"); |
| | | } |
| | | |
| | | /** |
| | | * è·åæç®æ¡ä¾å¨å®å详ç»ä¿¡æ¯ |
| | | */ |
| | | @ApiOperation("è·åæç®æ¡ä¾å¨å®å详ç»ä¿¡æ¯") |
| | | @PreAuthorize("@ss.hasPermi('project:donateorganstatics:query')") |
| | | @GetMapping(value = "/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") Long id) |
| | | { |
| | | return AjaxResult.success(serviceDonateorganstaticsService.getById(id)); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢æç®æ¡ä¾å¨å®å |
| | | */ |
| | | @ApiOperation("æ°å¢æç®æ¡ä¾å¨å®å") |
| | | @PreAuthorize("@ss.hasPermi('project:donateorganstatics:add')") |
| | | @Log(title = "æç®æ¡ä¾å¨å®å", businessType = BusinessType.INSERT) |
| | | @PostMapping |
| | | @RepeatSubmit |
| | | public AjaxResult add(@RequestBody ServiceDonateorganstatics serviceDonateorganstatics) |
| | | { |
| | | return toAjax(serviceDonateorganstaticsService.save(serviceDonateorganstatics)); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹æç®æ¡ä¾å¨å®å |
| | | */ |
| | | @ApiOperation("ä¿®æ¹æç®æ¡ä¾å¨å®å") |
| | | @PreAuthorize("@ss.hasPermi('project:donateorganstatics:edit')") |
| | | @Log(title = "æç®æ¡ä¾å¨å®å", businessType = BusinessType.UPDATE) |
| | | @PutMapping |
| | | @RepeatSubmit |
| | | public AjaxResult edit(@RequestBody ServiceDonateorganstatics serviceDonateorganstatics) |
| | | { |
| | | return toAjax(serviceDonateorganstaticsService.updateById(serviceDonateorganstatics)); |
| | | } |
| | | |
| | | /** |
| | | * å é¤æç®æ¡ä¾å¨å®å |
| | | */ |
| | | @ApiOperation("å é¤æç®æ¡ä¾å¨å®å") |
| | | @PreAuthorize("@ss.hasPermi('project:donateorganstatics:remove')") |
| | | @Log(title = "æç®æ¡ä¾å¨å®å", businessType = BusinessType.DELETE) |
| | | @DeleteMapping("/{ids}") |
| | | public AjaxResult remove(@PathVariable Long[] ids) |
| | | { |
| | | return toAjax(serviceDonateorganstaticsService.removeByIds(Arrays.asList(ids))); |
| | | } |
| | | } |
| | |
| | | * æ¥è¯¢æç®å¨å®è·åå表 |
| | | */ |
| | | @ApiOperation("æ¥è¯¢æç®å¨å®è·åå表") |
| | | @PreAuthorize("@ss.hasPermi('system:donationwitnessorgan:list')") |
| | | // @PreAuthorize("@ss.hasPermi('project:donationwitnessorgan:list')") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(ServiceDonationwitnessorgan serviceDonationwitnessorgan) { |
| | | startPage(); |
| | |
| | | * å¯¼åºæç®å¨å®è·åå表 |
| | | */ |
| | | @ApiOperation("å¯¼åºæç®å¨å®è·åå表") |
| | | @PreAuthorize("@ss.hasPermi('system:donationwitnessorgan:export')") |
| | | // @PreAuthorize("@ss.hasPermi('project:donationwitnessorgan:export')") |
| | | @Log(title = "æç®å¨å®è·å", businessType = BusinessType.EXPORT) |
| | | @GetMapping("/export") |
| | | public AjaxResult export(ServiceDonationwitnessorgan serviceDonationwitnessorgan) { |
| | |
| | | * è·åæç®å¨å®è·å详ç»ä¿¡æ¯ |
| | | */ |
| | | @ApiOperation("è·åæç®å¨å®è·å详ç»ä¿¡æ¯") |
| | | @PreAuthorize("@ss.hasPermi('system:donationwitnessorgan:query')") |
| | | // @PreAuthorize("@ss.hasPermi('project:donationwitnessorgan:query')") |
| | | @GetMapping(value = "/getInfo/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") Long id) { |
| | | return AjaxResult.success(serviceDonationwitnessorganService.getById(id)); |
| | |
| | | * æ°å¢æç®å¨å®è·å |
| | | */ |
| | | @ApiOperation("æ°å¢æç®å¨å®è·å") |
| | | @PreAuthorize("@ss.hasPermi('system:donationwitnessorgan:add')") |
| | | // @PreAuthorize("@ss.hasPermi('project:donationwitnessorgan:add')") |
| | | @Log(title = "æç®å¨å®è·å", businessType = BusinessType.INSERT) |
| | | @PostMapping("/add") |
| | | @RepeatSubmit |
| | |
| | | * ä¿®æ¹æç®å¨å®è·å |
| | | */ |
| | | @ApiOperation("ä¿®æ¹æç®å¨å®è·å") |
| | | @PreAuthorize("@ss.hasPermi('system:donationwitnessorgan:edit')") |
| | | // @PreAuthorize("@ss.hasPermi('project:donationwitnessorgan:edit')") |
| | | @Log(title = "æç®å¨å®è·å", businessType = BusinessType.UPDATE) |
| | | @PostMapping("/edit") |
| | | @RepeatSubmit |
| | |
| | | * å 餿ç®å¨å®è·å |
| | | */ |
| | | @ApiOperation("å 餿ç®å¨å®è·å") |
| | | @PreAuthorize("@ss.hasPermi('system:donationwitnessorgan:remove')") |
| | | // @PreAuthorize("@ss.hasPermi('project:donationwitnessorgan:remove')") |
| | | @Log(title = "æç®å¨å®è·å", businessType = BusinessType.DELETE) |
| | | @GetMapping("/remove/{ids}") |
| | | public AjaxResult remove(@PathVariable Long[] ids) { |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.web.controller.project; |
| | | |
| | | import com.ruoyi.common.annotation.Log; |
| | | import com.ruoyi.common.annotation.RepeatSubmit; |
| | | import com.ruoyi.common.core.controller.BaseController; |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.core.page.TableDataInfo; |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.project.domain.ServiceDonorcharge; |
| | | import com.ruoyi.project.service.IServiceDonorchargeService; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.security.access.prepost.PreAuthorize; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.util.Arrays; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®åController |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | @Api("æç®æ¡ä¾å¨å®å") |
| | | @RestController |
| | | @RequestMapping("/project/donorcharge") |
| | | public class ServiceDonorchargeController extends BaseController { |
| | | @Autowired |
| | | private IServiceDonorchargeService serviceDonorchargeService; |
| | | |
| | | /** |
| | | * æ¥è¯¢æç®æ¡ä¾å¨å®åå表 |
| | | */ |
| | | @ApiOperation("æ¥è¯¢æç®æ¡ä¾å¨å®åå表") |
| | | @PreAuthorize("@ss.hasPermi('project:donorcharge:list')") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(ServiceDonorcharge serviceDonorcharge) { |
| | | startPage(); |
| | | List<ServiceDonorcharge> list = serviceDonorchargeService.queryList(serviceDonorcharge); |
| | | return getDataTable(list); |
| | | } |
| | | |
| | | /** |
| | | * å¯¼åºæç®æ¡ä¾å¨å®åå表 |
| | | */ |
| | | @ApiOperation("å¯¼åºæç®æ¡ä¾å¨å®åå表") |
| | | @PreAuthorize("@ss.hasPermi('project:donorcharge:export')") |
| | | @Log(title = "æç®æ¡ä¾å¨å®å", businessType = BusinessType.EXPORT) |
| | | @GetMapping("/export") |
| | | public AjaxResult export(ServiceDonorcharge serviceDonorcharge) { |
| | | List<ServiceDonorcharge> list = serviceDonorchargeService.queryList(serviceDonorcharge); |
| | | ExcelUtil<ServiceDonorcharge> util = new ExcelUtil<ServiceDonorcharge>(ServiceDonorcharge.class); |
| | | return util.exportExcel(list, "æç®æ¡ä¾å¨å®åæ°æ®"); |
| | | } |
| | | |
| | | /** |
| | | * è·åæç®æ¡ä¾å¨å®å详ç»ä¿¡æ¯ |
| | | */ |
| | | @ApiOperation("è·åæç®æ¡ä¾å¨å®å详ç»ä¿¡æ¯") |
| | | @PreAuthorize("@ss.hasPermi('project:donorcharge:query')") |
| | | @GetMapping(value = "/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") Long id) { |
| | | return AjaxResult.success(serviceDonorchargeService.getById(id)); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢æç®æ¡ä¾å¨å®å |
| | | */ |
| | | @ApiOperation("æ°å¢æç®æ¡ä¾å¨å®å") |
| | | @PreAuthorize("@ss.hasPermi('project:donorcharge:add')") |
| | | @Log(title = "æç®æ¡ä¾å¨å®å", businessType = BusinessType.INSERT) |
| | | @PostMapping |
| | | @RepeatSubmit |
| | | public AjaxResult add(@RequestBody ServiceDonorcharge serviceDonorcharge) { |
| | | return toAjax(serviceDonorchargeService.save(serviceDonorcharge)); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹æç®æ¡ä¾å¨å®å |
| | | */ |
| | | @ApiOperation("ä¿®æ¹æç®æ¡ä¾å¨å®å") |
| | | @PreAuthorize("@ss.hasPermi('project:donorcharge:edit')") |
| | | @Log(title = "æç®æ¡ä¾å¨å®å", businessType = BusinessType.UPDATE) |
| | | @PutMapping |
| | | @RepeatSubmit |
| | | public AjaxResult edit(@RequestBody ServiceDonorcharge serviceDonorcharge) { |
| | | return toAjax(serviceDonorchargeService.updateById(serviceDonorcharge)); |
| | | } |
| | | |
| | | /** |
| | | * å é¤æç®æ¡ä¾å¨å®å |
| | | */ |
| | | @ApiOperation("å é¤æç®æ¡ä¾å¨å®å") |
| | | @PreAuthorize("@ss.hasPermi('project:donorcharge:remove')") |
| | | @Log(title = "æç®æ¡ä¾å¨å®å", businessType = BusinessType.DELETE) |
| | | @DeleteMapping("/{ids}") |
| | | public AjaxResult remove(@PathVariable Long[] ids) { |
| | | return toAjax(serviceDonorchargeService.removeByIds(Arrays.asList(ids))); |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.domain; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.ruoyi.common.annotation.Excel; |
| | | import com.ruoyi.common.core.domain.BaseEntity; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®å对象 service_donateorganstatics |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | @Data |
| | | @ApiModel("æç®æ¡ä¾å¨å®å") |
| | | public class ServiceDonateorganstatics extends BaseEntity |
| | | { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** id */ |
| | | @ApiModelProperty("id") |
| | | //æ°æ®åºèªå¢æ¹æ@TableId(type = IdType.AUTO) |
| | | @TableId(type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | | /** æç®æ¡ä¾ID */ |
| | | @ApiModelProperty("æç®æ¡ä¾ID") |
| | | @Excel(name = "æç®æ¡ä¾ID") |
| | | private Long infoid; |
| | | |
| | | /** OPOç¼å· */ |
| | | @ApiModelProperty("OPOç¼å·") |
| | | @Excel(name = "OPOç¼å·") |
| | | private String donateno; |
| | | |
| | | /** æç®æ¶é´ */ |
| | | @ApiModelProperty("æç®æ¶é´") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "æç®æ¶é´", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date donatetime; |
| | | |
| | | /** å§å */ |
| | | @ApiModelProperty("å§å") |
| | | @Excel(name = "å§å") |
| | | private String name; |
| | | |
| | | /** åºçå¹´æ */ |
| | | @ApiModelProperty("åºçå¹´æ") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "åºçå¹´æ", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date borthdate; |
| | | |
| | | /** æ§å« */ |
| | | @ApiModelProperty("æ§å«") |
| | | @Excel(name = "æ§å«") |
| | | private String sex; |
| | | |
| | | /** å¹´é¾ï¼å
å«æï¼ */ |
| | | @ApiModelProperty("å¹´é¾ï¼å
嫿ï¼") |
| | | @Excel(name = "å¹´é¾", readConverterExp = "å
=嫿") |
| | | private String age; |
| | | |
| | | /** æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory */ |
| | | @ApiModelProperty("æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory") |
| | | @Excel(name = "æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory") |
| | | private String donationcategory; |
| | | |
| | | /** å
¨èæ¥åå»é¢ */ |
| | | @ApiModelProperty("å
¨èæ¥åå»é¢") |
| | | @Excel(name = "å
¨èæ¥åå»é¢") |
| | | private String hospitalC22; |
| | | |
| | | /** å
¨èè´¹ç¨ */ |
| | | @ApiModelProperty("å
¨èè´¹ç¨") |
| | | @Excel(name = "å
¨èè´¹ç¨") |
| | | private BigDecimal feeC22; |
| | | |
| | | /** å·¦èæ¥åå»é¢ */ |
| | | @ApiModelProperty("å·¦èæ¥åå»é¢") |
| | | @Excel(name = "å·¦èæ¥åå»é¢") |
| | | private String hospitalC22l; |
| | | |
| | | /** å·¦èè´¹ç¨ */ |
| | | @ApiModelProperty("å·¦èè´¹ç¨") |
| | | @Excel(name = "å·¦èè´¹ç¨") |
| | | private BigDecimal feeC22l; |
| | | |
| | | /** å·¦å¤å¶æ¥åå»é¢ */ |
| | | @ApiModelProperty("å·¦å¤å¶æ¥åå»é¢") |
| | | @Excel(name = "å·¦å¤å¶æ¥åå»é¢") |
| | | private String hospitalC22le; |
| | | |
| | | /** å·¦å¤è´¹ç¨ */ |
| | | @ApiModelProperty("å·¦å¤è´¹ç¨") |
| | | @Excel(name = "å·¦å¤è´¹ç¨") |
| | | private BigDecimal feeC22le; |
| | | |
| | | /** å³èæ¥åå»é¢ */ |
| | | @ApiModelProperty("å³èæ¥åå»é¢") |
| | | @Excel(name = "å³èæ¥åå»é¢") |
| | | private String hospitalC22r; |
| | | |
| | | /** å³èè´¹ç¨ */ |
| | | @ApiModelProperty("å³èè´¹ç¨") |
| | | @Excel(name = "å³èè´¹ç¨") |
| | | private BigDecimal feeC22r; |
| | | |
| | | /** å·¦è¾æ¥åå»é¢ */ |
| | | @ApiModelProperty("å·¦è¾æ¥åå»é¢") |
| | | @Excel(name = "å·¦è¾æ¥åå»é¢") |
| | | private String hospitalC64l; |
| | | |
| | | /** å·¦è¾è´¹ç¨ */ |
| | | @ApiModelProperty("å·¦è¾è´¹ç¨") |
| | | @Excel(name = "å·¦è¾è´¹ç¨") |
| | | private BigDecimal feeC64l; |
| | | |
| | | /** å³è¾æ¥åå»é¢ */ |
| | | @ApiModelProperty("å³è¾æ¥åå»é¢") |
| | | @Excel(name = "å³è¾æ¥åå»é¢") |
| | | private String hospitalC64r; |
| | | |
| | | /** å³è¾è´¹ç¨ */ |
| | | @ApiModelProperty("å³è¾è´¹ç¨") |
| | | @Excel(name = "å³è¾è´¹ç¨") |
| | | private BigDecimal feeC64r; |
| | | |
| | | /** å¿èæ¥åå»é¢ */ |
| | | @ApiModelProperty("å¿èæ¥åå»é¢") |
| | | @Excel(name = "å¿èæ¥åå»é¢") |
| | | private String hospitalC38; |
| | | |
| | | /** å¿èè´¹ç¨ */ |
| | | @ApiModelProperty("å¿èè´¹ç¨") |
| | | @Excel(name = "å¿èè´¹ç¨") |
| | | private BigDecimal feeC38; |
| | | |
| | | /** åèºæ¥åå»é¢ */ |
| | | @ApiModelProperty("åèºæ¥åå»é¢") |
| | | @Excel(name = "åèºæ¥åå»é¢") |
| | | private String hospitalC34; |
| | | |
| | | /** åèºè´¹ç¨ */ |
| | | @ApiModelProperty("åèºè´¹ç¨") |
| | | @Excel(name = "åèºè´¹ç¨") |
| | | private BigDecimal feeC34; |
| | | |
| | | /** å·¦èºæ¥åå»é¢ */ |
| | | @ApiModelProperty("å·¦èºæ¥åå»é¢") |
| | | @Excel(name = "å·¦èºæ¥åå»é¢") |
| | | private String hospitalC34l; |
| | | |
| | | /** å·¦èºè´¹ç¨ */ |
| | | @ApiModelProperty("å·¦èºè´¹ç¨") |
| | | @Excel(name = "å·¦èºè´¹ç¨") |
| | | private BigDecimal feeC34l; |
| | | |
| | | /** å³èºç§»æ¤å»é¢ */ |
| | | @ApiModelProperty("å³èºç§»æ¤å»é¢") |
| | | @Excel(name = "å³èºç§»æ¤å»é¢") |
| | | private String hospitalC34r; |
| | | |
| | | /** å³èºè´¹ç¨ */ |
| | | @ApiModelProperty("å³èºè´¹ç¨") |
| | | @Excel(name = "å³èºè´¹ç¨") |
| | | private BigDecimal feeC34r; |
| | | |
| | | /** å°è æ¥åå»é¢ */ |
| | | @ApiModelProperty("å°è æ¥åå»é¢") |
| | | @Excel(name = "å°è æ¥åå»é¢") |
| | | private String hospitalC17; |
| | | |
| | | /** å°è è´¹ç¨ */ |
| | | @ApiModelProperty("å°è è´¹ç¨") |
| | | @Excel(name = "å°è è´¹ç¨") |
| | | private BigDecimal feeC17; |
| | | |
| | | /** å·¦ç¼ç»ç»æ¥åå»é¢ */ |
| | | @ApiModelProperty("å·¦ç¼ç»ç»æ¥åå»é¢") |
| | | @Excel(name = "å·¦ç¼ç»ç»æ¥åå»é¢") |
| | | private String hospitalC69l; |
| | | |
| | | /** å·¦ç¼ç»ç»è´¹ç¨ */ |
| | | @ApiModelProperty("å·¦ç¼ç»ç»è´¹ç¨") |
| | | @Excel(name = "å·¦ç¼ç»ç»è´¹ç¨") |
| | | private BigDecimal feeC69l; |
| | | |
| | | /** å³ç¼ç»ç»æ¥åå»é¢ */ |
| | | @ApiModelProperty("å³ç¼ç»ç»æ¥åå»é¢") |
| | | @Excel(name = "å³ç¼ç»ç»æ¥åå»é¢") |
| | | private String hospitalC69r; |
| | | |
| | | /** å³ç¼ç»ç»è´¹ç¨ */ |
| | | @ApiModelProperty("å³ç¼ç»ç»è´¹ç¨") |
| | | @Excel(name = "å³ç¼ç»ç»è´¹ç¨") |
| | | private BigDecimal feeC69r; |
| | | |
| | | /** å
¶ä»ç»ç»æ¥åå»é¢ */ |
| | | @ApiModelProperty("å
¶ä»ç»ç»æ¥åå»é¢") |
| | | @Excel(name = "å
¶ä»ç»ç»æ¥åå»é¢") |
| | | private String hospitalC01; |
| | | |
| | | /** å
¶ä»ç»ç»è´¹ç¨ */ |
| | | @ApiModelProperty("å
¶ä»ç»ç»è´¹ç¨") |
| | | @Excel(name = "å
¶ä»ç»ç»è´¹ç¨") |
| | | private BigDecimal feeC01; |
| | | |
| | | /** é使¥ååä½ */ |
| | | @ApiModelProperty("é使¥ååä½") |
| | | @Excel(name = "é使¥ååä½") |
| | | private String unitBody; |
| | | |
| | | /** åè®¡è´¹ç¨ */ |
| | | @ApiModelProperty("å计费ç¨") |
| | | @Excel(name = "å计费ç¨") |
| | | private BigDecimal feeCount; |
| | | |
| | | } |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.domain; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.ruoyi.common.annotation.Excel; |
| | | import com.ruoyi.common.core.domain.BaseEntity; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®å对象 service_donorcharge |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | @Data |
| | | @ApiModel("æç®æ¡ä¾å¨å®å") |
| | | public class ServiceDonorcharge extends BaseEntity |
| | | { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** id */ |
| | | @ApiModelProperty("id") |
| | | //æ°æ®åºèªå¢æ¹æ@TableId(type = IdType.AUTO) |
| | | @TableId(type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | | /** æç®æ¡ä¾ID */ |
| | | @ApiModelProperty("æç®æ¡ä¾ID") |
| | | @Excel(name = "æç®æ¡ä¾ID") |
| | | private Long infoid; |
| | | |
| | | /** OPOç¼å· */ |
| | | @ApiModelProperty("OPOç¼å·") |
| | | @Excel(name = "OPOç¼å·") |
| | | private String donateno; |
| | | |
| | | /** æç®æ¶é´ */ |
| | | @ApiModelProperty("æç®æ¶é´") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "æç®æ¶é´", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date donatetime; |
| | | |
| | | /** å§å */ |
| | | @ApiModelProperty("å§å") |
| | | @Excel(name = "å§å") |
| | | private String name; |
| | | |
| | | /** åºçå¹´æ */ |
| | | @ApiModelProperty("åºçå¹´æ") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "åºçå¹´æ", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date borthdate; |
| | | |
| | | /** æ§å« */ |
| | | @ApiModelProperty("æ§å«") |
| | | @Excel(name = "æ§å«") |
| | | private String sex; |
| | | |
| | | /** å¹´é¾ï¼å
å«æï¼ */ |
| | | @ApiModelProperty("å¹´é¾ï¼å
嫿ï¼") |
| | | @Excel(name = "å¹´é¾", readConverterExp = "å
=嫿") |
| | | private String age; |
| | | |
| | | /** æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory */ |
| | | @ApiModelProperty("æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory") |
| | | @Excel(name = "æç®ç±»å« æ ¹æ®åå
¸sys_DonationCategory") |
| | | private String donationcategory; |
| | | |
| | | /** æç®çå¨å® */ |
| | | @ApiModelProperty("æç®çå¨å®") |
| | | @Excel(name = "æç®çå¨å®") |
| | | private String donateorgan; |
| | | |
| | | /** åè®¡è´¹ç¨ */ |
| | | @ApiModelProperty("å计费ç¨") |
| | | @Excel(name = "å计费ç¨") |
| | | private BigDecimal chargeamount; |
| | | |
| | | /** å计å®é
è·åè´¹ç¨ */ |
| | | @ApiModelProperty("å计å®é
è·åè´¹ç¨") |
| | | @Excel(name = "å计å®é
è·åè´¹ç¨") |
| | | private BigDecimal chargeamounted; |
| | | |
| | | } |
| | | |
| | |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | |
| | | */ |
| | | @Data |
| | | @ApiModel("æç®å¨å®") |
| | | public class ServiceDonorchargeorgan extends BaseEntity |
| | | { |
| | | public class ServiceDonorchargeorgan extends BaseEntity { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** $column.columnComment */ |
| | | /** |
| | | * $column.columnComment |
| | | */ |
| | | @ApiModelProperty("$column.columnComment") |
| | | //æ°æ®åºèªå¢æ¹æ@TableId(type = IdType.AUTO) |
| | | @TableId(type = IdType.AUTO) |
| | | private Long id; |
| | | |
| | | /** å
³èservice_donatebaseinfo表çID */ |
| | | /** |
| | | * å
³èservice_donorcharge表çID |
| | | */ |
| | | @ApiModelProperty("å
³èservice_donorcharge表çID") |
| | | //æ°æ®åºèªå¢æ¹æ@TableId(type = IdType.AUTO) |
| | | private Long donorchargelD; |
| | | |
| | | /** |
| | | * å
³èservice_donatebaseinfo表çID |
| | | */ |
| | | @ApiModelProperty("å
³èservice_donatebaseinfo表çID") |
| | | @Excel(name = "å
³èservice_donatebaseinfo表çID") |
| | | private Long infoid; |
| | | |
| | | /** æç®äººåå */ |
| | | /** |
| | | * æç®äººåå |
| | | */ |
| | | @ApiModelProperty("æç®äººåå") |
| | | @Excel(name = "æç®äººåå") |
| | | private String donorname; |
| | | |
| | | /** å¨å®ç§»æ¤æºæåç§° å¯¹åºæºæè¡¨ */ |
| | | /** |
| | | * å¨å®ç§»æ¤æºæåç§° å¯¹åºæºæè¡¨ |
| | | */ |
| | | @ApiModelProperty("å¨å®ç§»æ¤æºæåç§° å¯¹åºæºæè¡¨") |
| | | @Excel(name = "å¨å®ç§»æ¤æºæåç§° å¯¹åºæºæè¡¨") |
| | | private String hospitalname; |
| | | |
| | | /** å¨å®ç§»æ¤æºæç¼å· å¯¹åºæºæè¡¨ */ |
| | | /** |
| | | * å¨å®ç§»æ¤æºæç¼å· å¯¹åºæºæè¡¨ |
| | | */ |
| | | @ApiModelProperty("å¨å®ç§»æ¤æºæç¼å· å¯¹åºæºæè¡¨") |
| | | @Excel(name = "å¨å®ç§»æ¤æºæç¼å· å¯¹åºæºæè¡¨") |
| | | private String hospitalno; |
| | | |
| | | /** å¨å®ç±»å« 详è§åå
¸sys_Organ */ |
| | | /** |
| | | * å¨å®ç±»å« 详è§åå
¸sys_Organ |
| | | */ |
| | | @ApiModelProperty("å¨å®ç±»å« 详è§åå
¸sys_Organ") |
| | | @Excel(name = "å¨å®ç±»å« 详è§åå
¸sys_Organ") |
| | | private String organno; |
| | | |
| | | /** å¨å®ç±»å«åç§° 详è§åå
¸sys_Organ */ |
| | | /** |
| | | * å¨å®ç±»å«åç§° 详è§åå
¸sys_Organ |
| | | */ |
| | | @ApiModelProperty("å¨å®ç±»å«åç§° 详è§åå
¸sys_Organ") |
| | | @Excel(name = "å¨å®ç±»å«åç§° 详è§åå
¸sys_Organ") |
| | | private String organname; |
| | | |
| | | /** å¨å®åºæ¶è´¹ç¨ */ |
| | | /** |
| | | * å¨å®åºæ¶è´¹ç¨ |
| | | */ |
| | | @ApiModelProperty("å¨å®åºæ¶è´¹ç¨") |
| | | @Excel(name = "å¨å®åºæ¶è´¹ç¨") |
| | | private BigDecimal organcharge; |
| | | |
| | | /** è´¹ç¨å½å
¥æ¶é´ */ |
| | | /** |
| | | * è´¹ç¨å½å
¥æ¶é´ |
| | | */ |
| | | @ApiModelProperty("è´¹ç¨å½å
¥æ¶é´") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "è´¹ç¨å½å
¥æ¶é´", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date organtime; |
| | | |
| | | /** è´¹ç¨å½å
¥äºº */ |
| | | /** |
| | | * è´¹ç¨å½å
¥äºº |
| | | */ |
| | | @ApiModelProperty("è´¹ç¨å½å
¥äºº") |
| | | @Excel(name = "è´¹ç¨å½å
¥äºº") |
| | | private String chargeoperator; |
| | | |
| | | /** å¨å®å®é
æ¶å°è´¹ç¨ */ |
| | | /** |
| | | * å¨å®å®é
æ¶å°è´¹ç¨ |
| | | */ |
| | | @ApiModelProperty("å¨å®å®é
æ¶å°è´¹ç¨") |
| | | @Excel(name = "å¨å®å®é
æ¶å°è´¹ç¨") |
| | | private BigDecimal amount; |
| | | |
| | | /** å¨å®å®é
æ¶å°è´¹ç¨æ¶é´ */ |
| | | /** |
| | | * å¨å®å®é
æ¶å°è´¹ç¨æ¶é´ |
| | | */ |
| | | @ApiModelProperty("å¨å®å®é
æ¶å°è´¹ç¨æ¶é´") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") |
| | | @Excel(name = "å¨å®å®é
æ¶å°è´¹ç¨æ¶é´", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") |
| | | private Date amounttime; |
| | | |
| | | /** æ¶è´¹å½å
¥äºº */ |
| | | /** |
| | | * æ¶è´¹å½å
¥äºº |
| | | */ |
| | | @ApiModelProperty("æ¶è´¹å½å
¥äºº") |
| | | @Excel(name = "æ¶è´¹å½å
¥äºº") |
| | | private String amountoperator; |
| | | |
| | | /** å¨å®è´¹ç¨æ¶åç¶æï¼0ï¼æªæ¶åï¼1ï¼å·²æ¶åï¼2ï¼æ¾å¼ */ |
| | | /** |
| | | * å¨å®è´¹ç¨æ¶åç¶æï¼0ï¼æªæ¶åï¼1ï¼å·²æ¶åï¼2ï¼æ¾å¼ |
| | | */ |
| | | @ApiModelProperty("å¨å®è´¹ç¨æ¶åç¶æï¼0ï¼æªæ¶åï¼1ï¼å·²æ¶åï¼2ï¼æ¾å¼") |
| | | @Excel(name = "å¨å®è´¹ç¨æ¶åç¶æï¼0ï¼æªæ¶åï¼1ï¼å·²æ¶åï¼2ï¼æ¾å¼") |
| | | private Long chargestate; |
| | | |
| | | /** å¨å®å®é
æ¶å°è´¹ç¨è¯´æ */ |
| | | /** |
| | | * å¨å®å®é
æ¶å°è´¹ç¨è¯´æ |
| | | */ |
| | | @ApiModelProperty("å¨å®å®é
æ¶å°è´¹ç¨è¯´æ") |
| | | @Excel(name = "å¨å®å®é
æ¶å°è´¹ç¨è¯´æ") |
| | | private String organchargedesc; |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.mapper; |
| | | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | import com.ruoyi.project.domain.ServiceDonateorganstatics; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®åMapperæ¥å£ |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | @Mapper |
| | | public interface ServiceDonateorganstaticsMapper extends BaseMapper<ServiceDonateorganstatics> { |
| | | /** |
| | | * æ¥è¯¢æç®æ¡ä¾å¨å®åå表 |
| | | * |
| | | * @param serviceDonateorganstatics æç®æ¡ä¾å¨å®å |
| | | * @return æç®æ¡ä¾å¨å®åéå |
| | | */ |
| | | public List<ServiceDonateorganstatics> selectServiceDonateorganstaticsList(ServiceDonateorganstatics serviceDonateorganstatics); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.mapper; |
| | | |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.ruoyi.project.domain.ServiceDonorcharge; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®åMapperæ¥å£ |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | @Mapper |
| | | public interface ServiceDonorchargeMapper extends BaseMapper<ServiceDonorcharge> { |
| | | /** |
| | | * æ¥è¯¢æç®æ¡ä¾å¨å®åå表 |
| | | * |
| | | * @param serviceDonorcharge æç®æ¡ä¾å¨å®å |
| | | * @return æç®æ¡ä¾å¨å®åéå |
| | | */ |
| | | public List<ServiceDonorcharge> selectServiceDonorchargeList(ServiceDonorcharge serviceDonorcharge); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ruoyi.project.domain.ServiceDonateorganstatics; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®åServiceæ¥å£ |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | public interface IServiceDonateorganstaticsService extends IService<ServiceDonateorganstatics> { |
| | | |
| | | /** |
| | | * æ¥è¯¢æç®æ¡ä¾å¨å®åå表 |
| | | * |
| | | * @param serviceDonateorganstatics æç®æ¡ä¾å¨å®å |
| | | * @return æç®æ¡ä¾å¨å®åéå |
| | | */ |
| | | public List<ServiceDonateorganstatics> queryList(ServiceDonateorganstatics serviceDonateorganstatics); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.ruoyi.project.domain.ServiceDonorcharge; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®åServiceæ¥å£ |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | public interface IServiceDonorchargeService extends IService<ServiceDonorcharge> |
| | | { |
| | | |
| | | /** |
| | | * æ¥è¯¢æç®æ¡ä¾å¨å®åå表 |
| | | * |
| | | * @param serviceDonorcharge æç®æ¡ä¾å¨å®å |
| | | * @return æç®æ¡ä¾å¨å®åéå |
| | | */ |
| | | public List<ServiceDonorcharge> queryList(ServiceDonorcharge serviceDonorcharge); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ruoyi.common.utils.StringUtils; |
| | | import com.ruoyi.project.domain.ServiceDonateorganstatics; |
| | | import com.ruoyi.project.mapper.ServiceDonateorganstaticsMapper; |
| | | import com.ruoyi.project.service.IServiceDonateorganstaticsService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®åServiceä¸å¡å±å¤ç |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | @Service |
| | | public class ServiceDonateorganstaticsServiceImpl extends ServiceImpl<ServiceDonateorganstaticsMapper, ServiceDonateorganstatics> implements IServiceDonateorganstaticsService |
| | | { |
| | | |
| | | |
| | | /** |
| | | * æ¥è¯¢æç®æ¡ä¾å¨å®åå表 |
| | | * |
| | | * @param serviceDonateorganstatics æç®æ¡ä¾å¨å®å |
| | | * @return æç®æ¡ä¾å¨å®å |
| | | */ |
| | | @Override |
| | | public List<ServiceDonateorganstatics> queryList(ServiceDonateorganstatics serviceDonateorganstatics) { |
| | | LambdaQueryWrapper<ServiceDonateorganstatics> wrappers = Wrappers.lambdaQuery(); |
| | | if (serviceDonateorganstatics.getInfoid() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getInfoid ,serviceDonateorganstatics.getInfoid()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getDonateno())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getDonateno ,serviceDonateorganstatics.getDonateno()); |
| | | } |
| | | if (serviceDonateorganstatics.getDonatetime() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getDonatetime ,serviceDonateorganstatics.getDonatetime()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getName())){ |
| | | wrappers.like(ServiceDonateorganstatics::getName ,serviceDonateorganstatics.getName()); |
| | | } |
| | | if (serviceDonateorganstatics.getBorthdate() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getBorthdate ,serviceDonateorganstatics.getBorthdate()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getSex())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getSex ,serviceDonateorganstatics.getSex()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getAge())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getAge ,serviceDonateorganstatics.getAge()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getDonationcategory())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getDonationcategory ,serviceDonateorganstatics.getDonationcategory()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC22())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC22 ,serviceDonateorganstatics.getHospitalC22()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC22() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC22 ,serviceDonateorganstatics.getFeeC22()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC22l())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC22l ,serviceDonateorganstatics.getHospitalC22l()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC22l() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC22l ,serviceDonateorganstatics.getFeeC22l()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC22le())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC22le ,serviceDonateorganstatics.getHospitalC22le()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC22le() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC22le ,serviceDonateorganstatics.getFeeC22le()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC22r())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC22r ,serviceDonateorganstatics.getHospitalC22r()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC22r() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC22r ,serviceDonateorganstatics.getFeeC22r()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC64l())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC64l ,serviceDonateorganstatics.getHospitalC64l()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC64l() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC64l ,serviceDonateorganstatics.getFeeC64l()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC64r())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC64r ,serviceDonateorganstatics.getHospitalC64r()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC64r() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC64r ,serviceDonateorganstatics.getFeeC64r()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC38())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC38 ,serviceDonateorganstatics.getHospitalC38()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC38() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC38 ,serviceDonateorganstatics.getFeeC38()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC34())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC34 ,serviceDonateorganstatics.getHospitalC34()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC34() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC34 ,serviceDonateorganstatics.getFeeC34()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC34l())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC34l ,serviceDonateorganstatics.getHospitalC34l()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC34l() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC34l ,serviceDonateorganstatics.getFeeC34l()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC34r())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC34r ,serviceDonateorganstatics.getHospitalC34r()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC34r() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC34r ,serviceDonateorganstatics.getFeeC34r()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC17())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC17 ,serviceDonateorganstatics.getHospitalC17()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC17() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC17 ,serviceDonateorganstatics.getFeeC17()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC69l())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC69l ,serviceDonateorganstatics.getHospitalC69l()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC69l() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC69l ,serviceDonateorganstatics.getFeeC69l()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC69r())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC69r ,serviceDonateorganstatics.getHospitalC69r()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC69r() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC69r ,serviceDonateorganstatics.getFeeC69r()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getHospitalC01())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getHospitalC01 ,serviceDonateorganstatics.getHospitalC01()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeC01() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeC01 ,serviceDonateorganstatics.getFeeC01()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonateorganstatics.getUnitBody())){ |
| | | wrappers.eq(ServiceDonateorganstatics::getUnitBody ,serviceDonateorganstatics.getUnitBody()); |
| | | } |
| | | if (serviceDonateorganstatics.getFeeCount() != null){ |
| | | wrappers.eq(ServiceDonateorganstatics::getFeeCount ,serviceDonateorganstatics.getFeeCount()); |
| | | } |
| | | return this.list(wrappers); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ruoyi.project.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.ruoyi.common.utils.StringUtils; |
| | | import com.ruoyi.project.domain.ServiceDonorcharge; |
| | | import com.ruoyi.project.mapper.ServiceDonorchargeMapper; |
| | | import com.ruoyi.project.service.IServiceDonorchargeService; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * æç®æ¡ä¾å¨å®åServiceä¸å¡å±å¤ç |
| | | * |
| | | * @author ruoyi |
| | | * @date 2023-12-27 |
| | | */ |
| | | @Service |
| | | public class ServiceDonorchargeServiceImpl extends ServiceImpl<ServiceDonorchargeMapper, ServiceDonorcharge> implements IServiceDonorchargeService { |
| | | |
| | | |
| | | /** |
| | | * æ¥è¯¢æç®æ¡ä¾å¨å®åå表 |
| | | * |
| | | * @param serviceDonorcharge æç®æ¡ä¾å¨å®å |
| | | * @return æç®æ¡ä¾å¨å®å |
| | | */ |
| | | @Override |
| | | public List<ServiceDonorcharge> queryList(ServiceDonorcharge serviceDonorcharge) { |
| | | LambdaQueryWrapper<ServiceDonorcharge> wrappers = Wrappers.lambdaQuery(); |
| | | if (serviceDonorcharge.getInfoid() != null) { |
| | | wrappers.eq(ServiceDonorcharge::getInfoid, serviceDonorcharge.getInfoid()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonorcharge.getDonateno())) { |
| | | wrappers.eq(ServiceDonorcharge::getDonateno, serviceDonorcharge.getDonateno()); |
| | | } |
| | | if (serviceDonorcharge.getDonatetime() != null) { |
| | | wrappers.eq(ServiceDonorcharge::getDonatetime, serviceDonorcharge.getDonatetime()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonorcharge.getName())) { |
| | | wrappers.like(ServiceDonorcharge::getName, serviceDonorcharge.getName()); |
| | | } |
| | | if (serviceDonorcharge.getBorthdate() != null) { |
| | | wrappers.eq(ServiceDonorcharge::getBorthdate, serviceDonorcharge.getBorthdate()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonorcharge.getSex())) { |
| | | wrappers.eq(ServiceDonorcharge::getSex, serviceDonorcharge.getSex()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonorcharge.getAge())) { |
| | | wrappers.eq(ServiceDonorcharge::getAge, serviceDonorcharge.getAge()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonorcharge.getDonationcategory())) { |
| | | wrappers.eq(ServiceDonorcharge::getDonationcategory, serviceDonorcharge.getDonationcategory()); |
| | | } |
| | | if (StringUtils.isNotBlank(serviceDonorcharge.getDonateorgan())) { |
| | | wrappers.eq(ServiceDonorcharge::getDonateorgan, serviceDonorcharge.getDonateorgan()); |
| | | } |
| | | if (serviceDonorcharge.getChargeamount() != null) { |
| | | wrappers.eq(ServiceDonorcharge::getChargeamount, serviceDonorcharge.getChargeamount()); |
| | | } |
| | | if (serviceDonorcharge.getChargeamounted() != null) { |
| | | wrappers.eq(ServiceDonorcharge::getChargeamounted, serviceDonorcharge.getChargeamounted()); |
| | | } |
| | | return this.list(wrappers); |
| | | } |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ruoyi.project.mapper.ServiceDonateorganstaticsMapper"> |
| | | |
| | | <resultMap type="com.ruoyi.project.domain.ServiceDonateorganstatics" id="ServiceDonateorganstaticsResult"> |
| | | <result property="id" column="id"/> |
| | | <result property="infoid" column="infoid"/> |
| | | <result property="donateno" column="donateno"/> |
| | | <result property="donatetime" column="donatetime"/> |
| | | <result property="name" column="name"/> |
| | | <result property="borthdate" column="borthdate"/> |
| | | <result property="sex" column="sex"/> |
| | | <result property="age" column="age"/> |
| | | <result property="donationcategory" column="DonationCategory"/> |
| | | <result property="hospitalC22" column="hospital_C22"/> |
| | | <result property="feeC22" column="fee_C22"/> |
| | | <result property="hospitalC22l" column="hospital_C22L"/> |
| | | <result property="feeC22l" column="fee_C22L"/> |
| | | <result property="hospitalC22le" column="hospital_C22LE"/> |
| | | <result property="feeC22le" column="fee_C22LE"/> |
| | | <result property="hospitalC22r" column="hospital_C22R"/> |
| | | <result property="feeC22r" column="fee_C22R"/> |
| | | <result property="hospitalC64l" column="hospital_C64L"/> |
| | | <result property="feeC64l" column="fee_C64L"/> |
| | | <result property="hospitalC64r" column="hospital_C64R"/> |
| | | <result property="feeC64r" column="fee_C64R"/> |
| | | <result property="hospitalC38" column="hospital_C38"/> |
| | | <result property="feeC38" column="fee_C38"/> |
| | | <result property="hospitalC34" column="hospital_C34"/> |
| | | <result property="feeC34" column="fee_C34"/> |
| | | <result property="hospitalC34l" column="hospital_C34L"/> |
| | | <result property="feeC34l" column="fee_C34L"/> |
| | | <result property="hospitalC34r" column="hospital_C34R"/> |
| | | <result property="feeC34r" column="fee_C34R"/> |
| | | <result property="hospitalC17" column="hospital_C17"/> |
| | | <result property="feeC17" column="fee_C17"/> |
| | | <result property="hospitalC69l" column="hospital_C69L"/> |
| | | <result property="feeC69l" column="fee_C69L"/> |
| | | <result property="hospitalC69r" column="hospital_C69R"/> |
| | | <result property="feeC69r" column="fee_C69R"/> |
| | | <result property="hospitalC01" column="hospital_C01"/> |
| | | <result property="feeC01" column="fee_C01"/> |
| | | <result property="unitBody" column="unit_body"/> |
| | | <result property="feeCount" column="fee_count"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectServiceDonateorganstaticsVo"> |
| | | select id, |
| | | infoid, |
| | | donateno, |
| | | donatetime, |
| | | name, |
| | | borthdate, |
| | | sex, |
| | | age, |
| | | DonationCategory, |
| | | hospital_C22, |
| | | fee_C22, |
| | | hospital_C22L, |
| | | fee_C22L, |
| | | hospital_C22LE, |
| | | fee_C22LE, |
| | | hospital_C22R, |
| | | fee_C22R, |
| | | hospital_C64L, |
| | | fee_C64L, |
| | | hospital_C64R, |
| | | fee_C64R, |
| | | hospital_C38, |
| | | fee_C38, |
| | | hospital_C34, |
| | | fee_C34, |
| | | hospital_C34L, |
| | | fee_C34L, |
| | | hospital_C34R, |
| | | fee_C34R, |
| | | hospital_C17, |
| | | fee_C17, |
| | | hospital_C69L, |
| | | fee_C69L, |
| | | hospital_C69R, |
| | | fee_C69R, |
| | | hospital_C01, |
| | | fee_C01, |
| | | unit_body, |
| | | fee_count |
| | | from service_donateorganstatics |
| | | </sql> |
| | | |
| | | <select id="selectServiceDonateorganstaticsList" parameterType="com.ruoyi.project.domain.ServiceDonateorganstatics" |
| | | resultMap="ServiceDonateorganstaticsResult"> |
| | | <include refid="selectServiceDonateorganstaticsVo"/> |
| | | <where> |
| | | <if test="infoid != null ">and infoid = #{infoid}</if> |
| | | <if test="donateno != null and donateno != ''">and donateno = #{donateno}</if> |
| | | <if test="donatetime != null ">and donatetime = #{donatetime}</if> |
| | | <if test="name != null and name != ''">and name like concat('%', #{name}, '%')</if> |
| | | <if test="borthdate != null ">and borthdate = #{borthdate}</if> |
| | | <if test="sex != null and sex != ''">and sex = #{sex}</if> |
| | | <if test="age != null and age != ''">and age = #{age}</if> |
| | | <if test="donationcategory != null and donationcategory != ''">and DonationCategory = #{donationcategory} |
| | | </if> |
| | | <if test="hospitalC22 != null and hospitalC22 != ''">and hospital_C22 = #{hospitalC22}</if> |
| | | <if test="feeC22 != null ">and fee_C22 = #{feeC22}</if> |
| | | <if test="hospitalC22l != null and hospitalC22l != ''">and hospital_C22L = #{hospitalC22l}</if> |
| | | <if test="feeC22l != null ">and fee_C22L = #{feeC22l}</if> |
| | | <if test="hospitalC22le != null and hospitalC22le != ''">and hospital_C22LE = #{hospitalC22le}</if> |
| | | <if test="feeC22le != null ">and fee_C22LE = #{feeC22le}</if> |
| | | <if test="hospitalC22r != null and hospitalC22r != ''">and hospital_C22R = #{hospitalC22r}</if> |
| | | <if test="feeC22r != null ">and fee_C22R = #{feeC22r}</if> |
| | | <if test="hospitalC64l != null and hospitalC64l != ''">and hospital_C64L = #{hospitalC64l}</if> |
| | | <if test="feeC64l != null ">and fee_C64L = #{feeC64l}</if> |
| | | <if test="hospitalC64r != null and hospitalC64r != ''">and hospital_C64R = #{hospitalC64r}</if> |
| | | <if test="feeC64r != null ">and fee_C64R = #{feeC64r}</if> |
| | | <if test="hospitalC38 != null and hospitalC38 != ''">and hospital_C38 = #{hospitalC38}</if> |
| | | <if test="feeC38 != null ">and fee_C38 = #{feeC38}</if> |
| | | <if test="hospitalC34 != null and hospitalC34 != ''">and hospital_C34 = #{hospitalC34}</if> |
| | | <if test="feeC34 != null ">and fee_C34 = #{feeC34}</if> |
| | | <if test="hospitalC34l != null and hospitalC34l != ''">and hospital_C34L = #{hospitalC34l}</if> |
| | | <if test="feeC34l != null ">and fee_C34L = #{feeC34l}</if> |
| | | <if test="hospitalC34r != null and hospitalC34r != ''">and hospital_C34R = #{hospitalC34r}</if> |
| | | <if test="feeC34r != null ">and fee_C34R = #{feeC34r}</if> |
| | | <if test="hospitalC17 != null and hospitalC17 != ''">and hospital_C17 = #{hospitalC17}</if> |
| | | <if test="feeC17 != null ">and fee_C17 = #{feeC17}</if> |
| | | <if test="hospitalC69l != null and hospitalC69l != ''">and hospital_C69L = #{hospitalC69l}</if> |
| | | <if test="feeC69l != null ">and fee_C69L = #{feeC69l}</if> |
| | | <if test="hospitalC69r != null and hospitalC69r != ''">and hospital_C69R = #{hospitalC69r}</if> |
| | | <if test="feeC69r != null ">and fee_C69R = #{feeC69r}</if> |
| | | <if test="hospitalC01 != null and hospitalC01 != ''">and hospital_C01 = #{hospitalC01}</if> |
| | | <if test="feeC01 != null ">and fee_C01 = #{feeC01}</if> |
| | | <if test="unitBody != null and unitBody != ''">and unit_body = #{unitBody}</if> |
| | | <if test="feeCount != null ">and fee_count = #{feeCount}</if> |
| | | </where> |
| | | </select> |
| | | |
| | | </mapper> |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?xml version="1.0" encoding="UTF-8" ?> |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ruoyi.project.mapper.ServiceDonorchargeMapper"> |
| | | |
| | | <resultMap type="com.ruoyi.project.domain.ServiceDonorcharge" id="ServiceDonorchargeResult"> |
| | | <result property="id" column="id"/> |
| | | <result property="infoid" column="infoid"/> |
| | | <result property="donateno" column="donateno"/> |
| | | <result property="donatetime" column="donatetime"/> |
| | | <result property="name" column="name"/> |
| | | <result property="borthdate" column="borthdate"/> |
| | | <result property="sex" column="sex"/> |
| | | <result property="age" column="age"/> |
| | | <result property="donationcategory" column="DonationCategory"/> |
| | | <result property="donateorgan" column="donateorgan"/> |
| | | <result property="chargeamount" column="chargeamount"/> |
| | | <result property="chargeamounted" column="chargeamounted"/> |
| | | <result property="remark" column="remark"/> |
| | | <result property="del_flag" column="del_flag"/> |
| | | <result property="createBy" column="create_by"/> |
| | | <result property="createTime" column="create_time"/> |
| | | <result property="updateBy" column="update_by"/> |
| | | <result property="updateTime" column="update_time"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectServiceDonorchargeVo"> |
| | | select id, |
| | | infoid, |
| | | donateno, |
| | | donatetime, |
| | | name, |
| | | borthdate, |
| | | sex, |
| | | age, |
| | | DonationCategory, |
| | | donateorgan, |
| | | chargeamount, |
| | | chargeamounted, |
| | | remark, |
| | | del_flag, |
| | | create_by, |
| | | create_time, |
| | | update_by, |
| | | update_time |
| | | from service_donorcharge |
| | | </sql> |
| | | |
| | | <select id="selectServiceDonorchargeList" parameterType="com.ruoyi.project.domain.ServiceDonorcharge" |
| | | resultMap="ServiceDonorchargeResult"> |
| | | <include refid="selectServiceDonorchargeVo"/> |
| | | <where> |
| | | <if test="infoid != null ">and infoid = #{infoid}</if> |
| | | <if test="donateno != null and donateno != ''">and donateno = #{donateno}</if> |
| | | <if test="donatetime != null ">and donatetime = #{donatetime}</if> |
| | | <if test="name != null and name != ''">and name like concat('%', #{name}, '%')</if> |
| | | <if test="borthdate != null ">and borthdate = #{borthdate}</if> |
| | | <if test="sex != null and sex != ''">and sex = #{sex}</if> |
| | | <if test="age != null and age != ''">and age = #{age}</if> |
| | | <if test="donationcategory != null and donationcategory != ''">and DonationCategory = #{donationcategory} |
| | | </if> |
| | | <if test="donateorgan != null and donateorgan != ''">and donateorgan = #{donateorgan}</if> |
| | | <if test="chargeamount != null ">and chargeamount = #{chargeamount}</if> |
| | | <if test="chargeamounted != null ">and chargeamounted = #{chargeamounted}</if> |
| | | </where> |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | <!DOCTYPE mapper |
| | | PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" |
| | | "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.ruoyi.system.mapper.ServiceDonorchargeorganMapper"> |
| | | <mapper namespace="com.ruoyi.project.mapper.ServiceDonorchargeorganMapper"> |
| | | |
| | | <resultMap type="ServiceDonorchargeorgan" id="ServiceDonorchargeorganResult"> |
| | | <resultMap type="com.ruoyi.project.domain.ServiceDonorchargeorgan" id="ServiceDonorchargeorganResult"> |
| | | <result property="id" column="ID" /> |
| | | <result property="infoid" column="InfoID" /> |
| | | <result property="id" column="ID"/> |
| | | <result property="donorchargelD" column="donorchargelD"/> |
| | | <result property="donorname" column="donorname" /> |
| | | <result property="hospitalname" column="HospitalName" /> |
| | | <result property="hospitalno" column="HospitalNo" /> |
| | |
| | | </resultMap> |
| | | |
| | | <sql id="selectServiceDonorchargeorganVo"> |
| | | select ID, InfoID, donorname, HospitalName, HospitalNo, OrganNo, OrganName, organcharge, organtime, chargeoperator, amount, amounttime, amountoperator, chargestate, organchargedesc, del_flag, create_by, create_time, update_by, update_time from service_donorchargeorgan |
| | | select ID, |
| | | donorchargelD, |
| | | InfoID, |
| | | donorname, |
| | | HospitalName, |
| | | HospitalNo, |
| | | OrganNo, |
| | | OrganName, |
| | | organcharge, |
| | | organtime, |
| | | chargeoperator, |
| | | amount, |
| | | amounttime, |
| | | amountoperator, |
| | | chargestate, |
| | | organchargedesc, |
| | | del_flag, |
| | | create_by, |
| | | create_time, |
| | | update_by, |
| | | update_time |
| | | from service_donorchargeorgan |
| | | </sql> |
| | | |
| | | <select id="selectServiceDonorchargeorganList" parameterType="ServiceDonorchargeorgan" resultMap="ServiceDonorchargeorganResult"> |
| | | <select id="selectServiceDonorchargeorganList" parameterType="com.ruoyi.project.domain.ServiceDonorchargeorgan" |
| | | resultMap="ServiceDonorchargeorganResult"> |
| | | <include refid="selectServiceDonorchargeorganVo"/> |
| | | <where> |
| | | <if test="infoid != null "> and InfoID = #{infoid}</if> |
| | | <if test="donorchargelD != null ">and donorchargelD = #{donorchargelD}</if> |
| | | <if test="donorname != null and donorname != ''"> and donorname like concat('%', #{donorname}, '%')</if> |
| | | <if test="hospitalname != null and hospitalname != ''"> and HospitalName like concat('%', #{hospitalname}, '%')</if> |
| | | <if test="hospitalname != null and hospitalname != ''">and HospitalName like concat('%', #{hospitalname}, |
| | | '%') |
| | | </if> |
| | | <if test="hospitalno != null and hospitalno != ''"> and HospitalNo = #{hospitalno}</if> |
| | | <if test="organno != null and organno != ''"> and OrganNo = #{organno}</if> |
| | | <if test="organname != null and organname != ''"> and OrganName like concat('%', #{organname}, '%')</if> |