示例#1
0
        public IList<CurriculmArrange> Fill(string QueryParam)
        {
            if (string.IsNullOrEmpty(QueryParam))
            {
                return null;
            }

            IList<Core.Business.CurriculmArrange> curriculmArrangelist = new List<Core.Business.CurriculmArrange>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlFillCurriculmArrange + QueryParam);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.CurriculmArrange curriculmArrange = new Core.Business.CurriculmArrange();

                    if (!reader.IsDBNull(0)) curriculmArrange.Term = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) curriculmArrange.ClassCode = reader.GetString(1);
                    if (!reader.IsDBNull(2)) curriculmArrange.Year = reader.GetString(2);

                    curriculmArrange.MarkOld();
                    curriculmArrangelist.Add(curriculmArrange);
                }
                reader.Close();
            }
            return curriculmArrangelist;
        }
示例#2
0
        public IList<CurriculmArrange> Fill(ClassInfo classInfo, string year, int term)
        {
            if (classInfo == null || string.IsNullOrEmpty(year) || term <= 0)
            {
                return null;
            }

            IList<Core.Business.CurriculmArrange> curriculmArrangelist = new List<Core.Business.CurriculmArrange>();

            SqlServerUtility sql = new SqlServerUtility();

            sql.AddParameter("@ClassCode", SqlDbType.NVarChar, classInfo.ClassCode, 30);

            sql.AddParameter("@Term", SqlDbType.Int, term);

            sql.AddParameter("@Year", SqlDbType.NVarChar, year);

            SqlDataReader reader = sql.ExecuteSqlReader(SqlFillCurriculmArrangeList);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.CurriculmArrange curriculmArrange = new Core.Business.CurriculmArrange();

                    if (!reader.IsDBNull(0)) curriculmArrange.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) curriculmArrange.CourseTime = reader.GetInt32(1);
                    if (!reader.IsDBNull(2)) curriculmArrange.Term = reader.GetInt32(2);
                    if (!reader.IsDBNull(3)) curriculmArrange.ClassCode = reader.GetString(3);
                    if (!reader.IsDBNull(4)) curriculmArrange.CourseCode = reader.GetString(4);
                    if (!reader.IsDBNull(5)) curriculmArrange.TeacherCode = reader.GetString(5);
                    if (!reader.IsDBNull(6)) curriculmArrange.ClassRoomCode = reader.GetString(6);
                    if (!reader.IsDBNull(7)) curriculmArrange.Year = reader.GetString(7);

                    curriculmArrange.MarkOld();
                    curriculmArrangelist.Add(curriculmArrange);
                }
                reader.Close();
            }
            return curriculmArrangelist;
        }
示例#3
0
        public Core.Business.CurriculmArrange Select(int id)
        {
            SqlServerUtility sql = new SqlServerUtility();

            sql.AddParameter("@Id", SqlDbType.Int, id);
            SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectCurriculmArrange);

            if (reader != null && !reader.IsClosed && reader.Read())
            {
                Core.Business.CurriculmArrange curriculmArrange = new Core.Business.CurriculmArrange();

                if (!reader.IsDBNull(0)) curriculmArrange.Id = reader.GetInt32(0);
                if (!reader.IsDBNull(1)) curriculmArrange.CourseTime = reader.GetInt32(1);
                if (!reader.IsDBNull(2)) curriculmArrange.Term = reader.GetInt32(2);
                if (!reader.IsDBNull(3)) curriculmArrange.ClassCode = reader.GetString(3);
                if (!reader.IsDBNull(4)) curriculmArrange.CourseCode = reader.GetString(4);
                if (!reader.IsDBNull(5)) curriculmArrange.TeacherCode = reader.GetString(5);
                if (!reader.IsDBNull(6)) curriculmArrange.ClassRoomCode = reader.GetString(6);
                if (!reader.IsDBNull(7)) curriculmArrange.Year = reader.GetString(7);

                reader.Close();
                return curriculmArrange;
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();

                return null;
            }
        }
示例#4
0
        public IList<Core.Business.CurriculmArrange> GetAllCurriculmArrange()
        {
            IList<Core.Business.CurriculmArrange> curriculmArrangelist = new List<Core.Business.CurriculmArrange>();
            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllCurriculmArrange);

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.CurriculmArrange curriculmArrange = new Core.Business.CurriculmArrange();

                    if (!reader.IsDBNull(0)) curriculmArrange.Id = reader.GetInt32(0);
                    if (!reader.IsDBNull(1)) curriculmArrange.CourseTime = reader.GetInt32(1);
                    if (!reader.IsDBNull(2)) curriculmArrange.Term = reader.GetInt32(2);
                    if (!reader.IsDBNull(3)) curriculmArrange.ClassCode = reader.GetString(3);
                    if (!reader.IsDBNull(4)) curriculmArrange.CourseCode = reader.GetString(4);
                    if (!reader.IsDBNull(5)) curriculmArrange.TeacherCode = reader.GetString(5);
                    if (!reader.IsDBNull(6)) curriculmArrange.ClassRoomCode = reader.GetString(6);
                    if (!reader.IsDBNull(7)) curriculmArrange.Year = reader.GetString(7);

                    curriculmArrange.MarkOld();
                    curriculmArrangelist.Add(curriculmArrange);
                }
                reader.Close();
            }
            return curriculmArrangelist;
        }
示例#5
0
        public List<CY.GFive.Core.Business.CurriculmArrange> FillTeacher(string queryParam)
        {
            if (string.IsNullOrEmpty(queryParam))
            {
                return null;
            }

            List<CY.GFive.Core.Business.CurriculmArrange> Teachers = new List<CY.GFive.Core.Business.CurriculmArrange>();

            SqlServerUtility sql = new SqlServerUtility();

            SqlDataReader reader = sql.ExecuteSqlReader(SqlFillCurriculmArrangeTeachers + queryParam);
            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.CurriculmArrange curriculmArrange = new Core.Business.CurriculmArrange();

                    if (!reader.IsDBNull(0)) curriculmArrange.TeacherCode = reader.GetString(0);
                    if (!reader.IsDBNull(1)) curriculmArrange.Year = reader.GetString(1);
                    if (!reader.IsDBNull(2)) curriculmArrange.Term = reader.GetInt32(2);

                    curriculmArrange.MarkOld();

                    Teachers.Add(curriculmArrange);
                }
                reader.Close();
            }
            return Teachers;
        }