/// <summary>
/// 傳入參數:@畫面上所有欄位資料
///
/// 處理：
/// 1.新增一筆資料至資料庫VDS_CAA_TEMP_MAIN(欄位對應資料請參閱畫面規格)
///
/// (1) 暫收單號 = TEMP_NO
/// (2) 來源 = SOURCE_TYPE
/// (3) 來源單號 = SOURCE_NO
/// (4) 店群 = 不儲存
/// (5) 客戶店號 = STORE_ID
/// (6) 營業所 = 不儲存
/// (7) 統一編號 = 不儲存
/// (8) 營業人員 = 不儲存
/// (9) 帳務人員 = 不儲存
/// (10)商品群分類 = ROOT_NO
/// (11)稅別 = TAX_TYPE
/// (12) 暫收金額 = TEMP_AMT
/// (13) 累計沖帳金額 = SUM_TEMP_AMT
/// (14) 暫收餘額 = TEMP_REMAIN_AMT
/// (15) 備註說明 = MEMO
/// (16) 結帳年月 = CLOSE_MONTH
/// (17) 轉其它收入 = CHG_INCOME_TYPE
/// (18) 轉其它收入日期 = CHG_INCOME_DATE
/// (19) 建立日期 = CREATEDATE (系統抓取目前AP機器之時間)
/// (20) 建立人員 = CREATEUID (系統抓取登入之使用者ID)
///
///
/// 回傳：
/// 新增是否成功
/// </summary>
public int CreateTempRecord(ArrayList ParameterList, DbTransaction RootDBT, out string TEMP_NO, out string ID)
{
int iResult;
bool IsRootTranscation = false;
try
{
CAA_MaintainTempRecordDBO DBO = new CAA_MaintainTempRecordDBO(ref USEDB);
//判斷是否有傳入Root Transcation
IsRootTranscation = (RootDBT == null) ? true : false;
#region 啟動交易或指定RootTranscation
if (IsRootTranscation)
{
//獨立呼叫啟動Transcation
Conn = USEDB.CreateConnection();
Conn.Open();
DBT = Conn.BeginTransaction();
}
else
{
DBT = RootDBT;
}
#endregion
iResult = DBO.CreateTempRecord(ParameterList, RootDBT, out TEMP_NO, out ID);
#region 交易成功
if (IsRootTranscation)
{
//獨立呼叫Transcation成立
DBT.Commit();
}
#endregion
}
catch (Exception ex)
{
#region 交易失敗
if (IsRootTranscation)
{
//獨立呼叫Transcation失敗
DBT.Rollback();
}
#endregion
throw ex;
}
finally
{
#region 判斷是否關閉交易連線
if (IsRootTranscation)
{
//獨立呼叫Transcation,關閉連線
if (Conn.State == ConnectionState.Connecting)
{
Conn.Close();
}
}
#endregion
}
return iResult;
}
/// <summary>
/// 依照畫面輸入的[店號]，取得相關資料
/// </summary>
/// <param name="ParameterList"></param>
/// <returns></returns>
public DataTable GET_STORE_RELATE_DATA(ArrayList ParameterList)
{
try
{
CAA_MaintainTempRecordDBO DBO = new CAA_MaintainTempRecordDBO(ref USEDB);
return DBO.GET_STORE_RELATE_DATA(ParameterList);
}
catch (Exception ex)
{ throw ex; }
}
/// <summary>
//回傳SourceType
/// </summary>
public DataTable GetSourceType()
{
try
{
CAA_MaintainTempRecordDBO DBO = new CAA_MaintainTempRecordDBO(ref USEDB);
DataTable dt = DBO.GetSourceType();
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 取得商品群分類資料
/// </summary>
/// <param name="ParameterList"></param>
/// <returns></returns>
public DataTable GetRootData(ArrayList ParameterList)
{
try
{
CAA_MaintainTempRecordDBO DBO = new CAA_MaintainTempRecordDBO(ref USEDB);
DataTable dt = DBO.GetRootData(ParameterList);
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 傳入參數：
/// 〔@依照頁面輸入的查詢條件〕
/// 傳回訊息：
/// 〔＠回傳以下欄位〕
///
/// Table：
/// VM=VDS_CAA_TEMP_MAIN (暫收款主檔)
/// VU=VDS_STM_STORE(門市主檔)
/// VS=VDS_STM_STOREGROUP(店群)
/// PV=VDS_STM_ACCOUNT_PROPERTY(帳務特性主檔)
///
/// 查詢條件:(若有輸入則組成過濾條件，無輸入則不過濾)
/// (1) 暫收單號 = VM.TEMP_NO
/// (2) 來源 = VM.SOURCE_TYPE
/// (3) 來源單號 = VM.SOURCE_NO
/// (4) 店群 = VU.GROUP_NO
/// (5) 客戶店號 = VM.STORE_ID
/// (6) 營業所 = VU.Z_O
/// (7) 統一編號 = PV.RFNO
/// (8) 營業人員 = VU.SAL_ID
/// (9) 帳務人員 = VU.AC_UID
/// (10) 暫收金額 = VM.TEMP_AMT
/// (11) 累計沖帳金額 = VM.SUM_TEMP_AMT
/// (12) 暫收餘額 = VM.TEMP_REMAIN_AMT
/// (13) 備註說明 = VM.MEMO
/// (14) 結帳年月 = VM.CLOSE_MONTH
/// (15) 轉其他收入 = VM.CHG_INCOME_TYPE
/// IF @轉其他收入="ALL" THEN
/// 不判斷
/// ELSEIF @轉其他收入="是" THEN
/// VM.CHG_INCOME_TYPE = 1
/// ELSE
/// VM.CHG_INCOME_TYPE = 0
/// END IF
/// (16) 轉其他收入日期
/// CHG_INCOME_DATE >=@其他收入日期(起) AND CHG_INCOME_DATE <=@其他收入日期(迄)
/// (17) 建立日期 = VM.CREATEDATE
/// (18) 建立人員 = VM.CREATEUID
/// (19) 維護日期 = VM.UPDATEDATE
/// (20) 維護人員 = VM.UPDATEUID
/// (21) VM.ENABLE = 1
/// (22) VM.STORE_ID = VU.STORE
/// (23) VM.STORE_ID = PV.STORE
/// (24) VU.MDC_STAR_DATE <= VM.CREATEDATE AND VU.MDC_END_DATE >=VM.CREATEDATE
/// (25) PV.EFF_DATE_FROM <= VM.CREATEDATE AND PV.EFF_DATE_TO >=VM.CREATDATE
///
///
/// 欄位：
/// (1) 暫收單號 = VM.TEMP_NO
/// (2) 來源 = ENUMTYPENAME
/// SELECT ENUMTYPENAME FROM SYS_ENUMBASE WHERE MODULE='CAA' AND
/// ENUM='SourceType' AND ENUMVALUE=VM.SOURCE_TYPE
/// (3) 來源單號 = VM.SOURCE_NO
/// (4) 店群 = VU.GROUP_NO + VS.NAME
/// NAME => SELECT NAME FROM VDS_STM_STOREGROUP WHERE CODE = VU.
/// GROUP_NO
/// (5) 店號 = VM.STORE_ID + VU.STORE_NAME
/// (6) 統一編號 = PV.RFNO
/// (7) 商品群分類 = VM.ROOT_NO
/// (8) 稅收 = VM.TAX_TYPE
/// (9) 暫收金額 =VM.TEMP_AMT
/// (10) 累計暫收金額 = VM.SUM_TEMP_AMT
/// (11) 暫收餘額 =VM.TEMP_REMAIN_AMT
/// </summary>
public DataTable QueryTempByFind(ArrayList ParameterList)
{
//Like部分直接在資料庫Procedure和前台做字串處理,所以查詢部分只呼叫QueryTempByFind,不用呼叫QueryTempByLike
try
{
CAA_MaintainTempRecordDBO DBO = new CAA_MaintainTempRecordDBO(ref USEDB);
DataTable dt = DBO.QueryTemp(ParameterList);
return dt;
}
catch (Exception ex)
{
throw ex;
}
}
