//public override void SetCurrentDal()
//{
// this.currentDal =DBSession.userInfoDal;
//}
#endregion
/// <summary>
/// 多条件搜索
/// </summary>
/// <param name="userSearchParms"></param>
/// <returns></returns>
public IQueryable <UserInfo> GetPageEntityBySearch(UserSearchParms userSearchParms)
{
short normal = (short)DelFlagEnum.Normal;
var temp = DBSession.UserInfoDal.GetEntities(u => u.DelFlag == normal);
if (!string.IsNullOrEmpty(userSearchParms.schName))
{
temp = temp.Where <UserInfo>(u => u.UName.Contains(userSearchParms.schName));
}
if (!string.IsNullOrEmpty(userSearchParms.schRemark))
{
temp = temp.Where <UserInfo>(u => u.Remark.Contains(userSearchParms.schRemark));
}
userSearchParms.total = temp.Count();
return(temp.OrderBy <UserInfo, int>(u => u.ID)
.Skip(userSearchParms.pageSize * (userSearchParms.pageIndex - 1))
.Take(userSearchParms.pageSize));
}
//获取用户数据
public ActionResult GetUserInfo()
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int totalCount = 0;
string schName = Request["schName"]; //获取要搜索的用户名
string schRemark = Request["schRemark"]; //获取要搜索的备注
UserSearchParms userSearchParms = new UserSearchParms()
{
pageIndex = pageIndex,
pageSize = pageSize,
total = totalCount,
schName = schName,
schRemark = schRemark
};
var userInfoList = userInfoService.GetPageEntityBySearch(userSearchParms);
//short delFlag = (short)DelFlagEnum.Normal;
//var userInfoList = userInfoService.GetPageEntities(pageSize, pageIndex, out totalCount, u => u.DelFlag == delFlag, u => u.ID, true);
var temp = from u in userInfoList
select new { ID = u.ID, UName = u.UName, Pwd = u.Pwd, ShowName = u.ShowName, Remark = u.Remark, ModfiedOn = u.ModfiedOn };
return(Json(new { rows = temp, total = userSearchParms.total }, JsonRequestBehavior.AllowGet));
}
