/// <summary>
/// 获得数据列表
/// </summary>
public List <LearnSite.Model.StudentsExcel> DataTableToList(DataTable dt)
{
List <LearnSite.Model.StudentsExcel> modelList = new List <LearnSite.Model.StudentsExcel>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LearnSite.Model.StudentsExcel model;
for (int n = 0; n < rowsCount; n++)
{
model = new LearnSite.Model.StudentsExcel();
if (dt.Rows[n]["Sid"].ToString() != "")
{
model.Sid = int.Parse(dt.Rows[n]["Sid"].ToString());
}
model.Snum = dt.Rows[n]["Snum"].ToString();
if (dt.Rows[n]["Syear"].ToString() != "")
{
model.Syear = int.Parse(dt.Rows[n]["Syear"].ToString());
}
if (dt.Rows[n]["Sgrade"].ToString() != "")
{
model.Sgrade = int.Parse(dt.Rows[n]["Sgrade"].ToString());
}
if (dt.Rows[n]["Sclass"].ToString() != "")
{
model.Sclass = int.Parse(dt.Rows[n]["Sclass"].ToString());
}
model.Sname = dt.Rows[n]["Sname"].ToString();
model.Spwd = dt.Rows[n]["Spwd"].ToString();
model.Sex = dt.Rows[n]["Sex"].ToString();
model.Saddress = dt.Rows[n]["Saddress"].ToString();
model.Sphone = dt.Rows[n]["Sphone"].ToString();
model.Sparents = dt.Rows[n]["Sparents"].ToString();
model.Sheadtheacher = dt.Rows[n]["Sheadtheacher"].ToString();
if (dt.Rows[n]["Sscore"].ToString() != "")
{
model.Sscore = int.Parse(dt.Rows[n]["Sscore"].ToString());
}
if (dt.Rows[n]["Squiz"].ToString() != "")
{
model.Squiz = int.Parse(dt.Rows[n]["Squiz"].ToString());
}
if (dt.Rows[n]["Sattitude"].ToString() != "")
{
model.Sattitude = int.Parse(dt.Rows[n]["Sattitude"].ToString());
}
model.Sape = dt.Rows[n]["Sape"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// ��������б�
/// </summary>
public List<LearnSite.Model.StudentsExcel> DataTableToList(DataTable dt)
{
List<LearnSite.Model.StudentsExcel> modelList = new List<LearnSite.Model.StudentsExcel>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LearnSite.Model.StudentsExcel model;
for (int n = 0; n < rowsCount; n++)
{
model = new LearnSite.Model.StudentsExcel();
if(dt.Rows[n]["Sid"].ToString()!="")
{
model.Sid=int.Parse(dt.Rows[n]["Sid"].ToString());
}
model.Snum=dt.Rows[n]["Snum"].ToString();
if(dt.Rows[n]["Syear"].ToString()!="")
{
model.Syear=int.Parse(dt.Rows[n]["Syear"].ToString());
}
if(dt.Rows[n]["Sgrade"].ToString()!="")
{
model.Sgrade=int.Parse(dt.Rows[n]["Sgrade"].ToString());
}
if(dt.Rows[n]["Sclass"].ToString()!="")
{
model.Sclass=int.Parse(dt.Rows[n]["Sclass"].ToString());
}
model.Sname=dt.Rows[n]["Sname"].ToString();
model.Spwd=dt.Rows[n]["Spwd"].ToString();
model.Sex=dt.Rows[n]["Sex"].ToString();
model.Saddress=dt.Rows[n]["Saddress"].ToString();
model.Sphone=dt.Rows[n]["Sphone"].ToString();
model.Sparents=dt.Rows[n]["Sparents"].ToString();
model.Sheadtheacher=dt.Rows[n]["Sheadtheacher"].ToString();
if(dt.Rows[n]["Sscore"].ToString()!="")
{
model.Sscore=int.Parse(dt.Rows[n]["Sscore"].ToString());
}
if (dt.Rows[n]["Squiz"].ToString() != "")
{
model.Squiz = int.Parse(dt.Rows[n]["Squiz"].ToString());
}
if(dt.Rows[n]["Sattitude"].ToString()!="")
{
model.Sattitude=int.Parse(dt.Rows[n]["Sattitude"].ToString());
}
model.Sape=dt.Rows[n]["Sape"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(LearnSite.Model.StudentsExcel model)
{
dal.Update(model);
}
/// <summary>
/// 导入一条数据,model中无Sscore,Sattitude,Sape
/// </summary>
public int AddFromExcelDs(LearnSite.Model.StudentsExcel model)
{
return(dal.AddFromExcelDs(model));
}
