public ResourceRecord(DbDataReader reader) { Page = reader.GetString(reader.GetOrdinal("resourcepage")); CultureCode = reader.GetString(reader.GetOrdinal("culturecode")); Key = reader.GetString(reader.GetOrdinal("resourcekey")); Value = reader.GetString(reader.GetOrdinal("resourcevalue")); }
protected override void MappingData(System.Data.Common.DbDataReader reader) { _id = (Guid)reader["PageId"]; _name = (string)reader["PageName"]; _title = (string)reader["PageTitle"]; if (!reader.IsDBNull(reader.GetOrdinal("PageLanguage"))) { _language = (int)reader["PageLanguage"]; } if (!reader.IsDBNull(reader.GetOrdinal("PageTemplate"))) { _template = (int)reader["PageTemplate"]; } }
protected Conversation GetCurrentConversation(DbDataReader reader) { int colID = reader.GetOrdinal("grupoid_grupo"); int colName = reader.GetOrdinal("nombre"); Conversation conversation = new Conversation(); if (!reader.IsDBNull(colID)) { conversation.ID = reader.GetInt32(colID); } if (!reader.IsDBNull(colName)) { conversation.Name = reader.GetString(colName); } return conversation; }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> protected static string GetTableType(DbDataReader reader) { const string TABLE_TYPE = @"TABLE_TYPE"; var ordinal = reader.GetOrdinal(TABLE_TYPE); var type = reader.GetString(ordinal); return type; }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> protected static string GetTableName(DbDataReader reader) { const string TABLE_NAME = @"TABLE_NAME"; var ordinal = reader.GetOrdinal(TABLE_NAME); var name = reader.GetString(ordinal); return name; }
protected override void MappingData(System.Data.Common.DbDataReader reader) { if (!reader.IsDBNull(reader.GetOrdinal("VoteQuestionId"))) { _id = (Guid)reader["VoteQuestionId"]; } if (!reader.IsDBNull(reader.GetOrdinal("VoteQuestionName"))) { _name = (string)reader["VoteQuestionName"]; } if (!reader.IsDBNull(reader.GetOrdinal("SubDomainId"))) { _SubDomainId = (Guid)reader["SubDomainId"]; } if (!reader.IsDBNull(reader.GetOrdinal("IsActive"))) { _isActive = (bool)reader["IsActive"]; } }
protected override void MappingData(System.Data.Common.DbDataReader reader) { if (!reader.IsDBNull(reader.GetOrdinal("Id"))) { Id = (Guid)reader["Id"]; } if (!reader.IsDBNull(reader.GetOrdinal("Title"))) { Title = (string)reader["Title"]; } if (!reader.IsDBNull(reader.GetOrdinal("Path"))) { Path = (string)reader["Path"]; } if (!reader.IsDBNull(reader.GetOrdinal("CreationDate"))) { CreationDate = (DateTime)reader["CreationDate"]; CreationDateString = string.Format("{0:dd/MM/yyyy}", (DateTime)reader["CreationDate"]); } if (!reader.IsDBNull(reader.GetOrdinal("Priority"))) { Priority = (int)reader["Priority"]; } if (!reader.IsDBNull(reader.GetOrdinal("FileExtension"))) { FileExtension = (string)reader["FileExtension"]; } }
static int GetOrdinal(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)); string arg0 = ToLua.CheckString(L, 2); int o = obj.GetOrdinal(arg0); LuaDLL.lua_pushinteger(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; }
protected override object GetValue(System.Data.Common.DbDataReader reader, PropertyInfo property) { var oracleReader = (reader as OracleDataReader); int ord = reader.GetOrdinal(property.Name); if (reader.IsDBNull(ord)) { return(null); } if (oracleReader.GetFieldType(ord) == typeof(decimal)) { return(GetDecimal(oracleReader, ord, property)); } else { return(oracleReader[property.Name]); } }
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); } }
private void mapValues(DbDataReader reader, object record) { foreach (var accessor in this.accessors) { var index = reader.GetOrdinal(accessor.Name); if (reader.IsDBNull(index)) { continue; } if (accessor.PropertyType == typeof(string)) { accessor.Set(record, reader.GetString(index)); } else if (accessor.PropertyType == typeof(int) || accessor.PropertyType == typeof(int?)) { accessor.Set(record, reader.GetInt32(index)); } else if (accessor.PropertyType == typeof(long) || accessor.PropertyType == typeof(long?)) { accessor.Set(record, reader.GetInt64(index)); } else if (accessor.PropertyType == typeof(DateTime) || accessor.PropertyType == typeof(DateTime?)) { accessor.Set(record, reader.GetDateTime(index)); } else if (accessor.PropertyType == typeof(char) || accessor.PropertyType == typeof(char?)) { accessor.Set(record, reader.GetChar(index)); } } }
//public override void Export2TradeTable(DbDataReader reader, IExportCallback callback, IExport2TradeTable tradeService) //{ // if (reader == null) // return; // TradeTable tradeTable = new TradeTable(); // if (!tradeTable.Open()) // return; // OrderRowService_LH lhService = new OrderRowService_LH(this.TheProject); // TradeInfo_O32Service o32Service = new TradeInfo_O32Service(this.TheProject); // if (!lhService.Open() || !o32Service.Open()) // { // tradeTable.Close(); // lhService.Close(); // o32Service.Close(); // return; // } // // 特别说明: // // 在加载结算明细表中的时候的时候需要从量化系统和O32系统中读取相关的数据进行比较, // // 在读取其他系统数据的时候会出现两个问题: // // 1、如果一次性把其他系统中的数据全部加载到内存,如果数据量过大,则会撑爆内存; // // 2、如果在根据需要实时的从其他系统相关数据表中读取数据,效率太低,导入速度太慢了; // // 3、所以采用一个折中的办法,设置一个临界值,如果大于该临界值,则采用实时加载的方法,否则一次性读取依赖数据; // bool bufferAll_lh = false; // bool bufferAll_o32 = false; // List<OrderRow_LH> buffer_lh = null; // List<TradeInfo_O32> buffer_o32 = null; // List<OrderRow_LH> lhDataList = null; // List<TradeInfo_O32> o32DataList = null; // string securityId = string.Empty; // lhService.SyncImportState2Local(); // if (lhService.TotalCount < this.MaxBufferSize) // { // bufferAll_lh = true; // buffer_lh = lhService.GetTradeItems(EMarketType.ALL); // } // o32Service.SyncImportState2Local(); // if (o32Service.TotalCount < this.MaxBufferSize) // { // bufferAll_o32 = true; // buffer_o32 = o32Service.GetTradeItems(EMarketType.ALL); // } // while (reader.Read()) // { // if (this.TheProject.HasStop) // { // tradeService.ImportState = EImportStatus.Interrupt; // break; // } // CilRow row = this.GetCilRow(reader); // if (securityId != row.ZQDM) // { // securityId = row.ZQDM; // if (bufferAll_lh) // lhDataList = buffer_lh.Where(o => o.zqdm == securityId).ToList(); // else // lhDataList = lhService.GetTradeItems(row.ZQDM, EMarketType.ALL); // if (bufferAll_o32) // o32DataList = buffer_o32.Where(o => o.VC_REPORT_CODE == securityId).ToList(); // else // o32DataList = o32Service.GetTradeItems(row.ZQDM, EMarketType.ALL); // } // //EEntrustType entrustType = this.GetEntrustType(row); // if (lhDataList.Count <= 0 && o32DataList.Count <= 0) // { // tradeTable.Add(this.GetTradeRow(row)); // callback.ValidIndex++; // } // callback.CurrentIndex++; // } // tradeTable.Close(); // lhService.Close(); // o32Service.Close(); //} protected CilRow GetCilRow(DbDataReader reader) { CilRow row = new CilRow(); row.JJDM = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_JJDM))); row.ZJLX = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_ZJLX))); row.ZQZH = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_ZQZH))); row.JYXW = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_JYXW))); row.XWHY = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_XWHY))); row.TKJE = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_TKJE))); row.BKJE = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_BKJE))); row.JSRQ = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_JSRQ))); row.JYRQ = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_JYRQ))); row.ZQDM = this.GetString(reader.GetValue(reader.GetOrdinal(CilRow.C_ZQDM))); return row; }
public TimeSpan? ReadTimeSpan(DbDataReader reader, string name) { int ordinal = reader.GetOrdinal(name); return ReadTimeSpan(reader, ordinal); }
public int? ReadInt(DbDataReader reader, string name) { int ordina = reader.GetOrdinal(name); return ReadInt(reader, ordina); }
public DateTime? ReadDateTime(DbDataReader reader, string name) { int ordinal = reader.GetOrdinal(name); return ReadDateTime(reader, ordinal); }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private DeptInfo BuilderEntity(DbDataReader reader) { DeptInfo info = new DeptInfo(); info.DeptId = (reader.IsDBNull(reader.GetOrdinal("deptid"))) ? "" : reader["deptid"].ToString(); info.DeptName = (reader.IsDBNull(reader.GetOrdinal("deptname"))) ? "" : reader["deptname"].ToString(); info.ParentId = (reader.IsDBNull(reader.GetOrdinal("parentid"))) ? "" : reader["parentid"].ToString(); info.Remark = (reader.IsDBNull(reader.GetOrdinal("remark"))) ? "" : reader["remark"].ToString(); info.DeptType = (reader.IsDBNull(reader.GetOrdinal("DEPTTYPE"))) ? "" : reader["DEPTTYPE"].ToString(); return info; }
private LogEntry ReadEntry(DbDataReader dataReader) { var entry = new LogEntry(); int idOrd = dataReader.GetOrdinal("ID"); entry.ID = dataReader.GetFieldValue<int>(idOrd); int applicationOrd = dataReader.GetOrdinal("Application"); entry.Application = dataReader.IsDBNull(applicationOrd) ? null : dataReader.GetFieldValue<string>(applicationOrd); int machineOrd = dataReader.GetOrdinal("MachineName"); entry.MachineName = dataReader.IsDBNull(machineOrd) ? null : dataReader.GetFieldValue<string>(machineOrd); int timestampOrd = dataReader.GetOrdinal("TimeStamp"); entry.TimeStamp = dataReader.GetFieldValue<DateTime>(timestampOrd); int threadOrd = dataReader.GetOrdinal("Thread"); entry.Thread = dataReader.IsDBNull(threadOrd) ? null : dataReader.GetFieldValue<string>(threadOrd); int levelOrd = dataReader.GetOrdinal("Level"); entry.Level = dataReader.IsDBNull(levelOrd) ? null : dataReader.GetFieldValue<string>(levelOrd); int loggerOrd = dataReader.GetOrdinal("Logger"); entry.Logger = dataReader.IsDBNull(loggerOrd) ? null : dataReader.GetFieldValue<string>(loggerOrd); int messageOrd = dataReader.GetOrdinal("Message"); entry.Message = dataReader.IsDBNull(messageOrd) ? null : dataReader.GetFieldValue<string>(messageOrd); int exceptionOrd = dataReader.GetOrdinal("Exception"); entry.Exception = dataReader.IsDBNull(exceptionOrd) ? null : dataReader.GetFieldValue<string>(exceptionOrd); int ntUserOrd = dataReader.GetOrdinal("NTUser"); entry.NTUser = dataReader.IsDBNull(ntUserOrd) ? null : dataReader.GetFieldValue<string>(ntUserOrd); return entry; }
private int GetColumnOrdinal(UpdateTranslator translator, DbDataReader reader, string columnName) { int columnOrdinal; try { columnOrdinal = reader.GetOrdinal(columnName); } catch (IndexOutOfRangeException) { throw EntityUtil.Update(System.Data.Entity.Strings.Update_MissingResultColumn(columnName), null, this.GetStateEntries(translator)); } return columnOrdinal; }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private DictInfo BuilderEntity(DbDataReader reader) { DictInfo info = new DictInfo(); info.Code = (reader.IsDBNull(reader.GetOrdinal("code"))) ? "" : reader["code"].ToString(); info.Name = (reader.IsDBNull(reader.GetOrdinal("name"))) ? "" : reader["name"].ToString(); info.Remark = (reader.IsDBNull(reader.GetOrdinal("remark"))) ? "" : reader["remark"].ToString(); info.Sort = (reader.IsDBNull(reader.GetOrdinal("sort"))) ? 0 : decimal.Parse(reader["sort"].ToString()); info.IsEnable = (reader.IsDBNull(reader.GetOrdinal("isenable"))) ? "" : reader["isenable"].ToString(); info.TypeCode = (reader.IsDBNull(reader.GetOrdinal("type"))) ? "" : reader["type"].ToString(); info.TypeName = (reader.IsDBNull(reader.GetOrdinal("typename"))) ? "" : reader["typename"].ToString(); return info; }
/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private DictTypeInfo BuilderDictType(DbDataReader reader) { DictTypeInfo info = new DictTypeInfo(); info.Code = (reader.IsDBNull(reader.GetOrdinal("code"))) ? "" : reader["code"].ToString(); info.Name = (reader.IsDBNull(reader.GetOrdinal("name"))) ? "" : reader["name"].ToString(); return info; }
protected ChinaETFPchRedmRow GetChinaETFPchRedmListRow(DbDataReader reader) { ChinaETFPchRedmRow row = new ChinaETFPchRedmRow(); row.OBJECT_ID = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_OBJECT_ID))); row.S_INFO_WINDCODE = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_S_INFO_WINDCODE))); row.TRADE_DT = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_TRADE_DT))); row.F_INFO_CASHDIF = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_CASHDIF))); row.F_INFO_MINPRASET = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_MINPRASET))); row.F_INFO_ESTICASH = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_ESTICASH))); row.F_INFO_CASHSUBUPLIMIT = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_CASHSUBUPLIMIT))); row.F_INFO_MINPRUNITS = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_MINPRUNITS))); row.F_INFO_PRPERMIT = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_PRPERMIT))); row.F_INFO_CONNUM = this.GetDouble(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_F_INFO_CONNUM))); row.OPDATE = this.GetDateTime(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_OPDATE))); row.OPMODE = this.GetString(reader.GetValue(reader.GetOrdinal(ChinaETFPchRedmRow.C_OPMODE))); return row; }
public TradeInfo_O32 GetTradeInfo(DbDataReader reader) { TradeInfo_O32 row = new TradeInfo_O32(); //1-10 row.VC_STOCK_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_STOCK_NAME))); row.VC_THIRD_REFF = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_THIRD_REFF))); row.C_BUSIN_CLASS = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_BUSIN_CLASS))); row.L_ENTRUST_SERIAL_NO = this.GetLong(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_ENTRUST_SERIAL_NO))); row.VC_DEAL_NO = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_DEAL_NO))); row.L_DATE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_DATE))); row.L_FUND_ID = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_FUND_ID))); row.VC_COMBI_NO = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_COMBI_NO))); row.VC_COMBI_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_COMBI_NAME))); row.L_BUSINESS_TIME = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_BUSINESS_TIME))); // 11-20 row.C_ENTRUST_DIRECTION = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_ENTRUST_DIRECTION))); row.VC_REPORT_DIRECTION = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_REPORT_DIRECTION))); row.VC_ENTRUSTDIR_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_ENTRUSTDIR_NAME))); row.L_DEAL_AMOUNT = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_DEAL_AMOUNT))); row.EN_DEAL_PRICE = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_DEAL_PRICE))); row.EN_DEAL_BALANCE = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_DEAL_BALANCE))); row.VC_REPORT_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_REPORT_CODE))); row.VC_STOCKHOLDER_ID = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_STOCKHOLDER_ID))); row.VC_REPORT_SEAT = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_REPORT_SEAT))); row.VC_OPERATOR_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_OPERATOR_NAME))); // 21-30 row.VC_CURRENCY_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_CURRENCY_NAME))); row.C_INVEST_TYPE = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_INVEST_TYPE))); row.VC_FUND_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_FUND_NAME))); row.VC_CURRENCY_NO_BB = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_CURRENCY_NO_BB))); row.EN_DEAL_BALANCE_BB = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_DEAL_BALANCE_BB))); row.EN_DEAL_RATIO = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_DEAL_RATIO))); row.VC_BROKER_NO = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_BROKER_NO))); row.VC_BROKER_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_BROKER_NAME))); row.VC_GROUPTYPE_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_GROUPTYPE_NAME))); row.VC_GROUP_NAME = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_GROUP_NAME))); // 31-41 row.VC_INTERNATIONAL_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_INTERNATIONAL_CODE))); row.VC_RIC_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_RIC_CODE))); row.VC_SEDOL_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_SEDOL_CODE))); row.VC_CUSIP_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_CUSIP_CODE))); row.VC_BLOOMBERG_CODE = this.GetString(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_VC_BLOOMBERG_CODE))); row.L_REPORT_SERIAL_NO = this.GetLong(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_REPORT_SERIAL_NO))); row.C_MARKET_NO = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_MARKET_NO))); row.EN_FULL_BALANCE = this.GetDouble(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_EN_FULL_BALANCE))); row.L_DIRECT_OPERATOR = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_DIRECT_OPERATOR))); row.L_DIRECT_INSTEAD_OPERATOR = this.GetInt(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_L_DIRECT_INSTEAD_OPERATOR))); row.C_MARGINED_OUT = this.GetChar(reader.GetValue(reader.GetOrdinal(TradeInfo_O32.C_C_MARGINED_OUT))); return row; }
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(); } }
protected Message GetCurrentMessage(DbDataReader reader) { int colID = reader.GetOrdinal("id_mensaje"); int colSender = reader.GetOrdinal("id_usuario_emisor"); int colConversation = reader.GetOrdinal("id_grupo"); int colContent = reader.GetOrdinal("mensaje"); int colDate = reader.GetOrdinal("fecha"); int colType = reader.GetOrdinal("tipo"); Message message = new Message(); if (!reader.IsDBNull(colID)) { message.ID = reader.GetInt32(colID); } if (!reader.IsDBNull(colSender)) { message.Sender = reader.GetInt32(colSender); } if (!reader.IsDBNull(colConversation)) { message.Conversation = reader.GetInt32(colConversation); } if (!reader.IsDBNull(colContent)) { message.Content = reader.GetString(colContent); } if (!reader.IsDBNull(colDate)) { message.Date = reader.GetDateTime(colDate); } if (!reader.IsDBNull(colType)) { message.Type = reader.GetString(colType); } return message; }
private int GetColumnOrdinal(UpdateTranslator translator, DbDataReader reader, string columnName) { int columnOrdinal; try { columnOrdinal = reader.GetOrdinal(columnName); } catch (IndexOutOfRangeException) { throw new UpdateException( Strings.Update_MissingResultColumn(columnName), null, GetStateEntries(translator).Cast<ObjectStateEntry>().Distinct()); } return columnOrdinal; }
protected Event GetCurrentEvent(DbDataReader reader) { int colID = reader.GetOrdinal("id_evento"); int colCreator = reader.GetOrdinal("id_usuario"); int colTitle = reader.GetOrdinal("nombre"); int colDescription = reader.GetOrdinal("descripcion"); int colIniDate = reader.GetOrdinal("fecha_ini"); int colFinDate = reader.GetOrdinal("fecha_end"); Event e = new Event(); if (!reader.IsDBNull(colID)) { e.ID = reader.GetInt32(colID); } if (!reader.IsDBNull(colCreator)) { e.Creator = reader.GetInt32(colCreator); } if (!reader.IsDBNull(colTitle)) { e.Title = reader.GetString(colTitle); } if (!reader.IsDBNull(colDescription)) { e.Description = reader.GetString(colDescription); } if (!reader.IsDBNull(colIniDate)) { e.IniDate = reader.GetDateTime(colIniDate); } if (!reader.IsDBNull(colFinDate)) { e.FinDate = reader.GetDateTime(colFinDate); } return e; }
/// <summary> /// Given a store datareader and a column name, try to find the column ordinal /// in the datareader with the name of the column. /// </summary> /// <param name="storeDataReader"></param> /// <param name="columnName"></param> /// <param name="ordinal"></param> /// <returns>true if found, false otherwise.</returns> private static bool TryGetColumnOrdinalFromReader(DbDataReader storeDataReader, string columnName, out int ordinal) { if (0 == storeDataReader.FieldCount) { // If there are no fields, there can't be a match (this check avoids // an InvalidOperationException on the call to GetOrdinal) ordinal = default(int); return false; } // Wrap ordinal lookup for the member so that we can throw a nice exception. try { ordinal = storeDataReader.GetOrdinal(columnName); return true; } catch (IndexOutOfRangeException) { // No column matching the column name found ordinal = default(int); return false; } }
public static T GetValueOrDefault <T>(this DbDataReader reader, string name) { var idx = reader.GetOrdinal(name); return(reader.IsDBNull(idx) ? default : reader.GetFieldValue <T>(idx)); }
internal static List<OfferDetails> GetOfferDetailObject(DbDataReader reader) { OfferDetails hooOffer = null; List<OfferDetails> allOffers = new List<OfferDetails>(); while (reader.Read()) { hooOffer = new OfferDetails(); hooOffer.OfferId = reader.IsDBNull(reader.GetOrdinal("OfferId")) ? 0 : Convert.ToInt32(reader["OfferId"], CultureInfo.InvariantCulture); hooOffer.OfferTitle = reader.IsDBNull(reader.GetOrdinal("OfferTitle")) ? string.Empty : Convert.ToString(reader["OfferTitle"], CultureInfo.InvariantCulture); hooOffer.OfferDescription = reader.IsDBNull(reader.GetOrdinal("OfferDescription")) ? string.Empty : Convert.ToString(reader["OfferDescription"], CultureInfo.InvariantCulture); hooOffer.ImageUrl = reader.IsDBNull(reader.GetOrdinal("OfferImageUrl")) ? string.Empty : Convert.ToString(reader["OfferImageUrl"], CultureInfo.InvariantCulture); hooOffer.StartDate = reader.IsDBNull(reader.GetOrdinal("StartDate")) ? DateTime.Now : Convert.ToDateTime(reader["StartDate"], CultureInfo.InvariantCulture); hooOffer.ExpireDate = reader.IsDBNull(reader.GetOrdinal("ExpireDate")) ? DateTime.Now : Convert.ToDateTime(reader["ExpireDate"], CultureInfo.InvariantCulture); hooOffer.comments = reader.IsDBNull(reader.GetOrdinal("Comments")) ? string.Empty : Convert.ToString(reader["Comments"], CultureInfo.InvariantCulture); hooOffer.Latitude = reader.IsDBNull(reader.GetOrdinal("Latitude")) ? 0 : Convert.ToDouble(reader["Latitude"], CultureInfo.InvariantCulture); hooOffer.Longitude = reader.IsDBNull(reader.GetOrdinal("Longitude")) ? 0 : Convert.ToDouble(reader["Longitude"], CultureInfo.InvariantCulture); hooOffer.City = reader.IsDBNull(reader.GetOrdinal("City")) ? string.Empty : Convert.ToString(reader["City"], CultureInfo.InvariantCulture); hooOffer.OfferCategory = reader.IsDBNull(reader.GetOrdinal("OfferCategory")) ? string.Empty : Convert.ToString(reader["OfferCategory"], CultureInfo.InvariantCulture); hooOffer.PromoCode = reader.IsDBNull(reader.GetOrdinal("PromoCode")) ? string.Empty : Convert.ToString(reader["PromoCode"], CultureInfo.InvariantCulture); hooOffer.Ratings = reader.IsDBNull(reader.GetOrdinal("SumOfRating")) ? 0 : Convert.ToInt32(reader["SumOfRating"], CultureInfo.InvariantCulture); hooOffer.Vendor = new Supplier(); hooOffer.Vendor.SupplierId = reader.IsDBNull(reader.GetOrdinal("SupplierId")) ? 0 : Convert.ToInt32(reader["SupplierId"], CultureInfo.InvariantCulture); hooOffer.Vendor.SupplierName = reader.IsDBNull(reader.GetOrdinal("SupName")) ? string.Empty : Convert.ToString(reader["SupName"], CultureInfo.InvariantCulture); hooOffer.Vendor.ContactNumber = reader.IsDBNull(reader.GetOrdinal("SupContactNumber")) ? string.Empty : Convert.ToString(reader["SupContactNumber"], CultureInfo.InvariantCulture); hooOffer.Vendor.Email = reader.IsDBNull(reader.GetOrdinal("SupEmailId")) ? string.Empty : Convert.ToString(reader["SupEmailId"], CultureInfo.InvariantCulture); hooOffer.Vendor.ImageUrl = ConfigurationManager.AppSettings["ImageFolder"].ToString(); hooOffer.Vendor.ImageUrl += reader.IsDBNull(reader.GetOrdinal("SupImageURL")) ? string.Empty : Convert.ToString(reader["SupImageURL"], CultureInfo.InvariantCulture); hooOffer.Vendor.SupplierAddress = reader.IsDBNull(reader.GetOrdinal("SupAddress")) ? string.Empty : Convert.ToString(reader["SupAddress"], CultureInfo.InvariantCulture); allOffers.Add(hooOffer); } reader.Close(); return allOffers; }
private string ValueFromReader(DbDataReader reader, String field) { string val = null; int col = reader.GetOrdinal(field); if (col >=0) { if (!reader.IsDBNull(col)) val = reader.GetString(col); } return val; }
public double? ReadDouble(DbDataReader reader, string name) { int ordina = reader.GetOrdinal(name); return ReadDouble(reader, ordina); }
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; }
public string ReadString(DbDataReader reader, string name) { int ordina = reader.GetOrdinal(name); return ReadString(reader, ordina); }
protected User GetCurrentUser(DbDataReader reader) { int colID = reader.GetOrdinal("id_usuario"); int colUsername = reader.GetOrdinal("username"); int colEmail = reader.GetOrdinal("email"); int colName = reader.GetOrdinal("nombre"); int colLastName1 = reader.GetOrdinal("primer_apellido"); int colLastName2 = reader.GetOrdinal("segundo_apellido"); User user = new User(); if (!reader.IsDBNull(colID)) { user.ID = reader.GetInt32(colID); } if (!reader.IsDBNull(colUsername)) { user.Username = reader.GetString(colUsername); } if (!reader.IsDBNull(colEmail)) { user.Email = reader.GetString(colEmail); } if (!reader.IsDBNull(colName)) { user.Name = reader.GetString(colName); } if (!reader.IsDBNull(colLastName1)) { user.LastName1 = reader.GetString(colLastName1); } if (!reader.IsDBNull(colLastName2)) { user.LastName2 = reader.GetString(colLastName2); } return user; }
/// <summary> /// 获取指定名字的列 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="reader"></param> /// <param name="key"></param> /// <returns></returns> public static T Get <T>(this System.Data.Common.DbDataReader reader, string key) { var ordinal = reader.GetOrdinal(key); return(reader.GetFieldValue <T>(ordinal)); }
/// <summary> /// 获取指定名字的列 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="reader"></param> /// <param name="key"></param> /// <returns></returns> public static async Task <T> GetAsync <T>(this System.Data.Common.DbDataReader reader, string key) { var ordinal = reader.GetOrdinal(key); return(await reader.GetFieldValueAsync <T>(ordinal)); }
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; }
public void Build(DbDataReader reader) { var tableSchema = reader.GetSchemaTable(); if (tableSchema == null) { return; } FetchTableColumnsName(tableSchema); //reader.Read(); BuildHandle((colName, property) => { var propertyType = property.PropertyType; var exists = CurrentTableSchemaColumnsName.Find(s => String.Equals(s, colName, StringComparison.InvariantCultureIgnoreCase)); if (String.IsNullOrWhiteSpace(exists)) { return false; } var index = reader.GetOrdinal(exists); try { if (reader.IsDBNull(index)) { return false; } var value = ChangeType(reader.GetValue(index), propertyType); property.SetValue(this, value, null); } catch (Exception ex) { Error.ErrorCode = ErrorMapping.BUSINESS_FFFF; Error.SimpleErrorDescription = ex.Message; return false; } return true; }); }