public async Task <TakeCashSearchResult> GetModelListAsync(long?userId, long?stateId, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
TakeCashSearchResult result = new TakeCashSearchResult();
var entities = dbc.GetAll <TakeCashEntity>();
if (userId != null)
{
entities = entities.Where(a => a.UserId == userId);
}
if (stateId != null)
{
entities = entities.Where(a => a.StateId == stateId);
}
if (!string.IsNullOrEmpty(keyword))
{
entities = entities.Where(g => g.User.Mobile.Contains(keyword) || g.User.NickName.Contains(keyword));
}
if (startTime != null)
{
entities = entities.Where(a => a.CreateTime >= startTime);
}
if (endTime != null)
{
entities = entities.Where(a => SqlFunctions.DateDiff("day", endTime, a.CreateTime) <= 0);
}
result.PageCount = (int)Math.Ceiling((await entities.LongCountAsync()) * 1.0f / pageSize);
var takeCashResult = await entities.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync();
result.TakeCashes = takeCashResult.Select(a => ToDTO(a, ToDTO(dbc.GetAll <PayCodeEntity>().SingleOrDefault(p => p.UserId == a.UserId)), ToDTO(dbc.GetAll <BankAccountEntity>().SingleOrDefault(b => b.UserId == a.UserId)))).ToArray();
return(result);
}
}
public async Task <TakeCashSearchResult> GetModelListAsync(long?userId, long?stateId, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
TakeCashSearchResult result = new TakeCashSearchResult();
var entities = dbc.GetAll <TakeCashEntity>();
if (userId != null)
{
entities = entities.Where(a => a.UserId == userId);
}
if (stateId != null)
{
entities = entities.Where(a => a.StateId == stateId);
}
if (!string.IsNullOrEmpty(keyword))
{
entities = entities.Where(g => g.User.Mobile.Contains(keyword) || g.User.NickName.Contains(keyword));
}
if (startTime != null)
{
entities = entities.Where(a => a.CreateTime >= startTime);
}
if (endTime != null)
{
entities = entities.Where(a => a.CreateTime <= endTime);
}
result.PageCount = (int)Math.Ceiling((await entities.LongCountAsync()) * 1.0f / pageSize);
var res = await entities.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync();
result.List = res.Select(a => ToDTO(a)).ToArray();
return(result);
}
}
public TakeCashSearchResult GetPageList(string name, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
TakeCashSearchResult result = new TakeCashSearchResult();
CommonService <TakeCashEntity> cs = new CommonService <TakeCashEntity>(dbc);
var takeCashs = cs.GetAll();
if (!string.IsNullOrEmpty(name))
{
takeCashs = takeCashs.Where(t => t.Holder.Name.Contains(name));
}
if (!string.IsNullOrEmpty(mobile))
{
takeCashs = takeCashs.Where(t => t.Holder.Mobile.Contains(mobile));
}
if (startTime != null)
{
takeCashs = takeCashs.Where(t => t.CreateTime >= startTime);
}
if (endTime != null)
{
takeCashs = takeCashs.Where(t => t.CreateTime <= endTime);
}
result.TotalCount = takeCashs.LongCount();
result.TakeCashs = takeCashs.OrderByDescending(t => t.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(t => ToDTO(t)).ToArray();
return(result);
}
}
public async Task <ActionResult> List(long?stateId, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
TakeCashSearchResult result = await takeCashService.GetModelListAsync(null, stateId, keyword, startTime, endTime, pageIndex, pageSize);
TakeCashListViewModel model = new TakeCashListViewModel();
model.TakeCashes = result.TakeCashes.Select(t => new TakeCashModel {
AdminMobile = t.AdminMobile,
Amount = t.Amount,
Code = t.Code,
CreateTime = t.CreateTime,
Description = t.Description,
Id = t.Id,
Mobile = t.Mobile,
Name = t.Name,
PayTypeInfo = userService.GetPayInfo(t.UserId, t.TypeName),
StateId = t.StateId,
StateName = t.StateName,
TypeId = t.TypeId,
TypeName = t.TypeName,
UserId = t.UserId
}).ToArray();
model.PageCount = result.PageCount;
model.States = await idNameService.GetByTypeNameAsync("提现状态");
return(Json(new AjaxResult {
Status = 1, Data = model
}));
}
public async Task <ActionResult> List(int pageIndex = 1)
{
long stateId = await idNameService.GetIdByNameAsync("已结款");
TakeCashSearchResult result = await takeCashService.GetModelListAsync(userId, stateId, null, null, null, pageIndex, pageSize);
return(Json(new AjaxResult {
Status = 1, Data = result
}));
}
public async Task <ActionResult> List(long?stateId, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
TakeCashSearchResult result = await takeCashService.GetModelListAsync(null, stateId, keyword, startTime, endTime, pageIndex, pageSize);
TakeCashListViewModel model = new TakeCashListViewModel();
model.TakeCashes = result.TakeCashes;
model.PageCount = result.PageCount;
model.States = MyEnumHelper.GetEnumList <TakeCashStateEnum>();
return(Json(new AjaxResult {
Status = 1, Data = model
}));
}
public async Task <ApiResult> List(TakeCashListModel model)
{
User user = JwtHelper.JwtDecrypt <User>(ControllerContext);
TakeCashSearchResult res = await takeCashService.GetModelListAsync(user.Id, null, null, null, null, model.PageIndex, model.PageSize);
TakeCashListApiModel result = new TakeCashListApiModel();
result.takeCashes = res.TakeCashes.Select(t => new TakeCash {
createTime = t.CreateTime, amount = t.Amount, description = t.Description, payTypeName = t.PayTypeName, stateName = t.StateName, bankAccount = t.BankAccount.BankAccount
});
result.pageCount = res.PageCount;
return(new ApiResult {
status = 1, data = result
});
}
public async Task <ActionResult> List(long?stateId, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
//long? typeId = await journalTypeService.GetIdByDescAsync("赠送");
TakeCashSearchResult result = await takeCashService.GetModelListAsync(stateId, mobile, startTime, endTime, pageIndex, pageSize);
ListViewModel model = new ListViewModel();
model.TakeCashes = result.TakeCashes;
model.States = await stateService.GetModelListAsync();
if (result.GivingIntegralCount == null)
{
result.GivingIntegralCount = 0;
}
if (result.UseIntegralCount == null)
{
result.UseIntegralCount = 0;
}
model.GivingIntegralCount = result.GivingIntegralCount;
model.UseIntegralCount = result.UseIntegralCount;
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.PageHtml = "test";
}
else
{
model.PageHtml = pager.GetPagerHtml();
}
model.Pages = pager.Pages;
model.PageCount = pager.PageCount;
return(Json(new AjaxResult {
Status = 1, Data = model
}));
//return View(model);
}
public async Task <TakeCashSearchResult> GetModelListAsync(long?stateId, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
TakeCashSearchResult result = new TakeCashSearchResult();
var entities = dbc.GetAll <TakeCashEntity>();
if (stateId != null)
{
entities = entities.Where(t => t.StateId == stateId);
}
if (!string.IsNullOrEmpty(mobile))
{
entities = entities.Where(t => t.PlatformUser.Mobile.Contains(mobile));
}
if (startTime != null)
{
entities = entities.Where(t => t.CreateTime >= startTime);
}
if (endTime != null)
{
entities = entities.Where(a => a.CreateTime.Year <= endTime.Value.Year && a.CreateTime.Month <= endTime.Value.Month && a.CreateTime.Day <= endTime.Value.Day);
}
long givingIntegralId = dbc.GetAll <IntegralTypeEntity>().SingleOrDefault(i => i.Name == "商家积分").Id;
long useIntegralId = dbc.GetAll <IntegralTypeEntity>().SingleOrDefault(i => i.Name == "消费积分").Id;
long sId = dbc.GetAll <StateEntity>().SingleOrDefault(s => s.Name == "已转账").Id;
result.TotalCount = await entities.LongCountAsync();
result.GivingIntegralCount = await entities.Where(t => t.IntegralTypeId == givingIntegralId && t.StateId == sId).SumAsync(t => t.Integral);
result.UseIntegralCount = await entities.Where(t => t.IntegralTypeId == useIntegralId && t.StateId == sId).SumAsync(t => t.Integral);
var res = await entities.OrderByDescending(t => t.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync();
result.TakeCashes = res.Select(t => ToDTO(t)).ToArray();
return(result);
}
}
public PartialViewResult ApplyGetPage(string name, string mobile, DateTime?startTime, DateTime?endTime, int pageIndex = 1)
{
TakeCashViewModel model = new TakeCashViewModel();
TakeCashSearchResult result = takeCashService.GetPageList(name, mobile, startTime, endTime, pageIndex, pageSize);
model.TakeCashes = result.TakeCashs;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(PartialView("TakeCashApplyPaging", model));
}