public DataTable ExportDiscountInvoiceFormat(ArrayList ParameterList)
 {
     try
     {
         DBO.VAM121_DBO dbo = new VAM121_DBO(ref USEDB);
         return dbo.ExportDiscountInvoiceFormat(ParameterList);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
		/// <summary>
        //        功能說明:查詢進項憑證發票

        //傳入值:
        //〔@發票日期起、迄〕
        //〔@供應商代號起、迄〕
        //〔@課稅別〕
        //〔@入帳/折讓日期起、迄〕

        //回傳值:
        //請參考WEB UI SPEC說明

        //TABLE:
        //A=VDS_VAM _INVOICE_MAIN(進項發票主檔)
        //B=VDS_VAM_INVOICE_DETL(進項發票明細檔)
        //C= VDS_VAM_DIFF_INVOICE(物料差主檔)
        ////廠商驗收
        //D=VDS_VGI_ACCEPT_MAIN(驗收主檔名稱)
        ////廠商退貨
        //E=VDS_VGR_RETURN_MAIN(退貨單主檔)

        ////供應商主檔
        //G= VDS_VDM_VENDOR

        //關聯:
        //A.INV_NO=B.INV_NO=C.INV_NO
        //A.VENDOR=C.VENDOR=G.VENDOR
        //IF B.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)
        //END IF 
        ////查詢條件
        //AND  a.keyin_date BETWEEN NVL(〔@入帳日期起日〕
        //,TO_DATE('19000101','yyyymmdd')) AND NVL(〔@入帳日期迄日〕,TO_DATE('29991230','yyyymmdd'))
        //AND  a.inv_date BETWEEN NVL(〔@發票/折讓日期起日〕
        //,TO_DATE('19000101','yyyymmdd')) AND NVL(〔@發票/折讓日期迄日〕
        //,TO_DATE('29991230','yyyymmdd'))
        //AND  a.tax_type = NVL(〔@課稅別〕,a.tax_type)
        //AND  a.vendor BETWEEN NVL(〔@供應商代號起〕
        //,' ') AND NVL(〔@供應商代號迄〕,'zzzzzzzzzz') 
        //ORDER  BY a.vendor,a.keyin_date,a.inv_date,a.inv_no,b.source_no;

        //說明:
        //1.ENABLE 欄為=1才可以被撈出,依照查詢條件回傳資料清單
        //2.建議可以寫一隻DB function查詢進/退貨單原始單據金額。
		/// </summary>
        public DataTable QueryPurchaseInvoice(ArrayList ParameterList)
        {
            try
            {

                DBO.VAM121_DBO dbo = new VAM121_DBO(ref USEDB);
                return dbo.doQueryPurchaseInvoice(ParameterList);

            }
            catch (Exception ex)
            {
                throw ex;
            }
		}