protected void DownData(object sender, EventArgs e)
{
int totalTicketCount;
decimal totalAmount;
DataTable statInfos = ReportService.QueryTodayProvideStatistics(getCondition(), GetSelectGroupInfo(), null, out totalTicketCount, out totalAmount);
ChangeColumnName(statInfos, "Carrier", "承运人");
ChangeColumnName(statInfos, "AirportPair", "航线");
ChangeColumnName(statInfos, "FlightNo", "航班号");
ChangeColumnName(statInfos, "Bunk", "舱位");
ChangeColumnName(statInfos, "TicketCount", "票量");
ChangeColumnName(statInfos, "Amount", "交易金额");
ChangeColumnName(statInfos, "ProviderName", "出票方");
ChangeColumnName(statInfos, "Relation", "销售关系");
DataRow dr = statInfos.NewRow();
if (totalTicketCount != 0)
{
dr["票量"] = totalTicketCount;
}
if (totalAmount != 0)
{
dr["交易金额"] = totalAmount;
}
for (int i = 0; i < statInfos.Columns.Count; i++)
{
statInfos.Columns[i].AllowDBNull = true;
}
statInfos.Rows.Add(dr);
NPOIExcelHelper.ExportDataTableToExcelAutoSheetName(statInfos, downloadFileName("当日票量分析报表"));
}
