/// <summary>
        /// 根據傳入參數,取得該品項的商品期別資訊

        /// </summary>
        /// <param name="ParameterList">@一段碼,@二段碼</param>
        /// <returns>回傳查詢結果(@品號,期別,@退書截止日)</returns>
        public DataTable QueryItemPeriodInfoByBarcode2(ArrayList ParameterList)
        {
            try
            {
                DBO.VDS_CRM_COMMON_DBO VCCD = new VDS_CRM_COMMON_DBO(ref USEDB);
                return VCCD.QUERYITEM_PERIOD_BYBARCODE_2(ParameterList);
            }
            catch (Exception ex)
            { throw GetNewException(ex); }
        }
 /// <summary>
 /// 根據傳入參數,取得該品項的最大已發行期別
 /// </summary>
 /// <param name="ParameterList">@品號</param>
 /// <returns>回傳查詢結果()</returns>
 public DataTable GetMaxDeiveryPeriod2(ArrayList ParameterList)
 {
     try
     {
         DBO.VDS_CRM_COMMON_DBO VCCD = new VDS_CRM_COMMON_DBO(ref USEDB);
         return VCCD.GET_MAX_DEIVERY_PERIOD_2(ParameterList);
     }
     catch (Exception ex)
     { throw GetNewException(ex); }
 }
        /// <summary>
        /// 根據傳入參數,取得該品項的商品期別資訊

        /// </summary>
        /// <param name="ParameterList">@通路,@品號,@期別</param>
        /// <returns>回傳查詢結果(@一段碼,@二段碼,@退書截止日)</returns>
        public DataTable QueryItemPeriodInfo(ArrayList ParameterList)
        {
            try
            {
                DBO.VDS_CRM_COMMON_DBO VCCD = new VDS_CRM_COMMON_DBO(ref USEDB);
                return VCCD.QUERY_ITEMPERIOD_INFO(ParameterList);
            }
            catch (Exception ex)
            { throw GetNewException(ex); }
        }
 /// <summary>
 /// 檢查PO單號是否重複
 /// </summary>
 /// <param name="ParameterList"></param>
 /// <param name="strErrMsg"></param>
 /// <returns></returns>
 public bool CheckCanDeliver_Web(ArrayList ParameterList)
 {
     #region
     try
     {
         VDS_CRM_COMMON_DBO DBO = new VDS_CRM_COMMON_DBO(ref USEDB);
         return DBO.doCheckCanDeliver_Web(ParameterList);
     }
     catch (Exception ex)
     {
         throw GetNewException(ex);
     }
     #endregion
 }
 /// <summary>
 /// QUERY_ITEM_AND_STOCK
 /// </summary>
 /// <param name="ParameterList">0.品名(關鍵字查詢) 1.品號 2.使用者</param>
 /// <returns>資料表DATATABLE</returns>
 public DataTable QueryItemAndStock(ArrayList ParameterList)
 {
     #region
     try
     {
         VDS_CRM_COMMON_DBO DBO = new VDS_CRM_COMMON_DBO(ref USEDB);
         return DBO.QUERY_ITEM_AND_STOCK(ParameterList);
     }
     catch (Exception ex)
     {
         throw GetNewException(ex);
     }
     #endregion
 }
 public DataTable QUERY_ITEM_PERIODSTOCK(ArrayList ParameterList)
 {
     try
     {
         DBO.VDS_CRM_COMMON_DBO VCCD = new VDS_CRM_COMMON_DBO(ref USEDB);
         return VCCD.QUERY_ITEM_PERIODSTOCK(ParameterList);
     }
     catch (Exception ex)
     { throw GetNewException(ex); }
 }
 /// <summary>
 /// 根據條件,查詢訂單擷轉暫存檔中錯誤資料。
 /// </summary>
 /// <param name="ParameterList">
 /// @訂單擷轉日、@門市進貨日、@群分類、@逾期客訂、@擷轉序號起、@擷轉序號迄
 /// </param>
 /// <returns>
 /// @查詢結果集
 /// </returns>
 public DataTable QueryDisNo(ArrayList ParameterList)
 {
     try
     {
         DBO.VDS_CRM_COMMON_DBO VCCD = new VDS_CRM_COMMON_DBO(ref USEDB);
         return VCCD.doQueryDisNo(ParameterList);
     }
     catch (Exception ex)
     { throw GetNewException(ex); }
 }
 /// <summary>
 /// 根據條件,查詢訂單擷轉暫存檔中錯誤資料。
 /// </summary>
 /// <param name="ParameterList">
 /// @訂單擷轉日、@門市進貨日、@群分類、@逾期客訂、@擷轉序號起、@擷轉序號迄
 /// </param>
 /// <returns>
 /// @查詢結果集
 /// </returns>
 public DataTable QueryTransErrorData(ArrayList ParameterList)
 {
     try
     {
         DBO.VDS_CRM_COMMON_DBO VCCD = new VDS_CRM_COMMON_DBO(ref USEDB);
         return VCCD.QUERY_TRANSERRORDATA(ParameterList);
     }
     catch (Exception ex)
     { throw GetNewException(ex); }
 }
        /// <summary>
        /// 根據傳入參數,取得該品項庫存儲區、退貨儲區的庫存資訊。

        /// </summary>
        /// <param name="ParameterList">@群分類,@品號 ,@期別</param>
        /// <returns>回傳查詢結果[@查詢結果資料集(儲區類別, 儲區, 品號, 期別, 現有庫存量, 配本保留數)]</returns>
        public DataTable QueryCRMItemPeriodStock(ArrayList ParameterList)
        {
            try
            {
                DBO.VDS_CRM_COMMON_DBO VCCD = new VDS_CRM_COMMON_DBO(ref USEDB);
                return VCCD.QueryCRMItemPeriodStock(ParameterList);
            }
            catch (Exception ex)
            { throw GetNewException(ex); }
        }
 /// <summary>
 /// 根據傳入參數,取得該品項的大分類和群分類
 /// </summary>
 /// <param name="ParameterList">@品號</param>
 /// <returns>回傳查詢結果(@大分類,@群分類)</returns>
 public DataTable QueryItemByFind(ArrayList ParameterList)
 {
     try
     {
         DBO.VDS_CRM_COMMON_DBO VCCD = new VDS_CRM_COMMON_DBO(ref USEDB);
         return VCCD.QUERY_ITEM_BYFIND(ParameterList);
     }
     catch (Exception ex)
     { throw GetNewException(ex); }
 }