/// <summary> /// 根据某个表名查询实体集合(分页) /// </summary> /// <typeparam name="T">泛型类型</typeparam> /// <param name="strTableName">属性名称</param> /// <param name="fieldShow">属性名称</param> /// <param name="pageSize">属性名称</param> /// <param name="currentPageIndex">属性名称</param> /// <param name="intCountPage">属性值</param> /// <param name="component">属性值</param> /// <returns></returns> public IList <T> GetList <T>(string strTableName, string fieldShow, int pageSize, int currentPageIndex, int intCountPage, ConditionComponent component) where T : class { IDataParameter[] param = null; StringBuilder sbSQL = new StringBuilder(); sbSQL.Append(" select "); sbSQL.Append(fieldShow); //此功能暂未实现 sbSQL.Append(" from "); sbSQL.Append(strTableName); if (component != null && component.sbComponent.Length > 0) { sbSQL.Append(" where "); sbSQL.Append(component.sbComponent.ToString()); } intRowCount_ = int.Parse(BaseHelper.ExecuteScalar(sbSQL.ToString().Replace(fieldShow, "count(*)")).ToString()); intPageNum_ = pageSize; //string strSql = Factory.CreatePageSql(typeof(T),pageSize, currentPageIndex, intCountPage, sbSQL.ToString()); string strSql = Factory.CreatePageSql(typeof(T), pageSize, currentPageIndex, intCountPage, sbSQL.ToString()); // return BaseHelper.Query(strSql); return(BaseHelper.ConvertToList <T>(BaseHelper.ExecuteDataReader(strSql, param as OracleParameter[]))); }
/// <summary> /// 根据多个属性查询实体集合 /// 该查询方式附加查询组建 /// </summary> /// <typeparam name="T">类型类</typeparam> /// <param name="dic">属性键值对</param> /// <param name="component">查询组件</param> /// <returns></returns> public IList <T> GetListTop <T>(IDictionary <string, object> dic, ConditionComponent component) where T : class { IDataParameter[] param = null; string sql = Factory.CreateQueryByPropertySql(typeof(T), dic, out param, component); return(BaseHelper.ConvertToList <T>(BaseHelper.ExecuteDataReader(sql, param as OracleParameter[]))); }
/// <summary> /// 根据多个属性查询实体集合 /// </summary> /// <typeparam name="T">泛型类型</typeparam> /// <param name="dic">实体公共接口</param> /// <returns></returns> public IList <T> GetListTop <T>(IDictionary <string, object> dic) where T : class { IDataParameter[] param = null; string sql = Factory.CreateQueryByPropertySql(typeof(T), dic, out param); strOrderString = ""; return(BaseHelper.ConvertToList <T>(BaseHelper.ExecuteDataReader(sql, param))); }
/// <summary> /// 根据某个实体属性查询实体集合 /// </summary> /// <typeparam name="T">泛型类型</typeparam> /// <param name="iTop">属性名称</param> /// <param name="strTableName">属性名称</param> /// <param name="component">属性值</param> /// <returns></returns> public IList <T> GetListTop <T>(int iTop, ConditionComponent component) where T : class { IDataParameter[] param = null; string strWhere = ((component == null || component.sbComponent == null) ? "" : component.sbComponent.ToString()); string sql = Factory.CreateQuerySql(typeof(T), "*", strWhere, iTop); strOrderString = ""; return(BaseHelper.ConvertToList <T>(BaseHelper.ExecuteDataReader(sql, param))); }
/// <summary> /// 根据某个表名查询实体集合(分页) /// </summary> /// <typeparam name="T">泛型类型</typeparam> /// <param name="strTableName">属性名称</param> /// <param name="fieldShow">属性名称</param> /// <param name="pageSize">属性名称</param> /// <param name="currentPageIndex">属性名称</param> /// <param name="intCountPage">属性值</param> /// <param name="component">属性值</param> /// <param name="isDel">是否删除0 未删除 1 已删除 2 所有</param> /// <returns></returns> public IList <T> GetList <T>(string strTableName, string fieldShow, string strKey, int pageSize, int currentPageIndex, int intCountPage, ConditionComponent component) where T : class { IDataParameter[] param = null; //StringBuilder sbSQL = new StringBuilder(); //sbSQL.Append(" select "); //sbSQL.Append(fieldShow); //此功能暂未实现 //sbSQL.Append(" from "); //sbSQL.Append(strTableName); //if (component != null && component.sbComponent.Length > 0) //{ // sbSQL.Append(" where "); // sbSQL.Append(component.sbComponent.ToString()); //} //intRowCount_ = int.Parse(BaseHelper.ExecuteScalar(sbSQL.ToString().Replace(fieldShow, "count(*)")).ToString()); intPageNum_ = pageSize; //string strSql = Factory.CreatePageSql(typeof(T),pageSize, currentPageIndex, intCountPage, sbSQL.ToString()); //if (isDel == 0) //{ // component.AddComponent("isnull(isdel,0)", "0", SearchComponent.Equals, SearchPad.And); //} //else if (isDel == 1) //{ // component.AddComponent("isdel", "1", SearchComponent.Equals, SearchPad.And); //} string strSql = Factory.CreatePageSql(strTableName, fieldShow, strKey, strOrderString_, pageSize, currentPageIndex, intCountPage, component.sbComponent.ToString(), out param); strOrderString_ = ""; // return BaseHelper.Query(strSql); IList <T> lstRet = BaseHelper.ConvertToList <T>(BaseHelper.ExecuteDataReader(strSql, true, param)); if (intCountPage <= 1 && (param[param.Length - 1] as SqlParameter) != null && (param[param.Length - 1] as SqlParameter).Value.ToString() != "") { intRowCount_ = Int32.Parse((param[param.Length - 1] as SqlParameter).Value.ToString()); } else { intPageCount_ = intCountPage; } return(lstRet); }
/// <summary> /// 查询所有实体集合 /// </summary> /// <typeparam name="T">泛型类型</typeparam> /// <param name="iTop">属性值</param> /// <param name="fieldShow">查询的列</param> /// <param name="component">属性值</param> /// <returns></returns> public IList <T> GetListTop <T>(int iTop, string fieldShow, ConditionComponent component) where T : class { string strWhere = " 1=1 "; if (iTop > 0) { strWhere += " and rownum<=" + iTop.ToString(); } if (component != null && component.sbComponent.Length > 0) { strWhere += " and " + component.sbComponent.ToString(); } string sql = Factory.CreateQuerySql(typeof(T), fieldShow, strWhere, iTop); return(BaseHelper.ConvertToList <T>(BaseHelper.ExecuteDataReader(sql))); }