public ResponseResult <PageList <Plan> > GetPlanList([FromBody] PlanSearch search) { return(ToResponse(() => { return _PlanRepo.GetPlans(search); })); }
public ActionResult Search(PlanSearch condition) { _DatatableResponseModel response = new _DatatableResponseModel(); PlanModel model = new PlanModel(); model.Search(condition); return Json(model.Items); }
public CurPageViewModel() { SearchCondition = new PlanSearch() { UnitName = AppSet.LoginUser.UnitName, PageIndex = 1, PageSize = 15 }; EntityPlans = new ObservableCollection <Lib.PlanEntity>(); CanVisible = "Collapsed"; }
public void Search(PlanSearch condition) { using (var entities = new DB_SWQUALEntities()) { Items = new _DatatableResponseModel(); var result = from o in entities.plan select o; Items.data = result.ToList().Skip(condition.start).Take(condition.length).Select(MediaItemSelector).Cast<object>().ToList(); Items.draw = condition.draw; Items.recordsFiltered = result.Count(); Items.recordsTotal = result.Count(); } }
public PageList <Plan> GetPlans(PlanSearch search) { search.Page.OrderField = "p.CreateTime"; string sql = @" SELECT p.[AutoID], p.[ID], p.[Title], p.[Author], p.[Description], p.[CreateTime], p.[PlanType], p.[DeleteFlag], p.[AuthFlag], p.[PlanCategory], COUNT(jp.JobPlanID) ReferenceCount FROM [Cherimoya].[dbo].[PlanDB] p (NOLOCK) LEFT JOIN dbo.JobPlanDB jp (NOLOCK) ON p.AutoID = jp.AutoID AND jp.DeleteFlag = 0 WHERE p.DeleteFlag = 0 {0} GROUP BY p.[AutoID], p.[ID], p.[Title], p.[Author], p.[Description], p.[CreateTime], p.[PlanType], p.[DeleteFlag], p.[AuthFlag], p.[PlanCategory] "; var param = ""; if (search.BeginDate.HasValue) { param += " AND p.CreateTime >= @BeginDate "; } if (search.EndDate.HasValue) { param += " AND p.CreateTime <= @EndDate "; } if (search.PlanType >= 0) { param += " AND p.PlanType = @PlanType "; } if (search.AuthFlag >= 0) { param += " AND p.AuthFlag = @PlanType "; } if (!string.IsNullOrEmpty(search.PlanCategory)) { param += " AND p.PlanCategory = @PlanCategory "; } if (!string.IsNullOrEmpty(search.Author)) { param += " AND p.Author = @Author "; } if (!string.IsNullOrEmpty(search.PlanName)) { param += " AND p.Title Like '%" + search.PlanName + "%' "; } if (!string.IsNullOrEmpty(search.Desc)) { param += " AND p.Description Like '%" + search.Desc + "%' "; } return(QueryPage <Plan>(string.Format(sql, param), search, search.Page)); }