UPDATE dbo.dog_Appraise set dog_birthday = "2010-09-20" where dog_birthday = "2010年9月20日";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-2-1" where dog_birthday = "2013-2";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-1-1" where dog_birthday = "2011-1";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-02-1" where dog_birthday = "2011-02";
UPDATE dbo.dog_Appraise set dog_birthday = "2010-1-1" where dog_birthday = "2010-1";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-12-1" where dog_birthday = "2013-12";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-02-1" where dog_birthday = "2012-2";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-02-1" where dog_birthday = "2012-02";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-04-1" where dog_birthday = "2012-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-01-1" where dog_birthday = "2012";
UPDATE dbo.dog_Appraise set dog_birthday = "2010-12-01" where dog_birthday = "2010-12";
UPDATE dbo.dog_Appraise set dog_birthday = "2010-01-01" where dog_birthday = "2012-1";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-05-01" where dog_birthday = "2011-05";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-1-01" where dog_birthday = "2013-1";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-03-01" where dog_birthday = "2012-03";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-03-01" where dog_birthday = "2011-03";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-01-01" where dog_birthday = "2012-01";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-09-01" where dog_birthday = "2012-09";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-08-01" where dog_birthday = "2012-08";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-07-01" where dog_birthday = "2012-07";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-06-01" where dog_birthday = "2012-06";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-05-01" where dog_birthday = "2012-05";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-04-01" where dog_birthday = "2012-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-12-01" where dog_birthday = "2012-12";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-07-01" where dog_birthday = "2013-07";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-04-01" where dog_birthday = "2013-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-02-28" where dog_birthday = "2012-02-30";
UPDATE dbo.dog_Appraise set dog_birthday = "2011-04-01" where dog_birthday = "2011-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2013-10-01" where dog_birthday = "2013-10";

UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-01" where dog_birthday = "2014-01";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-02" where dog_birthday = "2014-02";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-03" where dog_birthday = "2014-03";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-04" where dog_birthday = "2014-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-05" where dog_birthday = "2014-05";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-06" where dog_birthday = "2014-06";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-07" where dog_birthday = "2014-07";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-08" where dog_birthday = "2014-08";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-09" where dog_birthday = "2014-09";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-10" where dog_birthday = "2014-10";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-11" where dog_birthday = "2014-11";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-12" where dog_birthday = "2014-12";

UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-01" where dog_birthday = "2014-01";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-02" where dog_birthday = "2014-02";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-03" where dog_birthday = "2014-03";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-04" where dog_birthday = "2014-04";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-05" where dog_birthday = "2014-05";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-06" where dog_birthday = "2014-06";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-07" where dog_birthday = "2014-07";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-08" where dog_birthday = "2014-08";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-09" where dog_birthday = "2014-09";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-10" where dog_birthday = "2014-10";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-11" where dog_birthday = "2014-11";
UPDATE dbo.dog_Appraise set dog_birthday = "2014-01-12" where dog_birthday = "2014-12";
UPDATE dbo.dog_Appraise set dog_birthday = "2012-05-01" where dog_birthday = "2012-05-";
UPDATE dbo.dog_Appraise set dog_birthday = "2015-06-01" where dog_birthday = "2015-06";
INSERT INTO dog_appraisal (
	id,
	dog_id,
	dog_owner_code,
	dog_owner_name,
	payment_member_code,
	identify_type,
	identify_site,
	dog_breed,
	dog_name,
	dog_gender,
	dog_fur_color,
	birthday,
	operator,
	price,
	dog_appraisal.dog_chip,
	dog_dna_image,
	pedigree_certified,
	hospital_id,
	identify_code,
	review_state,
	review_time,
	review_remarks,
	running_number,
	payment_state,
	payment_time,
	process_time,
	process_state,
	create_by,
	create_date,
	update_by,
	update_date,
	remarks,
	del_flag
) SELECT
	id,
	dogid,
	pay_ckuid,
	'',
	pay_ckuid,
	Appraise_type,
	'',
	dog_class,
	dog_name,
	dog_sex,
	dog_color,
	case when dog_birthday = '' then null else dog_birthday end dog_birthday,
	operater,
	order_price,
	Appraise_sfnum,
	Appraise_pic,
	Appraise_zsnum,
	'',
	Appraise_sfnum,
	info_Confirm,
	info_Confirm_time,
	info_Confirm_why,
	running_number,
	payout,
	payout_time,
	operate_time,
	operate,
	1 create_by,
	add_time,
	1 update_by,
	edit_time,
	'' remarks,
	0 del_flag
FROM
	dbo.dog_Appraise;

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

update dog_appraisal set identify_type = 0 where identify_type = '审查员鉴定';
update dog_appraisal set identify_type = 1 where identify_type = 'DNA';

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

--更新犬只鉴定表中犬主人姓名缺失的问题
update dog_appraisal a,sys_member m set a.dog_owner_name = m.name where (a.dog_owner_name is null or a.dog_owner_name = '') and a.dog_owner_code=m.member_code;