/// <summary>
///功能說明：查詢進項憑證折讓
///傳入值：
///〔＠折讓日期起、迄〕
///〔＠供應商代號起、迄〕
///〔＠課稅別〕
///〔＠入帳/折讓日期起、迄〕
///回傳值：
///請參考WEB UI SPEC說明
///TABLE：
///A=VDS_VAM_DISCOUNT_MAIN(進項折讓主檔)
///B=VDS_VAM_DISCOUNT_DETL(進項折讓明細檔)
///C= VDS_VAM_DIFF_INVOICE(物料差主檔)
///D=VDS_VAM_DISCOUNT_INV(進項折讓發票檔)
/////供應商主檔
///G= VDS_VDM_VENDOR
///關聯：
///A.DISC_NO = B.DISC_NO=D.DISC_NO
///A.VENDOR=C=VENDOR=G.VENDOR
///查詢原始單據金額金額
///IF D.SOURCE_TYPE=1 THEN
/////廠商驗收 for 查出原進貨單金額
///B.SOURCE_NO=D.ACCEPT_NO
///查詢欄位：NVL(TAX_REMAIN_AMT, UTAX_REMAIN_AMT)
///ELSE IF B.SOURCE_TYPE=2
/////廠商退貨 for 查出原退貨單金額
///B.SOURCE_NO=E.RETURN_NO
///查詢欄位：NVL(TAX_REMAIN_AMT, UTAX_REMAIN_AMT)
///ELSE B.SOURCE_TYPE=3
/////物料差單據金額
///B.SOURCE_NO=C.DIFF_INV_NO
///查詢欄位：C.DIFF_INV_UAMT
///END IF
/////查詢條件
///AND A.KEYIN_DATE BETWEEN NVL(〔＠入帳日期起日〕
///,TO_DATE('19000101','YYYYMMDD')) AND NVL(〔＠入帳日期迄日〕
///,TO_DATE('29991231','YYYYMMDD'))
///AND A.DISC_DATE BETWEEN NVL(〔＠折讓日期起日〕,TO_DATE('19000101','YYYYMMDD'))
///AND NVL(〔＠折讓日期迄日〕,TO_DATE('29991231','YYYYMMDD'))
///AND A.TAX_TYPE = NVL(〔＠課稅別〕,A.TAX_TYPE)
///AND A.VENDOR BETWEEN NVL(〔＠供應商代號起,' ')
///AND NVL(〔＠供應商代號迄〕,'zzzzzzzzzz')
///GROUP BY A.VENDOR,G.VENDOR_NAME,A.KEYIN_DATE,
///A.DISC_DATE,A.DISC_NO,NVL(A.DISC_UAMT,0) ,
///NVL(A.DISC_TAX,0) ,D.INV_NO
///ORDER BY A.VENDOR,A.KEYIN_DATE,A.DISC_DATE,A.DISC_NO;
///說明：
///1.ENABLE 欄為=1才可以被撈出，依照查詢條件回傳資料清單
///2.建議可以寫一隻DB function查詢進/退貨單原始單據金額。
/// </summary>
public DataTable QueryDiscountInvoice(ArrayList ParameterList)
{
try
{
DBO.VAM121_DBO dbo = new VAM121_DBO(ref USEDB);
return dbo.doQueryDiscountInvoice(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
