/// <summary> /// ��SqlDataReader�а�ȫ��ȡ���� /// </summary> /// <param name="reader">���ݶ�ȡ��SqlDataReader</param> /// <param name="colname">����</param> /// <returns>���е��ַ������ݣ����Ϊ�գ���System.String.Empty</returns> public static string ValidateDataReader_S(SqlDataReader reader,string colname) { if(reader.GetValue(reader.GetOrdinal(colname))!=DBNull.Value) return reader.GetString(reader.GetOrdinal(colname)); else return System.String.Empty; }
public static int ValidateDataReader_N(SqlDataReader reader,string colname) { if(reader.GetValue(reader.GetOrdinal(colname))!=DBNull.Value) return reader.GetInt32(reader.GetOrdinal(colname)); else return System.Int32.MinValue; }
public static DateTime ValidateDataReader_T(SqlDataReader reader,string colname) { if(reader.GetValue(reader.GetOrdinal(colname))!=DBNull.Value) return reader.GetDateTime(reader.GetOrdinal(colname)); else return System.DateTime.MinValue; }
public void PopulateVolunteer(SqlDataReader _dtr, Volunteer obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_EMAIL); if (!_dtr.IsDBNull(columnIndex)) { obj.Email = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_CV); if (!_dtr.IsDBNull(columnIndex)) { obj.CV = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(VolunteerDataMapper.CN_MESSAGE); if (!_dtr.IsDBNull(columnIndex)) { obj.Message = _dtr.GetString((columnIndex)); } }
public override void Map(SqlDataReader sqlDataReader) { this.Id = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("Id")); this.Name = sqlDataReader.GetString(sqlDataReader.GetOrdinal("Name")); this.Level = sqlDataReader.GetByte(sqlDataReader.GetOrdinal("Level")); this.CountryId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("CountryId")); }
public static Request Map(SqlDataReader record) { if (record == null) throw new ArgumentNullException("record"); var request = new Request(); request.Id = (int) record["Id"]; request.RequesTime = (DateTime) record["RequetTime"]; if (record["CreatorId"].ToString() != string.Empty) { request.CreatorId = (int) record["CreatorId"]; } request.PhoneNumber = (string) record["PhoneNumber"]; request.Status = (int) record["Status"]; request.StartPoint = (string) record["StartPoint"]; request.FinishPoint = (string) record["FinishPoint"]; request.OperatorId = record.IsDBNull(record.GetOrdinal("OperatorId")) == false ? (int)record["OperatorId"] : default(int?); request.DriverId = record.IsDBNull(record.GetOrdinal("DriverId")) == false ? (int?) record["DriverId"] : default(int?); request.Price = record.IsDBNull(record.GetOrdinal("Price")) == false ? (decimal?)record["Price"] : default(decimal?); request.Additional = record.IsDBNull(record.GetOrdinal("Additional")) == false ? (string)record["Additional"] : default(string); return request; }
public void PopulateOrdinals(SqlDataReader reader) { ord_CustomerID = reader.GetOrdinal("CustomerID"); ord_FirstName = reader.GetOrdinal("FirstName"); ord_LastName = reader.GetOrdinal("LastName"); ord_Age = reader.GetOrdinal("Age"); ord_EmailAddress = reader.GetOrdinal("EmailAddress"); }
private object DeserializeQueuedEvent(SqlDataReader result) { var eventTypeIdColumnId = result.GetOrdinal("EventTypeId"); var eventDataColumnId = result.GetOrdinal("EventData"); result.Read(); var eventTypeId = result.GetSqlGuid(eventTypeIdColumnId).Value; return this.serializationMethod.Deserialize(new XmlSerializedData(eventTypeId, result.GetSqlXml(eventDataColumnId).CreateReader())); }
public LoginDB(System.Data.SqlClient.SqlDataReader reader) { this.reader = reader; this.ID = reader.GetInt64(reader.GetOrdinal("Id")); this.Login = reader.GetString(reader.GetOrdinal("Login")); this.Senha = reader.GetString(reader.GetOrdinal("Senha")); }
public Tarjeta(SqlDataReader reader) { this.codTarjeta = reader.IsDBNull(reader.GetOrdinal("codTarjeta")) ? null : (string)reader["codTarjeta"]; this.fecEmision = reader.IsDBNull(reader.GetOrdinal("fechaEmi")) ? null : (string)reader["fechaEmi"].ToString(); this.fecAnulado = reader.IsDBNull(reader.GetOrdinal("fechaAnu")) ? null : (string)reader["fechaAnu"].ToString(); this.estado = reader.IsDBNull(reader.GetOrdinal("estado")) ? -1 : (int)reader["estado"]; this.cliente = new Cliente(reader); }
public void PopulateCategory(SqlDataReader _dtr, Category obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_DESCRIPTION); if (!_dtr.IsDBNull(columnIndex)) { obj.Description = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_TYPE); if (!_dtr.IsDBNull(columnIndex)) { obj.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.CategoryType)_dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ATTRIBUTES); if (!_dtr.IsDBNull(columnIndex)) { obj.Attributes = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_ISDELETED); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDeleted = _dtr.GetBoolean((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_XSL_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.XslID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_image); if (!_dtr.IsDBNull(columnIndex)) { obj.Image = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_LANGUAGE_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.LanguageID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(CategoryDataMapper.CN_HASH); if (!_dtr.IsDBNull(columnIndex)) { obj.Hash = _dtr.GetString((columnIndex)); } }
private static void InitIndex(SqlDataReader reader) { if (NameIndex == -1) { object_idIndex = reader.GetOrdinal("object_id"); NameIndex = reader.GetOrdinal("Name"); ownerIndex = reader.GetOrdinal("owner"); typeIndex = reader.GetOrdinal("type"); } }
public object GetUnoSQlValue(SqlDataReader rdb, string str) { if (rdb.IsDBNull(rdb.GetOrdinal(str))) { return null; } else { return rdb[(rdb.GetOrdinal(str))]; } }
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader) { DotNetNancy.Rules.RuleSet.DataAccess.DTO.RuleStatistic dto; using (reader) { while (reader.Read()) { dto = new DotNetNancy.Rules.RuleSet.DataAccess.DTO.RuleStatistic(); dto.RuleName = _baseDatabase.resolveNullString(reader.GetOrdinal("RuleName"), reader); dto.ReferenceID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("ReferenceID"), reader); dto.Result = _baseDatabase.resolveNullBoolean(reader.GetOrdinal("Result"), reader); dto.RuleStatisticID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("RuleStatisticID"), reader); dto.ApplicationID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("ApplicationID"), reader); dto.TypeID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("TypeID"), reader); dto.RuleID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("RuleID"), reader); dto.DateInserted = _baseDatabase.resolveNullDateTime(reader.GetOrdinal("DateInserted"), reader); this.Add(dto); } } }
private Notification CreateNotification(SqlDataReader reader) { return new Notification { ID = reader.GetGuid(reader.GetOrdinal("NotificationID")), LanguageCode = GetString(reader, "LanguageCode"), Subject = GetString(reader, "Subject"), TypeKey = GetString(reader, "TypeKey"), Dispatched = reader.GetBoolean(reader.GetOrdinal("Dispatched")), Parameter = new JavaScriptSerializer().Deserialize<Dictionary<string, string>>( GetString(reader, "Parameter") ) }; }
public override UserOperationVO ReadRecord(System.Data.SqlClient.SqlDataReader reader) { UserOperationVO result = new UserOperationVO(); result.Id = reader.GetInt32(reader.GetOrdinal(idColumnName)); int userId = reader.GetInt32(reader.GetOrdinal(userOperationUserId)); int operationId = reader.GetInt32(reader.GetOrdinal(userOperationOperationId)); result.User = firstTableDAO.GetItem(userId); result.Operation = secondTableDAO.GetItem(operationId); firstTableDAO.CloseConnection(); secondTableDAO.CloseConnection(); return(result); }
public IProject Resolve(IProject project, SqlDataReader reader) { project.ProjectId = Convert.ToInt32(reader["projectId"]); project.Name = Convert.ToString(reader["name"]); project.StatusId = Convert.ToInt32(reader["statusId"]); if(!reader.IsDBNull(reader.GetOrdinal("PlannedEndDate"))) project.PlannedEndDate = Convert.ToDateTime(reader["PlannedEndDate"]); if (!reader.IsDBNull(reader.GetOrdinal("ActualEndDate"))) project.ActualEndDate = Convert.ToDateTime(reader["ActualEndDate"]); if (!reader.IsDBNull(reader.GetOrdinal("PlannedStartDate"))) project.PlannedStartDate = Convert.ToDateTime(reader["PlannedStartDate"]); if (!reader.IsDBNull(reader.GetOrdinal("ActualStartDate"))) project.ActualEndDate = Convert.ToDateTime(reader["ActualStartDate"]); project.CompanyId = Convert.ToInt32(reader["companyId"]); return project; }
public static StatsModel readRecord(SqlDataReader dr) { StatsModel currentRecord = new StatsModel(); currentRecord.id = dr["id"].ToString(); //reader.GetDateTime(reader.GetOrdinal("Timestamp")); currentRecord.logtime = dr.GetDateTime(dr.GetOrdinal("logtime")); currentRecord.is_interacting = Convert.ToBoolean(dr["is_interacting"]); currentRecord.pcy = Convert.ToInt32(dr["pcy"]); currentRecord.cpu = Convert.ToInt32(dr["cpu"]); currentRecord.vss = Convert.ToInt32(dr["vss"]); currentRecord.rss = Convert.ToInt32(dr["rss"]); currentRecord.threads = Convert.ToInt32(dr["threads"]); currentRecord.priority = Convert.ToInt32(dr["priority"]); currentRecord.status = dr["status"].ToString(); currentRecord.bg_up_data = Convert.ToInt32(dr["bg_up_data"]) == -1 ? 0 : Convert.ToInt32(dr["bg_up_data"]); ; currentRecord.bg_down_data = Convert.ToInt32(dr["bg_down_data"]) == -1 ? 0 : Convert.ToInt32(dr["bg_down_data"]); ; currentRecord.fg_up_data = Convert.ToInt32(dr["fg_up_data"]) == -1 ? 0 : Convert.ToInt32(dr["fg_up_data"]); currentRecord.fg_down_data = Convert.ToInt32(dr["fg_down_data"]) == -1 ? 0 : Convert.ToInt32(dr["fg_down_data"]); ; currentRecord.bg_up_wifi = Convert.ToInt32(dr["bg_up_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["bg_up_wifi"]); ; currentRecord.bg_down_wifi = Convert.ToInt32(dr["bg_down_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["bg_down_wifi"]); ; currentRecord.fg_up_wifi = Convert.ToInt32(dr["fg_up_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["fg_up_wifi"]); ; currentRecord.fg_down_wifi = Convert.ToInt32(dr["fg_down_wifi"]) == -1 ? 0 : Convert.ToInt32(dr["fg_down_wifi"]); ; //Console.WriteLine("Date Read: " + dt); return currentRecord; }
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader) { CodeSampleApplication.Dto.Purpose dto; using (reader) { while (reader.Read()) { dto = new CodeSampleApplication.Dto.Purpose(); dto.PurposeDescription = _baseDatabase.resolveNullString(reader.GetOrdinal("PurposeDescription"), reader); dto.PurposeID = _baseDatabase.resolveNullInt32(reader.GetOrdinal("PurposeID"), reader); this.Add(dto); } } }
public void FillEvent(SqlDataReader dr, string statementDate, int pageNumber, string title, iTextSharp.text.Image imgLogo) { if (statementDate != null && statementDate.Length > 0) { _statementDate = statementDate; } else { _statementDate = ""; } _groName = dr.GetString(dr.GetOrdinal("GrowerName")); _groAdr1 = dr.GetString(dr.GetOrdinal("GroAdr1")); _groAdr2 = dr.GetString(dr.GetOrdinal("GroAdr2")); _groCSZ = dr.GetString(dr.GetOrdinal("GroCSZ")); _pageNumber = pageNumber; _title = title; _imgLogo = imgLogo; }
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader) { TestSprocGenerator.Data.SingleTable.Dto.Person dto; using (reader) { while (reader.Read()) { dto = new TestSprocGenerator.Data.SingleTable.Dto.Person(); dto.PersonFirstName = _baseDatabase.resolveNullString(reader.GetOrdinal("PersonFirstName"), reader); dto.PersonLastName = _baseDatabase.resolveNullString(reader.GetOrdinal("PersonLastName"), reader); dto.PersonMiddleInitials = _baseDatabase.resolveNullString(reader.GetOrdinal("PersonMiddleInitials"), reader); dto.Deleted = _baseDatabase.resolveNullBoolean(reader.GetOrdinal("Deleted"), reader); dto.InsertedDateTime = _baseDatabase.resolveNullDateTime(reader.GetOrdinal("InsertedDateTime"), reader); dto.ModifiedDateTime = _baseDatabase.resolveNullDateTime(reader.GetOrdinal("ModifiedDateTime"), reader); dto.PersonID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("PersonID"), reader); this.Add(dto); } } }
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader) { TestSprocGenerator.Data.SingleTable.Dto.Account dto; using (reader) { while (reader.Read()) { dto = new TestSprocGenerator.Data.SingleTable.Dto.Account(); dto.AccountCode = _baseDatabase.resolveNullString(reader.GetOrdinal("AccountCode"), reader); dto.AccountUsername = _baseDatabase.resolveNullString(reader.GetOrdinal("AccountUsername"), reader); dto.AccountPassword = _baseDatabase.resolveNullString(reader.GetOrdinal("AccountPassword"), reader); dto.Deleted = _baseDatabase.resolveNullBoolean(reader.GetOrdinal("Deleted"), reader); dto.InsertedDateTime = _baseDatabase.resolveNullDateTime(reader.GetOrdinal("InsertedDateTime"), reader); dto.ModifiedDateTime = _baseDatabase.resolveNullDateTime(reader.GetOrdinal("ModifiedDateTime"), reader); dto.AccountID = _baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("AccountID"), reader); this.Add(dto); } } }
public virtual void MapToEntity(SqlDataReader sqlDataReader) { var properties = this.GetType().GetProperties(); foreach (var property in properties) { int index = sqlDataReader.GetOrdinal(property.Name); property.SetValue(this, sqlDataReader.GetValue(index)); } }
private EventStream DeserializeEvents(Guid id, SqlDataReader result) { var lastVersion = 0; var snapshotVersion = 0; var eventTypeIdColumnId = result.GetOrdinal("EventTypeId"); var eventDataColumnId = result.GetOrdinal("EventData"); var versionColumnId = result.GetOrdinal("Version"); var snapshotVersionColumnId = result.GetOrdinal("SnapshotVersion"); var events = new List<object>(); while (result.Read()) { var eventTypeId = result.GetSqlGuid(eventTypeIdColumnId).Value; lastVersion = result.GetSqlInt32(versionColumnId).Value; snapshotVersion = result.GetSqlInt32(snapshotVersionColumnId).Value; events.Add(this.serializationMethod.Deserialize(new XmlSerializedData(eventTypeId, result.GetSqlXml(eventDataColumnId).CreateReader()))); } return new EventStream(id, lastVersion, snapshotVersion, events); }
private List<Subscription> ParseSubscription(SqlDataReader sqlDataReader) { List<Subscription> subList = new List<Subscription>(); int iSubscription_id = sqlDataReader.GetOrdinal("Subscription_id"); int iDomainUserName = sqlDataReader.GetOrdinal("DomainUserName"); int iReportPath = sqlDataReader.GetOrdinal("ReportPath"); int iReportArgs = sqlDataReader.GetOrdinal("ReportArgs"); while (sqlDataReader.Read()) { Subscription sub = new Subscription() { Subscription_id = int.Parse(sqlDataReader[iSubscription_id].ToString()), DomainUserName = sqlDataReader[iDomainUserName].ToString(), ReportPath = sqlDataReader[iReportPath].ToString(), ReportArgs = sqlDataReader[iReportArgs].ToString() }; subList.Add(sub); } sqlDataReader.Close(); return subList; }
public override IModel CreateModel(SqlDataReader dr) { StockLogAttach stocklogattach = new StockLogAttach(); int indexStockLogAttachId = dr.GetOrdinal("StockLogAttachId"); stocklogattach.StockLogAttachId = Convert.ToInt32(dr[indexStockLogAttachId]); int indexStockLogId = dr.GetOrdinal("StockLogId"); if (dr["StockLogId"] != DBNull.Value) { stocklogattach.StockLogId = Convert.ToInt32(dr[indexStockLogId]); } int indexAttachId = dr.GetOrdinal("AttachId"); if (dr["AttachId"] != DBNull.Value) { stocklogattach.AttachId = Convert.ToInt32(dr[indexAttachId]); } return stocklogattach; }
private bool GetDBBool(SqlDataReader reader, string columnName) { try { int ordinal = reader.GetOrdinal(columnName); return reader.IsDBNull(ordinal) ? false : reader.GetBoolean(ordinal); } catch (IndexOutOfRangeException) { return false; } }
private DateTime GetDBDate(SqlDataReader reader, string columnName) { try { int ordinal = reader.GetOrdinal(columnName); return reader.IsDBNull(ordinal) ? DateTime.MinValue : reader.GetDateTime(ordinal); } catch (IndexOutOfRangeException) { return DateTime.MinValue; } }
internal JamTeamData ReadData(SqlDataReader reader) { JamTeamData jamFoul = new JamTeamData(); jamFoul.JamID = reader.GetInt32(reader.GetOrdinal("JamID")); jamFoul.TeamID = reader.GetInt32(reader.GetOrdinal("TeamID")); jamFoul.BlockerBoxTime = reader.GetInt32(reader.GetOrdinal("BlockerBoxTime")); jamFoul.JammerBoxTime = reader.GetInt32(reader.GetOrdinal("JammerBoxTime")); jamFoul.OppBlockerBoxTime = reader.GetInt32(reader.GetOrdinal("OppBlockerBoxTime")); jamFoul.OppJammerBoxTime = reader.GetInt32(reader.GetOrdinal("OppJammerBoxTime")); jamFoul.PointDelta = reader.GetInt32(reader.GetOrdinal("PointDelta")); return jamFoul; }
private static IEnumerable<Account> ReadData(SqlDataReader rdr) { var lst = new List<Account>(); int ordAccountNo = rdr.GetOrdinal("AccountNo"); int ordCompany = rdr.GetOrdinal("Company"); int ordContact = rdr.GetOrdinal("Contact"); int ordContracted = rdr.GetOrdinal("Contracted"); int ordPurchased = rdr.GetOrdinal("Purchased"); if (rdr.HasRows) { while (rdr.Read()) { lst.Add( new Account { AccountNo = ((string) ParameterUtils.SafeGetValue(rdr.GetValue(ordAccountNo), typeof (string), Constants.InitializeString)), Company = ((string) ParameterUtils.SafeGetValue(rdr.GetValue(ordCompany), typeof (string), Constants.InitializeString)), Contact = ((string) ParameterUtils.SafeGetValue(rdr.GetValue(ordContact), typeof (string), Constants.InitializeString)), Contracted = ((int) ParameterUtils.SafeGetValue(rdr.GetValue(ordContracted), typeof (int), Constants.InitializeInt)), Purchased = ((int) ParameterUtils.SafeGetValue(rdr.GetValue(ordPurchased), typeof (int), Constants.InitializeInt)) }); } } return lst; }
internal static LanguageURL GetLanguageURL(List<LanguageURL> LanguageURLs, SqlDataReader reader) { int colIndex = 0; colIndex = reader.GetOrdinal(CN_LANGUAGE_URL_ID); int value = reader.GetInt32(colIndex); LanguageURL LanguageURL = LanguageURLs.Where(c => c.ID == value).FirstOrDefault(); if (LanguageURL == null) { LanguageURL = new LanguageURL(); LanguageURLs.Add(LanguageURL); } return LanguageURL; }
public virtual void Map(SqlDataReader rdr) { var properties = this.GetType().GetProperties(); foreach (var property in properties) { int index = rdr.GetOrdinal(property.Name); if (rdr.IsDBNull(index)) { property.SetValue(this, null); continue; } property.SetValue(this, rdr.GetValue(index)); } }
public static void PopulateObjectFromReader(SqlDataReader reader, Account acc) { acc.AccountNumber = (int)reader["AccountNumber"]; acc.Type = (char)reader.GetString(reader.GetOrdinal("AccountType"))[0]; acc.AvailableBalance = (decimal)reader["AvailableBalance"]; acc.CustomerId = (int)reader["CustomerId"]; try { acc.LastUpdatedDate = Convert.ToDateTime(reader["LastUpdatedDate"]); } catch (Exception) { acc.LastUpdatedDate = null; } }
public static User Map(SqlDataReader record) { var user = new User { Id = (int)record["Id"], UserName = (string)record["Name"], LastName = (string)record["LastName"], Login = (string)record["Login"], PhoneNumber = (string)record["PhoneNumber"], Email = (string)record["Email"], Password = (string)record["Password"], Role = (int)record["Role"], Status = (int)record["Status"], DriverStatus = record.IsDBNull(record.GetOrdinal("DriverStatus")) == false ? (int?)record["DriverStatus"] : default(int?) }; return user; }
//初始化类型信息下拉列表 public void initComb() { try { cmdText = "select typename from Type"; cmd = new SqlCommand(cmdText, sc.getConn()); reader = cmd.ExecuteReader(); while (reader.Read()) { combType.Items.Add(reader.GetString(reader.GetOrdinal("typename"))); } reader.Dispose(); reader.Close(); cmd.Dispose(); } catch (Exception ex) { MessageBox.Show("初始化类型信息错误:" + ex.Message); } }