/// <summary> /// 获取供应商列表 /// </summary> /// <param name="arg"></param> /// <returns></returns> public async Task <IApiResult> GetList(P_Users.P_GetUserListPage arg) { return(await Task.Run(() => { IApiResult ar = new IApiResult(); var userid = userInfo.UserID; try { using (DAL.CarRentEntities db = new DAL.CarRentEntities()) { var query = from u in db.Users where u.ParentID == userid && u.Deleted == false select new Models.Return.R_Users.GetUsersListPage_Result.GetUsersListPage_List { UserID = u.UserID, UserName = u.UserName, LoginName = u.LoginName, Contact = u.FirstName ?? "", CellPhone = u.CellPhone ?? "", Price = u.ActivationCount, AllDeviceCount = u.AllDeviceCount, Created = u.Created, Address = u.Address1 ?? "" }; if (arg.start_date != null) { query = query.Where(u => u.Created >= arg.start_date); } if (arg.end_date != null) { query = query.Where(u => u.Created <= arg.end_date); } if (!string.IsNullOrEmpty(arg.keyword)) { query = query.Where(u => u.UserName.Contains(arg.keyword) || u.LoginName.Contains(arg.keyword) || u.Contact.Contains(arg.keyword) || u.CellPhone.Contains(arg.keyword)); } int index = (arg.p - 1) * arg.pagesize; var total = query.Count(); var list = query.OrderBy(u => u.UserID).Skip(index).Take(arg.pagesize).ToList(); list.ForEach(item => item.RowIndex = ++index); ar.result = new { total = total, pages = Math.Ceiling(Convert.ToDecimal(total / Convert.ToDouble(arg.pagesize))), list = list, }; ar.message = $"There are {total} data"; } } catch (Exception ex) { Log.Error(this, ex); ar.code = StatusCode.error; ar.message = ex.Message; } return ar; })); }
public async Task <IApiResult> GetUserList([FromUri] P_Users.P_GetUserListPage pars) { return(await ApiAsync(pars, new BLL.UsersManager.Users().GetList)); }