public ActionResult StuXuanzeTheme()
        {
            Student           stu       = (Student)Session["student"];
            string            themename = Request["ketiming"];
            ThemeService      theser    = new ThemeService();
            ChoseThemeService choseser  = new ChoseThemeService();

            if (choseser.GetStuChoseTheme((int)stu.Stu_Id) != null)//没有选过就为true
            {
                Response.Write("不能选择过个课题");
                Response.End();
                return(View());
            }
            ;

            Theme      theme      = theser.GetThemeByThemeName(themename);
            ChoseTheme chosetheme = new ChoseTheme();

            chosetheme.Student = stu;
            chosetheme.Theme   = theme;
            chosetheme.Teacher = theme.Teacher;
            chosetheme.SubTime = DateTime.Now;
            if (choseser.AddChoseTheme(chosetheme))
            {
                TeacherService ter = new TeacherService();
                ter.UpdateTeaAddCount(theme.Teacher);
                Response.Write("选题成功");
                Response.End();
                return(View());
            }
            ;
            Response.Write("选题未成功");
            Response.End();
            return(View());
        }
        //#region 查询已选论文课题状态
        ///// <summary>
        ///// 0:未审批
        ///// 1:审批未通过
        ///// 2:学生主动放弃
        ///// 3:审批通过
        ///// </summary>
        ///// <param name="ct"></param>
        ///// <returns></returns>
        //public int GetChoseThemeStatus(ChoseTheme ct)
        //{
        //    return ct.Status;
        //}
        //#endregion

        //#region 学生查询已选论文课题
        ///// <summary>
        ///// 学生查询已选论文课题
        ///// </summary>
        ///// <param name="stu"></param>
        ///// <returns></returns>
        //public IQueryable<ChoseTheme> GetChosedThemeByStudent(Student stu)
        //{
        //    IList<Theme> list = new List<Theme>();
        //    ChoseTheme cht = new ChoseTheme();
        //    IQueryable<ChoseTheme> ctiq = ctDal.GetEntities(ct => ct.Student.Stu_Num == stu.Stu_Num);
        //    return ctiq;
        //}
        //#endregion

        //#region 学生查询已选的并且通过的论文课题
        ///// <summary>
        ///// 学生查询已选的并且通过的论文课题
        ///// </summary>
        ///// <param name="stu"></param>
        ///// <returns></returns>
        //public IList<Theme> GetChosedAndPassedThemeByStudent(Student stu)
        //{

        //    IList<Theme> tlist = new List<Theme>();
        //    IQueryable<ChoseTheme> ctiq = ctDal.GetEntities(ct => ct.Student.Stu_Num == stu.Stu_Num && ct.Status == 3);
        //    if (ctiq.Count() == 0)
        //    {
        //        return null;
        //    }
        //    foreach (var item in ctiq)
        //    {
        //        tlist.Add(item.Theme);
        //    }
        //    return tlist;
        //}
        //#endregion

        //#region 学生查询已选的并且未通过的论文课题
        ///// <summary>
        ///// 学生查询已选的并且未通过的论文课题
        ///// </summary>
        ///// <param name="stu"></param>
        ///// <returns></returns>
        //public IList<Theme> GetChosedAndNotPassedThemeByStudent(Student stu)
        //{

        //    IList<Theme> tlist = new List<Theme>();
        //    IQueryable<ChoseTheme> ctiq = ctDal.GetEntities(ct => ct.Student.Stu_Num == stu.Stu_Num && ct.Status < 3);
        //    if (ctiq.Count() == 0)
        //    {
        //        return null;
        //    }
        //    foreach (var item in ctiq)
        //    {
        //        tlist.Add(item.Theme);
        //    }
        //    return tlist;
        //}
        //#endregion


        #region 老师查询已选论文课题
        /// <summary>
        /// 老师查询已选论文课题
        /// </summary>
        /// <param name="tea"></param>
        /// <returns></returns>
        public IQueryable <ChoseTheme> GetChosedThemeByTeacher(int teaid)
        {
            // IList<ChoseTheme> list = new List<ChoseTheme>();
            ChoseTheme cht = new ChoseTheme();
            IQueryable <ChoseTheme> ctiq = ctDal.GetEntities(ct => ct.Teacher.Tea_Id == teaid);

            return(ctiq);
        }
        public bool AddChoseTheme(ChoseTheme cho)
        {
            DBSession db = new DBSession();

            if (ctDal.Add(cho) != null)
            {
                db.SaveChanges();
                return(true);
            }
            return(false);
        }
        public ChoseTheme GetStuChoseTheme(int stuid)
        {
            ChoseTheme ct = new ChoseTheme();
            IQueryable <ChoseTheme> iq = ctDal.GetEntities(u => u.Student.Stu_Id == stuid);

            if (iq.Count() == 0)
            {
                return(null);
            }
            foreach (var item in iq)
            {
                ct = item;
            }
            return(ct);
        }
        public ActionResult GetMyTheme()
        {
            Session["filestyle"] = "开题报告";
            Student           stu      = (Student)Session["student"];
            ChoseThemeService choseser = new ChoseThemeService();
            ChoseTheme        ct       = choseser.GetStuChoseTheme((int)stu.Stu_Id);

            if (ct == null)
            {
                Response.Write("");
                Response.End();
                return(View());
            }
            string str = ct.Teacher.Tea_Name + "-" + ct.Teacher.Tea_Tel + "-" + ct.Teacher.Tea_Email + "-" + ct.Theme.Theme_Name + "-" + ct.Theme.TeaGroup.TG_Name + "-" + ct.Theme.Introduce;

            Response.Write(str);
            Response.End();
            return(View());
        }