/// <summary> /// CAA281 頁籤=解除鎖定維護 Button [查詢]鈕 /// </summary> /// <param name="ParameterList"></param> /// <returns></returns> public DataTable QUERY_LOCK_DATA(ArrayList ParameterList) { try { CAA_28DBO CAA28 = new CAA_28DBO(ref USEDB); return CAA28.QUERY_LOCK_DATA(ParameterList); } catch (Exception ex) { throw ex; } }
/// <summary> /// CAA281 頁籤=解除鎖定維護 Button [解除]鈕 /// </summary> /// <param name="RootDBT"></param> /// <param name="ParameterList"></param> public void DELETE_LOCK_DATA(DbTransaction RootDBT, ArrayList ParameterList) { bool IsRootTranscation = false; try { //判斷是否有傳入Root Transcation IsRootTranscation = (RootDBT == null) ? true : false; #region 啟動交易或指定RootTranscation if (IsRootTranscation) { //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = RootDBT; } #endregion #region 設定變數 CAA_28DBO CAA28 = new CAA_28DBO(ref USEDB); #endregion #region 更新 VDS_CAA_DISC_MAIN 資料 CAA28.DELETE_LOCK_DATA(DBT, ParameterList); #endregion #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 } }
/// <summary> /// CAA281 頁籤=月結設定查詢 Button [查詢]鈕 /// </summary> /// <param name="ParameterList"> /// @功能號(起),@功能號(迄), /// @月結月份(起),@月結月份(迄), /// @維護日期(起),@維護日期(迄), /// @維護人員 /// </param> /// <returns>月結月份, 功能號, 功能名稱, 維護日期, 維護人員</returns> public DataTable QueryMonClosebyLike(ArrayList ParameterList) { try { CAA_28DBO CAA28 = new CAA_28DBO(ref USEDB); return CAA28.QueryMonClosebyLike(ParameterList); } catch (Exception ex) { throw ex; } }