public DataTable QueryExportedStore_PAYITEM(ArrayList ParameterList)
{
try
{
CAM20DBO CAM20 = new CAM20DBO(ref USEDB);
return CAM20.doQueryExportedStore_PAYITEM(ParameterList);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
/// 【說明】：匯入金石堂DDD_暫存
///
/// 【傳入值】：
/// @處理日期
///
/// 【傳回值】：
/// @載入成功筆數，@載入失敗筆數
/// @處理回傳代號，@處理回傳訊息
///
/// 【處理內容】：
/// 1.呼叫VDS_CAM20.IMPORT_CA_DAILY_TRANDATA(OUT 成功筆數,OUT 失敗筆數,使用者代號,店群統稱代號,處理日期)
/// 內容為將 VDS_CAM_PAY_LOG 轉至 VDS_CAM_STORE_PAY_DETL ，
/// 及檢查資料
/// 當有異常資料時，會將資料轉至 VDS_CAM_STORE_PAY_DETL_ERR
///
/// 【使用TABLE】：
/// 門市端之資料(PAY＆Daily)載入暫存檔 VDS_CAM_PAY_LOG
/// 通路PAY資料明細檔(暫存檔) VDS_CAM_STORE_PAY_DETL
/// 通路PAY資料明細檔(暫存檔)_轉入異常 VDS_CAM_STORE_PAY_DETL_ERR
/// </summary>
public string[] ImportDDD_CA_load(ArrayList ParameterList)
{
try
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
return dbo.ImportDDD_CA_load(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public string[] CheckTmp_PAYITEM(ArrayList ParameterList)
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
return dbo.doCheckTmp_PAYITEM(ParameterList);
}
public string TmpToDB_PAYITEM(DbTransaction transaction, ArrayList ParameterList)
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
return dbo.doTmpToDB_PAYITEM(transaction, ParameterList);
}
public void LoadDataToTemp(DbTransaction transaction, ArrayList ParameterList)
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
dbo.LoadDataToTempTable_PAYITEM(transaction, ParameterList);
}
public void ClearTempTables_PAYITEM(string strUID)
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
dbo.ClearTempTables_PAYITEM(strUID);
}
public void LoadDataToTempTable_CB(DbTransaction transaction, DataRow data, string strUID)
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
dbo.LoadDataToTempTable_CB(transaction, data, strUID);
}
public void LOAD_TEMPFILE(DbTransaction transaction, ArrayList ParameterList)
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
dbo.LOAD_TEMPFILE(transaction, ParameterList);
}
public void PERFORM_CLEAR(ArrayList ParameterList)
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
dbo.PERFORM_CLEAR(ParameterList);
}
/// <summary>
/// 【說明】：查詢異常記錄
///
/// 【傳入值】：無
///
/// 【傳回值】：
/// @異常結果資訊
///
/// 【處理內容】：
/// 1.對資料庫查詢，回傳查詢結果
/// SELECT 'Daily_Load' ERR_SOURCE_DESC, ERR_DATE, ERR_LINE, ERR_REASON
/// FROM VDS_CAM_STORE_PAY_DETL_ERR
/// UNION
/// SELECT 'Daily_Submit' ERR_SOURCE_DESC, ERR_DATE, ERR_LINE, ERR_REASON
/// FROM VDS_CAM_STORE_PAY_ERR
/// UNION
/// SELECT 'PAY_Load' ERR_SOURCE_DESC, ERR_DATE, ERR_LINE, ERR_REASON
/// FROM VDS_CAM_STORE_PAY_SUM_ERR
/// UNION
/// SELECT 'PAY_Submit' ERR_SOURCE_DESC, ERR_DATE, ERR_LINE, ERR_REASON
/// FROM VDS_CAM_STORE_PAYSUM_ERR;
///
/// 【使用TABLE】：
/// VDS_CAM_STORE_PAY_DETL_ERR
/// VDS_CAM_STORE_PAY_ERR
/// VDS_CAM_STORE_PAY_SUM_ERR
/// VDS_CAM_STORE_PAYSUM_ERR
/// </summary>
public DataTable QueryImportErrorInfo(ArrayList ParameterList)
{
try
{
CAM20DBO CAM20 = new CAM20DBO(ref USEDB);
return CAM20.GetQueryImportErrorInfo(ParameterList);
}
catch (Exception ex)
{ throw ex; }
}
public string[] LP_BACK_STORE_PAY(ArrayList ParameterList)
{
try
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
return dbo.LP_BACK_STORE_PAY(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public string[] PAY_SUM(ArrayList ParameterList)
{
try
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
return dbo.PAY_SUM(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}
public string[] ImportPAY_CB_submit(ArrayList ParameterList)
{
try
{
CAM20DBO dbo = new CAM20DBO(ref USEDB);
return dbo.ImportPAY_CB_submit(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
}