c# sql级联查询分页

最新推荐文章于 2023-01-29 11:23:52 发布

weixin_43470677

最新推荐文章于 2023-01-29 11:23:52 发布

阅读量213

点赞数

分类专栏： c# 文章标签： c# sql 级联查询分页

本文链接：https://blog.csdn.net/weixin_43470677/article/details/102635542

版权

c# 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

    public DataSet GetListByPage_ds(string strWhere, string orderby, int startIndex, int endIndex, IDbConnection conn)
    {


        string strSql = @"SELECT TOP " + endIndex + @" 
                    f.id,f.userid,f.lbid,
                    u.user_id,
                    l.id,

                    FROM fuwu f
                    INNER JOIN users as u on f.userid = u.user_id
                    INNER JOIN leibie as l on f.lbid = l.id
                    WHERE f.ID NOT IN 
                    (SELECT TOP " + startIndex + @" f.Id FROM fuwu f
                    INNER JOIN users as u on f.userid = u.user_id
                    INNER JOIN leibie as l on f.lbid = l.id
                    where 1=1 
                    " + strWhere + @"
                    ORDER BY f.Id desc) 
                    and 1=1  " + strWhere + @"  
                    ORDER BY f.ID desc;";
        DataSet ds = DataAccessUtil.ExecuteDataSet(strSql.ToString(), new List<SqlParameter>(), (SqlConnection)conn);
        return ds;
    }