/// <summary> /// VAM24轉運廠商品項維護 /// </summary> /// <param name="ParameterList"></param> /// <returns>回傳查詢結果</returns> public DataTable QueryTranShipByFind(ArrayList ParameterList) { try { VAM24_DBO DBO = new VAM24_DBO(ref USEDB); return DBO.QueryTranShipByFind(ParameterList); } catch (Exception ex) { throw ex; } }
public string DeleteTranShipItem(ArrayList ParameterList, DbTransaction RootDBT) { bool IsRootTranscation = false; try { VAM24_DBO DBO = new VAM24_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 string V_MSG, V_RESULT; DBO.DeleteTranShipItem(ParameterList, DBT, out V_MSG, out V_RESULT); if (V_RESULT == "1")//刪除成功 { V_MSG = "刪除成功"; if (IsRootTranscation) { //獨立呼叫Transcation成立 DBT.Commit(); } } else { V_MSG = "刪除失敗"; DBT.Rollback(); } return V_MSG; } catch (Exception ex) { #region 交易失敗 DBT.Rollback(); #endregion throw ex; } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }
public string[] CheckItem(ArrayList ParameterList, DbTransaction RootDBT) { bool IsRootTranscation = false; string[] strReturn = new string[2]; strReturn[0] = ""; strReturn[1] = ""; try { VAM24_DBO DBO = new VAM24_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 strReturn = DBO.CheckItem(ParameterList, DBT); if (IsRootTranscation) { DBT.Commit(); } return strReturn; } catch (Exception ex) { #region 交易失敗 DBT.Rollback(); #endregion throw ex; } finally { #region 判斷是否關閉交易連線 if (IsRootTranscation) { //獨立呼叫Transcation,關閉連線 if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } #endregion } }
public string[] UpdateTranShipItem(DbTransaction transaction, ArrayList parameterList) { bool IsRootTranscation = false; VAM24_DBO dbo = new VAM24_DBO(ref USEDB); IsRootTranscation = (transaction == null) ? true : false; if (IsRootTranscation) { Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); } else { DBT = transaction; } try { string[] strReturn = dbo.UpdateTranShipItem(transaction, parameterList); if (IsRootTranscation) { DBT.Commit(); } return strReturn; } catch { if (IsRootTranscation) { DBT.Rollback(); } throw; } finally { if (IsRootTranscation) { if (Conn.State == ConnectionState.Connecting) { Conn.Close(); } } } }
public string UpdateTranShip(ArrayList masterParameter, ArrayList parameterList) { Conn = USEDB.CreateConnection(); Conn.Open(); DbTransaction transaction = Conn.BeginTransaction(); VAM24_DBO dbo = new VAM24_DBO(ref USEDB); string strReturn = ""; try { dbo.UpdateTranShipMain(transaction, masterParameter); ArrayList alTemp = new ArrayList(); alTemp.Clear(); alTemp.Add(masterParameter[0]); alTemp.Add(masterParameter[3]); dbo.DeleteTranShipItemByVendor(transaction,alTemp); if (parameterList.Count > 0) { for (int i = 0; i < parameterList.Count; i++) { ((ArrayList)parameterList[i]).Insert(0, masterParameter[0]); UpdateTranShipItem(transaction, (ArrayList)parameterList[i]); strReturn = UpdateTranShipItem(transaction, (ArrayList)parameterList[i])[1]; if (strReturn != "") { return strReturn; } } } transaction.Commit(); return strReturn; } catch { transaction.Rollback(); throw; } finally { Conn.Close(); } }
public string[] CreateTranShip(ArrayList masterParameter, ArrayList parameterList) { Conn = USEDB.CreateConnection(); Conn.Open(); DbTransaction transaction = Conn.BeginTransaction(); VAM24_DBO dbo = new VAM24_DBO(ref USEDB); try { string[] strReturn = dbo.CreateTranShipMain(transaction, masterParameter); if (strReturn[2] != "") { transaction.Rollback(); return strReturn; } if (parameterList.Count > 0) { string[] strReturn2 = new string[2]; for (int i = 0; i < parameterList.Count; i++) { ((ArrayList)parameterList[i]).Insert(0, strReturn[1]); strReturn2 = UpdateTranShipItem(transaction, (ArrayList)parameterList[i]); if (strReturn2[0] == "0") { strReturn[2] = strReturn2[1]; return strReturn; } } } transaction.Commit(); return strReturn; } catch { transaction.Rollback(); throw; } finally { Conn.Close(); } }
public DataTable GetTranShipMain(ArrayList ParameterList) { try { VAM24_DBO DBO = new VAM24_DBO(ref USEDB); return DBO.GetTranShipMain(ParameterList); } catch (Exception ex) { throw ex; } }