/// <summary>
/// CAA02報表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable CAA06_1(ArrayList ParameterList)
{
#region 宣告變數
BCO.CAACommon CAAComm = new BCO.CAACommon();
ArrayList arl_ReportService = new ArrayList();
DataTable dt_Return = new DataTable();
#endregion
#region 傳入參數
arl_ReportService.Clear();
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//[報表](0)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "date", false));//[兌換日期]起(1)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "date", false));//[兌換日期]迄(2)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "date", false));//[到期日]起(3)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "date", false));//[到期日]迄(4)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "string", false));//[結帳統編](5)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//[統一編號](6)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "string", false));//[營業所]起(3)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "string", false));//[營業所]迄(8)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//[帳務人員](9)
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[10].ToString(), "string", false));//[登入人員](10)
#endregion
#region 連結資料庫
BCO.MaintainBondMain bco = new BCO.MaintainBondMain(ConntionDB);
dt_Return = bco.DUEYETORNOTYET(arl_ReportService);
#endregion
#region 檢查回傳資料
if (dt_Return.Rows.Count == 0)
{ throw new Exception("查無資料"); }
else
{ return dt_Return; }
#endregion
}
/// <summary>
/// CAA02報表
/// </summary>
/// <param name="ParameterList">變數清單</param>
/// <returns>回傳查詢結果</returns>
public DataTable CAA20_1(ArrayList ParameterList)
{
#region 宣告變數
BCO.CAACommon CAAComm = new BCO.CAACommon();
ArrayList arl_ReportService = new ArrayList();
DataTable dt_Return = new DataTable();
#endregion
#region 傳入參數
arl_ReportService.Clear();
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[0].ToString(), "string", false));//[收票日]起
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[1].ToString(), "string", false));//[收票日]迄
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[2].ToString(), "string", false));//[託收日]起
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[3].ToString(), "string", false));//[託收日]迄
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[4].ToString(), "date", false));//[收款單號日期]起
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[5].ToString(), "date", false));//[收款單號日期]迄
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[6].ToString(), "string", false));//[營業所]起
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[7].ToString(), "string", false));//[營業所]迄
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[8].ToString(), "string", false));//[營業人員]
arl_ReportService.Add(CAAComm.GetValueSetParameter(ParameterList[9].ToString(), "string", false));//[帳務人員]
#endregion
#region 連結資料庫
BCO.MaintainBondMain bco = new BCO.MaintainBondMain(ConntionDB);
dt_Return = bco.BondReport(arl_ReportService);
#endregion
#region 檢查回傳資料
if (dt_Return.Rows.Count == 0)
{ throw new Exception("查無資料"); }
else
{ return dt_Return; }
#endregion
}
