/// <summary> /// 按条件查询试听课 /// </summary> /// <returns></returns> public ActionResult STClassList() { AjaxStatusModel ajax = new AjaxStatusModel(); ajax.status = EnumAjaxStatus.Error; //默认失败 ajax.msg = "获取失败!"; //前台获取,用于显示提示信息 ClassesListSearchModel search = new ClassesListSearchModel(); string CourseName = Request["CourseName"]; string StartTime_start = Request["StartTime_start"]; string StartTime_end = Request["StartTime_end"]; string islisten = Request["islisten"];//是否查询试听列表 search.ComCode = UserSession.comcode; search.CourseName = CourseName; if (!string.IsNullOrEmpty(StartTime_start)) { search.StartTime_start = StartTime_start; } if (!string.IsNullOrEmpty(StartTime_end)) { search.StartTime_end = StartTime_end; } search.CurrentPage = 1; //当前页 search.PageSize = 99999; //不想分页就设置成一个较大的值 search.islisten = islisten; List <vw_Classes> vw_Classes = ClassesData.GeClassesList(search); ajax.data = vw_Classes; return(Json(new { total = 1, rows = vw_Classes, state = true, msg = "加载成功" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 班级列表查询 /// </summary> public ActionResult Classes(ClassesListSearchModel search) { ClassesListViewModel model = new ClassesListViewModel(); //页面模型 model.search = search; //页面的搜索模型 model.search.PageSize = 15; //每页显示 model.search.CurrentPage = Convert.ToInt32(Request["pageindex"]) <= 0 ? 1 : Convert.ToInt32(Request["pageindex"]); //当前页 //下拉项 List <CommonEntity> SourceIL = CommonData.GetDictionaryList(5);//授课方式 model.SourceIL = CommonData.Instance.GetBropDownListData(SourceIL); //下拉项 List <CommonEntity> SourceIL1 = CommonData.GetCourseList();//课程 model.SourceIL1 = CommonData.Instance.GetBropDownListData(SourceIL1); //下拉项 List <CommonEntity> SourceIL2 = CommonData.GetTeachersList();//获取老师信息 model.SourceIL2 = CommonData.Instance.GetBropDownListData(SourceIL2); //下拉项 List <CommonEntity> SourceIL3 = CommonData.GetDictionaryList(11);//获取教室信息 model.SourceIL3 = CommonData.Instance.GetBropDownListData(SourceIL3); //下拉项 List <CommonEntity> SourceIL4 = CommonData.GetDictionaryList(8);//获取上课的时段信息 model.SourceIL4 = CommonData.Instance.GetBropDownListData(SourceIL4); //获取升级班级列表下拉框,只能是未排课的班级列表 List <CommonEntity> UpgradeClassesIL = CommonData.GetClassesItemList(); model.UpgradeClassesIL = CommonData.Instance.GetBropDownListData(UpgradeClassesIL); //分校下拉项 List <CommonEntity> ComCodeIL = CommonData.Get_SYS_Company_COMP_Code(UserSession.comcode);//分校 model.ComCodeIL = CommonData.Instance.GetBropDownListData_Choice(ComCodeIL); model.search.ComCodeIL = CommonData.Instance.GetBropDownListData_Choice(ComCodeIL); if (UserSession.comcode != null && UserSession.comcode != "1") { search.ComCode = UserSession.comcode;//默认查询当前分校的人员 } model.Classeslist = ClassesData.GeClassesList(search); //填充页面模型数据 return(View(model)); //返回页面模型 }
/// <summary> /// 按条件查询试听课 /// </summary> /// <returns></returns> public ActionResult GeClass_transfe_List() { AjaxStatusModel ajax = new AjaxStatusModel(); ajax.status = EnumAjaxStatus.Error; //默认失败 ajax.msg = "获取失败!"; //前台获取,用于显示提示信息 ClassesListSearchModel search = new ClassesListSearchModel(); //页面模型 string ClassName = Request["ClassName"]; if (!string.IsNullOrEmpty(ClassName)) { search.ClassName = ClassName; } search.CurrentPage = 1; //当前页 search.PageSize = 999; //不想分页就设置成一个较大的值,比如99999 List <vw_Classes> vw_Enroll = ClassesData.GeClass_transfe_List(search); ajax.data = vw_Enroll; return(Json(new { total = 1, rows = vw_Enroll, state = true, msg = "加载成功" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 分页获取班级列表 /// </summary> /// <param name="search"></param> /// <returns></returns> public static PagedList <vw_Classes> GeClass_transfe_List(ClassesListSearchModel search) { string table = string.Empty, fields = string.Empty, orderby = string.Empty, where = string.Empty; //定义结构 fields = @" * "; //输出字段 table = @" vw_Classes "; //表或者视图 orderby = "ID"; //排序信息 StringBuilder sb = new StringBuilder(); //构建where条件 sb.Append(" 1=1 and StateID <> 4 "); if (!string.IsNullOrWhiteSpace(search.ClassName))//当前讲师 { sb.AppendFormat(" and ClassName like '%{0}%' ", search.ClassName); } where = sb.ToString(); int allcount = 0; var list = CommonPage <vw_Classes> .GetPageList( out allcount, table, fields : fields, where : where.Trim(), orderby : orderby, pageindex : search.CurrentPage, pagesize : search.PageSize, connect : DBKeys.PRX); return(new PagedList <vw_Classes>(list, search.CurrentPage, search.PageSize, allcount)); }
/// <summary> /// 分页获取班级列表 /// </summary> /// <param name="search"></param> /// <returns></returns> public static PagedList <vw_Classes> GeClassesList(ClassesListSearchModel search) { string table = string.Empty, fields = string.Empty, orderby = string.Empty, where = string.Empty; //定义结构 fields = @" * "; //输出字段 table = @" vw_Classes "; //表或者视图 orderby = "ID desc"; //排序信息 StringBuilder sb = new StringBuilder(); //构建where条件 sb.Append(" 1=1 "); if (!string.IsNullOrWhiteSpace(search.ComCode))//校区 { sb.AppendFormat(" and [ComCode] = '{0}' ", search.ComCode); } if (!string.IsNullOrWhiteSpace(search.ClassName))//班级名称或ID { sb.AppendFormat(" and (ClassName like '%{0}%' OR ID LIKE '%{0}%')", search.ClassName); } if (!string.IsNullOrWhiteSpace(search.CourseID))//课程名称ID { sb.AppendFormat(" and CourseID like '%{0}%' ", search.CourseID); } if (!string.IsNullOrWhiteSpace(search.CourseName))//课程名称中文 { sb.AppendFormat(" and CourseName like '%{0}%' ", search.CourseName); } if (!string.IsNullOrWhiteSpace(search.StartTime_start))//开班时间 { sb.AppendFormat(" and StartTime > = '{0}' ", search.StartTime_start); } if (!string.IsNullOrWhiteSpace(search.StartTime_end))//开班时间 { sb.AppendFormat(" and StartTime <= '{0}' ", search.StartTime_end); } if (!string.IsNullOrWhiteSpace(search.EndTime_start))//结班时间 { sb.AppendFormat(" and EndTime > = '{0}' ", search.EndTime_start); } if (!string.IsNullOrWhiteSpace(search.EndTime_end))//结班时间 { sb.AppendFormat(" and EndTime <= '{0}' ", search.EndTime_end); } if (!string.IsNullOrWhiteSpace(search.TeacherID))//当前讲师 { sb.AppendFormat(" and TeacherID = '{0}' or Teacher2ID = '{0}'", search.TeacherID); } if (search.islisten == "1")//如果是试听班 { sb.AppendFormat(" and TeachTypeID =1 "); } else if (search.islisten == "0")//不是试听班,报名班为了保证有学员课程表,只取未排班数据,以后根据实际情况改 { sb.AppendFormat(" and TeachTypeID > 1 "); } else { } if (search.TeachTypeID != 0 && search.TeachTypeID != null)//授课方式TeachTypeID { sb.AppendFormat(" and TeachTypeID = {0} ", search.TeachTypeID); } where = sb.ToString(); int allcount = 0; var list = CommonPage <vw_Classes> .GetPageList( out allcount, table, fields : fields, where : where.Trim(), orderby : orderby, pageindex : search.CurrentPage, pagesize : search.PageSize, connect : DBKeys.PRX); return(new PagedList <vw_Classes>(list, search.CurrentPage, search.PageSize, allcount)); }