public JsonResult List(int page, int rows, string BeginTime = "", string EndTime = "")
{
MeetingInfoQuery model = new MeetingInfoQuery();
DateTime dt;
if (DateTime.TryParse(BeginTime, out dt) && DateTime.TryParse(EndTime, out dt))
{
model = new MeetingInfoQuery()
{
BeginTime = DateTime.Parse(BeginTime),
EndTime = DateTime.Parse(EndTime),
PageNo = page,
PageSize = rows
};
}
else
{
model = new MeetingInfoQuery()
{
PageNo = page,
PageSize = rows
};
}
PageModel <MeetingInfo> opModel = ServiceHelper.Create <IMeetInfoService>().GetMeetingInfos(model);
var array =
from item in opModel.Models.ToArray()
select new { Id = item.Id, Title = item.Title, MeetingTime = item.MeetingTime, MeetingPlace = item.MeetingPlace, MeetingContent = item.MeetingContent };
return(Json(new { rows = array, total = opModel.Total }));
}
public PageModel <MeetingInfo> GetMeetingInfosByThreeMouth(MeetingInfoQuery model)
{
DateTime oldtime = DateTime.Now.AddDays(-90);
DateTime nowtime = DateTime.Now;
int pageNum = 0;
IQueryable <MeetingInfo> MeetingInfos = from item in base.context.MeetingInfo
where item.MeetingTime >= oldtime && item.MeetingTime <= nowtime
//where item.MeetingTime <= DateTime.Now && item.MeetingTime >= DateTime.Now.AddDays(-7)
select item;
MeetingInfos = MeetingInfos.GetPage(out pageNum, model.PageNo, model.PageSize, (IQueryable <MeetingInfo> d) =>
from o in d
orderby o.MeetingTime descending
select o);
return(new PageModel <MeetingInfo>
{
Models = MeetingInfos,
Total = pageNum
});
}
/// <summary>
/// 获取会议信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public PageModel <MeetingInfo> GetMeetingInfos(MeetingInfoQuery model)
{
int pageNum = 0;
IQueryable <MeetingInfo> MeetingInfos = from item in base.context.MeetingInfo
select item;
string begin = model.BeginTime.ToString("yyyy/MM/dd");
string end = model.EndTime.ToString("yyyy/MM/dd");
if (!string.IsNullOrWhiteSpace(begin) && !begin.Equals("0001/01/01") && !string.IsNullOrWhiteSpace(end) && !end.Equals("0001/01/01"))
{
MeetingInfos = (from a in MeetingInfos where a.MeetingTime <model.BeginTime && a.MeetingTime> model.EndTime select a);
}
MeetingInfos = MeetingInfos.GetPage(out pageNum, model.PageNo, model.PageSize, (IQueryable <MeetingInfo> d) =>
from o in d
orderby o.MeetingTime descending
select o);
return(new PageModel <MeetingInfo>
{
Models = MeetingInfos,
Total = pageNum
});
}
