public int UpdateSTChanNo(ArrayList ParameterList) { int iResult = 0; try { int N_CNT=0; //獨立呼叫啟動Transcation Conn = USEDB.CreateConnection(); Conn.Open(); DBT = Conn.BeginTransaction(); ALO24_DBO ALOM = new ALO24_DBO(ref USEDB); ALOM.doUpdateSTChanNo(ParameterList, DBT, out N_CNT); DBT.Commit(); iResult = N_CNT; } catch (Exception ex) { if (DBT != null) DBT.Rollback(); throw ex; } finally { if (Conn.State == ConnectionState.Connecting) Conn.Close(); } return iResult; }
public DataTable QueryByFind(ArrayList ParameterList) { try { ALO24_DBO ALOM = new ALO24_DBO(ref USEDB); DataTable dt = ALOM.doQueryByFind(ParameterList); return dt; } catch (Exception ex) { throw ex; } }