[C#][WinForm] 제너릭 list 를 CSV string으로 변경

프로그래밍/WinForm

[C#][WinForm] 제너릭 list 를 CSV string으로 변경

도깨비방망이 2016. 7. 4. 14:15

- 다양한 string 형태로 응용 가능

//
// 출처 : https://garvincasimir.wordpress.com/2012/08/16/extension-method-for-converting-generic-lists-to-csv-in-c/
// 
public string ToCSV<T>(IEnumerable<T> list)
{
    var type = typeof(T);
    var props = type.GetProperties();

//Setup expression constants
    var param = Expression.Parameter(type, "x");
    var doublequote = Expression.Constant("\"");
    var doublequoteescape = Expression.Constant("\"\"");
    var comma = Expression.Constant(",");

//Convert all properties to strings, escape and enclose in double quotes
    var propq = (from prop in props
		 let tostringcall = Expression.Call(Expression.Property(param, prop), prop.ReflectedType.GetMethod("ToString", new Type[0]))
		 let replacecall = Expression.Call(tostringcall, typeof(string).GetMethod("Replace", new Type[] { typeof(String), typeof(String) }), doublequote, doublequoteescape)
		 select Expression.Call(typeof(string).GetMethod("Concat", new Type[] { typeof(String), typeof(String), typeof(String) }), doublequote, replacecall, doublequote)
		 ).ToArray();

var concatLine = propq[0];
    for (int i = 1; i < propq.Length; i++)
	concatLine = Expression.Call(typeof(string).GetMethod("Concat", new Type[] { typeof(String), typeof(String), typeof(String) }), concatLine, comma, propq[i]);

var method = Expression.Lambda<Func<T, String>>(concatLine, param).Compile();

var header = String.Join(",", props.Select(p => p.Name).ToArray());

return header + Environment.NewLine + String.Join(Environment.NewLine, list.Select(method).ToArray());
}

저작자표시 비영리 변경금지