public List <Model.Config> GetConfigs(Common.DataContext ctx) { //var tb = this.Select(ctx, new Model.Config() {State = 0}); var tb = ctx.ExecuteDataTable("Select * From Config Where State<>255"); if (tb != null && tb.Rows.Count > 0) { return(tb.ToList <Model.Config>().OrderBy(c => c.Code).ToList()); } return(new List <Model.Config>()); }
public List <Model.Channel> GetChannels(Common.DataContext ctx) { var tb = ctx.ExecuteDataTable("Select [ID],Code,Name as CName,ParentId,Case ParentId when 0 then [Name] else '|--'+[Name] end [Name],[Type],[ContentType],Case ParentId when 0 then ID else ParentId end sortId from [Channel] where State <> 255 order by sortId"); if (tb != null && tb.Rows.Count > 0) { var channels = tb.ToList <Model.Channel>(); return(channels); } return(new List <Model.Channel>()); }