public async Task <List <RecordEntity> > GetPageList(RecordListParam param, Pagination pagination)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression, pagination);
return(list.ToList());
}
private Expression <Func <RecordEntity, bool> > ListFilter(RecordListParam param)
{
var expression = LinqExtensions.True <RecordEntity>();
if (param != null)
{
}
return(expression);
}
public async Task <TData <List <RecordEntity> > > GetPageList(RecordListParam param, Pagination pagination)
{
TData <List <RecordEntity> > obj = new TData <List <RecordEntity> >();
obj.Result = await recordService.GetPageList(param, pagination);
obj.TotalCount = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <RecordEntity> > > GetList(RecordListParam param)
{
TData <List <RecordEntity> > obj = new TData <List <RecordEntity> >();
obj.Result = await recordService.GetList(param);
obj.TotalCount = obj.Result.Count;
obj.Tag = 1;
return(obj);
}
public async Task <ActionResult> GetListJsonStudentCode(string StudentCode)
{
DetailsListParam detailsListParam = new DetailsListParam();
OperatorInfo operatorInfo = await Operator.Instance.Current();
if (!operatorInfo.RoleIds.Contains(GlobalContext.SystemConfig.RoleId))//不是超级管理员
{
detailsListParam.SysDepartmentId = operatorInfo.DepartmentId;
}
detailsListParam.StudentCode = StudentCode;
TData <List <DetailsEntity> > details = await detailsBLL.GetList(detailsListParam);
if (details.Tag == 1 && details.Result.Any())
{
var infos = new List <SheetInfo>();
var ids = details.Result.Select(x => x.ChargeSheetId).Distinct().ToList();
foreach (var id in ids)
{
TData <SheetEntity> obj = await sheetBLL.GetEntity(long.Parse(id.ToString()));
if (obj.Tag == 1 && obj.Result != null)
{
SheetInfo info = obj.Result.MapTo <SheetEntity, SheetInfo>();
var mxs = details.Result.Where(x => x.ChargeSheetId == id).ToList();
info.details = mxs;
info.SumMoney = mxs.Sum(x => x.Money);
info.YesMoney = 0;
//收款记录
RecordListParam recordListParam = new RecordListParam();
if (!operatorInfo.RoleIds.Contains(GlobalContext.SystemConfig.RoleId))//不是超级管理员
{
recordListParam.SysDepartmentId = operatorInfo.DepartmentId;
}
recordListParam.StudentCode = StudentCode;
recordListParam.ChargeSheetId = id;
recordListParam.Status = 1;
TData <List <RecordEntity> > record = await recordBLL.GetList(recordListParam);
if (record.Tag == 1 && record.Result != null)
{
info.YesMoney = record.Result.Sum(x => x.Money);
}
info.NoMoney = info.SumMoney - info.YesMoney;
infos.Add(info);
}
}
return(Json(infos));
}
return(Json(new List <SheetInfo>()));
}
public async Task <ActionResult> GetPageListJson(RecordListParam param, Pagination pagination)
{
OperatorInfo operatorInfo = await Operator.Instance.Current();
if (!operatorInfo.RoleIds.Contains(GlobalContext.SystemConfig.RoleId))//不是超级管理员
{
param.SysDepartmentId = operatorInfo.DepartmentId;
}
TData <List <RecordEntity> > obj = await recordBLL.GetPageList(param, pagination);
return(Json(obj));
}
private Expression <Func <RecordEntity, bool> > ListFilter(RecordListParam param)
{
var expression = LinqExtensions.True <RecordEntity>();
expression = expression.And(t => t.BaseIsDelete == 0);
if (param != null)
{
if (!string.IsNullOrEmpty(param.ChargeNo))
{
expression = expression.And(t => t.ChargeNo.Contains(param.ChargeNo));
}
if (!string.IsNullOrEmpty(param.InvoiceNo))
{
expression = expression.And(t => t.InvoiceNo.Contains(param.InvoiceNo));
}
if (!string.IsNullOrEmpty(param.StudentCode))
{
expression = expression.And(t => t.StudentCode.Contains(param.StudentCode));
}
if (!string.IsNullOrEmpty(param.TypeName))
{
expression = expression.And(t => t.TypeName.Contains(param.TypeName));
}
if (!string.IsNullOrEmpty(param.UserName))
{
expression = expression.And(t => t.UserName.Contains(param.UserName));
}
if (param.Status > -1)
{
expression = expression.And(t => t.Status == param.Status);
}
if (!param.SysDepartmentId.IsNullOrZero())
{
expression = expression.And(t => t.SysDepartmentId == param.SysDepartmentId);
}
if (!param.ChargeSheetId.IsNullOrZero())
{
expression = expression.And(t => t.ChargeSheetId == param.ChargeSheetId);
}
if (!string.IsNullOrEmpty(param.StartTime.ParseToString()))
{
expression = expression.And(t => t.ChargeDate >= param.StartTime);
}
if (!string.IsNullOrEmpty(param.EndTime.ParseToString()))
{
param.EndTime = (param.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime();
expression = expression.And(t => t.ChargeDate <= param.EndTime);
}
}
return(expression);
}
public async Task <ActionResult> GetPageListJson(RecordListParam param, Pagination pagination)
{
TData <List <RecordEntity> > obj = await recordBLL.GetPageList(param, pagination);
return(Json(obj));
}
