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 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);
}