/// <summary>
/// 获取枚举成员的名称
/// </summary>
/// <typeparam name="T">枚举名,比如Enum1</typeparam>
/// <param name="member">枚举成员实例或成员值,
/// 范例:Enum1枚举有两个成员A=0,B=1,则传入Enum1.A或0,获取成员名称"A"</param>
/// <returns>返回值</returns>
public static string GetMemberName <T>(object member)
{
//转成基础类型的成员值
Type underlyingType = GetUnderlyingType(typeof(T));
object memberValue = MyConvertHelper.ConvertTo(member, underlyingType);
//获取枚举成员的名称
return(Enum.GetName(typeof(T), memberValue));
}
/// <summary>
/// 获取枚举成员的值
/// </summary>
/// <typeparam name="T">枚举名,比如Enum1</typeparam>
/// <param name="memberName">枚举成员的常量名,
/// 范例:Enum1枚举有两个成员A=0,B=1,则传入"A"获取0</param>
/// <returns>返回值</returns>
public static object GetMemberValue <T>(string memberName)
{
//获取基础类型
Type underlyingType = GetUnderlyingType(typeof(T));
//获取枚举实例
var instance = GetInstance <T>(memberName);
//获取枚举成员的值
return(MyConvertHelper.ConvertTo(instance, underlyingType));
}
/// <summary>
/// 返回Excel第一个工作表表名
/// </summary>
/// <param name="connection">excel连接</param>
/// <returns>返回值</returns>
public static string GetExcelFirstTableName(OleDbConnection connection)
{
string tableName = string.Empty;
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
DataTable dt = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt != null && dt.Rows.Count > 0)
{
tableName = MyConvertHelper.ConvertTo <string>(dt.Rows[0][2]);
}
return(tableName);
}
/// <summary>
/// 返回Excel工作表名
/// </summary>
/// <param name="connection">excel连接</param>
/// <returns>返回值</returns>
public static List <string> GetExcelTablesName(OleDbConnection connection)
{
var list = new List <string>();
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
DataTable dt = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
list.Add(MyConvertHelper.ConvertTo <string>(dt.Rows[i][2]));
}
}
return(list);
}
/// <summary>
/// 通过字符串获取枚举成员实例
/// </summary>
/// <typeparam name="T">枚举名,比如Enum1</typeparam>
/// <param name="member">枚举成员的常量名或常量值,
/// 范例:Enum1枚举有两个成员A=0,B=1,则传入"A"或"0"获取 Enum1.A 枚举类型</param>
/// <returns>返回值</returns>
public static T GetInstance <T>(string member)
{
return(MyConvertHelper.ConvertTo <T>(Enum.Parse(typeof(T), member, true)));
}
