id, entry_no, flow_no, dog_owner, dog_owner_e, user_no, show_num, identification, entry_fee, leave_cancel, show_leave, breed_name, breed_name_e, fci_code, breed_group, dog_name, gender, birth, age_group, cku_studbook_num, foreign_studbook_num, microchip_no, fstudbook_num, fdog_name, mstudbook_num, mdog_name, breeder, add_time, modify_date, del_tag, info_Confirm, info_Confirm_time, payout, payout_time, order_price, running_number, operate, operate_time, pay_ckuid, pay_Pid, serviceFee, serviceFeePrice, BBE, trainer_id, project_id, match_id, dog_id,sponsor_detil remark, opt_user, info_Confirm_why select , from cku_shows_baoming where id = #{id,jdbcType=VARCHAR} delete from cku_shows_baoming where id = #{id,jdbcType=VARCHAR} insert into cku_shows_baoming (id, entry_no, flow_no, dog_owner, dog_owner_e, user_no, show_num, identification, entry_fee, leave_cancel, show_leave, breed_name, breed_name_e, fci_code, breed_group, dog_name, gender, birth, age_group, cku_studbook_num, foreign_studbook_num, microchip_no, fstudbook_num, fdog_name, mstudbook_num, mdog_name, breeder, add_time, modify_date, del_tag, info_Confirm, info_Confirm_time, payout, payout_time, order_price, running_number, operate, operate_time, pay_ckuid, pay_Pid, serviceFee, serviceFeePrice, BBE, trainer_id, project_id, match_id, dog_id, remark, opt_user, info_Confirm_why,sponsor_detil) values (#{id,jdbcType=VARCHAR}, #{entryNo,jdbcType=VARCHAR}, #{flowNo,jdbcType=VARCHAR}, #{dogOwner,jdbcType=VARCHAR}, #{dogOwnerE,jdbcType=VARCHAR}, #{userNo,jdbcType=VARCHAR}, #{showNum,jdbcType=VARCHAR}, #{identification,jdbcType=VARCHAR}, #{entryFee,jdbcType=VARCHAR}, #{leaveCancel,jdbcType=VARCHAR}, #{showLeave,jdbcType=CHAR}, #{breedName,jdbcType=VARCHAR}, #{breedNameE,jdbcType=VARCHAR}, #{fciCode,jdbcType=VARCHAR}, #{breedGroup,jdbcType=VARCHAR}, #{dogName,jdbcType=VARCHAR}, #{gender,jdbcType=VARCHAR}, #{birth,jdbcType=TIMESTAMP}, #{ageGroup,jdbcType=VARCHAR}, #{ckuStudbookNum,jdbcType=VARCHAR}, #{foreignStudbookNum,jdbcType=VARCHAR}, #{microchipNo,jdbcType=VARCHAR}, #{fstudbookNum,jdbcType=VARCHAR}, #{fdogName,jdbcType=VARCHAR}, #{mstudbookNum,jdbcType=VARCHAR}, #{mdogName,jdbcType=VARCHAR}, #{breeder,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{modifyDate,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{infoConfirm,jdbcType=CHAR}, #{infoConfirmTime,jdbcType=TIMESTAMP}, #{payout,jdbcType=CHAR}, #{payoutTime,jdbcType=TIMESTAMP}, #{orderPrice,jdbcType=DECIMAL}, #{runningNumber,jdbcType=VARCHAR}, #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{payCkuid,jdbcType=VARCHAR}, #{payPid,jdbcType=VARCHAR}, #{servicefee,jdbcType=CHAR}, #{servicefeeprice,jdbcType=DECIMAL}, #{bbe,jdbcType=CHAR}, #{trainerid,jdbcType=VARCHAR}, #{projectId,jdbcType=INTEGER}, #{matchId,jdbcType=INTEGER}, #{dogId,jdbcType=INTEGER}, #{remark,jdbcType=LONGVARCHAR}, #{optUser,jdbcType=LONGVARCHAR}, #{infoConfirmWhy,jdbcType=LONGVARCHAR},#{sponsorDetil,jdbcType=VARCHAR}) insert into show_apply id, apply_code, running_number, dog_owner_name_cn, dog_owner_name_en, dog_owner_member_code, show_code, show_apply_appraisal, fee, refund_flag, absence_flag, dog_breed_name_cn, dog_breed_name_en, fci_code, dog_breed_group, dog_name, dog_gender, dog_birthday, age_group, pedigree_certified, other_certified, chip_code, fdog_pedigree_certified, fdog_name, mdog_pedigree_certified, mdog_name, breeder, create_date, update_date, del_flag, review_state, review_time, payment_state, payment_time, order_price, running_number, proccess_state, proccess_time, payment_member_code, payment_charging_item_id, phone_apply_flag, phone_apply_fee, bbe_flag, remarks, review_remarks, handler_member_code, main_show_id, organizer, dog_generation ,sticker_flag ,is_owner ,second_dog_owner ,second_owner_member #{id,jdbcType=VARCHAR}, #{entryNo,jdbcType=VARCHAR}, #{flowNo,jdbcType=VARCHAR}, #{dogOwner,jdbcType=VARCHAR}, #{dogOwnerE,jdbcType=VARCHAR}, #{userNo,jdbcType=VARCHAR}, #{showNum,jdbcType=VARCHAR}, #{identification,jdbcType=VARCHAR}, #{entryFee,jdbcType=VARCHAR}, #{leaveCancel,jdbcType=VARCHAR}, #{showLeave,jdbcType=CHAR}, #{breedName,jdbcType=VARCHAR}, #{breedNameE,jdbcType=VARCHAR}, #{fciCode,jdbcType=VARCHAR}, #{breedGroup,jdbcType=VARCHAR}, #{dogName,jdbcType=VARCHAR}, #{gender,jdbcType=VARCHAR}, #{birth,jdbcType=TIMESTAMP}, #{ageGroup,jdbcType=VARCHAR}, #{ckuStudbookNum,jdbcType=VARCHAR}, #{foreignStudbookNum,jdbcType=VARCHAR}, #{microchipNo,jdbcType=VARCHAR}, #{fstudbookNum,jdbcType=VARCHAR}, #{fdogName,jdbcType=VARCHAR}, #{mstudbookNum,jdbcType=VARCHAR}, #{mdogName,jdbcType=VARCHAR}, #{breeder,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{addTime,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{infoConfirm,jdbcType=CHAR}, #{infoConfirmTime,jdbcType=TIMESTAMP}, #{payout,jdbcType=CHAR}, #{payoutTime,jdbcType=TIMESTAMP}, #{orderPrice,jdbcType=DECIMAL}, #{runningNumber,jdbcType=VARCHAR}, #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{payCkuid,jdbcType=VARCHAR}, #{payPid,jdbcType=VARCHAR}, #{servicefee,jdbcType=CHAR}, #{servicefeeprice,jdbcType=DECIMAL}, #{bbe,jdbcType=CHAR}, #{remark,jdbcType=LONGVARCHAR}, #{infoConfirmWhy,jdbcType=LONGVARCHAR}, #{sponsorDetil,jdbcType=VARCHAR}, #{mainShowId}, #{organizer}, #{dogGenertions}, #{stickerFlag}, #{isOwner}, #{secondDogOwner}, #{secondOwnerMember}, update cku_shows_baoming entry_no = #{entryNo,jdbcType=VARCHAR}, flow_no = #{flowNo,jdbcType=VARCHAR}, dog_owner = #{dogOwner,jdbcType=VARCHAR}, dog_owner_e = #{dogOwnerE,jdbcType=VARCHAR}, user_no = #{userNo,jdbcType=VARCHAR}, show_num = #{showNum,jdbcType=VARCHAR}, identification = #{identification,jdbcType=VARCHAR}, entry_fee = #{entryFee,jdbcType=VARCHAR}, leave_cancel = #{leaveCancel,jdbcType=VARCHAR}, show_leave = #{showLeave,jdbcType=CHAR}, breed_name = #{breedName,jdbcType=VARCHAR}, breed_name_e = #{breedNameE,jdbcType=VARCHAR}, fci_code = #{fciCode,jdbcType=VARCHAR}, breed_group = #{breedGroup,jdbcType=VARCHAR}, dog_name = #{dogName,jdbcType=VARCHAR}, gender = #{gender,jdbcType=VARCHAR}, birth = #{birth,jdbcType=TIMESTAMP}, age_group = #{ageGroup,jdbcType=VARCHAR}, cku_studbook_num = #{ckuStudbookNum,jdbcType=VARCHAR}, foreign_studbook_num = #{foreignStudbookNum,jdbcType=VARCHAR}, microchip_no = #{microchipNo,jdbcType=VARCHAR}, fstudbook_num = #{fstudbookNum,jdbcType=VARCHAR}, fdog_name = #{fdogName,jdbcType=VARCHAR}, mstudbook_num = #{mstudbookNum,jdbcType=VARCHAR}, mdog_name = #{mdogName,jdbcType=VARCHAR}, breeder = #{breeder,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, modify_date = #{modifyDate,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, info_Confirm = #{infoConfirm,jdbcType=CHAR}, info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP}, payout = #{payout,jdbcType=CHAR}, payout_time = #{payoutTime,jdbcType=TIMESTAMP}, order_price = #{orderPrice,jdbcType=DECIMAL}, running_number = #{runningNumber,jdbcType=VARCHAR}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, pay_ckuid = #{payCkuid,jdbcType=VARCHAR}, pay_Pid = #{payPid,jdbcType=VARCHAR}, serviceFee = #{servicefee,jdbcType=CHAR}, serviceFeePrice = #{servicefeeprice,jdbcType=DECIMAL}, BBE = #{bbe,jdbcType=CHAR}, trainer_id = #{trainerId,jdbcType=INTEGER}, project_id = #{projectId,jdbcType=INTEGER}, match_id = #{matchId,jdbcType=INTEGER}, dog_id = #{dogId,jdbcType=INTEGER}, remark = #{remark,jdbcType=LONGVARCHAR}, opt_user = #{optUser,jdbcType=LONGVARCHAR}, info_Confirm_why = #{infoConfirmWhy,jdbcType=LONGVARCHAR}, sponsor_detil=#{sponsorDetil,jdbcType=VARCHAR}, where id = #{id,jdbcType=VARCHAR} update show_apply set payment_state = '2' where running_number = #{orderId} update cku_shows_baoming set entry_no = #{entryNo,jdbcType=VARCHAR}, flow_no = #{flowNo,jdbcType=VARCHAR}, dog_owner = #{dogOwner,jdbcType=VARCHAR}, dog_owner_e = #{dogOwnerE,jdbcType=VARCHAR}, user_no = #{userNo,jdbcType=VARCHAR}, show_num = #{showNum,jdbcType=VARCHAR}, identification = #{identification,jdbcType=VARCHAR}, entry_fee = #{entryFee,jdbcType=VARCHAR}, leave_cancel = #{leaveCancel,jdbcType=VARCHAR}, show_leave = #{showLeave,jdbcType=CHAR}, breed_name = #{breedName,jdbcType=VARCHAR}, breed_name_e = #{breedNameE,jdbcType=VARCHAR}, fci_code = #{fciCode,jdbcType=VARCHAR}, breed_group = #{breedGroup,jdbcType=VARCHAR}, dog_name = #{dogName,jdbcType=VARCHAR}, gender = #{gender,jdbcType=VARCHAR}, birth = #{birth,jdbcType=TIMESTAMP}, age_group = #{ageGroup,jdbcType=VARCHAR}, cku_studbook_num = #{ckuStudbookNum,jdbcType=VARCHAR}, foreign_studbook_num = #{foreignStudbookNum,jdbcType=VARCHAR}, microchip_no = #{microchipNo,jdbcType=VARCHAR}, fstudbook_num = #{fstudbookNum,jdbcType=VARCHAR}, fdog_name = #{fdogName,jdbcType=VARCHAR}, mstudbook_num = #{mstudbookNum,jdbcType=VARCHAR}, mdog_name = #{mdogName,jdbcType=VARCHAR}, breeder = #{breeder,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, modify_date = #{modifyDate,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, info_Confirm = #{infoConfirm,jdbcType=CHAR}, info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP}, payout = #{payout,jdbcType=CHAR}, payout_time = #{payoutTime,jdbcType=TIMESTAMP}, order_price = #{orderPrice,jdbcType=DECIMAL}, running_number = #{runningNumber,jdbcType=VARCHAR}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, pay_ckuid = #{payCkuid,jdbcType=VARCHAR}, pay_Pid = #{payPid,jdbcType=VARCHAR}, serviceFee = #{servicefee,jdbcType=CHAR}, serviceFeePrice = #{servicefeeprice,jdbcType=DECIMAL}, BBE = #{bbe,jdbcType=CHAR}, trainer_id = #{trainerId,jdbcType=INTEGER}, project_id = #{projectId,jdbcType=INTEGER}, match_id = #{matchId,jdbcType=INTEGER}, dog_id = #{dogId,jdbcType=INTEGER}, remark = #{remark,jdbcType=LONGVARCHAR}, opt_user = #{optUser,jdbcType=LONGVARCHAR}, info_Confirm_why = #{infoConfirmWhy,jdbcType=LONGVARCHAR}, sponsor_detil=#{sponsorDetil,jdbcType=VARCHAR} where id = #{id,jdbcType=VARCHAR} update cku_shows_baoming set entry_no = #{entryNo,jdbcType=VARCHAR}, flow_no = #{flowNo,jdbcType=VARCHAR}, dog_owner = #{dogOwner,jdbcType=VARCHAR}, dog_owner_e = #{dogOwnerE,jdbcType=VARCHAR}, user_no = #{userNo,jdbcType=VARCHAR}, show_num = #{showNum,jdbcType=VARCHAR}, identification = #{identification,jdbcType=VARCHAR}, entry_fee = #{entryFee,jdbcType=VARCHAR}, leave_cancel = #{leaveCancel,jdbcType=VARCHAR}, show_leave = #{showLeave,jdbcType=CHAR}, breed_name = #{breedName,jdbcType=VARCHAR}, breed_name_e = #{breedNameE,jdbcType=VARCHAR}, fci_code = #{fciCode,jdbcType=VARCHAR}, breed_group = #{breedGroup,jdbcType=VARCHAR}, dog_name = #{dogName,jdbcType=VARCHAR}, gender = #{gender,jdbcType=VARCHAR}, birth = #{birth,jdbcType=TIMESTAMP}, age_group = #{ageGroup,jdbcType=VARCHAR}, cku_studbook_num = #{ckuStudbookNum,jdbcType=VARCHAR}, foreign_studbook_num = #{foreignStudbookNum,jdbcType=VARCHAR}, microchip_no = #{microchipNo,jdbcType=VARCHAR}, fstudbook_num = #{fstudbookNum,jdbcType=VARCHAR}, fdog_name = #{fdogName,jdbcType=VARCHAR}, mstudbook_num = #{mstudbookNum,jdbcType=VARCHAR}, mdog_name = #{mdogName,jdbcType=VARCHAR}, breeder = #{breeder,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, modify_date = #{modifyDate,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, info_Confirm = #{infoConfirm,jdbcType=CHAR}, info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP}, payout = #{payout,jdbcType=CHAR}, payout_time = #{payoutTime,jdbcType=TIMESTAMP}, order_price = #{orderPrice,jdbcType=DECIMAL}, running_number = #{runningNumber,jdbcType=VARCHAR}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, pay_ckuid = #{payCkuid,jdbcType=VARCHAR}, pay_Pid = #{payPid,jdbcType=VARCHAR}, serviceFee = #{servicefee,jdbcType=CHAR}, serviceFeePrice = #{servicefeeprice,jdbcType=DECIMAL}, BBE = #{bbe,jdbcType=CHAR}, trainer_id = #{trainerId,jdbcType=INTEGER}, project_id = #{projectId,jdbcType=INTEGER}, match_id = #{matchId,jdbcType=INTEGER}, dog_id = #{dogId,jdbcType=INTEGER}, sponsor_detil=#{sponsorDetil,jdbcType=VARCHAR} where id = #{id,jdbcType=VARCHAR} select show_code show_num,pedigree_certified cku_studbook_num,chip_code microchip_no, (case age_group when '1' THEN '特幼公犬组' when '2' THEN '特幼母犬组' when '3' THEN '幼小公犬组' when '4' THEN '幼小母犬组' when '5' THEN '青年公犬组' when '6' THEN '青年母犬组' when '7' THEN '中间公犬组' when '8' THEN '中间母犬组' when '9' THEN '公开公犬组' when '10' THEN '公开母犬组' when '13' THEN '冠军公犬组' when '14' THEN '冠军母犬组' when '15' THEN '老年公犬组' when '16' THEN '老年母犬组' END )AS ageGroup, (case payment_state when '1' THEN '未缴费' when '2' THEN '已缴费' when '7' THEN '业务核对中' when '8' THEN '已提交' when '9' THEN '提交中' END )AS payout from show_apply where running_number=#{runningNumber} and del_flag = '0' and pedigree_certified = #{pedigreeCertified} update show_apply set del_flag = '1' where running_number = #{orderId}