/// <summary> /// 基本表單更新BCO /// </summary> /// <param name="DetailData">更新變數</param> /// <param name="RootDBT">是否有主交易,無主交易輸入null</param> /// <returns>回傳成功與否</returns> public bool UpdateDetail(DataTable dtForDetailAddedOrModified, string strUIDForLog, DataTable dtForDetailDeleted, DbTransaction RootDBT) { bool IsRootTranscation = false; bool bResult = false; try { VDS_ALO_PATTERNSPEC_DETL_DBO ALOD = new VDS_ALO_PATTERNSPEC_DETL_DBO(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 Hashtable htParams = new Hashtable(); if (dtForDetailDeleted != null) { #region for (Int32 i = 0; i <= dtForDetailDeleted.Rows.Count - 1; i++) { if (dtForDetailDeleted.Rows[i].RowState != DataRowState.Deleted) { #region htParams.Clear(); htParams.Add("ID", dtForDetailDeleted.Rows[i]["ID"]); htParams.Add("PID", dtForDetailDeleted.Rows[i]["PID"]); htParams.Add("CREATEDATE", dtForDetailDeleted.Rows[i]["CREATEDATE"]); htParams.Add("CREATEUID", dtForDetailDeleted.Rows[i]["CREATEUID"]); htParams.Add("UPDATEDATE", dtForDetailDeleted.Rows[i]["UPDATEDATE"]); htParams.Add("UPDATEUID", dtForDetailDeleted.Rows[i]["UPDATEUID"]); htParams.Add("START_RANKQTY", dtForDetailDeleted.Rows[i]["START_RANKQTY"]); htParams.Add("END_RANKQTY", dtForDetailDeleted.Rows[i]["END_RANKQTY"]); htParams.Add("ADJ_QTY", dtForDetailDeleted.Rows[i]["ADJ_QTY"]); htParams.Add("UIDForLog", strUIDForLog); ALOD.doDelete(htParams, DBT); #endregion } } #endregion } if (dtForDetailAddedOrModified != null) { #region for (Int32 i = 0; i <= dtForDetailAddedOrModified.Rows.Count - 1; i++) { if ((dtForDetailAddedOrModified.Rows[i].RowState == DataRowState.Added) || (dtForDetailAddedOrModified.Rows[i].RowState == DataRowState.Modified)) { #region htParams.Clear(); htParams.Add("ID", dtForDetailAddedOrModified.Rows[i]["ID"]); htParams.Add("PID",dtForDetailAddedOrModified.Rows[i]["PID"]); htParams.Add("CREATEDATE",dtForDetailAddedOrModified.Rows[i]["CREATEDATE"]); htParams.Add("CREATEUID",dtForDetailAddedOrModified.Rows[i]["CREATEUID"]); htParams.Add("UPDATEDATE",dtForDetailAddedOrModified.Rows[i]["UPDATEDATE"]); htParams.Add("UPDATEUID",dtForDetailAddedOrModified.Rows[i]["UPDATEUID"]); htParams.Add("START_RANKQTY", dtForDetailAddedOrModified.Rows[i]["START_RANKQTY"]); htParams.Add("END_RANKQTY", dtForDetailAddedOrModified.Rows[i]["END_RANKQTY"]); htParams.Add("ADJ_QTY", dtForDetailAddedOrModified.Rows[i]["ADJ_QTY"]); ALOD.doCreate(htParams, DBT); #endregion } } #endregion } #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion bResult = true; return bResult; } catch (Exception ex) { #region 交易失敗 if (IsRootTranscation) { //獨立呼叫Transcation失敗 DBT.Rollback(); } #endregion throw GetNewException(ex); } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }
/// <summary> /// 基本表單新增BCO /// </summary> /// <param name="DetailData">輸入變數</param> /// <param name="RootDBT">是否有主交易,無主交易輸入null</param> /// <returns>回傳異動筆數</returns> public void CreateDetail(Int32 PID, DataTable DetailData, DbTransaction RootDBT) { bool IsRootTranscation = false; try { VDS_ALO_PATTERNSPEC_DETL_DBO ALOD = new VDS_ALO_PATTERNSPEC_DETL_DBO(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 Hashtable htParams = new Hashtable(); for (Int32 i = 0; i <= DetailData.Rows.Count - 1; i++) { if (DetailData.Rows[i].RowState != DataRowState.Deleted) { htParams.Clear(); htParams.Add("PID", PID); htParams.Add("ID", DetailData.Rows[i]["ID"]); htParams.Add("CREATEDATE", DetailData.Rows[i]["CREATEDATE"]); htParams.Add("CREATEUID", DetailData.Rows[i]["CREATEUID"]); htParams.Add("UPDATEDATE", DetailData.Rows[i]["UPDATEDATE"]); htParams.Add("UPDATEUID", DetailData.Rows[i]["UPDATEUID"]); htParams.Add("START_RANKQTY", DetailData.Rows[i]["START_RANKQTY"]); htParams.Add("END_RANKQTY", DetailData.Rows[i]["END_RANKQTY"]); htParams.Add("ADJ_QTY", DetailData.Rows[i]["ADJ_QTY"]); ALOD.doCreate(htParams, DBT); } } #region 交易成功 if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } #endregion } catch (Exception ex) { #region 交易失敗 if (IsRootTranscation) { //獨立呼叫Transcation失敗 DBT.Rollback(); } #endregion throw GetNewException(ex); } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }