public virtual List <T> DataTableToList <T>(string filePath, string sheetName) where T : IExeclImport, new() { List <T> listEntity = new List <T>(); DataTable dt = excelReader.ReaderExcel(filePath, sheetName); if (dt.Rows.Count > this.MaxLeng) { this.ErrorMsg = $"超过最大条数{MaxLeng}"; return(null); } string TName = GetTName <T>(); string ExeclMappingPropertyInfoKey = $"{TName}_ExeclMappingPropertys"; #region 获取实体类映射集合 IEnumerable <PropertyInfo> PropertyInfos = CacheHelper.GetCache <IEnumerable <PropertyInfo> >(ExeclMappingPropertyInfoKey); if (PropertyInfos == null) { PropertyInfos = typeof(T).GetProperties().Where(m => m.GetCustomAttributes(typeof(ExeclMappingAttribute), true) != null); CacheHelper.SetCache(ExeclMappingPropertyInfoKey, PropertyInfos); } #endregion if (PropertyInfos == null || PropertyInfos.Count() <= 0) { this.ErrorMsg = $"传入实体无Execl映射信息"; return(null); } foreach (DataRow row in dt.Rows) { T t = new T(); foreach (PropertyInfo Prty in PropertyInfos) { ExeclMappingAttribute PrtyExeclMapping = Prty.GetCustomAttribute <ExeclMappingAttribute>(true); if (dt.Columns.Contains(PrtyExeclMapping.ExeclHeadName)) { // 判断此属性是否有Setter if (!Prty.CanWrite) { continue; //该属性不可写,直接跳出 } //取值 object value = row[PrtyExeclMapping.ExeclHeadName]; //如果非空,则赋给对象的属性 if (value != DBNull.Value && value != null && !string.IsNullOrEmpty(value.ToString())) { ConvertValueAttribute appointValueAttribute = Prty.GetCustomAttribute <ConvertValueAttribute>(true); if (appointValueAttribute != null) { value = appointValueAttribute.GetConvertValueValue(value); } object objValue = GetValue(Prty, value); Prty.SetValue(t, objValue, null); } } } listEntity.Add(t); } return(listEntity); }
public List <T> DataTableToList <T>(string filePath, string sheetName) where T : IExeclImport, new() { List <T> listEntity = new List <T>(); DataTable dt = excelReader.ReaderExcel(filePath, sheetName); if (dt.Rows.Count > this.MaxLeng) { this.ErrorMsg = $"超过最大条数{MaxLeng}"; return(null); } var PropertyInfos = typeof(T).GetProperties().Where(m => m.GetCustomAttributes(typeof(ExeclMappingAttribute), true) != null); if (PropertyInfos == null || PropertyInfos.Count() <= 0) { this.ErrorMsg = $"传入实体无Execl映射信息"; return(null); } foreach (DataRow row in dt.Rows) { T t = new T(); foreach (PropertyInfo Prty in PropertyInfos) { ExeclMappingAttribute PrtyExeclMapping = Prty.GetCustomAttribute <ExeclMappingAttribute>(true); if (dt.Columns.Contains(PrtyExeclMapping.ExeclHeadName)) { // 判断此属性是否有Setter if (!Prty.CanWrite) { continue; //该属性不可写,直接跳出 } //取值 object value = row[PrtyExeclMapping.ExeclHeadName]; //如果非空,则赋给对象的属性 if (value != DBNull.Value) { object objValue = GetValue(Prty, value); AppointValueAttribute appointValueAttribute = Prty.GetCustomAttribute <AppointValueAttribute>(true); if (appointValueAttribute != null) { objValue = appointValueAttribute.GetAppointValue(objValue); } Prty.SetValue(t, objValue, null); } } } listEntity.Add(t); } return(listEntity); }
public List <T> DataTableToList <T>(string filePath, string sheetName) where T : IExeclImport { List <T> listEntity = new List <T>(); (string[] headArr, DataTable dt)ExcelInfo = excelReader.ReaderExcel(filePath, sheetName); if (ExcelInfo == null) { } DataTable dt = ExcelInfo.dt; if (dt.Rows.Count > this.MaxLeng) { this.ErrorMsg = $"超过最大条数{MaxLeng}"; return(null); } var PropertyInfos = typeof(T).GetProperties().Where(m => m.GetCustomAttributes(typeof(ExeclMapping), true) != null); if (PropertyInfos == null || PropertyInfos.Count() <= 0) { this.ErrorMsg = $"传入实体无Execl映射信息"; return(null); } foreach (DataRow row in dt.Rows) { T t = default(T); foreach (PropertyInfo Prty in PropertyInfos) { if (dt.Columns.Contains(Prty.Name)) { // 判断此属性是否有Setter if (!Prty.CanWrite) { continue; //该属性不可写,直接跳出 } //取值 object value = row[Prty.Name]; //如果非空,则赋给对象的属性 if (value != DBNull.Value) { Prty.SetValue(t, value, null); } } } listEntity.Add(t); } return(listEntity); }
public virtual List <T> DataTableToList <T>(string filePath, string sheetName) where T : IExeclImport, new() { List <T> listEntity = new List <T>(); DataTable dt = excelReader.ReaderExcel(filePath, sheetName); if (dt.Rows.Count > this.MaxLeng) { this.ErrorMsg = $"超过最大条数{MaxLeng}"; return(null); } string TName = GetTName <T>(); Type TType = typeof(T); #region 获取实体类映射集合 string ExeclMappingPropertyInfosKey = $"{TName}_ExeclMappingPropertys"; IEnumerable <PropertyInfo> PropertyInfos = CacheHelper.GetCache <IEnumerable <PropertyInfo> >(ExeclMappingPropertyInfosKey); if (PropertyInfos == null) { PropertyInfos = TType.GetProperties().Where(m => m.GetCustomAttribute <ExeclMappingAttribute>(true) != null); if (PropertyInfos != null) { CacheHelper.SetCache(ExeclMappingPropertyInfosKey, PropertyInfos); } } #endregion if (PropertyInfos == null || PropertyInfos.Count() <= 0) { this.ErrorMsg = $"传入实体无Execl映射信息"; return(null); } foreach (DataRow row in dt.Rows) { T t = new T(); foreach (PropertyInfo Prty in PropertyInfos) { #region 获取指定字段ExeclMappingAttribute string ExeclMappingPropertyKey = $"{TName}_{Prty.Name}_ExeclMappingPropertyKey"; string ExeclMappingPropertyKeyNoHave = $"{TName}_{Prty.Name}_ExeclMappingPropertyKeyNoHave"; ExeclMappingAttribute PrtyExeclMapping = CacheHelper.GetCache <ExeclMappingAttribute>(ExeclMappingPropertyKey); if (PrtyExeclMapping == null && !CacheHelper.IsExist(ExeclMappingPropertyKeyNoHave)) { PrtyExeclMapping = Prty.GetCustomAttribute <ExeclMappingAttribute>(true); if (PrtyExeclMapping != null) { CacheHelper.SetCache(ExeclMappingPropertyKey, PrtyExeclMapping); } else { CacheHelper.SetCache(ExeclMappingPropertyKeyNoHave, true); } } #endregion if (PrtyExeclMapping != null && dt.Columns.Contains(PrtyExeclMapping.ExeclHeadName)) { // 判断此属性是否有Setter if (!Prty.CanWrite) { continue; //该属性不可写,直接跳出 } //取值 object value = row[PrtyExeclMapping.ExeclHeadName]; //如果非空,则赋给对象的属性 if (value != DBNull.Value && value != null && !string.IsNullOrEmpty(value.ToString())) { #region 获取指定字段ConvertValueAttribute string ConvertValuePropertyKey = $"{TName}_{Prty.Name}_ConvertValuePropertyKey"; string ConvertValuePropertyKeyNoHave = $"{TName}_{Prty.Name}_ConvertValuePropertyKeyNoHave"; ConvertValueAttribute appointValueAttribute = CacheHelper.GetCache <ConvertValueAttribute>(ConvertValuePropertyKey); if (appointValueAttribute == null && !CacheHelper.IsExist(ConvertValuePropertyKeyNoHave)) { appointValueAttribute = Prty.GetCustomAttribute <ConvertValueAttribute>(true); if (appointValueAttribute != null) { CacheHelper.SetCache(ConvertValuePropertyKey, appointValueAttribute); } else { CacheHelper.SetCache(ConvertValuePropertyKeyNoHave, true); } } #endregion if (appointValueAttribute != null) { value = appointValueAttribute.GetConvertValueValue(value); } ExcelNumberAttribute ss = Prty.GetCustomAttributes <ExcelNumberAttribute>(true); #region 字段验证BaseValidationAttribute string BaseValidationPropertyKey = $"{TName}_{Prty.Name}_BaseValidationPropertyKey"; string BaseValidationPropertyKeyNoHave = $"{TName}_{Prty.Name}_BaseValidationPropertyKeyNoHave"; IEnumerable <ExcelBaseValidationAttribute> baseValidationAttributeArray = CacheHelper.GetCache <IEnumerable <ExcelBaseValidationAttribute> >(BaseValidationPropertyKey); if (baseValidationAttributeArray == null && !CacheHelper.IsExist(BaseValidationPropertyKeyNoHave)) { baseValidationAttributeArray = Prty.GetCustomAttributes <ExcelBaseValidationAttribute>(true); if (baseValidationAttributeArray != null) { CacheHelper.SetCache(BaseValidationPropertyKey, baseValidationAttributeArray); } else { CacheHelper.SetCache(BaseValidationPropertyKeyNoHave, true); } } #endregion if (baseValidationAttributeArray != null && baseValidationAttributeArray.Count() > 0) { foreach (ExcelBaseValidationAttribute baseValidationAttribute in baseValidationAttributeArray) { if (!baseValidationAttribute.IsValid(value)) { PropertyInfo ExeclRowErrorMsgProperty = TType.GetProperty("ExeclRowErrorMsg"); if (ExeclRowErrorMsgProperty != null) { ExeclRowErrorMsgProperty.SetValue(t, string.IsNullOrEmpty(baseValidationAttribute.ErrorMsg)? baseValidationAttribute.ErrorMsg:$"{baseValidationAttribute.GetType().Name} 验证未通过" , null); } } } } object objValue = GetValue(Prty, value); Prty.SetValue(t, objValue, null); } } } listEntity.Add(t); } return(listEntity); }