/// <summary>
/// 傳入參數：
/// 〔@依照頁面輸入的查詢條件〕
/// 傳回訊息：
/// 〔＠回傳以下欄位〕
///
/// 【繳款資訊】
/// 1=電匯(專案代收)、2=支票/本票/匯票、3=應收付調整
/// IF 繳款別=1 THEN
/// 只查詢【電匯】TABLE
/// ELSEIF 繳款別=2 THEN
/// 只查詢【支票】 TABLE
/// ELSEIF 繳款別=3 THEN
/// 只查詢【應收付調整】
/// ELSE
/// 需查詢【電匯】、【支票】、【應收付調整】三個TABLE
/// END IF
///
/// 【電匯】：
/// SELECT COLL_NO, COLL_AMT, CHARGE, DIFF_AMT, OTHER_DIFF, REMIT_DIFF,
/// SUM_COLL_AMT, COLL_REMAIN_AMT, LAST_WASH_DATE,WASH_STATUS,WASH_CLOSE_FLG
/// FROM VDS_CAA_COLL_MAIN
/// WHERE COLL_DATE >=@繳款日(起) AND COLL_DATE<=@繳款日(迄)
/// AND WASH_STATUS = @狀態
/// (1)收款單號 = COLL_NO
/// (2)繳款別 = 1 (電匯)
/// (3)繳款金額 = COLL_AMT
/// (4)手續費 = CHARGE
/// (5)沖尾差 = DIFF_AMT
/// (6)其它差異 = OTHER_AMT
/// (7)匯兌差異 = REMIT_DIFF
/// (8)合計 = COLL_AMT + CHARGE - DIFF_AMT - OTHER_AMT - REMIT_DIFF
/// (9)沖帳餘額 = COLL_REMAIN_AMT
/// (10)最後沖帳日 = LAST_WASH_DATE
/// (11)狀態 = WASH_STATUS
/// (12)立沖月結狀態 = WASH_CLOSE_FLG
///
/// 【支票】：
/// SELECT BOND_NO, BOND_AMT, DIFF_AMT, OTHER_DIFF, REMIT_DIFF , SUM_BOND_AMT,
/// BOND_REMAIN_AMT , LAST_WASH_DATE,WASH_STATUS,WASH_CLOSE_FLG
/// FROM VDS_CAA_BOND_MAIN
/// WHERE DUE_DATE >=@繳款日(起) AND DUE_DATE<=@繳款日(迄)
/// AND WASH_STATUS = @狀態
/// (1)收款單號 = BOND_NO
/// (2)繳款別 = 2 (支票)
/// (3)繳款金額 = BOND_AMT
/// (4)手續費 = 0
/// (5)沖尾差 = DIFF_AMT
/// (6)其它差異 = OTHER_AMT
/// (7)匯兌差異 = REMIT_DIFF
/// (8)合計 = BOND_AMT - DIFF_AMT - OTHER_AMT - REMIT_DIFF
/// (9)沖帳餘額 = BOND_REMAIN_AMT
/// (10)最後沖帳日 = LAST_WASH_DATE
/// (11)狀態 = WASH_STATUS
/// (12)立沖月結狀態 = WASH_CLOSE_FLG
///
/// 【應收付調整】：
/// SELECT DUE_NO, DUE_AMT, DIFF_AMT, OTHER_DIFF, REMIT_DIFF, SUM_DUE_AMT,
/// DUE_REMAIN_AMT, LAST_WASH_DATE,WASH_STATUS,WASH_CLOSE_FLG
/// FROM VDS_CAA_DUE_MAIN
/// WHERE CREATEDATE >=@繳款日(起) AND CREATEDATE<=@繳款日(迄)
/// AND WASH_STATUS = @狀態
/// (1)收款單號 = DUE_NO
/// (2)繳款別 = 3(應收付調整)
/// (3)繳款金額 = DUE_AMT
/// (4)手續費 = 0
/// (5)沖尾差 = DIFF_AMT
/// (6)其它差異 = OTHER_AMT
/// (7)匯兌差異 = REMIT_DIFF
/// (8)合計 = DUE_AMT - DIFF_AMT - OTHER_AMT - REMIT_DIFF
/// (9)沖帳餘額 = DUE_REMAIN_AMT
/// (10)最後沖帳日 = LAST_WASH_DATE
/// (11)狀態 = WASH_STATUS
/// (12)立沖月結狀態 = WASH_CLOSE_FLG
///
/// 【發票/折讓/暫收資訊】
/// 以下語法均需執行
/// 【發票】：
///
/// SELECT IM.INV_NO, AP.PAY_RFNO, IM.VOUCH_RFNO, IM.STORE_ID, SS.STORE_NAME, IM.
/// ROOT_NO, IM.INV_DATE, IM.INV_UAMT, IM.INV_REMAIN_AMT
/// FROM VDS_CAA_INV_MAIN IM, VDS_STM_ACCOUNT_PROPERTY AP, VDS_STM_STORE SS
/// WHERE IM.INV_REMAIN_AMT>0
/// AND IM.CLOSE_MONTH >=@結帳年月(起) AND IM.CLOSE_MONTH <=@結帳年月(迄)
/// AND IM.DUE_DATE>=@應收應付帳款到期日(起) AND IM.DUE_DATE<=@應收應付帳款到期日(迄)
/// AND SS.GROUP_NO=@店群
/// AND AP.PROFIT_NO=@利潤中心
/// AND IM.STORE_ID=@店號
/// AND AP.PAY_RFNO=@結帳統編
/// AND IM.VOUCH_RFNO=@統一編號
/// AND SS.Z_O=@營業所
/// AND SS.SAL_ID=@營業人員
/// AND SS.AC_UID=@帳務人員
/// AND IM.STORE_ID = SS.STORE
/// AND IM.CREATEDATE BETWEEN SS.MDC_START_DATE AND SS.MDC_END_DATE
/// AND IM.STORE_ID = AP.STORE
/// AND IM.CREATEDATE BETWEEN AP.EFF_DATE_FROM AND AP.EFF_DATE_TO
/// AND IM.ENABLE = 1
///
/// (1)發票/折讓/暫收單號 = IM.INV_NO
/// (2)單別 = 1(發票)
/// (3)結帳統編 = AP.PAY_RFNO
/// (4)統一編號 = IM.VOUCH_RFNO
/// (5)店號 = IM.STORE_ID
/// (6)店名 = SS.STORE_NAME
/// (7)群分類 = IM.ROOT_NO
/// (8)發票/折讓日期 = IM.INV_DATE
/// (9)金額 = IM.INV_UAMT
/// (10)餘額 = IM.INV_REMAIN_AMT
/// (11)確認付款日 = IM.INDEED_DATE
/// (12)備註 = IM.MEMO
/// (13)狀態 = IM.WASH_STATUS
///
/// 【折讓】：
/// SELECT DM.DISC_NO, AP.PAY_RFNO, DM.RFNO, DM.STORE_ID, SS.STORE_NAME, DM.
/// ROOT_NO, DM.DISC_DATE, DM.DISC_UAMT, DM.DISC_REMAIN_AMT
/// FROM VDS_CAA_DISC_MAIN DM, VDS_STM_ACCOUNT_PROPERTY AP, VDS_STM_STORE SS
/// WHERE DM.PROOF_FLG= 1
/// AND DM.DISC_REMAIN_AMT>0
/// AND DM.CLOSE_MONTH >=@結帳年月(起) AND DM.CLOSE_MONTH <=@結帳年月(迄)
/// AND SS.GROUP_NO=@店群
/// AND AP.PROFIT_NO=@利潤中心
/// AND DM.STORE_ID=@店號
/// AND AP.PAY_RFNO=@結帳統編
/// AND DM.RFNO=@統一編號
/// AND SS.Z_O=@營業所
/// AND SS.SAL_ID=@營業人員
/// AND SS.AC_UID=@帳務人員
/// (1)發票/折讓/暫收單號 = DM.DISC_NO
/// (2)單別 = 2(折讓)
/// (3)結帳統編 = AP.PAY_RFNO
/// (4)統一編號 = DM.RFNO
/// (5)店號 = DM.STORE_ID
/// (6)店名 = SS.STORE_NAME
/// (7)群分類 = DM.ROOT_NO
/// (8)發票/折讓日期 = DM.DISC_DATE
/// (9)金額 = DM.DISC_UAMT
/// (10)餘額 = DM.DISC_REMAIN_AMT
/// (11)備註 = DM.MEMO
/// (12)狀態 = DM.WASH_STATUS
///
/// 【暫收】：
/// SELECT TM.TEMP_NO, AP.PAY_RFNO, TM.RFNO, SS.STORE_ID, SS.STORE_NAME, TM.
/// ROOT_NO, TM.CREATEDATE, TM.TEMP_UAMT, TM.TEMP_REMAIN_AMT
/// FROM VDS_CAA_TEMP_MAIN TM, VDS_STM_ACCOUNT_PROPERTY AP, VDS_STM_STORE SS
/// WHERE TM.TEMP_REMAIN_AMT>0
/// AND TM.CLOSE_MONTH >=@結帳年月(起) AND TM.CLOSE_MONTH <=@結帳年月(迄)
/// AND SS.GROUP_NO=@店群
/// AND AP.PROFIT_NO=@利潤中心
/// AND TM.STORE_ID=@店號
/// AND AP.PAY_RFNO=@結帳統編
/// AND TM.RFNO=@統一編號
/// AND SS.Z_O=@營業所
/// AND SS.SAL_ID=@營業人員
/// AND SS.AC_UID=@帳務人員
/// (1)發票/折讓/暫收單號 = TM.TEMP_NO
/// (2)單別 = 3(暫收)
/// (3)結帳統編 = AP.PAY_RFNO
/// (4)統一編號 = TM.RFNO
/// (5)店號 = TM.STORE_ID
/// (6)店名 = SS.STORE_NAME
/// (7)群分類 = TM.ROOT_NO
/// (8)發票/折讓日期 = TM.CREATEDATE
/// (9)金額 = TM.TEMP_UAMT
/// (10)餘額 = TM.TEMP_REMAIN_AMT
/// (11)備註 = TM.MEMO
/// (12)狀態 = TM.WASH_STATUS
///
/// 【發票/折讓/暫收資訊】
/// 依畫面【繳款資訊】點選帶出，畫面LOAD進來時以繳款資訊】第一筆帶出相關資料
/// SELECT * FROM VDS_CAA_CONNECT_MAIN WHERE WASH_NO=@【繳款資訊】發票/折讓/暫收單號
/// (1)發票/折讓/暫收單號 = CUBE_NO + CUBE_TYPE (1=>發票、2=>折讓、3=>暫收)
/// (2)沖帳金額=WASH_AMT
/// (3)沖帳日期=WASH_DATE
/// (4)小計 = 加總沖帳金額
/// </summary>
//取得繳款資訊
public DataTable QueryAccount(ArrayList ParameterList)
{
try
{
CAA_AccountRecordDBO DBO = new CAA_AccountRecordDBO(ref USEDB);
DataTable dt = DBO.QueryAccount(ParameterList);
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
