scheduleservice.cs

will let you know the result once they replied will let you know the result once they replied

using System;
using System.Collections.Generic;
using System.Text;
using MyOffice.Models;
using MyOffice.DBUtility;
using System.Data;
using System.Data.SqlClient;

namespace MyOffice.DAL
{
    public class ScheduleService
    {
        public IList<Schedule> GetAllSchedule()
        {
            IList<Schedule> list = new List<Schedule>();
            string sql = string.Format(@"select * from schedule");
            using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
            {
                while (reader.Read())
                {
                    Schedule schedule = new Schedule();
                    schedule.ScheduleId = reader.GetInt32(0);
                    schedule.Title = reader.GetString(1);
                    schedule.Address = reader.GetString(2);
                    schedule.Meeting = new MeetingInfoService().GetMeetingByID(reader.GetInt32(3));
                    schedule.BeginTime = reader.GetDateTime(4);
                    schedule.EndTime = reader.GetDateTime(5);
                    schedule.SchContent = reader.GetString(6);
                    schedule.CreateUser = reader.GetString(7);
                    schedule.CreateTime = reader.GetDateTime(8);
                    schedule.IfPrivate = reader.GetInt32(9);
                    list.Add(schedule);
                }
                return list;
            }

        }

        public IList<Schedule> GetScheduleByContent(string content)
        {
            IList<Schedule> list = new List<Schedule>();
            string sql = string.Format(@"select * from shcedule where '{0}'", content);
            using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null))
            {
                while (reader.Read())
                {
                    Schedule schedule = new Schedule();
                    schedule.ScheduleId = reader.GetInt32(0);
                    schedule.Title = reader.GetString(1);
                    schedule.Address = reader.GetString(2);
                    schedule.Meeting = new MeetingInfoService().GetMeetingByID(reader.GetInt32(3));
                    schedule.BeginTime = reader.GetDateTime(4);
                    schedule.EndTime = reader.GetDateTime(5);
                    schedule.SchContent = reader.GetString(6);
                    schedule.CreateUser = reader.GetString(7);
                    schedule.CreateTime = reader.GetDateTime(8);
                    schedule.IfPrivate = reader.GetInt32(9);
                    list.Add(schedule);
                }
            } return list;
        }
    }
}