INSERT INTO dog_birth_certificate (
	id,
	birth_cer_reg_code,
	pedigree_certified,
	dog_owenr,
	member_code,
	second_dog_owner,
	second_owner_member_code,
	breeder_member_code,
	breeder,
	temp_member_code,
	temp_user_name,
	dog_en_name,
	dog_gender,
	dog_breed,
	dog_birthday,
	same_batch_num,
	identification_flag,
	color_flag,
	dna,
	fdog_pedigree_certified,
	mdog_pedigree_certified,
	fmdog_breed_certified_code,
	operator,
	price,
	deduction,
	add_user,
	urgent,
	print_type,
	chip_inject_date,
	sn_code,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state
) SELECT
	id,
	出生证明登记编号,
	血统证书号,
	犬主人,
	会员号,
	第二犬主,
	第二犬主会员号,
	繁殖人会员号,
	繁殖人,
	tempUserID,
	tempUserName,
	英文姓名,
	性别,
	种类,
	case when 出生日期 = '' then null else 出生日期 end 出生日期,
	同胎犬数,
	身份识别标志,
	颜色及标志,
	DNA,
	父犬血统证号,
	母犬血统证号,
	父母犬配犬证明号,
	操作人员,
	order_price,
	dikou,
	insert_user,
	cku_jiaji,
	print_type,
	chipRegDate,
	snCode,
	1 create_by,
	添加日期,
	1 update_by,
	修改日期,
	'' remarks,
	del_tag,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate
FROM
	dbo.dog_BirthCertificate;


update dog_birth_certificate set dog_gender = 1 where dog_gender = '公';
update dog_birth_certificate set dog_gender = 2 where dog_gender = '母';

update dog_birth_certificate set urgent = 0 where urgent = '否';
update dog_birth_certificate set urgent = 1 where urgent = '是';

update dog_birth_certificate set payment_state = 2 where payment_state = 1;
update dog_birth_certificate set payment_state = 1 where payment_state = 0;