public IQueryable <Users> GetList(List <string> searchKeys, Users model, Dictionary <string, object> searchParams, int?pageIndex, int?rowCount) { //var modelQuery = MwtsEntities.Users.AsQueryable(); var modelQuery = new MWTSEntities().Users.AsQueryable();//.Include("子对象").AsQueryable(); #region 默认查询条件 if (searchKeys.Contains("UserID")) { modelQuery = modelQuery.Where(item => item.UserID == model.UserID); } if (searchKeys.Contains("Sid")) { modelQuery = modelQuery.Where(item => item.Sid == model.Sid); } if (searchKeys.Contains("UserType")) { modelQuery = modelQuery.Where(item => item.UserType == model.UserType); } if (searchKeys.Contains("AuthType")) { modelQuery = modelQuery.Where(item => item.AuthType == model.AuthType); } if (searchKeys.Contains("UserName")) { modelQuery = modelQuery.Where(item => item.UserName == model.UserName); } #endregion #region 自定义查询条件 if (searchParams.Count > 0) { //扩展查询条件 } #endregion #region 翻页逻辑 if (pageIndex != null && rowCount != null) { int skip = ((int)pageIndex - 1) * (int)rowCount; int take = (int)rowCount; modelQuery = modelQuery.OrderBy(item => item.UserID).Skip(skip > 0?skip:0).Take(take); } #endregion return(modelQuery); }
public IQueryable <Batch> GetList(List <string> searchKeys, Batch model, Dictionary <string, object> searchParams, int?pageIndex, int?rowCount) { //var modelQuery = MwtsEntities.Batchs.AsQueryable(); var modelQuery = new MWTSEntities().Batch.AsQueryable();//.Include("子对象").AsQueryable(); #region 默认查询条件 if (searchKeys.Contains("BatchID")) { modelQuery = modelQuery.Where(item => item.BatchID == model.BatchID); } if (searchKeys.Contains("AddedOn")) { var startTime = DateTime.Parse(model.AddedOn.ToString("yyyy-MM-dd")); var endTime = DateTime.Parse(model.AddedOn.AddDays(1).ToString("yyyy-MM-dd")); modelQuery = modelQuery.Where(item => item.AddedOn >= startTime && item.AddedOn < endTime); } if (searchKeys.Contains("Action")) { modelQuery = modelQuery.Where(item => item.Action == model.Action); } if (searchKeys.Contains("Item")) { modelQuery = modelQuery.Where(item => item.Item == model.Item); } if (searchKeys.Contains("Parent")) { modelQuery = modelQuery.Where(item => item.Parent == model.Parent); } if (searchKeys.Contains("Param")) { modelQuery = modelQuery.Where(item => item.Param == model.Param); } if (searchKeys.Contains("BoolParam")) { modelQuery = modelQuery.Where(item => item.BoolParam == model.BoolParam); } if (searchKeys.Contains("Content")) { modelQuery = modelQuery.Where(item => item.Content == model.Content); } if (searchKeys.Contains("Properties")) { modelQuery = modelQuery.Where(item => item.Properties == model.Properties); } #endregion #region 自定义查询条件 if (searchParams.Count > 0) { //扩展查询条件 } #endregion #region 翻页逻辑 if (pageIndex != null && rowCount != null) { int skip = ((int)pageIndex - 1) * (int)rowCount; int take = (int)rowCount; modelQuery = modelQuery.OrderBy(item => item.BatchID).Skip(skip > 0?skip:0).Take(take); } #endregion return(modelQuery); }