public IList<Core.Business.TeachPlanRate> GetAllTeachPlanRate() { IList<Core.Business.TeachPlanRate> teachPlanRatelist = new List<Core.Business.TeachPlanRate>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTeachPlanRate); if (reader != null) { while (reader.Read()) { Core.Business.TeachPlanRate teachPlanRate = new Core.Business.TeachPlanRate(); if (!reader.IsDBNull(0)) teachPlanRate.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) teachPlanRate.Term = reader.GetInt32(1); if (!reader.IsDBNull(2)) teachPlanRate.Week = reader.GetInt32(2); if (!reader.IsDBNull(3)) teachPlanRate.LftCode = reader.GetString(3); if (!reader.IsDBNull(4)) teachPlanRate.RgtCode = reader.GetString(4); if (!reader.IsDBNull(5)) teachPlanRate.CheckedDepart = reader.GetString(5); if (!reader.IsDBNull(6)) teachPlanRate.Year = reader.GetString(6); teachPlanRate.MarkOld(); teachPlanRatelist.Add(teachPlanRate); } reader.Close(); } return teachPlanRatelist; }
public IList<TeachPlanRate> GetTeachePlanRate(string queryParam) { if (string.IsNullOrEmpty(queryParam)) { return this.GetAllTeachPlanRate(); } IList<Core.Business.TeachPlanRate> teachPlanRatelist = new List<Core.Business.TeachPlanRate>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Text", SqlDbType.NVarChar, queryParam); SqlDataReader reader = sql.ExecuteSqlReader(string.Format(SqlGetTeachPlanRates, queryParam)); if (reader != null) { while (reader.Read()) { Core.Business.TeachPlanRate teachPlanRate = new Core.Business.TeachPlanRate(); if (!reader.IsDBNull(0)) teachPlanRate.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) teachPlanRate.Term = reader.GetInt32(1); if (!reader.IsDBNull(2)) teachPlanRate.Week = reader.GetInt32(2); if (!reader.IsDBNull(3)) teachPlanRate.LftCode = reader.GetString(3); if (!reader.IsDBNull(4)) teachPlanRate.RgtCode = reader.GetString(4); if (!reader.IsDBNull(5)) teachPlanRate.CheckedDepart = reader.GetString(5); if (!reader.IsDBNull(6)) teachPlanRate.Year = reader.GetString(6); teachPlanRate.MarkOld(); teachPlanRatelist.Add(teachPlanRate); } reader.Close(); } return teachPlanRatelist; }
public CY.GFive.Core.Business.TeachPlanRate Select(Department department, string year, int term) { if (department == null || year == "") { return null; } IList<Core.Business.TeachPlanRate> teachPlanRatelist = new List<Core.Business.TeachPlanRate>(); SqlServerUtility sql = new SqlServerUtility(); string sqlstr = string.Empty; sql.AddParameter("@Depart", SqlDbType.NVarChar, department.DepartCode); sql.AddParameter("@Year", SqlDbType.NVarChar, year); sql.AddParameter("@Term", SqlDbType.Int, term); SqlDataReader reader = sql.ExecuteSqlReader(SqlIsExsit); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TeachPlanRate teachPlanRate = new Core.Business.TeachPlanRate(); if (!reader.IsDBNull(0)) teachPlanRate.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) teachPlanRate.Term = reader.GetInt32(1); if (!reader.IsDBNull(2)) teachPlanRate.Week = reader.GetInt32(2); if (!reader.IsDBNull(3)) teachPlanRate.LftCode = reader.GetString(3); if (!reader.IsDBNull(4)) teachPlanRate.RgtCode = reader.GetString(4); if (!reader.IsDBNull(5)) teachPlanRate.CheckedDepart = reader.GetString(5); if (!reader.IsDBNull(6)) teachPlanRate.Year = reader.GetString(6); teachPlanRate.MarkOld(); reader.Close(); return teachPlanRate; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public Core.Business.TeachPlanRate Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectTeachPlanRate); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TeachPlanRate teachPlanRate = new Core.Business.TeachPlanRate(); if (!reader.IsDBNull(0)) teachPlanRate.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) teachPlanRate.Term = reader.GetInt32(1); if (!reader.IsDBNull(2)) teachPlanRate.Week = reader.GetInt32(2); if (!reader.IsDBNull(3)) teachPlanRate.LftCode = reader.GetString(3); if (!reader.IsDBNull(4)) teachPlanRate.RgtCode = reader.GetString(4); if (!reader.IsDBNull(5)) teachPlanRate.CheckedDepart = reader.GetString(5); if (!reader.IsDBNull(6)) teachPlanRate.Year = reader.GetString(6); reader.Close(); return teachPlanRate; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.TeachPlanRate> Search(string year, int term) { IList<Core.Business.TeachPlanRate> teachPlanRatelist = new List<Core.Business.TeachPlanRate>(); SqlServerUtility sql = new SqlServerUtility(); string sqlstr = string.Empty; if ((String.IsNullOrEmpty(year) || year == "") && term == 0) { sqlstr = SqlGetAllTeachPlanRate; } else if (String.IsNullOrEmpty(year) || year == "") { sql.AddParameter("@Term", SqlDbType.Int, term); sqlstr = SqlSearchByTerm; } else if (term == 0) { sql.AddParameter("@Year", SqlDbType.NVarChar, year); sqlstr = SqlSearchByYear; } else { sql.AddParameter("@Term", SqlDbType.Int, term); sql.AddParameter("@Year", SqlDbType.NVarChar, year); sqlstr = SqlSearchByYearAndTerm; } SqlDataReader reader = sql.ExecuteSqlReader(sqlstr); if (reader != null) { while (reader.Read()) { Core.Business.TeachPlanRate teachPlanRate = new Core.Business.TeachPlanRate(); if (!reader.IsDBNull(0)) teachPlanRate.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) teachPlanRate.Term = reader.GetInt32(1); if (!reader.IsDBNull(2)) teachPlanRate.Week = reader.GetInt32(2); if (!reader.IsDBNull(3)) teachPlanRate.LftCode = reader.GetString(3); if (!reader.IsDBNull(4)) teachPlanRate.RgtCode = reader.GetString(4); if (!reader.IsDBNull(5)) teachPlanRate.CheckedDepart = reader.GetString(5); if (!reader.IsDBNull(6)) teachPlanRate.Year = reader.GetString(6); teachPlanRate.MarkOld(); teachPlanRatelist.Add(teachPlanRate); } reader.Close(); } return teachPlanRatelist; }
public Core.Business.TeachPlanRate GetTP(string lcode, string rcode) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@LftCode", SqlDbType.NVarChar, lcode); sql.AddParameter("@RgtCode", SqlDbType.NVarChar, rcode); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetByLAndR); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TeachPlanRate teachPlanRate = new Core.Business.TeachPlanRate(); if (!reader.IsDBNull(0)) teachPlanRate.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) teachPlanRate.Term = reader.GetInt32(1); if (!reader.IsDBNull(2)) teachPlanRate.Week = reader.GetInt32(2); if (!reader.IsDBNull(3)) teachPlanRate.LftCode = reader.GetString(3); if (!reader.IsDBNull(4)) teachPlanRate.RgtCode = reader.GetString(4); if (!reader.IsDBNull(5)) teachPlanRate.CheckedDepart = reader.GetString(5); if (!reader.IsDBNull(6)) teachPlanRate.Year = reader.GetString(6); teachPlanRate.MarkOld(); reader.Close(); return teachPlanRate; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }