/// <summary> /// 通过身份证查询学员信息 /// </summary> /// <param name="sPidNo"></param> public void SearchTraineeByPidNo() { m_trainMangeDataSet.TraineeDataTable.Clear(); DBAccessHelper.GetTraStudInfoByPidNo(Trainee.m_sPidNo, m_trainMangeDataSet); if (m_trainMangeDataSet.TraineeDataTable.Rows.Count > 0) { DataRow dataRow = m_trainMangeDataSet.TraineeDataTable.Rows[0]; Trainee.m_sName = dataRow["TRAINE_NAME"].ToString(); if (dataRow["PHOTO"].ToString() != "" && dataRow["PHOTO"] != null) { Trainee.m_sPhoto = (byte[])dataRow["PHOTO"]; } else { Trainee.m_sPhoto = null; } Trainee.m_sSex = dataRow["SEX"].ToString(); Trainee.m_sBirthDate = Convert.ToDateTime(dataRow["BIRTH_DT"].ToString()); Trainee.m_sFingerprint = dataRow["FINGERPRINT1"].ToString(); Trainee.m_sDrvSchoolId = Convert.ToInt32(dataRow["DRIVING_SCHOOL_ID"].ToString()); Trainee.m_sPhoneNo = dataRow["PHONE_NO"].ToString(); Trainee.m_sRegDate = dataRow["FILLIN_TIME"].ToString(); Trainee.m_sTrainerNo = dataRow["TRAINER_ID"].ToString(); Trainee.m_sAutoType = dataRow["LICENSE_TYPE_CD"].ToString(); Trainee.m_sTrainingMode = dataRow["TRAINING_MODE"].ToString(); Trainee.m_nBalance = Convert.ToDouble(dataRow["BALANCE"].ToString()); Trainee.m_sHomeAddress = dataRow["HOMEADDRESS"].ToString(); } }
/// <summary> /// 获取指定学员信息 /// </summary> public void getTraStudinfo(string sPidNo) { try { TrainMangeDataSet.TraineeDataTable.Clear(); DBAccessHelper.GetTraStudInfoByPidNo(sPidNo, TrainMangeDataSet); } catch (Exception e) { System.Windows.MessageBox.Show("获取学员信息出错,错误内容:" + e.Message.ToString()); } }