我有这个遗留代码:privatevoidconecta(){if(conexao.State==ConnectionState.Closed)conexao.Open();}publicListget_dados_historico_verificacao_email_WEB(stringemail){Listhistoricos=newList();conecta();sql=@"SELECT*FROMhistorico_verificacao_emailWHEREnm_email='"+email+@"'ORDERBYdt_verificacao_emailDESC,hr_veri

我有这个遗留代码:privatevoidconecta(){if(conexao.State==ConnectionState.Closed)conexao.Open();}publicListget_dados_historico_verificacao_email_WEB(stringemail){Listhistoricos=newList();conecta();sql=@"SELECT*FROMhistorico_verificacao_emailWHEREnm_email='"+email+@"'ORDERBYdt_verificacao_emailDESC,hr_veri