/// <summary>
/// CRM14_3報表(匯出鈕)
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
/// <param name="EOT">匯出Excel方式</param>
/// <returns>回傳查詢結果</returns>
public DataTable CRM14_3(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
#region
CRMModel.QueryCRMTicketReport BCO = new CRMModel.QueryCRMTicketReport(ConntionDB);
DataTable Dt = BCO.Export(ParameterList);
if (Dt == null || Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
//設定使用第三方元件匯出EXCEL
if (ReportOutputFormat == "EXCEL")
{
#region 表頭
Dt.Columns[0].ColumnName = "來電日";
Dt.Columns[1].ColumnName = "店號";
Dt.Columns[2].ColumnName = "店名";
Dt.Columns[3].ColumnName = "營業所";
Dt.Columns[4].ColumnName = "營業所名稱";
Dt.Columns[5].ColumnName = "營業員";
Dt.Columns[6].ColumnName = "營業員名稱";
Dt.Columns[7].ColumnName = "原因代號";
Dt.Columns[8].ColumnName = "原因說明";
Dt.Columns[9].ColumnName = "問題陳述";
Dt.Columns[10].ColumnName = "處理敘述 ";
#endregion
EOT = ReportList.ExcelOtherType.Normal;
}
return Dt;
#endregion
}
