public ObsoletePageModel <CashDepositDetailInfo> GetCashDepositDetails(CashDepositDetailQuery query)
{
IQueryable <CashDepositDetailInfo> cashDepositDetails = Context.CashDepositDetailInfo.AsQueryable();
if (query.StartDate.HasValue)
{
cashDepositDetails = cashDepositDetails.Where(item => query.StartDate <= item.AddDate);
}
if (query.EndDate.HasValue)
{
cashDepositDetails = cashDepositDetails.Where(item => query.EndDate >= item.AddDate);
}
if (!string.IsNullOrWhiteSpace(query.Operator))
{
cashDepositDetails = cashDepositDetails.Where(item => item.Operator.Contains(query.Operator));
}
int total;
cashDepositDetails = cashDepositDetails.FindBy(item => item.CashDepositId == query.CashDepositId, query.PageNo, query.PageSize, out total, item => item.AddDate, false);
ObsoletePageModel <CashDepositDetailInfo> pageModel = new ObsoletePageModel <CashDepositDetailInfo>()
{
Models = cashDepositDetails, Total = total
};
return(pageModel);
}
public QueryPageModel <CashDepositDetailInfo> GetCashDepositDetails(CashDepositDetailQuery query)
{
//IQueryable<CashDepositDetailInfo> cashDepositDetails = Context.CashDepositDetailInfo.AsQueryable();
var cashDepositDetails = DbFactory.Default.Get <CashDepositDetailInfo>();
if (query.StartDate.HasValue)
{
cashDepositDetails.Where(item => query.StartDate <= item.AddDate);
}
if (query.EndDate.HasValue)
{
cashDepositDetails.Where(item => query.EndDate >= item.AddDate);
}
if (!string.IsNullOrWhiteSpace(query.Operator))
{
cashDepositDetails.Where(item => item.Operator.Contains(query.Operator));
}
cashDepositDetails.Where(item => item.CashDepositId == query.CashDepositId);
//int total = 0;
//cashDepositDetails = cashDepositDetails.FindBy(item => item.CashDepositId == query.CashDepositId, query.PageNo, query.PageSize, out total, item => item.AddDate, false);
var models = cashDepositDetails.OrderByDescending(p => p.AddDate).ToPagedList(query.PageNo, query.PageSize);
QueryPageModel <CashDepositDetailInfo> pageModel = new QueryPageModel <CashDepositDetailInfo>()
{
Models = models, Total = models.TotalRecordCount
};
return(pageModel);
}
public PageModel <CashDepositDetailInfo> GetCashDepositDetails(CashDepositDetailQuery query)
{
int num;
IQueryable <CashDepositDetailInfo> startDate = context.CashDepositDetailInfo.AsQueryable <CashDepositDetailInfo>();
if (query.StartDate.HasValue)
{
startDate =
from item in startDate
where query.StartDate <= item.AddDate
select item;
}
if (query.EndDate.HasValue)
{
startDate =
from item in startDate
where query.EndDate >= item.AddDate
select item;
}
if (!string.IsNullOrWhiteSpace(query.Operator))
{
startDate =
from item in startDate
where item.Operator.Contains(query.Operator)
select item;
}
startDate = startDate.FindBy <CashDepositDetailInfo, DateTime>((CashDepositDetailInfo item) => item.CashDepositId == query.CashDepositId, query.PageNo, query.PageSize, out num, (CashDepositDetailInfo item) => item.AddDate, false);
return(new PageModel <CashDepositDetailInfo>()
{
Models = startDate,
Total = num
});
}
public JsonResult CashDepositDetail(long cashDepositId, int pageNo = 1, int pageSize = 10)
{
CashDepositDetailQuery cashDepositDetailQuery = new CashDepositDetailQuery()
{
CashDepositId = cashDepositId,
PageNo = pageNo,
PageSize = pageSize
};
PageModel <CashDepositDetailInfo> cashDepositDetails = ServiceHelper.Create <ICashDepositsService>().GetCashDepositDetails(cashDepositDetailQuery);
var array =
from item in cashDepositDetails.Models.ToArray()
select new { Id = item.Id, Date = item.AddDate.ToString("yyyy-MM-dd HH:mm"), Balance = item.Balance, Operator = item.Operator, Description = item.Description };
return(Json(new { rows = array, total = cashDepositDetails.Total }));
}
public JsonResult CashDepositDetailList(long id, string name, DateTime?startDate, DateTime?endDate, int page, int rows)
{
CashDepositDetailQuery cashDepositDetailQuery = new CashDepositDetailQuery()
{
CashDepositId = id,
Operator = name,
StartDate = startDate,
EndDate = endDate,
PageNo = page,
PageSize = rows
};
PageModel <CashDepositDetailInfo> cashDepositDetails = ServiceHelper.Create <ICashDepositsService>().GetCashDepositDetails(cashDepositDetailQuery);
var array =
from item in cashDepositDetails.Models.ToArray()
select new { Id = item.Id, Date = item.AddDate.ToString("yyyy-MM-dd HH:mm"), Balance = item.Balance, Operator = item.Operator, Description = item.Description };
return(Json(new { rows = array, total = cashDepositDetails.Total }));
}
public JsonResult CashDepositDetail(long cashDepositId, int pageNo = 1, int pageSize = 100000)
{
CashDepositDetailQuery query = new CashDepositDetailQuery()
{
CashDepositId = cashDepositId,
PageNo = pageNo,
PageSize = pageSize
};
QueryPageModel <Entities.CashDepositDetailInfo> cashDepositDetails = _iCashDepositsService.GetCashDepositDetails(query);
var cashDepositDetailModel = cashDepositDetails.Models.ToArray().Select(item => new
{
Id = item.Id,
Date = item.AddDate.ToString("yyyy-MM-dd HH:mm"),
Balance = item.Balance,
Operator = item.Operator,
Description = item.Description
});
return(Json(new { rows = cashDepositDetailModel, total = cashDepositDetails.Total }));
}
public JsonResult CashDepositDetailList(long id, string name, DateTime?startDate, DateTime?endDate, int page, int rows)
{
var queryModel = new CashDepositDetailQuery()
{
CashDepositId = id,
Operator = name,
StartDate = startDate,
EndDate = endDate,
PageNo = page,
PageSize = rows
};
QueryPageModel <Entities.CashDepositDetailInfo> cashDepositDetail = _iCashDepositsService.GetCashDepositDetails(queryModel);
var cashDepositDetailModel = cashDepositDetail.Models.ToArray().Select(item => new
{
Id = item.Id,
Date = item.AddDate.ToString("yyyy-MM-dd HH:mm"),
Balance = item.Balance,
Operator = item.Operator,
Description = item.Description
});
return(Json(new { rows = cashDepositDetailModel, total = cashDepositDetail.Total }));
}
/// <summary>
/// 根据保证金ID获取明细列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static ObsoletePageModel <CashDepositDetailInfo> GetCashDepositDetails(CashDepositDetailQuery query)
{
return(_iCashDepositsService.GetCashDepositDetails(query));
}
