public IList<CoursePlan> Fill(string QueryParam)
{
IList<Core.Business.CoursePlan> coursePlanlist = new List<Core.Business.CoursePlan>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllCoursePlan + QueryParam);
if (reader != null)
{
while (reader.Read())
{
Core.Business.CoursePlan coursePlan = new Core.Business.CoursePlan();
if (!reader.IsDBNull(0)) coursePlan.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) coursePlan.PlanCode = reader.GetString(1);
if (!reader.IsDBNull(2)) coursePlan.PlanYear = reader.GetString(2);
if (!reader.IsDBNull(3)) coursePlan.PlanTerm = reader.GetString(3);
if (!reader.IsDBNull(4)) coursePlan.ProCode = reader.GetString(4);
if (!reader.IsDBNull(5)) coursePlan.PlanGrade = reader.GetString(5);
if (!reader.IsDBNull(6)) coursePlan.ClsCode = reader.GetString(6);
coursePlan.MarkOld();
coursePlanlist.Add(coursePlan);
}
reader.Close();
}
return coursePlanlist;
}
public IList<CoursePlan> Fill(string profess, string grade, string year, string term)
{
if (!string.IsNullOrEmpty(profess) && !string.IsNullOrEmpty(grade) && !string.IsNullOrEmpty(year) && !string.IsNullOrEmpty(term))
{
return null;
}
IList<Core.Business.CoursePlan> coursePlanlist = new List<Core.Business.CoursePlan>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Profess", SqlDbType.NVarChar, profess, 30);
sql.AddParameter("@Grade", SqlDbType.NVarChar, grade, 30);
sql.AddParameter("@Term", SqlDbType.NVarChar, year, 10);
sql.AddParameter("@Year", SqlDbType.NVarChar, term, 10);
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillCoursePlanWithParam);
if (reader != null)
{
while (reader.Read())
{
Core.Business.CoursePlan coursePlan = new Core.Business.CoursePlan();
if (!reader.IsDBNull(0)) coursePlan.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) coursePlan.PlanCode = reader.GetString(1);
if (!reader.IsDBNull(2)) coursePlan.PlanYear = reader.GetString(2);
if (!reader.IsDBNull(3)) coursePlan.PlanTerm = reader.GetString(3);
if (!reader.IsDBNull(4)) coursePlan.ProCode = reader.GetString(4);
if (!reader.IsDBNull(5)) coursePlan.PlanGrade = reader.GetString(5);
if (!reader.IsDBNull(6)) coursePlan.ClsCode = reader.GetString(6);
coursePlan.MarkOld();
coursePlanlist.Add(coursePlan);
}
reader.Close();
}
return coursePlanlist;
}
/// <summary>
/// private static readonly string SqlSelectCoursePlanWithParam = "SELECT [Id], [PlanCode],[PlanYear],[PlanTerm],[ProCode],[PlanGrade] FROM [CoursePlan] WHERE [PlanYear]=@Year AND [PlanTerm]=@Term AND [ProCode]=@Profess AND [PlanGrade]=@Grade";
/// </summary>
/// <param name="profess"></param>
/// <param name="grade"></param>
/// <param name="term"></param>
/// <param name="year"></param>
/// <returns></returns>
public CoursePlan Select(Profess profess, Grade grade, string term, string year, string clsCode)
{
if (profess == null || grade == null || string.IsNullOrEmpty(term) || string.IsNullOrEmpty(year) || string.IsNullOrEmpty(clsCode))
return null;
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Profess", SqlDbType.NVarChar, profess.ProCode, 30);
sql.AddParameter("@Grade", SqlDbType.NVarChar, grade.GradeCode, 30);
sql.AddParameter("@Term", SqlDbType.NVarChar, term, 10);
sql.AddParameter("@Year", SqlDbType.NVarChar, year, 10);
sql.AddParameter("@ClassCode", SqlDbType.NVarChar, clsCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectCoursePlanWithParam);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.CoursePlan coursePlan = new Core.Business.CoursePlan();
if (!reader.IsDBNull(0)) coursePlan.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) coursePlan.PlanCode = reader.GetString(1);
if (!reader.IsDBNull(2)) coursePlan.PlanYear = reader.GetString(2);
if (!reader.IsDBNull(3)) coursePlan.PlanTerm = reader.GetString(3);
if (!reader.IsDBNull(4)) coursePlan.ProCode = reader.GetString(4);
if (!reader.IsDBNull(5)) coursePlan.PlanGrade = reader.GetString(5);
if (!reader.IsDBNull(6)) coursePlan.ClsCode = reader.GetString(6);
reader.Close();
coursePlan.MarkOld();
return coursePlan;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
/// <summary>
/// [PlanYear]=@Year AND [PlanTerm]=@Term AND [ProCode]=@Profess AND [PlanGrade]=@Grade AND [ClsCode]=@ClassCode";
/// </summary>
/// <param name="year"></param>
/// <param name="semester"></param>
/// <param name="classInfo"></param>
/// <returns></returns>
public CoursePlan Select(string year, string semester, ClassInfo classInfo)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Year", SqlDbType.NVarChar, year, 30);
sql.AddParameter("@Term", SqlDbType.NVarChar, semester, 30);
sql.AddParameter("@Grade", SqlDbType.NVarChar,classInfo.GradeCode , 30);
sql.AddParameter("@Profess", SqlDbType.NVarChar, classInfo.ProCode, 30);
sql.AddParameter("@ClassCode", SqlDbType.NVarChar, classInfo.ClassCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectCoursePlanWithParam);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.CoursePlan coursePlan = new Core.Business.CoursePlan();
if (!reader.IsDBNull(0)) coursePlan.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) coursePlan.PlanCode = reader.GetString(1);
if (!reader.IsDBNull(2)) coursePlan.PlanYear = reader.GetString(2);
if (!reader.IsDBNull(3)) coursePlan.PlanTerm = reader.GetString(3);
if (!reader.IsDBNull(4)) coursePlan.ProCode = reader.GetString(4);
if (!reader.IsDBNull(5)) coursePlan.PlanGrade = reader.GetString(5);
if (!reader.IsDBNull(6)) coursePlan.ClsCode = reader.GetString(6);
reader.Close();
coursePlan.MarkOld();
return coursePlan;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public Core.Business.CoursePlan Select(int id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.Int, id);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectCoursePlan);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.CoursePlan coursePlan = new Core.Business.CoursePlan();
if (!reader.IsDBNull(0)) coursePlan.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) coursePlan.PlanCode = reader.GetString(1);
if (!reader.IsDBNull(2)) coursePlan.PlanYear = reader.GetString(2);
if (!reader.IsDBNull(3)) coursePlan.PlanTerm = reader.GetString(3);
if (!reader.IsDBNull(4)) coursePlan.ProCode = reader.GetString(4);
if (!reader.IsDBNull(5)) coursePlan.PlanGrade = reader.GetString(5);
if (!reader.IsDBNull(6)) coursePlan.ClsCode = reader.GetString(6);
reader.Close();
return coursePlan;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
