public string FetchString(SqlDataReader reader, int iField, string sDefaultValue)
{
if (reader.IsDBNull(iField))
{
return(sDefaultValue);
}
else if (reader.GetFieldType(iField) == typeof(System.Boolean))
{
return(ZData.FetchString(reader.GetBoolean(iField)));
}
else if (reader.GetFieldType(iField) == typeof(System.DateTime))
{
return(ZData.FetchString(reader.GetDateTime(iField)));
}
else
{
return(reader.GetValue(iField).ToString());
}
}
public string QueryString(string sCmd)
{
return(ZData.FetchString(QueryValue(sCmd, null)));
}
public string QueryString(string sCmd, Dictionary <string, object> parameters)
{
return(ZData.FetchString(QueryValue(sCmd, parameters)));
}
