public IQueryable <RoleInfo> LoadPageData(Model.Param.UserQueryParam userQueryParam)
{
var temp = CurrentDal.GetEntities(u => u.DelFlag == (short)DelFlagEnum.Normal);
if (!string.IsNullOrEmpty(userQueryParam.SrchName))
{
temp = temp.Where(u => u.RoleName.Contains(userQueryParam.SrchName));
}
if (!string.IsNullOrEmpty(userQueryParam.SrchRemark))
{
temp = temp.Where(u => u.Remark.Contains(userQueryParam.SrchRemark));
}
userQueryParam.Total = temp.Count();
// Pagination
return(temp.OrderBy(u => u.Id)
.Skip(userQueryParam.PageSize * (userQueryParam.PageIndex - 1))
.Take(userQueryParam.PageSize).AsQueryable());
}
//1233
#region old2
//让一个菜鸟到另一个一般开发人员。
//依赖接口编程。
//IUserInfoDal UserInfoDal = new UserInfoDal();
//稍微高级点开发人员也不能这么写。
//private IUserInfoDal UserInfoDal = StaticDalFactory.GetUserInfoDal();
//DbSession dbSession =new DbSession();
//IDbSession dbSession = new DbSession();
//private IDbSession dbSession = DbSessionFactory.GetCurrentDbSession();
#endregion
#region old
//更高级：IoC、DI 依赖注入的方式。 Spring.Net
//public UserInfo Add(UserInfo userInfo)//UnitWork单元工作模式。
//{
// //10000:每个用户
// dbSession.UserInfoDal.Add(userInfo);
// if (dbSession.SaveChanges() > 0)
// {
// }
// dbSession.UserInfoDal.Add(new UserInfo());
// dbSession.OrderInfoDal.Delete(new OrderInfo());
// dbSession.OrderInfoDal.Update(new OrderInfo());
// dbSession.SaveChanges();//数据提交的权利从数据库访问层提到了业务逻辑层。
// //return UserInfoDal.Add(userInfo);
//}
#endregion
//public override void SetCurrentDal()
//{
// CurrentDal = this.DbSession.UserInfoDal;
//}
#region 多条件查询
public IQueryable <UserInfo> LoagPageData(Model.Param.UserQueryParam userQueryParam)
{
short normalFlag = (short)Heima8.OA.Model.Enum.DelFlagEnum.Normal;
var temp = DbSession.UserInfoDal.GetEntities(u => u.DelFlag == normalFlag);
//过滤
if (!string.IsNullOrEmpty(userQueryParam.SchName))
{
temp = temp.Where(u => u.UName.Contains(userQueryParam.SchName)).AsQueryable();
}
if (!string.IsNullOrEmpty(userQueryParam.SchRemark))
{
temp = temp.Where(u => u.Remark.Contains(userQueryParam.SchRemark)).AsQueryable();
}
userQueryParam.Total = temp.Count();
//分页
return(temp.OrderBy(u => u.ID)
.Skip(userQueryParam.PageSize * (userQueryParam.PageIndex - 1))
.Take(userQueryParam.PageSize).AsQueryable());
}
public ActionResult GetAllUserInfos()
{
int pageSize = Int32.Parse(Request["rows"] ?? "10");
int pageIndex = Int32.Parse(Request["page"] ?? "1");
int total = 0;
string rchName = Request["rchName"];
string rchRemark = Request["rchRemark"];
var queryParam = new Model.Param.UserQueryParam
{
PageIndex = pageIndex,
PageSize = pageSize,
total = total,
schName = rchName,
schRemark = rchRemark
};
var pageData = UserInfoService.LoadPageData(queryParam);
var temp = pageData.Select(u => new { u.Id, u.Uname, u.Pwd, u.Remark, u.ModfiedOn, u.Subtime, u.ShowName }).AsQueryable();
// .Select(u=>new {u.Id,u.Uname,u.Pwd,u.Remark,u.ModfiedOn,u.Subtime,u.ShowName });
var data = new { queryParam.total, rows = temp.ToList() };
return(Json(data, JsonRequestBehavior.AllowGet));
}