1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Diagnostics;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using Tango.BL.Entities;
namespace Tango.PPC.Shared.SQL
{
public class RemoteSqlRow
{
private Func<String, Object> _getFuncKey;
private Func<int, Object> _getFuncIndex;
public List<Object> Values { get; set; }
public RemoteSqlRow()
{
Values = new List<object>();
}
public Object Get(String columnName)
{
return _getFuncKey.Invoke(columnName);
}
public Object Get(int columnIndex)
{
return _getFuncIndex.Invoke(columnIndex);
}
public T Get<T>(String columnName)
{
var value = _getFuncKey.Invoke(columnName);
if (typeof(T) != value.GetType())
{
return (T)Convert.ChangeType(value, typeof(T));
}
else
{
return (T)value;
}
}
public T Get<T>(int columnIndex)
{
var value = _getFuncIndex.Invoke(columnIndex);
if (typeof(T) != value.GetType())
{
return (T)Convert.ChangeType(value, typeof(T));
}
else
{
return (T)value;
}
}
internal void Init(Func<String, Object> getFuncKey, Func<int, Object> getFuncIndex)
{
_getFuncKey = getFuncKey;
_getFuncIndex = getFuncIndex;
}
public override string ToString()
{
return String.Join(", ", Values);
}
public T Map<T>() where T : class, new()
{
var obj = Activator.CreateInstance<T>();
Map<T>(obj);
return obj;
}
public void Map<T>(T obj) where T : class
{
foreach (var prop in typeof(T).GetPropertiesWithAttribute<ColumnAttribute>())
{
try
{
var columnName = prop.GetCustomAttribute<ColumnAttribute>().Name;
var value = Get(columnName).ToStringSafe();
prop.SetValue(obj, Convert.ChangeType(value, prop.PropertyType));
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
}
}
}
}
|
