// Token: 0x0600009F RID: 159 RVA: 0x0000F068 File Offset: 0x0000D268 protected override void View() { this.channelinfo = ChannelBll.GetChannelInfo(this.channelid); if (this.channelinfo.id == 0) { this.ShowErr("考试频道不存在或已被删除。"); } else { this.sortlist = SortBll.GetSortList(this.channelid, 0); List <SqlParam> list = new List <SqlParam>(); list.Add(DbHelper.MakeAndWhere("status", 1)); if (this.channelid > 0) { list.Add(DbHelper.MakeAndWhere("channelid", this.channelid)); } if (this.sortid > 0) { string childSorts = SortBll.GetChildSorts(this.sortid); list.Add(DbHelper.MakeAndWhere("sortid", WhereType.In, childSorts)); } if (FPUtils.IsNumericArray(this.typeid)) { StringBuilder stringBuilder = new StringBuilder(); foreach (int num in FPUtils.SplitInt(this.typeid)) { if (!string.IsNullOrEmpty(stringBuilder.ToString())) { stringBuilder.Append(" OR "); } stringBuilder.AppendFormat("(','+[typelist]+',') LIKE '%,{0},%'", num); } list.Add(DbHelper.MakeAndWhere("(" + stringBuilder.ToString() + ")", WhereType.Custom, "")); } list.Add(DbHelper.MakeAndWhere(string.Format("(([examroles]='' AND [examdeparts]='' AND [examuser]='') OR (','+[examroles]+',') LIKE '%,{0},%' OR (','+[examdeparts]+',') LIKE '%,{1},%' OR (','+[examuser]+',') LIKE '%,{2},%')", this.roleid, this.departid, this.userid), WhereType.Custom, "")); this._examlist = DbHelper.ExecuteList <ExamInfo>(this.pager, list.ToArray()); this.pagenav = this.channelinfo.name; } }
// Token: 0x06000053 RID: 83 RVA: 0x00004E70 File Offset: 0x00003070 public static List <ChannelInfo> GetChannelList(string idmarkup) { OrderByParam orderby = DbHelper.MakeOrderBy("display", OrderBy.ASC); List <ChannelInfo> result; if (FPUtils.IsNumericArray(idmarkup)) { SqlParam sqlParam = DbHelper.MakeAndWhere("id", WhereType.In, idmarkup); result = DbHelper.ExecuteList <ChannelInfo>(orderby, new SqlParam[] { sqlParam }); } else { SqlParam sqlParam = DbHelper.MakeAndWhere("markup", WhereType.Like, idmarkup); result = DbHelper.ExecuteList <ChannelInfo>(orderby, new SqlParam[] { sqlParam }); } return(result); }