/// <summary>
/// 获取视图导出数据
/// </summary>
/// <param name="_sql"></param>
/// <param name="page"></param>
/// <param name="User"></param>
/// <returns></returns>
public DataTable GetViewExportData(string _sql, Pagination page, AdminCredential admin)
{
DBDatabase db = CreateDao();
PageOfDaTaSet result;
var sql = CacheHelper.Single.TryGet($"{page.vid}-{admin.ID}-list-sql", 0, () => { return(_sql); }).ToString();
result = db.DataSetPage(page.Page, page.PageSize, new Sql(sql));
db.Dispose();
if (result.Data.Tables.Count > 0)
{
return(result.Data.Tables[0]);
}
else
{
return(new DataTable());
}
}