/// <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));
}
