/// <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); }
}