C# DbDataReader.Close方法代码示例

        public static DataTable ConvertDataReaderToDataTable(DbDataReader reader)
        {
            try
            {
                DataTable table = new DataTable();
                int fieldCount = reader.FieldCount;
                for (int fieldIndex = 0; fieldIndex < fieldCount; ++fieldIndex)
                {
                    table.Columns.Add(reader.GetName(fieldIndex), reader.GetFieldType(fieldIndex));
                }

                table.BeginLoadData();

                object[] rowValues = new object[fieldCount];
                while (reader.Read())
                {
                    reader.GetValues(rowValues);
                    table.LoadDataRow(rowValues, true);
                }
                reader.Close();
                table.EndLoadData();

                return table;

            }
            catch (Exception ex)
            {
                throw new Exception("DataReader转换为DataTable时出错!", ex);
            }
        }

 private MFPAJ100Entity GetMFPAJ100FromIDataReader(DbDataReader dr)
 {
     MFPAJ100Entity dt = new MFPAJ100Entity();
     if (dr.FieldCount > 0)
     {
         if (dr["MessageID"].ToString() != "" || dr["MessageID"] != null) dt.MessageID = Int32.Parse(dr["MessageID"].ToString());
         dt.MessageType = dr["MessageType"].ToString();
         dt.MessageDetail = dr["MessageDetail"].ToString();
         if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
         if (dr["CreatorSID"].ToString() != "" || dr["CreatorSID"] != null) dt.CreatorSID = Int32.Parse(dr["CreatorSID"].ToString());
         dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }

		public void GetProviderSpecificValues_Reader_Closed ()
		{
			cmd.CommandText = "SELECT * FROM employee";
			rdr = cmd.ExecuteReader ();
			rdr.Close ();

			try {
				rdr.GetProviderSpecificValues (null);
				Assert.Fail ("#1");
			} catch (InvalidOperationException ex) {
				// Invalid attempt to call MetaData
				// when reader is closed
				Assert.AreEqual (typeof (InvalidOperationException), ex.GetType (), "#2");
				Assert.IsNull (ex.InnerException, "#3");
				Assert.IsNotNull (ex.Message, "#4");
			}
		}

        /// <summary>
        /// Readers to G object.
        /// </summary>
        /// <param name="reader">The reader.</param>
        /// <returns></returns>
        public static GObject ReaderToGObject(DbDataReader reader)
        {
            GObject result = null;
            if (!reader.HasRows)
            {

            }

            try
            {
                reader.Close();
                reader = null;
            }
            catch (Exception)
            {
                reader = null;
            }
            return result;
        }

        public static List<object> GetColumnFromDataReader(DbDataReader dr, string columnName)
        {
            List<object> column = new List<object>();

            try
            {
                while (dr.Read())
                {
                    column.Add(dr[columnName]);
                }
            }
            finally
            {
                if (dr != null && !dr.IsClosed)
                {
                    dr.Close();  // Data Reader is done (read only, forward only)
                    dr.Dispose();
                }
            }

            return column;
        }

        public static List<Category> GetCategorys(DbDataReader dataReader)
        {
            List<Category> categorys = new List<Category>();
            while (dataReader.Read())
            {
                Category category = new Category();
                category.CategoryId = Convert.ToInt32(dataReader[CategoryField.CategoryId]);
                category.CategoryGuid = (Guid)dataReader[CategoryField.CategoryGuid];
                category.CategoryName = Convert.ToString(dataReader[CategoryField.CategoryName]);
                category.ParentGuid = (Guid)dataReader[CategoryField.ParentGuid];
                category.ParentCategoryName = dataReader[CategoryField.ParentCategoryName].ToString();
                category.Rank = Convert.ToInt32(dataReader[CategoryField.Rank]);
                category.ArticleType = (byte)dataReader[CategoryField.ArticleType];
                if (dataReader[CategoryField.ThumbnailWidth] != DBNull.Value)
                    category.ThumbnailWidth = (int)dataReader[CategoryField.ThumbnailWidth];
                if (dataReader[CategoryField.ThumbnailHeight] != DBNull.Value)
                    category.ThumbnailHeight = (int)dataReader[CategoryField.ThumbnailHeight];
                category.RecordCount = (int)dataReader[CategoryField.RecordCount];

                categorys.Add(category);
            }
            dataReader.Close();
            return categorys;
        }

        internal static List<OfferDetails> GetOfferDetailObject(DbDataReader reader)
        {
            OfferDetails hooOffer = null;
            List<OfferDetails> allOffers = new List<OfferDetails>();
            while (reader.Read())
            {
                hooOffer = new OfferDetails();
                hooOffer.OfferId = reader.IsDBNull(reader.GetOrdinal("OfferId")) ? 0 : Convert.ToInt32(reader["OfferId"], CultureInfo.InvariantCulture);
                hooOffer.OfferTitle = reader.IsDBNull(reader.GetOrdinal("OfferTitle")) ? string.Empty : Convert.ToString(reader["OfferTitle"], CultureInfo.InvariantCulture);
                hooOffer.OfferDescription = reader.IsDBNull(reader.GetOrdinal("OfferDescription")) ? string.Empty : Convert.ToString(reader["OfferDescription"], CultureInfo.InvariantCulture);
                hooOffer.ImageUrl = reader.IsDBNull(reader.GetOrdinal("OfferImageUrl")) ? string.Empty : Convert.ToString(reader["OfferImageUrl"], CultureInfo.InvariantCulture);
                hooOffer.StartDate = reader.IsDBNull(reader.GetOrdinal("StartDate")) ? DateTime.Now : Convert.ToDateTime(reader["StartDate"], CultureInfo.InvariantCulture);
                hooOffer.ExpireDate = reader.IsDBNull(reader.GetOrdinal("ExpireDate")) ? DateTime.Now : Convert.ToDateTime(reader["ExpireDate"], CultureInfo.InvariantCulture);
                hooOffer.comments = reader.IsDBNull(reader.GetOrdinal("Comments")) ? string.Empty : Convert.ToString(reader["Comments"], CultureInfo.InvariantCulture);
                hooOffer.Latitude = reader.IsDBNull(reader.GetOrdinal("Latitude")) ? 0 : Convert.ToDouble(reader["Latitude"], CultureInfo.InvariantCulture);
                hooOffer.Longitude = reader.IsDBNull(reader.GetOrdinal("Longitude")) ? 0 : Convert.ToDouble(reader["Longitude"], CultureInfo.InvariantCulture);
                hooOffer.City = reader.IsDBNull(reader.GetOrdinal("City")) ? string.Empty : Convert.ToString(reader["City"], CultureInfo.InvariantCulture);
                hooOffer.OfferCategory = reader.IsDBNull(reader.GetOrdinal("OfferCategory")) ? string.Empty : Convert.ToString(reader["OfferCategory"], CultureInfo.InvariantCulture);
                hooOffer.PromoCode = reader.IsDBNull(reader.GetOrdinal("PromoCode")) ? string.Empty : Convert.ToString(reader["PromoCode"], CultureInfo.InvariantCulture);

                hooOffer.Ratings = reader.IsDBNull(reader.GetOrdinal("SumOfRating")) ? 0 : Convert.ToInt32(reader["SumOfRating"], CultureInfo.InvariantCulture);

                hooOffer.Vendor = new Supplier();
                hooOffer.Vendor.SupplierId = reader.IsDBNull(reader.GetOrdinal("SupplierId")) ? 0 : Convert.ToInt32(reader["SupplierId"], CultureInfo.InvariantCulture);
                hooOffer.Vendor.SupplierName = reader.IsDBNull(reader.GetOrdinal("SupName")) ? string.Empty : Convert.ToString(reader["SupName"], CultureInfo.InvariantCulture);
                hooOffer.Vendor.ContactNumber = reader.IsDBNull(reader.GetOrdinal("SupContactNumber")) ? string.Empty : Convert.ToString(reader["SupContactNumber"], CultureInfo.InvariantCulture);
                hooOffer.Vendor.Email = reader.IsDBNull(reader.GetOrdinal("SupEmailId")) ? string.Empty : Convert.ToString(reader["SupEmailId"], CultureInfo.InvariantCulture);
                hooOffer.Vendor.ImageUrl = ConfigurationManager.AppSettings["ImageFolder"].ToString();
                hooOffer.Vendor.ImageUrl +=  reader.IsDBNull(reader.GetOrdinal("SupImageURL")) ? string.Empty : Convert.ToString(reader["SupImageURL"], CultureInfo.InvariantCulture);
                hooOffer.Vendor.SupplierAddress = reader.IsDBNull(reader.GetOrdinal("SupAddress")) ? string.Empty : Convert.ToString(reader["SupAddress"], CultureInfo.InvariantCulture);
                allOffers.Add(hooOffer);

            }
            reader.Close();

            return allOffers;
        }

 private PSACNEntity GetPSACNFromIDataReader(DbDataReader dr)
 {
     PSACNEntity dt = new PSACNEntity();
     if (dr.FieldCount > 0)
     {
         dt.PSACNCO = dr["PSACNCO"].ToString();
         dt.PSACNNCN = dr["PSACNNCN"].ToString();
         dt.PSACNNEN = dr["PSACNNEN"].ToString();
         dt.PSACNNTW = dr["PSACNNTW"].ToString();
         dt.PSACNPRE = dr["PSACNPRE"].ToString();
         dt.PSACNDAT = dr["PSACNDAT"].ToString();
         if (dr["PSACNLEN"].ToString() != "" || dr["PSACNLEN"] != null) dt.PSACNLEN = Int32.Parse(dr["PSACNLEN"].ToString());
         if (dr["PSACNCUR"].ToString() != "" || dr["PSACNCUR"] != null) dt.PSACNCUR = Int32.Parse(dr["PSACNCUR"].ToString());
         dt.PSACNPDA = dr["PSACNPDA"].ToString();
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }

 private Workflow_RequestBaseEntity GetWorkflow_RequestBaseFromIDataReader(DbDataReader dr)
 {
     Workflow_RequestBaseEntity dt = new Workflow_RequestBaseEntity();
     if (dr.FieldCount > 0)
     {
         if (dr["RequestID"].ToString() != "" || dr["RequestID"] != null) dt.RequestID = Int32.Parse(dr["RequestID"].ToString());
         if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
         if (dr["LastNodeID"].ToString() != "" || dr["LastNodeID"] != null) dt.LastNodeID = Int32.Parse(dr["LastNodeID"].ToString());
         dt.LastRuleID = dr["LastRuleID"].ToString();
         dt.LastRuleType = dr["LastRuleType"].ToString();
         if (dr["LastNodeType"].ToString() != "" || dr["LastNodeType"] != null) dt.LastNodeType = Int32.Parse(dr["LastNodeType"].ToString());
         if (dr["LastDeptLevel"].ToString() != "" || dr["LastDeptLevel"] != null) dt.LastDeptLevel = Int32.Parse(dr["LastDeptLevel"].ToString());
         dt.LastOperatorID = dr["LastOperatorID"].ToString();
         if (dr["CurrentNodeID"].ToString() != "" || dr["CurrentNodeID"] != null) dt.CurrentNodeID = Int32.Parse(dr["CurrentNodeID"].ToString());
         dt.CurrentRuleID = dr["CurrentRuleID"].ToString();
         dt.CurrentRuleType = dr["CurrentRuleType"].ToString();
         if (dr["CurrentNodeType"].ToString() != "" || dr["CurrentNodeType"] != null) dt.CurrentNodeType = Int32.Parse(dr["CurrentNodeType"].ToString());
         if (dr["CurrentDeptLevel"].ToString() != "" || dr["CurrentDeptLevel"] != null) dt.CurrentDeptLevel = Int32.Parse(dr["CurrentDeptLevel"].ToString());
         dt.CurrentOperatorID = dr["CurrentOperatorID"].ToString();
         dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
         if (dr["Creator"].ToString() != "" || dr["Creator"] != null) dt.Creator = Int32.Parse(dr["Creator"].ToString());
         dt.RequestStatus = dr["RequestStatus"].ToString();
         dt.RequestName = dr["RequestName"].ToString();
         if (dr["IsCancel"].ToString() != "" || dr["IsCancel"] != null) dt.IsCancel = Int32.Parse(dr["IsCancel"].ToString());
         dt.AllParticipator = dr["AllParticipator"].ToString();
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }

 private Workflow_ReportMainEntity GetWorkflow_ReportMainFromIDataReader(DbDataReader dr)
 {
     Workflow_ReportMainEntity dt = new Workflow_ReportMainEntity();
     if (dr.FieldCount > 0)
     {
         if (dr["ReportID"].ToString() != "" || dr["ReportID"] != null) dt.ReportID = Int32.Parse(dr["ReportID"].ToString());
         if (dr["ReportTypeID"].ToString() != "" || dr["ReportTypeID"] != null) dt.ReportTypeID = Int32.Parse(dr["ReportTypeID"].ToString());
         dt.ReportName = dr["ReportName"].ToString();
         if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
         dt.WorkflowID = dr["WorkflowID"].ToString();
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }

 private Workflow_NodeTriggerConditionEntity GetWorkflow_NodeTriggerConditionFromIDataReader(DbDataReader dr)
 {
     Workflow_NodeTriggerConditionEntity dt = new Workflow_NodeTriggerConditionEntity();
     if (dr.FieldCount > 0)
     {
         if (dr["ConditionID"].ToString() != "" || dr["ConditionID"] != null) dt.ConditionID = Int32.Parse(dr["ConditionID"].ToString());
         dt.BatchSeq = Convert.ToByte(dr["BatchSeq"]);
         dt.BranchBatchSeq = Convert.ToByte(dr["BranchBatchSeq"]);
         if (dr["TriggerID"].ToString() != "" || dr["TriggerID"] != null) dt.TriggerID = Int32.Parse(dr["TriggerID"].ToString());
         if (dr["FieldID"].ToString() != "" || dr["FieldID"] != null) dt.FieldID = Int32.Parse(dr["FieldID"].ToString());
         dt.SymbolCode = dr["SymbolCode"].ToString();
         dt.CompareToValue = dr["CompareToValue"].ToString();
         dt.AndOr = dr["AndOr"].ToString();
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }

 private Workflow_BrowseTypeEntity GetWorkflow_BrowseTypeFromIDataReader(DbDataReader dr)
 {
     Workflow_BrowseTypeEntity dt = new Workflow_BrowseTypeEntity();
     if (dr.FieldCount > 0)
     {
         if (dr["BrowseTypeID"].ToString() != "" || dr["BrowseTypeID"] != null) dt.BrowseTypeID = Int32.Parse(dr["BrowseTypeID"].ToString());
         dt.BrowseTypeName = dr["BrowseTypeName"].ToString();
         dt.BrowseTypeDesc = dr["BrowseTypeDesc"].ToString();
         dt.BrowsePage = dr["BrowsePage"].ToString();
         dt.Useflag = dr["Useflag"].ToString();
         dt.BrowseValueSql = dr["BrowseValueSql"].ToString();
         dt.BrowseSqlParam = dr["BrowseSqlParam"].ToString();
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }

 private Workflow_BasicValidTypeEntity GetWorkflow_BasicValidTypeFromIDataReader(DbDataReader dr)
 {
     Workflow_BasicValidTypeEntity dt = new Workflow_BasicValidTypeEntity();
     if (dr.FieldCount > 0)
     {
         if (dr["ValidTypeID"].ToString() != "" || dr["ValidTypeID"] != null) dt.ValidTypeID = Int32.Parse(dr["ValidTypeID"].ToString());
         dt.ValidTypeDesc = dr["ValidTypeDesc"].ToString();
         dt.ValidErrorMsg = dr["ValidErrorMsg"].ToString();
         dt.ValidRule = (dr["ValidRule"].ToString());
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }

 private Workflow_BaseEntity GetWorkflow_BaseFromIDataReader(DbDataReader dr)
 {
     Workflow_BaseEntity dt = new Workflow_BaseEntity();
     if (dr.FieldCount > 0)
     {
         if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
         dt.WorkflowName = dr["WorkflowName"].ToString();
         dt.WorkflowDesc = dr["WorkflowDesc"].ToString();
         if (dr["FlowTypeID"].ToString() != "" || dr["FlowTypeID"] != null) dt.FlowTypeID = Int32.Parse(dr["FlowTypeID"].ToString());
         if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
         if (dr["IsValid"].ToString() != "" || dr["IsValid"] != null) dt.IsValid = Int32.Parse(dr["IsValid"].ToString());
         if (dr["IsMailNotice"].ToString() != "" || dr["IsMailNotice"] != null) dt.IsMailNotice = Int32.Parse(dr["IsMailNotice"].ToString());
         if (dr["IsMsgNotice"].ToString() != "" || dr["IsMsgNotice"] != null) dt.IsMsgNotice = Int32.Parse(dr["IsMsgNotice"].ToString());
         if (dr["IsTransfer"].ToString() != "" || dr["IsTransfer"] != null) dt.IsTransfer = Int32.Parse(dr["IsTransfer"].ToString());
         if (dr["AttachDocPath"].ToString() != "" || dr["AttachDocPath"] != null) dt.AttachDocPath = Int32.Parse(dr["AttachDocPath"].ToString());
         if (dr["HelpDocPath"].ToString() != "" || dr["HelpDocPath"] != null) dt.HelpDocPath = Int32.Parse(dr["HelpDocPath"].ToString());
         if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }

 private Workflow_AgentSettingEntity GetWorkflow_AgentSettingFromIDataReader(DbDataReader dr)
 {
     Workflow_AgentSettingEntity dt = new Workflow_AgentSettingEntity();
     if (dr.FieldCount > 0)
     {
         if (dr["AgentID"].ToString() != "" || dr["AgentID"] != null) dt.AgentID = Int32.Parse(dr["AgentID"].ToString());
         if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
         if (dr["BeAgentPersonID"].ToString() != "" || dr["BeAgentPersonID"] != null) dt.BeAgentPersonID = Int32.Parse(dr["BeAgentPersonID"].ToString());
         if (dr["AgentPersonID"].ToString() != "" || dr["AgentPersonID"] != null) dt.AgentPersonID = Int32.Parse(dr["AgentPersonID"].ToString());
         if (dr["AgentStartDate"].ToString() != "" || dr["AgentStartDate"].ToString() != null) dt.AgentStartDate = Convert.ToDateTime(dr["AgentStartDate"].ToString());
         if (dr["AgentEndDate"].ToString() != "" || dr["AgentEndDate"].ToString() != null) dt.AgentEndDate = Convert.ToDateTime(dr["AgentEndDate"].ToString());
         if (dr["CreateDate"].ToString() != "" || dr["CreateDate"].ToString() != null) dt.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString());
         if (dr["Creator"].ToString() != "" || dr["Creator"] != null) dt.Creator = Int32.Parse(dr["Creator"].ToString());
         dt.IsCancel = dr["IsCancel"].ToString();
         dt.AllowCycle = dr["AllowCycle"].ToString();
         dt.AllowCreate = dr["AllowCreate"].ToString();
         if (dr["CancelOperator"].ToString() != "" || dr["CancelOperator"] != null) dt.CancelOperator = Int32.Parse(dr["CancelOperator"].ToString());
         if (dr["CancelDate"].ToString() != "" || dr["CancelDate"].ToString() != null) dt.CancelDate = Convert.ToDateTime(dr["CancelDate"].ToString());
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }