public PagerResult <GetCardsOutput> GetCards(GetCardsInput input)
{
//if( input.CardType.IsNullOrEmpty())
//{
// input.CardType = CardType.Default.Key;
//}
input.OrderBy = "AccountId";
var pagerWrapper = new PagerResult <GetCardsOutput>();
var table = from a in _cardRepository.GetAll()
join b in _accountRepository.GetAll()
on a.AccountId equals b.Id into temp
from B in temp.DefaultIfEmpty()
select new GetCardsOutput
{
AccountId = a.AccountId,
CardNo = a.CardNo,
CardType = a.CardType,
IsPasswordAuth = a.IsPasswordAuth,
Status = a.Status,
AccountName = B == null ? "": B.Name,
AccountIDCardNo = B == null ? "" : B.IDCardNo,
IsOnlyCancellation = a.CardType != CardType.Default.Key
};
var result = table
.WhereIf(!input.Name.IsNullOrEmpty(), a => a.AccountName.StartsWith(input.Name))
.WhereIf(!input.CardType.IsNullOrEmpty(), c => c.CardType == input.CardType)
.WhereIf(!input.CardNo.IsNullOrEmpty(), c => c.CardNo.StartsWith(input.CardNo))
.Page(input, pagerWrapper)
.ToList();
pagerWrapper.Result = result;
return(pagerWrapper);
}
public Task <PagerResult <ListEventlogResponse> > Handle(IReceiveContext <PagerQuery <ListEventlogRequest> > context, CancellationToken cancellationToken)
{
var query = context.Message;
var sql = from r in _context.Eventlog
join u in _context.User on r.OptionUserId equals u.Id
orderby r.Id descending
select new ListEventlogResponse
{
CreateTime = r.CreateTime,
Id = r.Id,
Content = r.Content,
OptionUsername = u.Username,
Title = r.Title,
};
if (query.Query?.BeginDate != null)
{
sql = sql.Where(x => x.CreateTime >= query.Query.BeginDate.Value);
}
if (query.Query?.EndDate != null)
{
sql = sql.Where(x => x.CreateTime < query.Query.EndDate.Value.AddDays(1));
}
var pager = new PagerResult <ListEventlogResponse>(query.Index, query.Size, sql);
return(Task.FromResult(pager));
}
public async Task <PagerResult <StoreRecordListApiModel> > GetPagerRecordListByInvoiceIdAsync(PagerQuery <int> query)
{
var invoice = _context.Invoice.First(x => x.Id == query.Query);
IQueryable <StoreRecordListApiModel> sql;
if (invoice.InvoiceTypeId == (int)InvoiceType.Client)
{
sql = GetPagerRecordListForClientByInvoiceId(invoice);
}
else
{
sql = GetPagerRecordListForChangeTypeByInvoiceId(invoice);
}
var data = new PagerResult <StoreRecordListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var departments = await _mediator.ListByIdsAsync <GetHospitalDepartmentRequest, GetHospitalDepartmentResponse>(data.Select(x => x.HospitalDepartment.Id));
var goods = await _mediator.ListByIdsAsync <GetHospitalGoodsRequest, GetHospitalGoodsResponse>(data.Select(x => x.HospitalGoods.Id).ToList());
foreach (var m in data.Result)
{
m.HospitalGoods = goods.FirstOrDefault(x => x.Id == m.HospitalGoods.Id);
m.HospitalDepartment = departments.FirstOrDefault(x => x.Id == m.HospitalDepartment.Id);
}
}
return(data);
}
public PagerResult <bjf_loginlog> GetPageList(QueryRole query)
{
//拼接sql条件查询-表达式树
var builder = PredicateBuilder.True <bjf_loginlog>();
var queryinfo = new QueryInfo <bjf_loginlog>()
{
wheresql = builder,
orderby = m => m.updatetime,
pageindex = query.PageIndex,
pagesize = query.PageSize
};
var list = this.SelectPageList(queryinfo);
var count = this.GetCountByQuery(queryinfo);
//返回到视图
var res = new PagerResult <bjf_loginlog>
{
DataList = list,
Total = count,
PageSize = query.PageSize,
PageIndex = query.PageIndex,
RequestUrl = query.RequetUrl
};
return(res);
}
public async Task <PagerResult <PurchaseGoodsBillnoListApiModel> > GetPagerListByClientAsync(PagerQuery <PurchaseGoodsBillnoListQueryModel> query, int clientId)
{
var sql = from r in _context.PurchaseGoodsBillno
join p in _context.PurchaseGoods on r.PurchaseGoodsId equals p.Id
join x in _context.Purchase on p.PurchaseId equals x.Id
join d in _context.HospitalDepartment on x.HospitalDepartmentId equals d.Id
join m in _context.Client2HospitalClient on p.HospitalClientId equals m.HospitalClientId
join u in _context.User on r.CreateUserId equals u.Id
where m.ClientId == clientId
orderby r.Id descending
select new PurchaseGoodsBillnoListApiModel
{
CreateTime = r.CreateTime,
Id = r.Id,
Qty = r.Qty,
PurchaseGoodsId = r.PurchaseGoodsId,
Status = r.Status,
HospitalGoods = new GetHospitalGoodsResponse {
Id = p.HospitalGoodsId,
},
HospitalClient = new GetHospitalClientResponse {
Id = p.HospitalClientId
},
Billno = r.Billno,
Enddate = r.Enddate,
CreateUserName = u.Username,
Price = r.Price,
Purchase = new PurchaseValueModel
{
Id = p.PurchaseId,
HospitalDepartment = new GetHospitalDepartmentResponse
{
Hospital = new GetHospitalResponse {
Id = d.HospitalId
},
Id = d.Id
}
},
};
sql = GetQueryableForList(sql, query.Query);
var data = new PagerResult <PurchaseGoodsBillnoListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var purachses = await _purchaseRespository.GetValueAsync(data.Result.Select(x => x.Purchase.Id).ToArray());
var clients = await _mediator.ListByIdsAsync <GetHospitalClientRequest, GetHospitalClientResponse>(data.Select(x => x.HospitalClient.Id));
var goods = await _mediator.ListByIdsAsync <GetHospitalGoodsRequest, GetHospitalGoodsResponse>(data.Select(x => x.HospitalGoods.Id).ToList());
foreach (var m in data.Result)
{
m.HospitalGoods = goods.FirstOrDefault(x => x.Id == m.HospitalGoods.Id);
m.Purchase = purachses.FirstOrDefault(x => x.Id == m.Purchase.Id);
m.HospitalClient = clients.FirstOrDefault(x => x.Id == m.HospitalClient.Id);
}
}
return(data);
}
/// <summary>
/// 导出用卡明细列表数据
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public HttpFileOutput DeriveBillingRecordList(InputBillingRecordListDto input)
{
string sql = string.Empty;
var parameters = HandleSQL(input, "export", out sql);
var pagerWrapper = new PagerResult <OutputDeriveBillingRecordListDto>();
pagerWrapper.Result = _databaseMediator.ExcuteSqlQueryAsync <OutputDeriveBillingRecordListDto>(sql, parameters).Result;
//预留：ex操作组件 begin
var excelFormatter = _formatterFactory.Create(FomatterType.Excel);
// 准备输出文件的路径（绝对路径）
var filePath = Path.Combine(
AppDomain.CurrentDomain.BaseDirectory,
PlatformServiceConst.TEMP_FILE_NAME,
$"{Guid.NewGuid().ToString()}.xlsx");
// 把Studen实体列表输出到指定路径
excelFormatter.FromListToFile <OutputDeriveBillingRecordListDto>(pagerWrapper.Result, filePath);
//预留：ex操作组件 end
return(new HttpFileOutput()
{
FilePath = filePath,
FileName = $"用卡明细列表数据{DateTime.Now.ToString("yyyyMMdd_HH:mm")}.xlsx"
});
}
// GET: Enrolls
public async Task <IActionResult> Index(EnrollsParam param)
{
//return View(await _context.Enrolls.ToListAsync());
ViewBag.SearchFilters = param.SearchFilters;
var list = string.IsNullOrWhiteSpace(param.SearchFilters) ?
await _context.Enrolls.OrderByDescending(x => x.CreateDate).AsNoTracking().ToListAsync() :
await _context.Enrolls.Where(x => x.Message.Contains(param.SearchFilters)).OrderByDescending(x => x.CreateDate).AsNoTracking().ToListAsync();
//paginate
var list_page = list.Skip(param.Skip).Take(param.PageSize);
//total count
var data_count = list.Count;
param.RequetUrl = Request.QueryString.Value;
var res = new PagerResult <Enroll>
{
Code = 0,
DataList = list_page,
Total = data_count,
PageSize = param.PageSize,
PageIndex = param.PageIndex,
RequestUrl = param.RequetUrl
};
return(View(res));
}
public async Task <PagerResult <StoreInoutGoodsListApiModel> > GetPagerListAsync(PagerQuery <StoreInoutGoodsListQueryModel> query)
{
var sql = from r in _context.StoreInoutGoods
orderby r.Id descending
select new StoreInoutGoodsListApiModel
{
CreateTime = r.CreateTime,
Id = r.Id,
Qty = r.Qty,
StoreInoutId = r.StoreInoutId,
HospitalGoods = new GetHospitalGoodsResponse
{
Id = r.HospitalGoodsId,
},
};
if (query.Query?.StoreInoutId != null)
{
sql = sql.Where(x => x.StoreInoutId == query.Query.StoreInoutId.Value);
}
var data = new PagerResult <StoreInoutGoodsListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var goods = await _mediator.ListByIdsAsync <GetHospitalGoodsRequest, GetHospitalGoodsResponse>(data.Select(x => x.HospitalGoods.Id).ToList());
foreach (var m in data.Result)
{
m.HospitalGoods = goods.FirstOrDefault(x => x.Id == m.HospitalGoods.Id);
}
}
return(data);
}
public async Task <PagerResult <CheckListGoodsPreviewListApiModel> > GetPagerPreviewListAsync(int checkListId, PagerQuery <CheckListGoodsPreviewQueryModel> query)
{
var sql = from r in _context.CheckListGoods
join u in _context.User on r.CreateUserId equals u.Id
where r.CheckListId == checkListId
select new CheckListGoodsPreviewListApiModel
{
CreateTime = r.CreateTime,
Id = r.Id,
CheckQty = r.CheckQty,
HospitalGoods = new GetHospitalGoodsResponse
{
Id = r.HospitalGoodsId,
},
CreateUsername = u.Username,
StoreQty = r.StoreQty,
};
var data = new PagerResult <CheckListGoodsPreviewListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var goods = await _mediator.ListByIdsAsync <GetHospitalGoodsRequest, GetHospitalGoodsResponse>(data.Select(x => x.HospitalGoods.Id).ToList());
foreach (var m in data.Result)
{
m.HospitalGoods = goods.FirstOrDefault(x => x.Id == m.HospitalGoods.Id);
}
}
return(data);
}
public PagerResult <Client2HospitalClientOverview> GetOverviewByPage(PagerQuery <Client2HospitalClientQurable> payload)
{
var sql = from p in _context.Client2HospitalClient
join u in _context.User on p.CreateUserId equals u.Id
join c in _context.HospitalClient on p.HospitalClientId equals c.Id
join h in _context.Hospital on c.HospitalId equals h.Id
join ct in _context.Client on p.ClientId equals ct.Id
orderby p.Id descending
select new Client2HospitalClientOverview
{
Client = ct,
Mapping = p,
HospitalClient = c,
Hospital = h,
User = u,
};
if (payload.Query?.HospitalId != null)
{
sql = sql.Where(x => x.Hospital.Id == payload.Query.HospitalId.Value);
}
if (payload.Query?.ClientId != null)
{
sql = sql.Where(x => x.Client.Id == payload.Query.ClientId.Value);
}
if (!string.IsNullOrEmpty(payload.Query?.Name))
{
sql = sql.Where(x => x.Client.Name.Contains(payload.Query.Name));
}
var data = new PagerResult <Client2HospitalClientOverview>(payload.Index, payload.Size, sql);
return(data);
}
public PagerResult <bjf_user> GetPageList(QueryUser query)
{
//拼接sql条件查询-表达式树
var builder = PredicateBuilder.True <bjf_user>();
builder = builder.And(m => m.isdelete == false);
//传参
if (!string.IsNullOrEmpty(query.loginname))
{
builder = builder.And(m => m.loginname == query.loginname);
}
var queryinfo = new QueryInfo <bjf_user>()
{
wheresql = builder,
orderby = m => m.updatetime,
pageindex = query.PageIndex,
pagesize = query.PageSize
};
var list = this.SelectPageList(queryinfo);
var count = this.GetCountByQuery(queryinfo);
//返回到视图
var res = new PagerResult <bjf_user>
{
DataList = list,
Total = count,
PageSize = query.PageSize,
PageIndex = query.PageIndex,
RequestUrl = query.RequetUrl
};
return(res);
}
public PagerResult<bjf_menu> GetPageList(PagerInBase query)
{
//拼接sql条件查询-表达式树
var builder = PredicateBuilder.True<bjf_menu>();
builder = builder.And(m => m.isdelete == false);
//传参
var queryinfo = new QueryInfo<bjf_menu>()
{
wheresql = builder,
orderby = m => m.updatetime,
pageindex = query.PageIndex,
pagesize = query.PageSize
};
var list = this.SelectPageList(queryinfo);
var count = this.GetCountByQuery(queryinfo);
//返回到视图
var res = new PagerResult<bjf_menu>
{
DataList = list,
Total = count,
PageSize = query.PageSize,
PageIndex = query.PageIndex,
RequestUrl = query.RequetUrl
};
return res;
}
/// <summary>
/// 获取结算明细
/// </summary>
public PagerResult <GetSettlementListOutput> GetSettlementList(GetSettlementListInput inputDto)
{
var result = new PagerResult <GetSettlementListOutput>();
if (!inputDto.StartTime.HasValue)
{
inputDto.StartTime = DateTime.Now.AddDays(-1);
}
if (!inputDto.EndTime.HasValue)
{
inputDto.EndTime = DateTime.Now;
}
var matchedRecords = _settlementRecordRepository.GetAllIncluding(p => p.OwedOperator)
.WhereIf(p => p.OwedOperator.UserName == inputDto.OperatorName, !inputDto.OperatorName.IsNullOrEmpty())
.WhereIf(p => p.SettleEndTime > inputDto.StartTime, inputDto.StartTime != default(DateTime))
.WhereIf(p => p.SettleEndTime <= inputDto.EndTime, inputDto.EndTime != default(DateTime))
.Page(inputDto, result)
.Select(p => new GetSettlementListOutput()
{
SettlementRecordId = p.Id.ToString(),
OperatorName = p.OwedOperator.UserName,
SettlementTime = p.SettleEndTime,
SettlementContent = p.AmountContent
}).ToList();
result.Result = matchedRecords;
return(result);
}
public async Task <PagerResult <PurchaseSettingThresholdListApiModel> > GetPagerListAsync(PagerQuery <PurchaseSettingThresholdListQueryModel> query)
{
var sql = from r in _context.PurchaseSettingThreshold
join p in _context.PurchaseSetting on r.PurchaseSettingId equals p.Id
join u in _context.User on r.CreateUserId equals u.Id
join t in _context.DataPurchaseThresholdType on r.ThresholdTypeId equals t.Id
orderby r.Id descending
select new PurchaseSettingThresholdListApiModel
{
CreateTime = r.CreateTime,
Id = r.Id,
CreateUserName = u.Username,
DownQty = r.DownQty,
UpQty = r.UpQty,
HospitalGoods = new GetHospitalGoodsResponse
{
Id = r.HospitalGoodsId,
},
ThresholdType = t,
};
var data = new PagerResult <PurchaseSettingThresholdListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var goods = await _mediator.ListByIdsAsync <GetHospitalGoodsRequest, GetHospitalGoodsResponse>(data.Select(x => x.HospitalGoods.Id).ToList());
foreach (var m in data.Result)
{
m.HospitalGoods = goods.FirstOrDefault(x => x.Id == m.HospitalGoods.Id);
}
}
return(data);
}
public JsonResult GetOnlineUsers(UserSearchModel searchModel)
{
var result = new ResponseResult();
try
{
var skip = (searchModel.PageIndex - 1) * searchModel.PageSize;
var onlienUsers = searchModel.UserType > 0
? PKBag.OnlineUserRecorder.GetUserList().Where(u => u.UserDegree == searchModel.UserType).OrderBy(u => u.UserName).Skip(skip).Take(searchModel.PageSize).ToList()
: PKBag.OnlineUserRecorder.GetUserList().OrderBy(u => u.UserName).Skip(skip).Take(searchModel.PageSize).ToList();
//var userNames = onlienUsers.Select(u => u.UserName).ToList();
//var users = new UserService().GetUsers(userNames);
var pager = new PagerResult <App.Core.OnlineStat.OnlineUser>();
pager.Items = onlienUsers;
pager.RowCount = PKBag.OnlineUserRecorder.GetUserList().Count;
pager.PageCount = pager.RowCount % searchModel.PageSize == 0 ? pager.RowCount / searchModel.PageSize : pager.RowCount / searchModel.PageSize + 1;
result.Data = pager;
}
catch (Exception ex)
{
result.Success = false;
result.Message = MessageConst.System_Error;
_logger.Info(ex);
}
return(Json(result));
}
public PagerResult <T> Find(IEnumerable <Expression <Func <T, bool> > > filters, Pager pager, OrderBy orderBy)
{
var exec = this.Query.AsQueryable <T>();
if (filters != null)
{
foreach (var f in filters)
{
exec = exec.Where(f);
}
}
var totalCount = pager != null && pager.IsValid() ? exec.Count() : 0;
if (orderBy != null)
{
exec = orderBy.Apply(exec);
}
if (pager != null && pager.IsValid())
{
exec = exec.Skip((pager.PageNum - 1) * pager.PageSize).Take(pager.PageSize);
}
var result = new PagerResult <T>(exec.AsEnumerable <T>().ToArray());
if (pager != null && pager.IsValid())
{
result.SetInfo(pager.PageNum, pager.PageSize, totalCount);
}
return(result);
}
public async Task <PagerResult <StoreRecordListApiModel> > GetPagerListAsync(PagerQuery <StoreRecordListQueryModel> query)
{
var sql = from r in _context.StoreRecord
join uc in _context.User on r.CreateUserId equals uc.Id
join ct in _context.DataStoreChangeType on r.ChangeTypeId equals ct.Id
orderby r.Id descending
select new StoreRecordListApiModel
{
Id = r.Id,
CreateTime = r.CreateTime,
CreateUserName = uc.Username,
ChangeQty = r.ChangeQty,
BeforeQty = r.BeforeQty,
Price = r.Price,
ChangeType = ct,
HospitalDepartment = new GetHospitalDepartmentResponse
{
Id = r.HospitalDepartmentId,
},
HospitalGoods = new GetHospitalGoodsResponse
{
Id = r.HospitalGoodsId,
},
};
if (query.Query?.HospitalDepartmentId != null)
{
sql = sql.Where(x => x.HospitalDepartment.Id == query.Query.HospitalDepartmentId.Value);
}
if (query.Query?.HospitalGoodsId != null)
{
sql = sql.Where(x => x.HospitalGoods.Id == query.Query.HospitalGoodsId.Value);
}
if (query.Query?.BeginDate != null)
{
sql = sql.Where(x => x.CreateTime >= query.Query.BeginDate.Value);
}
if (query.Query?.EndDate != null)
{
sql = sql.Where(x => x.CreateTime < query.Query.EndDate.Value.AddDays(1));
}
var data = new PagerResult <StoreRecordListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var departments = await _mediator.ListByIdsAsync <GetHospitalDepartmentRequest, GetHospitalDepartmentResponse>(data.Select(x => x.HospitalDepartment.Id));
var goods = await _mediator.ListByIdsAsync <GetHospitalGoodsRequest, GetHospitalGoodsResponse>(data.Select(x => x.HospitalGoods.Id).ToList());
foreach (var m in data.Result)
{
m.HospitalGoods = goods.FirstOrDefault(x => x.Id == m.HospitalGoods.Id);
m.HospitalDepartment = departments.FirstOrDefault(x => x.Id == m.HospitalDepartment.Id);
}
}
return(data);
}
internal async Task <PagerResult> LoadDataSource(int currentPage)
{
var result = new PagerResult()
{
Rows = Datas,
Total = Datas.Count
};
return(await Task.FromResult(result));
}
internal async Task <PagerResult> LoadDataSource(int currentPage)
{
var result = new PagerResult()
{
Rows = AllDatas.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList(),
Total = AllDatas.Count
};
return(await Task.FromResult(result));
}
public System.Web.Http.IHttpActionResult Get([FromQuery] string search, [FromQuery] int page, [FromQuery] int rows, [FromQuery] int order)
{
var list = ctx.listArtits(search, page, rows, (ArtitsOrderBy)order);
PagerResult result = new PagerResult(page, rows);
result.totalRecords = ctx.totalArtists();
result.setResult <Artist>(list);
return(Ok(result));
}
public static PagerResult <T> GetPagerList <T>(IList <T> list, PagerSupport criteria)
{
var result = new PagerResult <T>();
var limit = 20;
var offset = 0;
if (!DataCheckHelper.IsNull(criteria.Limit))
{
limit = decimal.ToInt32(criteria.Limit.Value);
if (limit <= 0)
{
limit = 10;
}
}
if (!DataCheckHelper.IsNull(criteria.Offset))
{
offset = decimal.ToInt32(criteria.Offset.Value);
if (offset <= 0 || offset > list.Count)
{
offset = 0;
}
}
result.AllRecordCount = list.Count;
result.Limit = limit;
result.Offset = offset;
var start = list.Count > offset ? offset : 0;
var end = list.Count > offset + limit ? offset + limit : list.Count > offset ? list.Count : 0;
result.AddAll(list.Skip(start).Take(end - start).ToList());
if (!DataCheckHelper.IsNull(criteria.SortBy))
{
if (IsSortField <T>(criteria.SortBy))
{
var ex = GetExpressionSort <T>(criteria.SortBy);
if (DataCheckHelper.IsNull(criteria.IsAsc))
{
criteria.IsAsc = true;
}
if (criteria.IsAsc.Value)
{
result.ResultList = result.AsQueryable().OrderBy(ex).ToList();
}
else
{
result.ResultList = result.AsQueryable().OrderByDescending(ex).ToList();
}
}
}
return(result);
}
public IHttpActionResult Get([FromUri] string search, [FromUri] string artistId, [FromUri] int page, [FromUri] int rows, [FromUri] int order)
{
var list = ctx.listProducts(search, artistId, page, rows, (ProductOrderBy)order);
PagerResult result = new PagerResult(page, rows);
result.totalRecords = ctx.totalProducts();
result.setResult <Product>(list);
return(Ok(result));
}
public PagerResult <UserDto> GetUsers(InputGetUsers input)
{
List <Guid> organizeIds = null;
List <Guid> departmentIds = null;
if (input.OrganizeId != null && input.OrganizeId != Guid.Empty)
{
organizeIds = _organizeRepository.GetAllChildren(input.OrganizeId.Value).Select(s => s.Id).ToList();
}
if (input.DepartmentId != null && input.DepartmentId != Guid.Empty)
{
departmentIds = _departmentRepository.GetAllChildren(input.DepartmentId.Value).Select(s => s.Id).ToList();
}
var users = _userRepository.GetAll()
.WhereIf(!input.LoginName.IsNullOrEmpty(), s => s.LoginName.Contains(input.LoginName))
.WhereIf(!input.UserName.IsNullOrEmpty(), s => s.UserName.Contains(input.UserName))
.WhereIf(!input.Mobile.IsNullOrEmpty(), s => s.Mobile == input.Mobile)
.WhereIf(organizeIds != null && organizeIds.Count > 0, s => organizeIds.Contains(s.OrganizeId))
.WhereIf(departmentIds != null && departmentIds.Count > 0, s => s.Departments.Any(d => departmentIds.Contains(d.Id)));
var totalResult = from user in users
join org in _organizeRepository.GetAll()
on user.OrganizeId equals org.Id
select new { User = user, OrganizeName = org.Name };
var result = from user in totalResult.OrderBy(s => s.User.CreateTime).Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize).ToList()
select new UserDto
{
Id = user.User.Id,
OrganizeId = user.User.OrganizeId,
OrganizeName = user.OrganizeName,
Departments = user.User.Departments.ToDictionary(s => s.Id, s => s.Name),
Duty = user.User.Duty,
EMail = user.User.EMail,
IsReset = user.User.IsReset,
IsStop = user.User.IsStop,
JobNo = user.User.JobNo,
LoginName = user.User.LoginName,
Mobile = user.User.Mobile,
ProfessionalLevel = user.User.ProfessionalLevel,
Remark = user.User.Remark,
Roles = user.User.Roles.ToDictionary(s => s.Id, s => s.Name),
UserName = user.User.UserName
};
var pageResult = new PagerResult <UserDto>()
{
PageIndex = input.PageIndex,
PageSize = input.PageSize,
TotalCount = totalResult.Count(),
Result = result.ToList(),
};
return(pageResult);
}
public async Task <PagerResult <ListClient2HospitalClientResponse> > Handle(IReceiveContext <PagerQuery <ListClient2HospitalClientRequest> > context, CancellationToken cancellationToken)
{
var query = context.Message;
var sql = from p in _context.Client2HospitalClient
join u in _context.User on p.CreateUserId equals u.Id
join c in _context.HospitalClient on p.HospitalClientId equals c.Id
join h in _context.Hospital on c.HospitalId equals h.Id
join ct in _context.Client on p.ClientId equals ct.Id
orderby p.Id descending
select new ListClient2HospitalClientResponse
{
Client = new GetClientResponse
{
Id = ct.Id,
Name = ct.Name,
},
ClientMappingId = p.Id,
HospitalClient = new GetHospitalClientResponse
{
Id = c.Id,
Hospital = new GetHospitalResponse {
Id = h.Id,
}
},
CreateTime = p.CreateTime,
CreateUserName = u.Username,
};
if (query.Query?.HospitalId != null)
{
sql = sql.Where(x => x.HospitalClient.Hospital.Id == query.Query.HospitalId.Value);
}
if (query.Query?.ClientId != null)
{
sql = sql.Where(x => x.Client.Id == query.Query.ClientId.Value);
}
if (!string.IsNullOrEmpty(query.Query?.Name))
{
sql = sql.Where(x => x.Client.Name.Contains(query.Query.Name));
}
var data = new PagerResult <ListClient2HospitalClientResponse>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var hospitalclients = await _mediator.ListByIdsAsync <GetHospitalClientRequest, GetHospitalClientResponse>(data.Select(x => x.HospitalClient.Id));
foreach (var m in data.Result)
{
m.HospitalClient = hospitalclients.FirstOrDefault(x => x.Id == m.HospitalClient.Id);
}
}
return(data);
}
/// <summary>
/// 查询记录
/// </summary>
/// <param name="inputDto">查询实体</param>
/// <returns></returns>
public PagerResult <Dtos.GetDepartmentOutputDTO> GetDepartment(Dtos.GetDepartmentInputDTO inputDto)
{
var pagerWrapper = new PagerResult <Dtos.GetDepartmentOutputDTO>();
var table = from c in _deptRepository.GetAll()
join p in _deptRepository.GetAll()
on c.ParentId equals p.Id into Parent
from P in Parent.DefaultIfEmpty()
join o in _organizeRepository.GetAll()
on c.OrganizeId equals o.Id into Organize
from O in Organize.DefaultIfEmpty()
join mu in _userRepository.GetAll()
on c.ManagerId equals mu.Id into Manager
from MU in Manager.DefaultIfEmpty()
join cu in _userRepository.GetAll()
on c.Creator equals cu.Id into Creator
from CU in Creator.DefaultIfEmpty()
join uu in _userRepository.GetAll()
on c.LastModifier equals uu.Id into LastModifier
from UU in LastModifier.DefaultIfEmpty()
select new Dtos.GetDepartmentOutputDTO
{
Id = c.Id.ToString(),
Name = c.Name,
Email = c.Email,
ManagerId = c.ManagerId.ToString(),
Fax = c.Fax,
Layer = c.Layer,
ParentId = c.ParentId,
ParentName = P.Name,
OrganizeName = O.Name,
Phone = c.Phone,
CreateTime = c.CreateTime,
Creator = CU == null ? "" : CU.UserName,
Description = c.Description,
OrganizeId = c.OrganizeId,
LastModifier = UU == null ? "" : UU.UserName,
LastModifyTime = c.LastModifyTime,
SortCode = c.SortCode,
Manager = MU == null ? "" : MU.UserName,
};
var result = table
.WhereIf(!inputDto.DepartmentName.IsNullOrEmpty(), p => p.Name.Contains(inputDto.DepartmentName))
.WhereIf(inputDto.OrganizeId.HasValue, p => p.OrganizeId == inputDto.OrganizeId)
.WhereIf(!inputDto.Manager.IsNullOrEmpty(), p => p.Manager.Contains(inputDto.Manager))
.WhereIf(inputDto.ParentId.HasValue, p => p.ParentId == inputDto.ParentId)
.Page(inputDto, pagerWrapper)
.ToList();
pagerWrapper.Result = result;
return(pagerWrapper);
}
public async Task <PagerResult <PrescriptionListApiModel> > GetPagerListAsync(PagerQuery <PrescriptionListQueryModel> query, int hospitalId)
{
var sql = from p in _context.Prescription
join u in _context.User on p.CreateUserId equals u.Id
join d in _context.HospitalDepartment on p.HospitalDepartmentId equals d.Id
where d.HospitalId == hospitalId
orderby p.Id descending
select new PrescriptionListApiModel
{
Cardno = p.Cardno,
CreateTime = p.CreateTime,
CreateUserName = u.Username,
Id = p.Id,
Status = p.Status,
HospitalDepartment = new GetHospitalDepartmentResponse {
Id = p.HospitalDepartmentId
},
};
if (query.Query?.HospitalDepartmentId != null)
{
sql = sql.Where(x => x.HospitalDepartment.Id == query.Query.HospitalDepartmentId.Value);
}
if (!string.IsNullOrEmpty(query.Query?.Cardno))
{
sql = sql.Where(x => x.Cardno.Contains(query.Query.Cardno));
}
if (query.Query?.Status != null)
{
sql = sql.Where(x => x.Status == query.Query.Status.Value);
}
if (query.Query?.BeginDate != null)
{
sql = sql.Where(x => x.CreateTime >= query.Query.BeginDate.Value);
}
if (query.Query?.EndDate != null)
{
sql = sql.Where(x => x.CreateTime < query.Query.EndDate.Value.AddDays(1));
}
var data = new PagerResult <PrescriptionListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var departments = await _mediator.ListByIdsAsync <GetHospitalDepartmentRequest, GetHospitalDepartmentResponse>(data.Select(x => x.HospitalDepartment.Id));
foreach (var m in data.Result)
{
m.HospitalDepartment = departments.FirstOrDefault(x => x.Id == m.HospitalDepartment.Id);
}
}
return(data);
}
public async Task <PagerResult <PurchaseListApiModel> > GetPagerListAsync(PagerQuery <PurchaseListQueryModel> query)
{
var sql = from r in _context.Purchase
join u in _context.User on r.CreateUserId equals u.Id
join p in _context.HospitalDepartment on r.HospitalDepartmentId equals p.Id
orderby r.Id descending
select new PurchaseListApiModel
{
CreateTime = r.CreateTime,
Id = r.Id,
CreateUserName = u.Username,
Name = r.Name,
Remark = r.Remark,
Status = r.Status,
HospitalDepartment = new GetHospitalDepartmentResponse
{
Id = r.HospitalDepartmentId,
Hospital = new GetHospitalResponse {
Id = p.HospitalId
}
}
};
if (query.Query?.HospitalId != null)
{
sql = sql.Where(x => x.HospitalDepartment.Hospital.Id == query.Query.HospitalId.Value);
}
if (query.Query?.HospitalDepartmentId != null)
{
sql = sql.Where(x => x.HospitalDepartment.Id == query.Query.HospitalDepartmentId.Value);
}
if (query.Query?.Status != null)
{
sql = sql.Where(x => x.Status == query.Query.Status.Value);
}
if (!string.IsNullOrEmpty(query.Query?.Name))
{
sql = sql.Where(x => x.Name.Contains(query.Query.Name));
}
var data = new PagerResult <PurchaseListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var departments = await _mediator.ListByIdsAsync <GetHospitalDepartmentRequest, GetHospitalDepartmentResponse>(data.Select(x => x.HospitalDepartment.Id).ToList());
foreach (var m in data.Result)
{
m.HospitalDepartment = departments.FirstOrDefault(x => x.Id == m.HospitalDepartment.Id);
}
}
return(data);
}
/// <summary>
/// 获取机器人
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public PagerResult<GetRobotsOutput> GetRobots(GetRobotsInput input)
{
var result = new PagerResult<GetRobotsOutput>();
var robots = _robotRepo.GetAll()
.WhereIf(input.DepartmentId.HasValue, p => p.DepartmentId == input.DepartmentId)
.WhereIf(!string.IsNullOrEmpty(input.Name), p => p.Name.Contains( input.Name))
.Page(input, result)
.ToList();
result.Result = robots.MapTo<List<GetRobotsOutput>>();
return result;
}
public async Task <PagerResult <ListHospitalDepartmentResponse> > Handle(IReceiveContext <PagerQuery <ListHospitalDepartmentRequest> > context, CancellationToken cancellationToken)
{
var query = context.Message;
var sql = from r in _context.HospitalDepartment
join u in _context.User on r.CreateUserId equals u.Id
join d in _context.DataDepartmentType on r.DepartmentTypeId equals d.Id
join rp in _context.HospitalDepartment on r.ParentId equals rp.Id into rp_def
from rp_def_t in rp_def.DefaultIfEmpty()
orderby r.Id descending
select new ListHospitalDepartmentResponse
{
CreateTime = r.CreateTime,
Id = r.Id,
Name = r.Name,
Hospital = new GetHospitalResponse
{
Id = r.HospitalId
},
CreateUserName = u.Username,
DepartmentType = d,
IsPurchaseCheck = r.IsPurchaseCheck,
Parent = rp_def_t != null ? new IdNameValueModel {
Id = rp_def_t.Id, Name = rp_def_t.Name
} : null,
};
if (query.Query?.HospitalId != null)
{
sql = sql.Where(x => x.Hospital.Id == query.Query.HospitalId.Value);
}
if (query.Query?.DepartmentTypeId != null)
{
sql = sql.Where(x => x.DepartmentType.Id == query.Query.DepartmentTypeId.Value);
}
if (!string.IsNullOrEmpty(query.Query?.Name))
{
sql = sql.Where(x => x.Name.Contains(query.Query.Name));
}
var data = new PagerResult <ListHospitalDepartmentResponse>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var hospitals = await _mediator.ListByIdsAsync <GetHospitalRequest, GetHospitalResponse>(data.Select(x => x.Hospital.Id).ToList());
foreach (var m in data.Result)
{
m.Hospital = hospitals.FirstOrDefault(x => x.Id == m.Hospital.Id);
}
}
return(data);
}
public async Task <PagerResult <InvoiceListApiModel> > GetPagerListAsync(PagerQuery <InvoiceListQueryModel> query, int hospitalId)
{
var sql = from r in _context.Invoice
join u in _context.User on r.CreateUserId equals u.Id
join t in _context.DataInvoiceType on r.InvoiceTypeId equals t.Id
join p in _context.HospitalDepartment on r.HospitalDepartmentId equals p.Id
orderby r.Id descending
where p.HospitalId == hospitalId
select new InvoiceListApiModel
{
CreateTime = r.CreateTime,
Id = r.Id,
CreateUserName = u.Username,
Name = r.Name,
Remark = r.Remark,
EndDate = r.EndDate,
StartDate = r.StartDate,
InvoiceType = t,
Status = r.Status,
HospitalDepartment = new GetHospitalDepartmentResponse {
Id = r.HospitalDepartmentId,
}
};
if (query.Query?.HospitalDepartmentId != null)
{
sql = sql.Where(x => x.HospitalDepartment.Id == query.Query.HospitalDepartmentId.Value);
}
if (query.Query?.Status != null)
{
sql = sql.Where(x => x.Status == query.Query.Status.Value);
}
if (query.Query?.Type != null)
{
sql = sql.Where(x => x.InvoiceType.Id == (int)query.Query.Type.Value);
}
var data = new PagerResult <InvoiceListApiModel>(query.Index, query.Size, sql);
if (data.Total > 0)
{
var departments = await _mediator.ListByIdsAsync <GetHospitalDepartmentRequest, GetHospitalDepartmentResponse>(data.Select(x => x.HospitalDepartment.Id));
foreach (var m in data.Result)
{
m.HospitalDepartment = departments.FirstOrDefault(x => x.Id == m.HospitalDepartment.Id);
}
}
return(data);
}
// GET: Home
public ActionResult Index(UserParams param)
{
param.PageSize = 10;
var list = PageContent();
var query = param.Name!=null ?
list.Where(t=>t.Name.Contains(param.Name)).ToList() :
list.ToList();
var data = query.Skip(param.Skip).Take(param.PageSize);
var count = query.Count;
var res = new PagerResult<User> { Code = 0, DataList = data, Total = count,
PageSize = param.PageSize,PageIndex = param.PageIndex,RequestUrl = param.RequetUrl};
return View(res);
}
