/// <summary>
/// 分页获取dataset
/// </summary>
/// <param name="pagesize"></param>
/// <param name="pageindex"></param>
/// <param name="where"></param>
/// <returns></returns>
public static DataSet GetPageDataSet(int pagesize, int pageindex, out int total, string where = "")
{
var skip = (pageindex - 1) * pagesize;
var wsql = "SELECT * FROM [UserPhotoSnap] " + where;
var sql = wsql + " ORDER BY ID DESC OFFSET " + skip + " ROWS FETCH NEXT " +
pagesize +
" ROWS ONLY;";
total = (int)SqlCeHelper.ExecuteScalar(CONNECTION_STRING, CommandType.Text, wsql.Replace("*", "COUNT(*) AS CT"));
return(SqlCeHelper.ExecuteDataset(CONNECTION_STRING, CommandType.Text, sql));
}
public static DataSet GetPhotos()
{
return(SqlCeHelper.ExecuteDataset(CONNECTION_STRING, CommandType.Text, "SELECT * FROM [UserPhotoSnap]"));
}
