/// <summary> /// 分页查询表(返回List) /// </summary> /// <param name="scopeList">范围查找的集合</param> /// <returns></returns> public List <T> SelectList(ScopeList scopeList) { if (scopeList.HasPage) { if (!scopeList.HasSort) { foreach (EntityPropertyInfo pInfo in CurEntityInfo.PrimaryProperty) { scopeList.OrderBy.Add(pInfo.PropertyName, SortType.ASC); } } } if (scopeList.HasInner) { return(_cdal.SelectList <T>(scopeList)); } ParamList list = null; list = new ParamList(); string sql = null; using (BatchAction ba = Oper.StarBatchAction()) { if (!scopeList.HasPage)//判断是否分页查询 { sql = GetSelectContant(list, scopeList, GetSelectParams(scopeList)).GetSql(scopeList.UseCache); } else { sql = GetSelectPageContant(list, scopeList); } List <T> retlist = null; Dictionary <string, bool> cacheTables = null; if (scopeList.UseCache) { cacheTables = _oper.DBInfo.QueryCache.CreateMap(CurEntityInfo.TableName); } retlist = QueryList(sql, list, CommandType.Text, cacheTables); DataAccessCommon.FillEntityChidList(retlist, scopeList); return(retlist); } }
/// <summary> /// 查询表 /// </summary> /// <param name="scopeList">范围查找的集合</param> /// <returns></returns> public DataSet Select(ScopeList scopeList) { if (scopeList.HasInner) { if (scopeList.OrderBy.Count <= 0 && scopeList.HasPage) { foreach (EntityPropertyInfo pInfo in CurEntityInfo.PrimaryProperty) { scopeList.OrderBy.Add(pInfo.PropertyName, SortType.ASC); } } return(_cdal.SelectDataSet <T>(scopeList)); } ParamList list = null; list = new ParamList(); string sql = null; PageContent objPage = scopeList.PageContent; using (BatchAction ba = Oper.StarBatchAction()) { if (objPage == null)//判断是否分页查询 { sql = GetSelectContant(list, scopeList, GetSelectParams(scopeList)).GetSql(scopeList.UseCache); } else { sql = GetSelectPageContant(list, scopeList); } DataSet ds = null; Dictionary <string, bool> cacheTables = null; if (scopeList.UseCache) { cacheTables = _oper.DBInfo.QueryCache.CreateMap(CurEntityInfo.TableName); } ds = _oper.QueryDataSet(sql, list, CommandType.Text, cacheTables); return(ds); } }