public BaseResponse <InValueModel> SaveInValue(InValueModel request)
{
if (request.InNo == 0)
{
request.OrgId = SecurityHelper.CurrentPrincipal.OrgId;
}
return(base.Save <LTC_INVALUE, InValueModel>(request, (q) => q.INNO == request.InNo));
}
public BaseResponse <IList <InValueModel> > QueryInValue(BaseRequest <InValueFilter> request)
{
BaseResponse <IList <InValueModel> > response = new BaseResponse <IList <InValueModel> >();
var q = from n in unitOfWork.GetRepository <LTC_INVALUE>().dbSet
join e in unitOfWork.GetRepository <LTC_EMPFILE>().dbSet on n.RECORDBY equals e.EMPNO into res
from re in res.DefaultIfEmpty()
select new
{
InValueModel = n,
EmpName = re.EMPNAME
};
if (request.Data.FeeNo.HasValue)
{
q = q.Where(m => m.InValueModel.FEENO == request.Data.FeeNo);
}
if (!string.IsNullOrEmpty(request.Data.OrgId))
{
q = q.Where(m => m.InValueModel.ORGID == request.Data.OrgId);
}
q = q.OrderByDescending(m => m.InValueModel.INNO);
response.RecordsCount = q.Count();
Action <IList> mapperResponse = (IList list) =>
{
response.Data = new List <InValueModel>();
foreach (dynamic item in list)
{
InValueModel newItem = Mapper.DynamicMap <InValueModel>(item.InValueModel);
newItem.RecordNameBy = item.EmpName;
response.Data.Add(newItem);
}
};
if (request != null && request.PageSize > 0)
{
var list = q.Skip((request.CurrentPage - 1) * request.PageSize).Take(request.PageSize).ToList();
response.PagesCount = GetPagesCount(request.PageSize, response.RecordsCount);
mapperResponse(list);
}
else
{
var list = q.ToList();
mapperResponse(list);
}
return(response);
}
