/// <summary>
/// CRM02_1報表(匯出鈕)
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
/// <param name="EOT">匯出Excel方式</param>
/// <returns>回傳查詢結果</returns>
public DataTable CRM02_1(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
#region
CRMModel.QueryCRMTicketReport BCO = new CRMModel.QueryCRMTicketReport(ConntionDB);
DataTable Dt = BCO.QueryCRMRecordAndTicketByFind(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 = "主管簽核日";
#endregion
EOT = ReportList.ExcelOtherType.Normal;
}
return Dt;
#endregion
}
/// <summary>
/// 從資料數讀取資料
/// </summary>
/// <returns></returns>
private DataTable GetQueryData()
{
#region
try
{
#region 組SQL字串
System.Text.StringBuilder srb_SQL = new System.Text.StringBuilder();
srb_SQL.Append(@"
select M.CRM_DATE, M.CRM_NO,
(select R1.name
from SYS_USER R1
where R1.CODE = M.BUSUID) as BUSUID_NAME, M.KD, M.REQUEST_NO,
M.REQUEST_STATEMENT,
(select R1.name
from SYS_USER R1
where R1.CODE = M.PROC_MAN) as PROC_MAN_NAME, M.CLOSE_DATE,
M.CONFIRM_DATE, M.ID
from VDS_CRM_MAINA_VIEW M
");
srb_SQL.Append(ToMakeSQL().ToString());
#endregion
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(srb_SQL.ToString());
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add("CRM021_按下Button[查詢]");
DataTable dt_Return = new DataTable();
BCO.QueryCRMTicketReport bco = new BCO.QueryCRMTicketReport(ConntionDB);
dt_Return = bco.QueryCRMRecordAndTicketByFind(ParameterList);
return dt_Return;
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
