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