//获取医院信息
public void getHospitalInfo()
{
sqlHelper mysql = new sqlHelper();
SqlConnection conn = mysql.getcon();
SqlCommand comm = conn.CreateCommand();
comm.CommandText = "SELECT name, ADDRESS FROM tb_hospital WHERE signUpCode='" + userHelper.signUpCode + "';";
conn.Open();
SqlDataReader dr = comm.ExecuteReader();
if (dr.Read())
{
userHelper.hospitalName = dr["Name"].ToString();
userHelper.hospitalAddress = dr["ADDRESS"].ToString();
}
dr.Close();
conn.Close();
}
