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=INTEGER} delete from cku_shows_baoming where id = #{id,jdbcType=INTEGER} 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=INTEGER}, #{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=INTEGER}, #{servicefee,jdbcType=CHAR}, #{servicefeeprice,jdbcType=DECIMAL}, #{bbe,jdbcType=CHAR}, #{trainerId,jdbcType=INTEGER}, #{projectId,jdbcType=INTEGER}, #{matchId,jdbcType=INTEGER}, #{dogId,jdbcType=INTEGER}, #{remark,jdbcType=LONGVARCHAR}, #{optUser,jdbcType=LONGVARCHAR}, #{infoConfirmWhy,jdbcType=LONGVARCHAR},#{sponsorDetil,jdbcType=VARCHAR}) insert into cku_shows_baoming id, 报名序号, 流水账号, 犬主人, 犬主英文名, 会员号, 赛事编号, 鉴定, 报名费, 请假及取消, 赛场请假, 犬种中文名, 犬种英文名, FCI代码, 犬种组, 犬名, 性别, 出生日期, 年龄组别, CKU血统证书号, 国外血统证书号, 芯片号, 父犬血统证书号, 父犬名, 母犬血统证书号, 母犬名, 繁殖人, 添加日期, 修改日期, del_tag, info_Confirm, info_Confirm_time, payout, payout_time, order_price, running_number, operate, operate_time, pay_ckuid, pay_Pid, serviceFee, serviceFeePrice, BBE, 备注, 操作人员, info_Confirm_why, sponsor_detil #{id,jdbcType=INTEGER}, #{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=INTEGER}, #{servicefee,jdbcType=CHAR}, #{servicefeeprice,jdbcType=DECIMAL}, #{bbe,jdbcType=CHAR}, #{remark,jdbcType=LONGVARCHAR}, #{optUser,jdbcType=LONGVARCHAR}, #{infoConfirmWhy,jdbcType=LONGVARCHAR}, #{sponsorDetil,jdbcType=VARCHAR}, 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=INTEGER}, 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=INTEGER} update cku_shows_baoming set payout = '1' 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=INTEGER}, 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=INTEGER} 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=INTEGER}, 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=INTEGER} select 赛事编号 show_num,CKU血统证书号 cku_studbook_num,芯片号 microchip_no, (case 年龄组别 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 payout when '0' THEN '未缴费' when '1' THEN '已缴费' when '7' THEN '业务核对中' when '8' THEN '已提交' when '9' THEN '提交中' END )AS payout from cku_shows_baoming where running_number=#{runningNumber} delete from cku_shows_baoming where running_number = #{orderId}