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