private Expression <Func <DetailsEntity, bool> > ListFilter(DetailsListParam param)
{
var expression = LinqExtensions.True <DetailsEntity>();
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 (!param.ChargeSheetId.IsNullOrZero())
{
expression = expression.And(t => t.ChargeSheetId == param.ChargeSheetId);
}
if (!string.IsNullOrEmpty(param.StudentCode))
{
expression = expression.And(t => t.StudentCode.Contains(param.StudentCode));
}
if (!param.SysDepartmentId.IsNullOrZero())
{
expression = expression.And(t => t.SysDepartmentId == param.SysDepartmentId);
}
}
return(expression);
}
public async Task <ActionResult> GetPageListJson(DetailsListParam param, Pagination pagination)
{
OperatorInfo operatorInfo = await Operator.Instance.Current();
if (!operatorInfo.RoleIds.Contains(GlobalContext.SystemConfig.RoleId))//不是超级管理员
{
param.SysDepartmentId = operatorInfo.DepartmentId;
}
StudentInfoListParam stuaram = new StudentInfoListParam();
param.SysDepartmentId = operatorInfo.DepartmentId;
TData <List <StudentInfoEntity> > stuobj = await studentInfoBLL.GetList(stuaram);
TData <List <DetailsEntity> > obj = await detailsBLL.GetPageList(param, pagination);
TData <List <DetailsInfo> > infos = new TData <List <DetailsInfo> >();
if (stuobj.Tag == 1 && stuobj.Result.Any() && obj.Tag == 1 && obj.Result.Any())
{
infos.Result = obj.Result.MapToMany <DetailsEntity, DetailsInfo>();
infos.Tag = 1;
infos.TotalCount = obj.TotalCount;
foreach (var model in infos.Result)
{
model.StudentName = stuobj.Result.Where(x => x.Code == model.StudentCode).FirstOrDefault().Name;
}
return(Json(infos));
}
return(Json(obj));
}
public async Task <List <DetailsEntity> > GetPageList(DetailsListParam param, Pagination pagination)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression, pagination);
return(list.ToList());
}
public async Task <TData <List <DetailsEntity> > > GetPageList(DetailsListParam param, Pagination pagination)
{
TData <List <DetailsEntity> > obj = new TData <List <DetailsEntity> >();
obj.Result = await detailsService.GetPageList(param, pagination);
obj.TotalCount = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <DetailsEntity> > > GetList(DetailsListParam param)
{
TData <List <DetailsEntity> > obj = new TData <List <DetailsEntity> >();
obj.Result = await detailsService.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> GetListJson(DetailsListParam param)
{
OperatorInfo operatorInfo = await Operator.Instance.Current();
if (!operatorInfo.RoleIds.Contains(GlobalContext.SystemConfig.RoleId))//不是超级管理员
{
param.SysDepartmentId = operatorInfo.DepartmentId;
}
TData <List <DetailsEntity> > obj = await detailsBLL.GetList(param);
return(Json(obj));
}
