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