public static diagnose Diagnose_data_result(int diagnose_id)
{
string query = string.Format("select Diagnose_name,Diagnose_group from Diagnose where Diagnose_ID = {0}", diagnose_id);
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string Diagnose_name = reader.GetString(0);
int group_id = reader.GetInt32(1);
diagnose dia = new diagnose(Diagnose_name, group_id);
return(dia);
}
}
finally
{
conn.Close();
}
return(null);
}
public static diagnose Diagnose_data_group_id(int diagnose_id)
{
string query = string.Format("select Name_diagnose from Diagnose_group where Diagnose_group = {0}", diagnose_id);
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string Group_Diagnose_name = reader.GetString(0);
diagnose dia = new diagnose(Group_Diagnose_name);
return(dia);
}
}
finally
{
conn.Close();
}
return(null);
}
