
# 业务场景
纯二开的一张分页账表,在使用分页账表的套打导出全部分页账表功能时,需要按照客户加客户编码分文件导出

# 实现步骤
## 1.参考资料:[套打.二开案例.分页账表导出按页分文件导出文件名](https://wenku.my7c.com/article/436172358412320768?channel_level=%E9%87%91%E8%9D%B6%E4%BA%91%E7%A4%BE%E5%8C%BA%7C%E6%90%9C%E7%B4%A2%7C%E7%BB%BC%E5%90%88&productLineId=1)
在套打设置里,设置按分页文件导出

## 2.需要在BOS增加按钮,添加套打导出全部分页报表的操作

## 3.分页账表代码调整
在GetList方法的分页依据表dt中增加字段存储文件名
```language
/// 分页报表必须实现的方法,此方法用于为报表提供分页依据。
public override DataTable GetList(IRptParams filter)
{
DataTable dt;
DynamicObject customFilter = filter.FilterParameter.CustomFilter;
//查询分页表的sql,FBMJMC字段就是分页导出文件的文件名,就是客户编码加客户名称
//'.xlsx'就是导出文件名的后缀,这里不加的话导出的文件将无法识别
string sSQL = "/*dialect*/select a.FNUMBER,b.FCUSTID,b.FNAME as FCustomerName,a.FNUMBER+'-'+b.FNAME+'.xlsx' FBMJMC " +
"from T_BD_CUSTOMER a " +
"inner join T_BD_CUSTOMER_L b on a.FCUSTID = b.FCUSTID and b.FLOCALEID = 2052 ";
DynamicObject firstCustome = customFilter["F_USPV_firstCustomer"] as DynamicObject;
DynamicObject lastCustomer = customFilter["F_USPV_lastCustomer"] as DynamicObject;
if (Convert.ToInt32(customFilter["F_USPV_firstCustomer_Id"]) != 0)
{
sSQL += string.Format(@" and a.FNUMBER >= '{0}'", Convert.ToString(firstCusto