/// <summary>
/// 将选择的Excel数据表查询后封装成对象集合
/// </summary>
/// <param name="path">excel路径</param>
/// <returns></returns>
public List <StudentExt> GetStudentByExcel(string path)
{
List <StudentExt> studentList = new List <StudentExt>();
string sql = "select * from [Student$]";
try
{
DataSet ds = OledbHelper.DataSet(sql, path);
DataTable dt = ds.Tables[0];
foreach (DataRow item in dt.Rows)
{
studentList.Add(new StudentExt
{
StudentName = item["姓名"].ToString(),
Gender = item["性别"].ToString(),
Birthday = Convert.ToDateTime(item["出生日期"]),
StudentIdNo = item["身份证号"].ToString(),
PhoneNumber = item["电话号码"].ToString(),
CardNo = item["考勤卡号"].ToString(),
Age = DateTime.Now.Year - Convert.ToDateTime(item["出生日期"].ToString()).Year,
StudentAddress = item["家庭住址"].ToString(),
ClassId = Convert.ToInt32(item["班级编号"]),
});
}
return(studentList);
}
catch (Exception ex)
{
throw ex;
}
}
