/// <summary> /// 保存编辑班级表 /// </summary> /// <param name="json"></param> /// <returns></returns> public JsonResult SaveClasses() { AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel,数据放到AjaxStatusModel.data中,前台获取json后加载 ajax.status = EnumAjaxStatus.Error; //默认失败 ajax.msg = "保存失败!"; //前台获取,用于显示提示信息 var data = Request["data"]; //获取前台传递的数据,主要序列化 if (string.IsNullOrEmpty(data)) { return(Json(ajax)); } Classes Clas = (Classes)(JsonConvert.DeserializeObject(data.ToString(), typeof(Classes))); Clas.UpdateTime = DateTime.Now; Clas.UpdatorId = UserSession.userid; if (ClassesData.Update_Classes(Clas)) { ajax.msg = "保存成功!"; ajax.status = EnumAjaxStatus.Success; } return(Json(ajax)); }
/// <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 JsonResult AddClasses() { AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel,数据放到AjaxStatusModel.data中,前台获取json后加载 ajax.status = EnumAjaxStatus.Error; //默认失败 ajax.msg = "新增失败!"; //前台获取,用于显示提示信息 var data = Request["data"]; //获取前台传递的数据,主要序列化 if (string.IsNullOrEmpty(data)) { return(Json(ajax)); } Classes Clas = (Classes)(JsonConvert.DeserializeObject(data.ToString(), typeof(Classes))); Classes query = ClassesData.GetClassesList();//获取创建时间最新的一条数据 string MAX_ID; if (query != null) { MAX_ID = query.ID; } else { MAX_ID = null; } var year = DateTime.Now.Year.ToString(); if (!string.IsNullOrEmpty(MAX_ID)) { Clas.ID = "CL" + year + (Convert.ToInt32(MAX_ID.Substring(6)) + 1).ToString().PadLeft(4, '0'); } else { Clas.ID = "CL" + year + "0001"; } Clas.PresentLesson = 0; //已上课时 Clas.StateID = 1; //状态 Clas.CreateTime = DateTime.Now; //创建时间 Clas.CreatorId = UserSession.userid; //创建人 if (ClassesData.AddStudent(Clas) != "")//注意时间类型,而且需要在前台把所有的值 { ajax.msg = "新增成功!"; ajax.status = EnumAjaxStatus.Success; } return(Json(ajax)); }
/// <summary> /// 保存编辑转班 /// </summary> /// <param name="json"></param> /// <returns></returns> public JsonResult SaveClass_transfe() { AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel,数据放到AjaxStatusModel.data中,前台获取json后加载 ajax.status = EnumAjaxStatus.Error; //默认失败 ajax.msg = "保存失败!"; //前台获取,用于显示提示信息 string Classes_ID = Request["Classes_ID"]; //班级ID,班级号(新) string Enroll_ID = Request["Enroll_ID"]; //报名表主键 string Enroll_StudentID = Request["Enroll_StudentID"]; //报名表学员号 string Enroll_ClassID = Request["Enroll_ClassID"]; //报名表班级ID(旧) if (string.IsNullOrEmpty(Classes_ID)) { return(Json(ajax)); } if (string.IsNullOrEmpty(Enroll_ID)) { return(Json(ajax)); } if (string.IsNullOrEmpty(Enroll_StudentID)) { return(Json(ajax)); } if (string.IsNullOrEmpty(Enroll_ClassID)) { return(Json(ajax)); } DataProvider.Entities.Enroll en = new DataProvider.Entities.Enroll(); en.ClassID = Classes_ID; en.ID = Enroll_ID; en.UpdateTime = DateTime.Now; en.UpdatorId = UserSession.userid; ClassesTrans ct = new ClassesTrans(); ct.CreateTime = DateTime.Now; ct.CreatorId = UserSession.userid; ct.StudentID = Enroll_StudentID; ct.ClassFrom = Enroll_ClassID; ct.ClassTo = Classes_ID; ct.ENID = Enroll_ID; //报名单号 if (ClassesData.SaveClass_transfe(en, ct)) //注意时间类型,而且需要在前台把所有的值 { ajax.msg = "保存成功!"; ajax.status = EnumAjaxStatus.Success; } return(Json(ajax)); }
/// <summary> /// 根据班级号ID获取详细信息 /// </summary> /// <param name="ID"></param> /// <returns></returns> public JsonResult GetClassesByID(string id) { AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel,数据放到AjaxStatusModel.data中,前台获取json后加载 ajax.status = EnumAjaxStatus.Error; //默认失败 ajax.msg = "获取失败!"; //前台获取,用于显示提示信息 Classes Clas = ClassesData.GetClassesByID(id); //业务层获取底层方法,返回数据 if (Clas != null) { ajax.data = Clas;//放入数据 ajax.status = EnumAjaxStatus.Success; ajax.msg = "获取成功!"; } return(Json(ajax)); }
/// <summary> /// 升班的操作,为了不影响之前的报名数据,所有生成的新的报名记录,然后生成转班记录记录当时发生情况,然后还要添加差价记录 /// 只能升到未排课的班级,升班之后需重新排课 /// </summary> /// <returns></returns> public ActionResult UpgradeClass() { AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel,数据放到AjaxStatusModel.data中,前台获取json后加载 ajax.status = EnumAjaxStatus.Error; //默认失败 ajax.msg = "保存失败!"; //前台获取,用于显示提示信息 string oldclassid = Request["oldclassid"]; //旧的班级号 string newclassid = Request["newclassid"]; //新的班级号 string did = Request["did"]; //升班的学员记录 JArray ja = (JArray)JsonConvert.DeserializeObject(did); if (ClassesData.UpClass(oldclassid, newclassid, ja, UserSession.userid)) { ajax.status = EnumAjaxStatus.Success; ajax.msg = "升班成功!请重新进行排课操作!"; } return(Json(ajax)); }
/// <summary> /// 删除 /// </summary> /// <param name="json"></param> /// <returns></returns> public JsonResult DELETE() { AjaxStatusModel ajax = new AjaxStatusModel(); //功能操作类的返回类型都是AjaxStatusModel,数据放到AjaxStatusModel.data中,前台获取json后加载 ajax.status = EnumAjaxStatus.Error; //默认失败 ajax.msg = "删除失败!"; //前台获取,用于显示提示信息 var ID = Request["ID"]; //获取前台传递的数据,主要序列化 if (string.IsNullOrEmpty(ID)) { return(Json(ajax)); } if (ClassesData.DELETE_Classes(ID, UserSession.userid, DateTime.Now) > 0)//注意时间类型,而且需要在前台把所有的值 { ajax.msg = "删除成功!"; ajax.status = EnumAjaxStatus.Success; } return(Json(ajax)); }
/// <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)); }
public void DeleteClassById(int id) { ClassesData classData = new ClassesData(CurrentDataContext); classData.DeleteClass(id); }
public void EditClass(Class editClass) { ClassesData classData = new ClassesData(CurrentDataContext); classData.UpdateClass(editClass); }
public int AddClass(Class newClass) { ClassesData classData = new ClassesData(CurrentDataContext); return(classData.AddClass(newClass)); }
public List <Class> GetAll() { ClassesData cData = new ClassesData(CurrentDataContext); return(cData.GetAll()); }