public class ConvertHelper<T> where T : new() { private static Dictionary<Type, List<IPropertyConvertInfo>> ConvertInfo = new Dictionary<Type, List<IPropertyConvertInfo>>(); public static ObservableCollection<T> ConvertToList(DataTable dt) { List<IPropertyConvertInfo> convertInfo = ConvertInfo.ContainsKey(typeof(T)) ? ConvertInfo[typeof(T)] : ParseConvertInfo(typeof(T)); convertInfo = convertInfo.Where(v => dt.Columns.Contains(v.ColumnName)).ToList(); return new ObservableCollection<T>(dt.Rows.Cast<DataRow>().Select(v => ConvertRowToModel(convertInfo, v))); } #region ==== Private Mothods ==== private static List<IPropertyConvertInfo> ParseConvertInfo(Type modelType) { var properties = modelType.GetProperties().Where(v => v.IsDefined(typeof(ColumnNameAttribute), true)) .Select(v => CreatePropertyConvertInfo(v)).ToList(); ConvertInfo[modelType] = properties; return properties; } private static IPropertyConvertInfo CreatePropertyConvertInfo(PropertyInfo property) { IPropertyConvertInfo info = Activator.CreateInstance(typeof(PropertyConvertInfo<>).MakeGenericType(property.PropertyType)) as IPropertyConvertInfo; info.ColumnName = ((ColumnNameAttribute)property.GetCustomAttributes(typeof(ColumnNameAttribute), true)[0]).ColumnName; info.Property = property; return info; } private static T ConvertRowToModel(List<IPropertyConvertInfo> convertInfo, DataRow dataRow) { T model = new T(); convertInfo.ForEach(v => v.DoFetchData(model, dataRow)); return model; } #endregion ==== Private Mothods ==== } internal interface IPropertyConvertInfo { PropertyInfo Property { get; set; } string ColumnName { get; set; } void DoFetchData(object model, DataRow row); } internal class PropertyConvertInfo<TProperty> : IPropertyConvertInfo { public PropertyInfo Property { get; set; } public string ColumnName { get; set; } public void DoFetchData(object model, DataRow row) { if (!(row[ColumnName] is DBNull)) { if (row[ColumnName].GetType().ToString() == "System.Decimal") { object value = Convert.ToDouble(row[ColumnName]); Property.SetValue(model, value, null); } else if (row[ColumnName].GetType().ToString() =="System.SByte") { object value = Convert.ToBoolean(row[ColumnName]); Property.SetValue(model, value, null); } else { Property.SetValue(model, row.Field<TProperty>(ColumnName), null); } } } }
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列:向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· 10年+ .NET Coder 心语 ── 封装的思维:从隐藏、稳定开始理解其本质意义
· 地球OL攻略 —— 某应届生求职总结
· 提示词工程——AI应用必不可少的技术
· Open-Sora 2.0 重磅开源!
· 周边上新:园子的第一款马克杯温暖上架
2010-12-29 How to add share folder in svn(propset)
2010-12-29 VXML Event
2010-12-29 svn/cvs diff and commit command
2010-12-29 find and grep command
2010-12-29 VXML Code : in a if element replace the symbols