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