public IList<Core.Business.TrGoupArrangeItem> GetAllTrGoupArrangeItem() { IList<Core.Business.TrGoupArrangeItem> trGoupArrangeItemlist = new List<Core.Business.TrGoupArrangeItem>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTrGoupArrangeItem); if (reader != null) { while (reader.Read()) { Core.Business.TrGoupArrangeItem trGoupArrangeItem = new Core.Business.TrGoupArrangeItem(); if (!reader.IsDBNull(0)) trGoupArrangeItem.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) trGoupArrangeItem.ArrangeItemCode = reader.GetString(1); if (!reader.IsDBNull(2)) trGoupArrangeItem.Unit = reader.GetString(2); if (!reader.IsDBNull(3)) trGoupArrangeItem.ClassCode = reader.GetString(3); if (!reader.IsDBNull(4)) trGoupArrangeItem.WeekType = reader.GetInt32(4); if (!reader.IsDBNull(5)) trGoupArrangeItem.Num = reader.GetInt32(5); if (!reader.IsDBNull(6)) trGoupArrangeItem.AssessCate = reader.GetString(6); if (!reader.IsDBNull(7)) trGoupArrangeItem.TeacherCode = reader.GetString(7); if (!reader.IsDBNull(8)) trGoupArrangeItem.Turn = reader.GetString(8); if (!reader.IsDBNull(9)) trGoupArrangeItem.ArrangeCode = reader.GetString(9); trGoupArrangeItem.MarkOld(); trGoupArrangeItemlist.Add(trGoupArrangeItem); } reader.Close(); } return trGoupArrangeItemlist; }
public Core.Business.TrGoupArrangeItem Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectTrGoupArrangeItem); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TrGoupArrangeItem trGoupArrangeItem = new Core.Business.TrGoupArrangeItem(); if (!reader.IsDBNull(0)) trGoupArrangeItem.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) trGoupArrangeItem.ArrangeItemCode = reader.GetString(1); if (!reader.IsDBNull(2)) trGoupArrangeItem.Unit = reader.GetString(2); if (!reader.IsDBNull(3)) trGoupArrangeItem.ClassCode = reader.GetString(3); if (!reader.IsDBNull(4)) trGoupArrangeItem.WeekType = reader.GetInt32(4); if (!reader.IsDBNull(5)) trGoupArrangeItem.Num = reader.GetInt32(5); if (!reader.IsDBNull(6)) trGoupArrangeItem.AssessCate = reader.GetString(6); if (!reader.IsDBNull(7)) trGoupArrangeItem.TeacherCode = reader.GetString(7); if (!reader.IsDBNull(8)) trGoupArrangeItem.Turn = reader.GetString(8); if (!reader.IsDBNull(9)) trGoupArrangeItem.ArrangeCode = reader.GetString(9); reader.Close(); return trGoupArrangeItem; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }