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