public async Task <IEnumerable <LoginUser> > SearchInfo()
{
List <LoginUser> list = null;
await ServiceProxyFactory.LifeTime(async factory =>
{
var service = factory.Create <LoginUserMasterClient>();
LoginUserSearch loginUserSearch;
if (onlyUseClient)
{
loginUserSearch = new LoginUserSearch {
UseClient = 1
};
}
else
{
loginUserSearch = new LoginUserSearch();
}
UsersResult result = await service.GetItemsAsync(Application.Login.SessionKey,
Application.Login.CompanyId, loginUserSearch);
if (result.ProcessResult.Result)
{
list = result.Users;
}
});
return(list);
}
public Task <IEnumerable <LoginUser> > GetAsync(LoginUserSearch option, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT lu.*
, dt.Code as DepartmentCode
, dt.Name AS DepartmentName
, st.Code AS StaffCode
, st.Name AS StaffName
FROM LoginUser AS lu
LEFT JOIN Department AS dt ON dt.Id = lu.DepartmentId
LEFT JOIN Staff AS st ON st.Id = lu.AssignedStaffId
WHERE lu.Id = lu.Id";
if (option.CompanyId.HasValue)
{
query += @"
AND lu.CompanyId = @CompanyId";
}
if (option.Ids?.Any() ?? false)
{
query += @"
AND lu.Id IN (SELECT Id FROM @Ids)";
}
if (option.Codes?.Any() ?? false)
{
query += @"
AND lu.Code IN (SELECT Code FROM @Codes)";
}
if (!string.IsNullOrWhiteSpace(option.Name))
{
option.Name = Sql.GetWrappedValue(option.Name);
query += @"
AND lu.Name LIKE @Name";
}
if (option.UseClient.HasValue)
{
query += @"
AND lu.UseClient = @UseClient";
}
if (option.ExcludeCodes?.Any() ?? false)
{
query += @"
AND EXISTS (
SELECT 1
FROM SectionWithLoginUser swl
WHERE swl.LoginUserId = lu.Id
)
AND lu.Code NOT IN (SELECT Code FROM @ExcludeCodes)";
}
query += @"
ORDER BY lu.CompanyId ASC
, lu.Code ASC";
return(dbHelper.GetItemsAsync <LoginUser>(query, new {
option.CompanyId,
option.Name,
option.UseClient,
Ids = option.Ids.GetTableParameter(),
Codes = option.Codes.GetTableParameter(),
ExcludeCodes = option.ExcludeCodes.GetTableParameter(),
}, token));
}
public async Task <IEnumerable <LoginUser> > GetAsync(LoginUserSearch option, CancellationToken token = default(CancellationToken)) => await loginUserQueryProcessor.GetAsync(option, token);
public async Task <IEnumerable <LoginUser> > GetItems(LoginUserSearch option, CancellationToken token) => (await loginUserProcessor.GetAsync(option, token)).ToArray();
public async Task <UsersResult> GetItemsAsync(string SessionKey, int CompanyId, LoginUserSearch LoginUserSearch)
{
return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token =>
{
LoginUserSearch.CompanyId = CompanyId;
var result = (await loginUserProcessor.GetAsync(LoginUserSearch, token)).ToList();
return new UsersResult
{
ProcessResult = new ProcessResult {
Result = true
},
Users = result,
};
}, logger));
}
