本文整理汇总了C#中OracleDataReader类的典型用法代码示例。如果您正苦于以下问题：C# OracleDataReader类的具体用法？C# OracleDataReader怎么用？C# OracleDataReader使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
OracleDataReader类属于命名空间，在下文中一共展示了OracleDataReader类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: PopulateDto
internal override DtoBase PopulateDto(OracleDataReader reader)
{
var turno = new TurnoDto();
//
if (!reader.IsDBNull(_ordTrnId)) { turno.TrnId = reader.GetInt32(_ordTrnId); }
//
if (!reader.IsDBNull(_ordTrnFecha)) { turno.TrnFecha = reader.GetString(_ordTrnFecha); }
//
if (!reader.IsDBNull(_ordTrnHora)) { turno.TrnHora = reader.GetString(_ordTrnHora); }
//
if (!reader.IsDBNull(_ordTrnMontoCobrado)) { turno.TrnMontoCobrado = reader.GetInt32(_ordTrnMontoCobrado); }
//
if (!reader.IsDBNull(_ordTrnEstId)) { turno.TrnEstId = reader.GetInt32(_ordTrnEstId); }
//
if (!reader.IsDBNull(_ordTrnProId)) { turno.TrnProId = reader.GetInt32(_ordTrnProId); }
//
if (!reader.IsDBNull(_ordTrnSesId)) { turno.TrnSesId = reader.GetInt32(_ordTrnSesId); }
//
if (!reader.IsDBNull(_ordTrnPaeId)) { turno.TrnPaeId = reader.GetInt32(_ordTrnPaeId); }
//
if (!reader.IsDBNull(_ordTrnDatId)) { turno.TrnDatId = reader.GetInt32(_ordTrnDatId); }
//
if (!reader.IsDBNull(_ordTrnOspId)) { turno.TrnOspId = reader.GetInt32(_ordTrnOspId); }
// IsNew
turno.IsNew = false;
return turno;
}示例2: SafeReadInt
/// <summary>
/// Safely reads int values from the database if they are null
/// </summary>
/// <param name="odr">oracle datareader</param>
/// <param name="colindex">column index</param>
/// <returns>-1 if null otherwise value from DB</returns>
int SafeReadInt(OracleDataReader odr, int colindex)
{
if (!odr.IsDBNull(colindex))
return odr.GetInt32(colindex);
else
return -1;
}示例3: ReadGroups
private IEnumerable<Group> ReadGroups(OracleDataReader reader)
{
var groups = new List<Group>();
Group group;
Group lastGroup = null;
Word word;
while ((group = ReadGroupWord(reader, out word)) != null)
{
if (lastGroup == null)
lastGroup = group;
if (lastGroup.Name != group.Name)
{
groups.Add(lastGroup);
lastGroup = group;
}
lastGroup.Words.Add(word);
}
if (lastGroup != null)
groups.Add(lastGroup);
return groups;
}示例4: PopulateOrdinals
internal override void PopulateOrdinals(OracleDataReader reader)
{
_ordTstId = reader.GetOrdinal("tstId");
_ordTstObservacion = reader.GetOrdinal("tstObservacion");
_ordTstZcuId = reader.GetOrdinal("tst_zcuId");
_ordTstTptId = reader.GetOrdinal("tst_tptId");
}示例5: PopulateOrdinals
internal override void PopulateOrdinals(OracleDataReader reader)
{
_ordVacId = reader.GetOrdinal("vacId");
_ordVacFechaDesde = reader.GetOrdinal("vacFechaDesde");
_ordVacFechaHasta = reader.GetOrdinal("vacFechaHasta");
_ordVacProId = reader.GetOrdinal("vac_proId");
}示例6: PopulateOrdinals
internal override void PopulateOrdinals(OracleDataReader reader)
{
_ordOspId = reader.GetOrdinal("ospId");
_ordOspPaeId = reader.GetOrdinal("osp_paeId");
_ordOspOsoId = reader.GetOrdinal("osp_osoId");
_ordOspNroSocio = reader.GetOrdinal("OspNroSocio");
}示例7: PopulateOrdinals
internal override void PopulateOrdinals(OracleDataReader reader)
{
_ordZcuId = reader.GetOrdinal("zcuId");
_ordZcuDescripcion = reader.GetOrdinal("zcuDescripcion");
_ordZcuNivel = reader.GetOrdinal("zcuNivel");
_ordZcuIdPadre = reader.GetOrdinal("zcuIdPadre");
}示例8: ReadPhrases
private IEnumerable<Phrase> ReadPhrases(OracleDataReader reader)
{
var phrases = new List<Phrase>();
Phrase phrase;
Phrase lastPhrase = null;
PhraseWord word;
while ((phrase = ReadPhraseWord(reader, out word)) != null)
{
if (lastPhrase == null)
lastPhrase = phrase;
if (lastPhrase.PhraseNumber != phrase.PhraseNumber)
{
phrases.Add(lastPhrase);
lastPhrase = phrase;
}
lastPhrase.Words.Add(word);
}
if (lastPhrase != null)
phrases.Add(lastPhrase);
return phrases;
}示例9: ReadRelations
private IEnumerable<Relation> ReadRelations(OracleDataReader reader)
{
var relations = new List<Relation>();
Relation relation;
Relation lastRelation = null;
Pair pair;
while ((relation = ReadRelationPair(reader, out pair)) != null)
{
if (lastRelation == null)
lastRelation = relation;
if (lastRelation.Name != relation.Name)
{
relations.Add(lastRelation);
lastRelation = relation;
}
lastRelation.Pairs.Add(pair);
}
if (lastRelation != null)
relations.Add(lastRelation);
return relations;
}示例10: SafeReadString
/// Safely reads string values from the database if they are null
///<returns>empty string otherwise value from DB</returns>
string SafeReadString(OracleDataReader odr, int colindex)
{
if (!odr.IsDBNull(colindex))
return odr.GetString(colindex);
else
return string.Empty;
}示例11: SafeReadDateTime
/// Safely reads datetime values from the database if they are null
///<returns>datetime minimimvalue if null otherwise value from DB</returns>
DateTime SafeReadDateTime(OracleDataReader odr, int colindex)
{
if (!odr.IsDBNull(colindex))
return odr.GetDateTime(colindex);
else
return DateTime.MinValue;
}示例12: PopulateOrdinals
internal override void PopulateOrdinals(OracleDataReader reader)
{
_ordAfnId = reader.GetOrdinal("afnId");
_ordAfnDescripcion = reader.GetOrdinal("afnDescripcion");
_ordAfnTafId = reader.GetOrdinal("afn_tafId");
_ordAfnZcuId = reader.GetOrdinal("afn_zcuId");
}示例13: PopulateDto
internal override DtoBase PopulateDto(OracleDataReader reader)
{
var turno = new TurneroDto();
//
if (!reader.IsDBNull(_ordTurId)) { turno.TurId = reader.GetInt32(_ordTurId); }
//
if (!reader.IsDBNull(_ordTurTitulo)) { turno.TurTitulo = reader.GetString(_ordTurTitulo); }
//
if (!reader.IsDBNull(_ordTurDescripcion)) { turno.TurDescripcion = reader.GetString(_ordTurDescripcion); }
//
if (!reader.IsDBNull(_ordTurFechaIni)) { turno.TurFechaIni = reader.GetDateTime(_ordTurFechaIni); }
//
if (!reader.IsDBNull(_ordTurFechaFin)) { turno.TurFechaFin = reader.GetDateTime(_ordTurFechaFin); }
//
if (!reader.IsDBNull(_ordTurTodoDia)) { turno.TurTodoDia = reader.GetString(_ordTurTodoDia); }
//
if (!reader.IsDBNull(_ordTurPae)) { turno.TurPae = reader.GetInt32(_ordTurPae); }
//
if (!reader.IsDBNull(_ordTurPro)) { turno.TurPro= reader.GetInt32(_ordTurPro); }
//
if (!reader.IsDBNull(_ordTurMonto)) { turno.TurMonto = reader.GetDecimal(_ordTurMonto); }
//
if (!reader.IsDBNull(_ordTurOspId)) { turno.TurOspId = reader.GetInt32(_ordTurOspId); }
// IsNew
turno.IsNew = false;
return turno;
}示例14: ReadSequenceValue
private int ReadSequenceValue(OracleDataReader reader)
{
if (!reader.Read())
return 0;
return (int)(decimal)reader[SequenceValueColumn];
}示例15: GetInfo
public static Employee GetInfo(OracleDataReader reader, DPFP.Sample Sample, string Finger)
{
OracleConnection conn = new OracleConnection(ConStr);
Employee _info = null;
DPFP.Template _template = null;
bool IsFound = false;
if (reader[Finger] != DBNull.Value)
{
_template = Util.ProcessDBTemplate((byte[])reader[Finger]);
IsFound = Util.Verify(Sample, _template);
}
if (IsFound == true)
{
string sqlEmp = "select * from employees where Empl_Id_No=" + reader["Empl_Id_No"];
OracleCommand cmd = new OracleCommand(sqlEmp, conn);
cmd.CommandType = CommandType.Text;
conn.Open();
OracleDataReader odr = cmd.ExecuteReader();
if (odr.HasRows)
{
_info = new Employee();
_info.Empl_Id_No = Convert.ToInt32(reader["Empl_Id_No"]);
_info.Empl_Name = (string)odr["Empl_Name"];
_info.Empl_Deptname = (string)odr["Empl_Deptname"];
_info.Shift_Id = Convert.ToInt32(odr["Shift_Id"]);
}
odr.Dispose();
cmd.Dispose();
conn.Close();
conn.Dispose();
}
return _info;
}