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