/// <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)));
}
