public TClassInfo GetByParam(string classCode, string TclsCode) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@ClassCode", SqlDbType.NVarChar, classCode); sql.AddParameter("@TClsCode", SqlDbType.NVarChar, TclsCode); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetByParam); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TClassInfo tClassInfo = new Core.Business.TClassInfo(); if (!reader.IsDBNull(0)) tClassInfo.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) tClassInfo.ClassCode = reader.GetString(1); if (!reader.IsDBNull(2)) tClassInfo.TClsCode = reader.GetString(2); tClassInfo.MarkOld(); reader.Close(); return tClassInfo; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<Core.Business.TClassInfo> GetAllTClassInfo() { IList<Core.Business.TClassInfo> tClassInfolist = new List<Core.Business.TClassInfo>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllTClassInfo); if (reader != null) { while (reader.Read()) { Core.Business.TClassInfo tClassInfo = new Core.Business.TClassInfo(); if (!reader.IsDBNull(0)) tClassInfo.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) tClassInfo.ClassCode = reader.GetString(1); if (!reader.IsDBNull(2)) tClassInfo.TClsCode = reader.GetString(2); tClassInfo.MarkOld(); tClassInfolist.Add(tClassInfo); } reader.Close(); } return tClassInfolist; }
public IList<Core.Business.TClassInfo> GetListByQuery(string wherestr) { IList<Core.Business.TClassInfo> tClassInfolist = new List<Core.Business.TClassInfo>(); SqlServerUtility sql = new SqlServerUtility(); StringBuilder sb = new StringBuilder(); sb.Append(" SELECT [TClassInfo].* FROM [TClassInfo],[CourseClass],[ClassInfo],[Course]"); sb.Append(" WHERE [TClassInfo].[ClassCode]=[ClassInfo].[ClassCode] AND [TClassInfo].[TClsCode]=[CourseClass].[TCCode] AND [CourseClass].[CourseCode]=[Course].[Code]"); if (!string.IsNullOrEmpty(wherestr)) { sb.Append(" AND " + wherestr); } SqlDataReader reader = sql.ExecuteSqlReader(sb.ToString()); if (reader != null) { while (reader.Read()) { Core.Business.TClassInfo tClassInfo = new Core.Business.TClassInfo(); if (!reader.IsDBNull(0)) tClassInfo.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) tClassInfo.ClassCode = reader.GetString(1); if (!reader.IsDBNull(2)) tClassInfo.TClsCode = reader.GetString(2); tClassInfo.MarkOld(); tClassInfolist.Add(tClassInfo); } reader.Close(); } return tClassInfolist; }
public Core.Business.TClassInfo Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Key", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectTClassInfo); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TClassInfo tClassInfo = new Core.Business.TClassInfo(); if (!reader.IsDBNull(0)) tClassInfo.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) tClassInfo.ClassCode = reader.GetString(1); if (!reader.IsDBNull(2)) tClassInfo.TClsCode = reader.GetString(2); reader.Close(); return tClassInfo; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }