public IList<Core.Business.Teacher> Fill(String param)
{
if (String.IsNullOrEmpty(param))
{
return GetAllTeacher();
}
else
{
List<CY.GFive.Core.Business.Teacher> teacherlist = new List<CY.GFive.Core.Business.Teacher>();
SqlServerUtility sql = new SqlServerUtility();
StringBuilder strBuilder = new StringBuilder();
strBuilder.Append(SqlGetAllTeacher + param);
SqlDataReader reader = sql.ExecuteSqlReader(strBuilder.ToString());
if (reader != null && !reader.IsClosed)
{
while (reader.Read())
{
Core.Business.Teacher teacher = new Core.Business.Teacher();
if (!reader.IsDBNull(0)) teacher.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacher.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) teacher.Name = reader.GetString(2);
if (!reader.IsDBNull(3)) teacher.Gender = reader.GetByte(3);
if (!reader.IsDBNull(4)) teacher.CatetoryCode = reader.GetString(4);
if (!reader.IsDBNull(5)) teacher.Age = reader.GetByte(5);
if (!reader.IsDBNull(6)) teacher.Salary = reader.GetDecimal(6);
if (!reader.IsDBNull(7)) teacher.Degree = reader.GetString(7);
if (!reader.IsDBNull(8)) teacher.Record = reader.GetString(8);
if (!reader.IsDBNull(9)) teacher.Pic = reader.GetString(9);
teacher.MarkOld();
teacherlist.Add(teacher);
}
reader.Close();
}
return teacherlist;
}
}
public IList<Core.Business.Teacher> GetAllTeacher()
{
IList<Core.Business.Teacher> teacherlist = new List<Core.Business.Teacher>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTeacher);
if(reader != null)
{
while(reader.Read())
{
Core.Business.Teacher teacher = new Core.Business.Teacher();
if (!reader.IsDBNull(0)) teacher.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) teacher.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) teacher.Name = reader.GetString(2);
if (!reader.IsDBNull(3)) teacher.Gender = reader.GetByte(3);
if (!reader.IsDBNull(4)) teacher.CatetoryCode = reader.GetString(4);
if (!reader.IsDBNull(5)) teacher.Age = reader.GetByte(5);
if (!reader.IsDBNull(6)) teacher.Salary = reader.GetDecimal(6);
if (!reader.IsDBNull(7)) teacher.Degree = reader.GetString(7);
if (!reader.IsDBNull(8)) teacher.Record = reader.GetString(8);
if (!reader.IsDBNull(9)) teacher.Pic = reader.GetString(9);
teacher.MarkOld();
teacherlist.Add(teacher);
}
reader.Close();
}
return teacherlist;
}
