//加载活动医生信息
private void LoadActiveDoctor()
{
DataTable dtDoctorActive = _sqHelper.ExcuteSqlite("select DoctorName,DoctorDept,ElectronicSignature from tb_patientInfo inner join tb_doctor on DoctorID=tb_doctor.ID where PatientID='" + _patientId + "'");
if (null != dtDoctorActive && dtDoctorActive.Rows.Count > 0)
{
lbDoctorName.Text = dtDoctorActive.Rows[0]["DoctorName"].ToString();
lbDoctorDept.Text = dtDoctorActive.Rows[0]["DoctorDept"].ToString();
if (DBNull.Value != dtDoctorActive.Rows[0]["ElectronicSignature"])
{
_electronicSignature = _sqHelper.GetImg((byte[])dtDoctorActive.Rows[0]["ElectronicSignature"]);
}
else
{
_electronicSignature = null;
}
}
}