Linq返回的集合类型不是已有的表格类型时的写法(谨记:列表的时候用)

  public IEnumerable GetYsqgkHandleList(int startIndex, int pageSize)
        {
            DataClassesDataContext _db = DataClassesDataContext.Default;
            var result = _db.T_INTERACTION.Where(i => i.INTERACTION_CATALOG == "依申请公开" && i.BE_PASS == 1);           
            var data = result.Select(i => new
            {
                 i.Q_TYPE,
                 NAME = i.Q_TYPE == "公民" ? i.Q_USER_NAME : i.OFFICE_NAME,
                 i.Q_TIME,
                 i.A_TIME
            }).OrderByDescending(i=>i.Q_TIME).Skip(startIndex-1).Take(pageSize).ToArray();
            total = result.Count();
            return data;

        }

 

posted @ 2013-08-21 14:04  天殇月痕  阅读(172)  评论(0编辑  收藏  举报