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); }