62,074
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM
(SELECT ROW_NUMBER() OVER (ORDER BY Fav.ID desc) AS RowNumber,* FROM
(Fav Left Join UserInfo UA ON Fav.ToUserID = UA.ID)
Where UserID=174) TA
WHERE RowNumber BETWEEN 1 AND 10
private List<Model.Fav> _GetList(string sql)
{
using (var conn = DbHelper.OpenConnection())
{
List<Model.Fav> list = conn.Query<Model.Fav, Model.UserInfo, Model.Fav>(sql,
(mFav, mSub1, mSub2) =>
{
mFav.ToUserIDModel = mSub2;
return mFav;
}).ToList();
return list;
}
}