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);
}
