public BaseResponse <GroupActivityRec> SaveGroupActivityRec(GroupActivityRec request) { if (request.Id == 0) { if (string.IsNullOrEmpty(request.CreateBy)) { request.CreateBy = SecurityHelper.CurrentPrincipal.EmpNo; } request.CreateDate = DateTime.Now; request.OrgId = SecurityHelper.CurrentPrincipal.OrgId; } return(base.Save <LTC_GROUPACTIVITYREC, GroupActivityRec>(request, (q) => q.ID == request.Id)); }
public BaseResponse <IList <GroupActivityRec> > QueryGroupActivityRec(BaseRequest <GroupActivityRecFilter> request) { BaseResponse <IList <GroupActivityRec> > response = new BaseResponse <IList <GroupActivityRec> >(); var q = from n in unitOfWork.GetRepository <LTC_GROUPACTIVITYREC>().dbSet join e in unitOfWork.GetRepository <LTC_EMPFILE>().dbSet on n.LEADERNAME equals e.EMPNO into res from re in res.DefaultIfEmpty() select new { GroupActivityRec = n, EmpName = re.EMPNAME }; if (!string.IsNullOrEmpty(request.Data.ActivityName)) { q = q.Where(m => m.GroupActivityRec.ACTIVITYNAME.Contains(request.Data.ActivityName)); } if (!string.IsNullOrEmpty(request.Data.OrgId)) { q = q.Where(m => m.GroupActivityRec.ORGID == request.Data.OrgId); } q = q.OrderByDescending(m => m.GroupActivityRec.RECORDDATE); response.RecordsCount = q.Count(); Action <IList> mapperResponse = (IList list) => { response.Data = new List <GroupActivityRec>(); foreach (dynamic item in list) { GroupActivityRec newItem = Mapper.DynamicMap <GroupActivityRec>(item.GroupActivityRec); newItem.LeaderName = 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); }
public IHttpActionResult Post(GroupActivityRec baseRequest) { var response = service.SaveGroupActivityRec(baseRequest); return(Ok(response)); }