public List <DetailsSubject> DetailsSubject(BaoKao baoKao)
{
string str = "select name,grade,ApplyTime,Score,Estate,sid from baokao b,Students s where b.Sid=s.id and b.eid=@eid";
SqlParameter[] pars =
{
new SqlParameter("@eid", SqlDbType.Int)
};
pars[0].Value = baoKao.Eid;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
List <DetailsSubject> list = new List <DetailsSubject>();//
if (da.Rows.Count > 0)
{
DetailsSubject detailsSubject = null;
foreach (DataRow datarow in da.Rows)
{
detailsSubject = new DetailsSubject();
LoadExamSubject1(datarow, detailsSubject);
list.Add(detailsSubject);
}
}
return(list);
}
public void LoadExamSubject1(DataRow rows, DetailsSubject detailsSubject)
{
detailsSubject.name = rows["name"] != null ? rows["name"].ToString().Trim() : string.Empty;
//detailsSubject.name = rows["Score"].ToString();
detailsSubject.ApplyTime = Convert.ToDateTime(rows["ApplyTime"]);
detailsSubject.grade = rows["grade"] != null ? rows["grade"].ToString() : string.Empty;
// detailsSubject.Score = int.Parse(rows["Score"].ToString()) is DBNull ? -1 : Convert.ToInt32(rows["Score"]);// Convert.ToInt32(rows["Score"])
//string date = rows["Score"] is DBNull ? "-1" : rows["Score"].ToString;//rows["Score"].ToString()
detailsSubject.Score = Convert.ToInt32(rows["Score"] is DBNull ? "-1" : rows["Score"].ToString());
detailsSubject.Estate = Convert.ToInt32(rows["Estate"] is DBNull ? "-1" : rows["Estate"].ToString());; //Convert.ToInt32(rows["Estate"])
detailsSubject.sid = rows["sid"] != null ? rows["sid"].ToString() : string.Empty;
}
