//获取置顶News public News GetTopNews() { //sql语句 string sql = "select * from News,NState where News.NState=NState.NStateId and NState.NStateId=2"; News topnews = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sql)) { if (reader.Read()) { AdminService adminService = new AdminService(); NStateService nstateService = new NStateService(); topnews = new News(); topnews.id = (int)reader["id"]; topnews.NewsTitle = (string)reader["NewsTitle"]; topnews.NewsMain = (string)reader["NewsMain"]; topnews.NewsDate = reader["NewsDate"] != DBNull.Value ? (DateTime?)reader["NewsDate"] : null; topnews.NewsPublisher = adminService.GetAdminById((int)reader["NewsPublisher"]); topnews.NState = nstateService.GetNStateById((int)reader["NState"]); topnews.NewsHits = (int)reader["NewsHits"]; } } return(topnews); }
//获取置顶Notices public Notices GetTopNotices() { //sql语句 string sql = "select * from Notices,NState where Notices.NState=NState.NStateId and NState.NStateId=2"; Notices topnotices = null; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sql)) { if (reader.Read()) { AdminService adminService = new AdminService(); DepartmentService departmentService = new DepartmentService(); NStateService nstateService = new NStateService(); topnotices = new Notices(); topnotices.id = (int)reader["id"]; topnotices.NoticeTitle = (string)reader["NoticeTitle"]; topnotices.NoticeMain = (string)reader["NoticeMain"]; topnotices.NoticeDate = reader["NoticeDate"] != DBNull.Value ? (DateTime?)reader["NoticeDate"] : null; topnotices.NoticePublisher = adminService.GetAdminById((int)reader["NoticePublisher"]); topnotices.NoticeBelong = departmentService.GetDepartmentById((int)reader["NoticeBelong"]); topnotices.NState = nstateService.GetNStateById((int)reader["NState"]); topnotices.NoticeHits = (int)reader["NoticeHits"]; } } return(topnotices); }
//获取Newsbyid public News GetNewsById(int id) { //sql语句 string sql = "select * from News where ID=@id"; News news = new News(); using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sql, new SqlParameter("@id", id))) { if (reader.Read()) { AdminService adminService = new AdminService(); NStateService nstateService = new NStateService(); news = new News(); news.id = (int)reader["id"]; news.NewsTitle = (string)reader["NewsTitle"]; news.NewsMain = (string)reader["NewsMain"]; news.NewsDate = reader["NewsDate"] != DBNull.Value ? (DateTime?)reader["NewsDate"] : null; news.NewsPublisher = adminService.GetAdminById((int)reader["NewsPublisher"]); news.NState = nstateService.GetNStateById((int)reader["NState"]); news.NewsHits = (int)reader["NewsHits"]; } } return(news); }
//获取公告byid public Notices GetNoticeById(int id) { Notices notices = new Notices(); //sql语句 string sql = "select * from Notices where ID=@id"; using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sql, new SqlParameter("@id", id))) { if (reader.Read()) { AdminService adminService = new AdminService(); DepartmentService departmentService = new DepartmentService(); NStateService nstateService = new NStateService(); notices = new Notices(); notices.id = (int)reader["id"]; notices.NoticeTitle = (string)reader["NoticeTitle"]; notices.NoticeMain = (string)reader["NoticeMain"]; notices.NoticeDate = reader["NoticeDate"] != DBNull.Value ? (DateTime?)reader["NoticeDate"] : null; notices.NoticePublisher = adminService.GetAdminById((int)reader["NoticePublisher"]); notices.NoticeBelong = departmentService.GetDepartmentById((int)reader["NoticeBelong"]); notices.NState = nstateService.GetNStateById((int)reader["NState"]); notices.NoticeHits = (int)reader["NoticeHits"]; } } return(notices); }