public string GetFestivalList(HttpContext context) { BCtrl_Festival bll = new BCtrl_Festival(); List <FestivalEntity> list = bll.GetFestivalList("", 3); if (list == null) { return(string.Empty); } var groupYear = list.OrderByDescending(o => o.StartTime).GroupBy(o => o.StartTime.ToString("yyyy年")); List <FestivalEntity> resultlist = new List <FestivalEntity>(); foreach (var year in groupYear) { FestivalEntity entity = new FestivalEntity { FestivalName = year.Key, FestivalList = year.Select(o => o).ToList() }; resultlist.Add(entity); } string result = StringUti.ToUnicode(JsonObj <object> .ToJsonString(resultlist)); return(result); }
public string GetFestivalListByGroup(HttpContext context) { BCtrl_Festival bll = new BCtrl_Festival(); string qvalue = context.Request.QueryString["query"]; List <FestivalEntity> list = bll.GetFestivalList(qvalue, 3); if (list != null) { dynamic result = new { query = "Unit", suggestions = list.Select(o => new { value = o.FestivalName, data = new { category = o.StartTime.ToString("yyyy年"), text = o.FestivalID } }) }; string temp = StringUti.ToUnicode(JsonObj <object> .ToJsonString(result)); return(temp); } return(string.Empty); }
private DataTable GetQueryData(bool isDownload) { int totalcnt = 0; BCtrl_Festival bll = new BCtrl_Festival(); searchFestivalEntity entity = new searchFestivalEntity(); if (!string.IsNullOrEmpty(txtStartTime)) { entity.StartTime = txtStartTime; } if (!string.IsNullOrEmpty(txtEndTime)) { entity.EndTime = txtEndTime; } entity.PageSize = base.PageSize; entity.PageIndex = base.PageIndex; entity.UseDBPagination = !isDownload; entity.OrderfieldType = OrderFieldType.Desc; DataTable db = bll.GetFestivalList(entity, out totalcnt); base.TotalRecords = totalcnt; return(db); }