public void Delete(string[] ids) { DALT_Base_Student dal = new DALT_Base_Student(); DAL.DALT_Event_CourseTask dal2 = new DALT_Event_CourseTask(); DAL.DALT_ClassTask_Stu dal3 = new DALT_ClassTask_Stu(); string str = string.Join(",", ids);//将数组转化为string,中间用","隔开 bool res = dal.DeleteList(str); //int[] ids2 = new int[ids.Length]; /*for(int i=0;i<ids.Length;i++) //wx * { * ids2[i] = Integer.parseInt(ids[i]); * } * for (int i=0;i<ids.Length;i++) * { * if(dal2.ExistsStu(ids[i])==true) * }*/ if (res) { string tmp = "{\"statusCode\":\"200\",\"message\":\"删除成功\",\"navTabId\":\"StudentList\",\"rel\":\"StudentList\",\"callbackType\":\"\",\"forwardUrl\":\"\"}"; Response.Write(tmp); } else { string tmp = "{\"statusCode\":\"300\",\"message\":\"删除失败\",\"navTabId\":\"StudentList\",\"rel\":\"StudentList\",\"callbackType\":\"\",\"forwardUrl\":\"\"}"; Response.Write(tmp); } }
public ActionResult TetT() { if (Session["UserId"] == null) { return(Redirect("/Login/Login/Index")); } int Teaid = (int)Session["UserId"]; List <T_Task_Course> list = FindAllCourse(Teaid); DateTime d = DateTime.Now; //wx int id = (int)Session["UserId"]; DAL.DALT_Event_MyTask dal = new DALT_Event_MyTask(); DAL.DALT_Event_ClassTask dal2 = new DALT_Event_ClassTask(); DAL.DALT_Event_CourseTask dal3 = new DALT_Event_CourseTask(); List <T_Event_ClassTask> list3 = dal2.FindListT(d, id); List <T_Event_CourseTask> list4 = dal3.FindListT(d, id); List <T_Event_MyTask> list2 = dal.FindList(d, id); ViewBag.list2 = list2; ViewBag.list3 = list3; ViewBag.list4 = list4; ViewBag.list = list; return(View()); }
//王一情 public string GetOneCourseTask(int id) { DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); T_Event_CourseTask item = dal.GetModel(id); //DALT_Task_Course dal_cou = new DALT_Task_Course(); //T_Task_Course course = new T_Task_Course(); //course = dal_cou.GetModel(courseId); #region 连接传回数据 string res = "["; int taskAlert = 0; if (item.IsAlert != 0) { taskAlert = (int)item.IsAlert; //是否提醒 } res += "{\"type\":\"" + item.Type + "\",\"des\":\"" + item.Description + "\",\"taskalert\":\"" + taskAlert + "\",\"title\":\"" + "shu" + "\"}"; res += ","; if (res.Count() >= 1) { res = res.Substring(0, res.Count() - 1); } res += "]"; #endregion return(res); }
public List <T_Search_Event> SearchCourseTask(int searchid, int userLevel, string title, string start) { string wtitel = ""; string wstart = ""; if (title != "") { wtitel = " and Name like'%" + title + "%'"; } if (start != "") { wstart = " and convert(varchar(10),StartWeek,120) = '" + start + "'"; } string where = ""; DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); List <T_Search_Event> lst = new List <T_Search_Event>(); if (!(userLevel == 10 || userLevel == 11)) { where += "StuId = " + searchid + wtitel + wstart; lst = dal.GetAllSearch(0, where); } else { where += "TeaId = " + searchid + wtitel + wstart; lst = dal.GetAllSearch(1, where); } return(lst); }
//王一情 public int DeleteCourseTask(int taskid) { DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); dal.Delete(taskid); return(1); }
public int GetAllTime(DateTime start, DateTime end, DateTime start_date, int userid, int week_type, int week_number) { #region 判断课程和课程冲突 //王一情 需要先找到这个老师所教的所有课程,然后进行冲突判断 DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); List <T_Event_CourseTask> course_list = dal.GetTeaCourseList2(userid); DateTime st = start_date; string ym = st.ToString("yyyy-MM-dd"); string strSt = ym + " " + start.ToLongTimeString().ToString(); string strEn = ym + " " + end.ToLongTimeString().ToString(); DateTime newSt = Convert.ToDateTime(strSt); DateTime newEn = Convert.ToDateTime(strEn); foreach (T_Event_CourseTask item in course_list) { if (item.State == 1) { continue; } DateTime st2 = (DateTime)item.StartWeek; string om = st2.ToString("yyyy-MM-dd"); string strSt2 = om + " " + Convert.ToDateTime(item.StartTime).ToLongTimeString().ToString(); string strEn2 = om + " " + Convert.ToDateTime(item.EndTime).ToLongTimeString().ToString(); DateTime oldSt = Convert.ToDateTime(strSt2); DateTime oldEn = Convert.ToDateTime(strEn2); if (!(newSt >= oldEn || newEn <= oldSt)) { return(0); } } #endregion #region 判断课程和班级冲突 //王一情 //需要先通过courseid找到选这个课的学生的班级,然后查找班级日程 DALT_Event_ClassTask classdal = new DALT_Event_ClassTask(); List <T_Event_ClassTask> classList = classdal.GetTeaClassList2(userid); foreach (T_Event_ClassTask item in classList) { if (item.State == 1) { continue; } if (!(newSt >= item.EndTime || newEn <= item.StartTime)) { return(0); } } #endregion return(1); }
//-班级和课程冲突判定 public int IsChongtu(int taskid, string start, string end) { DateTime dt_start = Convert.ToDateTime(start); DateTime dt_end = Convert.ToDateTime(end); #region 判断班级和班级冲突 DALT_Event_ClassTask dal = new DALT_Event_ClassTask(); List <T_Event_ClassTask> class_list = dal.GetAllList(); foreach (T_Event_ClassTask item in class_list) { if (taskid == item.Id || item.State == 1) { continue; } if (!(dt_start >= (DateTime)item.EndTime || dt_end <= (DateTime)item.StartTime)) { return(0); } } #endregion #region 判断班级和课程冲突 DALT_Event_CourseTask coursedal = new DALT_Event_CourseTask(); List <T_Event_CourseTask> course_list = coursedal.GetAllList(); foreach (T_Event_CourseTask item in course_list) { if (item.State == 1) { continue; } DateTime st = (DateTime)item.StartWeek; string ym = st.ToString("yyyy-MM-dd"); string strSt = ym + " " + item.StartTime; string strEn = ym + " " + item.EndTime; DateTime newSt = Convert.ToDateTime(strSt); DateTime newEn = Convert.ToDateTime(strEn); if (!(dt_start >= newEn || dt_end <= newSt)) { return(0); } } #endregion return(1); }
//王一情 public int EditCourseTask(string title, int type, string des, DateTime start, DateTime end, int alert, int userid, int taskid) { if (title == "") { return(1); } else if (userid == -1) { return(2); } #region 课程日程修改 DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); T_Event_CourseTask item = new T_Event_CourseTask(); T_Event_CourseTask course_task = new T_Event_CourseTask(); course_task = dal.GetModel(taskid); item.Id = taskid; item.State = 0; item.Type = type; item.Description = des; item.StartTime = start.ToLongTimeString().ToString(); item.EndTime = end.ToLongTimeString().ToString(); item.WPeople = course_task.WPeople; item.CourseId = course_task.CourseId; item.StartWeek = start; item.WeekNum = 1; if (alert == 0) { item.IsAlert = 0; } else { item.IsAlert = 1; item.IsAlert = alert; } #endregion bool res = dal.Update(item); if (res) { return(0); } else { return(3); } }
//王一情 //冲突检测(自己和自己不存在冲突——吴佳洁) public int IsCouChongtu2(DateTime start, DateTime end, int taskid, int userid) { #region 判断课程和课程冲突 //王一情 需要先找到这个老师所教的所有课程,然后进行冲突判断 DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); List <T_Event_CourseTask> course_list = dal.GetTeaCourseList2(userid); foreach (T_Event_CourseTask item in course_list) { //王一情 if (item.State == 1 || taskid == item.Id) { continue; } DateTime st2 = (DateTime)item.StartWeek; string om = st2.ToString("yyyy-MM-dd"); string strSt2 = om + " " + Convert.ToDateTime(item.StartTime).ToLongTimeString().ToString(); string strEn2 = om + " " + Convert.ToDateTime(item.EndTime).ToLongTimeString().ToString(); DateTime oldSt = Convert.ToDateTime(strSt2); DateTime oldEn = Convert.ToDateTime(strEn2); if (!(start >= oldEn || end <= oldSt)) { return(0); } } #endregion #region 判断课程和班级冲突 //王一情 //需要先通过courseid找到选这个课的学生的班级,然后查找班级日程 DALT_Event_ClassTask classdal = new DALT_Event_ClassTask(); List <T_Event_ClassTask> classList = classdal.GetTeaClassList2(userid); foreach (T_Event_ClassTask item in classList) { if (item.State == 1) { continue; } if (!(start >= item.EndTime || end <= item.StartTime)) { return(0); } } #endregion return(1); }
//王一情 public string GetCourseTask(int userid, int userlevel) { T_Base_Teacher teacher = new T_Base_Teacher(); DALT_Base_Teacher dal_Teacher = new DALT_Base_Teacher(); teacher = dal_Teacher.GetModel(userid); DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); List <T_Event_CourseTask> list = new List <T_Event_CourseTask>(); if (userlevel != 10 && userlevel != 11) { list = dal.GetStuCourseList(userid); } else { list = dal.GetTeaCourseList("WPeople=" + "'" + teacher.Name + "'"); } string res = ""; foreach (T_Event_CourseTask item in list) { T_Task_Course course = new T_Task_Course(); DALT_Task_Course dal_course = new DALT_Task_Course(); course = dal_course.GetModel(item.CourseId); string st_date = ((DateTime)item.StartWeek).ToString("yyyy-MM-dd"); string st = st_date + " " + item.StartTime; string ed = st_date + " " + item.EndTime; res += "{\"id\":\"" + item.Id + "\",\"title\":\"" + course.Name + "\",\"type\":\"" + item.Type + "\",\"des\":\"" + item.Description + "\",\"start\":\"" + st + "\",\"end\":\"" + ed + "\"}"; res += ","; } return(res); }
//王一情,并且把那个GetCourseTask放到了其他地方 public int AddCourseTask(int type, string des, DateTime start, DateTime end, int taskalert, DateTime start_date, int week_type, int week_number, int userid, int choose_course) { T_Base_Teacher teacher = new T_Base_Teacher(); DALT_Base_Teacher dal_teacher = new DALT_Base_Teacher(); //王一情 teacher = dal_teacher.GetModel(userid); T_Event_CourseTask model = new T_Event_CourseTask(); model.Type = type; model.IsAlert = taskalert; model.CourseId = choose_course; model.Description = des; model.EndTime = end.ToLongTimeString().ToString(); model.StartTime = start.ToLongTimeString().ToString(); model.StartWeek = start_date; model.State = 0; model.WeekNum = week_number; model.WeekType = week_type; model.WPeople = teacher.Name; DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); //循环添加课程日程 int result = 0; if (model.WeekNum == 1) { result = dal.Add(model); } //如果有循环的话 else if (model.WeekNum > 1) { for (int i = 1; i <= model.WeekNum; i++) { //如果不分单双周 if (model.WeekType == 0) { result = dal.Add(model); model.StartWeek = start_date.AddDays(7 * i); } //如果单周 else if (model.WeekType == 1) { result = dal.Add(model); model.StartWeek = start_date.AddDays(14 * i); } //如果双周 else if (model.WeekType == 2) { model.StartWeek = start_date.AddDays(14 * (i - 1) + 7); result = dal.Add(model); } } } if (result > 0) { return(2); } return(0); }