¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.controller; |
| | | |
| | | import com.aps.common.core.utils.poi.ExcelUtil; |
| | | import com.aps.common.core.utils.uuid.IdUtils; |
| | | import com.aps.common.core.web.controller.BaseController; |
| | | import com.aps.common.core.web.domain.AjaxResult; |
| | | import com.aps.common.core.web.page.TableDataInfo; |
| | | import com.aps.common.log.annotation.Log; |
| | | import com.aps.common.log.enums.BusinessType; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.common.security.utils.DictUtils; |
| | | import com.aps.core.domain.ApsWeldSeam; |
| | | import com.aps.core.domain.ApsWeldSeamTemp; |
| | | import com.aps.core.service.IApsWeldSeamService; |
| | | import com.aps.core.service.IApsWeldSeamTempService; |
| | | import com.aps.system.api.domain.SysDictData; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import org.springframework.web.multipart.MultipartFile; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * çç¼Controller |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | @RestController |
| | | @RequestMapping("/weldSeam") |
| | | public class ApsWeldSeamController extends BaseController { |
| | | @Autowired |
| | | private IApsWeldSeamService apsWeldSeamService; |
| | | @Autowired |
| | | private IApsWeldSeamTempService apsWeldSeamTempService; |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼å表 |
| | | */ |
| | | @RequiresPermissions("gasPiping:gasPiping:list") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(ApsWeldSeam apsWeldSeam) { |
| | | // startPage(); |
| | | List<ApsWeldSeam> list = apsWeldSeamService.selectApsWeldSeamList(apsWeldSeam); |
| | | return getDataTable(list); |
| | | } |
| | | |
| | | /** |
| | | * 导åºçç¼å表 |
| | | */ |
| | | @RequiresPermissions("gasPiping:gasPiping:export") |
| | | @Log(title = "çç¼", businessType = BusinessType.EXPORT) |
| | | @PostMapping("/export") |
| | | public void export(HttpServletResponse response, ApsWeldSeam apsWeldSeam) { |
| | | List<ApsWeldSeam> apsWeldSeams = apsWeldSeamService.selectApsWeldSeamList(apsWeldSeam); |
| | | //å·¥åç±»å |
| | | List<SysDictData> listTypes = DictUtils.getDictCache("aps_weld_work_order_type"); |
| | | //åç±» |
| | | List<SysDictData> list = DictUtils.getDictCache("aps_weld_classification"); |
| | | for (int i = 0; i < apsWeldSeams.size(); i++) { |
| | | //åç±» |
| | | for (int j = 0; j < list.size(); j++) { |
| | | if (apsWeldSeams.get(i).getClassification().equals(list.get(j).getDictValue())) { |
| | | apsWeldSeams.get(i).setClassificationTxt(list.get(j).getDictLabel()); |
| | | } |
| | | } |
| | | //å·¥åç±»å |
| | | for (int j = 0; j < listTypes.size(); j++) { |
| | | if (apsWeldSeams.get(i).getWorkOrderType().equals(listTypes.get(j).getDictValue())) { |
| | | apsWeldSeams.get(i).setWorkOrderTypeTxt(listTypes.get(j).getDictLabel()); |
| | | } |
| | | } |
| | | } |
| | | ExcelUtil<ApsWeldSeam> util = new ExcelUtil<ApsWeldSeam>(ApsWeldSeam.class); |
| | | util.exportExcel(response, apsWeldSeams, "çç¼æ°æ®"); |
| | | } |
| | | |
| | | /** |
| | | * è·åçç¼è¯¦ç»ä¿¡æ¯ |
| | | */ |
| | | @RequiresPermissions("gasPiping:gasPiping:query") |
| | | @GetMapping(value = "/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") String id) { |
| | | return success(apsWeldSeamService.selectApsWeldSeamById(id)); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢çç¼ |
| | | */ |
| | | @RequiresPermissions("gasPiping:gasPiping:add") |
| | | @Log(title = "çç¼", businessType = BusinessType.INSERT) |
| | | @PostMapping |
| | | public AjaxResult add(@RequestBody ApsWeldSeam apsWeldSeam) { |
| | | return toAjax(apsWeldSeamService.insertApsWeldSeam(apsWeldSeam)); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹çç¼ |
| | | */ |
| | | @RequiresPermissions("gasPiping:gasPiping:edit") |
| | | @Log(title = "çç¼", businessType = BusinessType.UPDATE) |
| | | @PutMapping |
| | | public AjaxResult edit(@RequestBody ApsWeldSeam apsWeldSeam) { |
| | | return toAjax(apsWeldSeamService.updateApsWeldSeam(apsWeldSeam)); |
| | | } |
| | | |
| | | /** |
| | | * å é¤çç¼ |
| | | */ |
| | | @RequiresPermissions("gasPiping:gasPiping:remove") |
| | | @Log(title = "çç¼", businessType = BusinessType.DELETE) |
| | | @DeleteMapping("/{ids}") |
| | | public AjaxResult remove(@PathVariable String[] ids) { |
| | | return toAjax(apsWeldSeamService.deleteApsWeldSeamByIds(ids)); |
| | | } |
| | | |
| | | /** |
| | | * çç¼å¯¼å
¥ |
| | | */ |
| | | @PostMapping("/importData") |
| | | public AjaxResult importData(MultipartFile file) throws Exception { |
| | | ExcelUtil<ApsWeldSeamTemp> util = new ExcelUtil<ApsWeldSeamTemp>(ApsWeldSeamTemp.class); |
| | | List<ApsWeldSeamTemp> apsWeldSeamTemps = util.importExcel(file.getInputStream()); |
| | | //夿坼å
¥æ°æ®æ¯å¦ä¸ºç©º |
| | | if (apsWeldSeamTemps.size() > 0) { |
| | | String batchNum = IdUtils.fastUUID(); |
| | | //å·¥åç±»å |
| | | List<SysDictData> listTypes = DictUtils.getDictCache("aps_weld_work_order_type"); |
| | | //åç±» |
| | | List<SysDictData> list = DictUtils.getDictCache("aps_weld_classification"); |
| | | for (int i = 0; i < apsWeldSeamTemps.size(); i++) { |
| | | //åç±» |
| | | for (int j = 0; j < list.size(); j++) { |
| | | if (apsWeldSeamTemps.get(i).getClassificationTxt().equals(list.get(j).getDictLabel())) { |
| | | apsWeldSeamTemps.get(i).setClassification(list.get(j).getDictValue()); |
| | | } |
| | | } |
| | | //å·¥åç±»å |
| | | for (int j = 0; j < listTypes.size(); j++) { |
| | | if (apsWeldSeamTemps.get(i).getWorkOrderTypeTxt().equals(listTypes.get(j).getDictLabel())) { |
| | | apsWeldSeamTemps.get(i).setWorkOrderType(listTypes.get(j).getDictValue()); |
| | | } |
| | | } |
| | | //æå
¥çæ¬å· |
| | | apsWeldSeamTemps.get(i).setBatchNumber(batchNum); |
| | | //æå
¥ä¸´æ¶è¡¨ |
| | | apsWeldSeamTemps.get(i).setTotalWeldSeam(apsWeldSeamTemps.get(i).getSingleWeldSeam().longValue()*apsWeldSeamTemps.get(i).getProductionQuantity().longValue()); |
| | | apsWeldSeamTempService.insertApsWeldSeamTemp(apsWeldSeamTemps.get(i)); |
| | | } |
| | | |
| | | return AjaxResult.success("导å
¥æå", batchNum); |
| | | } else { |
| | | return AjaxResult.error("模æ¿å
容为空"); |
| | | } |
| | | } |
| | | |
| | | /*** |
| | | * @Description: 确认ä¸ä¼ |
| | | * @Param: [apsPartPlan] |
| | | * @return: com.aps.common.core.web.domain.AjaxResult |
| | | * @Author: wwj |
| | | * @Date: 2025/4/9 |
| | | */ |
| | | @GetMapping("/confirmWeldSeam") |
| | | public AjaxResult confirmWeldSeam(ApsWeldSeamTemp apsWeldSeamTemp) { |
| | | return toAjax(apsWeldSeamService.confirmWeldSeam(apsWeldSeamTemp)); |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.controller; |
| | | |
| | | import java.util.List; |
| | | import java.io.IOException; |
| | | |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.PutMapping; |
| | | import org.springframework.web.bind.annotation.DeleteMapping; |
| | | import org.springframework.web.bind.annotation.PathVariable; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | import com.aps.common.log.annotation.Log; |
| | | import com.aps.common.log.enums.BusinessType; |
| | | import com.aps.common.security.annotation.RequiresPermissions; |
| | | import com.aps.core.domain.ApsWeldSeamTemp; |
| | | import com.aps.core.service.IApsWeldSeamTempService; |
| | | import com.aps.common.core.web.controller.BaseController; |
| | | import com.aps.common.core.web.domain.AjaxResult; |
| | | import com.aps.common.core.utils.poi.ExcelUtil; |
| | | import com.aps.common.core.web.page.TableDataInfo; |
| | | |
| | | /** |
| | | * çç¼-临æ¶Controller |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | @RestController |
| | | @RequestMapping("/weldSeamTemp") |
| | | public class ApsWeldSeamTempController extends BaseController |
| | | { |
| | | @Autowired |
| | | private IApsWeldSeamTempService apsWeldSeamTempService; |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼-临æ¶å表 |
| | | */ |
| | | @RequiresPermissions("gasPipingTemp:gasPipingTemp:list") |
| | | @GetMapping("/list") |
| | | public TableDataInfo list(ApsWeldSeamTemp apsWeldSeamTemp) |
| | | { |
| | | // startPage(); |
| | | List<ApsWeldSeamTemp> list = apsWeldSeamTempService.selectApsWeldSeamTempList(apsWeldSeamTemp); |
| | | return getDataTable(list); |
| | | } |
| | | |
| | | /** |
| | | * 导åºçç¼-临æ¶å表 |
| | | */ |
| | | @RequiresPermissions("gasPipingTemp:gasPipingTemp:export") |
| | | @Log(title = "çç¼-临æ¶", businessType = BusinessType.EXPORT) |
| | | @PostMapping("/export") |
| | | public void export(HttpServletResponse response, ApsWeldSeamTemp apsWeldSeamTemp) |
| | | { |
| | | List<ApsWeldSeamTemp> list = apsWeldSeamTempService.selectApsWeldSeamTempList(apsWeldSeamTemp); |
| | | ExcelUtil<ApsWeldSeamTemp> util = new ExcelUtil<ApsWeldSeamTemp>(ApsWeldSeamTemp.class); |
| | | util.exportExcel(response, list, "çç¼-ä¸´æ¶æ°æ®"); |
| | | } |
| | | |
| | | /** |
| | | * è·åçç¼-临æ¶è¯¦ç»ä¿¡æ¯ |
| | | */ |
| | | @RequiresPermissions("gasPipingTemp:gasPipingTemp:query") |
| | | @GetMapping(value = "/{id}") |
| | | public AjaxResult getInfo(@PathVariable("id") String id) |
| | | { |
| | | return success(apsWeldSeamTempService.selectApsWeldSeamTempById(id)); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢çç¼-ä¸´æ¶ |
| | | */ |
| | | @RequiresPermissions("gasPipingTemp:gasPipingTemp:add") |
| | | @Log(title = "çç¼-临æ¶", businessType = BusinessType.INSERT) |
| | | @PostMapping |
| | | public AjaxResult add(@RequestBody ApsWeldSeamTemp apsWeldSeamTemp) |
| | | { |
| | | return toAjax(apsWeldSeamTempService.insertApsWeldSeamTemp(apsWeldSeamTemp)); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹çç¼-ä¸´æ¶ |
| | | */ |
| | | @RequiresPermissions("gasPipingTemp:gasPipingTemp:edit") |
| | | @Log(title = "çç¼-临æ¶", businessType = BusinessType.UPDATE) |
| | | @PutMapping |
| | | public AjaxResult edit(@RequestBody ApsWeldSeamTemp apsWeldSeamTemp) |
| | | { |
| | | return toAjax(apsWeldSeamTempService.updateApsWeldSeamTemp(apsWeldSeamTemp)); |
| | | } |
| | | |
| | | /** |
| | | * å é¤çç¼-ä¸´æ¶ |
| | | */ |
| | | @RequiresPermissions("gasPipingTemp:gasPipingTemp:remove") |
| | | @Log(title = "çç¼-临æ¶", businessType = BusinessType.DELETE) |
| | | @DeleteMapping("/{ids}") |
| | | public AjaxResult remove(@PathVariable String[] ids) |
| | | { |
| | | return toAjax(apsWeldSeamTempService.deleteApsWeldSeamTempByIds(ids)); |
| | | } |
| | | } |
| | |
| | | /** é£é©æ è¯ */ |
| | | @Excel(name = "é£é©æ è¯") |
| | | private Integer hasRisk; |
| | | |
| | | private String plant; |
| | | public void setId(String id) |
| | | { |
| | | this.id = id; |
| | |
| | | public void setIsSuspendedTxt(String isSuspendedTxt) { |
| | | this.isSuspendedTxt = isSuspendedTxt; |
| | | } |
| | | |
| | | public String getPlant() { |
| | | return plant; |
| | | } |
| | | |
| | | public void setPlant(String plant) { |
| | | this.plant = plant; |
| | | } |
| | | } |
| | |
| | | /** æ¹æ¬¡å· */ |
| | | @Excel(name = "æ¹æ¬¡å·") |
| | | private String batchNumber; |
| | | private String plant; |
| | | |
| | | public void setId(String id) |
| | | { |
| | |
| | | public void setIsSuspendedTxt(String isSuspendedTxt) { |
| | | this.isSuspendedTxt = isSuspendedTxt; |
| | | } |
| | | |
| | | public String getPlant() { |
| | | return plant; |
| | | } |
| | | |
| | | public void setPlant(String plant) { |
| | | this.plant = plant; |
| | | } |
| | | } |
| | |
| | | private Integer hasRisk; |
| | | |
| | | /** å·¥å */ |
| | | @Excel(name = "å·¥å") |
| | | // @Excel(name = "å·¥å") |
| | | private String plant; |
| | | |
| | | public void setId(String id) |
| | |
| | | private String batchNumber; |
| | | |
| | | /** å·¥å */ |
| | | @Excel(name = "å·¥å") |
| | | // @Excel(name = "å·¥å") |
| | | private String plant; |
| | | |
| | | |
| | |
| | | private Integer hasRisk; |
| | | |
| | | /** å·¥å */ |
| | | @Excel(name = "å·¥å") |
| | | // @Excel(name = "å·¥å") |
| | | private String plant; |
| | | |
| | | public void setId(String id) |
| | |
| | | private String batchNumber; |
| | | |
| | | /** å·¥å */ |
| | | @Excel(name = "å·¥å") |
| | | // @Excel(name = "å·¥å") |
| | | private String plant; |
| | | |
| | | public void setId(String id) |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.domain; |
| | | |
| | | import java.util.Date; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import org.apache.commons.lang3.builder.ToStringBuilder; |
| | | import org.apache.commons.lang3.builder.ToStringStyle; |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.aps.common.core.web.domain.BaseEntity; |
| | | |
| | | /** |
| | | * çç¼å¯¹è±¡ aps_weld_seam |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | public class ApsWeldSeam extends BaseEntity |
| | | { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** 主é®id */ |
| | | private String id; |
| | | /** éå®è®¢åå· */ |
| | | @Excel(name = "éå®è®¢åå·") |
| | | private String saleOrderNo; |
| | | |
| | | /** éå®è®¢åè¡ */ |
| | | @Excel(name = "éå®è®¢åè¡") |
| | | private Long saleOrderLine; |
| | | |
| | | /** 主工åå· */ |
| | | @Excel(name = "主工åå·") |
| | | private String mainWorkOrderNo; |
| | | |
| | | /** ä¸çº§å·¥åå· */ |
| | | @Excel(name = "ä¸çº§å·¥åå·") |
| | | private String superiorWorkOrderNo; |
| | | |
| | | /** å·¥åå· */ |
| | | @Excel(name = "å·¥åå·") |
| | | private String workOrderNo; |
| | | /** å·¥åç±»å */ |
| | | // @Excel(name = "å·¥åç±»å") |
| | | private String workOrderType; |
| | | @Excel(name = "å·¥åç±»å") |
| | | private String workOrderTypeTxt; |
| | | |
| | | /** ç©æç¼ç */ |
| | | @Excel(name = "ç©æç¼ç ") |
| | | private String materialCode; |
| | | |
| | | /** 客æ·å¾å· */ |
| | | @Excel(name = "客æ·å¾å·") |
| | | private String customerDrawingNumber; |
| | | |
| | | /** ç产æ°é */ |
| | | @Excel(name = "ç产æ°é") |
| | | private Long productionQuantity; |
| | | /** ç»ç»è´¦å· */ |
| | | @Excel(name = "ç»ç»è´¦å·") |
| | | private String organizeNumber; |
| | | /** ç©æéæ±æ¥æ */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | @Excel(name = "ç©æéæ±æ¥æ", width = 30, dateFormat = "yyyy-MM-dd") |
| | | private Date materialsRequirementDay; |
| | | /** æ¬æ¬¡å馿¥æ */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | @Excel(name = "æ¬æ¬¡å馿¥æ", width = 30, dateFormat = "yyyy-MM-dd") |
| | | private Date thisFeedbackDay; |
| | | /** ç产åºå° */ |
| | | @Excel(name = "ç产åºå°") |
| | | private String productionBase; |
| | | |
| | | /** åç±»(æ°æ/管路) */ |
| | | // @Excel(name = "åç±»(æ°æ/管路)") |
| | | private String classification; |
| | | @Excel(name = "åç±»") |
| | | private String classificationTxt; |
| | | |
| | | /** ç产年份 */ |
| | | @Excel(name = "ç产年份") |
| | | private Long produceYear; |
| | | |
| | | /** ç产æä»½ */ |
| | | @Excel(name = "ç产æä»½") |
| | | private Long produceMonth; |
| | | |
| | | |
| | | /** å®¢æ· */ |
| | | @Excel(name = "客æ·") |
| | | private String customer; |
| | | |
| | | /** åä»¶çç¼ */ |
| | | @Excel(name = "åä»¶çç¼") |
| | | private Long singleWeldSeam; |
| | | |
| | | /** æ»çç¼ */ |
| | | @Excel(name = "æ»çç¼") |
| | | private Long totalWeldSeam; |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | /** å·¥å */ |
| | | // @Excel(name = "å·¥å") |
| | | private String plant; |
| | | |
| | | public void setId(String id) |
| | | { |
| | | this.id = id; |
| | | } |
| | | |
| | | public String getId() |
| | | { |
| | | return id; |
| | | } |
| | | |
| | | public void setWorkOrderType(String workOrderType) |
| | | { |
| | | this.workOrderType = workOrderType; |
| | | } |
| | | |
| | | public String getWorkOrderType() |
| | | { |
| | | return workOrderType; |
| | | } |
| | | |
| | | public void setMaterialCode(String materialCode) |
| | | { |
| | | this.materialCode = materialCode; |
| | | } |
| | | |
| | | public String getMaterialCode() |
| | | { |
| | | return materialCode; |
| | | } |
| | | |
| | | public void setCustomerDrawingNumber(String customerDrawingNumber) |
| | | { |
| | | this.customerDrawingNumber = customerDrawingNumber; |
| | | } |
| | | |
| | | public String getCustomerDrawingNumber() |
| | | { |
| | | return customerDrawingNumber; |
| | | } |
| | | |
| | | public void setOrganizeNumber(String organizeNumber) |
| | | { |
| | | this.organizeNumber = organizeNumber; |
| | | } |
| | | |
| | | public String getOrganizeNumber() |
| | | { |
| | | return organizeNumber; |
| | | } |
| | | |
| | | public void setProductionBase(String productionBase) |
| | | { |
| | | this.productionBase = productionBase; |
| | | } |
| | | |
| | | public String getProductionBase() |
| | | { |
| | | return productionBase; |
| | | } |
| | | |
| | | public void setClassification(String classification) |
| | | { |
| | | this.classification = classification; |
| | | } |
| | | |
| | | public String getClassification() |
| | | { |
| | | return classification; |
| | | } |
| | | |
| | | public void setProduceYear(Long produceYear) |
| | | { |
| | | this.produceYear = produceYear; |
| | | } |
| | | |
| | | public Long getProduceYear() |
| | | { |
| | | return produceYear; |
| | | } |
| | | |
| | | public void setProduceMonth(Long produceMonth) |
| | | { |
| | | this.produceMonth = produceMonth; |
| | | } |
| | | |
| | | public Long getProduceMonth() |
| | | { |
| | | return produceMonth; |
| | | } |
| | | |
| | | public void setProductionQuantity(Long productionQuantity) |
| | | { |
| | | this.productionQuantity = productionQuantity; |
| | | } |
| | | |
| | | public Long getProductionQuantity() |
| | | { |
| | | return productionQuantity; |
| | | } |
| | | |
| | | public void setCustomer(String customer) |
| | | { |
| | | this.customer = customer; |
| | | } |
| | | |
| | | public String getCustomer() |
| | | { |
| | | return customer; |
| | | } |
| | | |
| | | public void setSingleWeldSeam(Long singleWeldSeam) |
| | | { |
| | | this.singleWeldSeam = singleWeldSeam; |
| | | } |
| | | |
| | | public Long getSingleWeldSeam() |
| | | { |
| | | return singleWeldSeam; |
| | | } |
| | | |
| | | public void setTotalWeldSeam(Long totalWeldSeam) |
| | | { |
| | | this.totalWeldSeam = totalWeldSeam; |
| | | } |
| | | |
| | | public Long getTotalWeldSeam() |
| | | { |
| | | return totalWeldSeam; |
| | | } |
| | | |
| | | public void setThisFeedbackDay(Date thisFeedbackDay) |
| | | { |
| | | this.thisFeedbackDay = thisFeedbackDay; |
| | | } |
| | | |
| | | public Date getThisFeedbackDay() |
| | | { |
| | | return thisFeedbackDay; |
| | | } |
| | | |
| | | public void setMaterialsRequirementDay(Date materialsRequirementDay) |
| | | { |
| | | this.materialsRequirementDay = materialsRequirementDay; |
| | | } |
| | | |
| | | public Date getMaterialsRequirementDay() |
| | | { |
| | | return materialsRequirementDay; |
| | | } |
| | | |
| | | public void setSaleOrderNo(String saleOrderNo) |
| | | { |
| | | this.saleOrderNo = saleOrderNo; |
| | | } |
| | | |
| | | public String getSaleOrderNo() |
| | | { |
| | | return saleOrderNo; |
| | | } |
| | | |
| | | public void setSaleOrderLine(Long saleOrderLine) |
| | | { |
| | | this.saleOrderLine = saleOrderLine; |
| | | } |
| | | |
| | | public Long getSaleOrderLine() |
| | | { |
| | | return saleOrderLine; |
| | | } |
| | | |
| | | public void setMainWorkOrderNo(String mainWorkOrderNo) |
| | | { |
| | | this.mainWorkOrderNo = mainWorkOrderNo; |
| | | } |
| | | |
| | | public String getMainWorkOrderNo() |
| | | { |
| | | return mainWorkOrderNo; |
| | | } |
| | | |
| | | public void setSuperiorWorkOrderNo(String superiorWorkOrderNo) |
| | | { |
| | | this.superiorWorkOrderNo = superiorWorkOrderNo; |
| | | } |
| | | |
| | | public String getSuperiorWorkOrderNo() |
| | | { |
| | | return superiorWorkOrderNo; |
| | | } |
| | | |
| | | public void setWorkOrderNo(String workOrderNo) |
| | | { |
| | | this.workOrderNo = workOrderNo; |
| | | } |
| | | |
| | | public String getWorkOrderNo() |
| | | { |
| | | return workOrderNo; |
| | | } |
| | | |
| | | public void setPlant(String plant) |
| | | { |
| | | this.plant = plant; |
| | | } |
| | | |
| | | public String getPlant() |
| | | { |
| | | return plant; |
| | | } |
| | | |
| | | @Override |
| | | public String toString() { |
| | | return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) |
| | | .append("id", getId()) |
| | | .append("workOrderType", getWorkOrderType()) |
| | | .append("materialCode", getMaterialCode()) |
| | | .append("customerDrawingNumber", getCustomerDrawingNumber()) |
| | | .append("organizeNumber", getOrganizeNumber()) |
| | | .append("productionBase", getProductionBase()) |
| | | .append("classification", getClassification()) |
| | | .append("produceYear", getProduceYear()) |
| | | .append("produceMonth", getProduceMonth()) |
| | | .append("productionQuantity", getProductionQuantity()) |
| | | .append("customer", getCustomer()) |
| | | .append("singleWeldSeam", getSingleWeldSeam()) |
| | | .append("totalWeldSeam", getTotalWeldSeam()) |
| | | .append("thisFeedbackDay", getThisFeedbackDay()) |
| | | .append("materialsRequirementDay", getMaterialsRequirementDay()) |
| | | .append("saleOrderNo", getSaleOrderNo()) |
| | | .append("saleOrderLine", getSaleOrderLine()) |
| | | .append("mainWorkOrderNo", getMainWorkOrderNo()) |
| | | .append("superiorWorkOrderNo", getSuperiorWorkOrderNo()) |
| | | .append("workOrderNo", getWorkOrderNo()) |
| | | .append("plant", getPlant()) |
| | | .toString(); |
| | | } |
| | | |
| | | public String getClassificationTxt() { |
| | | return classificationTxt; |
| | | } |
| | | |
| | | public void setClassificationTxt(String classificationTxt) { |
| | | this.classificationTxt = classificationTxt; |
| | | } |
| | | |
| | | public String getWorkOrderTypeTxt() { |
| | | return workOrderTypeTxt; |
| | | } |
| | | |
| | | public void setWorkOrderTypeTxt(String workOrderTypeTxt) { |
| | | this.workOrderTypeTxt = workOrderTypeTxt; |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.domain; |
| | | |
| | | import java.util.Date; |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import org.apache.commons.lang3.builder.ToStringBuilder; |
| | | import org.apache.commons.lang3.builder.ToStringStyle; |
| | | import com.aps.common.core.annotation.Excel; |
| | | import com.aps.common.core.web.domain.BaseEntity; |
| | | |
| | | /** |
| | | * çç¼-临æ¶å¯¹è±¡ aps_weld_seam_temp |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | public class ApsWeldSeamTemp extends BaseEntity |
| | | { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** 主é®id */ |
| | | private String id; |
| | | |
| | | /** å·¥åç±»å */ |
| | | // @Excel(name = "å·¥åç±»å") |
| | | private String workOrderType; |
| | | @Excel(name = "å·¥åç±»å") |
| | | private String workOrderTypeTxt; |
| | | |
| | | /** ç©æç¼ç */ |
| | | @Excel(name = "ç©æç¼ç ") |
| | | private String materialCode; |
| | | |
| | | /** 客æ·å¾å· */ |
| | | @Excel(name = "客æ·å¾å·") |
| | | private String customerDrawingNumber; |
| | | |
| | | /** ç»ç»è´¦å· */ |
| | | @Excel(name = "ç»ç»è´¦å·") |
| | | private String organizeNumber; |
| | | |
| | | /** ç产åºå° */ |
| | | @Excel(name = "ç产åºå°") |
| | | private String productionBase; |
| | | |
| | | /** åç±»(æ°æ/管路) */ |
| | | // @Excel(name = "åç±»(æ°æ/管路)") |
| | | private String classification; |
| | | @Excel(name = "åç±»") |
| | | private String classificationTxt; |
| | | |
| | | /** ç产年份 */ |
| | | @Excel(name = "ç产年份") |
| | | private Long produceYear; |
| | | |
| | | /** ç产æä»½ */ |
| | | @Excel(name = "ç产æä»½") |
| | | private Long produceMonth; |
| | | |
| | | /** çææ°é */ |
| | | @Excel(name = "ç产æ°é") |
| | | private Long productionQuantity; |
| | | |
| | | /** å®¢æ· */ |
| | | @Excel(name = "客æ·") |
| | | private String customer; |
| | | |
| | | /** åä»¶çç¼ */ |
| | | @Excel(name = "åä»¶çç¼") |
| | | private Long singleWeldSeam; |
| | | |
| | | /** æ»çç¼ */ |
| | | @Excel(name = "æ»çç¼") |
| | | private Long totalWeldSeam; |
| | | |
| | | /** æ¬æ¬¡å馿¥æ */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | @Excel(name = "æ¬æ¬¡å馿¥æ", width = 30, dateFormat = "yyyy-MM-dd") |
| | | private Date thisFeedbackDay; |
| | | |
| | | /** ç©æéæ±æ¥æ */ |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | @Excel(name = "ç©æéæ±æ¥æ", width = 30, dateFormat = "yyyy-MM-dd") |
| | | private Date materialsRequirementDay; |
| | | |
| | | /** éå®è®¢åå· */ |
| | | @Excel(name = "éå®è®¢åå·") |
| | | private String saleOrderNo; |
| | | |
| | | /** éå®è®¢åè¡ */ |
| | | @Excel(name = "éå®è®¢åè¡") |
| | | private Long saleOrderLine; |
| | | |
| | | /** 主工åå· */ |
| | | @Excel(name = "主工åå·") |
| | | private String mainWorkOrderNo; |
| | | |
| | | /** ä¸çº§å·¥åå· */ |
| | | @Excel(name = "ä¸çº§å·¥åå·") |
| | | private String superiorWorkOrderNo; |
| | | |
| | | /** å·¥åå· */ |
| | | @Excel(name = "å·¥åå·") |
| | | private String workOrderNo; |
| | | |
| | | /** å·¥å */ |
| | | // @Excel(name = "å·¥å") |
| | | private String plant; |
| | | |
| | | /** æ¹æ¬¡å· */ |
| | | @Excel(name = "æ¹æ¬¡å·") |
| | | private String batchNumber; |
| | | |
| | | public void setId(String id) |
| | | { |
| | | this.id = id; |
| | | } |
| | | |
| | | public String getId() |
| | | { |
| | | return id; |
| | | } |
| | | |
| | | public void setWorkOrderType(String workOrderType) |
| | | { |
| | | this.workOrderType = workOrderType; |
| | | } |
| | | |
| | | public String getWorkOrderType() |
| | | { |
| | | return workOrderType; |
| | | } |
| | | |
| | | public void setMaterialCode(String materialCode) |
| | | { |
| | | this.materialCode = materialCode; |
| | | } |
| | | |
| | | public String getMaterialCode() |
| | | { |
| | | return materialCode; |
| | | } |
| | | |
| | | public void setCustomerDrawingNumber(String customerDrawingNumber) |
| | | { |
| | | this.customerDrawingNumber = customerDrawingNumber; |
| | | } |
| | | |
| | | public String getCustomerDrawingNumber() |
| | | { |
| | | return customerDrawingNumber; |
| | | } |
| | | |
| | | public void setOrganizeNumber(String organizeNumber) |
| | | { |
| | | this.organizeNumber = organizeNumber; |
| | | } |
| | | |
| | | public String getOrganizeNumber() |
| | | { |
| | | return organizeNumber; |
| | | } |
| | | |
| | | public void setProductionBase(String productionBase) |
| | | { |
| | | this.productionBase = productionBase; |
| | | } |
| | | |
| | | public String getProductionBase() |
| | | { |
| | | return productionBase; |
| | | } |
| | | |
| | | public void setClassification(String classification) |
| | | { |
| | | this.classification = classification; |
| | | } |
| | | |
| | | public String getClassification() |
| | | { |
| | | return classification; |
| | | } |
| | | |
| | | public void setProduceYear(Long produceYear) |
| | | { |
| | | this.produceYear = produceYear; |
| | | } |
| | | |
| | | public Long getProduceYear() |
| | | { |
| | | return produceYear; |
| | | } |
| | | |
| | | public void setProduceMonth(Long produceMonth) |
| | | { |
| | | this.produceMonth = produceMonth; |
| | | } |
| | | |
| | | public Long getProduceMonth() |
| | | { |
| | | return produceMonth; |
| | | } |
| | | |
| | | public void setProductionQuantity(Long productionQuantity) |
| | | { |
| | | this.productionQuantity = productionQuantity; |
| | | } |
| | | |
| | | public Long getProductionQuantity() |
| | | { |
| | | return productionQuantity; |
| | | } |
| | | |
| | | public void setCustomer(String customer) |
| | | { |
| | | this.customer = customer; |
| | | } |
| | | |
| | | public String getCustomer() |
| | | { |
| | | return customer; |
| | | } |
| | | |
| | | public void setSingleWeldSeam(Long singleWeldSeam) |
| | | { |
| | | this.singleWeldSeam = singleWeldSeam; |
| | | } |
| | | |
| | | public Long getSingleWeldSeam() |
| | | { |
| | | return singleWeldSeam; |
| | | } |
| | | |
| | | public void setTotalWeldSeam(Long totalWeldSeam) |
| | | { |
| | | this.totalWeldSeam = totalWeldSeam; |
| | | } |
| | | |
| | | public Long getTotalWeldSeam() |
| | | { |
| | | return totalWeldSeam; |
| | | } |
| | | |
| | | public void setThisFeedbackDay(Date thisFeedbackDay) |
| | | { |
| | | this.thisFeedbackDay = thisFeedbackDay; |
| | | } |
| | | |
| | | public Date getThisFeedbackDay() |
| | | { |
| | | return thisFeedbackDay; |
| | | } |
| | | |
| | | public void setMaterialsRequirementDay(Date materialsRequirementDay) |
| | | { |
| | | this.materialsRequirementDay = materialsRequirementDay; |
| | | } |
| | | |
| | | public Date getMaterialsRequirementDay() |
| | | { |
| | | return materialsRequirementDay; |
| | | } |
| | | |
| | | public void setSaleOrderNo(String saleOrderNo) |
| | | { |
| | | this.saleOrderNo = saleOrderNo; |
| | | } |
| | | |
| | | public String getSaleOrderNo() |
| | | { |
| | | return saleOrderNo; |
| | | } |
| | | |
| | | public void setSaleOrderLine(Long saleOrderLine) |
| | | { |
| | | this.saleOrderLine = saleOrderLine; |
| | | } |
| | | |
| | | public Long getSaleOrderLine() |
| | | { |
| | | return saleOrderLine; |
| | | } |
| | | |
| | | public void setMainWorkOrderNo(String mainWorkOrderNo) |
| | | { |
| | | this.mainWorkOrderNo = mainWorkOrderNo; |
| | | } |
| | | |
| | | public String getMainWorkOrderNo() |
| | | { |
| | | return mainWorkOrderNo; |
| | | } |
| | | |
| | | public void setSuperiorWorkOrderNo(String superiorWorkOrderNo) |
| | | { |
| | | this.superiorWorkOrderNo = superiorWorkOrderNo; |
| | | } |
| | | |
| | | public String getSuperiorWorkOrderNo() |
| | | { |
| | | return superiorWorkOrderNo; |
| | | } |
| | | |
| | | public void setWorkOrderNo(String workOrderNo) |
| | | { |
| | | this.workOrderNo = workOrderNo; |
| | | } |
| | | |
| | | public String getWorkOrderNo() |
| | | { |
| | | return workOrderNo; |
| | | } |
| | | |
| | | public void setPlant(String plant) |
| | | { |
| | | this.plant = plant; |
| | | } |
| | | |
| | | public String getPlant() |
| | | { |
| | | return plant; |
| | | } |
| | | |
| | | public void setBatchNumber(String batchNumber) |
| | | { |
| | | this.batchNumber = batchNumber; |
| | | } |
| | | |
| | | public String getBatchNumber() |
| | | { |
| | | return batchNumber; |
| | | } |
| | | |
| | | @Override |
| | | public String toString() { |
| | | return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) |
| | | .append("id", getId()) |
| | | .append("workOrderType", getWorkOrderType()) |
| | | .append("materialCode", getMaterialCode()) |
| | | .append("customerDrawingNumber", getCustomerDrawingNumber()) |
| | | .append("organizeNumber", getOrganizeNumber()) |
| | | .append("productionBase", getProductionBase()) |
| | | .append("classification", getClassification()) |
| | | .append("produceYear", getProduceYear()) |
| | | .append("produceMonth", getProduceMonth()) |
| | | .append("productionQuantity", getProductionQuantity()) |
| | | .append("customer", getCustomer()) |
| | | .append("singleWeldSeam", getSingleWeldSeam()) |
| | | .append("totalWeldSeam", getTotalWeldSeam()) |
| | | .append("thisFeedbackDay", getThisFeedbackDay()) |
| | | .append("materialsRequirementDay", getMaterialsRequirementDay()) |
| | | .append("saleOrderNo", getSaleOrderNo()) |
| | | .append("saleOrderLine", getSaleOrderLine()) |
| | | .append("mainWorkOrderNo", getMainWorkOrderNo()) |
| | | .append("superiorWorkOrderNo", getSuperiorWorkOrderNo()) |
| | | .append("workOrderNo", getWorkOrderNo()) |
| | | .append("plant", getPlant()) |
| | | .append("batchNumber", getBatchNumber()) |
| | | .toString(); |
| | | } |
| | | |
| | | public String getWorkOrderTypeTxt() { |
| | | return workOrderTypeTxt; |
| | | } |
| | | |
| | | public void setWorkOrderTypeTxt(String workOrderTypeTxt) { |
| | | this.workOrderTypeTxt = workOrderTypeTxt; |
| | | } |
| | | |
| | | public String getClassificationTxt() { |
| | | return classificationTxt; |
| | | } |
| | | |
| | | public void setClassificationTxt(String classificationTxt) { |
| | | this.classificationTxt = classificationTxt; |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsWeldSeam; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * çç¼Mapperæ¥å£ |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | @Mapper |
| | | public interface ApsWeldSeamMapper |
| | | { |
| | | /** |
| | | * æ¥è¯¢çç¼ |
| | | * |
| | | * @param id çç¼ä¸»é® |
| | | * @return çç¼ |
| | | */ |
| | | public ApsWeldSeam selectApsWeldSeamById(String id); |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼å表 |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return çç¼éå |
| | | */ |
| | | public List<ApsWeldSeam> selectApsWeldSeamList(ApsWeldSeam apsWeldSeam); |
| | | |
| | | /** |
| | | * æ°å¢çç¼ |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return ç»æ |
| | | */ |
| | | public int insertApsWeldSeam(ApsWeldSeam apsWeldSeam); |
| | | |
| | | /** |
| | | * ä¿®æ¹çç¼ |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return ç»æ |
| | | */ |
| | | public int updateApsWeldSeam(ApsWeldSeam apsWeldSeam); |
| | | |
| | | /** |
| | | * å é¤çç¼ |
| | | * |
| | | * @param id çç¼ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteApsWeldSeamById(String id); |
| | | |
| | | /** |
| | | * æ¹éå é¤çç¼ |
| | | * |
| | | * @param ids éè¦å é¤çæ°æ®ä¸»é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteApsWeldSeamByIds(String[] ids); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.mapper; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsWeldSeamTemp; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * çç¼-临æ¶Mapperæ¥å£ |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | @Mapper |
| | | public interface ApsWeldSeamTempMapper |
| | | { |
| | | /** |
| | | * æ¥è¯¢çç¼-ä¸´æ¶ |
| | | * |
| | | * @param id çç¼-临æ¶ä¸»é® |
| | | * @return çç¼-ä¸´æ¶ |
| | | */ |
| | | public ApsWeldSeamTemp selectApsWeldSeamTempById(String id); |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼-临æ¶å表 |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return çç¼-临æ¶éå |
| | | */ |
| | | public List<ApsWeldSeamTemp> selectApsWeldSeamTempList(ApsWeldSeamTemp apsWeldSeamTemp); |
| | | |
| | | /** |
| | | * æ°å¢çç¼-ä¸´æ¶ |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return ç»æ |
| | | */ |
| | | public int insertApsWeldSeamTemp(ApsWeldSeamTemp apsWeldSeamTemp); |
| | | |
| | | /** |
| | | * ä¿®æ¹çç¼-ä¸´æ¶ |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return ç»æ |
| | | */ |
| | | public int updateApsWeldSeamTemp(ApsWeldSeamTemp apsWeldSeamTemp); |
| | | |
| | | /** |
| | | * å é¤çç¼-ä¸´æ¶ |
| | | * |
| | | * @param id çç¼-临æ¶ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteApsWeldSeamTempById(String id); |
| | | |
| | | /** |
| | | * æ¹éå é¤çç¼-ä¸´æ¶ |
| | | * |
| | | * @param ids éè¦å é¤çæ°æ®ä¸»é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteApsWeldSeamTempByIds(String[] ids); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.service; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsWeldSeam; |
| | | import com.aps.core.domain.ApsWeldSeamTemp; |
| | | |
| | | /** |
| | | * çç¼Serviceæ¥å£ |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | public interface IApsWeldSeamService |
| | | { |
| | | /** |
| | | * æ¥è¯¢çç¼ |
| | | * |
| | | * @param id çç¼ä¸»é® |
| | | * @return çç¼ |
| | | */ |
| | | public ApsWeldSeam selectApsWeldSeamById(String id); |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼å表 |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return çç¼éå |
| | | */ |
| | | public List<ApsWeldSeam> selectApsWeldSeamList(ApsWeldSeam apsWeldSeam); |
| | | |
| | | /** |
| | | * æ°å¢çç¼ |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return ç»æ |
| | | */ |
| | | public int insertApsWeldSeam(ApsWeldSeam apsWeldSeam); |
| | | |
| | | /** |
| | | * ä¿®æ¹çç¼ |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return ç»æ |
| | | */ |
| | | public int updateApsWeldSeam(ApsWeldSeam apsWeldSeam); |
| | | |
| | | /** |
| | | * æ¹éå é¤çç¼ |
| | | * |
| | | * @param ids éè¦å é¤ççç¼ä¸»é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteApsWeldSeamByIds(String[] ids); |
| | | |
| | | /** |
| | | * å é¤çç¼ä¿¡æ¯ |
| | | * |
| | | * @param id çç¼ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteApsWeldSeamById(String id); |
| | | |
| | | int confirmWeldSeam(ApsWeldSeamTemp apsWeldSeamTemp); |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.service; |
| | | |
| | | import java.util.List; |
| | | import com.aps.core.domain.ApsWeldSeamTemp; |
| | | |
| | | /** |
| | | * çç¼-临æ¶Serviceæ¥å£ |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | public interface IApsWeldSeamTempService |
| | | { |
| | | /** |
| | | * æ¥è¯¢çç¼-ä¸´æ¶ |
| | | * |
| | | * @param id çç¼-临æ¶ä¸»é® |
| | | * @return çç¼-ä¸´æ¶ |
| | | */ |
| | | public ApsWeldSeamTemp selectApsWeldSeamTempById(String id); |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼-临æ¶å表 |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return çç¼-临æ¶éå |
| | | */ |
| | | public List<ApsWeldSeamTemp> selectApsWeldSeamTempList(ApsWeldSeamTemp apsWeldSeamTemp); |
| | | |
| | | /** |
| | | * æ°å¢çç¼-ä¸´æ¶ |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return ç»æ |
| | | */ |
| | | public int insertApsWeldSeamTemp(ApsWeldSeamTemp apsWeldSeamTemp); |
| | | |
| | | /** |
| | | * ä¿®æ¹çç¼-ä¸´æ¶ |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return ç»æ |
| | | */ |
| | | public int updateApsWeldSeamTemp(ApsWeldSeamTemp apsWeldSeamTemp); |
| | | |
| | | /** |
| | | * æ¹éå é¤çç¼-ä¸´æ¶ |
| | | * |
| | | * @param ids éè¦å é¤ççç¼-临æ¶ä¸»é®éå |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteApsWeldSeamTempByIds(String[] ids); |
| | | |
| | | /** |
| | | * å é¤çç¼-临æ¶ä¿¡æ¯ |
| | | * |
| | | * @param id çç¼-临æ¶ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | public int deleteApsWeldSeamTempById(String id); |
| | | } |
| | |
| | | if (count==apsGasPipingPlanTemps.size()) { |
| | | apsGasPipingPlanTempMapper.deleteApsGasPipingPlanTempByIds(ids); |
| | | } |
| | | return 0; |
| | | return 1; |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.service.impl; |
| | | |
| | | import java.util.List; |
| | | |
| | | import com.aps.common.core.utils.uuid.IdUtils; |
| | | import com.aps.core.domain.ApsPartPlan; |
| | | import com.aps.core.domain.ApsPartPlanTemp; |
| | | import com.aps.core.domain.ApsWeldSeamTemp; |
| | | import com.aps.core.mapper.ApsWeldSeamTempMapper; |
| | | import org.springframework.beans.BeanUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.mapper.ApsWeldSeamMapper; |
| | | import com.aps.core.domain.ApsWeldSeam; |
| | | import com.aps.core.service.IApsWeldSeamService; |
| | | |
| | | /** |
| | | * çç¼Serviceä¸å¡å±å¤ç |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | @Service |
| | | public class ApsWeldSeamServiceImpl implements IApsWeldSeamService |
| | | { |
| | | @Autowired |
| | | private ApsWeldSeamMapper apsWeldSeamMapper; |
| | | @Autowired |
| | | private ApsWeldSeamTempMapper apsWeldSeamTempMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼ |
| | | * |
| | | * @param id çç¼ä¸»é® |
| | | * @return çç¼ |
| | | */ |
| | | @Override |
| | | public ApsWeldSeam selectApsWeldSeamById(String id) |
| | | { |
| | | return apsWeldSeamMapper.selectApsWeldSeamById(id); |
| | | } |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼å表 |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return çç¼ |
| | | */ |
| | | @Override |
| | | public List<ApsWeldSeam> selectApsWeldSeamList(ApsWeldSeam apsWeldSeam) |
| | | { |
| | | return apsWeldSeamMapper.selectApsWeldSeamList(apsWeldSeam); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢çç¼ |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int insertApsWeldSeam(ApsWeldSeam apsWeldSeam) |
| | | { |
| | | apsWeldSeam.setId(IdUtils.fastUUID()); |
| | | return apsWeldSeamMapper.insertApsWeldSeam(apsWeldSeam); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹çç¼ |
| | | * |
| | | * @param apsWeldSeam çç¼ |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int updateApsWeldSeam(ApsWeldSeam apsWeldSeam) |
| | | { |
| | | return apsWeldSeamMapper.updateApsWeldSeam(apsWeldSeam); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤çç¼ |
| | | * |
| | | * @param ids éè¦å é¤ççç¼ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int deleteApsWeldSeamByIds(String[] ids) |
| | | { |
| | | return apsWeldSeamMapper.deleteApsWeldSeamByIds(ids); |
| | | } |
| | | |
| | | /** |
| | | * å é¤çç¼ä¿¡æ¯ |
| | | * |
| | | * @param id çç¼ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int deleteApsWeldSeamById(String id) |
| | | { |
| | | return apsWeldSeamMapper.deleteApsWeldSeamById(id); |
| | | } |
| | | |
| | | @Override |
| | | public int confirmWeldSeam(ApsWeldSeamTemp apsWeldSeamTemp) { |
| | | //æ¥è¯¢ä¸´æ¶è¡¨æ°æ® |
| | | List<ApsWeldSeamTemp> apsWeldSeamTemps=apsWeldSeamTempMapper.selectApsWeldSeamTempList(apsWeldSeamTemp); |
| | | int count=0; |
| | | String[] ids=new String[apsWeldSeamTemps.size()]; |
| | | for (int i = 0; i <apsWeldSeamTemps.size() ; i++) { |
| | | //è®°å½ä¸´æ¶è¡¨id |
| | | ids[i]=apsWeldSeamTemps.get(i).getId(); |
| | | ApsWeldSeam apsWeldSeam=new ApsWeldSeam(); |
| | | BeanUtils.copyProperties(apsWeldSeamTemps.get(i), apsWeldSeam); |
| | | apsWeldSeam.setId(IdUtils.fastUUID()); |
| | | //æå
¥æ£å¼è¡¨ï¼å¹¶è®°å½ |
| | | apsWeldSeamMapper.insertApsWeldSeam(apsWeldSeam); |
| | | count++; |
| | | } |
| | | //æå
¥æ°éä¸ä¸´æ¶è¡¨æ¥è¯¢ä¸ç´åå é¤ä¸´æ¶è¡¨æ°æ® |
| | | if (count==apsWeldSeamTemps.size()) { |
| | | apsWeldSeamTempMapper.deleteApsWeldSeamTempByIds(ids); |
| | | } |
| | | return 1; |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.aps.core.service.impl; |
| | | |
| | | import java.util.List; |
| | | |
| | | import com.aps.common.core.utils.uuid.IdUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import com.aps.core.mapper.ApsWeldSeamTempMapper; |
| | | import com.aps.core.domain.ApsWeldSeamTemp; |
| | | import com.aps.core.service.IApsWeldSeamTempService; |
| | | |
| | | /** |
| | | * çç¼-临æ¶Serviceä¸å¡å±å¤ç |
| | | * |
| | | * @author wwj |
| | | * @date 2025-04-09 |
| | | */ |
| | | @Service |
| | | public class ApsWeldSeamTempServiceImpl implements IApsWeldSeamTempService |
| | | { |
| | | @Autowired |
| | | private ApsWeldSeamTempMapper apsWeldSeamTempMapper; |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼-ä¸´æ¶ |
| | | * |
| | | * @param id çç¼-临æ¶ä¸»é® |
| | | * @return çç¼-ä¸´æ¶ |
| | | */ |
| | | @Override |
| | | public ApsWeldSeamTemp selectApsWeldSeamTempById(String id) |
| | | { |
| | | return apsWeldSeamTempMapper.selectApsWeldSeamTempById(id); |
| | | } |
| | | |
| | | /** |
| | | * æ¥è¯¢çç¼-临æ¶å表 |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return çç¼-ä¸´æ¶ |
| | | */ |
| | | @Override |
| | | public List<ApsWeldSeamTemp> selectApsWeldSeamTempList(ApsWeldSeamTemp apsWeldSeamTemp) |
| | | { |
| | | return apsWeldSeamTempMapper.selectApsWeldSeamTempList(apsWeldSeamTemp); |
| | | } |
| | | |
| | | /** |
| | | * æ°å¢çç¼-ä¸´æ¶ |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int insertApsWeldSeamTemp(ApsWeldSeamTemp apsWeldSeamTemp) |
| | | { |
| | | apsWeldSeamTemp.setId(IdUtils.fastUUID()); |
| | | return apsWeldSeamTempMapper.insertApsWeldSeamTemp(apsWeldSeamTemp); |
| | | } |
| | | |
| | | /** |
| | | * ä¿®æ¹çç¼-ä¸´æ¶ |
| | | * |
| | | * @param apsWeldSeamTemp çç¼-ä¸´æ¶ |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int updateApsWeldSeamTemp(ApsWeldSeamTemp apsWeldSeamTemp) |
| | | { |
| | | return apsWeldSeamTempMapper.updateApsWeldSeamTemp(apsWeldSeamTemp); |
| | | } |
| | | |
| | | /** |
| | | * æ¹éå é¤çç¼-ä¸´æ¶ |
| | | * |
| | | * @param ids éè¦å é¤ççç¼-临æ¶ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int deleteApsWeldSeamTempByIds(String[] ids) |
| | | { |
| | | return apsWeldSeamTempMapper.deleteApsWeldSeamTempByIds(ids); |
| | | } |
| | | |
| | | /** |
| | | * å é¤çç¼-临æ¶ä¿¡æ¯ |
| | | * |
| | | * @param id çç¼-临æ¶ä¸»é® |
| | | * @return ç»æ |
| | | */ |
| | | @Override |
| | | public int deleteApsWeldSeamTempById(String id) |
| | | { |
| | | return apsWeldSeamTempMapper.deleteApsWeldSeamTempById(id); |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | <?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.aps.core.mapper.ApsWeldSeamMapper"> |
| | | |
| | | <resultMap type="ApsWeldSeam" id="ApsWeldSeamResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="workOrderType" column="work_order_type" /> |
| | | <result property="materialCode" column="material_code" /> |
| | | <result property="customerDrawingNumber" column="customer_drawing_number" /> |
| | | <result property="organizeNumber" column="organize_number" /> |
| | | <result property="productionBase" column="production_base" /> |
| | | <result property="classification" column="classification" /> |
| | | <result property="produceYear" column="produce_year" /> |
| | | <result property="produceMonth" column="produce_month" /> |
| | | <result property="productionQuantity" column="production_quantity" /> |
| | | <result property="customer" column="customer" /> |
| | | <result property="singleWeldSeam" column="single_weld_seam" /> |
| | | <result property="totalWeldSeam" column="total_weld_seam" /> |
| | | <result property="thisFeedbackDay" column="this_feedback_day" /> |
| | | <result property="materialsRequirementDay" column="materials_requirement_day" /> |
| | | <result property="saleOrderNo" column="sale_order_no" /> |
| | | <result property="saleOrderLine" column="sale_order_line" /> |
| | | <result property="mainWorkOrderNo" column="main_work_order_no" /> |
| | | <result property="superiorWorkOrderNo" column="superior_work_order_no" /> |
| | | <result property="workOrderNo" column="work_order_no" /> |
| | | <result property="plant" column="plant" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectApsWeldSeamVo"> |
| | | select id, work_order_type, material_code, customer_drawing_number, organize_number, production_base, classification, produce_year, produce_month, production_quantity, customer, single_weld_seam, total_weld_seam, this_feedback_day, materials_requirement_day, sale_order_no, sale_order_line, main_work_order_no, superior_work_order_no, work_order_no, plant from aps_weld_seam |
| | | </sql> |
| | | |
| | | <select id="selectApsWeldSeamList" parameterType="ApsWeldSeam" resultMap="ApsWeldSeamResult"> |
| | | <include refid="selectApsWeldSeamVo"/> |
| | | <where> |
| | | <if test="workOrderType != null and workOrderType != ''"> and work_order_type = #{workOrderType}</if> |
| | | <if test="materialCode != null and materialCode != ''"> and material_code = #{materialCode}</if> |
| | | <if test="customerDrawingNumber != null and customerDrawingNumber != ''"> and customer_drawing_number = #{customerDrawingNumber}</if> |
| | | <if test="organizeNumber != null and organizeNumber != ''"> and organize_number = #{organizeNumber}</if> |
| | | <if test="productionBase != null and productionBase != ''"> and production_base = #{productionBase}</if> |
| | | <if test="classification != null and classification != ''"> and classification = #{classification}</if> |
| | | <if test="produceYear != null "> and produce_year = #{produceYear}</if> |
| | | <if test="produceMonth != null "> and produce_month = #{produceMonth}</if> |
| | | <if test="productionQuantity != null "> and production_quantity = #{productionQuantity}</if> |
| | | <if test="customer != null and customer != ''"> and customer = #{customer}</if> |
| | | <if test="singleWeldSeam != null "> and single_weld_seam = #{singleWeldSeam}</if> |
| | | <if test="totalWeldSeam != null "> and total_weld_seam = #{totalWeldSeam}</if> |
| | | <if test="params.beginThisFeedbackDay != null and params.beginThisFeedbackDay != '' and params.endThisFeedbackDay != null and params.endThisFeedbackDay != ''"> and this_feedback_day between #{params.beginThisFeedbackDay} and #{params.endThisFeedbackDay}</if> |
| | | <if test="params.beginMaterialsRequirementDay != null and params.beginMaterialsRequirementDay != '' and params.endMaterialsRequirementDay != null and params.endMaterialsRequirementDay != ''"> and materials_requirement_day between #{params.beginMaterialsRequirementDay} and #{params.endMaterialsRequirementDay}</if> |
| | | <if test="saleOrderNo != null and saleOrderNo != ''"> and sale_order_no = #{saleOrderNo}</if> |
| | | <if test="saleOrderLine != null "> and sale_order_line = #{saleOrderLine}</if> |
| | | <if test="mainWorkOrderNo != null and mainWorkOrderNo != ''"> and main_work_order_no = #{mainWorkOrderNo}</if> |
| | | <if test="superiorWorkOrderNo != null and superiorWorkOrderNo != ''"> and superior_work_order_no = #{superiorWorkOrderNo}</if> |
| | | <if test="workOrderNo != null and workOrderNo != ''"> and work_order_no = #{workOrderNo}</if> |
| | | <if test="plant != null and plant != ''"> and plant = #{plant}</if> |
| | | </where> |
| | | </select> |
| | | |
| | | <select id="selectApsWeldSeamById" parameterType="String" resultMap="ApsWeldSeamResult"> |
| | | <include refid="selectApsWeldSeamVo"/> |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsWeldSeam" parameterType="ApsWeldSeam"> |
| | | insert into aps_weld_seam |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="workOrderType != null">work_order_type,</if> |
| | | <if test="materialCode != null">material_code,</if> |
| | | <if test="customerDrawingNumber != null">customer_drawing_number,</if> |
| | | <if test="organizeNumber != null">organize_number,</if> |
| | | <if test="productionBase != null">production_base,</if> |
| | | <if test="classification != null">classification,</if> |
| | | <if test="produceYear != null">produce_year,</if> |
| | | <if test="produceMonth != null">produce_month,</if> |
| | | <if test="productionQuantity != null">production_quantity,</if> |
| | | <if test="customer != null">customer,</if> |
| | | <if test="singleWeldSeam != null">single_weld_seam,</if> |
| | | <if test="totalWeldSeam != null">total_weld_seam,</if> |
| | | <if test="thisFeedbackDay != null">this_feedback_day,</if> |
| | | <if test="materialsRequirementDay != null">materials_requirement_day,</if> |
| | | <if test="saleOrderNo != null">sale_order_no,</if> |
| | | <if test="saleOrderLine != null">sale_order_line,</if> |
| | | <if test="mainWorkOrderNo != null">main_work_order_no,</if> |
| | | <if test="superiorWorkOrderNo != null">superior_work_order_no,</if> |
| | | <if test="workOrderNo != null">work_order_no,</if> |
| | | <if test="plant != null">plant,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">#{id},</if> |
| | | <if test="workOrderType != null">#{workOrderType},</if> |
| | | <if test="materialCode != null">#{materialCode},</if> |
| | | <if test="customerDrawingNumber != null">#{customerDrawingNumber},</if> |
| | | <if test="organizeNumber != null">#{organizeNumber},</if> |
| | | <if test="productionBase != null">#{productionBase},</if> |
| | | <if test="classification != null">#{classification},</if> |
| | | <if test="produceYear != null">#{produceYear},</if> |
| | | <if test="produceMonth != null">#{produceMonth},</if> |
| | | <if test="productionQuantity != null">#{productionQuantity},</if> |
| | | <if test="customer != null">#{customer},</if> |
| | | <if test="singleWeldSeam != null">#{singleWeldSeam},</if> |
| | | <if test="totalWeldSeam != null">#{totalWeldSeam},</if> |
| | | <if test="thisFeedbackDay != null">#{thisFeedbackDay},</if> |
| | | <if test="materialsRequirementDay != null">#{materialsRequirementDay},</if> |
| | | <if test="saleOrderNo != null">#{saleOrderNo},</if> |
| | | <if test="saleOrderLine != null">#{saleOrderLine},</if> |
| | | <if test="mainWorkOrderNo != null">#{mainWorkOrderNo},</if> |
| | | <if test="superiorWorkOrderNo != null">#{superiorWorkOrderNo},</if> |
| | | <if test="workOrderNo != null">#{workOrderNo},</if> |
| | | <if test="plant != null">#{plant},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsWeldSeam" parameterType="ApsWeldSeam"> |
| | | update aps_weld_seam |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="workOrderType != null">work_order_type = #{workOrderType},</if> |
| | | <if test="materialCode != null">material_code = #{materialCode},</if> |
| | | <if test="customerDrawingNumber != null">customer_drawing_number = #{customerDrawingNumber},</if> |
| | | <if test="organizeNumber != null">organize_number = #{organizeNumber},</if> |
| | | <if test="productionBase != null">production_base = #{productionBase},</if> |
| | | <if test="classification != null">classification = #{classification},</if> |
| | | <if test="produceYear != null">produce_year = #{produceYear},</if> |
| | | <if test="produceMonth != null">produce_month = #{produceMonth},</if> |
| | | <if test="productionQuantity != null">production_quantity = #{productionQuantity},</if> |
| | | <if test="customer != null">customer = #{customer},</if> |
| | | <if test="singleWeldSeam != null">single_weld_seam = #{singleWeldSeam},</if> |
| | | <if test="totalWeldSeam != null">total_weld_seam = #{totalWeldSeam},</if> |
| | | <if test="thisFeedbackDay != null">this_feedback_day = #{thisFeedbackDay},</if> |
| | | <if test="materialsRequirementDay != null">materials_requirement_day = #{materialsRequirementDay},</if> |
| | | <if test="saleOrderNo != null">sale_order_no = #{saleOrderNo},</if> |
| | | <if test="saleOrderLine != null">sale_order_line = #{saleOrderLine},</if> |
| | | <if test="mainWorkOrderNo != null">main_work_order_no = #{mainWorkOrderNo},</if> |
| | | <if test="superiorWorkOrderNo != null">superior_work_order_no = #{superiorWorkOrderNo},</if> |
| | | <if test="workOrderNo != null">work_order_no = #{workOrderNo},</if> |
| | | <if test="plant != null">plant = #{plant},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteApsWeldSeamById" parameterType="String"> |
| | | delete from aps_weld_seam where id = #{id} |
| | | </delete> |
| | | |
| | | <delete id="deleteApsWeldSeamByIds" parameterType="String"> |
| | | delete from aps_weld_seam where id in |
| | | <foreach item="id" collection="array" open="(" separator="," close=")"> |
| | | #{id} |
| | | </foreach> |
| | | </delete> |
| | | </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.aps.core.mapper.ApsWeldSeamTempMapper"> |
| | | |
| | | <resultMap type="ApsWeldSeamTemp" id="ApsWeldSeamTempResult"> |
| | | <result property="id" column="id" /> |
| | | <result property="workOrderType" column="work_order_type" /> |
| | | <result property="materialCode" column="material_code" /> |
| | | <result property="customerDrawingNumber" column="customer_drawing_number" /> |
| | | <result property="organizeNumber" column="organize_number" /> |
| | | <result property="productionBase" column="production_base" /> |
| | | <result property="classification" column="classification" /> |
| | | <result property="produceYear" column="produce_year" /> |
| | | <result property="produceMonth" column="produce_month" /> |
| | | <result property="productionQuantity" column="production_quantity" /> |
| | | <result property="customer" column="customer" /> |
| | | <result property="singleWeldSeam" column="single_weld_seam" /> |
| | | <result property="totalWeldSeam" column="total_weld_seam" /> |
| | | <result property="thisFeedbackDay" column="this_feedback_day" /> |
| | | <result property="materialsRequirementDay" column="materials_requirement_day" /> |
| | | <result property="saleOrderNo" column="sale_order_no" /> |
| | | <result property="saleOrderLine" column="sale_order_line" /> |
| | | <result property="mainWorkOrderNo" column="main_work_order_no" /> |
| | | <result property="superiorWorkOrderNo" column="superior_work_order_no" /> |
| | | <result property="workOrderNo" column="work_order_no" /> |
| | | <result property="plant" column="plant" /> |
| | | <result property="batchNumber" column="batch_number" /> |
| | | </resultMap> |
| | | |
| | | <sql id="selectApsWeldSeamTempVo"> |
| | | select id, work_order_type, material_code, customer_drawing_number, organize_number, production_base, classification, produce_year, produce_month, production_quantity, customer, single_weld_seam, total_weld_seam, this_feedback_day, materials_requirement_day, sale_order_no, sale_order_line, main_work_order_no, superior_work_order_no, work_order_no, plant, batch_number from aps_weld_seam_temp |
| | | </sql> |
| | | |
| | | <select id="selectApsWeldSeamTempList" parameterType="ApsWeldSeamTemp" resultMap="ApsWeldSeamTempResult"> |
| | | <include refid="selectApsWeldSeamTempVo"/> |
| | | <where> |
| | | <if test="workOrderType != null and workOrderType != ''"> and work_order_type = #{workOrderType}</if> |
| | | <if test="materialCode != null and materialCode != ''"> and material_code = #{materialCode}</if> |
| | | <if test="customerDrawingNumber != null and customerDrawingNumber != ''"> and customer_drawing_number = #{customerDrawingNumber}</if> |
| | | <if test="organizeNumber != null and organizeNumber != ''"> and organize_number = #{organizeNumber}</if> |
| | | <if test="productionBase != null and productionBase != ''"> and production_base = #{productionBase}</if> |
| | | <if test="classification != null and classification != ''"> and classification = #{classification}</if> |
| | | <if test="produceYear != null "> and produce_year = #{produceYear}</if> |
| | | <if test="produceMonth != null "> and produce_month = #{produceMonth}</if> |
| | | <if test="productionQuantity != null "> and production_quantity = #{productionQuantity}</if> |
| | | <if test="customer != null and customer != ''"> and customer = #{customer}</if> |
| | | <if test="singleWeldSeam != null "> and single_weld_seam = #{singleWeldSeam}</if> |
| | | <if test="totalWeldSeam != null "> and total_weld_seam = #{totalWeldSeam}</if> |
| | | <if test="params.beginThisFeedbackDay != null and params.beginThisFeedbackDay != '' and params.endThisFeedbackDay != null and params.endThisFeedbackDay != ''"> and this_feedback_day between #{params.beginThisFeedbackDay} and #{params.endThisFeedbackDay}</if> |
| | | <if test="params.beginMaterialsRequirementDay != null and params.beginMaterialsRequirementDay != '' and params.endMaterialsRequirementDay != null and params.endMaterialsRequirementDay != ''"> and materials_requirement_day between #{params.beginMaterialsRequirementDay} and #{params.endMaterialsRequirementDay}</if> |
| | | <if test="saleOrderNo != null and saleOrderNo != ''"> and sale_order_no = #{saleOrderNo}</if> |
| | | <if test="saleOrderLine != null "> and sale_order_line = #{saleOrderLine}</if> |
| | | <if test="mainWorkOrderNo != null and mainWorkOrderNo != ''"> and main_work_order_no = #{mainWorkOrderNo}</if> |
| | | <if test="superiorWorkOrderNo != null and superiorWorkOrderNo != ''"> and superior_work_order_no = #{superiorWorkOrderNo}</if> |
| | | <if test="workOrderNo != null and workOrderNo != ''"> and work_order_no = #{workOrderNo}</if> |
| | | <if test="plant != null and plant != ''"> and plant = #{plant}</if> |
| | | <if test="batchNumber != null and batchNumber != ''"> and batch_number = #{batchNumber}</if> |
| | | </where> |
| | | </select> |
| | | |
| | | <select id="selectApsWeldSeamTempById" parameterType="String" resultMap="ApsWeldSeamTempResult"> |
| | | <include refid="selectApsWeldSeamTempVo"/> |
| | | where id = #{id} |
| | | </select> |
| | | |
| | | <insert id="insertApsWeldSeamTemp" parameterType="ApsWeldSeamTemp"> |
| | | insert into aps_weld_seam_temp |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">id,</if> |
| | | <if test="workOrderType != null">work_order_type,</if> |
| | | <if test="materialCode != null">material_code,</if> |
| | | <if test="customerDrawingNumber != null">customer_drawing_number,</if> |
| | | <if test="organizeNumber != null">organize_number,</if> |
| | | <if test="productionBase != null">production_base,</if> |
| | | <if test="classification != null">classification,</if> |
| | | <if test="produceYear != null">produce_year,</if> |
| | | <if test="produceMonth != null">produce_month,</if> |
| | | <if test="productionQuantity != null">production_quantity,</if> |
| | | <if test="customer != null">customer,</if> |
| | | <if test="singleWeldSeam != null">single_weld_seam,</if> |
| | | <if test="totalWeldSeam != null">total_weld_seam,</if> |
| | | <if test="thisFeedbackDay != null">this_feedback_day,</if> |
| | | <if test="materialsRequirementDay != null">materials_requirement_day,</if> |
| | | <if test="saleOrderNo != null">sale_order_no,</if> |
| | | <if test="saleOrderLine != null">sale_order_line,</if> |
| | | <if test="mainWorkOrderNo != null">main_work_order_no,</if> |
| | | <if test="superiorWorkOrderNo != null">superior_work_order_no,</if> |
| | | <if test="workOrderNo != null">work_order_no,</if> |
| | | <if test="plant != null">plant,</if> |
| | | <if test="batchNumber != null">batch_number,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="id != null">#{id},</if> |
| | | <if test="workOrderType != null">#{workOrderType},</if> |
| | | <if test="materialCode != null">#{materialCode},</if> |
| | | <if test="customerDrawingNumber != null">#{customerDrawingNumber},</if> |
| | | <if test="organizeNumber != null">#{organizeNumber},</if> |
| | | <if test="productionBase != null">#{productionBase},</if> |
| | | <if test="classification != null">#{classification},</if> |
| | | <if test="produceYear != null">#{produceYear},</if> |
| | | <if test="produceMonth != null">#{produceMonth},</if> |
| | | <if test="productionQuantity != null">#{productionQuantity},</if> |
| | | <if test="customer != null">#{customer},</if> |
| | | <if test="singleWeldSeam != null">#{singleWeldSeam},</if> |
| | | <if test="totalWeldSeam != null">#{totalWeldSeam},</if> |
| | | <if test="thisFeedbackDay != null">#{thisFeedbackDay},</if> |
| | | <if test="materialsRequirementDay != null">#{materialsRequirementDay},</if> |
| | | <if test="saleOrderNo != null">#{saleOrderNo},</if> |
| | | <if test="saleOrderLine != null">#{saleOrderLine},</if> |
| | | <if test="mainWorkOrderNo != null">#{mainWorkOrderNo},</if> |
| | | <if test="superiorWorkOrderNo != null">#{superiorWorkOrderNo},</if> |
| | | <if test="workOrderNo != null">#{workOrderNo},</if> |
| | | <if test="plant != null">#{plant},</if> |
| | | <if test="batchNumber != null">#{batchNumber},</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateApsWeldSeamTemp" parameterType="ApsWeldSeamTemp"> |
| | | update aps_weld_seam_temp |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="workOrderType != null">work_order_type = #{workOrderType},</if> |
| | | <if test="materialCode != null">material_code = #{materialCode},</if> |
| | | <if test="customerDrawingNumber != null">customer_drawing_number = #{customerDrawingNumber},</if> |
| | | <if test="organizeNumber != null">organize_number = #{organizeNumber},</if> |
| | | <if test="productionBase != null">production_base = #{productionBase},</if> |
| | | <if test="classification != null">classification = #{classification},</if> |
| | | <if test="produceYear != null">produce_year = #{produceYear},</if> |
| | | <if test="produceMonth != null">produce_month = #{produceMonth},</if> |
| | | <if test="productionQuantity != null">production_quantity = #{productionQuantity},</if> |
| | | <if test="customer != null">customer = #{customer},</if> |
| | | <if test="singleWeldSeam != null">single_weld_seam = #{singleWeldSeam},</if> |
| | | <if test="totalWeldSeam != null">total_weld_seam = #{totalWeldSeam},</if> |
| | | <if test="thisFeedbackDay != null">this_feedback_day = #{thisFeedbackDay},</if> |
| | | <if test="materialsRequirementDay != null">materials_requirement_day = #{materialsRequirementDay},</if> |
| | | <if test="saleOrderNo != null">sale_order_no = #{saleOrderNo},</if> |
| | | <if test="saleOrderLine != null">sale_order_line = #{saleOrderLine},</if> |
| | | <if test="mainWorkOrderNo != null">main_work_order_no = #{mainWorkOrderNo},</if> |
| | | <if test="superiorWorkOrderNo != null">superior_work_order_no = #{superiorWorkOrderNo},</if> |
| | | <if test="workOrderNo != null">work_order_no = #{workOrderNo},</if> |
| | | <if test="plant != null">plant = #{plant},</if> |
| | | <if test="batchNumber != null">batch_number = #{batchNumber},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |
| | | |
| | | <delete id="deleteApsWeldSeamTempById" parameterType="String"> |
| | | delete from aps_weld_seam_temp where id = #{id} |
| | | </delete> |
| | | |
| | | <delete id="deleteApsWeldSeamTempByIds" parameterType="String"> |
| | | delete from aps_weld_seam_temp where id in |
| | | <foreach item="id" collection="array" open="(" separator="," close=")"> |
| | | #{id} |
| | | </foreach> |
| | | </delete> |
| | | </mapper> |
| | |
| | | discovery: |
| | | # æå¡æ³¨åå°å |
| | | server-addr: 192.168.50.160:8848 |
| | | metadata: |
| | | local: wwj |
| | | namespace: 8e9f8829-4286-4925-943a-a6c242767ac2 |
| | | config: |
| | | # é
ç½®ä¸å¿å°å |