/// <summary>
/// CAA21報表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable CAA21_1(ArrayList ParameterList)
{
CAAModel.InvoiceLetterPrint bco = new CAAModel.InvoiceLetterPrint(ConntionDB);
DataTable Dt = bco.PrintReport(ParameterList);
if (Dt.Rows.Count == 0)
{
throw new Exception("查無資料");
}
else
{
return Dt;
}
}
//protected void btnReport_Click(object sender, EventArgs e)
//{
// try
// {
// CAAModel.InvoiceLetterPrint BCO = new CAAModel.InvoiceLetterPrint(ConntionDB);
// DataTable dt;
// ParameterList.Clear();
// string strINVOICE_SEND = SLP_INVOICE_SEND.Text;
// ParameterList.Add(this.SLP_YearMonth.Text.Trim());
// ParameterList.Add(this.SLP_DATE.Text.Trim());
// ParameterList.Add(this.txtRFNO.Text.Trim());
// ParameterList.Add(this.SLP_Store.Text.Trim());
// ParameterList.Add(strINVOICE_SEND);
// dt = BCO.PrintReport(ParameterList);
// if (dt.Rows.Count == 0)
// {
// ErrorMsgLabel.Text = "查無資料";
// this.CryView.ReportSource = null;
// }
// else
// {
// //#region 設定頁面狀態
// //this.hid_PageStatus.Value = "PRINT";
// //#endregion
// //ShowReport(dt);
// #region 設定頁面狀態
// this.hid_PageStatus.Value = "QUERY";
// #endregion
// ExportReport(dt);
// }
// }
// catch (Exception ex)
// {
// ErrorMsgLabel.Text = ex.Message;
// }
// finally { }
//}
/// <summary>
/// show報表
/// </summary>
//private void ShowReport(DataTable Dt)
//{
// try
// {
// CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
// report.Load(Server.MapPath("./REPORT/CAA211/CAA21R01.rpt"));
// this.CryView.ReportSource = null;
// report.SetDataSource(Dt);
// this.CryView.ReportSource = report;
// //CryView.Visible = true;
// //重Bind Report 用
// Session["Rpt_Data" + PageTimeStamp.Value] = Dt;
// }
// catch (Exception ex)
// {
// ErrorMsgLabel.Text = ex.Message;
// }
// finally { }
//}
/// <summary>
/// 設定報表參數
/// </summary>
/// <param name="paramName"></param>
/// <param name="paramValue"></param>
/// <param name="paramFields"></param>
protected void btnExport_Click(object sender, EventArgs e)
{
string strGROUP_NO = ""; //店群代號
string strGROUP_NAME = ""; //店群名稱
string strCHAN_NO = ""; //通路代號
string strCHAN_NAME = ""; //通路名稱
string strSTORE_ID = ""; //店號
string strSTORE_NAME = ""; //店名
string strPAY_RFNO = ""; //結帳統編
string strROUTE = ""; //路線
string strSTEP = ""; //路順
string strAC_UID = ""; //帳務人員
string strPath = "";
string strContent = "";
CAAModel.InvoiceLetterPrint BCO = new CAAModel.InvoiceLetterPrint(ConntionDB);
DataTable dtResult;
ParameterList.Clear();
string strINVOICE_SEND = SLP_INVOICE_SEND.Text;
ParameterList.Add(this.SLP_YearMonth.Text.Trim());
ParameterList.Add(this.SLP_DATE.Text.Trim());
ParameterList.Add(this.txtRFNO.Text.Trim());
ParameterList.Add(this.SLP_Store.Text.Trim());
ParameterList.Add(strINVOICE_SEND);
dtResult = BCO.ExportLetterText(ParameterList);
ErrorMsgLabel.Text = "";
if (dtResult.Rows.Count == 0)
{
ErrorMsgLabel.Text = "查無資料";
}
else
{
strContent = "\"店群代號\",\"店群名稱\",\"通路代號\",\"通路名稱\",\"店號\",\"店名\",\"結帳統編\",\"路線\",\"路順\",\"帳務人員\"" + "\r\n";
for (int i = 0; i < dtResult.Rows.Count; i++)
{
strGROUP_NO = dtResult.Rows[i]["GROUP_NO"].ToString().Trim(); //店群代號
strGROUP_NAME = dtResult.Rows[i]["GROUP_NAME"].ToString().Trim(); //店群名稱
strCHAN_NO = dtResult.Rows[i]["CHAN_NO"].ToString().Trim(); //通路代號
strCHAN_NAME = dtResult.Rows[i]["CHAN_NAME"].ToString().Trim(); //通路名稱
strSTORE_ID = dtResult.Rows[i]["STORE_ID"].ToString().Trim(); //店號
strSTORE_NAME = dtResult.Rows[i]["STORE_NAME"].ToString().Trim(); //店名
strPAY_RFNO = dtResult.Rows[i]["PAY_RFNO"].ToString().Trim(); //結帳統編
strROUTE = dtResult.Rows[i]["ROUTE"].ToString().Trim(); //路線
strSTEP = dtResult.Rows[i]["STEP"].ToString().Trim(); //路順
strAC_UID = dtResult.Rows[i]["AC_UID"].ToString().Trim(); //帳務人員
strContent += "=\"" + strGROUP_NO + "\",=\"" + strGROUP_NAME + "\",=\"" + strCHAN_NO + "\",=\"" + strCHAN_NAME + "\",=\"" + strSTORE_ID + "\",=\"" + strSTORE_NAME + "\",=\"" + strPAY_RFNO + "\",=\"" + strROUTE + "\",=\"" + strSTEP + "\",=\"" + strAC_UID + "\"" + "\r\n";
}
DownloadStringToFile(this.Page, "EXPORT.CSV", strContent);
}
}