/// <summary> /// 查看班级列表 /// </summary> public void ClassesList(int id) { CQGJClassesListViewData viewData = new CQGJClassesListViewData(); passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport(); string OrgType = HttpContext.Session["OrgType"].ToString(); List<Classes> TempList=null; if (OrgType.Equals("1")) { TempList = (from c in CQGJ.Classes select c).ToList(); } if (OrgType.Equals("3")) { int OrgID = int.Parse(HttpContext.Session["OrgID"].ToString()); 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; RenderView("ClassesList", viewData); }
/// <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 void SchoolList(int? id) { SchoolSchoolListViewData viewData = new SchoolSchoolListViewData(); passport.CQGJPassport cqgjp = new CQGJ.passport.CQGJPassport(); var Schools = cqgjp.GetSchoolOrglist(); viewData.Schools = Schools.Skip(20 * (id.Value - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(Schools.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; RenderView("SchoolList", viewData); }
public void DocReceiveSearch(int? id) { if(id!=null) { string DocTitle = GetString("DocTitle"); int PubDate = GetInt("Year"); string YearNo=GetString("YearNo"); string TeamNo=GetString("TeamNo"); string WordNo=GetString("WordNo"); if (PubDate == 0) PubDate = 2008; /* int? status=0; try { status = (int?)GetInt("Status"); } catch { }*/ DocReceiveSearchViewData viewData = new DocReceiveSearchViewData() { SearchKey = new Dictionary<string, string>(),StatusKey=new Dictionary<int,string>() }; int iOrgID = GetOrgID(); IQueryable<DocReceiveCell> TempList = null; IQueryable<Doc> docs = CQGJ.Doc; if (DocTitle != "") { TempList = (from c in CQGJ.Doc from dt in c.DocTreat select new DocReceiveCell { doc = c, doctreat = dt }).Where(c => c.doc.DocTitle.StartsWith(DocTitle) || c.doc.DocTitle.Contains(DocTitle) || c.doc.DocTitle.EndsWith(DocTitle)); } else { TempList = (from c in CQGJ.Doc from dt in c.DocTreat select new DocReceiveCell { doc = c, doctreat = dt }); } if (YearNo != "") { TempList = TempList.Where(c => c.doc.YearNo == YearNo); } if (WordNo != "") { TempList = TempList.Where(c => c.doc.WordNo == WordNo); } if (TeamNo != "") { TempList = TempList.Where(c => c.doc.TeamNo == TeamNo); } /* if (DocTitle != "" && status != 123456)//单状态 有标题 { TempList = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID && (c.DocTitle.Contains(DocTitle) || c.DocTitle.EndsWith(DocTitle) || c.DocTitle.StartsWith(DocTitle) ) && c.PubDate.Value.Year == PubDate && dt.TreatType == status orderby c.PubDate descending select new DocReceiveCell { doc = c, doctreat = dt }).ToList(); }else if (DocTitle!= "" && status==123456)//全体状态 有标题 { TempList = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID && (c.DocTitle.Contains(DocTitle) || c.DocTitle.EndsWith(DocTitle) || c.DocTitle.StartsWith(DocTitle) )&& c.PubDate.Value.Year == PubDate orderby c.PubDate descending select new DocReceiveCell { doc = c, doctreat = dt }).ToList(); }else if(DocTitle=="" && status!=123456)//无标题 单状态 { TempList = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID && c.PubDate.Value.Year == PubDate && dt.TreatType==status orderby c.PubDate descending select new DocReceiveCell { doc = c, doctreat = dt }).ToList(); }else if(DocTitle=="" && status==123456)//无标题 全状态 { TempList = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID && c.PubDate.Value.Year == PubDate orderby c.PubDate descending select new DocReceiveCell { doc = c, doctreat = dt }).ToList(); } */ TempList = TempList.Where(c => c.doctreat.Org.OrgID == iOrgID); TempList = TempList.OrderBy(c => c.doc.PubDate); viewData.Docs = TempList.Skip((id.Value - 1) * 15).Take(15).ToList(); UrlManager urlManager = new DefaultUrlManager(TempList.Count(), 15); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; viewData.SearchKey.Add("DocTitle", DocTitle); viewData.SearchKey.Add("PubData", YearNo); viewData.SearchKey.Add("WordNo", WordNo); viewData.SearchKey.Add("TeamNo", TeamNo); viewData.StatusKey.Add(0, "Published"); viewData.StatusKey.Add(1, "Registed"); viewData.StatusKey.Add(2, "Downloaded"); viewData.StatusKey.Add(3, "Treated"); viewData.StatusKey.Add(4, "Treated"); viewData.StatusKey.Add(5, "FightBack"); viewData.StatusKey.Add(6, "End"); RenderView("DocReceiveSearch", viewData); } }
public void DocTreatIndex(int? id) { if (id != null) { DocReceiveTreatViewData viewData = new DocReceiveTreatViewData(); int iOrgID = GetOrgID(); int? Published = (int?)DocProcessStatus.Published; int? Registed = (int?)DocProcessStatus.Registered; int? Treated = (int?)DocProcessStatus.Treated; int? Downloaded = (int?)DocProcessStatus.Downloaded; viewData.DocTreats = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID select dt).ToList(); //待接收公文 viewData.Doc1 = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID && dt.TreatType == Published orderby c.PubDate descending select c).ToList(); //待处理公文 viewData.Doc2 = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID && (dt.TreatType == Registed || dt.TreatType == Downloaded) orderby c.PubDate descending select c).ToList(); //已处理公文 var tempList = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID && dt.TreatType >= Treated orderby c.PubDate descending select c); viewData.Doc3 = tempList.Skip((id.Value - 1) * 15).Take(15).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 15); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; RenderView("DocTreatIndex", viewData); } }
/// <summary> /// 次级页面 /// </summary> /// <param name="id"></param> public ActionResult Category(int? id, int? page) { if (id != null && page != null) { var column = (from c in CQGJ.Column where c.ColumnID == id select c).First(); ViewData["ColumnName"] = column.ColumnName; HomeCategoryViewData viewData = new HomeCategoryViewData(); //下一部分代码 viewData.sigColumn = (from c in CQGJ.Column where c.ColumnID == id select c).First(); viewData.lsHotNews = (from hn in CQGJ.News where hn.IsNotify == false && hn.IsApproved == true && hn.Status == (int?)NewsStatus.Approved orderby hn.PubDate descending select hn).Take(6).ToList(); viewData.lsCountNews = (from cn in CQGJ.News where cn.IsNotify == false && cn.IsApproved == true && cn.Status == (int?)NewsStatus.Approved orderby cn.ViewNum descending select cn).Take(5).ToList(); //需要对lsNews进行分页 var tempList = (from n in CQGJ.News from nc in n.NewsColumn where nc.Column.ColumnID == id && n.IsApproved == true && n.IsNotify == false && n.Status == (int?)NewsStatus.Approved orderby n.PubDate descending select n); //截取 viewData.lsNews = tempList.Skip(30 * (page.Value - 1)).Take(30).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 30); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("Category", viewData); } else { return RedirectToAction("Index"); } }
/// <summary> /// 班级园地 - 搜索班级 /// </summary> public ActionResult SearchClass(int id) { HomeCCViewData viewData = new HomeCCViewData(); //最新班级 viewData.LatestClass = (from c in CQGJ.Classes orderby c.BeginDate descending select c).Take(8).ToList(); string key = GetString("keyword"); if (key != "") { var result = from c in CQGJ.Classes where c.ClassName.Contains(key) orderby c.BeginDate descending select c; viewData.ClassList = result.Skip(20 * (id - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(result.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("ClassList", viewData); } else { return View("ClassList", viewData); } }
//公告通知列表 public ActionResult NoticeList(int page) { if (page > 0) { HomeCategoryViewData viewData = new HomeCategoryViewData(); viewData.lsHotNews = (from hn in CQGJ.News where hn.IsNotify == false && hn.IsApproved == true && hn.Status == (int?)NewsStatus.Approved orderby hn.PubDate descending select hn).Take(5).ToList(); viewData.lsCountNews = (from cn in CQGJ.News where cn.IsNotify == false && cn.IsApproved == true && cn.Status == (int?)NewsStatus.Approved orderby cn.ViewNum descending select cn).Take(5).ToList(); //需要对list进行分页 var tempList = (from n in CQGJ.News where n.IsNotify == true orderby n.PubDate descending select n); //截取 viewData.NoticeList = tempList.Skip(20 * (page - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("NoticeList", viewData); } else { return RedirectToAction("Index"); } }
/// <summary> /// 分页显示回帖信息 /// </summary> /// <param name="id"></param> public void ShowItemDetailByPager(int id, int page) { BBSItemListViewData BBSILVD = new BBSItemListViewData(); BBSItemListViewData replyPerPage = new BBSItemListViewData(); try { BBSILVD = GetItemDetailInfoByID(id); // 根据BBSItem的ID取出该条BBSItem的内容 BBSILVD.BBSItem = (from bi in CQGJ.BBSItem where bi.ItemID == id select bi).First(); // 查看次数加1 BBSILVD.BBSItem.ViewCount = BBSILVD.BBSItem.ViewCount + 1; CQGJ.SaveChanges(); // 计算回复条数 int count = 0; count = BBSILVD.BBSItemInfo.Count(); // 分页中发起帖的信息 replyPerPage.TopicItemInfo = new BBSItemInfo { TopicBBSItem = BBSILVD.TopicItemInfo.TopicBBSItem, Author=BBSILVD.TopicItemInfo.Author }; // 定义回复帖信息列表 replyPerPage.BBSItemInfo = new List<BBSItemInfo>(); // 设置每页的BBSItem和信息,即Item的条数等信息 replyPerPage.BBSItemInfo = BBSILVD.BBSItemInfo.Skip(6 * (page - 1)).Take(6).ToList(); // 该BBSItem所属的BBS的信息, replyPerPage.BBSID 简要标明该BBSItem所属BBS的ID // replyPerPage.BBSInfo 为该BBSItem所属BBS的详细信息 replyPerPage.BBSID = BBSILVD.BBSID; replyPerPage.BBSInfo = GetBBSByBBSID(BBSILVD.BBSID).BBS; // 设置分页信息 UrlManager urlManager = new DefaultUrlManager(count, 6); Pager pager = new Pager(urlManager); replyPerPage.PagerString = pager.PagerString; } catch(Exception ex) { Response.Write(ex.Message); } RenderView("ShowItemDetail", replyPerPage); }
/// <summary> /// 分页显示公共论坛的item /// </summary> /// <param name="id">PublicBBS id</param> /// <param name="page">分页页码</param> public void ListPublicBBSByPage(int id, int page) { int nbrOfPerPage = 10; int count = 0; HttpContext.Session["CurrentBBSID"] = id; BBSItemListViewData BBSItems = ListBBSItemsByBBSID(id); // 设置游客信息 if (HttpContext.Session["userobject"] == null) { BBSItems.User = new CQGJ.passport.User { UserID = -1, Username = "******" }; HttpContext.Session["userobject"] = BBSItems.User; } count = BBSItems.BBSItemInfo.Count(); BBSItemListViewData perPage = new BBSItemListViewData(); perPage.BBSItemInfo = BBSItems.BBSItemInfo.Skip(nbrOfPerPage * (page - 1)).Take(nbrOfPerPage).ToList(); perPage.BBSID = BBSItems.BBSID; perPage.BBSInfo = BBSItems.BBSInfo; perPage.User = BBSItems.User; UrlManager urlManager = new DefaultUrlManager(count); Pager pager = new Pager(urlManager); perPage.PagerString = pager.PagerString; RenderView("ListPublicBBS", perPage); }
/// <summary> /// 根据BBS论坛ID以前ParentID=-1来分页显示BBS论坛的所有Topic /// </summary> /// <param name="id">该论坛的ID</param> public void ListBBSItemsByPage(int id, int page) { // 定义BBSItemViewData用来保存BBS Topic的列表 BBSItemListViewData BBSItemViewData = new BBSItemListViewData(); BBSItemViewData.BBSID = id; HttpContext.Session["CurrentBBSID"] = id; // count 保存item的总条数 int count = 0; try { // 获取该BBS的相关信息 BBSItemViewData.BBSInfo = (from b in CQGJ.BBS where b.BBSID == id select b).FirstOrDefault(); // 获取当前用户信息 BBSItemViewData.User = (CQGJ.passport.User)HttpContext.Session["userobject"]; // 根据BBS论坛ID以前ParentID=-1来取出该BBS论坛的所有Topic, 并以列表的方式保存 var a = from bi in CQGJ.BBSItem where bi.BBS.BBSID == id && bi.ParentID == -1 select bi; // item的总条数 count = a.Count(); BBSItemViewData.BBSItemInfo = new List<BBSItemInfo>(); foreach (var temp in a) { // 初使化信息参数 BBSItemInfo tempInfo = new BBSItemInfo(); tempInfo.LastReply = new BBSItem(); tempInfo.TopicBBSItem = new BBSItem(); // 填充BBSItem信息 tempInfo.TopicBBSItem = temp; // 发起帖 var tempLastReply = from bi in CQGJ.BBSItem where bi.ParentID == temp.ItemID orderby bi.SubmitTime descending select bi; if (tempLastReply.Count() > 0) { tempInfo.LastReply = tempLastReply.First(); // 最新回复帖 } BBSItemViewData.BBSItemInfo.Add(tempInfo); } List<BBSItemInfo> itemList = new List<BBSItemInfo>(); foreach (var b in BBSItemViewData.BBSItemInfo) { BBSItem topic = b.TopicBBSItem; BBSItem lastReply = b.LastReply; BBSItemInfo info = new BBSItemInfo { LastReply = lastReply, TopicBBSItem = topic }; itemList.Add(info); } BBSItemViewData.BBSItemInfo.Clear(); BBSItemViewData.BBSItemInfo = itemList.Skip(10 * (page - 1)).Take(10).ToList(); // 定义分页信息 UrlManager urlManager = new DefaultUrlManager(count, 10); Pager pager = new Pager(urlManager); BBSItemViewData.PagerString = pager.PagerString; } catch (ArgumentNullException) { Response.Write("该班级还没有人发贴!"); } RenderView("ListBBSItems", BBSItemViewData); }
/// <summary> /// 显示教师列表 /// </summary> /// 采用id做为页面数url public ActionResult TeacherList(int? id) { SchoolViewData viewData = new SchoolViewData(); //viewData.Teachers var tempList = (from t in CQGJ.Teacher orderby t.TeacherID select t); int icount = tempList.Count(); viewData.Teachers = tempList.Skip(20 * (id.Value - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View(viewData); }
/// <summary> /// 显示施教机构列表 /// </summary> public ActionResult SchoolList(int? id) { SchoolViewData viewData = new SchoolViewData(); var schools = from o in CQGJ.Org where o.OrgType == 3 select o; viewData.Schools = schools.Skip(20 * (id.Value - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(schools.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View(viewData); }
/// <summary> /// 分页显示已发送短信 /// </summary> /// <param name="id"></param> public void ListSentSMSByPager(int id) { // 将id转化为page(由于Global文件中路由设置的顺序问题) int page = id; // 获取所有已发送短信 SentSMSListViewData AllOfSentSMS = GetSentSMSList(); // 计算已发送短信总数 int count = 0; count = AllOfSentSMS.SentSMSList.Count(); // 定义每页中显示的已发送短信 SentSMSListViewData SentSMSPerPage = new SentSMSListViewData(); // 每页显示50条已发送短信 SentSMSPerPage.SentSMSList = AllOfSentSMS.SentSMSList.Skip(50 * (page - 1)).Take(50).ToList(); // 设置分页信息 UrlManager urlManager = new DefaultUrlManager(count, 50); Pager pager = new Pager(urlManager); // 绑定分页信息 SentSMSPerPage.PagerString = pager.PagerString; // 页面渲染 RenderView("ListSentSMS", SentSMSPerPage); }
/// <summary> /// 分页显示已发送短信 /// </summary> /// <param name="id"></param> public ActionResult SentList(int id) { // 将id转化为page int page = id; // 获取所有已发送短信 SentSMSListViewData AllOfSentSMS = GetSentSMSList(); // 计算已发送短信总数 int count = 0; count = AllOfSentSMS.SentSMSList.Count(); // 定义每页中显示的已发送短信 SentSMSListViewData SentSMSPerPage = new SentSMSListViewData(); // 每页显示50条已发送短信 SentSMSPerPage.SentSMSList = AllOfSentSMS.SentSMSList.Skip(50 * (page - 1)).Take(50).ToList(); // 设置分页信息 UrlManager urlManager = new DefaultUrlManager(count, 50); Pager pager = new Pager(urlManager); // 绑定分页信息 SentSMSPerPage.PagerString = pager.PagerString; // 页面渲染 return View("SentList", SentSMSPerPage); }
public ActionResult PlanList(int id) { TrainPlanListViewData viewData = new TrainPlanListViewData(); //正常培训计划 int plantype = (int)PlanType.Normal; var planList = from p in CQGJ.Plan where p.PlanType == plantype orderby p.PlanID select p; viewData.PlanList = planList.Skip(20 * (id - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(planList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; //补充培训计划 plantype = (int)PlanType.Additional; viewData.PlanList2 = (from p in CQGJ.Plan where p.PlanType == plantype orderby p.PlanID select p).ToList(); return View("PlanList", viewData); }
public ActionResult Classlist(int id) { HomeCCViewData viewData = new HomeCCViewData(); //最新课程 viewData.LatestCourse = (from c in CQGJ.Course select c).Take(8).ToList(); //最新班级 viewData.LatestClass = (from c in CQGJ.Classes orderby c.BeginDate descending select c).Take(8).ToList(); var result = (from c in CQGJ.Classes where c.Status <= (int)ClassStatus.Deleted orderby c.BeginDate descending select c).Take(15).ToList(); viewData.ClassList = result.Skip(20 * (id - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(result.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("classlist", viewData); }
/// <summary> /// 根据用户ID分页列出他的所有发帖 /// </summary> /// <param name="id">Passport数据库中的用户ID</param> /// <param name="page"></param> public void toListBBSItemsByUserIDAndPager(int id, int page) { BBSItemListViewData UserBBSItems = ListBBSItemsByUserID(id); UserBBSItems.BBSID = GetCurrentBBSID(); int count = 0; count = UserBBSItems.BBSItemInfo.Count(); BBSItemListViewData ItemsOfPerPage = new BBSItemListViewData(); ItemsOfPerPage.BBSID = UserBBSItems.BBSID; ItemsOfPerPage.BBSItemInfo = UserBBSItems.BBSItemInfo.Skip(10 * (page - 1)).Take(10).ToList(); UrlManager urlManager = new DefaultUrlManager(count, 10); Pager pager = new Pager(urlManager); ItemsOfPerPage.PagerString = pager.PagerString; RenderView("ListBBSItemsByUserIDPage", ItemsOfPerPage); }
/// <summary> /// 首页搜索 /// </summary> public ActionResult Search(int? id) { HomeSearchViewData viewData = new HomeSearchViewData() { lsNews = new List<News>() }; string keyword = Request.QueryString["k"]; if (keyword == null || keyword == "") { return View(viewData); } int p = 1; try { p = int.Parse(Request.QueryString["p"]); } catch { } if (id == null) { id = (int?)1; } Expression condition = Expression.Constant(false); ParameterExpression parameter = Expression.Parameter(typeof(News), "n"); Expression con = Expression.Call(Expression.Property(parameter, typeof(News).GetProperty("Title")), typeof(string).GetMethod("Contains", new Type[] { typeof(string) }), Expression.Constant(keyword)); Expression con1 = Expression.Call(Expression.Property(parameter, typeof(News).GetProperty("PubAuthor")), typeof(string).GetMethod("Contains", new Type[] { typeof(string) }), Expression.Constant(keyword)); Expression ture = Expression.Or(con, con1); Expression<Func<News, bool>> end = Expression.Lambda<Func<News, bool>>(ture, new ParameterExpression[] { parameter }); List<News> result = CQGJ.News.Where(end).OrderBy(n => n.PubDate).ToList(); viewData.lsNews = result.Skip(30 * (id.Value - 1)).Take(30).ToList(); UrlManager urlManager = new DefaultUrlManager(result.Count, 30, "p"); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View(viewData); }
/// <summary> /// 分页显示BBSItem /// </summary> /// <param name="id">BBS ID</param> /// <param name="page">Page ID</param> public void toListBBSItemsInAdminPageByPager(int id, int page) { BBSItemListViewData BBSItemVD = ListBBSItemsByBBSID(id); HttpContext.Session["CurrentBBSID"] = id; int count = 0; count = BBSItemVD.BBSItemInfo.Count(); BBSItemListViewData ItemsOfPerPage = new BBSItemListViewData(); ItemsOfPerPage.BBSID = BBSItemVD.BBSID; ItemsOfPerPage.BBSItemInfo = BBSItemVD.BBSItemInfo.Skip(10 * (page - 1)).Take(10).ToList(); UrlManager urlManager = new DefaultUrlManager(count, 10); Pager pager = new Pager(urlManager); ItemsOfPerPage.PagerString = pager.PagerString; RenderView("ListBBSItemsInAdminPage", ItemsOfPerPage); }
/// <summary> /// 学习成果列表 /// </summary> /// <param name="id">页码</param> /// <returns></returns> public ActionResult WareList(int id) { HomeCCViewData viewData = new HomeCCViewData(); var tempList = (from cw in CQGJ.Courseware select cw).ToList(); viewData.WareList = tempList.Skip(30 * (id - 1)).Take(30).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 30); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View(viewData); }
/// <summary> /// 根据ItemId, 获取该Item的内容及回复等信息,并分页显示 /// </summary> /// <param name="id"></param> /// <param name="page"></param> public void toShowItemDetailInAdminPageByPager(int id, int page) { BBSItemListViewData BBSILVD = GetItemDetailInfoByID(id); BBSItemListViewData replyPerPage = new BBSItemListViewData(); try { BBSILVD = GetItemDetailInfoByID(id); // 根据BBSItem的ID取出该条BBSItem的内容 BBSILVD.BBSItem = (from bi in CQGJ.BBSItem where bi.ItemID == id select bi).First(); // 查看次数加1 BBSILVD.BBSItem.ViewCount = BBSILVD.BBSItem.ViewCount + 1; CQGJ.SaveChanges(); // 计算回复条数 int count = 0; count = BBSILVD.BBSItemInfo.Count(); replyPerPage.TopicItemInfo = new BBSItemInfo { TopicBBSItem = BBSILVD.TopicItemInfo.TopicBBSItem, Author = GetUserInfoByID((int)BBSILVD.TopicItemInfo.TopicBBSItem.UserReference.EntityKey.EntityKeyValues[0].Value) }; replyPerPage.BBSItemInfo = new List<BBSItemInfo>(); replyPerPage.BBSItemInfo = BBSILVD.BBSItemInfo.Skip(10 * (page - 1)).Take(10).ToList(); replyPerPage.BBSID = BBSILVD.BBSID; UrlManager urlManager = new DefaultUrlManager(count, 10); Pager pager = new Pager(urlManager); replyPerPage.PagerString = pager.PagerString; } catch (Exception ex) { Response.Write(ex.Message); } RenderView("ShowItemDetailInAdminPage", replyPerPage); }
public void DocSendedSubList(int year, int wordno, int page) { int ot = GetOrgType(); DocSendedSubListViewData viewData = new DocSendedSubListViewData() { lsSubDoc = new List<Doc>(), DocFightBack = new List<Doc>() }; if (wordno != 0) { viewData.docWord = (from d in CQGJ.DocWord where d.WordID == wordno select d).First().WordName; viewData.Year = year; //取得本地Orgid string strOrgID = GetOrgID().ToString(); //取出所有的公文 int? DocEnd = (int?)DocStatus.End; if (ot == 2 || ot == 3 || ot == 4) { //已经发送的公文 包括所有的 var TempList = (from c in CQGJ.Doc where c.SignMan == strOrgID && c.Status >= (int?)DocStatus.Normal orderby c.PubDate descending select c); viewData.DocFightBack = (from c in CQGJ.Doc from dt in c.DocTreat where c.SignMan == strOrgID && dt.TreatType == (int?)DocProcessStatus.FightBack && c.Status >= (int?)DocStatus.Normal orderby c.PubDate descending select c).ToList(); viewData.lsSubDoc = TempList.Skip((page - 1) * 20).Take(20).ToList(); UrlManager urlManger = new DefaultUrlManager(TempList.Count(), 20); Pager pager = new Pager(urlManger); viewData.PagerString = pager.PagerString; } else { //已经发送的公文 包括所有的 var TempList = (from c in CQGJ.Doc where c.SignMan == strOrgID && c.PubDate.Value.Year == year && c.WordNo == viewData.docWord && c.Status >= (int?)DocStatus.Normal orderby c.PubDate descending select c); viewData.lsSubDoc = TempList.Skip((page - 1) * 20).Take(20).ToList(); UrlManager urlManger = new DefaultUrlManager(TempList.Count(), 20); Pager pager = new Pager(urlManger); viewData.PagerString = pager.PagerString; } } else { viewData.Year = DateTime.Now.Year; viewData.docWord = "暂时没有公文"; } RenderView("DocSendedSubList", viewData); }
/// <summary> /// 首页搜索 /// </summary> public void HomeSearch(int? id) { HomeSearchViewData viewData = new HomeSearchViewData(){ lsNews=new List<News>() }; viewData.lsHotNews = (from hn in CQGJ.News where hn.IsNotify == false && hn.IsApproval == true && hn.Status == (int?)NewsStatus.Approved orderby hn.PubDate descending select hn).Take(5).ToList(); viewData.lsCountNews = (from cn in CQGJ.News where cn.IsNotify == false && cn.IsApproval == true && cn.Status == (int?)NewsStatus.Approved orderby cn.ViewNum descending select cn).Take(5).ToList(); if (GetString("keyword") != "" || id != null) { if (id == null) { id = (int?)1; } Expression condition = Expression.Constant(false); ParameterExpression parameter = Expression.Parameter(typeof(News), "n"); Expression con = Expression.Call(Expression.Property(parameter, typeof(News).GetProperty("Title")), typeof(string).GetMethod("Contains", new Type[] { typeof(string) }), Expression.Constant(GetString("keyword"))); Expression con1 = Expression.Call(Expression.Property(parameter, typeof(News).GetProperty("PubAuthor")), typeof(string).GetMethod("Contains", new Type[] { typeof(string) }), Expression.Constant(GetString("keyword"))); Expression ture = Expression.Or(con, con1); Expression<Func<News, bool>> end = Expression.Lambda<Func<News, bool>>(ture, new ParameterExpression[] { parameter }); List<News> result = CQGJ.News.Where(end).OrderBy(n => n.PubDate).ToList(); viewData.lsNews = result.Skip(20 * (id.Value - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(result.Count, 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; RenderView("HomeSearch", viewData); } else { RenderView("HomeSearch", viewData); } }
public void DocMaintans_SubList(int year, int wordno, int page) { DocMantainSubListViewData viewData = new DocMantainSubListViewData() { lsSubDoc = new List<Doc>(), lsDocEnd = new List<Doc>() }; if (wordno != 0) { viewData.docWord = (from d in CQGJ.DocWord where d.WordID == wordno select d).First().WordName; viewData.Year = year; //取得本地Orgid string strOrgID = GetOrgID().ToString(); //取出所有的公文 int? DocEnd = (int?)DocStatus.End; //已经发送的公文 包括所有的 var TempList = (from c in CQGJ.Doc //from dt in c.DocTreat where c.SignMan == strOrgID && c.PubDate.Value.Year == year && c.WordNo == viewData.docWord orderby c.PubDate descending select c); viewData.lsSubDoc = TempList.Skip((page - 1) * 20).Take(20).ToList(); int ot = Convert.ToInt32(HttpContext.Session["OrgType"]); //如果是ot==1 那么就没有该段 if (ot == 2 || ot == 3 || ot == 4) { viewData.lsDocEnd = (from c in CQGJ.Doc where c.SignMan == strOrgID && c.Status == (int?)DocStatus.FightBack orderby c.PubDate descending select c).ToList(); } UrlManager urlManger = new DefaultUrlManager(TempList.Count(), 20); Pager pager = new Pager(urlManger); viewData.PagerString = pager.PagerString; } else { viewData.Year = DateTime.Now.Year; viewData.docWord = "暂时没有公文"; } RenderView("DocMantainsSublist", viewData); }
/// <summary> /// 用户留言列表 /// </summary> /// <param name="id">类型(收件箱或发件箱)</param> /// <param name="page">页码</param> /// <returns></returns> public ActionResult MsgList(int id, int page) { int userID = GetUserID(); UserIndexViewData viewData = new UserIndexViewData(); List<Message> tempList = new List<Message>(); if (id == 1)//收件箱 { tempList = (from m in CQGJ.Message where m.ToUserID == userID orderby m.AddTime descending select m).ToList(); } else//发件箱 { tempList = (from m in CQGJ.Message where m.FromUserID == userID orderby m.AddTime descending select m).ToList(); } viewData.MessageList = tempList.Skip(20 * (page - 1)).Take(20).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("MsgList", viewData); }
public void DocReceiveSearchIndex(int? id) { if (id != null) { DocReceiveSearchViewData viewData = new DocReceiveSearchViewData(){SearchKey=new Dictionary<string,string>(),StatusKey=new Dictionary<int,string>()}; int iOrgID = GetOrgID(); var tempList = (from c in CQGJ.Doc from dt in c.DocTreat where dt.Org.OrgID == iOrgID orderby c.PubDate descending select new DocReceiveCell {doc = c,doctreat = dt }); viewData.Docs = tempList.Skip((id.Value - 1) * 15).Take(15).ToList(); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 15); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; viewData.SearchKey.Add("DocTitle", ""); viewData.SearchKey.Add("PubData", ""); viewData.StatusKey.Add(0, "Published"); viewData.StatusKey.Add(1, "Registed"); viewData.StatusKey.Add(2,"Downloaded"); viewData.StatusKey.Add(3,"Treated"); viewData.StatusKey.Add(4,"Treated"); viewData.StatusKey.Add(5,"FightBack"); viewData.StatusKey.Add(6,"End"); RenderView("DocReceiveSearch", viewData); } }
/// <summary> /// 未开班班级列表 /// </summary> public ActionResult OpenClassList(int id) { int orgID = GetOrg().OrgID; int orgType = (int)GetOrg().OrgType; TrainOpenClassListViewData viewData = new TrainOpenClassListViewData(); int s = (int)ClassStatus.Signup; int count = 0; if (orgType == 1) { var classList = from c in CQGJ.Classes where c.Status == s orderby c.ClassID select c; viewData.PlanClassList = classList.Skip(20 * (id - 1)).Take(20).ToList(); count = classList.Count(); } else { var classList = from c in CQGJ.Classes where c.Status == s where c.Org.OrgID == orgID orderby c.ClassID select c; viewData.PlanClassList = classList.Skip(20 * (id - 1)).Take(20).ToList(); count = classList.Count(); } UrlManager urlManager = new DefaultUrlManager(count, 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("OpenClassList", viewData); }
///有必要删除学校? //public void SchoolDelete() //{ // string strID = HttpContext.Request.QueryString["id"]; // passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport(); // cqgj.DeleteSchool(strID); // RedirectToAction("SchoolList"); //public void SchoolDelete() //{ // string strID = HttpContext.Request.QueryString["id"]; // passport.CQGJPassport cqgj = new CQGJ.passport.CQGJPassport(); // try // { // List<Teacher> lsteacher = (from c in CQGJ.Teacher // from d in CQGJ.Org // where c.Org == d // select c).ToList(); // if (lsteacher.Count == 0) // { // Org org=from c in CQGJ.Org // select c.OrgCode // } // } // catch // { // } // RedirectToAction("SchoolList"); //} ///// <summary> ///// 编辑施教机构信息 ///// </summary> ///// <param name="id">施教机构ID</param> //public void EditSchool(int id) //{ // SchoolEditSchoolViewData viewData = new SchoolEditSchoolViewData(); // //School school = (from s in CQGJ.School // // where s.SchoolID == id // // select s).First(); // //if (GetString("schoolName") != "") // //{ // // school.SchoolName = GetString("schoolName"); // // school.Address = GetString("Address"); // // school.ZipCode = GetString("ZipCode"); // // school.Tel = GetString("Tel"); // // CQGJ.SaveChanges(); // //} // //viewData.School = school; // RenderView("EditSchool", viewData); //} //public void DeleteShool() //{ //} /// <summary> /// 显示教师列表 /// </summary> /// 采用id做为页面数url public void TeacherList(int? id) { SchoolTeacherListViewData viewData = new SchoolTeacherListViewData(); //viewData.Teachers var tempList = (from t in CQGJ.Teacher orderby t.TeacherID select t); int icount = tempList.Count(); viewData.Teachers = tempList.Skip(20 * (id.Value - 1)).Take(20).ToList(); viewData.Url = ConfigurationManager.AppSettings.Get("TeacherPhotoUrl"); UrlManager urlManager = new DefaultUrlManager(tempList.Count(), 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; RenderView("TeacherList", viewData); }
public ActionResult PlanClassList(int id, int page) { TrainPlanClassListViewData viewData = new TrainPlanClassListViewData(); viewData.PlanID = id; int s = (int)ClassStatus.Deleted; int count = 0; if (id == 0) { var classList = from pc in CQGJ.Classes where pc.Status != s orderby pc.ClassID select pc; viewData.PlanClassList = classList.Skip(20 * (page - 1)).Take(20).ToList(); count = classList.Count(); } else { var classList = from pc in CQGJ.Classes where pc.Plan.PlanID == id where pc.Status != s orderby pc.ClassID select pc; viewData.PlanClassList = classList.Skip(20 * (page - 1)).Take(20).ToList(); count = classList.Count(); } UrlManager urlManager = new DefaultUrlManager(count, 20); Pager pager = new Pager(urlManager); viewData.PagerString = pager.PagerString; return View("PlanClassList", viewData); }