public JsonResult ChargeList(int page, int rows)
{
var capitalService = _iMemberCapitalService;
var query = new ChargeQuery
{
memberId = CurrentUser.Id,
PageSize = rows,
PageNo = page
};
var pageMode = capitalService.GetChargeLists(query);
var model = pageMode.Models.ToList().Select(e =>
{
return(new ChargeDetailModel
{
Id = e.Id.ToString(),
ChargeAmount = e.ChargeAmount,
ChargeStatus = e.ChargeStatus,
ChargeStatusDesc = e.ChargeStatus.ToDescription(),
ChargeTime = e.ChargeTime.ToString(),
CreateTime = e.CreateTime.ToString(),
ChargeWay = e.ChargeWay,
MemId = e.MemId
});
});
var models = new DataGridModel <ChargeDetailModel>
{
rows = model,
total = pageMode.Total
};
return(Json(models));
}
public QueryPageModel <ChargeDetailInfo> GetChargeLists(ChargeQuery query)
{
//var charges = Context.ChargeDetailInfo.AsQueryable();
var charges = DbFactory.Default.Get <ChargeDetailInfo>();
if (query.ChargeStatus.HasValue)
{
charges = charges.Where(e => e.ChargeStatus == query.ChargeStatus.Value);
}
if (query.memberId.HasValue)
{
charges = charges.Where(e => e.MemId == query.memberId.Value);
}
if (query.ChargeNo.HasValue)
{
charges = charges.Where(e => e.Id == query.ChargeNo.Value);
}
//int total = 0;
//var model = charges.GetPage(p => p.OrderByDescending(o => o.CreateTime), out total, query.PageNo, query.PageSize);
var model = charges.OrderByDescending(o => o.CreateTime).ToPagedList(query.PageNo, query.PageSize);
QueryPageModel <ChargeDetailInfo> result = new QueryPageModel <ChargeDetailInfo> {
Models = model, Total = model.TotalRecordCount
};
return(result);
}
public JsonResult ChargeList(int page, int rows)
{
IMemberCapitalService memberCapitalService = ServiceHelper.Create <IMemberCapitalService>();
ChargeQuery chargeQuery = new ChargeQuery()
{
memberId = new long?(base.CurrentUser.Id),
PageSize = rows,
PageNo = page
};
PageModel <ChargeDetailInfo> chargeLists = memberCapitalService.GetChargeLists(chargeQuery);
IEnumerable <ChargeDetailModel> list =
from e in chargeLists.Models.ToList()
select new ChargeDetailModel()
{
Id = e.Id.ToString(),
ChargeAmount = e.ChargeAmount,
ChargeStatus = e.ChargeStatus,
ChargeStatusDesc = e.ChargeStatus.ToDescription(),
ChargeTime = e.ChargeTime.ToString(),
CreateTime = e.CreateTime.ToString(),
ChargeWay = e.ChargeWay,
MemId = e.MemId
};
DataGridModel <ChargeDetailModel> dataGridModel = new DataGridModel <ChargeDetailModel>()
{
rows = list,
total = chargeLists.Total
};
return(Json(dataGridModel));
}
public async Task <IActionResult> GetChargById(Guid id)
{
if (id == Guid.Empty)
{
return(BadRequest("Invalid Id"));
}
var chargeQuery = new ChargeQuery()
{
Id = id
};
_logger.LogInformation(
"----- Sending query: {@QueryName} Id: {@Id}",
nameof(chargeQuery),
chargeQuery.Id);
var paymentDetail = await _mediator.Send(chargeQuery);
if (paymentDetail == null)
{
return(NotFound());
}
return(Ok(paymentDetail));
}
public ActionResult List(ChargeQuery query)
{
var list = this.ChargeRepository.GetList(query);
var data = list.Data.Select(c => ChargeModel.From(c)).ToList();
var result = new { total = list.RecordCount, rows = data };
return(Json(result));
}
public PageModel <ChargeDetailInfo> GetChargeLists(ChargeQuery query)
{
IQueryable <ChargeDetailInfo> chargeStatus = context.ChargeDetailInfo.AsQueryable <ChargeDetailInfo>();
if (query.ChargeStatus.HasValue)
{
chargeStatus =
from e in chargeStatus
where (int)e.ChargeStatus == (int)query.ChargeStatus.Value
select e;
}
if (query.memberId.HasValue)
{
chargeStatus =
from e in chargeStatus
where e.MemId == query.memberId.Value
select e;
}
if (query.ChargeNo.HasValue)
{
chargeStatus =
from e in chargeStatus
where e.Id == query.ChargeNo.Value
select e;
}
int num = 0;
IQueryable <ChargeDetailInfo> page = chargeStatus.GetPage(out num, query.PageNo, query.PageSize, (IQueryable <ChargeDetailInfo> p) =>
from o in p
orderby o.CreateTime descending
select o);
return(new PageModel <ChargeDetailInfo>()
{
Models = page,
Total = num
});
}
public ObsoletePageModel <ChargeDetailInfo> GetChargeLists(ChargeQuery query)
{
var charges = Context.ChargeDetailInfo.AsQueryable();
if (query.ChargeStatus.HasValue)
{
charges = charges.Where(e => e.ChargeStatus == query.ChargeStatus.Value);
}
if (query.memberId.HasValue)
{
charges = charges.Where(e => e.MemId == query.memberId.Value);
}
if (query.ChargeNo.HasValue)
{
charges = charges.Where(e => e.Id == query.ChargeNo.Value);
}
int total = 0;
var model = charges.GetPage(out total, query.PageNo, query.PageSize, p => p.OrderByDescending(o => o.CreateTime));
ObsoletePageModel <ChargeDetailInfo> result = new ObsoletePageModel <ChargeDetailInfo> {
Models = model, Total = total
};
return(result);
}
/// <summary>
/// 取充值列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static ObsoletePageModel <ChargeDetailInfo> GetChargeLists(ChargeQuery query)
{
return(_iMemberCapitalService.GetChargeLists(query));
}
/// <summary>
/// 取充值列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static QueryPageModel <ChargeDetailInfo> GetChargeLists(ChargeQuery query)
{
return(Service.GetChargeLists(query));
}
public ActionResult Index(ChargeQuery query)
{
var items = _chargeSrv.GetAllChargeCardList(query);
return(View(items));
}
public IPagedList <ChargeCard> GetAllChargeCardList(ChargeQuery query)
{
return(_chargeCardRep.GetAllList().AsPagedList(query));
}
