/// <summary>
/// 分页查询
/// </summary>
/// <param name="id">当前页</param>
/// <param name="page">当前页</param>
/// <param name="searchMsg">会议主题</param>
/// <param name="Status">会议状态</param>
/// <returns></returns>
public ActionResult List_Json(int?id, int?page, int Status)
{
int pageIndex = page ?? 1;
const int pageSize = 10;
int rowCount = db.GetListAll(null, Status).Count();
var pageCount = 1;
if (rowCount != 0)
{
if (rowCount % pageSize != 0)
{
if (rowCount - pageSize < 0)
{
pageCount = 1;
}
else
{
pageCount = rowCount / pageSize + 1;
}
}
else
{
pageCount = rowCount / pageSize;
}
}
//====多表查询star====
MeetMemberData md = new MeetMemberData();
List <int> meerStr = md.MeetingStr(1);
var meeting = from n in od.Meeting
join b in od.Employee on n.EmId equals b.EmpId
join c in od.MeetRoom on n.RoomId equals c.RoomId
where (meerStr.Contains(n.MeetId) || n.EmId == 1) && n.Status == Status
//(n.EmId==1&&n.Status==Status) || meerStr.Contains(n.MeetId.ToString())
//n.Status==Status && meerStr.Contains(n.MeetId.ToString())||n.EmId==1
orderby n.MeetId descending
select new
{
n.MeetId,
n.Subject,
n.EmId,
b.EmpName,
c.RoomName,
n.StartDateTime,
n.Minutes,
n.Status,
};
try
{
var meetingList = meeting.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var strResult = "{\"pageCount\":" + pageCount + ",\"CurrentPage\":" + pageIndex + ",\"list\":" + meetingList.ToJsonString() + "}";
return(Json(strResult, JsonRequestBehavior.AllowGet));
//=========多表查询End====
}
catch
{
return(Json(null));
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="id">当前页</param>
/// <param name="page">当前页</param>
/// <param name="searchMsg">会议主题</param>
/// <param name="Status">会议状态</param>
/// <returns></returns>
public ActionResult List_Json(int?id, int?page, string searchMsg, int Status)
{
int pageIndex = page ?? 1;
const int pageSize = 10;
//未多表查询的方法
//IEnumerable<Meeting> list = db.GetListByMe(pageIndex, pageSize, searchMsg, Status);
int rowCount = db.GetListAll(searchMsg, Status).Count();
var pageCount = 1;
if (rowCount != 0)
{
if (rowCount % pageSize != 0)
{
if (rowCount - pageSize < 0)
{
pageCount = 1;
}
else
{
pageCount = rowCount / pageSize + 1;
}
}
else
{
pageCount = rowCount / pageSize;
}
}
//====多表查询star====
if (string.IsNullOrEmpty(searchMsg))
{
var meeting = from n in od.Meeting
join b in od.Employee on n.EmId equals b.EmpId
join c in od.MeetRoom on n.RoomId equals c.RoomId
where n.Status == Status
orderby n.MeetId descending
select new
{
n.MeetId,
n.Subject,
b.EmpName,
c.RoomName,
n.StartDateTime,
n.Minutes,
n.Status,
};
var meetingList = meeting.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var strResult = "{\"pageCount\":" + pageCount + ",\"CurrentPage\":" + pageIndex + ",\"list\":" + meetingList.ToJsonString() + "}";
return(Json(strResult, JsonRequestBehavior.AllowGet));
//meeting = db.Meeting.Where(n=>n.Status == Status).OrderByDescending(n => n.MeetId).Skip((pageindex - 1) * pageSize).Take(pageSize).ToList();
}
else
{
var meeting = from n in od.Meeting
join b in od.Employee on n.EmId equals b.EmpId
join c in od.MeetRoom on n.RoomId equals c.RoomId
where n.Status == Status && n.Subject.Contains(searchMsg)
orderby n.MeetId descending
select new
{
n.MeetId,
n.Subject,
b.EmpName,
c.RoomName,
n.StartDateTime,
n.Minutes,
n.Status,
};
var meetingList = meeting.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var strResult = "{\"pageCount\":" + pageCount + ",\"CurrentPage\":" + pageIndex + ",\"list\":" + meetingList.ToJsonString() + "}";
return(Json(strResult, JsonRequestBehavior.AllowGet));
//meeting = db.Meeting.Where(n=>n.Subject.Contains(Subject) &&n.Status == Status).OrderByDescending(n=>n.MeetId).Skip((pageindex-1)* pageSize).Take(pageSize);
}
//=========多表查询End====
//以前总的return
//var strResult = "{\"pageCount\":" + pageCount + ",\"CurrentPage\":" + pageIndex + ",\"list\":" + list.ToJsonString() + "}";
//return Json(strResult, JsonRequestBehavior.AllowGet);
}