public static string TransactionEnum(string fieldName, Type enumType)
        {
            return TransactionEnum(fieldName, enumType, null);
        }

        public static string TransactionEnum(string fieldName, Type enumType, string[] name)
        {

            DataTable dt = ParseEnumToTable(enumType);
            if (name != null && name.Length != dt.Rows.Count)
                name = null;
            string strReturn = "";
            string strK = "";
            for (int i = 0; i < dt.Rows.Count - 1; i++)
            {
                string v = name == null ? dt.Rows[i][0].ToString() : name[i];
                strReturn += "Iif(" + fieldName + "='" + dt.Rows[i][1].ToString() + "','" + v + "',";
                strK += ")";
            }
            string v1 = name == null ? dt.Rows[dt.Rows.Count -1][0].ToString() : name[dt.Rows.Count-1];
            strReturn += "'" + v1 + "'";

            strReturn += strK;
            return strReturn;