public ActionResult GetAllOrganizeInfo()
{
int pageSize = int.Parse(Request["limit"] ?? "5");
int offset = int.Parse(Request["offset"] ?? "0");
int pageIndex = (offset / pageSize) + 1;
OrganizeQueryParam qrganizeQueryParam = new OrganizeQueryParam();
if (!string.IsNullOrEmpty(Request["filter"]))
{
qrganizeQueryParam = Newtonsoft.Json.JsonConvert.DeserializeObject <OrganizeQueryParam>(Request["filter"]);
}
qrganizeQueryParam.PageSize = pageSize;
qrganizeQueryParam.PageIndex = pageIndex;
qrganizeQueryParam.Total = 0;
var pageData = OrganizeInfoService.LoadPageData(qrganizeQueryParam, LoginOrganize.OrganizeInfoID)
.Select(u => new
{
u.OrganizeInfoID,
u.OrganizeInfoLoginId,
u.OrganizeInfoShowName,
u.OrganizeInfoPeople,
u.OrganizeInfoEmail,
u.OrganizeInfoPhone,
u.OrganizeInfoLastTime,
u.CreateTime,
u.Status,
u.ActivityCount
}).AsQueryable();
var data = new { total = qrganizeQueryParam.Total, rows = pageData.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 多条件查询
/// </summary>
/// <param name="organizeQueryParam"></param>
/// <param name="LoginUserId"> 自身ID</param>
/// <returns></returns>
public IQueryable <OrganizeInfo> LoadPageData(OrganizeQueryParam organizeQueryParam, int loginUserId)
{
short delInvalid = (short)Model.Enum.DelFlagEnum.Invalid;
var temp = CurrentDal.GetEntities(u => u.Status != delInvalid).AsQueryable();
#region 状态
short delFlag = -1;
if (!String.IsNullOrEmpty(organizeQueryParam.Status))
{
if (("正常").Contains(organizeQueryParam.Status))
{
delFlag = 0;
}
else if (("待审核").Contains(organizeQueryParam.Status))
{
delFlag = 2;
}
else if (("删除").Contains(organizeQueryParam.Status))
{
delFlag = 1;
}
}
if (delFlag > -1)
{
temp = temp.Where(u => u.Status == delFlag);
}
#endregion
#region OrganizeInfoID
if (!String.IsNullOrEmpty(organizeQueryParam.OrganizeInfoID))
{
temp = temp.Where(u => (u.OrganizeInfoID).ToString().Contains(organizeQueryParam.OrganizeInfoID)).AsQueryable();
}
#endregion
#region LoginId
if (!String.IsNullOrEmpty(organizeQueryParam.OrganizeInfoLoginId))
{
temp = temp.Where(u => u.OrganizeInfoLoginId.Contains(organizeQueryParam.OrganizeInfoLoginId)).AsQueryable();
}
#endregion
#region ShowName
if (!String.IsNullOrEmpty(organizeQueryParam.OrganizeInfoShowName))
{
temp = temp.Where(u => u.OrganizeInfoShowName.Contains(organizeQueryParam.OrganizeInfoShowName)).AsQueryable();
}
#endregion
#region People
if (!String.IsNullOrEmpty(organizeQueryParam.OrganizeInfoPeople))
{
temp = temp.Where(u => u.OrganizeInfoPeople.Contains(organizeQueryParam.OrganizeInfoPeople)).AsQueryable();
}
#endregion
#region Phone
if (!String.IsNullOrEmpty(organizeQueryParam.OrganizeInfoPhone))
{
temp = temp.Where(u => u.OrganizeInfoPhone.Contains(organizeQueryParam.OrganizeInfoPhone)).AsQueryable();
}
#endregion
#region Email
if (!string.IsNullOrEmpty(organizeQueryParam.OrganizeInfoEmail))
{
temp = temp.Where(u => u.OrganizeInfoEmail.Contains(organizeQueryParam.OrganizeInfoEmail)).AsQueryable();
}
#endregion
#region LastTime
if (!String.IsNullOrEmpty(organizeQueryParam.OrganizeInfoLastTime))
{
temp = temp.Where(u => (u.OrganizeInfoLastTime).ToString().Contains(organizeQueryParam.OrganizeInfoLastTime)).AsQueryable();
}
#endregion
#region CreateTime
if (!String.IsNullOrEmpty(organizeQueryParam.CreateTime))
{
temp = temp.Where(u => (u.CreateTime).ToString().Contains(organizeQueryParam.CreateTime)).AsQueryable();
}
#endregion
#region ActivityCount
if (!String.IsNullOrEmpty(organizeQueryParam.ActivityCount))
{
temp = temp.Where(u => (u.ActivityCount).ToString().Contains(organizeQueryParam.ActivityCount)).AsQueryable();
}
#endregion
temp = temp.Where(u => u.OrganizeInfoID != loginUserId).AsQueryable();
organizeQueryParam.Total = temp.Count();
return(temp.OrderBy(u => u.OrganizeInfoID).Skip((organizeQueryParam.PageIndex - 1) * organizeQueryParam.PageSize).Take(organizeQueryParam.PageSize).AsQueryable());
}
