如何将枚举定义翻译成DataTable
public static string TransactionEnum(string fieldName, Type enumType)
{
return TransactionEnum(fieldName, enumType, null);
}
}
{
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 + "'";
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;
return strReturn;
}