public async Task <List <OrderTradeRecord> > OrderTradePayRecordList(OrderTradeRecordIn OrderTradeRecordInfo)
{
var OrderTradeRecords = _repository.GetAll().Where(OrderTradeRecordInfo.Expression);
var ordermanage = _orderrepository.GetAll().Where(t => t.IsDelete == false);
var consul = _consulrepository.GetAll().Where(t => t.IsDelete == false && t.ConsultState != "return");
OrderTradeRecords = from a in OrderTradeRecords
join b in ordermanage on a.OrderID equals b.Id
join c in consul on b.ConsultNumber equals c.ConsultNumber
select a;
return(await OrderTradeRecords.OrderByDescending(t => t.CreatedOn).ToListAsync());
}
public async Task <List <OrderTradeRecord> > PatientOrderTradeRecordList(OrderTradeRecordIn OrderTradeRecordInfo)
{
var OrderTradeRecords = _repository.GetAll().Where(OrderTradeRecordInfo.Expression);
var order = _orderrepository.GetAll().Where(t => t.IsDelete == false && t.ServiceID == OrderTradeRecordInfo.ServiceID);
var consul = _consulrepository.GetAll().Where(t => t.IsDelete == false && (t.RefundNumber == "" || t.RefundNumber == null));
var record = from a in OrderTradeRecords
join b in order on a.OrderNumber equals b.OrderNumber
join c in consul on b.ConsultNumber equals c.ConsultNumber
where c.DoctorID == OrderTradeRecordInfo.DoctorId
select a;
return(await record.ToListAsync());
}
public async Task <PagedResultDto <OrderTradeRecord> > OrderTradeRecordPage(OrderTradeRecordIn OrderTradeRecordInfo)
{
//初步过滤
var query = _repository.GetAll().OrderByDescending(a => a.CreatedOn).Where(OrderTradeRecordInfo.Expression);
//获取总数
var tasksCount = query.Count();
//获取总数
var totalpage = tasksCount / OrderTradeRecordInfo.MaxResultCount;
var OrderTradeRecordList = await query.PageBy(OrderTradeRecordInfo.SkipTotal, OrderTradeRecordInfo.MaxResultCount).ToListAsync();
return(new PagedResultDto <OrderTradeRecord>(tasksCount, OrderTradeRecordList.MapTo <List <OrderTradeRecord> >()));
}
public async Task <List <OrderTradeRecord> > OrderTradeRecordList(OrderTradeRecordIn OrderTradeRecordInfo)
{
var OrderTradeRecords = _repository.GetAll().Where(OrderTradeRecordInfo.Expression);
if (OrderTradeRecordInfo.DoctorId > 0)
{
var ordermanage = _orderrepository.GetAll().Where(t => t.IsDelete == false && t.DoctorID == OrderTradeRecordInfo.DoctorId);
if (OrderTradeRecordInfo.ServiceID > 0)
{
ordermanage = ordermanage.Where(t => t.ServiceID == OrderTradeRecordInfo.ServiceID);
}
OrderTradeRecords = from a in OrderTradeRecords
join b in ordermanage on a.OrderID equals b.Id
select a;
}
return(await OrderTradeRecords.OrderByDescending(t => t.CreatedOn).ToListAsync());
}
public async Task <IList <OrderTradeRecord> > OrderTradeRecordReportList(OrderTradeRecordIn OrderTradeRecordInfo)
{
var list = _repository.GetAll().Where(t => !t.IsDelete);
var order = _orderrepository.GetAll().Where(t => !t.IsDelete);
var consul = _consulrepository.GetAll().Where(t => !t.IsDelete);
var query = from a in list
join c in order on a.OrderNumber equals c.OrderNumber
join d in consul on c.ConsultNumber equals d.ConsultNumber
where a.PaymentState == "paid" && a.PaymentSourceCode == "order"
select new OrderTradeRecord
{
OrderID = c.Id,
OrderCurrency = c.OrderCurrency,
VoucherNumber = a.VoucherNumber,
PayMoney = a.PayMoney,
CreatedBy = a.CreatedBy,
CreatedOn = a.CreatedOn,
};
var OrderTradeRecords = await _repository.GetAllListAsync(OrderTradeRecordInfo.Expression);
return(OrderTradeRecords.ToList());
}
public async Task <PagedResultDto <OrderTradeRecordPCModule> > PCOrderTradeRecordPage(OrderTradeRecordIn OrderTradeRecordInfo)
{
//初步过滤
var querylist = _repository.GetAll().OrderByDescending(a => a.CreatedOn).Where(OrderTradeRecordInfo.Expression);
var order = _orderrepository.GetAll().Where(t => t.IsDelete == false);
var consul = _consulrepository.GetAll().Where(t => t.IsDelete == false);
var query = from a in querylist
join b in order on a.OrderNumber equals b.OrderNumber
join c in consul on b.ConsultNumber equals c.ConsultNumber
select new OrderTradeRecordPCModule
{
SequenceNo = a.SequenceNo,
OrderID = a.OrderID,
OrderNumber = a.OrderNumber,
PayType = a.PayType,
OrderCurrency = a.OrderCurrency,
TenpayNumber = a.TenpayNumber,
VoucherNumber = a.VoucherNumber,
VoucherJSON = a.VoucherJSON,
PayMoney = a.PayMoney,
PayAchiveTime = a.PayAchiveTime,
PaySerialNumber = a.PaySerialNumber,
PaymentState = a.PaymentState,
PaymentSource = a.PaymentSource,
PaymentSourceCode = a.PaymentSourceCode,
WXPayBillno = a.WXPayBillno,
WXTransactionId = a.WXTransactionId,
WXOrderQuery = a.WXOrderQuery,
CreatedOn = a.CreatedOn,
Id = a.Id,
ConsultId = c.Id,
ConsultNumber = c.ConsultNumber,
};
if (!string.IsNullOrEmpty(OrderTradeRecordInfo.KeyWord))
{
//(a => a.OrderNumber.Contains(OrderTradeRecordInfo.KeyWord)||a.WXPayBillno.Contains(OrderTradeRecordInfo.KeyWord)||a.WXTransactionId.Contains(OrderTradeRecordInfo.KeyWord));
query = query.Where(a => a.OrderNumber.Contains(OrderTradeRecordInfo.KeyWord) ||
a.WXPayBillno.Contains(OrderTradeRecordInfo.KeyWord) ||
a.WXTransactionId.Contains(OrderTradeRecordInfo.KeyWord) ||
a.ConsultNumber.Contains(OrderTradeRecordInfo.KeyWord));
}
//获取总数
var tasksCount = query.Count();
//获取总数
var totalpage = tasksCount / OrderTradeRecordInfo.MaxResultCount;
var OrderTradeRecordList = await query.PageBy(OrderTradeRecordInfo.SkipTotal, OrderTradeRecordInfo.MaxResultCount).ToListAsync();
return(new PagedResultDto <OrderTradeRecordPCModule>(tasksCount, OrderTradeRecordList.MapTo <List <OrderTradeRecordPCModule> >()));
}
/// <summary>
/// 输出模型
/// </summary>
/// <param name="OrderTradeRecordDto"></param>
/// <param name="OrderTradeRecordInfo"></param>
public OrderTradeRecordPCModuleOut(PagedResultDto <OrderTradeRecordPCModule> OrderTradeRecordDto, OrderTradeRecordIn OrderTradeRecordInfo)
{
Items = OrderTradeRecordDto.Items;
TotalCount = OrderTradeRecordDto.TotalCount;
TotalPage = OrderTradeRecordDto.TotalCount / OrderTradeRecordInfo.MaxResultCount;
SkipCount = OrderTradeRecordInfo.SkipCount;
MaxResultCount = OrderTradeRecordInfo.MaxResultCount;
}
