public static bool IsField(this AdsDataReader reader, string field)
{
var table = reader.GetSchemaTable();
var rows = table?.Rows.Cast <DataRow>().ToList();
var item = rows?.SingleOrDefault(x => (string)x.ItemArray[0] == field);
return(item != null);
}
public override void FillFromReader(AdsDataReader reader)
{
desc = reader.ReadString("desc");
partno = reader.ReadString("partno");
//term = reader.ReadString("term");
alloc = reader.ReadDecimal("alloc");
note = reader.ReadString("note");
MakeClean();
}
public static DateTime?ReadDate(this AdsDataReader reader, int col)
{
if (string.IsNullOrEmpty(reader.GetValue(col).ToString()))
{
return(null);
}
var good = DateTime.TryParse(reader.GetValue(col).ToString(), out var x);
return(good ? x : (DateTime?)null);
}
public static bool ReadBool(this AdsDataReader reader, int col)
{
if (reader.GetValue(col) == null)
{
return(false);
}
var good = bool.TryParse(reader.GetValue(col).ToString(), out var x);
return(good && x);
}
public static decimal ReadDecimal(this AdsDataReader reader, int col)
{
if (reader.GetValue(col) == null)
{
return(0);
}
var good = decimal.TryParse(reader.GetValue(col).ToString(), out var x);
return(good ? x : 0);
}
public static int ReadInt(this AdsDataReader reader, int col)
{
if (reader.GetValue(col) == null)
{
return(0);
}
var good = int.TryParse(reader.GetValue(col).ToString(), out var x);
return(good ? x : 0);
}
public static char ReadChar(this AdsDataReader reader, int col)
{
if (reader.GetValue(col) == null)
{
return(new char());
}
var good = char.TryParse(reader.GetValue(col).ToString(), out var x);
return(good ? x : new char());
}
public override void FillFromReader(AdsDataReader reader)
{
partno = reader.ReadString("partno");
desc = reader.ReadString("desc");
note = reader.ReadString("note");
orderno = reader.ReadInt("orderno");
lineno = reader.ReadInt("lineno");
ship_date = reader.ReadDate("ship_date");
repno = reader.ReadInt("repno");
custserv = reader.ReadString("custserv");
linedesc = reader.ReadString("linedesc");
MakeClean();
}
public static string ReadString(this AdsDataReader reader, string field)
{
string x = null;
try {
var col = reader.GetOrdinal(field);
x = reader.GetValue(col)?.ToString();
}
catch (Exception e) {
Debug.WriteLine(e);
}
return(x);
}
public static char ReadChar(this AdsDataReader reader, string field)
{
var x = new char();
try {
var col = reader.GetOrdinal(field);
if (reader.GetValue(col) == null)
{
return(x);
}
var good = char.TryParse(reader.GetValue(col).ToString(), out x);
}
catch (Exception e) {
Debug.WriteLine(e);
}
return(x);
}
public static bool ReadBool(this AdsDataReader reader, string field)
{
var x = false;
try {
var col = reader.GetOrdinal(field);
if (reader.GetValue(col) == null)
{
return(x);
}
var good = bool.TryParse(reader.GetValue(col).ToString(), out x);
}
catch (Exception e) {
Debug.WriteLine(e);
}
return(x);
}
public static DateTime ReadDateNotNull(this AdsDataReader reader, string field)
{
var x = DateTime.Today;
try {
var col = reader.GetOrdinal(field);
if (string.IsNullOrEmpty(reader.GetValue(col).ToString()))
{
return(x);
}
var good = DateTime.TryParse(reader.GetValue(col).ToString(), out var xx);
x = xx;
}
catch (Exception e) {
Debug.WriteLine(e);
}
return(x);
}
public T Get <T>(object key) where T : class
{
AdsEntityMapping mapping = AdsEntityMapping.GetForType(typeof(T));
var primaryKeyMappings = new List <AdsEntityMemberMapping>();
foreach (AdsEntityMemberMapping memberMapping in mapping.Members)
{
if (memberMapping.ColumnAttribute.IsPrimaryKey)
{
primaryKeyMappings.Add(memberMapping);
}
}
if (primaryKeyMappings.Count == 0)
{
throw new AdsContextException("No primary key is defined for the class");
}
if (primaryKeyMappings.Count > 1)
{
throw new AdsContextException("Multiple primary key columns are not supported");
}
AdsEntityMemberMapping primaryKeyMapping = primaryKeyMappings[0];
string selectFilter = string.Format("{0} = :p_key", primaryKeyMapping.ResolvedName);;
string query = CreateSelectQuery <T>(mapping, null, selectFilter, null);
AdsCommand command = new AdsCommand(query, connection);
command.Parameters.Add(":p_key", key);
AdsDataReader reader = command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
T obj = (T)Activator.CreateInstance(typeof(T));
foreach (AdsEntityMemberMapping memberMapping in mapping.Members)
{
int resolvedNameOrdinal = reader.GetOrdinal(memberMapping.ResolvedName);
object value = null;
if (!reader.IsDBNull(resolvedNameOrdinal))
{
value = reader.GetValue(resolvedNameOrdinal);
if (memberMapping.MemberType == typeof(uint) && value is int)
{
value = (uint)(int)value;
}
if (memberMapping.MemberType == typeof(ushort) && value is short)
{
value = (ushort)(short)value;
}
}
memberMapping.SetValue(obj, value);
}
return(obj);
}
return(null);
}
public virtual void FillFromReaderList(AdsDataReader reader, List <string> fields)
{
FieldList = fields;
FillFromReader(reader);
}
public abstract void FillFromReader(AdsDataReader reader);
public static string ReadString(this AdsDataReader reader, int col)
{
return(reader.GetValue(col) == null ? null : reader.GetValue(col).ToString());
}
