public void Close()
{
if (ContainedReader != null)
{
ContainedReader.Close();
}
}
public virtual bool GetBool(string colName)
{
if (ContainedReader.IsDBNull(GetOrdinal(colName)))
{
return(false);
}
return(bool.Parse(ContainedReader[colName].ToString()));
}
public string GetName(int i)
{
try
{
return(ContainedReader.GetName(i));
}
catch (IndexOutOfRangeException e)
{
string msg = string.Format("Column index {0} does not exist in the resultset of SP {1}", i, sp.ProcName);
logger.Fatal(e, msg);
throw;
}
}
int GetOrdinal(string columnName)
{
try
{
return(ContainedReader.GetOrdinal(columnName));
}
catch (IndexOutOfRangeException e)
{
string msg = string.Format("Column {0} does not exist in the resultset of SP {1}", columnName, sp.ProcName);
logger.Fatal(e, msg);
throw;
}
}
public override string ToString()
{
StringBuilder sb = new StringBuilder("RowIndex=");
sb.Append(rowIndex).Append(" ");
for (int i = 0; i < ContainedReader.FieldCount; i++)
{
sb.Append(ContainedReader.GetName(i));
sb.AppendFormat("{0}=|{1}",
ContainedReader.GetName(i),
Utility.StringUtils.ToString(ContainedReader.GetProviderSpecificValue(i)));
if (i < ContainedReader.FieldCount - 1)
{
sb.Append(", ");
}
}
return(sb.ToString());
}
public virtual T GetValue <T>(string colName, T defaultValue)
{
if (ContainedReader.IsDBNull(GetOrdinal(colName)))
{
return(defaultValue);
}
Type t = typeof(T);
if (t == typeof(string))
{
return((T)Convert.ChangeType((string)ContainedReader[colName], t));
}
t = Nullable.GetUnderlyingType(t) ?? t;
if (t.IsEnum)
{
return((T)Enum.Parse(t, (string)ContainedReader[colName]));
}
else
{
return((T)Convert.ChangeType(ContainedReader[colName], t));
}
}
public virtual void Dispose()
{
ContainedReader.Dispose();
}
public bool NextResult()
{
return(ContainedReader.NextResult());
}
public virtual string GetString(int index)
{
return(ContainedReader.IsDBNull(index) ? null : ContainedReader[index].ToString().Trim());
}
public virtual byte GetByte(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column))
? (byte)0
: ((IConvertible)ContainedReader[column]).ToByte(null));
}
public decimal GetDecimal(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column))
? 0
: decimal.Parse(ContainedReader[column].ToString()));
}
public virtual double GetDouble(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column))
? 0
: double.Parse(ContainedReader[column].ToString()));
}
public float GetFloat(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column)) ? 0 : float.Parse(ContainedReader[column].ToString()));
}
public virtual short GetInt16(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column)) ? (short)0 : short.Parse(ContainedReader[column].ToString()));
}
public virtual int GetInt32(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column))
? 0
: ((IConvertible)ContainedReader[column]).ToInt32(null));
}
public virtual Guid GetGuid(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column)) ? Guid.Empty : (Guid)ContainedReader[column]);
}
public bool IsDBNull(string colName)
{
return(ContainedReader.IsDBNull(GetOrdinal(colName)));
}
public virtual DateTime GetDateTime(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column)) ? DateTime.MinValue : DateTime.Parse(ContainedReader[column].ToString()));
}
public char GetChar(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column)) ? char.MinValue : ContainedReader[column].ToString()[0]);
}
public virtual bool Read()
{
rowIndex++;
return(ContainedReader.Read());
}
public virtual byte[] GetByteArray(string column)
{
return(ContainedReader.IsDBNull(GetOrdinal(column))
? null
: ((byte[])ContainedReader[column]));
}
public virtual string GetString(string colName)
{
return(ContainedReader.IsDBNull(GetOrdinal(colName)) ? null : ContainedReader[colName].ToString().Trim());
}
