/// <summary>
/// CRM14_1報表(列印鈕)-明細表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <param name="ReportOutputFormat">報表格式(PDF,EXCEL)</param>
/// <param name="EOT">匯出Excel方式</param>
/// <returns>回傳查詢結果</returns>
public DataTable CRM14_1(ArrayList ParameterList,
string ReportOutputFormat,
ref ReportList.ExcelOtherType EOT
)
{
#region
CRMModel.QueryCRMTicketReport BCO = new CRMModel.QueryCRMTicketReport(ConntionDB);
DataTable Dt = null;
Dt = BCO.PrintDetail(ParameterList);
if (Dt == null || Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
return Dt;
#endregion
}
/// <summary>
/// BUTTON TEST列印 按下按鈕
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
try
{
#region 從資料庫讀取資料
#region 組SQL字串
System.Text.StringBuilder srb_SQL = new System.Text.StringBuilder();
srb_SQL.Append(@"
select T.CRM_DATE, T.STORE || S.STORE_NAME as STOREANDNAME,
S.Z_O || (select C.EXPLAIN
from SYS_CODE_DETL C
where C.CATEGORY = '97'
and C.SCODE = S.Z_O) as Z_OANDNAME, U.name,
T.REQUEST_NO || (select C.EXPLAIN
from SYS_CODE_DETL C
where C.CATEGORY = 'C1'
and C.SCODE = T.REQUEST_NO) as REQUEST_NOANDNAME,
T.REQUEST_STATEMENT
from VDS_CRM_TICKET T, VDS_STM_STORE S, SYS_USER U
where T.ENABLE = 1
and T.STORE = S.STORE
and T.BUSUID = U.CODE(+)
and S.SAL_ID = U.CODE
");
srb_SQL.Append("order by T.CHAN_NO, T.CRM_DATE, T.STORE");
#endregion
ParameterList.Clear();
ParameterList.Add(srb_SQL.ToString());
ParameterList.Add(Session["UID"].ToString());
ParameterList.Add("CRM141_客服記錄明細表(報表格式)");
DataTable dt_Return = new DataTable();
BCO.QueryCRMTicketReport bco = new BCO.QueryCRMTicketReport(ConntionDB);
dt_Return = bco.PrintDetail(ParameterList);
#endregion
#region 利用CrystalReport列印報表
string s_par_Program_ID = string.Empty;
string s_par_LoginUser = string.Empty;
string s_par_DateRange = string.Empty;
string s_par_StoreChain = string.Empty;
string s_par_CodeFile = string.Empty;
string s_par_Role = string.Empty;
string s_par_User = string.Empty;
string s_par_Handle_Status = string.Empty;
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Server.MapPath("./../REPORT/CRSTM08R03.rpt"));
report.SetDataSource(dt_Return);
Session["CRSTM08R03"] = report;
s_par_Program_ID = "s_par_Program_ID";
s_par_LoginUser = Session["UID"].ToString();
ParameterFields par1 = new ParameterFields();
AddParameter("par_Program_ID", s_par_Program_ID, par1);
ParameterFields par2 = new ParameterFields();
AddParameter("par_LoginUser", s_par_LoginUser, par2);
//this.CryView.ReportSource = null;
this.CryView.ReportSource = (ReportDocument)Session["CRSTM08R03"];
this.CryView.ParameterFieldInfo.Add(par1[0]);
this.CryView.ParameterFieldInfo.Add(par2[0]);
#endregion
}
catch (Exception ex)
{ this.ErrorMsgLabel.Text = ex.ToString(); }
}
