SELECT tab.*, game.开始日期 starting_data , game.结束日期 ending_data, game.赛事名称 show_name, left(CONVERT(varchar(100), game.结束日期, 23),7) gradeMonth FROM tab_grade_ddz tab LEFT JOIN tab_games game ON tab.showsId = game.赛事编号 WHERE breedId = #{pedigreeNum} and left(CONVERT(varchar(100), game.结束日期, 23),7) = #{charTime} SELECT left(CONVERT(varchar(100), game.结束日期, 23),7) gradeMonth FROM tab_grade_ddz tab LEFT JOIN tab_games game ON tab.showsId = game.赛事编号 WHERE breedId = #{pedigreeNum} order by tab.id desc id, showsCode, showsId, serialNumber, CC, BOB, BOW, WB, BISS, rankings, integrals, userId, UserName_C, UserName_E, fciCode, dogSex, ageClass, breedId, breedIdOther, judges, showsPlace, editTime, del_tag, dogGroup, print_cc, formatCode CC_Remarks, operater, Remarks select , from tab_grade_ddz where id = #{id,jdbcType=INTEGER} delete from tab_grade_ddz where id = #{id,jdbcType=INTEGER} insert into tab_grade_ddz (id, showsCode, showsId, serialNumber, CC, BOB, BOW, WB, BISS, rankings, integrals, userId, UserName_C, UserName_E, fciCode, dogSex, ageClass, breedId, breedIdOther, judges, showsPlace, editTime, del_tag, dogGroup, print_cc, formatCode, CC_Remarks, operater, Remarks ) values (#{id,jdbcType=INTEGER}, #{showscode,jdbcType=CHAR}, #{showsid,jdbcType=VARCHAR}, #{serialnumber,jdbcType=CHAR}, #{cc,jdbcType=CHAR}, #{bob,jdbcType=CHAR}, #{bow,jdbcType=CHAR}, #{wb,jdbcType=VARCHAR}, #{biss,jdbcType=CHAR}, #{rankings,jdbcType=VARCHAR}, #{integrals,jdbcType=INTEGER}, #{userid,jdbcType=CHAR}, #{usernameC,jdbcType=VARCHAR}, #{usernameE,jdbcType=VARCHAR}, #{fcicode,jdbcType=CHAR}, #{dogsex,jdbcType=CHAR}, #{ageclass,jdbcType=INTEGER}, #{breedid,jdbcType=VARCHAR}, #{breedidother,jdbcType=VARCHAR}, #{judges,jdbcType=VARCHAR}, #{showsplace,jdbcType=CHAR}, #{edittime,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{doggroup,jdbcType=CHAR}, #{printCc,jdbcType=CHAR}, #{formatcode,jdbcType=CHAR}, #{ccRemarks,jdbcType=LONGVARCHAR}, #{operater,jdbcType=LONGVARCHAR}, #{remarks,jdbcType=LONGVARCHAR} ) insert into tab_grade_ddz id, showsCode, showsId, serialNumber, CC, BOB, BOW, WB, BISS, rankings, integrals, userId, UserName_C, UserName_E, fciCode, dogSex, ageClass, breedId, breedIdOther, judges, showsPlace, editTime, del_tag, dogGroup, print_cc, formatCode, CC_Remarks, operater, Remarks, #{id,jdbcType=INTEGER}, #{showscode,jdbcType=CHAR}, #{showsid,jdbcType=VARCHAR}, #{serialnumber,jdbcType=CHAR}, #{cc,jdbcType=CHAR}, #{bob,jdbcType=CHAR}, #{bow,jdbcType=CHAR}, #{wb,jdbcType=VARCHAR}, #{biss,jdbcType=CHAR}, #{rankings,jdbcType=VARCHAR}, #{integrals,jdbcType=INTEGER}, #{userid,jdbcType=CHAR}, #{usernameC,jdbcType=VARCHAR}, #{usernameE,jdbcType=VARCHAR}, #{fcicode,jdbcType=CHAR}, #{dogsex,jdbcType=CHAR}, #{ageclass,jdbcType=INTEGER}, #{breedid,jdbcType=VARCHAR}, #{breedidother,jdbcType=VARCHAR}, #{judges,jdbcType=VARCHAR}, #{showsplace,jdbcType=CHAR}, #{edittime,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{doggroup,jdbcType=CHAR}, #{printCc,jdbcType=CHAR}, #{formatcode,jdbcType=CHAR}, #{ccRemarks,jdbcType=LONGVARCHAR}, #{operater,jdbcType=LONGVARCHAR}, #{remarks,jdbcType=LONGVARCHAR}, update tab_grade_ddz showsCode = #{showscode,jdbcType=CHAR}, showsId = #{showsid,jdbcType=VARCHAR}, serialNumber = #{serialnumber,jdbcType=CHAR}, CC = #{cc,jdbcType=CHAR}, BOB = #{bob,jdbcType=CHAR}, BOW = #{bow,jdbcType=CHAR}, WB = #{wb,jdbcType=VARCHAR}, BISS = #{biss,jdbcType=CHAR}, rankings = #{rankings,jdbcType=VARCHAR}, integrals = #{integrals,jdbcType=INTEGER}, userId = #{userid,jdbcType=CHAR}, UserName_C = #{usernameC,jdbcType=VARCHAR}, UserName_E = #{usernameE,jdbcType=VARCHAR}, fciCode = #{fcicode,jdbcType=CHAR}, dogSex = #{dogsex,jdbcType=CHAR}, ageClass = #{ageclass,jdbcType=INTEGER}, breedId = #{breedid,jdbcType=VARCHAR}, breedIdOther = #{breedidother,jdbcType=VARCHAR}, judges = #{judges,jdbcType=VARCHAR}, showsPlace = #{showsplace,jdbcType=CHAR}, editTime = #{edittime,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, dogGroup = #{doggroup,jdbcType=CHAR}, print_cc = #{printCc,jdbcType=CHAR}, formatCode = #{formatcode,jdbcType=CHAR}, CC_Remarks = #{ccRemarks,jdbcType=LONGVARCHAR}, operater = #{operater,jdbcType=LONGVARCHAR}, Remarks = #{remarks,jdbcType=LONGVARCHAR}, where id = #{id,jdbcType=INTEGER} update tab_grade_ddz set showsCode = #{showscode,jdbcType=CHAR}, showsId = #{showsid,jdbcType=VARCHAR}, serialNumber = #{serialnumber,jdbcType=CHAR}, CC = #{cc,jdbcType=CHAR}, BOB = #{bob,jdbcType=CHAR}, BOW = #{bow,jdbcType=CHAR}, WB = #{wb,jdbcType=VARCHAR}, BISS = #{biss,jdbcType=CHAR}, rankings = #{rankings,jdbcType=VARCHAR}, integrals = #{integrals,jdbcType=INTEGER}, userId = #{userid,jdbcType=CHAR}, UserName_C = #{usernameC,jdbcType=VARCHAR}, UserName_E = #{usernameE,jdbcType=VARCHAR}, fciCode = #{fcicode,jdbcType=CHAR}, dogSex = #{dogsex,jdbcType=CHAR}, ageClass = #{ageclass,jdbcType=INTEGER}, breedId = #{breedid,jdbcType=VARCHAR}, breedIdOther = #{breedidother,jdbcType=VARCHAR}, judges = #{judges,jdbcType=VARCHAR}, showsPlace = #{showsplace,jdbcType=CHAR}, editTime = #{edittime,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, dogGroup = #{doggroup,jdbcType=CHAR}, print_cc = #{printCc,jdbcType=CHAR}, formatCode = #{formatcode,jdbcType=CHAR}, CC_Remarks = #{ccRemarks,jdbcType=LONGVARCHAR}, operater = #{operater,jdbcType=LONGVARCHAR}, Remarks = #{remarks,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=INTEGER} update tab_grade_ddz set showsCode = #{showscode,jdbcType=CHAR}, showsId = #{showsid,jdbcType=VARCHAR}, serialNumber = #{serialnumber,jdbcType=CHAR}, CC = #{cc,jdbcType=CHAR}, BOB = #{bob,jdbcType=CHAR}, BOW = #{bow,jdbcType=CHAR}, WB = #{wb,jdbcType=VARCHAR}, BISS = #{biss,jdbcType=CHAR}, rankings = #{rankings,jdbcType=VARCHAR}, integrals = #{integrals,jdbcType=INTEGER}, userId = #{userid,jdbcType=CHAR}, UserName_C = #{usernameC,jdbcType=VARCHAR}, UserName_E = #{usernameE,jdbcType=VARCHAR}, fciCode = #{fcicode,jdbcType=CHAR}, dogSex = #{dogsex,jdbcType=CHAR}, ageClass = #{ageclass,jdbcType=INTEGER}, breedId = #{breedid,jdbcType=VARCHAR}, breedIdOther = #{breedidother,jdbcType=VARCHAR}, judges = #{judges,jdbcType=VARCHAR}, showsPlace = #{showsplace,jdbcType=CHAR}, editTime = #{edittime,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, dogGroup = #{doggroup,jdbcType=CHAR}, print_cc = #{printCc,jdbcType=CHAR}, formatCode = #{formatcode,jdbcType=CHAR} where id = #{id,jdbcType=INTEGER}