public PagedList <MpUserDTO> GetUsers(int pageIndex, int pageSize, MpUserDTO mpDto) { string sql = "select mug.*,mq.title , a.Name as LoginName from (select mp.*,(isnull(mp.Country,'')+','+isnull(mp.Province,'')+','+isnull(mp.City,'')) as Area,mpg.Name as CateName"; sql += " from mpuser mp,mpusergroup mpg where mp.MpGroupID=mpg.Id "; Dictionary <string, object> parms = new Dictionary <string, object>(); if (mpDto != null) { if (mpDto.MpGroupID != Guid.Empty) { sql += " and mp.MpGroupID=@gId"; parms.Add("gId", mpDto.MpGroupID.ToString()); } if (!string.IsNullOrEmpty(mpDto.NickName) && !string.IsNullOrEmpty(mpDto.NickName.Trim())) { sql += " and mp.NickName like @nickName"; parms.Add("nickName", "%" + mpDto.NickName.ToString() + "%"); } if (mpDto.IsAuth == 1) { sql += " and mp.IsAuth =1"; } } sql += ") as mug left join dbo.MpQrScene mq on mug.sceneid=mq.sceneid left join dbo.Admin a on mug.adminid = a.Id "; if (mpDto != null) { if (!string.IsNullOrEmpty(mpDto.LoginName) && !string.IsNullOrEmpty(mpDto.LoginName.Trim())) { sql += " where a.Name like @LoginName"; parms.Add("LoginName", "%" + mpDto.LoginName.Trim() + "%"); } if (!string.IsNullOrEmpty(mpDto.Qrcode)) { sql += " and mq.Title like @qrcode"; parms.Add("qrcode", "%" + mpDto.Qrcode.Trim() + "%"); } } sql += " order by mug.LastVisitDate desc"; return(this.GetPageList <MpUserDTO>(sql, parms, pageIndex, pageSize)); }
public ActionResult MpUserListProvide(MpUserDTO mpDto) { PagedList <MpUserDTO> list = MpUserService.GetUsers(PageIndex, PageSize, mpDto); return(JsonList <MpUserDTO>(list, list.TotalItemCount)); }