| 提交 | 用户 | 时间 | ||
| e46d3b | 1 | using System; |
| 懒 | 2 | using System.Collections.Generic; |
| 3 | using System.Data; | |
| 4 | using System.Linq; | |
| 5 | using System.Text; | |
| 6 | ||
| 7 | namespace YX.BLL | |
| 8 | { | |
| 9 | public class DataTableToModel | |
| 10 | { | |
| 11 | //数据库查出来的表名必须与实体表名一致 | |
| 12 | ||
| 13 | public static T GetEntity<T>(DataTable table) where T : new() | |
| 14 | { | |
| 15 | T entity = new T(); | |
| 16 | foreach (DataRow row in table.Rows) | |
| 17 | { | |
| 18 | foreach (var item in entity.GetType().GetProperties()) | |
| 19 | { | |
| 20 | if (row.Table.Columns.Contains(item.Name)) | |
| 21 | { | |
| 22 | if (DBNull.Value != row[item.Name]) | |
| 23 | { | |
| 24 | item.SetValue(entity, Convert.ChangeType(row[item.Name], item.PropertyType), null); | |
| 25 | } | |
| 26 | } | |
| 27 | } | |
| 28 | } | |
| 29 | return entity; | |
| 30 | } | |
| 31 | public static IList<T> GetEntities<T>(DataTable table) where T : new() | |
| 32 | { | |
| 33 | IList<T> entities = new List<T>(); | |
| 34 | foreach (DataRow row in table.Rows) | |
| 35 | { | |
| 36 | T entity = new T(); | |
| 37 | foreach (var item in entity.GetType().GetProperties()) | |
| 38 | { | |
| 39 | item.SetValue(entity, Convert.ChangeType(row[item.Name], item.PropertyType), null); | |
| 40 | } | |
| 41 | entities.Add(entity); | |
| 42 | } | |
| 43 | return entities; | |
| 44 | } | |
| 45 | } | |
| 46 | } | |
