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));
}
