积分系统(4)-详细公告页面的“B”层跟“D”层

这篇博客是一篇代码存档；

因为是第一次用到 Bootstrap技术，算是有点小兴奋，留下来，下次用的时候可以站在这一篇的基础上！

B层

///************************************************* 
//*说明：此页面为详细公告的B层，用于将Controller里面的请求传到D层，再将D层里面的值传给Controller,也可以理解为传到U层或者前端
//*作者：王川
//*版本号： V2.0.0
//*创建时间：2017年4月18日 16:30:00
//**********************************************/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ViewModel;



//BLL层的方法
namespace BLL.AnnounceBoardBLL
{
    public class AnnounceBoardBLL
    {
        public List<AnnounceBoardViewModel> QueryTableInfo1()
        {
            //将D层的值往回返。
            return new DAL.AnnounceBoardDAL().QueryTableInfo1();
        }


        public List<AnnounceBoardViewModel> QueryTableInfo2()
        {
            //将D层的值往回返。
            return new DAL.AnnounceBoardDAL().QueryTableInfo2();
        }


        public List<AnnounceBoardViewModel> QueryTableInfo3()
        { 
            //将D层的值往回反。
            return new DAL.AnnounceBoardDAL().QueryTableInfo3();
        }
    }
}

D层

///************************************************* 
//*说明：此页面为详细公告的D层，用于将B层的请求传到D层，再将D层里面的值传给Controller,也可以理解为传到U层或者前端
//*作者：王川
//*小组：王浩田、常银玲、刘少锋、马金兴、王啸、吴晓如、杨晓风、张婷、陈丹、郭晶晶、任杰、田晓冰、李建敏、王红伟
//*版本号： V2.0.0
//*创建时间：2017年4月18日 16:30:00
//**********************************************/


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Model;
using ViewModel;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace DAL
{
    public class AnnounceBoardDAL
    {
        public List<AnnounceBoardViewModel> QueryTableInfo1()
        {
            try
            {
                //引用上下文
                excellentmcoinEntities DBcontext = new excellentmcoinEntities();
                List<AnnounceBoardViewModel> QueryRecordID = new List<AnnounceBoardViewModel>();
                QueryRecordID = (from a in DBcontext.t_announce

                                 //需找数据库里相应的字段
                                 where a.announceType == "合格的"
                                 select new AnnounceBoardViewModel()
                                 {
                                     announceName = a.announceName,
                                     date = a.date,
                                     announceStates = a.announceStates,
                                 }).ToList();
                return QueryRecordID;
            }
            catch (Exception e)
            {
                throw e;
            }
        }




        public List<AnnounceBoardViewModel> QueryTableInfo2()
        {
            try
            {
                //引用上下文
                excellentmcoinEntities DBcontext = new excellentmcoinEntities();
                List<AnnounceBoardViewModel> QueryRecordID = new List<AnnounceBoardViewModel>();
                QueryRecordID = (from a in DBcontext.t_announce

                                 //需找数据库里相应的字段
                                 where a.announceType == "待审批"
                                 select new AnnounceBoardViewModel()
                                 {
                                     announceName = a.announceName,
                                     date = a.date,
                                     announceStates = a.announceStates,
                                 }).ToList();
                return QueryRecordID;
            }
            catch (Exception e)
            {
                throw e;
            }
        }




        public List<AnnounceBoardViewModel> QueryTableInfo3()
        {
            try
            {
                //引用上下文
                excellentmcoinEntities DBcontext = new excellentmcoinEntities();
                List<AnnounceBoardViewModel> QueryRecordID = new List<AnnounceBoardViewModel>();
                QueryRecordID = (from a in DBcontext.t_announce

                                 //需找数据库里相应的字段
                                 where a.announceType == "不合格"
                                 select new AnnounceBoardViewModel()
                                 {
                                     announceName = a.announceName,
                                     date = a.date,
                                     announceStates = a.announceStates,
                                 }).ToList();
                return QueryRecordID;
            }
            catch (Exception e)
            {
                throw e;
            }
        }
    }
}