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); }