# 业务场景
纯二开的一张分页账表，在使用分页账表的套打导出全部分页账表功能时，需要按照客户加客户编码分文件导出
# 实现步骤
## 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(firstCustome["Number"]));
}
if (Convert.ToInt32(customFilter["F_USPV_lastCustomer_Id"]) != 0)
{
sSQL += string.Format(@" and a.FNUMBER <= '{0}'", Convert.ToString(lastCustomer["Number"]));
}
sSQL += " order by a.FNUMBER ";
dt = DBUtils.ExecuteDataSet(this.Context, sSQL).Tables[0];
return dt;
}
```
## 4.账表服务插件中设置 导出文件名属性
public override void Initialize()
{ //初始化
base.Initialize();
// 简单账表类型：分页
this.ReportProperty.ReportType = ReportType.REPORTTYPE_MOVE;
//导出文件名属性
this.ReportProperty.ReportExprotFileNameFieldName = "FBMJMC";
this.IsCreateTempTableByPlugin = true;
//设置为false时,报表中的列以插件定义为准 为true则以元数据为准
ReportProperty.IsUIDesignerColumns = true;
//是否分组汇总
this.ReportProperty.IsGroupSummary = true;
}
```
