Exemple #1
0
        public bool UploadData(DateTime dateFrom)
        {
            bool ret = true;
            OracleDBObj obj = new OracleDBObj();
            obj.CreateSeverConnection();
            obj.CreateTransaction();
            try
            {
                OracleDB.ExecNonQueryCmd("CALL SP_IMPORT_EXPORT(" + OracleDB.QRDate(dateFrom) + ")", obj.zTrans);

                obj.zTrans.Commit();
                obj.zConn.Close();
            }
            catch (Exception ex)
            {
                ret = false;
                _error = ex.Message;
                obj.zTrans.Rollback();
                obj.zConn.Close();
            }
            return ret;
        }