public async Task <JsonResult> GetUserList2(QueryUserModel pageBase)
{
pageBase.AdminId = loginDto.CurrentId;
var list = await _userService.GetUserList2(pageBase);
return(Jsons(list));
}
public async Task <QueryResult <RepairManDTO> > GetRepairManList(QueryUserModel pageBase)
{
var community = await _communityService.GetAllAsync();
Expression <Func <User, bool> > func = p => p.IsRepairMan;
if (!string.IsNullOrWhiteSpace(pageBase.mobile))
{
func = func.And(p => p.Mobile == pageBase.mobile);
}
var list = await _repository.PageListAsync(func.Compile(), p => p.Id, pageBase);
var dtoList = list.List.MapTo <List <RepairManDTO> >();
dtoList.ForEach(p =>
{
var nameList = community.Where(x => x.RepairManId == p.Id).Select(x => x.Name).ToList();
p.CommunityName = string.Join(",", nameList);
});
var result = new QueryResult <RepairManDTO>();
result.List = dtoList;
result.Total = list.Total;
return(result);
}
/// <summary>
/// 获取用户信息列表
/// </summary>
/// <param name="parameterJson"></param>
/// <param name="jqgridparam"></param>
/// <returns></returns>
public JsonResult GetUserListByQuery(string parameterJson, JqGridParam jqgridparam)
{
var model = new QueryUserModel();
if (!string.IsNullOrWhiteSpace(parameterJson))
{
model = JsonConvert.DeserializeObject <QueryUserModel>(parameterJson);
}
model.PageIndex = jqgridparam.page;
model.PageSize = jqgridparam.rows;
model.UserType = (int)EnumUserType.User;
var send = JsonConvert.SerializeObject(model);
var result = ServiceHelper.CallService <PagedListData <List <SysUser> > >(
ServiceConst.SysUserApi.GetUserListByQuery,
send, this.CurrentUser.Token);
var json = new
{
page = result.Data.PagingInfo.PageIndex,
total = result.Data.PagingInfo.PageCount,
records = result.Data.PagingInfo.TotalCount,
rows = result.Data.PagingData.ToArray()
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
public async Task <QueryResult <User> > GetUserList2(QueryUserModel pageBase)
{
var comm = await _communityService.FirstOrDefult(p => p.AdminId == pageBase.AdminId);
var sql = $" SELECT u.* from RepairMan r RIGHT JOIN Users u ON u.Id = r.UserId where r.CommunityId = {comm.Id} ";
var list = await DapperService.PageList <User>(sql, pageBase);
return(list);
}
public async Task <QueryResult <User> > GetAllRepair(QueryUserModel pageBase)
{
var comm = await _communityService.FirstOrDefult(p => p.AdminId == pageBase.AdminId);
var sql = $" SELECT * FROM Users WHERE IsRepairMan = 1 ";
var list = await DapperService.PageList <User>(sql, pageBase);
return(list);
}
public ResponseResult <PagedListData <List <SysUser> > > GetUserListByQuery(QueryUserModel query)
{
PagedListData <List <SysUser> > model = new PagedListData <List <SysUser> >();
var userService = GetService <SysUserService>();
var result = userService.GetUserListByQuery(query);
model.PagingData = result.PagingData?.ToList();
model.PagingInfo = result.PagingInfo;
return(ResponseResult <PagedListData <List <SysUser> > > .GenSuccessResponse(model));
}
public IActionResult CommunityMan(int commuityId, int type = 0)
{
var SearchModel = new QueryUserModel();
if (type == 1 || type == 4)
{
SearchModel.IsRepair = true;
}
ViewBag.SearchModel = SearchModel;
return(View());
}
public JsonResult GetUserListByQuery(JqGridParam jqgridparam)
{
QueryUserModel query = new QueryUserModel()
{
PageIndex = jqgridparam.page,
PageSize = jqgridparam.rows,
OrderBy = jqgridparam.sord
};
var result = ServiceHelper.CallService <PagedListData <List <SysUser> > >(ServiceConst.SysUserApi.GetUserListByQuery,
JsonConvert.SerializeObject(query), this.CurrentUser.Token);
var json = result.Data.JqGridJsonData();
return(Json(json, JsonRequestBehavior.AllowGet));
}
public JsonResult GetShopListByQuery(JqGridParam jqgridparam)
{
QueryUserModel query = new QueryUserModel()
{
PageIndex = jqgridparam.page,
PageSize = jqgridparam.rows,
OrderBy = jqgridparam.sord,
Where = $" and UserId={CurrentUser.UserId}"
};
var result = ServiceHelper.CallService <PagedListData <List <ShipInfo> > >(ServiceConst.BizApi.ShopGetPage,
JsonConvert.SerializeObject(query), this.CurrentUser.Token);
var json = result.Data.JqGridJsonData();
return(Json(json, JsonRequestBehavior.AllowGet));
}
public async Task <QueryResult <User> > GetUserList(QueryUserModel pageBase)
{
Expression <Func <User, bool> > func = p => !p.IsAdmin;
if (!string.IsNullOrWhiteSpace(pageBase.mobile))
{
func = func.And(p => p.Mobile == pageBase.mobile);
}
if (pageBase.IsRepair.HasValue)
{
func = func.And(p => p.IsRepairMan == pageBase.IsRepair);
}
var list = await _repository.PageListAsync(func.Compile(), p => p.Id, pageBase);
return(list);
}
public override bool Execute()
{
QueryUserModel qum = new QueryUserModel();
qum.Username = random.Next(1, 100)+"";
qum.FirstName = random.Next(1, 100) + "";
qum.LastName = random.Next(1, 100) + "";
qum.Email = random.Next(1, 100) + "";
IEnumerable<UserProfileModel> results = accountServices.QueryUsers(qum);
Console.WriteLine("Results of user search:");
foreach (UserProfileModel userProfile in results)
{
Console.WriteLine("\t{0} {1}\n", userProfile.FirstName, userProfile.LastName);
}
return true;
}
/// <summary>
/// 获取所有的用户信息分页列表
/// </summary>
/// <returns></returns>
internal DataTable GetList(Paging paging, QueryUserModel queryUserModel)
{
List <SqlParameter> parms = new List <SqlParameter>()
{
new SqlParameter("@Key", queryUserModel.Keyword),
new SqlParameter("@OrganizationId", queryUserModel.OrganizationId),
new SqlParameter("@DepartmentId", queryUserModel.DepartmentId),
new SqlParameter("@RroleGroupsId", queryUserModel.RoleGroupsId),
new SqlParameter("@CurrentPage", paging.PageIndex),
new SqlParameter("@PageSize", paging.PageSize)
};
if (queryUserModel.Status.HasValue)
{
parms.Add(new SqlParameter("@Status", queryUserModel.Status.Value));
}
return(DbHelper.DataTable("OMS_Sys_UserList", parms.ToArray(), ref paging));
}
/// <summary>
/// 查询用户信息列表（分页）
/// </summary>
/// <param name="query">查询条件</param>
/// <returns></returns>
public PagedListData <List <SysUser> > GetUserListByQuery(QueryUserModel query)
{
return(_sysUserRepository.GetUserListByQuery(query));
}
/// <summary>
/// 根据条件获取用户列表
/// </summary>
/// <param name="query"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public PagedListData <List <SysUser> > GetUserListByQuery(QueryUserModel query, IDbTransaction transaction = null)
{
var sql = @" DECLARE @Sql NVARCHAR(MAX);
DECLARE @Order NVARCHAR(200);
IF ( @OrderBy IS NOT NULL AND @OrderBy<>'')
BEGIN
SET @Order = 'ORDER BY ' + @OrderBy;
END;
ELSE
BEGIN
SET @Order = ' ORDER BY InDate DESC ';
END;
IF ( @Where IS NULL)
BEGIN
SET @Where = '';
END;
SET @Sql = N'
WITH SysUserList AS
(
SELECT ROW_NUMBER() OVER ( ' + @Order + ' ) RowNumber,
[Id]
,[UserName]
,[LoginName]
,[UserExtent]
,[Enabled]
,[UserIsFreeze]
,[UserIsManage]
,[UserRemark]
,[BeginDate]
,[ExpireDade]
,[IsExpireDate]
,[PartitionFalg]
,[FlowDepId]
,[FlowTypeCode]
,[UserType]
,[UserPosition]
,[UserCustomerId]
,[PlaneNumber]
,[WhetherDog]
,[Securitylevel]
,[DistrictId]
,[DataGroupId]
,[InUser]
,[InDate]
,[EditUser]
,[EditDate]
,[DelUser]
,[DelState]
,[DelDate]
FROM dbo.SysUser WHERE DelState = 0 AND Enabled=1' + @Where + '
)
SELECT
A.[Id]
,A.[UserName]
,A.[LoginName]
,A.[UserExtent]
,A.[Enabled]
,A.[UserIsFreeze]
,A.[UserIsManage]
,A.[UserRemark]
,A.[BeginDate]
,A.[ExpireDade]
,A.[IsExpireDate]
,A.[PartitionFalg]
,A.[FlowDepId]
,A.[FlowTypeCode]
,A.[UserType]
,A.[UserPosition]
,A.[UserCustomerId]
,A.[PlaneNumber]
,A.[WhetherDog]
,A.[Securitylevel]
,A.[DistrictId]
,A.[DataGroupId]
,A.[InUser]
,CONVERT(varchar(20), A.[InDate], 20) InDate
,A.[EditUser]
,CONVERT(varchar(20), A.[EditDate], 20) EditDate
,A.[DelUser]
,A.[DelState]
,A.[DelDate]
,D.UserName InUserName
,E.UserName EditUserName
FROM SysUserList A
LEFT JOIN SysUser D
ON A.InUser=D.Id
LEFT JOIN SysUser E
ON A.EditUser=E.Id
WHERE (RowNumber BETWEEN ( @PageSize * ( @CurrentPageIndex - 1 ) + 1 )
AND @PageSize * @CurrentPageIndex )
SELECT @Count = COUNT(1)
FROM dbo.SysUser WHERE DelState = 0 AND Enabled=1 AND UserIsManage=0 ' + @Where;
EXECUTE sp_executesql @Sql,N'
@CurrentPageIndex INT,
@PageSize INT,
@Where NVARCHAR(1000),
@OrderBy NVARCHAR(200),
@Count int OUT',
@CurrentPageIndex,
@PageSize,
@Where,
@OrderBy,
@Count OUTPUT;";
PagedListData <List <SysUser> > model = new PagedListData <List <SysUser> >();
var dp = new DynamicParameters();
dp.Add("@CurrentPageIndex", query.PageIndex);
dp.Add("@PageSize", query.PageSize);
dp.Add("@Where", query.Where);
dp.Add("@OrderBy", query.OrderBy);
dp.Add("@Count", 0, DbType.Int32, ParameterDirection.Output);
var data = this.Query(sql, dp, transaction);
var pageInfo = new PagingInfo(query.PageSize, query.PageIndex);
model.PagingData = data?.ToList();
pageInfo.TotalCount = dp.Get <int>("@Count");
model.PagingInfo = pageInfo;
return(model);
}
public IEnumerable<UserProfileModel> QueryUsers(QueryUserModel queryModel)
{
IQueryable<User> usernameMatches = db.Users.Where(u => u.Username.ToLower().Contains(queryModel.Username.ToLower()));
IQueryable<UserProfile> firstNameMatches = db.UserProfiles.Where(up => up.FirstName.ToLower().Contains(queryModel.FirstName.ToLower()));
IQueryable<UserProfile> lastNameMatches = db.UserProfiles.Where(up => up.LastName.ToLower().Contains(queryModel.LastName.ToLower()));
IQueryable<User> emailMatches = db.Users.Where(u => u.Email.ToLower().Contains(queryModel.Email.ToLower()));
List<UserProfileModel> results = new List<UserProfileModel>();
foreach (User user in usernameMatches)
{
results.Add(Utilities.UserProfileToUserProfileModel(user.UserProfile));
}
foreach (UserProfile userProfile in firstNameMatches)
{
results.Add(Utilities.UserProfileToUserProfileModel(userProfile));
}
foreach (UserProfile userProfile in lastNameMatches)
{
results.Add(Utilities.UserProfileToUserProfileModel(userProfile));
}
foreach (User user in emailMatches)
{
results.Add(Utilities.UserProfileToUserProfileModel(user.UserProfile));
}
return results.AsQueryable();
}
/// <summary>
/// 获得用户列表
/// </summary>
/// <param name="paging"></param>
/// <param name="key"></param>
/// <returns></returns>
public DataTable GetList(Paging paging, QueryUserModel queryUserModel)
{
return(_dal.GetList(paging, queryUserModel));
}
public async Task <JsonResult> GetUserList(QueryUserModel pageBase)
{
var list = await _userService.GetUserList(pageBase);
return(Jsons(list));
}
