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