public ActionResult GetBikeInfo()
{
//报文中请求自动发送 rows page
int pageSize = int.Parse(Request["rows"] ?? "5");
int pageIndex = int.Parse(Request["page"] ?? "1");
//多条件差寻过滤
string searchName = Request["seacrchName"];
var queryParam = new UserQueryParam()
{
PageSize = pageSize,
PageIndex = pageIndex,
Total = 0,
SearchName = searchName
};
//封装业务逻辑
var pageData = bikeInfoService.LoadPageData(queryParam);
var data = new { total = queryParam.Total, rows = pageData.ToList() };
//具有导航属性注意 循环序列化
return(Json(data, JsonRequestBehavior.AllowGet));
}
public IEnumerable <User> Find(UserQueryParam options)
{
var results = Context.Users.AsEnumerable();
if (!string.IsNullOrEmpty(options?.Filter?.Country))
{
results = results.Where(x => x.Country == options.Filter.Country);
}
if (options?.Sort?.Latest == true)
{
results = results.OrderByDescending(x => x.Id);
}
if (options?.Pagination?.Offset > 0)
{
results = results.Skip(options.Pagination.Offset.Value);
}
if (options?.Pagination?.Limit > 1)
{
results = results.Take(options.Pagination.Limit.Value);
}
var tmp = results.ToList();
return(ConvertToDomainType(tmp));
}
//another way to set field in base class , no test----------
//public UserInfoBll()
//{
// base.CurrentDal = DbSessionFactory.GetDbSession().UserInfoDal;
//}
//----------------------------------------------------------
public IQueryable <UserInfo> GetSearchIndex <S>(UserQueryParam qm, Expression <Func <UserInfo, S> > orderByLambada, out int totalCount)
{
IQueryable <UserInfo> users = CurrentDal.GetEntities(u => true);
if (qm.ID != 0)
{
users = users.Where(u => u.ID == qm.ID);
}
if (!string.IsNullOrEmpty(qm.UName))
{
users = users.Where(u => u.UName.Contains(qm.UName));
}
if (!string.IsNullOrEmpty(qm.ShowName))
{
users = users.Where(u => u.ShowName.Contains(qm.ShowName));
}
if (!string.IsNullOrEmpty(qm.Remark))
{
users = users.Where(u => u.Remark.Contains(qm.Remark));
}
if (qm.TimeAfter != DateTime.MinValue)
{
users = users.Where(u => DateTime.Compare(u.SubTime, qm.TimeAfter) > 0);
}
if (qm.TimeBefore != DateTime.MinValue)
{
users = users.Where(u => DateTime.Compare(qm.TimeBefore, u.SubTime) > 0);
}
totalCount = users.Count();
users = users.OrderBy(orderByLambada).Skip(qm.pageIndex * qm.pageCount).Take(qm.pageCount);
return(users);
}
public ActionResult GetAllUserInfos()
{
//jquery easyUI:table:{total:32,rows:[{},{}]}//需要json数据格式
//jquery easyUI:table:在初始化时自动发送以下两个参数值
int pageSize = int.Parse(Request["rows"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
int total = 0;
//拿到过滤条件用户名和备注的值
string schName = Request["schName"];
string schRemark = Request["schRemark"];
var queryParam = new UserQueryParam()
{
PageSize = pageSize,
PageIndex = pageIndex,
Total = total,
SchName = schName,
SchRemark = schRemark
};
//根据条件查询出数据（并且分好页）
var pageData = userInfoBll.LoadPageData(queryParam);
//获取部分列
var temp = pageData.Select(u => new { ID = u.Id, u.ModifyOn, u.Pwd, u.Remark, u.ShowName, u.SubTime, u.UName });
var data = new { total = queryParam.Total, rows = temp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult GetUserInfos()
{
int pageSize = int.Parse(Request["rows"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
int total = 0;
String sName = Request["sName"];
String sRemark = Request["sRemark"];
var queryParam = new UserQueryParam()
{
PageIndex = pageIndex,
PageSize = pageSize,
Total = total,
SchName = sName,
SchRemark = sRemark
};
var pageData = UserInfoService.GetPageData(queryParam);
var tmp = pageData.Select(u => new
{
ID = u.ID,
u.UName,
u.Remark,
u.ShowName,
u.SubTime,
u.ModfiedOn,
u.Pwd
});
var data = new { total = queryParam.Total, rows = tmp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取用户基本信息
/// </summary>
/// <returns>Json数据</returns>
public ActionResult GetAllUserInfos(string limit, string page, string schCode, string schRoleName)
{
int pageSize = int.Parse(limit ?? "10");
int pageIndex = int.Parse(page ?? "1");
//过滤的用户名 过滤备注schName schRemark
var queryParam = new UserQueryParam()
{
PageSize = pageSize,
PageIndex = pageIndex,
SchCode = schCode,
SchRoleName = schRoleName,
Total = 0,
};
var pageData = UserInfoService.LoagUserPageData(queryParam).ToList();
var data = new { code = 0, msg = "", count = queryParam.Total, data = pageData.ToList() };
if (!string.IsNullOrEmpty(schCode) || !string.IsNullOrEmpty(schRoleName))
{
//写操作日志
OperationLogService.Add("查找员工", "系统管理", LoginInfo, schCode, schRoleName);
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 根据查询条件获取所有的用户
/// </summary>
/// <returns></returns>
public async Task <IList <UserItemDto> > GetAllUsersAsync(UserQueryParam param)
{
List <UserItemDto> users = new List <UserItemDto>();
var tasks = new List <Task <List <UserItemDto> > >();
foreach (var appService in await _remotingClient.CreateAllUserAppServicesAsync())
{
tasks.Add(appService.GetAllUserItem(new UserQueryInput()
{
IdCardNo = param.IdCardNo,
Name = param.Name,
Username = param.UserName,
UserId = param.UserId
}));
}
await Task.WhenAll(tasks);
users.AddRange(tasks.SelectMany(u => u.Result));
users.Sort(new UserItemDtoComparer());
if (param.PageIndex.HasValue && param.PageSize.HasValue)
{
users = users.OrderByDescending(u => u.Created ?? default(DateTimeOffset))
.Skip(Math.Abs((param.PageIndex.Value - 1) * param.PageSize.Value))
.Take(Math.Abs(param.PageSize.Value)).ToList();
}
return(users);
}
/// <summary>
/// 实现多条件查询
/// </summary>
/// <param name="userQueryParam">查询参数</param>
/// <returns></returns>
public IQueryable <UserInfo> LoadPageData(UserQueryParam userQueryParam)
{
short noDel = (short)Model.Enum.DelFlagEnum.NoDel;
//查询出所有没有删除的数据
var temp = CurrentDal.GetEntity(u => u.DelFlag == noDel);
//判断查询名字是否为空
if (!string.IsNullOrEmpty(userQueryParam.SearchName))
{
temp = temp.Where(u => u.Name.Contains(userQueryParam.SearchName));
}
//在此处拼接多个条件 返回temp 可以写多个if 获取参数
//查询到数据总条数
var pageSize = userQueryParam.PageSize;
var pageIndex = userQueryParam.PageIndex - 1;
//分页 记得先排序
var userInfos = temp.OrderBy(u => u.ID)
.Skip(pageSize * pageIndex)
.Take(pageSize);
userQueryParam.Total = temp.Count();
return(userInfos);
}
public ActionResult GetActionInfo()
{
//报文中请求自动发送 rows page
int pageSize = int.Parse(Request["rows"] ?? "5");
int pageIndex = int.Parse(Request["page"] ?? "1");
//多条件差寻过滤
string searchName = Request["seacrchName"];
var queryParam = new UserQueryParam()
{
PageSize = pageSize,
PageIndex = pageIndex,
Total = 0,
SearchName = searchName
};
//封装业务逻辑
var temp = accountInfoService.LoadPageData(queryParam);
var pageData = temp.Select(u => new
{
u.ID,
u.Money,
u.SubTime,
u.Remark,
u.DelFlag,
AdminUser = u.AdminUser,
Name = u.UserInfo.Name
});
var data = new { total = queryParam.Total, rows = pageData.ToList() };
//具有导航属性注意 循环序列化
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 查询数据
/// </summary>
/// <returns></returns>
public ActionResult GetUserInfo()
{
//jQuery easy UI table：{total：32，rows:[{},{}]}
//报文中请求自动发送 rows page
int pageSize = int.Parse(Request["rows"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
//多条件差寻过滤
string searchName = Request["seacrchName"];
var queryParam = new UserQueryParam()
{
PageSize = pageSize,
PageIndex = pageIndex,
Total = 0,
SearchName = searchName
};
//封装业务逻辑
var temp = userInfoService.LoadPageData(queryParam);
//具有导航属性注意 循环序列化
var pageData = temp.Select(u => new { u.ID, u.Name, u.Pwd, u.ShowName, u.DelFlag, u.SubTime, u.Remark });
var data = new { total = queryParam.Total, rows = pageData.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 内连接查询
/// </summary>
/// <param name="userQueryParam">查询条件</param>
/// <returns>查询结果</returns>
public IQueryable <UserInfoRoleInfo> LoagUserPageData(UserQueryParam userQueryParam)
{
short delFlag = (short)Glove.IOT.Model.Enum.StatusFlagEnum.Deleted;
DataModelContainer model = new DataModelContainer();
//内连接查询
var query = from t1 in model.UserInfo
join t2 in model.R_UserInfo_RoleInfo on t1.Id equals t2.UserInfoId
join t3 in model.RoleInfo on t2.RoleInfoId equals t3.Id
where (t2.StatusFlag != delFlag && t3.StatusFlag != delFlag)
select new UserInfoRoleInfo
{
UId = t1.Id,
RId = t3.Id,
UCode = t1.UCode,
UName = t1.UName,
RoleName = t3.RoleName,
StatusFlag = t1.StatusFlag
};
userQueryParam.Total = query.Count();
return(query.OrderBy(u => u.UId)
.Skip(userQueryParam.PageSize * (userQueryParam.PageIndex - 1))
.Take(userQueryParam.PageSize).AsQueryable());
}
public ActionResult GetAllUserInfos()
{
//jquery easyui: table: {total:32,rows:[{},{}]}
//easyui: table在初始化时候自动发送以下两个参数值。
int pageSize = int.Parse(Request["rows"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
int total = 0;
//过滤的用户名 过滤备注schName schRemark
string schName = Request["schName"];
string schRemark = Request["schRemark"];
var queryParam = new UserQueryParam()
{
PageIndex = pageIndex,
PageSize = pageSize,
Total = 0,
SchName = schName,
SchRemark = schRemark
};
var pageData = UserInfoService.LoagPageData(queryParam);
var temp = pageData.Select(u => new
{
ID = u.ID,
u.UName,
u.Remark,
u.ShowName,
u.SubTime,
u.ModfiedOn,
u.Pwd
});
//拿到当前页的数据
//var pageData = UserInfoService.GetPageEntities(pageSize, pageIndex, out total,
// u => u.DelFlag == delflagNormal, u => u.ID, true)
//.select(
// u =>
// new
// {
// id = u.id,
// u.uname,
// u.remark,
// u.showname,
// u.subtime,
// u.modfiedon,
// u.pwd
// });
var data = new { total = queryParam.Total, rows = temp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage Get([FromUri] UserQueryParam options)
{
var request = new GetUsersRequest {
QueryParams = options
};
var response = _userService.GetUsers(request);
return(_responseBuilder.BuildResponse(Request, response));
}
public async Task <ActionResult <PagesListModel <UserDto> > > GetUsers([FromQuery] UserQueryParam param)
{
var result = await _accountService.GetUsersAsync(param);
if (result == null || result.data == null || result.data.Length == 0)
{
return(NoContent());
}
return(Ok(result));
}
public async Task <IActionResult> ListUsers([FromQuery] UserQueryParam userQueryParam)
{
try
{
return(Ok(await _getAllUseCase.Execute(userQueryParam).ConfigureAwait(false)));
}
catch (UseCaseException e)
{
return(BadRequest(e));
}
}
/// <summary>
/// 多条件查询
/// </summary>
/// <param name="userQueryParam">查询条件</param>
/// <returns>查询结果</returns>
public IQueryable <UserInfo> LoagPageData(UserQueryParam userQueryParam)
{
var temp = DbSession.UserInfoDal.GetEntities(u => u.IsDeleted == false);
userQueryParam.Total = temp.Count();
//分页
return(temp.OrderBy(u => u.Id)
.Skip(userQueryParam.PageSize * (userQueryParam.PageIndex - 1))
.Take(userQueryParam.PageSize).AsQueryable());
}
public IEnumerable <User> Find(UserQueryParam options)
{
var results = Context.Users.AsEnumerable();
if (!string.IsNullOrEmpty(options?.Filter?.Country))
{
results = results.Where(x => x.Country == options.Filter.Country);
}
return(ConvertToDomainType(results));
}
public async Task <UsersResponseList> Execute(UserQueryParam userQueryParam)
{
var users = await _usersGateway.GetAllUsers(userQueryParam).ConfigureAwait(false);
var usersList = new UsersResponseList
{
Users = users.ToResponse()
};
return(usersList);
}
public ActionResult GetAll()
{
//jquery easyui:table {total:32,row:[{},{}]}
//jquery：table在初始化的时候自动发送以下两个数据
int pagesize = int.Parse(Request["rows"] ?? "10");
int pageindex = int.Parse(Request["page"] ?? "1");
int total = 0;
//过滤的用户名和过滤的备注
//{ searchName: $("#txtsName").val(), searchRemark: $("#txtSchRemark").val() };
string schName = Request["searchName"];
string schRemark = Request["searchRemark"];
//short delflag = (short)Model.Enums.DelFlagEnum.Normal;
//拿到当前页的数据
var param = new UserQueryParam()
{
PageIndex = pageindex,
PageSize = pagesize,
SchName = schName,
SchRemark = schRemark,
Total = total
};
var pageData = u.LoadPageData(param);
var temp = pageData.Select(u => new
{
ID = u.ID,
UserName = u.UName,
Remark = u.Remark,
Pwd = u.UPwd,
SubTime = u.SubTime,
});
//var pageData = u.GetPageEntities(
// pagesize, pageindex, out total,
// u => u.DelFlag == delflag,
// u => u.ID, true).Select(
// u => new
//{
// ID = u.ID,
// UserName = u.UName,
// Remark = u.Remark,
// Pwd = u.UPwd,
// SubTime = u.SubTime,
//});
var data = new { total = param.Total, rows = temp.ToList() };
//有导航属性的时候，使用微软默认序列化会有问题
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <inheritdoc/>
public async Task <PagesListModel <UserDto> > GetUsersAsync(UserQueryParam param)
{
var users = ObjMapper.Map <IList <User>, IList <UserDto> >(await _userManager.Users.ToListAsync());
var usersPagesList = await PagesList <UserDto> .GetPagesListAsync(users.AsQueryable(), param);
foreach (var user in usersPagesList)
{
user.Roles = await _rolesService.GetUserRolesAsync(user.Id);
}
var result = ObjMapper.Map <PagesList <UserDto>, PagesListModel <UserDto> >(usersPagesList);
return(result);
}
private void LoadSearchData(string uqmStr)
{
//FormCollection fm = Common.SerializerHelper.DeserializeToObject<FormCollection>(fmStr);
//qm = Common.SerializerHelper.DeserializeToObject<UserQueryParam>(fm["FormQm"]);
int recordCount;
UserQueryParam uqm = Common.SerializerHelper.DeserializeToObject <UserQueryParam>(uqmStr);
var users = userInfoBll.GetSearchIndex(uqm, u => u.ID, out recordCount).ToList();
//grid1.DataSource(users,new string[] { "ID", "UName", "ShowName", "Remark", "SubTime" } , true);
//grid1.RecordCount(recordCount);
ViewBag.Grid1DataSource = users;
ViewBag.Grid1RecordCount = recordCount;
ViewBag.qm = Common.SerializerHelper.SerializerToString(uqm);
}
public ActionResult GetAllUserInfo()
{
int pageSize = int.Parse(Request["limit"] ?? "5");
int offset = int.Parse(Request["offset"] ?? "0");
int pageIndex = (offset / pageSize) + 1;
UserQueryParam userQueryParam = new UserQueryParam();
if (!string.IsNullOrEmpty(Request["filter"])) //过滤
{
userQueryParam = Newtonsoft.Json.JsonConvert.DeserializeObject <UserQueryParam>(Request["filter"]);
}
userQueryParam.PageSize = pageSize;
userQueryParam.PageIndex = pageIndex;
if (LoginOrganize.OrganizeInfoManageId != null) //判断是不是拥有最高权限
{
userQueryParam.OrganizeInfoID = LoginOrganize.OrganizeInfoID;
userQueryParam.isSuper = false;
}
else
{
userQueryParam.isSuper = true;
}
userQueryParam.Total = 0;
//显示各个人的信息
var pageData = UserInfoService.LoadPageData(userQueryParam).Select(u => new
{
u.UserInfoID,
u.UserInfoLoginId,
u.UserInfoShowName,
u.Department.DepartmentName,
u.OrganizeInfoID,
u.OrganizeInfo.OrganizeInfoShowName,
u.UserInfoEmail,
u.Political.PoliticalName,
u.Major.MajorName,
u.UserInfoTalkCount,
u.UserInfoLastTime,
u.UserInfoPhone,
u.UserInfoStuId,
u.UserDuration.UserDurationNormalTotal,
u.UserDuration.UserDurationPartyTotal,
u.UserDuration.UserDurationPropartyTotal,
u.UserDuration.UserDurationTotal,
u.Status,
}).AsQueryable();
var data = new { total = userQueryParam.Total, rows = pageData.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
public async void GetUsers_UsersDontExist_ReturnsNoContentResult()
{
//Arrange
var param = new UserQueryParam();
var users = new PagesListModel <UserDto>();
_accountService.Setup(cfg => cfg.GetUsersAsync(param)).ReturnsAsync(users);
//Act
var response = await _accountController.GetUsers(param);
//Assert
Assert.NotNull(response);
Assert.IsType <NoContentResult>(response.Result);
}
public ActionResult GetAllUserInfos()
{
//jquery easyui:table:{total:32,rows:[{},{}]}
//easy ：table在初始化的时候自动发送一下两个参数值
int pageSize = int.Parse(Request["rows"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
int total = 0;
//过滤用户名 过滤备注 ,没有过滤信息直接拿到所有
//拿到当前页的数据,带有导航属性时，使用select过滤一下
string schName = Request["schName"];
string schRemark = Request["schRemark"];
var queryParam = new UserQueryParam()
{
PageIndex = pageIndex,
PageSize = pageSize,
Total = 0,
SchName = schName,
SchRemark = schRemark
};
var pageData = UserInfoService.LoadPageData(queryParam);
var temp = pageData.Select(
u => new
{
u.Id,
u.UName,
u.Remark,
u.ShowName,
u.SubTime,
u.ModfiliedOn,
u.Pwd
});
////拿到当前页的数据,带有导航属性时，使用select过滤一下
//var pageData = UserInfoService.GetPageEntities(
// pageSize,
// pageIndex,
// out total,
// u => u.DelFlag == delFlagNormal,
// u => u.Id,
// true).Select(u => new { u.Id, u.UName, u.Remark, u.ShowName, u.SubTime, u.ModfiliedOn, u.Pwd });
var data = new { total = queryParam.Total, rows = temp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取用户数据
/// </summary>
/// <returns></returns>
public ActionResult GetAllUserInfos()
{
//JQuery easyUI:table:{total:32,row:[{},{}]}
//初始化自动发送一下两个参数
int pageSize = int.Parse(Request["rows"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
int total = 0;
//数据过滤
string schName = Request["schName"];
string schRemark = Request["schRemark"];
//short delflagNormal = (short)Moshang.OA.Model.Enum.DelFlagEnum.Normal;
//获取当前页数据
var queryParam = new UserQueryParam()
{
PageIndex = pageIndex,
PageSize = pageSize,
Total = 0,
SchName = schName,
SchRemark = schRemark
};
var pageData = UserInfoService.LoagPageData(queryParam);
var temp = pageData.Select(
u => new
{
ID = u.ID,
u.UName,
u.Remark,
u.ShowName,
u.SubTime,
u.ModfiedOn,
u.Pwd
});
//序列化实体注意导航属性依赖
var data = new { total = queryParam.Total, rows = temp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
public OrganisationResponse ExecuteCreate(string accessToken, OrganisationRequest requestParams)
{
var gatewayResponse = _organisationsGateway.CreateOrganisation(requestParams.ToEntity());
if (gatewayResponse != null)
{
var session = _sessionsGateway.GetSessionByToken(accessToken);
var userQueryParam = new UserQueryParam {
Sort = "Name", Direction = "asc"
};
var adminUsers = _usersGateway.GetAllUsers(userQueryParam).Result
.Where(u => u.UserRoles.Any(ur => ur.Role.Name == "Admin"));
var adminEmails = adminUsers.Select(au => au.Email).ToArray();
_notifyGateway.SendMessage(NotifyMessageTypes.AdminNotification, adminEmails, requestParams.StatusMessage);
}
return(gatewayResponse == null ? new OrganisationResponse() : gatewayResponse.ToResponse());
}
public ActionResult GetAllUserInfos()
{
//jquery easyui:table:{total:32,row:[{},{}]}
// easyui:table 在初始化的时候自动发送以下俩个参数值
int pageSize = int.Parse(Request["limit"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
//int total = 0;
//过滤的用户名 过滤备注schName schRemark
var queryParam = new UserQueryParam()
{
PageSize = pageSize,
PageIndex = pageIndex,
Total = 0,
};
//var pageData = UserInfoService.LoagPageData(queryParam).ToList();
var pageData = UserInfoService.LoagUserPageData(queryParam).ToList();
//var temp = pageData.Select(u => new
//{
// u.Id,
// u.UName,
// u.SubTime,
// u.ModfiedOn,
// u.Pwd,
//});
//拿到当前页的数据
//var pageData = UserInfoService.GetPageEntities(pageSize, pageIndex,
// out total, u => u.DelFlag == delflagNormal, u => u.Id,
// true)
// .Select(
// u =>
// new { u.Id, u.UName, u.Remark, u.ShowName, u.SubTime, u.ModfiedOn, u.Pwd }
// );
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult Grid1_PageIndexChanged(FormCollection fm, string[] Grid1_fields, string SearchQm, int Grid1_pageIndex)
{
var grid1 = UIHelper.Grid("Grid1");
UserQueryParam uqm = Common.SerializerHelper.DeserializeToObject <UserQueryParam>(SearchQm);
if (uqm.ID > 0)
{
qm.ID = uqm.ID;
}
if (!string.IsNullOrEmpty(uqm.UName))
{
qm.UName = uqm.UName;
}
if (!string.IsNullOrEmpty(uqm.ShowName))
{
qm.ShowName = uqm.ShowName;
}
if (!string.IsNullOrEmpty(uqm.Remark))
{
qm.Remark = uqm.Remark;
}
if (uqm.TimeAfter > DateTime.MinValue)
{
qm.TimeAfter = uqm.TimeAfter;
}
if (uqm.TimeBefore > DateTime.MinValue)
{
qm.TimeBefore = uqm.TimeBefore;
}
int recordCount;
qm.pageIndex = Grid1_pageIndex;
//qm.orderBy = u => u.ID;
// .获取当前分页数据
//var dataSource = userInfoBll.GetEntitiesIndex(pageIndex: Grid1_pageIndex, pageCount: 3,Total :out recordCount,whereLambda:u=>true,orderbyLambda:s=>s.ID,isAsc:true).ToList();
//var dataSource = userInfoBll.GetSearchAll(qm, out recordCount).OrderBy(u => u.ID).Skip(qm.pageCount * qm.pageIndex).Take(qm.pageCount).ToList();
var dataSource = userInfoBll.GetSearchIndex(qm, u => u.ID, out recordCount).ToList();
// .设置总项数（数据库分页回发时，如果总记录数不变，可以不设置RecordCount）
grid1.RecordCount(recordCount);
grid1.DataSource(dataSource, new string[] { "ID", "UName", "ShowName", "Remark", "SubTime" }, false);
ViewBag.qm = Common.SerializerHelper.SerializerToString(qm);
return(UIHelper.Result());
}
public ActionResult GetAllRoleInfos()
{
// jQuery easyui: table format: {total:32, rows:[{}{}]}
// those data are passing through the Request from client, when the table is initialized.
int pageSize = int.Parse(Request["rows"] ?? "10");
int pageIndex = int.Parse(Request["page"] ?? "1");
int totalData = 0;
string srchName = Request["srchName"];
string srchRemark = Request["srchRemark"];
short Normal = (short)MAP.OA.Model.Enum.DelFlagEnum.Normal;
#region Old Pagination
//// Get the current page data
//// 如果有导航属性时，使用微软的默认序列化方式的时候会出现问题: 循环引用的问题
//// 解决方案: 直接选要显示的属性(非导航属性)
//var pageData = ActionInfoService.GetPageEntities(
// pageSize,
// pageIndex,
// out totalData,
// u => u.DelFlag == Normal,
// u => u.Id,
// true).Select(u => new { u.Id, u.ActionName, u.Url, u.HttpMethod, u.IsMenu, u.MenuIcon, u.Sort, u.SubTime, u.ModifiedOn, u.Remark });
#endregion
var userQueryParam = new UserQueryParam()
{
PageIndex = pageIndex,
PageSize = pageSize,
Total = 0,
SrchName = srchName,
SrchRemark = srchRemark
};
var pageData = RoleInfoService.LoadPageData(userQueryParam)
.Select(u => new { u.Id, u.RoleName, u.ModifiedOn, u.SubTime, u.Remark });
var data = new { total = userQueryParam.Total, rows = pageData.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}
public IQueryable <UserInfo> LoadPageData(UserQueryParam userQueryParam)
{
short DelFlagNormal = (short)Model.Enum.DelFlagEnum.Normal;
var temp = DbSession.UserInfoDal.GetEntities(u => u.DelFlag == DelFlagNormal);
if (!string.IsNullOrEmpty(userQueryParam.schName))
{
temp = temp.Where(u => u.Uname.Contains(userQueryParam.schName));
}
if (!string.IsNullOrEmpty(userQueryParam.schRemark))
{
temp = temp.Where(u => u.Remark.Contains(userQueryParam.schRemark));
}
userQueryParam.total = temp.Count();
return(temp.OrderBy(u => u.Id)
.Skip(userQueryParam.PageSize * (userQueryParam.PageIndex - 1))
.Take(userQueryParam.PageSize).AsQueryable());
}
