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; }