public string MapColumn(PropertyInfo prop, List <string> columns)
{
IgnoreAttribute ignoreAttr = prop.GetCustomAttributes <IgnoreAttribute>(false).FirstOrDefault();
if (ignoreAttr != null)
{
return(null);
}
ColumnNameAttribute colNameAttr = null;
string columnName = "";
if (!columns.Any(x => x == prop.Name))
{
colNameAttr = prop.GetCustomAttributes <ColumnNameAttribute>(false).FirstOrDefault();
if (colNameAttr == null)
{
throw new Exception("Column name doesn't exist.");
}
if (!columns.Any(x => x == colNameAttr.ColumnName))
{
throw new Exception("Column name doesn't exist.");
}
columnName = colNameAttr.ColumnName;
}
else
{
columnName = prop.Name;
}
return(columnName);
}
private List <string> _GetEntityValues <TEntity>(IEnumerable <TEntity> param, List <string> columnString)
{
List <string> entityValueList = new List <string>();
foreach (TEntity entity in param)
{
List <object> objectValues = new List <object>();
PropertyInfo[] props = entity.GetType().GetProperties();
foreach (string col in columnString)
{
PropertyInfo prop = props.SingleOrDefault(p => p.Name == col);
if (prop == null)
{
prop = props.SingleOrDefault(p =>
{
ColumnNameAttribute collNameAttribute = p.GetCustomAttributes <ColumnNameAttribute>(false).FirstOrDefault();
if (collNameAttribute == null)
{
return(false);
}
return(collNameAttribute.ColumnName == col);
});
}
IgnoreAttribute ignoreAttr = prop.GetCustomAttributes <IgnoreAttribute>(false).FirstOrDefault();
if (ignoreAttr != null)
{
continue;
}
KeyAttribute keyAttr = prop.GetCustomAttribute <KeyAttribute>(false);
if (keyAttr != null)
{
DbOptionAttribute dbOptionAttr = prop.GetCustomAttribute <DbOptionAttribute>(false);
if (dbOptionAttr == null)
{
continue;
}
if (dbOptionAttr.Option == DbGenerateOption.AutoIncrement)
{
continue;
}
}
string value = "";
if (prop.GetValue(entity) is DateTime)
{
value = (Convert.ToDateTime(prop.GetValue(entity).ToString())).ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
value = prop.GetValue(entity).ToString();
}
objectValues.Add(string.Format("'{0}'", MySqlHelper.EscapeString(value)));
}
entityValueList.Add(string.Format("({0})", string.Join(", ", objectValues)));
}
return(entityValueList);
}
