JSONObject jsonObject = new JSONObject();
            //獲取車間編號
            String workCenter = workCenterNo.substring(0,2);
            //獲取時間編號
            SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
            String dateNo = sdf.format(new Date()); // 格式化日期 date: 20230112
            //初始化隔離編號
            String markNo1 = String.join("",workCenter,dateNo,"001");
            //模糊查找用
            String workDate = String.join("",workCenter,dateNo);
            //模糊查詢隔離編號
            String markSQL = "SELECT MARK_NO  FROM BP_MARKING WHERE MARK_NO  LIKE ? order by CREATE_DATE DESC";
            List<Map<String, Object>> maps = this.getJdbcTemplate().queryForList(markSQL,workDate+"%");
            //判斷模糊查找的隔離編號是否存在
            if (maps.size()>0){
                Map<String, Object> m=maps.get(0);
                String mark1=m.get("MARK_NO").toString();
                //取出mark1的后面三位數(shù)
                String str1 = mark1.substring(mark1.length()-3);
                int number1 = Integer.valueOf(str1).intValue();
                if (number1>999)throw new Exception("流水號超過規(guī)定！");
                int number2 = number1+1;
                //實例化format，格式為“000”
                DecimalFormat formatCount = new DecimalFormat("000");
                //一般都是將累加的數(shù)字當做一些單號的一部分，format要求string
                String str2 = formatCount.format(number2);
                //再用number2拼接workDate
                String markNo2 =String.join("",workDate,str2);
                jsonObject.put("markNo",markNo2);
                array.add(jsonObject);
            }else if (maps.size()==0){
                //如果maps為零，取markNo1
                jsonObject.put("markNo",markNo1);
                array.add(jsonObject);
            }
            return array;