public WorkoutPlan(DbDataReader reader) { _id = reader.GetInt64(0); _title = reader.GetValue(1).ToString() == "" ? "" : reader.GetString(1); _period = reader.GetValue(2).ToString() == "" ? (byte)0 : reader.GetByte(2); _creatorId = reader.GetValue(3).ToString() == "" ? 0 : reader.GetInt64(3); }
public List <T> Fetch <T>(sql sql) { try { System.Data.Common.DbDataReader reader = dbHelperInstance.GetReader(sql.GetSql()); List <T> list = new List <T>(); Type type = typeof(T); if (type.IsPrimitive || type == typeof(string) || type == typeof(DateTime) || type.IsEnum) { while (reader.Read()) { if (type.IsEnum) { list.Add((T)Enum.ToObject(type, reader.GetValue(0))); } else { list.Add((T)Convert.ChangeType(reader.GetValue(0), type)); } } } else { while (reader.Read()) { T result = Activator.CreateInstance <T>(); PropertyInfo[] properties = type.GetProperties(); foreach (PropertyInfo property in properties) { string columName = attributesHelper.GetColumnName(property); if (property.PropertyType.IsEnum) { property.SetValue(result, Enum.ToObject(property.PropertyType, reader.GetValue(reader.GetOrdinal(columName))), null); } else { property.SetValue(result, Convert.ChangeType(reader.GetValue(reader.GetOrdinal(columName)), property.PropertyType), null); } } list.Add(result); } } return(list); } catch { throw; } finally { Close(); } }
public static void Print(string sql, DbDataReader reader) { log.Info("Results of [" + sql + "]"); string results = "\n"; if (reader.HasRows) { for (int j = 0; j < reader.FieldCount; j++) { results += reader.GetName(j); if (j < reader.FieldCount - 1) { results += "|"; } } results += "\n"; while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { results += reader.GetValue(i); if (i < reader.FieldCount - 1) { results += "|"; } } results += "\n"; } results = results.Substring(0, results.Length - 1); log.Info(results); } }
public override object Map(DbDataReader dataReader, RowMapperContext context) { if (dataReader.IsDBNull(0)) return null; return _converter(dataReader.GetValue(0)); }
public double? ReadDouble(DbDataReader reader, int index) { double d = double.NaN; if (reader.IsDBNull(index)) return 0; Object obj = reader.GetValue(index); if (obj.GetType() == typeof(Decimal)) { d = Decimal.ToDouble((Decimal)obj); } else if (obj.GetType() == typeof(double)) { d = (double)obj; } else if (obj.GetType() == typeof(float)) { d = (float)obj; } else if (obj.GetType() == typeof(string)) { d = double.Parse((string)obj); } else return null; return d; }
public DynamicEntityValue(DbDataReader reader) { for(int i = 0; i < reader.FieldCount; i++) { this._nameValues.Add(reader.GetName(i), reader.GetValue(i)); } }
protected void dsAuctionItemDetails2_Selected(object sender, SqlDataSourceStatusEventArgs e) { try { e.Command.Connection.Open(); System.Data.Common.DbDataReader dr = e.Command.ExecuteReader(CommandBehavior.SingleRow); if (dr.HasRows) { if (dr.Read()) { lblUserName.Text = "Welcome " + dr.GetValue(0).ToString() + "!"; lblAuctionTitle.Text = dr.GetValue(2).ToString(); Session["AuctionType"] = dr.GetValue(9).ToString(); } } } catch { } finally { e.Command.Connection.Close(); } }
public int EjecutarComandoSqlReturnID() { //retornara el id que fue insertado serialmente int id = 0; System.Data.Common.DbDataReader Datos = comando.ExecuteReader(); while (Datos.Read()) { id = Convert.ToInt32(Datos.GetValue(0)); } return(id); }
public override object Map(DbDataReader dataReader, RowMapperContext context) { var arrayType = context.Type.GetElementType(); var array = Array.CreateInstance(arrayType, _posNames.Length); for (int i = 0; i < _posNames.Length; i++) { if (!dataReader.IsDBNull(_posNames[i].Pos)) { array.SetValue(dataReader.GetValue(_posNames[i].Pos), i); } } return array; }
public static IEnumerable <PSObject> Translate(System.Data.Common.DbDataReader dataReader, Boolean ProviderTypes) { List <Map> MapList = new List <Map>(); int Ord = 0; foreach (var x in dataReader.GetSchemaTable().Select("", "ColumnOrdinal")) { MapList.Add(new Map(Ord, x["DataType"].ToString(), x["ColumnName"].ToString())); // x("AllowDBNull"), Ord += 1; } PSObject responseObject = new PSObject(); while (dataReader.Read()) { PSObject psObj = new PSObject(); foreach (Map m in MapList) { { var withBlock = psObj.Members; if (dataReader.IsDBNull(m.Ordinal)) { withBlock.Add(new PSNoteProperty(m.Name, null), true); } else { try { if (ProviderTypes) { withBlock.Add(new PSNoteProperty(m.Name, dataReader.GetProviderSpecificValue(m.Ordinal)), true); } else { withBlock.Add(new PSNoteProperty(m.Name, dataReader.GetValue(m.Ordinal)), true); } } catch (Exception ex) { string msg = string.Format("Failed to translate, ColumnName = {0} | ColumnOrdinal = {1} | ColumnType = {2} | ToStringValue = '{3}' | See InnerException for details", m.Name, m.Ordinal, m.DataType, dataReader.GetValue(m.Ordinal).ToString()); throw new Exception(msg, ex); } } } } yield return(psObj); } }
public static string ConvertRowToString(DbDataReader row, StringBuilder headers) { var output = new List<string>(); for (var i = 0; i < row.FieldCount; i++) { output.Add("" + row.GetValue(i)); } if (headers.Length == 0) { for (var i = 0; i < row.FieldCount; i++) { headers.Append(row.GetName(i) + ", "); } } return String.Join(", ", output.ToArray()); }
static int GetValue(IntPtr L) { try { ToLua.CheckArgsCount(L, 2); System.Data.Common.DbDataReader obj = (System.Data.Common.DbDataReader)ToLua.CheckObject(L, 1, typeof(System.Data.Common.DbDataReader)); int arg0 = (int)LuaDLL.luaL_checknumber(L, 2); object o = obj.GetValue(arg0); ToLua.Push(L, o); return(1); } catch (Exception e) { return(LuaDLL.toluaL_exception(L, e)); } }
/// <summary> /// 解析整行数据 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="reader"></param> /// <returns></returns> public static T GetRow <T>(this System.Data.Common.DbDataReader reader) where T : new() { var fields = typeof(T).GetFields(); T t = new T(); object boxT = t; foreach (var item in fields) { var name = item.Name; var attrs = item.GetCustomAttributes(typeof(ColNameAttribute), false); if (attrs.Length > 0) { name = (attrs[0] as ColNameAttribute).ColName; } try { var ordinal = reader.GetOrdinal(name); var valObj = reader.GetValue(ordinal); object valTo; if (valObj is DBNull) { if (!item.FieldType.IsValueType) { item.SetValue(boxT, null); } } else { if (item.FieldType.IsEnum) { valTo = Convert.ChangeType(valObj, typeof(int)); } else { valTo = Convert.ChangeType(valObj, item.FieldType); } item.SetValue(boxT, valTo); } } catch (IndexOutOfRangeException) { } } return((T)boxT); }
protected ProjectInfo_LH GetProjectInfo(DbDataReader reader) { ProjectInfo_LH row = new ProjectInfo_LH(); row.Id = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_id))); row.Projname = Convert.ToString(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_projName))); row.Xmdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_xmdm))); row.Zjdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_zjdm))); row.Zmdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_zmdm))); row.Sc = Convert.ToChar(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_sc))); return row; }
public DataTable(DbDataReader reader) { this.fields = new List<string>(); this.data = new List<object[]>(); for (int i = 0; i < reader.FieldCount; i++) { fields.Add(reader.GetName(i)); } while (reader.Read()) { object[] values = new object[reader.FieldCount]; for (int i = 0; i < fields.Count; i++) { values[i] = reader.GetValue(reader.GetOrdinal(fields[i])); } data.Add(values); } }
public int? ReadInt(DbDataReader reader, int index) { if (reader.IsDBNull(index)) return 0; int i; Object obj = reader.GetValue(index); if (obj.GetType() == typeof(int) || obj.GetType() == typeof(Int16) || obj.GetType() == typeof(Int32) || obj.GetType() == typeof(Int64)) i = Convert.ToInt32(obj); else if (obj.GetType() == typeof(string)) i = int.Parse((string)obj); else return null; return i; }
private Dictionary<string, object> CreateRow(DbDataReader record, string[] columns) { Dictionary<string, object> row = new Dictionary<string, object>(StringComparer.Ordinal); for (int i = 0; i < columns.Length; i++) { object value = record.GetValue(i); if (value == DBNull.Value) { value = null; } else { Type valueType = value.GetType(); if (valueType == typeof(Guid)) { value = value.ToString(); } else if (valueType == typeof(DateTime)) { value = ((DateTime)value).ToString("R", CultureInfo.InvariantCulture); } } row[columns[i]] = value; } return row; }
/// <summary> /// Execute a command against a data source, mapping the data reader to an enumerable of record dictionaries. /// This method perfoms LAZY LOADING/DEFERRED EXECUTION. /// Note that THE DATA READER WILL NOT BE DISPOSED UPON ENUMERATION OR FOREACH BRANCH OUT. /// </summary> /// <param name="dbDataReader"> The target data reader. </param> /// <param name="recordsAffectedCallback"> Executed when the output count of records affected is available to return (post enumeration). </param> /// <returns> An enumerable of record dictionary instances, containing key/value pairs of data. </returns> public IEnumerable<IRecord> GetRecordsFromReader(DbDataReader dbDataReader, Action<int> recordsAffectedCallback) { IRecord record; int recordsAffected; int recordIndex = 0; string key; object value; OnlyWhen._PROFILE_ThenPrint(string.Format("{0}::GetRecordsFromReader(...): enter", typeof(AdoNetStreamingFascade).Name)); if ((object)dbDataReader == null) throw new ArgumentNullException(nameof(dbDataReader)); OnlyWhen._PROFILE_ThenPrint(string.Format("{0}::GetRecordsFromReader(...): before yield", typeof(AdoNetStreamingFascade).Name)); while (dbDataReader.Read()) { record = new Record(); for (int columnIndex = 0; columnIndex < dbDataReader.FieldCount; columnIndex++) { key = dbDataReader.GetName(columnIndex); value = dbDataReader.GetValue(columnIndex).ChangeType<object>(); if (record.ContainsKey(key) || (key ?? string.Empty).Length == 0) key = string.Format("Column_{0:0000}", columnIndex); record.Add(key, value); } OnlyWhen._PROFILE_ThenPrint(string.Format("{0}::GetRecordsFromReader(...): on yield", typeof(AdoNetStreamingFascade).Name)); yield return record; // LAZY PROCESSING INTENT HERE / DO NOT FORCE EAGER LOAD } OnlyWhen._PROFILE_ThenPrint(string.Format("{0}::GetRecordsFromReader(...): after yield", typeof(AdoNetStreamingFascade).Name)); recordsAffected = dbDataReader.RecordsAffected; if ((object)recordsAffectedCallback != null) recordsAffectedCallback(recordsAffected); OnlyWhen._PROFILE_ThenPrint(string.Format("{0}::GetRecordsFromReader(...): leave", typeof(AdoNetStreamingFascade).Name)); }
/// <summary> /// Copies the standard agent select results into a ProcessAgent object /// </summary> /// <param name="dataReader"></param> /// <returns></returns> protected ProcessAgent readProcessAgent(DbDataReader dataReader) { ProcessAgent agent = new ProcessAgent(); long id = dataReader.GetInt32(0); agent.agentGuid = dataReader.GetString(1); agent.agentName = dataReader.GetString(2); // get process agent type if (!DBNull.Value.Equals(dataReader.GetValue(3))) agent.type = dataReader.GetString(3); // get the description if (!DBNull.Value.Equals(dataReader.GetValue(4))) agent.domainGuid = dataReader.GetString(4); // Get CodeBase if (!DBNull.Value.Equals(dataReader.GetValue(5))) agent.codeBaseUrl = dataReader.GetString(5); // get Webservice_URL if (!DBNull.Value.Equals(dataReader.GetValue(6))) agent.webServiceUrl = dataReader.GetString(6); return agent; }
protected ProcessAgentInfo readAgentInfo(DbDataReader dataReader) { long idIn = -1; long idOut = -1; string passIn = null; string passOut = null; ProcessAgentInfo info = new ProcessAgentInfo(); info.agentId = dataReader.GetInt32(0); info.agentGuid = dataReader.GetString(1); if (!DBNull.Value.Equals(dataReader.GetValue(2))) info.agentName = dataReader.GetString(2); info.agentType = (ProcessAgentType.AgentType) dataReader.GetInt32(3); if (!DBNull.Value.Equals(dataReader.GetValue(4))) info.codeBaseUrl = dataReader.GetString(4); info.webServiceUrl = dataReader.GetString(5); if (!DBNull.Value.Equals(dataReader.GetValue(6))) info.domainGuid = dataReader.GetString(6); if (!DBNull.Value.Equals(dataReader.GetValue(7))) info.issuerGuid = dataReader.GetString(7); if (!DBNull.Value.Equals(dataReader.GetValue(8))) idIn = dataReader.GetInt64(8); if (!DBNull.Value.Equals(dataReader.GetValue(9))) passIn = dataReader.GetString(9); if (!DBNull.Value.Equals(dataReader.GetValue(10))) idOut =dataReader.GetInt64(10); if (!DBNull.Value.Equals(dataReader.GetValue(11))) passOut = dataReader.GetString(11); if (!DBNull.Value.Equals(dataReader.GetValue(12))) info.retired = dataReader.GetBoolean(12); if (info.issuerGuid != null) { if (idIn > 0) { Coupon couponIn = new Coupon(); couponIn.couponId = idIn; couponIn.issuerGuid = info.issuerGuid; couponIn.passkey = passIn; info.identIn = couponIn; } else { info.identIn = null; } if (idOut > 0) { Coupon couponOut = new Coupon(); couponOut.couponId = idOut; couponOut.issuerGuid = info.issuerGuid; couponOut.passkey = passOut; info.identOut = couponOut; } else { info.identOut = null; } } return info; }
/// <summary>Gets the value of the specified column as an instance of type T.</summary> /// <typeparam name="T">The type of element to return.</typeparam> /// <param name="reader">The reader.</param> /// <param name="ordinal">The zero-based column ordinal.</param> /// <returns>This method returns default values for null database column values.</returns> public static T GetSafeValue <T>(this DbDataReader reader, int ordinal) { return(!reader.IsDBNull(ordinal) ? (T)reader.GetValue(ordinal) : default(T)); }
/// <summary> /// Load all values from DbDataReader /// </summary> /// <param name="reader">Reader from which to load all column values</param> public Donymous(DbDataReader reader) { for (int i = 0; i < reader.FieldCount; i++) this.memberValues[reader.GetName(i)] = reader.IsDBNull(i) ? null : reader.GetValue(i); }
/// <summary> /// Конструктор класса Workout /// </summary> public Workout(DbDataReader reader) { this._id = reader.GetValue(0).ToString() == "" ? (long)0 : reader.GetInt64(0); this._date = reader.GetValue(1).ToString() == "" ? (long)0 : reader.GetInt64(1); this._timeBegin = reader.GetValue(2).ToString() == "" ? (long)0 : reader.GetInt64(2); this._timeEnd = reader.GetValue(3).ToString() == "" ? (long)0 : reader.GetInt64(3); this._warmUp = reader.GetValue(4).ToString() == "" ? (byte)0 : reader.GetByte(4); this._musclesGroupId = reader.GetValue(5).ToString() == "" ? (Int16)0 : reader.GetInt16(5); this._workoutPlanId = reader.GetValue(6).ToString() == "" ? (long)0 : reader.GetInt64(6); this._workoutTypeId = reader.GetValue(7).ToString() == "" ? (Int16)0 : reader.GetInt16(7); this._athleteId = reader.GetValue(8).ToString() == "" ? (long)0 : reader.GetInt64(8); this._createDate = reader.GetValue(9).ToString() == "" ? (long)0 : reader.GetInt64(9); this._workoutPlanTypeId = reader.GetValue(10).ToString() == "" ? (Int16)0 : reader.GetInt16(10); }
public object GetFromDataReader(DbDataReader rset, int index) { return rset.GetValue(index) == DBNull.Value ? false : (bool) rset.GetValue(index); }
private static IEnumerable<object[]> Read(DbDataReader reader) { while (reader.Read()) { var values = new List<object>(); for (int i = 0; i < reader.FieldCount; i++) { values.Add(reader.GetValue(i)); } yield return values.ToArray(); } }
/// <summary> /// 根据模板将datareaser数据导成过滤指定列的EXCEL格式 /// </summary> /// <param name="dataReader">数据集</param> /// <param name="strFilePath">模板文件路径</param> /// <param name="intStartRow">起始行</param> /// <param name="strFileFullPath">全路径</param> /// <param name="arrFilterColumn">过滤指定列,列名(别名)列表</param> public static void ExportExcelByTemplate(DbDataReader dataReader, string strFilePath, int intStartRow, string strFileFullPath, string[] arrFilterColumn) { Workbook excelTemplate = new Workbook(); Workbook excel = new Workbook(); //建立excel并打开模板文件 excelTemplate.Open(strFilePath); int intSheetRowCount = 0; int intSheetCount = 0; excel.Worksheets[intSheetRowCount].Copy(excelTemplate.Worksheets[0]); Cells cells = excel.Worksheets[intSheetCount].Cells;// sheet.Cells; Object[] arrObj = new Object[dataReader.FieldCount];// List<string> list = null; if (arrFilterColumn != null) { list = new List<string>(arrFilterColumn);//过滤指定列,列名(别名)列表 } while (dataReader.Read()) { if (intSheetRowCount == IntPageSize) { excel.Worksheets.Add(); intSheetCount += 1; excel.Worksheets[intSheetCount].Copy(excelTemplate.Worksheets[0]); intSheetRowCount = 0; cells = excel.Worksheets[intSheetCount].Cells; } if (arrFilterColumn != null) { ArrayList arrList = new ArrayList(); for (int i = 0; i < dataReader.FieldCount; i++) { if (!Array.Exists(list.ToArray(), p => { return p.Equals(dataReader.GetName(i), StringComparison.OrdinalIgnoreCase); })) { arrList.Add(dataReader.GetValue((i))); } } Object[] arrObjTmp = arrList.ToArray(); cells.ImportObjectArray(arrObjTmp, intStartRow + intSheetRowCount, 0, false); } else { dataReader.GetValues(arrObj); cells.ImportObjectArray(arrObj, intStartRow + intSheetRowCount, 0, false); } intSheetRowCount += 1; } excel.Worksheets.Add(); excel.Save(strFileFullPath, SaveFormat.Auto); }
public string ReadString(DbDataReader reader, int index) { if (reader.IsDBNull(index)) return null; string str; Object obj = reader.GetValue(index); if (obj.GetType() == typeof(string)) str = (string)obj; else return obj.ToString(); return str; }
private bool MapValue(GroupResult<PosName> posName, DbDataReader reader, Func<object, object> converter, object instance, PocoColumn pocoColumn, object defaultValue) { if (!reader.IsDBNull(posName.Key.Pos)) { var value = converter != null ? converter(reader.GetValue(posName.Key.Pos)) : reader.GetValue(posName.Key.Pos); pocoColumn.SetValue(instance, value); return true; } if (_mappingOntoExistingInstance && defaultValue == null) { pocoColumn.SetValue(instance, null); } return false; }
public DateTime? ReadDateTime(DbDataReader reader, int index) { if (reader.IsDBNull(index)) return null; Object obj = reader.GetValue(index); if (obj.GetType() == typeof(DateTime)) return (DateTime)obj; else return Convert.ToDateTime(obj); }
internal static void FillCompatibleSettersFromReader(SmiEventSink_Default sink, SmiTypedGetterSetter setters, IList<SmiExtendedMetaData> metaData, DbDataReader reader) { for (int i = 0; i < metaData.Count; i++) { object sqlValue; DateTimeOffset dateTimeOffset; TimeSpan timeSpan; ExtendedClrTypeCode code; if (reader.IsDBNull(i)) { SetDBNull_Unchecked(sink, setters, i); continue; } switch (metaData[i].SqlDbType) { case SqlDbType.BigInt: { SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i)); continue; } case SqlDbType.Binary: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Bit: { SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i)); continue; } case SqlDbType.Char: { SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.DateTime: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.Decimal: { SqlDataReader reader6 = reader as SqlDataReader; if (reader6 == null) { break; } SetSqlDecimal_Unchecked(sink, setters, i, reader6.GetSqlDecimal(i)); continue; } case SqlDbType.Float: { SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i)); continue; } case SqlDbType.Image: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Int: { SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i)); continue; } case SqlDbType.Money: { SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i))); continue; } case SqlDbType.NChar: case SqlDbType.NText: case SqlDbType.NVarChar: { SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Real: { SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i)); continue; } case SqlDbType.UniqueIdentifier: { SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i)); continue; } case SqlDbType.SmallDateTime: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.SmallInt: { SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i)); continue; } case SqlDbType.SmallMoney: { SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i))); continue; } case SqlDbType.Text: { SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Timestamp: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.TinyInt: { SetByte_Unchecked(sink, setters, i, reader.GetByte(i)); continue; } case SqlDbType.VarBinary: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.VarChar: { SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Variant: { SqlDataReader reader4 = reader as SqlDataReader; if (reader4 == null) { goto Label_0311; } sqlValue = reader4.GetSqlValue(i); goto Label_0319; } case SqlDbType.Xml: { SqlDataReader reader5 = reader as SqlDataReader; if (reader5 == null) { goto Label_02E4; } SetSqlXml_Unchecked(sink, setters, i, reader5.GetSqlXml(i)); continue; } case SqlDbType.Udt: { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; } case SqlDbType.Date: case SqlDbType.DateTime2: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.Time: { SqlDataReader reader3 = reader as SqlDataReader; if (reader3 == null) { goto Label_03A0; } timeSpan = reader3.GetTimeSpan(i); goto Label_03AE; } case SqlDbType.DateTimeOffset: { SqlDataReader reader2 = reader as SqlDataReader; if (reader2 == null) { goto Label_03D5; } dateTimeOffset = reader2.GetDateTimeOffset(i); goto Label_03E2; } default: throw ADP.NotSupported(); } SetSqlDecimal_Unchecked(sink, setters, i, new SqlDecimal(reader.GetDecimal(i))); continue; Label_02E4: SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); continue; Label_0311: sqlValue = reader.GetValue(i); Label_0319: code = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(metaData[i].SqlDbType, metaData[i].IsMultiValued, sqlValue, null, 210L); SetCompatibleValueV200(sink, setters, i, metaData[i], sqlValue, code, 0, 0, null); continue; Label_03A0: timeSpan = (TimeSpan) reader.GetValue(i); Label_03AE: SetTimeSpan_Checked(sink, setters, i, metaData[i], timeSpan); continue; Label_03D5: dateTimeOffset = (DateTimeOffset) reader.GetValue(i); Label_03E2: SetDateTimeOffset_Unchecked(sink, setters, i, dateTimeOffset); } }
public TimeSpan? ReadTimeSpan(DbDataReader reader, int index) { if (reader.IsDBNull(index)) return null; Object obj = reader.GetValue(index); if (obj.GetType() == typeof(TimeSpan)) return (TimeSpan)obj; else return null; }
protected BondFuturesEODPriceRow GetBondFuturesEODPriceRow(DbDataReader reader) { BondFuturesEODPriceRow row = new BondFuturesEODPriceRow(); row.OBJECT_ID = this.GetString(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_OBJECT_ID))); row.S_INFO_WINDCODE = this.GetString(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_INFO_WINDCODE))); row.TRADE_DT = this.GetString(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_TRADE_DT))); row.S_DQ_PRESETTLE = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_PRESETTLE))); row.S_DQ_OPEN = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_OPEN))); row.S_DQ_HIGH = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_HIGH))); row.S_DQ_LOW = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_LOW))); row.S_DQ_CLOSE = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_CLOSE))); row.S_DQ_SETTLE = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_SETTLE))); row.S_DQ_VOLUME = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_VOLUME))); row.S_DQ_AMOUNT = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_AMOUNT))); row.S_DQ_OI = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_OI))); row.S_DQ_CHANGE = this.GetDouble(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_S_DQ_CHANGE))); row.OPDATE = this.GetDateTime(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_OPDATE))); row.OPMODE = this.GetString(reader.GetValue(reader.GetOrdinal(BondFuturesEODPriceRow.C_OPMODE))); return row; }
// Copy multiple fields from reader to SmiTypedGetterSetter // Supports V200 code path, without damaging backward compat for V100 code. // Main differences are supporting DbDataReader, and for binary, character, decimal and Udt types. // Assumes caller enforces that reader and setter metadata are compatible internal static void FillCompatibleSettersFromReader(SmiEventSink_Default sink, SmiTypedGetterSetter setters, IList<SmiExtendedMetaData> metaData, DbDataReader reader) { for (int i = 0; i < metaData.Count; i++) { if (reader.IsDBNull(i)) { ValueUtilsSmi.SetDBNull_Unchecked(sink, setters, i); } else { switch (metaData[i].SqlDbType) { case SqlDbType.BigInt: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int64)); SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i)); break; case SqlDbType.Binary: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Bit: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Boolean)); SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i)); break; case SqlDbType.Char: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray)); SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.DateTime: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime)); SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); break; case SqlDbType.Decimal: { // block to scope sqlReader local to avoid conflicts Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlDecimal)); // Support full fidelity for SqlDataReader SqlDataReader sqlReader = reader as SqlDataReader; if (null != sqlReader) { SetSqlDecimal_Unchecked(sink, setters, i, sqlReader.GetSqlDecimal(i)); } else { SetSqlDecimal_Unchecked(sink, setters, i, new SqlDecimal(reader.GetDecimal(i))); } } break; case SqlDbType.Float: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Double)); SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i)); break; case SqlDbType.Image: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Int: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int32)); SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i)); break; case SqlDbType.Money: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney)); SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i))); break; case SqlDbType.NChar: case SqlDbType.NText: case SqlDbType.NVarChar: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray)); SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Real: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Single)); SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i)); break; case SqlDbType.UniqueIdentifier: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Guid)); SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i)); break; case SqlDbType.SmallDateTime: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime)); SetDateTime_Checked(sink, setters, i,metaData[i], reader.GetDateTime(i)); break; case SqlDbType.SmallInt: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Int16)); SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i)); break; case SqlDbType.SmallMoney: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlMoney)); SetSqlMoney_Checked(sink, setters, i, metaData[i], new SqlMoney(reader.GetDecimal(i))); break; case SqlDbType.Text: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.CharArray)); SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Timestamp: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.TinyInt: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.Byte)); SetByte_Unchecked(sink, setters, i, reader.GetByte(i)); break; case SqlDbType.VarBinary: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.VarChar: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.String)); SetCharsOrString_FromReader(sink, setters, i, metaData[i], reader, 0); break; case SqlDbType.Xml: { Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.SqlXml)); SqlDataReader sqlReader = reader as SqlDataReader; if (null != sqlReader) { SetSqlXml_Unchecked(sink, setters, i, sqlReader.GetSqlXml(i)); } else { SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); } } break; case SqlDbType.Variant: { // block to scope sqlReader local and avoid conflicts // Support better options for SqlDataReader SqlDataReader sqlReader = reader as SqlDataReader; SqlBuffer.StorageType storageType = SqlBuffer.StorageType.Empty; object o; if (null != sqlReader) { o = sqlReader.GetSqlValue(i); storageType = sqlReader.GetVariantInternalStorageType(i); } else { o = reader.GetValue(i); } ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCodeForUseWithSqlDbType(metaData[i].SqlDbType, metaData[i].IsMultiValued, o, null, // SmiContextFactory.KatmaiVersion ); if ((storageType == SqlBuffer.StorageType.DateTime2) || (storageType == SqlBuffer.StorageType.Date)) SetCompatibleValueV200(sink, setters, i, metaData[i], o, typeCode, 0, 0, null, storageType); else SetCompatibleValueV200(sink, setters, i, metaData[i], o, typeCode, 0, 0, null); } break; case SqlDbType.Udt: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.ByteArray)); // Skip serialization for Udt types. SetBytes_FromReader(sink, setters, i, metaData[i], reader, 0); break; // SqlDbType.Structured should have been caught before this point for TVPs. SUDTs will still need to implement. case SqlDbType.Date: case SqlDbType.DateTime2: Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTime)); SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); break; case SqlDbType.Time: { // block to scope sqlReader local and avoid conflicts Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.TimeSpan)); SqlDataReader sqlReader = reader as SqlDataReader; TimeSpan ts; if (null != sqlReader) { ts = sqlReader.GetTimeSpan(i); } else { ts = (TimeSpan)reader.GetValue(i); } SetTimeSpan_Checked(sink, setters, i, metaData[i], ts); } break; case SqlDbType.DateTimeOffset: { // block to scope sqlReader local and avoid conflicts Debug.Assert(CanAccessSetterDirectly(metaData[i], ExtendedClrTypeCode.DateTimeOffset)); SqlDataReader sqlReader = reader as SqlDataReader; DateTimeOffset dto; if (null != sqlReader) { dto = sqlReader.GetDateTimeOffset(i); } else { dto = (DateTimeOffset)reader.GetValue(i); } SetDateTimeOffset_Unchecked(sink, setters, i, dto); } break; default: // In order for us to get here we would have to have an // invalid instance of SqlDbType, or one would have to add // new member to SqlDbType without adding a case in this // switch, hence the assert - it must be Debug.Assert(false, "unsupported DbType:" + metaData[i].SqlDbType.ToString()); throw ADP.NotSupported(); } } } }
/// <summary> /// Initializes a new instance of the VDataEntityList class. /// VDataEntityList implemented as case insensitive ListDictionary under hood. /// </summary> /// <param name="reader">Provides a way of reading a forward-only stream of rows from a SQL Server database</param> /// <returns>Initialized a new instance of the VDataEntityList class</returns> public static VDataEntityList Load(DbDataReader reader) { var list = new VDataEntityList(); if (reader != null && reader.HasRows && reader.Read()) { list = new VDataEntityList(); for (int i = 0; i < reader.FieldCount; i++) { list.Add(reader.GetName(i), reader.GetValue(i)); } } return list; }
private Person LoadPerson(DbDataReader reader) { Person p = new Person(); p.ID = reader.GetValue<int>("ID"); p.Name = reader.GetValue<string>("Name"); p.Age = reader.GetValue<int>("Age"); return p; }
public static dynamic consulta(string query, bool tipoSelect = false, bool eliminando = false) { var consulta = new List <Dictionary <string, object> >(); try { conexion.Open(); NpgsqlCommand cmd = new NpgsqlCommand(query, conexion); if (!tipoSelect) { System.Data.Common.DbDataReader datos = cmd.ExecuteReader(); while (datos.Read()) { Dictionary <string, object> objeto = new Dictionary <string, object>(); for (int x = 0; x < datos.FieldCount; x++) { objeto.Add(datos.GetName(x), datos.GetValue(x)); } consulta.Add(objeto); } // consulta.Clear(); // consulta = new List<Dictionary<string, object>>(); } else { try { cmd.ExecuteNonQuery(); conexion.Close(); cmd.Dispose(); return(true); } catch (Exception e) { if (eliminando) { return(false); } MessageBox.Show(e.Message, "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); conexion.Close(); return(false); } } conexion.Close(); } catch (Exception e) { if (eliminando) { return(false); } MessageBox.Show(e.Message, "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); conexion.Close(); } return(consulta); }
protected JsmxRow_SZ GetJsmxRow_SZ(DbDataReader reader) { JsmxRow_SZ row = new JsmxRow_SZ(); row.MXJSZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSZH))); row.MXBFZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXBFZH))); row.MXSJLX = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSJLX))); row.MXYWLB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYWLB))); row.MXZQDM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQDM))); row.MXJYDY = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYDY))); row.MXTGDY = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXTGDY))); row.MXZQZH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQZH))); row.MXDDBH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXDDBH))); row.MXYYB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYYB))); row.MXZXBH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZXBH))); row.MXYWLSH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYWLSH))); row.MXCJSL = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJSL))); row.MXQSSL = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSSL))); row.MXCJJG = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJJG))); row.MXQSJG = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSJG))); row.MXXYJY = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXXYJY))); row.MXPCBS = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXPCBS))); row.MXZQLB = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQLB))); row.MXZQZL = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQZL))); row.MXGFXZ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXGFXZ))); row.MXJSFS = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSFS))); row.MXHBDH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXHBDH))); row.MXQSBJ = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSBJ))); row.MXYHS = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXYHS))); row.MXJYJSF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYJSF))); row.MXJGGF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJGGF))); row.MXGHF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXGHF))); row.MXJSF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSF))); row.MXSXF = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSXF))); row.MXQSYJ = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSYJ))); row.MXQTFY = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQTFY))); row.MXZJJE = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZJJE))); row.MXSFJE = this.GetDouble(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSFJE))); row.MXCJRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCJRQ))); row.MXQSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQSRQ))); row.MXJSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJSRQ))); row.MXFSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXFSRQ))); row.MXQTRQ = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXQTRQ))); row.MXSCDM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXSCDM))); row.MXJYFS = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXJYFS))); row.MXZQDM2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXZQDM2))); row.MXTGDY2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXTGDY2))); row.MXDDBH2 = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXDDBH2))); row.MXCWDH = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXCWDH))); row.MXPPHM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXPPHM))); row.MXFJSM = this.GetString(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXFJSM))); row.MXBYBZ = this.GetChar(reader.GetValue(reader.GetOrdinal(JsmxRow_SZ.C_MXBYBZ))); return row; }
protected override object ReadInternal(DbDataReader reader, int ordinal, SqlRandomTableColumn columnInfo, Type asType) { return reader.GetValue(ordinal); }