protected void btnExport_OnClick(object sender, EventArgs e)
{
try
{
var result = GetData();
if (result.Any() || result.Any())
{
List <string> headerList = new List <string>()
{
"订单编号", "订单状态", "订单关闭日期",
"预约人", "数量", "商品名称", "入住时间"
, "离店时间", "商品单价", "总计"
};
List <int> columnIndexList = new List <int>()
{
3, 2, 11, 4, 5, 6, 7, 8, 9, 10
};
CSVHelper.DownloadAsSCV <OrderDetailDTO>(Response, "服务凭据查询", result,
columnIndexList, headerList);
}
}
catch
{
}
}
private void DownloadExcel()
{
var dataTable = new DataTable();
dataTable.Columns.Add("序号");
dataTable.Columns.Add("订单编号");
dataTable.Columns.Add("订单状态");
dataTable.Columns.Add("订单关闭日期");
dataTable.Columns.Add("预约人");
dataTable.Columns.Add("总计");
var data = SearchData();
if (data != null && data.Count > 0)
{
DataRow newRow = null;
for (int index = 0; index < data.Count; index++)
{
newRow = dataTable.NewRow();
newRow[0] = index + 1;
newRow[1] = data[index].OrderNumber;
newRow[2] = data[index].PayStatus;
newRow[3] = data[index].ModifyTime;
newRow[4] = data[index].CustomerName;
newRow[5] = data[index].PayAmount;
dataTable.Rows.Add(newRow);
}
}
CSVHelper.DownloadAsSCV(Response, "餐饮服务验证码", dataTable);
}
protected void btnExport_OnClick(object sender, EventArgs e)
{
try
{
var result = GetData(true);
var headerList = new List <string>()
{
"序号",
"退单号",
"订单号",
"预订人",
"电话",
"预定时间",
"退单商品",
"退款总额",
"退单状态"
};
var columnIndex = new List <int>()
{
11, 2, 3, 4, 5, 6, 7, 8, 10
};
CSVHelper.DownloadAsSCV(Response, "退单管理", result.Tables[0], columnIndex, headerList);
}
catch (Exception)
{
}
}
/// <summary>
/// 导出按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_OnClick(object sender, EventArgs e)
{
try
{
GetWhere();
var result = GetQueryData();
List <string> headerList = new List <string>()
{
"序号", "订单编号", "订单状态", "是否退单",
"商户或门店名称", " 预定人", "交易日期", "商品名称", "购买数量", "商品价格", "入住时间"
, "离店时间", "支付金额"
};
List <int> columnIndexList = new List <int>()
{
1, 5, 22, 23, 20, 4, 18, 11, 13, 14, 9, 10, 21
};
CSVHelper.DownloadAsSCV(Response, "酒店订单管理", result.Tables[0], columnIndexList, headerList);
}
catch (Exception)
{
// ignored
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
try
{
var result = QueryData(true);
var headerList = new List <string>()
{
"订单号",
"预订人",
"电话",
"预定时间",
"总价",
"预订套餐",
};
var columnIndex = new List <int>()
{
2, 3, 5, 4, 6, 8
};
CSVHelper.DownloadAsSCV(Response, "订单管理", result.Tables[0], columnIndex, headerList);
}
catch (Exception exception)
{
}
}
