Пример #1
0
        /// <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;
            }
        }
Пример #2
0
        public DataTable QueryVdsVamSalesClear(ArrayList ParameterList)
        {
            try
            {
                VAM091_DBO dbo = new VAM091_DBO(ref USEDB);
                return dbo.doQueryVAM091H(ParameterList);

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #3
0
        public DataTable QueryVAM094SetIsMark(ArrayList ParameterList)
        {
            try
            {
                VAM091_DBO dbo = new VAM091_DBO(ref USEDB);
                return dbo.doQueryVAM091F(ParameterList);

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