public void SaveAs(Stream stream, object input)
{
using (StreamWriter writer = new StreamWriter(stream))
{
// notice : if first one is null then it can't get Type infomation
var first = true;
Type type;
PropertyInfo[] props = null;
foreach (var e in input as IEnumerable)
{
// head
if (first)
{
first = false;
type = e.GetType();
props = type.GetProperties(BindingFlags.Public | BindingFlags.Instance);
writer.Write(string.Join(",", props.Select(s => CsvHelpers.ConvertToCsvValue(s.Name))));
writer.Write(Environment.NewLine);
}
var values = props.Select(s => CsvHelpers.ConvertToCsvValue(s.GetValue(e)?.ToString()));
writer.Write(string.Join(",", values));
writer.Write(Environment.NewLine);
}
}
}
private void GenerateSheetByDapperRow(StreamWriter writer, IEnumerable value, List <string> keys, string seperator, string newLine)
{
foreach (IDictionary <string, object> v in value)
{
var values = keys.Select(key => CsvHelpers.ConvertToCsvValue(v[key]?.ToString()));
writer.Write(string.Join(seperator, values));
writer.Write(newLine);
}
}
private void GenerateSheetByProperties(StreamWriter writer, IEnumerable value, List <ExcelCustomPropertyInfo> props, string seperator, string newLine)
{
foreach (var v in value)
{
var values = props.Select(s => CsvHelpers.ConvertToCsvValue(s?.Property.GetValue(v)?.ToString()));
writer.Write(string.Join(seperator, values));
writer.Write(newLine);
}
}
private void GenerateSheetByIDictionary(StreamWriter writer, IEnumerable value, List <object> keys, string seperator, string newLine)
{
foreach (IDictionary v in value)
{
var values = keys.Select(key => CsvHelpers.ConvertToCsvValue(ToCsvString(v[key], null)));
writer.Write(string.Join(seperator, values));
writer.Write(newLine);
}
}
private static void GenerateSheetByIDataReader(object value, bool printHeader, string seperator, string newLine, StreamWriter writer)
{
var reader = (IDataReader)value;
int fieldCount = reader.FieldCount;
if (fieldCount == 0)
{
throw new InvalidDataException("fieldCount is 0");
}
if (printHeader)
{
for (int i = 0; i < fieldCount; i++)
{
var columnName = reader.GetName(i);
if (i != 0)
{
writer.Write(seperator);
}
writer.Write(CsvHelpers.ConvertToCsvValue(columnName?.ToCsvString(null)));
}
writer.Write(newLine);
}
while (reader.Read())
{
for (int i = 0; i < fieldCount; i++)
{
var cellValue = reader.GetValue(i);
if (i != 0)
{
writer.Write(seperator);
}
writer.Write(CsvHelpers.ConvertToCsvValue(cellValue?.ToCsvString(null)));
}
writer.Write(newLine);
}
}
private void GenerateSheetByDataTable(StreamWriter writer, DataTable dt, bool printHeader, string seperator, string newLine)
{
if (printHeader)
{
writer.Write(string.Join(seperator, dt.Columns.Cast <DataColumn>().Select(s => s.ColumnName)));
writer.Write(newLine);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
var first = true;
for (int j = 0; j < dt.Columns.Count; j++)
{
var cellValue = CsvHelpers.ConvertToCsvValue(dt.Rows[i][j]?.ToString());
if (!first)
{
writer.Write(seperator);
}
writer.Write(cellValue);
first = false;
}
writer.Write(newLine);
}
}
public void SaveAs(object value, bool printHeader, IConfiguration configuration)
{
var cf = configuration == null ? CsvConfiguration.DefaultConfiguration : (CsvConfiguration)configuration;
var seperator = cf.Seperator.ToString();
var newLine = cf.NewLine;
using (StreamWriter writer = new StreamWriter(_stream))
{
if (value == null)
{
writer.Write("");
return;
}
var type = value.GetType();
Type genericType = null;
//DapperRow
if (value is IEnumerable)
{
var values = value as IEnumerable;
List <object> keys = new List <object>();
List <ExcelCustomPropertyInfo> props = null;
string mode = null;
// check mode
{
foreach (var item in values) //TODO: need to optimize
{
if (item != null && mode == null)
{
if (item is IDictionary <string, object> )
{
var item2 = item as IDictionary <string, object>;
mode = "IDictionary<string, object>";
foreach (var key in item2.Keys)
{
keys.Add(key);
}
}
else if (item is IDictionary)
{
var item2 = item as IDictionary;
mode = "IDictionary";
foreach (var key in item2.Keys)
{
keys.Add(key);
}
}
else
{
mode = "Properties";
genericType = item.GetType();
props = Helpers.GetSaveAsProperties(genericType);
}
break;
}
}
}
//if(mode == null)
// throw new NotImplementedException($"Type {type?.Name} & genericType {genericType?.Name} not Implemented. please issue for me.");
if (keys.Count() == 0 && props == null)
{
writer.Write(newLine);
return;
}
if (printHeader)
{
if (props != null)
{
writer.Write(string.Join(seperator, props.Select(s => CsvHelpers.ConvertToCsvValue(s?.ExcelColumnName))));
writer.Write(newLine);
}
else if (keys.Count > 0)
{
writer.Write(string.Join(seperator, keys));
writer.Write(newLine);
}
else
{
throw new InvalidOperationException("Please issue for me.");
}
}
if (mode == "IDictionary<string, object>") //Dapper Row
{
GenerateSheetByDapperRow(writer, value as IEnumerable, keys.Cast <string>().ToList(), seperator, newLine);
}
else if (mode == "IDictionary") //IDictionary
{
GenerateSheetByIDictionary(writer, value as IEnumerable, keys, seperator, newLine);
}
else if (mode == "Properties")
{
GenerateSheetByProperties(writer, value as IEnumerable, props, seperator, newLine);
}
else
{
throw new NotImplementedException($"Type {type?.Name} & genericType {genericType?.Name} not Implemented. please issue for me.");
}
}
else if (value is DataTable)
{
GenerateSheetByDataTable(writer, value as DataTable, printHeader, seperator, newLine);
}
else
{
throw new NotImplementedException($"Type {type?.Name} & genericType {genericType?.Name} not Implemented. please issue for me.");
}
}
}
