Example #1
0
        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;
        }
Example #2
0
 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;
     }
 }