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()); }
//-记得修改stuid public string GetMyTask(int stuId) { //int stuId = (int)Session["userId"]; //int stuId = 4; string where = "StuId = " + stuId; DALT_Event_MyTask dal = new DALT_Event_MyTask(); List <T_Event_MyTask> list = new List <T_Event_MyTask>(); list = dal.GetAllList(where);//传参数where string res = ""; foreach (T_Event_MyTask item in list) { if (item.State == 1) { continue; } string st = ((DateTime)item.StartTime).ToString("yyyy-MM-dd HH:mm"); string ed = ((DateTime)item.EndTime).ToString("yyyy-MM-dd HH:mm"); res += "{\"id\":\"" + item.Id + "\",\"title\":\"" + item.Name + "\",\"start\":\"" + st + "\",\"type\":\"" + item.Type + "\",\"end\":\"" + ed + "\"}"; res += ","; } return(res); }
public string GetOneMyTask(int id) { DALT_Event_MyTask dal = new DALT_Event_MyTask(); T_Event_MyTask item = dal.GetModel(id); string res = "["; int taskAlert = 0; if (item.IsAlert != 0) { taskAlert = (int)item.AlertTime; } res += "{\"type\":\"" + item.Type + "\",\"des\":\"" + item.Description + "\",\"taskAlert\":\"" + taskAlert + "\",\"userid\":\"" + item.StuId + "\"}"; res += ","; if (res.Count() >= 1) { res = res.Substring(0, res.Count() - 1); } res += "]"; return(res); }
//删除我的日程 public int DeleteMyTask(int taskid) { bool res; DALT_Event_MyTask dal = new DALT_Event_MyTask(); res = dal.Delete(taskid); if (res) { return(1); } else { return(0); } }
public List <T_Search_Event> SearchMyTask(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),StartTime,120) = '" + start + "'"; } string where = "StuId = " + searchid + wtitel + wstart; DALT_Event_MyTask dal = new DALT_Event_MyTask(); List <T_Event_MyTask> lst = dal.GetAllList(where); List <T_Search_Event> list = new List <T_Search_Event>(); #region 转换成现实格式 foreach (T_Event_MyTask item in lst) { T_Search_Event now = new T_Search_Event(); now.Name = item.Name; now.StartTime = (DateTime)item.StartTime; now.EndTime = (DateTime)item.EndTime; now.Description = item.Description; if (item.IsAlert == 1) { now.AlertTime = (int)item.AlertTime; } else { now.AlertTime = 0; } now.Type = item.Type; list.Add(now); } #endregion return(list); }
//新建我的日程 public int AddMyTask(string title, int type, string des, string start, string end, int alert, int userid = -1, int state = 0) { if (title == "") { return(1); } else if (userid == -1) { return(2); } #region 我的日程创建 DALT_Event_MyTask dal = new DALT_Event_MyTask(); T_Event_MyTask item = new T_Event_MyTask(); item.State = state; item.Name = title; item.Type = type; item.Description = des; item.StuId = userid; item.StartTime = Convert.ToDateTime(start); item.EndTime = Convert.ToDateTime(end); if (alert == 0) { item.IsAlert = 0; } else { item.IsAlert = 1; item.AlertTime = alert; } int res = dal.Add(item); #endregion if (res != 0) { return(0); } else { return(3); } }
//修改我的日程 public int EditMyTask(string title, int type, string des, string start, string end, int alert, int taskid, int userid = -1) { if (title == "") { return(1); } else if (userid == -1) { return(2); } #region 我的日程修改 DALT_Event_MyTask dal = new DALT_Event_MyTask(); T_Event_MyTask item = new T_Event_MyTask(); item.Id = taskid; item.StuId = userid;//学生Id,之后修改 item.Name = title; item.Type = type; item.Description = des; item.StartTime = Convert.ToDateTime(start); item.EndTime = Convert.ToDateTime(end); if (alert == 0) { item.IsAlert = 0; } else { item.IsAlert = 1; item.AlertTime = alert; } bool res = dal.Update(item); #endregion if (res) { return(0); } else { return(3); } }