/// <summary> /// 查看班级列表 /// </summary> public ActionResult ClassesList(int id) { NotifyViewData viewData = new NotifyViewData(); List<Classes> TempList = null; if (GetOrg().OrgType.ToString().Equals("1")) { TempList = (from c in CQGJ.Classes select c).ToList(); } if (GetOrg().OrgType.ToString().Equals("3")) { int OrgID = GetOrg().OrgID; TempList = (from c in CQGJ.Classes where c.Org.OrgID == OrgID select c).ToList(); } //取出了所有的列表 //下步是取出实际的列表 viewData.ClassesList = TempList.Skip((id - 1) * 20).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("ClassesList", viewData); }
/// <summary> /// 添加班级与单位通知 /// </summary> public ActionResult ClassNotifyAdd() { NotifyViewData viewData = new NotifyViewData(); viewData.NotifyList = (from n in CQGJ.Notify select n).ToList(); viewData.OrgList = from o in CQGJ.Org where o.OrgType == 2 select o; if (GetOrg().OrgType.ToString().Equals("1")) { viewData.ClassesList = (from c in CQGJ.Classes select c).ToList(); } if (GetOrg().OrgType.ToString().Equals("3")) { int OrgID = GetOrg().OrgID; viewData.ClassesList = (from c in CQGJ.Classes where c.Org.OrgID == OrgID select c).ToList(); } return View("NotifyAdd", viewData); }
/// <summary> /// 查看单位通知列表 /// </summary> public ActionResult OrgNotifyList(string id, int page) { NotifyViewData viewData = new NotifyViewData(); int OrgID = GetOrg().OrgID; List<Notify> TempList = null; if (GetOrg().OrgType.ToString().Equals("1")) { TempList = (from n in CQGJ.Notify from nm in CQGJ.NotifyMap from o in CQGJ.Org where nm.Notify.NotifyID == n.NotifyID && n.NotifyType == 2 && nm.ObjectID == o.OrgID && o.OrgCode == id select n).ToList(); viewData.NotifyList = TempList.Skip((page - 1) * 20).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("OrgNotifyList", viewData); } if (GetOrg().OrgType.ToString().Equals("2")) { // 取出发给ORG的Notify列表 TempList = (from n in CQGJ.Notify from nm in CQGJ.NotifyMap from o in CQGJ.Org where nm.Notify.NotifyID == n.NotifyID && n.NotifyType == 2 && nm.ObjectID == o.OrgID select n).AsEnumerable().Distinct().ToList(); viewData.NotifyList = TempList.Skip((page - 1) * 20).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("Org2NotifyList", viewData); } return null; }
public ActionResult OrgNotifyAdd() { NotifyViewData viewData = new NotifyViewData(); viewData.NotifyList = (from n in CQGJ.Notify select n).ToList(); viewData.OrgList = from o in CQGJ.Org where o.OrgType == 2 select o; return View("OrgNotifyAdd", viewData); }
/// <summary> /// 查看单位列表 /// </summary> public ActionResult OrgList(int id) { NotifyViewData viewData = new NotifyViewData(); var TempList = from o in CQGJ.Org where o.OrgType == 2 orderby o.OrgID select o; viewData.OrgList = TempList.Skip((id - 1) * 20).Take(20); UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("OrgList", viewData); }
/// <summary> /// 查看班级通知列表 /// </summary> public ActionResult NotifyList(int id, int page) { NotifyViewData viewData = new NotifyViewData(); //int ClassID = GetInt("ClassID"); List<Notify> TempList = null; TempList = (from n in CQGJ.Notify from nm in CQGJ.NotifyMap where n.NotifyID == nm.Notify.NotifyID && nm.ObjectID == id select n).ToList(); viewData.NotifyList = TempList.Skip((page - 1) * 20).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("NotifyList", viewData); }
/// <summary> /// 查看班级通知 /// </summary> /// <param name="id">班级通知ID</param> public ActionResult NotifyEdit(int id) { NotifyViewData viewData = new NotifyViewData(); viewData.Notify = (from n in CQGJ.Notify where n.NotifyID == id select n).First(); int? notifyType = viewData.Notify.NotifyType; if (notifyType == 1) { if (GetOrg().OrgType.ToString().Equals("1")) { viewData.ClassesList = (from c in CQGJ.Classes select c).ToList(); // modified by 陈建平 2008.7.14 // 获取所有班级, 若该班级存在ID为id的班级通知, // 则ClassNotify的MapNotifyMap属性为ID=id的NotifyMap, // 否则ClassNotifyMap的MapNotifyMap为null viewData.ClassNotifyList = (from c in CQGJ.Classes join nm in CQGJ.NotifyMap on c.ClassID equals nm.ObjectID into o select new ClassNotifyMap { Class = c, NotifyMap = o.Where(n => n.Notify.NotifyID == id).FirstOrDefault() }).ToList(); } if (GetOrg().OrgType.ToString().Equals("3")) { int OrgID = GetOrg().OrgID; viewData.ClassesList = (from c in CQGJ.Classes where c.Org.OrgID == OrgID select c).ToList(); // modified by 陈建平 2008.7.14 // 获取所有班级, 若该班级存在ID为id的班级通知, // 则ClassNotify的MapNotifyMap属性为ID=id的NotifyMap, // 否则ClassNotifyMap的MapNotifyMap为null viewData.ClassNotifyList = (from c in CQGJ.Classes join nm in CQGJ.NotifyMap on c.ClassID equals nm.ObjectID into o where c.Org.OrgID == OrgID select new ClassNotifyMap { Class = c, NotifyMap = o.Where(n => n.Notify.NotifyID == id).FirstOrDefault() }).ToList(); } } else { viewData.OrgNotifyMapList = (from o in CQGJ.Org join nm in CQGJ.NotifyMap on o.OrgID equals nm.ObjectID into a select new OrgNotifyMap { Org = o, NotifyMap = a.Where(n => n.Notify.NotifyID == id).FirstOrDefault() }).ToList(); } return View("NotifyEdit", viewData); }