/// <summary>
/// 循环里面 每次获取10个分类 isLeaf=1 AND ID >{0}
/// </summary>
/// <param name="id"> </param>
/// <returns></returns>
public static List <CategoryInfoEntity> GetList_9()
{
string sqlText = "SELECT top 10 * FROM dbo.CategoryInfo WHERE isLeaf=1 and IsProcess=0 ";
DataSet ds = DBCommon.DBHelper.Query(ConnString, sqlText);
return(DALUtil.ConvertDataTableToEntityList <CategoryInfoEntity>(ds.Tables[0]));
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="SelectIF">需要查询的字段</param>
/// <param name="pramsWhere">条件集合</param>
/// <param name="OrderName">排序无需带Order by</param>
public static List <CategoryInfoEntity> GetList(string SelectIF, int level, string OrderName = "")
{
SqlParameter[] pramsWhere =
{
DALUtil.MakeInParam("@level", SqlDbType.Int, 4, level)
};
DataTable dt = DBCommon.DBHelper.GetDataTable2(ConnString, TableName, SelectIF, pramsWhere, OrderName);
return(DALUtil.ConvertDataTableToEntityList <CategoryInfoEntity>(dt));
}
/// <summary>
/// 分页获取数据
///条件如：a=1 and b=2
/// </summary>
/// <param name="PageIndex">页码</param>
/// <param name="PageSize">数量</param>
/// <param name="SelectIF">查询字段</param>
/// <param name="OrderName">排序值</param>
/// <param name="strWhere">条件(a=1 and b=2)</param>
/// <param name="values">条件对应值</param>
public static List <CategoryInfoEntity> GetPageList(int PageIndex, int PageSize, string SelectIF, string OrderName, string strWhere, params object[] values)
{
DataTable dt = DBCommon.DBHelper.GetDataTablePage(ConnString, TableName, SelectIF, PageIndex, PageSize, OrderName, strWhere, values);
return(DALUtil.ConvertDataTableToEntityList <CategoryInfoEntity>(dt));
}
/// <summary>
/// 分页获取数据
///条件如：a=1 and b=2
/// </summary>
/// <param name="PageIndex">页码</param>
/// <param name="PageSize">数量</param>
/// <param name="SelectIF">查询字段</param>
/// <param name="OrderName">排序值</param>
/// <param name="strWhere">条件(a=1 and b=2)</param>
/// <param name="values">条件对应值</param>
public static List <AttributeValueInfoEntity> GetPageList(int PageIndex, int PageSize, string SelectIF, string OrderName, string strWhere, List <object> valuesList)
{
DataTable dt = DBCommon.DBHelper.GetDataTablePage(ConnString, TableName, SelectIF, PageIndex, PageSize, OrderName, strWhere, valuesList.ToArray());
return(DALUtil.ConvertDataTableToEntityList <AttributeValueInfoEntity>(dt));
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="SelectIF">需要查询的字段</param>
/// <param name="pramsWhere">条件集合</param>
/// <param name="OrderName">排序无需带Order by</param>
public static List <AttributeValueInfoEntity> GetList(string SelectIF, SqlParameter[] pramsWhere, string OrderName = "")
{
DataTable dt = DBCommon.DBHelper.GetDataTable2(ConnString, TableName, SelectIF, pramsWhere, OrderName);
return(DALUtil.ConvertDataTableToEntityList <AttributeValueInfoEntity>(dt));
}
