/// <summary>
/// 功能說明：查詢供應商對帳單彙總表-單據
///
/// 傳入值：
/// 〔＠處理年月日起、迄〕//必填查詢條件
/// 〔＠供應商代號起、迄〕
/// 〔＠品號起、迄〕
/// 〔＠期別起、迄〕
/// 〔＠課稅別〕
/// 〔＠付款方式〕
/// 回傳值：
/// 請參考WEB UI SPEC說明
///
/// TABLE:
/// //廠商驗收
/// A=VDS_VGI_ACCEPT_MAIN(驗收主檔名稱)
/// B=VDS_VGI_ACCEPT_DETL(驗收商品檔)
/// //廠商退貨
/// C=VDS_VGR_RETURN_MAIN(退貨單主檔)
/// D=VDS_VGR_RETURN_ITEM(供應商退貨單明細檔)
/// //商品主檔
/// E=VDS_ITM_PERIOD_MAIN(期別主檔)
/// F=VDS_ITM_ITEM(商品主檔)
/// //供應商主檔
/// G= VDS_VDM_VENDOR
///
/// 關聯：
/// //驗收單
/// A.ACCEPT_NO=B.ACCEPT_NO
/// A.ACCEPT_DATE BETWEEN 〔＠處理年月日起、迄〕
/// UNION ALL
/// //退貨單
/// C.RETURN_NO=D.RETURN_NO
/// C.RETURN_DATE BETWEEN 〔＠處理年月日起、迄〕
///
/// //查詢條件
/// A.VENDOR=C.VENDOR=G.VENDOR BETWEEN 〔＠供應商代號起、迄〕
/// A.ITEM = C.ITEM = F.ITEM =E.ITEM BETWEEN 〔＠品號起、迄〕
/// A.PERIOD=C.PERIOD=E.PERIOD BETWEEN 〔＠期別起、迄〕
/// E.TAX_TYPE =〔＠課稅別〕
/// G.PAY_TYPE=〔＠付款方式〕 //例舉值（VendorPayType:0月結1期別結）
///
/// 說明：
/// 1.//驗收單
/// SUM(NVL(B.ACCEPT_QTY,0)) //進貨數量
/// SUM(NVL(B.ACCEPT_QTY,0) * NVL(B.COST,0)) //進貨金額
/// GROUP BY A.VENDOR,A.ACCEPT_DATE,A.ACCEPT_NO,E.TAX_TYPE
/// 2.//退貨單
/// SUM(NVL(F.RETURN_QTY,0)) //退貨數量
/// SUM(NVL(F.RETURN_QTY,0)*NVL(F.COST,0)) //退貨金額
/// GROUP BY C.VENDOR,C.RETURN_DATE,C.RETURN_NO, ,E.TAX_TYPE
///
/// 3.計算稅額
/// TAX_TYPE＝0表示應稅
/// 進貨稅額＝進貨金額＊稅率％
/// 退貨稅額＝退貨金額＊稅率％
/// TAX_TYPE=1OR2
/// 進貨稅額＝0
/// 退貨稅額＝0
/// </summary>
public DataTable QueryVendorTransCheckSheet(ArrayList ParameterList)
{
try
{
VAM091_DBO dbo = new VAM091_DBO(ref USEDB);
return dbo.doQueryVAM091A(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable QueryVdsVamSalesClear(ArrayList ParameterList)
{
try
{
VAM091_DBO dbo = new VAM091_DBO(ref USEDB);
return dbo.doQueryVAM091H(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable QueryVAM094SetIsMark(ArrayList ParameterList)
{
try
{
VAM091_DBO dbo = new VAM091_DBO(ref USEDB);
return dbo.doQueryVAM091F(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}