/// <summary> /// 傳入參數:@發票日(起),@發票日(迄),@來源別(起),@來源別(迄),@稅別 /// 回傳:批次電子發票明細資料 /// /// TABLE: /// IM = VDS_CAA_INV_MAIN(銷項發票檔) /// AV = VDS_CAM_ACCOUNTPROPERTY_VIEW(帳務特性主檔) /// 語法: /// 查詢資料庫VDS_CAA_INV_MAIN欄位 /// (1) 來源別SOURCE_TYPE=>1:營業系統開立、2:財會系統開立) /// (2) 發票日(INV_DATE) /// (3) 發票號碼(INV_NO) /// (4) 檢查碼(INV_CHKNO) /// (5) 課稅別(TAX_TYPE=>0應稅、1免稅、2零稅) /// (6) 統一編號(VOUCH_RFNO) /// (7) 買受人名稱 /// 查詢資料庫(VDS_CAM_ACCOUNTPROPERTY_VIEW之欄位TITLE,依AV.STORE=IM.STORE_ID AND AV. /// ENADBLE=1) /// (8) 收入性質(ITEM_NAME) /// (9) 銷售額(INV_UAMT) /// (10)稅額(INV_TAX) /// (11)合計(INV_AMT) /// (12)備註(CANCEL_FLG=Y=>此欄位呈現"作廢"字樣) /// 條件: /// (1) 發票日(INV_DATE) 介於傳送值@發票日(起),@發票日(迄)區間內 /// (2) 來源別(FORM_NO) 介於傳送值@來源別(起),@來源別(迄)區間內 /// (3) 稅別(TAX_TYPE) = @稅別 /// (3.1) 若稅別選項值='ALL',則稅別選項不列為條件值 /// (4) ENABLE = 1 /// 排序: /// 依發票號碼排序(ORDER BY INV_NO) /// </summary> public DataTable GetInvoiceBatch(ArrayList ParameterList) { try { CAA_InvoiceDetailDBO DBO = new CAA_InvoiceDetailDBO(ref USEDB); DataTable dt = DBO.doQuery(ParameterList); return dt; } catch (Exception ex) { throw ex; } }
/// <summary> /// 所有稅別資料查詢 /// </summary> public DataTable GetTaxType() { try { CAA_InvoiceDetailDBO DBO = new CAA_InvoiceDetailDBO(ref USEDB); DataTable dt = DBO.GetTaxType(); return dt; } catch (Exception ex) { throw ex; } }